# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=662 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 663 --- ## [\[Feature-1985\]Perspective table: Close sub view of table via script](https://forum.inductiveautomation.com/t/feature-1985-perspective-table-close-sub-view-of-table-via-script/37995)
**Author:** [@yash.bhan](https://forum.inductiveautomation.com/u/yash.bhan)\ **Replies:** 3\ **Last updated:** [April 26, 2023, 2:13pm UTC](https://forum.inductiveautomation.com/t/feature-1985-perspective-table-close-sub-view-of-table-via-script/37995 "2023-04-26T14:13:10Z")
Hi Is there any way to close/collapse an open sub view in a table via script. --- ## [Perspective Table Subview - Row disappearing keeps subview open on row that takes its place](https://forum.inductiveautomation.com/t/perspective-table-subview-row-disappearing-keeps-subview-open-on-row-that-takes-its-place/39518)
**Author:** [@john.glynn](https://forum.inductiveautomation.com/u/john.glynn)\ **Replies:** 7\ **Last updated:** [April 26, 2023, 1:42pm UTC](https://forum.inductiveautomation.com/t/perspective-table-subview-row-disappearing-keeps-subview-open-on-row-that-takes-its-place/39518 "2023-04-26T13:42:17Z")
Version: 8.0.16 (b2020082513) I have a perspective table with a subview. The table shows alarms and on the subview there is an option to shelve the alarm. This causes the row to disappear because the table only shows u… --- ## [Perspective data crash](https://forum.inductiveautomation.com/t/perspective-data-crash/72916)
**Author:** [@AntoineF](https://forum.inductiveautomation.com/u/AntoineF)\ **Replies:** 3\ **Last updated:** [April 26, 2023, 1:18pm UTC](https://forum.inductiveautomation.com/t/perspective-data-crash/72916 "2023-04-26T13:18:49Z")
Hello everybody, I regularly (around once a day) have a problem with perspective crashing and not displaying data anymore : It affects the 3 differents projects that are hosted on the gateway and the only way I can … --- ## [Integrating transaction groups with a unique database structure](https://forum.inductiveautomation.com/t/integrating-transaction-groups-with-a-unique-database-structure/72898)
**Author:** [@Sam\_Engsberg](https://forum.inductiveautomation.com/u/Sam_Engsberg)\ **Replies:** 3\ **Last updated:** [April 26, 2023, 12:55pm UTC](https://forum.inductiveautomation.com/t/integrating-transaction-groups-with-a-unique-database-structure/72898 "2023-04-26T12:55:17Z")
On a request from a customer, I want to eliminate a bunch of data entry via form into an existing database. The database structure uses similarly structured tables kept in 6 tables separated based on frequency that is r… --- ## [Run to startup Ignition Perspective with PC ThinPro 7.2.0 ubuntu](https://forum.inductiveautomation.com/t/run-to-startup-ignition-perspective-with-pc-thinpro-7-2-0-ubuntu/72869)
**Author:** [@VARGAS\_Fabien](https://forum.inductiveautomation.com/u/VARGAS_Fabien)\ **Replies:** 4\ **Last updated:** [April 26, 2023, 12:34pm UTC](https://forum.inductiveautomation.com/t/run-to-startup-ignition-perspective-with-pc-thinpro-7-2-0-ubuntu/72869 "2023-04-26T12:34:50Z")
After install Perspective Workstation, I would like run my application when stratup my computer and put a bash file in the desktop for execute. I tried all solution ".desktop" and "init.d". Nothing works. Do you have a… --- ## [Classic Chart X-Axis always show date not time](https://forum.inductiveautomation.com/t/classic-chart-x-axis-always-show-date-not-time/72874)
**Author:** [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\ **Replies:** 2\ **Last updated:** [April 26, 2023, 12:19pm UTC](https://forum.inductiveautomation.com/t/classic-chart-x-axis-always-show-date-not-time/72874 "2023-04-26T12:19:37Z")
I have a classic chart that gets its data from a named query. The query consolidates the data by day. Therefore, I always want to show the date on the X-axis on the chart. However, I still want auto scaling because th… --- ## [Novice seeks help with Vision Property Change Script - \*He thinks\*](https://forum.inductiveautomation.com/t/novice-seeks-help-with-vision-property-change-script-he-thinks/72864)
**Author:** [@S1ack](https://forum.inductiveautomation.com/u/S1ack)\ **Replies:** 12\ **Last updated:** [April 26, 2023, 11:08am UTC](https://forum.inductiveautomation.com/t/novice-seeks-help-with-vision-property-change-script-he-thinks/72864 "2023-04-26T11:08:37Z")
My issue is this....looking at an old HMI (Delphi 5 w/Pascal - what fun) they set a tag value based on what forms are open/visible by the operator. So in Ignition (vision) I have (2) pages with (5) tabs total. I created … --- ## [Copied internal user tables over, now primary key constraint failling when adding new user](https://forum.inductiveautomation.com/t/copied-internal-user-tables-over-now-primary-key-constraint-failling-when-adding-new-user/72345)
**Author:** [@jeffrey.boey](https://forum.inductiveautomation.com/u/jeffrey.boey)\ **Replies:** 2\ **Last updated:** [April 26, 2023, 8:31am UTC](https://forum.inductiveautomation.com/t/copied-internal-user-tables-over-now-primary-key-constraint-failling-when-adding-new-user/72345 "2023-04-26T08:31:23Z")
Hi guys, bit of a curious problem. I've copied the following tables over during a migration, everything worked out, roles where preserved, users could log in etc. However, when I want to create a new user, I'm gettin… --- ## [Easy Chart-Vision](https://forum.inductiveautomation.com/t/easy-chart-vision/72209)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 7\ **Last updated:** [April 26, 2023, 6:50am UTC](https://forum.inductiveautomation.com/t/easy-chart-vision/72209 "2023-04-26T06:50:12Z")
Hi , I am currently working on vision easy chart to allow users to dynamically select the pen. I have 80 to 100 parameters for a process where i would like to display only the pens in groups not the chart as users want … --- ## [BACNET/IP communications](https://forum.inductiveautomation.com/t/bacnet-ip-communications/71227)
**Author:** [@r.lebohec](https://forum.inductiveautomation.com/u/r.lebohec)\ **Replies:** 7\ **Last updated:** [April 26, 2023, 7:33am UTC](https://forum.inductiveautomation.com/t/bacnet-ip-communications/71227 "2023-04-26T07:33:13Z")
Hi, On our Ignition platform composed of an Ignition server and a Siemens PXC12 Bacnet/IP PLC present on the same subnet network (192.168.1.0 /24 ) Ignition does not connect to the PLC in Bacnet/IP. By doing a w… --- ## [How to take aggregate values of powerchart such as Maximum values, Average values to display on the table](https://forum.inductiveautomation.com/t/how-to-take-aggregate-values-of-powerchart-such-as-maximum-values-average-values-to-display-on-the-table/72901)
**Author:** [@Kannan\_Karunanithi](https://forum.inductiveautomation.com/u/Kannan_Karunanithi)\ **Replies:** 1\ **Last updated:** [April 26, 2023, 7:24am UTC](https://forum.inductiveautomation.com/t/how-to-take-aggregate-values-of-powerchart-such-as-maximum-values-average-values-to-display-on-the-table/72901 "2023-04-26T07:24:07Z")
I have a power chart designed to display tags. How to take aggregate values of powerchart such as Maximum values, Average values to display on the table. --- ## [Upload and select image from perspective client](https://forum.inductiveautomation.com/t/upload-and-select-image-from-perspective-client/72858)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 4\ **Last updated:** [April 26, 2023, 7:24am UTC](https://forum.inductiveautomation.com/t/upload-and-select-image-from-perspective-client/72858 "2023-04-26T07:24:04Z")
I would like to achieve the following functions: upload image the perspective user can select a local (PC/Phone) image, rename it and upload it to the server. select image the operator can click a button from perspe… --- ## [Import tags with values from MQTT Edge](https://forum.inductiveautomation.com/t/import-tags-with-values-from-mqtt-edge/72868)
**Author:** [@Daniel\_Wade](https://forum.inductiveautomation.com/u/Daniel_Wade)\ **Replies:** 1\ **Last updated:** [April 26, 2023, 4:58am UTC](https://forum.inductiveautomation.com/t/import-tags-with-values-from-mqtt-edge/72868 "2023-04-26T04:58:16Z")
I have to create an offline testing environment for SCADA development. The live system gets MQTT data from an Edge server. I'm wondering if there is a way to import the MQTT tags with their values so I can use this as a … --- ## [Sudden Internal Error has occurred when trying to open Databases/Drivers Config page](https://forum.inductiveautomation.com/t/sudden-internal-error-has-occurred-when-trying-to-open-databases-drivers-config-page/72087)
**Author:** [@UnSuk\_Song](https://forum.inductiveautomation.com/u/UnSuk_Song)\ **Replies:** 3\ **Last updated:** [April 26, 2023, 1:24am UTC](https://forum.inductiveautomation.com/t/sudden-internal-error-has-occurred-when-trying-to-open-databases-drivers-config-page/72087 "2023-04-26T01:24:11Z")
Internal Error has occurred while configuring 3rd-party JDBC drvier and its Translator. \[Reenactment\] I deleted 3rd-party Database Connection, JDBC Driver & Translator on Gateway Config page. Then to make it clear, … --- ## [High Speed Topic MQTT Subscription](https://forum.inductiveautomation.com/t/high-speed-topic-mqtt-subscription/72328)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 19\ **Last updated:** [April 26, 2023, 12:02am UTC](https://forum.inductiveautomation.com/t/high-speed-topic-mqtt-subscription/72328 "2023-04-26T00:02:28Z")
I'm looking for anyone who has experience consuming high speed messages from MQ using Cirrus link. If this thread is better posted on their forum, please let me know. As a way to explain the issue we have, when we trie… --- ## [Self Property Reference Vision](https://forum.inductiveautomation.com/t/self-property-reference-vision/72872)
**Author:** [@rfolkes](https://forum.inductiveautomation.com/u/rfolkes)\ **Replies:** 2\ **Last updated:** [April 25, 2023, 11:12pm UTC](https://forum.inductiveautomation.com/t/self-property-reference-vision/72872 "2023-04-25T23:12:00Z")
I have a Label with a custom property {Row} I want to be able to use this to do some expressions. For example (not actual script here) if (Len(dataset) \> {row},1,0) for visibility Dataset\[{row},3\] = value Da… --- ## [Custom JAR files preventing 7.9 server from startings](https://forum.inductiveautomation.com/t/custom-jar-files-preventing-7-9-server-from-startings/72893)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 1\ **Last updated:** [April 25, 2023, 10:55pm UTC](https://forum.inductiveautomation.com/t/custom-jar-files-preventing-7-9-server-from-startings/72893 "2023-04-25T22:55:34Z")
I'm attempting to start an Ignition server from a backup but it fails because it is looking for custom Jar files. Is it possible to simply comment those Jar files out of some config file so that the Ignition server does … --- ## [Can't read Tags from SIEMENS OPC server](https://forum.inductiveautomation.com/t/cant-read-tags-from-siemens-opc-server/67778)
**Author:** [@Anna\_Goldberg](https://forum.inductiveautomation.com/u/Anna_Goldberg)\ **Replies:** 7\ **Last updated:** [April 25, 2023, 9:41pm UTC](https://forum.inductiveautomation.com/t/cant-read-tags-from-siemens-opc-server/67778 "2023-04-25T21:41:44Z")
Hi, I'm having some problems reading tags from SIEMENS OPC-UA Server. I've configured an additional OPC connection for SIEMENS OPC server in ignition. I've added tags to ignition and was able to read them. After resta… --- ## [Design launcherh](https://forum.inductiveautomation.com/t/design-launcherh/72888)
**Author:** [@Ashraf\_ABDUALKAREEM](https://forum.inductiveautomation.com/u/Ashraf_ABDUALKAREEM)\ **Replies:** 8\ **Last updated:** [April 25, 2023, 8:58pm UTC](https://forum.inductiveautomation.com/t/design-launcherh/72888 "2023-04-25T20:58:23Z")
I installed ignition 8.1.20 but when i start design launcher it doesn't work --- ## [Help needed for setting up Redundancy in Ignition 8](https://forum.inductiveautomation.com/t/help-needed-for-setting-up-redundancy-in-ignition-8/24715)
**Author:** [@aaron1](https://forum.inductiveautomation.com/u/aaron1)\ **Replies:** 6\ **Last updated:** [April 25, 2023, 7:00pm UTC](https://forum.inductiveautomation.com/t/help-needed-for-setting-up-redundancy-in-ignition-8/24715 "2023-04-25T19:00:05Z")
Hi all, I am trying to set up Redundancy in Ignition 8 for some testing using two VMs but haven't had much luck so far. I followed the usual steps for setting up redundancy also refer to the thread for setting up the… --- ## [Cannot start gateway after upgrade to 8.1.16](https://forum.inductiveautomation.com/t/cannot-start-gateway-after-upgrade-to-8-1-16/58855)
**Author:** [@kuek](https://forum.inductiveautomation.com/u/kuek)\ **Replies:** 4\ **Last updated:** [April 25, 2023, 6:31pm UTC](https://forum.inductiveautomation.com/t/cannot-start-gateway-after-upgrade-to-8-1-16/58855 "2023-04-25T18:31:24Z")
Gateway failed to start. Anyone can help to advise? Running Ignition-Gateway... wrapper | --\> Wrapper Started as Console wrapper | Java Service Wrapper Standard Edition 64-bit 3.5.42 wrapper | Copyright (C) 1999-20… --- ## [FileUpload filebytes convert to \`multipart/form-data\` compatible data](https://forum.inductiveautomation.com/t/fileupload-filebytes-convert-to-multipart-form-data-compatible-data/52749)
**Author:** [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\ **Replies:** 2\ **Last updated:** [April 25, 2023, 6:13pm UTC](https://forum.inductiveautomation.com/t/fileupload-filebytes-convert-to-multipart-form-data-compatible-data/52749 "2023-04-25T18:13:09Z")
I’m working on an integration between Ignition and a video platform and part of the process is obviously uploading a video. However, I’m running into a problem uploading the video - the API docs state that the video uplo… --- ## [Accessing notification block message inside scripting section](https://forum.inductiveautomation.com/t/accessing-notification-block-message-inside-scripting-section/72860)
**Author:** [@liam1](https://forum.inductiveautomation.com/u/liam1)\ **Replies:** 1\ **Last updated:** [April 25, 2023, 3:16pm UTC](https://forum.inductiveautomation.com/t/accessing-notification-block-message-inside-scripting-section/72860 "2023-04-25T15:16:18Z")
Hi, Is it possible to access the message property of the notification block inside the calculated roster scripting environment? I want to log the message that is being sent via SMS to a database. --- ## [\[BUG\] Perspective Table selection not updated if selected item is removed](https://forum.inductiveautomation.com/t/bug-perspective-table-selection-not-updated-if-selected-item-is-removed/58969)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [April 25, 2023, 11:47am UTC](https://forum.inductiveautomation.com/t/bug-perspective-table-selection-not-updated-if-selected-item-is-removed/58969 "2023-04-25T11:47:55Z")
v8.1.5 If you have rows in a Table component, select a row, then remove that row from the Table, the row disappears and the row that was below it then replaces its position in the Table with the selected row now highlig… --- ## [Docked view not visible - Perspective Menu Navigation Project from Exchange](https://forum.inductiveautomation.com/t/docked-view-not-visible-perspective-menu-navigation-project-from-exchange/72853)
**Author:** [@ott.andrew33](https://forum.inductiveautomation.com/u/ott.andrew33)\ **Replies:** 2\ **Last updated:** [April 25, 2023, 11:12am UTC](https://forum.inductiveautomation.com/t/docked-view-not-visible-perspective-menu-navigation-project-from-exchange/72853 "2023-04-25T11:12:51Z")
Not sure if anyone else has run into this issue with the docked menu tree not being visible. I have the latest Ignition Edge version (8.1.26) and imported the Perspective Menu Navigation Project from Exchange. Below is … --- ## [Alarm on redundancy when Master down](https://forum.inductiveautomation.com/t/alarm-on-redundancy-when-master-down/72856)
**Author:** [@arjunrajas](https://forum.inductiveautomation.com/u/arjunrajas)\ **Replies:** 1\ **Last updated:** [April 25, 2023, 9:31am UTC](https://forum.inductiveautomation.com/t/alarm-on-redundancy-when-master-down/72856 "2023-04-25T09:31:36Z")
Hi i am trying to trigger an alarm when the master or backup gateway is down from which tag can i trigger it --- ## [\[FEATURE\] Context menu option to add all columns from data into Table props.columns](https://forum.inductiveautomation.com/t/feature-context-menu-option-to-add-all-columns-from-data-into-table-props-columns/72800)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [April 25, 2023, 8:30am UTC](https://forum.inductiveautomation.com/t/feature-context-menu-option-to-add-all-columns-from-data-into-table-props-columns/72800 "2023-04-25T08:30:26Z")
Often I will want to add all or most columns from a Table's data into the props.columns array and configure them, however every time I have to add them manually. It would be nice if there was a context option (similar to… --- ## [DateTimeInput has a delay from value to formatedData](https://forum.inductiveautomation.com/t/datetimeinput-has-a-delay-from-value-to-formateddata/44179)
**Author:** [@artur-oliveira](https://forum.inductiveautomation.com/u/artur-oliveira)\ **Replies:** 1\ **Last updated:** [April 25, 2023, 6:29am UTC](https://forum.inductiveautomation.com/t/datetimeinput-has-a-delay-from-value-to-formateddata/44179 "2023-04-25T06:29:34Z")
Hi everybody. I’m on Ignition Platform 8.1.2 and having problem with DateTime It’s seems to have a delay from the Value and the FormattedValue as image I’m GMT-3 timezone Does anyone know how to solve this? Thank… --- ## [Special Non-English Character Issue in downloaded csv files using system.perspective.download](https://forum.inductiveautomation.com/t/special-non-english-character-issue-in-downloaded-csv-files-using-system-perspective-download/58580)
**Author:** [@Shouvik\_Roy](https://forum.inductiveautomation.com/u/Shouvik_Roy)\ **Replies:** 7\ **Last updated:** [April 25, 2023, 3:33am UTC](https://forum.inductiveautomation.com/t/special-non-english-character-issue-in-downloaded-csv-files-using-system-perspective-download/58580 "2023-04-25T03:33:22Z")
Hello Team, we are facing some issue when opening downloaded csv files (data read from SQL DB) using system.perspective.download that contain Non-English special characters. The characters are not correctly denoted aft… --- ## [Can/How do I sum column rows into a label?](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 4\ **Last updated:** [April 24, 2023, 9:15pm UTC](https://forum.inductiveautomation.com/t/can-how-do-i-sum-column-rows-into-a-label/72849 "2023-04-24T21:15:02Z")
Good afternoon all! Can I sum the "Cost\_In\_Dollars" column into a single label? Here is my table Here is my named Query: SELECT t\_stamp, \[271\_Valve\_ON\_Time\_minutes\], (\[271\_Valve\_ON\_Time\_minutes\]\* 0.02) AS Cos… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=661) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=663)