# Ignition SQL Tags XML Schema

**URL:** <https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994>\
**Category:** Ignition\
**Created:** [August 6, 2013, 10:16pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994 "2013-08-06T22:16:59Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeffkrol](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jeffkrol/32/3339_2.png) [@jeffkrol](https://forum.inductiveautomation.com/u/jeffkrol)\
**Post date:** [August 6, 2013, 10:16pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/1 "2013-08-06T22:16:59Z")

</div>

Hello,

I’m wondering if you guys can publish the XML schema file used for importing/exporting SQL tags. I do a lot of tag creation/manipulation using Excel. This used to be very easy when the importing/exporting was done with CSV. I’m just learning the basics of XML and I’m trying to make my own schema file for this. I’m fairly close to figuring it out, but figured that maybe Induction Automation would already have such a file handy.

Thanks.

---

<div class="post-metadata">

**Author:** ![Robert.Cavagnaro](https://avatars.discourse-cdn.com/v4/letter/r/eb9ed0/32.png) [@Robert.Cavagnaro](https://forum.inductiveautomation.com/u/Robert.Cavagnaro)\
**Post date:** [December 2, 2013, 10:58pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/2 "2013-12-02T22:58:55Z")

</div>

In 7.6.4 we have brought back CSV tag import and export, however because of the more complex nature of the new alarming system alarm data does not get included in the CSV.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [December 5, 2013, 5:26pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/3 "2013-12-05T17:26:44Z")

</div>

I wrote some scripts to parse the xml file and populate an editable table and then write it back to an xml for re-import. It worked fine until I realized that I didn’t take into account the alarm structure. Once I get it working 100% ill pass it along.

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [January 10, 2014, 11:00am UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/4 "2014-01-10T11:00:51Z")

</div>

That would be realy nice. ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")  
I need to configure 400+ alarms. 🙂

---

<div class="post-metadata">

**Author:** ![zackscriven](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zackscriven/32/7213_2.png) [@zackscriven](https://forum.inductiveautomation.com/u/zackscriven)\
**Post date:** [January 11, 2014, 9:42pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/5 "2014-01-11T21:42:14Z")

</div>

[quote="jeffkrol"]Hello,

I'm wondering if you guys can publish the XML schema file used for importing/exporting SQL tags. I do a lot of tag creation/manipulation using Excel. This used to be very easy when the importing/exporting was done with CSV. I'm just learning the basics of XML and I'm trying to make my own schema file for this. I'm fairly close to figuring it out, but figured that maybe Induction Automation would already have such a file handy.

Thanks.[/quote]

> [@zxcslo](#):
>
> [quote="drewdin"]I wrote some scripts to parse the xml file and populate an editable table and then write it back to an xml for re-import. It worked fine until I realized that I didn't take into account the alarm structure. Once I get it working 100% ill pass it along.

That would be realy nice. ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")  
I need to configure 400+ alarms. 🙂[/quote]

Any breakthroughs?

---

<div class="post-metadata">

**Author:** ![zackscriven](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zackscriven/32/7213_2.png) [@zackscriven](https://forum.inductiveautomation.com/u/zackscriven)\
**Post date:** [January 27, 2014, 6:03pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/6 "2014-01-27T18:03:43Z")

</div>

I’m bringing this thread back to life. If anyone has any scripts for mass creating tags and configuring alarms it would be greatly appreciated if you could post that here.

I have a system with 1,000 tags that I would like to be able to change the opc address of all of them quickly.

---

<div class="post-metadata">

**Author:** ![john.furby](https://avatars.discourse-cdn.com/v4/letter/j/e9bcb4/32.png) [@john.furby](https://forum.inductiveautomation.com/u/john.furby)\
**Post date:** [May 2, 2018, 7:17pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/7 "2018-05-02T19:17:48Z")

</div>

So no schema was ever released? Wouldnt this be very easy for Inductive to do?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [May 2, 2018, 8:01pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/8 "2018-05-02T20:01:12Z")

</div>

We don’t have a schema to release or we would.

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [May 2, 2018, 8:13pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/9 "2018-05-02T20:13:28Z")

</div>

This is really easy to do with a CSV or in excel.  
In excel look into the FileSystemObject  
Then you can just loop through a range like

```auto
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Dim oFile As Object
Set oFile = fso.CreateTextFile('c:\XMLImport.xml')
oFile.writeline "<Tags>"
for x in range
      oFile.writeline "<tag name=>"
oFile.writeline "</Tags>"

```

I can’t share our actual code since it is NDA.  
But others might be able to expound on it further.

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [May 2, 2018, 8:13pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/10 "2018-05-02T20:13:55Z")

</div>

getting familiar with the add and edit tag functions I find is much better than dealing with csv or xml files. the sky is the limit as far as adding tags with these methods

---

<div class="post-metadata">

**Author:** ![john.furby](https://avatars.discourse-cdn.com/v4/letter/j/e9bcb4/32.png) [@john.furby](https://forum.inductiveautomation.com/u/john.furby)\
**Post date:** [May 2, 2018, 8:17pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/11 "2018-05-02T20:17:24Z")

</div>

Fair. Is there some software you could recommend to edit XMLs on a massive scale? I’m trying to change UDT Parameters and alarm priorities on a massive scale.

Maynard, Thanks for the pointer. I’ve thought about VBA to make these kinds of changes but I was hoping this was a solved problem. I was hoping to avoid the hours to make that tool just so I can make a simple edit in a database mode.

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [May 2, 2018, 8:19pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/12 "2018-05-02T20:19:11Z")

</div>

If it is a pretty standard search replace you are doing, like changing an OPC Server name in the path  
I always use Notepad++ for that.  
It can do RegEx replacements as well as straight find/replace on very large files and multiple files.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [May 2, 2018, 8:26pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/13 "2018-05-02T20:26:58Z")

</div>

I’m not aware of any (doesn’t mean there are none).

A lot of customers do what @diat150 suggests and they lean heavily on scripting within Ignition to edit/create/delete tags.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 2, 2018, 8:34pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-tags-xml-schema/6994/14 "2018-05-02T20:34:30Z")

</div>

awk and sed are my friends. 😁