Middlebury

Difference between revisions of "Loading Records Using Data Exchange"

m
 
(6 intermediate revisions by one other user not shown)
Line 1: Line 1:
[[Cataloging|&lt;&lt; Back to Cataloging]] <br> [[Innovative (Millennium)|&lt;&lt; Back to Innovative (Millennium)]]<br>  
+
[[Cataloging|&lt;&lt; Back to Cataloging]] <br> [[Innovative (Millennium)|&lt;&lt; Back to Innovative (Millennium)]]<br>
  
 
== Downloading MARC Records from Online Vendor Sites (like Oxford)<br>  ==
 
== Downloading MARC Records from Online Vendor Sites (like Oxford)<br>  ==
Line 5: Line 5:
 
==== Edit/Prepare records via MarcEdit  ====
 
==== Edit/Prepare records via MarcEdit  ====
  
#Download file from Vendor/publisher website: Usually you have the option to Open or Save with Marcedit. You save a step or two by choosing "Open with MarcEdit."  
+
#Download file from Vendor/publisher website: Usually you have the option to Open or Save with Marcedit. You save a step or two by choosing "Open with MarcEdit."
#Using MarcEdit once opened:  
+
#Using MarcEdit once opened:
#*MarcEdit Input file: should already be filled in with the file link  
+
#*MarcEdit Input file: should already be filled in with the file link
#*MarcEdit output file: click '''Browse''', choose location to download, then name file &amp; save<br>  
+
#*MarcEdit output file: click '''Browse''', choose location to download, then name file &amp; save<br>
#*Back to MARC tools window, click '''Execute'''. Then click '''Close'''. Saves as MARC text file (using '''mrk''' extension). This will allow you to view records and make changes.  
+
#*Back to MARC tools window, click '''Execute'''. Then click '''Close'''. Saves as MARC text file (using '''mrk''' extension). This will allow you to view records and make changes.
#*Go to downloaded file and click&nbsp; to open  
+
#*Go to downloaded file and click&nbsp; to open
#*If necessary, make changes to records:  
+
#*If necessary, make changes to records:
#**From top toolbar, choose '''Tools/AddDelete fields''', etc. (e.g., 655 Electronic books). From this same menu you can also edit subfields and indicators.<br><u>Example</u>: <br>To add a 730 to all records, int eh Field Data box, type ''0\$aOxford handbooks online''. (The backward slash stands for no 2nd indicator)<br>
+
#**From top toolbar, choose '''Tools/AddDelete fields''', etc. (e.g., 655 Electronic books). From this same menu you can also edit subfields and indicators.<br><u>Example</u>: <br>To add a 730 to all records, in the Field Data box, type: ''0\$aOxford handbooks online''. (The backward slash stands for no 2nd indicator)<br><br><u>Example</u>:<br>To simply append data to the end of a subfield, add ''^e'' to the "Field Data" textbox and the data to be appended in the "Replace With" textbox.<br><br>To append data to the end of the subfield while replacing a text string, add ''^e[string to replace]'' to the "Field Data" textbox and the data to be appended in the "Replace With" textbox.<br> <br>
#**From top toolbar, choose'''Edit/FindReplace''', etc. (856 ezproxy prefix) <br><u>Example</u>:<br>In "Find what" box, type: ''=856 40$uhttp://''<br>In Replace with" box, type:&nbsp;''=http://ezproxy.middlebury.edu/login?url=http://''<br>  
+
#**From top toolbar, choose '''Edit/FindReplace''', etc. (856 ezproxy prefix) <br><u>Example</u>:<br>In "Find what" box, type: ''=856 40$u''<br>In Replace with" box, type: ''=856 40$uhttp://ezproxy.middlebury.edu/login?url=http://''<br>
#*Next, change file format from mrk to mrc:  
+
#*Next, change file format from mrk to mrc:
#**From top toolbar, choose '''File/Compile file into MARC'''  
+
#**From top toolbar, choose '''File/Compile file into MARC'''
#**Give file a name &amp; save  
+
#**Give file a name &amp; save
#**Creates/saves on desktop with '''mrc''' extension<br>  
+
#**Creates/saves on desktop with '''mrc''' extension<br>
 
#*Close MarcEdit<br>
 
#*Close MarcEdit<br>
  
 
==== Use Millennium Data Exchange  ====
 
==== Use Millennium Data Exchange  ====
  
