# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1228 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1229 --- ## [Search Text Field / Syntax help](https://forum.inductiveautomation.com/t/search-text-field-syntax-help/30737)
**Author:** [@csanyia](https://forum.inductiveautomation.com/u/csanyia)\ **Replies:** 1\ **Last updated:** [December 17, 2019, 12:38am UTC](https://forum.inductiveautomation.com/t/search-text-field-syntax-help/30737 "2019-12-17T00:38:14Z")
I have a main table, with many text fields that can be written to the table. I’m attempting to add a filter to the column, I am attempting to achieve this by adding a WHERE tag = {Root Container.Search.search} The " Sea… --- ## [LInked Server in Reports](https://forum.inductiveautomation.com/t/linked-server-in-reports/30740)
**Author:** [@ajrowe](https://forum.inductiveautomation.com/u/ajrowe)\ **Replies:** 5\ **Last updated:** [December 16, 2019, 10:06pm UTC](https://forum.inductiveautomation.com/t/linked-server-in-reports/30740 "2019-12-16T22:06:22Z")
I have a complex query that uses a reference to a linked server and database. I successfully use the query in standard table object on a display. I’m trying now to make a report using the same query and am having probl… --- ## [Create a dataset of live tag values, what is best practice?](https://forum.inductiveautomation.com/t/create-a-dataset-of-live-tag-values-what-is-best-practice/30731)
**Author:** [@jimschaefer](https://forum.inductiveautomation.com/u/jimschaefer)\ **Replies:** 5\ **Last updated:** [December 16, 2019, 8:50pm UTC](https://forum.inductiveautomation.com/t/create-a-dataset-of-live-tag-values-what-is-best-practice/30731 "2019-12-16T20:50:14Z")
I would like to create a dataset that contains a list of tags with various live values of tag properties (value, converted value, units, timestamp, quality). Currently I am running a script every second that reads the t… --- ## [System.Report.executeandDistribute()](https://forum.inductiveautomation.com/t/system-report-executeanddistribute/14107)
**Author:** [@kingnoboru](https://forum.inductiveautomation.com/u/kingnoboru)\ **Replies:** 8\ **Last updated:** [December 16, 2019, 6:35pm UTC](https://forum.inductiveautomation.com/t/system-report-executeanddistribute/14107 "2019-12-16T18:35:41Z")
Hi to all, I'm trying to print a report using script, here the code: if system.tag.read("PLC\_MetalCan/PalletPresente").value == 1: system.report.executeAndDistribute(path = 'EtichettaPallet' , project = 'PLC… --- ## [Best practice csv to SQL import](https://forum.inductiveautomation.com/t/best-practice-csv-to-sql-import/30612)
**Author:** [@robert1](https://forum.inductiveautomation.com/u/robert1)\ **Replies:** 7\ **Last updated:** [December 16, 2019, 6:00pm UTC](https://forum.inductiveautomation.com/t/best-practice-csv-to-sql-import/30612 "2019-12-16T18:00:53Z")
Hello- I have a script that opens a .csv with somewhere between 5-10,000 rows, and then inserts this into a SQL table. It works just fine but runs fairly slow (I think). The script takes about 15-20 seconds to execute… --- ## [Restart module Alarm Notification](https://forum.inductiveautomation.com/t/restart-module-alarm-notification/30726)
**Author:** [@roberto.buompane](https://forum.inductiveautomation.com/u/roberto.buompane)\ **Replies:** 3\ **Last updated:** [December 16, 2019, 4:29pm UTC](https://forum.inductiveautomation.com/t/restart-module-alarm-notification/30726 "2019-12-16T16:29:42Z")
Hi, I’ve have a problem with Alarm Notification Module; we are using it to send emails and sms when alarms occur but sometimes we notice the module is stuck and emails and sms won’t be sent. We have to restart module. … --- ## [Report module - timeseries chart axis format](https://forum.inductiveautomation.com/t/report-module-timeseries-chart-axis-format/30529)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 2\ **Last updated:** [December 16, 2019, 4:27pm UTC](https://forum.inductiveautomation.com/t/report-module-timeseries-chart-axis-format/30529 "2019-12-16T16:27:05Z")
V8.05. Please can someone tell me how to change the text format on the x axis (time) of a time series chart in the report designer? Thanks --- ## [Backup lose connection](https://forum.inductiveautomation.com/t/backup-lose-connection/30733)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 1\ **Last updated:** [December 16, 2019, 4:17pm UTC](https://forum.inductiveautomation.com/t/backup-lose-connection/30733 "2019-12-16T16:17:26Z")
Hi, I have a redundant configuration, a few times a day, the redundant node lose connection, then recconect after a few seconds. What can I do to solve this problem? Ignition 7.9.8 --- ## [Bad Mistake Gateway Security](https://forum.inductiveautomation.com/t/bad-mistake-gateway-security/30728)
**Author:** [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Replies:** 3\ **Last updated:** [December 16, 2019, 3:51pm UTC](https://forum.inductiveautomation.com/t/bad-mistake-gateway-security/30728 "2019-12-16T15:51:08Z")
I have managed to make a terrible mistake. I set up a Hybrid Active Directory. I the set a role as Administrator. In the manage users I set my name to Administrator. I then went to the Gateway Security and changed it to … --- ## [\[13834\] Perspective: load screen spinning logo artifacts](https://forum.inductiveautomation.com/t/13834-perspective-load-screen-spinning-logo-artifacts/24779)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 3\ **Last updated:** [December 16, 2019, 12:45pm UTC](https://forum.inductiveautomation.com/t/13834-perspective-load-screen-spinning-logo-artifacts/24779 "2019-12-16T12:45:18Z")
Just a comment and very low priority, but I noticed that there are artifacts around the edges on the spinning Ignition logo when you first start up Perspective on both PC and mobile app. Looks like it’s a few bitmaps wit… --- ## [Multi-State Button - Making Confirm text dynamic](https://forum.inductiveautomation.com/t/multi-state-button-making-confirm-text-dynamic/27938)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 7\ **Last updated:** [December 15, 2019, 5:17am UTC](https://forum.inductiveautomation.com/t/multi-state-button-making-confirm-text-dynamic/27938 "2019-12-15T05:17:46Z")
Hi there, can anyone help me how to change the confirmation text depending on the button clicked on multi-state button. I have a multi-state button that has 3 states Manual =2,Off =0, and Auto=1. I would like a confir… --- ## [File Read From Gateway Directory](https://forum.inductiveautomation.com/t/file-read-from-gateway-directory/30696)
**Author:** [@kaushik.shah](https://forum.inductiveautomation.com/u/kaushik.shah)\ **Replies:** 2\ **Last updated:** [December 13, 2019, 11:16pm UTC](https://forum.inductiveautomation.com/t/file-read-from-gateway-directory/30696 "2019-12-13T23:16:21Z")
Hello, I have a gateway Timers to look for the new file in a mapped drive on gateway !! Here’s how the script looks like - import time import threading import os import glob def getFile(): machine = "MDR 1" machin… --- ## [Comms established, binding on screen still broken?](https://forum.inductiveautomation.com/t/comms-established-binding-on-screen-still-broken/30715)
**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Replies:** 0\ **Last updated:** [December 13, 2019, 11:11pm UTC](https://forum.inductiveautomation.com/t/comms-established-binding-on-screen-still-broken/30715 "2019-12-13T23:11:10Z")
So we are seeing something that is a little strange. We built our screens and linked properties like background color to the appropriate tag name via bindings. Today, we got our first station talking, and the driver is c… --- ## [Keyboard Events not triggering scripts in Perspective](https://forum.inductiveautomation.com/t/keyboard-events-not-triggering-scripts-in-perspective/30619)
**Author:** [@Dan\_Bridgeman](https://forum.inductiveautomation.com/u/Dan_Bridgeman)\ **Replies:** 7\ **Last updated:** [December 13, 2019, 8:43pm UTC](https://forum.inductiveautomation.com/t/keyboard-events-not-triggering-scripts-in-perspective/30619 "2019-12-13T20:43:32Z")
I find that I can’t get any Keyboard Events on my views’ roots to work. I am trying to put hotkeys on buttons by putting a script on the onKeyUp keyboard event, and triggering the script from the event script, using a s… --- ## [Strange problem with Transaction Group](https://forum.inductiveautomation.com/t/strange-problem-with-transaction-group/30585)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 5\ **Last updated:** [December 13, 2019, 7:56pm UTC](https://forum.inductiveautomation.com/t/strange-problem-with-transaction-group/30585 "2019-12-13T19:56:52Z")
I’ve been trying to figure out this problem for sometime now, without any luck! Let me try to explain: I’m using SQL Server Express(2014) as my database. I have several Transaction Groups that record Tag Data into a d… --- ## ["Error fetching users" after upgrading to 7.6.3](https://forum.inductiveautomation.com/t/error-fetching-users-after-upgrading-to-7-6-3/7456)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 3\ **Last updated:** [October 24, 2013, 8:31pm UTC](https://forum.inductiveautomation.com/t/error-fetching-users-after-upgrading-to-7-6-3/7456 "2013-10-24T20:31:21Z")
We just upgraded from 7.5 to 7.6.3 and I'm now getting in the error log this error about every minute or two: ERROR \[Wrapper\] \[10:59:41,627\]: \[profileName=Research\] Error fetching users. ... java.lang.NullPointerExcep… --- ## [OPC Connection to Another Ignition OPC UA Server on a different domain](https://forum.inductiveautomation.com/t/opc-connection-to-another-ignition-opc-ua-server-on-a-different-domain/30680)
**Author:** [@jpence](https://forum.inductiveautomation.com/u/jpence)\ **Replies:** 9\ **Last updated:** [December 13, 2019, 7:33pm UTC](https://forum.inductiveautomation.com/t/opc-connection-to-another-ignition-opc-ua-server-on-a-different-domain/30680 "2019-12-13T19:33:06Z")
I am creating a connection on an 8.0.6 ignition to another ignition server running 7.9.12 GIF steps Endpoint Discovery Choose A Server Security setup Left auth blank I created a new Client cert on the 8.0.6 I … --- ## [Log file has 1000's of these errors](https://forum.inductiveautomation.com/t/log-file-has-1000s-of-these-errors/30706)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 4\ **Last updated:** [December 13, 2019, 7:13pm UTC](https://forum.inductiveautomation.com/t/log-file-has-1000s-of-these-errors/30706 "2019-12-13T19:13:22Z")
Can someone explain these errors and what I might do to correct the problem? --- ## [High CPU Usage - from time to time](https://forum.inductiveautomation.com/t/high-cpu-usage-from-time-to-time/30691)
**Author:** [@Dawid\_Fulczynski](https://forum.inductiveautomation.com/u/Dawid_Fulczynski)\ **Replies:** 3\ **Last updated:** [December 13, 2019, 6:37pm UTC](https://forum.inductiveautomation.com/t/high-cpu-usage-from-time-to-time/30691 "2019-12-13T18:37:59Z")
Hello, Normally my project use about 15 - 25 % of cpu. But sometimes it goes to 100% and stay there until I reset server. It happend on version v7.9.12 (now updated to 7.9.13), I think there is issue with default scan … --- ## [Chart Range Selector Time Axis](https://forum.inductiveautomation.com/t/chart-range-selector-time-axis/30702)
**Author:** [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\ **Replies:** 1\ **Last updated:** [December 13, 2019, 6:34pm UTC](https://forum.inductiveautomation.com/t/chart-range-selector-time-axis/30702 "2019-12-13T18:34:33Z")
I am using a Chart Range Selector component to select a date/time range for a report display. I have a script that sets the selectedRange:start to one day prior to the current time, and the selectedRange:end to the curre… --- ## [Ignition 8 - Tags in Windows take longer to load than in Ignition 7](https://forum.inductiveautomation.com/t/ignition-8-tags-in-windows-take-longer-to-load-than-in-ignition-7/30530)
**Author:** [@informatica](https://forum.inductiveautomation.com/u/informatica)\ **Replies:** 9\ **Last updated:** [December 13, 2019, 5:13pm UTC](https://forum.inductiveautomation.com/t/ignition-8-tags-in-windows-take-longer-to-load-than-in-ignition-7/30530 "2019-12-13T17:13:20Z")
Good morning. We have updated to Ignition 8, and we have noticed that the tags in the windows take longer to load than in version 7. You can even see how when opening a window the tags are still loading. My PC is an i5… --- ## [Siemens S7 1500 OPC UA UDT with string member](https://forum.inductiveautomation.com/t/siemens-s7-1500-opc-ua-udt-with-string-member/30695)
**Author:** [@mohamad.tayara](https://forum.inductiveautomation.com/u/mohamad.tayara)\ **Replies:** 5\ **Last updated:** [December 13, 2019, 4:16pm UTC](https://forum.inductiveautomation.com/t/siemens-s7-1500-opc-ua-udt-with-string-member/30695 "2019-12-13T16:16:13Z")
Hi I have developed a nested level UDT in s7-1500, the PLC is communicating via OPC UA with the ignition, the communication was working fine for the nested UDT until one string member was added, after that the status tur… --- ## [Report showing incorrect date](https://forum.inductiveautomation.com/t/report-showing-incorrect-date/12435)
**Author:** [@collink](https://forum.inductiveautomation.com/u/collink)\ **Replies:** 6\ **Last updated:** [December 13, 2019, 3:28pm UTC](https://forum.inductiveautomation.com/t/report-showing-incorrect-date/12435 "2019-12-13T15:28:12Z")
In my report, the StartDate parameter's default value is toDate('2016-11-01 00:00:00'). If I drag the StartDate parameter onto the report designer and set the text component's date format to d-MMM-yyyy HH:mm:ss, the pr… --- ## [Reports in ignition](https://forum.inductiveautomation.com/t/reports-in-ignition/30684)
**Author:** [@epifanio.tigno](https://forum.inductiveautomation.com/u/epifanio.tigno)\ **Replies:** 1\ **Last updated:** [December 13, 2019, 1:49pm UTC](https://forum.inductiveautomation.com/t/reports-in-ignition/30684 "2019-12-13T13:49:53Z")
Hai ,is there a way how can i set a default printer in ignition?so that when printing a report i no longer select printer to print,thank you --- ## [Ignition license reverts to trial mode](https://forum.inductiveautomation.com/t/ignition-license-reverts-to-trial-mode/4095)
**Author:** [@fadihindi](https://forum.inductiveautomation.com/u/fadihindi)\ **Replies:** 8\ **Last updated:** [December 13, 2019, 12:02pm UTC](https://forum.inductiveautomation.com/t/ignition-license-reverts-to-trial-mode/4095 "2019-12-13T12:02:41Z")
I have an Ignition 7.3 server running for approximately 10 days, licensed with "The Works". Last night at almost exactly midnight all of the licenses reverted to "trial" mode. Viewing the licenses on the Gateway showed "… --- ## [Windows7 :(](https://forum.inductiveautomation.com/t/windows7/2027)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 3\ **Last updated:** [July 19, 2010, 8:05pm UTC](https://forum.inductiveautomation.com/t/windows7/2027 "2010-07-19T20:05:47Z")
I can't make the application frame go away in Windows 7. --- ## [Create components for Ignition (Vision)](https://forum.inductiveautomation.com/t/create-components-for-ignition-vision/30665)
**Author:** [@giulio.comito](https://forum.inductiveautomation.com/u/giulio.comito)\ **Replies:** 3\ **Last updated:** [December 13, 2019, 8:01am UTC](https://forum.inductiveautomation.com/t/create-components-for-ignition-vision/30665 "2019-12-13T08:01:32Z")
Hello everyone! I’d like to know if it’s possible to create components for Ignition (Vision) and then import them into a project … I want to create an object (a table) that has a series of properties created ad hoc (incl… --- ## [Report Table Population Direction](https://forum.inductiveautomation.com/t/report-table-population-direction/30685)
**Author:** [@kerwin.grapa](https://forum.inductiveautomation.com/u/kerwin.grapa)\ **Replies:** 0\ **Last updated:** [December 13, 2019, 3:25am UTC](https://forum.inductiveautomation.com/t/report-table-population-direction/30685 "2019-12-13T03:25:37Z")
Good day, I am making a report for my client. They want the report reading from left to right. Is there a way to populate a table in sideways from left to right? --- ## [Unable to browse Ignition OPC-UA Browser after restoring a gateway backup v7.9.x](https://forum.inductiveautomation.com/t/unable-to-browse-ignition-opc-ua-browser-after-restoring-a-gateway-backup-v7-9-x/30675)
**Author:** [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\ **Replies:** 7\ **Last updated:** [December 13, 2019, 2:20am UTC](https://forum.inductiveautomation.com/t/unable-to-browse-ignition-opc-ua-browser-after-restoring-a-gateway-backup-v7-9-x/30675 "2019-12-13T02:20:15Z")
Good afternoon, I am running v7.9.13 and have a gateway backup taken from v7.9.4. When I restore this gateway backup and successfully setup my device on it I am unable to browse any devices under Tag Browser -\> Ignition… --- ## [Popup Window Templating with flexRepeater?](https://forum.inductiveautomation.com/t/popup-window-templating-with-flexrepeater/30677)
**Author:** [@tmahaffey](https://forum.inductiveautomation.com/u/tmahaffey)\ **Replies:** 4\ **Last updated:** [December 13, 2019, 12:16am UTC](https://forum.inductiveautomation.com/t/popup-window-templating-with-flexrepeater/30677 "2019-12-13T00:16:44Z")
So I’ve successfully templated out some buttons using the flex repeater, but I’m having a bit of trouble figuring out how have the button script change for each instance. Tag directory I’m targeting, I wish to have e… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1227) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1229)