# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1323 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1324 --- ## [Using a MySQL variable in a data query throwing me an error](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 3\ **Last updated:** [January 17, 2019, 10:37am UTC](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826 "2019-01-17T10:37:41Z")
I am doing a data query for a tree component. With this query, I am making a column for the treeItem number, which I accomplished just by ordering correctly and it seems to work fine, my column treeNum corresponds direc… --- ## [Epoch time to time with timezone](https://forum.inductiveautomation.com/t/epoch-time-to-time-with-timezone/4787)
**Author:** [@quper](https://forum.inductiveautomation.com/u/quper)\ **Replies:** 1\ **Last updated:** [July 9, 2012, 9:39am UTC](https://forum.inductiveautomation.com/t/epoch-time-to-time-with-timezone/4787 "2012-07-09T09:39:27Z")
Hello, I am reading register from controller. Register is epoch time like "1341832802". I need to display that as time with local timezone. I am using expression toDate({register path}\*1000), but I am getting time wit… --- ## [Alarm Status Table Question (TAGS)](https://forum.inductiveautomation.com/t/alarm-status-table-question-tags/21918)
**Author:** [@curtisfennell](https://forum.inductiveautomation.com/u/curtisfennell)\ **Replies:** 4\ **Last updated:** [January 16, 2019, 11:11pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-question-tags/21918 "2019-01-16T23:11:35Z")
Good Day, Have not got to dig into this to far, but I was looking for a way to identify active alarms. That is easily done with the Alarm Status Table. I was able to get that lined out how I liked, but started exploring… --- ## [Flash client window in taskbar](https://forum.inductiveautomation.com/t/flash-client-window-in-taskbar/21920)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 10:54pm UTC](https://forum.inductiveautomation.com/t/flash-client-window-in-taskbar/21920 "2019-01-16T22:54:01Z")
I’m using the messaging system to occasionally send clients a message to show the user. I was wondering if anyone had a way to make the window for this client flash in the taskbar, like some other applications do when th… --- ## [Chart Help](https://forum.inductiveautomation.com/t/chart-help/9303)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 8\ **Last updated:** [January 16, 2019, 8:45pm UTC](https://forum.inductiveautomation.com/t/chart-help/9303 "2019-01-16T20:45:29Z")
I have posted about this several times. This link and context is the closest thing that I can find that might help me achieve this result. What I need to do is this: I would like to be able to calculate the integral o… --- ## [Voice Notification Module with Cisco Call Manager](https://forum.inductiveautomation.com/t/voice-notification-module-with-cisco-call-manager/20727)
**Author:** [@Jack\_Lebel](https://forum.inductiveautomation.com/u/Jack_Lebel)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 7:28pm UTC](https://forum.inductiveautomation.com/t/voice-notification-module-with-cisco-call-manager/20727 "2019-01-16T19:28:39Z")
Does anyone know how to connect the Voice Notification Module to a Cisco Call Manager system? I am currently attempting to figure out what would need to be configured within both Cisco and Ignition in order to get this t… --- ## [User Security - User name only with numbers](https://forum.inductiveautomation.com/t/user-security-user-name-only-with-numbers/19137)
**Author:** [@michal.koblasa](https://forum.inductiveautomation.com/u/michal.koblasa)\ **Replies:** 2\ **Last updated:** [January 16, 2019, 5:44pm UTC](https://forum.inductiveautomation.com/t/user-security-user-name-only-with-numbers/19137 "2019-01-16T17:44:43Z")
Hello, in our company we use user identification only with numbers. For example user name is: 321 In ignition project we want to use same system. But when im creating new user in ignition, user form forces me to use on… --- ## [How to Manually fire a components expression binding?](https://forum.inductiveautomation.com/t/how-to-manually-fire-a-components-expression-binding/21904)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 2\ **Last updated:** [January 16, 2019, 4:29pm UTC](https://forum.inductiveautomation.com/t/how-to-manually-fire-a-components-expression-binding/21904 "2019-01-16T16:29:47Z")
Let’s say that NumericTextField3.FloatValue property is bound to the following expression - NumericTextField1.floatValue \* NumericTextField2.FloatValue All three numeric text fields are set to True for the Commit On Fo… --- ## [Numeric ldap UID's, ldap attribute as ignition username or prepend/strip character](https://forum.inductiveautomation.com/t/numeric-ldap-uids-ldap-attribute-as-ignition-username-or-prepend-strip-character/21913)
**Author:** [@alfred\_dussault](https://forum.inductiveautomation.com/u/alfred_dussault)\ **Replies:** 3\ **Last updated:** [January 16, 2019, 4:21pm UTC](https://forum.inductiveautomation.com/t/numeric-ldap-uids-ldap-attribute-as-ignition-username-or-prepend-strip-character/21913 "2019-01-16T16:21:42Z")
Hi, I was able to get the user authentication source working against our dirsrv-389 ldap instance with help from the forum. so thanks for that. Now I’m running into a different issue and I’m hoping there is a work aro… --- ## [system.gui.chooseColor not returning Alpha value](https://forum.inductiveautomation.com/t/system-gui-choosecolor-not-returning-alpha-value/11299)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 4\ **Last updated:** [January 16, 2019, 3:34pm UTC](https://forum.inductiveautomation.com/t/system-gui-choosecolor-not-returning-alpha-value/11299 "2019-01-16T15:34:30Z")
Is there a way to make the system.gui.chooseColor function return the selected alpha value as well as the RGB values? It doesn't matter what alpha or transparency is selected, it never gets returned. --- ## [Color to string](https://forum.inductiveautomation.com/t/color-to-string/12662)
**Author:** [@Jukka](https://forum.inductiveautomation.com/u/Jukka)\ **Replies:** 4\ **Last updated:** [February 11, 2017, 12:36am UTC](https://forum.inductiveautomation.com/t/color-to-string/12662 "2017-02-11T00:36:11Z")
Is there any way to read the color from the Power table and convert it to string, where R,G and B values can be read? I need to store these values to MySql database as a string. --- ## [What is a locked component?](https://forum.inductiveautomation.com/t/what-is-a-locked-component/21914)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [January 16, 2019, 3:04pm UTC](https://forum.inductiveautomation.com/t/what-is-a-locked-component/21914 "2019-01-16T15:04:32Z")
I recently recreated a tree navigator for my application. I replaced all references to the old tree with the new tree so now when I try to delete the old tree, I no longer get the “root container.component.field relies … --- ## [Creating many instances of a data type when AB Logix PLC tag is an array](https://forum.inductiveautomation.com/t/creating-many-instances-of-a-data-type-when-ab-logix-plc-tag-is-an-array/21903)
**Author:** [@nicklas.thystrup](https://forum.inductiveautomation.com/u/nicklas.thystrup)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 12:17am UTC](https://forum.inductiveautomation.com/t/creating-many-instances-of-a-data-type-when-ab-logix-plc-tag-is-an-array/21903 "2019-01-16T00:17:05Z")
I typically use the instance name of the datatype in the OPC Item path so that I can make many instances of the data type by using the multi-instance wizard: However, this time my tags in the Allen Bradley CompactLogi… --- ## [Conecting 2 pcs into the same network](https://forum.inductiveautomation.com/t/conecting-2-pcs-into-the-same-network/21894)
**Author:** [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\ **Replies:** 8\ **Last updated:** [January 15, 2019, 9:58pm UTC](https://forum.inductiveautomation.com/t/conecting-2-pcs-into-the-same-network/21894 "2019-01-15T21:58:10Z")
Hello, I’m a little new in ignition environment and I’m having some issues… i want to open my client in 2 different pcs… but my secondary pc create a different ignition network instead of connecting in the principal netw… --- ## [Transaction Execution not running in set up timer](https://forum.inductiveautomation.com/t/transaction-execution-not-running-in-set-up-timer/21881)
**Author:** [@trishhiyah](https://forum.inductiveautomation.com/u/trishhiyah)\ **Replies:** 1\ **Last updated:** [January 15, 2019, 4:18pm UTC](https://forum.inductiveautomation.com/t/transaction-execution-not-running-in-set-up-timer/21881 "2019-01-15T16:18:20Z")
HI Have you guys encountered that the next execution time is not running in realtime base on the set up of the timer? --- ## [Script to Set Component Security Checkboxes](https://forum.inductiveautomation.com/t/script-to-set-component-security-checkboxes/21792)
**Author:** [@mlindstrom](https://forum.inductiveautomation.com/u/mlindstrom)\ **Replies:** 4\ **Last updated:** [January 11, 2019, 2:36pm UTC](https://forum.inductiveautomation.com/t/script-to-set-component-security-checkboxes/21792 "2019-01-11T14:36:11Z")
I'm creating a popup template with configurable text and buttons on it, for use by a wide range of development and production engineers. Using system.security.getRoles() returns the roles of the active user, which I can … --- ## [OPC-UA Connection Setup](https://forum.inductiveautomation.com/t/opc-ua-connection-setup/21889)
**Author:** [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\ **Replies:** 5\ **Last updated:** [January 15, 2019, 4:07pm UTC](https://forum.inductiveautomation.com/t/opc-ua-connection-setup/21889 "2019-01-15T16:07:02Z")
Trying to connect to 3rd Party OPC-UA Server. (GE Cimplicity). I have trusted Ignitions Client Certificate on the Server. Do I need to install the server certificate onto Ignition. It faults out with “The user identit… --- ## [Can't reach Gateway Home Page](https://forum.inductiveautomation.com/t/cant-reach-gateway-home-page/21884)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 4\ **Last updated:** [January 15, 2019, 2:17pm UTC](https://forum.inductiveautomation.com/t/cant-reach-gateway-home-page/21884 "2019-01-15T14:17:34Z")
Hi All, I am unable to reach the Gateway Home Page from another computer in the same network and I can’t figure out why :frowning: . The Gateway I’m trying to connect to has the following IP address 192.168.250.2, I’m … --- ## [Limiting Tag Historian Memory Usage](https://forum.inductiveautomation.com/t/limiting-tag-historian-memory-usage/21880)
**Author:** [@mriederer](https://forum.inductiveautomation.com/u/mriederer)\ **Replies:** 1\ **Last updated:** [January 15, 2019, 2:12am UTC](https://forum.inductiveautomation.com/t/limiting-tag-historian-memory-usage/21880 "2019-01-15T02:12:10Z")
Hi All, I’m looking for a way to limit the amount of memory allocated to a tag historian query via system.db.queryTagHistorian()… or at least prevent the system from bogging down if we perform too large of a query. Mayb… --- ## [Using system.net.httpGet To Call For Bearer Token](https://forum.inductiveautomation.com/t/using-system-net-httpget-to-call-for-bearer-token/21868)
**Author:** [@mmintenko](https://forum.inductiveautomation.com/u/mmintenko)\ **Replies:** 2\ **Last updated:** [January 14, 2019, 9:21pm UTC](https://forum.inductiveautomation.com/t/using-system-net-httpget-to-call-for-bearer-token/21868 "2019-01-14T21:21:16Z")
Hello, I am completely new to Python and Ignition, and am having a heck of a time trying to put together a simple call to receive a bearer token. Here’s what I have: url2 = “http://ipaddress/api/v1/signin” urlHeader =… --- ## [Mac OSX Launch Gateway on Startup](https://forum.inductiveautomation.com/t/mac-osx-launch-gateway-on-startup/21833)
**Author:** [@WillMT10](https://forum.inductiveautomation.com/u/WillMT10)\ **Replies:** 2\ **Last updated:** [January 14, 2019, 3:48pm UTC](https://forum.inductiveautomation.com/t/mac-osx-launch-gateway-on-startup/21833 "2019-01-14T15:48:42Z")
I’ve been looking through the various forum posts and help articles but I can’t seem to find an answer. A new project that I am working on requires installing the Ignition gateway on a Mac. I was able to run through th… --- ## [Tag Export doesn't include tags with unchanged value](https://forum.inductiveautomation.com/t/tag-export-doesnt-include-tags-with-unchanged-value/21843)
**Author:** [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\ **Replies:** 4\ **Last updated:** [January 14, 2019, 3:27pm UTC](https://forum.inductiveautomation.com/t/tag-export-doesnt-include-tags-with-unchanged-value/21843 "2019-01-14T15:27:01Z")
Hello I export my tag list to xml or csv but for newly created tag which its value doesn’t change there is no item in either csv or xml export file. I should try manually change value and export again, this time the ta… --- ## [XML Parsing Failing Every 10 Runs of Code](https://forum.inductiveautomation.com/t/xml-parsing-failing-every-10-runs-of-code/21838)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 2\ **Last updated:** [January 14, 2019, 2:53pm UTC](https://forum.inductiveautomation.com/t/xml-parsing-failing-every-10-runs-of-code/21838 "2019-01-14T14:53:34Z")
Ignition Version 7.9.10 Trial Version I am doing some very basic xml parsing and I keep running into an error: oxml = """\ **Author:** [@Faisal.Shibli](https://forum.inductiveautomation.com/u/Faisal.Shibli)\ **Replies:** 5\ **Last updated:** [January 14, 2019, 2:53pm UTC](https://forum.inductiveautomation.com/t/attributeerror-array-array-object-has-no-attribute-getrowcount/21835 "2019-01-14T14:53:02Z") Hi, I am working on a pop-up. When I click ‘Submit Sign Off’ button, then an action event handler is performed. Click ‘Submit Sign Off’ button returns with the error AttributeError: ‘array.array’ object has no attribute… --- ## [Automatic save report doesn't work](https://forum.inductiveautomation.com/t/automatic-save-report-doesnt-work/21859)
**Author:** [@jens1011](https://forum.inductiveautomation.com/u/jens1011)\ **Replies:** 4\ **Last updated:** [January 14, 2019, 2:05pm UTC](https://forum.inductiveautomation.com/t/automatic-save-report-doesnt-work/21859 "2019-01-14T14:05:34Z")
I want to save a report automatically. now I have written this code, but I still get a pop up to select a path. does anyone know what I’m doing wrong? report = event.source.parent.getComponent(‘Parameter viewer’) d = s… --- ## [Timeout daemon message](https://forum.inductiveautomation.com/t/timeout-daemon-message/21853)
**Author:** [@ltraverso](https://forum.inductiveautomation.com/u/ltraverso)\ **Replies:** 0\ **Last updated:** [January 14, 2019, 7:07am UTC](https://forum.inductiveautomation.com/t/timeout-daemon-message/21853 "2019-01-14T07:07:39Z")
At random intervals, I’m getting the following warning message at the gateway system console: TimeoutDaemon : ScheduledRequest\[com.inductiveautomation.xopc.drivers.siemens.requests.ReadRequest@d74f83c\] request with key … --- ## [File path for FTP location (new)](https://forum.inductiveautomation.com/t/file-path-for-ftp-location-new/21851)
**Author:** [@hendrisvs](https://forum.inductiveautomation.com/u/hendrisvs)\ **Replies:** 0\ **Last updated:** [January 14, 2019, 2:49am UTC](https://forum.inductiveautomation.com/t/file-path-for-ftp-location-new/21851 "2019-01-14T02:49:05Z")
Hi, I have the same problem as this post First prooblem and I can not solve it. I’m trying to put an image from an ftp server in an image component I tried like this, but nothing file:///ftp://user:password@192.168.… --- ## [Difference between tag change scripts and gateway message handler scripts?](https://forum.inductiveautomation.com/t/difference-between-tag-change-scripts-and-gateway-message-handler-scripts/21845)
**Author:** [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Replies:** 1\ **Last updated:** [January 13, 2019, 2:06am UTC](https://forum.inductiveautomation.com/t/difference-between-tag-change-scripts-and-gateway-message-handler-scripts/21845 "2019-01-13T02:06:55Z")
I have an odd situation that I’m running into, and I’m not sure if my troubles are coming from how I’m calling some shared scripts. I have some code that runs on a tag change script. It works fine, but it isn’t the pre… --- ## [system.tag.queryTagCalculations problem](https://forum.inductiveautomation.com/t/system-tag-querytagcalculations-problem/21844)
**Author:** [@dan.wiebe](https://forum.inductiveautomation.com/u/dan.wiebe)\ **Replies:** 1\ **Last updated:** [January 12, 2019, 7:18pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytagcalculations-problem/21844 "2019-01-12T19:18:54Z")
Hi Guys, I Have a problem using this command. In script console i have it working properly. Using a gateway timer script it fails and says cannot multiply nonetype and float. i have done it right in there plus with th… --- ## [Report is blank when saved/emailed from a schedule](https://forum.inductiveautomation.com/t/report-is-blank-when-saved-emailed-from-a-schedule/21816)
**Author:** [@jgibson](https://forum.inductiveautomation.com/u/jgibson)\ **Replies:** 3\ **Last updated:** [January 11, 2019, 4:25pm UTC](https://forum.inductiveautomation.com/t/report-is-blank-when-saved-emailed-from-a-schedule/21816 "2019-01-11T16:25:17Z")
I’ve created a report, that within the preview, displays properly. And when the dash is launched, appears like it should. However, when i attempt to use the built in schedule, to either email the report, or save it local… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1322) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1324)