# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=332 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 333 --- ## [Reading 'DInt' Tag with Minus Sign.](https://forum.inductiveautomation.com/t/reading-dint-tag-with-minus-sign/22541)
**Author:** [@Ralpho](https://forum.inductiveautomation.com/u/Ralpho)\ **Replies:** 6\ **Last updated:** [September 20, 2024, 4:04am UTC](https://forum.inductiveautomation.com/t/reading-dint-tag-with-minus-sign/22541 "2024-09-20T04:04:30Z")
Im trying to read a DInt tag from TIA Portal and the value is -4. En Ignition Designer/Tag Editor/General Properties i have selected Data Type as a Long but the tag value dont have any relation with the real value, look… --- ## [Exporting SQL Database data to Excel?](https://forum.inductiveautomation.com/t/exporting-sql-database-data-to-excel/96206)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 3\ **Last updated:** [September 19, 2024, 9:06pm UTC](https://forum.inductiveautomation.com/t/exporting-sql-database-data-to-excel/96206 "2024-09-19T21:06:56Z")
Is there a way to export data from a SQL database without creating a report? I know how to create a report and populate with data from my SQL database and once the report is generated you can export to excel and this wo… --- ## [Transform a Column](https://forum.inductiveautomation.com/t/transform-a-column/96202)
**Author:** [@Tyler\_French](https://forum.inductiveautomation.com/u/Tyler_French)\ **Replies:** 3\ **Last updated:** [September 19, 2024, 8:09pm UTC](https://forum.inductiveautomation.com/t/transform-a-column/96202 "2024-09-19T20:09:40Z")
Is there an easy way to transform a single column's value using a script? I am rather new to this and looking for a way to transform the minutes remaining in an order to hours, so I just want to divide the returned valu… --- ## [Is it possible to have an editable excel spreedsheet in perspective?](https://forum.inductiveautomation.com/t/is-it-possible-to-have-an-editable-excel-spreedsheet-in-perspective/95953)
**Author:** [@Alex\_Ford-King](https://forum.inductiveautomation.com/u/Alex_Ford-King)\ **Replies:** 11\ **Last updated:** [September 19, 2024, 8:05pm UTC](https://forum.inductiveautomation.com/t/is-it-possible-to-have-an-editable-excel-spreedsheet-in-perspective/95953 "2024-09-19T20:05:56Z")
Im trying to create a page in perspective that one user can enter information on a spreedsheet and all others can view it. Right now the plant has a shared excel spreedsheet but we want to have it displayed on the prespe… --- ## [GraalPy or GraalJS with Ignition](https://forum.inductiveautomation.com/t/graalpy-or-graaljs-with-ignition/96136)
**Author:** [@Nick\_Hotto](https://forum.inductiveautomation.com/u/Nick_Hotto)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 7:59pm UTC](https://forum.inductiveautomation.com/t/graalpy-or-graaljs-with-ignition/96136 "2024-09-19T19:59:53Z")
With GraalPy gaining traction as the de facto Python 3 runtime on the JVM - has anyone tried implementing GraalPy or GraalJS with ignition? --- ## [String Array Tag Read Fallback](https://forum.inductiveautomation.com/t/string-array-tag-read-fallback/96196)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 2\ **Last updated:** [September 19, 2024, 6:27pm UTC](https://forum.inductiveautomation.com/t/string-array-tag-read-fallback/96196 "2024-09-19T18:27:49Z")
I've scripted a read from a string array tag using a tag path parameter to the function. I want to define the behavior when the tag path is empty or none. So, how do I assign an empty string array to the same variable, … --- ## [After creating user we unable to find out here user for better understanding](https://forum.inductiveautomation.com/t/after-creating-user-we-unable-to-find-out-here-user-for-better-understanding/96108)
**Author:** [@Kaustubh\_Joshi](https://forum.inductiveautomation.com/u/Kaustubh_Joshi)\ **Replies:** 2\ **Last updated:** [September 19, 2024, 6:01pm UTC](https://forum.inductiveautomation.com/t/after-creating-user-we-unable-to-find-out-here-user-for-better-understanding/96108 "2024-09-19T18:01:03Z")
--- ## [JDBC failed after Ignition Upgrade](https://forum.inductiveautomation.com/t/jdbc-failed-after-ignition-upgrade/84586)
**Author:** [@anthony\_ho](https://forum.inductiveautomation.com/u/anthony_ho)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 4:31pm UTC](https://forum.inductiveautomation.com/t/jdbc-failed-after-ignition-upgrade/84586 "2024-09-19T16:31:17Z")
We have a Test server that mirrors a Production Server. Both have version 8.1.32. I have the latest snowflake-jdbc-3.14.4 installed on both servers and they were making connections to a Snowflake database fine. But afte… --- ## [How to populate a Tree display from a query](https://forum.inductiveautomation.com/t/how-to-populate-a-tree-display-from-a-query/96176)
**Author:** [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\ **Replies:** 14\ **Last updated:** [September 19, 2024, 3:42pm UTC](https://forum.inductiveautomation.com/t/how-to-populate-a-tree-display-from-a-query/96176 "2024-09-19T15:42:21Z")
Hello! I do have a query that gives me data like this: I would like if possible to bind this data to my tree view but I don´t know where to bind it. Should I use a change script? SOLICITANTE would be the first fol… --- ## [Transaction Group Execute too early](https://forum.inductiveautomation.com/t/transaction-group-execute-too-early/96179)
**Author:** [@Raphael](https://forum.inductiveautomation.com/u/Raphael)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 2:28pm UTC](https://forum.inductiveautomation.com/t/transaction-group-execute-too-early/96179 "2024-09-19T14:28:31Z")
Hello, I have set up a transaction Group for calling a stored procedures in SQL Server. There are : one input parameter one output parameter one trigger Sometimes, the transaction is fired before Ignition get the in… --- ## [Duplicate Easy Chart Pen](https://forum.inductiveautomation.com/t/duplicate-easy-chart-pen/96183)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 2:23pm UTC](https://forum.inductiveautomation.com/t/duplicate-easy-chart-pen/96183 "2024-09-19T14:23:24Z")
Is there an easy way to duplicate a row (pen) in the easy chart component? Many of my rows are the same minus one number and the color. For instance, I have the pens Pump 1/Speed | \[tagHistory:ignition-desktop-av9al01:… --- ## [Find/Replace Tag Value Question](https://forum.inductiveautomation.com/t/find-replace-tag-value-question/11841)
**Author:** [@hgarner](https://forum.inductiveautomation.com/u/hgarner)\ **Replies:** 7\ **Last updated:** [September 19, 2024, 2:21pm UTC](https://forum.inductiveautomation.com/t/find-replace-tag-value-question/11841 "2024-09-19T14:21:39Z")
We are interested in searching for a tag value within a project. We have a number of string tags within UDTs that hold values we may need to find through the course of our development. We have tried using the Find/Replac… --- ## [Writing to EDC TCP on Ax350i Domino InkJet Printers](https://forum.inductiveautomation.com/t/writing-to-edc-tcp-on-ax350i-domino-inkjet-printers/96149)
**Author:** [@cdrizzy](https://forum.inductiveautomation.com/u/cdrizzy)\ **Replies:** 0\ **Last updated:** [September 18, 2024, 7:37pm UTC](https://forum.inductiveautomation.com/t/writing-to-edc-tcp-on-ax350i-domino-inkjet-printers/96149 "2024-09-18T19:37:36Z")
I had made a post a while back about sending commands to Domino Inkjet Printers, and had a lot of questions answered and was able to successfully query the printers for status and levels: I have next been trying to fig… --- ## [Issue with MySQL and Ignition](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171)
**Author:** [@Filippos\_Onisiforou](https://forum.inductiveautomation.com/u/Filippos_Onisiforou)\ **Replies:** 10\ **Last updated:** [September 19, 2024, 1:31pm UTC](https://forum.inductiveautomation.com/t/issue-with-mysql-and-ignition/96171 "2024-09-19T13:31:23Z")
Hello Guys, i have a problem with Mysql and Ignition . Although it seems that Ignition Located the Mysql Database ,nothing are store in the database. I saw the video provided by ingition but i have not seen any example o… --- ## [Ignition Badge Auth with Remeber Me Expiration](https://forum.inductiveautomation.com/t/ignition-badge-auth-with-remeber-me-expiration/96169)
**Author:** [@Alessandro\_Oliosi](https://forum.inductiveautomation.com/u/Alessandro_Oliosi)\ **Replies:** 0\ **Last updated:** [September 19, 2024, 7:45am UTC](https://forum.inductiveautomation.com/t/ignition-badge-auth-with-remeber-me-expiration/96169 "2024-09-19T07:45:56Z")
Hi there, I'm working on a mobile app for our operators and I would like them to login using the badge authentication method. I noticed the Remember Me option on the Identity Provider settings and I tested it successful… --- ## [Popup messaged based on tag](https://forum.inductiveautomation.com/t/popup-messaged-based-on-tag/96098)
**Author:** [@Rahul\_solanki](https://forum.inductiveautomation.com/u/Rahul_solanki)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 12:10pm UTC](https://forum.inductiveautomation.com/t/popup-messaged-based-on-tag/96098 "2024-09-19T12:10:13Z")
I have 40 boolean tags. I want to have a popup when ever the boolean tag is high and should close when the tag is low. Each tag should have separate pop up. Any help would be appreciated on this --- ## [Omron FINS Driver - Intermittent Drop Out](https://forum.inductiveautomation.com/t/omron-fins-driver-intermittent-drop-out/33720)
**Author:** [@tjcorbin](https://forum.inductiveautomation.com/u/tjcorbin)\ **Replies:** 14\ **Last updated:** [September 19, 2024, 10:06am UTC](https://forum.inductiveautomation.com/t/omron-fins-driver-intermittent-drop-out/33720 "2024-09-19T10:06:17Z")
I am currently trialing the Omron FINS driver on a new project. Ignition V8.0.9 OPC UA V8.0.9 Omron Driver 3.0.9 I have set up the Omron Device using the UDP connection. It connects fine and shows ‘Bound’. I have s… --- ## [The Session Custom is missing](https://forum.inductiveautomation.com/t/the-session-custom-is-missing/95988)
**Author:** [@Senthee\_Wu](https://forum.inductiveautomation.com/u/Senthee_Wu)\ **Replies:** 9\ **Last updated:** [September 19, 2024, 9:50am UTC](https://forum.inductiveautomation.com/t/the-session-custom-is-missing/95988 "2024-09-19T09:50:33Z")
Hello,I'm having a problem.I can't open session.custom in Perspective Property Editor.I try four device,all of them have this problem.I'm want to edit a binding right now.Please help me to solve it. --- ## [Error with number format in perspective table](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593)
**Author:** [@Flavia\_Delli](https://forum.inductiveautomation.com/u/Flavia_Delli)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 8:24am UTC](https://forum.inductiveautomation.com/t/error-with-number-format-in-perspective-table/86593 "2024-09-19T08:24:16Z")
Hello, I'm on ignition 8.1.31. I have a table with float numbers that have to follow the locale format. Example: en-US -\> 1,000.5 it-IT -\> 1.000,5 At this moment even if I change the locale in the perspective sessi… --- ## [\[FEATURE-done 8.1.8\] Perspective 'theme' session prop missing custom themes](https://forum.inductiveautomation.com/t/feature-done-8-1-8-perspective-theme-session-prop-missing-custom-themes/47265)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [May 30, 2021, 11:26pm UTC](https://forum.inductiveautomation.com/t/feature-done-8-1-8-perspective-theme-session-prop-missing-custom-themes/47265 "2021-05-30T23:26:04Z")
If you add custom themes in the same format as IA themes (i.e. with an index.css in the root and sub folder with definitions), these custom themes are not included within the theme selection in the session props. In fact… --- ## [Identifying and removing unused parameters, SQL queries etc](https://forum.inductiveautomation.com/t/identifying-and-removing-unused-parameters-sql-queries-etc/96165)
**Author:** [@Olli\_Burr](https://forum.inductiveautomation.com/u/Olli_Burr)\ **Replies:** 0\ **Last updated:** [September 19, 2024, 6:37am UTC](https://forum.inductiveautomation.com/t/identifying-and-removing-unused-parameters-sql-queries-etc/96165 "2024-09-19T06:37:42Z")
Hi guys, I got one question... I've just Updated a rather massive IGNITION App with tons of Parameters and SQL Queries... I've stumbled upon a few Parameters which are of no longer use... As I want to tidy up my work I… --- ## [Vision Status Chart Tooltip Format](https://forum.inductiveautomation.com/t/vision-status-chart-tooltip-format/96102)
**Author:** [@jchen](https://forum.inductiveautomation.com/u/jchen)\ **Replies:** 4\ **Last updated:** [September 19, 2024, 1:33am UTC](https://forum.inductiveautomation.com/t/vision-status-chart-tooltip-format/96102 "2024-09-19T01:33:38Z")
Hi there, Is there a way to convert the date format of the status chart tooltip to other style such as "yyyy/MM/dd HH:mm:ss". I found a similiar topic below and tried, but the date changes when the mouse moves along… --- ## [Web Dev URL Dont Load Icons](https://forum.inductiveautomation.com/t/web-dev-url-dont-load-icons/96138)
**Author:** [@Francisco\_Ochoa](https://forum.inductiveautomation.com/u/Francisco_Ochoa)\ **Replies:** 15\ **Last updated:** [September 18, 2024, 9:54pm UTC](https://forum.inductiveautomation.com/t/web-dev-url-dont-load-icons/96138 "2024-09-18T21:54:30Z")
Hi Everyone I have a issue with a extern URL , the idea is to show in Inline Frame the website but the icons dont show when i open the view. This is from Web Browser --- ## [System.perspective.download() in an Android Tablet](https://forum.inductiveautomation.com/t/system-perspective-download-in-an-android-tablet/96081)
**Author:** [@Samuel\_Sinohui](https://forum.inductiveautomation.com/u/Samuel_Sinohui)\ **Replies:** 5\ **Last updated:** [September 18, 2024, 9:33pm UTC](https://forum.inductiveautomation.com/t/system-perspective-download-in-an-android-tablet/96081 "2024-09-18T21:33:23Z")
When I use the command: system.perspective.download() in the Ignition Designer, the save prompt appears with no issues (I have it linked to a button). But when I try this on the Ignition Perspective App in my Samsung Ta… --- ## [Java version recommended](https://forum.inductiveautomation.com/t/java-version-recommended/80131)
**Author:** [@Miguel\_Cimildoro](https://forum.inductiveautomation.com/u/Miguel_Cimildoro)\ **Replies:** 8\ **Last updated:** [September 18, 2024, 8:54pm UTC](https://forum.inductiveautomation.com/t/java-version-recommended/80131 "2024-09-18T20:54:33Z")
good morning, I open this post precisely to determine which is the recommended Java version to install on the system and have a good performance of designer ignition. I have installed version 8 .381 and I have had a lo… --- ## [Getting the name of the Database Dynamically](https://forum.inductiveautomation.com/t/getting-the-name-of-the-database-dynamically/96147)
**Author:** [@Farhan\_Basheer](https://forum.inductiveautomation.com/u/Farhan_Basheer)\ **Replies:** 14\ **Last updated:** [September 18, 2024, 8:23pm UTC](https://forum.inductiveautomation.com/t/getting-the-name-of-the-database-dynamically/96147 "2024-09-18T20:23:04Z")
I have a Insert Query execution method. Which is being used to insert the data in the database. def onMessageReceived(self, payload): user = self.session.props.auth.user.userName if payload\['confirm'\]: data = payloa… --- ## [Treeview component: Detect when expand button is pressed](https://forum.inductiveautomation.com/t/treeview-component-detect-when-expand-button-is-pressed/82504)
**Author:** [@Hyphriend](https://forum.inductiveautomation.com/u/Hyphriend)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 6:32pm UTC](https://forum.inductiveautomation.com/t/treeview-component-detect-when-expand-button-is-pressed/82504 "2024-09-18T18:32:06Z")
Hi all! I want to display a lot of categorized data with a treeview component. Instead of loading the data all at once, i want to run a script that updates the dataset when one of the expand button is pressed. Is ther… --- ## [List Rosters In Pipeline](https://forum.inductiveautomation.com/t/list-rosters-in-pipeline/96094)
**Author:** [@Pico\_Sankari](https://forum.inductiveautomation.com/u/Pico_Sankari)\ **Replies:** 2\ **Last updated:** [September 18, 2024, 5:44pm UTC](https://forum.inductiveautomation.com/t/list-rosters-in-pipeline/96094 "2024-09-18T17:44:10Z")
I would like to be able to enter a pipeline name in a script and find out what rosters are in the pipeline's blocks. Is this possible? --- ## [Remote Alarm Journal](https://forum.inductiveautomation.com/t/remote-alarm-journal/36479)
**Author:** [@niravad](https://forum.inductiveautomation.com/u/niravad)\ **Replies:** 4\ **Last updated:** [September 18, 2024, 5:15pm UTC](https://forum.inductiveautomation.com/t/remote-alarm-journal/36479 "2024-09-18T17:15:23Z")
Hi All, Ignition Edge Install in plant and Ignition Central Server install in Cloud server. Problem is Remote Alarm Journal not sync with edge sync service. Here is error " Remote server \[Ignition-Central Gateway\] do… --- ## ["First" Alarm Only](https://forum.inductiveautomation.com/t/first-alarm-only/96139)
**Author:** [@gregory.sachs](https://forum.inductiveautomation.com/u/gregory.sachs)\ **Replies:** 5\ **Last updated:** [September 18, 2024, 4:27pm UTC](https://forum.inductiveautomation.com/t/first-alarm-only/96139 "2024-09-18T16:27:32Z")
Hi-Been working on alarms and equipment downtime analysis, and one issue we commonly run into on existing equipment is that they may have multiple alarm states active at the same time; for example "Light Curtain Broken" … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=331) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=333)