# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=883 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 884 --- ## [Does component Alarm Status Table not have a property for total alarms?](https://forum.inductiveautomation.com/t/does-component-alarm-status-table-not-have-a-property-for-total-alarms/56641)
**Author:** [@BVong](https://forum.inductiveautomation.com/u/BVong)\ **Replies:** 2\ **Last updated:** [March 1, 2022, 3:24am UTC](https://forum.inductiveautomation.com/t/does-component-alarm-status-table-not-have-a-property-for-total-alarms/56641 "2022-03-01T03:24:41Z")
I didn’t like the overhead that came along with the filterAlarm event. I ended up going with the the conditions property to a source that will populate the alarms status table. This works and will update the label next t… --- ## [Mysql data base connection](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645)
**Author:** [@Ray\_Guthrie](https://forum.inductiveautomation.com/u/Ray_Guthrie)\ **Replies:** 3\ **Last updated:** [February 28, 2022, 10:57pm UTC](https://forum.inductiveautomation.com/t/mysql-data-base-connection/56645 "2022-02-28T22:57:30Z")
I get a faulted status when I create mySQL data base. see description as follows:java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user ‘admin’@‘localhost’ (using password: YES)) at org.… --- ## [Pulling controllogix Rslogix5000 tag based alarms into Ignition](https://forum.inductiveautomation.com/t/pulling-controllogix-rslogix5000-tag-based-alarms-into-ignition/56622)
**Author:** [@Viet\_Le](https://forum.inductiveautomation.com/u/Viet_Le)\ **Replies:** 4\ **Last updated:** [February 28, 2022, 9:53pm UTC](https://forum.inductiveautomation.com/t/pulling-controllogix-rslogix5000-tag-based-alarms-into-ignition/56622 "2022-02-28T21:53:39Z")
I saw a topic some time last year about pulling the tag based alarm from compactlogix about which the forum basically said it’s not possible. A year gone by now, and with 30 + of controllogix systems coming up in our pro… --- ## [PI OPC DA Server and OSI PI Buffer Subsystem on Ignition servers](https://forum.inductiveautomation.com/t/pi-opc-da-server-and-osi-pi-buffer-subsystem-on-ignition-servers/56635)
**Author:** [@Tawnya\_Hennesy](https://forum.inductiveautomation.com/u/Tawnya_Hennesy)\ **Replies:** 2\ **Last updated:** [February 28, 2022, 7:12pm UTC](https://forum.inductiveautomation.com/t/pi-opc-da-server-and-osi-pi-buffer-subsystem-on-ignition-servers/56635 "2022-02-28T19:12:45Z")
Has anyone used the PI OPC DA Server, configured as a DA OPC Connection on an Ignition redundant pair, to read/write to an OSI PI Collective? If so, did you install/enable the PI Buffer Subsystem on the Ignition servers? … --- ## [Named Queries as .sql](https://forum.inductiveautomation.com/t/named-queries-as-sql/56638)
**Author:** [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\ **Replies:** 1\ **Last updated:** [February 28, 2022, 7:10pm UTC](https://forum.inductiveautomation.com/t/named-queries-as-sql/56638 "2022-02-28T19:10:34Z")
Hey I am about to do an update to an application and realized that at some point named queries were switched to .sql files instead of binaries (woohoo!) I was just curious, what version did this happen in? --- ## [Duplicate Alarm Events in Pipelines](https://forum.inductiveautomation.com/t/duplicate-alarm-events-in-pipelines/55939)
**Author:** [@Dee\_Duncan](https://forum.inductiveautomation.com/u/Dee_Duncan)\ **Replies:** 3\ **Last updated:** [February 28, 2022, 6:27pm UTC](https://forum.inductiveautomation.com/t/duplicate-alarm-events-in-pipelines/55939 "2022-02-28T18:27:34Z")
Is anyone else having issues with duplicate alarm events occurring in alarm pipelines? The issue occurs when remote tag providers are utilized. Every alarm event that is routed to a pipeline is duplicated. Was wonder… --- ## [Get Project Tag Count](https://forum.inductiveautomation.com/t/get-project-tag-count/56624)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 5\ **Last updated:** [February 28, 2022, 5:24pm UTC](https://forum.inductiveautomation.com/t/get-project-tag-count/56624 "2022-02-28T17:24:08Z")
Is there an easy way to count the total number of tags included in a project? I tried exporting to XML and opening in Excel, but due to the way tags are structured it makes it very difficult to read and interpret. --- ## [Datetime format problem](https://forum.inductiveautomation.com/t/datetime-format-problem/56608)
**Author:** [@eren.uyanik](https://forum.inductiveautomation.com/u/eren.uyanik)\ **Replies:** 3\ **Last updated:** [February 28, 2022, 4:56pm UTC](https://forum.inductiveautomation.com/t/datetime-format-problem/56608 "2022-02-28T16:56:20Z")
Hello all, I need add extra minutes on datetime.now(). I’m trying a script in the below but it doesn’t work because of time sctructure of datetime. import datetime time\_format = '%Y-%m-%d %H:%M:%S' pitchStartTime = … --- ## [Running Ignition v8.1 on Windows XP](https://forum.inductiveautomation.com/t/running-ignition-v8-1-on-windows-xp/56625)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 7\ **Last updated:** [February 28, 2022, 4:32pm UTC](https://forum.inductiveautomation.com/t/running-ignition-v8-1-on-windows-xp/56625 "2022-02-28T16:32:54Z")
I’ve been investigating how to run an Ignition v8.1 vision client on windows xp but I haven’t been able to find a solution yet. Due to licensing issues I am stuck on windows xp 32-bit for the foreseeable future. I trie… --- ## [How to reinitialize the log for DEBUG?](https://forum.inductiveautomation.com/t/how-to-reinitialize-the-log-for-debug/56611)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 4\ **Last updated:** [February 28, 2022, 4:23pm UTC](https://forum.inductiveautomation.com/t/how-to-reinitialize-the-log-for-debug/56611 "2022-02-28T16:23:36Z")
We have many of these clogging up the Status | Diagnostics | Log. \[tag-group-default\_default\] Failed to add 1 items to the subscription- error codes were returned from the OPC server. To see the codes, change the lo… --- ## [Java method behind 'Copy XML to Clipboard'](https://forum.inductiveautomation.com/t/java-method-behind-copy-xml-to-clipboard/48082)
**Author:** [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Replies:** 7\ **Last updated:** [February 28, 2022, 4:14pm UTC](https://forum.inductiveautomation.com/t/java-method-behind-copy-xml-to-clipboard/48082 "2022-02-28T16:14:10Z")
If it’s public, what is the java class/method behind the ‘Copy XML to Clipboard’ option in the Shift + Right Click context menu on a vision window in the the Project Browser? Context: When our Ignition environment was … --- ## [How to precisely measure function execution time](https://forum.inductiveautomation.com/t/how-to-precisely-measure-function-execution-time/56618)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 5\ **Last updated:** [February 28, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/how-to-precisely-measure-function-execution-time/56618 "2022-02-28T15:41:34Z")
hi I have a piece of code which is quite slow (the code interacts with the database) and need to measure its execution time to know if i make it quicker or slower. Could you please share what tools would you use to meas… --- ## [Ignition Designer in Inductive automation](https://forum.inductiveautomation.com/t/ignition-designer-in-inductive-automation/56616)
**Author:** [@kuldeep\_arya](https://forum.inductiveautomation.com/u/kuldeep_arya)\ **Replies:** 2\ **Last updated:** [February 28, 2022, 2:48pm UTC](https://forum.inductiveautomation.com/t/ignition-designer-in-inductive-automation/56616 "2022-02-28T14:48:53Z")
Hello, Anyone Suggest how can i resolve this issues. --- ## [Is there a way to delete a table from internal database](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110)
**Author:** [@zhouhcupb](https://forum.inductiveautomation.com/u/zhouhcupb)\ **Replies:** 6\ **Last updated:** [February 28, 2022, 2:28pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-delete-a-table-from-internal-database/36110 "2022-02-28T14:28:51Z")
Hi there. Trying to find a way to delete a table from internal database. http://localhost:8088/web/status/sys.internaldb?39 Some one get any idea? :disappointed\_relieved: --- ## [MQTT Transmission - Topic Structure - AWS IOT Policy](https://forum.inductiveautomation.com/t/mqtt-transmission-topic-structure-aws-iot-policy/47105)
**Author:** [@john.macenri](https://forum.inductiveautomation.com/u/john.macenri)\ **Replies:** 6\ **Last updated:** [February 28, 2022, 2:15pm UTC](https://forum.inductiveautomation.com/t/mqtt-transmission-topic-structure-aws-iot-policy/47105 "2022-02-28T14:15:06Z")
Hi, I’m evaluating using Ignition for edge data acquisition where the data gathered will be transmitted using MQTT to our AWS IOT Core MQTT endpoint. I need to adhere to a strict Policy in IOT Core regarding the root o… --- ## [Get size of unopened windows](https://forum.inductiveautomation.com/t/get-size-of-unopened-windows/21032)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [February 28, 2022, 12:48pm UTC](https://forum.inductiveautomation.com/t/get-size-of-unopened-windows/21032 "2022-02-28T12:48:35Z")
I'm looking to get a list of all of the Windows that we have in our SCADA system, and categorise them by main/popup/docked by pulling the info from their config using their size, layer, and docking settings. I am getting… --- ## [About Perspective Projects](https://forum.inductiveautomation.com/t/about-perspective-projects/56606)
**Author:** [@eren.uyanik](https://forum.inductiveautomation.com/u/eren.uyanik)\ **Replies:** 2\ **Last updated:** [February 28, 2022, 11:49am UTC](https://forum.inductiveautomation.com/t/about-perspective-projects/56606 "2022-02-28T11:49:29Z")
Hello all, I know there are some materials in the Ignition University website regarding to Perspective. But I wonder is there another source for perspective? (more details, more projects etc.) Thanks a lot, --- ## [Siemens S7-300, Connection Errors](https://forum.inductiveautomation.com/t/siemens-s7-300-connection-errors/27716)
**Author:** [@bmusson](https://forum.inductiveautomation.com/u/bmusson)\ **Replies:** 11\ **Last updated:** [February 28, 2022, 7:59am UTC](https://forum.inductiveautomation.com/t/siemens-s7-300-connection-errors/27716 "2022-02-28T07:59:31Z")
Hey ya’ll, I’m getting some errors connecting to an S7-300, and I’m not sure what my next step should be in troubleshooting. Here’s the set of repeating events that are filling up my logs… S7300Driver Socket connectio… --- ## [Gateway Timer script not working](https://forum.inductiveautomation.com/t/gateway-timer-script-not-working/56519)
**Author:** [@deepak.nule](https://forum.inductiveautomation.com/u/deepak.nule)\ **Replies:** 11\ **Last updated:** [February 28, 2022, 2:46am UTC](https://forum.inductiveautomation.com/t/gateway-timer-script-not-working/56519 "2022-02-28T02:46:26Z")
I have script to post data to web services- Using Gateway timer script runs, But scripts failing sometimes using timer ,whereas using user button they work 100%. Any solution or improvement we can do. Sample code- TS… --- ## [Historic trend data GUI](https://forum.inductiveautomation.com/t/historic-trend-data-gui/56603)
**Author:** [@david.rigby](https://forum.inductiveautomation.com/u/david.rigby)\ **Replies:** 4\ **Last updated:** [February 28, 2022, 12:42am UTC](https://forum.inductiveautomation.com/t/historic-trend-data-gui/56603 "2022-02-28T00:42:27Z")
Hi All. Just putting my feelers out to see if anyone knows of a nice front end project/window to display historic trend data. I’m looking for something along the lines of the wonderware trend client \[Edit: Windows s… --- ## [System.file.writeFile issue creating new file](https://forum.inductiveautomation.com/t/system-file-writefile-issue-creating-new-file/56539)
**Author:** [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Replies:** 4\ **Last updated:** [February 27, 2022, 6:01pm UTC](https://forum.inductiveautomation.com/t/system-file-writefile-issue-creating-new-file/56539 "2022-02-27T18:01:47Z")
Hi I am currently using Ignition 8.1.14 and windows server 2019. I have created button function which create XML File and update it if it is same file. Is there different function to create a new file in same folder. … --- ## [Need help with incrementing a counter + 1 with a button](https://forum.inductiveautomation.com/t/need-help-with-incrementing-a-counter-1-with-a-button/55509)
**Author:** [@IgnitionNewbie](https://forum.inductiveautomation.com/u/IgnitionNewbie)\ **Replies:** 6\ **Last updated:** [February 27, 2022, 3:47am UTC](https://forum.inductiveautomation.com/t/need-help-with-incrementing-a-counter-1-with-a-button/55509 "2022-02-27T03:47:25Z")
Hi there, I am new to ignition and am trying to learn the basics , so I have a button and was trying to make a script that would + 1 to a tag value whenever I clicked on the button I am not really familiar with python a… --- ## [Alarm pipeline is not working in Gateway](https://forum.inductiveautomation.com/t/alarm-pipeline-is-not-working-in-gateway/55519)
**Author:** [@Raghul.G](https://forum.inductiveautomation.com/u/Raghul.G)\ **Replies:** 3\ **Last updated:** [February 27, 2022, 3:23am UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-is-not-working-in-gateway/55519 "2022-02-27T03:23:02Z")
I’m trying to send SMS while some sensor exceeds the particular active points through alarm pipelines. While sensor exceeds that value… In gateway alarm pipeline is not triggering. --- ## [Ignition failure? Navigation/OverviewNav does not exist](https://forum.inductiveautomation.com/t/ignition-failure-navigation-overviewnav-does-not-exist/56595)
**Author:** [@Kyle\_Weaver](https://forum.inductiveautomation.com/u/Kyle_Weaver)\ **Replies:** 1\ **Last updated:** [February 26, 2022, 9:15pm UTC](https://forum.inductiveautomation.com/t/ignition-failure-navigation-overviewnav-does-not-exist/56595 "2022-02-26T21:15:23Z")
Good evening everyone; I’m having a recurring issue regarding this. I’m an amateur when it comes to this software. Is there any troubleshooting steps I could go through? Possibly edit some files? Any input would be great… --- ## [Want to send message on Microsoft Teams to users](https://forum.inductiveautomation.com/t/want-to-send-message-on-microsoft-teams-to-users/56435)
**Author:** [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\ **Replies:** 4\ **Last updated:** [February 26, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/want-to-send-message-on-microsoft-teams-to-users/56435 "2022-02-26T15:00:28Z")
Hi, I want to send teams message through scripting in perspective. Anyone has any idea how we can achieve this? Is it possible or not? Thanks. --- ## [How does one query across monthly data tables?](https://forum.inductiveautomation.com/t/how-does-one-query-across-monthly-data-tables/12703)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 7\ **Last updated:** [February 26, 2022, 2:45am UTC](https://forum.inductiveautomation.com/t/how-does-one-query-across-monthly-data-tables/12703 "2022-02-26T02:45:19Z")
I can’t find an explanation in the documentation. If I write an SQL query I have to pass the table name. How do I ensure that I get records in preceding months (and future months when the time comes)? Many thanks. --- ## [To Excel as xlsx?](https://forum.inductiveautomation.com/t/to-excel-as-xlsx/41860)
**Author:** [@cfuta](https://forum.inductiveautomation.com/u/cfuta)\ **Replies:** 5\ **Last updated:** [February 25, 2022, 10:30pm UTC](https://forum.inductiveautomation.com/t/to-excel-as-xlsx/41860 "2022-02-25T22:30:27Z")
I am currently running a named query that gets exported to excel using system.dataset.exportExcel which works but can only currently export as an xls file. Is there a work around to export as xlsx file? --- ## [Create Popup: Get Value of the Menu Item Clicked On](https://forum.inductiveautomation.com/t/create-popup-get-value-of-the-menu-item-clicked-on/56585)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [February 25, 2022, 10:00pm UTC](https://forum.inductiveautomation.com/t/create-popup-get-value-of-the-menu-item-clicked-on/56585 "2022-02-25T22:00:38Z")
I oddly couldn’t find anywhere that shows how to get the value of the popup menu item that is ultimately clicked on. All of my menu items will call the exact same function and will set a window property to the value tha… --- ## [Scripting a Redundancy Failover](https://forum.inductiveautomation.com/t/scripting-a-redundancy-failover/56543)
**Author:** [@dferrie1](https://forum.inductiveautomation.com/u/dferrie1)\ **Replies:** 3\ **Last updated:** [February 25, 2022, 9:52pm UTC](https://forum.inductiveautomation.com/t/scripting-a-redundancy-failover/56543 "2022-02-25T21:52:45Z")
Is it possible to script a failover to a backup Gateway, and also is the system response time accessible? We have a pair of gateway which have nightly backup taken of them, the server infrastructure is managed by the IT… --- ## [Launch Ignition 8.0 Client on Raspberry PI 3B+](https://forum.inductiveautomation.com/t/launch-ignition-8-0-client-on-raspberry-pi-3b/31867)
**Author:** [@nataliabmuller](https://forum.inductiveautomation.com/u/nataliabmuller)\ **Replies:** 9\ **Last updated:** [February 25, 2022, 9:43pm UTC](https://forum.inductiveautomation.com/t/launch-ignition-8-0-client-on-raspberry-pi-3b/31867 "2022-02-25T21:43:35Z")
After reading through some topics on the subject (http://forum.inductiveautomation.com/t/version-8-32-bit-vision-clients/24658 and http://forum.inductiveautomation.com/t/ignition-8-client-on-raspberry-pi/24464/19), I d… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=882) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=884)