Setting Up CSV Templates
You may have a current system that holds your customers, products, equipment, purchase orders, sites and contacts. Most systems allow you to extract into a CSV file, which can be saved into Excel.
Instead of using our default CSV templates, you can now map the fields from the CSV template your current system produces to Clik Service and use them again any time you want. This will stop copy/pasting into the Clik Service CSV files and save you some time.
This article will show you how to set this up.
To view, edit or create a predefined CSV import click on Tools > CSV Import > Setup Predefined Imports.
To create a new mapping configuration, click ‘New’, enter a name in the ‘Name’ box and select the type of CSV from the ‘Type’ box.
You will notice that this populates the “User Column” and the “Clik Column”, with the default CSV headers for the selected import type as well as any user-defined fields assigned to that type.
- The User Column is where we will eventually see the headers from your custom CSV, headers that are different from the standard Clik headers.
- The Clik Column shows the standard Clik CSV headers for the selected type.
- The Converters column is where we can view, edit and create converters for our imported data. For example, our CSV might have “yep” or “nope” but we need to enter “True” or “False”, we can create a rule to convert these values when importing.
Some rows might display icons next to the headers:
- The plus icon means it is a duplicate field.
- The link icon is a linked field.
- The warning icon means are using more than one linked field. The import will work but obviously, both fields aren’t required.
If you hover the mouse of any of these cells you will see a tooltip explaining what each icon means.
Currently, the “User Columns” and the “Clik Columns” are both showing the default Clik columns. To load the columns from your own CSV, click on ‘Read CSV Headers’.
Click ‘Yes’ to continue and select your CSV file. Find your CSV file and click ‘Open’ to receive the headers in that CSV.
The ‘User Column’ will now show all of your headers and the “Clik Column” will show headers where you are using the same header title.
To match your headers to the Clik headers click on an empty cell in the “Clik Column” and select the Clik header that corresponds to your user header.
The drop-down will show you all available Clik headers, including icons to indicate if they are links or duplicate headers.
Headers that have been matched show a green circle, headers that haven’t been matched yet show an empty circle.
Continue matching your headers until they are all done. Your CSV needs to have at least one link header if the Clik CSV type includes a link header.
If some of your data appears in a different format from the Clik import format, you can create a converter to correct this.
To do this click in the cell in the “Converters” column for the row that contains this data.
For example, I will click on the “Converters” cell for my user field “(User Field) Is Fire Alarm on?”
Now you need to select ‘New’.
Type the current record in your CSV. In this case, it’s “Yes” and “No” under the user field ‘is fire alarm on’.
Then select the value in Clik. In this case, because it’s a yes/no value it will be “True” and “False”.
You will see “Yes” anywhere you have created converters.
Once you have completed matching your headers and created any required converters click ‘OK’ to close and save the CSV mapping.
To import a CSV that contains the headers you created in your mapping you will be able to find your mapping listed under Tools > CSV Import > Imports.
This will open the usual CSV import window with your mapping selected.
CSV Mapping was added in update v4.331, make sure your software is running the latest version to ensure you have the new improvements and features.