Upload Files | Data mapping templates#

Note

Requires read/modify csv-mappings permissions. See EclecticIQ Intelligence Center permissions.

Data mapping templates allow you to create mappings for data formats that you can ingest through manual uploads.

Important

Currently, only mappings for CSV files are supported.

To create a data mapping template:

Go to Data configuration > Data mapping templates.
Select +.
From the left sidebar, select Data configuration > Data mapping templates.
In the top right corner, select + Create template.
Enter a Name.
(Optional) Enter a Description.
Select Continue.
Choose a Delimiter by selecting the checkbox of the character that delimits values in the files you want to upload, or select Other and enter the delimiting character in the field that appears.
(Optional) If the files you want to upload use one, enter the Quote character that encloses fields which include special characters to escape.
(Optional) If the files you want to upload have lines without data that begin with #, toggle Non-date lines on.
(Optional) If the files you want to upload have headers as the entries in the first line, toggle Headers on.
Select Continue.
For each column in the files you want to upload, select Add mapping and, from the drop-down menu under Matching fields in EclecticIQ, select the EclecticIQ Intelligence Center (EIQ IC) field(s) the data in that column should be mapped to. If you want to add more fields later, select the + Add field link for that column.

Sub-dividing column fields

If you selected multiple fields from the Matching fields in EclecticIQ drop-down menu, toggle Split values in column on if fields in that column in the CSV files actually contain multiple values that you would like to map to different fields. From the drop-down list that appears if the switch is on, select the delimiting character used in the fields of that column.
Not selecting a delimiting character when Split values in column is on will result in the value of the fields of that column being copied to all the fields you selected under Matching fields in EclecticIQ.
Select Continue.
On the Configure screen, you will see drop-down menus for all the EIQ IC field you haven’t mapped a column to. You can select default values for these fields or choose not to leave these field empty by selecting None.
This screen also allows you to review the fields you have mapped columns to, so you can go back and correct them if you spot any mistakes.
Once all mappings are correct, select Create template to save the template

After creating the template you can select it when uploading CSV files.

Invalid mappings from 3.1.x and earlier#

In release 3.1.x and earlier, it was possible to create Advanced CSV incoming feeds that had invalid mappings from CSV fields to EclecticIQ fields.

When upgrading to 3.2.0 and later, these mappings are automatically converted to Upload Files | Data mapping templates.

In Data configuration > Data mapping templates, templates that contain invalid mappings are shown with a warning icon (⚠️):

Data mapping templates now show a warning icon (⚠️) for invalid templates.#

When you edit the template, it shows a warning icon for fields that contain invalid mappings, and does not allow you to save the template until the field mapping is corrected: