# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1165 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1166 --- ## [Create columns from a SQL Column](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682)
**Author:** [@malejandroreyes](https://forum.inductiveautomation.com/u/malejandroreyes)\ **Replies:** 4\ **Last updated:** [June 16, 2020, 2:27am UTC](https://forum.inductiveautomation.com/t/create-columns-from-a-sql-column/35682 "2020-06-16T02:27:07Z")
How do I create new columns in Ignition from a SQL Column. SQL column contains different names, then I want to use those differente names to create headers and count how many times repeat those names. Column in SQL is Ar… --- ## [\[BUG?\] Trend data with gaps after upgrade to 7.9.14](https://forum.inductiveautomation.com/t/bug-trend-data-with-gaps-after-upgrade-to-7-9-14/35641)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [June 15, 2020, 10:28pm UTC](https://forum.inductiveautomation.com/t/bug-trend-data-with-gaps-after-upgrade-to-7-9-14/35641 "2020-06-15T22:28:15Z")
Since upgrading to version 7.9.14 from 7.9.5, a bit after 9AM this morning, I’m seeing very choppy trend data which was solid prior to the upgrade. I don’t know it’s associated, but I’m also seeing the wrapper and on… --- ## [IGS driver (Kep Server)](https://forum.inductiveautomation.com/t/igs-driver-kep-server/35679)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 4\ **Last updated:** [June 15, 2020, 10:08pm UTC](https://forum.inductiveautomation.com/t/igs-driver-kep-server/35679 "2020-06-15T22:08:52Z")
Hello all, I’m connecting Ignition 8 on IGS driver, which is Kep Server sold by GE Digital. I create the connection using the proper username and security settings. It works. Ignition is connecting successfuly. Now… --- ## [Trouble with Gateway Message from 7.9 to 8.0](https://forum.inductiveautomation.com/t/trouble-with-gateway-message-from-7-9-to-8-0/32587)
**Author:** [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Replies:** 6\ **Last updated:** [June 15, 2020, 7:46pm UTC](https://forum.inductiveautomation.com/t/trouble-with-gateway-message-from-7-9-to-8-0/32587 "2020-06-15T19:46:33Z")
We're looking into a project where we'd like to leverage 8.0 but decouple some of the functionality from the existing 7.9 system. To do this, we'd like to send gateway messages from the 7.9 gateway to the 8.0 gateway. … --- ## [Terminal Boss Replacement](https://forum.inductiveautomation.com/t/terminal-boss-replacement/35677)
**Author:** [@emuchris](https://forum.inductiveautomation.com/u/emuchris)\ **Replies:** 0\ **Last updated:** [June 15, 2020, 7:42pm UTC](https://forum.inductiveautomation.com/t/terminal-boss-replacement/35677 "2020-06-15T19:42:09Z")
We’re using tboss for reporting and ticketing, I was wondering whether its possible that Ignition could replace this, and how much functionality would be missing if it was used instead. --- ## [Alarm Pipeline - Calculated Roster](https://forum.inductiveautomation.com/t/alarm-pipeline-calculated-roster/35667)
**Author:** [@ssatonkar](https://forum.inductiveautomation.com/u/ssatonkar)\ **Replies:** 0\ **Last updated:** [June 15, 2020, 5:18pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-calculated-roster/35667 "2020-06-15T17:18:21Z")
Hi, I am using an alarm pipeline for Email notification where I have used the calculated Roster type to get roster as per my requirement. However, I am trying to test the developed script for the Email pipeline. Also, … --- ## [Restart Tag vs Refresh Tag](https://forum.inductiveautomation.com/t/restart-tag-vs-refresh-tag/35663)
**Author:** [@Dan\_Bridgeman](https://forum.inductiveautomation.com/u/Dan_Bridgeman)\ **Replies:** 0\ **Last updated:** [June 15, 2020, 4:41pm UTC](https://forum.inductiveautomation.com/t/restart-tag-vs-refresh-tag/35663 "2020-06-15T16:41:10Z")
When you right-click on a tag in the Tag Browser, Ignition 8 has “Restart Tag” in the context menu. Does selecting this do the same thing as selecting “Refresh” did in Ignition 7? --- ## [Multiple commits using db.transactions?](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231)
**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\ **Replies:** 4\ **Last updated:** [June 15, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/multiple-commits-using-db-transactions/8231 "2020-06-15T16:32:15Z")
Is it possible to have multiple commits for a single transaction? For instance: txID = system.db.beginTransaction(timeout=5000) Insert statement here system.db.commitTransaction(txID) Second insert statement here s… --- ## [Data reading problems of CSV files](https://forum.inductiveautomation.com/t/data-reading-problems-of-csv-files/35645)
**Author:** [@m15195757181](https://forum.inductiveautomation.com/u/m15195757181)\ **Replies:** 2\ **Last updated:** [June 15, 2020, 3:36pm UTC](https://forum.inductiveautomation.com/t/data-reading-problems-of-csv-files/35645 "2020-06-15T15:36:15Z")
How do I get all the data in a column of a CSV file in an array format via a script? --- ## [Symbol Factory 3](https://forum.inductiveautomation.com/t/symbol-factory-3/35633)
**Author:** [@hophead6](https://forum.inductiveautomation.com/u/hophead6)\ **Replies:** 12\ **Last updated:** [June 15, 2020, 3:38pm UTC](https://forum.inductiveautomation.com/t/symbol-factory-3/35633 "2020-06-15T15:38:25Z")
I am trying to use Symbol Factory Version 3. Trying to copy and paste as .svg, I get this error: com.inductiveautomation.ignition.common.xmlserialization.SerializationException: Unexpected parsing error during XML dese… --- ## [Passing Tag Path to Easy Chart](https://forum.inductiveautomation.com/t/passing-tag-path-to-easy-chart/35657)
**Author:** [@kyle.lawson](https://forum.inductiveautomation.com/u/kyle.lawson)\ **Replies:** 5\ **Last updated:** [June 15, 2020, 3:37pm UTC](https://forum.inductiveautomation.com/t/passing-tag-path-to-easy-chart/35657 "2020-06-15T15:37:47Z")
Hello, I am trying to pass the full tag path from a custom property into the easy chart Tag Pens. When I try to pass the full path its not pulling any data into the trend. I see how I can use the cell update to set th… --- ## [system.opc.readValue config error](https://forum.inductiveautomation.com/t/system-opc-readvalue-config-error/34916)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 37\ **Last updated:** [June 15, 2020, 1:58pm UTC](https://forum.inductiveautomation.com/t/system-opc-readvalue-config-error/34916 "2020-06-15T13:58:15Z")
I am trying to test the OPC scripting function to read a tag. I enabled "Anonymous Access" in the OPC UA server settings, all my project tags are visible in the OPC UA tag browser. I copied the tag path of one of the tag… --- ## [Edit table cell with results from pop up window](https://forum.inductiveautomation.com/t/edit-table-cell-with-results-from-pop-up-window/17901)
**Author:** [@mluedecke](https://forum.inductiveautomation.com/u/mluedecke)\ **Replies:** 7\ **Last updated:** [December 26, 2018, 4:41pm UTC](https://forum.inductiveautomation.com/t/edit-table-cell-with-results-from-pop-up-window/17901 "2018-12-26T16:41:21Z")
I am wanting to allow a user to click in a cell of a table which will open a pop-up window. In the pop up window, the user will select some items that will build a string. I want that string to populate the cell on the… --- ## [Increase Raised Button Border Width](https://forum.inductiveautomation.com/t/increase-raised-button-border-width/35650)
**Author:** [@kwingert](https://forum.inductiveautomation.com/u/kwingert)\ **Replies:** 0\ **Last updated:** [June 15, 2020, 12:32pm UTC](https://forum.inductiveautomation.com/t/increase-raised-button-border-width/35650 "2020-06-15T12:32:18Z")
Vision 8.05 Is there a way to increase the width of the raised/lowered border width? On larger buttons the width is too small to really notice the difference and would like to increase the width of the raised/lowered p… --- ## [\[BUG\] Memory Tags not working after rebooting gateway](https://forum.inductiveautomation.com/t/bug-memory-tags-not-working-after-rebooting-gateway/31942)
**Author:** [@mfontana](https://forum.inductiveautomation.com/u/mfontana)\ **Replies:** 1\ **Last updated:** [June 15, 2020, 12:23pm UTC](https://forum.inductiveautomation.com/t/bug-memory-tags-not-working-after-rebooting-gateway/31942 "2020-06-15T12:23:17Z")
Hello to everyone, I found a strange behavior, I’m using Ignition V8.0.7, created a memory tag and it work perfectly. When I reboot the PC the memory tag became “stuck”. The error message I found is “Uncertain\_Initial… --- ## [Connecting to integrated S7 1500 OPC server](https://forum.inductiveautomation.com/t/connecting-to-integrated-s7-1500-opc-server/27799)
**Author:** [@brendan.curran](https://forum.inductiveautomation.com/u/brendan.curran)\ **Replies:** 12\ **Last updated:** [June 15, 2020, 9:48am UTC](https://forum.inductiveautomation.com/t/connecting-to-integrated-s7-1500-opc-server/27799 "2020-06-15T09:48:03Z")
I’ve been having a lot of issues getting a connection to a Siemens s7 1500 PLC. I’m now attempting to use Siemens inbuilt OPC UA but getting connection errors. I’m wondering if anyone has any experience with the integrat… --- ## [Data exchange via local SQL DB table](https://forum.inductiveautomation.com/t/data-exchange-via-local-sql-db-table/35621)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 5\ **Last updated:** [June 15, 2020, 8:09am UTC](https://forum.inductiveautomation.com/t/data-exchange-via-local-sql-db-table/35621 "2020-06-15T08:09:32Z")
I am currently working on a project where we use Ignition as the HMI of several machines. Each machine has its own PC and its own Ignition. The customer has an MES system in the company to which each machine must pass a… --- ## [VOIP Notification Profile - Registration Issues](https://forum.inductiveautomation.com/t/voip-notification-profile-registration-issues/32572)
**Author:** [@adrian.zatta](https://forum.inductiveautomation.com/u/adrian.zatta)\ **Replies:** 2\ **Last updated:** [June 15, 2020, 1:58am UTC](https://forum.inductiveautomation.com/t/voip-notification-profile-registration-issues/32572 "2020-06-15T01:58:11Z")
Hi everyone, I am in the process of trialing Ignition for use as a notification server, specifically for Voice notifications via SIP. I have been unable to get the notification profile to connect to my 3CX server; If … --- ## [\[Feature Request or Bug?\] Perspective Menu Tree Navicon Styling](https://forum.inductiveautomation.com/t/feature-request-or-bug-perspective-menu-tree-navicon-styling/35636)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 0\ **Last updated:** [June 15, 2020, 1:05am UTC](https://forum.inductiveautomation.com/t/feature-request-or-bug-perspective-menu-tree-navicon-styling/35636 "2020-06-15T01:05:03Z")
You are able to directly affect the label.text and label.icon.color properties of a menu tree item through styling, even without the label.icon.color property existing. However the navIcon.color property is not tied into… --- ## [System Tag Bad quality Perspective](https://forum.inductiveautomation.com/t/system-tag-bad-quality-perspective/35634)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 1\ **Last updated:** [June 14, 2020, 10:31pm UTC](https://forum.inductiveautomation.com/t/system-tag-bad-quality-perspective/35634 "2020-06-14T22:31:45Z")
Hi, I’m triying to use some system tags, like username tag, but when I binding the tag to a label, it just show bad quality, how can I use this tags in perspective? --- ## [Test SMTP profile](https://forum.inductiveautomation.com/t/test-smtp-profile/35627)
**Author:** [@ssatonkar](https://forum.inductiveautomation.com/u/ssatonkar)\ **Replies:** 1\ **Last updated:** [June 14, 2020, 11:30am UTC](https://forum.inductiveautomation.com/t/test-smtp-profile/35627 "2020-06-14T11:30:07Z")
Hi, I am trying to test the SMTP connection for Gmail but I think I am missing something. Please help. Satchit javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 465 at com.sun.ma… --- ## [Gateway Tag Change Scripts Periodically missing tag change events](https://forum.inductiveautomation.com/t/gateway-tag-change-scripts-periodically-missing-tag-change-events/35619)
**Author:** [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\ **Replies:** 1\ **Last updated:** [June 13, 2020, 1:37pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-scripts-periodically-missing-tag-change-events/35619 "2020-06-13T13:37:53Z")
Hi All, We have some gateway tag change scripts that are periodically missing tag change events. In an attempt to mitigate stale tag values we are using the following method to trigger data processing in the gateway scr… --- ## [Parse a TCP driver string and store the extracted values in one table row](https://forum.inductiveautomation.com/t/parse-a-tcp-driver-string-and-store-the-extracted-values-in-one-table-row/35585)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [June 13, 2020, 12:59pm UTC](https://forum.inductiveautomation.com/t/parse-a-tcp-driver-string-and-store-the-extracted-values-in-one-table-row/35585 "2020-06-13T12:59:10Z")
I have several checkweighers. They each spit out weighings on UDP every few seconds and I can pick them up with the TCP driver. The string received is in the format Date=2020-06-12,TIME=9:11:44,MachineID=Pack1, ... ,Wei… --- ## [UDT Tag Group Inheritance](https://forum.inductiveautomation.com/t/udt-tag-group-inheritance/35604)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 1\ **Last updated:** [June 13, 2020, 3:31am UTC](https://forum.inductiveautomation.com/t/udt-tag-group-inheritance/35604 "2020-06-13T03:31:31Z")
I created a udt tag and set its tag group to other than default (custom), will the tags(child) within the udt inherit the parent tag group, in this case ‘custom’ or do I still have to manually change each of them? Thank… --- ## [Component methods?](https://forum.inductiveautomation.com/t/component-methods/35608)
**Author:** [@chris.dimaria](https://forum.inductiveautomation.com/u/chris.dimaria)\ **Replies:** 1\ **Last updated:** [June 12, 2020, 6:26pm UTC](https://forum.inductiveautomation.com/t/component-methods/35608 "2020-06-12T18:26:08Z")
I know you can invoke the actionPerformed event of a button by by calling the .doClick() method in script. But are there other methods that can be called on other components? Can’t seem to find any documentation. Not e… --- ## [System.opc.browse perfermance](https://forum.inductiveautomation.com/t/system-opc-browse-perfermance/35594)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 7\ **Last updated:** [June 12, 2020, 5:12pm UTC](https://forum.inductiveautomation.com/t/system-opc-browse-perfermance/35594 "2020-06-12T17:12:12Z")
I have a PLC with +/- 10 000 tags. I search a way to get path and value of each tag with term “config” in the path. I have a functionnal solution but it takes a very long times to do it. (30-40s). Somebody know a bett… --- ## [Relation between different polling rate](https://forum.inductiveautomation.com/t/relation-between-different-polling-rate/35601)
**Author:** [@doshinikhil](https://forum.inductiveautomation.com/u/doshinikhil)\ **Replies:** 0\ **Last updated:** [June 12, 2020, 4:39pm UTC](https://forum.inductiveautomation.com/t/relation-between-different-polling-rate/35601 "2020-06-12T16:39:25Z")
Hello, I am looking at different settings for different polling rate. Is there any relation between them or is there any thumb rule do we need to follow? For example, Can I say Client Polling Rate \< Polling Base rate \<… --- ## [Styling problems for "Docked Window"](https://forum.inductiveautomation.com/t/styling-problems-for-docked-window/35579)
**Author:** [@m15195757181](https://forum.inductiveautomation.com/u/m15195757181)\ **Replies:** 1\ **Last updated:** [June 12, 2020, 4:37pm UTC](https://forum.inductiveautomation.com/t/styling-problems-for-docked-window/35579 "2020-06-12T16:37:05Z")
As shown in the first figure, the red arrow area is red and white two “Docked Window”, now is red Window blocking the lateral extension of white Window, I want to by some Settings make Bai Seyan "at both ends to the Wind… --- ## [\[bug-16643\]"&" Sign screws up project title in vision launcher](https://forum.inductiveautomation.com/t/bug-16643-sign-screws-up-project-title-in-vision-launcher/35587)
**Author:** [@kyle.lawson](https://forum.inductiveautomation.com/u/kyle.lawson)\ **Replies:** 1\ **Last updated:** [June 12, 2020, 4:07pm UTC](https://forum.inductiveautomation.com/t/bug-16643-sign-screws-up-project-title-in-vision-launcher/35587 "2020-06-12T16:07:00Z")
Not sure if someone else has identified this issue but when I created a project I used the “&” sign in the title name. When I went to launch the project through the vision client I couldn’t find the project name I creat… --- ## [Tag Groups within Data Types/UDTs](https://forum.inductiveautomation.com/t/tag-groups-within-data-types-udts/31638)
**Author:** [@mbhagotra](https://forum.inductiveautomation.com/u/mbhagotra)\ **Replies:** 2\ **Last updated:** [June 12, 2020, 4:06pm UTC](https://forum.inductiveautomation.com/t/tag-groups-within-data-types-udts/31638 "2020-06-12T16:06:10Z")
Hello, I tried digging through the manual to find an answer but couldn’t hence this post. How exactly do the tag groups work within data types/UDTs? I see that one can set a tag group at the UDT level but also within … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1164) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1166)