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
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 |