The Support Center has moved!! See the new website https://support.goalexandria.com/  

Alexandria

Space shortcuts

Page tree


Versions Compared

Old Version 35

changes.mady.by.user Ashley

Saved on

compared with

New Version Current

changes.mady.by.user Bethany Brown

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Content Layer
id750601818
Copy
Content Column
tabbed-blockstabs
id750601822
ItemFieldsbyNumber

Content Block
nameItem Fields
id751037530
Info

This page has been moved over to https://support.goalexandria.com/items/item-field-mapping/


Item Fields by Field Number

Multiexcerpt
MultiExcerptName
Advanced Tables - Table Plus
highlightColor#f1f6fc
enableHeadingAttributesfalse
FieldHeaderMARCTypeNotes
Copy Barcode2000852_pImport/ExportLimit 15 characters
Copy Site Code2023852_aImport/ExportLimit 8 characters
Copy Location *2024852_bImport/Export

Limit 8 characters
Terminology preference field

Shelving Location *2027
Import/Export

Limit 32 characters
Terminology preference field

Copy Accession Date2009852_1Import/ExportLimit 12 characters
Copy Inventory Date2008852_1Import/ExportLimit 12 characters
Copy
Number		2021852_tImport/ExportLimit 6 characters
Volume2064
Import/ExportLimit
10
30 characters
Copy Call Number2025852_hImport/ExportLimit 50 characters
Copy Policy Code2013
Import/Export

Limit 4 characters

Copy Serial #2441
Import/ExportLimit 50 characters
Copy Condition2017852_1Import/ExportLimit 4 characters
Vendor2016852_1Import/ExportLimit 50 characters
Purchase Cost2012852_9Import/Export

Limit 7 characters, up to $99,999.99
Must include decimal (5.00 NOT 5)

Replacement Cost2011
Import/Export

Limit 7 characters, up to $99,999.99
Must include decimal (5.00 NOT 5)

Special Funds *
2022
Import/ExportLimit 45 characters
Terminology preference field
Copy Notes2018852_xImport/ExportLimit 1000 characters
Copy Alert Notes2019852_zImport/ExportLimit 1000 characters
LCCN2010010_aImport/Export
ISBN2020020_aImport/Export
Title Volume2026092_vImport/ExportLimit 30 characters
Primary Author2100100_aImport/Export
Title2245245_aImport/Export
Sub Title2246245_bImport/Export
Statement of Responsibility2247245_cImport/Export
Medium2248245_hImport/Export
Edition2250250_aImport/Export
Publisher Place2260260_aImport/Export
Publisher2261260_bImport/Export
Publication Year2262260_cImport/Export
Extent2300300_aImport/Export
Other Physical Details2302300_bImport/Export
Dimensions2303300_cImport/Export
Accompanying Material2304300_eImport/Export
General Note2500500_aImport/Export
Content Notes2501505_aImport/Export
Awards Note2502586_aImport/Export
Summary2520520_aImport/Export
Target Audience2521521_aImport/Export
Review Source2522521_bImport/Export
Lexile Value2757521_aImport/ExportThe term Lexile will be automatically added to 521_b
Lexile Code2758521_aImport/ExportThe term Lexile will be automatically added to 521_b
Fountas and Pinnell Value2761521_aImport/ExportThe term Fountas and Pinnell will be automatically added to 521_b
Guided Reading Value2762521_aImport/ExportThe term Guided Reading will be automatically added to 521_b
Study Program Name2750526_aImport/Export


Study Program Interest Code2751526_bImport/Export
Study Program Reading Level2752526_cImport/Export
Study Program Point Count2753526_xImport/Export
Study Program Test Number2759526_zImport/Export
Study Program Have Test2754526_9Import/Export
Study Program Holding Code2755526_5Import/Export
First Subject2651

650_a
650_x
650_y
650_z

Import/Export
Second Subject2652

650_a
650_x
650_y
650_z

Import/Export
Third Subject2653

650_a
650_x
650_y
650_z

Import/Export
Fourth Subject2654

650_a
650_x
650_y
650_z

Import/Export
Fifth Subject2655

650_a
650_x
650_y
650_z

