# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1028 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1029 --- ## [Tag Historian Table not creating automatically](https://forum.inductiveautomation.com/t/tag-historian-table-not-creating-automatically/22342)
**Author:** [@emovspunk1996](https://forum.inductiveautomation.com/u/emovspunk1996)\ **Replies:** 2\ **Last updated:** [April 27, 2021, 5:10pm UTC](https://forum.inductiveautomation.com/t/tag-historian-table-not-creating-automatically/22342 "2021-04-27T17:10:08Z")
I’m having a problem with tag historian table after setting up a new database connection java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.… --- ## [CSV get cutted export](https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967)
**Author:** [@Kevin\_DLeon](https://forum.inductiveautomation.com/u/Kevin_DLeon)\ **Replies:** 2\ **Last updated:** [April 27, 2021, 5:07pm UTC](https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967 "2021-04-27T17:07:04Z")
hello i have some columns and rows to export as csv file to my computer but i have a problem, imagine the table: COL1 | COL2 | COL3 | COL4 | COL5 data data data data data data data data … --- ## [EasyChart discrete value](https://forum.inductiveautomation.com/t/easychart-discrete-value/46065)
**Author:** [@tupanaster](https://forum.inductiveautomation.com/u/tupanaster)\ **Replies:** 4\ **Last updated:** [April 27, 2021, 4:20pm UTC](https://forum.inductiveautomation.com/t/easychart-discrete-value/46065 "2021-04-27T16:20:17Z")
Hi, It is possible to have EasyChart plot discrete values? Using historical groups based on time. There is a similar topic talking about Historian and historian module but that’s not my case. Thank you. --- ## [Keyboard Wedge Badge Reader after update to 8.1](https://forum.inductiveautomation.com/t/keyboard-wedge-badge-reader-after-update-to-8-1/46039)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 2\ **Last updated:** [April 27, 2021, 3:02pm UTC](https://forum.inductiveautomation.com/t/keyboard-wedge-badge-reader-after-update-to-8-1/46039 "2021-04-27T15:02:27Z")
This is a very odd side affect since updating from 8.0 to 8.1. In Perspective, I have a pop up view that asked the end user for a badge number into a PasswordField. I have a badge reader that acts as a keyboard wedge. … --- ## [Expression binding in tag properties](https://forum.inductiveautomation.com/t/expression-binding-in-tag-properties/45121)
**Author:** [@bertrand.challet](https://forum.inductiveautomation.com/u/bertrand.challet)\ **Replies:** 0\ **Last updated:** [March 31, 2021, 3:05pm UTC](https://forum.inductiveautomation.com/t/expression-binding-in-tag-properties/45121 "2021-03-31T15:05:06Z")
Hello, We are running an issue into our Ignition Gateway 7.9. We are lazily injecting OPC parameters from an UDT into his tags with, for each of them, this expression binding: Path: {{PathToParentFolder}.Path} Serve… --- ## [Setup Gateway Network Settings not working](https://forum.inductiveautomation.com/t/setup-gateway-network-settings-not-working/46068)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 0\ **Last updated:** [April 27, 2021, 2:37pm UTC](https://forum.inductiveautomation.com/t/setup-gateway-network-settings-not-working/46068 "2021-04-27T14:37:41Z")
I have two VM’s, one with version 7.9.13 and another one with version 8.0.14. Each one has its own gateway. I am attempting to create a gateway network to link the two together. I can ping the VM’s from the other one.… --- ## [UDT transform by disable of members](https://forum.inductiveautomation.com/t/udt-transform-by-disable-of-members/46057)
**Author:** [@gurovskiy-a](https://forum.inductiveautomation.com/u/gurovskiy-a)\ **Replies:** 3\ **Last updated:** [April 27, 2021, 10:07am UTC](https://forum.inductiveautomation.com/t/udt-transform-by-disable-of-members/46057 "2021-04-27T10:07:11Z")
Good day! I am have a problem with enabling (disabling) a tags by changing the “.Enable” tag property. Ignition 8.0.18, OS windows 10 There are several UDT tags that are part of another UDT tag. The outer UDT tag also… --- ## [Reference self in tag expression?](https://forum.inductiveautomation.com/t/reference-self-in-tag-expression/46059)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [April 27, 2021, 8:16am UTC](https://forum.inductiveautomation.com/t/reference-self-in-tag-expression/46059 "2021-04-27T08:16:30Z")
Is it possible to reference the expression tag itself in an expression tag’s expression? For example, I want to get the containing tag’s name dynamically: lookup({\[.\]Daily Table Row Counts}, '\[dbo\].\[' + {\[.\].Name} + '\]… --- ## [Customize Alarm Priority](https://forum.inductiveautomation.com/t/customize-alarm-priority/46049)
**Author:** [@desaitvisha](https://forum.inductiveautomation.com/u/desaitvisha)\ **Replies:** 1\ **Last updated:** [April 26, 2021, 11:35pm UTC](https://forum.inductiveautomation.com/t/customize-alarm-priority/46049 "2021-04-26T23:35:53Z")
Can we change names of alarm priority in ignition. I want ‘Low’ priority to be named as ‘Warning’ . How can this be done? --- ## [Insert a calculated value into a classic chart](https://forum.inductiveautomation.com/t/insert-a-calculated-value-into-a-classic-chart/45891)
**Author:** [@christopher.berg](https://forum.inductiveautomation.com/u/christopher.berg)\ **Replies:** 4\ **Last updated:** [April 26, 2021, 11:06pm UTC](https://forum.inductiveautomation.com/t/insert-a-calculated-value-into-a-classic-chart/45891 "2021-04-26T23:06:25Z")
I’m trying to overlay a couple of different SQL query results into a classic chart and I’m not having any luck. I’ve got several hundred data points that I’m getting from an SQL query. The results display fine on the cha… --- ## [propertyChange script with Internal property not running](https://forum.inductiveautomation.com/t/propertychange-script-with-internal-property-not-running/46038)
**Author:** [@srb](https://forum.inductiveautomation.com/u/srb)\ **Replies:** 4\ **Last updated:** [April 26, 2021, 10:20pm UTC](https://forum.inductiveautomation.com/t/propertychange-script-with-internal-property-not-running/46038 "2021-04-26T22:20:56Z")
Hi all, I’m trying to run a property change script whenever the alarm count (gateway tag) changes to write Unack and Ack count of an area into two memory tags. I setup an Internal property in my template called alarmCha… --- ## [Office viewer](https://forum.inductiveautomation.com/t/office-viewer/12592)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 6\ **Last updated:** [April 26, 2021, 5:37pm UTC](https://forum.inductiveautomation.com/t/office-viewer/12592 "2021-04-26T17:37:40Z")
Is it possible to incorporate some ActiveX component that will show a powerpoint presentation inside an Ignition client? --- ## [MQTT Engine: switching brokers breaks Sparkplug functionality](https://forum.inductiveautomation.com/t/mqtt-engine-switching-brokers-breaks-sparkplug-functionality/45669)
**Author:** [@321liftoff](https://forum.inductiveautomation.com/u/321liftoff)\ **Replies:** 6\ **Last updated:** [April 26, 2021, 5:00pm UTC](https://forum.inductiveautomation.com/t/mqtt-engine-switching-brokers-breaks-sparkplug-functionality/45669 "2021-04-26T17:00:11Z")
@wes0johnson Running Ignition 8.1.4 with MQTT Engine 4.0.7. MQTT Engine enters a non-functional condition after manually switching from one broker to another. Procedure: Enable Ignition trial and connect MQTT Engine… --- ## [How to drill down into a chart?](https://forum.inductiveautomation.com/t/how-to-drill-down-into-a-chart/45938)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 2\ **Last updated:** [April 26, 2021, 4:43pm UTC](https://forum.inductiveautomation.com/t/how-to-drill-down-into-a-chart/45938 "2021-04-26T16:43:05Z")
Hi there, I have a bar chart with line state names. What i want to do is allow the user to click onto a specific bar which would open up a popup window and show how that specific line state duration is split into diffe… --- ## [Intermittent Connection & Odd ControlLogix legacy driver behavior on L18s over NAT router](https://forum.inductiveautomation.com/t/intermittent-connection-odd-controllogix-legacy-driver-behavior-on-l18s-over-nat-router/45962)
**Author:** [@wking](https://forum.inductiveautomation.com/u/wking)\ **Replies:** 6\ **Last updated:** [April 26, 2021, 4:15pm UTC](https://forum.inductiveautomation.com/t/intermittent-connection-odd-controllogix-legacy-driver-behavior-on-l18s-over-nat-router/45962 "2021-04-26T16:15:58Z")
I have 30 devices going through a MikroTik NAT router. And it works pretty well. I have the same rules set up on all the interfaces of the router. I’ll post the export from that switch below. But the devices are named 1… --- ## [How to Expose the Tag Path of a Component Binding](https://forum.inductiveautomation.com/t/how-to-expose-the-tag-path-of-a-component-binding/12480)
**Author:** [@ajdewhirst](https://forum.inductiveautomation.com/u/ajdewhirst)\ **Replies:** 13\ **Last updated:** [April 26, 2021, 2:26pm UTC](https://forum.inductiveautomation.com/t/how-to-expose-the-tag-path-of-a-component-binding/12480 "2021-04-26T14:26:32Z")
Is it possible to expose the tag path of a tag that a window component is bound to? For example, if the Value property of a Numeric Label component on a screen is bound to the value of a tag, is it possible to expose t… --- ## [Tag history binding to different table columns](https://forum.inductiveautomation.com/t/tag-history-binding-to-different-table-columns/46031)
**Author:** [@berkay.cinar](https://forum.inductiveautomation.com/u/berkay.cinar)\ **Replies:** 0\ **Last updated:** [April 26, 2021, 1:27pm UTC](https://forum.inductiveautomation.com/t/tag-history-binding-to-different-table-columns/46031 "2021-04-26T13:27:27Z")
Hello everybody, Very new to Ignition struggling on my first project. I want to assign tag history binding to each column of the table. I can do the history binding and bring data every hour but I could not figure out … --- ## [Power Chart Printing - Potential Bug in 8.1.4](https://forum.inductiveautomation.com/t/power-chart-printing-potential-bug-in-8-1-4/45908)
**Author:** [@scott.stamps](https://forum.inductiveautomation.com/u/scott.stamps)\ **Replies:** 5\ **Last updated:** [April 26, 2021, 1:14pm UTC](https://forum.inductiveautomation.com/t/power-chart-printing-potential-bug-in-8-1-4/45908 "2021-04-26T13:14:16Z")
We recently upgraded to 8.1.4 and are noticing that the print option (under the kebab/vertical ellipsis menu) no longer works. We are curious if anyone else is experiencing this. We tested using Chrome (Version 90.0.4430… --- ## [Clock drift, degraded performance, or pause-the-world detected](https://forum.inductiveautomation.com/t/clock-drift-degraded-performance-or-pause-the-world-detected/46026)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 2\ **Last updated:** [April 26, 2021, 11:44am UTC](https://forum.inductiveautomation.com/t/clock-drift-degraded-performance-or-pause-the-world-detected/46026 "2021-04-26T11:44:16Z")
Hello , I have a performance problem. I have Ignition installed on virtual server, which I am accessing using remote desktop control. Lately my whole system is freezing and not letting me do anything, but closing the r… --- ## [Transaction groups, full redundancy, automatic switchover?](https://forum.inductiveautomation.com/t/transaction-groups-full-redundancy-automatic-switchover/23891)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 7\ **Last updated:** [April 26, 2021, 7:03am UTC](https://forum.inductiveautomation.com/t/transaction-groups-full-redundancy-automatic-switchover/23891 "2021-04-26T07:03:39Z")
I have a project with lots of transaction groups for storing history data. It is storing history to a SQL server but the facility wants to install another SQL on another server as a backup. Since they are transaction g… --- ## [Duration Calculation](https://forum.inductiveautomation.com/t/duration-calculation/45791)
**Author:** [@Adriaan.leRoux](https://forum.inductiveautomation.com/u/Adriaan.leRoux)\ **Replies:** 6\ **Last updated:** [April 26, 2021, 6:57am UTC](https://forum.inductiveautomation.com/t/duration-calculation/45791 "2021-04-26T06:57:41Z")
I have a simple parameter on a report called duration, and is calculated as follows: fromMillis({EndDate}-{StartDate}) I get the correct time difference + 2 hours, it’s always exactly two hours more than what it should… --- ## [Gateway scope and client scope](https://forum.inductiveautomation.com/t/gateway-scope-and-client-scope/45944)
**Author:** [@pick](https://forum.inductiveautomation.com/u/pick)\ **Replies:** 6\ **Last updated:** [April 26, 2021, 5:42am UTC](https://forum.inductiveautomation.com/t/gateway-scope-and-client-scope/45944 "2021-04-26T05:42:02Z")
Hello, I would like to control the buton’s visibility from a opc tag change In the gateway tag change script i use the folowing code: topDebutProd = system.tag.read(“QMP\_rebox\_2208/comPLC/topDebutProd”).value BTvalid… --- ## [Ordered Dictionaries](https://forum.inductiveautomation.com/t/ordered-dictionaries/45949)
**Author:** [@limjx](https://forum.inductiveautomation.com/u/limjx)\ **Replies:** 4\ **Last updated:** [April 26, 2021, 5:02am UTC](https://forum.inductiveautomation.com/t/ordered-dictionaries/45949 "2021-04-26T05:02:26Z")
Hi, I would like create a json file in a specific format, however there are some restriction involved. Declared dictionaries not in my specific key order (d,c,a,b). from collections import OrderedDict mylist = \[\] m… --- ## [Allen-Bradley driver failure after upgrade to 8.1.4](https://forum.inductiveautomation.com/t/allen-bradley-driver-failure-after-upgrade-to-8-1-4/45953)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [April 26, 2021, 2:00am UTC](https://forum.inductiveautomation.com/t/allen-bradley-driver-failure-after-upgrade-to-8-1-4/45953 "2021-04-26T02:00:29Z")
We upgraded to 8.1.4 and found that a problem occurred with all our Allen-Bradley devices. We are using A-B CompactLogix (Legacy) A-B Logix Driver A-B ControlLogix (Legacy) A-B SLC If we use the gateway’s OPC Quick Cl… --- ## [Serial module for Raspberry PI](https://forum.inductiveautomation.com/t/serial-module-for-raspberry-pi/29241)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 12\ **Last updated:** [April 25, 2021, 6:58pm UTC](https://forum.inductiveautomation.com/t/serial-module-for-raspberry-pi/29241 "2021-04-25T18:58:28Z")
Hello The serial module for gateway side is not working for raspberry PI. Is there any new Java serial library that can be used for ARM platform? --- ## [Blue pill or Red pill - Reporting, Historizing, and Summarizing Data](https://forum.inductiveautomation.com/t/blue-pill-or-red-pill-reporting-historizing-and-summarizing-data/25942)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 17\ **Last updated:** [April 25, 2021, 6:08pm UTC](https://forum.inductiveautomation.com/t/blue-pill-or-red-pill-reporting-historizing-and-summarizing-data/25942 "2021-04-25T18:08:31Z")
I feel like I am going down the wrong rabbit hole because I seem to be going to great lengths to generate daily and monthly reports when it comes to historizing totalized values. There are 2 general ways of generating d… --- ## [Disable "writing" square in object](https://forum.inductiveautomation.com/t/disable-writing-square-in-object/45979)
**Author:** [@JFer](https://forum.inductiveautomation.com/u/JFer)\ **Replies:** 4\ **Last updated:** [April 25, 2021, 5:39pm UTC](https://forum.inductiveautomation.com/t/disable-writing-square-in-object/45979 "2021-04-25T17:39:50Z")
Hi all, started worked with ignition a few weeks ago, and so far will all the knowledge shared here I have been able to manage to make what I was supposed to, but i am getting a bit stuck with this: Both buttons are t… --- ## [Please give me some instance for write tag into database](https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008)
**Author:** [@netliuhao](https://forum.inductiveautomation.com/u/netliuhao)\ **Replies:** 2\ **Last updated:** [April 25, 2021, 12:43pm UTC](https://forum.inductiveautomation.com/t/please-give-me-some-instance-for-write-tag-into-database/46008 "2021-04-25T12:43:09Z")
hello ： SIR. i am new guy for ignition. i can read date form MYSQL database in Ignition software before last week . but i don’t know : how to write tags-value into Mysql database in Ignition software . my idea is … --- ## [History Database Connection](https://forum.inductiveautomation.com/t/history-database-connection/31278)
**Author:** [@thomas.stevic](https://forum.inductiveautomation.com/u/thomas.stevic)\ **Replies:** 7\ **Last updated:** [April 25, 2021, 7:27am UTC](https://forum.inductiveautomation.com/t/history-database-connection/31278 "2021-04-25T07:27:53Z")
I am trying to get a database connection working so I might set up tag history. I am using SQL Server. ( I am not a database person) The connection name is MSSQLServer. The JDBC driver is Microsoft SQLServer. The dat… --- ## [Dataset memory tag UDT](https://forum.inductiveautomation.com/t/dataset-memory-tag-udt/45929)
**Author:** [@kunal.ghule](https://forum.inductiveautomation.com/u/kunal.ghule)\ **Replies:** 9\ **Last updated:** [April 25, 2021, 6:49am UTC](https://forum.inductiveautomation.com/t/dataset-memory-tag-udt/45929 "2021-04-25T06:49:19Z")
I have created dataset tag (memory) UDTs. I want to change dataset inside UDTs rather than instances. Is there a way I can access this dataset UDT tags in table components. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1027) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1029)