Contents
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
Field | Header | Notes |
---|---|---|
Copy Record Number | 8031 | Export only * Import can match this field but NOT update or add it. |
Copy Barcode | 8000 | Export and Import |
Copy Site Code | 8029 | Export and Import |
Copy Location | 8024 | Export and Import |
Copy Shelving | 8027 | Export and Import |
Copy Vendor | 8016 | Export and Import |
Copy Accession Date | 8009 | Export and Import |
Copy Inventory Date | 8008 | Export and Import |
Copy Modify Date | 8004 | Export only |
Copy Policy Code | 8013 | Export and Import |
Copy Serial # | 8441 | Export and Import |
Copy Condition Code | 8017 | Export and Import |
Copy Purchase Cost | 8012 | Export and Import |
Copy Replacement Cost | 8011 | Export and Import |
Copy Status | 8015 | Export only |
Copy Notes | 8018 | Export and Import |
Copy Assigned Patron | 8028 | Export only (Barcode, if none, blank) |
Title Fields
Field | Header | Notes |
---|---|---|
Author | 8100 | Export and Import |
Budget Code | 8444 | Export and Import |
Department | 8443 | Export and Import |
District Adoption Date | 8446 | Export and Import |
Edition | 8250 | Export and Import |
Extent | 8300 | Export and Import |
Funding Source | 8022 | Export and Import |
General Notes | 8500 | Export and Import |
ISBN | 8020 | Export and Import |
Materials Notes | 8501 | Export and Import |
Number Checked Out | 8599 | Export only |
Number of Copies | 8043 | Export only |
Publication Year | 8262 | Export and Import |
Publisher | 8261 | Export and Import |
State Adoption Date | 8445 | Export and Import |
Stock # | 8442 | Export and Import |
Title | 8245 | Export and Import |
Title Created Date | 8098 | Export only |
Title ID | 8063 | Export and Import |
Title Last Modified Date | 8050 | Export only |
Title Policy | 8052 | Export and Import |
Title Record Number | 8099 | Export only |
Volume | 8026 | Export and Import |