# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1276 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1277 --- ## [Reading Cell From Excel Sheet](https://forum.inductiveautomation.com/t/reading-cell-from-excel-sheet/22208)
**Author:** [@elizabeth](https://forum.inductiveautomation.com/u/elizabeth)\ **Replies:** 1\ **Last updated:** [July 13, 2019, 2:38pm UTC](https://forum.inductiveautomation.com/t/reading-cell-from-excel-sheet/22208 "2019-07-13T14:38:01Z")
I am wanting to read a specific cell that is added to an excel sheet daily from a shared drive and write it to tag in Ignition. The cell with the value is next to a date column, is there a way to search the excel sheet f… --- ## [Live Ignition Data to Excel](https://forum.inductiveautomation.com/t/live-ignition-data-to-excel/18241)
**Author:** [@dturner](https://forum.inductiveautomation.com/u/dturner)\ **Replies:** 3\ **Last updated:** [July 13, 2019, 2:22pm UTC](https://forum.inductiveautomation.com/t/live-ignition-data-to-excel/18241 "2019-07-13T14:22:33Z")
I have a situation where a user needs certain live tag information but cannot install java or just about anything else on his desktop. Excel is the only thing that I have been able to install. Is there a way to get the d… --- ## [Interfacing with Excel](https://forum.inductiveautomation.com/t/interfacing-with-excel/26118)
**Author:** [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Replies:** 1\ **Last updated:** [July 13, 2019, 2:15pm UTC](https://forum.inductiveautomation.com/t/interfacing-with-excel/26118 "2019-07-13T14:15:48Z")
How do you interface back and forth with excel spreadsheets? I want to have a live interface with an Ignition app. --- ## [Dropdown bind to SQL query, but allow no selection](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 2\ **Last updated:** [July 13, 2019, 1:03pm UTC](https://forum.inductiveautomation.com/t/dropdown-bind-to-sql-query-but-allow-no-selection/26498 "2019-07-13T13:03:34Z")
Using 7.9.10, I have a dropdown list bound to SQL query. This works fine. What if I want to deselect and have nothing selected? How can this be accomplished? Right now, the only available choices are what’s returned … --- ## [Edit dataset, then copy to SQL?](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494)
**Author:** [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Replies:** 6\ **Last updated:** [July 13, 2019, 1:02pm UTC](https://forum.inductiveautomation.com/t/edit-dataset-then-copy-to-sql/26494 "2019-07-13T13:02:35Z")
Looking for advice, and direction as well. Using 7.9.10, MySQL. I have a table with several rows that I allow changes. Right now you don’t edit the from within table, yet with selected row I move data into dropdown bo… --- ## [toCSV vs exportCSV](https://forum.inductiveautomation.com/t/tocsv-vs-exportcsv/26537)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 1\ **Last updated:** [July 13, 2019, 11:31am UTC](https://forum.inductiveautomation.com/t/tocsv-vs-exportcsv/26537 "2019-07-13T11:31:47Z")
When I use system.dataset.toCSV to export Russian translations from table to .csv, I get this: When I use system.dataset.exportCSV, I get this: To import csv there’s only one function: system.dataset.fromCSV, w… --- ## [TabStrip Arrows blocking tab](https://forum.inductiveautomation.com/t/tabstrip-arrows-blocking-tab/26509)
**Author:** [@brian.ankeny](https://forum.inductiveautomation.com/u/brian.ankeny)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 10:19pm UTC](https://forum.inductiveautomation.com/t/tabstrip-arrows-blocking-tab/26509 "2019-07-12T22:19:07Z")
We recently noticed an issue with an existing tab strip where a set of right/left arrows have appeared overlayed over one of the tabs (We recently upgraded to 7.9.12 but are not sure if this caused it). Pressing the arro… --- ## [System.report.executeanddistribute - time zone issue?](https://forum.inductiveautomation.com/t/system-report-executeanddistribute-time-zone-issue/26530)
**Author:** [@kwj](https://forum.inductiveautomation.com/u/kwj)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 8:38pm UTC](https://forum.inductiveautomation.com/t/system-report-executeanddistribute-time-zone-issue/26530 "2019-07-12T20:38:54Z")
I am pulling two dates (saved in postgresql with timezone) for a report. When that report is displayed in a viewer with the dates plugged in, everything is displayed correctly. When I use the same dates and report, but p… --- ## [Window information](https://forum.inductiveautomation.com/t/window-information/21549)
**Author:** [@alex.cordova.ee](https://forum.inductiveautomation.com/u/alex.cordova.ee)\ **Replies:** 10\ **Last updated:** [July 12, 2019, 8:05pm UTC](https://forum.inductiveautomation.com/t/window-information/21549 "2019-07-12T20:05:46Z")
How do I get information to tag on which window is open. Not sure if I can assign numbers to windows or just grab the names of them. Reason being, I have a filter button on alarm banner. The banner is docked under ever… --- ## [Detect Ignition 8.0 or 7.9 in script](https://forum.inductiveautomation.com/t/detect-ignition-8-0-or-7-9-in-script/26521)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 5\ **Last updated:** [July 12, 2019, 6:58pm UTC](https://forum.inductiveautomation.com/t/detect-ignition-8-0-or-7-9-in-script/26521 "2019-07-12T18:58:53Z")
Is there a way to detect in Gateway/Client script if the version is Ignition 8.0 or Ignition 7.9 --- ## [Client fallback mechanism in 8.x vs 7.9](https://forum.inductiveautomation.com/t/client-fallback-mechanism-in-8-x-vs-7-9/26474)
**Author:** [@florint](https://forum.inductiveautomation.com/u/florint)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 6:08pm UTC](https://forum.inductiveautomation.com/t/client-fallback-mechanism-in-8-x-vs-7-9/26474 "2019-07-12T18:08:51Z")
There seem to be a difference between Ignition 7.9 and 8.02 in terms of client fallback behavior. I have two Ignition servers - A and B - configured as “Independent”. The clients connect to server A (while server B is n… --- ## [Setting Page Problems](https://forum.inductiveautomation.com/t/setting-page-problems/26523)
**Author:** [@kstewart](https://forum.inductiveautomation.com/u/kstewart)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 5:39pm UTC](https://forum.inductiveautomation.com/t/setting-page-problems/26523 "2019-07-12T17:39:52Z")
I am doing a settings popup window for all of the different main windows we have. I am having a problem though, I would like the user to be able to adjust the font to what size they want but the font option does not have… --- ## [Custom Store&Forward Fails - Truncates VARBINARY Field Data](https://forum.inductiveautomation.com/t/custom-store-forward-fails-truncates-varbinary-field-data/26516)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 4:41pm UTC](https://forum.inductiveautomation.com/t/custom-store-forward-fails-truncates-varbinary-field-data/26516 "2019-07-12T16:41:23Z")
I’m trying to build a custom Store & Forward component in a project that will take test data from a local MS SQL DB and insert it into a remote MS SQL DB in an Azure Cloud server. One of the fields in the data being cop… --- ## [Ignition Edge on arm32hf device](https://forum.inductiveautomation.com/t/ignition-edge-on-arm32hf-device/25622)
**Author:** [@yurichamarelli](https://forum.inductiveautomation.com/u/yurichamarelli)\ **Replies:** 17\ **Last updated:** [July 12, 2019, 4:33pm UTC](https://forum.inductiveautomation.com/t/ignition-edge-on-arm32hf-device/25622 "2019-07-12T16:33:53Z")
Hello all, We been working on implementing the the Ignition Edge version for the armv32hf , in a debian based armv32hf target. we have correctly installed and configured the JRE arm32 version 8, and followed through pr… --- ## [\[14424\] Cannot Monitor SFC Defined in Base Project](https://forum.inductiveautomation.com/t/14424-cannot-monitor-sfc-defined-in-base-project/26290)
**Author:** [@rttwge](https://forum.inductiveautomation.com/u/rttwge)\ **Replies:** 4\ **Last updated:** [July 12, 2019, 4:08pm UTC](https://forum.inductiveautomation.com/t/14424-cannot-monitor-sfc-defined-in-base-project/26290 "2019-07-12T16:08:33Z")
Hi, I have an SFC in an inheritable project, I’ve created another project which inherits from that project and successfully start the SFC. I see the SFC running from the web portal plus I can set tags etc. etc. and have… --- ## [Power Table Formatting](https://forum.inductiveautomation.com/t/power-table-formatting/26511)
**Author:** [@Ranga.Katti](https://forum.inductiveautomation.com/u/Ranga.Katti)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 2:59pm UTC](https://forum.inductiveautomation.com/t/power-table-formatting/26511 "2019-07-12T14:59:24Z")
I am binding a power table data through an sql query. Sql data type is char(50) but actual data length is only 10 char long. If I use TRIM command in sql query, I lose column headings in power table. Is there a different… --- ## [\[Bug-14458\] Changes saved if clicking cancel on 'Edit Group Tag'](https://forum.inductiveautomation.com/t/bug-14458-changes-saved-if-clicking-cancel-on-edit-group-tag/26057)
**Author:** [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\ **Replies:** 5\ **Last updated:** [July 12, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/bug-14458-changes-saved-if-clicking-cancel-on-edit-group-tag/26057 "2019-07-12T14:07:53Z")
I’m on the 8.0.2 Release. It appears that if I make a change(such as changing the name) and hit cancel instead of OK or Apply, the changes are still saved to the transaction. I’m guessing this isn’t intentional behavior? … --- ## [Java Specs per Version](https://forum.inductiveautomation.com/t/java-specs-per-version/26506)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 1\ **Last updated:** [July 12, 2019, 12:41pm UTC](https://forum.inductiveautomation.com/t/java-specs-per-version/26506 "2019-07-12T12:41:11Z")
Where can I find the details on which versions have embedded Java for clients/gateways? I’m currently on 7.9.10 looking to go to 7.9.11 soon, and hopefully 8.0.x next. Also would like to know the Java version details. --- ## [Chart Strange behaviour](https://forum.inductiveautomation.com/t/chart-strange-behaviour/26197)
**Author:** [@nagewaza1009](https://forum.inductiveautomation.com/u/nagewaza1009)\ **Replies:** 15\ **Last updated:** [July 12, 2019, 11:30am UTC](https://forum.inductiveautomation.com/t/chart-strange-behaviour/26197 "2019-07-12T11:30:08Z")
Hello everyone, I have had a problem for a few days. Some of my charts and the records of the historian tags in the database don’t make sense at all. To explain my problem, here is an example : the Tag TT105. If you hav… --- ## [Email Notification block consolidation](https://forum.inductiveautomation.com/t/email-notification-block-consolidation/26504)
**Author:** [@annr](https://forum.inductiveautomation.com/u/annr)\ **Replies:** 0\ **Last updated:** [July 12, 2019, 10:29am UTC](https://forum.inductiveautomation.com/t/email-notification-block-consolidation/26504 "2019-07-12T10:29:01Z")
Hi all, I have a doubt about the Notification Block consolidation Delay (sec)= 15 seconds Frequency (sec)= 60 seconds Alarm 1 enters the pipeline and has to wait for 15 seconds to be sent Alarm 2 enters the pipeline… --- ## [Scan classes and gateway scriptcs - time precision](https://forum.inductiveautomation.com/t/scan-classes-and-gateway-scriptcs-time-precision/26473)
**Author:** [@szcz](https://forum.inductiveautomation.com/u/szcz)\ **Replies:** 2\ **Last updated:** [July 12, 2019, 4:51am UTC](https://forum.inductiveautomation.com/t/scan-classes-and-gateway-scriptcs-time-precision/26473 "2019-07-12T04:51:00Z")
Greetings, I have scan-class and gateway scripts-related question. With scan class, we can set how often it is going to run. The same we can do with gateway scripts (e.g. run every 10 seconds). I just wanted to ask how … --- ## [Named query to insert float to sql, error unable to coerce to number](https://forum.inductiveautomation.com/t/named-query-to-insert-float-to-sql-error-unable-to-coerce-to-number/21143)
**Author:** [@bebel](https://forum.inductiveautomation.com/u/bebel)\ **Replies:** 3\ **Last updated:** [July 11, 2019, 7:05pm UTC](https://forum.inductiveautomation.com/t/named-query-to-insert-float-to-sql-error-unable-to-coerce-to-number/21143 "2019-07-11T19:05:16Z")
I have a named query to insert a record into a sql database table One of the data types in the table is float. In the Parameters portion of the named query I have tried Float4 and Float8 In the button that triggers the n… --- ## [Vision component position differs between designer and launch](https://forum.inductiveautomation.com/t/vision-component-position-differs-between-designer-and-launch/26486)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 1\ **Last updated:** [July 11, 2019, 5:55pm UTC](https://forum.inductiveautomation.com/t/vision-component-position-differs-between-designer-and-launch/26486 "2019-07-11T17:55:10Z")
In designer, I create a main window with a label quite near its left margin, as seen in this screenshot: However, when I launch the project (windowed or maximized, no difference), the label is very far from the left … --- ## [Passing a table to runScript](https://forum.inductiveautomation.com/t/passing-a-table-to-runscript/26484)
**Author:** [@waldner](https://forum.inductiveautomation.com/u/waldner)\ **Replies:** 14\ **Last updated:** [July 11, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/passing-a-table-to-runscript/26484 "2019-07-11T17:35:46Z")
In Vision, I want to use a label component which shows the number of selected rows in a table. I can get the number of selected rows in a table with .getSelectedRowCount(), so I wrote: def getSelectedRowCount(table): … --- ## [Report Schedules Problem](https://forum.inductiveautomation.com/t/report-schedules-problem/26475)
**Author:** [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Replies:** 6\ **Last updated:** [July 11, 2019, 5:27pm UTC](https://forum.inductiveautomation.com/t/report-schedules-problem/26475 "2019-07-11T17:27:16Z")
So we have a gateway that due to domain issues had its date set 2 months ahead. The scheduled reports ran and set the last run date/time to Sept 1st Now since the date was corrected after that no reports will execute a… --- ## [Ignition Windows on a Smart TV or website](https://forum.inductiveautomation.com/t/ignition-windows-on-a-smart-tv-or-website/26459)
**Author:** [@RRagan](https://forum.inductiveautomation.com/u/RRagan)\ **Replies:** 3\ **Last updated:** [July 11, 2019, 3:41pm UTC](https://forum.inductiveautomation.com/t/ignition-windows-on-a-smart-tv-or-website/26459 "2019-07-11T15:41:13Z")
My plant is set up with each production line being run by a client HMI, and the information on that HMI being specific to each production line. There is another HMI that is a plant overview, and is used for some scheduli… --- ## [Print table data](https://forum.inductiveautomation.com/t/print-table-data/26456)
**Author:** [@mavallejo](https://forum.inductiveautomation.com/u/mavallejo)\ **Replies:** 6\ **Last updated:** [July 11, 2019, 3:31pm UTC](https://forum.inductiveautomation.com/t/print-table-data/26456 "2019-07-11T15:31:11Z")
Hello Collages Someone could help me to know how to print table data on my default printer? Thanks in advance --- ## [valueChanged error](https://forum.inductiveautomation.com/t/valuechanged-error/26464)
**Author:** [@tgfgreaves](https://forum.inductiveautomation.com/u/tgfgreaves)\ **Replies:** 2\ **Last updated:** [July 11, 2019, 3:22pm UTC](https://forum.inductiveautomation.com/t/valuechanged-error/26464 "2019-07-11T15:22:54Z")
Trying to create a valueChanged script with a numeric entry field. Any guidance would be greatly appreciated. code: ‘’’ import string x = previousValue.value y = currentValue.value if self.view.custom.PM.ewonType =… --- ## [Logix Driver - Bad Quality](https://forum.inductiveautomation.com/t/logix-driver-bad-quality/26469)
**Author:** [@jonathan1](https://forum.inductiveautomation.com/u/jonathan1)\ **Replies:** 4\ **Last updated:** [July 11, 2019, 3:13pm UTC](https://forum.inductiveautomation.com/t/logix-driver-bad-quality/26469 "2019-07-11T15:13:29Z")
I am connected to a compactlogix L36E via VPN. I’m using an Allen-Bradley Logix Driver. My tags are perfectly healthy, all values are reading correctly and changing when they’re supposed to, but they’re all marked as ‘ba… --- ## [Circular Slider in canvas](https://forum.inductiveautomation.com/t/circular-slider-in-canvas/26254)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 12\ **Last updated:** [July 11, 2019, 12:39pm UTC](https://forum.inductiveautomation.com/t/circular-slider-in-canvas/26254 "2019-07-11T12:39:19Z")
OK, after 4 days I have enough… :disappointed\_relieved: It seems that (at least for me) this seems to be more difficult than I thought. Making a circular slider is way more different/difficult than making a circular ga… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1275) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1277)