# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=939 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 940 --- ## [stringFormat error Perspective](https://forum.inductiveautomation.com/t/stringformat-error-perspective/52581)
**Author:** [@laurie.croteau](https://forum.inductiveautomation.com/u/laurie.croteau)\ **Replies:** 3\ **Last updated:** [November 1, 2021, 6:38pm UTC](https://forum.inductiveautomation.com/t/stringformat-error-perspective/52581 "2021-11-01T18:38:27Z")
Hi, I want to copy my labels into an email and I want to transfer integer into string, so I used stringFormat. However, I have this error: Error running property change script on NumericEntryField.props.value: NameErro… --- ## [SQL Query - Joining tables according to date](https://forum.inductiveautomation.com/t/sql-query-joining-tables-according-to-date/52543)
**Author:** [@Hefin\_Price](https://forum.inductiveautomation.com/u/Hefin_Price)\ **Replies:** 2\ **Last updated:** [November 1, 2021, 6:37pm UTC](https://forum.inductiveautomation.com/t/sql-query-joining-tables-according-to-date/52543 "2021-11-01T18:37:25Z")
I have two two SQL tables set up, one is for planned future events that contains a column ‘StartDate’ and the other is a record of completed events that has a ‘TimeStamp’ column. Table 1 - SchedulerEvent |StartDate| 2… --- ## [Database Redundancy ( Failover Datasource )](https://forum.inductiveautomation.com/t/database-redundancy-failover-datasource/52489)
**Author:** [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Replies:** 1\ **Last updated:** [November 1, 2021, 6:11pm UTC](https://forum.inductiveautomation.com/t/database-redundancy-failover-datasource/52489 "2021-11-01T18:11:58Z")
Hi all, Image above is the database configuration in the gateway which is the Failover Datasource and Failover Mode. May I know that anyone use this before and how does it work actually ? Currently, I have two NAS (… --- ## [\[IGN-4991, IGN-4996\]system.file.writeFile encoding](https://forum.inductiveautomation.com/t/ign-4991-ign-4996-system-file-writefile-encoding/19878)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 13\ **Last updated:** [November 1, 2021, 5:44pm UTC](https://forum.inductiveautomation.com/t/ign-4991-ign-4996-system-file-writefile-encoding/19878 "2021-11-01T17:44:08Z")
Unlike system.file.readFileAsString, system.file.writeFile has no encoding option. It appears that the behaviour is the same as readFileAsString without any encoding option - it uses Java’s default charset, which is pla… --- ## [SQL Dynamic Query Using PREPARE Statement](https://forum.inductiveautomation.com/t/sql-dynamic-query-using-prepare-statement/52574)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 5\ **Last updated:** [November 1, 2021, 5:50pm UTC](https://forum.inductiveautomation.com/t/sql-dynamic-query-using-prepare-statement/52574 "2021-11-01T17:50:20Z")
I have set up tag historian partitioning, but now I would like to query the most recent data table. I can easily SELECT \* FROM sqlt\_data\_1\_2021\_10, but now it is November, so I need sqlt\_data\_1\_2021\_11. These partition n… --- ## [Error when opening Ignition perspective](https://forum.inductiveautomation.com/t/error-when-opening-ignition-perspective/52528)
**Author:** [@jian.ng](https://forum.inductiveautomation.com/u/jian.ng)\ **Replies:** 1\ **Last updated:** [November 1, 2021, 5:49pm UTC](https://forum.inductiveautomation.com/t/error-when-opening-ignition-perspective/52528 "2021-11-01T17:49:44Z")
Hello, I’m having an error when opening Ignition perspective. I was trying to export a project from one designer and import it into another, but when it doesn’t properly copy over the views or the named queries. In fact,… --- ## [How to make a shortcut for Ignition Vision 7.5.5?](https://forum.inductiveautomation.com/t/how-to-make-a-shortcut-for-ignition-vision-7-5-5/52572)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 5\ **Last updated:** [November 1, 2021, 5:36pm UTC](https://forum.inductiveautomation.com/t/how-to-make-a-shortcut-for-ignition-vision-7-5-5/52572 "2021-11-01T17:36:18Z")
Not really Ignition 7.9 but this tag was the closest. Have an old project thats running Ignition 7.5.5. Need to make a new shortcut for the client after some IP changes broke the old one. I notice the splash page is d… --- ## [Reset Axes in XY classic chart](https://forum.inductiveautomation.com/t/reset-axes-in-xy-classic-chart/52560)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 2\ **Last updated:** [November 1, 2021, 5:19pm UTC](https://forum.inductiveautomation.com/t/reset-axes-in-xy-classic-chart/52560 "2021-11-01T17:19:21Z")
Hi, I am using Classic chart in vision. In chart if we right click we have option for Reset Axes Is there any way to call the Reset axes in script? Can any one help me out in this? --- ## [\[FEATURE\] Perspective Column Container rearrangement bugs](https://forum.inductiveautomation.com/t/feature-perspective-column-container-rearrangement-bugs/38203)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [November 1, 2021, 4:02pm UTC](https://forum.inductiveautomation.com/t/feature-perspective-column-container-rearrangement-bugs/38203 "2021-11-01T16:02:28Z")
v8.0.15 After having just tried to use the column container, I’ve found it quite frustrating to rearrange items around with the mouse. It seems anything I try to move will permanently move every other component that I t… --- ## [Have Chart or Easy chart graph only when tag value is true](https://forum.inductiveautomation.com/t/have-chart-or-easy-chart-graph-only-when-tag-value-is-true/52193)
**Author:** [@user62](https://forum.inductiveautomation.com/u/user62)\ **Replies:** 5\ **Last updated:** [October 29, 2021, 11:01pm UTC](https://forum.inductiveautomation.com/t/have-chart-or-easy-chart-graph-only-when-tag-value-is-true/52193 "2021-10-29T23:01:38Z")
I need an elapsed time x axis. The time would be according to a historical boolean tag going from true\>false and vice-versa. So when tag goes true, plot data. When tag goes false, stop plotting data. I have used the inf… --- ## [Automating address mapping](https://forum.inductiveautomation.com/t/automating-address-mapping/16784)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 7\ **Last updated:** [November 1, 2021, 3:27pm UTC](https://forum.inductiveautomation.com/t/automating-address-mapping/16784 "2021-11-01T15:27:15Z")
We have configured an Ignition system to allow the customer to add new machinery through the user interface. Using a script we can add a new Modbus TCP/IP device using system.device.addDevice. Is it also possible to se… --- ## [\[IGN-4811\]system.gui.messageBox location](https://forum.inductiveautomation.com/t/ign-4811-system-gui-messagebox-location/18562)
**Author:** [@aladdinwow](https://forum.inductiveautomation.com/u/aladdinwow)\ **Replies:** 3\ **Last updated:** [November 1, 2021, 3:20pm UTC](https://forum.inductiveautomation.com/t/ign-4811-system-gui-messagebox-location/18562 "2021-11-01T15:20:43Z")
Hello there, I have a small question regarding the messageBox or any other type of box that is in the system.gui category. If you were to have multiple monitors, and then switch the client to a different monitor, the m… --- ## [Change label name every hour](https://forum.inductiveautomation.com/t/change-label-name-every-hour/52547)
**Author:** [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\ **Replies:** 2\ **Last updated:** [November 1, 2021, 11:44am UTC](https://forum.inductiveautomation.com/t/change-label-name-every-hour/52547 "2021-11-01T11:44:43Z")
hi, I have four status like A,B,C,D. when a tag value changes to true, the status has to change to A. After 2hrs it should automatically change to B. Like this for every 2hrs it has to change to next status. Can i do li… --- ## [Creating a multi-state indicator in perspective](https://forum.inductiveautomation.com/t/creating-a-multi-state-indicator-in-perspective/47894)
**Author:** [@guy](https://forum.inductiveautomation.com/u/guy)\ **Replies:** 3\ **Last updated:** [November 1, 2021, 11:36am UTC](https://forum.inductiveautomation.com/t/creating-a-multi-state-indicator-in-perspective/47894 "2021-11-01T11:36:59Z")
I am looking to create a multi state indicator that changes background color and font color depending on a state value. I have created a custom property called state and binded it to the tag where I get my integer from 0… --- ## [Alarms Auto-Acknowledging in Manual Acknowledge mode](https://forum.inductiveautomation.com/t/alarms-auto-acknowledging-in-manual-acknowledge-mode/11344)
**Author:** [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Replies:** 2\ **Last updated:** [November 1, 2021, 1:18am UTC](https://forum.inductiveautomation.com/t/alarms-auto-acknowledging-in-manual-acknowledge-mode/11344 "2021-11-01T01:18:42Z")
We are having an issue where alarms are Auto-Acknowledging in Manual Acknowledge mode. I am using 7.7.4. Is this a known issue? Dan --- ## [Add menu item to about menu](https://forum.inductiveautomation.com/t/add-menu-item-to-about-menu/19890)
**Author:** [@miketob](https://forum.inductiveautomation.com/u/miketob)\ **Replies:** 9\ **Last updated:** [October 31, 2021, 10:13pm UTC](https://forum.inductiveautomation.com/t/add-menu-item-to-about-menu/19890 "2021-10-31T22:13:44Z")
Is there a way to add a menu item into the Help menu so I can add my own “about my app” menu item? --- ## [Datatype transforming in Vision](https://forum.inductiveautomation.com/t/datatype-transforming-in-vision/52522)
**Author:** [@Dalyn](https://forum.inductiveautomation.com/u/Dalyn)\ **Replies:** 3\ **Last updated:** [October 31, 2021, 9:25pm UTC](https://forum.inductiveautomation.com/t/datatype-transforming-in-vision/52522 "2021-10-31T21:25:27Z")
I’m fairly new to Vision 11.1.10 and Perspection 2.1.10 in Ignition 8.1.10 and am new to Python and JSON. I’ve been developing projects to be used in my facility for these past few months. I’ve found using the Transform … --- ## [Using a CSV file as a datasource for XYChart](https://forum.inductiveautomation.com/t/using-a-csv-file-as-a-datasource-for-xychart/52534)
**Author:** [@taghipoor\_hosein](https://forum.inductiveautomation.com/u/taghipoor_hosein)\ **Replies:** 1\ **Last updated:** [October 31, 2021, 2:03pm UTC](https://forum.inductiveautomation.com/t/using-a-csv-file-as-a-datasource-for-xychart/52534 "2021-10-31T14:03:12Z")
Hello everyone, I have a CSV file and I want to use it as a datasource for my XYChart. I have searched in docs.inductiveautomation and I found that it could be possible by scripting. Is there anyone who can help me do… --- ## [Error Icon In Tags Folder](https://forum.inductiveautomation.com/t/error-icon-in-tags-folder/52454)
**Author:** [@tzbh1234](https://forum.inductiveautomation.com/u/tzbh1234)\ **Replies:** 6\ **Last updated:** [October 31, 2021, 1:43pm UTC](https://forum.inductiveautomation.com/t/error-icon-in-tags-folder/52454 "2021-10-31T13:43:29Z")
Hi, Ignition 7.9.11, I had a lot of tags in the project and suddenly when I open the last project backup I see an Error icon in the tags folder. How to fix it ? Thanks. --- ## [Perspective alarm status table header](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-header/52537)
**Author:** [@1050738465](https://forum.inductiveautomation.com/u/1050738465)\ **Replies:** 0\ **Last updated:** [October 31, 2021, 7:02am UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-header/52537 "2021-10-31T07:02:17Z")
I want to use the Alarm Status Table component in perspective, but I don’t want others to disturb my sorting because it’s meaningless. What can I do to achieve this effect --- ## [Secured (non-text) python script for deployment](https://forum.inductiveautomation.com/t/secured-non-text-python-script-for-deployment/51920)
**Author:** [@user5](https://forum.inductiveautomation.com/u/user5)\ **Replies:** 3\ **Last updated:** [October 31, 2021, 5:30am UTC](https://forum.inductiveautomation.com/t/secured-non-text-python-script-for-deployment/51920 "2021-10-31T05:30:07Z")
Hello, We are extending the functionality in Ignition UI with Python scripting, some or most of it could be considered IP and we do not want our customers to be able to read the files. So far what we have seen is that … --- ## [Writing table component data to an array tag](https://forum.inductiveautomation.com/t/writing-table-component-data-to-an-array-tag/52532)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 6\ **Last updated:** [October 30, 2021, 10:34pm UTC](https://forum.inductiveautomation.com/t/writing-table-component-data-to-an-array-tag/52532 "2021-10-30T22:34:48Z")
I am testing a new project which I am trying to write table component data to an array tag that is part of a UDT in the PLC. I will eventually be writing to 4 different PLC’s. The total array for the UDT is 501 skipping … --- ## [Display custom message when Perspective Table has no data](https://forum.inductiveautomation.com/t/display-custom-message-when-perspective-table-has-no-data/52499)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 6\ **Last updated:** [October 30, 2021, 9:54am UTC](https://forum.inductiveautomation.com/t/display-custom-message-when-perspective-table-has-no-data/52499 "2021-10-30T09:54:25Z")
I want to display a message when no data on table, something like below but it’s not working, plz let me know how to mention for table if nodata if (LotId!="" or MatlAutoId!=None) and vtable==dataset\[0x6\]: self.props.… --- ## [BasicExecutionEngine spamming logs](https://forum.inductiveautomation.com/t/basicexecutionengine-spamming-logs/15141)
**Author:** [@pturner](https://forum.inductiveautomation.com/u/pturner)\ **Replies:** 6\ **Last updated:** [October 30, 2021, 5:16am UTC](https://forum.inductiveautomation.com/t/basicexecutionengine-spamming-logs/15141 "2021-10-30T05:16:30Z")
Hello forums, One of my ignition servers is being spammed with this error every 30 seconds. What's it mean, and how can I resolve it? BasicExecutionEngine 22Aug2017 12:51:51 Task usersourcemanager cache-updater threw … --- ## [OPC UA Server Connection faulted](https://forum.inductiveautomation.com/t/opc-ua-server-connection-faulted/31070)
**Author:** [@pratikme1](https://forum.inductiveautomation.com/u/pratikme1)\ **Replies:** 8\ **Last updated:** [October 29, 2021, 9:23pm UTC](https://forum.inductiveautomation.com/t/opc-ua-server-connection-faulted/31070 "2021-10-29T21:23:54Z")
I am getting following error. Returning ServiceFault for request: com.inductiveautomation.opcua.types.messages.ActivateSessionRequest@5c3d1b49. StatusCode=StatusCode\[Severity=Bad, Subcode=Bad\_UserAccessDenied\] --- ## [Find the Database File](https://forum.inductiveautomation.com/t/find-the-database-file/52520)
**Author:** [@hrissley](https://forum.inductiveautomation.com/u/hrissley)\ **Replies:** 0\ **Last updated:** [October 29, 2021, 8:01pm UTC](https://forum.inductiveautomation.com/t/find-the-database-file/52520 "2021-10-29T20:01:09Z")
I took over our Ignition system and I am trying to clean up some old projects. I am getting some quarantined items I am trying to fix, (duplicate key). Is there a way to search projects to find a database or do i have … --- ## [queryAuditLog find limited number of most recent matches](https://forum.inductiveautomation.com/t/queryauditlog-find-limited-number-of-most-recent-matches/52519)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 0\ **Last updated:** [October 29, 2021, 7:43pm UTC](https://forum.inductiveautomation.com/t/queryauditlog-find-limited-number-of-most-recent-matches/52519 "2021-10-29T19:43:59Z")
As our system makes more use of the audit log for recording important events, we’re also finding use cases where we want to quickly fetch and display the most recent instances of certain events. I’ve peeked at the DB si… --- ## [Bug Time Axis in easy chart](https://forum.inductiveautomation.com/t/bug-time-axis-in-easy-chart/9999)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 4\ **Last updated:** [October 29, 2021, 6:53pm UTC](https://forum.inductiveautomation.com/t/bug-time-axis-in-easy-chart/9999 "2021-10-29T18:53:13Z")
Hi everybody, When I use an easy chart, time axis show this time format xx:59 and xx:29. Can we resolve this problem to have rounded time like xx:00 and xx:30 ? Thanks, --- ## [Expression: Find Lowest Non-Zero Number?](https://forum.inductiveautomation.com/t/expression-find-lowest-non-zero-number/52496)
**Author:** [@downerczx](https://forum.inductiveautomation.com/u/downerczx)\ **Replies:** 12\ **Last updated:** [October 29, 2021, 6:33pm UTC](https://forum.inductiveautomation.com/t/expression-find-lowest-non-zero-number/52496 "2021-10-29T18:33:31Z")
Hello, I have a set of tags with values, \[0,2,0,1\]. I need to find the lowest non-zero number from my set in expression language. The min() expression always brings back the zeros. Any ideas? Thank you. --- ## [Alarm Journal Eventflags version 8](https://forum.inductiveautomation.com/t/alarm-journal-eventflags-version-8/52510)
**Author:** [@JR7](https://forum.inductiveautomation.com/u/JR7)\ **Replies:** 4\ **Last updated:** [October 29, 2021, 5:56pm UTC](https://forum.inductiveautomation.com/t/alarm-journal-eventflags-version-8/52510 "2021-10-29T17:56:22Z")
Hi All, Is there a full description of eventflags in alarm jounal eventflags table in alarm and events table? The Ignition generate a lot of eventflags=24 in our system once the OPC connection restarted. Thanks, … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=938) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=940)