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
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
this info has been merged into https://support.goalexandria.com/operations/import/import-field-mapping/#patron
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 |
Nickname | 1070 | 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 Only the first general note MARC tag will be exported |
2nd Phone Number * | 1018 | Limit 25 characters Terminology field, often named Mobile or Fax |
Primary Email | 1019 | Limit 100 characters |
Other Emails | 1054 | 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 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 |
Balance (Library) | 1030 | Export, only |
Balance (Textbook) | 1130 | Export, only |
Total Library Payments | 1031 | Export, only |
Total Textbook Payments | 1131 | Export, only |
Credits | 1061 | Export, only |
Last Use Date | 1042 | Export, only |
Lifetime Usage (Library) | 1033 | Export, only |
Total Library Items Out | 1034 | Export, only |
Total Textbook Items Out | 1134 | Export, only |
Lifetime Overdue (Library) | 1035 | Export, only |
Overdue Library Items | 1036 | Export, only |
Overdue Textbook Items | 1136 | 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 |
Charge Balance | 3005 | Export Patrons Fines report, only |
Item Export Fields
this info has been merged into https://support.goalexandria.com/operations/import/import-field-mapping/#item
Field | Header | MARC | Notes |
---|---|---|---|
Copy Barcode | 2000 | 852_p | Limit 15 characters |
Copy Site Code | 2023 | 852_a | Limit 8 characters |
Copy Location * | 2024 | 852_b | Limit 8 characters |
Shelving Location * | 2027 | Limit 32 characters | |
Copy Accession Date | 2009 | 852_1 | Limit 12 characters |
Copy Inventory Date | 2008 | 852_1 | Limit 12 characters |
Copy Volume | 2064 | Limit 10 characters | |
Copy Call Number | 2025 | 852_h | Limit 50 characters |
Copy Policy Code | 2013 | Limit 4 characters | |
Copy Serial # | 2441 | Limit 50 characters | |
Copy Condition | 2017 | 852_1 | Limit 4 characters |
Vendor | 2016 | 852_1 | Limit 50 characters |
Purchase Cost | 2012 | 852_9 | Limit 7 characters, up to $99,999.99 |
Replacement Cost | 2011 | Limit 7 characters, up to $99,999.99 | |
Special Funds * | 2022 | Limit 45 characters Terminology preference field | |
Copy Notes | 2018 | 852_x | Limit 1000 characters |
Copy Alert Notes | 2019 | 852_z | Limit 1000 characters |
LCCN | 2010 | 010_a | |
ISBN | 2020 | 020_a | |
Title Volume | 2026 | 092_v | |
Primary Author | 2100 | 100_a | |
Title | 2245 | 245_a | |
Sub Title | 2246 | 245_b | |
Statement of Responsibility | 2247 | 245_c | |
Medium | 2248 | 245_h | |
Edition | 2250 | 250_a | |
Publisher Place | 2260 | 260_a | |
Publisher | 2261 | 260_b | |
Publication Year | 2262 | 260_c | |
Extent | 2300 | 300_a | |
Other Physical Details | 2302 | 300_b | |
Dimensions | 2303 | 300_c | |
Accompanying Material | 2304 | 300_e | |
General Note | 2500 | 500_a | Only the first general note MARC tag will be exported |
Content Notes | 2501 | 505_a | |
Summary | 2520 | 520_a | |
Target Audience | 2521 | 521_a | |
Review Source | 2522 | 521_b | |
Lexile Value | 2757 | 521_a | The term Lexile will be automatically added to 521_b |
Lexile Code | 2758 | 521_a | The term Lexile will be automatically added to 521_b |
Fountas and Pinnell Value | 2761 | 521_a | The term Fountas and Pinnell will be automatically added to 521_b |
Guided Reading Value | 2762 | 521_a | The term Guided Reading will be automatically added to 521_b |
Study Program Name | 2750 | 526_a | |
Study Program Interest Code | 2751 | 526_b | |
Study Program Reading Level | 2752 | 526_c | |
Study Program Point Count | 2753 | 526_x | |
Study Program Test Number | 2759 | 526_z | |
Study Program Have Test | 2754 | 526_9 | |
Study Program Holding Code | 2755 | 526_5 | |
First Subject | 2651 | 650_a | |
Second Subject | 2652 | 650_a | |
Third Subject | 2653 | 650_a | |
Fourth Subject | 2654 | 650_a | |
Fifth Subject | 2655 | 650_a | |
Bibliographic Term | 2040 | 653_a | Separate each term by \ |
Genre | 2442 | 655_a | |
Curriculum Term | 2041 | 658_a | Separate each term by \ |
Series | 2440 | 830_a | |
URL Description | 2531 | 856_y | |
URL | 2530 | 856_u | |
Call Number | 2063 | 900_a | |
Don't Show Title in Researcher | 2042 | 917_a | |
Policy Code | 2052 | ||
Copy Status | 2015 | Export, only | |
Copy Borrowed Date | 2001 | Export, only Limit 12 characters | |
Copy Days in Circulation | 2003 | Export, only | |
Copy Check Out Count | 2002 | Export, only | |
Copy Last Modified Date | 2004 | Export, only Limit 12 characters | |
Copy Last Modified By | 2005 | Export, only Limit 12 characters | |
Copy Transit History | 2006 | Export, only Limit 300 characters | |
Copy Usage History | 2007 | Export, only Limit 300 characters | |
Accession Date | 2047 | 918_b | Export, only |
Last Use Date | 2049 | Export, only | |
Last Modified Date | 2050 | 918_c | Export, only |
Last Modified User ID | 2051 | 918_o | Export, only |
Last Validation Date | 2054 | Export, only | |
Full Title | 2240 | Export, only | |
Copy Count | 2043 | Export, only | |
Available for Check Out | 2044 | Export, only | |
Title Life-to-Date Usage Count | 2045 | Export, only | |
Checked Out To | 2055 | Export, only |