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
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 |
Item Export Fields
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 Number | 2021 | 852_t | Limit 6 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 | |
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 | |
Title Sequence # | 2099 | 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 |