First very rough draft of general links and tasks useful to Batch & Sierra regularly occurring duties
...
Most batch files are for various e-resources, but some tangible batch record collection are also loaded via batch files ((print DDA files), vendor and ready files, government document and map files, (loaded by Government Information staff), etc.)
Copy/Paste the batch file name(s) into each Collection Tracker in Box as soon as they are downloaded/received
Take note of how many records there are in a batch file
if that number changes after a batch processes, then something went wrong, and the file or the process needs to be checked for problems: some of which can be as simple as duplicate bibs in the file, but at other times, may be indicating one or more bibs with errors from a typo or a missing field)
When loading into Sierra, always click Use Review Files; then Test the batch, and if it looks good, Load.
Avoid at all costs, loading files out of order (generally, this is by the date on in the file , name but some dates will have need to be added as you are downloading them)
If possible, keep up with weekly loads, so loading dates out of order does not become a possibility
For most collection batch files, when the files have the same date; first load new/additions files, then delete files (there are exceptions noted in the these workflows); but, always check the date, and load files with earliest date before the latest.
001 fields: each MARC record in a batch file needs a unique control number that is not duplicated anywhere in the catalog (we may need to overlay them later) - some collections already have good 001 as as supplied by the vendor; and all current batch collections have documented methods to apply prefixes or create completely unique numbers.
For any completely new batch collection, where the 001 fields are missing or contain simple numbers, there will need to be a method worked out to apply a new, non-duplicating prefix or a creation method for a 001 (and add it to your new workflow)
Hooks: a series of fields and codes are applied to each batch collection, making them easier to batch edit or remove. The current master document of hooks is kept in USU’s Box; updates will need to be added and updates distributed to various areas of the library (such cataloging, LIT, etc.), as old batch collections are changed, deaccessioned, or new ones are added. The most current Master List E-Resource Hooks is kept here: https://usu.app.box.com/file/1326778691763.
It will need regular updating, with new batch purchases, and regular batch perpetual purchases, as seen in the screen shot below:
...
Start with single record loads for Wageningen, then weekly record loads of Cambridge EBA, Taylor & Francis EBA, Safari/O'Reilly subscription, and the YBP discovery records, and then the more complex Academic Complete update records. (One thing to remember is to watch the dates on the ebook discovery and deletes and make sure you load them in order; also, with 1 exception, don't load deletes until you have loaded the discovery records with earlier dates.) Make sure you use the tracking sheet versions with “current” at the end.
...
I’ve included my suggested answers to your questions below in red. Becky, what do you think?
...
First, I have been counting the Delete loads as records loaded, but I then remove them. So, maybe a new category? Or possibly not, since we no longer base our numbers of things in the catalog from our cataloging stats. Yes! These definitely need to be a different category. You can use the “MARC Batch-Deleted Records” in the stats. That is what Carol has been using for her batch removed records.
I also have gotten a steady stream of emails with single deletions to be done manually, where I simply erase a PDDA record that we have gotten in another format. I’ve counted those as part of the batch stuff, since again, I haven’t cataloged them individually (just deleted them). This one is a hard one. The closest thing we have is the “Sierra-Items Deleted” column. A while back, Barb made the call to collapse the “titles deleted” and the “items deleted” into one category to make it easier to record weeding projects. We decided the larger number was probably more useful. The PDDA records are odd because we never owned the item, it was always just a discovery record. So, you have a few options to consider: 1) Could make a new category for “records deleted” so that the PDDA number could be reported more accurately (but it might be complicated by the fact that Barb doesn’t report records deleted for her work – and assumptions might be made that this field includes all records deleted) or 2) you could use the “Sierra-Items Deleted” for these few one offs (complication is that this could be interpreted as materials deaccessioned) or 3) could create its own category for “PDDA records deleted” or 4) Option I can’t think of at the moment… 😊
I also download individual records from the streaming video sites for Gaby, again these are vendor records, and I edited them the same as the batch records. So, I could count them as individually cataloged titles, but I don’t do much check (except for the link) and I add in the “hooks”, so I’ve been uncertain how to count them. Right now they are in my Batch stats, because, vendor records and process is the same. I would recommend “Genstacks-CopyCat-Electronic” for this. As long as you are doing them one-by-one that is. If you are pulling them individually but compiling them into groups to manipulate and load records, then “GenStacks-Batch-Modified”.
Melanie
I will add Statistics to each workflow as soon as possible (while still keeping weekly duties on track…)
...