Blog

Tip for 10.22.18

When you receive a file of item records from the vendor, importing those records into Alexandria doesn’t need to be complicated. Follow these steps for a painless import process.


Best practices

  • We highly recommend that you run imports when Alexandria is not busy. Large imports could slow down your system. This also makes it easier to track down any problems later on, as it isolates activity during that time.

  • The format of the file may be MARC, MicroLIF, or tab-delimited. In the case of tab-delimited, we recommend using Alexandria Headers for accurate field mapping. Otherwise, you'll need to manually adjust it by clicking Field Mapping for each import.

  • Create Saved Imports to save the settings you use most often, including Field Mapping (v7 only).



To import item records from a vendor file in v7

  1. Go to Tools and select Import.

  2. Click the Items category.

  3. Drag and drop your import file onto the window, or use Choose File to select from your desktop.

  4. Set Field Mapping, if needed.

  5. For this example, select Add or Update Titles & Copies.

  6. Make sure Always add at least one Copy is unchecked and Title Update Matching is set to ISBN OR LCCN.

  7. Set Barcode Handling to Reassign Only Duplicate Barcodes; vendors typically know your barcode range and have assigned them in the file. 

  8. Go to the Options tab and set the Title and Copy options as necessary, if the vendor didn't supply them. In the Copy subtab, make sure the Site is set correctly. 

  9. When you're finished, click Run.

  10. Check Operations Management for the status of your import.



To import item records from a vendor file in v6

  1. Go to Tools and select Import.

  2. Choose Quick for a one-time import, or add a new Advanced import for FTP imports and field mapping.

  3. Drag and drop your import file onto the window, or use the plus icon (+) to select from your desktop.

  4. Click the Item Settings tab.

  5. Set Copies to Add Found Copies.

  6. Check the boxes for Use Imported BarcodesReassign Duplicate Barcodes, and Allow Title Updates.

  7. Look over the location defaults and Item Policy settings.

  8. When you're finished, click Start.

  9. Check Operations Management for the status of your import.

If you use Mackin or Bound to Stay Bound, you can turn on automatic imports.

Want more tips? 

Sign up for the emails!

How helpful was this page? 

Your Rating:
Results:
1 Star2 Star3 Star4 Star5 Star
4 rates

Tell us what we can improve.

6 Comments

  1. Anonymous

    How do I import records from OverDrive

    1. Myra AUTHOR

      Hi! If you have our OverDrive registration, you can configure the preference and have the records import automatically. See our article here: OverDrive

      Otherwise, you would follow the same instructions in this tip, only "Add Titles". Read more here Add Titles (see the tab for Import Electronic Resources).

  2. Anonymous

    Hi, I've just gone to alexandria 7 on the cloud and my normal means of importing files from vendors isn't working (Junior library guild, files ending in .MRC).  There is a message that it's either too large or has the wrong ending.   I've tried to  rename the file to microlif.001, which has worked in the past or microlif.txt and its still not working. Any ideas? Can call the customer service number if this question is too complicated.  Thanks! 

    1. Hello! .MRC files should work for item imports, so that's probably not the issue. Have you checked to make sure the file is 50 megabytes (MB) or smaller? If you use macOS, you can check a file's size by right-clicking on the file, selecting Get Info, and looking under the General section. On Windows, you can right-click on the file, select Properties, and look under the General tab.

      If the .MRC file is 50 MB or smaller and the import is still giving you that error, please feel free to call Customer Support at 1-800-347-4942!

  3. Anonymous

    Can I import perpetual access eBook MARC records from EBSCO?

    1. Hi! Check out our instructions on Importing eBooks. As long as your records are in a format Alexandria accepts (MARC, MicroLIF, or other tab-delimited formats, including .txt, .tab, .tsv, .mrc, .mlif, .001, and .dat), you should be good to go. Feel free to call Customer Support at 1-800-347-4942 if you need additional assistance!

Write a comment…