# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1467 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1468 --- ## [Timezones and Expressions](https://forum.inductiveautomation.com/t/timezones-and-expressions/8657)
**Author:** [@marioquark](https://forum.inductiveautomation.com/u/marioquark)\ **Replies:** 7\ **Last updated:** [January 27, 2016, 3:29pm UTC](https://forum.inductiveautomation.com/t/timezones-and-expressions/8657 "2016-01-27T15:29:57Z")
Any way to convert a Date to another, specifing a different timezone, using expressions? --- ## [Manual needs to be updated - Modbus Driver Designator](https://forum.inductiveautomation.com/t/manual-needs-to-be-updated-modbus-driver-designator/11123)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 1\ **Last updated:** [January 26, 2016, 10:04pm UTC](https://forum.inductiveautomation.com/t/manual-needs-to-be-updated-modbus-driver-designator/11123 "2016-01-26T22:04:53Z")
Seems the manual still needs to be updated for the HRBCD32 and IRBCD32 designators. They should be HRBCD\_32 and IRBCD\_32, Kevin :wink: https://inductiveautomation.com/forum/viewtopic.php?f=70&t=9639&p=33503&hilit=h… --- ## [Power Table onCellEdited with SQL table](https://forum.inductiveautomation.com/t/power-table-oncelledited-with-sql-table/11122)
**Author:** [@Kstofcho](https://forum.inductiveautomation.com/u/Kstofcho)\ **Replies:** 1\ **Last updated:** [January 26, 2016, 7:38pm UTC](https://forum.inductiveautomation.com/t/power-table-oncelledited-with-sql-table/11122 "2016-01-26T19:38:32Z")
I am trying to update a SQL table when edits are made within a power table using the onCellEdited extension function. I cannot get the following code or any attempted modifications to work. selectedID is a custom propert… --- ## [A couple of questions about IP Camera Viewer](https://forum.inductiveautomation.com/t/a-couple-of-questions-about-ip-camera-viewer/11121)
**Author:** [@AleInge](https://forum.inductiveautomation.com/u/AleInge)\ **Replies:** 0\ **Last updated:** [January 26, 2016, 4:02pm UTC](https://forum.inductiveautomation.com/t/a-couple-of-questions-about-ip-camera-viewer/11121 "2016-01-26T16:02:03Z")
Hi, reading an old topic (inductiveautomation.com/forum/v ... era+status), I've found the following statement: "\[...\] the connection to the IP camera is actually initiated directly from the Client itself, it is not … --- ## [Running Client from boot](https://forum.inductiveautomation.com/t/running-client-from-boot/11114)
**Author:** [@CamJam](https://forum.inductiveautomation.com/u/CamJam)\ **Replies:** 2\ **Last updated:** [January 26, 2016, 3:54pm UTC](https://forum.inductiveautomation.com/t/running-client-from-boot/11114 "2016-01-26T15:54:41Z")
Hi, I am getting an error when running the client executable from the startup folder in windows. Attached is the error I'm getting. Looks as though the gateway is not up and running by the time I want to run the client… --- ## [Bad quality of components at client start](https://forum.inductiveautomation.com/t/bad-quality-of-components-at-client-start/11038)
**Author:** [@S.Ojeda](https://forum.inductiveautomation.com/u/S.Ojeda)\ **Replies:** 6\ **Last updated:** [January 26, 2016, 7:47am UTC](https://forum.inductiveautomation.com/t/bad-quality-of-components-at-client-start/11038 "2016-01-26T07:47:35Z")
Hi there! Hope I can find help from the community. I have the following problem: I have a template where there are a few components. These components take their value from an expression. If a certain condition is tru… --- ## [Filepath in script](https://forum.inductiveautomation.com/t/filepath-in-script/11112)
**Author:** [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Replies:** 3\ **Last updated:** [January 25, 2016, 10:28pm UTC](https://forum.inductiveautomation.com/t/filepath-in-script/11112 "2016-01-25T22:28:04Z")
I am trying to open a file using Ignition's scripting the format of the filepath is: Code: filepath = "\\machine\\c$\\Logs\\03\_filename.log" file = open(filepath) but the console returns: Quote: No such file or dir… --- ## [OPCUaConnection Error with Kepware](https://forum.inductiveautomation.com/t/opcuaconnection-error-with-kepware/11109)
**Author:** [@bridress](https://forum.inductiveautomation.com/u/bridress)\ **Replies:** 0\ **Last updated:** [January 25, 2016, 3:37pm UTC](https://forum.inductiveautomation.com/t/opcuaconnection-error-with-kepware/11109 "2016-01-25T15:37:41Z")
We just upgraded to 7.7.6 last week. We are using a Kepware OPC connection to DeltaV. Yesterday we had the following error which prevented all data from displaying. ERROR \[OpcUaConnection\[KepwareOPC\] \] \[19:23:33,24… --- ## [getKey from SQL Server](https://forum.inductiveautomation.com/t/getkey-from-sql-server/11091)
**Author:** [@boandersen](https://forum.inductiveautomation.com/u/boandersen)\ **Replies:** 4\ **Last updated:** [January 25, 2016, 1:38pm UTC](https://forum.inductiveautomation.com/t/getkey-from-sql-server/11091 "2016-01-25T13:38:56Z")
I am kind of confused about this because this worked yesterday and I have no clue what changed.. On SQL Server 2014, Ignition 7.8 on Java 8.65 I cannot retrieve the key from an insert using getKey: Here is a simplifi… --- ## [Still getting Emails after removing from roster](https://forum.inductiveautomation.com/t/still-getting-emails-after-removing-from-roster/11104)
**Author:** [@darrell.henley](https://forum.inductiveautomation.com/u/darrell.henley)\ **Replies:** 0\ **Last updated:** [January 22, 2016, 11:19pm UTC](https://forum.inductiveautomation.com/t/still-getting-emails-after-removing-from-roster/11104 "2016-01-22T23:19:42Z")
We have removed someone from the email notification roster but yet they are still getting emails. Where else could it be? --- ## [Reports, Schedule, Action, Body, Printing a New Line](https://forum.inductiveautomation.com/t/reports-schedule-action-body-printing-a-new-line/11092)
**Author:** [@darrell.henley](https://forum.inductiveautomation.com/u/darrell.henley)\ **Replies:** 2\ **Last updated:** [January 22, 2016, 8:16pm UTC](https://forum.inductiveautomation.com/t/reports-schedule-action-body-printing-a-new-line/11092 "2016-01-22T20:16:53Z")
Okay this should be simple In the body of my email how do I get it to print on the next line? I tried \\r and \\n\\r but it just prints those in the email too --- ## [Exporting reports](https://forum.inductiveautomation.com/t/exporting-reports/11097)
**Author:** [@Oleksii](https://forum.inductiveautomation.com/u/Oleksii)\ **Replies:** 2\ **Last updated:** [January 22, 2016, 7:41pm UTC](https://forum.inductiveautomation.com/t/exporting-reports/11097 "2016-01-22T19:41:57Z")
Hello. Is there a way to export reports to excel files(not csv)? I know that there is functions that allow to export datasets to excel files. But there is a need to make a report with possibility to save it in excel tab… --- ## [Report Designer causing crash](https://forum.inductiveautomation.com/t/report-designer-causing-crash/10863)
**Author:** [@jmoniz](https://forum.inductiveautomation.com/u/jmoniz)\ **Replies:** 7\ **Last updated:** [January 22, 2016, 3:13pm UTC](https://forum.inductiveautomation.com/t/report-designer-causing-crash/10863 "2016-01-22T15:13:42Z")
Version 7.8.0 64bit After working on a report for about 15min the report designer locks up and I am forced to kill the designer. This has happened more than once and is repeatable. --- ## [Groups & Templates](https://forum.inductiveautomation.com/t/groups-templates/11099)
**Author:** [@WaleedK](https://forum.inductiveautomation.com/u/WaleedK)\ **Replies:** 0\ **Last updated:** [January 22, 2016, 1:26pm UTC](https://forum.inductiveautomation.com/t/groups-templates/11099 "2016-01-22T13:26:29Z")
Hi, i am having a small problem where when ever I create a template and group the components. The grouped components are not visible and not sure what option i have clicked. The visible property is checked true for all … --- ## [Sql query keep leading zero](https://forum.inductiveautomation.com/t/sql-query-keep-leading-zero/11089)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 3\ **Last updated:** [January 21, 2016, 9:46pm UTC](https://forum.inductiveautomation.com/t/sql-query-keep-leading-zero/11089 "2016-01-21T21:46:29Z")
I am having an issue where my leading zeros keep getting cut off of my string when i do my query. qv1 = event.source.parent.getComponent('Bushings').text qv2 = event.source.parent.getComponent('Adhesive').text qv3 = e… --- ## [Reporting Options from the Client](https://forum.inductiveautomation.com/t/reporting-options-from-the-client/11088)
**Author:** [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\ **Replies:** 1\ **Last updated:** [January 21, 2016, 7:45pm UTC](https://forum.inductiveautomation.com/t/reporting-options-from-the-client/11088 "2016-01-21T19:45:05Z")
Is there anyway to access the Schedule options of a report from a client? Specifically the schedule and recipient emails? I know I could use the executeAndDistribute functions in a timer or tag change script to run a rep… --- ## [Tag Arrays](https://forum.inductiveautomation.com/t/tag-arrays/11078)
**Author:** [@r\_beall](https://forum.inductiveautomation.com/u/r_beall)\ **Replies:** 6\ **Last updated:** [January 21, 2016, 3:38pm UTC](https://forum.inductiveautomation.com/t/tag-arrays/11078 "2016-01-21T15:38:29Z")
I'm trying to get a specific index value from a tag array. From reading, this would be done by saying 'OPCPATH\[0\].\[INDEX HERE\]' However, this isn't working in this case. I've tried it with and without brackets around … --- ## [Io-link](https://forum.inductiveautomation.com/t/io-link/11066)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 2\ **Last updated:** [January 21, 2016, 2:41pm UTC](https://forum.inductiveautomation.com/t/io-link/11066 "2016-01-21T14:41:14Z")
Hi, Is there a way to add IO-Link and/or standard output(4-20mA) sensors to Ignition without involving a PLC for example through kepware, I have been trying to find an answer for this question, your help is appreciated. --- ## [Playing Video Clip in Ignition](https://forum.inductiveautomation.com/t/playing-video-clip-in-ignition/11086)
**Author:** [@dadof3and3](https://forum.inductiveautomation.com/u/dadof3and3)\ **Replies:** 0\ **Last updated:** [January 21, 2016, 1:50pm UTC](https://forum.inductiveautomation.com/t/playing-video-clip-in-ignition/11086 "2016-01-21T13:50:08Z")
What is the best way to play a video inside an Ignition Window? HTML5 ? If so... what codec should the video play? What must the extension be? MP4, AVI, MOV ? Thanks in advance for any comment/response... --- ## [SFC Script Failing](https://forum.inductiveautomation.com/t/sfc-script-failing/11080)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 3\ **Last updated:** [January 21, 2016, 2:46am UTC](https://forum.inductiveautomation.com/t/sfc-script-failing/11080 "2016-01-21T02:46:48Z")
This script keeps failing. Basically what I'm trying to do is subtract the 'pkQty' from the 'bal' and store it in the 'Contqty' \ \ \ **Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 4\ **Last updated:** [January 20, 2016, 11:17pm UTC](https://forum.inductiveautomation.com/t/unexpected-error-executing-scan-class/11060 "2016-01-20T23:17:39Z") I have this error in my System Console, but I'm not sure what it's telling me. com.google.common.util.concurrent.UncheckedExecutionException: com.google.common.collect.ComputationException: com.inductiveautomation.i… --- ## [Style Customizer: Fallback State?](https://forum.inductiveautomation.com/t/style-customizer-fallback-state/11079)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 0\ **Last updated:** [January 20, 2016, 9:27pm UTC](https://forum.inductiveautomation.com/t/style-customizer-fallback-state/11079 "2016-01-20T21:27:26Z")
I was wondering if there is a way to setup a 'fallback' state in the style customizer. This would be equivalent to the last parameter of a switch() statement in an expression (the value you to return if the driving prope… --- ## [Sql inner join](https://forum.inductiveautomation.com/t/sql-inner-join/11075)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 1\ **Last updated:** [January 20, 2016, 5:58pm UTC](https://forum.inductiveautomation.com/t/sql-inner-join/11075 "2016-01-20T17:58:02Z")
I want to run the following sql query on the push of a button but I am not sure how to do it with Component Scripting. update Thermoplastics.dbo.FinishingResults set Thermoplastics.dbo.FinishingResults.BushingCont… --- ## [SQL query with table/row/value where clause](https://forum.inductiveautomation.com/t/sql-query-with-table-row-value-where-clause/11073)
**Author:** [@boster281](https://forum.inductiveautomation.com/u/boster281)\ **Replies:** 2\ **Last updated:** [January 20, 2016, 5:44pm UTC](https://forum.inductiveautomation.com/t/sql-query-with-table-row-value-where-clause/11073 "2016-01-20T17:44:07Z")
I want to use a container value from the selected table row as a where clause in the component scripting sql update query when I press a button. queryValue = '520' qv1 = event.source.parent.getComponent('Group 1').getC… --- ## [Calling OPC-UA Methods](https://forum.inductiveautomation.com/t/calling-opc-ua-methods/11070)
**Author:** [@malleblas](https://forum.inductiveautomation.com/u/malleblas)\ **Replies:** 1\ **Last updated:** [January 20, 2016, 4:01pm UTC](https://forum.inductiveautomation.com/t/calling-opc-ua-methods/11070 "2016-01-20T16:01:26Z")
Hi, Is there any facility to call OPC-UA methods from within Ignition and if so, what is the best way of going about this? I can see the methods exposed by the OPC-UA server and I can even call them using UAExpert. How… --- ## [Example of Using Serial Gateway Module?](https://forum.inductiveautomation.com/t/example-of-using-serial-gateway-module/11068)
**Author:** [@cswett](https://forum.inductiveautomation.com/u/cswett)\ **Replies:** 1\ **Last updated:** [January 20, 2016, 1:15pm UTC](https://forum.inductiveautomation.com/t/example-of-using-serial-gateway-module/11068 "2016-01-20T13:15:49Z")
Would anyone have an example of how the Serial Gateway module can be used to allow clients to write to the serial port of the gateway? I have searched within forum, on the site and thru the manuals but haven't had much … --- ## [Delete Files in a Disk using Ignition](https://forum.inductiveautomation.com/t/delete-files-in-a-disk-using-ignition/11061)
**Author:** [@rmdalisay](https://forum.inductiveautomation.com/u/rmdalisay)\ **Replies:** 2\ **Last updated:** [January 20, 2016, 12:55am UTC](https://forum.inductiveautomation.com/t/delete-files-in-a-disk-using-ignition/11061 "2016-01-20T00:55:11Z")
Hi! Is there a way to delete a file in a disk using ignition? In our project, we have an inventory wherein each entry has an associated PDF file. What I did is to use system.file.writefile to save the PDF in a predefined… --- ## [Ultra Low Memory Client](https://forum.inductiveautomation.com/t/ultra-low-memory-client/11059)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 6\ **Last updated:** [January 19, 2016, 11:22pm UTC](https://forum.inductiveautomation.com/t/ultra-low-memory-client/11059 "2016-01-19T23:22:54Z")
I'm looking for some memory management help. I have a client that I want to launch, however it is on a system with strict memory management requirements. I want to ensure the client can consume no more than somewhere i… --- ## [Feedback: Script Editor / Window Editor Switching](https://forum.inductiveautomation.com/t/feedback-script-editor-window-editor-switching/11064)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [January 19, 2016, 9:28pm UTC](https://forum.inductiveautomation.com/t/feedback-script-editor-window-editor-switching/11064 "2016-01-19T21:28:21Z")
I posted previously in the Ignition Problems forum about a bug switching between the two "layouts". I don't know how to replicate it, but it happens just about every couple minutes. The only fix I've found is to save my … --- ## [Report copy/paste issue](https://forum.inductiveautomation.com/t/report-copy-paste-issue/11048)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 3\ **Last updated:** [January 19, 2016, 8:02pm UTC](https://forum.inductiveautomation.com/t/report-copy-paste-issue/11048 "2016-01-19T20:02:18Z")
Ignition 7.8.0 b2015101414 Gateway Java 1.8.0\_65 on Win Server 2012R2 Designer Java 1.8.0\_66 on Windows 7 In the Report Designer, on a table header, I have a static Text object. When I select it and press Ctrl-C, Ctrl-… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1466) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1468)