# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1588 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1589 --- ## [Initializing a dataset](https://forum.inductiveautomation.com/t/initializing-a-dataset/5948)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 3\ **Last updated:** [March 1, 2013, 11:43pm UTC](https://forum.inductiveautomation.com/t/initializing-a-dataset/5948 "2013-03-01T23:43:23Z")
Hi, I need to pivot a table and to do so, create a dataset with system.dataset.toDataSet(header, row). The problem is that all the columns are in string type instead of int or double, and then the report cannot make a… --- ## [Has anyone integrated ignition with quickbooks?](https://forum.inductiveautomation.com/t/has-anyone-integrated-ignition-with-quickbooks/5942)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 1\ **Last updated:** [March 1, 2013, 11:08pm UTC](https://forum.inductiveautomation.com/t/has-anyone-integrated-ignition-with-quickbooks/5942 "2013-03-01T23:08:56Z")
we might look at this since quickbooks cant run some of the reports we would like to generate. has anyone done something like this? I found this database synch program but havent had a chance to fool with it yet: syn… --- ## [Feature Request](https://forum.inductiveautomation.com/t/feature-request/5951)
**Author:** [@Sunil](https://forum.inductiveautomation.com/u/Sunil)\ **Replies:** 0\ **Last updated:** [March 1, 2013, 7:28pm UTC](https://forum.inductiveautomation.com/t/feature-request/5951 "2013-03-01T19:28:23Z")
Will it be possible to include an ability of adding client tags programmatically in next release, similar to adding tags under default, using system.tag.addTag ? --- ## [Serial Module Possible Error](https://forum.inductiveautomation.com/t/serial-module-possible-error/5920)
**Author:** [@rhoag](https://forum.inductiveautomation.com/u/rhoag)\ **Replies:** 10\ **Last updated:** [March 1, 2013, 3:13am UTC](https://forum.inductiveautomation.com/t/serial-module-possible-error/5920 "2013-03-01T03:13:32Z")
The first time my serial write code is launched I get the following message in the output console. Serialio Library: version 10.1.2: build 9221 Copyright (c) 1996-2012 Serialio.com, All Rights Reserved. os.name="Window… --- ## [SQLTag History Data](https://forum.inductiveautomation.com/t/sqltag-history-data/5930)
**Author:** [@jasonpdavid](https://forum.inductiveautomation.com/u/jasonpdavid)\ **Replies:** 3\ **Last updated:** [February 28, 2013, 9:13pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-data/5930 "2013-02-28T21:13:34Z")
I've recently discovered that when I run any charts for tags that the data leads into the future by about one hour. The values are correct up to the current time and then the current value is cast into the future. The … --- ## [Modbus driver - One of many subscriptions stopped updating](https://forum.inductiveautomation.com/t/modbus-driver-one-of-many-subscriptions-stopped-updating/5929)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 14\ **Last updated:** [February 28, 2013, 7:35pm UTC](https://forum.inductiveautomation.com/t/modbus-driver-one-of-many-subscriptions-stopped-updating/5929 "2013-02-28T19:35:37Z")
Hi, i have a strange problem with the modbus driver. Yesterday after 6:30pm one of the subscribed values stopped updating, but the quality is still ‘good’. All other values (which are in a different ScanClass) are worki… --- ## [Charging window](https://forum.inductiveautomation.com/t/charging-window/3690)
**Author:** [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Replies:** 12\ **Last updated:** [February 28, 2013, 6:47pm UTC](https://forum.inductiveautomation.com/t/charging-window/3690 "2013-02-28T18:47:30Z")
Hello! I was looking for information about how create a “charging window” bar or some other component that indicates the window is opening (doing calculations, etc). Does anybody have an idea? Thanks for your answers! … --- ## [Unable to Restore Gateway - Java zip](https://forum.inductiveautomation.com/t/unable-to-restore-gateway-java-zip/5936)
**Author:** [@scott\_stc](https://forum.inductiveautomation.com/u/scott_stc)\ **Replies:** 4\ **Last updated:** [February 28, 2013, 5:32pm UTC](https://forum.inductiveautomation.com/t/unable-to-restore-gateway-java-zip/5936 "2013-02-28T17:32:23Z")
When trying to restore a gateway, (Ign. v7.5.5 (b1255)), (32bit Java version 7.15), I get an error: \[color=#FF0040\]Error writing to restore file: java.util.zip.ZipException: invalid distance too far back\[/color\] Since … --- ## [Warning-Error in Gateway console Log](https://forum.inductiveautomation.com/t/warning-error-in-gateway-console-log/5932)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 5\ **Last updated:** [February 28, 2013, 4:18pm UTC](https://forum.inductiveautomation.com/t/warning-error-in-gateway-console-log/5932 "2013-02-28T16:18:08Z")
I keep getting this error showing up in the log, What is possible problem? \[WARN\] 12:37:17 PM RunQuery Error closing statement. java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@5372b9a5 is… --- ## [rotateDataset() and sortDataset() function](https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 2\ **Last updated:** [February 28, 2013, 3:14pm UTC](https://forum.inductiveautomation.com/t/rotatedataset-and-sortdataset-function/5938 "2013-02-28T15:14:25Z")
HI, When dealing with dataset for reporting or interfacing other system, it is usual to have to pivot dataset. I know some database can handle this quite nicely or by a magic python script, but it would be very helpful… --- ## [Jnlp file](https://forum.inductiveautomation.com/t/jnlp-file/5935)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 4\ **Last updated:** [February 28, 2013, 3:11am UTC](https://forum.inductiveautomation.com/t/jnlp-file/5935 "2013-02-28T03:11:37Z")
this is probably a really dumb question but I just installed ignition on a different computer and when I hit launch for the project it opens the project and puts a shortcut on my desktop but no jnlp file. On the previou… --- ## [How applet adapt screen resolution](https://forum.inductiveautomation.com/t/how-applet-adapt-screen-resolution/5931)
**Author:** [@ckdatong](https://forum.inductiveautomation.com/u/ckdatong)\ **Replies:** 1\ **Last updated:** [February 28, 2013, 1:54am UTC](https://forum.inductiveautomation.com/t/how-applet-adapt-screen-resolution/5931 "2013-02-28T01:54:16Z")
I now use Ignition applet,but I want to know how to dynamically adapt the screen resolution. --- ## [Changing a number](https://forum.inductiveautomation.com/t/changing-a-number/5934)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [February 27, 2013, 9:03pm UTC](https://forum.inductiveautomation.com/t/changing-a-number/5934 "2013-02-27T21:03:35Z")
If I scanned a barcode into a text field and it read: 12345-67 is there a way to make it show up as 1234567 Is there a way to remove the "dash" --- ## [Multi Instance Wizard](https://forum.inductiveautomation.com/t/multi-instance-wizard/5933)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 1\ **Last updated:** [February 27, 2013, 9:00pm UTC](https://forum.inductiveautomation.com/t/multi-instance-wizard/5933 "2013-02-27T21:00:20Z")
In the process of trying to convert standard tag folders to UDT's, the naming convention that we use cannot be replicated by using the Multi Instance wizard because of the space introduced between the Base Tag Name and t… --- ## [Selecting last row of a table](https://forum.inductiveautomation.com/t/selecting-last-row-of-a-table/5924)
**Author:** [@jaepark](https://forum.inductiveautomation.com/u/jaepark)\ **Replies:** 2\ **Last updated:** [February 27, 2013, 2:43pm UTC](https://forum.inductiveautomation.com/t/selecting-last-row-of-a-table/5924 "2013-02-27T14:43:21Z")
What is the best way to select the last row of a table and retrieve a value from it after a new row is added? I am currently using the following, which does select the last tow but the value retrieved is from the previou… --- ## [Python try/exepts in Ignition](https://forum.inductiveautomation.com/t/python-try-exepts-in-ignition/5690)
**Author:** [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\ **Replies:** 4\ **Last updated:** [February 26, 2013, 2:02pm UTC](https://forum.inductiveautomation.com/t/python-try-exepts-in-ignition/5690 "2013-02-26T14:02:48Z")
Is there a type error that will accept sql database writes in Ignition like the first one? try: Lots of things that might not work system.db.runPrepUpdate("INSERT INTO table VALUES ('lots of things')", \[lots of th… --- ## [Numeric Text Field Units](https://forum.inductiveautomation.com/t/numeric-text-field-units/2779)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 15\ **Last updated:** [February 26, 2013, 1:22pm UTC](https://forum.inductiveautomation.com/t/numeric-text-field-units/2779 "2013-02-26T13:22:33Z")
I like to use the "units" or "suffix" properties of the numeric label component for displaying my process values with the units in the same field. Unfortunately, the numeric text field component used for entering set po… --- ## [Inefficient query in Database Driving Provider?](https://forum.inductiveautomation.com/t/inefficient-query-in-database-driving-provider/5912)
**Author:** [@todd.be](https://forum.inductiveautomation.com/u/todd.be)\ **Replies:** 1\ **Last updated:** [February 26, 2013, 12:46am UTC](https://forum.inductiveautomation.com/t/inefficient-query-in-database-driving-provider/5912 "2013-02-26T00:46:38Z")
We had a mysterious mysql database issue the other day and while debugging some of that I noticed some odd queries running from the ignition instance. I suspect the index got corrupted even though repairing does not fix… --- ## [OPC communication problem](https://forum.inductiveautomation.com/t/opc-communication-problem/5506)
**Author:** [@miketob](https://forum.inductiveautomation.com/u/miketob)\ **Replies:** 2\ **Last updated:** [February 25, 2013, 11:10pm UTC](https://forum.inductiveautomation.com/t/opc-communication-problem/5506 "2013-02-25T23:10:06Z")
Hello, I have a problem with an OPC server that I guess that it’s faulty, these are the symptoms: One of my SQL Bridge group starts to fail, the involved tags have an OPC Quality=Unknown When I go to OPC Server… --- ## [Designer and project slow to respond](https://forum.inductiveautomation.com/t/designer-and-project-slow-to-respond/5923)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 1\ **Last updated:** [February 25, 2013, 4:58pm UTC](https://forum.inductiveautomation.com/t/designer-and-project-slow-to-respond/5923 "2013-02-25T16:58:17Z")
Hello, Running V7.5.5 on VM. For some reason i have been experiencing very slow performance from the gateway. Designer project downloads take forever and saving changes to the project constanly suffer from connection… --- ## [Modbus Driver question!](https://forum.inductiveautomation.com/t/modbus-driver-question/5918)
**Author:** [@Rv.Batista](https://forum.inductiveautomation.com/u/Rv.Batista)\ **Replies:** 3\ **Last updated:** [February 25, 2013, 4:01pm UTC](https://forum.inductiveautomation.com/t/modbus-driver-question/5918 "2013-02-25T16:01:49Z")
Hello everyone, this is my first post in Ignition forum! I'm want to know how to use HRBCD32 designator! I made a configuration with the following OPC Item Path: \[ConversorETH\_Serial\]1.HRBCD321680 But when I snif… --- ## [Vision Panel Edition send email alerts?](https://forum.inductiveautomation.com/t/vision-panel-edition-send-email-alerts/5913)
**Author:** [@linktdi](https://forum.inductiveautomation.com/u/linktdi)\ **Replies:** 3\ **Last updated:** [February 24, 2013, 8:11pm UTC](https://forum.inductiveautomation.com/t/vision-panel-edition-send-email-alerts/5913 "2013-02-24T20:11:35Z")
Can you send an email alert in VPE? I haven't been able to yet as I get an error. I can send email alerts in the standard Ignition version just not VPE. Wondering if it's disabled in the VPE version. --- ## [Csv automatic insertion into SQL](https://forum.inductiveautomation.com/t/csv-automatic-insertion-into-sql/5919)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 1\ **Last updated:** [February 24, 2013, 3:10pm UTC](https://forum.inductiveautomation.com/t/csv-automatic-insertion-into-sql/5919 "2013-02-24T15:10:35Z")
I'm currently working on a project with several dataloggers, each datalogger sends a csv file to an ftp sever everyday, the name of each file is function of the date and time it was sent, for instance TEST\_DATALOGGER1\_2… --- ## [Serial device opc](https://forum.inductiveautomation.com/t/serial-device-opc/5863)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 6\ **Last updated:** [February 24, 2013, 6:00am UTC](https://forum.inductiveautomation.com/t/serial-device-opc/5863 "2013-02-24T06:00:18Z")
Im sure this has been asked before but an opc server for serial devices (modbus rs232) would be huge. I know you guys weren't planning on doing any opc servers in the beginning - but I think having a built in opc server… --- ## [Query of 2 databases](https://forum.inductiveautomation.com/t/query-of-2-databases/5894)
**Author:** [@d.laquidain](https://forum.inductiveautomation.com/u/d.laquidain)\ **Replies:** 2\ **Last updated:** [February 23, 2013, 8:36am UTC](https://forum.inductiveautomation.com/t/query-of-2-databases/5894 "2013-02-23T08:36:49Z")
Hi, I need a query to get datas from 2 diferent databases and later show them in a table. Does anybody know which is exactly the syntax in Ignition? thanks! --- ## [Tag diagnostics](https://forum.inductiveautomation.com/t/tag-diagnostics/5882)
**Author:** [@Ruslan](https://forum.inductiveautomation.com/u/Ruslan)\ **Replies:** 5\ **Last updated:** [February 23, 2013, 12:33am UTC](https://forum.inductiveautomation.com/t/tag-diagnostics/5882 "2013-02-23T00:33:40Z")
Hello, I would like to troubleshoot my newly written schedule gateway timer script, and find out why some tags are not changed in time. How can I check write times of specific tag, and confirm that it was rewritten by sc… --- ## [Print Two Page Report](https://forum.inductiveautomation.com/t/print-two-page-report/5916)
**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Replies:** 4\ **Last updated:** [February 23, 2013, 12:28am UTC](https://forum.inductiveautomation.com/t/print-two-page-report/5916 "2013-02-23T00:28:48Z")
I am using the following script to print a two page report: report = window.getComponent('Report') report.print() Only the first page of the report prints unless I specifically select the pages to print in the print… --- ## [Dates](https://forum.inductiveautomation.com/t/dates/5917)
**Author:** [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\ **Replies:** 1\ **Last updated:** [February 22, 2013, 9:36pm UTC](https://forum.inductiveautomation.com/t/dates/5917 "2013-02-22T21:36:47Z")
I have a datetime in a mssql database. When I do date = system.db.runScalarQuery('QueryForDate') How do I subtract one minute from date? I can do date.month += 1, but not date.minute +=1 It appears to be a java… --- ## [Changing colors on Chart](https://forum.inductiveautomation.com/t/changing-colors-on-chart/5776)
**Author:** [@mikehill100](https://forum.inductiveautomation.com/u/mikehill100)\ **Replies:** 7\ **Last updated:** [February 22, 2013, 9:04pm UTC](https://forum.inductiveautomation.com/t/changing-colors-on-chart/5776 "2013-02-22T21:04:04Z")
I have a chart with a dataset that has 5 columns. I want to change the colors of columns3 and 4. This is the only way on the forum I have found to change series colors colors = \[sameColor, sameColor, ANOTHERCOLOR,… --- ## [Multi-Client for Multi-screen](https://forum.inductiveautomation.com/t/multi-client-for-multi-screen/5903)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [February 22, 2013, 8:05pm UTC](https://forum.inductiveautomation.com/t/multi-client-for-multi-screen/5903 "2013-02-22T20:05:41Z")
We plan to replace with Ignition an existing Siemens WinCC application. Some PC have 3 screens. The same WinCC application is launched 3 times, 1 instance is dedicated for 1 screen. For example, user can have : - vi… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1587) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1589)