Once you've created a data source, you can add a large amount of tags more easily by preparing a CSV file and importing that into your data source. For long lists of tags, this method is faster than adding each tag manually through the IXON Cloud interface.

Additionally, you can export the tags of an existing data source and import it at another data source or even at another edge gateway to easily copy them over.

• Copy tags from one data source to another
• Prepare a CSV file to import a large amount of tags

Copy tags from one data source to another

If you have a list of tags that you wish to copy over to another data source, simply export the tags and import them at the other data source.

1. Go to the original data source and open the list of tags.
2. In the top right, click Export to CSV-file.
   • You can also make a selection of tags you wish to export before pressing this button. If no selection is made, all tags will be exported.
3. Go to the new data source and then to the tags.
4. In the top right, click Import from CSV-file and select your CSV file.

Prepare a CSV file to import a large amount of tags

The structure of the CSV file need to be correct for the import function to work properly. It's easiest if you first create a template so you have an example of what the file and exact contents need to look like.

1. Add a single tag to your data source.
2. In the top right, click Export to CSV-file.
3. Edit the CSV file in any text editor and add all the tags you wish to add.
   • The structure and content of the CSV file is explained in detail below, in chapter CSV file structure.
4. Once you've added all the tags, save the file.
   • If you used Microsoft Excel to edit the CSV file, it may not be ready yet. 
   • Make sure that the used delimiter is supported by opening the edited CSV file in a plain text editor, like Notepad, and comparing it with the information in the below support article.
     • Which delimiters are supported in a CSV import and how do I change it?
5. Go back to the tags of your data source in IXON Cloud.
6. In the top right, click Import from CSV-file and select your CSV file.

CSV file structure

The structure of the CSV file needs to be correct for the import function to work properly. The headers (first row) of column 1-9 should look like this:

The headers of column 10-12, only applicable when setting "log event" to "trigger", should look like this:

Each column represents a different setting and all are explained below. You can easily navigate to the desired section by pressing the corresponding header above.

Identifier

The identifier ensures that every data source and variable in the your company remains unique, even when you give multiple variables the same name. An identifier only has to be unique for a certain data-source. Two different data-sources in the same company can have the same identifiers and can therefore import the same CSV-file.

Address

Every tag needs to be linked to a variable. You do this by entering the address of the concerning variable. The address is fully explained in the "Import variables" article. Below you will find several examples.

Name

You can name the tags freely. It is advised to enter a very brief description of the variable (i.e. weight, temperature zone #1, emergency stop section B5).

Logging interval

This setting's function depends on what you set as the type of log event:

• Log on interval
• Log on change or on trigger

Log on interval

Log on interval means the variable is logged every X seconds.

This setting determines the logging interval, which can be configured anywhere between 100ms - 1h, using milliseconds, seconds, minutes, or hour. Examples are listed in the table below.

Log on change or on trigger

Log on change means the variable is logged when its value changes, while log on trigger means the variable is logged when a custom trigger happens (view "Configure triggers" for more info).

This setting now determines the maximum amount of logged values per hour. If you have this set to "up to 100 values per hour" and the variable changes/triggers 101 times in an hour, then the 101th time won't be logged. Don't worry, the logging will continue when the next hour begins. All available options are listed in the table below.

Retention policy

The data storage duration is indicated in weeks with four options to choose from. Data older then the retention policy will be deleted from the IXON Cloud completely. The available options are:

Edge aggregator

The edge aggregator is called Formula in the IXON Cloud. To have reliable and accurate data the IXrouter is constantly requesting the variables' value. The edge aggregator processes this data between logging intervals.

On change expiry

When logging on change, you may want to log the value every hour when the value doesn't change as well. If this is the case you have to add 1h to this column, otherwise you can leave the column empty.

Log event

This setting, together with the "logging interval"-setting, determines when the variable will be logged. All options are listed in the table below.

Trigger address

Here you enter the address corresponding with the variable you'd like to use as trigger. For example, when using Modbus and the variable is a holding register with address 7, you enter a 7 here. If you're unsure how you need to format the address, you can best add a single tag at your data source and export it so you have an example.

Trigger condition

A trigger happens if the outcome of <variable><condition><threshold> is true. For example, if variable "Temperature" is "greater than or equal to" "60" degrees celsius. The available options for the condition are:

Trigger threshold

The threshold is the last part of the equation that determines if a trigger happens or not. The available options depend on the variable's data type. For example, if the variable's data type is boolean, then you can choose either TRUE or FALSE.