# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1480 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1481 --- ## [On the fly chage database connection for a client session](https://forum.inductiveautomation.com/t/on-the-fly-chage-database-connection-for-a-client-session/10470)
**Author:** [@boandersen](https://forum.inductiveautomation.com/u/boandersen)\ **Replies:** 1\ **Last updated:** [September 16, 2015, 11:25pm UTC](https://forum.inductiveautomation.com/t/on-the-fly-chage-database-connection-for-a-client-session/10470 "2015-09-16T23:25:16Z")
My question is basically the same as this one inductiveautomation.com/forum/v ... ion#p34863 , just 2.5 years later. Would like a client to switch to a different data connection while other clients on the same gatewa… --- ## [Can someone explain why this trans.trigger does not work?](https://forum.inductiveautomation.com/t/can-someone-explain-why-this-trans-trigger-does-not-work/10439)
**Author:** [@TimOSullivan](https://forum.inductiveautomation.com/u/TimOSullivan)\ **Replies:** 6\ **Last updated:** [September 16, 2015, 8:01pm UTC](https://forum.inductiveautomation.com/t/can-someone-explain-why-this-trans-trigger-does-not-work/10439 "2015-09-16T20:01:04Z")
Ignition V7.7.5 (({\[~\]Nordon/NLSTP02\_CastNumber} != {\[~\]pNLSTP02\_CastNumber}) && ({\[~\]Nordon/NLSTP02\_L\_Phase}={txD/LOAD\_START})) || ((({\[~\]Nordon/NLSTP02\_L\_Phase}={txD/LOAD\_END}) || ({\[~\]Nordon/NLSTP02\_L\_Phase}={txD/T… --- ## [Get Tags based on tag attribute](https://forum.inductiveautomation.com/t/get-tags-based-on-tag-attribute/10476)
**Author:** [@son122](https://forum.inductiveautomation.com/u/son122)\ **Replies:** 3\ **Last updated:** [September 16, 2015, 7:09pm UTC](https://forum.inductiveautomation.com/t/get-tags-based-on-tag-attribute/10476 "2015-09-16T19:09:21Z")
I'm aware of using a Tag Driven Provider to query tags from an external database; however, due to scale, this isn't a good option for us. Other option I tried is system.tag.browseTags and using the result set to continu… --- ## [Python Libraries pymodbus](https://forum.inductiveautomation.com/t/python-libraries-pymodbus/10473)
**Author:** [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\ **Replies:** 3\ **Last updated:** [September 16, 2015, 4:38pm UTC](https://forum.inductiveautomation.com/t/python-libraries-pymodbus/10473 "2015-09-16T16:38:59Z")
Morning all I sometimes struggle with importing Python Libraries, right now I need to do some weird ModbusTCP stuff, retrieving stored data tables, I know what to do but I can't do it with the Modbus driver or Kepware … --- ## [Script Creation of windows](https://forum.inductiveautomation.com/t/script-creation-of-windows/10477)
**Author:** [@Amarth](https://forum.inductiveautomation.com/u/Amarth)\ **Replies:** 0\ **Last updated:** [September 16, 2015, 3:48pm UTC](https://forum.inductiveautomation.com/t/script-creation-of-windows/10477 "2015-09-16T15:48:04Z")
Hello all, I have a project to migrate an old scada system to Ignition. The idea is to export the old scada views and variables in a database then create the new project in Ignition. Let us assume that the database i… --- ## [Best way to have diferent languages](https://forum.inductiveautomation.com/t/best-way-to-have-diferent-languages/10475)
**Author:** [@Ignaciof](https://forum.inductiveautomation.com/u/Ignaciof)\ **Replies:** 3\ **Last updated:** [September 16, 2015, 3:39pm UTC](https://forum.inductiveautomation.com/t/best-way-to-have-diferent-languages/10475 "2015-09-16T15:39:28Z")
Hi, I was thinking about the most efficient way for having one Ignition project in two or more languages. I have all my project in spanish and the first idea was copy and paste all folders and then translate everythin… --- ## [Find Data in PyDataset](https://forum.inductiveautomation.com/t/find-data-in-pydataset/10472)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 2\ **Last updated:** [September 16, 2015, 7:38am UTC](https://forum.inductiveautomation.com/t/find-data-in-pydataset/10472 "2015-09-16T07:38:58Z")
I'm trying to access a PyDataset and I can return the records in the first row but can't seem to find the records in the second row. Currently the dataset has only 2 rows but will get to about 40. \[code\]data = event.so… --- ## [Program control of Transaction Group delete of old data](https://forum.inductiveautomation.com/t/program-control-of-transaction-group-delete-of-old-data/10083)
**Author:** [@McAlisterD](https://forum.inductiveautomation.com/u/McAlisterD)\ **Replies:** 6\ **Last updated:** [September 16, 2015, 12:33am UTC](https://forum.inductiveautomation.com/t/program-control-of-transaction-group-delete-of-old-data/10083 "2015-09-16T00:33:07Z")
Can a script change the delete older than time of a transaction group? --- ## [UPDATE Query Syntax issue](https://forum.inductiveautomation.com/t/update-query-syntax-issue/10467)
**Author:** [@alewayhar](https://forum.inductiveautomation.com/u/alewayhar)\ **Replies:** 6\ **Last updated:** [September 15, 2015, 8:19pm UTC](https://forum.inductiveautomation.com/t/update-query-syntax-issue/10467 "2015-09-15T20:19:39Z")
So I started with my SQL Code within the Database Query Browser and I was able to do an update query with no issue :slight\_smile: This is just a basic edit row SQL script so I could make sure I got the syntax correct: U… --- ## [7.7.5 project on a 7.7.4 Gateway](https://forum.inductiveautomation.com/t/7-7-5-project-on-a-7-7-4-gateway/10468)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 5\ **Last updated:** [September 15, 2015, 6:06pm UTC](https://forum.inductiveautomation.com/t/7-7-5-project-on-a-7-7-4-gateway/10468 "2015-09-15T18:06:39Z")
So we are new to Ignition and I have an issue that has come up. We shipped a system to our customer that was running the 7.7.4 version of the Gateway. Well after the project shipped we did a computer upgrade here at t… --- ## [List of usernames in a dataset](https://forum.inductiveautomation.com/t/list-of-usernames-in-a-dataset/10471)
**Author:** [@Matthew\_Temple](https://forum.inductiveautomation.com/u/Matthew_Temple)\ **Replies:** 1\ **Last updated:** [September 15, 2015, 5:03pm UTC](https://forum.inductiveautomation.com/t/list-of-usernames-in-a-dataset/10471 "2015-09-15T17:03:29Z")
I'm trying to list all of the usernames in the internal profile into a table and / or drop down list. When I run the following code, I'm getting an error of "Row 0 doesn't have the same number of columns as header list"… --- ## [Text-field text to date-time tag property binding](https://forum.inductiveautomation.com/t/text-field-text-to-date-time-tag-property-binding/10465)
**Author:** [@ian](https://forum.inductiveautomation.com/u/ian)\ **Replies:** 2\ **Last updated:** [September 15, 2015, 10:11am UTC](https://forum.inductiveautomation.com/t/text-field-text-to-date-time-tag-property-binding/10465 "2015-09-15T10:11:37Z")
Hi all, Is there a way to specify the date-time string format of the text-field text when it is property bound to a date-time (memory) tag? I have a memory tag whose data type is datetime. In the memory tag itself, I s… --- ## [Handling Exceptions](https://forum.inductiveautomation.com/t/handling-exceptions/10449)
**Author:** [@oscar.salcedo](https://forum.inductiveautomation.com/u/oscar.salcedo)\ **Replies:** 7\ **Last updated:** [September 15, 2015, 8:50am UTC](https://forum.inductiveautomation.com/t/handling-exceptions/10449 "2015-09-15T08:50:46Z")
Hi, Is there a setting to hide all exceptions across a project? We have some unattended displays that show data on the floor shop and we would like all exceptions to be ignored; we have try-catches around all major fun… --- ## [Table Edit Text Size](https://forum.inductiveautomation.com/t/table-edit-text-size/9701)
**Author:** [@Automator59](https://forum.inductiveautomation.com/u/Automator59)\ **Replies:** 4\ **Last updated:** [September 15, 2015, 1:56am UTC](https://forum.inductiveautomation.com/t/table-edit-text-size/9701 "2015-09-15T01:56:53Z")
When I go into the table to edit the data, the text is very small. How can I make the edit text size the same as the display text size? --- ## [Serial.client module giving Permission Denied exception](https://forum.inductiveautomation.com/t/serial-client-module-giving-permission-denied-exception/10463)
**Author:** [@JoeJansen](https://forum.inductiveautomation.com/u/JoeJansen)\ **Replies:** 1\ **Last updated:** [September 14, 2015, 9:06pm UTC](https://forum.inductiveautomation.com/t/serial-client-module-giving-permission-denied-exception/10463 "2015-09-14T21:06:13Z")
I'm trying to use the serial.client module to read data in from a barcode scanner. I'm running Ignition 7.7.5 on an ubuntu variant linux system. I've used cat /dev/ttyS0 to verify the electrical connections and t… --- ## [Best way to send alarms to external systems](https://forum.inductiveautomation.com/t/best-way-to-send-alarms-to-external-systems/10460)
**Author:** [@oscar.salcedo](https://forum.inductiveautomation.com/u/oscar.salcedo)\ **Replies:** 1\ **Last updated:** [September 14, 2015, 8:20pm UTC](https://forum.inductiveautomation.com/t/best-way-to-send-alarms-to-external-systems/10460 "2015-09-14T20:20:13Z")
Hi all, We have a requirement to write to a PLC tag everytime there is an active alarm. I am seeking advice on what is the best approach to identify those alarms. We are considering the following options: Use system… --- ## [Copy Timestamp to property](https://forum.inductiveautomation.com/t/copy-timestamp-to-property/10461)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 1\ **Last updated:** [September 14, 2015, 4:56pm UTC](https://forum.inductiveautomation.com/t/copy-timestamp-to-property/10461 "2015-09-14T16:56:27Z")
I'm wanting to copy the current date time when a scripting event happens. I can't seem to get the code right. strTime = event.source.parent.PT.StartTime strTime.today() Gives me this error Traceback (most recent … --- ## [Overriding java methods in Igntion scripts](https://forum.inductiveautomation.com/t/overriding-java-methods-in-igntion-scripts/10457)
**Author:** [@JGJohnson](https://forum.inductiveautomation.com/u/JGJohnson)\ **Replies:** 2\ **Last updated:** [September 14, 2015, 3:50pm UTC](https://forum.inductiveautomation.com/t/overriding-java-methods-in-igntion-scripts/10457 "2015-09-14T15:50:32Z")
I need to do a http get to download files on a server that is using authentication so I am trying to use the setDefaultAuthenticator method of java.net.Authneticator. To do this I will need to override the getPasswordAut… --- ## [Defualt Open location](https://forum.inductiveautomation.com/t/defualt-open-location/10459)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 2\ **Last updated:** [September 14, 2015, 2:46pm UTC](https://forum.inductiveautomation.com/t/defualt-open-location/10459 "2015-09-14T14:46:52Z")
Is there a way to have a open file dialog that defaults to a certain path? What I am looking to do is have it so that when the operator hits open it defaults to a ftp location where all of the robot modules are stored… --- ## [GatewayException: Read timed out](https://forum.inductiveautomation.com/t/gatewayexception-read-timed-out/10452)
**Author:** [@namehta](https://forum.inductiveautomation.com/u/namehta)\ **Replies:** 1\ **Last updated:** [September 14, 2015, 10:56am UTC](https://forum.inductiveautomation.com/t/gatewayexception-read-timed-out/10452 "2015-09-14T10:56:34Z")
We have a user trying to launch the Ignition Gateway Client both remotely through an RDP connection and locally on the Ignition Server itself with the Ignition Client shortcut on the desktop. In both cases he cannot log… --- ## [Using system.db.runPrepUpdate](https://forum.inductiveautomation.com/t/using-system-db-runprepupdate/10453)
**Author:** [@alewayhar](https://forum.inductiveautomation.com/u/alewayhar)\ **Replies:** 2\ **Last updated:** [September 11, 2015, 4:15pm UTC](https://forum.inductiveautomation.com/t/using-system-db-runprepupdate/10453 "2015-09-11T16:15:46Z")
I am trying to add a row into a SQL DB table. I have successfully used the following code in mySQL so I know that my SQL code should not have any syntax errors. INSERT INTO sensor\_notes (user, timestamp, sensor\_numbe… --- ## [SQL Query Issue](https://forum.inductiveautomation.com/t/sql-query-issue/10446)
**Author:** [@alewayhar](https://forum.inductiveautomation.com/u/alewayhar)\ **Replies:** 2\ **Last updated:** [September 10, 2015, 12:09pm UTC](https://forum.inductiveautomation.com/t/sql-query-issue/10446 "2015-09-10T12:09:17Z")
I am using the following SQL query to query data between a certain set of dates: SELECT source, eventtime FROM alarm\_events WHERE eventtime BETWEEN Mon Jul 06 09:22:08 CDT 2015 and Mon Jul 06 09:22:18 CDT 2015 I kee… --- ## [Getting A Value From A Template In A Template Repeater](https://forum.inductiveautomation.com/t/getting-a-value-from-a-template-in-a-template-repeater/10128)
**Author:** [@rayjones9210](https://forum.inductiveautomation.com/u/rayjones9210)\ **Replies:** 7\ **Last updated:** [September 10, 2015, 1:43am UTC](https://forum.inductiveautomation.com/t/getting-a-value-from-a-template-in-a-template-repeater/10128 "2015-09-10T01:43:02Z")
How do I get a value from a specific numeric text field component that's inside of a template repeater? I'd like to take that value and store it in a database through scripting. --- ## [Possible to move Historical Data](https://forum.inductiveautomation.com/t/possible-to-move-historical-data/10444)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 1\ **Last updated:** [September 9, 2015, 10:37pm UTC](https://forum.inductiveautomation.com/t/possible-to-move-historical-data/10444 "2015-09-09T22:37:13Z")
I am moving a temperature storage project from one server to another. The temp data is simply stored wiht the historical flag turned on... Is there a way to move the last year or 180 days of data or something like that… --- ## [Problem with historical tags](https://forum.inductiveautomation.com/t/problem-with-historical-tags/9748)
**Author:** [@Kogan](https://forum.inductiveautomation.com/u/Kogan)\ **Replies:** 1\ **Last updated:** [September 9, 2015, 5:27am UTC](https://forum.inductiveautomation.com/t/problem-with-historical-tags/9748 "2015-09-09T05:27:42Z")
Hello. A few weeks ago, I changed historical tags in running project. I reduced time in special scan class for my tags and after that ALL historical tags stopped write in DB. (It use another scan class) I tried to dele… --- ## [Calculations based on relatime values](https://forum.inductiveautomation.com/t/calculations-based-on-relatime-values/10418)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 4\ **Last updated:** [September 9, 2015, 4:58am UTC](https://forum.inductiveautomation.com/t/calculations-based-on-relatime-values/10418 "2015-09-09T04:58:54Z")
Hi, I have a machine that provide the data attached, the weight output is cumulative. I'm trying to calculate the weight for each hopper for each new cycle, (cycle weight=last weight - new weight) i figured i'll need … --- ## [IA Demo project Mobile module](https://forum.inductiveautomation.com/t/ia-demo-project-mobile-module/10438)
**Author:** [@neon](https://forum.inductiveautomation.com/u/neon)\ **Replies:** 0\ **Last updated:** [September 6, 2015, 4:35pm UTC](https://forum.inductiveautomation.com/t/ia-demo-project-mobile-module/10438 "2015-09-06T16:35:01Z")
Good afternoon! To demonstrate the functionality we use Ignition: s3.amazonaws.com/files.inductiv … VmImageV77.зип When you open the mobile version of the project for Iphone 6 Plus is in the Safari browser and rotate … --- ## [SQL Syntax Error Help?](https://forum.inductiveautomation.com/t/sql-syntax-error-help/10401)
**Author:** [@alewayhar](https://forum.inductiveautomation.com/u/alewayhar)\ **Replies:** 11\ **Last updated:** [September 4, 2015, 8:43pm UTC](https://forum.inductiveautomation.com/t/sql-syntax-error-help/10401 "2015-09-04T20:43:00Z")
I'm getting an error message when I'm running my code to update a table in my SQL db. The Code is: string = event.source.parent.getComponent('Group').getComponent('Text Field').text string2 = event.source.parent.g… --- ## [Easy Chart Indirect Tag Binding](https://forum.inductiveautomation.com/t/easy-chart-indirect-tag-binding/10435)
**Author:** [@alewayhar](https://forum.inductiveautomation.com/u/alewayhar)\ **Replies:** 4\ **Last updated:** [September 4, 2015, 8:34pm UTC](https://forum.inductiveautomation.com/t/easy-chart-indirect-tag-binding/10435 "2015-09-04T20:34:37Z")
I have multiple instances of the same template within my program. Based on what template I click on, a popup with corresponding data pops up. On this popup window, there is an easy chart that I also want to correlate w… --- ## [Ignition gateway rebooting for unknown reason](https://forum.inductiveautomation.com/t/ignition-gateway-rebooting-for-unknown-reason/10434)
**Author:** [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\ **Replies:** 1\ **Last updated:** [September 4, 2015, 1:58pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-rebooting-for-unknown-reason/10434 "2015-09-04T13:58:18Z")
Our gateway 7.6.4 has ran steadily for months until this week we noticed huge chunks of no data in the middleof the night on our easy charts. The gateway was ‘off’ apparently for a couple of hours before recovering with… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1479) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1481)