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
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 |
|
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 Terminology field, often named Graduation Date | 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 | Email | 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 Terminology field, often named Parent/Guardian | Username | 1052 | Limit 100 characters | Lexile Table | 1060 | 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 - Encrypted | 1063 | Limit 30 characters This option is used when importing a password that is already encrypted MD5 | 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 |
|
|
|
|