# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=908 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 909 --- ## [Best practice for tag calculating derivative (difference between values at 2 timestamps)](https://forum.inductiveautomation.com/t/best-practice-for-tag-calculating-derivative-difference-between-values-at-2-timestamps/54728)
**Author:** [@djs](https://forum.inductiveautomation.com/u/djs)\ **Replies:** 1\ **Last updated:** [January 6, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/best-practice-for-tag-calculating-derivative-difference-between-values-at-2-timestamps/54728 "2022-01-06T16:03:21Z")
I have tags that are calculating throughput from individual ports on network switches (through Kymera SNMP Driver). The way to calculate throughput is to take the difference of ifInOctets over a period of time and the di… --- ## [Dropdown List Manual Selection in Addition to Scroll!](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700)
**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Replies:** 5\ **Last updated:** [January 6, 2022, 3:24pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-manual-selection-in-addition-to-scroll/54700 "2022-01-06T15:24:05Z")
I have a droplist list whose data source is an SQL table (1 column.) My question is how to give the user the option to start typing in the dropdown list to select the item directly and still have the ability to scroll th… --- ## [MSSQL DB connection on Ignition 8.1](https://forum.inductiveautomation.com/t/mssql-db-connection-on-ignition-8-1/48572)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 12\ **Last updated:** [January 6, 2022, 3:07pm UTC](https://forum.inductiveautomation.com/t/mssql-db-connection-on-ignition-8-1/48572 "2022-01-06T15:07:17Z")
Hi All I’ve been trying to set up a database connection for MSSQL database which is running on an MSSQL 2019 server and end up having faulted connection. I checked the URL, db name, and the user credentials it looks rig… --- ## [Audit log options](https://forum.inductiveautomation.com/t/audit-log-options/14411)
**Author:** [@tom.wouters](https://forum.inductiveautomation.com/u/tom.wouters)\ **Replies:** 5\ **Last updated:** [May 31, 2017, 12:07pm UTC](https://forum.inductiveautomation.com/t/audit-log-options/14411 "2017-05-31T12:07:49Z")
Hello, I have configured my audit profile and everything works. Now I want to add two things to my audit log; I want te computer name added to the table. In the configuration settings at the advanced settings the… --- ## [Convert a string value tag into dateTime](https://forum.inductiveautomation.com/t/convert-a-string-value-tag-into-datetime/54713)
**Author:** [@vani161998](https://forum.inductiveautomation.com/u/vani161998)\ **Replies:** 4\ **Last updated:** [January 6, 2022, 1:01pm UTC](https://forum.inductiveautomation.com/t/convert-a-string-value-tag-into-datetime/54713 "2022-01-06T13:01:30Z")
I have a string value ‘20211228064508000’ in a tag . i want to convert into current date format. I tried to change the data type of tag to Datetime but it didn’t work. Anybody have any solution? --- ## [Error in Log Activity. Logger: ReadArrayTagsRequest](https://forum.inductiveautomation.com/t/error-in-log-activity-logger-readarraytagsrequest/12328)
**Author:** [@casey.myers](https://forum.inductiveautomation.com/u/casey.myers)\ **Replies:** 3\ **Last updated:** [January 6, 2022, 12:57pm UTC](https://forum.inductiveautomation.com/t/error-in-log-activity-logger-readarraytagsrequest/12328 "2022-01-06T12:57:42Z")
Our Ignition Gateway Log Activity, for an Allen-Bradley 1756-L71, is throwing the following error ever second. Nonstop. Does anyone have any ideas as to why it is being thrown? I have tried researching the error, etc.,… --- ## [Manage Perspective app with keyboard only (no touch)](https://forum.inductiveautomation.com/t/manage-perspective-app-with-keyboard-only-no-touch/54717)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 0\ **Last updated:** [January 6, 2022, 11:15am UTC](https://forum.inductiveautomation.com/t/manage-perspective-app-with-keyboard-only-no-touch/54717 "2022-01-06T11:15:27Z")
Hello, i am trying to use the Perspective Android app on a smart signage display. That display has no touch or mouse, so i have to manage the app settings with keyboard only. Is this even possible? I have not found a w… --- ## [Designer error - Cannot create PyString with non-byte value](https://forum.inductiveautomation.com/t/designer-error-cannot-create-pystring-with-non-byte-value/50795)
**Author:** [@michal.ruda](https://forum.inductiveautomation.com/u/michal.ruda)\ **Replies:** 5\ **Last updated:** [November 19, 2021, 3:32pm UTC](https://forum.inductiveautomation.com/t/designer-error-cannot-create-pystring-with-non-byte-value/50795 "2021-11-19T15:32:08Z")
Hi. Can anybody help me with this? I am unable to open any project in the Designer. Thanks. Michal --- ## [How to: Committing project to Git with author and timestamps](https://forum.inductiveautomation.com/t/how-to-committing-project-to-git-with-author-and-timestamps/48662)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 9\ **Last updated:** [January 6, 2022, 11:04am UTC](https://forum.inductiveautomation.com/t/how-to-committing-project-to-git-with-author-and-timestamps/48662 "2022-01-06T11:04:49Z")
I modified the bash script from the best practices guide which has a guide to configuring automatic Git commits on Designer save. I made it so that it adds the author of the change and the timestamp of the change to the … --- ## [How to convert key of array from int to string through scripting](https://forum.inductiveautomation.com/t/how-to-convert-key-of-array-from-int-to-string-through-scripting/54392)
**Author:** [@manjuyadav95.m](https://forum.inductiveautomation.com/u/manjuyadav95.m)\ **Replies:** 5\ **Last updated:** [January 6, 2022, 9:25am UTC](https://forum.inductiveautomation.com/t/how-to-convert-key-of-array-from-int-to-string-through-scripting/54392 "2022-01-06T09:25:51Z")
I want the row key to be displayed as below: \[“Name”, “percentage”, “color”\] below is my code: rows = \[round(value1,2),round(value2,2),round(value3,2),round(value4,2)\] vList = \['Value1','Value2','Value3','Value4'… --- ## [Why is LDAP 'Deleted Objects' is queried?](https://forum.inductiveautomation.com/t/why-is-ldap-deleted-objects-is-queried/18113)
**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\ **Replies:** 1\ **Last updated:** [January 6, 2022, 12:29am UTC](https://forum.inductiveautomation.com/t/why-is-ldap-deleted-objects-is-queried/18113 "2022-01-06T00:29:40Z")
Ever since lifting our AD to 2016 I have been getting a bunch of these warnings. The 'User Search Base' and 'Role Search Base' are set much deeper than DC=Domain,DC=com so I cannot figure out which LDAP filter or settin… --- ## [Ignition gateway not starting up even after reinstalling](https://forum.inductiveautomation.com/t/ignition-gateway-not-starting-up-even-after-reinstalling/54705)
**Author:** [@PREETHAM\_SEVARKODIYO](https://forum.inductiveautomation.com/u/PREETHAM_SEVARKODIYO)\ **Replies:** 0\ **Last updated:** [January 5, 2022, 11:41pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-not-starting-up-even-after-reinstalling/54705 "2022-01-05T23:41:52Z")
HELLO, I HAVE INSTALLED THE IGNITION IN LAPTOP AND THE GATEWAY AND DESIGNER WERE WORKING CORRECTLY. BUT RECENTLY THE DESIGNER WORKS CORRECTLY AND THE GATEWAY IS NOT STARTING UP. I HAVE REINSTALLED THE PROGRAM BUT STILL … --- ## [Better Equipment Schedule events arrangement](https://forum.inductiveautomation.com/t/better-equipment-schedule-events-arrangement/48790)
**Author:** [@miketob](https://forum.inductiveautomation.com/u/miketob)\ **Replies:** 2\ **Last updated:** [January 5, 2022, 10:52pm UTC](https://forum.inductiveautomation.com/t/better-equipment-schedule-events-arrangement/48790 "2022-01-05T22:52:54Z")
Hello, I have an Equipment Schedule component displaying planned orders: And I can switch to view the actual executed orders (with a dropdown list): There are some differences between planned orders and the actu… --- ## [Update Roles from Identity Provider](https://forum.inductiveautomation.com/t/update-roles-from-identity-provider/52730)
**Author:** [@dvaughn](https://forum.inductiveautomation.com/u/dvaughn)\ **Replies:** 3\ **Last updated:** [January 5, 2022, 10:37pm UTC](https://forum.inductiveautomation.com/t/update-roles-from-identity-provider/52730 "2022-01-05T22:37:55Z")
We’re working on a project that is using Auth0 as an OpenID Connect 1.0 Identity Provider and we’re storing the users roles on Auth0. Auth0 is setup to pass the roles with the response object when the user logs in and Ig… --- ## [Invoking event scripts from message handler scripts?](https://forum.inductiveautomation.com/t/invoking-event-scripts-from-message-handler-scripts/54696)
**Author:** [@user69](https://forum.inductiveautomation.com/u/user69)\ **Replies:** 3\ **Last updated:** [January 5, 2022, 10:01pm UTC](https://forum.inductiveautomation.com/t/invoking-event-scripts-from-message-handler-scripts/54696 "2022-01-05T22:01:07Z")
I have a perspective page with a button component whose an “on action performed” event script performs various updates to a backend. The page also has the ​message handler script that populates some dropdown components … --- ## [Linear Gradient colour binding](https://forum.inductiveautomation.com/t/linear-gradient-colour-binding/5820)
**Author:** [@Powerplan](https://forum.inductiveautomation.com/u/Powerplan)\ **Replies:** 9\ **Last updated:** [January 5, 2022, 9:34pm UTC](https://forum.inductiveautomation.com/t/linear-gradient-colour-binding/5820 "2022-01-05T21:34:37Z")
Hi I'd like to be able to dynamically alter the two colours in a Linear Gradient for a rectangle but I can't find a property to bind too, can this be done? Chris --- ## [Can't seem to assign value to (new) variable within IF statement, Syntax Error on Token: 'EQUAL'](https://forum.inductiveautomation.com/t/cant-seem-to-assign-value-to-new-variable-within-if-statement-syntax-error-on-token-equal/54697)
**Author:** [@Jacob\_Sanchez](https://forum.inductiveautomation.com/u/Jacob_Sanchez)\ **Replies:** 7\ **Last updated:** [January 5, 2022, 6:20pm UTC](https://forum.inductiveautomation.com/t/cant-seem-to-assign-value-to-new-variable-within-if-statement-syntax-error-on-token-equal/54697 "2022-01-05T18:20:40Z")
First off, i apologize as i do need to get to reading more and figure these out on my own, but i’m on a mission here so any help is appreciated. This is an expression linked to the background color in a multi state indi… --- ## [SQL Stored Procedure Encapsilation](https://forum.inductiveautomation.com/t/sql-stored-procedure-encapsilation/54692)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 4\ **Last updated:** [January 5, 2022, 5:52pm UTC](https://forum.inductiveautomation.com/t/sql-stored-procedure-encapsilation/54692 "2022-01-05T17:52:44Z")
I’m working a a vendor’s documentation that demonstrates calling a stored procedure in a way that I’m not familiar with. I would like to encapsulate the call in a custom script in the project and then use that script thr… --- ## [Does making graphics into unions increase performance?](https://forum.inductiveautomation.com/t/does-making-graphics-into-unions-increase-performance/54687)
**Author:** [@Yvain17](https://forum.inductiveautomation.com/u/Yvain17)\ **Replies:** 2\ **Last updated:** [January 5, 2022, 5:21pm UTC](https://forum.inductiveautomation.com/t/does-making-graphics-into-unions-increase-performance/54687 "2022-01-05T17:21:48Z")
The project I am working on has many graphics taken from the symbol factory. I am curious if making a graphic into a union would increase performance? A motor graphic, for example, has many shapes and nuances that make i… --- ## [OPC tag not working](https://forum.inductiveautomation.com/t/opc-tag-not-working/54680)
**Author:** [@urvishmehta92](https://forum.inductiveautomation.com/u/urvishmehta92)\ **Replies:** 4\ **Last updated:** [January 5, 2022, 4:19pm UTC](https://forum.inductiveautomation.com/t/opc-tag-not-working/54680 "2022-01-05T16:19:30Z")
Hello Everyone, I am connecting ET200SP to ignition. I created OPC Server on PLC and connection is successful. Few days back I did this process and everything worked fine even today those tags are working but the one I … --- ## [Rename headers dataset](https://forum.inductiveautomation.com/t/rename-headers-dataset/54678)
**Author:** [@indenkleefj](https://forum.inductiveautomation.com/u/indenkleefj)\ **Replies:** 3\ **Last updated:** [January 5, 2022, 3:38pm UTC](https://forum.inductiveautomation.com/t/rename-headers-dataset/54678 "2022-01-05T15:38:11Z")
Does anybody have a way (without loop) to rename the headers of a dataset in a script? --- ## [Kepware endpoint](https://forum.inductiveautomation.com/t/kepware-endpoint/54617)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 1\ **Last updated:** [January 5, 2022, 3:25pm UTC](https://forum.inductiveautomation.com/t/kepware-endpoint/54617 "2022-01-05T15:25:47Z")
I have an opc connection to kepware on one Ignition, I have a second Ignition that I’d like to connect to the same opc server. Question, do I have to create 2 endpoints w/different port no. in Kepware or can I use the s… --- ## [Changing UDT Parent Type](https://forum.inductiveautomation.com/t/changing-udt-parent-type/45825)
**Author:** [@levi\_jacobs](https://forum.inductiveautomation.com/u/levi_jacobs)\ **Replies:** 7\ **Last updated:** [January 5, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/changing-udt-parent-type/45825 "2022-01-05T15:00:06Z")
I’ve noticed in 8.1.3 that I can no longer change the UDT parent type on a UDT instance. Was this an intentional change? (I found this feature very convenient!) I see this entry in the release notes, but i thought it on… --- ## [How to properly copy a list of dictionaries in python?](https://forum.inductiveautomation.com/t/how-to-properly-copy-a-list-of-dictionaries-in-python/54522)
**Author:** [@djs](https://forum.inductiveautomation.com/u/djs)\ **Replies:** 5\ **Last updated:** [January 5, 2022, 1:14pm UTC](https://forum.inductiveautomation.com/t/how-to-properly-copy-a-list-of-dictionaries-in-python/54522 "2022-01-05T13:14:36Z")
I’ve been having trouble with a script and I isolated the issue to the fact that my for loops are somehow modifying an unrelated list (as far as I can tell). I replicated the result with this piece of code: list1 = \[{"k… --- ## [Perspective Mobile App Shortcut Single Instance](https://forum.inductiveautomation.com/t/perspective-mobile-app-shortcut-single-instance/54672)
**Author:** [@matthew.ayre](https://forum.inductiveautomation.com/u/matthew.ayre)\ **Replies:** 0\ **Last updated:** [January 5, 2022, 12:41pm UTC](https://forum.inductiveautomation.com/t/perspective-mobile-app-shortcut-single-instance/54672 "2022-01-05T12:41:04Z")
On the Perspective mobile app when using the ‘launcher’ it will open the same instance if one was launched previously. However, if you create a shortcut of the project, it will always create a new instance. Sometimes thi… --- ## [Calculated roster throwing an error](https://forum.inductiveautomation.com/t/calculated-roster-throwing-an-error/54600)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 9\ **Last updated:** [January 5, 2022, 9:22am UTC](https://forum.inductiveautomation.com/t/calculated-roster-throwing-an-error/54600 "2022-01-05T09:22:09Z")
Hello all, Happy New Year! :tada: I am trying to use an alarm event property when using a calculated roster, the script is: value = event\[“propertyname”\] data = system.db.runPrepQuery("query") for row in dat… --- ## [Locked out of local gateway](https://forum.inductiveautomation.com/t/locked-out-of-local-gateway/44385)
**Author:** [@indra.biswas](https://forum.inductiveautomation.com/u/indra.biswas)\ **Replies:** 12\ **Last updated:** [January 5, 2022, 2:57am UTC](https://forum.inductiveautomation.com/t/locked-out-of-local-gateway/44385 "2022-01-05T02:57:36Z")
I restored a backup from a customer site gateway locally as I overwrote some windows accidentally. However I cannot login to it locally as the local gateway cannot verify my login info. Reason being Active Directory aut… --- ## [Export Project with Scripting](https://forum.inductiveautomation.com/t/export-project-with-scripting/54664)
**Author:** [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Replies:** 4\ **Last updated:** [January 4, 2022, 11:30pm UTC](https://forum.inductiveautomation.com/t/export-project-with-scripting/54664 "2022-01-04T23:30:16Z")
Is there any way to export a project as a .zip file from a script? I poked around in the javaDocs but I couldn’t really decipher anything that was what I was looking for. Basically I’d like to replicate the export from … --- ## [Perspective view params in embedded table row](https://forum.inductiveautomation.com/t/perspective-view-params-in-embedded-table-row/49559)
**Author:** [@csanchez](https://forum.inductiveautomation.com/u/csanchez)\ **Replies:** 6\ **Last updated:** [January 4, 2022, 10:21pm UTC](https://forum.inductiveautomation.com/t/perspective-view-params-in-embedded-table-row/49559 "2022-01-04T22:21:26Z")
Hello, im using a embedded view in a table to display an alarmar in a row, each row has a diferente value that chanche a text field and a background image depending on a view’s value params. theese are the view pictur… --- ## [Missing tag change?](https://forum.inductiveautomation.com/t/missing-tag-change/54658)
**Author:** [@AlexZanduR](https://forum.inductiveautomation.com/u/AlexZanduR)\ **Replies:** 2\ **Last updated:** [January 4, 2022, 9:50pm UTC](https://forum.inductiveautomation.com/t/missing-tag-change/54658 "2022-01-04T21:50:19Z")
Stuck with an issue that that could be related to a multitude of things, so was looking for some insight in my inexperience. I have an event script set to run when a Boolean tag changes value (indicating quality test pa… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=907) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=909)