The Tracker Importer is a powerful tool that does more than just read a CSV data file and create new trackers. The Tracker Importer also acts as a way to update, edit and even delete trackers just by uploading a single CSV file.
This allows people with many trackers to effectively manage their trackers externally with tools like Microsoft Excel, LibreOffice Calc or even Notepad.
The import process consists of three steps:
The Tracker Importer is quite sensitive to the format of the CSV file. For this reason it is a good idea to download the demo template CSV file and open it using a text editor like Notepad to see how the data must be formatted.
The format itself is a pretty standard 'CSV' (Comma-separated Values) format which consists of a single header row followed by multiple data rows. Each individual data item (including the header column names) should be surrounded by double-quotation marks (as can be seen in the demo template file). Within a row, each data item should be seperated by a single comma outside of the quotation marks (eg: "some data 1", "some data 2", "some data 3"). Each data record or row must be on its own line of the text file.
The following table details all the possible columns a CSV data file can have and their allowable values
|CSV field name||Description||Permitted Values||Mandatory?||Value if omitted|
|import_mode||The specific operation to perform on the given tracker data row.||[CREATE|UPDATE|DELETE]||NO||CREATE|
|tracker_api_key||A unique ID which identifies a single tracker. These are generated on tracker creation. This must be supplied to perform either a UDPDATE or DELETE operation.||A valid tracker 'api key' (eg: "f2t12345abcde")||NOT for CREATE operations||N/A|
|tracker_label||A friendly name to help identify the tracker||Any text upto 40 characters long||YES||N/A|
|tracker_group||The name of the group to which this tracker should belong||Any text upto 25 characters long||NO||(empty)|
|tracker_url||The web page URL from which changes will be tracked.||A valid URL with upto 500 characters||YES||N/A|
|tracker_source_content||The type of content being tracked.||[1|2|3]
|NO||1 (Web Page)|
|tracker_css_selector||The CSS Selector used to extract content from the tracker_url web page||A valid CSS Selector upto 500 characters||NO||"document"|
|tracker_data_type||The format the tracker content should be converted to.||[text|number]||NO||text|
|tracker_email_list||A single email address or a comma-delimited list of email addresses.Upto 400 characters||[text|number]||NO||text|
|tracker_state||Used to specify which state the tracker should be set to.||[running|suspended]||NO||running|
Currently the Importer does not support all possible tracker options. If you require the Importer to support more tracker features, please get in touch and we will update the system.