If the import file is recognized, Alexandria will automatically sort, organize, and match the information to the correct, specified fields. If the import file is missing a header, it will not be recognized. The relationships between fields and attributes of different names and types may not match and have to be mapped. Alexandria will require you to set your patron and item field mapping in order to proceed.
Use the Field Mapping dialog to specify where data from the import file belongs in Alexandria; in other words, match data in the import file to specific Alexandria fields. Data from the import file is shown on the left-hand of the window while Alexandria field names are shown on the right-hand side.
Data is imported in sequential order; use the white up and down arrows to correctly align the fields of the import file. Click on a field to exclude it from the import; clicking on fields will toggle them between a green and a red . See Item Import Fields by Field Number for more information on the fields that can be imported.
When you've finished matching Alexandria fields to the information in your file, click the Set button.
Tip
If you have a patron with a combined first and last name (one that has not been separated by tab delimitation), use this field to split the name into First and Last Name during import.
Limit 12 characters Terminology field, often named Graduation Date
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
Email
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 Terminology field, often named Parent/Guardian
Username
1052
Limit 100 characters
Lexile Table
1060
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 - Encrypted
1063
Limit 30 characters This option is used when importing a password that is already encrypted MD5