#On the left menu Millennium Client toolbar, click '''Data Exchange''' icon  
+
#On the left menu Millennium Client toolbar, click '''Data Exchange''' icon
#Select process: '''Load records via locally created load profiles'''  
+
#Select process: '''Load records via locally created load profiles'''
#Click Get PC; select file location; select file name with '''mrc''' (not '''mrk''') extension. Click '''Upload'''  
+
#Click Get PC; select file location; select file name with '''mrc''' (not '''mrk''') extension. Click '''Upload'''
#Rename file window: For "Accepted suffix", choose:<span style="font-weight: bold;"> lfts. </span>Click '''OK'''  
+
#Rename file window: For "Accepted suffix", choose:<span style="font-weight: bold;"> lfts. </span>Click '''OK'''
#Back at main results list, highlight file &amp; click '''Prep '''icon at top menu  
+
#Back at main results list, highlight file &amp; click '''Prep '''icon at top menu
#At next screen, click '''Start '''button. Output message will hopefully show no errors. Should be same number of input records as output records  
+
#At next screen, click '''Start '''button. Output message will hopefully show no errors. Should be same number of input records as output records
#Click '''Close'''. This saves file as type '''lmarc'''  
+
#Click '''Close'''. This saves file as type '''lmarc'''
#Highlight '''lmarc '''file&nbsp;  
+
#Highlight '''lmarc '''file&nbsp;
#Click Load A (EAM file). You&nbsp; may want to click '''Test''' first. Also, before you do this step, you may need to alert Barbara Merz to change the item record template that this Load table points to.  
+
#Click Load R (Load eMARC - general purpose). (Or another appropriate load table from this [[Load_table_information|information page]]) You&nbsp; may want to click '''Test''' first. Also, before you do this step, you may need to alert Barbara Merz to change the item record template that this Load table points to.
#Select '''Load''': Load records via locally created load profile. Close window.  
+
#Select '''Load''': Load records via locally created load profile. Close window.
 
#Check records in Millennium.
 
#Check records in Millennium.
  
<br>  
+
<br>
  
[[Category:Millennium]] [[Category:Data_exchange]] [[Category:MarcEdit]] [[Category:MARC_records]]
+
[[Category:Millennium]]
 +
[[Category:Data exchange]]
 +
[[Category:MarcEdit]]
 +
[[Category:MARC records]]
 +
[[Category:Innovative Interfaces]]

Latest revision as of 10:54, 28 January 2015

<< Back to Cataloging
<< Back to Innovative (Millennium)

Downloading MARC Records from Online Vendor Sites (like Oxford)

Edit/Prepare records via MarcEdit

  1. Download file from Vendor/publisher website: Usually you have the option to Open or Save with Marcedit. You save a step or two by choosing "Open with MarcEdit."
  2. Using MarcEdit once opened:
    • MarcEdit Input file: should already be filled in with the file link
    • MarcEdit output file: click Browse, choose location to download, then name file & save
    • Back to MARC tools window, click Execute. Then click Close. Saves as MARC text file (using mrk extension). This will allow you to view records and make changes.
    • Go to downloaded file and click  to open
    • If necessary, make changes to records:
      • From top toolbar, choose Tools/AddDelete fields, etc. (e.g., 655 Electronic books). From this same menu you can also edit subfields and indicators.
        Example:
        To add a 730 to all records, in the Field Data box, type: 0\$aOxford handbooks online. (The backward slash stands for no 2nd indicator)

        Example:
        To simply append data to the end of a subfield, add ^e to the "Field Data" textbox and the data to be appended in the "Replace With" textbox.

        To append data to the end of the subfield while replacing a text string, add ^e[string to replace] to the "Field Data" textbox and the data to be appended in the "Replace With" textbox.

      • From top toolbar, choose Edit/FindReplace, etc. (856 ezproxy prefix)
        Example:
        In "Find what" box, type: =856 40$u
        In Replace with" box, type: =856 40$uhttp://ezproxy.middlebury.edu/login?url=http://
    • Next, change file format from mrk to mrc:
      • From top toolbar, choose File/Compile file into MARC
      • Give file a name & save
      • Creates/saves on desktop with mrc extension
    • Close MarcEdit

Use Millennium Data Exchange

  1. On the left menu Millennium Client toolbar, click Data Exchange icon
  2. Select process: Load records via locally created load profiles
  3. Click Get PC; select file location; select file name with mrc (not mrk) extension. Click Upload
  4. Rename file window: For "Accepted suffix", choose: lfts. Click OK
  5. Back at main results list, highlight file & click Prep icon at top menu
  6. At next screen, click Start button. Output message will hopefully show no errors. Should be same number of input records as output records
  7. Click Close. This saves file as type lmarc
  8. Highlight lmarc file 
  9. Click Load R (Load eMARC - general purpose). (Or another appropriate load table from this information page) You  may want to click Test first. Also, before you do this step, you may need to alert Barbara Merz to change the item record template that this Load table points to.
  10. Select Load: Load records via locally created load profile. Close window.
  11. Check records in Millennium.


Powered by MediaWiki