The Support Center has moved!! See the new website https://support.goalexandria.com/ 
How helpful was this page?
Related Blog Posts
Blog Posts
-
Say cheese! All about patron pictures
created by
Aug 10, 2022
-
Assigning policies–the complete guide
created by
Mar 23, 2022
-
Update title records with exports & imports? Yes, you can!
created by
Jan 19, 2022
-
Getting equipped: Cataloging items for your library
created by
Jan 13, 2022
-
Saved field mapping—Easy peasy imports
created by
Feb 10, 2021
-
As you like it—Import Headings
created by
Nov 30, 2018
-
Importing MARC Records from a Vendor
created by
Oct 19, 2018
-
New Copies? In Processing
created by
Oct 06, 2014
Import Field Mapping
Last Updated: $action.dateFormatter.formatDateTime($content.getLastModificationDate())
If the import file is recognized, Alexandria will automatically sort, organize, and match the information to the correct, specified fields. If the import file is missing a header, it will not be recognized. The relationships between fields and attributes of different names and types may not match and have to be mapped. Alexandria will require you to set your patron and item field mapping in order to proceed.
Use the Field Mapping dialog to specify where data from the import file belongs in Alexandria; in other words, match data in the import file to specific Alexandria fields. Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right-hand side.
Data is imported in sequential order; use the white up and down arrows to correctly align the fields of the import file. Click on a field to exclude it from the import; clicking on fields will toggle them between a green 
and a red 
. See Item Import Fields by Field Number for more information on the fields that can be imported.
When you've finished matching Alexandria fields to the information in your file, click the Set button.
If you have a patron with a combined first and last name (one that has not been separated by tab delimitation), use this field to split the name into First and Last Name during import.
Related Links
Item Fields by Field Numbers
| Field | Header | MARC | Notes |
|---|---|---|---|
| Copy Barcode | 2000 | 852_p | Limit 15 characters |
| Copy Site Code | 2023 | 852_a | Limit 8 characters |
| Copy Location * | 2024 | 852_b | Limit 8 characters |
| Shelving Location * | 2027 | Limit 32 characters | |
| Copy Accession Date | 2009 | 852_1 | Limit 12 characters |
| Copy Inventory Date | 2008 | 852_1 | Limit 12 characters |
| Copy Number | 2021 | 852_t | Limit 6 characters |
| Copy Volume | 2064 | Limit 10 characters | |
| Copy Call Number | 2025 | 852_h | Limit 50 characters |
| Copy Policy Code | 2013 | Limit 4 characters | |
| Copy Serial # | 2441 | Limit 50 characters | |
| Copy Condition | 2017 | 852_1 | Limit 4 characters |
| Vendor | 2016 | 852_1 | Limit 50 characters |
| Purchase Cost | 2012 | 852_9 | Limit 7 characters, up to $99,999.99 |
| Replacement Cost | 2011 | Limit 7 characters, up to $99,999.99 | |
| Special Funds * | 2022 | Limit 45 characters Terminology preference field | |
| Copy Notes | 2018 | 852_x | Limit 1000 characters |
| Copy Alert Notes | 2019 | 852_z | Limit 1000 characters |
| LCCN | 2010 | 010_a | |
| ISBN | 2020 | 020_a | |
| Title Volume | 2026 | 092_v | |
| Primary Author | 2100 | 100_a | |
| Title | 2245 | 245_a | |
| Sub Title | 2246 | 245_b | |
| Statement of Responsibility | 2247 | 245_c | |
| Medium | 2248 | 245_h | |
| Edition | 2250 | 250_a | |
| Publisher Place | 2260 | 260_a | |
| Publisher | 2261 | 260_b | |
| Publication Year | 2262 | 260_c | |
| Extent | 2300 | 300_a | |
| Other Physical Details | 2302 | 300_b | |
| Dimensions | 2303 | 300_c | |
| Accompanying Material | 2304 | 300_e | |
| General Note | 2500 | 500_a | |
| Content Notes | 2501 | 505_a | |
| Summary | 2520 | 520_a | |
| Target Audience | 2521 | 521_a | |
| Review Source | 2522 | 521_b | |
| Lexile Value | 2757 | 521_a | The term Lexile will be automatically added to 521_b |
| Lexile Code | 2758 | 521_a | The term Lexile will be automatically added to 521_b |
| Fountas and Pinnell Value | 2761 | 521_a | The term Fountas and Pinnell will be automatically added to 521_b |
| Guided Reading Value | 2762 | 521_a | The term Guided Reading will be automatically added to 521_b |
| Study Program Name | 2750 | 526_a | |
| Study Program Interest Code | 2751 | 526_b | |
| Study Program Reading Level | 2752 | 526_c | |
| Study Program Point Count | 2753 | 526_x | |
| Study Program Test Number | 2759 | 526_z | |
| Study Program Have Test | 2754 | 526_9 | |
| Study Program Holding Code | 2755 | 526_5 | |
| First Subject | 2651 | 650_a | |
| Second Subject | 2652 | 650_a | |
| Third Subject | 2653 | 650_a | |
| Fourth Subject | 2654 | 650_a | |
| Fifth Subject | 2655 | 650_a | |
| Bibliographic Term | 2040 | 653_a | Separate each term by \ |
| Genre | 2442 | 655_a | |
| Curriculum Term | 2041 | 658_a | Separate each term by \ |
| Series | 2440 | 830_a | |
| URL Description | 2531 | 856_y | |
| URL | 2530 | 856_u | |
| Call Number | 2063 | 900_a | |
| Don't Show Title in Researcher | 2042 | 917_a | |
| Policy Code | 2052 |
MultiExcerpt named PatronFields was not found -- Please check the page name and MultiExcerpt name used in the MultiExcerpt-Include macro
