# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1663 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1664 --- ## [Number to Color translation](https://forum.inductiveautomation.com/t/number-to-color-translation/2793)
**Author:** [@Jon.Trusik](https://forum.inductiveautomation.com/u/Jon.Trusik)\ **Replies:** 6\ **Last updated:** [March 23, 2011, 3:28pm UTC](https://forum.inductiveautomation.com/t/number-to-color-translation/2793 "2011-03-23T15:28:20Z")
When using a component, typically a shape, is there a way the 'number to color translation' can use a variable instead of a hardcoded value. I'd like to make this into an end user defineable value. --- ## [Trying to emulate functions of our old SCADA system](https://forum.inductiveautomation.com/t/trying-to-emulate-functions-of-our-old-scada-system/2794)
**Author:** [@JasonFraser](https://forum.inductiveautomation.com/u/JasonFraser)\ **Replies:** 3\ **Last updated:** [March 23, 2011, 3:03pm UTC](https://forum.inductiveautomation.com/t/trying-to-emulate-functions-of-our-old-scada-system/2794 "2011-03-23T15:03:37Z")
Hello all, I've been trying to copy some of the functionality of our old SCADA system into ignition. I have been playing around in the Script playground trying to get his to work and it's basically a series of SQL comman… --- ## [Viewing a binding for multiple items gives misleading error](https://forum.inductiveautomation.com/t/viewing-a-binding-for-multiple-items-gives-misleading-error/2791)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [March 22, 2011, 10:37pm UTC](https://forum.inductiveautomation.com/t/viewing-a-binding-for-multiple-items-gives-misleading-error/2791 "2011-03-22T22:37:42Z")
If you select more than one item and try to display the binding of a common property (such as 'Visible'), an error is displayed which says Uncaught IllegalArgumentException: Cannot open bindings for orphaned componen… --- ## [Launch window on open](https://forum.inductiveautomation.com/t/launch-window-on-open/2792)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 4\ **Last updated:** [March 22, 2011, 8:46pm UTC](https://forum.inductiveautomation.com/t/launch-window-on-open/2792 "2011-03-22T20:46:07Z")
I was looking to have a main window automatically open a sub-window when the main window opens. I tried using the system.nav.openWindow() function, giving it an explicit path to a window in double quotes. I put this sc… --- ## [Report Module (1.2.4) - Total in crosstab](https://forum.inductiveautomation.com/t/report-module-1-2-4-total-in-crosstab/2783)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 2\ **Last updated:** [March 22, 2011, 7:04pm UTC](https://forum.inductiveautomation.com/t/report-module-1-2-4-total-in-crosstab/2783 "2011-03-22T19:04:55Z")
Hi, I've a very simple crosstab : row : country column : department I want to add a sum (total) for each row and each column. I can't get it done. Thanks --- ## [Sql Help](https://forum.inductiveautomation.com/t/sql-help/2788)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 2\ **Last updated:** [March 22, 2011, 5:22pm UTC](https://forum.inductiveautomation.com/t/sql-help/2788 "2011-03-22T17:22:11Z")
I have this SQL Query binding to a text field. It will work if there is a value in the table between range. If there is not it comes back with a nothing. How can I get it to bring back the "MinVal +1" if there is nothing… --- ## [Find & Replace](https://forum.inductiveautomation.com/t/find-replace/2634)
**Author:** [@rfbuehler](https://forum.inductiveautomation.com/u/rfbuehler)\ **Replies:** 2\ **Last updated:** [March 22, 2011, 2:15pm UTC](https://forum.inductiveautomation.com/t/find-replace/2634 "2011-03-22T14:15:30Z")
I have over 80 Multistate Indicators on a single window. I want to do a search & replace of the text in text property of a style within the object. Is this possable? --- ## [Container layout problem](https://forum.inductiveautomation.com/t/container-layout-problem/2206)
**Author:** [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\ **Replies:** 13\ **Last updated:** [March 22, 2011, 2:09am UTC](https://forum.inductiveautomation.com/t/container-layout-problem/2206 "2011-03-22T02:09:27Z")
There may be a problem with the layout feature. Design has two components within a container where the components and the container layout is set to relative. All axis of the container can be moved without affecting th… --- ## [Text Field input issue](https://forum.inductiveautomation.com/t/text-field-input-issue/2296)
**Author:** [@alex.ferrell](https://forum.inductiveautomation.com/u/alex.ferrell)\ **Replies:** 5\ **Last updated:** [March 21, 2011, 11:56pm UTC](https://forum.inductiveautomation.com/t/text-field-input-issue/2296 "2011-03-21T23:56:23Z")
I am having trouble with a text input field with the text bound to a string tag in my PLC. In certain cases the text that is entered is not accepted by the PLC logic, so in that case it over-writes the string value back … --- ## [Mobile Module - ERR\_ACCESS\_DENIED in 3G only (work on wifi)](https://forum.inductiveautomation.com/t/mobile-module-err-access-denied-in-3g-only-work-on-wifi/2781)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 1\ **Last updated:** [March 21, 2011, 9:44pm UTC](https://forum.inductiveautomation.com/t/mobile-module-err-access-denied-in-3g-only-work-on-wifi/2781 "2011-03-21T21:44:24Z")
Hi, I've an Ignition gateway set up and working correctly, hosted on a server over internet. When I access the server in wifi and with a mobile (android 2.2), it is ok. Work correctly. When I want to use 3G, I've the f… --- ## [Query the internal SQLtags database?](https://forum.inductiveautomation.com/t/query-the-internal-sqltags-database/2787)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 4\ **Last updated:** [March 21, 2011, 9:03pm UTC](https://forum.inductiveautomation.com/t/query-the-internal-sqltags-database/2787 "2011-03-21T21:03:43Z")
Is it possible to query the internal SQLtags database directly? --- ## [Chart gaps and red overlay in data table](https://forum.inductiveautomation.com/t/chart-gaps-and-red-overlay-in-data-table/2786)
**Author:** [@adamstagnaro](https://forum.inductiveautomation.com/u/adamstagnaro)\ **Replies:** 1\ **Last updated:** [March 21, 2011, 8:50pm UTC](https://forum.inductiveautomation.com/t/chart-gaps-and-red-overlay-in-data-table/2786 "2011-03-21T20:50:35Z")
Hi, I’m having problems with a historical tag. In my Easychart there is gaps every couple of minutes. When I drag the tag onto a table, there is red overlays on many of the cells (see attached). I’m assuming these are t… --- ## [Pulling timestamp from a table](https://forum.inductiveautomation.com/t/pulling-timestamp-from-a-table/2784)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 1\ **Last updated:** [March 21, 2011, 4:18pm UTC](https://forum.inductiveautomation.com/t/pulling-timestamp-from-a-table/2784 "2011-03-21T16:18:10Z")
I have a table created from an SQL query. The columns of the table are bound to properties and use this expression.(toFloat({Root Container.Table 8.data}\[0,1\])) This allows me to use the numeric data. My problem is that… --- ## [File explorer component, internet explorer component](https://forum.inductiveautomation.com/t/file-explorer-component-internet-explorer-component/2768)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 5\ **Last updated:** [March 21, 2011, 5:06am UTC](https://forum.inductiveautomation.com/t/file-explorer-component-internet-explorer-component/2768 "2011-03-21T05:06:54Z")
is there a way to make the file explorer only view the root directory on the server pc instead of the client pc? I have a program that generates a file that my customer wants to see, but the customer is logging in to my … --- ## [Schedule jobs](https://forum.inductiveautomation.com/t/schedule-jobs/2780)
**Author:** [@alex](https://forum.inductiveautomation.com/u/alex)\ **Replies:** 1\ **Last updated:** [March 21, 2011, 4:40am UTC](https://forum.inductiveautomation.com/t/schedule-jobs/2780 "2011-03-21T04:40:17Z")
I need to schedule a task which would get the data from mysql, convert as excel file and then create a file in my local system (or) remote system in C: (or) D: drive & as well as send email with attachment. I have wri… --- ## [Create directory](https://forum.inductiveautomation.com/t/create-directory/2776)
**Author:** [@alex](https://forum.inductiveautomation.com/u/alex)\ **Replies:** 4\ **Last updated:** [March 20, 2011, 5:16pm UTC](https://forum.inductiveautomation.com/t/create-directory/2776 "2011-03-20T17:16:10Z")
How do i create directory in C: drive (or) D: drive. I have used python script and Java, but i was not able to create directory, i got syntax error. Please help me out. Python script : import os os.mkdir(newdir) … --- ## [OPC-UA server "CONNECTING"](https://forum.inductiveautomation.com/t/opc-ua-server-connecting/2507)
**Author:** [@alex.ferrell](https://forum.inductiveautomation.com/u/alex.ferrell)\ **Replies:** 2\ **Last updated:** [March 19, 2011, 1:38pm UTC](https://forum.inductiveautomation.com/t/opc-ua-server-connecting/2507 "2011-03-19T13:38:58Z")
This has happened to me a few times the last couple of days while doing some design and testing locally on my laptop. The OPC Connection status either shows "CONNECTING" or "Faulted". Below is the error description. If I… --- ## [NET-ENI Connection](https://forum.inductiveautomation.com/t/net-eni-connection/2774)
**Author:** [@kjwilde](https://forum.inductiveautomation.com/u/kjwilde)\ **Replies:** 8\ **Last updated:** [March 19, 2011, 3:49am UTC](https://forum.inductiveautomation.com/t/net-eni-connection/2774 "2011-03-19T03:49:58Z")
Recently we ran into network problems and had to isolate the corporate network from the EthernetIP I/O network. For PLC access then I added a NET-ENI module connected to the serial port. I've got it working, RsLinx rec… --- ## [Display PLC Clock Time](https://forum.inductiveautomation.com/t/display-plc-clock-time/2778)
**Author:** [@rooks](https://forum.inductiveautomation.com/u/rooks)\ **Replies:** 1\ **Last updated:** [March 18, 2011, 11:04pm UTC](https://forum.inductiveautomation.com/t/display-plc-clock-time/2778 "2011-03-18T23:04:55Z")
I am trying to display the current time from a PLC's RTC on a window. The PLC is a MIcroLogix 1100. I have created sql tags that are reading the PLC Clock's Year, Month, Day, Hour, Minute, Seconds as integers. I want to … --- ## [Meter component issues](https://forum.inductiveautomation.com/t/meter-component-issues/2765)
**Author:** [@DennisWomack](https://forum.inductiveautomation.com/u/DennisWomack)\ **Replies:** 2\ **Last updated:** [March 18, 2011, 5:14pm UTC](https://forum.inductiveautomation.com/t/meter-component-issues/2765 "2011-03-18T17:14:32Z")
Is it me or is there a problem with the Meter ccomponent? When I drop a meter component in a window and then drag a tag to it, editing some of the properties doesn't stick. The meter has a lower bound and an upper bo… --- ## [Disable AlertExecEnabled for a whole folder of tags at once](https://forum.inductiveautomation.com/t/disable-alertexecenabled-for-a-whole-folder-of-tags-at-once/2777)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 0\ **Last updated:** [March 18, 2011, 4:04pm UTC](https://forum.inductiveautomation.com/t/disable-alertexecenabled-for-a-whole-folder-of-tags-at-once/2777 "2011-03-18T16:04:17Z")
Have a folder of SQLtags w/ alarming enabled, Would like to disable the notifcations based on another tag. I know I can do this on a per tag basis, Is there any easy way to disable the whole folder's worth at once? Al… --- ## [Headless Gateway Port setting](https://forum.inductiveautomation.com/t/headless-gateway-port-setting/2772)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 2\ **Last updated:** [March 18, 2011, 3:22pm UTC](https://forum.inductiveautomation.com/t/headless-gateway-port-setting/2772 "2011-03-18T15:22:28Z")
On a headless system not using the GCU. I have seen reference to editing 2 different files to change the port. \\Ignition\\config.xml \\Ignition\\tomcat\\webapps\\ctx0\\WEB-INF\\web.xml I got it working editing the config.xm… --- ## [Container properties](https://forum.inductiveautomation.com/t/container-properties/2734)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 8\ **Last updated:** [March 17, 2011, 10:42pm UTC](https://forum.inductiveautomation.com/t/container-properties/2734 "2011-03-17T22:42:09Z")
I just noticed some odd behavior with the container component. Perhaps this is by design or I am missing something. If I bind the background color property to a color whose alpha is less than 255, then the opaque prope… --- ## [Trend Lines Dropping Out](https://forum.inductiveautomation.com/t/trend-lines-dropping-out/2220)
**Author:** [@jay](https://forum.inductiveautomation.com/u/jay)\ **Replies:** 9\ **Last updated:** [March 17, 2011, 6:06pm UTC](https://forum.inductiveautomation.com/t/trend-lines-dropping-out/2220 "2011-03-17T18:06:13Z")
The value on trend lines will often drop to 0.0. See attached pdfs. The following data comes from the SQL statement … SELECT from\_unixtime(t\_stamp/1000) as ‘time’, floatvalue, dataintegrity FROM sqlt\_data\_1\_2010\_09 W… --- ## [One-Shot Button Security](https://forum.inductiveautomation.com/t/one-shot-button-security/2651)
**Author:** [@jay](https://forum.inductiveautomation.com/u/jay)\ **Replies:** 5\ **Last updated:** [March 17, 2011, 5:48pm UTC](https://forum.inductiveautomation.com/t/one-shot-button-security/2651 "2011-03-17T17:48:39Z")
Ignition version 7.2.3 (b6630) Applying security to a one-shot button component does not disable the button from being pressed when a user is not logged in. --- ## [Tag Change Scripts](https://forum.inductiveautomation.com/t/tag-change-scripts/2773)
**Author:** [@f\_jons](https://forum.inductiveautomation.com/u/f_jons)\ **Replies:** 1\ **Last updated:** [March 17, 2011, 5:30pm UTC](https://forum.inductiveautomation.com/t/tag-change-scripts/2773 "2011-03-17T17:30:07Z")
Can we make it so that the tags referenced in the tag change scripts can be indirectly bound? --- ## [Auto Save option as textfile at regular intervals](https://forum.inductiveautomation.com/t/auto-save-option-as-textfile-at-regular-intervals/2764)
**Author:** [@ajay](https://forum.inductiveautomation.com/u/ajay)\ **Replies:** 3\ **Last updated:** [March 17, 2011, 4:29pm UTC](https://forum.inductiveautomation.com/t/auto-save-option-as-textfile-at-regular-intervals/2764 "2011-03-17T16:29:11Z")
One of Ignition Server 7.2.1 is connected with ABB 800 XA system. Now I want to store data in text file format (.txt) from ignition. I would like to know whether Ignition have this option? We have seen this ki… --- ## [Easy Chart - Pen Digital Offset](https://forum.inductiveautomation.com/t/easy-chart-pen-digital-offset/2633)
**Author:** [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\ **Replies:** 3\ **Last updated:** [March 17, 2011, 12:07pm UTC](https://forum.inductiveautomation.com/t/easy-chart-pen-digital-offset/2633 "2011-03-17T12:07:06Z")
I think this is something overlooked… I have 6 pens in an easy chart, tracking digital states. 3 pens in subplot 1, 3 in subplot 2. If I check the digital offset for each of them, it is applied as if all the pens were … --- ## [Disappearing DB tag](https://forum.inductiveautomation.com/t/disappearing-db-tag/1954)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [March 16, 2011, 10:59pm UTC](https://forum.inductiveautomation.com/t/disappearing-db-tag/1954 "2011-03-16T22:59:56Z")
If you try to drag a DB tag from the 'Tags' folder of SQLTags to the 'Client' folder, you get a warning that states Cannot add this type \[DB\] of tag into the project's tags. When you clear the warning the tag has dis… --- ## [OPC-UA ControlNet - PLC5](https://forum.inductiveautomation.com/t/opc-ua-controlnet-plc5/2544)
**Author:** [@jobe](https://forum.inductiveautomation.com/u/jobe)\ **Replies:** 6\ **Last updated:** [March 16, 2011, 8:09pm UTC](https://forum.inductiveautomation.com/t/opc-ua-controlnet-plc5/2544 "2011-03-16T20:09:58Z")
I am having issues following the set procedures for connecting a controlnet logix to a plc5. Here is the layout I have in both plc's and in the opc-ua setup. What am I missing? Control Logix Setup 0… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1662) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1664)