# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=818 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 819 --- ## [Perspective: alarms texts localization issue](https://forum.inductiveautomation.com/t/perspective-alarms-texts-localization-issue/60538)
**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 8:16am UTC](https://forum.inductiveautomation.com/t/perspective-alarms-texts-localization-issue/60538 "2022-06-29T08:16:34Z")
One of my alarms Display Path property is the result of an expression like this: concat("Alrm bench#",{benchNr}," - ",translate("Charger line fault or offline")) Even if a translation for Charger line fault or offline … --- ## [PCCC protocol causing problems](https://forum.inductiveautomation.com/t/pccc-protocol-causing-problems/11651)
**Author:** [@doug.breshears](https://forum.inductiveautomation.com/u/doug.breshears)\ **Replies:** 22\ **Last updated:** [June 29, 2022, 5:01am UTC](https://forum.inductiveautomation.com/t/pccc-protocol-causing-problems/11651 "2022-06-29T05:01:50Z")
Ignition Version 7.8.2 Java(TM) SE Runtime Environment (build 1.8.0\_92-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.92-b14, mixed mode) OS : Ubuntu 14.04 Is there a way yet to stop a protocol from being used? I ha… --- ## [Startup Script assign default db connection](https://forum.inductiveautomation.com/t/startup-script-assign-default-db-connection/61330)
**Author:** [@Daniel\_Newton](https://forum.inductiveautomation.com/u/Daniel_Newton)\ **Replies:** 2\ **Last updated:** [June 29, 2022, 12:39am UTC](https://forum.inductiveautomation.com/t/startup-script-assign-default-db-connection/61330 "2022-06-29T00:39:58Z")
Hi All, Obligatory first post declaration. English is my first language, so please judge accordingly. I have a gateway that is being developed in a testing OU that is air gapped from all production environments. For s… --- ## [system.db.runPrepQuery - GROUP BY](https://forum.inductiveautomation.com/t/system-db-runprepquery-group-by/61240)
**Author:** [@Paul.M](https://forum.inductiveautomation.com/u/Paul.M)\ **Replies:** 4\ **Last updated:** [June 28, 2022, 8:57pm UTC](https://forum.inductiveautomation.com/t/system-db-runprepquery-group-by/61240 "2022-06-28T20:57:03Z")
Hello, I try to use system.db.runPrepQuery and add a 'GROUP BY' CLAUSE, script without group by works fine. Without group by data\['a'\] = system.db.runPrepQuery("SELECT AREA, DATEPART(week, CREATED), STATUS\_TEXT FRO… --- ## [SMTP good but Alarm Pipeline not working](https://forum.inductiveautomation.com/t/smtp-good-but-alarm-pipeline-not-working/61117)
**Author:** [@Madison\_Chester](https://forum.inductiveautomation.com/u/Madison_Chester)\ **Replies:** 6\ **Last updated:** [June 28, 2022, 7:38pm UTC](https://forum.inductiveautomation.com/t/smtp-good-but-alarm-pipeline-not-working/61117 "2022-06-28T19:38:13Z")
Not sure if this has been touched on already, but I’m having issues with testing my alarm pipeline…When I test my SMTP Server via the Ignition Gateway the email sends, but when I try to test my alarm pipeline/notificatio… --- ## [Perspective Android app, issues?](https://forum.inductiveautomation.com/t/perspective-android-app-issues/61307)
**Author:** [@Bradley\_Peay](https://forum.inductiveautomation.com/u/Bradley_Peay)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 6:08pm UTC](https://forum.inductiveautomation.com/t/perspective-android-app-issues/61307 "2022-06-28T18:08:59Z")
Has anyone had issues with the Perspective app for Android? I have had to restart the app several times and performance is not as good as chrome. Am I missing an update? I currently have v1.0.3. --- ## [Table with Different Data Types In The Same Column](https://forum.inductiveautomation.com/t/table-with-different-data-types-in-the-same-column/61313)
**Author:** [@Steve\_McQueen](https://forum.inductiveautomation.com/u/Steve_McQueen)\ **Replies:** 1\ **Last updated:** [June 28, 2022, 5:58pm UTC](https://forum.inductiveautomation.com/t/table-with-different-data-types-in-the-same-column/61313 "2022-06-28T17:58:13Z")
I'm currently using Ignition 8.1. And I'm having trouble creating a table where one column has more than one data type. Where the table looks like something below: Tag Name | Data Type | Value | Timestamp Tag1 … --- ## [Gateway timer script to log folder of tags to SQL](https://forum.inductiveautomation.com/t/gateway-timer-script-to-log-folder-of-tags-to-sql/61180)
**Author:** [@ctodd](https://forum.inductiveautomation.com/u/ctodd)\ **Replies:** 22\ **Last updated:** [June 28, 2022, 5:55pm UTC](https://forum.inductiveautomation.com/t/gateway-timer-script-to-log-folder-of-tags-to-sql/61180 "2022-06-28T17:55:15Z")
I’m attempting to create a gateway script that will log all of the tags of a folder into the MySQL table on a time interval. This script does not report any errors when operating, but nothing appears in the SQL table. I’… --- ## [Write to OPC UDT tag arrays](https://forum.inductiveautomation.com/t/write-to-opc-udt-tag-arrays/61306)
**Author:** [@Davide\_Bortolini](https://forum.inductiveautomation.com/u/Davide_Bortolini)\ **Replies:** 0\ **Last updated:** [June 28, 2022, 4:10pm UTC](https://forum.inductiveautomation.com/t/write-to-opc-udt-tag-arrays/61306 "2022-06-28T16:10:44Z")
Hi, I’m trying to write to an OPC UDT using derived tag and jsonGet/jsonGet functions. I’ve setup mu OPC tag as Document type and the tag contains an array of elements like this: \[ { “i\_conformityResult”: 1 }, { “… --- ## [Ignition Voice: No compatible voice found](https://forum.inductiveautomation.com/t/ignition-voice-no-compatible-voice-found/61304)
**Author:** [@aidansks](https://forum.inductiveautomation.com/u/aidansks)\ **Replies:** 2\ **Last updated:** [June 28, 2022, 4:04pm UTC](https://forum.inductiveautomation.com/t/ignition-voice-no-compatible-voice-found/61304 "2022-06-28T16:04:32Z")
Hello, I am setting up Ignition Voice Notifications using Telnyx for my SIP connection. My alarm notification profile successfully registers with the VOIP host, but when the pipeline is started with that profile I receiv… --- ## [Ignition behind an apache reverse proxy, issue with perspective views](https://forum.inductiveautomation.com/t/ignition-behind-an-apache-reverse-proxy-issue-with-perspective-views/53576)
**Author:** [@Massimo\_Forni](https://forum.inductiveautomation.com/u/Massimo_Forni)\ **Replies:** 6\ **Last updated:** [June 27, 2022, 7:21pm UTC](https://forum.inductiveautomation.com/t/ignition-behind-an-apache-reverse-proxy-issue-with-perspective-views/53576 "2022-06-27T19:21:54Z")
Hello, I wanted to protect my Igniton (8.1.12) installation behind a reverse proxy, done with apache. I successfully configured apache to listen on ports 80 and 443 (with ssl offloading), on port 80 it redirects to the… --- ## [Non ASCII Characters in tags inserting in to postgres database tabel](https://forum.inductiveautomation.com/t/non-ascii-characters-in-tags-inserting-in-to-postgres-database-tabel/61228)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 9\ **Last updated:** [June 28, 2022, 11:46am UTC](https://forum.inductiveautomation.com/t/non-ascii-characters-in-tags-inserting-in-to-postgres-database-tabel/61228 "2022-06-28T11:46:45Z")
Hi i am inserting a tag in to databse table before inserting tag name \[default\]Montreal/IN40RM/Quality/Montreal\_Moulin/InspectionPoint/InspectionPointMeasures/Measure/Eau\_combinée\_Marmite\_1/CharacteristicValue inserte… --- ## ["Connection Lost" - "java.io.IOException: End of stream reached."](https://forum.inductiveautomation.com/t/connection-lost-java-io-ioexception-end-of-stream-reached/61288)
**Author:** [@Vengatesan\_S](https://forum.inductiveautomation.com/u/Vengatesan_S)\ **Replies:** 0\ **Last updated:** [June 28, 2022, 12:05pm UTC](https://forum.inductiveautomation.com/t/connection-lost-java-io-ioexception-end-of-stream-reached/61288 "2022-06-28T12:05:54Z")
I am getting this below mentioned error after adding a TCP driver with Port 2000. It worked fine for few days but suddenly i am facing this issue :java.io.IOException: End of stream reached. at com.inductiveautomation.… --- ## [Siemens S7-1500 Bit Arrays](https://forum.inductiveautomation.com/t/siemens-s7-1500-bit-arrays/22068)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 2\ **Last updated:** [June 28, 2022, 12:05pm UTC](https://forum.inductiveautomation.com/t/siemens-s7-1500-bit-arrays/22068 "2022-06-28T12:05:35Z")
I have seen one post inferring that the Siemen’s S7 driver in Ignition does NOT support accessing data in arrays in these PLCs. Is this true? I’m being given a listing of a Boolean Array in a 1500 PLC and doing some tes… --- ## [Transform Dataset](https://forum.inductiveautomation.com/t/transform-dataset/61284)
**Author:** [@Philip\_08012](https://forum.inductiveautomation.com/u/Philip_08012)\ **Replies:** 2\ **Last updated:** [June 28, 2022, 11:52am UTC](https://forum.inductiveautomation.com/t/transform-dataset/61284 "2022-06-28T11:52:49Z")
Hi all, Using a named Query I am returning “siteaddress” into a value display from a dataset. it returns the following: \[{“siteAddress”:“Texas”}\]. How would i manipulate this to return the column alone which is Texas … --- ## [Power table changing datasets and making them editable](https://forum.inductiveautomation.com/t/power-table-changing-datasets-and-making-them-editable/61231)
**Author:** [@Esn](https://forum.inductiveautomation.com/u/Esn)\ **Replies:** 2\ **Last updated:** [June 28, 2022, 7:04am UTC](https://forum.inductiveautomation.com/t/power-table-changing-datasets-and-making-them-editable/61231 "2022-06-28T07:04:34Z")
Hi, I’m trying to make a simple dataset editor tool where you can chose a dataset tag in a tag browse tree and then the data is displayed in a power table where you should be able to edit the data. The problem is that … --- ## [Dataset Bidirectional Binding](https://forum.inductiveautomation.com/t/dataset-bidirectional-binding/57317)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 5\ **Last updated:** [June 28, 2022, 6:55am UTC](https://forum.inductiveautomation.com/t/dataset-bidirectional-binding/57317 "2022-06-28T06:55:40Z")
I think I want to keep going through scripting in order to verify the edited values, but when editing a dataset in a table, it is possible to have the modified value written back to the dataset tag using bidirectional bi… --- ## [Perspective event scripts-touch event vs mouse event](https://forum.inductiveautomation.com/t/perspective-event-scripts-touch-event-vs-mouse-event/61261)
**Author:** [@Bradley\_Peay](https://forum.inductiveautomation.com/u/Bradley_Peay)\ **Replies:** 2\ **Last updated:** [June 27, 2022, 10:44pm UTC](https://forum.inductiveautomation.com/t/perspective-event-scripts-touch-event-vs-mouse-event/61261 "2022-06-27T22:44:06Z")
Hello, I am looking for some advice on touch events vs. mouse events for running button scripts. I am using a Hope HMI as the terminal screen and an android tablet as a remote viewer. The scripts work great when execu… --- ## [Classic Chart getting Null Paint Exception in X-Trace and Mark modes](https://forum.inductiveautomation.com/t/classic-chart-getting-null-paint-exception-in-x-trace-and-mark-modes/58513)
**Author:** [@Zachary\_Zipper](https://forum.inductiveautomation.com/u/Zachary_Zipper)\ **Replies:** 9\ **Last updated:** [June 27, 2022, 10:37pm UTC](https://forum.inductiveautomation.com/t/classic-chart-getting-null-paint-exception-in-x-trace-and-mark-modes/58513 "2022-06-27T22:37:27Z")
I am currently using the Classic Chart’s configureChart() function to change the color of the data points if it is outside of a user-defined spec limit. It is currently working as expected. However, when I go into X-… --- ## [Sepasoft WS XML Body Processing](https://forum.inductiveautomation.com/t/sepasoft-ws-xml-body-processing/61250)
**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Replies:** 4\ **Last updated:** [June 27, 2022, 7:08pm UTC](https://forum.inductiveautomation.com/t/sepasoft-ws-xml-body-processing/61250 "2022-06-27T19:08:26Z")
I am creating a Sepasoft Web Service endpoint to receive ERP data. Ignition 8.1.17, WS 3.81.1 (b2022042818). When I have a single record in the records section, there is no issue; the XML is automatically converted to… --- ## [No longer support OPC DA?](https://forum.inductiveautomation.com/t/no-longer-support-opc-da/60960)
**Author:** [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Replies:** 14\ **Last updated:** [June 27, 2022, 6:27pm UTC](https://forum.inductiveautomation.com/t/no-longer-support-opc-da/60960 "2022-06-27T18:27:11Z")
In 8.1.7, the OPC configuration included support for legacy OPC DA, which is what Rockwell Linx uses: I installed 8.1.18 and now see there is no support for OPC DA: Does this mean there is no longer support for l… --- ## [In config setting make a field "password type"](https://forum.inductiveautomation.com/t/in-config-setting-make-a-field-password-type/39757)
**Author:** [@mpervaiz](https://forum.inductiveautomation.com/u/mpervaiz)\ **Replies:** 9\ **Last updated:** [June 27, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/in-config-setting-make-a-field-password-type/39757 "2022-06-27T18:05:25Z")
for my module settings page (in config) I want to make one of the text fields a password field. Is that possible? --- ## [Diffrence between gateway backups made manually and automatically?](https://forum.inductiveautomation.com/t/diffrence-between-gateway-backups-made-manually-and-automatically/61247)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 5\ **Last updated:** [June 27, 2022, 5:32pm UTC](https://forum.inductiveautomation.com/t/diffrence-between-gateway-backups-made-manually-and-automatically/61247 "2022-06-27T17:32:01Z")
I have a 8.1.17 gateway that takes automatic backups. We have a backup VM (in case production goes down) that we routinely restore these auto backups to that sometimes give us an error and then we manually back up produ… --- ## [Reset Trial Not Permitting New Perspective Session](https://forum.inductiveautomation.com/t/reset-trial-not-permitting-new-perspective-session/61199)
**Author:** [@Sam\_Engsberg](https://forum.inductiveautomation.com/u/Sam_Engsberg)\ **Replies:** 1\ **Last updated:** [June 27, 2022, 3:40pm UTC](https://forum.inductiveautomation.com/t/reset-trial-not-permitting-new-perspective-session/61199 "2022-06-27T15:40:37Z")
Hi, I was working on my Perspective project yesterday using the trial mode activated from my laptop’s browser. This morning, I tried to enable the trial from my phone’s browser. After starting the trial, however, any per… --- ## [Generate report when a tag reaches a value](https://forum.inductiveautomation.com/t/generate-report-when-a-tag-reaches-a-value/61243)
**Author:** [@Israel\_Martinez\_Morr](https://forum.inductiveautomation.com/u/Israel_Martinez_Morr)\ **Replies:** 1\ **Last updated:** [June 27, 2022, 3:05pm UTC](https://forum.inductiveautomation.com/t/generate-report-when-a-tag-reaches-a-value/61243 "2022-06-27T15:05:27Z")
Hello, I would like to know if anyone knows if it is possible to generate an automatic report when a tag reaches a certain value. For example, if in a tag I am having a reading of values ​​but the reading drops to 0, a p… --- ## [Script Editor Issue in 8.1.18](https://forum.inductiveautomation.com/t/script-editor-issue-in-8-1-18/61242)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 1\ **Last updated:** [June 27, 2022, 2:55pm UTC](https://forum.inductiveautomation.com/t/script-editor-issue-in-8-1-18/61242 "2022-06-27T14:55:52Z")
We upgraded our servers and dev systems to 8.1.18 last week. Working in the Script Editor in the Designer, I’ve seen one project script file that, when opened, does not show the functions in the right hand pane, nor does… --- ## [XY Chart Not Displaying First Datapoint Label](https://forum.inductiveautomation.com/t/xy-chart-not-displaying-first-datapoint-label/61241)
**Author:** [@Samg23](https://forum.inductiveautomation.com/u/Samg23)\ **Replies:** 1\ **Last updated:** [June 27, 2022, 2:50pm UTC](https://forum.inductiveautomation.com/t/xy-chart-not-displaying-first-datapoint-label/61241 "2022-06-27T14:50:26Z")
I am currently working in ignition 8.1.7 and when sending a parameter to a XY chart that has an object with an array through a carousel view the first label is always absent, the error also persists if the table is not e… --- ## [Send and receiving json using MQTT in ignition](https://forum.inductiveautomation.com/t/send-and-receiving-json-using-mqtt-in-ignition/61224)
**Author:** [@user66](https://forum.inductiveautomation.com/u/user66)\ **Replies:** 3\ **Last updated:** [June 27, 2022, 2:36pm UTC](https://forum.inductiveautomation.com/t/send-and-receiving-json-using-mqtt-in-ignition/61224 "2022-06-27T14:36:02Z")
Hi all, I want to publish and subscribe to a json payload using MQTT without it being changed to tags. Can this be achieved in ignition? --- ## [CANVAS how to add or remove instances using click event](https://forum.inductiveautomation.com/t/canvas-how-to-add-or-remove-instances-using-click-event/61236)
**Author:** [@Thiago\_Vilela](https://forum.inductiveautomation.com/u/Thiago_Vilela)\ **Replies:** 8\ **Last updated:** [June 27, 2022, 2:28pm UTC](https://forum.inductiveautomation.com/t/canvas-how-to-add-or-remove-instances-using-click-event/61236 "2022-06-27T14:28:31Z")
Hello. I need to create a Python object to add or remove instances. The idea is to have a picture where the user clicks on and adds or removes an “X” mark. --- ## [Duplicate a View with a script](https://forum.inductiveautomation.com/t/duplicate-a-view-with-a-script/61229)
**Author:** [@Carla\_Ratto](https://forum.inductiveautomation.com/u/Carla_Ratto)\ **Replies:** 12\ **Last updated:** [June 27, 2022, 1:52pm UTC](https://forum.inductiveautomation.com/t/duplicate-a-view-with-a-script/61229 "2022-06-27T13:52:36Z")
Hi, Is it possible to create or duplicate a view with a script ? I searched for system functions that could help but didn’t find anything. Also, is there another function to pass parameters to this view ? Thank you, C… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=817) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=819)