E-journal usage uploading

This feature was added Spring 2007. The following steps need to take place:

1. Download stats from all desired databases into the appropriate subfolders of the "e-journal usage statistics" folder (in the shared Periodical Survey)
2. Compile stats from each source into a spreadsheet or MS Access datasheet. I've created Access databases for several of these to help make the compilation easier. Each spreadsheet/datasheet must include the following columns, in the following order:
1. Title
2. Platform
3. Print ISSN
4. Online ISSN (often blank)
5. 2004/2005
6. 2005/2006
7. 2006/2007
8. and so on, adding years as needed. Note: every time you add a new year, the queries in the Use Study DB will need to be changed.
3. Import the spreadsheets for each source into the Use Study Database. Give the imported tables a consistent name of "tblStatsSource" (e.g., tblStatsMuse). This must correspond to the nomenclature in qryCreateOnlineStatsUnion.
4. If your stats include a source that has not been used before, perform the following steps:
1. Insert the following coding at the beginning of the SQL source of qryCreateOnlineStatsUnion: SELECT * FROM tblStatsSource WHERE ([Print ISSN] <> '0000-0000' AND [Print ISSN] Is Not Null) OR ([Online ISSN] <> '0000-0000' AND [Online ISSN] Is Not Null) UNION ALL Replace tblStatsSource with the name of the new table. This will include the new source(s) in the union listing of online usage. Open qryCreateOnlineStatsUnion to make sure that all the data displays correctly.
2. Open tblAuthorityAggregator. Find the entry/entries for your new source if it exists already. In the "platform" field, enter the name of the source exactly as it appears in the "platform" field of tblStatsSource. If your new source is not listed in the file, create a new entry. Put the form of the database name that you want to display on reports in the "established" field. Put the name of the database as it appears in reports from Serials Solutions in the "aggregator" field. In the "platform" field, enter the name of the source exactly as it appears in the "platform" field of tblStatsSource.
3. Re-import the latest online holdings file from Serials Solutions so that data can be matched with the corresponding database stats.
5. You're finally ready to run the import macro. Run the "E-usage update" macro. This macro runs two make-table queries: the first converts the result of the qryCreateOnlineStatsUnion into an independent table called tblOnlineStats (necessary so Access can join that data with the online access data from Serials Solutions.) This step takes only a few seconds. The second step joins tblOnlineStats with tblOnlineAccess to create tblOnlineWithStats. This step takes several minutes to run. A dialog box stating "Upload complete" will appear when the macro is finished running.
6. Once the macro is done, any report with the online access subreport should include the updated data.

Back to Use Study Database documentation