The Support Center has moved! see https://support.goalexandria.com/

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

If the import file is recognized, Textbook Tracker will automatically sort, organize, and match the information to the correct, specified fields. Relationships between fields and attributes of different names and types may not match and will have to be mapped. For example, if the import file is missing a header, it will not be recognized.

To improve the accuracy of your import, label the columns in your import file to match Textbook Tracker fields. When importing data from outside sources, Textbook Tracker will map the fields as correctly as possible. Because relationships between fields and may not be recognized, it's important that you fine-tune the mapping before running the import. In the Field Mapping dialog, specify where to import the data by mapping the fields in your database to the fields in the source data you’re importing.

In the Field Mapping dialog, data from the import file is shown on the left-hand of the window while Textbook Tracker field names are shown on the right-hand side.

Data is imported in sequential order. Select a field, then use these controls to organize it. Click the check mark in a field to exclude it from the import.

Move the field up or down to correctly align the fields in the import file.

This field will be included in your import. Click this icon in the field to exclude it from the import, or

This field will be excluded from your import.

Restore field mapping settings to the default.


When you've finished matching Textbook Tracker fields to the information in your file, click Set.


Copy Fields

FieldHeaderNotes
Copy Record Number8031

Export only

 * Import can match this field but NOT update or add it.

Copy Barcode8000Export and Import
Copy Site Code8029Export and Import
Copy Location8024Export and Import
Copy Shelving8027Export and Import
Copy Vendor8016Export and Import
Copy Accession Date8009Export and Import
Copy Inventory Date8008Export and Import
Copy Modify Date8004Export only
Copy Policy Code8013Export and Import
Copy Serial #8441Export and Import
Copy Condition Code8017Export and Import
Copy Purchase Cost8012Export and Import
Copy Replacement Cost8011Export and Import
Copy Status8015Export only
Copy Notes8018Export and Import
Copy Assigned Patron8028Export only (Barcode, if none, blank)

Title Fields

FieldHeaderNotes
Author8100Export and Import
Budget Code8444Export and Import
Department8443Export and Import
District Adoption Date8446Export and Import
Edition8250Export and Import
Extent8300Export and Import
Funding Source8022

Export and Import

General Notes8500Export and Import
ISBN8020Export and Import
Materials Notes8501Export and Import
Number Checked Out8599Export only
Number of Copies8043Export only
Publication Year8262Export and Import
Publisher8261Export and Import
State Adoption Date8445Export and Import
Stock #8442Export and Import
Title8245Export and Import
Title Created Date8098Export only
Title ID8063Export and Import
Title Last Modified Date8050Export only
Title Policy8052Export and Import
Title Record Number8099

Export only
 * Import can match this field but NOT update or add it.

Volume8026Export and Import