# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=222 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 223 --- ## [Access Tag Reference Tracker by Script](https://forum.inductiveautomation.com/t/access-tag-reference-tracker-by-script/97943)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 10\ **Last updated:** [March 28, 2025, 10:31pm UTC](https://forum.inductiveautomation.com/t/access-tag-reference-tracker-by-script/97943 "2025-03-28T22:31:27Z")
Is it possible to retrieve the Tag Reference Tracker log in the script? Right now KI only can access this info from the designer tag diagnostic. It will be really handy for searching. --- ## [Perspective Stacked Bar Chart - Sorting Largest to Smallest](https://forum.inductiveautomation.com/t/perspective-stacked-bar-chart-sorting-largest-to-smallest/104405)
**Author:** [@Eric\_Meyer](https://forum.inductiveautomation.com/u/Eric_Meyer)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 10:15pm UTC](https://forum.inductiveautomation.com/t/perspective-stacked-bar-chart-sorting-largest-to-smallest/104405 "2025-03-28T22:15:07Z")
Hey everyone - I am pulling in a dataset via a named query and have a stacked bar chart setup and working with 11 columns. The 12th is a totalizer used as a label on top of the stacks. Is there a best way to sort these l… --- ## [system.tag.getConfiguration -\> valid JSON object](https://forum.inductiveautomation.com/t/system-tag-getconfiguration-valid-json-object/104398)
**Author:** [@sherman](https://forum.inductiveautomation.com/u/sherman)\ **Replies:** 10\ **Last updated:** [March 28, 2025, 9:24pm UTC](https://forum.inductiveautomation.com/t/system-tag-getconfiguration-valid-json-object/104398 "2025-03-28T21:24:06Z")
I want to export my tag configuration as a valid json object so I can mutate it by script. When I try to run the following, it inevitably bounces off of some custom class objects that come out of the configuration. Is th… --- ## [Transaction Group writing -1 instead of Latched Value](https://forum.inductiveautomation.com/t/transaction-group-writing-1-instead-of-latched-value/104403)
**Author:** [@jesse.daniels](https://forum.inductiveautomation.com/u/jesse.daniels)\ **Replies:** 8\ **Last updated:** [March 28, 2025, 9:06pm UTC](https://forum.inductiveautomation.com/t/transaction-group-writing-1-instead-of-latched-value/104403 "2025-03-28T21:06:04Z")
i have a transaction group returning data from a view in database writing to PLC tags. i'm using one tag to line up the correct row to return from the view in the update/select area The TG writes the columns into four di… --- ## [Connect Ignition to DataBricks EDL](https://forum.inductiveautomation.com/t/connect-ignition-to-databricks-edl/53559)
**Author:** [@Gaurav.Shitole](https://forum.inductiveautomation.com/u/Gaurav.Shitole)\ **Replies:** 5\ **Last updated:** [March 28, 2025, 8:30pm UTC](https://forum.inductiveautomation.com/t/connect-ignition-to-databricks-edl/53559 "2025-03-28T20:30:50Z")
Hello there, I have never connected Ignition gateway with DataBricks EDL connection. I want to do this now with JDBC Driver. I’ve added JDBC driver with spark jar. Now I am not getting how to get Connect URL and genera… --- ## [Tool to convert CSV/Excel to Dataset tag format](https://forum.inductiveautomation.com/t/tool-to-convert-csv-excel-to-dataset-tag-format/104402)
**Author:** [@Harry\_O\_Brien](https://forum.inductiveautomation.com/u/Harry_O_Brien)\ **Replies:** 0\ **Last updated:** [March 28, 2025, 8:09pm UTC](https://forum.inductiveautomation.com/t/tool-to-convert-csv-excel-to-dataset-tag-format/104402 "2025-03-28T20:09:28Z")
I have worked a lot with dataset tags, and found it tedious to convert excel files to csv, convert csv to plaintext, and then manually add the additional little bit of text at the top of the csv file, and then copy that … --- ## [Adding JDBC Driver for Databricks in Azure](https://forum.inductiveautomation.com/t/adding-jdbc-driver-for-databricks-in-azure/101242)
**Author:** [@bscott](https://forum.inductiveautomation.com/u/bscott)\ **Replies:** 4\ **Last updated:** [March 28, 2025, 8:08pm UTC](https://forum.inductiveautomation.com/t/adding-jdbc-driver-for-databricks-in-azure/101242 "2025-03-28T20:08:57Z")
Has anyone been successful in adding a JDBC driver for Databricks? We are particularly interested in Azure Databricks and only querying data out of the data lake. I have downloaded the Databricks JDBC driver jar file f… --- ## [toCSV is Downloading as a .txt file](https://forum.inductiveautomation.com/t/tocsv-is-downloading-as-a-txt-file/104307)
**Author:** [@cwkidd](https://forum.inductiveautomation.com/u/cwkidd)\ **Replies:** 8\ **Last updated:** [March 28, 2025, 7:25pm UTC](https://forum.inductiveautomation.com/t/tocsv-is-downloading-as-a-txt-file/104307 "2025-03-28T19:25:58Z")
I know that I'm doing something incorrectly, as I'm not amazingly practiced with Python and with Perspective scripting, so I apologize if it's something really obvious. I'm running some tests for a download button on a t… --- ## [Document Tag to Store XML File](https://forum.inductiveautomation.com/t/document-tag-to-store-xml-file/104394)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 11\ **Last updated:** [March 28, 2025, 7:14pm UTC](https://forum.inductiveautomation.com/t/document-tag-to-store-xml-file/104394 "2025-03-28T19:14:05Z")
I have not used the document tag type yet. Wondering if it would be appropriate to use it to store XML file data. If yes: How would I read/write the document tag? Is the resulting document tag able to be read and pars… --- ## [Click PLC Connection Into Ignition](https://forum.inductiveautomation.com/t/click-plc-connection-into-ignition/104329)
**Author:** [@Wirehead](https://forum.inductiveautomation.com/u/Wirehead)\ **Replies:** 22\ **Last updated:** [March 28, 2025, 6:23pm UTC](https://forum.inductiveautomation.com/t/click-plc-connection-into-ignition/104329 "2025-03-28T18:23:14Z")
Does anyone have much experience with setting up a Click PLC to communicate with Ignition? I have setup the port1 connection to my desired address and believe i setup the modbus tcp section for port 1 properly as well(po… --- ## [Historian Changes in 8.3](https://forum.inductiveautomation.com/t/historian-changes-in-8-3/104378)
**Author:** [@Andre\_Hennecke](https://forum.inductiveautomation.com/u/Andre_Hennecke)\ **Replies:** 4\ **Last updated:** [March 28, 2025, 4:59pm UTC](https://forum.inductiveautomation.com/t/historian-changes-in-8-3/104378 "2025-03-28T16:59:16Z")
Hi, I read that the historian in version 8.3 will be significantly improved. Does anyone know if these enhancements will also extend to timestamp relations? We have a use case where we need to relate batch or single-pi… --- ## [\[BUG\] Unable to render CSS Layers in Themes](https://forum.inductiveautomation.com/t/bug-unable-to-render-css-layers-in-themes/104388)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 2\ **Last updated:** [March 28, 2025, 4:32pm UTC](https://forum.inductiveautomation.com/t/bug-unable-to-render-css-layers-in-themes/104388 "2025-03-28T16:32:49Z")
I am trying to do some stuff that leverages CSS layers, however whenever I try to add a layer to the native light.css or dark.css themes it gives me a null pointer when trying to strip comments from the CSS. I am guessi… --- ## [Sending a message from a main view on one page to a popup in another page](https://forum.inductiveautomation.com/t/sending-a-message-from-a-main-view-on-one-page-to-a-popup-in-another-page/104385)
**Author:** [@Noah\_Gilgo](https://forum.inductiveautomation.com/u/Noah_Gilgo)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 4:21pm UTC](https://forum.inductiveautomation.com/t/sending-a-message-from-a-main-view-on-one-page-to-a-popup-in-another-page/104385 "2025-03-28T16:21:05Z")
Is system.perspective.sendMessage incapable of sending messages from a main view on one page to a popup on another page? I want a user modifying a record on one page to refresh a binding on a popup open on another page. … --- ## [Unable to load PNG files in ignition](https://forum.inductiveautomation.com/t/unable-to-load-png-files-in-ignition/104380)
**Author:** [@ColeS](https://forum.inductiveautomation.com/u/ColeS)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 3:42pm UTC](https://forum.inductiveautomation.com/t/unable-to-load-png-files-in-ignition/104380 "2025-03-28T15:42:54Z")
I have images that show up in the image management tab, I have right clicked on them and copied the path then pasted it into the source props. I am doing this on a gateway running on my local machine and cannot view it i… --- ## [Driven Tag group](https://forum.inductiveautomation.com/t/driven-tag-group/104328)
**Author:** [@AUSDIV](https://forum.inductiveautomation.com/u/AUSDIV)\ **Replies:** 10\ **Last updated:** [March 28, 2025, 3:29pm UTC](https://forum.inductiveautomation.com/t/driven-tag-group/104328 "2025-03-28T15:29:42Z")
I made a driven tag group to update 9 tags in my database every time a pointer changes value. I left pretty much all settings default, but I made the driving expression be the value of the pointer (changes 1-20 then recy… --- ## [Perspective Message Handler Issues](https://forum.inductiveautomation.com/t/perspective-message-handler-issues/104381)
**Author:** [@dwangrud](https://forum.inductiveautomation.com/u/dwangrud)\ **Replies:** 3\ **Last updated:** [March 28, 2025, 3:14pm UTC](https://forum.inductiveautomation.com/t/perspective-message-handler-issues/104381 "2025-03-28T15:14:02Z")
Hi guys, I'm working on using a gateway system.util.SendMessage function (I have it in a timer script to test but eventually want to do it on a tag change event) which should link to a session event to open a popup. I do… --- ## [Database Faulted even when I can connect](https://forum.inductiveautomation.com/t/database-faulted-even-when-i-can-connect/104377)
**Author:** [@Michael\_White](https://forum.inductiveautomation.com/u/Michael_White)\ **Replies:** 3\ **Last updated:** [March 28, 2025, 3:08pm UTC](https://forum.inductiveautomation.com/t/database-faulted-even-when-i-can-connect/104377 "2025-03-28T15:08:04Z")
For our dev environment, we run Ignition in docker desktop on windows. We also build the ignition image where the only changes we make is we also install ping, dig, mariadb-client, and git in the container. When I exec… --- ## [Creating OPC-UA tags externally \[api/sdk\]](https://forum.inductiveautomation.com/t/creating-opc-ua-tags-externally-api-sdk/104379)
**Author:** [@pandeyvspvivek](https://forum.inductiveautomation.com/u/pandeyvspvivek)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 2:50pm UTC](https://forum.inductiveautomation.com/t/creating-opc-ua-tags-externally-api-sdk/104379 "2025-03-28T14:50:54Z")
Is it possible to create tags in a tag provider in gateway using API or SDK? I dont want to use "ignition desinger" hence please tell me if there is any way using which I can create a device using some sort or API or S… --- ## [How to make a radio button filter my chart or table?](https://forum.inductiveautomation.com/t/how-to-make-a-radio-button-filter-my-chart-or-table/104369)
**Author:** [@Allan\_neves\_castanhe](https://forum.inductiveautomation.com/u/Allan_neves_castanhe)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 2:43pm UTC](https://forum.inductiveautomation.com/t/how-to-make-a-radio-button-filter-my-chart-or-table/104369 "2025-03-28T14:43:22Z")
I would like to know how to make the radio button selection filter the chart or table, does anyone have an idea? --- ## [Vision Theme Colors](https://forum.inductiveautomation.com/t/vision-theme-colors/104355)
**Author:** [@770043297](https://forum.inductiveautomation.com/u/770043297)\ **Replies:** 2\ **Last updated:** [March 28, 2025, 2:41pm UTC](https://forum.inductiveautomation.com/t/vision-theme-colors/104355 "2025-03-28T14:41:43Z")
Define color Use color Is this reasonable, or is there a better way? Thank you --- ## [\[BUG\] Flex containers set to auto basis don't size correctly](https://forum.inductiveautomation.com/t/bug-flex-containers-set-to-auto-basis-dont-size-correctly/104061)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 23\ **Last updated:** [March 28, 2025, 2:15pm UTC](https://forum.inductiveautomation.com/t/bug-flex-containers-set-to-auto-basis-dont-size-correctly/104061 "2025-03-28T14:15:07Z")
Recently, more often than not I've noticed that when I add components into a flex container and have a mixture of fixed and auto basis, with the flex container basis being set to auto as well, the flex container size doe… --- ## [Can't access files from gateway script](https://forum.inductiveautomation.com/t/cant-access-files-from-gateway-script/104156)
**Author:** [@Giacomo\_Saccani](https://forum.inductiveautomation.com/u/Giacomo_Saccani)\ **Replies:** 14\ **Last updated:** [March 28, 2025, 2:10pm UTC](https://forum.inductiveautomation.com/t/cant-access-files-from-gateway-script/104156 "2025-03-28T14:10:41Z")
Hello everyone I have a problem opening a file in a gateway script import os art\_path = r'C:\\Users\\admsaccagi\\Desktop\\Data\_exchange\\' dirList=os.listdir(art\_path) for fname in dirList: print(fname) Before even get… --- ## [How to build this component: Multi Layered Gauge](https://forum.inductiveautomation.com/t/how-to-build-this-component-multi-layered-gauge/104290)
**Author:** [@Jesse\_Dale\_Gimenez](https://forum.inductiveautomation.com/u/Jesse_Dale_Gimenez)\ **Replies:** 6\ **Last updated:** [March 28, 2025, 1:58pm UTC](https://forum.inductiveautomation.com/t/how-to-build-this-component-multi-layered-gauge/104290 "2025-03-28T13:58:15Z")
I saw this component from the general discussion page, share your project screen. I am curious on how he managed to build this component --- ## [For some reason I am double logged into Perspective](https://forum.inductiveautomation.com/t/for-some-reason-i-am-double-logged-into-perspective/104360)
**Author:** [@emanuel.o](https://forum.inductiveautomation.com/u/emanuel.o)\ **Replies:** 2\ **Last updated:** [March 28, 2025, 10:42am UTC](https://forum.inductiveautomation.com/t/for-some-reason-i-am-double-logged-into-perspective/104360 "2025-03-28T10:42:22Z")
Whenever i go into ignition it says their are 2 users loged in How do i log the other one out of it ? --- ## [Send Message on Page Load](https://forum.inductiveautomation.com/t/send-message-on-page-load/28898)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 9\ **Last updated:** [March 28, 2025, 12:41pm UTC](https://forum.inductiveautomation.com/t/send-message-on-page-load/28898 "2025-03-28T12:41:07Z")
What would be the best way to send a message out in perspective when a page is first loaded? I have a docked view that I would like the label to change on depending on what page is loaded. --- ## [KO|Cannot drop the table 'Gev.dbo.\_\_tmpGEVChiusura', because it does not exist or you do not have permission.](https://forum.inductiveautomation.com/t/ko-cannot-drop-the-table-gev-dbo-tmpgevchiusura-because-it-does-not-exist-or-you-do-not-have-permission/104366)
**Author:** [@Fr4bby](https://forum.inductiveautomation.com/u/Fr4bby)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 12:23pm UTC](https://forum.inductiveautomation.com/t/ko-cannot-drop-the-table-gev-dbo-tmpgevchiusura-because-it-does-not-exist-or-you-do-not-have-permission/104366 "2025-03-28T12:23:14Z")
idriga = 279 system.db.runPrepUpdate('UPDATE t01commesse SET FINE = getdate() WHERE ID\_COMMESSA = (SELECT TOP 1 ID\_COMMESSA from t02Lavorazioni where ID = ?)', \[idriga\], 'GEV') produce error: \>\>\> Java Traceback: Trace… --- ## [\[NOT BUG, PEBKAC\] system.date.parse returning dodgy date for formats other than YYYY-MM-dd HH:mm:ss](https://forum.inductiveautomation.com/t/not-bug-pebkac-system-date-parse-returning-dodgy-date-for-formats-other-than-yyyy-mm-dd-hhss/104352)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 6\ **Last updated:** [March 28, 2025, 12:08pm UTC](https://forum.inductiveautomation.com/t/not-bug-pebkac-system-date-parse-returning-dodgy-date-for-formats-other-than-yyyy-mm-dd-hhss/104352 "2025-03-28T12:08:39Z")
When using system.date.parse with formats other than the standard, it returns whatever dates it feels like, everything but what it should! E.g. system.date.format( system.date.parse('20250312\_120000', 'YYYYMMdd\_HHmmss… --- ## [Installer not asking to upgrade?](https://forum.inductiveautomation.com/t/installer-not-asking-to-upgrade/104325)
**Author:** [@christopher.berg](https://forum.inductiveautomation.com/u/christopher.berg)\ **Replies:** 7\ **Last updated:** [March 28, 2025, 12:03pm UTC](https://forum.inductiveautomation.com/t/installer-not-asking-to-upgrade/104325 "2025-03-28T12:03:54Z")
I've got a server running 8.1.25 that I'm trying to upgrade to 8.1.45. In the past, the installer always detected that there was already an Ignition installation on the server and offered to upgrade but that's not happe… --- ## [DateTime as Int in database Table](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277)
**Author:** [@Alex\_Ford-King](https://forum.inductiveautomation.com/u/Alex_Ford-King)\ **Replies:** 3\ **Last updated:** [March 28, 2025, 11:51am UTC](https://forum.inductiveautomation.com/t/datetime-as-int-in-database-table/104277 "2025-03-28T11:51:11Z")
I'm working on a editable table and I'm having some issues with my DateTime data types. They are in integers when I click the cells to make an edit. Anyone experience this before? I'm entering into the table using the T… --- ## [dateFormat returning the wrong year](https://forum.inductiveautomation.com/t/dateformat-returning-the-wrong-year/100310)
**Author:** [@Billy\_Grigo](https://forum.inductiveautomation.com/u/Billy_Grigo)\ **Replies:** 7\ **Last updated:** [March 28, 2025, 8:54am UTC](https://forum.inductiveautomation.com/t/dateformat-returning-the-wrong-year/100310 "2025-03-28T08:54:54Z")
Hey all, I hope your holidays have been going well! Just looking for a quick sanity check and maybe some pointers regarding an expression that I'm using on a label component in perspective. The specific function is: d… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=221) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=223)