How helpful was this page?
Related Blog Posts
Blog Posts
-
Tip compilation: end-of-year edition
created by
May 17, 2023
-
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
The following is a list of Alexandria's export-only patron and item fields (i.e. fields that Alexandria exports, but doesn't import). However, the program is capable of exporting much, much more. For a full list of the Alexandria's patron import and export fields, check out Item Field Mapping.
Export-only Patron Fields
Export-only Items Fields
First Name
Header
Alert Notes 1022 Pending Holds Count 1037 In Stock Hold Count 1039 Reservations Count 1038 Reserves Count 1040 Total Fines 1030 Total Payments 1031 Credits 1061 Last Use Date 1042 Life to Date Usage 1033 Total Currently Out 1034 Life to Date Overdue 1035 Currently Overdue 1036
Export Patrons Fine report
First Name
Header
Patron Barcode 3000 Patron Name 3001 Type 3002 Description 3003 Total 3004 Balance 3005
Field Name
Header
Copy Status 2015 Copy Borrowed Date 2001 Copy Days in Circulation 2003 Copy Check Out Count 2002 Copy Last Modified Date 2004 Copy Last Modified By 2005 Copy Transit History 2006 Copy Usage History 2007 Accession Date 2047 Last Use Date 2049 Last Modified Date 2050 Last Modified User ID 2051 Last Validation Date 2054 Title Sequence # 2099 Full Title 2240 Copy Count 2043 Available for Check Out 2044 Title Life-to-Date Usage Count 2045 Checked Out To 2055
Patron Export Fields
Limit 12 characters 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 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 Limit 2000 characters 2nd Phone Number * 1018 Limit 25 characters
Terminology field, often named Mobile or FaxEmail 1019 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 RSN 1099 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 Total Fines 1030 Export, only Total Payments 1031 Export, only Credits 1061 Export, only Last Use Date 1042 Export, only Life to Date Usage 1033 Export, only Total Currently Out 1034 Export, only Life to Date Overdue 1035 Export, only Currently Overdue 1036 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 Balance 3005 Export Patrons Fines report, only