# SQL Tags Browser

**URL:** <https://forum.inductiveautomation.com/t/sql-tags-browser/2145>\
**Category:** Ignition\
**Created:** [August 20, 2010, 4:07pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145 "2010-08-20T16:07:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ciands](https://avatars.discourse-cdn.com/v4/letter/c/eb9ed0/32.png) [@Ciands](https://forum.inductiveautomation.com/u/Ciands)\
**Post date:** [August 20, 2010, 4:07pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/1 "2010-08-20T16:07:20Z")

</div>

Does the SQL tags import utility import from a CSV file from RSLOGIX 5000.  
I tried and Ignition gave me a error

java.lang.Exception: Unknown CSV format  
at com.inductiveautomation.ignition.designer.sqltags.action.ImportTagAction$CSVTagImporter.run(ImportTagAction.java:142)  
at com.inductiveautomation.ignition.client.util.gui.ProgressDialog$TaskRunner.run(ProgressDialog.java:208)  
at java.lang.Thread.run(Unknown Source)

Ignition v7.1.5 (b5670)  
Java: Sun Microsystems Inc. 1.6.0\_18

thanks

---

<div class="post-metadata">

**Author:** ![Ciands](https://avatars.discourse-cdn.com/v4/letter/c/eb9ed0/32.png) [@Ciands](https://forum.inductiveautomation.com/u/Ciands)\
**Post date:** [August 20, 2010, 4:14pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/2 "2010-08-20T16:14:31Z")

</div>

I guess I figured it out. I used the Ignition Export and can clearly see that it is not in the same format.

So my next question would be , what would be the best way to develop screens when you dont have a live PLC to quickly drag and drop tags. Instead of typing 500 tags in?

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [August 20, 2010, 5:32pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/3 "2010-08-20T17:32:32Z")

</div>

I have a feeling that someone around here has written a script to convert from that format to SQLTags format, but I don’t think they posted it.

Doing something to convert it to our format would be the only way to import them, we don’t support importing external formats.

I haven’t looked at the RSLogix format in a while, but if you post your file, some friendly script-a-holic might be able to help you out.

Regards,

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [August 20, 2010, 5:34pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/4 "2010-08-20T17:34:23Z")

</div>

You certainly don’t need live PLC tags to develop screens, but having the tags themselves (even though they will be either simulated or stale) will be helpful.

Also, typing in 500 tags by hand sounds like a bad strategy. Most of our customers find ways to coerce their tag lists into our CSV format via copy/paste or macros.

---

<div class="post-metadata">

**Author:** ![Ciands](https://avatars.discourse-cdn.com/v4/letter/c/eb9ed0/32.png) [@Ciands](https://forum.inductiveautomation.com/u/Ciands)\
**Post date:** [August 20, 2010, 8:22pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/5 "2010-08-20T20:22:12Z")

</div>

I found a processor and got it tied into ignition. I browsed the tags in the OPC and dragged them to the SQL tags. There is probally 900 tags I believe mabye more, Now that I did that Ignition is unstable and java is running at 90% of the computers memory.

Thanks for any comments on this.

---

<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:** [August 20, 2010, 11:42pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/6 "2010-08-20T23:42:50Z")

</div>

Are you using a UA or DA connection? What driver or type of PLC are they from? What are you system specs?

---

<div class="post-metadata">

**Author:** ![Ciands](https://avatars.discourse-cdn.com/v4/letter/c/eb9ed0/32.png) [@Ciands](https://forum.inductiveautomation.com/u/Ciands)\
**Post date:** [August 23, 2010, 7:00pm UTC](https://forum.inductiveautomation.com/t/sql-tags-browser/2145/7 "2010-08-23T19:00:58Z")

</div>

UA, Controllogix L61, 2.81 Gig Ram, with 102 gig free hard drive.
