The Alexandria Makeover is here! See what has changed. 
Related Blog Posts
Blog Posts
-
Update title records with exports & imports? Yes, you can!
created by
Jan 19, 2022
-
Analyze your collection—Mitinet and Titlewave
created by
Aug 06, 2021
-
Exports—Move and modify data
created by
May 05, 2021
-
Export Patron Fines
created by
Apr 27, 2015
Export Field Mapping
Last Updated: Nov 23, 2021 08:42
Open an export, then go to the Options tab and click Select Fields. For an Items exports, the Tab Delimited format must be selected.
Specify which fields to export and in what order they will be included in the file. Data is imported in sequential order. Use the white up and down arrows to change the order of the fields, or click on a field to exclude it from the import. Fields with a green 
will be exported, and fields with a red 
will not.
When you've finished selecting and ordering the fields, click Set and Run the export.
Patron Export Fields
Limit 12 characters Limit 2000 characters Only the first general note MARC tag will be exported Limit 100 characters Limit 300 characters Limit 30 charactersField
Header
Notes
Barcode 1000 Limit 15 characters First Name 1007 Limit 25 characters Last Name 1006 Limit 25 characters Middle Name 1008 Limit 25 characters Nickname 1070 Limit 25 characters Policy 1028 Limit 4 characters
Uses policy short code as specified in Preferences.Status 1026 Integer indicating Status: 1=Active, 2=Card Lost, 3=Suspended, 4=Transferred, 5=Inactive, 6=Other Government ID * 1002 Terminology field, often named SSN Location * 1004 Terminology field, often named Homeroom Sublocation * 1005 Terminology field, often named 2nd Location Level * 1010 Terminology field, often named Grade Community ID * 1001 Terminology field, often named Student # Site 1050 Site code as specified in Site Management Optional Date * 1048
Terminology field, often named Graduation DateAddress 1011 Limit 100 characters Address 2 88 City 1012 Limit 100 characters State 1013 Limit 100 characters Postal Code 1014 Limit 100 characters Country 1016 Limit 100 characters Telephone 1017 Limit 25 characters Date of Birth 1045 Limit 12 characters Sex 1032 Integer indicating sex or gender: Unknown=0 or U, Male=1 or M, Female=2 or F Contact Notes 1020 Limit 1000 characters General Notes 1021 2nd Phone Number * 1018 Limit 25 characters
Terminology field, often named Mobile or FaxPrimary Email 1019 Limit 100 characters Other Emails 1054 Limit 100 characters Categories 1025 Limit 1000 characters
Separate category terms with \Patron Accession Date 1046 Limit 12 characters Additional Contact * 1049
Terminology field, often named Parent/GuardianUsername 1052 Limit 100 characters Lexile Table 1060
All grades contained in single string, rows separated by // and cells by II (e.g. Patron ID<tab>//gradeIIscoreIIsourcelldate ...repeated as necessary)Password - Encrypted 1063
This option is used when importing a password that is already encrypted MD5Password - Plain Text Card Exp. Date 1047 Limit 12 characters Lexile 1051 Limit 4 characters Reading Level * 1053 Terminology preference field Patron GUID 1200 Limit 100 characters Alert Notes 1022 Export, only Pending Holds Count 1037 Export, only In Stock Hold Count 1039 Export, only Reservations Count 1038 Export, only Reserves Count 1040 Export, only Balance (Library) 1030 Export, only Balance (Textbook) 1130 Export, only Total Library Payments 1031 Export, only Total Textbook Payments 1131 Export, only Credits 1061 Export, only Last Use Date 1042 Export, only Lifetime Usage (Library) 1033 Export, only Total Library Items Out 1034 Export, only Total Textbook Items Out 1134 Export, only Lifetime Overdue (Library) 1035 Export, only Overdue Library Items 1036 Export, only Overdue Textbook Items 1136 Export, only Patron Barcode 3000 Export Patrons Fines report, only Patron Name 3001 Export Patrons Fines report, only Type 3002 Export Patrons Fines report, only Description 3003 Export Patrons Fines report, only Total 3004 Export Patrons Fines report, only Charge Balance 3005 Export Patrons Fines report, only
Item Export Fields
Limit 8 characters Limit 32 characters Limit 4 characters Limit 7 characters, up to $99,999.99 Limit 7 characters, up to $99,999.99 650_a 650_a 650_a 650_a 650_aField 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
Terminology preference fieldShelving Location * 2027
Terminology preference fieldCopy Accession Date 2009 852_1 Limit 12 characters Copy Inventory Date 2008 852_1 Limit 12 characters Copy Volume 2064 Limit 10 characters Copy Call Number 2025 852_h Limit 50 characters Copy Policy Code 2013 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
Must include decimal (5.00 NOT 5)Replacement Cost 2011
Must include decimal (5.00 NOT 5)Special Funds * 2022 Limit 45 characters
Terminology preference fieldCopy 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 Only the first general note MARC tag will be exported 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_x
650_y
650_zSecond Subject 2652
650_x
650_y
650_zThird Subject 2653
650_x
650_y
650_zFourth Subject 2654
650_x
650_y
650_zFifth Subject 2655
650_x
650_y
650_zBibliographic 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 Copy Status 2015 Export, only Copy Borrowed Date 2001 Export, only
Limit 12 charactersCopy Days in Circulation 2003 Export, only Copy Check Out Count 2002 Export, only Copy Last Modified Date 2004 Export, only
Limit 12 charactersCopy Last Modified By 2005 Export, only
Limit 12 charactersCopy Transit History 2006 Export, only
Limit 300 charactersCopy Usage History 2007 Export, only
Limit 300 charactersAccession Date 2047 918_b Export, only Last Use Date 2049 Export, only Last Modified Date 2050 918_c Export, only Last Modified User ID 2051 918_o Export, only Last Validation Date 2054 Export, only Full Title 2240 Export, only Copy Count 2043 Export, only Available for Check Out 2044 Export, only Title Life-to-Date Usage Count 2045 Export, only Checked Out To 2055 Export, only
