Scope: This document details the methods by which these batch processing statistics are derived, including information about tools and files used, and where they may be found. These statistics must be gathered from various Access reports, from multiple databases. Some statistics are required for the department-wide spreadsheet that is shared with Library Administration; some are for inter-departmental use. The department-wide spreadsheet can be found at L://tsstats/LTS_Stats_2005-2017[current year].xlsx (See image below).
Contact: Nancy Solla
Unit: Batch Processing
Date last updated: 6/25/2019
Date of next review: June 2020
The portion of this spreadsheet devoted to Batch Processing includes these categories:
...
D. “Records Exported” – The information for this total comes from the spreadsheet found at “L://Batch_Processing/LoadExtractLogs/VoyagerExtracts[FYdates].xls.” The total for the FY is derived by adding together the totals from the following sheets in the document: “Batchmatch (MARCadia)” + “OCLC Archives & Man. Records” (CRN12) + “OCLC Institutional Records” + “OCLC MARC Local Holdings” (CRN10) + “OCLC Daily Export" (CRN15 and CRN16). ” (NOTE: These jobs are cron jobs, run against large numbers of records at a time. )Batchmatch MARCadia and OCLC Institutional Records scripts ceased to be run and logged as of FYE 1617.)
1.) Use “L:1.) Use “L://Batch_Processing/LoadExtractLogs/VoyagerExtracts[FYdates].xls.”
2.) The total for the FY is derived by adding together the totals from the following sheets in the document: “Batchmatch (MARCadia)” + “OCLC Archives & Man. Records” + “OCLC Institutional Records” + “OCLC MARC Local Holdings” + “OCLC Daily Export.” Enter data into LTS_Stats_2005-20[YY].xlsx.
...
G. “Batch OP ID Stats” – This information will be gathered by running the “Batch Bib Summary Report” found in the “3_BATCHstats.mdb.” Statistics for all batch operator id’s will be gathered for interdepartmental use and entered into the spreadsheet, “BATCHID_Stats_ FY[YY]_[YY].xlsx” found in L:\Batch_Processing\Statistics\BatchIDStats.
1.) Use database 3_BATCHstats.mdb
...
3.) Use statistics for all batch operator ID’s. Enter into BATCHID_Stats_FY[YY[_[YY].xlsx (found at L:\Batch_Processing\Statistics\BatchIDStats). This document contains statistics for records created or updated by a Batch Processing staff member using their “batchnetid” log in.
...
Staff member must run this LS Tools script, found at Admin Proc/TS Stats Summary (CGI24), for each individual month.
...
Batch Stats Summary query | subfield value | instance | records | | | | | bi | Andinos1391 | 20171110 | 12 | bi | Andinos1391 | TOTAL (1) | 12 | bi | BACH1316 | 20171106 | 13 | bi | BACH1316 | TOTAL (1) | 13 | bi | BACH1317 | 20171110 | 15 | bi | BACH1317 | TOTAL (1) | 15 | bi | BACH1318 | 20171101 | 16 | bi | BACH1318 | TOTAL (1) | 16 | bi | BACH1319 | 20171115 | 16 | bi | BACH1319 | TOTAL (1) | 16 | bi | BACH1320 | 20171109 | 8 | bi | BACH1320 | TOTAL (1) | 8 | bi | BACH1322 | 20171106 | 18 | bi | BACH1322 | TOTAL (1) | 18 | bi | BACH1323 | 20171110 | 17 | bi | BACH1323 | TOTAL (1) | 17 | bi | BACH1324 | 20171110 | 19 | bi | BACH1324 | TOTAL (1) | 19 | bi | BACH1325 | 20171101 | 14 | bi | BACH1325 | TOTAL (1) | 14 | bi | BACH1326 | 20171110 | 17 | bi | BACH1326 | TOTAL (1) | 17 | bi | Cambeiro1095 | 20171108 | 20 | bi | Cambeiro1095 | TOTAL (1) | 20 | bi | Cambeiro1167 | 20171107 | 19 | bi | Cambeiro1167 | TOTAL (1) | 19 | bi | Cambeiro1191 | 20171107 | 21 | bi | Cambeiro1191 | TOTAL (1) | 21 | bi | Eulyoo | 20171103 | 31 | bi | Eulyoo | TOTAL (1) | 31 | bi | HoChiMinh | 20171108 | 317 | bi | HoChiMinh | TOTAL (1) | 317 | bi | Iturriaga8706 | 20171128 | 11 | bi | Iturriaga8706 | TOTAL (1) | 11 | bi | Iturriaga8707 | 20171128 | 15 | bi | Iturriaga8707 | TOTAL (1) | 15 | bi | Retta16831 | 20171107 | 25 | bi | Retta16831 | TOTAL (1) | 25 | bi | Retta16832 | 20171107 | 21 | bi | Retta16832 | TOTAL (1) | 21 | | | | | bm | UpdatedTreatises_20171009UTF8.mrc | 20171122 | 30 | bm | UpdatedTreatises_20171009UTF8.mrc | TOTAL (1) | 30 | bm | WorldShare | 20171120 | 6484 | bm | WorldShare | 20171127 | 1549 | bm | WorldShare | 20171113 | 1211 | bm | WorldShare | 20171106 | 796 | bm | WorldShare | TOTAL (4) | 10040 | bm | addnew899 | 20171109 | 59 | bm | addnew899 | 20171101 | 49 | bm | addnew899 | TOTAL (2) | 108 | bm | bib_replace | 20171110 | 795 | bm | bib_replace | TOTAL (1) | 795 | bm | deloclcprefix | 20171103 | 705 | bm | deloclcprefix | 20171110 | 617 | bm | deloclcprefix | 20171117 | 547 | bm | deloclcprefix | 20171124 | 429 | bm | deloclcprefix | TOTAL (4) | 2298 | bm | olat | 20171107 | 29 | bm | olat | TOTAL (1) | 29 | | | | | ind3 | AUX_Fine | 20171116AuxamInvoice171030592923.mrc.uc | 10 | ind3 | AUX_Fine | 20171116AuxamInvoice171011591776.mrc.uc | 10 | ind3 | AUX_Fine | 20171116AuxamInvoice171019592315.mrc.uc | 9 | ind3 | AUX_Fine | TOTAL (3) | 29 | ind3 | AUX_Olin | 20171102AuxamInvoice171009591556.mrc.uc | 1 | ind3 | AUX_Olin | 20171102AuxamInvoice170928590873.mrc.uc | 1 | ind3 | AUX_Olin | 20171127AuxamInvoice171027592854.mrc.uc | 1 | ind3 | AUX_Olin | 20171102AuxamInvoice171004591372.mrc.uc | 1 | ind3 | AUX_Olin | 20171101AuxamInvoice171009591557.mrc.uc | 1 | ind3 | AUX_Olin | 20171102AuxamInvoice171013591932.mrc.uc | 1 | ind3 | AUX_Olin | 20171120AuxamInvoice171027592848.mrc.uc | 1 | ind3 | AUX_Olin | TOTAL (7) | 7 | ind3 | Casalini | 20171115bsr-Nyra40b.983 | 9 | ind3 | Casalini | 20171115bsr-Nyra40b.984 | 7 | ind3 | Casalini | 20171103bsr-Nyra40g.366 | 7 | ind3 | Casalini | 20171103bsr-Nyra40g.370 | 5 | ind3 | Casalini | 20171116bsr-Nyra40x.771 | 5 | ind3 | Casalini | 20171115bsr-Nyra40w.899 | 5 | ind3 | Casalini | 20171115bsr-Nyra40w.898 | 5 | ind3 | Casalini | 20171103bsr-Nyra40g.364 | 5 | ind3 | Casalini | 20171115bsr-Nyra40f.839 | 4 | ind3 | Casalini | 20171103bsr-Nyra40g.368 | 4 | ind3 | Casalini | 20171128bsr-Nyra40w.900 | 3 | ind3 | Casalini | 20171115bsr-Nyra40d.607 | 3 | ind3 | Casalini | 20171115bsr-Nyra40g.371 | 3 | ind3 | Casalini | 20171115bsr-Nyra40f.840 | 3 | ind3 | Casalini | 20171103bsr-Nyra40g.369 | 3 | ind3 | Casalini | 20171128bsr-Nyra40q.264 | 3 | ind3 | Casalini | 20171103bsr-Nyra40e.256 | 2 | ind3 | Casalini | 20171110bsr-Nyra40q.262 | 2 | ind3 | Casalini | 20171116bas-Nyra40O.186 | 2 | ind3 | Casalini | 20171115bsr-Nyra40d.608 | 2 | ind3 | Casalini | 20171116bsr-Nyra40x.770 | 2 | ind3 | Casalini | 20171115bsr-Nyra40m.343 | 2 | ind3 | Casalini | 20171108bsr-Nyra40O.185 | 1 | ind3 | Casalini | 20171115bas-Nyra40t.052 | 1 | ind3 | Casalini | 20171103bas-Nyra40t.051 | 1 | ind3 | Casalini | 20171115bsr-Nyra40v.501 | 1 | ind3 | Casalini | 20171115bsr-Nyra40z.111 | 1 | ind3 | Casalini | 20171115bsr-Nyra40O.187 | 1 | ind3 | Casalini | 20171115bsr-Nyra40q.263 | 1 | ind3 | Casalini | 20171120bsr-Nyra40u.283 | 1 | ind3 | Casalini | 20171107bsr-Nyra40u.281 | 1 | ind3 | Casalini | 20171115bsr-Nyra40g.372 | 1 | ind3 | Casalini | 20171115bsr-Nyra40m.342 | 1 | ind3 | Casalini | 20171103bsr-Nyra40e.257 | 1 | ind3 | Casalini | 20171108bsr-Nyra40v.500 | 1 | ind3 | Casalini | 20171120bsr-Nyra40u.282 | 1 | ind3 | Casalini | TOTAL (36) | 100 | ind3 | CassLex | 20171120COR_LEXIS-ETREATn20171117.mrc | 13 | ind3 | CassLex | 20171130COR_LEXIS-ETREATu20171117.mrc | 1 | ind3 | CassLex | TOTAL (2) | 14 | ind3 | Coutts | 20171128110917NAapp.mrc.uc | 354 | ind3 | Coutts | 20171101101917NAapp.mrc.uc | 300 | ind3 | Coutts | 20171115110217NAapp.mrc.uc | 298 | ind3 | Coutts | 20171108102617NAapp.mrc.uc | 211 | ind3 | Coutts | 20171101101917NAapp.mrc.u | 1 | ind3 | Coutts | TOTAL (5) | 1164 | ind3 | CouttsShelfReady | 2.01711E+15 | 10 | ind3 | CouttsShelfReady | TOTAL (1) | 10 | ind3 | EastView | 20171108EV20171107-155.mrc.uc | 12 | ind3 | EastView | TOTAL (1) | 12 | ind3 | Fast_updates | 20171101FASTChangeReport2017-08-09.txt | 3284 | ind3 | Fast_updates | 20171103FASTChangeReport2017-09-18.txt | 1818 | ind3 | Fast_updates | 20171101FASTChangeReport2017-07-12.txt | 1657 | ind3 | Fast_updates | 20171103FASTChangeReport2017-10-12.txt | 1465 | ind3 | Fast_updates | 20171103FASTChangeReport2017-09-19.txt | 593 | ind3 | Fast_updates | 20171103FASTChangeReport2017-10-10.txt | 158 | ind3 | Fast_updates | 20171101FASTChangeReport2017-08-04.txt | 1 | ind3 | Fast_updates | TOTAL (7) | 8976 | ind3 | HARRASSMARCNOW | 20171117COR#2794_22_10_2_2017.mrc.uc | 22 | ind3 | HARRASSMARCNOW | 20171129COR#2793_20_10_2_2017.mrc.uc | 20 | ind3 | HARRASSMARCNOW | 20171115COR#2789_15_9_25_2017.mrc.uc | 15 | ind3 | HARRASSMARCNOW | 20171129COR#2811_13_10_16_2017.mrc.uc | 13 | ind3 | HARRASSMARCNOW | 20171109COR#2788_11_9_25_2017.mrc.uc | 11 | ind3 | HARRASSMARCNOW | 20171103COR#2779_10_9_11_2017.mrc.uc | 10 | ind3 | HARRASSMARCNOW | 20171115COR#2787_9_9_25_2017.mrc.uc | 9 | ind3 | HARRASSMARCNOW | 20171117COR#2800_8_10_9_2017.mrc.uc | 8 | ind3 | HARRASSMARCNOW | 20171117COR#2799_8_10_9_2017.mrc.uc | 8 | ind3 | HARRASSMARCNOW | 20171103COR#2767_7_9_04_2017.mrc.uc | 7 | ind3 | HARRASSMARCNOW | 20171106COR#2786_8_9_25_2017.mrc.uc | 7 | ind3 | HARRASSMARCNOW | 20171106COR#2759_7_28_8_2017.mrc.uc | 7 | ind3 | HARRASSMARCNOW | 20171115COR#2785_6_9_25_2017.mrc.uc | 6 | ind3 | HARRASSMARCNOW | 20171128COR#2797_6_10_9_2017.mrc.uc | 6 | ind3 | HARRASSMARCNOW | 20171120COR#2798_6_10_9_2017.mrc.uc | 6 | ind3 | HARRASSMARCNOW | 20171103COR#2778_6_9_11_2017.mrc.uc | 6 | ind3 | HARRASSMARCNOW | 20171120COR#2804_5_10_16_2017.mrc.uc | 5 | ind3 | HARRASSMARCNOW | 20171115COR#2784_5_9_25_2017.mrc.uc | 5 | ind3 | HARRASSMARCNOW | 20171117COR#2795_5_10_9_2017.mrc.uc | 5 | ind3 | HARRASSMARCNOW | 20171106COR#2777_5_9_11_2017.mrc.uc | 5 | ind3 | HARRASSMARCNOW | 20171120COR#2805_5_10_16_2017.mrc.uc | 5 | ind3 | HARRASSMARCNOW | 20171103COR#2776_4_9_11_2017.mrc.uc | 4 | ind3 | HARRASSMARCNOW | 20171116COR#2782_4_9_25_2017.mrc.uc | 4 | ind3 | HARRASSMARCNOW | 20171120COR#2796_5_10_9_2017.mrc.uc | 4 | ind3 | HARRASSMARCNOW | 20171103COR#2764_4_9_04_2017.mrc.uc | 4 | ind3 | HARRASSMARCNOW | 20171108COR#2781_3_9_25_2017.mrc.uc | 3 | ind3 | HARRASSMARCNOW | 20171117COR#2790_3_10_2_2017.mrc.uc | 3 | ind3 | HARRASSMARCNOW | 20171103COR#2763_3_9_04_2017.mrc.uc | 3 | ind3 | HARRASSMARCNOW | 20171103COR#2762_3_9_04_2017.mrc.uc | 3 | ind3 | HARRASSMARCNOW | 20171115COR#2783_4_9_25_2017.mrc.uc | 2 | ind3 | HARRASSMARCNOW | 20171115COR#2783_4_9_25_2017.mrc.uc..f | 1 | ind3 | HARRASSMARCNOW | 20171117COR#2801_2_10_16_2017.mrc.uc | 1 | ind3 | HARRASSMARCNOW | TOTAL (32) | 218 | ind3 | Harrassowitz | 2017110320170922102706.24setblo.inv.mrc.uc | 25 | ind3 | Harrassowitz | 2017112820171027111939.24setblo.inv.mrc.uc | 23 | ind3 | Harrassowitz | 2017112820171027111943.24setblo.inv.mrc.uc | 11 | ind3 | Harrassowitz | 2017110320170922102712.24setblo.inv.mrc.uc | 6 | ind3 | Harrassowitz | TOTAL (4) | 65 | ind3 | IndoRR | 20171116IndoRRset1.mrc | 99 | ind3 | IndoRR | TOTAL (1) | 99 | ind3 | Kanopy | 20171116Kanopy_11152017_17_fxd.mrc | 16 | ind3 | Kanopy | TOTAL (1) | 16 | ind3 | Myilibraryeeduappr | 20171106Cornell_ePDA_11032017_edu.mrc.uc | 3 | ind3 | Myilibraryeeduappr | TOTAL (1) | 3 | ind3 | OverDriveEbk | 20171103OverDrive_OvD_11032017_5_Cataloged.mrc | 3 | ind3 | OverDriveEbk | TOTAL (1) | 3 | ind3 | PRVATY_X2C | 20171106Rand_20170807through20171031.mrc | 106 | ind3 | PRVATY_X2C | TOTAL (1) | 106 | ind3 | PRVEHT_~ZI | 20171130Law_Nov2017.mrc.uc | 10 | ind3 | PRVEHT_~ZI | TOTAL (1) | 10 | ind3 | PRVLSH_ACAJP | 20171109CITH1711-NOV17.uc | 1410 | ind3 | PRVLSH_ACAJP | TOTAL (1) | 1410 | ind3 | PRVLSH_AJLOV | 20171109coo-20171109aln.mrc.uc | 5 | ind3 | PRVLSH_AJLOV | 20171117coo-20171115aln.mrc.uc | 4 | ind3 | PRVLSH_AJLOV | TOTAL (2) | 9 | ind3 | SerialSolutions | 20171120COO_360MARC_Update_20171116_monographs_new.mrc.uc | 58911 | ind3 | SerialSolutions | 20171120COO_360MARC_Update_20171116_monographs_changed.mrc.uc | 19871 | ind3 | SerialSolutions | 20171117COO_360MARC_Update_20171116_serials_changed.mrc.uc | 9496 | ind3 | SerialSolutions | 20171117COO_360MARC_Update_20171116_serials_new.mrc.uc | 1801 | ind3 | SerialSolutions | TOTAL (4) | 90079 | ind3 | berenguer | 20171130hbbooks_271712.mrc.uc | 24 | ind3 | berenguer | 20171130hbbooks_271711.mrc.uc | 24 | ind3 | berenguer | TOTAL (2) | 48 | ind3 | bks24x7SKSFTevid | 20171103Books24x7_all_videoall_2017-09-30.mrc.uc | 2317 | ind3 | bks24x7SKSFTevid | 20171101Books24x7-videoall-UPDATED-on-03-31-17.mrc.uc | 47 | ind3 | bks24x7SKSFTevid | TOTAL (2) | 2364 |
| | | | | | | | | |
|
3.) The total is derived by adding “Catalog/Format/Computer files” total + “Catalog/Format/e-Resources (books)” total + “Catalog/Format/Sound recordings” total. (net id in 948 is “batch” for these counts.) Enter data into LTS_Stats_2005-20[YY].xlsx The data from the second section, headed “Batch Stats Summary” must have entries separated by “query” (‘bi’ on ‘Inputting’ page, ‘bm’ on ‘Maintenance’ page, and ‘ind3’ on ‘New’ page) and then by “subfield value,” and must be copied and pasted into the spreadsheet, “3_Batch_Stats_FY[yy]_[yy].xlsx” found in L:\tsstats\Batch Stats.
I. “Fastshelve” – In 1New_culv2-2012-2013.accdb, there is a make table query called “Find fastshelve” (See image below) that can be run to gather bib-level statistics on the number of records fast-shelved by LTS staff. Criteria for the date range and the name of the output table must be manually changed each year.
...
3.) The resulting table should be delivered to the Batch Processing Supervisor for review.
Save
Save
Save
Save
Save
Save
Save
Save
Save
Save