# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=895 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 896 --- ## [Close a workbook with openpyxl](https://forum.inductiveautomation.com/t/close-a-workbook-with-openpyxl/55720)
**Author:** [@g.cascales](https://forum.inductiveautomation.com/u/g.cascales)\ **Replies:** 6\ **Last updated:** [February 4, 2022, 1:20pm UTC](https://forum.inductiveautomation.com/t/close-a-workbook-with-openpyxl/55720 "2022-02-04T13:20:21Z")
Hello there! as @zxcslo indicated in Copying a Excel file to a tables Dataset - #38 by zxcslo the openpyxl worked also for me. But I am having issues when it comes to close or save the file. The code I am using is: f… --- ## [Any ideas for a substitute to dropdown?](https://forum.inductiveautomation.com/t/any-ideas-for-a-substitute-to-dropdown/55727)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 3\ **Last updated:** [February 4, 2022, 9:22am UTC](https://forum.inductiveautomation.com/t/any-ideas-for-a-substitute-to-dropdown/55727 "2022-02-04T09:22:08Z")
Good day! I am writing a page in perspective to select a piece of equipment (88 of them) and then display the last Workorders entered into our CMMS. At the moment I think im going to use a dropdown menu, but I was wonder… --- ## [MemoryForwardTransaction](https://forum.inductiveautomation.com/t/memoryforwardtransaction/32344)
**Author:** [@seth.hathcock](https://forum.inductiveautomation.com/u/seth.hathcock)\ **Replies:** 1\ **Last updated:** [February 4, 2022, 7:40am UTC](https://forum.inductiveautomation.com/t/memoryforwardtransaction/32344 "2022-02-04T07:40:38Z")
Hello, I am getting this error filling up my logs and I cannot seem to figure it out. 11:59:16 AM MemoryForwardTransaction Error forwarding data: Duplicate entry ‘34801-1581962350174’ for key ‘PRIMARY’ java.sql… --- ## [Trigger is not working](https://forum.inductiveautomation.com/t/trigger-is-not-working/55640)
**Author:** [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\ **Replies:** 5\ **Last updated:** [February 4, 2022, 3:56am UTC](https://forum.inductiveautomation.com/t/trigger-is-not-working/55640 "2022-02-04T03:56:40Z")
Hi guys, I have a standard trans group and trying to use the trigger option. Currently, I’m facing the issue that my project keeps logging the data 5 secs interval, which is my execution scheduling not my trigger settin… --- ## [\[FEATURE\] Perspective PowerChart - Axes: add individual auto-range for min and max](https://forum.inductiveautomation.com/t/feature-perspective-powerchart-axes-add-individual-auto-range-for-min-and-max/55736)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [February 3, 2022, 11:24pm UTC](https://forum.inductiveautomation.com/t/feature-perspective-powerchart-axes-add-individual-auto-range-for-min-and-max/55736 "2022-02-03T23:24:37Z")
Oftentimes I will want to auto range only the high range and keep the min set to say 0. Being able to individually enable auto ranging for min and max would solve this. --- ## [Pulling Project Properties (Identity Provider) into script](https://forum.inductiveautomation.com/t/pulling-project-properties-identity-provider-into-script/55681)
**Author:** [@Taylor\_Marsh](https://forum.inductiveautomation.com/u/Taylor_Marsh)\ **Replies:** 1\ **Last updated:** [February 4, 2022, 12:00am UTC](https://forum.inductiveautomation.com/t/pulling-project-properties-identity-provider-into-script/55681 "2022-02-04T00:00:33Z")
I am trying to create a gateway event to check and make sure that our Identity Provider, User Source and Required Client Roles are correct in the Project Properties, and alarm if it is not. I am having trouble finding a … --- ## [\[IGN-4972\] Translate - Help/Diagnostics](https://forum.inductiveautomation.com/t/ign-4972-translate-help-diagnostics/55504)
**Author:** [@Esme\_Lopez](https://forum.inductiveautomation.com/u/Esme_Lopez)\ **Replies:** 9\ **Last updated:** [February 3, 2022, 11:21pm UTC](https://forum.inductiveautomation.com/t/ign-4972-translate-help-diagnostics/55504 "2022-02-03T23:21:14Z")
Can Anyone know how to translate the diagnostics standard window ? Because I can’t do it, I tried to add the list of the words but didn’t work. --- ## [Ignition 8.1.0 - default Error executing annotation query with powerChart component](https://forum.inductiveautomation.com/t/ignition-8-1-0-default-error-executing-annotation-query-with-powerchart-component/40494)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 18\ **Last updated:** [February 3, 2022, 11:04pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0-default-error-executing-annotation-query-with-powerchart-component/40494 "2022-02-03T23:04:49Z")
Ignition 8.1.0 MYSQL 8.0.20 JDBC Driver: mysql-connector-java-8.0.20.jar When I use the perspective powerChart component, every seconds I have the following error in the gateway logs. DB 10Nov2020 17:30:16 default Er… --- ## [Perspective power chart](https://forum.inductiveautomation.com/t/perspective-power-chart/55725)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 9:37pm UTC](https://forum.inductiveautomation.com/t/perspective-power-chart/55725 "2022-02-03T21:37:44Z")
I have a power chart with historical data (tags) and I would like to add a static plot, eg. a target or threshold to the chart. How should I add this value to the chart? --- ## [Evaluating bindings as you type (SILLY)](https://forum.inductiveautomation.com/t/evaluating-bindings-as-you-type-silly/55733)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 0\ **Last updated:** [February 3, 2022, 9:33pm UTC](https://forum.inductiveautomation.com/t/evaluating-bindings-as-you-type-silly/55733 "2022-02-03T21:33:46Z")
This is what you end up with after Designer keeps evaluating a binding script as you are typing and that script creates a new property: :rofl: --- ## [Gateway Network Faulting](https://forum.inductiveautomation.com/t/gateway-network-faulting/55713)
**Author:** [@CHAD.LOUSBERG](https://forum.inductiveautomation.com/u/CHAD.LOUSBERG)\ **Replies:** 4\ **Last updated:** [February 3, 2022, 9:31pm UTC](https://forum.inductiveautomation.com/t/gateway-network-faulting/55713 "2022-02-03T21:31:18Z")
We have a Perspective Project that is connecting via Gateway Network to several locations, many of which have a mediocre internet connection, so it’s not uncommon for a couple to be faulted. When we connect to 5 or 6 Gat… --- ## [\[BUG\] Alarm Journal delayed filters after 30 seconds](https://forum.inductiveautomation.com/t/bug-alarm-journal-delayed-filters-after-30-seconds/48880)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 4\ **Last updated:** [February 3, 2022, 9:00pm UTC](https://forum.inductiveautomation.com/t/bug-alarm-journal-delayed-filters-after-30-seconds/48880 "2022-02-03T21:00:47Z")
In Perspective's Alarm Journal component....when adding an expression binding to the "source" or "displayPath" filter conditions in the designer, the journal filters immediately and quickly. However, at runtime, when ar… --- ## [UDT Expression Tag Dictionary](https://forum.inductiveautomation.com/t/udt-expression-tag-dictionary/55728)
**Author:** [@Alexavier\_Garcia](https://forum.inductiveautomation.com/u/Alexavier_Garcia)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 8:45pm UTC](https://forum.inductiveautomation.com/t/udt-expression-tag-dictionary/55728 "2022-02-03T20:45:00Z")
Im trying to get the Fault1Description expression tag to return a string message based on the value of Fault1Code but only when Faulted is True. I want this string to show up on the display path of the Faulted bit’s Alar… --- ## [Fill Paint and Stroke Style](https://forum.inductiveautomation.com/t/fill-paint-and-stroke-style/3940)
**Author:** [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 7:20pm UTC](https://forum.inductiveautomation.com/t/fill-paint-and-stroke-style/3940 "2022-02-03T19:20:02Z")
This may have been discussed before, but I would like to be able to access the Fill Paint pattern, foreground and background color properties dynamically on basic shapes (rectangle). Also would be nice to access Stroke S… --- ## [Report Header Repeating](https://forum.inductiveautomation.com/t/report-header-repeating/55716)
**Author:** [@steven.rehnborg](https://forum.inductiveautomation.com/u/steven.rehnborg)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/report-header-repeating/55716 "2022-02-03T18:05:22Z")
I know I am missing something basic, but my report is repeating the header in the CSV file. Any suggestions? --- ## [Ignition disaster recovery test in a sandbox, without attaching in production](https://forum.inductiveautomation.com/t/ignition-disaster-recovery-test-in-a-sandbox-without-attaching-in-production/55723)
**Author:** [@NewFan](https://forum.inductiveautomation.com/u/NewFan)\ **Replies:** 0\ **Last updated:** [February 3, 2022, 5:43pm UTC](https://forum.inductiveautomation.com/t/ignition-disaster-recovery-test-in-a-sandbox-without-attaching-in-production/55723 "2022-02-03T17:43:29Z")
Hi, My question is related to Disaster recovery planning exercice for servers running Ignition. Is there a way to test if the environnement (Server with Ignition installed and backuped as VM snapshot, etc.) is fully wo… --- ## [Ignition Edge OPC-UA Capabilities](https://forum.inductiveautomation.com/t/ignition-edge-opc-ua-capabilities/55614)
**Author:** [@Darran\_Weissenborn](https://forum.inductiveautomation.com/u/Darran_Weissenborn)\ **Replies:** 6\ **Last updated:** [February 3, 2022, 4:35pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-opc-ua-capabilities/55614 "2022-02-03T16:35:18Z")
I am using an Opto 22 EPIC PR1 device running Ignition Edge 8.1.7 (Trial Licence Version). I have a project which needs to achieve the following: Obtain data from an OPC-UA Server connected to one IP port of the EPIC… --- ## [Reading files from symbolic link folder](https://forum.inductiveautomation.com/t/reading-files-from-symbolic-link-folder/55646)
**Author:** [@anastasia.blinova](https://forum.inductiveautomation.com/u/anastasia.blinova)\ **Replies:** 9\ **Last updated:** [February 3, 2022, 4:33pm UTC](https://forum.inductiveautomation.com/t/reading-files-from-symbolic-link-folder/55646 "2022-02-03T16:33:06Z")
I have a symbolic link folder on the C drive of the machine running the gateway. When I try: os.path.exists(path) it returns False. When I try the same with a different folder on the C drive with the same permissions… --- ## [SMS Notification Using Twilio](https://forum.inductiveautomation.com/t/sms-notification-using-twilio/40228)
**Author:** [@manju.p](https://forum.inductiveautomation.com/u/manju.p)\ **Replies:** 10\ **Last updated:** [February 3, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/sms-notification-using-twilio/40228 "2022-02-03T16:13:50Z")
Aim: As a user, I need to acknowledge the alarm by sending an acknowledgement reply to the SMS Alarm Notification. SMS Notification Profile had been created in Ignition Gateway to send SMS to ordered lists of users in t… --- ## [Perspective Component Carousel Dots](https://forum.inductiveautomation.com/t/perspective-component-carousel-dots/55718)
**Author:** [@alex.dunning](https://forum.inductiveautomation.com/u/alex.dunning)\ **Replies:** 0\ **Last updated:** [February 3, 2022, 3:41pm UTC](https://forum.inductiveautomation.com/t/perspective-component-carousel-dots/55718 "2022-02-03T15:41:17Z")
Is it possible to animate the dots on the Carousel object in perspective besides the currently selected view? Also, is it possible to have unique icons for each view on the carousel? --- ## [Web Browser Component - Site Can't Be Reached](https://forum.inductiveautomation.com/t/web-browser-component-site-cant-be-reached/55714)
**Author:** [@Nicholas\_Houston](https://forum.inductiveautomation.com/u/Nicholas_Houston)\ **Replies:** 0\ **Last updated:** [February 3, 2022, 2:49pm UTC](https://forum.inductiveautomation.com/t/web-browser-component-site-cant-be-reached/55714 "2022-02-03T14:49:25Z")
I am trying to access a power meter website to view current, voltage, etc… from an ignition client web browser component. The power meter is a power xpert 4000 series. I am able to ping the power meter’s IP address and a… --- ## [Perspective - Popup - Breakpoint](https://forum.inductiveautomation.com/t/perspective-popup-breakpoint/39534)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 1:32pm UTC](https://forum.inductiveautomation.com/t/perspective-popup-breakpoint/39534 "2022-02-03T13:32:31Z")
I’m on 8.0.16 Is there a way to get a popup responsive ? I try to configure a view for a popup and want to set it with breakpoint but the popup use the width of the breakpoint view and not the size of the small and lar… --- ## [Database table visualization in Vision launcher-error](https://forum.inductiveautomation.com/t/database-table-visualization-in-vision-launcher-error/55700)
**Author:** [@Serban\_Laurentiu](https://forum.inductiveautomation.com/u/Serban_Laurentiu)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 1:15pm UTC](https://forum.inductiveautomation.com/t/database-table-visualization-in-vision-launcher-error/55700 "2022-02-03T13:15:14Z")
I’m using Designer launcher and Vision client launcher for about 2-3 weeks. I’ve found something that i dont understand: -I did a database and Vision window for this database in Designer launcher and everything works g… --- ## [Easy chart - Drag and drop tags from a Tag browse tree](https://forum.inductiveautomation.com/t/easy-chart-drag-and-drop-tags-from-a-tag-browse-tree/24158)
**Author:** [@rdelasheras](https://forum.inductiveautomation.com/u/rdelasheras)\ **Replies:** 1\ **Last updated:** [February 3, 2022, 11:47am UTC](https://forum.inductiveautomation.com/t/easy-chart-drag-and-drop-tags-from-a-tag-browse-tree/24158 "2022-02-03T11:47:21Z")
Hello. I have a Tag browse tree and I can drag and drop tags to an Easy chart. But I want to show the full path of the tags as its Name in the Pen Control. And I want to add a new Axis for the new dropped tag. Is there … --- ## [Tag Status Rollup](https://forum.inductiveautomation.com/t/tag-status-rollup/55692)
**Author:** [@DSandy](https://forum.inductiveautomation.com/u/DSandy)\ **Replies:** 2\ **Last updated:** [February 3, 2022, 12:27am UTC](https://forum.inductiveautomation.com/t/tag-status-rollup/55692 "2022-02-03T00:27:03Z")
I must be missing something, this should be simple. We have a UDT with an integer status tag calculated on the device. I currently have about 75 of those devices, but will end up with several hundred. The UDT also inclu… --- ## [Issues reading tags from AB EN4TR - Connects but tags Uncertain\_LastKnownValue quality](https://forum.inductiveautomation.com/t/issues-reading-tags-from-ab-en4tr-connects-but-tags-uncertain-lastknownvalue-quality/55691)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 5\ **Last updated:** [February 2, 2022, 11:23pm UTC](https://forum.inductiveautomation.com/t/issues-reading-tags-from-ab-en4tr-connects-but-tags-uncertain-lastknownvalue-quality/55691 "2022-02-02T23:23:47Z")
I’m testing comms to an L83 via an AB EN4TR however I’m unable to get it reading tags. It connects fine but tags are coming up with: \[2, Uncertain\_LastKnownValue(“Whatever was updating this value has stopped doing so.”)… --- ## [Faulted Connection to Oracle 12c](https://forum.inductiveautomation.com/t/faulted-connection-to-oracle-12c/55685)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 1\ **Last updated:** [February 2, 2022, 9:26pm UTC](https://forum.inductiveautomation.com/t/faulted-connection-to-oracle-12c/55685 "2022-02-02T21:26:25Z")
With Ignition 8.1.11, I’m trying to configure a connection to an Oracle 12c database and I get the following error message: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The IT admi… --- ## [How to get Ignition install directory (OS agnostic)?](https://forum.inductiveautomation.com/t/how-to-get-ignition-install-directory-os-agnostic/40456)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [February 2, 2022, 9:25pm UTC](https://forum.inductiveautomation.com/t/how-to-get-ignition-install-directory-os-agnostic/40456 "2022-02-02T21:25:19Z")
As in the title, how can I get the Ignition install directory that is OS agnostic? Also, are the relative paths from this point onwards the same regardless of OS? e.g. the Perspective projects directory, is this always… --- ## [How to filter tags and folders in all tag tree browser using one common script instead of running script in all tag tree browser?](https://forum.inductiveautomation.com/t/how-to-filter-tags-and-folders-in-all-tag-tree-browser-using-one-common-script-instead-of-running-script-in-all-tag-tree-browser/46706)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 64\ **Last updated:** [February 2, 2022, 8:45pm UTC](https://forum.inductiveautomation.com/t/how-to-filter-tags-and-folders-in-all-tag-tree-browser-using-one-common-script-instead-of-running-script-in-all-tag-tree-browser/46706 "2022-02-02T20:45:51Z")
Hi, i am using tag tree browser in my project in different modules In future if customer adding a folder called system tags that i want to hide, but instead of going to every tag tree browser and write script in filter … --- ## [java.sql.SQLException after migration 7.9 to 8.1 and with SQL Server 2005 Database Connection](https://forum.inductiveautomation.com/t/java-sql-sqlexception-after-migration-7-9-to-8-1-and-with-sql-server-2005-database-connection/41526)
**Author:** [@david.roy](https://forum.inductiveautomation.com/u/david.roy)\ **Replies:** 7\ **Last updated:** [February 2, 2022, 8:08pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-after-migration-7-9-to-8-1-and-with-sql-server-2005-database-connection/41526 "2022-02-02T20:08:23Z")
At begin, we installed Ignition 7.9. Our Database is SQL Server 2005 installed on another server. Our JDBC Driver 4.0 on Ignition 7.9 worked has well before upgrade. After upgraded to Ignition 8.1, we has this error “j… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=894) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=896)