# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1912 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1913 --- ## [All Devices Connecting & Disconnecting Rapidly on OPCUA](https://forum.inductiveautomation.com/t/all-devices-connecting-disconnecting-rapidly-on-opcua/5952)
**Author:** [@bpirtle](https://forum.inductiveautomation.com/u/bpirtle)\ **Replies:** 6\ **Last updated:** [March 2, 2013, 12:01am UTC](https://forum.inductiveautomation.com/t/all-devices-connecting-disconnecting-rapidly-on-opcua/5952 "2013-03-02T00:01:31Z")
I have attached my log files - All connections seem to be timing out after they have just connected. Tried rebooting the server and restarting the ignition service, and nothing works. I also deleted and then added the … --- ## [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 ? --- ## [Allen Bradley PLC not connecting](https://forum.inductiveautomation.com/t/allen-bradley-plc-not-connecting/5946)
**Author:** [@David3](https://forum.inductiveautomation.com/u/David3)\ **Replies:** 1\ **Last updated:** [March 1, 2013, 3:00pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-plc-not-connecting/5946 "2013-03-01T15:00:48Z")
I can ping device and view it on web browser but ignition is not connecting to PLC Using Version 7.5.5(b1255) I am recieving this error: BCon enable live values Connecting Error: hide Details java.lang.Excep… --- ## [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… --- ## [system.tag.queryTagHistory question](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-question/5943)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 1\ **Last updated:** [February 28, 2013, 10:01pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-question/5943 "2013-02-28T22:01:59Z")
We have the below script in the event handle of a button: paths = event.source.parent.selectedLocation startDate = event.source.parent.getComponent('Date Range').startDate endDate = event.source.parent.getComponent('Da… --- ## [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… --- ## [SQL querry question](https://forum.inductiveautomation.com/t/sql-querry-question/5897)
**Author:** [@lcs226](https://forum.inductiveautomation.com/u/lcs226)\ **Replies:** 7\ **Last updated:** [February 28, 2013, 2:33pm UTC](https://forum.inductiveautomation.com/t/sql-querry-question/5897 "2013-02-28T14:33:55Z")
Hello All, I am OK with SQL when it comes to the basic’s but not very good when tring to do more complicated querries or data extraction. Any suggestions would be welcomed. I have attached a word document with the quer… --- ## [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. --- ## [SPC Measurement of a dataset](https://forum.inductiveautomation.com/t/spc-measurement-of-a-dataset/5872)
**Author:** [@hazelchr](https://forum.inductiveautomation.com/u/hazelchr)\ **Replies:** 3\ **Last updated:** [February 27, 2013, 9:39pm UTC](https://forum.inductiveautomation.com/t/spc-measurement-of-a-dataset/5872 "2013-02-27T21:39:29Z")
I have measurement data from a device stored in a SQL database in a cell as a tab delimited string. The size of the actual dataset that was stored inside the cell can be something like 1000 rows x 1 col. I created a SQL … --- ## [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… --- ## [Rollback Exception](https://forum.inductiveautomation.com/t/rollback-exception/5829)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 10\ **Last updated:** [February 27, 2013, 8:14pm UTC](https://forum.inductiveautomation.com/t/rollback-exception/5829 "2013-02-27T20:14:21Z")
While running driver module, importing and creating tags, the system does a settings backup which blows up our module with the following exception: \[code\] simpleorm.utils.SException$Jdbc: Executing SELECT TAG\_PROPERTIE… --- ## [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… --- ## [Project Effort - How many hours?](https://forum.inductiveautomation.com/t/project-effort-how-many-hours/5908)
**Author:** [@inavarro78](https://forum.inductiveautomation.com/u/inavarro78)\ **Replies:** 3\ **Last updated:** [February 26, 2013, 7:58am UTC](https://forum.inductiveautomation.com/t/project-effort-how-many-hours/5908 "2013-02-26T07:58:20Z")
Based on your own experience, ¿how many hours do you think a medium-complex project would be? We must historize about 500 tags and develop 20 different screens of several production processes. No reports are needed. --- ## [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… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1911) [Next page](https://forum.inductiveautomation.com/latest.md?page=1913)