How to load MARC records for Naxos

Naxos Music Library Records

 

Naxos publishes MARC Records to their blog at http://naxosmusiclibrary.blogspot.com/. The files are in MARC XML format so they need to be converted to MARC before they can be loaded.

Download the “Full Set by Year” for the Naxos Music Library. File will download as a .7z file. Use WinZip or Unarchiver to open the archive and extract it to a folder on your desktop. Once extracted, you should have XML files for each year.

 

New Records:

 

  • In MarcEdit, go to Tools > Batch Process Records.

  • For Source Directory, browse to the folder with the XML files

  • Leave File Types blank.

  • Under Functions, select MARCXML => MARC

  • Click Process. Once complete, you should now see a folder called “processed_files” that contains the MARC versions of each XML file.

  • In MarcEdit, go to Tools > MARCJoin

  • For Save File, click the Folder icon and browse to a location on your desktop where you’d like to save the file. Give it a name and click Save.

  • For File(s) to Join, click the folder icon and browse to the files you’re going to join. Select all and click Open.

  • Click Process. Once complete, you should now see your joined file in the location you specified.

  • Open the file in MarcEdit.

  • Go to Tools > Manage Tasks. If you have not yet imported the Naxos Music Library task, do that now. Otherwise, select the Naxos Music Library task and click Edit Selected Task List. *** See full MarcEdit task details below.

  • In the task list, click on the last task which adds a 910 $a field with the batchload date. You need to modify the date to today’s date.

  • Click on the Edit icon and update the date. Then click Add Field.

  • Click Save to save the change to the task.

  • Close the Manage Tasks window.

  • Click on Tools > Current Tasks > Naxos Music Library. Once task is complete, verify that changes were applied properly.

  • This task should do the following:

    • Add the prefix “naxos” to the 001 field

    • Replace the default 856 field with institution-specific fields, each with its own URL

    • Add 949 field with a location field for each library

    • Add 910 field with the the following note: naxos-nml-YYYYMMDD (where YYYYMMDD is the date of the batchload).

  • Click on File > Compile Options > Compile File to MARC.

  • Give the file a name and save it to your desktop.

  • In Sierra, go to Data Exchange.

  • Select Process = Load records via locally-created load profiles (local)

  • Click Get PC to upload the MARC file from your desktop.

  • Select the file and click Prep

  • Remove the .lfts extension from the filename and select the .lmarc extension from the dropdown menu.

  • Select the .lmarc file and click Load > Load a SAUDIO file

  • In the Admin Corner, open the "saudio" load profile and check for the following:

    • Default record templates should be “conrea,conrei

    • ov_action = d (assuming all libraries still have access and should have items on each record)

    • 001 should be loaded as-is

    • 856 should be loaded as-is

    • @link i:1:949 line should be uncommented to that items are created

    • 949 $l should be uncommented so that location codes are pulled from the 949 fields

  • In Data Exchange, click on Test. Make sure that overlays are not getting new items and that new records are receiving items.

  • Load one record and check for accuracy.

  • Load remaining records.

 

Delete Records:

 

