# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1641 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1642 --- ## [SQL Insert Issues](https://forum.inductiveautomation.com/t/sql-insert-issues/17897)
**Author:** [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Replies:** 7\ **Last updated:** [May 2, 2018, 1:39pm UTC](https://forum.inductiveautomation.com/t/sql-insert-issues/17897 "2018-05-02T13:39:48Z")
Good Morning, I am trying to do a SQL Insert through Scripting. I have it set on the Action performed of a button. Unfortunately I can't seem to get it to work. Here is the script I have in place: PO = "CT/Var… --- ## [Web page automatic data passing](https://forum.inductiveautomation.com/t/web-page-automatic-data-passing/17898)
**Author:** [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Replies:** 3\ **Last updated:** [May 2, 2018, 1:37pm UTC](https://forum.inductiveautomation.com/t/web-page-automatic-data-passing/17898 "2018-05-02T13:37:57Z")
Hi, I have some alphanumeric data available, I am currently accessing web page manually, entering the data in webpage input field and pressing the button on the web page to get the results. is there any way possible to… --- ## [Defining a Tag Driving Provider for Memory tags](https://forum.inductiveautomation.com/t/defining-a-tag-driving-provider-for-memory-tags/17876)
**Author:** [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\ **Replies:** 2\ **Last updated:** [May 2, 2018, 12:27pm UTC](https://forum.inductiveautomation.com/t/defining-a-tag-driving-provider-for-memory-tags/17876 "2018-05-02T12:27:44Z")
Our project(s) make extensive (almost exclusive) use of Memory tags, and we need them available to some 3rd party SCADA packages. I created a Tag Driving provider for them just so that their values, etc would be availabl… --- ## [Evaluate on Change & Max Time Between Records](https://forum.inductiveautomation.com/t/evaluate-on-change-max-time-between-records/17877)
**Author:** [@CraigP](https://forum.inductiveautomation.com/u/CraigP)\ **Replies:** 2\ **Last updated:** [May 2, 2018, 12:25pm UTC](https://forum.inductiveautomation.com/t/evaluate-on-change-max-time-between-records/17877 "2018-05-02T12:25:29Z")
The documentation states that when using the Evaluate on Change historical scanclass, the Max Time Between Records setting will be ignored. I'm using Evaluate on Change now but I'd also like to store history every 6 hou… --- ## [Diagnostics CLient Logs](https://forum.inductiveautomation.com/t/diagnostics-client-logs/17847)
**Author:** [@trishhiyah](https://forum.inductiveautomation.com/u/trishhiyah)\ **Replies:** 3\ **Last updated:** [May 2, 2018, 11:42am UTC](https://forum.inductiveautomation.com/t/diagnostics-client-logs/17847 "2018-05-02T11:42:09Z")
Hi We figure out that we have clients that are constantly launching every seconds. --- ## [Convert Dataset Column Type](https://forum.inductiveautomation.com/t/convert-dataset-column-type/17886)
**Author:** [@ahardin](https://forum.inductiveautomation.com/u/ahardin)\ **Replies:** 1\ **Last updated:** [May 1, 2018, 3:49pm UTC](https://forum.inductiveautomation.com/t/convert-dataset-column-type/17886 "2018-05-01T15:49:07Z")
I have a dataset that all of the columns are a string. Is there a way to convert the types for certain columns in a dataset? --- ## [BarChart bar values with Prefix or Suffix](https://forum.inductiveautomation.com/t/barchart-bar-values-with-prefix-or-suffix/17885)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 0\ **Last updated:** [May 1, 2018, 2:31pm UTC](https://forum.inductiveautomation.com/t/barchart-bar-values-with-prefix-or-suffix/17885 "2018-05-01T14:31:23Z")
Hey guys, Is it possible to add a $ to the bar label? I have a Bar Chart that has a bar for number of scraps and one for the dollar amount and it would be great if the dollar amount bar has a '$' next to the value. Than… --- ## [SQL migration using SSMA, tables need database reference](https://forum.inductiveautomation.com/t/sql-migration-using-ssma-tables-need-database-reference/17851)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 5\ **Last updated:** [May 1, 2018, 4:29am UTC](https://forum.inductiveautomation.com/t/sql-migration-using-ssma-tables-need-database-reference/17851 "2018-05-01T04:29:37Z")
Hey folks, We're in the midst of a SQL migration from MySQL to MSSQL using the SSMA tool. However, I've found that the tables we migrate, when we query from ignition, they need a database reference (ie: select \* from… --- ## [History with Multiple Scan Classes](https://forum.inductiveautomation.com/t/history-with-multiple-scan-classes/17846)
**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\ **Replies:** 7\ **Last updated:** [May 1, 2018, 12:56am UTC](https://forum.inductiveautomation.com/t/history-with-multiple-scan-classes/17846 "2018-05-01T00:56:51Z")
Hi Guys, I would like to keep tag history at a fast rate for a short time (1 second intervals for 1 week), and the same tag at a slower rate for a longer period of time (30 second intervals for 1 year). This will allow d… --- ## [Broadcast Ignition Client to a Raspberry Pi hooked up to TV using VNC Viewer](https://forum.inductiveautomation.com/t/broadcast-ignition-client-to-a-raspberry-pi-hooked-up-to-tv-using-vnc-viewer/17872)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 4\ **Last updated:** [May 1, 2018, 12:29am UTC](https://forum.inductiveautomation.com/t/broadcast-ignition-client-to-a-raspberry-pi-hooked-up-to-tv-using-vnc-viewer/17872 "2018-05-01T00:29:00Z")
I want to know if anyone has tried just using VNC Viewer (or the like) on a Raspberry Pi hooked up to a Smart TV via HDMI to display an Ignition Client that is running on an arbitrary box that is perhaps just in a server… --- ## [Sepasoft Task Routing](https://forum.inductiveautomation.com/t/sepasoft-task-routing/17878)
**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Replies:** 0\ **Last updated:** [April 30, 2018, 11:58pm UTC](https://forum.inductiveautomation.com/t/sepasoft-task-routing/17878 "2018-04-30T23:58:57Z")
Does anyone know anything about MES Task Routing? --- ## [Java Web Start - Associate with JNLP files](https://forum.inductiveautomation.com/t/java-web-start-associate-with-jnlp-files/17873)
**Author:** [@robwarren](https://forum.inductiveautomation.com/u/robwarren)\ **Replies:** 6\ **Last updated:** [April 30, 2018, 8:33pm UTC](https://forum.inductiveautomation.com/t/java-web-start-associate-with-jnlp-files/17873 "2018-04-30T20:33:29Z")
Hello Everyone, I am running Ignition in the Cloud, and I have many remote users who connect to many different projects. I am having problems with the javaws.exe file not being associated to automatically open .JNLP file… --- ## [Module Signing](https://forum.inductiveautomation.com/t/module-signing/12144)
**Author:** [@nifemi](https://forum.inductiveautomation.com/u/nifemi)\ **Replies:** 3\ **Last updated:** [April 30, 2018, 7:42pm UTC](https://forum.inductiveautomation.com/t/module-signing/12144 "2018-04-30T19:42:12Z")
Module Marketplace has become Module Showcase, and It seems I can no longer get developer license keys, or sign a module for internal use.. have I missed something? Thanks. --- ## [Performance of trends after run time of 17+ hours - Large Client Tag History Cache?](https://forum.inductiveautomation.com/t/performance-of-trends-after-run-time-of-17-hours-large-client-tag-history-cache/14082)
**Author:** [@kcabatic](https://forum.inductiveautomation.com/u/kcabatic)\ **Replies:** 3\ **Last updated:** [April 30, 2018, 3:17pm UTC](https://forum.inductiveautomation.com/t/performance-of-trends-after-run-time-of-17-hours-large-client-tag-history-cache/14082 "2018-04-30T15:17:39Z")
Hi, During a soak testing of our trend displays we encountered performance issues. On two monitors we ran a trend screen (realtime mode) that contained 4 pens each. In addition we had three pop-up trends. In total w… --- ## [Tag editor scan classes unsorted](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 6\ **Last updated:** [April 30, 2018, 3:15pm UTC](https://forum.inductiveautomation.com/t/tag-editor-scan-classes-unsorted/17860 "2018-04-30T15:15:30Z")
In the Scan class editor, all scan classes are sorted alphabetically. But in Tag editor dropdown for choosing Scan Class they are shown unsorted in some weird order and it’s very difficult to find the right scan class i… --- ## [Bug? Dropdown boxes populated from a database](https://forum.inductiveautomation.com/t/bug-dropdown-boxes-populated-from-a-database/17861)
**Author:** [@Stuart](https://forum.inductiveautomation.com/u/Stuart)\ **Replies:** 2\ **Last updated:** [April 30, 2018, 3:11pm UTC](https://forum.inductiveautomation.com/t/bug-dropdown-boxes-populated-from-a-database/17861 "2018-04-30T15:11:40Z")
I encountered a problem populating my dropdown boxes from my database. I created a dropdown box and gave it this query: SELECT pmkSupplier, supplierName FROM supplier ORDER BY supplierName ASC Works great. If I c… --- ## [Indirect tags in SFC transitions](https://forum.inductiveautomation.com/t/indirect-tags-in-sfc-transitions/17858)
**Author:** [@jrd](https://forum.inductiveautomation.com/u/jrd)\ **Replies:** 1\ **Last updated:** [April 30, 2018, 2:46pm UTC](https://forum.inductiveautomation.com/t/indirect-tags-in-sfc-transitions/17858 "2018-04-30T14:46:35Z")
Hi I am having difficulty in using indirect tags in SFC transitions. I have an SFC with Key Parameter "Tank", value 1-18. I have corresponding Tags : "Tank\_n\_HighLevel" What is the correct format for representing these… --- ## [Out Of Hours SMS Alarm Notification](https://forum.inductiveautomation.com/t/out-of-hours-sms-alarm-notification/17865)
**Author:** [@Dodonnell999](https://forum.inductiveautomation.com/u/Dodonnell999)\ **Replies:** 0\ **Last updated:** [April 30, 2018, 1:46pm UTC](https://forum.inductiveautomation.com/t/out-of-hours-sms-alarm-notification/17865 "2018-04-30T13:46:27Z")
We have a system where all medium priority alarms are only sent via sms between the hours of 08:00 and 17:00, outside of these hours the alarms are only sent via email. This is currently working fine. Our customer now wa… --- ## [Modbus query out of range from the Modbus Adresse](https://forum.inductiveautomation.com/t/modbus-query-out-of-range-from-the-modbus-adresse/17813)
**Author:** [@olivier.dekoster](https://forum.inductiveautomation.com/u/olivier.dekoster)\ **Replies:** 5\ **Last updated:** [April 30, 2018, 11:51am UTC](https://forum.inductiveautomation.com/t/modbus-query-out-of-range-from-the-modbus-adresse/17813 "2018-04-30T11:51:09Z")
Hello for all, I communicate between our PLC and the Gateway in Modbus TCP. I'm working with ignition 7.9.7 I have had a Device Modbus TCP with those adresses below 10 NUM\_8\_,4000,4255,false,0,InputRegister,4000 NUM\_… --- ## [Table with tag float](https://forum.inductiveautomation.com/t/table-with-tag-float/17857)
**Author:** [@maynor.martinez](https://forum.inductiveautomation.com/u/maynor.martinez)\ **Replies:** 1\ **Last updated:** [April 28, 2018, 6:03pm UTC](https://forum.inductiveautomation.com/t/table-with-tag-float/17857 "2018-04-28T18:03:33Z")
How can I create a table where I have 3 columns but the third column shows the values ​​of a tag directly? Name Site KW TG 01 offices tag 1 TG 02 … --- ## [Tag Event Scripts vs Gateway Tag Change Scripts](https://forum.inductiveautomation.com/t/tag-event-scripts-vs-gateway-tag-change-scripts/14098)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 10\ **Last updated:** [April 27, 2018, 6:09pm UTC](https://forum.inductiveautomation.com/t/tag-event-scripts-vs-gateway-tag-change-scripts/14098 "2018-04-27T18:09:43Z")
Hi all, Just looking for some advice/ recommendations about which script handle to use for doing an action on a Tag Change event. At this stage, I am trying to run a SQL query when a boolean tag value goes True. T… --- ## [Disable Alarm when byte tag value is 0](https://forum.inductiveautomation.com/t/disable-alarm-when-byte-tag-value-is-0/17853)
**Author:** [@alexis.aldrete](https://forum.inductiveautomation.com/u/alexis.aldrete)\ **Replies:** 0\ **Last updated:** [April 27, 2018, 5:47pm UTC](https://forum.inductiveautomation.com/t/disable-alarm-when-byte-tag-value-is-0/17853 "2018-04-27T17:47:49Z")
I have an alarm that I want to enable only if byte tag value is equal to 0. Can someone tell me how to put that in the enable section of the alarm in code. Thanks! --- ## [Unable to run Module classes under gateway event scripts](https://forum.inductiveautomation.com/t/unable-to-run-module-classes-under-gateway-event-scripts/17850)
**Author:** [@patrick.garceau](https://forum.inductiveautomation.com/u/patrick.garceau)\ **Replies:** 10\ **Last updated:** [April 27, 2018, 5:25pm UTC](https://forum.inductiveautomation.com/t/unable-to-run-module-classes-under-gateway-event-scripts/17850 "2018-04-27T17:25:20Z")
How come I am able to run scripts under Tools/Scrip Console but I cannot run the same script under the Gateway Event Scripts It starts with an import and I have put a system.write.tags after the import to see if it wro… --- ## [Auditing Setpoint Changes](https://forum.inductiveautomation.com/t/auditing-setpoint-changes/17844)
**Author:** [@mbhagotra](https://forum.inductiveautomation.com/u/mbhagotra)\ **Replies:** 1\ **Last updated:** [April 26, 2018, 10:28pm UTC](https://forum.inductiveautomation.com/t/auditing-setpoint-changes/17844 "2018-04-26T22:28:11Z")
Hello all, I'm wondering if it was possible for Ignition's built-in auditing tool to store a setpoint's old value when it is changed? I see that it only stores the new value in the database at the moment. I like the… --- ## [AutoSave Report to database?](https://forum.inductiveautomation.com/t/autosave-report-to-database/17841)
**Author:** [@kmlhan](https://forum.inductiveautomation.com/u/kmlhan)\ **Replies:** 1\ **Last updated:** [April 26, 2018, 8:12pm UTC](https://forum.inductiveautomation.com/t/autosave-report-to-database/17841 "2018-04-26T20:12:33Z")
I would like to autosave a report to a database to be read back later from various clients. This code works great but its save as a PDF on the gateway. d=system.tag.read("Kiln1/StartUp/K1 ChargeNum") path="StartUp\_K… --- ## [Gateway Event Timer Script Error](https://forum.inductiveautomation.com/t/gateway-event-timer-script-error/17820)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 7\ **Last updated:** [April 26, 2018, 12:39pm UTC](https://forum.inductiveautomation.com/t/gateway-event-timer-script-error/17820 "2018-04-26T12:39:34Z")
I have a Gateway Timer Script set to run every 20 seconds. In the Gateway Scripts page on the Gateway, the script shows up as an Error for about 3-5 seconds and then reverts to Success. It says Success for most of the ti… --- ## [Simplest way to send a tag value to another gateway](https://forum.inductiveautomation.com/t/simplest-way-to-send-a-tag-value-to-another-gateway/17832)
**Author:** [@Vince](https://forum.inductiveautomation.com/u/Vince)\ **Replies:** 6\ **Last updated:** [April 26, 2018, 11:30am UTC](https://forum.inductiveautomation.com/t/simplest-way-to-send-a-tag-value-to-another-gateway/17832 "2018-04-26T11:30:29Z")
Everything is in the title! What is the simplest way to send a tag value from a gateway to another., Thanks. --- ## [Image rotation point](https://forum.inductiveautomation.com/t/image-rotation-point/17812)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 1\ **Last updated:** [April 25, 2018, 10:30pm UTC](https://forum.inductiveautomation.com/t/image-rotation-point/17812 "2018-04-25T22:30:37Z")
Hi All, I was wondering if there is a chance to rotate an image around a certain point ( not the default center point ). I mean, for a rectangle you can choose the rotation point ( double click the rectangle and move t… --- ## [GE PLCs only provide Diagnostics when connected to OPCUA](https://forum.inductiveautomation.com/t/ge-plcs-only-provide-diagnostics-when-connected-to-opcua/17776)
**Author:** [@NHOutbacker](https://forum.inductiveautomation.com/u/NHOutbacker)\ **Replies:** 14\ **Last updated:** [April 25, 2018, 9:09pm UTC](https://forum.inductiveautomation.com/t/ge-plcs-only-provide-diagnostics-when-connected-to-opcua/17776 "2018-04-25T21:09:46Z")
I am evaluating Ignition for use with GE PLCs of various types (90-30, 90-70, 90-90, R3xi, etc). When I set up the device in the Gateway Configuration, it shows "Connected". I am using the Modbus TCP driver and have e… --- ## [Anyone could kindly show me how to setup my alarm notification via local computer speakers? thank you?](https://forum.inductiveautomation.com/t/anyone-could-kindly-show-me-how-to-setup-my-alarm-notification-via-local-computer-speakers-thank-you/17833)
**Author:** [@phisal](https://forum.inductiveautomation.com/u/phisal)\ **Replies:** 0\ **Last updated:** [April 25, 2018, 7:41pm UTC](https://forum.inductiveautomation.com/t/anyone-could-kindly-show-me-how-to-setup-my-alarm-notification-via-local-computer-speakers-thank-you/17833 "2018-04-25T19:41:11Z")
anyone could kindly show me how to setup my alarm notification via local computer speakers? thank you? [Previous page](https://forum.inductiveautomation.com/latest.md?page=1640) [Next page](https://forum.inductiveautomation.com/latest.md?page=1642)