Page tree
Skip to end of metadata
Go to start of metadata

URIs into Bibliographic Records Project - Step by Step

Summary steps:

  1. Run a Sirsi report (demo)

  2. Export metadata (demo)

  3. Convert file to .mrc (demo)

  4. Build records containing URIs

  5. Import records into Sirsi

1.Run a Sirsi report (demo)

In Sirsi, go to the Reports tab and select Schedule New Reports from the Common Tasks menu on left.

Under the Bibliographic tab, choose the Extract keys for Marc Export report

Setup & Schedule.

SirsiExtractKeysReport.PNG

Under the Basic tab, rename the report to the specific task, like HistFictTest in place of Extract Keys for Marc Export.

BasicTab.PNG


Under the Item Selection tab, click on the gadget for the Home location.

Select the desired record set using the gadget to the right of the text box.

Double click or arrow over to select.

Click OK.

HomeLocation.PNG


Run now.

Go to Finished reports. (Check status of report, and refresh Finished reports list)

FinishedReport.PNG


Select your report and view the results.

ViewExtractReportLog.PNG


A text file will open up in Notepad.

*************************************************************************************************************

HistFictReportLog.PNG

*************************************************************************************************************

2. Export the metadata (demo)

Go to the Utility tab and select Marc Export from the Common Tasks menu.

Click "Export all records to one file" radio button.

Click View all records.

Click OK.

MarcExport.PNG


On the next screen, the Export tab should show the client radio button selected.

Use the gadget to the right of the text box for “File name on client” to select a destination and name for the file.

Click OK and Export.

MarcExport2.PNG

A message should appear saying that the export was completed. Click on OK.


Open the text file.

A window will open asking you to choose the program you want to use to open the file.

Choose Notepad and click OK.

ChooseProgramToOpenSirsiRpt.PNG


The Sirsi report looks like this:

SirsiFlatFile.PNG




3. Convert file to .mrc (demo)

Open MarcEdit 6.

Click on the Marc Tools icon to open the MarcBreaker function.


MarcTools.PNG




Select the Input File by using the yellow folder to choose the finished Sirsi report (text file).

For this example, the Sirsi report was saved to the desktop.

ChooseInputInMarcEditTools.PNG



OutputforMarcTools.PNG

Assign the same file path to the Output File, but with an .mrk (Mnemonic text) file extension.

MarcBreaker should already be the selected Function.

Execute.

Click the Edit Records button that will become available.

The MarcEditor tool will open up.

MarcEditorToolsSaveAs.PNG


Go to File, Save as, keep the same name but with a .mrc file extension, in the URIs_inBibRecords\Project files for staff folder.

Close the MarcEditor.

Open the folder with staff name in the Project files to confirm its location.

Scale back to Project files for staff folder to view rest of staff folders.


Recap: Ran a Sirsi report, exported the results, converted the file to a .mrk (Mnemonic text) file, then saved it as an .mrc (binary) file type which is needed to use the MarcEdit Link Identifiers tool for adding URIs to MARC records.

4. Build linked data records

On the MarcEdit landing page, click on MarcNext.

MarcEditSplash.PNG

LinkIdentifiers.PNG


Then click on Link Identifiers to open the Build Linked Records screen.


BuildLinkedRecords.PNG

Use the yellow folder to the right of the Source File textbox to select the assigned file.

(G:\Acq&D\Current Department Projects\URIs_InBibRecords\Project files for staff\Staff name\file name)

NOTE: The source file MUST BE in .mrc format


The Save File name have the same file path as the Source File, EXCEPT it needs an .mrk extension.

The Rules File should have this file path:

D:\Users\name\AppData\Roaming\marcedit\configs\linked_data_profile.xml


Under [LOC] ID Services, check the three boxes highlighted above.  

Process.

When processing is finished, click OK to close the tool.





Back in your project folder, looked for the new .mrk file.

Double click and it will open in the MarcEditor.

Go to File, Save As an .mrc file with “LD” in front of the name.

SaveLD.PNG


Spot check your results by pasting links from the $0 into your browser.

CopyLink.PNG


PasteLink.PNG

5. Import records into Sirsi  

Staff will import records and run Sirsi report according to the Import Schedule.

Open the Sirsi Utility module.

Select MARC Import under Common Tasks.

Click OK on the default screen (neither Behavior box is checked).

MarcImport.PNG



Under the Marc Import tab, use the gadget to select the .mrc source file with the newly added linked data.

Name the destination file with a name that is easily identifiable to you (e.g. 01HistFict). File extensions are unnecessary for the destination file.

Click Import (b).

ImportLDfile.PNG


"Are there more files to upload?" :  Select No.

Close.  


ImportedLD.PNG



Open the Sirsi Reports module.

Schedule New Reports, click OK.

Select the Load bibliographic records on the MarcImport tab.


RunReport.PNG


Set up & schedule.


Under the Load tab, select the destination file (e.g. 01HistFict) you named when you imported the .mrc file with linked data.  Use the gadget to select the correct Title Control Number matching rule 4.   Click OK.

RunLoadBibRpt.PNG

Also adjust the following settings, if necessary:

TitleControlNumberSource.PNG

LoadGeneralInformation.PNG


Then click the Run Now button at the bottom of the Load tab screen.



To check on the status of your report, go to Finished Reports, click on the bunny icon to refresh.

Depending on your permissions, your list may be much shorter than the screenshot below.  To see the results of your import, select the Report name, View.

FinishedReport.PNG


SirsiViewFinishedReport.PNG


Click OK to see the MARC records with URIs in the 1XX, 7XX, and 6XX fields..

Example of Discovery layer display:

http://catalog.lib.ncsu.edu/record/NCSU3599424


  • No labels