# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1653 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1654 --- ## [Gateway script error in LOAD DATA query from a csv file](https://forum.inductiveautomation.com/t/gateway-script-error-in-load-data-query-from-a-csv-file/17162)
**Author:** [@prithvidesai](https://forum.inductiveautomation.com/u/prithvidesai)\ **Replies:** 1\ **Last updated:** [February 28, 2018, 6:23pm UTC](https://forum.inductiveautomation.com/t/gateway-script-error-in-load-data-query-from-a-csv-file/17162 "2018-02-28T18:23:03Z")
I am trying to load data from a csv file in to MySQL table using gateway script. This was working fine until I added OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' to remove " characters from some of the fields. PFB code line… --- ## [Access Components jythonCode in Script](https://forum.inductiveautomation.com/t/access-components-jythoncode-in-script/17166)
**Author:** [@Malcolm](https://forum.inductiveautomation.com/u/Malcolm)\ **Replies:** 2\ **Last updated:** [February 28, 2018, 3:53pm UTC](https://forum.inductiveautomation.com/t/access-components-jythoncode-in-script/17166 "2018-02-28T15:53:48Z")
Is there a way to access the script behind a component on a windows and retrieve it into say a string. I am upgrading an older project and have multiple menu screens driven by individual buttons which I am improving t… --- ## [Table - Indirect Tag / Cell update](https://forum.inductiveautomation.com/t/table-indirect-tag-cell-update/17133)
**Author:** [@mohammed.omar](https://forum.inductiveautomation.com/u/mohammed.omar)\ **Replies:** 4\ **Last updated:** [February 28, 2018, 3:12pm UTC](https://forum.inductiveautomation.com/t/table-indirect-tag-cell-update/17133 "2018-02-28T15:12:03Z")
Hi, I would like to know if there is a solution to below; I am currently using 7.5v Here I have the Readings which are restricted to one site, I want whenever I select a site using dropdown I want the readings to chang… --- ## [Having a condition then perform runscript](https://forum.inductiveautomation.com/t/having-a-condition-then-perform-runscript/17163)
**Author:** [@Mel](https://forum.inductiveautomation.com/u/Mel)\ **Replies:** 1\ **Last updated:** [February 28, 2018, 2:57am UTC](https://forum.inductiveautomation.com/t/having-a-condition-then-perform-runscript/17163 "2018-02-28T02:57:45Z")
I am trying to create an if condition before the runscript will be execute. On my case I have two(2) tables and my aim is if there something changed on table 1 or something like property change event then my table 2 will… --- ## [ImportError: No module named abc](https://forum.inductiveautomation.com/t/importerror-no-module-named-abc/17150)
**Author:** [@liau.kwongweng](https://forum.inductiveautomation.com/u/liau.kwongweng)\ **Replies:** 3\ **Last updated:** [February 28, 2018, 2:25am UTC](https://forum.inductiveautomation.com/t/importerror-no-module-named-abc/17150 "2018-02-28T02:25:20Z")
Greetings I created a library function and hope to reuse it But then i got this error. I search through and read through the forum posts and tried but still could not resolve it. Finally i just copy an existing file d… --- ## [Accessing tag values in Gateway Tag Change Script](https://forum.inductiveautomation.com/t/accessing-tag-values-in-gateway-tag-change-script/17159)
**Author:** [@andrew.brauer](https://forum.inductiveautomation.com/u/andrew.brauer)\ **Replies:** 4\ **Last updated:** [February 27, 2018, 10:17pm UTC](https://forum.inductiveautomation.com/t/accessing-tag-values-in-gateway-tag-change-script/17159 "2018-02-27T22:17:19Z")
I am new to Ignition. I have been unable to find an example to help. I have created a Gateway Tag Change Script, this script has 5 tags defined for the change event. In the body of the script I want to compare the tag… --- ## [Timer as stop watch Question](https://forum.inductiveautomation.com/t/timer-as-stop-watch-question/17156)
**Author:** [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Replies:** 4\ **Last updated:** [February 27, 2018, 5:33pm UTC](https://forum.inductiveautomation.com/t/timer-as-stop-watch-question/17156 "2018-02-27T17:33:42Z")
Good Day all, most may think this a trivial effort but it is one I would like to solve. I have a Timer, 1 textbox which displays the running state of the timer. 2 numeric textboxes, and a button. One numeric textbox is… --- ## [Is there a way to reduce delay between database reading/writing?](https://forum.inductiveautomation.com/t/is-there-a-way-to-reduce-delay-between-database-reading-writing/17137)
**Author:** [@carolineuchoa.estuda](https://forum.inductiveautomation.com/u/carolineuchoa.estuda)\ **Replies:** 7\ **Last updated:** [February 27, 2018, 5:13pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-reduce-delay-between-database-reading-writing/17137 "2018-02-27T17:13:35Z")
So I have a system that sends information to Ignition via OPC-UA. I connected a MSSQL database to it, so that I could use realtime charts and stuff. But my problem is that the chart data writing is too delayed from the r… --- ## [Conversion to UNKNOWN in a query](https://forum.inductiveautomation.com/t/conversion-to-unknown-in-a-query/17155)
**Author:** [@patrick.garceau](https://forum.inductiveautomation.com/u/patrick.garceau)\ **Replies:** 1\ **Last updated:** [February 27, 2018, 4:02pm UTC](https://forum.inductiveautomation.com/t/conversion-to-unknown-in-a-query/17155 "2018-02-27T16:02:20Z")
Caused by: java.lang.Exception: Error executing system.db.runPrepUpdate(insert into aws\_log(tagpath,lasttime) Values(?,?), \[1\_i1-1\_i10/1\_i10, 1517461200000\], Ignition, , false, false) Caused by: com.inductiveautomation.i… --- ## [Unable to insert with a simple select statement](https://forum.inductiveautomation.com/t/unable-to-insert-with-a-simple-select-statement/17145)
**Author:** [@patrick.garceau](https://forum.inductiveautomation.com/u/patrick.garceau)\ **Replies:** 8\ **Last updated:** [February 27, 2018, 4:00pm UTC](https://forum.inductiveautomation.com/t/unable-to-insert-with-a-simple-select-statement/17145 "2018-02-27T16:00:31Z")
Code is databaseConnection = "Ignition" Insert missing tags from database sqlString = """ insert into aws\_log(tagpath,lasttime) select distinct tagpath , (select MIN(start\_time) from sqlth\_partitions) from dbo.sq… --- ## [Getting a tag path from another bound property](https://forum.inductiveautomation.com/t/getting-a-tag-path-from-another-bound-property/17152)
**Author:** [@mcarritt1](https://forum.inductiveautomation.com/u/mcarritt1)\ **Replies:** 1\ **Last updated:** [February 27, 2018, 1:26pm UTC](https://forum.inductiveautomation.com/t/getting-a-tag-path-from-another-bound-property/17152 "2018-02-27T13:26:59Z")
Hi! Is there a way to grab the tag path from another component, and use that in an expression or indirect tag binding? --- ## [DB Query adjustments](https://forum.inductiveautomation.com/t/db-query-adjustments/17096)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 12\ **Last updated:** [February 27, 2018, 3:40am UTC](https://forum.inductiveautomation.com/t/db-query-adjustments/17096 "2018-02-27T03:40:32Z")
My database gets a running "runtime hours" value from our PLCs in the field every morning. I use a query in an expression tag to, every morning, take the last written record for these runtimes and subtract the previous d… --- ## [Ubuntu fullscreen display on 2nd monitor](https://forum.inductiveautomation.com/t/ubuntu-fullscreen-display-on-2nd-monitor/17103)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 6\ **Last updated:** [February 27, 2018, 1:38am UTC](https://forum.inductiveautomation.com/t/ubuntu-fullscreen-display-on-2nd-monitor/17103 "2018-02-27T01:38:00Z")
I'm using system.gui.opendesktop to open a window on a second monitor. It does not open in full screen. Unity Menu Bar is displayed at the top. This is a dedicated HMI and we don't want operators having access to menubar… --- ## [Report key calculation on boolean](https://forum.inductiveautomation.com/t/report-key-calculation-on-boolean/17123)
**Author:** [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Replies:** 7\ **Last updated:** [February 26, 2018, 9:25pm UTC](https://forum.inductiveautomation.com/t/report-key-calculation-on-boolean/17123 "2018-02-26T21:25:35Z")
I'm having trouble with a key calculation in a table on a boolean value. I'm trying to replace the simple true/false word that comes into the simple table cell from the database query with just an "ON" for true and blan… --- ## [Scripting component Angle (angleDegrees)](https://forum.inductiveautomation.com/t/scripting-component-angle-angledegrees/17140)
**Author:** [@adampainter](https://forum.inductiveautomation.com/u/adampainter)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 5:20pm UTC](https://forum.inductiveautomation.com/t/scripting-component-angle-angledegrees/17140 "2018-02-26T17:20:07Z")
Are there any known issues with setting a component's angleDegrees (or angleRadians) properties? When executing the statements: popup = system.gui.getWindow(event.source.parent.popupWindowPath) for param in taskParam… --- ## [Problem with keyboard in mobile project](https://forum.inductiveautomation.com/t/problem-with-keyboard-in-mobile-project/17138)
**Author:** [@Juank\_Chavarria](https://forum.inductiveautomation.com/u/Juank_Chavarria)\ **Replies:** 0\ **Last updated:** [February 26, 2018, 3:01pm UTC](https://forum.inductiveautomation.com/t/problem-with-keyboard-in-mobile-project/17138 "2018-02-26T15:01:22Z")
Hello, we have a problem with the keyboard that mobile applications use, this keyboard is not the one usually brought by phones, so it has almost no functionality and is a little ugly, some way to disable it and allow th… --- ## [Tags used in a page](https://forum.inductiveautomation.com/t/tags-used-in-a-page/17134)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [February 26, 2018, 2:53pm UTC](https://forum.inductiveautomation.com/t/tags-used-in-a-page/17134 "2018-02-26T14:53:07Z")
Hallo, is there a way to dump to a file the list of tags which are used in a page? I thought I could find the whole list in the file you create with the "Export ..." command, but it's practically a binary file. Thanks … --- ## [Displaying Date events within a window](https://forum.inductiveautomation.com/t/displaying-date-events-within-a-window/17119)
**Author:** [@franklepkowski](https://forum.inductiveautomation.com/u/franklepkowski)\ **Replies:** 0\ **Last updated:** [February 24, 2018, 1:36am UTC](https://forum.inductiveautomation.com/t/displaying-date-events-within-a-window/17119 "2018-02-24T01:36:21Z")
I have a handful of UDT instances that contain a tag that is of type date. The values of these dates can be anywhere from now to into the future. The tags are not currently being historized in any way. I am looking for a… --- ## [Switching user to another User source](https://forum.inductiveautomation.com/t/switching-user-to-another-user-source/17051)
**Author:** [@dan.kobus](https://forum.inductiveautomation.com/u/dan.kobus)\ **Replies:** 1\ **Last updated:** [February 23, 2018, 9:30pm UTC](https://forum.inductiveautomation.com/t/switching-user-to-another-user-source/17051 "2018-02-23T21:30:37Z")
is there a way to use the system.security.switchUser function to switch to a user in another user source. i am currently using the default user source with a generic user to auto-login to the application, but there is… --- ## [Global Scripts for Tag Usage?](https://forum.inductiveautomation.com/t/global-scripts-for-tag-usage/17115)
**Author:** [@lshirley](https://forum.inductiveautomation.com/u/lshirley)\ **Replies:** 17\ **Last updated:** [February 23, 2018, 7:51pm UTC](https://forum.inductiveautomation.com/t/global-scripts-for-tag-usage/17115 "2018-02-23T19:51:05Z")
Hello, Is there like a global script location that tags CAN access? I have like 10 tags that all do the same thing, just from different TCP drivers. It's several pages of code in each tag that's duplicate (using vari… --- ## [OPC Tag - Clear Value](https://forum.inductiveautomation.com/t/opc-tag-clear-value/17095)
**Author:** [@lshirley](https://forum.inductiveautomation.com/u/lshirley)\ **Replies:** 6\ **Last updated:** [February 23, 2018, 6:21pm UTC](https://forum.inductiveautomation.com/t/opc-tag-clear-value/17095 "2018-02-23T18:21:54Z")
Hello, I have OPC Tags (TCP Drivers) that add the incoming data into a MS SQL Table every time the Value Changed Tag Event fires. This works great 99% of the time. Sometimes, the value will get written to the databas… --- ## [Dynamic Unselected Backgroud Color for Alarm tab](https://forum.inductiveautomation.com/t/dynamic-unselected-backgroud-color-for-alarm-tab/16930)
**Author:** [@JM\_PEREZ](https://forum.inductiveautomation.com/u/JM_PEREZ)\ **Replies:** 4\ **Last updated:** [February 23, 2018, 5:40pm UTC](https://forum.inductiveautomation.com/t/dynamic-unselected-backgroud-color-for-alarm-tab/16930 "2018-02-23T17:40:16Z")
Hello, I want to assign the the Unselected Background Color of my Alarms tab to a custom property I called StatusColor. This custom property type is Color. StatusColor will change from grey to red in the presence of an… --- ## [Creating a default state for screen](https://forum.inductiveautomation.com/t/creating-a-default-state-for-screen/17091)
**Author:** [@stuart.williams](https://forum.inductiveautomation.com/u/stuart.williams)\ **Replies:** 3\ **Last updated:** [February 23, 2018, 5:26pm UTC](https://forum.inductiveautomation.com/t/creating-a-default-state-for-screen/17091 "2018-02-23T17:26:42Z")
I'm trying to create a default state for a screen and its components. I have an easy chart with x tags and a table set to a certain time range that's alterable by a date range slider. I know that any privileged user can … --- ## [Changing window's name without firing an "event"](https://forum.inductiveautomation.com/t/changing-windows-name-without-firing-an-event/17104)
**Author:** [@nimanamjouyan](https://forum.inductiveautomation.com/u/nimanamjouyan)\ **Replies:** 5\ **Last updated:** [February 23, 2018, 5:24pm UTC](https://forum.inductiveautomation.com/t/changing-windows-name-without-firing-an-event/17104 "2018-02-23T17:24:35Z")
Hi, I have been looking into changing the name of some windows based on some tag names. I can't seem to be able to access and change the window name in a binding to the tags and I have to write an script which involves… --- ## [How to use system.db.PrepUpdate query](https://forum.inductiveautomation.com/t/how-to-use-system-db-prepupdate-query/17110)
**Author:** [@tim.marbury](https://forum.inductiveautomation.com/u/tim.marbury)\ **Replies:** 13\ **Last updated:** [February 23, 2018, 5:21pm UTC](https://forum.inductiveautomation.com/t/how-to-use-system-db-prepupdate-query/17110 "2018-02-23T17:21:48Z")
I need help on a error that I'm getting when trying to run a query on at sql table and then update the data if it returns nothing. serialNumber = ('701000973') sqlString = "SELECT SerialNumber FROM SerialTracking WHERE… --- ## [System memory usage increase using CachePolicy=Auto](https://forum.inductiveautomation.com/t/system-memory-usage-increase-using-cachepolicy-auto/17112)
**Author:** [@stefano\_marengo](https://forum.inductiveautomation.com/u/stefano_marengo)\ **Replies:** 2\ **Last updated:** [February 23, 2018, 4:39pm UTC](https://forum.inductiveautomation.com/t/system-memory-usage-increase-using-cachepolicy-auto/17112 "2018-02-23T16:39:28Z")
The memory usage increase each time I open a popup windows using Cache Policy=Auto. The issue seem solved switching Cache Policy=Never. --- ## [Remote access according IEC62443 Architecture](https://forum.inductiveautomation.com/t/remote-access-according-iec62443-architecture/17099)
**Author:** [@Ivan\_a](https://forum.inductiveautomation.com/u/Ivan_a)\ **Replies:** 2\ **Last updated:** [February 23, 2018, 3:24pm UTC](https://forum.inductiveautomation.com/t/remote-access-according-iec62443-architecture/17099 "2018-02-23T15:24:50Z")
Hi According to Cybersecurity IEC62443, Remote Access shall be placed in a DMZ (Level 3.5), whereas SCADA system shall be on the control LAN (level 3) separated by firewall. Some SCADA systems have webserver separated fr… --- ## [Reinitialize windows a la system.security.switchUser?](https://forum.inductiveautomation.com/t/reinitialize-windows-a-la-system-security-switchuser/17102)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 1\ **Last updated:** [February 23, 2018, 4:31am UTC](https://forum.inductiveautomation.com/t/reinitialize-windows-a-la-system-security-switchuser/17102 "2018-02-23T04:31:20Z")
The system.security.switchUser function will close all of the windows and reopen them in their same state so that the new user's permissions take effect. Is there any way to do the close/reopen window sequence that this … --- ## [Is there a way to allow mouse clicks to pass to object beneath](https://forum.inductiveautomation.com/t/is-there-a-way-to-allow-mouse-clicks-to-pass-to-object-beneath/17093)
**Author:** [@dws2384](https://forum.inductiveautomation.com/u/dws2384)\ **Replies:** 1\ **Last updated:** [February 22, 2018, 10:50pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-allow-mouse-clicks-to-pass-to-object-beneath/17093 "2018-02-22T22:50:37Z")
I have some overlaying objects on top of a larger object. Is there a way that when clicking on these overlaying objects the event for the object beneath is executed. I know I can group them and put the code there but was… --- ## [Alarm Notification: Clear notify only contacts who were Active notified](https://forum.inductiveautomation.com/t/alarm-notification-clear-notify-only-contacts-who-were-active-notified/16391)
**Author:** [@cwells](https://forum.inductiveautomation.com/u/cwells)\ **Replies:** 1\ **Last updated:** [February 22, 2018, 10:43pm UTC](https://forum.inductiveautomation.com/t/alarm-notification-clear-notify-only-contacts-who-were-active-notified/16391 "2018-02-22T22:43:19Z")
Hello, My Active alarm pipeline goes through the roster notifying one contact at a time (using a non-zero Delay Between Messages and Direct Roster), with the Dropout Conditions as Acknowledged, Cleared, and Shelved. I … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1652) [Next page](https://forum.inductiveautomation.com/latest.md?page=1654)