The Support Center has moved!! See the new website https://support.goalexandria.com/ 
Items
The root page ALEX:Items could not be found in space Alexandria.
Related Blog Posts
Blog Posts
-
Items: a few things you may not know...
created by
Apr 12, 2023
-
Searching by Subject
created by
Nov 16, 2022
-
Assigning policies–the complete guide
created by
Mar 23, 2022
-
Title Assistant to the rescue!
created by
Jan 27, 2022
-
Overdue Items Notices? We've got you cover-ed
created by
Nov 24, 2021
-
Search smarter!—Combine search results
created by
Oct 13, 2021
-
Using Contents Notes
created by
Sep 23, 2021
-
Introducing... FAQs!
created by
Jul 07, 2021
-
Changing call numbers—helpful utilities
created by
Mar 03, 2021
-
From our librarians—Reusable book menu cards
created by
Nov 18, 2020
Field Mapping
Item Fields by Field Number
| Field | Header | MARC | Type | Notes |
|---|---|---|---|---|
| Copy Barcode | 2000 | 852_p | Import/Export | Limit 15 characters |
| Copy Site Code | 2023 | 852_a | Import/Export | Limit 8 characters |
| Copy Location * | 2024 | 852_b | Import/Export | Limit 8 characters |
| Shelving Location * | 2027 | Import/Export | Limit 32 characters | |
| Copy Accession Date | 2009 | 852_1 | Import/Export | Limit 12 characters |
| Copy Inventory Date | 2008 | 852_1 | Import/Export | Limit 12 characters |
| Copy Number | 2021 | 852_t | Import/Export | Limit 6 characters |
| Copy Volume | 2064 | Import/Export | Limit 10 characters | |
| Copy Call Number | 2025 | 852_h | Import/Export | Limit 50 characters |
| Copy Policy Code | 2013 | Import/Export | Limit 4 characters | |
| Copy Serial # | 2441 | Import/Export | Limit 50 characters | |
| Copy Condition | 2017 | 852_1 | Import/Export | Limit 4 characters |
| Vendor | 2016 | 852_1 | Import/Export | Limit 50 characters |
| Purchase Cost | 2012 | 852_9 | Import/Export | Limit 7 characters, up to $99,999.99 |
| Replacement Cost | 2011 | Import/Export | Limit 7 characters, up to $99,999.99 | |
| Special Funds * | 2022 | Import/Export | Limit 45 characters Terminology preference field | |
| Copy Notes | 2018 | 852_x | Import/Export | Limit 1000 characters |
| Copy Alert Notes | 2019 | 852_z | Import/Export | Limit 1000 characters |
| LCCN | 2010 | 010_a | Import/Export | |
| ISBN | 2020 | 020_a | Import/Export | |
| Title Volume | 2026 | 092_v | Import/Export | |
| Primary Author | 2100 | 100_a | Import/Export | |
| Title | 2245 | 245_a | Import/Export | |
| Sub Title | 2246 | 245_b | Import/Export | |
| Statement of Responsibility | 2247 | 245_c | Import/Export | |
| Medium | 2248 | 245_h | Import/Export | |
| Edition | 2250 | 250_a | Import/Export | |
| Publisher Place | 2260 | 260_a | Import/Export | |
| Publisher | 2261 | 260_b | Import/Export | |
| Publication Year | 2262 | 260_c | Import/Export | |
| Extent | 2300 | 300_a | Import/Export | |
| Other Physical Details | 2302 | 300_b | Import/Export | |
| Dimensions | 2303 | 300_c | Import/Export | |
| Accompanying Material | 2304 | 300_e | Import/Export | |
| General Note | 2500 | 500_a | Import/Export | |
| Content Notes | 2501 | 505_a | Import/Export | |
| Summary | 2520 | 520_a | Import/Export | |
| Target Audience | 2521 | 521_a | Import/Export | |
| Review Source | 2522 | 521_b | Import/Export | |
| Lexile Value | 2757 | 521_a | Import/Export | The term Lexile will be automatically added to 521_b |
| Lexile Code | 2758 | 521_a | Import/Export | The term Lexile will be automatically added to 521_b |
| Fountas and Pinnell Value | 2761 | 521_a | Import/Export | The term Fountas and Pinnell will be automatically added to 521_b |
| Guided Reading Value | 2762 | 521_a | Import/Export | The term Guided Reading will be automatically added to 521_b |
| Study Program Name | 2750 | 526_a | Import/Export | |
| Study Program Interest Code | 2751 | 526_b | Import/Export | |
| Study Program Reading Level | 2752 | 526_c | Import/Export | |
| Study Program Point Count | 2753 | 526_x | Import/Export | |
| Study Program Test Number | 2759 | 526_z | Import/Export | |
| Study Program Have Test | 2754 | 526_9 | Import/Export | |
| Study Program Holding Code | 2755 | 526_5 | Import/Export | |
| First Subject | 2651 | 650_a | Import/Export | |
| Second Subject | 2652 | 650_a | Import/Export | |
| Third Subject | 2653 | 650_a | Import/Export | |
| Fourth Subject | 2654 | 650_a | Import/Export | |
| Fifth Subject | 2655 | 650_a | Import/Export | |
| Bibliographic Term | 2040 | 653_a | Import/Export | Separate each term by \ |
| Genre | 2442 | 655_a | Import/Export | |
| Curriculum Term | 2041 | 658_a | Import/Export | Separate each term by \ |
| Series | 2440 | 830_a | Import/Export | |
| URL Description | 2531 | 856_y | Import/Export | |
| URL | 2530 | 856_u | Import/Export | |
| Call Number | 2063 | 900_a | Import/Export | |
| Don't Show Title in Researcher | 2042 | 917_a | Import/Export | |
| Policy Code | 2052 | Import/Export | ||
| Copy Status | 2015 | Export | Limit 1 character | |
| Copy Borrowed Date | 2001 | Export | Limit 12 characters | |
| Copy Days in Circulation | 2003 | Export | ||
| Copy Check Out Count | 2002 | Export | ||
| Copy Last Modified Date | 2004 | Export | Limit 12 characters | |
| Copy Last Modified By | 2005 | Export | Limit 12 characters | |
| Copy Transit History | 2006 | Export | Limit 300 characters | |
| Copy Usage History | 2007 | Export | Limit 300 characters | |
| Accession Date | 2047 | 918_b | Export | |
| Last Use Date | 2049 | Export | ||
| Last Modified Date | 2050 | 918_c | Export | |
| Last Modified User ID | 2051 | 918_o | Export | |
| Last Validation Date | 2054 | Export | ||
| Title Sequence # | 2099 | Export | ||
| Full Title | 2240 | Export | ||
| Copy Count | 2043 | Export | ||
| Available for Check Out | 2044 | Export | ||
| Title Life-to-Date Usage Count | 2045 | Export | ||
| Checked Out To | 2055 | Export |
Patron Fields by Field Number
Patron field numbers are necessary when creating a transaction script or an import document. Use the following table below to determine which field numbers you need for your import.
Field | Header | Type | Notes |
|---|---|---|---|
| Barcode | 1000 | Import/Export | Limit 15 characters |
| First Name | 1007 | Import/Export | Limit 25 characters |
| Last Name | 1006 | Import/Export | Limit 25 characters |
| Middle Name | 1008 | Import/Export | Limit 25 characters |
| Policy | 1028 | Import/Export | Limit 4 characters Uses policy short code as specified in Preferences. |
| Status | 1026 | Import/Export | Integer indicating Status: 1=Active, 2=Card Lost, 3=Suspended, 4=Transferred, 5=Inactive, 6=Other |
| Government ID * | 1002 | Import/Export | Terminology field, often named SSN |
| Location * | 1004 | Import/Export | Terminology field, often named Homeroom |
| Sublocation * | 1005 | Import/Export | Terminology field, often named 2nd Location |
| Level * (Grade) | 1010 | Import/Export | Terminology field, often named Grade |
| Community ID * | 1001 | Import/Export | Terminology field, often named Student # |
| Site | 1050 | Import/Export | Site code as specified in Site Management |
| Optional Date * | 1048 | Import/Export | Limit 12 characters |
| Address | 1011 | Import/Export | Limit 100 characters |
| Address 2 | 88 | Import/Export | |
| City | 1012 | Import/Export | Limit 100 characters |
| State | 1013 | Import/Export | Limit 100 characters |
| Postal Code | 1014 | Import/Export | Limit 100 characters |
| Country | 1016 | Import/Export | Limit 100 characters |
| Telephone | 1017 | Import/Export | Limit 25 characters |
| Date of Birth | 1045 | Import/Export | Limit 12 characters |
| Sex | 1032 | Import/Export | Integer indicating sex or gender: Unknown=0 or U, Male=1 or M, Female=2 or F |
| Contact Notes | 1020 | Import/Export | Limit 1000 characters |
| General Notes | 1021 | Import/Export | Limit 2000 characters |
| 2nd Phone Number * | 1018 | Import/Export | Limit 25 characters Terminology field, often named Mobile or Fax |
| 1019 | Import/Export | Limit 100 characters | |
| Categories | 1025 | Import/Export | Limit 1000 characters Separate category terms with \ |
| Patron Accession Date | 1046 | Import/Export | Limit 12 characters |
| Additional Contact * | 1049 | Import/Export | Limit 100 characters |
| Username | 1052 | Import/Export | Limit 100 characters |
| Lexile Table | 1060 | Import/Export | Limit 300 characters |
| Password - Encrypted | 1063 | Import/Export | Limit 30 characters |
| Password - Plain Text | Import | ||
| Card Exp. Date | 1047 | Import/Export | Limit 12 characters |
| Lexile | 1051 | Import/Export | Limit 4 characters |
| Reading Level * | 1053 | Import/Export | Terminology preference field |
| Patron RSN | 1099 | Import/Export | |
| Patron GUID | 1200 | Import/Export | Limit 100 characters |
| Alert Notes | 1022 | Export | |
| Pending Holds Count | 1037 | Export | |
| In Stock Hold Count | 1039 | Export | |
| Reservations Count | 1038 | Export | |
| Reserves Count | 1040 | Export | |
| Total Fines | 1030 | Export | |
| Total Payments | 1031 | Export | |
| Credits | 1061 | Export | |
| Last Use Date | 1042 | Export | Limit 12 characters |
| Life to Date Usage | 1033 | Export | |
| Total Currently Out | 1034 | Export | |
| Life to Date Overdue | 1035 | Export | |
| Currently Overdue | 1036 | Export | |
| Patron Barcode | 3000 | Export | Export Patrons Fines report, only |
| Patron Name | 3001 | Export | Export Patrons Fines report, only |
| Type | 3002 | Export | Export Patrons Fines report, only |
| Description | 3003 | Export | Export Patrons Fines report, only |
| Total | 3004 | Export | Export Patrons Fines report, only |
| Balance | 3005 | Export | Export Patrons Fines report, only |
