# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=552 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 553 --- ## [Converting a report to excel sheet](https://forum.inductiveautomation.com/t/converting-a-report-to-excel-sheet/80679)
**Author:** [@Bharat\_Krishnan](https://forum.inductiveautomation.com/u/Bharat_Krishnan)\ **Replies:** 2\ **Last updated:** [October 19, 2023, 11:12pm UTC](https://forum.inductiveautomation.com/t/converting-a-report-to-excel-sheet/80679 "2023-10-19T23:12:56Z")
I have been trying to download a report as excel file for which i have set up the following view given below and a button called "Save as XLS" is used. I am retrieving the data for the report using a single named query .… --- ## [Perspective Key Event Regex New Line](https://forum.inductiveautomation.com/t/perspective-key-event-regex-new-line/51553)
**Author:** [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\ **Replies:** 12\ **Last updated:** [October 19, 2023, 10:29pm UTC](https://forum.inductiveautomation.com/t/perspective-key-event-regex-new-line/51553 "2023-10-19T22:29:08Z")
Hi, I’m trying to catch an RFID read using the Perspective key events to go straight to the idP login. The RFID badges are an 8 - 10 character hex code followed by a line feed. While I can catch the code, as soon as I … --- ## [Mirror then Upgrade a Gateway Server](https://forum.inductiveautomation.com/t/mirror-then-upgrade-a-gateway-server/80728)
**Author:** [@pfortue](https://forum.inductiveautomation.com/u/pfortue)\ **Replies:** 4\ **Last updated:** [October 19, 2023, 10:26pm UTC](https://forum.inductiveautomation.com/t/mirror-then-upgrade-a-gateway-server/80728 "2023-10-19T22:26:43Z")
Hello! I need some help as I haven't done this before. So there's this case that I was handed; here are the general details: Ignition 7.9.21 is currently running on an old PC. The field is reliant on it; ideally it do… --- ## [How do I prevent multiple pages with the same URL?](https://forum.inductiveautomation.com/t/how-do-i-prevent-multiple-pages-with-the-same-url/80560)
**Author:** [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\ **Replies:** 13\ **Last updated:** [October 19, 2023, 10:21pm UTC](https://forum.inductiveautomation.com/t/how-do-i-prevent-multiple-pages-with-the-same-url/80560 "2023-10-19T22:21:50Z")
The title says it all :slight\_smile: I don't see anything in the Session props that would indicate how many pages, or which ones are open in a browser. Is this even possible? Perhaps by storing the Page ID in a custom… --- ## [Tool finder question on perspective](https://forum.inductiveautomation.com/t/tool-finder-question-on-perspective/80726)
**Author:** [@Abdul\_Wahab\_Qureshi](https://forum.inductiveautomation.com/u/Abdul_Wahab_Qureshi)\ **Replies:** 3\ **Last updated:** [October 19, 2023, 9:35pm UTC](https://forum.inductiveautomation.com/t/tool-finder-question-on-perspective/80726 "2023-10-19T21:35:26Z")
I am trying to make a webpage on perspective to locate different tools. Its supposed to have a enter text component and a search button. The text is where you type in the tool number and then press the search button. My … --- ## [Disabled Tag in Expression Causes Error](https://forum.inductiveautomation.com/t/disabled-tag-in-expression-causes-error/80704)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 11\ **Last updated:** [October 19, 2023, 9:26pm UTC](https://forum.inductiveautomation.com/t/disabled-tag-in-expression-causes-error/80704 "2023-10-19T21:26:42Z")
I have a tag used in an expression inside a UDT. Sometimes the tag isn't needed, so it's disabled. Of course, now the expression throws an error because the first argument is null. Shouldn't the disabled tag be ignored (… --- ## [Dynamic Sizing of Component in Coordinate Container View](https://forum.inductiveautomation.com/t/dynamic-sizing-of-component-in-coordinate-container-view/80604)
**Author:** [@Umar\_Khalil](https://forum.inductiveautomation.com/u/Umar_Khalil)\ **Replies:** 6\ **Last updated:** [October 19, 2023, 9:24pm UTC](https://forum.inductiveautomation.com/t/dynamic-sizing-of-component-in-coordinate-container-view/80604 "2023-10-19T21:24:29Z")
Hi, I have a view with a root coordinate container. The view is used as a popup and has many components that are fixed on the page, one of which is a text box area. I would like to resize the view and have only the descr… --- ## [Perspective - Issue with content expanding beyond page with no scroll bars](https://forum.inductiveautomation.com/t/perspective-issue-with-content-expanding-beyond-page-with-no-scroll-bars/80715)
**Author:** [@C.Lewis](https://forum.inductiveautomation.com/u/C.Lewis)\ **Replies:** 6\ **Last updated:** [October 19, 2023, 8:07pm UTC](https://forum.inductiveautomation.com/t/perspective-issue-with-content-expanding-beyond-page-with-no-scroll-bars/80715 "2023-10-19T20:07:42Z")
Hi All, Was hoping someone could lend some help in regards to an issue I am having with Perspective. I have tabs that displays various data for my project. This data is grouped and can be expanded when clicked on. My is… --- ## [Transaction Group -\> DB to Memory Tags](https://forum.inductiveautomation.com/t/transaction-group-db-to-memory-tags/80721)
**Author:** [@tim.schultz](https://forum.inductiveautomation.com/u/tim.schultz)\ **Replies:** 0\ **Last updated:** [October 19, 2023, 8:01pm UTC](https://forum.inductiveautomation.com/t/transaction-group-db-to-memory-tags/80721 "2023-10-19T20:01:04Z")
One of my plant is entering process quality records into a database. The records are not necessarily put in to the DB in a timely manner, but there is a representative timestamp column; the table columns end up as Lane,… --- ## [Table - Limit Selectable Cells](https://forum.inductiveautomation.com/t/table-limit-selectable-cells/80718)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 3\ **Last updated:** [October 19, 2023, 7:57pm UTC](https://forum.inductiveautomation.com/t/table-limit-selectable-cells/80718 "2023-10-19T19:57:26Z")
Wondering if there's a way to limit what column of cells is selectable. I can disable selection for the entire table via the Enabled prop, but wondering if I could do this for an entire column? --- ## [Alarm Analysis Queries](https://forum.inductiveautomation.com/t/alarm-analysis-queries/80657)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 1\ **Last updated:** [October 18, 2023, 6:51pm UTC](https://forum.inductiveautomation.com/t/alarm-analysis-queries/80657 "2023-10-18T18:51:13Z")
I have some queries that used to be from the vision demo project (maybe they still are being used) Alarms by count With TopItems AS ( SELECT displaypath , COUNT(\*) cnt , ROW\_Number() OVER (ORDER BY count(id) DESC) … --- ## [Sorting through a dataset](https://forum.inductiveautomation.com/t/sorting-through-a-dataset/80709)
**Author:** [@hw79](https://forum.inductiveautomation.com/u/hw79)\ **Replies:** 2\ **Last updated:** [October 19, 2023, 4:50pm UTC](https://forum.inductiveautomation.com/t/sorting-through-a-dataset/80709 "2023-10-19T16:50:12Z")
I have a dataset set to a custom param that I want to go through and remove rows where the IsValid column is true. I think I can do this through a script transform def transform(self, value, quality, timestamp): value… --- ## [Sorting with lambda](https://forum.inductiveautomation.com/t/sorting-with-lambda/80692)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 15\ **Last updated:** [October 19, 2023, 4:38pm UTC](https://forum.inductiveautomation.com/t/sorting-with-lambda/80692 "2023-10-19T16:38:13Z")
Hello all, I'm struggling to figure out this simple problem after lots of research. I am attempting to sort a PyDataSet by ApprenticeGroup 0, then ApprenticeGroup descending, then hours descending, then seniority ascend… --- ## [View global scripts, queries, and Perspective/Vision open simultaneously?](https://forum.inductiveautomation.com/t/view-global-scripts-queries-and-perspective-vision-open-simultaneously/80708)
**Author:** [@j.israelsen](https://forum.inductiveautomation.com/u/j.israelsen)\ **Replies:** 1\ **Last updated:** [October 19, 2023, 4:23pm UTC](https://forum.inductiveautomation.com/t/view-global-scripts-queries-and-perspective-vision-open-simultaneously/80708 "2023-10-19T16:23:12Z")
Is there a way to simultaneously view global scripts or named queries and perspective/vision windows at the same time? Example of a current situation: I may be working on a named query or a global script that is used on… --- ## [Report Schedule if enabled from plc tag](https://forum.inductiveautomation.com/t/report-schedule-if-enabled-from-plc-tag/80612)
**Author:** [@Gregory\_Heinrichs](https://forum.inductiveautomation.com/u/Gregory_Heinrichs)\ **Replies:** 9\ **Last updated:** [October 19, 2023, 3:36pm UTC](https://forum.inductiveautomation.com/t/report-schedule-if-enabled-from-plc-tag/80612 "2023-10-19T15:36:42Z")
I have reports that run at the end of each shift. I would like to only generate the report if the machine was actually run that shift. I have a tag set up in the plc to enable the report. Can someone point me in the corr… --- ## [One tag listed twice in a tx group to trigger an hour meter and a counter](https://forum.inductiveautomation.com/t/one-tag-listed-twice-in-a-tx-group-to-trigger-an-hour-meter-and-a-counter/80703)
**Author:** [@MC2338](https://forum.inductiveautomation.com/u/MC2338)\ **Replies:** 0\ **Last updated:** [October 19, 2023, 3:40pm UTC](https://forum.inductiveautomation.com/t/one-tag-listed-twice-in-a-tx-group-to-trigger-an-hour-meter-and-a-counter/80703 "2023-10-19T15:40:32Z")
I have a single boolean tag I'm reading from a plc. I setup a transaction group with 4 basic opc/group items: the boolean tag listed twice, one tag to store the value for the hour meter, one tag to store value for the co… --- ## [Running Vision Client via Bash script](https://forum.inductiveautomation.com/t/running-vision-client-via-bash-script/80701)
**Author:** [@David\_Jimenez\_Ruiz](https://forum.inductiveautomation.com/u/David_Jimenez_Ruiz)\ **Replies:** 0\ **Last updated:** [October 19, 2023, 3:31pm UTC](https://forum.inductiveautomation.com/t/running-vision-client-via-bash-script/80701 "2023-10-19T15:31:23Z")
Hi there, I am trying to use Gitlab to execute a runner that calls a script stored on another machine (running Ignition Edge). I am trying to synchronize two Gateways (Ignition and Ignition Edge). The Synchro is working… --- ## [Trying to use a live scale reading to turn on a Timer so it only runs during production](https://forum.inductiveautomation.com/t/trying-to-use-a-live-scale-reading-to-turn-on-a-timer-so-it-only-runs-during-production/80700)
**Author:** [@Matthew\_McBride](https://forum.inductiveautomation.com/u/Matthew_McBride)\ **Replies:** 0\ **Last updated:** [October 19, 2023, 3:20pm UTC](https://forum.inductiveautomation.com/t/trying-to-use-a-live-scale-reading-to-turn-on-a-timer-so-it-only-runs-during-production/80700 "2023-10-19T15:20:12Z")
Trying to use a live scale reading to verify we are running production. When the scale reading is increasing we are running production and a timer will be turned on. Not sure how to program this looking at previous val… --- ## [Tag Browser CTRL+Click](https://forum.inductiveautomation.com/t/tag-browser-ctrl-click/80697)
**Author:** [@Jack\_Spencer](https://forum.inductiveautomation.com/u/Jack_Spencer)\ **Replies:** 0\ **Last updated:** [October 19, 2023, 2:54pm UTC](https://forum.inductiveautomation.com/t/tag-browser-ctrl-click/80697 "2023-10-19T14:54:25Z")
When selecting multiple tags in the Tag Browser by CTRL-clicking, the view is always shifted so the most recently selected tag/folder is at the top or bottom of the view. I find this incredibly annoying. It always shift… --- ## [No values in the tag](https://forum.inductiveautomation.com/t/no-values-in-the-tag/80684)
**Author:** [@Ayhan\_Yildirim](https://forum.inductiveautomation.com/u/Ayhan_Yildirim)\ **Replies:** 3\ **Last updated:** [October 19, 2023, 2:49pm UTC](https://forum.inductiveautomation.com/t/no-values-in-the-tag/80684 "2023-10-19T14:49:47Z")
I have connected a machine controller via OPC-UA! The connection shows connected! I drag OPC UA tag at tag creature! I see the names of all tag what is in the OPC\_UA! But I don't see any value! Does anyone have idea wh… --- ## [SAML 2 Direct Mapped User Attributes](https://forum.inductiveautomation.com/t/saml-2-direct-mapped-user-attributes/50575)
**Author:** [@AliE](https://forum.inductiveautomation.com/u/AliE)\ **Replies:** 2\ **Last updated:** [October 19, 2023, 2:40pm UTC](https://forum.inductiveautomation.com/t/saml-2-direct-mapped-user-attributes/50575 "2023-10-19T14:40:41Z")
Hi, What is the path syntax for direct mapping SAML 2 user attributes in Ignition? I do not see an example in the user manual found at https://docs.inductiveautomation.com/display/DOC81/User+Attribute+Mapping How wou… --- ## [Tooltip date type .format ,How to use](https://forum.inductiveautomation.com/t/tooltip-date-type-format-how-to-use/80530)
**Author:** [@samer\_samy](https://forum.inductiveautomation.com/u/samer_samy)\ **Replies:** 4\ **Last updated:** [October 19, 2023, 2:20pm UTC](https://forum.inductiveautomation.com/t/tooltip-date-type-format-how-to-use/80530 "2023-10-19T14:20:21Z")
Dears, I am not able to show the x-axis value in tooltip of my trend as required. I put the tooltip as you see : {name}:{dateX.formatdate("yyyy-MM-dd HH:mm:ss")} \[Bold\]{valueY.formatNumber("#,###.0")}\[/\] Cases The x … --- ## [Gateway restoration failed, gateway will no longer load](https://forum.inductiveautomation.com/t/gateway-restoration-failed-gateway-will-no-longer-load/80691)
**Author:** [@Robert\_Collinson](https://forum.inductiveautomation.com/u/Robert_Collinson)\ **Replies:** 12\ **Last updated:** [October 19, 2023, 1:55pm UTC](https://forum.inductiveautomation.com/t/gateway-restoration-failed-gateway-will-no-longer-load/80691 "2023-10-19T13:55:02Z")
HI all, So, I took a backup of my laptops local gateway which was running a project I was using to experiment with the Ignition software with the intention of deploying another configuration over the top such that i cou… --- ## [Weintek cMT2078x Modbus Addressing Help](https://forum.inductiveautomation.com/t/weintek-cmt2078x-modbus-addressing-help/80649)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 11\ **Last updated:** [October 18, 2023, 8:31pm UTC](https://forum.inductiveautomation.com/t/weintek-cmt2078x-modbus-addressing-help/80649 "2023-10-18T20:31:00Z")
I've got a new machine in the plant that I'm trying to get Modbus TCP setup on. The OEM sent me some information on the setup, for example READ 100 RECORDS STARTING FROM 400 ReadValues = modbusClient.ReadInputRegisters… --- ## [Error Query SQL multiple select](https://forum.inductiveautomation.com/t/error-query-sql-multiple-select/80669)
**Author:** [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\ **Replies:** 2\ **Last updated:** [October 19, 2023, 9:37am UTC](https://forum.inductiveautomation.com/t/error-query-sql-multiple-select/80669 "2023-10-19T09:37:54Z")
Hello everyone I have a problem with the following query SELECT (SELECT Dato FROM Dato\_Medidor WHERE Linea = 'ELFO\_006\_Oficinas') as 'ELFO\_006', (SELECT Dato FROM Dato\_Medidor WHERE Linea = 'ELFO\_007\_Oficinas') as 'ELF… --- ## [Tab container disabling property for individual tab](https://forum.inductiveautomation.com/t/tab-container-disabling-property-for-individual-tab/80682)
**Author:** [@Archana\_Chandran](https://forum.inductiveautomation.com/u/Archana_Chandran)\ **Replies:** 6\ **Last updated:** [October 19, 2023, 9:26am UTC](https://forum.inductiveautomation.com/t/tab-container-disabling-property-for-individual-tab/80682 "2023-10-19T09:26:13Z")
I am using ignition version 8.1.18. In that version Tab contaioner has no disable property to disable individual tabs. But i cannot upgrade the version.Is there any way to do the disabling feature through scripting? --- ## [Ignition Backup Gateway, Out Of Date Sync issue](https://forum.inductiveautomation.com/t/ignition-backup-gateway-out-of-date-sync-issue/78846)
**Author:** [@Jobin\_Samuel](https://forum.inductiveautomation.com/u/Jobin_Samuel)\ **Replies:** 15\ **Last updated:** [October 19, 2023, 3:57am UTC](https://forum.inductiveautomation.com/t/ignition-backup-gateway-out-of-date-sync-issue/78846 "2023-10-19T03:57:56Z")
Hi There, The Ignition version we are using is V 8.1.14 Master Sync status : Good Backup Sync status : Out Of Date Force Re-Sync both from Master and Backup gateway, no change move the config.idb file and restarted … --- ## [\[FEATURE\] Enhance the "Browse Device" tag staging dialogue for manipulating the tag tree as well](https://forum.inductiveautomation.com/t/feature-enhance-the-browse-device-tag-staging-dialogue-for-manipulating-the-tag-tree-as-well/80675)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [October 18, 2023, 11:34pm UTC](https://forum.inductiveautomation.com/t/feature-enhance-the-browse-device-tag-staging-dialogue-for-manipulating-the-tag-tree-as-well/80675 "2023-10-18T23:34:45Z")
I really like the tag staging dialogue available when you select "Browse Devices" from the tag browser + menu: However, this would be super nice to be able to also use to stage manipulations/additions/deletions of ta… --- ## [Rockwell Alarm Server](https://forum.inductiveautomation.com/t/rockwell-alarm-server/80671)
**Author:** [@Roman\_Rozenshteyn](https://forum.inductiveautomation.com/u/Roman_Rozenshteyn)\ **Replies:** 3\ **Last updated:** [October 18, 2023, 11:05pm UTC](https://forum.inductiveautomation.com/t/rockwell-alarm-server/80671 "2023-10-18T23:05:51Z")
Anyone know if there are future plans to support Rocwell PLC Alarm Servers? --- ## [Adding columns to default Ignition Audit log table](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571)
**Author:** [@rajesh.dayala](https://forum.inductiveautomation.com/u/rajesh.dayala)\ **Replies:** 3\ **Last updated:** [October 18, 2023, 10:28pm UTC](https://forum.inductiveautomation.com/t/adding-columns-to-default-ignition-audit-log-table/53571 "2023-10-18T22:28:23Z")
Hi All, We have a requirement that when a tag value is changed from perspective client, For example a setpoint change of a tag. We need to see the log as XXXtag value changed from XX to XXX with some reason added to it.… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=551) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=553)