The Support Center has moved!! See the new website https://support.goalexandria.com/ 
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
Export Fields
Last Updated: $action.dateFormatter.formatDateTime($content.getLastModificationDate())
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
Field | 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 | Limit 12 characters |
| Address | 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 Fax |
| 1019 | Limit 100 characters | |
| Categories | 1025 | Limit 1000 characters Separate category terms with \ |
| Patron Accession Date | 1046 | Limit 12 characters |
| Additional Contact * | 1049 | Limit 100 characters |
| Username | 1052 | Limit 100 characters |
| Lexile Table | 1060 | Limit 300 characters |
| Password - Encrypted | 1063 | Limit 30 characters |
| Password - 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 |
