Pardon the mess! The Support Center is undergoing construction.  

Alexandria

Space shortcuts

Page tree


Operations

Export

How helpful was this page? 

Tell us what we can improve.

Related Blog Posts

Blog Posts


Save as PDF

Export Field Mapping

Last Updated: $action.dateFormatter.formatDateTime($content.getLastModificationDate())

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

Field

Header

Notes

Barcode1000Limit 15 characters
First Name1007Limit 25 characters
Last Name1006Limit 25 characters
Middle Name1008Limit 25 characters
Nickname1070Limit 25 characters
Policy1028Limit 4 characters
Uses policy short code as specified in Preferences.
Status1026Integer indicating Status: 1=Active, 2=Card Lost, 3=Suspended, 4=Transferred, 5=Inactive, 6=Other
Government ID * 1002Terminology field, often named SSN
Location * 1004Terminology field, often named Homeroom
Sublocation *1005Terminology field, often named 2nd Location
Level * 1010Terminology field, often named Grade
Community ID * 1001Terminology field, often named Student #
Site1050Site code as specified in Site Management
Optional Date * 1048

Limit 12 characters
Terminology field, often named Graduation Date

Address1011Limit 100 characters
Address 288
City1012Limit 100 characters
State1013Limit 100 characters
Postal Code1014Limit 100 characters
Country1016Limit 100 characters
Telephone1017Limit 25 characters
Date of Birth1045Limit 12 characters
Sex1032Integer indicating sex or gender: Unknown=0 or U, Male=1 or M, Female=2 or F
Contact Notes1020Limit 1000 characters
General Notes1021

Limit 2000 characters

Only the first general note MARC tag will be exported

2nd Phone Number * 1018Limit 25 characters
Terminology field, often named Mobile or Fax
Primary Email1019Limit 100 characters
Other Emails1054Limit 100 characters
Categories1025Limit 1000 characters
Separate category terms with \
Patron Accession Date1046Limit 12 characters
Additional Contact * 1049

Limit 100 characters
Terminology field, often named Parent/Guardian

Username1052Limit 100 characters
Lexile Table1060

Limit 300 characters
All grades contained in single string, rows separated by // and cells by II (e.g. Patron ID<tab>//gradeIIscoreIIsourcelldate ...repeated as necessary)

Password - Encrypted1063

Limit 30 characters
This option is used when importing a password that is already encrypted MD5

Password - Plain Text

Card Exp. Date1047Limit 12 characters
Lexile1051Limit 4 characters
Reading Level *1053Terminology preference field
Patron GUID1200Limit 100 characters
Alert Notes1022Export, only
Pending Holds Count1037Export, only
In Stock Hold Count1039Export, only
Reservations Count1038Export, only
Reserves Count1040Export, only
Balance (Library)1030Export, only
Balance (Textbook)1130Export, only
Total Library Payments1031 Export, only
Total Textbook Payments1131Export, only
Credits1061Export, only
Last Use Date1042Export, only
Lifetime Usage (Library)1033Export, only
Total Library Items Out1034Export, only
Total Textbook Items Out1134Export, only
Lifetime Overdue (Library)1035Export, only
Overdue Library Items1036Export, only
Overdue Textbook Items1136Export, only
Patron Barcode3000Export Patrons Fines report, only
Patron Name3001Export Patrons Fines report, only
Type3002Export Patrons Fines report, only
Description3003Export Patrons Fines report, only
Total3004Export Patrons Fines report, only
Charge Balance3005Export Patrons Fines report, only








Item Export Fields

FieldHeaderMARCNotes
Copy Barcode2000852_pLimit 15 characters
Copy Site Code2023852_aLimit 8 characters
Copy Location *2024852_b

Limit 8 characters
Terminology preference field

Shelving Location *2027

Limit 32 characters
Terminology preference field

Copy Accession Date2009852_1Limit 12 characters
Copy Inventory Date2008852_1Limit 12 characters
Copy Volume2064
Limit 10 characters
Copy Call Number2025852_hLimit 50 characters
Copy Policy Code2013

Limit 4 characters

Copy Serial #2441
Limit 50 characters
Copy Condition2017852_1Limit 4 characters
Vendor2016852_1Limit 50 characters
Purchase Cost2012852_9

Limit 7 characters, up to $99,999.99
Must include decimal (5.00 NOT 5)

Replacement Cost2011

Limit 7 characters, up to $99,999.99
Must include decimal (5.00 NOT 5)

Special Funds *
2022
Limit 45 characters
Terminology preference field
Copy Notes2018852_xLimit 1000 characters
Copy Alert Notes2019852_zLimit 1000 characters
LCCN2010010_a
ISBN2020020_a
Title Volume2026092_v
Primary Author2100100_a
Title2245245_a
Sub Title2246245_b
Statement of Responsibility2247245_c
Medium2248245_h
Edition2250250_a
Publisher Place2260260_a
Publisher2261260_b
Publication Year2262260_c
Extent2300300_a
Other Physical Details2302300_b
Dimensions2303300_c
Accompanying Material2304300_e
General Note2500500_aOnly the first general note MARC tag will be exported
Content Notes2501505_a
Summary2520520_a
Target Audience2521521_a
Review Source2522521_b
Lexile Value2757521_aThe term Lexile will be automatically added to 521_b
Lexile Code2758521_aThe term Lexile will be automatically added to 521_b
Fountas and Pinnell Value2761521_aThe term Fountas and Pinnell will be automatically added to 521_b
Guided Reading Value2762521_aThe term Guided Reading will be automatically added to 521_b
Study Program Name2750526_a


Study Program Interest Code2751526_b
Study Program Reading Level2752526_c
Study Program Point Count2753526_x
Study Program Test Number2759526_z
Study Program Have Test2754526_9
Study Program Holding Code2755526_5
First Subject2651

650_a
650_x
650_y
650_z


Second Subject2652

650_a
650_x
650_y
650_z


Third Subject2653

650_a
650_x
650_y
650_z


Fourth Subject2654

650_a
650_x
650_y
650_z


Fifth Subject2655

650_a
650_x
650_y
650_z


Bibliographic Term2040653_aSeparate each term by \
Genre2442655_a
Curriculum Term2041658_aSeparate each term by \
Series2440830_a
URL Description2531856_y
URL2530856_u
Call Number2063900_a
Don't Show Title in Researcher2042917_a
Policy Code2052

Copy Status2015
Export, only
Copy Borrowed Date2001
Export, only
Limit 12 characters
Copy Days in Circulation2003
Export, only
Copy Check Out Count2002
Export, only
Copy Last Modified Date2004
Export, only
Limit 12 characters
Copy Last Modified By2005
Export, only
Limit 12 characters
Copy Transit History2006
Export, only
Limit 300 characters
Copy Usage History2007
Export, only
Limit 300 characters
Accession Date2047918_bExport, only
Last Use Date2049
Export, only
Last Modified Date2050918_cExport, only
Last Modified User ID2051918_oExport, only
Last Validation Date2054
Export, only
Full Title2240
Export, only
Copy Count2043
Export, only
Available for Check Out2044
Export, only
Title Life-to-Date Usage Count2045
Export, only
Checked Out To2055
Export, only

© 2023 COMPanion® Corporation | All Rights Reserved | Terms of Service & Privacy Policy