# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=681 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 682 --- ## [How to see what is writing to a memory tag](https://forum.inductiveautomation.com/t/how-to-see-what-is-writing-to-a-memory-tag/71510)
**Author:** [@Brennan\_Joles](https://forum.inductiveautomation.com/u/Brennan_Joles)\ **Replies:** 3\ **Last updated:** [March 23, 2023, 4:59pm UTC](https://forum.inductiveautomation.com/t/how-to-see-what-is-writing-to-a-memory-tag/71510 "2023-03-23T16:59:51Z")
Is there a way to see where a memory tag is getting its value from? --- ## [Text cursor in legacy script editor is way off in 8.1.25](https://forum.inductiveautomation.com/t/text-cursor-in-legacy-script-editor-is-way-off-in-8-1-25/71509)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [March 23, 2023, 4:35pm UTC](https://forum.inductiveautomation.com/t/text-cursor-in-legacy-script-editor-is-way-off-in-8-1-25/71509 "2023-03-23T16:35:09Z")
Upgrading a system from 7.9.9 to 8.1.25. This system has some legacy scripts as it's been around since 7.4 iirc that were never brought to the project scripts as there are many of them and it works, so there's never bee… --- ## [Shared file updates import via designer or gateway](https://forum.inductiveautomation.com/t/shared-file-updates-import-via-designer-or-gateway/71397)
**Author:** [@Cameronin](https://forum.inductiveautomation.com/u/Cameronin)\ **Replies:** 2\ **Last updated:** [March 23, 2023, 4:26pm UTC](https://forum.inductiveautomation.com/t/shared-file-updates-import-via-designer-or-gateway/71397 "2023-03-23T16:26:08Z")
There's an excel .xlsx file on a shared drive that I need to have available in Ignition. It's updated pretty much daily. I have @JordanCClark's excelBytesToDataSet function (I've popped it into a project script for now… --- ## [Webdev return csv](https://forum.inductiveautomation.com/t/webdev-return-csv/71503)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 5\ **Last updated:** [March 23, 2023, 4:16pm UTC](https://forum.inductiveautomation.com/t/webdev-return-csv/71503 "2023-03-23T16:16:30Z")
Simple question, I'm already using the webdev module to return a json file. In PowerBI, often it would be much easier to parse a csv. So the question is: is it possible to return a csv instead of a json in a doGet? T… --- ## [Named Query for Machine Runtime calculation (Example)](https://forum.inductiveautomation.com/t/named-query-for-machine-runtime-calculation-example/71465)
**Author:** [@SNikte](https://forum.inductiveautomation.com/u/SNikte)\ **Replies:** 3\ **Last updated:** [March 23, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/named-query-for-machine-runtime-calculation-example/71465 "2023-03-23T16:10:01Z")
Hi all, Here is a named query for calculating machine runtime based on a simple 3 state stack light. I have been using SQL bridge module to create a transaction group for every machine. When machine is running, RUN\_ST… --- ## [Keep View in Cache](https://forum.inductiveautomation.com/t/keep-view-in-cache/68374)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 3\ **Last updated:** [March 23, 2023, 4:08pm UTC](https://forum.inductiveautomation.com/t/keep-view-in-cache/68374 "2023-03-23T16:08:07Z")
Is there any way to keep a specific view always available in the cache, so it doesn't have to reload every time it's navigated to? A session prop, perhaps? For instance, I have one larger overview that takes some time t… --- ## [Perspective Table Variable Column Count & Header Groups](https://forum.inductiveautomation.com/t/perspective-table-variable-column-count-header-groups/71502)
**Author:** [@eckman.tech](https://forum.inductiveautomation.com/u/eckman.tech)\ **Replies:** 0\ **Last updated:** [March 23, 2023, 3:31pm UTC](https://forum.inductiveautomation.com/t/perspective-table-variable-column-count-header-groups/71502 "2023-03-23T15:31:28Z")
Just want to get some thoughts about something I'm trying to accomplish. I have an idea of how... I have a dataset that is comprised of 3 rows (sometimes it may only be 1 or 2 rows). Each row will always have 3 columns … --- ## [Cannot take gateway backup - FileNotFound Exception](https://forum.inductiveautomation.com/t/cannot-take-gateway-backup-filenotfound-exception/71498)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [March 23, 2023, 3:23pm UTC](https://forum.inductiveautomation.com/t/cannot-take-gateway-backup-filenotfound-exception/71498 "2023-03-23T15:23:51Z")
Using 7.9.9. Tried to make a gateway backup multiple times from the gateway. I saw in the logs an error come through - BackupServlet Error creating gateway backup file. The stack trace java.io.FileNotFoundExcepti… --- ## [Batch tag renaming](https://forum.inductiveautomation.com/t/batch-tag-renaming/71496)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 2\ **Last updated:** [March 23, 2023, 3:18pm UTC](https://forum.inductiveautomation.com/t/batch-tag-renaming/71496 "2023-03-23T15:18:24Z")
Anyway to rename a lot of tags like these? I need to change the L12 part to L21. --- ## [Variable global in event script doesnt work](https://forum.inductiveautomation.com/t/variable-global-in-event-script-doesnt-work/71495)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 3\ **Last updated:** [March 23, 2023, 2:53pm UTC](https://forum.inductiveautomation.com/t/variable-global-in-event-script-doesnt-work/71495 "2023-03-23T14:53:20Z")
Hello, I have a simple script in an event script that when the button is pressed, causes the following code to write to the Label text component: def runAction(self, event): tempCounter = 0 def funkcja(): global … --- ## [Writing dayOfWeek to tag](https://forum.inductiveautomation.com/t/writing-dayofweek-to-tag/71398)
**Author:** [@kaleb.s](https://forum.inductiveautomation.com/u/kaleb.s)\ **Replies:** 5\ **Last updated:** [March 23, 2023, 12:52pm UTC](https://forum.inductiveautomation.com/t/writing-dayofweek-to-tag/71398 "2023-03-23T12:52:05Z")
What is the best way to use getDayOfWeek so I have a tag that shows the current value 1-7? So far this is what i have gathered but cant seem to piece it all together..... date = system.date.now() print system.date.ge… --- ## [New Server Sharing Old Historian Database](https://forum.inductiveautomation.com/t/new-server-sharing-old-historian-database/71492)
**Author:** [@JohnBomb](https://forum.inductiveautomation.com/u/JohnBomb)\ **Replies:** 1\ **Last updated:** [March 23, 2023, 1:50pm UTC](https://forum.inductiveautomation.com/t/new-server-sharing-old-historian-database/71492 "2023-03-23T13:50:39Z")
Hey all! I'm getting ready to upgrade my Ignition server's hardware to a new machine and I have a few questions about handling the SQL database with our Historian data in it. I plan on running both servers in parallel f… --- ## [How do I connect Endress+Hauser Liquiline CM-448 controllers with Profinet output to Ignition?](https://forum.inductiveautomation.com/t/how-do-i-connect-endress-hauser-liquiline-cm-448-controllers-with-profinet-output-to-ignition/71376)
**Author:** [@Matthew\_McBride](https://forum.inductiveautomation.com/u/Matthew_McBride)\ **Replies:** 5\ **Last updated:** [March 23, 2023, 1:49pm UTC](https://forum.inductiveautomation.com/t/how-do-i-connect-endress-hauser-liquiline-cm-448-controllers-with-profinet-output-to-ignition/71376 "2023-03-23T13:49:00Z")
We are in the process of installing multiple Endress+Hauser Liquiline CM-448 controllers with Profinet output to monitor tank solution concentration, conductivity, and temperature. Is there a driver that can be set up i… --- ## [SQLiteException: \[SQLITE\_ERROR\] SQL error or missing database](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488)
**Author:** [@arjunrajas](https://forum.inductiveautomation.com/u/arjunrajas)\ **Replies:** 8\ **Last updated:** [March 23, 2023, 1:40pm UTC](https://forum.inductiveautomation.com/t/sqliteexception-sqlite-error-sql-error-or-missing-database/71488 "2023-03-23T13:40:58Z")
when i try to push data into the SQLITE database on running a timer script but i end up getting the error "SQLiteException: \[SQLITE\_ERROR\] SQL error or missing database " but when i check the database configuration is V… --- ## [Trigger Perspective view script on page reload](https://forum.inductiveautomation.com/t/trigger-perspective-view-script-on-page-reload/71489)
**Author:** [@Sholom\_Ellenbogen](https://forum.inductiveautomation.com/u/Sholom_Ellenbogen)\ **Replies:** 0\ **Last updated:** [March 23, 2023, 12:37pm UTC](https://forum.inductiveautomation.com/t/trigger-perspective-view-script-on-page-reload/71489 "2023-03-23T12:37:08Z")
I want to trigger a script on a perspective view when the page is reloaded. Is there a way to capture the page refresh event from within a view? --- ## [Compare Tag values](https://forum.inductiveautomation.com/t/compare-tag-values/71439)
**Author:** [@aman\_sharma](https://forum.inductiveautomation.com/u/aman_sharma)\ **Replies:** 3\ **Last updated:** [March 23, 2023, 9:19am UTC](https://forum.inductiveautomation.com/t/compare-tag-values/71439 "2023-03-23T09:19:00Z")
Hi, I am getting data from postgreSql. basically i have created one query tag and getting the values. query is : SELECT "Sample" FROM "Samples" ORDER BY "Timestamp" desc LIMIT 6 Now i want to compare these values… --- ## [Connecting to Modicon PLCs Via OFS](https://forum.inductiveautomation.com/t/connecting-to-modicon-plcs-via-ofs/71474)
**Author:** [@Devadarshan\_G](https://forum.inductiveautomation.com/u/Devadarshan_G)\ **Replies:** 2\ **Last updated:** [March 23, 2023, 8:45am UTC](https://forum.inductiveautomation.com/t/connecting-to-modicon-plcs-via-ofs/71474 "2023-03-23T08:45:47Z")
Hi , I'm currently trying to make a connection between Ignition Gateway and OFS Factory Server to read data from Modicon M580 to Ignition SCADA. But after creating the OPC connection , The status is shown as faulted. How… --- ## [Template repeater not refresh](https://forum.inductiveautomation.com/t/template-repeater-not-refresh/71452)
**Author:** [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\ **Replies:** 2\ **Last updated:** [March 23, 2023, 5:20am UTC](https://forum.inductiveautomation.com/t/template-repeater-not-refresh/71452 "2023-03-23T05:20:35Z")
Hi guys, In my case created a template repeater using a dataset. this dataset got from dropdown property change action. Template repeater data refresh when changing dropdown selected value. when I delete or insert a row… --- ## [Perspective question](https://forum.inductiveautomation.com/t/perspective-question/71470)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 4\ **Last updated:** [March 23, 2023, 2:24am UTC](https://forum.inductiveautomation.com/t/perspective-question/71470 "2023-03-23T02:24:54Z")
When I clicked, this error occurred. What should I do? --- ## [Wrapper Log: Subscription transfer failed](https://forum.inductiveautomation.com/t/wrapper-log-subscription-transfer-failed/71456)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 6\ **Last updated:** [March 22, 2023, 9:45pm UTC](https://forum.inductiveautomation.com/t/wrapper-log-subscription-transfer-failed/71456 "2023-03-22T21:45:37Z")
This is for Ignition 8.1.2 I am seeing a lot of entries in my wrapper log file of INFO | jvm 1 | 2023/03/18 00:47:00 | I \[c.i.i.g.o.c.c.OpcUaConnection \] \[04:46:59\]: Subscription transfer failed, id=2426678631, s… --- ## [Notifications with capcode pagers](https://forum.inductiveautomation.com/t/notifications-with-capcode-pagers/71464)
**Author:** [@Brian\_Cockrell](https://forum.inductiveautomation.com/u/Brian_Cockrell)\ **Replies:** 1\ **Last updated:** [March 22, 2023, 9:39pm UTC](https://forum.inductiveautomation.com/t/notifications-with-capcode-pagers/71464 "2023-03-22T21:39:51Z")
Does ignition have a way to send alarm notifications to a ztron paging system that uses capcodes for the pagers. Our paging system is a local system and not with a phone company. We currently use win911 for this but wa… --- ## [Change row color of table based on a value of the row](https://forum.inductiveautomation.com/t/change-row-color-of-table-based-on-a-value-of-the-row/31548)
**Author:** [@petar.zurzevic](https://forum.inductiveautomation.com/u/petar.zurzevic)\ **Replies:** 4\ **Last updated:** [March 22, 2023, 9:20pm UTC](https://forum.inductiveautomation.com/t/change-row-color-of-table-based-on-a-value-of-the-row/31548 "2023-03-22T21:20:00Z")
Hi, im using a table in perspective that shows the results of a query, im trying to change color of the row based on the value of a field in the table, is it possible? --- ## [2 User source connections, 1 project](https://forum.inductiveautomation.com/t/2-user-source-connections-1-project/71458)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 5\ **Last updated:** [March 22, 2023, 8:18pm UTC](https://forum.inductiveautomation.com/t/2-user-source-connections-1-project/71458 "2023-03-22T20:18:22Z")
Our company is split into 2 regions. Each region has its own internal Microsoft AD. Up until now, only one region has accessed the project (dashboards etc) so it was their AD/internal user source that was in the project… --- ## [Order by descending only ordering by first digit instead of entire number](https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459)
**Author:** [@Brennan\_Joles](https://forum.inductiveautomation.com/u/Brennan_Joles)\ **Replies:** 2\ **Last updated:** [March 22, 2023, 7:49pm UTC](https://forum.inductiveautomation.com/t/order-by-descending-only-ordering-by-first-digit-instead-of-entire-number/71459 "2023-03-22T19:49:25Z")
Every other column but "TimeBehind" sorts by the entire number and they are all created the same. Here is a screenshot of the column "TimeBehind" sorting by only the first digit instead of the entire number: --- ## [Calling a Stored Procedure - Tag Editor](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-tag-editor/71457)
**Author:** [@Carsten\_Dressler](https://forum.inductiveautomation.com/u/Carsten_Dressler)\ **Replies:** 2\ **Last updated:** [March 22, 2023, 7:46pm UTC](https://forum.inductiveautomation.com/t/calling-a-stored-procedure-tag-editor/71457 "2023-03-22T19:46:26Z")
Hello, I have a script that runs perfect from the Script Console. The code is this: system.db.execSProcCall(system.db.createSProcCall("sp\_test")) Basically just calls a Stored Procedure in my MS SQL DB. Now I want t… --- ## [Alarm Pipeline Notification Calculated Roster: access pipeline properties](https://forum.inductiveautomation.com/t/alarm-pipeline-notification-calculated-roster-access-pipeline-properties/16976)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 6\ **Last updated:** [March 11, 2023, 5:50pm UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-notification-calculated-roster-access-pipeline-properties/16976 "2023-03-11T17:50:39Z")
I have an alarm notification profile that has been setup as per the Escalation pipeline in the user manual (https://docs.inductiveautomation.com/display/DOC79/Pipeline±+Escalation) Instead of sending an SMS to all users… --- ## [Vision Client Tag Arrays give Tag not found error](https://forum.inductiveautomation.com/t/vision-client-tag-arrays-give-tag-not-found-error/50387)
**Author:** [@BCNoyes](https://forum.inductiveautomation.com/u/BCNoyes)\ **Replies:** 9\ **Last updated:** [March 22, 2023, 6:18pm UTC](https://forum.inductiveautomation.com/t/vision-client-tag-arrays-give-tag-not-found-error/50387 "2023-03-22T18:18:44Z")
I created a Boolean Array Vision Client Tag, but when I try to edit the value in the tag browser I get an Error writing to value: Bad Not Found error. I also get selected: Bad\_NotFound if I bind it to vision component (c… --- ## [Active Directory not filtering by with User List Filter?](https://forum.inductiveautomation.com/t/active-directory-not-filtering-by-with-user-list-filter/71448)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 6\ **Last updated:** [March 22, 2023, 6:01pm UTC](https://forum.inductiveautomation.com/t/active-directory-not-filtering-by-with-user-list-filter/71448 "2023-03-22T18:01:10Z")
I am working with Ignition 7.9. Setting up an active directory-internal hybrid User source. Right now it seems like anyone from the Active Directory is able to login but really we just want certain members of the AD to… --- ## [Insert euro symbol in database from ignition](https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450)
**Author:** [@Priyanka.Khandge](https://forum.inductiveautomation.com/u/Priyanka.Khandge)\ **Replies:** 2\ **Last updated:** [March 22, 2023, 5:51pm UTC](https://forum.inductiveautomation.com/t/insert-euro-symbol-in-database-from-ignition/71450 "2023-03-22T17:51:43Z")
Hi guys, I have tried to insert the euro(€) symbol in the database using the insert query from the vision button action performed but the format is not ok in the database. val = str(202) + str("€") Display the databas… --- ## [Question about Name Queries](https://forum.inductiveautomation.com/t/question-about-name-queries/71444)
**Author:** [@Chang\_Shi](https://forum.inductiveautomation.com/u/Chang_Shi)\ **Replies:** 4\ **Last updated:** [March 22, 2023, 5:35pm UTC](https://forum.inductiveautomation.com/t/question-about-name-queries/71444 "2023-03-22T17:35:21Z")
Could you someone answer my question? I used the name query to create the table in ignition 8.1, It looks like name query only connect SQLite database and show the table. When I use the MySQL connected, Cant see any tabl… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=680) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=682)