# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1358 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1359 --- ## [Python script to count the number of different resource types in a set of project files](https://forum.inductiveautomation.com/t/python-script-to-count-the-number-of-different-resource-types-in-a-set-of-project-files/19256)
**Author:** [@fourmajor](https://forum.inductiveautomation.com/u/fourmajor)\ **Replies:** 0\ **Last updated:** [August 14, 2018, 10:05pm UTC](https://forum.inductiveautomation.com/t/python-script-to-count-the-number-of-different-resource-types-in-a-set-of-project-files/19256 "2018-08-14T22:05:46Z")
Just in case anyone else finds this of use! This Python script counts the number of different resource types in a set of project files: from os import listdir import pprint import xml.etree.ElementTree as ET folder =… --- ## [Automated user interface testing](https://forum.inductiveautomation.com/t/automated-user-interface-testing/4539)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [August 14, 2018, 9:56pm UTC](https://forum.inductiveautomation.com/t/automated-user-interface-testing/4539 "2018-08-14T21:56:09Z")
Has anyone tried an automated user interface test package with the Ignition client? A quick look has come up with packages like Marathon, Maveryx or Squish. We use Ignition as a front-end for a user's database and it … --- ## [Read/Write Live Date to Excel](https://forum.inductiveautomation.com/t/read-write-live-date-to-excel/19249)
**Author:** [@Brandon.Hildebrand](https://forum.inductiveautomation.com/u/Brandon.Hildebrand)\ **Replies:** 2\ **Last updated:** [August 14, 2018, 7:38pm UTC](https://forum.inductiveautomation.com/t/read-write-live-date-to-excel/19249 "2018-08-14T19:38:41Z")
I am working on a conversion project and there is functionality in the old system that reads/writes live data between the HMI and excel. Is there a way to do that in Ignition? --- ## [Need help writing while loop](https://forum.inductiveautomation.com/t/need-help-writing-while-loop/19251)
**Author:** [@nruimveld](https://forum.inductiveautomation.com/u/nruimveld)\ **Replies:** 0\ **Last updated:** [August 14, 2018, 5:50pm UTC](https://forum.inductiveautomation.com/t/need-help-writing-while-loop/19251 "2018-08-14T17:50:36Z")
Hello all! I'm trying to loop through this to when the Command\_commands shows 'G4N3F', I need to write to BP2\_Has\_Cook. if Has\_Command \< 1: system.tag.write("AGCs/AGC2/To\_Cart/Command\_commands", 'DG4N3F') sys… --- ## [Can't Remove TestData From a Table](https://forum.inductiveautomation.com/t/cant-remove-testdata-from-a-table/19232)
**Author:** [@ddurant](https://forum.inductiveautomation.com/u/ddurant)\ **Replies:** 3\ **Last updated:** [August 14, 2018, 4:11pm UTC](https://forum.inductiveautomation.com/t/cant-remove-testdata-from-a-table/19232 "2018-08-14T16:11:19Z")
I created a Table component and unchecked the TestData property and it populated my table with test data as expected. However, now I can't check it back to false? It won't allow me and I don't where else it is bound. … --- ## [Easy Chart on Template with UDT's](https://forum.inductiveautomation.com/t/easy-chart-on-template-with-udts/19233)
**Author:** [@ryanastiefes](https://forum.inductiveautomation.com/u/ryanastiefes)\ **Replies:** 5\ **Last updated:** [August 14, 2018, 3:38pm UTC](https://forum.inductiveautomation.com/t/easy-chart-on-template-with-udts/19233 "2018-08-14T15:38:26Z")
Using Ignition 7.7.5 Here’s my problem: I’m getting this error using an Easy Chart in a Template with Data Type’s I’m using the Cell Update table to pass my Data Types in through the Meta.TagPath. The DataTypes are… --- ## [Component Rotation](https://forum.inductiveautomation.com/t/component-rotation/2852)
**Author:** [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Replies:** 3\ **Last updated:** [August 14, 2018, 3:25pm UTC](https://forum.inductiveautomation.com/t/component-rotation/2852 "2018-08-14T15:25:00Z")
The forum has some discussion about workarounds for the limited current component rotation implementation. I submit that components should be able to rotate via one of the component handles (maybe after pressing right-cl… --- ## [Backup is out of date](https://forum.inductiveautomation.com/t/backup-is-out-of-date/19236)
**Author:** [@folgore](https://forum.inductiveautomation.com/u/folgore)\ **Replies:** 2\ **Last updated:** [August 14, 2018, 2:55pm UTC](https://forum.inductiveautomation.com/t/backup-is-out-of-date/19236 "2018-08-14T14:55:11Z")
Hi, in my redundancy application (ignition 7.8.3) I have a master that occupied 11GB of RAM and the communication with the client is interrupted. The server is online and not switch to stand by server. I restarted the m… --- ## [Connection problems with my MySql and Ignition](https://forum.inductiveautomation.com/t/connection-problems-with-my-mysql-and-ignition/19238)
**Author:** [@thaynarasant.pol](https://forum.inductiveautomation.com/u/thaynarasant.pol)\ **Replies:** 1\ **Last updated:** [August 14, 2018, 2:01pm UTC](https://forum.inductiveautomation.com/t/connection-problems-with-my-mysql-and-ignition/19238 "2018-08-14T14:01:35Z")
Hello, I am having connection problems with my MySql and Ignition. For more information: STATUS Cannot create PoolableConnectionFactory (Unknown initial character set index '255' received from server. Initial client … --- ## [MySQL Connection Faulted](https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225)
**Author:** [@thaynarasant.pol](https://forum.inductiveautomation.com/u/thaynarasant.pol)\ **Replies:** 2\ **Last updated:** [August 14, 2018, 2:00pm UTC](https://forum.inductiveautomation.com/t/mysql-connection-faulted/19225 "2018-08-14T14:00:08Z")
--- ## [New alarm automatically shelved](https://forum.inductiveautomation.com/t/new-alarm-automatically-shelved/19229)
**Author:** [@Philcr](https://forum.inductiveautomation.com/u/Philcr)\ **Replies:** 2\ **Last updated:** [August 14, 2018, 11:07am UTC](https://forum.inductiveautomation.com/t/new-alarm-automatically-shelved/19229 "2018-08-14T11:07:23Z")
Hello, my understanding is that a shelved alarm that is "Acked" and "Cleared" and become active again before the end of the shelve duration would not appear as shelved because it is a different alarm, but I have this i… --- ## [Run Expression from script](https://forum.inductiveautomation.com/t/run-expression-from-script/19196)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 3\ **Last updated:** [August 13, 2018, 9:33pm UTC](https://forum.inductiveautomation.com/t/run-expression-from-script/19196 "2018-08-13T21:33:32Z")
Is it possible to run an expression from a script. I have a script that returns the setpoint value from an alarm property. What I need it the value that is shown after the expression is run. I have attached a snippet … --- ## [Evaluate Expression Language in Script](https://forum.inductiveautomation.com/t/evaluate-expression-language-in-script/15012)
**Author:** [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\ **Replies:** 8\ **Last updated:** [August 13, 2018, 9:31pm UTC](https://forum.inductiveautomation.com/t/evaluate-expression-language-in-script/15012 "2018-08-13T21:31:34Z")
I'm trying to write a script that creates a list of alarms setup on an Ignition System. So far I've got it iterating through all the Tags then through all Alarms, but when I print the alarms, many of my bindings show … --- ## [Screen changes not consistent across two clients](https://forum.inductiveautomation.com/t/screen-changes-not-consistent-across-two-clients/19228)
**Author:** [@PearceJ](https://forum.inductiveautomation.com/u/PearceJ)\ **Replies:** 4\ **Last updated:** [August 13, 2018, 7:08pm UTC](https://forum.inductiveautomation.com/t/screen-changes-not-consistent-across-two-clients/19228 "2018-08-13T19:08:45Z")
I am having some difficulty pushing out screen changes across two clients. Changes made on the Ignition Designer are not showing up on my first client but are showing up on my second client. I have tried the followi… --- ## [SQL tag with reference to other tag](https://forum.inductiveautomation.com/t/sql-tag-with-reference-to-other-tag/19226)
**Author:** [@bdecelles](https://forum.inductiveautomation.com/u/bdecelles)\ **Replies:** 2\ **Last updated:** [August 13, 2018, 3:46pm UTC](https://forum.inductiveautomation.com/t/sql-tag-with-reference-to-other-tag/19226 "2018-08-13T15:46:51Z")
I am trying to have a query tag that references another tag for my query, and it keeps coming back as null. SELECT fname FROM auth\_users WHERE username = '{\[System\]Client/User/Username}' If I replace the {\[System\]Cli… --- ## [MySQL Database Connection Faulted](https://forum.inductiveautomation.com/t/mysql-database-connection-faulted/6659)
**Author:** [@sfrahm](https://forum.inductiveautomation.com/u/sfrahm)\ **Replies:** 3\ **Last updated:** [June 27, 2013, 10:07pm UTC](https://forum.inductiveautomation.com/t/mysql-database-connection-faulted/6659 "2013-06-27T22:07:02Z")
Did your MySQL Database Connection just fail? Yes No Linux Windows Just Updated 0voters Choose up to 4 options Vote now!Show results PROBLEM Caveats - I am a Ignition newb and relative Ubuntu Linux newb… --- ## [Ignition SQL query changing from vantage-pt to pi-server](https://forum.inductiveautomation.com/t/ignition-sql-query-changing-from-vantage-pt-to-pi-server/19205)
**Author:** [@Faisal.Shibli](https://forum.inductiveautomation.com/u/Faisal.Shibli)\ **Replies:** 4\ **Last updated:** [August 13, 2018, 12:26pm UTC](https://forum.inductiveautomation.com/t/ignition-sql-query-changing-from-vantage-pt-to-pi-server/19205 "2018-08-13T12:26:25Z")
I am new to Ignition and also to sql. I am at the moment revising some of the sql qery code in ignition to point from factory talk historian tags from Vantage-Point to OLEDB (osipi server). Please find below the old scri… --- ## [Disabled tag values = None](https://forum.inductiveautomation.com/t/disabled-tag-values-none/19217)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 1\ **Last updated:** [August 13, 2018, 10:51am UTC](https://forum.inductiveautomation.com/t/disabled-tag-values-none/19217 "2018-08-13T10:51:30Z")
If a tag is disabled does it return none for a tag value read? --- ## [Store and forward data state?](https://forum.inductiveautomation.com/t/store-and-forward-data-state/19167)
**Author:** [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\ **Replies:** 2\ **Last updated:** [August 13, 2018, 5:36am UTC](https://forum.inductiveautomation.com/t/store-and-forward-data-state/19167 "2018-08-13T05:36:16Z")
What happens to data which is stored in store and forward and accidentally the physical machine on which ignition server is installed is restarted? --- ## [SQL Command Available](https://forum.inductiveautomation.com/t/sql-command-available/19212)
**Author:** [@kevin.jones](https://forum.inductiveautomation.com/u/kevin.jones)\ **Replies:** 4\ **Last updated:** [August 12, 2018, 1:03am UTC](https://forum.inductiveautomation.com/t/sql-command-available/19212 "2018-08-12T01:03:14Z")
I'm limping along trying to get some various SQL queries to work and have issues with trying to use IF or CASE in the SELECT statement. Eg: SELECT B28H as State, Count (B28) as Min , SUM ( IF B28H IN (1,2,3,5) THEN 1 E… --- ## [Change language of the Calendar component](https://forum.inductiveautomation.com/t/change-language-of-the-calendar-component/19213)
**Author:** [@mpoulsen921](https://forum.inductiveautomation.com/u/mpoulsen921)\ **Replies:** 0\ **Last updated:** [August 11, 2018, 7:36pm UTC](https://forum.inductiveautomation.com/t/change-language-of-the-calendar-component/19213 "2018-08-11T19:36:53Z")
Hi, Does anyone know how to change the language of the calendar component(names of months and days)? I have chosen the locale to be "da\_DK" in order to have european numbering format of decimal numbers. That way all nu… --- ## [Setting Popup Calendar to current datetime](https://forum.inductiveautomation.com/t/setting-popup-calendar-to-current-datetime/19211)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 3\ **Last updated:** [August 11, 2018, 3:52pm UTC](https://forum.inductiveautomation.com/t/setting-popup-calendar-to-current-datetime/19211 "2018-08-11T15:52:24Z")
Is there a way to use a expression or scripting to set the calenders current date and time when the window opens? --- ## [Ignition Port Usage](https://forum.inductiveautomation.com/t/ignition-port-usage/19208)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 1\ **Last updated:** [August 10, 2018, 10:49pm UTC](https://forum.inductiveautomation.com/t/ignition-port-usage/19208 "2018-08-10T22:49:45Z")
I have a customer that made this request. They want no traffic on port 8088 for security reasons. Is there a way to channel all Ignition activity through port 8043? I turned off the Windows firewall to test, and I foun… --- ## [Ignition Designer Dark Theme](https://forum.inductiveautomation.com/t/ignition-designer-dark-theme/19200)
**Author:** [@stuart.williams](https://forum.inductiveautomation.com/u/stuart.williams)\ **Replies:** 3\ **Last updated:** [August 10, 2018, 10:34pm UTC](https://forum.inductiveautomation.com/t/ignition-designer-dark-theme/19200 "2018-08-10T22:34:11Z")
Hello again everyone, Some colleagues and I were talking and we were wondering if Inductive had any plans of creating a "Dark Theme" for Ignition's Designer environment. Also, I was wondering what other developers th… --- ## [Inserting the last row of a pydataset into a database table](https://forum.inductiveautomation.com/t/inserting-the-last-row-of-a-pydataset-into-a-database-table/19203)
**Author:** [@comaife](https://forum.inductiveautomation.com/u/comaife)\ **Replies:** 4\ **Last updated:** [August 10, 2018, 8:12pm UTC](https://forum.inductiveautomation.com/t/inserting-the-last-row-of-a-pydataset-into-a-database-table/19203 "2018-08-10T20:12:27Z")
Hi: I want to insert the last row of a pydataset into an existing database. However, my current script adds the entire dataset each time it is executed. What modifications can I make to my script (below) to ensure only… --- ## [Historical Queries consuming Connections and Hanging, eventually Fault DB Connection](https://forum.inductiveautomation.com/t/historical-queries-consuming-connections-and-hanging-eventually-fault-db-connection/19199)
**Author:** [@dano38291](https://forum.inductiveautomation.com/u/dano38291)\ **Replies:** 3\ **Last updated:** [August 10, 2018, 7:30pm UTC](https://forum.inductiveautomation.com/t/historical-queries-consuming-connections-and-hanging-eventually-fault-db-connection/19199 "2018-08-10T19:30:40Z")
Hello, I have some users reporting occasional Red Overlays on a Historical Page. I have noticed I get these query strings that hang as Active Queries on my Database Status Page. Is there anyway I can turn on some verbo… --- ## [Increment tag ID to create a DataSet](https://forum.inductiveautomation.com/t/increment-tag-id-to-create-a-dataset/19173)
**Author:** [@Anne-Marie.Coupal](https://forum.inductiveautomation.com/u/Anne-Marie.Coupal)\ **Replies:** 2\ **Last updated:** [August 10, 2018, 4:06pm UTC](https://forum.inductiveautomation.com/t/increment-tag-id-to-create-a-dataset/19173 "2018-08-10T16:06:27Z")
Hi, I would like to know if there is a simple way to increment a tag ID. I am trying to read the value of different tags to create a dataset then, I want to put it in a table. headers = \["Status", "Permissive"\] blan… --- ## [Dropdown list horizontal scroll bar table mode](https://forum.inductiveautomation.com/t/dropdown-list-horizontal-scroll-bar-table-mode/19191)
**Author:** [@rrowe](https://forum.inductiveautomation.com/u/rrowe)\ **Replies:** 1\ **Last updated:** [August 10, 2018, 2:27pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-horizontal-scroll-bar-table-mode/19191 "2018-08-10T14:27:43Z")
I would like to have a horizontal scroll bar on my drop down list (table mode) so that my user can see all of the columns. Is this doable as of now? --- ## [Type Conversion error on switch statement](https://forum.inductiveautomation.com/t/type-conversion-error-on-switch-statement/19066)
**Author:** [@Anwesha\_Gupta](https://forum.inductiveautomation.com/u/Anwesha_Gupta)\ **Replies:** 2\ **Last updated:** [August 10, 2018, 8:45am UTC](https://forum.inductiveautomation.com/t/type-conversion-error-on-switch-statement/19066 "2018-08-10T08:45:49Z")
Hello All, I am trying to use a template repeater which has a component ‘Status’ (Integer). I am using the following code to drive the ‘Status’ . switch( {AllProjectsSite.SiteName}, ‘PoT’, ‘Broxburn’, ‘TynemouthA’, … --- ## [Users source migration](https://forum.inductiveautomation.com/t/users-source-migration/19166)
**Author:** [@r.lebohec](https://forum.inductiveautomation.com/u/r.lebohec)\ **Replies:** 4\ **Last updated:** [August 10, 2018, 7:17am UTC](https://forum.inductiveautomation.com/t/users-source-migration/19166 "2018-08-10T07:17:53Z")
Hi @Colby.Clegg is it a way to migrate an existing 'Internal User Source' with more than 50 users profiles to a new 'Database User Source'? My orignal issue is that, i'll like to restore backup on a production gateway … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1357) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1359)