Is there a way to import tags from an Excel file?

Ignition
1

I am currently working on a recipe project, where a customer is wanting to see who makes changes to a recipe, which is easy to do with the recipe software in Ignition with a Recipe Editor and a ChangeLog. The customer has 9 different recipes with almost a hundred tags, and each tag value is different from the other recipes. Is there a way to import the tags/values from an excel file?

2

You would need to be familiar with VBScript and writing to files.
We use Excel to import tag dumps from wonderware, we parse the sheets and fill in the variables for the XML tag import.

3

Yes, there is a way. You would need to use the Apache POI libraries, and read the file in through Python. Do you have an example file?

4

Note that you can also import CSV directly, and Excel can export to CSV. You’ll just have to figure out how to transform your Excel to the right columns and what delimitors to use.

You can get an example CSV by exporting existing tags and choosing the *.csv export extension (default is *.xml).

5

.CSV is nice, but doesn’t support alarm parameters.

2 Likes
6

Exactly. That’s what is a pain to set up manually.