# Ignition

**URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=944

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 945

---

## [Add style and value to json script](https://forum.inductiveautomation.com/t/add-style-and-value-to-json-script/52158)

<div class="topic-metadata">

**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Replies:** 11\
**Last updated:** [October 21, 2021, 1:26pm UTC](https://forum.inductiveautomation.com/t/add-style-and-value-to-json-script/52158 "2021-10-21T13:26:21Z")

</div>

Hello all, I am trying to change a dataset to json dataset with this script, I used this script in script transform section of a data property bininding: py\_data = system.dataset.toPyDataSet(value) data = \[\] headers…

---

## [Creating UDT raw. structure query](https://forum.inductiveautomation.com/t/creating-udt-raw-structure-query/52154)

<div class="topic-metadata">

**Author:** [@trishadx](https://forum.inductiveautomation.com/u/trishadx)\
**Replies:** 2\
**Last updated:** [October 21, 2021, 1:25pm UTC](https://forum.inductiveautomation.com/t/creating-udt-raw-structure-query/52154 "2021-10-21T13:25:07Z")

</div>

Hi guys I’ve created some UDT’s in designer using the tool. I’ve got quite a few more UDT’s to do, that all have a long list of different Booleans. I’m looking to create an excel sheet where i can paste the UDT structur…

---

## [Find can't find something in perspective session property change script](https://forum.inductiveautomation.com/t/find-cant-find-something-in-perspective-session-property-change-script/52163)

<div class="topic-metadata">

**Author:** [@ken.maze](https://forum.inductiveautomation.com/u/ken.maze)\
**Replies:** 2\
**Last updated:** [October 21, 2021, 1:22pm UTC](https://forum.inductiveautomation.com/t/find-cant-find-something-in-perspective-session-property-change-script/52163 "2021-10-21T13:22:14Z")

</div>

Hi, I have been using the find function to do some debug. Trying to find a place where I am updating a line in a SQL Server database. I only find one place where I am doing this, which I already determined I haven’t b…

---

## [How to set an expression tag to not change on false](https://forum.inductiveautomation.com/t/how-to-set-an-expression-tag-to-not-change-on-false/51983)

<div class="topic-metadata">

**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Replies:** 27\
**Last updated:** [October 21, 2021, 1:16pm UTC](https://forum.inductiveautomation.com/t/how-to-set-an-expression-tag-to-not-change-on-false/51983 "2021-10-21T13:16:23Z")

</div>

if true, I change the value, but on false, I don’t want to change the value. I am not sure how to make it not change though. Throws an error with “if (condition ,true)” without the false condition. Throws an error if …

---

## [Loading screen/gif during script execution](https://forum.inductiveautomation.com/t/loading-screen-gif-during-script-execution/48976)

<div class="topic-metadata">

**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Replies:** 11\
**Last updated:** [October 21, 2021, 12:53pm UTC](https://forum.inductiveautomation.com/t/loading-screen-gif-during-script-execution/48976 "2021-10-21T12:53:32Z")

</div>

Hi, In my perspective project, I created som transform scripts in charts to get a lot of data from my DB. These actions can last between 5 to 10 seconds. Is it possible to show a loading screen or hourglass pointer to …

---

## [Import translation](https://forum.inductiveautomation.com/t/import-translation/52181)

<div class="topic-metadata">

**Author:** [@laurie.croteau](https://forum.inductiveautomation.com/u/laurie.croteau)\
**Replies:** 3\
**Last updated:** [October 21, 2021, 12:28pm UTC](https://forum.inductiveautomation.com/t/import-translation/52181 "2021-10-21T12:28:11Z")

</div>

Hi, I need to translate a lot of string and I tried to do it in .xml file. I have export all my translation and I add at the end my new translation (in english and in french, in separated file). However, I can’t import …

---

## [How can I get the count and details of Vision clients open from script?](https://forum.inductiveautomation.com/t/how-can-i-get-the-count-and-details-of-vision-clients-open-from-script/52194)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 5\
**Last updated:** [October 21, 2021, 8:58am UTC](https://forum.inductiveautomation.com/t/how-can-i-get-the-count-and-details-of-vision-clients-open-from-script/52194 "2021-10-21T08:58:39Z")

</div>

I’m basically looking to get the detail that’s available on the gateway webpage for number of Vision clients open, similarly to the Perspective system.perspective.getSessionInfo(). There are no system functions that I c…

---

## [How to fix TypeError: Unable to convert row 1, column 3 to type class java.lang.Integer](https://forum.inductiveautomation.com/t/how-to-fix-typeerror-unable-to-convert-row-1-column-3-to-type-class-java-lang-integer/52186)

<div class="topic-metadata">

**Author:** [@jill.zhao](https://forum.inductiveautomation.com/u/jill.zhao)\
**Replies:** 3\
**Last updated:** [October 21, 2021, 8:13am UTC](https://forum.inductiveautomation.com/t/how-to-fix-typeerror-unable-to-convert-row-1-column-3-to-type-class-java-lang-integer/52186 "2021-10-21T08:13:52Z")

</div>

Hi I write the function to create a tag , I have test the script, I have successful get two output, but when I try the third input, it said : File "\<input\>", line 1, in \<module\> File "\<module:waterfall.handler2\>", l…

---

## [Auto Kill Switch Script RAM and/or Timeout](https://forum.inductiveautomation.com/t/auto-kill-switch-script-ram-and-or-timeout/52197)

<div class="topic-metadata">

**Author:** [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\
**Replies:** 3\
**Last updated:** [October 21, 2021, 7:55am UTC](https://forum.inductiveautomation.com/t/auto-kill-switch-script-ram-and-or-timeout/52197 "2021-10-21T07:55:16Z")

</div>

Hi all, I’ve been wondering if killing a script/Gateway Scope can be canceled further than manual action hitting on “Cancel”. and do it automatically I think is simple to implement a self.interrupt with ScriptManage…

---

## [\[SOLVED\] Native launcher not starting under Zulu built in JRE linux](https://forum.inductiveautomation.com/t/solved-native-launcher-not-starting-under-zulu-built-in-jre-linux/52196)

<div class="topic-metadata">

**Author:** [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\
**Replies:** 2\
**Last updated:** [October 21, 2021, 4:05am UTC](https://forum.inductiveautomation.com/t/solved-native-launcher-not-starting-under-zulu-built-in-jre-linux/52196 "2021-10-21T04:05:57Z")

</div>

Installing native client (linux 64bit arch) on a small format PC (AMD Ryzen 3 4300U/Video baked in AMD Renoir) Ignition 7.9.18 ( b2021062913) Cannot start client on X (xorg version 1.20.13-2) if I use the ignition supp…

---

## [PI connecting path - ignition master or edge](https://forum.inductiveautomation.com/t/pi-connecting-path-ignition-master-or-edge/52199)

<div class="topic-metadata">

**Author:** [@YL\_Synergy](https://forum.inductiveautomation.com/u/YL_Synergy)\
**Replies:** 0\
**Last updated:** [October 21, 2021, 2:53am UTC](https://forum.inductiveautomation.com/t/pi-connecting-path-ignition-master-or-edge/52199 "2021-10-21T02:53:24Z")

</div>

Hi there, what is ignition’s recommendation of the connecting path to OSI PI historian? We have a central Master gateway and a few edge gateway connecting to the central master. where would be the recommended path to con…

---

## [Best Perspective component](https://forum.inductiveautomation.com/t/best-perspective-component/52178)

<div class="topic-metadata">

**Author:** [@user59](https://forum.inductiveautomation.com/u/user59)\
**Replies:** 12\
**Last updated:** [October 21, 2021, 12:32am UTC](https://forum.inductiveautomation.com/t/best-perspective-component/52178 "2021-10-21T00:32:01Z")

</div>

What is the best Perspective component to show the On/Off status of a devce?

---

## [Main script location for multiple gateways](https://forum.inductiveautomation.com/t/main-script-location-for-multiple-gateways/52179)

<div class="topic-metadata">

**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\
**Replies:** 9\
**Last updated:** [October 21, 2021, 12:18am UTC](https://forum.inductiveautomation.com/t/main-script-location-for-multiple-gateways/52179 "2021-10-21T00:18:06Z")

</div>

I have a frontend gateway housing a perspective project and a backend gateway housing the connection to a database and a connection to the plc. There will be another backend gateway housing connection to a database and …

---

## [Perspective Table Row Wrap](https://forum.inductiveautomation.com/t/perspective-table-row-wrap/44401)

<div class="topic-metadata">

**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Replies:** 1\
**Last updated:** [October 20, 2021, 6:14pm UTC](https://forum.inductiveautomation.com/t/perspective-table-row-wrap/44401 "2021-10-20T18:14:07Z")

</div>

8.1.2 - Is there a way to prevent data from causing wrap within a Perspective Table cell? I looked at this thread and tried using the height property and also textOverflow: clip, but that just squished everything ins…

---

## [Vertically center popup but fixed X position](https://forum.inductiveautomation.com/t/vertically-center-popup-but-fixed-x-position/52161)

<div class="topic-metadata">

**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Replies:** 2\
**Last updated:** [October 20, 2021, 5:54pm UTC](https://forum.inductiveautomation.com/t/vertically-center-popup-but-fixed-x-position/52161 "2021-10-20T17:54:00Z")

</div>

Using Windows and Ignition 8.1 I have a navigation popup that due to animation can’t be a docked window, and I need to set the popup location to a fixed X position (0), but vertically centered in the screen. I’m openin…

---

## [How to Reserve a Tag Provider Name in the Gateway](https://forum.inductiveautomation.com/t/how-to-reserve-a-tag-provider-name-in-the-gateway/52028)

<div class="topic-metadata">

**Author:** [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\
**Replies:** 16\
**Last updated:** [October 20, 2021, 5:41pm UTC](https://forum.inductiveautomation.com/t/how-to-reserve-a-tag-provider-name-in-the-gateway/52028 "2021-10-20T17:41:43Z")

</div>

I’m in a situation where I need to be able to reserve a name of tag provider in the server. Something like “System” tag provider name, is well know is a reserved name. I was wondering if this is posible to reserve a …

---

## [\[IGN-4923\]Page-config and git](https://forum.inductiveautomation.com/t/ign-4923-page-config-and-git/52171)

<div class="topic-metadata">

**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\
**Replies:** 1\
**Last updated:** [October 20, 2021, 5:25pm UTC](https://forum.inductiveautomation.com/t/ign-4923-page-config-and-git/52171 "2021-10-20T17:25:04Z")

</div>

I’d like it if Ignition could stop reordering all of page-config/config.json any time I touch it. As we move to a more git-devops-based workflow, being able to look at diffs to see what changed is useful. When it random…

---

## [Text area background color change automatically](https://forum.inductiveautomation.com/t/text-area-background-color-change-automatically/46096)

<div class="topic-metadata">

**Author:** [@clement.faure](https://forum.inductiveautomation.com/u/clement.faure)\
**Replies:** 6\
**Last updated:** [October 20, 2021, 4:39pm UTC](https://forum.inductiveautomation.com/t/text-area-background-color-change-automatically/46096 "2021-10-20T16:39:26Z")

</div>

Hi, I’m working on a new application and i have a text area with black background color by default, when i toggle in preview mode, focus on the text area change automatically background to white color and i don’t unders…

---

## [Perspective Table Double Click on Mobile](https://forum.inductiveautomation.com/t/perspective-table-double-click-on-mobile/52165)

<div class="topic-metadata">

**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\
**Replies:** 1\
**Last updated:** [October 20, 2021, 3:33pm UTC](https://forum.inductiveautomation.com/t/perspective-table-double-click-on-mobile/52165 "2021-10-20T15:33:27Z")

</div>

Has anyone been able to get the double click extension function to fire on a table while on mobile? I can get it to execute on desktop but if I double tap it from my phone, it doesn’t execute.

---

## [\[FEATURE\] Designer - Add icon to show Gateway Events have been configured](https://forum.inductiveautomation.com/t/feature-designer-add-icon-to-show-gateway-events-have-been-configured/52142)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 1\
**Last updated:** [October 20, 2021, 3:29pm UTC](https://forum.inductiveautomation.com/t/feature-designer-add-icon-to-show-gateway-events-have-been-configured/52142 "2021-10-20T15:29:32Z")

</div>

Currently there’s no indication from the project browser that any gateway events are configured. It would be great to have an icon or icons to show what has been configured. It would also be good to maintain consisten…

---

## [How to Set background color to flex repeater](https://forum.inductiveautomation.com/t/how-to-set-background-color-to-flex-repeater/52151)

<div class="topic-metadata">

**Author:** [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\
**Replies:** 11\
**Last updated:** [October 20, 2021, 2:56pm UTC](https://forum.inductiveautomation.com/t/how-to-set-background-color-to-flex-repeater/52151 "2021-10-20T14:56:38Z")

</div>

Hi, I have one screen in that I have used multiple flex repeaters. I want to do search functionality, What ever number entered in text field to search, It should get highlight. here I am searching for 180 so 180 sh…

---

## [Not able to edit perspective table cells after applying the color transform script](https://forum.inductiveautomation.com/t/not-able-to-edit-perspective-table-cells-after-applying-the-color-transform-script/52060)

<div class="topic-metadata">

**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Replies:** 11\
**Last updated:** [October 20, 2021, 2:49pm UTC](https://forum.inductiveautomation.com/t/not-able-to-edit-perspective-table-cells-after-applying-the-color-transform-script/52060 "2021-10-20T14:49:09Z")

</div>

Hello everyone, I have a perspective table with an event script configured on “onEditCellCommit”. #GET EDITED DATA DETAILS rowIndex=event.row # row number of the commit colName=event.column # column n…

---

## [MySQL Error only on Backup](https://forum.inductiveautomation.com/t/mysql-error-only-on-backup/52152)

<div class="topic-metadata">

**Author:** [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\
**Replies:** 1\
**Last updated:** [October 20, 2021, 1:02pm UTC](https://forum.inductiveautomation.com/t/mysql-error-only-on-backup/52152 "2021-10-20T13:02:45Z")

</div>

I’m getting the following error only on the backup gateway and I can’t understand why. I know the user it is using allows connections outside of localhost. Any help would be appreciated. java.sql.SQLException: Cannot …

---

## [Ignition 8.1.2: Error Saving Node Configuration in wrapper.log](https://forum.inductiveautomation.com/t/ignition-8-1-2-error-saving-node-configuration-in-wrapper-log/44215)

<div class="topic-metadata">

**Author:** [@pgmo](https://forum.inductiveautomation.com/u/pgmo)\
**Replies:** 5\
**Last updated:** [October 20, 2021, 12:56pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-2-error-saving-node-configuration-in-wrapper-log/44215 "2021-10-20T12:56:15Z")

</div>

One month ago I upgraded an Ignition Gateway from 7.9.8 to 8.1.2 (b2021020311). Two days ago the wrapper.log started recording the following error every 2 seconds Any suggestion? Thanks in advance, regards

---

## [How do I close all open Perspective sessions?](https://forum.inductiveautomation.com/t/how-do-i-close-all-open-perspective-sessions/52143)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 2\
**Last updated:** [October 20, 2021, 12:40pm UTC](https://forum.inductiveautomation.com/t/how-do-i-close-all-open-perspective-sessions/52143 "2021-10-20T12:40:52Z")

</div>

I have a test gateway that only has 2 perspective sessions licensed. I’m at that limit because sessions have been opened and the browser closed in quick succession. I’m trying to force close them all so I can start a per…

---

## [Creating a form to print out](https://forum.inductiveautomation.com/t/creating-a-form-to-print-out/51697)

<div class="topic-metadata">

**Author:** [@toddayers](https://forum.inductiveautomation.com/u/toddayers)\
**Replies:** 7\
**Last updated:** [October 20, 2021, 12:21pm UTC](https://forum.inductiveautomation.com/t/creating-a-form-to-print-out/51697 "2021-10-20T12:21:43Z")

</div>

I have a project where employees fill out information and I was wondering if there is a way to create a form that when the employee clicks a print button, the form would print out for the employee.

---

## [Data Viz and Sequential CSS Variables](https://forum.inductiveautomation.com/t/data-viz-and-sequential-css-variables/52145)

<div class="topic-metadata">

**Author:** [@matthew.gollasch](https://forum.inductiveautomation.com/u/matthew.gollasch)\
**Replies:** 0\
**Last updated:** [October 20, 2021, 7:10am UTC](https://forum.inductiveautomation.com/t/data-viz-and-sequential-css-variables/52145 "2021-10-20T07:10:34Z")

</div>

Can anyone tell me where the Perspective theme CSS variables "Data Viz: Qualitative", "Data Viz: Diverging" and "Sequential" are used? When I search through the built in Perspective "Light" theme I can see heavy use of t…

---

## [\[BUG\] v8.1.5 Project isn't honouring default tag provider](https://forum.inductiveautomation.com/t/bug-v8-1-5-project-isnt-honouring-default-tag-provider/52141)

<div class="topic-metadata">

**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Replies:** 0\
**Last updated:** [October 20, 2021, 3:47am UTC](https://forum.inductiveautomation.com/t/bug-v8-1-5-project-isnt-honouring-default-tag-provider/52141 "2021-10-20T03:47:12Z")

</div>

I have a gateway which has multiple tag providers. If I change one of my project’s default tag provider to something else and save, the new one goes bold in the Tag Browser drop down to select tag providers, but referenc…

---

## [Fingerprint reader integration](https://forum.inductiveautomation.com/t/fingerprint-reader-integration/52136)

<div class="topic-metadata">

**Author:** [@jorge.galvez](https://forum.inductiveautomation.com/u/jorge.galvez)\
**Replies:** 0\
**Last updated:** [October 19, 2021, 11:23pm UTC](https://forum.inductiveautomation.com/t/fingerprint-reader-integration/52136 "2021-10-19T23:23:36Z")

</div>

Hello! Does anyone have done fingerprint authentication with mobile phones, tablets or external hardware? We have a customer who is asking for using both a USB fingerprint reader and a Galaxy Tab which has it´s own reade…

---

## [How to change cell color in message handler](https://forum.inductiveautomation.com/t/how-to-change-cell-color-in-message-handler/52130)

<div class="topic-metadata">

**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Replies:** 1\
**Last updated:** [October 19, 2021, 8:48pm UTC](https://forum.inductiveautomation.com/t/how-to-change-cell-color-in-message-handler/52130 "2021-10-19T20:48:33Z")

</div>

Hello All, I am trying to change the color of a specific cell (process\_value) based on the value of two columns (low limit, high limit). I have the script below in the message handler. However, with this script the whol…

[Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=943)

[Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=945)
