Support files
Open a support ticket
Welcome!
Introduction
Help files
Basic functions
Cases, persons and items
Location setup
System customization
Chain-of-custody
PDA mobile tracking
System tools
User administration
Miscellaneous features
Technical documents
General technical info
Installation guides
Hardware
Software version guide
Additional info
News and articles
Data import
When Tracker Products support staff is presented with the task of importing a client's data (as part of an original purchase agreement or additional compensation), the following conditions must be met prior to beginning the import:
Important information: Tracker essentially has four primary data tables... case, person, item and custody tables. Case is the primary table and all other tables relate back to this primary table except the custody table which relates to the item table.
1. Case Table: one to many relationship with person's and item's.
2. Person Table: many to one relationship with a record in case table.
3. Item Table: many to one relationship with a record in the case table.
4. Chain of Custody Table: many to one relationship with a record in the item table.We have to fit all data into this structure. The more you define how data will fit into this structure the easier the import will be.
- All data must be provided in one of the following formats: .txt, .csv, access data or excel.
Note: Any file that is more than 65,000 line items or 100mb in size needs to be submitted via a database file like MS Access (.mdb or .accdb) or MS SQL (.bak).
- Please provide a data definition file. Define all documents and tables as well as the data that resides within them.
Note: This is especially important when data is in the form of a number and that number has a text definition. For example, 1=Evidence, 2=Found Property, 3=XXX. We need to know if a field is part of a drop down with assigned values.
- If more than one document, table or file is provided, please define their relationship to one another.
- Each column of data must be clearly labeled. If providing a .txt or .csv file, columns must be part of the actual data file.
- Please provide clear information about where the provided data should be placed in the Tracker Products system. This includes the case, item, person and chain-of-custody architecture. Please talk with your rep if you need help with this.
- At a minimum please provide the following data...
(Item Data) Case Number, Item Number, Item Category, Item Description, Item Status (Checked In or Out), Item Disposition (Disposed or Not), Item Storage Location and any existing barcode formats.
(Case Data) Case number
(Person Data) Name and type of person
