...
- Download and install the MySQL ODBC 5.1 driver. The installer is available on the LTS share, in "netadmins\Software\MySQL." Also, either create a desktop shortcut to the database, or map drive to it. The database is found at \\files.cornell.edu\lib\ds-deptshares\LTS\tsstats\1New_culv2-2012-2013.accdb.
- Ask Amy Blumenthal or Chris Manly for the database password.
- Configure the driver, using the 32-bit ODBC Administrator, here: c:\windows\syswow64\odbcad32.exe. (Note: Do not use the ODBC Administrator in Control Panel/Administrative Tools.)
...
Anchor basic basic
C. Basic Guide to the Database
| basic | |
| basic |
- Go to \\files.cornell.edu\LIB\ds-deptshares\tsstats (Probably mapped on your computer as L:\tsstats)
Open the file named 1New_culv2-2012-2013.accdb
- You should see the following sidebar on the left side of the Access window:
Make sure that the "Macros" menu is showing. If it does not say "Macros," click on the little circled arrow and select "Macros."
...
5. Individual Reports and Staff/Bib ID Reports will ask for the net ID of the staff member whose activity you wish to view. (See below.) Only one net ID can be entered for these reports at a time.
6. All macros will ask you for a date range of activity to be reported out. (See below) You may query as far back as July 2012 in this system, if you wish.
7. The first time you run a report in each session of Access, you will be asked for a database user and password. Both are "dbread," just as with our other Voyager Access databases.
8. You will get a message box asking you if it is ok to delete the existing table. The answer is "yes," otherwise you will be getting data from the last query run in the system, instead of for the query you just requested.
9. The query will now run and will generate a report for the data you requested. How long it takes will depend upon the length of the date range, and whether the query is harvesting data for a whole unit, the whole department, or just one staff member.
...
i. Click File/Print, then click "Print Preview," as seen below.
ii. Toward the middle of the tool bar, click the "PDF or XOP" button.
iii. The following menu box with appear:
iv. Check to make sure the program is defaulting to the folder in which you'd like to save the report. (See above)
...
- Go to L:\tsstats and select "1New_culv-2012-2013.accdb." Make sure that the "Macros" menu is showing. If it does not say "Macros," click on the little circled arrow and select "Macros." Click on the "Unit Reports" macro.
- Enter the desired date range in the boxes and click "Ok."
- This dialog box will most likely appear (below). If it does, you must click YES to clear the data from the last time someone ran this report for their unit.
- Next the macro will ask you to enter the name of your unit. (See below.) You may enter it in full, as rendered in the Unit ID/ Unit Name table shown below, or type the first three letters of the name as shown in that same table (case sensitive); the script will then automatically choose the corresponding unit name. After entering the name, click “ok” to run the query and return a report.
NOTE: Please note that staff members have been entered into this database under the unit of their administrative supervisor. For example, while Betty Datacruncher does some copy cataloging, she is a direct report of the Batch Processing Unit Supervisor and is therefore entered under Batch Processing. If you have a staff member who does some work for you but who reports to another manager, you can run your unit report and then run the “Individual Report” for any such staff member(s).
...
- Go to \\files.cornell.edu\LIB\ds-deptshares\tsstats and open the .mdb file called “3_BATCHstats.mdb.”
- At the right side of the screen, double-click on the macro called “1 – Batch BIB Summary Report.” (see below)
The following window will appear (below). Enter the starting and ending dates for the time period for which you wish to collect data.
If you haven’t already been in an Access database for Voyager during your computing session, Access will ask you for the VGR7 username and password (dbread, dbread). (see below)
The script will start to run a series of queries. When it is done, it will open the report containing the data for the date range you entered. (See next page for screenshot.) NOTE: If you want to save a copy of your report, you’ll need to right click on it and Export it as a PDF. If you or someone else runs the query before you’ve done that, your report will be overwritten and you will have to run it again (and export it immediately) in order to save the information it generated. Here's a sample report (below). See also the annotated version, after this one.
...
- Go to L:\tsstats and select "1New_culv-2012-2013.accdb." Make sure that the "Macros" menu is showing. If it does not say "Macros," click on the little circled arrow and select "Macros." Click on either the "Sarah's Cataloging Reports" or the "Naun's Cataloging Reports" macro.
- Both of these macros will ask you for a date range of activity to be reported out. (See below) You may query as far back as July 2012 in this system, if you wish.
3. The first time you run a report in each session of Access, you will be asked for a database user and password. Both are "dbread," just as with our other Voyager Access databases
4. You will get a message box asking you if it is ok to delete the existing table. The answer is "yes," otherwise you will be getting data from the last query run in the system, instead of for the query you just requested.
5. The query will now run and will generate a report for the data you requested. How long it takes will depend upon the length of the date range you have chosen.
...
i. Click File/Print, then click "Print Preview," as seen below.
ii. Toward the middle of the tool bar, click the "PDF or XOP" button.
iii. The following menu box with appear:
iv. Check to make sure the program is defaulting to the folder in which you'd like to save the report. (See above)
...
vii. The program has saved your report as a .pdf file in your chosen folder and has opened it in Adobe Acrobat for you to review. (If you wish to print it at this time, click the "Print" button on the toolbar and remember to go to "Print Properties and deselect "print on both sides".) Now that you have saved the report as a .pdf, you may retrieve and print it at any time.