# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1451 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1452 --- ## [DB Data calculation](https://forum.inductiveautomation.com/t/db-data-calculation/29272)
**Author:** [@IMEngineering](https://forum.inductiveautomation.com/u/IMEngineering)\ **Replies:** 2\ **Last updated:** [October 23, 2019, 8:20am UTC](https://forum.inductiveautomation.com/t/db-data-calculation/29272 "2019-10-23T08:20:03Z")
Hello, I need to made a calculation of an average value of a flow rate taken by a database interval then I have to calculate the total product consumption in the same interval and I have no idea at all on how to create … --- ## [Python 2.7 no longer maintained after 01.01.2020](https://forum.inductiveautomation.com/t/python-2-7-no-longer-maintained-after-01-01-2020/29299)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 3\ **Last updated:** [October 23, 2019, 5:33am UTC](https://forum.inductiveautomation.com/t/python-2-7-no-longer-maintained-after-01-01-2020/29299 "2019-10-23T05:33:02Z")
Googling the internet, I stumbled upon this nice site: https://pythonclock.org/ What about Jython? Shall Ignition script language switch to 3.x too? --- ## [Expression Help. Coalesce Null value](https://forum.inductiveautomation.com/t/expression-help-coalesce-null-value/29301)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 1\ **Last updated:** [October 22, 2019, 9:28pm UTC](https://forum.inductiveautomation.com/t/expression-help-coalesce-null-value/29301 "2019-10-22T21:28:16Z")
Hey y’all I have an expression: substring({.../lotone/lot.props.text},0,9) + (toint(substring({.../lotone/lot.props.text},"10")) + toint(substring({.../lottwo/lot.props.text},"10")) +100+ toint(substring({.../lotthree/… --- ## [Replace Tag Consuming Provider with Remote Provider](https://forum.inductiveautomation.com/t/replace-tag-consuming-provider-with-remote-provider/29300)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [October 22, 2019, 8:43pm UTC](https://forum.inductiveautomation.com/t/replace-tag-consuming-provider-with-remote-provider/29300 "2019-10-22T20:43:20Z")
I have a gateway (7.9.6) that is setup with a Tag Consuming Provider to an External Tags Provider that belongs to another gateway (7.9.6). My question is if I want to change the Tag Consuming Provider to a Remote Tag Pr… --- ## [system.db.runScalarQuery command works in Script Console but not in Calculated Pipeline script](https://forum.inductiveautomation.com/t/system-db-runscalarquery-command-works-in-script-console-but-not-in-calculated-pipeline-script/29294)
**Author:** [@r123](https://forum.inductiveautomation.com/u/r123)\ **Replies:** 2\ **Last updated:** [October 22, 2019, 6:43pm UTC](https://forum.inductiveautomation.com/t/system-db-runscalarquery-command-works-in-script-console-but-not-in-calculated-pipeline-script/29294 "2019-10-22T18:43:57Z")
I have a system.db.runScalarQuery script that works in Script Console but not in Calculated Pipeline script. Any ideas why? NewV = system.db.runScalarQuery(“SELECT COUNT(\*) FROM NewTable where id = 1 AND date IS NULL”) … --- ## [Question about Objects vs. Properties](https://forum.inductiveautomation.com/t/question-about-objects-vs-properties/29261)
**Author:** [@richard.d.white](https://forum.inductiveautomation.com/u/richard.d.white)\ **Replies:** 7\ **Last updated:** [October 22, 2019, 5:27pm UTC](https://forum.inductiveautomation.com/t/question-about-objects-vs-properties/29261 "2019-10-22T17:27:39Z")
Can someone please point me to a reference where this is better explained? I understand that tags as created with Ignition are Objects that have properties associated with them. For example, if I want to see the LastC… --- ## [Project help scheduling board](https://forum.inductiveautomation.com/t/project-help-scheduling-board/29167)
**Author:** [@DHP22](https://forum.inductiveautomation.com/u/DHP22)\ **Replies:** 5\ **Last updated:** [October 22, 2019, 4:16pm UTC](https://forum.inductiveautomation.com/t/project-help-scheduling-board/29167 "2019-10-22T16:16:57Z")
This is my first time writing on this forum. I have been using Ignition for a couple years now and really like the software. I am in the middle of a big project for me and could use some help. I am working on a scheduli… --- ## [Template Repeater: Template Properties Bindings](https://forum.inductiveautomation.com/t/template-repeater-template-properties-bindings/29283)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 0\ **Last updated:** [October 22, 2019, 2:25pm UTC](https://forum.inductiveautomation.com/t/template-repeater-template-properties-bindings/29283 "2019-10-22T14:25:59Z")
In my current project I’m using lots of template repeaters, with Repeat behavior set to Dataset. Say that my template has 2 Custom Properties: tagProp and uiProp. tagProp is used to bind a Numeric Label's Value to the … --- ## [Update db table B from table A with button press](https://forum.inductiveautomation.com/t/update-db-table-b-from-table-a-with-button-press/29277)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 0\ **Last updated:** [October 22, 2019, 1:31pm UTC](https://forum.inductiveautomation.com/t/update-db-table-b-from-table-a-with-button-press/29277 "2019-10-22T13:31:40Z")
The top table is table A and the bottom is table B. On table B I have polling turned off. On table A I am coping table B and have editable rows I edit table A the press the button and it moves the data into table B… --- ## [\[Solved\] Need help with system.tag.browse and diagnostic tool - Bit State Change Locator](https://forum.inductiveautomation.com/t/solved-need-help-with-system-tag-browse-and-diagnostic-tool-bit-state-change-locator/28371)
**Author:** [@kpswiney](https://forum.inductiveautomation.com/u/kpswiney)\ **Replies:** 3\ **Last updated:** [October 22, 2019, 10:27am UTC](https://forum.inductiveautomation.com/t/solved-need-help-with-system-tag-browse-and-diagnostic-tool-bit-state-change-locator/28371 "2019-10-22T10:27:13Z")
Hello, I am open sourcing this with the hopes of speeding up development and giving it to anyone who might need a tool like this. I plan to place this on the public template cloud when it is complete. It worked ok, but a… --- ## [Weird client tag behavior in Vision 8.0.5](https://forum.inductiveautomation.com/t/weird-client-tag-behavior-in-vision-8-0-5/29238)
**Author:** [@roberto.camp](https://forum.inductiveautomation.com/u/roberto.camp)\ **Replies:** 7\ **Last updated:** [October 22, 2019, 5:35am UTC](https://forum.inductiveautomation.com/t/weird-client-tag-behavior-in-vision-8-0-5/29238 "2019-10-22T05:35:55Z")
Hey guys, I’m trying to move an old project from Ignition 7.7 to Ignition 8.0.5. I’m aware there are still some issues with Client Tags (e.g. not able to copy, etc.) But I’ve been seeing some weird behavior. I’m not sur… --- ## [Font Issue in Vision Client](https://forum.inductiveautomation.com/t/font-issue-in-vision-client/27091)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 8\ **Last updated:** [October 21, 2019, 9:46pm UTC](https://forum.inductiveautomation.com/t/font-issue-in-vision-client/27091 "2019-10-21T21:46:18Z")
Hi all, I’m experiencing the following issue: pages show different fonts depending on the way I launch the application. If I launch the application from the designer with the Tools-Launch project-Full screen command all… --- ## [Running Ignition Edge and Designer on Raspberry pi 4](https://forum.inductiveautomation.com/t/running-ignition-edge-and-designer-on-raspberry-pi-4/29258)
**Author:** [@bayswimmer](https://forum.inductiveautomation.com/u/bayswimmer)\ **Replies:** 2\ **Last updated:** [October 21, 2019, 8:05pm UTC](https://forum.inductiveautomation.com/t/running-ignition-edge-and-designer-on-raspberry-pi-4/29258 "2019-10-21T20:05:33Z")
I have installed Ignition Edge Ignition-Edge-linux-armhf-8.0.5 on a Raspberry pi 4 NOOBS Raspian. When trying to install the designer, I get the below error. Has anyone sucessfully installed Edge and Designer on a pi 4? … --- ## [SQL within a client](https://forum.inductiveautomation.com/t/sql-within-a-client/29208)
**Author:** [@lrhyrne](https://forum.inductiveautomation.com/u/lrhyrne)\ **Replies:** 12\ **Last updated:** [October 21, 2019, 7:38pm UTC](https://forum.inductiveautomation.com/t/sql-within-a-client/29208 "2019-10-21T19:38:22Z")
I have a SQL statement that outputs results to a file. Where will the file attempt to be written? on the Client’s local machine, or the Gateway computer? Snippet: SELECT columns… FROM table INTO OUTFILE “C:\\tmp\\out… --- ## [Cancel system.gui.transform](https://forum.inductiveautomation.com/t/cancel-system-gui-transform/29041)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 7\ **Last updated:** [October 21, 2019, 6:54pm UTC](https://forum.inductiveautomation.com/t/cancel-system-gui-transform/29041 "2019-10-21T18:54:33Z")
I’m using system.gui.transform with a duration to move a container to X,Y positions supplied by PLC tags. This works, except when I begin a new movement with another system.gui.transform before the previous move has com… --- ## [Documenting the Event-Driven-ness of Ignition programs?](https://forum.inductiveautomation.com/t/documenting-the-event-driven-ness-of-ignition-programs/29252)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [October 21, 2019, 6:41pm UTC](https://forum.inductiveautomation.com/t/documenting-the-event-driven-ness-of-ignition-programs/29252 "2019-10-21T18:41:32Z")
Our company is trying to document our projects so if someone has to come and work on a screen in a project they don’t know anything about, they can read the documentation and be able to dive right in. How do you documen… --- ## [If I copy (or cut) and paste an instance of UDT, its values are not copied](https://forum.inductiveautomation.com/t/if-i-copy-or-cut-and-paste-an-instance-of-udt-its-values-are-not-copied/29251)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 5\ **Last updated:** [October 21, 2019, 6:39pm UTC](https://forum.inductiveautomation.com/t/if-i-copy-or-cut-and-paste-an-instance-of-udt-its-values-are-not-copied/29251 "2019-10-21T18:39:20Z")
In Ignition 7.9.9, if I copy (or cut) and paste an instance of UDT, its values are not copied. This is a big inconvenience. For example, if you are moving a UDT within a folder. Best Regards. --- ## [Timeseries Chart Configuration](https://forum.inductiveautomation.com/t/timeseries-chart-configuration/28464)
**Author:** [@salvador.medina](https://forum.inductiveautomation.com/u/salvador.medina)\ **Replies:** 1\ **Last updated:** [October 21, 2019, 4:09pm UTC](https://forum.inductiveautomation.com/t/timeseries-chart-configuration/28464 "2019-10-21T16:09:02Z")
Hi, I need help with some problems in a timeseries chart: The chart include a space in both side (red circles in images). I would like delete this space and maximize the graphic area. The X-Axis only show one line. I … --- ## [Ignition 8 help](https://forum.inductiveautomation.com/t/ignition-8-help/29240)
**Author:** [@dylanscully01123](https://forum.inductiveautomation.com/u/dylanscully01123)\ **Replies:** 5\ **Last updated:** [October 21, 2019, 4:06pm UTC](https://forum.inductiveautomation.com/t/ignition-8-help/29240 "2019-10-21T16:06:31Z")
Hi, I am new to ignition and I’m getting stuck on some small things. I’m hoping to find someone who is willing to help me through minor hang ups I’m having on a more one-to-one basis. The questions I have are simple and … --- ## [\[BUG-13211\] Windows and Templates turned into folders](https://forum.inductiveautomation.com/t/bug-13211-windows-and-templates-turned-into-folders/29019)
**Author:** [@ald](https://forum.inductiveautomation.com/u/ald)\ **Replies:** 3\ **Last updated:** [October 21, 2019, 4:06pm UTC](https://forum.inductiveautomation.com/t/bug-13211-windows-and-templates-turned-into-folders/29019 "2019-10-21T16:06:28Z")
I have encounted a problem where when i open the project in the design launcher most of my windows and templates are now gone and replaced by folders with the same name. In the gateway diagnostic logs i have about 15 not… --- ## [\[13211\] Ignition Edge Windows and Templates show as Folders](https://forum.inductiveautomation.com/t/13211-ignition-edge-windows-and-templates-show-as-folders/28600)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 3\ **Last updated:** [October 21, 2019, 4:05pm UTC](https://forum.inductiveautomation.com/t/13211-ignition-edge-windows-and-templates-show-as-folders/28600 "2019-10-21T16:05:52Z")
I’ve been working in Ignition Edge 8.0.4 on Linux Mint. Today I closed Ignition Designer with several windows open. When prompted I selected “Save and Exit”. When I opened the designer again, the windows that had been… --- ## [\[BUG-13211\]Unable to open window in Client/Designer](https://forum.inductiveautomation.com/t/bug-13211-unable-to-open-window-in-client-designer/28484)
**Author:** [@danieltalbot](https://forum.inductiveautomation.com/u/danieltalbot)\ **Replies:** 4\ **Last updated:** [October 21, 2019, 4:05pm UTC](https://forum.inductiveautomation.com/t/bug-13211-unable-to-open-window-in-client-designer/28484 "2019-10-21T16:05:38Z")
DL\_Foundry\_2019-09-23\_1320.zip (1012 Bytes) See attached. I can’t open this window in a client or in the designer. We recently upgraded to 8.0.4 from 7.9.10, but I think this window was working until today. I could be … --- ## [\[Bug-14839\]Perspective Session Property Causing System Jython Error](https://forum.inductiveautomation.com/t/bug-14839-perspective-session-property-causing-system-jython-error/28975)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 3\ **Last updated:** [October 21, 2019, 4:02pm UTC](https://forum.inductiveautomation.com/t/bug-14839-perspective-session-property-causing-system-jython-error/28975 "2019-10-21T16:02:43Z")
Hi all, I encountered a strange error that did not initially appear on a script, but appeared after a few saves. So, the script was working until the error occurred. The script was a transform script on the props.data p… --- ## [Controls in a table row](https://forum.inductiveautomation.com/t/controls-in-a-table-row/29232)
**Author:** [@sac](https://forum.inductiveautomation.com/u/sac)\ **Replies:** 5\ **Last updated:** [October 21, 2019, 2:06pm UTC](https://forum.inductiveautomation.com/t/controls-in-a-table-row/29232 "2019-10-21T14:06:32Z")
Is it possible to add a control like a checkbox to rows of a table. Let’s say i have a table with a list of lights with columns name, on/off status. Is it possible to add a checkbox under on/off status and turn the light… --- ## [How to alter data from a table?](https://forum.inductiveautomation.com/t/how-to-alter-data-from-a-table/29230)
**Author:** [@sac](https://forum.inductiveautomation.com/u/sac)\ **Replies:** 1\ **Last updated:** [October 21, 2019, 1:20pm UTC](https://forum.inductiveautomation.com/t/how-to-alter-data-from-a-table/29230 "2019-10-21T13:20:16Z")
I have a table which is showing some data from my database. I’d like to modify the data from the table. I see that there is a allowEditOn property for the table and permissible values are single-click, double-click and l… --- ## [How can I add a MODBUS device over serial to Ignition](https://forum.inductiveautomation.com/t/how-can-i-add-a-modbus-device-over-serial-to-ignition/29234)
**Author:** [@sac](https://forum.inductiveautomation.com/u/sac)\ **Replies:** 5\ **Last updated:** [October 21, 2019, 12:59pm UTC](https://forum.inductiveautomation.com/t/how-can-i-add-a-modbus-device-over-serial-to-ignition/29234 "2019-10-21T12:59:26Z")
I have already added a MODBUS TCP device to ignition. But, is it possible to add a serial device to Ignition, from a port? --- ## [Implement a graph displaying 2 plots on live Time](https://forum.inductiveautomation.com/t/implement-a-graph-displaying-2-plots-on-live-time/29235)
**Author:** [@alexm](https://forum.inductiveautomation.com/u/alexm)\ **Replies:** 2\ **Last updated:** [October 21, 2019, 12:05pm UTC](https://forum.inductiveautomation.com/t/implement-a-graph-displaying-2-plots-on-live-time/29235 "2019-10-21T12:05:22Z")
Hi, I would like to make a graph displaying 2 plots. Plot (a) reads an incrementing integer on y-axis vs time on x-axis Plot (b) shows the difference of the previous value that has occurred between lets say every 15 m… --- ## [SVG drop Freezes designer](https://forum.inductiveautomation.com/t/svg-drop-freezes-designer/25675)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 3\ **Last updated:** [October 21, 2019, 11:58am UTC](https://forum.inductiveautomation.com/t/svg-drop-freezes-designer/25675 "2019-10-21T11:58:47Z")
Hi, I tried drop an SVG into a template in vision on 8.0 As soon as I dropped it in I just get the spinning wheel Nothing has happened yet, it’s been 10 minutes Is this a known issue? --- ## [Connecting to mySQL 4.0.26 Cannot create PoolableConnectionFactory (ResultSet is from UPDATE. No Data.)](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132)
**Author:** [@Craighunter1986](https://forum.inductiveautomation.com/u/Craighunter1986)\ **Replies:** 4\ **Last updated:** [October 21, 2019, 10:00am UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132 "2019-10-21T10:00:19Z")
I am struggling to get a valid connection to a MySQL database. The SQL database is hosted on a machine which is remote from the Ignition server. I have set up a user in PHPMyAdmin with any host and global privileges. I h… --- ## [Gateway Network Problems with Duplicate Connection IDs](https://forum.inductiveautomation.com/t/gateway-network-problems-with-duplicate-connection-ids/18316)
**Author:** [@hgarner](https://forum.inductiveautomation.com/u/hgarner)\ **Replies:** 5\ **Last updated:** [October 20, 2019, 9:47pm UTC](https://forum.inductiveautomation.com/t/gateway-network-problems-with-duplicate-connection-ids/18316 "2019-10-20T21:47:52Z")
We are working to set up Gateway Network Connections between several Ignition Gateways and a Central Ignition Server to allow us to gather tag information from each Gateway to build real-time Dashboards. We have a mixtur… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1450) [Next page](https://forum.inductiveautomation.com/latest.md?page=1452)