# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1287 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1288 --- ## [Square root function sqrt() in script](https://forum.inductiveautomation.com/t/square-root-function-sqrt-in-script/39299)
**Author:** [@deforder](https://forum.inductiveautomation.com/u/deforder)\ **Replies:** 6\ **Last updated:** [October 2, 2020, 6:57pm UTC](https://forum.inductiveautomation.com/t/square-root-function-sqrt-in-script/39299 "2020-10-02T18:57:41Z")
How to correctly include and run the square root function in scripts? I try import math print math.sqrt(4) but obtain AttributeError: ‘com.inductiveautomation.ignition.designer.gui.tool’ object has no attribute ‘sqr… --- ## [Perspective - PyODBC installation](https://forum.inductiveautomation.com/t/perspective-pyodbc-installation/39323)
**Author:** [@luc.martin](https://forum.inductiveautomation.com/u/luc.martin)\ **Replies:** 1\ **Last updated:** [October 2, 2020, 6:46pm UTC](https://forum.inductiveautomation.com/t/perspective-pyodbc-installation/39323 "2020-10-02T18:46:31Z")
I have to connect to a database with an ODBC connector. I know pyODBC but not sure how can I install it in Ignition. Any suggestion for ODBC connection will be appreciated. --- ## [What is the standard way to create info page in status section? React or NamedPanel](https://forum.inductiveautomation.com/t/what-is-the-standard-way-to-create-info-page-in-status-section-react-or-namedpanel/39314)
**Author:** [@mpervaiz](https://forum.inductiveautomation.com/u/mpervaiz)\ **Replies:** 3\ **Last updated:** [October 2, 2020, 6:01pm UTC](https://forum.inductiveautomation.com/t/what-is-the-standard-way-to-create-info-page-in-status-section-react-or-namedpanel/39314 "2020-10-02T18:01:15Z")
I am developing a new module for ignition and want to put some results and information on a page. I noticed in the inductiveautomation git that there is a React way of doing it, but then I noticed that ignition is built … --- ## [New DB Table Historian Info](https://forum.inductiveautomation.com/t/new-db-table-historian-info/39320)
**Author:** [@nickboratyn](https://forum.inductiveautomation.com/u/nickboratyn)\ **Replies:** 0\ **Last updated:** [October 2, 2020, 5:45pm UTC](https://forum.inductiveautomation.com/t/new-db-table-historian-info/39320 "2020-10-02T17:45:43Z")
I see that there is a new tag historian tag provider called DB Table Historian which is new in ignition 8.1. I think this could be useful in querying data from other system to get data. My question is how do you set it u… --- ## [Named query from multiple datasources](https://forum.inductiveautomation.com/t/named-query-from-multiple-datasources/39319)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 1\ **Last updated:** [October 2, 2020, 5:42pm UTC](https://forum.inductiveautomation.com/t/named-query-from-multiple-datasources/39319 "2020-10-02T17:42:37Z")
Is it possible to to have named query that gets data from more than 1 datasource/gateway database? Do I just need to explicitly specify the datasource name in front of the table name? If this is not possible, what the b… --- ## [Very high CPU and Ram usage on 7.8 - troubleshooting help?](https://forum.inductiveautomation.com/t/very-high-cpu-and-ram-usage-on-7-8-troubleshooting-help/39316)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [October 2, 2020, 5:25pm UTC](https://forum.inductiveautomation.com/t/very-high-cpu-and-ram-usage-on-7-8-troubleshooting-help/39316 "2020-10-02T17:25:28Z")
I have a system running on 7.8.4 that is experiencing clients locking up ie needing a to alt+cntrl+delete out of the screen, and a gateway that is sometimes showing over 100% usage like this It seems like the gateway … --- ## [Nightly 8.0 Changelogs - 2020](https://forum.inductiveautomation.com/t/nightly-8-0-changelogs-2020/31153)
**Author:** [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\ **Replies:** 132\ **Last updated:** [October 2, 2020, 5:04pm UTC](https://forum.inductiveautomation.com/t/nightly-8-0-changelogs-2020/31153 "2020-10-02T17:04:58Z")
This post contains changelog entries for nightly builds available in 2020. Previous change logs can be found here: Nightly Changelogs - 2019 --- ## [Gateway timer script - calling a function within a function - global not defined error](https://forum.inductiveautomation.com/t/gateway-timer-script-calling-a-function-within-a-function-global-not-defined-error/39313)
**Author:** [@rpavlicek](https://forum.inductiveautomation.com/u/rpavlicek)\ **Replies:** 3\ **Last updated:** [October 2, 2020, 4:14pm UTC](https://forum.inductiveautomation.com/t/gateway-timer-script-calling-a-function-within-a-function-global-not-defined-error/39313 "2020-10-02T16:14:17Z")
Is it possible to call a function within a function inside a Gateway timer script? I can run the same script in the script console, but in the gateway timer, I get the error “global name ‘doThis’ not defined”. For exam… --- ## [Perspective: Tablet keyboard is not showing when used from a web browser](https://forum.inductiveautomation.com/t/perspective-tablet-keyboard-is-not-showing-when-used-from-a-web-browser/39308)
**Author:** [@francois.morin](https://forum.inductiveautomation.com/u/francois.morin)\ **Replies:** 2\ **Last updated:** [October 2, 2020, 4:00pm UTC](https://forum.inductiveautomation.com/t/perspective-tablet-keyboard-is-not-showing-when-used-from-a-web-browser/39308 "2020-10-02T16:00:30Z")
Hello, I have a perspective application opening a popup to enter quality information (numeric and text fields). The numeric and text fields do open the Android Onscreen Keyboard to enter values when the project is run … --- ## [Does system.gui.transform have specific graphics card requirements?](https://forum.inductiveautomation.com/t/does-system-gui-transform-have-specific-graphics-card-requirements/39292)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 2\ **Last updated:** [October 2, 2020, 3:38pm UTC](https://forum.inductiveautomation.com/t/does-system-gui-transform-have-specific-graphics-card-requirements/39292 "2020-10-02T15:38:01Z")
Good evening, I have a system using system.gui.transform extensively. Every once in a seemingly random while the components being called by system.gui.transform will all go black when acted upon by some event. This seem… --- ## [Disable alarms for user-defined time](https://forum.inductiveautomation.com/t/disable-alarms-for-user-defined-time/38895)
**Author:** [@eessig](https://forum.inductiveautomation.com/u/eessig)\ **Replies:** 14\ **Last updated:** [October 2, 2020, 3:20pm UTC](https://forum.inductiveautomation.com/t/disable-alarms-for-user-defined-time/38895 "2020-10-02T15:20:13Z")
Hi, Is there a way to essentially shelve an alarm in perspective before it occurs or disable an alarm for a user-defined time? The idea is that the customer may be performing maintenance and they want to disable alarms, … --- ## [Theming Variables Reference View](https://forum.inductiveautomation.com/t/theming-variables-reference-view/39243)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [October 2, 2020, 3:08pm UTC](https://forum.inductiveautomation.com/t/theming-variables-reference-view/39243 "2020-10-02T15:08:12Z")
@ray I love the idea of this, however it would be awesome to actually retrieve a list of all of the CSS variables from the relevant selected theme and dynamically show them on the View with a flex repeater/table. I d… --- ## [Ignition update to 8.1.0RC1 License become trial](https://forum.inductiveautomation.com/t/ignition-update-to-8-1-0rc1-license-become-trial/39300)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 8\ **Last updated:** [October 2, 2020, 2:33pm UTC](https://forum.inductiveautomation.com/t/ignition-update-to-8-1-0rc1-license-become-trial/39300 "2020-10-02T14:33:37Z")
before only the perspective module is trial , but after update, all the inductive license become trial , any one have the same issue? --- ## [Audit log space requirements](https://forum.inductiveautomation.com/t/audit-log-space-requirements/39303)
**Author:** [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\ **Replies:** 1\ **Last updated:** [October 2, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/audit-log-space-requirements/39303 "2020-10-02T14:05:44Z")
I just created an Internal Audit log. Do I need to worry about the space required on disk? --- ## [Tag limit for OPC UA Device](https://forum.inductiveautomation.com/t/tag-limit-for-opc-ua-device/39305)
**Author:** [@Gareth.Hewetson](https://forum.inductiveautomation.com/u/Gareth.Hewetson)\ **Replies:** 8\ **Last updated:** [October 2, 2020, 2:00pm UTC](https://forum.inductiveautomation.com/t/tag-limit-for-opc-ua-device/39305 "2020-10-02T14:00:19Z")
What is the maximum number of tags that can be imported for a single OPC UA device? I’m only able to import 644 tags per device. Can anyone confirm that this is correct? --- ## [Maximum number of alarms at one time?](https://forum.inductiveautomation.com/t/maximum-number-of-alarms-at-one-time/39304)
**Author:** [@twstevic](https://forum.inductiveautomation.com/u/twstevic)\ **Replies:** 0\ **Last updated:** [October 2, 2020, 1:22pm UTC](https://forum.inductiveautomation.com/t/maximum-number-of-alarms-at-one-time/39304 "2020-10-02T13:22:23Z")
Does the Alarm subsystem have a maximum number of alarms it can process at one time? While testing a project, if I hit Ignition with 4800 alarms, some times the alarm system misses complete DINTs, and other ones it simpl… --- ## [Tag binding cross-reference](https://forum.inductiveautomation.com/t/tag-binding-cross-reference/6340)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 3\ **Last updated:** [October 2, 2020, 10:47am UTC](https://forum.inductiveautomation.com/t/tag-binding-cross-reference/6340 "2020-10-02T10:47:42Z")
Several times I've wanted to delete a tag, but haven't been sure if it's used in any tag bindings anywhere. It would be nice to have an option to highlight a tag and find where it's been used. Even if it's just a text li… --- ## [Scrollbar in popup will not go away](https://forum.inductiveautomation.com/t/scrollbar-in-popup-will-not-go-away/26616)
**Author:** [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\ **Replies:** 2\ **Last updated:** [October 2, 2020, 10:27am UTC](https://forum.inductiveautomation.com/t/scrollbar-in-popup-will-not-go-away/26616 "2020-10-02T10:27:08Z")
Above is a screenshot of what I’m talking about. I have this container that I want as a popup which has nothing but an XY Chart inside of it. No matter what, I cannot get rid of the useless scrollbar on the right. I’v… --- ## [Gateway starting time](https://forum.inductiveautomation.com/t/gateway-starting-time/39297)
**Author:** [@federico.furlani](https://forum.inductiveautomation.com/u/federico.furlani)\ **Replies:** 0\ **Last updated:** [October 2, 2020, 7:21am UTC](https://forum.inductiveautomation.com/t/gateway-starting-time/39297 "2020-10-02T07:21:32Z")
Hi there, I moved from Ignition 8.0.16 to 8.1. Tried 8.1.0 RC1, RC2 and 8.1.1 nightly. With these versions, gateway takes about 15/20 minutes in starting procedure. Previously, with 8.0.16, this time was less than 2 mi… --- ## [Good day! How to convert date strings to Int? Thank you](https://forum.inductiveautomation.com/t/good-day-how-to-convert-date-strings-to-int-thank-you/39255)
**Author:** [@vincent.canda](https://forum.inductiveautomation.com/u/vincent.canda)\ **Replies:** 5\ **Last updated:** [October 2, 2020, 6:58am UTC](https://forum.inductiveautomation.com/t/good-day-how-to-convert-date-strings-to-int-thank-you/39255 "2020-10-02T06:58:41Z")
How to convert unicode to int? I have a scenario i want to get the difference between 2 date. Example my date format is: a = 10/01/2020 b= 10/01/2020 print a - b I want to get the value 0 Reference: --- ## [Adding custom components to alarm status table - Perspective](https://forum.inductiveautomation.com/t/adding-custom-components-to-alarm-status-table-perspective/39219)
**Author:** [@cleye.jensen](https://forum.inductiveautomation.com/u/cleye.jensen)\ **Replies:** 3\ **Last updated:** [October 2, 2020, 5:22am UTC](https://forum.inductiveautomation.com/t/adding-custom-components-to-alarm-status-table-perspective/39219 "2020-10-02T05:22:22Z")
Is it possible to embed a Perspective component as a column in an alarm status table? This screenshot is an example of what I’d like to achieve; for each alarm there should be a button in one of the columns which can … --- ## [Twilio "double dips"](https://forum.inductiveautomation.com/t/twilio-double-dips/39291)
**Author:** [@thowsham](https://forum.inductiveautomation.com/u/thowsham)\ **Replies:** 1\ **Last updated:** [October 2, 2020, 1:37am UTC](https://forum.inductiveautomation.com/t/twilio-double-dips/39291 "2020-10-02T01:37:54Z")
I have Twilio working. BUT when I restore a backup onto my work PC from my development PC I get TWICE the messages sent to my phone when both PCs are running and only 1 set of messages when 1 PC runs. Am I doing somethi… --- ## [Table schema in transaction group target](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151)
**Author:** [@zacht](https://forum.inductiveautomation.com/u/zacht)\ **Replies:** 3\ **Last updated:** [October 1, 2020, 10:07pm UTC](https://forum.inductiveautomation.com/t/table-schema-in-transaction-group-target/39151 "2020-10-01T22:07:01Z")
Can you specify table schema like this in a transaction group? This group is full of hour meters. If I stop and start the group, it will read initial values from the table like I expect, but then when it executes it d… --- ## [Gateway tag change script - previous value not available](https://forum.inductiveautomation.com/t/gateway-tag-change-script-previous-value-not-available/27055)
**Author:** [@CraigP](https://forum.inductiveautomation.com/u/CraigP)\ **Replies:** 4\ **Last updated:** [October 1, 2020, 9:36pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-script-previous-value-not-available/27055 "2020-10-01T21:36:42Z")
In tag event scripts, previousValue is available in the valueChanged event function but it doesn’t appear to be available in a gateway event tag change script. Is there a way to get the previous value from there? Versio… --- ## [Non-SCADA Applications of Ignition](https://forum.inductiveautomation.com/t/non-scada-applications-of-ignition/7967)
**Author:** [@Tommy\_Austin](https://forum.inductiveautomation.com/u/Tommy_Austin)\ **Replies:** 11\ **Last updated:** [October 1, 2020, 8:44pm UTC](https://forum.inductiveautomation.com/t/non-scada-applications-of-ignition/7967 "2020-10-01T20:44:54Z")
I'm looking for examples of non-SCADA and non-control system applications of Ignition. For example, point-of-sale systems, or church related, or recreational and sports related, etc... --- ## [Python 'Sets' in Ignition](https://forum.inductiveautomation.com/t/python-sets-in-ignition/39283)
**Author:** [@Chris.Hawkey](https://forum.inductiveautomation.com/u/Chris.Hawkey)\ **Replies:** 4\ **Last updated:** [October 1, 2020, 8:38pm UTC](https://forum.inductiveautomation.com/t/python-sets-in-ignition/39283 "2020-10-01T20:38:45Z")
Hello, I am attempting to verify that a system.tag.writeBlocking function successfully wrote to every tag in the list. It works on one of my scripts that was writing to 50+ tags, but i wrote a similiar script (with onl… --- ## [Windows 10 or Server](https://forum.inductiveautomation.com/t/windows-10-or-server/39281)
**Author:** [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\ **Replies:** 1\ **Last updated:** [October 1, 2020, 7:13pm UTC](https://forum.inductiveautomation.com/t/windows-10-or-server/39281 "2020-10-01T19:13:47Z")
I am planning to buy a small Ignition server for a customer. They will be using 2-3 clients and have probably less than 2000 tags. I am looking at either a small server class machine (Dell) or a higher end desktop mach… --- ## [Visibility through QualityCode](https://forum.inductiveautomation.com/t/visibility-through-qualitycode/39275)
**Author:** [@luis.2aw](https://forum.inductiveautomation.com/u/luis.2aw)\ **Replies:** 1\ **Last updated:** [October 1, 2020, 7:05pm UTC](https://forum.inductiveautomation.com/t/visibility-through-qualitycode/39275 "2020-10-01T19:05:46Z")
good afternoon. A question, I want to set the visibility condition based on QualityCode, to be invisible when: “Error\_Configuration”. I’m using {Root Container.Numeric Label 5.quality} = “Error\_Configuration” but it do… --- ## [How to write to memory tag based on value of another tag?](https://forum.inductiveautomation.com/t/how-to-write-to-memory-tag-based-on-value-of-another-tag/39264)
**Author:** [@matthew.tomlinson](https://forum.inductiveautomation.com/u/matthew.tomlinson)\ **Replies:** 11\ **Last updated:** [October 1, 2020, 6:56pm UTC](https://forum.inductiveautomation.com/t/how-to-write-to-memory-tag-based-on-value-of-another-tag/39264 "2020-10-01T18:56:53Z")
Hello! What I’m trying to do is take an integer value of 0-100 that is outputted by a tag (Moisture). Then compare that value with a static number to see if it is below 30. If it is below 30, make the memory tag (Pump) … --- ## [Gateway log flooded with StoreAndForward.Sink.HsqlDataStore Errors](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234)
**Author:** [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Replies:** 7\ **Last updated:** [October 1, 2020, 6:29pm UTC](https://forum.inductiveautomation.com/t/gateway-log-flooded-with-storeandforward-sink-hsqldatastore-errors/39234 "2020-10-01T18:29:34Z")
My gateway log is flooded with these errors and I cannot find what is causing them. Error deserializing data from data store. java.lang.ClassCastException: cannot assign instance of com.inductiveautomation.ignition.com… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1286) [Next page](https://forum.inductiveautomation.com/latest.md?page=1288)