# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=212 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 213 --- ## [While loops inside Gateway Events are very unreliable](https://forum.inductiveautomation.com/t/while-loops-inside-gateway-events-are-very-unreliable/105023)
**Author:** [@Spencer\_Lommel1](https://forum.inductiveautomation.com/u/Spencer_Lommel1)\ **Replies:** 33\ **Last updated:** [April 12, 2025, 12:28am UTC](https://forum.inductiveautomation.com/t/while-loops-inside-gateway-events-are-very-unreliable/105023 "2025-04-12T00:28:17Z")
I made a simple Update Gateway Event which had a while loop inside of it and rather than killing the current while loop and starting a new one when you update the project. It puts that while loop in the background and cr… --- ## [When are transaction groups the best solution?](https://forum.inductiveautomation.com/t/when-are-transaction-groups-the-best-solution/105025)
**Author:** [@Simon\_Hathout\_Willar](https://forum.inductiveautomation.com/u/Simon_Hathout_Willar)\ **Replies:** 4\ **Last updated:** [April 12, 2025, 12:20am UTC](https://forum.inductiveautomation.com/t/when-are-transaction-groups-the-best-solution/105025 "2025-04-12T00:20:43Z")
I'm working on (re)writing some code, which logs CNC machine statuses. There's some logic with translating from the machine's statuses to a shared set, and HMI overrides to the status, but nothing too complex. The previ… --- ## [Page vs Session Props Security](https://forum.inductiveautomation.com/t/page-vs-session-props-security/104595)
**Author:** [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\ **Replies:** 19\ **Last updated:** [April 11, 2025, 11:08pm UTC](https://forum.inductiveautomation.com/t/page-vs-session-props-security/104595 "2025-04-11T23:08:41Z")
For a long time in 7 vision, we used client tags to store state within our app. We want to do the same in 8 perspective. In 7, we would write to these state tags with scripting or bindings and many of our Templates would… --- ## [BACnet Driver not connecting to units - database-revision property](https://forum.inductiveautomation.com/t/bacnet-driver-not-connecting-to-units-database-revision-property/68181)
**Author:** [@kyler.kamyszek](https://forum.inductiveautomation.com/u/kyler.kamyszek)\ **Replies:** 5\ **Last updated:** [April 11, 2025, 10:30pm UTC](https://forum.inductiveautomation.com/t/bacnet-driver-not-connecting-to-units-database-revision-property/68181 "2025-04-11T22:30:42Z")
I'm using build 8.1.20 (b2022082313) My BACnet HVAC units lost connection sometime over that last two weeks. I just noticed today that they weren't connected. I tried to disable and reenable them, and now I'm getting … --- ## [Gateway Script Access to a Mapped Drive (Redundancy)](https://forum.inductiveautomation.com/t/gateway-script-access-to-a-mapped-drive-redundancy/105019)
**Author:** [@Haniyeh\_Seyed\_Alinez](https://forum.inductiveautomation.com/u/Haniyeh_Seyed_Alinez)\ **Replies:** 1\ **Last updated:** [April 11, 2025, 8:54pm UTC](https://forum.inductiveautomation.com/t/gateway-script-access-to-a-mapped-drive-redundancy/105019 "2025-04-11T20:54:16Z")
Hi every one, I have a script that runs on a scheduled Gateway Event and relies on accessing files located on a local drive of the server where the Ignition Gateway is running. Now, with Ignition Redundancy enabled, if… --- ## [Issues with saving records in the database](https://forum.inductiveautomation.com/t/issues-with-saving-records-in-the-database/105016)
**Author:** [@FelipeRosson](https://forum.inductiveautomation.com/u/FelipeRosson)\ **Replies:** 2\ **Last updated:** [April 11, 2025, 8:31pm UTC](https://forum.inductiveautomation.com/t/issues-with-saving-records-in-the-database/105016 "2025-04-11T20:31:37Z")
Dear community, I need your help to try to understand and resolve an error that has occurred while saving records in my database. I am using Ignition 8.1 and Microsoft SQL Server v19.1. To save the data from Ignition t… --- ## [Migrate Tag History Data Post Migration of Windows/Tags to New Gateway/SQL Server](https://forum.inductiveautomation.com/t/migrate-tag-history-data-post-migration-of-windows-tags-to-new-gateway-sql-server/25731)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 5\ **Last updated:** [April 11, 2025, 7:23pm UTC](https://forum.inductiveautomation.com/t/migrate-tag-history-data-post-migration-of-windows-tags-to-new-gateway-sql-server/25731 "2025-04-11T19:23:19Z")
Long title! :slight\_smile: I may have been a bit short sighted when I migrated some content from one server to another for a customer. In the effort we were tasked with moving a set of OPC tags and windows from one serv… --- ## [Perspective - rotate an image](https://forum.inductiveautomation.com/t/perspective-rotate-an-image/105010)
**Author:** [@jkelleyus](https://forum.inductiveautomation.com/u/jkelleyus)\ **Replies:** 7\ **Last updated:** [April 11, 2025, 7:07pm UTC](https://forum.inductiveautomation.com/t/perspective-rotate-an-image/105010 "2025-04-11T19:07:01Z")
Good afternoon! I'm working on a SVG to indicate machine running speeds and need some help. I've done a little with CSS in the past but completely lost on using it with Ignition. Basically, I'm working on creating an in… --- ## [Locating Broken Bindings](https://forum.inductiveautomation.com/t/locating-broken-bindings/105008)
**Author:** [@Craig\_Kincade](https://forum.inductiveautomation.com/u/Craig_Kincade)\ **Replies:** 8\ **Last updated:** [April 11, 2025, 5:23pm UTC](https://forum.inductiveautomation.com/t/locating-broken-bindings/105008 "2025-04-11T17:23:58Z")
How do I locate the tag that is causing my expression binding to fail? --- ## [Basic Integer Expression Tag producing Error\_ExpressionEval error](https://forum.inductiveautomation.com/t/basic-integer-expression-tag-producing-error-expressioneval-error/104264)
**Author:** [@Robert\_Collinson](https://forum.inductiveautomation.com/u/Robert_Collinson)\ **Replies:** 18\ **Last updated:** [March 27, 2025, 6:00pm UTC](https://forum.inductiveautomation.com/t/basic-integer-expression-tag-producing-error-expressioneval-error/104264 "2025-03-27T18:00:34Z")
Hi All, Wondered if anyone could offer us some advice regarding an issue we're seeing with multiple expression tags. It appears that SOME (not all) of our expression tags result in an Error\_EspressionEval error. They'… --- ## [Alarms set to auto-acknowledge are not auto-acknowledging](https://forum.inductiveautomation.com/t/alarms-set-to-auto-acknowledge-are-not-auto-acknowledging/105001)
**Author:** [@Brian\_Stilson](https://forum.inductiveautomation.com/u/Brian_Stilson)\ **Replies:** 2\ **Last updated:** [April 11, 2025, 5:01pm UTC](https://forum.inductiveautomation.com/t/alarms-set-to-auto-acknowledge-are-not-auto-acknowledging/105001 "2025-04-11T17:01:41Z")
I have this alarm: I've made sure the Ack Mode is Auto: However, when I trigger it, it shows up as Unacknowledged So what gives? Does Ack Mode Auto not do what I think it does? --- ## [Updating Projects via Java](https://forum.inductiveautomation.com/t/updating-projects-via-java/105003)
**Author:** [@Darren\_Steele](https://forum.inductiveautomation.com/u/Darren_Steele)\ **Replies:** 2\ **Last updated:** [April 11, 2025, 4:27pm UTC](https://forum.inductiveautomation.com/t/updating-projects-via-java/105003 "2025-04-11T16:27:13Z")
When we release a new version of our module we also release new versions of our projects bundled into the module. When the new version is launched then we use java to copy the project files from our modl package into th… --- ## [Table selected row looks like selected when table gets updated](https://forum.inductiveautomation.com/t/table-selected-row-looks-like-selected-when-table-gets-updated/105002)
**Author:** [@Mushu](https://forum.inductiveautomation.com/u/Mushu)\ **Replies:** 4\ **Last updated:** [April 11, 2025, 4:15pm UTC](https://forum.inductiveautomation.com/t/table-selected-row-looks-like-selected-when-table-gets-updated/105002 "2025-04-11T16:15:14Z")
Hi, I have a dataset tag. The dataset data is filtered and shown in a table by a script in a button in perspective. When the dataset get updated by a gateway script, the table flickered and cleared. To avoid the tabl… --- ## [Bar Chart Starting from Middle](https://forum.inductiveautomation.com/t/bar-chart-starting-from-middle/104901)
**Author:** [@randaz99](https://forum.inductiveautomation.com/u/randaz99)\ **Replies:** 1\ **Last updated:** [April 11, 2025, 3:46pm UTC](https://forum.inductiveautomation.com/t/bar-chart-starting-from-middle/104901 "2025-04-11T15:46:52Z")
I have made the bar chart on the left (IMG below), but I am struggling to make the bar chart on the right. Is this something Ignition can do without add-ons? If so then how? --- ## [Decorating runAction functions in component Script actions?](https://forum.inductiveautomation.com/t/decorating-runaction-functions-in-component-script-actions/104978)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [April 11, 2025, 2:49pm UTC](https://forum.inductiveautomation.com/t/decorating-runaction-functions-in-component-script-actions/104978 "2025-04-11T14:49:50Z")
Is it possible to decorate these runAction functions? I want to show any errors in the script to the user and maybe do other actions, but at the moment I just copy boiler plate code with try/except blocks, however I'd re… --- ## [Quality: \[Bad\_NoDataAvailable\]](https://forum.inductiveautomation.com/t/quality-bad-nodataavailable/65085)
**Author:** [@Titus\_Lepic](https://forum.inductiveautomation.com/u/Titus_Lepic)\ **Replies:** 8\ **Last updated:** [April 11, 2025, 1:50pm UTC](https://forum.inductiveautomation.com/t/quality-bad-nodataavailable/65085 "2025-04-11T13:50:56Z")
Ignition 7.9.5. I created a new OPC tag, but the value is showing up as "null." When trying to read the configured tag from the quick client, I get the error "Quality: \[Bad\_NoDataAvailable\] No data is currently available… --- ## [Difference in Tag History Values Between Script and Excel Export](https://forum.inductiveautomation.com/t/difference-in-tag-history-values-between-script-and-excel-export/104964)
**Author:** [@willer](https://forum.inductiveautomation.com/u/willer)\ **Replies:** 8\ **Last updated:** [April 11, 2025, 1:37pm UTC](https://forum.inductiveautomation.com/t/difference-in-tag-history-values-between-script-and-excel-export/104964 "2025-04-11T13:37:15Z")
I'm working on a script that separates tag values into "peak" and "off-peak" periods. However, I'm noticing a discrepancy: the total value shown on my graph/label (based on the script) doesn't match the total I get when … --- ## [How do I use 2 databases in one named query](https://forum.inductiveautomation.com/t/how-do-i-use-2-databases-in-one-named-query/89083)
**Author:** [@compuzak](https://forum.inductiveautomation.com/u/compuzak)\ **Replies:** 6\ **Last updated:** [April 11, 2025, 12:10pm UTC](https://forum.inductiveautomation.com/t/how-do-i-use-2-databases-in-one-named-query/89083 "2025-04-11T12:10:53Z")
I need to read data from a table in one database and write to a table in another database in a named update query. Both database connections are setup in the same Ignition gateway. I can't figure out the syntax to refe… --- ## [Graph showing in Designer but not in published HMI](https://forum.inductiveautomation.com/t/graph-showing-in-designer-but-not-in-published-hmi/104829)
**Author:** [@Yash\_Patel1](https://forum.inductiveautomation.com/u/Yash_Patel1)\ **Replies:** 4\ **Last updated:** [April 11, 2025, 12:06pm UTC](https://forum.inductiveautomation.com/t/graph-showing-in-designer-but-not-in-published-hmi/104829 "2025-04-11T12:06:32Z")
--- ## [Gateway Access Controlled with Active Directory Users](https://forum.inductiveautomation.com/t/gateway-access-controlled-with-active-directory-users/104974)
**Author:** [@Kyle\_Young](https://forum.inductiveautomation.com/u/Kyle_Young)\ **Replies:** 1\ **Last updated:** [April 11, 2025, 11:38am UTC](https://forum.inductiveautomation.com/t/gateway-access-controlled-with-active-directory-users/104974 "2025-04-11T11:38:09Z")
I am trying to control access to my gateway page using roles that are generated by an active directory user source. Every time I change who has permissions to view a page it will not allow access. If I try to login on … --- ## [Struggling to add components](https://forum.inductiveautomation.com/t/struggling-to-add-components/104989)
**Author:** [@S\_Fox](https://forum.inductiveautomation.com/u/S_Fox)\ **Replies:** 4\ **Last updated:** [April 11, 2025, 9:49am UTC](https://forum.inductiveautomation.com/t/struggling-to-add-components/104989 "2025-04-11T09:49:52Z")
I'm not sure if I'm using the designer wrong, or if something is broken, but I cannot drag and drop components. When I try, I am met with the 'no' symbol. Any help to understand what's wrong would be appreciated. --- ## [CSV file help...please!](https://forum.inductiveautomation.com/t/csv-file-help-please/104979)
**Author:** [@hhbauss](https://forum.inductiveautomation.com/u/hhbauss)\ **Replies:** 3\ **Last updated:** [April 11, 2025, 9:17am UTC](https://forum.inductiveautomation.com/t/csv-file-help-please/104979 "2025-04-11T09:17:09Z")
Here is an example of a csv file that I am trying to import into Ignition. This is a nightmare! So many escape characters...I have tried to convert to xml with Excel with no luck. I have tried different Python scripts...… --- ## [Accordian Item Body](https://forum.inductiveautomation.com/t/accordian-item-body/104981)
**Author:** [@surajpatil26796](https://forum.inductiveautomation.com/u/surajpatil26796)\ **Replies:** 1\ **Last updated:** [April 11, 2025, 7:53am UTC](https://forum.inductiveautomation.com/t/accordian-item-body/104981 "2025-04-11T07:53:18Z")
Hello Experts, I am using accordion for Navigation in perspective, I have created one item inside it along with header and body. I want item body to occupy all the available content inside the body section. How i can a… --- ## [Perspective App communication with Ignition gateway](https://forum.inductiveautomation.com/t/perspective-app-communication-with-ignition-gateway/104850)
**Author:** [@JIGNESH\_AGHERA](https://forum.inductiveautomation.com/u/JIGNESH_AGHERA)\ **Replies:** 5\ **Last updated:** [April 11, 2025, 3:47am UTC](https://forum.inductiveautomation.com/t/perspective-app-communication-with-ignition-gateway/104850 "2025-04-11T03:47:06Z")
The Perspective mobile app is communicating with WiFi router to Ignition gateway through Server "IPaddress:\[Port\]". However when I switch the internet connection of app from WiFi Router( Same network of server) to mobil… --- ## [Table Filtering adding a day?](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976)
**Author:** [@joe.bernicke](https://forum.inductiveautomation.com/u/joe.bernicke)\ **Replies:** 6\ **Last updated:** [April 10, 2025, 10:30pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976 "2025-04-10T22:30:33Z")
Hello, So I have a filter and a date column. The filter seems to be adding a day to whatever I select in my filter. Am I missing something here? or is it something on the SQL end doing this? Any help is appreciated. … --- ## [Noob needs help creating a simple Bar Chart](https://forum.inductiveautomation.com/t/noob-needs-help-creating-a-simple-bar-chart/104962)
**Author:** [@Neil\_Gehrke](https://forum.inductiveautomation.com/u/Neil_Gehrke)\ **Replies:** 3\ **Last updated:** [April 10, 2025, 8:27pm UTC](https://forum.inductiveautomation.com/t/noob-needs-help-creating-a-simple-bar-chart/104962 "2025-04-10T20:27:39Z")
I need to create a simple bar chart to display flow meter totalizer tag data in 5 minute increments with a selectable date range. I've been searching for instruction on how to do this. I am unfamiliar with how to create … --- ## [How to have a button flash if the value of the button is less than another value?](https://forum.inductiveautomation.com/t/how-to-have-a-button-flash-if-the-value-of-the-button-is-less-than-another-value/104970)
**Author:** [@sergio\_valencia](https://forum.inductiveautomation.com/u/sergio_valencia)\ **Replies:** 3\ **Last updated:** [April 10, 2025, 8:05pm UTC](https://forum.inductiveautomation.com/t/how-to-have-a-button-flash-if-the-value-of-the-button-is-less-than-another-value/104970 "2025-04-10T20:05:57Z")
I have this button changing colors with the shown expression... N701:0 Value is less then N101:0 value change to red....Once it changes to RED how do i make it flash?? if({\[default\]AZ ASRS Conveyor System/Wave Control/C… --- ## [Call COM methods using ActiveXComponent](https://forum.inductiveautomation.com/t/call-com-methods-using-activexcomponent/104951)
**Author:** [@fadihindi](https://forum.inductiveautomation.com/u/fadihindi)\ **Replies:** 4\ **Last updated:** [April 10, 2025, 8:12pm UTC](https://forum.inductiveautomation.com/t/call-com-methods-using-activexcomponent/104951 "2025-04-10T20:12:36Z")
I'm trying to call COM methods using ActiveXComponent in a vision 7.9 project. I downloaded "jacob-1.21.zip" from Releases · freemansoft/jacob-project · GitHub. This includes files "jacob.jar" and "jacob-1.21-x64.dll". I… --- ## [Exporting a report as a spreadsheet](https://forum.inductiveautomation.com/t/exporting-a-report-as-a-spreadsheet/104972)
**Author:** [@Evan\_Curry](https://forum.inductiveautomation.com/u/Evan_Curry)\ **Replies:** 2\ **Last updated:** [April 10, 2025, 7:58pm UTC](https://forum.inductiveautomation.com/t/exporting-a-report-as-a-spreadsheet/104972 "2025-04-10T19:58:11Z")
I am creating a monthly operating report for a client (it is a water plant), who needs a data sheet populated so that they can return a mandatory worksheet to the state every month. It will have a row for every day of th… --- ## [Database usage by Project](https://forum.inductiveautomation.com/t/database-usage-by-project/104947)
**Author:** [@dick.willis](https://forum.inductiveautomation.com/u/dick.willis)\ **Replies:** 4\ **Last updated:** [April 10, 2025, 7:51pm UTC](https://forum.inductiveautomation.com/t/database-usage-by-project/104947 "2025-04-10T19:51:31Z")
I am trying to make a list of which projects use which database connections ... we DO use the kindling tool to parse the gateway backup ... it DOES give us a list of projects, and DOES give us a separate list of database… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=211) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=213)