Middlebury

Difference between revisions of "Loading Records Using Data Exchange"

m
m
 
(33 intermediate revisions by one other user not shown)
Line 1: Line 1:
Downloading from online site (like Oxford)<br>  
+
[[Cataloging|&lt;&lt; Back to Cataloging]] <br> [[Innovative (Millennium)|&lt;&lt; Back to Innovative (Millennium)]]<br>
  
Using MarcEdit
+
== Downloading MARC Records from Online Vendor Sites (like Oxford)<br>  ==
  
Download file:
+
==== Edit/Prepare records via MarcEdit  ====
  
Usually you have the option to Save or Open with Marcedit. You save a step or two by opening 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:
 +
#*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>
 +
#*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
 +
#*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, 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$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:
 +
#**From top toolbar, choose '''File/Compile file into MARC'''
 +
#**Give file a name &amp; save
 +
#**Creates/saves on desktop with '''mrc''' extension<br>
 +
#*Close MarcEdit<br>
  
Output file: click Browse, then name file, save to desktop (usually), and save as type MARC text file (using '''mr'''k extension). This will allow you to view records and make changes.
+
==== Use Millennium Data Exchange  ====
  
Click Execute.  
+
#On the left menu Millennium Client toolbar, click '''Data Exchange''' icon
 +
#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'''
 +
#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
 +
#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'''
 +
#Highlight '''lmarc '''file&nbsp;
 +
#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.
 +
#Check records in Millennium.
  
Go to desktop and click icon to open
+
<br>
  
Make changes:  
+
[[Category:Millennium]]
 
+
[[Category:Data exchange]]
Tools--Add/Edit fields, etc.&nbsp;; Edit--Find/replace, etc.
+
[[Category:MarcEdit]]
 
+
[[Category:MARC records]]
File -- Compile file into MARC. Creates it with '''mrc''' extension.
+
[[Category:Innovative Interfaces]]
 
 
Should be on your desktop now.
 
 
 
Using Millennium Data Exchange
 
 
 
 
 
 
 
Click Data Exchange icon
 
 
 
Get PC: select desktop; select file. click upload
 
 
 
Accepted suffix: '''lfts'''
 
 
 
Highlight file: click Prep
 
 
 
Click Start.
 
 
 
Close. Saves as type lmarc
 
 
 
HIghlight file if not already
 
 
 
Click Load C (load a MARC file slow rate)
 
 
 
Select process: Load records via locally created load profiles
 

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