# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1373 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1374 --- ## [Bulk Insert csv into sql](https://forum.inductiveautomation.com/t/bulk-insert-csv-into-sql/18276)
**Author:** [@bwagner](https://forum.inductiveautomation.com/u/bwagner)\ **Replies:** 13\ **Last updated:** [June 4, 2018, 6:27pm UTC](https://forum.inductiveautomation.com/t/bulk-insert-csv-into-sql/18276 "2018-06-04T18:27:28Z")
I'm trying to bulk insert a csv file. I am using a timed gateway script. Below is the code, and the error I am getting. Any help is appreciated. inputPath = 'C:/IgniteFTP/ScheduleData/' for fname in os.listdir(inputP… --- ## [Unlicensed Ignition Web Browser module](https://forum.inductiveautomation.com/t/unlicensed-ignition-web-browser-module/18282)
**Author:** [@jordan.richardson](https://forum.inductiveautomation.com/u/jordan.richardson)\ **Replies:** 1\ **Last updated:** [June 4, 2018, 4:54pm UTC](https://forum.inductiveautomation.com/t/unlicensed-ignition-web-browser-module/18282 "2018-06-04T16:54:05Z")
I have downloaded the web browser module and am currently running it in trial mode. All is well inside of the designer, I can add pages, URLS, HTML, etc and preview it just fine. However, when I publish my project and op… --- ## [Recursive scan for leaf nodes on selected treeview parent nodes](https://forum.inductiveautomation.com/t/recursive-scan-for-leaf-nodes-on-selected-treeview-parent-nodes/18164)
**Author:** [@benjamin.f.mcneill](https://forum.inductiveautomation.com/u/benjamin.f.mcneill)\ **Replies:** 2\ **Last updated:** [June 4, 2018, 3:46pm UTC](https://forum.inductiveautomation.com/t/recursive-scan-for-leaf-nodes-on-selected-treeview-parent-nodes/18164 "2018-06-04T15:46:13Z")
Hello, I have a treeview populated from a sql query that is only two layers deep. I have the ability to pass a multiselection to a querie's where clause but I am not able to get the children of a parent node. Do I ne… --- ## [Embedded Images in Report](https://forum.inductiveautomation.com/t/embedded-images-in-report/18150)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 3\ **Last updated:** [June 4, 2018, 3:28pm UTC](https://forum.inductiveautomation.com/t/embedded-images-in-report/18150 "2018-06-04T15:28:50Z")
Hello all, I am looking for some guidance in creating a report filled with BMP files from a folder on my gateway. These are vision system quality images that I want to appear in sequential order. I have read that this … --- ## [Tag Change Script printing too many copies](https://forum.inductiveautomation.com/t/tag-change-script-printing-too-many-copies/18277)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 1\ **Last updated:** [June 4, 2018, 3:07pm UTC](https://forum.inductiveautomation.com/t/tag-change-script-printing-too-many-copies/18277 "2018-06-04T15:07:59Z")
I’m trying to print to a computer currently, but I’m getting too many copies(2-4 as opposed to just one). I think it has something to do with the boolean condition being true for too long and the script getting triggered… --- ## [Report Designer bar chart](https://forum.inductiveautomation.com/t/report-designer-bar-chart/18100)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 5\ **Last updated:** [June 4, 2018, 2:22pm UTC](https://forum.inductiveautomation.com/t/report-designer-bar-chart/18100 "2018-06-04T14:22:37Z")
How do you get the data to populate in the bar chart? --- ## [System.gui.messageBox and System.gui.confirm issue](https://forum.inductiveautomation.com/t/system-gui-messagebox-and-system-gui-confirm-issue/18269)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 10\ **Last updated:** [June 3, 2018, 4:59pm UTC](https://forum.inductiveautomation.com/t/system-gui-messagebox-and-system-gui-confirm-issue/18269 "2018-06-03T16:59:59Z")
When I added System.gui.messageBox to my code it continues to pop up even if you try to close it out. Like it is in a loop. Also wondring how to get the confirmation from System.gui.Confirm to complete the code. --- ## [Java Heap Size Issue](https://forum.inductiveautomation.com/t/java-heap-size-issue/18209)
**Author:** [@1jeffwill11](https://forum.inductiveautomation.com/u/1jeffwill11)\ **Replies:** 25\ **Last updated:** [June 2, 2018, 12:24am UTC](https://forum.inductiveautomation.com/t/java-heap-size-issue/18209 "2018-06-02T00:24:14Z")
When starting the Ignition Gateway as a service, I kept running into a problem where the Java heap size on the JVM was too large and the service would crash and fail to start. I was able to work around this by editing th… --- ## [Carriage Return/Line Feed in string tags](https://forum.inductiveautomation.com/t/carriage-return-line-feed-in-string-tags/18262)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 8\ **Last updated:** [June 1, 2018, 9:15pm UTC](https://forum.inductiveautomation.com/t/carriage-return-line-feed-in-string-tags/18262 "2018-06-01T21:15:41Z")
I’ve building a string using python then writing that string into a string tag. In building the string I am attempting to add line feeds/carriage returns using the ‘\\r\\n’ escape characters. What I actually see in the s… --- ## [How to force client update](https://forum.inductiveautomation.com/t/how-to-force-client-update/9922)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 9\ **Last updated:** [June 1, 2018, 8:57pm UTC](https://forum.inductiveautomation.com/t/how-to-force-client-update/9922 "2018-06-01T20:57:04Z")
I have 2 ignition vision client on the same PC with 2 monitor. Some client’s interactions are made with message handler (7.7 feature :slight\_smile: ) When I publish a modification, I have the “Project update available… --- ## [Problem with opaque rootContainer](https://forum.inductiveautomation.com/t/problem-with-opaque-rootcontainer/11788)
**Author:** [@Esn](https://forum.inductiveautomation.com/u/Esn)\ **Replies:** 4\ **Last updated:** [June 1, 2018, 7:25pm UTC](https://forum.inductiveautomation.com/t/problem-with-opaque-rootcontainer/11788 "2018-06-01T19:25:25Z")
Hi, When I check opaque off for a rootContainer the background remains visible. Is this a feature for the rootContainer or am I doing something wrong? Thanks --- ## [How to change the upper and lower bounds of the x-y graph or time series graph](https://forum.inductiveautomation.com/t/how-to-change-the-upper-and-lower-bounds-of-the-x-y-graph-or-time-series-graph/18263)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 1\ **Last updated:** [June 1, 2018, 5:08pm UTC](https://forum.inductiveautomation.com/t/how-to-change-the-upper-and-lower-bounds-of-the-x-y-graph-or-time-series-graph/18263 "2018-06-01T17:08:47Z")
I want to use start and end times that I've gotten from data and use those as the bounds on the x-axis for a graph on a report. How can I do this? when i try to change the bounds in the time series chart, it won't let me… --- ## [Hyper SQL stored procedure doesn't return result set](https://forum.inductiveautomation.com/t/hyper-sql-stored-procedure-doesnt-return-result-set/18251)
**Author:** [@douglas.roberts](https://forum.inductiveautomation.com/u/douglas.roberts)\ **Replies:** 5\ **Last updated:** [June 1, 2018, 3:25pm UTC](https://forum.inductiveautomation.com/t/hyper-sql-stored-procedure-doesnt-return-result-set/18251 "2018-06-01T15:25:10Z")
I'm trying to call a stored procedure in Hyper SQL by using createSProcCall and execSProcCall. However, no result set is returned. The stored procedure works outside of Ignition though. Hyper SQL uses a cursor to retur… --- ## [License Activation / Unactivation Via Command Line](https://forum.inductiveautomation.com/t/license-activation-unactivation-via-command-line/18261)
**Author:** [@jkiffer](https://forum.inductiveautomation.com/u/jkiffer)\ **Replies:** 0\ **Last updated:** [June 1, 2018, 2:59pm UTC](https://forum.inductiveautomation.com/t/license-activation-unactivation-via-command-line/18261 "2018-06-01T14:59:25Z")
Is there a way to perform "online" unactivation and activation Ignition license from the command line? I know it's possible with gwcmd.sh, but this is offline. Looking to upgrade a modest number of gateways from 7.7.7… --- ## [Web Browser Component - Project Freezing](https://forum.inductiveautomation.com/t/web-browser-component-project-freezing/18243)
**Author:** [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Replies:** 4\ **Last updated:** [June 1, 2018, 2:38pm UTC](https://forum.inductiveautomation.com/t/web-browser-component-project-freezing/18243 "2018-06-01T14:38:45Z")
I have an Office Overview project that’s essentially a Kiosk display. It has a list of windows that it swaps between, each with it’s own number of seconds to display for. I have a client timer script that checks the elap… --- ## [Evaluation Errors in my dateTime tags and my Expression Tag](https://forum.inductiveautomation.com/t/evaluation-errors-in-my-datetime-tags-and-my-expression-tag/18248)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 6\ **Last updated:** [June 1, 2018, 2:23pm UTC](https://forum.inductiveautomation.com/t/evaluation-errors-in-my-datetime-tags-and-my-expression-tag/18248 "2018-06-01T14:23:02Z")
I’m having problems getting the correct output/value for these tags and I am also getting an evaluation error in the quality for my tags. Note that I made the return values for the if statements the same just to test if … --- ## [High CPU usage by Netty / OpcUa](https://forum.inductiveautomation.com/t/high-cpu-usage-by-netty-opcua/18257)
**Author:** [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Replies:** 0\ **Last updated:** [June 1, 2018, 6:36am UTC](https://forum.inductiveautomation.com/t/high-cpu-usage-by-netty-opcua/18257 "2018-06-01T06:36:06Z")
We’re having some issues where the CPU suddenly rises to 50% or even 100% on our Ignition server. When the OPC Server module is restarted, the CPU usage drops back to single-digit numbers, for a few hours. And then it g… --- ## [Open62541 client to Ignition?](https://forum.inductiveautomation.com/t/open62541-client-to-ignition/18252)
**Author:** [@JoeJansen](https://forum.inductiveautomation.com/u/JoeJansen)\ **Replies:** 1\ **Last updated:** [June 1, 2018, 12:24am UTC](https://forum.inductiveautomation.com/t/open62541-client-to-ignition/18252 "2018-06-01T00:24:57Z")
I have a logger I'm experimenting with / putting together that runs the open62541 client. I'd like to connect to the Ignition OPC-UA server so I can nab a couple tags from the PLC and log the data changes. I want to d… --- ## [Time.sleep function in Ignition](https://forum.inductiveautomation.com/t/time-sleep-function-in-ignition/10337)
**Author:** [@dlaki](https://forum.inductiveautomation.com/u/dlaki)\ **Replies:** 17\ **Last updated:** [June 1, 2018, 12:02am UTC](https://forum.inductiveautomation.com/t/time-sleep-function-in-ignition/10337 "2018-06-01T00:02:21Z")
Hi All, Anyone here have tried to to use time.sleep function of time module in Ignition? I tried to use this function but the result is not what I wanted. Below is my sample script: import time for i in range(1, … --- ## [Tag values not changing correctly in response to input](https://forum.inductiveautomation.com/t/tag-values-not-changing-correctly-in-response-to-input/18158)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 9\ **Last updated:** [May 31, 2018, 11:27pm UTC](https://forum.inductiveautomation.com/t/tag-values-not-changing-correctly-in-response-to-input/18158 "2018-05-31T23:27:54Z")
I’m currently having an issue where it seems that when I turn certain switches on the MicroLogix PLC from off to on or when I press certain pushbuttons, the inputs do not change correctly. For example, in this image, whe… --- ## [Pie Chart SQL Query](https://forum.inductiveautomation.com/t/pie-chart-sql-query/18231)
**Author:** [@ndutra](https://forum.inductiveautomation.com/u/ndutra)\ **Replies:** 9\ **Last updated:** [May 31, 2018, 9:20pm UTC](https://forum.inductiveautomation.com/t/pie-chart-sql-query/18231 "2018-05-31T21:20:45Z")
What I am trying to accomplish is sum each column value and filter based on the date range picker value, also exclude any columns that sum a 0 value (so the pie chart does not show many legend items that have no value). … --- ## [Table query ok button issue](https://forum.inductiveautomation.com/t/table-query-ok-button-issue/18145)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 2\ **Last updated:** [May 31, 2018, 6:17pm UTC](https://forum.inductiveautomation.com/t/table-query-ok-button-issue/18145 "2018-05-31T18:17:13Z")
Ignition 7.9.7 Java 8 Update 171 64 bits Hi, I have an issue when I get data from mysql to a table. When I put the query and push the ok button all works just fine, but when I close the windows and save is when the pro… --- ## [OSUsername from other Open Clients?](https://forum.inductiveautomation.com/t/osusername-from-other-open-clients/18204)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 1\ **Last updated:** [May 31, 2018, 5:30pm UTC](https://forum.inductiveautomation.com/t/osusername-from-other-open-clients/18204 "2018-05-31T17:30:40Z")
Anyway to get OSUsernames from the other open clients? I am currently using getSessionInfo() to see Project names and Addresses. Maybe I can do some sort of Message Handler where the other clients report back their OSUse… --- ## [How to Create and configure a New Pipeline By Script](https://forum.inductiveautomation.com/t/how-to-create-and-configure-a-new-pipeline-by-script/18219)
**Author:** [@prevostb](https://forum.inductiveautomation.com/u/prevostb)\ **Replies:** 2\ **Last updated:** [May 31, 2018, 4:57pm UTC](https://forum.inductiveautomation.com/t/how-to-create-and-configure-a-new-pipeline-by-script/18219 "2018-05-31T16:57:49Z")
Hello guys, Does anyone know how can I create a Pipeline Using Script? Then after, still with a script, to add a Script block inside? --- ## [Problems scripting a button to save a file](https://forum.inductiveautomation.com/t/problems-scripting-a-button-to-save-a-file/18247)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 5\ **Last updated:** [May 31, 2018, 4:07pm UTC](https://forum.inductiveautomation.com/t/problems-scripting-a-button-to-save-a-file/18247 "2018-05-31T16:07:16Z")
I am having issues saving a file via pressing a button. My script is below. I am not receiving an error in my logs, but I don’t see the file in the path where it’s supposed to be. --- ## [OPC Tag in Transaction does not update even though the tag browser changing](https://forum.inductiveautomation.com/t/opc-tag-in-transaction-does-not-update-even-though-the-tag-browser-changing/16709)
**Author:** [@trishhiyah](https://forum.inductiveautomation.com/u/trishhiyah)\ **Replies:** 9\ **Last updated:** [May 31, 2018, 3:29pm UTC](https://forum.inductiveautomation.com/t/opc-tag-in-transaction-does-not-update-even-though-the-tag-browser-changing/16709 "2018-05-31T15:29:20Z")
Hi We are encountering that the OPC Tag in Transaction Group does not update. In the tag browser state = 3 while in the transaction group tag State = 1 It has the same location and the execution scheduling timer is 1… --- ## [Switch user problem](https://forum.inductiveautomation.com/t/switch-user-problem/18210)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 1\ **Last updated:** [May 31, 2018, 2:52pm UTC](https://forum.inductiveautomation.com/t/switch-user-problem/18210 "2018-05-31T14:52:50Z")
hello all, i need help with the following. i have a window that lets supervisor would be using. the window is to create a pallet. so supervisor has access to change the the default information, and to select lots, from… --- ## [INFO: Handling users external SQL database](https://forum.inductiveautomation.com/t/info-handling-users-external-sql-database/18237)
**Author:** [@n.meluccio](https://forum.inductiveautomation.com/u/n.meluccio)\ **Replies:** 1\ **Last updated:** [May 31, 2018, 1:57pm UTC](https://forum.inductiveautomation.com/t/info-handling-users-external-sql-database/18237 "2018-05-31T13:57:03Z")
Hello sirs, i would like to ask some detailed information about External User Database. I'm using a custom sql table containing additional columns such as nation, gender, usercode, image and i would like to know how i … --- ## [All Tag on unknow quality](https://forum.inductiveautomation.com/t/all-tag-on-unknow-quality/18215)
**Author:** [@automatisme.iton](https://forum.inductiveautomation.com/u/automatisme.iton)\ **Replies:** 2\ **Last updated:** [May 31, 2018, 12:04pm UTC](https://forum.inductiveautomation.com/t/all-tag-on-unknow-quality/18215 "2018-05-31T12:04:38Z")
All my tag have unknown quality if i check on opc connection status are connected , device status are connected. on the log i only have Some one can help me to solve this ? --- ## [Bug? Can't change sql query / binding on table for any table](https://forum.inductiveautomation.com/t/bug-cant-change-sql-query-binding-on-table-for-any-table/18216)
**Author:** [@mcarritt1](https://forum.inductiveautomation.com/u/mcarritt1)\ **Replies:** 4\ **Last updated:** [May 31, 2018, 6:22am UTC](https://forum.inductiveautomation.com/t/bug-cant-change-sql-query-binding-on-table-for-any-table/18216 "2018-05-31T06:22:46Z")
This problem keeps happening everywhere in my application. I'll set up a table with a SQL query, and then later am unable to change it whatsoever, or even remove it by selecting "no binding". In fact, editing the table d… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1372) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1374)