Naxos also publishes “removals”. These need to be deleted. Naxos publishes their removals at the same time they publish their new record sets. Download the “Removals” file for that quarter. This will download as a CSV file.

 

  • Open the CSV file in Excel.

  • Delete the entire first column and then insert a blank column in its place. For each cell, add the word “naxos”. You will join this word with the record id numbers so that we can match on the 001 field in Sierra.

  • In Excel, highlight the column containing the record numbers. Click on Format > Cells > Number. Change the decimal places to ‘0’ and click OK.

  • In Column C, enter the formula =A1&B1 and press enter. You should see the content from cells A1 and B1 concatenated in C1.

  • Click on the new cell in C1 and then drag that cell’s handle (the little box in the lower right corner of the cell) all the way to the bottom of the column until you’ve reached the end of the record numbers. Release the handle, and all cells should now contain the concatenated record numbers.

  • Highlight the entire column and click on Edit (or right click on PC) > Copy. Then click on Edit > Paste Special > Values > OK.

  • Now delete all columns except for the new column with the concatenated record numbers.

  • Insert a new header row at the top of the worksheet and give it the header “Record Number”. 

  • Click on File > Save As.

  • Give the file a name and save it to your desktop as a Tab delimited text (.txt) file.

  • In MarcEdit, go to Tools (Add-ins on PC) > Delimited Text Translator.

  • For Source File, click the Folder icon and select the file you just created.

  • For Output File, click the Folder icon to navigate to the location where you want to save the MARC file and give it a name. Then click Save.

  • For Delimiter, select Tab.

  • Click Import Data.

  • Click on the Map Data tab

  • In the Select menu, select the column containing record numbers. Should be called “Record Number” if you followed the steps above.

  • For Map To, enter 001 and click Add Argument

  • Click Process Data. Once complete, this will produce a .mrk file.

  • Locate and open the .mrk file in MarcEdit

  • Click on File > Compile Options > Compile File to MARC

  • Select a location to save the file and give it a name. Then click Save.

  • In Sierra, go to Data Exchange.

  • Select Select Process > Load records via locally-created load profiles (local)

  • Click Get PC to upload the MARC file from your desktop.

  • Select the file and click Prep

  • Remove the .lfts extension from the filename and select the .lmarc extension from the dropdown menu.

  • Select the .lmarc file and click Load > Load a SAUDIO file

  • In the Admin Corner, open the "saudio" load profile and check for the following:

    • ov_action=“b

    • Comment out this line:

      • #|||0|0| | |0|n|G|0|@link="i:1:949”

  • In Data Exchange, click on Test. Make sure that overlays are not getting new items and that any records that are not overlays are rejected (since these are deletes, we don’t want to create any new records).

  • Click on Use Review Files.

  • Click Load

  • Once complete, go to Create Lists.

  • Select a review file with enough room to hold the file of deleted records.

  • Click Copy and then select the review file created from the record load. It will be called “Load: Overlaid records for…

  • When prompted to remove the file after copying, click Yes.

  • Go to Global Update.

    • Under the “1. Select Records” tab on the left, use the dropdown menu to select Review. Use the dropdown menu for “Review file” to select the file (the number will match the list number you created), then click Search.

    • Under the “2. Command input tab”, select Change fixed-length field, and click OK.

      • Fixed-length = 31 SUPPRESS

      • Find = <any>

      • Replace = y DELETE

      • Click OK 

    • Click the “3. Preview” tab to review the changes

    • If the changes are appropriate, click Process

 

____________________________________________________________________________

 

*** MarcEdit task details

Naxos Music Library:

 

1.

FIND:

=001  (.*)

REPLACE:

=001  naxos$1

 

2.

FIND:

=856  (.*)\$uhttp://univportal.naxosmusiclibrary.com(.*)

REPLACE:

=856$1$uhttps://denison.idm.oclc.org/login?url=http://denisonuni.naxosmusiclibr… listen online at Naxos Music Library\n=856  $1$uhttps://libproxy.kenyon.edu/login?url=http://kenyoncoll.naxosmusiclibra… listen online at Naxos Music Library\n=856 $1$uhttps://owu.idm.oclc.org/login?url=http://ohiowesleyan.naxosmusiclibrar… Wesleyan listen online at Naxos Music Library\n=856  $1$uhttps://wooster.idm.oclc.org/login?url=http://wooster.naxosmusiclibrary… listen online at Naxos Music Library

 

3.

ADD:

Field: 949

Field data:  $lden

[✓] Insert last

 

4.

ADD:

Field: 949

Field data:  $lken

[✓] Insert last

 

5.

ADD:

Field: 949

Field data:  $lowu

[✓] Insert last

 

6.

ADD:

Field: 949

Field data:  $lwoo

[✓] Insert last

 

7.

ADD:

Field: 910

Field data:  $anaxos-nml-YYYYMMDD      (insert the current date)

[✓] Insert last

 

Naxos Music Library - Jazz

 

1.

FIND:

=001  (.*)

REPLACE:

=001  naxos$1

 

2.

FIND:

=856  (.*)\$uhttp://univportal.naxosmusiclibrary.com(.*)

REPLACE:

=856$1$uhttps://denison.idm.oclc.org/login?url=http://denisonuni.naxosmusiclibr… listen online at Naxos Music Library\n=856  $1$uhttps://libproxy.kenyon.edu/login?url=http://kenyoncoll.naxosmusiclibra… listen online at Naxos Music Library\n=856 $1$uhttps://owu.idm.oclc.org/login?url=http://ohiowesleyan.naxosmusiclibrar… Wesleyan listen online at Naxos Music Library

 

3.

ADD:

Field: 949

Field data:  $lden

[✓] Insert last

 

4.

ADD:

Field: 949

Field data:  $lken

[✓] Insert last

 

5.

ADD:

Field: 949

Field data:  $lowu

[✓] Insert last

 

6.

ADD:

Field: 910

Field data:  $anaxos-nml-jazz-YYYYMMDD     (insert the current date)

[✓] Insert last