# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=648 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 649 --- ## [Ignition connection to Siemens Teamcenter PLM](https://forum.inductiveautomation.com/t/ignition-connection-to-siemens-teamcenter-plm/73964)
**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\ **Replies:** 2\ **Last updated:** [May 20, 2023, 10:54am UTC](https://forum.inductiveautomation.com/t/ignition-connection-to-siemens-teamcenter-plm/73964 "2023-05-20T10:54:26Z")
We have various documents in Siemens Teamcenter PLM system. I was wondering if there is a way to connect Ignition to Siemens Teamcenter PLM? --- ## [Ignition Perspective XY Chart](https://forum.inductiveautomation.com/t/ignition-perspective-xy-chart/73963)
**Author:** [@PRASHANTH\_KAKKIRALA](https://forum.inductiveautomation.com/u/PRASHANTH_KAKKIRALA)\ **Replies:** 2\ **Last updated:** [May 20, 2023, 7:21am UTC](https://forum.inductiveautomation.com/t/ignition-perspective-xy-chart/73963 "2023-05-20T07:21:13Z")
How can I make an update/poll request to a named query that is binded to an XY chart from the script ? ex: I've a parameter that keeps changing and based on this I wanted to update my chart data automatically and instan… --- ## [Update public holiday from website onto ignition dataset](https://forum.inductiveautomation.com/t/update-public-holiday-from-website-onto-ignition-dataset/73978)
**Author:** [@Callmesoon](https://forum.inductiveautomation.com/u/Callmesoon)\ **Replies:** 1\ **Last updated:** [May 20, 2023, 5:14am UTC](https://forum.inductiveautomation.com/t/update-public-holiday-from-website-onto-ignition-dataset/73978 "2023-05-20T05:14:30Z")
Hi guys, may I know how can i update public holiday dates from website onto ignition dateset to be presented in table? --- ## [Log all queries against a given database table](https://forum.inductiveautomation.com/t/log-all-queries-against-a-given-database-table/73975)
**Author:** [@reed.hoffmaster](https://forum.inductiveautomation.com/u/reed.hoffmaster)\ **Replies:** 1\ **Last updated:** [May 19, 2023, 9:34pm UTC](https://forum.inductiveautomation.com/t/log-all-queries-against-a-given-database-table/73975 "2023-05-19T21:34:19Z")
How can I set up logging for all queries run against a given database object/table? Or, how do I see a longer list of queries being run than what is shown on the status page of the gateway? I have a db table that is writ… --- ## [Absolute addressing for array in siemens PLC S7-1500](https://forum.inductiveautomation.com/t/absolute-addressing-for-array-in-siemens-plc-s7-1500/73969)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 3\ **Last updated:** [May 19, 2023, 7:37pm UTC](https://forum.inductiveautomation.com/t/absolute-addressing-for-array-in-siemens-plc-s7-1500/73969 "2023-05-19T19:37:29Z")
I have this array that I would like to access, can I get some help on the format? I know it would start like: \[Doffer M18 North\]DB77,(not sure here)2.0 --- ## [Can't connect to s7-300](https://forum.inductiveautomation.com/t/cant-connect-to-s7-300/73865)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 3\ **Last updated:** [May 19, 2023, 7:24pm UTC](https://forum.inductiveautomation.com/t/cant-connect-to-s7-300/73865 "2023-05-19T19:24:11Z")
hello, I'm having problems connecting a PLC, it is a siemens s7-300. I have to connect 3 PLCs, I have been able to connect one without problems, the other two do not work. the three plc are in the same network. and the… --- ## [Importing a .proj file into my current project](https://forum.inductiveautomation.com/t/importing-a-proj-file-into-my-current-project/73958)
**Author:** [@Brittany\_Villasenor](https://forum.inductiveautomation.com/u/Brittany_Villasenor)\ **Replies:** 2\ **Last updated:** [May 19, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/importing-a-proj-file-into-my-current-project/73958 "2023-05-19T16:18:42Z")
I have a coworker who made a component layout they would like me to use in my current Ignition project. Will it mess anything up if I import the .proj file he sent me into my current project? Or would I need to re-create… --- ## [IA Webinar on Ignition+Docker (April 2023) Q&A](https://forum.inductiveautomation.com/t/ia-webinar-on-ignition-docker-april-2023-q-a/73672)
**Author:** [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Replies:** 7\ **Last updated:** [May 19, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/ia-webinar-on-ignition-docker-april-2023-q-a/73672 "2023-05-19T16:10:45Z")
Greetings all! We recently did a webinar where myself, @joe, and @kgamble discussed and demoed some ways to leverage Ignition and containers for faster development. I'm posting here to present those questions and our a… --- ## [Alarm Horn Not Sounding Upon Alarm Initialization, Help Required](https://forum.inductiveautomation.com/t/alarm-horn-not-sounding-upon-alarm-initialization-help-required/73920)
**Author:** [@Mason\_Stevens](https://forum.inductiveautomation.com/u/Mason_Stevens)\ **Replies:** 13\ **Last updated:** [May 19, 2023, 4:08pm UTC](https://forum.inductiveautomation.com/t/alarm-horn-not-sounding-upon-alarm-initialization-help-required/73920 "2023-05-19T16:08:09Z")
Currently my alarm pipeline is configured to pick up an alarm and call the function below regardless of priority: system.tag.write("\_Misc/Alarm\_CR\_HORN", 1) this is as simple as I can make the system, but somehow the h… --- ## [Historian t\_stamp format](https://forum.inductiveautomation.com/t/historian-t-stamp-format/73954)
**Author:** [@Austin\_Jasmer](https://forum.inductiveautomation.com/u/Austin_Jasmer)\ **Replies:** 5\ **Last updated:** [May 19, 2023, 3:22pm UTC](https://forum.inductiveautomation.com/t/historian-t-stamp-format/73954 "2023-05-19T15:22:26Z")
I was wondering how to change the t\_stamp data to be in a datetime format? It is currently only a long number which is difficult to use. --- ## [Editing Cells in Table -- Script Changing Multiple Table Values](https://forum.inductiveautomation.com/t/editing-cells-in-table-script-changing-multiple-table-values/73944)
**Author:** [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Replies:** 4\ **Last updated:** [May 19, 2023, 2:41pm UTC](https://forum.inductiveautomation.com/t/editing-cells-in-table-script-changing-multiple-table-values/73944 "2023-05-19T14:41:01Z")
So, this is going to be a long one and a bit hard to explain. I have made my tables return as JSON so I can edit the cells inside of the table. I have three columns that can be edited in each table within 4 tables. One i… --- ## [Perspective Map Component Tooltip Auto-Appear Issue](https://forum.inductiveautomation.com/t/perspective-map-component-tooltip-auto-appear-issue/38959)
**Author:** [@bzink1](https://forum.inductiveautomation.com/u/bzink1)\ **Replies:** 1\ **Last updated:** [May 19, 2023, 1:27pm UTC](https://forum.inductiveautomation.com/t/perspective-map-component-tooltip-auto-appear-issue/38959 "2023-05-19T13:27:34Z")
Hey all, I have an issue with the map component tooltip auto appearing and messing with the pan functionality. When generating the markers via a script that runs on a timer, they appear as expected. The script takes in… --- ## [Query binding not refreshing with the refreshBinding command](https://forum.inductiveautomation.com/t/query-binding-not-refreshing-with-the-refreshbinding-command/73917)
**Author:** [@Charles\_Belanger](https://forum.inductiveautomation.com/u/Charles_Belanger)\ **Replies:** 4\ **Last updated:** [May 19, 2023, 12:57pm UTC](https://forum.inductiveautomation.com/t/query-binding-not-refreshing-with-the-refreshbinding-command/73917 "2023-05-19T12:57:46Z")
Hi, I have text boxes that update based on a query. The user can add a comment in a text input box, which then gets put into a database and read back by a named query. The problem is that the query binding doesn't upda… --- ## [Java heap space OutOfMemoryError](https://forum.inductiveautomation.com/t/java-heap-space-outofmemoryerror/73901)
**Author:** [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Replies:** 8\ **Last updated:** [May 19, 2023, 12:37pm UTC](https://forum.inductiveautomation.com/t/java-heap-space-outofmemoryerror/73901 "2023-05-19T12:37:49Z")
Trying to run a staging on 7.9.12 (I know, I know, we have our other server currently going through 8.1.25 sandbox testing). On Windows server 2019. I am trying to launch a staging client to test some edits, both on th… --- ## [Perspective audit log query to database](https://forum.inductiveautomation.com/t/perspective-audit-log-query-to-database/73900)
**Author:** [@Ladrone](https://forum.inductiveautomation.com/u/Ladrone)\ **Replies:** 4\ **Last updated:** [May 19, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/perspective-audit-log-query-to-database/73900 "2023-05-19T12:35:47Z")
In perspective at the moment there isn't the possibility to log in the audit the query launched aginst a database. I've used all named query in my project: in your opinion what is the best approach to log them in the au… --- ## [Perspective Pie Chart questions](https://forum.inductiveautomation.com/t/perspective-pie-chart-questions/73934)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 1\ **Last updated:** [May 19, 2023, 8:16am UTC](https://forum.inductiveautomation.com/t/perspective-pie-chart-questions/73934 "2023-05-19T08:16:24Z")
Hi To make the border visible even if the value is zero in the pie chart ? --- ## [How to set transparent background for the Table component?](https://forum.inductiveautomation.com/t/how-to-set-transparent-background-for-the-table-component/73836)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 5\ **Last updated:** [May 19, 2023, 6:55am UTC](https://forum.inductiveautomation.com/t/how-to-set-transparent-background-for-the-table-component/73836 "2023-05-19T06:55:03Z")
Hello, is it possible to set transparent backgrounds for the Table component from the perspective? I can't set it in any ways. I would like the background of the table to come from the compnent underneath - blue color … --- ## [\[BUG-7731\] Power Chart Pen Edit Overwrites the Wrong Pen](https://forum.inductiveautomation.com/t/bug-7731-power-chart-pen-edit-overwrites-the-wrong-pen/73621)
**Author:** [@nick.gehringer](https://forum.inductiveautomation.com/u/nick.gehringer)\ **Replies:** 0\ **Last updated:** [May 11, 2023, 10:05pm UTC](https://forum.inductiveautomation.com/t/bug-7731-power-chart-pen-edit-overwrites-the-wrong-pen/73621 "2023-05-11T22:05:18Z")
v8.1.26 While the pen edit sidebar is open, if I click on another pen edit in the power chart and then click "Done" on the sidebar, it overwrites all that pen's data. Both pens: Clicking Station 10 "Edit Pen" icon … --- ## [Managing Time Zones & Time Stamps in Reports](https://forum.inductiveautomation.com/t/managing-time-zones-time-stamps-in-reports/71281)
**Author:** [@matsons](https://forum.inductiveautomation.com/u/matsons)\ **Replies:** 8\ **Last updated:** [May 18, 2023, 8:19pm UTC](https://forum.inductiveautomation.com/t/managing-time-zones-time-stamps-in-reports/71281 "2023-05-18T20:19:31Z")
We have a hub-and-spoke architecture with a central hub where reporting runs. All data resides at each operating location, often in different time zones. We are having challenges with building reports that display the … --- ## [Case statement help](https://forum.inductiveautomation.com/t/case-statement-help/73919)
**Author:** [@mjohnson0238](https://forum.inductiveautomation.com/u/mjohnson0238)\ **Replies:** 7\ **Last updated:** [May 18, 2023, 7:08pm UTC](https://forum.inductiveautomation.com/t/case-statement-help/73919 "2023-05-18T19:08:32Z")
I have this case statement: case({view.params.Line} && {view.params.Pos}, 11 && 1, 111, 11 && 2, 112, 11 && 3, 121, 11 && 4, 122, 11 && 5, 131, 11 && 6, 132, 11 && 7, 141, 11 && 8, 142, 999) It always returns a 111. Is… --- ## [Popup event to run script](https://forum.inductiveautomation.com/t/popup-event-to-run-script/73915)
**Author:** [@Siebold](https://forum.inductiveautomation.com/u/Siebold)\ **Replies:** 2\ **Last updated:** [May 18, 2023, 6:09pm UTC](https://forum.inductiveautomation.com/t/popup-event-to-run-script/73915 "2023-05-18T18:09:56Z")
I am trying to have a script trigger when a popup appears that calls a namedquery and filles in some text boxes with the results. I can't find an event that fires everytime the popup is opened up. Any ideas? --- ## [Can i force perspective to use horizontal layout?](https://forum.inductiveautomation.com/t/can-i-force-perspective-to-use-horizontal-layout/73850)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 10\ **Last updated:** [May 18, 2023, 5:46pm UTC](https://forum.inductiveautomation.com/t/can-i-force-perspective-to-use-horizontal-layout/73850 "2023-05-18T17:46:11Z")
hi All I am learning perspective and wonder if there is a way for perspective to force horizontal view in the tablet (without modification of the tablet settings)? My horizontal view looks a lot better than vertical so … --- ## [Dynamic Roster Schedule](https://forum.inductiveautomation.com/t/dynamic-roster-schedule/73907)
**Author:** [@tj.holt](https://forum.inductiveautomation.com/u/tj.holt)\ **Replies:** 2\ **Last updated:** [May 18, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/dynamic-roster-schedule/73907 "2023-05-18T17:18:49Z")
I have operators who work in 1 week shifts. Operator 1 starts Monday-Sunday Week 1, then Operator 2 Week 2 Monday. However, if a holiday falls on a Monday Operator 1's schedule becomes Week 1 Monday - Week 2 Monday and O… --- ## [Central gateway logs missing](https://forum.inductiveautomation.com/t/central-gateway-logs-missing/73873)
**Author:** [@Shawn\_Rieger](https://forum.inductiveautomation.com/u/Shawn_Rieger)\ **Replies:** 3\ **Last updated:** [May 18, 2023, 4:25pm UTC](https://forum.inductiveautomation.com/t/central-gateway-logs-missing/73873 "2023-05-18T16:25:40Z")
A few days after upgrading our central gateway from 8.1.18 to 8.1.26, our gateway log seemed to get truncated, and there were no entries past 5/5. I tossed it up with the upgrade, although it was a few days after. Now I'… --- ## [Using a spinner to activate multiple boolean tags](https://forum.inductiveautomation.com/t/using-a-spinner-to-activate-multiple-boolean-tags/73909)
**Author:** [@Sebastian\_Medrano](https://forum.inductiveautomation.com/u/Sebastian_Medrano)\ **Replies:** 4\ **Last updated:** [May 18, 2023, 4:23pm UTC](https://forum.inductiveautomation.com/t/using-a-spinner-to-activate-multiple-boolean-tags/73909 "2023-05-18T16:23:26Z")
Soy nuevo en ignition estoy tratando que un spinner active un tag boolean cuando el dato sea uno y cuando el dato sea dos se active otro tag boolean y asi sucesivamente, es buena solucion para un buscador, me podrian ayu… --- ## [IBM AS400 Database connection](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 29\ **Last updated:** [May 18, 2023, 4:14pm UTC](https://forum.inductiveautomation.com/t/ibm-as400-database-connection/1619 "2023-05-18T16:14:17Z")
Can someone point me to a document to setup ignition to read data from a AS400 database. Which JDBC driver and how to install in Ubuntu? --- ## [Row color change in power table](https://forum.inductiveautomation.com/t/row-color-change-in-power-table/73902)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 1\ **Last updated:** [May 18, 2023, 2:52pm UTC](https://forum.inductiveautomation.com/t/row-color-change-in-power-table/73902 "2023-05-18T14:52:07Z")
Hi , I am trying to update each row based one column value. my code if colIndex == 0: if "Communication" in value: return {'background': 'red'} else: return {'background': 'yellow'} output i want to … --- ## [Run Button On Click Script When Key is Pressed](https://forum.inductiveautomation.com/t/run-button-on-click-script-when-key-is-pressed/73897)
**Author:** [@msitson](https://forum.inductiveautomation.com/u/msitson)\ **Replies:** 10\ **Last updated:** [May 18, 2023, 2:45pm UTC](https://forum.inductiveautomation.com/t/run-button-on-click-script-when-key-is-pressed/73897 "2023-05-18T14:45:23Z")
Hello, Is it possible to run a button's on click event when the 'Enter' key is pressed? The on click event is a navigation script with one url parameter. I noticed that within Session Events there is a key events sectio… --- ## [Cut off text in buttons](https://forum.inductiveautomation.com/t/cut-off-text-in-buttons/73899)
**Author:** [@david.l](https://forum.inductiveautomation.com/u/david.l)\ **Replies:** 2\ **Last updated:** [May 18, 2023, 2:27pm UTC](https://forum.inductiveautomation.com/t/cut-off-text-in-buttons/73899 "2023-05-18T14:27:13Z")
I have a nuisance item. I tried searching the forum but came up mostly empty or no responses (perhaps wrong search terms) The text is cut off. For example, it is supposed to read "Return Net (int)" . Instead the last pa… --- ## [External Python Libraries](https://forum.inductiveautomation.com/t/external-python-libraries/73889)
**Author:** [@PRASHANTH\_KAKKIRALA](https://forum.inductiveautomation.com/u/PRASHANTH_KAKKIRALA)\ **Replies:** 8\ **Last updated:** [May 18, 2023, 2:16pm UTC](https://forum.inductiveautomation.com/t/external-python-libraries/73889 "2023-05-18T14:16:51Z")
Can Someone tell me if I can use matplotlib.pyplot in Ignition? I saw some posts where it says these modules are built on C and cannot be supported with Ignition. Is this correct? If it's compatible, please share an exa… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=647) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=649)