Mass creation of Tags and Alarms in xml

ignition79
database
#1

Is there any easy way to create and import a large number of tags and alarms, say 100.000, into Ignition?.

1 Like

#2

It’s more efficient if your tags are well structured with UDT. You import first UDT definitions with an XML file and then tags definitions with another XML file.

0 Likes

#3

I can create UDTs, different types of tags, Alarms and export it as template.xml file. I have a list of 100,000+ UDT instances, tags and Alarms to be created in an Excel file tags_alarms.xlsx. I would like to use the tags_alarms.xlsx file to auto generate a final.xml file based upon the template.xml file, which can be directly imported into Ignition. Is it possible or should i have to edit the xml file manually?.

1 Like

#4

You can store your instance tags data definition in an SQL database (mysql or another one) and generate xml file with an Ignition script which read the data from the database and print in a text file the xml instance definition.

You can export tag example to file to learn about tag xml format and this is described in ignition online help.

If you don’t want a database, export excel to csv and write a script in Ignition to read csv and generate an xml file.
Another way is not generating an xml file to import but using ignition edit tag function to create the tag.

Ignition xml format for tag, udt and intance will enable to configure all what you need.

0 Likes

#5

I searched the Ignition document which may explain in detail with some example about converting a csv file of tags and Alarms into an xml file, which can be directly imported into Ignition. This is the one i found but not very helpful for the above requirement. I could not find in IA university either.

Editing xml tags manually is time consuming, error prone and not the best way to engineer a SCADA project.

https://docs.inductiveautomation.com/display/DOC79/Importing+and+Exporting+Tags

I thought, with edit tag we can only edit an existing tag. I am NOT sure how to create a tag with edit tag function. If you mean, copy, paste and edit, this is very laborious for 100,000+ tags.

1 Like

#6

But where are the 100k tags coming from? A previous ignition export? An export from another SCADA system? This will help understand the context of the original question.

0 Likes

#7

An export from another SCADA system. I am trying to migrate from another SCADA to Ignition. This is a new project starting from scratch.

1 Like

#8

what I have done successfully in the past is this: Create a global script in Ignition, import the csv with Python, iterate through the file and use the ‘add tag’ script system function to create new Ignition tags. I suggest editing the raw csv file before to make the Ignition script easier to use. For example, I’ll create a new column with a 1 or 0 and filter the tag creation for those csv rows. This will allow me to dial in the code befor running it for all rows. Expect to create and destroy all tags multiple times until you are satisfied and expect the code to run for 10 to 30 min because creating the tags is process intensive. I like using the same tag structure as the original system because it makes finding tags easier, also use the ignition tags ‘documentation’ attribute to store important important information about the tag such as the original systems tag name and folder location.

0 Likes

#9

Doesn’t sound like an easy way to accomplish. This is not so complicated in other SCADA systems. Even WW Archestra which is using an object database has explained the procedure very clearly with csv file and it works perfectly. May be internally it converts into an xml file. Configuring tags, Alarms, history and importing into the SCADA db is the first step in creating a SCADA project. Almost every SCADA system explains the procedure to mass import tags and Alarms very clearly. I wonder, why Ignition document ignored this very important point !!.

A person coming from FTView, wincc, WW, Wizcon etc will be very badly put off by this need to learn Jython scripting to import tags and Alarms.

1 Like

#10

The XML format for importing tags in Ignition is very simple.
With either a CSV or an Excel file, you can just loop down the rows creating the required XML.
We import entire wonderware tag databases to Ignition in under 10 seconds using this method.

  1. Create some example tags in Ignition, export them to XML.
  2. Model your Excel/CSV file to the fields you want in the tags.
  3. Code a simple file writing loop to create the tags.xml file
  4. Go into Designer, Right Click, Import tags.xml
2 Likes

#11

I have to figure out step 3. Otherwise, step 1,2, 4 sounds logical and humane. This is what i expected.

Scripting is normally used for some special customization in any SCADA. Over scripting may kill the project. Expecting a beginner to write Jython scripts to import tags and alarms even before creating a basic project, sounds cruel and inhumane to say the least. This will create a very bad allergy in the minds of many SI’s towards Ignition

1 Like

#12

This is ridiculous. Ignition provides GUI tools to perform all of the configuration tasks one needs to make use of the platform. But building big, complex projects with just a GUI takes much time, regardless of which platform is involved. That Ignition’s development can be scripted at all to automate many of the tasks is a big win. Since a system integrator that can’t write code for integration itself is unworthy of the name, writing code to automate development tasks is not a big ask.

1 Like

#13

Why the documentation is not explaining the procedure (converting csv to xml) to mass import tags and alarms?.

The first source of information for any SI is the user manual. May be in the next version, IA can update this procedure.

1 Like

#14

Because there’s no procedure. It’s just something that coders who understand both CSV and XML will be able to do.

0 Likes

#15

There may be several workarounds and tricks. But tags and alarms db is the heart of a project. The official procedure will eliminate any inconsistencies, malfunctioning and surprises which may pop up at a later stage.

Most of the functionalities, every SCADA programmer knows. But still, the document and IA university takes efforts to explain them in detail. This is because of the responsibility of a product manufacturer. Importing a flawless Tags and Alarm database is the first step in creating any SCADA project. I wonder, how it was overlooked in the user manual.

Do you think, an SI who doesn’t even know how to write some simple Jython scripts and automate tasks is NOT eligible to use Ignition?.

1 Like

#16

To be fair, i will take your point in the right spirit. I agree that, it’s not possible to engineer a decent Ignition project without Jython scripting skills. But writing Jython script to import 100,000+ tags and alarms is NOT acceptable for me. This will be a disaster. I will never do that. There must be better ways to convert a csv file into Ignition compatible xml file.

1 Like

#17

Its impossible if you dont try. The existing Ignition documentation provides everything an SI needs to accomplish the conversion. Once you dive into and succeed then this becomes an imporant part of your toolbag. A toolbag that gives you an advantage amongst your peers.

3 Likes

#18

ok. I wil try and let you know. Thanks :slight_smile:

1 Like

#19

Script for importing 100 000 tags or script for importing 10 tags will be almost, if not the same…

3 Likes

#20

Compared to the top 3 SCADA vendors, one key thing missing in Ignition camp is, the support base has not spread beyond the primary IA domain. It’s easy to find tools, tips and tricks for WW, FTV, WinCC in the internet. We can find a lot of tutorials, code snippets and project ideas from their user base and freelancers in social media. I am sure, some of them are hired by the respective vendor’s marketing division.

There are excellent freelance tutors and programmers with a huge number of followers in Youtube, Udemy and social media. IA can hire few of them to spread the Ignition ecosystem.

1 Like