Deleting Holdings from the NHU-PAC
NHAIS libraries have always been responsible for deleting holdings from the NHU-PAC for any materials they no longer hold. Without an online holdings maintenance tool this process is going to be brought into NHAIS Services for the first time. Consequently, this procedure is somewhat experimental. We have tested this process and think that it will be manageable, but once we start getting requests from libraries for deletions we may find that some aspect of the process--either what libraries send us or what we do when we get it--may need to change.
- Create a spreadsheet containing ONLY one sheet and a SINGLE column of data (without a header row). The data in that column will be the NHU-PAC bib number of the records you want your holding deleted from. The cells must be formatted as numbers with 0 decimal places.
- Save the spreadsheet as a csv file and name it CODEmmddyyyy.csv where CODE is your library's HSA code and the date is the day you are sending us the spreadsheet.
- Email the csv file as an attachment to nhu-pac@nh.gov with the subject "Deletions for CODE" (use your library's HSA code in place of CODE).
- Don't put more than 20 bib numbers in your file
- Indicate in the email what software you used to create the csv file (MSExcel, etc.)
- Wait until you get an email back from us indicating the file was correctly formatted before sending another one
The process we will be using to delete holdings is an automated loading and item removal process and the format of the data being loaded must be exactly what the program expects so we will return files for reformatting if they aren't in the format we can load. After you have sent one file and heard back from us that it could be used you will be able to send csv files with as many deletions in them as you want.
January 2016 update: deletes will be processed in batches, probably quarterly. Files of bib numbers must be AT LEAST 100 numbers unless they are your library's first file (which will be a test batch of 20) or the file is a full year's worth of deletions and that was fewer than 100.
August 2017 update: email addresses were updated to reflect new NHSL addresses
Hi Mary, thanks for the update. In Excel, there are three options for CSV files: Macintosh, ms-dos, and comma delimited. Do we need to choose a specific one of those, or will any do?
ReplyDeleteGood question: you want to choose CSV (comma delimited).
Delete