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

« Previous Version 3 Next »

Textbook Tracker automatically recognizes file headers created by other COMPanion software to correctly import files without you knowing anything about the contents of the data. However, when importing data from outside sources, relationships between fields may not be recognized, so it's important that you fine-tune the mapping before running the import. Use the Field Mapping dialog to specify where to import the data by mapping the fields in your database to the fields in the source data you’re importing. Data from the import file is shown on the left of the window, and Textbook Tracker field names are shown on the right.

Field Mapping is required for all tab-delimited import files that do not have a header.

Data is imported in sequential order. Select a field, then use the white arrows to move it up and down the list. Click the icon individual field to toggle between a check mark and an X, or click the icons in the controls below to set all to include or all to exclude. 

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

This field will be included in your import.

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