# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1312 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1313 --- ## [How to get the last alarm?](https://forum.inductiveautomation.com/t/how-to-get-the-last-alarm/23014)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 2\ **Last updated:** [March 2, 2019, 6:27pm UTC](https://forum.inductiveautomation.com/t/how-to-get-the-last-alarm/23014 "2019-03-02T18:27:53Z")
How can I get the last (by time) occurred Unack and Active or Ack and Active alarm from system.alarm.queryStatus function? I want to display in the label the time and the text(name or label) only of the last alarm… --- ## [Convert string column to Datetime](https://forum.inductiveautomation.com/t/convert-string-column-to-datetime/23013)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [March 2, 2019, 4:40pm UTC](https://forum.inductiveautomation.com/t/convert-string-column-to-datetime/23013 "2019-03-02T16:40:33Z")
I am retrieving certain data from 3rd party scada system using below query and need to added data set results to charts in ignition . The problem is the datetime column is coming as string not as data time format as p… --- ## [Convert dataset column values from string to integer](https://forum.inductiveautomation.com/t/convert-dataset-column-values-from-string-to-integer/10886)
**Author:** [@framebuilder](https://forum.inductiveautomation.com/u/framebuilder)\ **Replies:** 20\ **Last updated:** [March 2, 2019, 4:12pm UTC](https://forum.inductiveautomation.com/t/convert-dataset-column-values-from-string-to-integer/10886 "2019-03-02T16:12:54Z")
Hi everyone, I have a dataset with two columns. Column1 has string values that I need to convert into integers in order to use both columns on a chart. Is this possible? I was thinking about creating a Custom Propert… --- ## [Reg Port 4445 and 4446](https://forum.inductiveautomation.com/t/reg-port-4445-and-4446/22916)
**Author:** [@harigobu.gb](https://forum.inductiveautomation.com/u/harigobu.gb)\ **Replies:** 5\ **Last updated:** [March 2, 2019, 7:30am UTC](https://forum.inductiveautomation.com/t/reg-port-4445-and-4446/22916 "2019-03-02T07:30:23Z")
Hi, In online manual (https://docs.inductiveautomation.com/display/DOC79/Advanced+Gateway+Settings), Advanced Gateway Setting page it was listed that port 4445 & 4446 will be required to open. Wanted to understand the… --- ## [EasyChart display issue with "digital area"](https://forum.inductiveautomation.com/t/easychart-display-issue-with-digital-area/22976)
**Author:** [@richard.d.white](https://forum.inductiveautomation.com/u/richard.d.white)\ **Replies:** 2\ **Last updated:** [March 1, 2019, 11:09pm UTC](https://forum.inductiveautomation.com/t/easychart-display-issue-with-digital-area/22976 "2019-03-01T23:09:13Z")
I am having issues with simply displaying digital status in EasyChart. We would like to have a full bar to represent an ON state and no bar at all when there is an OFF state. Changes are very infrequent so we may have … --- ## [History not being logged consistently](https://forum.inductiveautomation.com/t/history-not-being-logged-consistently/23004)
**Author:** [@1jeffwill11](https://forum.inductiveautomation.com/u/1jeffwill11)\ **Replies:** 0\ **Last updated:** [March 1, 2019, 7:55pm UTC](https://forum.inductiveautomation.com/t/history-not-being-logged-consistently/23004 "2019-03-01T19:55:07Z")
I am currently having an issue where the historian is not logging the data from tags consistently. I noticed this when some easy charts started to have spaces in the tag pens. I am not sure how to address this problem at… --- ## [Binding Script Value(Float) to Numeric Text Box](https://forum.inductiveautomation.com/t/binding-script-value-float-to-numeric-text-box/22998)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 2\ **Last updated:** [March 1, 2019, 7:00pm UTC](https://forum.inductiveautomation.com/t/binding-script-value-float-to-numeric-text-box/22998 "2019-03-01T19:00:46Z")
I have a script that adds a column and calculate the Average, How do I bind this value(Avg) to a numeric text box. I have looked all over and watched several videos but still can’t figure it out. Thanks --- ## [Error code 13 license activation](https://forum.inductiveautomation.com/t/error-code-13-license-activation/23001)
**Author:** [@jquintero](https://forum.inductiveautomation.com/u/jquintero)\ **Replies:** 2\ **Last updated:** [March 1, 2019, 6:57pm UTC](https://forum.inductiveautomation.com/t/error-code-13-license-activation/23001 "2019-03-01T18:57:57Z")
Hello friends We are trying to activate an ignition license and this error message appear. License file “data\\license.ipl” does not match host system. and then this message error message appears Activation request fa… --- ## [Dataset in tag expresion in fault](https://forum.inductiveautomation.com/t/dataset-in-tag-expresion-in-fault/22996)
**Author:** [@GeraGarcia](https://forum.inductiveautomation.com/u/GeraGarcia)\ **Replies:** 4\ **Last updated:** [March 1, 2019, 5:27pm UTC](https://forum.inductiveautomation.com/t/dataset-in-tag-expresion-in-fault/22996 "2019-03-01T17:27:45Z")
hello I have a tag of which I have a split, of this tag I want to make another tag with a part of the split and the tag is in fault, how do you handle a tag when it is a dataset? this is my expresion i find this with th… --- ## [Cache project in client PC to decrease startup time](https://forum.inductiveautomation.com/t/cache-project-in-client-pc-to-decrease-startup-time/22991)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 0\ **Last updated:** [March 1, 2019, 2:37pm UTC](https://forum.inductiveautomation.com/t/cache-project-in-client-pc-to-decrease-startup-time/22991 "2019-03-01T14:37:17Z")
Hello, In some cases the network between Gateway and client is not fast so for each time the client open, it has to download the entire project from gateway. Is it possible to so how cache or save the project in client… --- ## [Modbus TCP driver to RS485 Device](https://forum.inductiveautomation.com/t/modbus-tcp-driver-to-rs485-device/22194)
**Author:** [@Special\_tec](https://forum.inductiveautomation.com/u/Special_tec)\ **Replies:** 12\ **Last updated:** [March 1, 2019, 2:55pm UTC](https://forum.inductiveautomation.com/t/modbus-tcp-driver-to-rs485-device/22194 "2019-03-01T14:55:25Z")
I am trying to replicate the modbus enquiry in the image and would like to know how to add this request in MODBUS TCP driver. I am attempting to send this request via a TCP driver to a MOXA 3280 and ten on through sla… --- ## [Pre-processing](https://forum.inductiveautomation.com/t/pre-processing/4444)
**Author:** [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Replies:** 4\ **Last updated:** [March 1, 2019, 8:14am UTC](https://forum.inductiveautomation.com/t/pre-processing/4444 "2019-03-01T08:14:03Z")
pre-processing Does anyone use this? What are pros and cons? Please explain the window sizes. What this does in the database. How queries are affected. --- ## [Error while executing a script is not showing up. 7.9.8](https://forum.inductiveautomation.com/t/error-while-executing-a-script-is-not-showing-up-7-9-8/22982)
**Author:** [@venkatuic15](https://forum.inductiveautomation.com/u/venkatuic15)\ **Replies:** 1\ **Last updated:** [March 1, 2019, 1:23am UTC](https://forum.inductiveautomation.com/t/error-while-executing-a-script-is-not-showing-up-7-9-8/22982 "2019-03-01T01:23:25Z")
Error while executing a script is not showing up. So it makes it so difficult to troubleshoot. We need to add print statements everywhere in the code to debug the code. Is there a fix for this issue ? --- ## [Error INSERTing data into SQL table: Conversion from UNKNOWN to UNKNOWN unsupported](https://forum.inductiveautomation.com/t/error-inserting-data-into-sql-table-conversion-from-unknown-to-unknown-unsupported/22960)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 5\ **Last updated:** [February 28, 2019, 10:36pm UTC](https://forum.inductiveautomation.com/t/error-inserting-data-into-sql-table-conversion-from-unknown-to-unknown-unsupported/22960 "2019-02-28T22:36:51Z")
I’m getting the below exception error when my script is attempting to execute the line: system.db.runPrepUpdate(INSERT INTO datSeqLogData (seq\_logs\_id, tag\_id, val\_int, logged\_datetime) VALUES (?, ?, ?, ?), \[5285, 1190,… --- ## [Error Java Heap Size(maxmemory set at 16gb)](https://forum.inductiveautomation.com/t/error-java-heap-size-maxmemory-set-at-16gb/22980)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 5\ **Last updated:** [February 28, 2019, 9:41pm UTC](https://forum.inductiveautomation.com/t/error-java-heap-size-maxmemory-set-at-16gb/22980 "2019-02-28T21:41:29Z")
Hello, I’ve been having this error for sometime now when i open one of my windows. i will try to be as detailed as possible so please read on. and thanks in advance I press a push button to open a new window should ope… --- ## [How to make an HOA Pop UP](https://forum.inductiveautomation.com/t/how-to-make-an-hoa-pop-up/22973)
**Author:** [@bchristenson](https://forum.inductiveautomation.com/u/bchristenson)\ **Replies:** 13\ **Last updated:** [February 28, 2019, 7:10pm UTC](https://forum.inductiveautomation.com/t/how-to-make-an-hoa-pop-up/22973 "2019-02-28T19:10:31Z")
Hi, We our still getting to know ignition and one of the big things we want to be able to do before we purchase it is know if we can make a HOA (Hand, Off, Auto) Pop Up for multiple buttons? So i was able to make a pop… --- ## [Activate an Ignition CD-KEY for a third-party module - activation failed. \[code=15, message="Edition Mismatch"\]](https://forum.inductiveautomation.com/t/activate-an-ignition-cd-key-for-a-third-party-module-activation-failed-code-15-message-edition-mismatch/22961)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 4\ **Last updated:** [February 28, 2019, 7:37pm UTC](https://forum.inductiveautomation.com/t/activate-an-ignition-cd-key-for-a-third-party-module-activation-failed-code-15-message-edition-mismatch/22961 "2019-02-28T19:37:41Z")
Hi, When I try to activate an Ignition CD-KEY for a third-party module for Ignition 7.9.9, I have the following error : Error: Activation failed. \[code=15, message=“Edition Mismatch”\] Same error returned in case of on… --- ## [Create dataset and assign to table data](https://forum.inductiveautomation.com/t/create-dataset-and-assign-to-table-data/22948)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 18\ **Last updated:** [February 28, 2019, 6:12pm UTC](https://forum.inductiveautomation.com/t/create-dataset-and-assign-to-table-data/22948 "2019-02-28T18:12:42Z")
I’m just trying to create some sample data for a Table. Won’t this create a Dataset - Titled DP? (with just 5 rows of data) headers = \[“Date”, “Barrels”\] Then create an empty list, this will house our data. data = \[\] … --- ## [Export csv data to sql server](https://forum.inductiveautomation.com/t/export-csv-data-to-sql-server/22954)
**Author:** [@mavallejo](https://forum.inductiveautomation.com/u/mavallejo)\ **Replies:** 2\ **Last updated:** [February 28, 2019, 4:22pm UTC](https://forum.inductiveautomation.com/t/export-csv-data-to-sql-server/22954 "2019-02-28T16:22:12Z")
Hello everyone, Somebody can help how can I read information into de CSV file adn to save data in sql server?, is there a ignition code that you can provide me ? is there a scripting that you can provide me? thanks in… --- ## [Script Built Dataset Scan Class Problem](https://forum.inductiveautomation.com/t/script-built-dataset-scan-class-problem/22963)
**Author:** [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Replies:** 0\ **Last updated:** [February 28, 2019, 1:11pm UTC](https://forum.inductiveautomation.com/t/script-built-dataset-scan-class-problem/22963 "2019-02-28T13:11:12Z")
My project has a “Well” tag template which holds all associated well tags, There are also a few dataset tags under the Well tag template. I’m running into an issue when I make a change to a “Well” tag that the datasets d… --- ## [Faulted ignition gateway](https://forum.inductiveautomation.com/t/faulted-ignition-gateway/22908)
**Author:** [@johnson.jumaquio](https://forum.inductiveautomation.com/u/johnson.jumaquio)\ **Replies:** 3\ **Last updated:** [February 28, 2019, 12:47am UTC](https://forum.inductiveautomation.com/t/faulted-ignition-gateway/22908 "2019-02-28T00:47:41Z")
how can I resolve this problem about faulted gateway. it’s a re-installed ignition but the gateway says faulted STATUS | wrapper | 2019/02/27 14:00:26 | --\> Wrapper Started as Service STATUS | wrapper | 2019/02/27 14:… --- ## [httpGet vs. urllib2 slow at fetching data from the web](https://forum.inductiveautomation.com/t/httpget-vs-urllib2-slow-at-fetching-data-from-the-web/22953)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 2\ **Last updated:** [February 27, 2019, 11:53pm UTC](https://forum.inductiveautomation.com/t/httpget-vs-urllib2-slow-at-fetching-data-from-the-web/22953 "2019-02-27T23:53:11Z")
Can anyone tell me why urllib2.urlopen takes so long to fetch file/binary data from a website while system.net.httpGet fetches data quickly. I’m talking apples vs. oranges here because httpGet doesn’t work well with bin… --- ## [Is it wise to use dataset tags for storing file 'blob' data vs storing in SQL?](https://forum.inductiveautomation.com/t/is-it-wise-to-use-dataset-tags-for-storing-file-blob-data-vs-storing-in-sql/22900)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 11\ **Last updated:** [February 27, 2019, 11:41pm UTC](https://forum.inductiveautomation.com/t/is-it-wise-to-use-dataset-tags-for-storing-file-blob-data-vs-storing-in-sql/22900 "2019-02-27T23:41:24Z")
I am hoping someone can share their expertise on the recommended or best practice in terms of saving data. I currently utilize a dataset type memory tag to store user uploadable files…one is an image of the instrument (… --- ## [Property for storing ID in Tag](https://forum.inductiveautomation.com/t/property-for-storing-id-in-tag/22950)
**Author:** [@fady.machaalani](https://forum.inductiveautomation.com/u/fady.machaalani)\ **Replies:** 2\ **Last updated:** [February 27, 2019, 10:36pm UTC](https://forum.inductiveautomation.com/t/property-for-storing-id-in-tag/22950 "2019-02-27T22:36:05Z")
I have the need to create a Unique ID for each Tag that I am using. In my code, I have iterated through each TagProp that is available and I need to figure out which attribute I can use to store an ID. Is there already… --- ## [Popup Title Bar Question](https://forum.inductiveautomation.com/t/popup-title-bar-question/22946)
**Author:** [@ericlabounty](https://forum.inductiveautomation.com/u/ericlabounty)\ **Replies:** 1\ **Last updated:** [February 27, 2019, 8:55pm UTC](https://forum.inductiveautomation.com/t/popup-title-bar-question/22946 "2019-02-27T20:55:14Z")
Hello, I am new to Ignition and have a question about using the close button on a Popup Title Bar. When the Close Button is pressed on the Title Bar, is there a way of turning off a Boolean? I have looked through the … --- ## [propertyChange Event Executes on Form Load](https://forum.inductiveautomation.com/t/propertychange-event-executes-on-form-load/22942)
**Author:** [@mwolter](https://forum.inductiveautomation.com/u/mwolter)\ **Replies:** 3\ **Last updated:** [February 27, 2019, 7:20pm UTC](https://forum.inductiveautomation.com/t/propertychange-event-executes-on-form-load/22942 "2019-02-27T19:20:36Z")
I have the following code on the propertyChange event of a dropdown box and it executes on form load. I only want it to execute when the selected value changes. I’m new to Ignition, so any help would be appreciated, Th… --- ## [Getting mobile screen size data](https://forum.inductiveautomation.com/t/getting-mobile-screen-size-data/7339)
**Author:** [@mwillenbring](https://forum.inductiveautomation.com/u/mwillenbring)\ **Replies:** 3\ **Last updated:** [February 27, 2019, 6:39pm UTC](https://forum.inductiveautomation.com/t/getting-mobile-screen-size-data/7339 "2019-02-27T18:39:35Z")
Is there a way to get the screen size data for mobile clients? i ran into the post here about how to determine if its a mobile client. This works great, but I want to know the general screen size of the client also. If u… --- ## [Bind two opc tags togehter](https://forum.inductiveautomation.com/t/bind-two-opc-tags-togehter/22924)
**Author:** [@florent.gelas](https://forum.inductiveautomation.com/u/florent.gelas)\ **Replies:** 2\ **Last updated:** [February 27, 2019, 4:30pm UTC](https://forum.inductiveautomation.com/t/bind-two-opc-tags-togehter/22924 "2019-02-27T16:30:40Z")
Hello, I would like to do read an OPC tag “tag\_1” from a device “device1” and bind it to an other OPC tag “tag2” from a device “device2” using ModBus TCP protocol. The objectif is to collect informations from differen… --- ## [AD SSO login failed](https://forum.inductiveautomation.com/t/ad-sso-login-failed/22929)
**Author:** [@arturo.galvan](https://forum.inductiveautomation.com/u/arturo.galvan)\ **Replies:** 1\ **Last updated:** [February 27, 2019, 4:21pm UTC](https://forum.inductiveautomation.com/t/ad-sso-login-failed/22929 "2019-02-27T16:21:18Z")
I tried to set an auto login wit SSO but it doesn’t work. I want to open a project in the client launcher with my windows user. I don’t know if someone has done this before. --- ## [Popup Calendar Time only](https://forum.inductiveautomation.com/t/popup-calendar-time-only/22932)
**Author:** [@Phil\_B](https://forum.inductiveautomation.com/u/Phil_B)\ **Replies:** 2\ **Last updated:** [February 27, 2019, 4:15pm UTC](https://forum.inductiveautomation.com/t/popup-calendar-time-only/22932 "2019-02-27T16:15:21Z")
I have a screen in which the user can set break, shift, and scheduled down times for their plant. this setup isn’t specific to a certain day. Therefore, I am curious if it is possible to make a component like the popup c… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1311) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1313)