# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1761 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1762 --- ## [Kepware bought out!](https://forum.inductiveautomation.com/t/kepware-bought-out/10955)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 2\ **Last updated:** [December 23, 2015, 4:11pm UTC](https://forum.inductiveautomation.com/t/kepware-bought-out/10955 "2015-12-23T16:11:42Z")
PTC to Acquire Kepware, Will Extend Internet of Things Offering with Access to Industrial Automation Data NEEDHAM, MASS., December 22, 2015 – PTC (NASDAQ: PTC) today announced it has signed a definitive agreement to ac… --- ## [Verifying Database entries](https://forum.inductiveautomation.com/t/verifying-database-entries/10952)
**Author:** [@Freundl](https://forum.inductiveautomation.com/u/Freundl)\ **Replies:** 4\ **Last updated:** [December 22, 2015, 10:02pm UTC](https://forum.inductiveautomation.com/t/verifying-database-entries/10952 "2015-12-22T22:02:07Z")
So here is what were doing and what I want to do: We hard currently using the ignition designer to pull data from our plc's to help track parts. Things like test readings and verifying that a part has completed stations.… --- ## [Mobile Module on Droid](https://forum.inductiveautomation.com/t/mobile-module-on-droid/2560)
**Author:** [@esamuelson](https://forum.inductiveautomation.com/u/esamuelson)\ **Replies:** 2\ **Last updated:** [December 22, 2015, 7:07pm UTC](https://forum.inductiveautomation.com/t/mobile-module-on-droid/2560 "2015-12-22T19:07:40Z")
I apologize if this has been posted earlier, but the mobile module interests me greatly and would be a great addition to any SCADA system. However when me and my coworker pulled up the demo application via the web on our… --- ## [Gaps in easychart trends](https://forum.inductiveautomation.com/t/gaps-in-easychart-trends/10951)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 1\ **Last updated:** [December 22, 2015, 5:06pm UTC](https://forum.inductiveautomation.com/t/gaps-in-easychart-trends/10951 "2015-12-22T17:06:44Z")
Hi, I am using an Easy Chart to show data coming from a MS SQL Server database table. I configured some Database Pens and some of them are not showing correctly. To focus the problem, I developed a test page where only o… --- ## [Point comma issues based on locale](https://forum.inductiveautomation.com/t/point-comma-issues-based-on-locale/10950)
**Author:** [@thierryv](https://forum.inductiveautomation.com/u/thierryv)\ **Replies:** 3\ **Last updated:** [December 22, 2015, 4:28pm UTC](https://forum.inductiveautomation.com/t/point-comma-issues-based-on-locale/10950 "2015-12-22T16:28:43Z")
Do you have problems with comma/points? No problems at all Yes, but it doesn't bother me Yes, but I fix it myself Yes, and I hope that I.A. provides a solution Yes, and it is driving me crazy, I expect a solution f… --- ## [NullPointerException with system.tag.writeAll](https://forum.inductiveautomation.com/t/nullpointerexception-with-system-tag-writeall/10928)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 1\ **Last updated:** [December 22, 2015, 12:52am UTC](https://forum.inductiveautomation.com/t/nullpointerexception-with-system-tag-writeall/10928 "2015-12-22T00:52:59Z")
I always get the same error when trying to simultaneously write to 163 variables using the function system.tag.writeAll, below you can see the code and the error report. Any ideas? tags1 = \["" for x in range(163)\] tag… --- ## [Ignition client on system tray](https://forum.inductiveautomation.com/t/ignition-client-on-system-tray/10901)
**Author:** [@ella\_ramos](https://forum.inductiveautomation.com/u/ella_ramos)\ **Replies:** 3\ **Last updated:** [December 22, 2015, 12:27am UTC](https://forum.inductiveautomation.com/t/ignition-client-on-system-tray/10901 "2015-12-22T00:27:06Z")
Is it possible to minimize the ignition client and put it on the System Tray? --- ## [A quick way to clear the contents of an unbound table](https://forum.inductiveautomation.com/t/a-quick-way-to-clear-the-contents-of-an-unbound-table/10949)
**Author:** [@cbanzet](https://forum.inductiveautomation.com/u/cbanzet)\ **Replies:** 1\ **Last updated:** [December 21, 2015, 10:13pm UTC](https://forum.inductiveautomation.com/t/a-quick-way-to-clear-the-contents-of-an-unbound-table/10949 "2015-12-21T22:13:36Z")
I'm using an unbound table to accumulate a user's selections from a super long drop down list - that way the user can see all of the selections easily before he finalizes. When he clicks "OK" and I'm finished with the d… --- ## [How big is your data?](https://forum.inductiveautomation.com/t/how-big-is-your-data/10947)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 0\ **Last updated:** [December 21, 2015, 8:29pm UTC](https://forum.inductiveautomation.com/t/how-big-is-your-data/10947 "2015-12-21T20:29:36Z")
I had meant to share this a couple of weeks ago, but I'm just lazy... \[attachment=0\]HowBigIsData.jpeg\[/attachment\] --- ## [Fast data trending with millisecond resolution](https://forum.inductiveautomation.com/t/fast-data-trending-with-millisecond-resolution/10724)
**Author:** [@gglenn](https://forum.inductiveautomation.com/u/gglenn)\ **Replies:** 7\ **Last updated:** [December 21, 2015, 5:36pm UTC](https://forum.inductiveautomation.com/t/fast-data-trending-with-millisecond-resolution/10724 "2015-12-21T17:36:08Z")
Looking for guidance in fast data trending, historical trending, and export to Excel without losing resolution. The details: PLC tags to trend (OPC): 15 Calculated tags to trend (Exprension): 5 Scan Class for all tag… --- ## [How do I Set Multiple DataSet Values with one button?](https://forum.inductiveautomation.com/t/how-do-i-set-multiple-dataset-values-with-one-button/10942)
**Author:** [@jjanowiak](https://forum.inductiveautomation.com/u/jjanowiak)\ **Replies:** 1\ **Last updated:** [December 19, 2015, 1:46pm UTC](https://forum.inductiveautomation.com/t/how-do-i-set-multiple-dataset-values-with-one-button/10942 "2015-12-19T13:46:36Z")
I have an EasyChart and I want a single button to reset 6 pens to their default colors. I already have the Hex code for their colors. I also have code that will change to color of a single pen. I am not strong with Pyth… --- ## [runScript in Expression tag](https://forum.inductiveautomation.com/t/runscript-in-expression-tag/10940)
**Author:** [@ovendenk](https://forum.inductiveautomation.com/u/ovendenk)\ **Replies:** 3\ **Last updated:** [December 18, 2015, 9:11pm UTC](https://forum.inductiveautomation.com/t/runscript-in-expression-tag/10940 "2015-12-18T21:11:21Z")
Hey. We are trying to display the connection state of our AB PLC's and the only ones we have an issue with is the V24 PLC's because we need to use the Logix Driver which doesn't give us a diagnostics file. So, I am try… --- ## [NumericTextField Decimal Format different With Focus](https://forum.inductiveautomation.com/t/numerictextfield-decimal-format-different-with-focus/10930)
**Author:** [@r.lebohec](https://forum.inductiveautomation.com/u/r.lebohec)\ **Replies:** 4\ **Last updated:** [December 18, 2015, 6:31pm UTC](https://forum.inductiveautomation.com/t/numerictextfield-decimal-format-different-with-focus/10930 "2015-12-18T18:31:26Z")
Hi, Actually I use a NumericTextField component and i observe that the decimal format is not good (a the same) when the component is in edition mode. In the picture attach You see the component without focus (17.89 -\>… --- ## [Simple report query not working](https://forum.inductiveautomation.com/t/simple-report-query-not-working/10934)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 1\ **Last updated:** [December 18, 2015, 5:56pm UTC](https://forum.inductiveautomation.com/t/simple-report-query-not-working/10934 "2015-12-18T17:56:16Z")
I found when I create this simple query in the report designer: SELECT TO\_CHAR(trunc(sysdate)-1, 'DY MON DD') as "Date" from dual the report does not process the query and becomes very unhappy. preview stalls out in… --- ## [Export to Excel](https://forum.inductiveautomation.com/t/export-to-excel/10936)
**Author:** [@sushalexy](https://forum.inductiveautomation.com/u/sushalexy)\ **Replies:** 1\ **Last updated:** [December 18, 2015, 3:46pm UTC](https://forum.inductiveautomation.com/t/export-to-excel/10936 "2015-12-18T15:46:48Z")
Hi All! First of all, sorry for my English. Here is questions about export Table to excel. I using this script fpmi.dataset.exportExcel("MyReport", 1, event.source.parent.parent.getComponent('RESULT').getComponent('T… --- ## [MySQL SET statement causing error](https://forum.inductiveautomation.com/t/mysql-set-statement-causing-error/10927)
**Author:** [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\ **Replies:** 4\ **Last updated:** [December 17, 2015, 6:58pm UTC](https://forum.inductiveautomation.com/t/mysql-set-statement-causing-error/10927 "2015-12-17T18:58:35Z")
The following code throws this error from MySQL: caused by GatewayException: ResultSet is from UPDATE. No Data. caused by SQLException: ResultSet is from UPDATE. No Data. SET @prev\_value = -1; SELECT ABS(SUM(a.cur… --- ## [Tag scan classes, alarming, tag events](https://forum.inductiveautomation.com/t/tag-scan-classes-alarming-tag-events/10929)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [December 17, 2015, 1:37pm UTC](https://forum.inductiveautomation.com/t/tag-scan-classes-alarming-tag-events/10929 "2015-12-17T13:37:02Z")
Hi, I would like to understand a bit more about how scan classes affect tag alarms and events. If I set the scan class of a tag to leased with a slow rate of 60.000 and a fast rate of 500, what about its Alarming and Tag… --- ## [7.8 Transaction Mgr write a SQL query result to tags in PLC](https://forum.inductiveautomation.com/t/7-8-transaction-mgr-write-a-sql-query-result-to-tags-in-plc/10925)
**Author:** [@rwright](https://forum.inductiveautomation.com/u/rwright)\ **Replies:** 1\ **Last updated:** [December 16, 2015, 5:22pm UTC](https://forum.inductiveautomation.com/t/7-8-transaction-mgr-write-a-sql-query-result-to-tags-in-plc/10925 "2015-12-16T17:22:07Z")
I am trying to write the results of a SQL query into PLC tags based on the value of a trigger tag changing. This is being used in a batch process and I am logging additions of each batch to a table in the DB. When t… --- ## [VisualVM](https://forum.inductiveautomation.com/t/visualvm/10924)
**Author:** [@Amarth](https://forum.inductiveautomation.com/u/Amarth)\ **Replies:** 5\ **Last updated:** [December 16, 2015, 4:46pm UTC](https://forum.inductiveautomation.com/t/visualvm/10924 "2015-12-16T16:46:47Z")
Hello, I'm trying to monitor the memory consumption of one of my module. I've found that VisualVM could fit my needs. (I seems to be able to connect to a JVM through the wrapper by using a JMX Connection) I was wonde… --- ## [Control logix tags don't show up properly](https://forum.inductiveautomation.com/t/control-logix-tags-dont-show-up-properly/7779)
**Author:** [@jdana](https://forum.inductiveautomation.com/u/jdana)\ **Replies:** 9\ **Last updated:** [December 16, 2015, 4:43pm UTC](https://forum.inductiveautomation.com/t/control-logix-tags-dont-show-up-properly/7779 "2015-12-16T16:43:49Z")
The following causes a problem. Add a tag to Ignition V. 7.6.3 where the tag does not exist in a Contrologix plc. Upon adding the tag to the plc, Ignition will still not find it. If you browse for the tag in Ignition, … --- ## [Bad Tag Values following PLC Reload (Allen Bradley)](https://forum.inductiveautomation.com/t/bad-tag-values-following-plc-reload-allen-bradley/8723)
**Author:** [@george](https://forum.inductiveautomation.com/u/george)\ **Replies:** 3\ **Last updated:** [December 16, 2015, 4:39pm UTC](https://forum.inductiveautomation.com/t/bad-tag-values-following-plc-reload-allen-bradley/8723 "2015-12-16T16:39:26Z")
Ignition 7.6.6 AB ControlLogix V20 Today we've had some issues following the PLC program being reloaded while Ignition was running. The first thing I noticed was that it still said "Connecting....Program Mode" even onc… --- ## [PostgreSQL](https://forum.inductiveautomation.com/t/postgresql/10915)
**Author:** [@vnewman1963](https://forum.inductiveautomation.com/u/vnewman1963)\ **Replies:** 2\ **Last updated:** [December 16, 2015, 9:34am UTC](https://forum.inductiveautomation.com/t/postgresql/10915 "2015-12-16T09:34:19Z")
Has anyone used PostgreSQL with ignition? How was it , Stability etc.. --- ## [Event Script an system.tag.addTag](https://forum.inductiveautomation.com/t/event-script-an-system-tag-addtag/10923)
**Author:** [@lemeur17](https://forum.inductiveautomation.com/u/lemeur17)\ **Replies:** 0\ **Last updated:** [December 15, 2015, 9:25pm UTC](https://forum.inductiveautomation.com/t/event-script-an-system-tag-addtag/10923 "2015-12-15T21:25:29Z")
Hello, I'm wondering if it's possible to create a tag Event script with system.tag.addTag() ? I configured alarm tag with PyDictionary alarmConfig like this alarmConfig={"Alarm ":\[\["name", "Value", "Test "\], \["s… --- ## [Change popup calendar default date](https://forum.inductiveautomation.com/t/change-popup-calendar-default-date/10922)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 1\ **Last updated:** [December 15, 2015, 9:23pm UTC](https://forum.inductiveautomation.com/t/change-popup-calendar-default-date/10922 "2015-12-15T21:23:15Z")
I want to have the start and end time update every day to make the process easier for the users. Can a popup calendar default to show yesterday's date 7:00 am? --- ## [Error Writing to PLC](https://forum.inductiveautomation.com/t/error-writing-to-plc/10921)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 3\ **Last updated:** [December 15, 2015, 8:58pm UTC](https://forum.inductiveautomation.com/t/error-writing-to-plc/10921 "2015-12-15T20:58:02Z")
I'm getting an error when i try to write to my PLC Error writing to tag Almco/PLC/Packs/N9/InboundQTY Write timed out \[C\]. This is odd because it seems to wirte okay, but i still get the error. --- ## [Database Security](https://forum.inductiveautomation.com/t/database-security/10920)
**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Replies:** 1\ **Last updated:** [December 15, 2015, 8:28pm UTC](https://forum.inductiveautomation.com/t/database-security/10920 "2015-12-15T20:28:58Z")
version 7.7.5 using database security some edits to users through the gateway cause entries in the user\_ex table to be deleted. specifically, I added contact information for a user and an entry in the user\_ex table was d… --- ## [Subscription issues in python client](https://forum.inductiveautomation.com/t/subscription-issues-in-python-client/10914)
**Author:** [@nifemi](https://forum.inductiveautomation.com/u/nifemi)\ **Replies:** 6\ **Last updated:** [December 15, 2015, 1:24pm UTC](https://forum.inductiveautomation.com/t/subscription-issues-in-python-client/10914 "2015-12-15T13:24:03Z")
Hello all, I've just run into a peculiar problem subscribing to nodes from an external python client : PublishService Returning ServiceFault for request: \[PublishRequest requestHandle=9\]. StatusCode=StatusCode\[Seve… --- ## [Odd lines on graphic pages](https://forum.inductiveautomation.com/t/odd-lines-on-graphic-pages/10913)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [December 14, 2015, 8:59pm UTC](https://forum.inductiveautomation.com/t/odd-lines-on-graphic-pages/10913 "2015-12-14T20:59:02Z")
Hi, I'm experiencing the following problem on a panel PC: sometimes odd lines appear on graphic pages, like those in the next picture (please look at the oblique lines): \[attachment=0\]20151214.jpg\[/attachment\] Such lines… --- ## [Connecting to the SQL database from a module](https://forum.inductiveautomation.com/t/connecting-to-the-sql-database-from-a-module/10916)
**Author:** [@pmclean2](https://forum.inductiveautomation.com/u/pmclean2)\ **Replies:** 1\ **Last updated:** [December 14, 2015, 7:54pm UTC](https://forum.inductiveautomation.com/t/connecting-to-the-sql-database-from-a-module/10916 "2015-12-14T19:54:38Z")
Hi, I tried to connect my module to the MySQL database in Ignition using the example found in the SDK developer guide. But it seems that the "context" variable is not the same as the GatewayContext. Can you provide a c… --- ## [Dynamic SQL](https://forum.inductiveautomation.com/t/dynamic-sql/10908)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 5\ **Last updated:** [December 14, 2015, 2:52pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql/10908 "2015-12-14T14:52:13Z")
How to compare an int column with a varchar column containing SQL comparison operators? If I have a column1 containing 3315 and column2 containing '6287 OR 4596 OR 3315' how can the value of the 2nd column be treated a… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1760) [Next page](https://forum.inductiveautomation.com/latest.md?page=1762)