# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1399 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1400 --- ## [How to export OPC DA data via OPC UA](https://forum.inductiveautomation.com/t/how-to-export-opc-da-data-via-opc-ua/16457)
**Author:** [@Apisit\_Chuencharoen](https://forum.inductiveautomation.com/u/Apisit_Chuencharoen)\ **Replies:** 1\ **Last updated:** [January 3, 2018, 3:41am UTC](https://forum.inductiveautomation.com/t/how-to-export-opc-da-data-via-opc-ua/16457 "2018-01-03T03:41:35Z")
Hello, Our Ignition server connect DCS OPC-DA server (OPC protocal). I created tags and logged tag history in Ignition designer. Can I use 3rd party OPC-UA client connect Ignition OPC-UA server and export Ignition tags… --- ## [Polling Purges Memory State of Selected Cell in PowerTable](https://forum.inductiveautomation.com/t/polling-purges-memory-state-of-selected-cell-in-powertable/16456)
**Author:** [@SpikerBrian](https://forum.inductiveautomation.com/u/SpikerBrian)\ **Replies:** 1\ **Last updated:** [January 3, 2018, 3:32am UTC](https://forum.inductiveautomation.com/t/polling-purges-memory-state-of-selected-cell-in-powertable/16456 "2018-01-03T03:32:39Z")
We have a Select Query within a Power Table, configured to Poll every 10 seconds. Therefore every 10 seconds, the cell selected by the user is no longer highlighted, because 'Selected Column' and 'Selected Row' both reve… --- ## [CompactLogix status switching in and out of Connected:Browse Pending](https://forum.inductiveautomation.com/t/compactlogix-status-switching-in-and-out-of-connected-browse-pending/16440)
**Author:** [@Nathan\_ICS](https://forum.inductiveautomation.com/u/Nathan_ICS)\ **Replies:** 5\ **Last updated:** [January 2, 2018, 7:21pm UTC](https://forum.inductiveautomation.com/t/compactlogix-status-switching-in-and-out-of-connected-browse-pending/16440 "2018-01-02T19:21:27Z")
We have a system with 4 CompactLogixs v20 and they keep changing from Connected: Protocol: EIP - Run Mode to Connected:Browse Pending then back. They are using the Legacy Allen-Bradley CompactLogix type and I have automa… --- ## [Change Chart Bar Colors based on tag](https://forum.inductiveautomation.com/t/change-chart-bar-colors-based-on-tag/16358)
**Author:** [@danewilbanks1](https://forum.inductiveautomation.com/u/danewilbanks1)\ **Replies:** 1\ **Last updated:** [January 2, 2018, 2:30pm UTC](https://forum.inductiveautomation.com/t/change-chart-bar-colors-based-on-tag/16358 "2018-01-02T14:30:59Z")
I'm trying to separate the visualization of shift data. For example one shift of Good, Bad, and Total Parts would have a set of colors. The second shift, a different set. I have a tag denoting Shift 1 or 2 that actually … --- ## [Ign v7.8.5 date format issue SOLVED](https://forum.inductiveautomation.com/t/ign-v7-8-5-date-format-issue-solved/16445)
**Author:** [@DwSoFt](https://forum.inductiveautomation.com/u/DwSoFt)\ **Replies:** 3\ **Last updated:** [January 2, 2018, 5:08am UTC](https://forum.inductiveautomation.com/t/ign-v7-8-5-date-format-issue-solved/16445 "2018-01-02T05:08:54Z")
I had a yesterdays date expression tag, that was grabbing date now, minus 1 day via the datearitmetic then using dateformat() to make it yyyyMMdd. beow is the expression: dateformat(dateArithmetic(now(), -1, "days"), "YY… --- ## [Calculate runtime percentage](https://forum.inductiveautomation.com/t/calculate-runtime-percentage/16393)
**Author:** [@bwagner](https://forum.inductiveautomation.com/u/bwagner)\ **Replies:** 2\ **Last updated:** [December 29, 2017, 6:31pm UTC](https://forum.inductiveautomation.com/t/calculate-runtime-percentage/16393 "2017-12-29T18:31:16Z")
I have a Boolean historical tag that is 1 when machine starts and 0 when it stops. I wanted to calculate the percentage of time that it is running over a certain time period. Anyone have any ideas how to calculate that? … --- ## [Mouse cursor through transparent templates](https://forum.inductiveautomation.com/t/mouse-cursor-through-transparent-templates/9291)
**Author:** [@jeffkrol](https://forum.inductiveautomation.com/u/jeffkrol)\ **Replies:** 3\ **Last updated:** [December 28, 2017, 8:42pm UTC](https://forum.inductiveautomation.com/t/mouse-cursor-through-transparent-templates/9291 "2017-12-28T20:42:20Z")
Howdy, I have some templates that have some objects in them, but also have a lot of empty (transparent) space. I have then taken those templates and layered them into a bigger template. I noticed something strange and … --- ## [Tags Path in Script](https://forum.inductiveautomation.com/t/tags-path-in-script/16431)
**Author:** [@lsauna40](https://forum.inductiveautomation.com/u/lsauna40)\ **Replies:** 3\ **Last updated:** [December 28, 2017, 2:18pm UTC](https://forum.inductiveautomation.com/t/tags-path-in-script/16431 "2017-12-28T14:18:28Z")
Hello everybody! Can i call one variables (tag) in script? How? And can i parametrizated that tag? For example i've one Live with 3 Extruders but in the future i choose to install and put the 4th Extruder. Can I chan… --- ## [Split Regex expression to get tag OPCItemPath 'Device' name](https://forum.inductiveautomation.com/t/split-regex-expression-to-get-tag-opcitempath-device-name/16425)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [December 27, 2017, 12:01pm UTC](https://forum.inductiveautomation.com/t/split-regex-expression-to-get-tag-opcitempath-device-name/16425 "2017-12-27T12:01:35Z")
Hi, I'm trying to write a regex in a split expression to pull the device (PLC) name from the OPCItemPath of a tag, but what I have seems to be pulling the inverse of what I'm expecting and what online resources tell me… --- ## [Getting Window Type](https://forum.inductiveautomation.com/t/getting-window-type/16421)
**Author:** [@jasoncoope](https://forum.inductiveautomation.com/u/jasoncoope)\ **Replies:** 2\ **Last updated:** [December 27, 2017, 12:48am UTC](https://forum.inductiveautomation.com/t/getting-window-type/16421 "2017-12-27T00:48:38Z")
Am calling system.gui.getWindows() to return a tuple of all project windows. Is there a way or a function call that will tell me the window type of each window i.e. Main Window, Docked Window or popup? Am trying to build… --- ## [Change the Value of tag using time slicing](https://forum.inductiveautomation.com/t/change-the-value-of-tag-using-time-slicing/16418)
**Author:** [@k.jain](https://forum.inductiveautomation.com/u/k.jain)\ **Replies:** 1\ **Last updated:** [December 26, 2017, 6:58pm UTC](https://forum.inductiveautomation.com/t/change-the-value-of-tag-using-time-slicing/16418 "2017-12-26T18:58:27Z")
Hello, I was wondering if there is a way of doing time slicing. I have a button and on action I want the current time saved in a memory tag and but clicking it again I want it to store the time stamp in another memory … --- ## [Easy Chart Database Pen UTC time to CST time](https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 2\ **Last updated:** [December 26, 2017, 4:33pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pen-utc-time-to-cst-time/16315 "2017-12-26T16:33:11Z")
Making an Easy chart, Have a Database Pen grabbing a cycle time Y Column, my Time Column is in UTC. So when you go to view the data, the newest data is "in the future" (CST is -6 hours UTC). Can I some how tell the Eas… --- ## [IF ,Select statement error](https://forum.inductiveautomation.com/t/if-select-statement-error/16388)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [December 23, 2017, 12:10pm UTC](https://forum.inductiveautomation.com/t/if-select-statement-error/16388 "2017-12-23T12:10:21Z")
I have this SQL query SELECT Allocation\_State FROM allocation\_state where ws\_cur\_mode={Root Container.Tabel1.AllocationSate\_F} IF ({Root Container.Dropdown.selectedValue}\>0) i received below error java.lang.Excep… --- ## [OPC UA custom model for devices](https://forum.inductiveautomation.com/t/opc-ua-custom-model-for-devices/14871)
**Author:** [@vinitkapoor](https://forum.inductiveautomation.com/u/vinitkapoor)\ **Replies:** 5\ **Last updated:** [December 23, 2017, 12:23am UTC](https://forum.inductiveautomation.com/t/opc-ua-custom-model-for-devices/14871 "2017-12-23T00:23:46Z")
Hi, Is there a way we can import/define custom model based on OPC UA Information model for the devices? For e.g., I want define an information model where a device has 3 sensors and 2 actuators in opc ua model. Is this… --- ## [tag.writeSynchronous not reflected immediately?](https://forum.inductiveautomation.com/t/tag-writesynchronous-not-reflected-immediately/16392)
**Author:** [@lyndon.schroeder](https://forum.inductiveautomation.com/u/lyndon.schroeder)\ **Replies:** 4\ **Last updated:** [December 22, 2017, 9:32pm UTC](https://forum.inductiveautomation.com/t/tag-writesynchronous-not-reflected-immediately/16392 "2017-12-22T21:32:39Z")
I have a gateway tag change script, I wanted to insure only executed once, it sends an email and I don't want to spam the recipients if we have a network error. So I wrote it like this... trigger = system.tag.read("DoT… --- ## [VOIP configuration parameter](https://forum.inductiveautomation.com/t/voip-configuration-parameter/16405)
**Author:** [@nezuvitaku](https://forum.inductiveautomation.com/u/nezuvitaku)\ **Replies:** 0\ **Last updated:** [December 22, 2017, 4:59pm UTC](https://forum.inductiveautomation.com/t/voip-configuration-parameter/16405 "2017-12-22T16:59:12Z")
Hi! I'm a newbie of Ignition... I'm trying to set the VOIP account but I've some problem... I want to use an existing Voip account that already work correctly with "Blink Voip Software" but not with Ignition. I've alread… --- ## [Purge the pipes](https://forum.inductiveautomation.com/t/purge-the-pipes/6391)
**Author:** [@danielsoar](https://forum.inductiveautomation.com/u/danielsoar)\ **Replies:** 10\ **Last updated:** [December 22, 2017, 2:58pm UTC](https://forum.inductiveautomation.com/t/purge-the-pipes/6391 "2017-12-22T14:58:05Z")
For reasons unexplainable I have occasionally found an alarm that is 'stuck' in a pipeline. Any way to purge the pipes? (apart from resetting the gateway) This could really be handy if things went south for those a l… --- ## [Clientlauncher.exe does not work](https://forum.inductiveautomation.com/t/clientlauncher-exe-does-not-work/16397)
**Author:** [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\ **Replies:** 1\ **Last updated:** [December 22, 2017, 12:58am UTC](https://forum.inductiveautomation.com/t/clientlauncher-exe-does-not-work/16397 "2017-12-22T00:58:20Z")
Hello every body. When I start the clientlauncher.exe file to run the designer, it does not work. I´m using Windows 10, 64 bits and Ignition´s gateway version: 7.9.4. The clientlauncher.log fle shows this: INFO \[G… --- ## [Bar Chart Legend Issue](https://forum.inductiveautomation.com/t/bar-chart-legend-issue/16394)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 8\ **Last updated:** [December 21, 2017, 9:52pm UTC](https://forum.inductiveautomation.com/t/bar-chart-legend-issue/16394 "2017-12-21T21:52:11Z")
I have a bar chart component that has a client tag bound to the background color of the chart itself. Using a propertyChange script, I'm changing the background color of the bar chart legend to the same color as the back… --- ## [MySQL Exception Handling on Duplicate Entry](https://forum.inductiveautomation.com/t/mysql-exception-handling-on-duplicate-entry/16361)
**Author:** [@ctonge](https://forum.inductiveautomation.com/u/ctonge)\ **Replies:** 5\ **Last updated:** [December 21, 2017, 7:26pm UTC](https://forum.inductiveautomation.com/t/mysql-exception-handling-on-duplicate-entry/16361 "2017-12-21T19:26:10Z")
Hi, I'm not much of a ninja on exception handling in general. In this case I'm trying to gracefully handle a duplicate constraint exception. Currently I'm just trying to capture it with a generic Exception handler, but… --- ## [Paintable Canvas - slower/stop repainting](https://forum.inductiveautomation.com/t/paintable-canvas-slower-stop-repainting/16384)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 2\ **Last updated:** [December 21, 2017, 6:27am UTC](https://forum.inductiveautomation.com/t/paintable-canvas-slower-stop-repainting/16384 "2017-12-21T06:27:16Z")
I'm wondering if theres a way to keep the old graphics in a paintable canvas in the repaint function. I see there is a similar topic but I don't need to actually have this data persist across sessions, just to keep the c… --- ## [Tag Limit Exceeded](https://forum.inductiveautomation.com/t/tag-limit-exceeded/16383)
**Author:** [@k.jain](https://forum.inductiveautomation.com/u/k.jain)\ **Replies:** 2\ **Last updated:** [December 20, 2017, 9:57pm UTC](https://forum.inductiveautomation.com/t/tag-limit-exceeded/16383 "2017-12-20T21:57:39Z")
I am getting an error for a tag in the tag browser that says “Limit Exceeded”. How can I fix that? --- ## [Counter per shift](https://forum.inductiveautomation.com/t/counter-per-shift/16362)
**Author:** [@santiago4ever72](https://forum.inductiveautomation.com/u/santiago4ever72)\ **Replies:** 7\ **Last updated:** [December 20, 2017, 8:12pm UTC](https://forum.inductiveautomation.com/t/counter-per-shift/16362 "2017-12-20T20:12:58Z")
Is it possible to create a counter per shift where I have a tag that gives me a global accumulation eg. Bottles\_per\_production\_day=45,032 but I want the bottles per shift Shift 1 (5am-1pm)= 15,350 bottles Shift 2 (1pm-9… --- ## [Property change is done several times](https://forum.inductiveautomation.com/t/property-change-is-done-several-times/16380)
**Author:** [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\ **Replies:** 4\ **Last updated:** [December 20, 2017, 7:03pm UTC](https://forum.inductiveautomation.com/t/property-change-is-done-several-times/16380 "2017-12-20T19:03:56Z")
Hi, I have a chart with code that changes a specific value on the table every time the data changes (propertyChange), but when I do this if event.propertyName == "data": ds = event.source val = 100 - ds.data.getValu… --- ## [SQLTags External Providers Documentation](https://forum.inductiveautomation.com/t/sqltags-external-providers-documentation/1538)
**Author:** [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\ **Replies:** 9\ **Last updated:** [December 20, 2017, 5:16pm UTC](https://forum.inductiveautomation.com/t/sqltags-external-providers-documentation/1538 "2017-12-20T17:16:30Z")
I'm not sure if this exists or not ... please correct me if so ... I'd believe having documentation on the tables that are created when using an external provider would be beneficial. For example, I've created a Realti… --- ## [Editable Cells in a Power Table displaying a Pivot Table (from postgres tablefunc crosstab function)](https://forum.inductiveautomation.com/t/editable-cells-in-a-power-table-displaying-a-pivot-table-from-postgres-tablefunc-crosstab-function/16378)
**Author:** [@trent1](https://forum.inductiveautomation.com/u/trent1)\ **Replies:** 0\ **Last updated:** [December 20, 2017, 2:49pm UTC](https://forum.inductiveautomation.com/t/editable-cells-in-a-power-table-displaying-a-pivot-table-from-postgres-tablefunc-crosstab-function/16378 "2017-12-20T14:49:02Z")
Is that a thing? I understand it's a degree of separation from the database (and a quick implementation from another power table didn't work), so it's not the end of the world. Sure would be a more "spreadsheety" interfa… --- ## [Controllogic Connection Path](https://forum.inductiveautomation.com/t/controllogic-connection-path/16345)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 7\ **Last updated:** [December 20, 2017, 12:08pm UTC](https://forum.inductiveautomation.com/t/controllogic-connection-path/16345 "2017-12-20T12:08:16Z")
I am trying to figure out the correct connection path for a Controllogix(L71) PLC Version 24. Any Ideas? --- ## [\[SOLVED\] CRLF in Text Area](https://forum.inductiveautomation.com/t/solved-crlf-in-text-area/14358)
**Author:** [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\ **Replies:** 1\ **Last updated:** [December 20, 2017, 12:17am UTC](https://forum.inductiveautomation.com/t/solved-crlf-in-text-area/14358 "2017-12-20T00:17:08Z")
Hi All, I'm programmatically entering data into a text area, and I want the operators to be able to enter data into it sometimes, too. User text entry into the text area works well, and is able to include CRLF on press… --- ## [Updating multiple rows with same value](https://forum.inductiveautomation.com/t/updating-multiple-rows-with-same-value/16369)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 1\ **Last updated:** [December 19, 2017, 10:47pm UTC](https://forum.inductiveautomation.com/t/updating-multiple-rows-with-same-value/16369 "2017-12-19T22:47:31Z")
How do I go about updating multiple rows of data in MySql with same values. I have a query which pull multiple rows in a lot and bin. I would like to create a transfer button that changes the rows to a new lot and loca… --- ## [Adding Y-Axis value label to an easy chart?](https://forum.inductiveautomation.com/t/adding-y-axis-value-label-to-an-easy-chart/16366)
**Author:** [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\ **Replies:** 3\ **Last updated:** [December 19, 2017, 10:29pm UTC](https://forum.inductiveautomation.com/t/adding-y-axis-value-label-to-an-easy-chart/16366 "2017-12-19T22:29:45Z")
I have an easy chart component that has a pen with a constant target value that I’d like to add a Y-Axis label to with the current numeric value of the pen. Ideally the label is the same color as the pen itself and next … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1398) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1400)