# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1208 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1209 --- ## [Convert float to bool SQL historian](https://forum.inductiveautomation.com/t/convert-float-to-bool-sql-historian/32326)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 4\ **Last updated:** [February 19, 2020, 8:57am UTC](https://forum.inductiveautomation.com/t/convert-float-to-bool-sql-historian/32326 "2020-02-19T08:57:08Z")
Ignition 8.0 SQL server express Hi. Due to hardware restrictions, I’m forced to read data from 2 digital proximity switches as analog values (0…1000mV). \<~50mV is 0, \>~900mV is 1. I would like to log this data to our… --- ## [Image inside Power Table](https://forum.inductiveautomation.com/t/image-inside-power-table/32368)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 2\ **Last updated:** [February 19, 2020, 8:36am UTC](https://forum.inductiveautomation.com/t/image-inside-power-table/32368 "2020-02-19T08:36:53Z")
Hi there :slight\_smile: I was wondering if it was possible to have an image inside one of the Power Table’s cell. I know it’s possible with the “basic” table, but for scripting purposes, I can’t use it :confused: Any … --- ## [Settings for slow Ignition to PLC comms](https://forum.inductiveautomation.com/t/settings-for-slow-ignition-to-plc-comms/32409)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [February 19, 2020, 7:24am UTC](https://forum.inductiveautomation.com/t/settings-for-slow-ignition-to-plc-comms/32409 "2020-02-19T07:24:01Z")
I’m looking to see what I can do about slow PLC comms to an Ignition gateway, as the Ignition clients are seeing red overlays (f(x)) flash cyclically around the pages, indicating to me that Ignition is trying to read too… --- ## [\[BUG-15748\] Export excel problem in 8.0.8](https://forum.inductiveautomation.com/t/bug-15748-export-excel-problem-in-8-0-8/32371)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 2\ **Last updated:** [February 19, 2020, 1:24am UTC](https://forum.inductiveautomation.com/t/bug-15748-export-excel-problem-in-8-0-8/32371 "2020-02-19T01:24:19Z")
Hey all, I just updated my Ignition servers to 8.0.8 from 7.9.12 and now I’m having a problem with the system.dataset.exportExcel() function. I get the following error: Traceback (most recent call last): File "\ **Author:** [@anon55648468](https://forum.inductiveautomation.com/u/anon55648468)\ **Replies:** 0\ **Last updated:** [February 19, 2020, 12:15am UTC](https://forum.inductiveautomation.com/t/alarm-query-multiple-sources/32405 "2020-02-19T00:15:26Z") Hi guys, it’s probably something simple but i can’t think of a why to pass a binding into a system.alarm.queryStatus script regarding multiple sources. If i write it directly into the script as Source = \[“X,Y”\] it works … --- ## [Perspective popup dock aware](https://forum.inductiveautomation.com/t/perspective-popup-dock-aware/32322)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 3\ **Last updated:** [February 19, 2020, 12:03am UTC](https://forum.inductiveautomation.com/t/perspective-popup-dock-aware/32322 "2020-02-19T00:03:17Z")
When I open a popup with a dock present, it overlays the dock. How do I keep that from happening? Shouldn’t the popup respect the dock just like a normal view does? --- ## [Perspective polling not working consistently?](https://forum.inductiveautomation.com/t/perspective-polling-not-working-consistently/32390)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 8:37pm UTC](https://forum.inductiveautomation.com/t/perspective-polling-not-working-consistently/32390 "2020-02-18T20:37:25Z")
I have a view where I let a user select his own filter settings with 5 drop downs. On the value change to the drop down, we write to our users table the value of the drop down into a column. Now, also on the drop downs… --- ## [Ignition 8 gateway network and active alarms](https://forum.inductiveautomation.com/t/ignition-8-gateway-network-and-active-alarms/32393)
**Author:** [@Quinn.tomo](https://forum.inductiveautomation.com/u/Quinn.tomo)\ **Replies:** 0\ **Last updated:** [February 18, 2020, 7:54pm UTC](https://forum.inductiveautomation.com/t/ignition-8-gateway-network-and-active-alarms/32393 "2020-02-18T19:54:38Z")
We have set up an instance of Ignition 8 on our DMZ and are communicating to other internal gateways over the gateway network. We have set up a number of remote tag providers and would like to view the alarms in a perspe… --- ## [Coordinating Zoom on Time Series Chart](https://forum.inductiveautomation.com/t/coordinating-zoom-on-time-series-chart/32384)
**Author:** [@jgardner](https://forum.inductiveautomation.com/u/jgardner)\ **Replies:** 4\ **Last updated:** [February 18, 2020, 7:44pm UTC](https://forum.inductiveautomation.com/t/coordinating-zoom-on-time-series-chart/32384 "2020-02-18T19:44:28Z")
I have two Time Series Charts on one view. Is there a way to coordinate the Zoom / Pan action between them? I have Temperature (with lower / upper bounds) as well as Humidity (with bounds) and it would be great if zoomin… --- ## [Z order in runtime](https://forum.inductiveautomation.com/t/z-order-in-runtime/4934)
**Author:** [@vahterto](https://forum.inductiveautomation.com/u/vahterto)\ **Replies:** 6\ **Last updated:** [February 18, 2020, 7:13pm UTC](https://forum.inductiveautomation.com/t/z-order-in-runtime/4934 "2020-02-18T19:13:35Z")
Hi Is it possible to change graphics components z order in runtime? Like X and Y. Br Tommi --- ## [Hub and Spoke Architecture](https://forum.inductiveautomation.com/t/hub-and-spoke-architecture/32389)
**Author:** [@Pat\_Schmidt](https://forum.inductiveautomation.com/u/Pat_Schmidt)\ **Replies:** 0\ **Last updated:** [February 18, 2020, 7:06pm UTC](https://forum.inductiveautomation.com/t/hub-and-spoke-architecture/32389 "2020-02-18T19:06:59Z")
We currently have a customer with multiple independent sites. Each site has it’s own local gateway, clients, and databases. They are inquiring about connecting all these sites together over a VPN and having some central … --- ## [Expression Tag not updating?](https://forum.inductiveautomation.com/t/expression-tag-not-updating/32387)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 0\ **Last updated:** [February 18, 2020, 6:04pm UTC](https://forum.inductiveautomation.com/t/expression-tag-not-updating/32387 "2020-02-18T18:04:18Z")
This has happened before but the last time I just created a tag in the plc and logged it with a transaction group. So the problem was solved, however I need to do it again and I could create another tag in the Plc and no… --- ## [Using Session Property for Barcode scanner](https://forum.inductiveautomation.com/t/using-session-property-for-barcode-scanner/32302)
**Author:** [@fisayoa](https://forum.inductiveautomation.com/u/fisayoa)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 5:57pm UTC](https://forum.inductiveautomation.com/t/using-session-property-for-barcode-scanner/32302 "2020-02-18T17:57:06Z")
Hi, Please, is it possible to temporarily store the scanned barcode to a session property for multiple users to scan using their mobile device and save to the the database simultaneously? I am currently saving the scan… --- ## [\[SOLVED\] Deleting rows from a SQL table using RunPrepQuery](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 6\ **Last updated:** [February 18, 2020, 5:26pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353 "2020-02-18T17:26:48Z")
I have some code here that lets the user drag and drop data from one power table to the next: if system.gui.confirm("Are you sure you want to scrap this part?", "Recycle?"): if self != sourceTable: destDataset = self… --- ## [Swiping Up/Down on Time-Series Chart](https://forum.inductiveautomation.com/t/swiping-up-down-on-time-series-chart/32323)
**Author:** [@jaspinall](https://forum.inductiveautomation.com/u/jaspinall)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 5:19pm UTC](https://forum.inductiveautomation.com/t/swiping-up-down-on-time-series-chart/32323 "2020-02-18T17:19:20Z")
Hi There, We have a few time-series charts on one of our views and one of the things that I’ve noticed is when we are swiping up/down in order to scroll through the page - if our thumb happens to touch the time series c… --- ## [Expression tag alters the scan rate of referred tag(-s)](https://forum.inductiveautomation.com/t/expression-tag-alters-the-scan-rate-of-referred-tag-s/32380)
**Author:** [@d.filos](https://forum.inductiveautomation.com/u/d.filos)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 4:46pm UTC](https://forum.inductiveautomation.com/t/expression-tag-alters-the-scan-rate-of-referred-tag-s/32380 "2020-02-18T16:46:47Z")
Hi, I am using UDTs with expression and OPC tags (Ignition 8.0.7). The issue I have encounter is that eventhough all tags belong to a direct mode tag group with rate at 5sec those OPC tags that are used in expressions a… --- ## [Database Query Browser Issue with HXTT Driver](https://forum.inductiveautomation.com/t/database-query-browser-issue-with-hxtt-driver/32382)
**Author:** [@boyergary](https://forum.inductiveautomation.com/u/boyergary)\ **Replies:** 0\ **Last updated:** [February 18, 2020, 4:00pm UTC](https://forum.inductiveautomation.com/t/database-query-browser-issue-with-hxtt-driver/32382 "2020-02-18T16:00:19Z")
We are using the HXTT driver to access our FoxPro data tables in ignition and it works fine for the most part. For some of the reports, we sometimes get a 1000msec timeout when the SQL query uses dates or string functio… --- ## [Using Tag Values in Strings & Date Formatting](https://forum.inductiveautomation.com/t/using-tag-values-in-strings-date-formatting/32320)
**Author:** [@s\_petrarca](https://forum.inductiveautomation.com/u/s_petrarca)\ **Replies:** 7\ **Last updated:** [February 18, 2020, 3:43pm UTC](https://forum.inductiveautomation.com/t/using-tag-values-in-strings-date-formatting/32320 "2020-02-18T15:43:10Z")
I’m writing a script to export a Report that will run on the value change of a UDT mem tag and I’m having some issues with trying to dynamically adjust the file name of the Report pdf. I have a Job # (MO) and batch # (c… --- ## [Translation manager don’t show item values when filtered](https://forum.inductiveautomation.com/t/translation-manager-don-t-show-item-values-when-filtered/9462)
**Author:** [@Didi71](https://forum.inductiveautomation.com/u/Didi71)\ **Replies:** 1\ **Last updated:** [February 18, 2020, 3:38pm UTC](https://forum.inductiveautomation.com/t/translation-manager-don-t-show-item-values-when-filtered/9462 "2020-02-18T15:38:38Z")
Version: Ignition Gateway 7.7.1 (b2014092209) | 64-bit Steps to reproduce the behavior: 1) In the translation manager apply a filter to restrict the number of items. 2) Expand one item having some translations text. 3… --- ## [Insert reportByte into mysql database](https://forum.inductiveautomation.com/t/insert-reportbyte-into-mysql-database/32334)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 1\ **Last updated:** [February 18, 2020, 3:33pm UTC](https://forum.inductiveautomation.com/t/insert-reportbyte-into-mysql-database/32334 "2020-02-18T15:33:05Z")
Hi, In a run script schedule (report module), how can I insert reporBytes in a MySQL database blob column ? Do you have an exemple ? Thanks, --- ## [Determining window size](https://forum.inductiveautomation.com/t/determining-window-size/2525)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 13\ **Last updated:** [February 18, 2020, 3:22pm UTC](https://forum.inductiveautomation.com/t/determining-window-size/2525 "2020-02-18T15:22:43Z")
This thread relates to the one on supporting clients with varying resolutions. We have experimented with various relative and fixed layouts with anchors. These settings are OK for some screen resizing, but some issues … --- ## [Client customized background color](https://forum.inductiveautomation.com/t/client-customized-background-color/32370)
**Author:** [@latifa.rhandour](https://forum.inductiveautomation.com/u/latifa.rhandour)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 2:12pm UTC](https://forum.inductiveautomation.com/t/client-customized-background-color/32370 "2020-02-18T14:12:37Z")
Hello, I am trying to configure a “Dark mode” for a project. I have different users and some prefer having a dark background. I first thought I could bind the background color property to a tag that I will set to the us… --- ## [Voice Notification module compatibility](https://forum.inductiveautomation.com/t/voice-notification-module-compatibility/32372)
**Author:** [@r.lebohec](https://forum.inductiveautomation.com/u/r.lebohec)\ **Replies:** 0\ **Last updated:** [February 18, 2020, 1:53pm UTC](https://forum.inductiveautomation.com/t/voice-notification-module-compatibility/32372 "2020-02-18T13:53:22Z")
Hi Community, We tried to make a test platform with: Voice Notification module Voice TTS (fr\_suzanne) SIP Server (Office SIP Server is open source IM and VoIP server for Windows or Download 60-day Free Trial | Brekeke… --- ## [Socket Time Out](https://forum.inductiveautomation.com/t/socket-time-out/32367)
**Author:** [@nouh.qaoud](https://forum.inductiveautomation.com/u/nouh.qaoud)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 1:29pm UTC](https://forum.inductiveautomation.com/t/socket-time-out/32367 "2020-02-18T13:29:48Z")
Dears I have startup script with socket, when i update script and save project i get error below: " com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Read timed out at com.inductiveautomatio… --- ## [Project \> Script Modules?](https://forum.inductiveautomation.com/t/project-script-modules/32366)
**Author:** [@lachguerabdallah](https://forum.inductiveautomation.com/u/lachguerabdallah)\ **Replies:** 1\ **Last updated:** [February 18, 2020, 12:17pm UTC](https://forum.inductiveautomation.com/t/project-script-modules/32366 "2020-02-18T12:17:28Z")
hello. how can i import a script in ignition 8 can’t i find the “Script Modules” in Project menu --- ## [Force antialiasing for font in Ignition 7.9.12?](https://forum.inductiveautomation.com/t/force-antialiasing-for-font-in-ignition-7-9-12/30534)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [February 18, 2020, 11:58am UTC](https://forum.inductiveautomation.com/t/force-antialiasing-for-font-in-ignition-7-9-12/30534 "2020-02-18T11:58:19Z")
I try to force antialiasing for font in Ignition 7.9.12 (like in Ignition 8.0) (windows 10 client) I’ve added to my launch cmd these flags, but it has no effect ??? -Dawt.useSystemAAFontSettings=on -Dswing.aatext=true … --- ## [TAG reading issue](https://forum.inductiveautomation.com/t/tag-reading-issue/31460)
**Author:** [@Rameshwar.kuthale](https://forum.inductiveautomation.com/u/Rameshwar.kuthale)\ **Replies:** 8\ **Last updated:** [February 18, 2020, 11:48am UTC](https://forum.inductiveautomation.com/t/tag-reading-issue/31460 "2020-02-18T11:48:30Z")
Hello Guys, Iam facing some issues while reading tag from ignition designer v7.9.8 Iam using momentary button on screen,through opc server iam assigning tag to button,Boolean tag,which is already defined in s7-1500 plc… --- ## [Text Alignment & Animation for integer value on button](https://forum.inductiveautomation.com/t/text-alignment-animation-for-integer-value-on-button/31755)
**Author:** [@Rameshwar.kuthale](https://forum.inductiveautomation.com/u/Rameshwar.kuthale)\ **Replies:** 11\ **Last updated:** [February 18, 2020, 11:33am UTC](https://forum.inductiveautomation.com/t/text-alignment-animation-for-integer-value-on-button/31755 "2020-02-18T11:33:06Z")
1)how to do spacing & alignment of texts on normal button. . 2)suppose I have integer tag, for different values I have to set different colours on button iam facing issue because (greater or equal) Expression. for ex… --- ## [Automation Direct Tag Setup Ideas](https://forum.inductiveautomation.com/t/automation-direct-tag-setup-ideas/32355)
**Author:** [@robert1](https://forum.inductiveautomation.com/u/robert1)\ **Replies:** 2\ **Last updated:** [February 18, 2020, 2:49am UTC](https://forum.inductiveautomation.com/t/automation-direct-tag-setup-ideas/32355 "2020-02-18T02:49:47Z")
Hello- I’ve been working with automation direct PLCs (Productivity 3000) along with Ignition HMI now for some time and am quite happy with what I’ve been able to do. I’m working on a new project with relatively simple … --- ## [EasyChart Data Issue](https://forum.inductiveautomation.com/t/easychart-data-issue/32337)
**Author:** [@dkauffman](https://forum.inductiveautomation.com/u/dkauffman)\ **Replies:** 5\ **Last updated:** [February 17, 2020, 8:07pm UTC](https://forum.inductiveautomation.com/t/easychart-data-issue/32337 "2020-02-17T20:07:46Z")
I’m struggling with the Easychart. I have historian data that is this: 3 tags that are totalizers for one piece of equipment at the end of each shift (Shift 1, Shift 2, and Shift 3.) Each of those tags writes at the end … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1207) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1209)