ASP New Admin MARC

Overview

On June 2, 2017 will exclusively use a new administrative portal for making MARC records available. The following procedures suggest a way to download the MARC records and load them. There are two over-arching goals for the process. First, we want to load all records as quickly and accurately as possible. Second, we need to track which records are part of a purchased collection -- which gives us perpetual access -- versus which are only part of a subscribed collection. As of writing, the only subscribed collection is Academic Video Online (AVON).

Admin Portal Link

To login go to: http://adminportal.alexanderstreet.com/user/login

Login details are available here: "file:///\\lib-fs-2k12\libshare$\elecres\VendorInformation\Resource_Administrative_Information_FGM-2016-05-02-46317.xlsx"

Proceed to Menu > Marc Records > Custom Sets

Selecting Files

• 1. Set the updated dates to the last time we did a download to the current date (eg. 3/1/2017 to 4/10/2017).

• 1. Run the search to narrow down the total results, which can be seen at the bottom of the page with the results.

• 1. Under collections, select each collection that isn't a subscribed collection and select the search button. Download all MARC records in result. Set the collection back to "none."

• 1. Repeat this process until all collections have been downloaded.

  2. Unzip all the files - they can go into directories with the same name they came out of.

• 1. Place all of the extracted folders into a single folder called "ASP Firm" (making them subfolders within the ASPFirm folder).

  2. Open a command line window.

• 1. Navigate to the directory where the downloaded folders are. Enter the following text to combine all the files in the subfolders into a single file...

  2. for /r "c:\...." %a in (*.mrc) do type "%a" >> aspFirmMonth.mrc

  3. where the text above has "c:\..." you'll enter the directory (include the quotes). For example, my ASPFirm folder is in the director C:\users\fenichele\downloads\ASPFirm so my text string will be:

  4. for /r "c:\users\fenichele\downloads\ASPfirm" %a in (*.mrc) do type "%a" >> aspFirmMarch.mrc