Import/Export
Bibliographic Term2040653_aImport/ExportSeparate each term by \
Genre2442655_aImport/Export
Curriculum Term2041658_aImport/ExportSeparate each term by \
Series2440830_aImport/Export
URL Description2531856_yImport/Export
URL2530856_uImport/Export
Call Number2063900_aImport/Export
Don't Show Title in Researcher2042917_aImport/Export
Policy Code2052
Import/Export
Copy Status2015
ExportLimit 1 character
Copy Borrowed Date2001
ExportLimit 12 characters
Copy Days in Circulation2003
Export
Copy Check Out Count2002
Export
Copy Last Modified Date2004
ExportLimit 12 characters
Copy Last Modified By2005
ExportLimit 12 characters
Copy Transit History2006
ExportLimit 300 characters
Copy Usage History2007
ExportLimit
300
600 characters
Accession Date2047918_bExport
Last Use Date2049
Export
Last Modified Date2050918_cExport
Last Modified User ID2051918_oExport
Last Validation Date2054
Export
Title Sequence #2099Export

Full Title2240
Export
Copy Count2043
Export
Available for Check Out2044
Export
Title Life-to-Date Usage Count2045
Export
Checked Out To2055
Export Content Block
namePatron Fields
id83664375

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. 

1030
Multiexcerpt
MultiExcerptNamePatronFields
Advanced Tables - Table Plus
highlightColor#f1f6fc
enableHeadingAttributesfalse

Field

Header

Type

Notes

Barcode1000Import/ExportLimit 15 characters
First Name1007Import/ExportLimit 25 characters
Last Name1006Import/ExportLimit 25 characters
Middle Name1008Import/ExportLimit 25 characters
Policy1028Import/ExportLimit 4 characters
Uses policy short code as specified in Preferences.
Status1026Import/ExportInteger indicating Status: 1=Active, 2=Card Lost,
3=Suspended, 4=Transferred, 5=Inactive, 6=Other
Government ID * 1002Import/ExportTerminology field, often named SSN
Location * 1004Import/ExportTerminology field, often named Homeroom
Sublocation *1005Import/ExportTerminology field, often named 2nd Location
Level * (Grade)1010Import/ExportTerminology field, often named Grade
Community ID * 1001Import/ExportTerminology field, often named Student #
Site1050Import/ExportSite code as specified in Site Management
Optional Date * 1048Import/Export

Limit 12 characters
Terminology field, often named Graduation Date

Address1011Import/ExportLimit 100 characters
Address 288Import/Export
City1012Import/ExportLimit 100 characters
State1013Import/ExportLimit 100 characters
Postal Code1014Import/ExportLimit 100 characters
Country1016Import/ExportLimit 100 characters
Telephone1017Import/ExportLimit 25 characters
Date of Birth1045Import/ExportLimit 12 characters
Sex1032Import/ExportInteger indicating sex or gender:
Unknown=0 or U, Male=1 or M, Female=2 or F
Contact Notes1020Import/ExportLimit 1000 characters
General Notes1021Import/ExportLimit 2000 characters
2nd Phone Number * 1018Import/ExportLimit 25 characters
Terminology field, often named Mobile or Fax
Email1019Import/ExportLimit 100 characters
Categories1025Import/ExportLimit 1000 characters
Separate category terms with \
Patron Accession Date1046Import/ExportLimit 12 characters
Additional Contact * 1049Import/Export

Limit 100 characters
Terminology field, often named Parent/Guardian

Username1052Import/ExportLimit 100 characters
Lexile Table1060Import/Export

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 - Encrypted1063Import/Export

Limit 30 characters
This option is used when importing a password that is already encrypted MD5

Password - Plain TextImport
Card Exp. Date1047Import/ExportLimit 12 characters
Lexile1051Import/ExportLimit 4 characters
Reading Level *1053Import/ExportTerminology preference field
Patron RSN1099Import/Export
Patron GUID1200Import/ExportLimit 100 characters
Alert Notes1022ExportPending Holds Count1037ExportIn Stock Hold Count1039ExportReservations Count1038ExportReserves Count1040ExportTotal Fines

Export
Total Payments1031ExportCredits1061ExportLast Use Date1042ExportLimit 12 charactersLife to Date Usage1033ExportTotal Currently Out1034ExportLife to Date Overdue1035ExportCurrently Overdue1036ExportPatron Barcode3000ExportExport Patrons Fines report, onlyPatron Name3001ExportExport Patrons Fines report, onlyType3002ExportExport Patrons Fines report, onlyDescription3003ExportExport Patrons Fines report, onlyTotal3004ExportExport Patrons Fines report, onlyBalance3005ExportExport Patrons Fines report, only

© 2023 COMPanion® Corporation | All Rights Reserved | Terms of Service & Privacy Policy