# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1718 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1719 --- ## [Gateway Tag Change scripts issue](https://forum.inductiveautomation.com/t/gateway-tag-change-scripts-issue/12430)
**Author:** [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Replies:** 6\ **Last updated:** [December 8, 2016, 2:35pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-scripts-issue/12430 "2016-12-08T14:35:58Z")
cardNumber = newValue.value for i in range(1,21): cardMatch = system.tag.read("\[TAS\_D\]TT/TT%d/nCardNo"%(i)).value if cardnumber == cardMatch: bayNo = system.tag.read("\[TAS\_D\]TT/TT%d/Comp1/szBayNo"%(i)).value if b… --- ## [OPC Failover settings](https://forum.inductiveautomation.com/t/opc-failover-settings/12444)
**Author:** [@Sammy5](https://forum.inductiveautomation.com/u/Sammy5)\ **Replies:** 0\ **Last updated:** [December 8, 2016, 1:59pm UTC](https://forum.inductiveautomation.com/t/opc-failover-settings/12444 "2016-12-08T13:59:04Z")
Having issues with backup server settings for v7.9. With 7.8 and before we mere put the IP address to the secondary server. With 7.9 we have several more fields: Backup Discovery URL: Backup Endpoint URL: Failover End… --- ## [Semicolon instead of comma in Table exportToCSV?](https://forum.inductiveautomation.com/t/semicolon-instead-of-comma-in-table-exporttocsv/12438)
**Author:** [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\ **Replies:** 2\ **Last updated:** [December 8, 2016, 1:36pm UTC](https://forum.inductiveautomation.com/t/semicolon-instead-of-comma-in-table-exporttocsv/12438 "2016-12-08T13:36:22Z")
Hi, i am exporting a table to CSV, But i have noticed that using a swedish Excel, all rows ends up in one column, instead of splitting up the data with the comma. In sweden we uses comma (,) to seperate decimals, and sw… --- ## [History data partitioning and MySQL](https://forum.inductiveautomation.com/t/history-data-partitioning-and-mysql/12406)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 1\ **Last updated:** [December 7, 2016, 11:51pm UTC](https://forum.inductiveautomation.com/t/history-data-partitioning-and-mysql/12406 "2016-12-07T23:51:13Z")
We have commissioned one Ignition project in Feb 2015 & has Daily & yearly reports. Recently our customer reported that daily reports are working fine but yearly reports are not working properly. We investigated & found… --- ## [Refresh Browse Script](https://forum.inductiveautomation.com/t/refresh-browse-script/12441)
**Author:** [@erick](https://forum.inductiveautomation.com/u/erick)\ **Replies:** 1\ **Last updated:** [December 7, 2016, 11:30pm UTC](https://forum.inductiveautomation.com/t/refresh-browse-script/12441 "2016-12-07T23:30:08Z")
Purely out of convenience, I am wondering if there is a way to mimic the 'Refresh Browse" for a device on the gateway via a script, say on a button? Because I have automatic browse turned off, when I make PLC changes I… --- ## [Slow response system.tag.write](https://forum.inductiveautomation.com/t/slow-response-system-tag-write/12424)
**Author:** [@giulianacaula](https://forum.inductiveautomation.com/u/giulianacaula)\ **Replies:** 13\ **Last updated:** [December 7, 2016, 9:19pm UTC](https://forum.inductiveautomation.com/t/slow-response-system-tag-write/12424 "2016-12-07T21:19:25Z")
\[color=#FF0000\]This is the thing: -I have created almost 20000 tags that I use in 3 different Siemens PLC. -The network here is new made with optical fiber with a velocity of 1Gbps. The network is tested and I’m sure thi… --- ## [SQL Query for color in Equipment Schedule component](https://forum.inductiveautomation.com/t/sql-query-for-color-in-equipment-schedule-component/12436)
**Author:** [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\ **Replies:** 3\ **Last updated:** [December 7, 2016, 4:39pm UTC](https://forum.inductiveautomation.com/t/sql-query-for-color-in-equipment-schedule-component/12436 "2016-12-07T16:39:01Z")
I would like to use the Equipment Schedule component, and base the data in the Items and Scheduled Events properties off a SQL query. How do I get a color into the Foreground and Background fields of the Items property, … --- ## [Tag Replace Function](https://forum.inductiveautomation.com/t/tag-replace-function/12433)
**Author:** [@conlonj25](https://forum.inductiveautomation.com/u/conlonj25)\ **Replies:** 5\ **Last updated:** [December 7, 2016, 3:40pm UTC](https://forum.inductiveautomation.com/t/tag-replace-function/12433 "2016-12-07T15:40:39Z")
Does Ignition provide an easy way to replace all the tag binding on a single page with new tags? I'm looking for something similar to Intouch's tag replace feature. For example, I make a page for a single pump which co… --- ## [Graphs - how to?](https://forum.inductiveautomation.com/t/graphs-how-to/12409)
**Author:** [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\ **Replies:** 4\ **Last updated:** [December 7, 2016, 3:00pm UTC](https://forum.inductiveautomation.com/t/graphs-how-to/12409 "2016-12-07T15:00:41Z")
Hi, i have this project where we log different measurement values, and the customer would like to see fancy graphs over some options they select on the page. I have tried to tie a SQL-String where it returns a list, an… --- ## [Reporting: table won't appear on multiple pages](https://forum.inductiveautomation.com/t/reporting-table-wont-appear-on-multiple-pages/12429)
**Author:** [@Philcr](https://forum.inductiveautomation.com/u/Philcr)\ **Replies:** 1\ **Last updated:** [December 6, 2016, 1:41pm UTC](https://forum.inductiveautomation.com/t/reporting-table-wont-appear-on-multiple-pages/12429 "2016-12-06T13:41:15Z")
I created a table component with all the grouping and formatting, but when my data exceeds one page, the table is copied horizontally on the same page instead of creating a new page. When I looked at the videos, the r… --- ## [Acnowledge an Disabled Event on Alarm Status Table](https://forum.inductiveautomation.com/t/acnowledge-an-disabled-event-on-alarm-status-table/12427)
**Author:** [@Jonathan\_ASEcuador](https://forum.inductiveautomation.com/u/Jonathan_ASEcuador)\ **Replies:** 0\ **Last updated:** [December 5, 2016, 5:39pm UTC](https://forum.inductiveautomation.com/t/acnowledge-an-disabled-event-on-alarm-status-table/12427 "2016-12-05T17:39:01Z")
I have an Alarm Status Table in which appear a disabled event. When i try to acknowledge that event, it seems like the event never get acknowledged and it appears on the Alarms Status Table forever, how can i solve this … --- ## ["No render context, scripts disabled" in Report Viewer](https://forum.inductiveautomation.com/t/no-render-context-scripts-disabled-in-report-viewer/12426)
**Author:** [@collink](https://forum.inductiveautomation.com/u/collink)\ **Replies:** 1\ **Last updated:** [December 5, 2016, 3:14pm UTC](https://forum.inductiveautomation.com/t/no-render-context-scripts-disabled-in-report-viewer/12426 "2016-12-05T15:14:57Z")
The scripts will not run on any charts when viewing my report in the Report Viewer component. The scripts do run in the designer's preview, and they do also run when the report is emailed using system.report.executeAndDi… --- ## [First Day of the current week on Client startup](https://forum.inductiveautomation.com/t/first-day-of-the-current-week-on-client-startup/12411)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 5\ **Last updated:** [December 4, 2016, 4:06pm UTC](https://forum.inductiveautomation.com/t/first-day-of-the-current-week-on-client-startup/12411 "2016-12-04T16:06:45Z")
I am racking my brains trying to figure out to automatically set a date on a calendar component to the first day of the current week. This is my chart, it displays weekly historical CIP data in a chart starting on a Sund… --- ## [Periodic Database Connection Drops](https://forum.inductiveautomation.com/t/periodic-database-connection-drops/12347)
**Author:** [@dturner](https://forum.inductiveautomation.com/u/dturner)\ **Replies:** 1\ **Last updated:** [December 2, 2016, 2:39pm UTC](https://forum.inductiveautomation.com/t/periodic-database-connection-drops/12347 "2016-12-02T14:39:43Z")
I am trying to troubleshoot periodic drops between the Ignition client and the gateway. The client machine and server are on the same switch. My guess is that it is a socket issue but I do not know how to view the number… --- ## [Mobile client keeps having to be reset](https://forum.inductiveautomation.com/t/mobile-client-keeps-having-to-be-reset/9374)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 12\ **Last updated:** [December 1, 2016, 5:40pm UTC](https://forum.inductiveautomation.com/t/mobile-client-keeps-having-to-be-reset/9374 "2016-12-01T17:40:35Z")
I am seeing this message repeatedly in the console and the mobile client keeps saying "No Session" with a restart button. I have a to keep tapping the restart button around 20-30 times before the mobile client works agai… --- ## [Problem changing any property(or TAG) in an UDT Type](https://forum.inductiveautomation.com/t/problem-changing-any-property-or-tag-in-an-udt-type/12420)
**Author:** [@manel](https://forum.inductiveautomation.com/u/manel)\ **Replies:** 0\ **Last updated:** [December 1, 2016, 4:00pm UTC](https://forum.inductiveautomation.com/t/problem-changing-any-property-or-tag-in-an-udt-type/12420 "2016-12-01T16:00:00Z")
In my application I have one UDT type and about 30 instances of it. UDT type is quite big (about 600 tags). When I change or add any description, alarm, expresion in any tag of my structure, SCADA system breaks. SCADA st… --- ## [Case expression wiith try for default](https://forum.inductiveautomation.com/t/case-expression-wiith-try-for-default/12418)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 2\ **Last updated:** [November 30, 2016, 6:50pm UTC](https://forum.inductiveautomation.com/t/case-expression-wiith-try-for-default/12418 "2016-11-30T18:50:10Z")
Hi guys, I’m sure the subject line kinda explains it. I basically like to use something like the following: case({Hour}, 11,{Hourly\_PP}, 19,{Hourly\_PP}, 3,{Hourly\_PP}, try({Root Container.HourlyCount}\[4,'Hourly'\],0) ) s… --- ## [Possible memory link on 7.9 Gateway?](https://forum.inductiveautomation.com/t/possible-memory-link-on-7-9-gateway/12417)
**Author:** [@dgillis](https://forum.inductiveautomation.com/u/dgillis)\ **Replies:** 1\ **Last updated:** [November 30, 2016, 5:30pm UTC](https://forum.inductiveautomation.com/t/possible-memory-link-on-7-9-gateway/12417 "2016-11-30T17:30:50Z")
Hi there, Had a look around to see if anyone else has posted anything like this and didn't come up with anything. Gateway info: Win7 x64 12GB RAM We are noticing that the gateway is gradually increasing it's me… --- ## [Report table sum of rows (based on page)](https://forum.inductiveautomation.com/t/report-table-sum-of-rows-based-on-page/12416)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 1\ **Last updated:** [November 30, 2016, 3:13pm UTC](https://forum.inductiveautomation.com/t/report-table-sum-of-rows-based-on-page/12416 "2016-11-30T15:13:25Z")
Is there a built in function to display the number of rows in a table that are displayed on each page within the report designer? Something like the count function but for the specific page (1-20 rows of 100 total)? I'd … --- ## [Client crash 7.9.0](https://forum.inductiveautomation.com/t/client-crash-7-9-0/12260)
**Author:** [@gekkoman](https://forum.inductiveautomation.com/u/gekkoman)\ **Replies:** 9\ **Last updated:** [November 30, 2016, 3:04pm UTC](https://forum.inductiveautomation.com/t/client-crash-7-9-0/12260 "2016-11-30T15:04:42Z")
Greetings, Am getting complete hang of client using global templates, including diagnostics. At time of crash code is producing no errors and resource utilisation etc is normal. Diagnostics hangs at same time. The te… --- ## [How would I construct this SQL Address?](https://forum.inductiveautomation.com/t/how-would-i-construct-this-sql-address/12413)
**Author:** [@aqueousdan](https://forum.inductiveautomation.com/u/aqueousdan)\ **Replies:** 13\ **Last updated:** [November 30, 2016, 1:56pm UTC](https://forum.inductiveautomation.com/t/how-would-i-construct-this-sql-address/12413 "2016-11-30T13:56:04Z")
I simply want to see whether this output bit is on or off on my Siemens S7-1200. Can anyone here tell me what to type in to my OPC Item path in the designer please. I have tried \[Siemens\]QX0.0 but i get a small questio… --- ## [Power table auto column width](https://forum.inductiveautomation.com/t/power-table-auto-column-width/12415)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 1\ **Last updated:** [November 29, 2016, 10:20pm UTC](https://forum.inductiveautomation.com/t/power-table-auto-column-width/12415 "2016-11-29T22:20:57Z")
I am designing a lot of screens with tables currently. I also have some dropdown components that are used to filter the table contents. I would quite like the dropdowns to be above the column they are filtering, and be … --- ## [Month view event color](https://forum.inductiveautomation.com/t/month-view-event-color/12412)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 2\ **Last updated:** [November 29, 2016, 6:49pm UTC](https://forum.inductiveautomation.com/t/month-view-event-color/12412 "2016-11-29T18:49:33Z")
I'm searching for a way to make the event color be a highlight (or box around the event text) rather than just the font color (like note 2 in the image). In this case, note 2 is just selected but I want all the events to… --- ## [How to add custom timestamp in Reports?](https://forum.inductiveautomation.com/t/how-to-add-custom-timestamp-in-reports/12379)
**Author:** [@DanielFVS](https://forum.inductiveautomation.com/u/DanielFVS)\ **Replies:** 4\ **Last updated:** [November 28, 2016, 2:49pm UTC](https://forum.inductiveautomation.com/t/how-to-add-custom-timestamp-in-reports/12379 "2016-11-28T14:49:26Z")
Hello, I am trying to do a Daily Report of many realtime values, my objective is to create a page in the Designer that can let me see the actual reported values at the moment since the beggining of the day to the end (… --- ## [Strict format for SQL queries?](https://forum.inductiveautomation.com/t/strict-format-for-sql-queries/12410)
**Author:** [@sg7](https://forum.inductiveautomation.com/u/sg7)\ **Replies:** 2\ **Last updated:** [November 28, 2016, 2:26pm UTC](https://forum.inductiveautomation.com/t/strict-format-for-sql-queries/12410 "2016-11-28T14:26:09Z")
It looks like SQL query for SQL query tag has to have very specific format: 1) OK: SELECT "value\_int" FROM "w\_0\_5" WHERE object\_key='0\_5\_lamp' 2) OK: SELECT value\_int FROM w\_0\_5 WHERE object\_key='0\_5\_lamp' 3) WRON… --- ## [How to use "Ack Notes" in Alarm Status Table?](https://forum.inductiveautomation.com/t/how-to-use-ack-notes-in-alarm-status-table/8397)
**Author:** [@Bob](https://forum.inductiveautomation.com/u/Bob)\ **Replies:** 1\ **Last updated:** [November 28, 2016, 1:40am UTC](https://forum.inductiveautomation.com/t/how-to-use-ack-notes-in-alarm-status-table/8397 "2016-11-28T01:40:26Z")
Is it necessary to create a custom pop-up to allow the users to enter Ack Notes and the Ack'd By information when acknowledging an alarm? The columns are built-in to the table, but I don't see a built-in way to enter v… --- ## [Multiple Series On Chart with Discontinuous Time Stamps](https://forum.inductiveautomation.com/t/multiple-series-on-chart-with-discontinuous-time-stamps/12408)
**Author:** [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\ **Replies:** 0\ **Last updated:** [November 25, 2016, 9:45pm UTC](https://forum.inductiveautomation.com/t/multiple-series-on-chart-with-discontinuous-time-stamps/12408 "2016-11-25T21:45:26Z")
I have a dataset that I would like to make a chart out of, but I am having trouble figuring out the most efficient way to do it. In the dataset, I am: Returning a string combination (date, line, shift, and upc) and eff… --- ## [Error with Easy Chart Maximum Rows limit](https://forum.inductiveautomation.com/t/error-with-easy-chart-maximum-rows-limit/12356)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 1\ **Last updated:** [November 25, 2016, 12:38pm UTC](https://forum.inductiveautomation.com/t/error-with-easy-chart-maximum-rows-limit/12356 "2016-11-25T12:38:25Z")
I have multiple Pop Up windows with an Easy chart, some times I get an error. I'm using Tag Historian module and Mysql. \[attachment=0\]error\[1685\].png\[/attachment\] \[size=200\]\[b\]EDIT: I attached a video. https://yout… --- ## [Recipe Editor Table - Alternate row colour](https://forum.inductiveautomation.com/t/recipe-editor-table-alternate-row-colour/12405)
**Author:** [@dhananjay\_vichare](https://forum.inductiveautomation.com/u/dhananjay_vichare)\ **Replies:** 0\ **Last updated:** [November 25, 2016, 10:55am UTC](https://forum.inductiveautomation.com/t/recipe-editor-table-alternate-row-colour/12405 "2016-11-25T10:55:01Z")
I am using Recipe module 1.9.0 (b1610111606) and try to change colour of alternate row of "Recipe Editor Table" object, using "Background Mode = Alternating" and "Odd Row Background colour = 255,0,255". I am not able … --- ## [Data for boxplot](https://forum.inductiveautomation.com/t/data-for-boxplot/12365)
**Author:** [@the\_msp](https://forum.inductiveautomation.com/u/the_msp)\ **Replies:** 3\ **Last updated:** [November 25, 2016, 8:36am UTC](https://forum.inductiveautomation.com/t/data-for-boxplot/12365 "2016-11-25T08:36:15Z")
I want to get data into a box plot and have tried a few methods with limited success. There are 4 stations (split into two stations with two substations) and each logs into a DB (Sql server) 8 parameters. I want a box … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1717) [Next page](https://forum.inductiveautomation.com/latest.md?page=1719)