# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1798 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1799 --- ## [Connection to a PI Database](https://forum.inductiveautomation.com/t/connection-to-a-pi-database/9673)
**Author:** [@Kamal\_Lang](https://forum.inductiveautomation.com/u/Kamal_Lang)\ **Replies:** 3\ **Last updated:** [February 9, 2015, 11:26am UTC](https://forum.inductiveautomation.com/t/connection-to-a-pi-database/9673 "2015-02-09T11:26:57Z")
Hi, I was wondering if anybody has experiance in connecting Ignition to a PI database from OSIsoft. I am an in the investigation phase with a customer that is asking if Ignition can connect to his PI database. So any he… --- ## [Beveled Border Color](https://forum.inductiveautomation.com/t/beveled-border-color/9667)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 1\ **Last updated:** [February 6, 2015, 7:07pm UTC](https://forum.inductiveautomation.com/t/beveled-border-color/9667 "2015-02-06T19:07:59Z")
It would be nice to have the double beveled edge of a component (like a numeric label) be a different color than the background. Since I don't think this is a feature in Ignition, can someone explain how I can modify th… --- ## [Window Minize Button Script](https://forum.inductiveautomation.com/t/window-minize-button-script/9672)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [February 6, 2015, 4:27pm UTC](https://forum.inductiveautomation.com/t/window-minize-button-script/9672 "2015-02-06T16:27:00Z")
is there a way in scripting to duplicate the function of the Windows Minimize button? I would like to create a button on the main screen that minimizes the running client. On touch screens, operators with fat fingers… --- ## [Change Pen Color based on its Tag's Value](https://forum.inductiveautomation.com/t/change-pen-color-based-on-its-tags-value/9664)
**Author:** [@Samn265](https://forum.inductiveautomation.com/u/Samn265)\ **Replies:** 1\ **Last updated:** [February 6, 2015, 4:05pm UTC](https://forum.inductiveautomation.com/t/change-pen-color-based-on-its-tags-value/9664 "2015-02-06T16:05:30Z")
I have a chart that I would like to change the color of its pen to Red/Yellow/Green based on its tag value. Is there anyway to do this? or is there other methods to accomplish this function? Thanks, Sam --- ## [Database error when logging to alarm journal](https://forum.inductiveautomation.com/t/database-error-when-logging-to-alarm-journal/9467)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 3\ **Last updated:** [February 6, 2015, 3:55pm UTC](https://forum.inductiveautomation.com/t/database-error-when-logging-to-alarm-journal/9467 "2015-02-06T15:55:23Z")
We've set up an alarm journal and are getting a database error every time the tag goes into its alarm state. The error as logged on the console is: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found w… --- ## [Connecting to Eurotherm 2500 processor](https://forum.inductiveautomation.com/t/connecting-to-eurotherm-2500-processor/9669)
**Author:** [@Special\_tec](https://forum.inductiveautomation.com/u/Special_tec)\ **Replies:** 1\ **Last updated:** [February 6, 2015, 1:52pm UTC](https://forum.inductiveautomation.com/t/connecting-to-eurotherm-2500-processor/9669 "2015-02-06T13:52:59Z")
Does anybody know if you can connect directly to a Eurotherm 2500 Ethernet processor? Are any specific drivers required? --- ## [Event Driven Protocols](https://forum.inductiveautomation.com/t/event-driven-protocols/9643)
**Author:** [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\ **Replies:** 8\ **Last updated:** [February 6, 2015, 5:08am UTC](https://forum.inductiveautomation.com/t/event-driven-protocols/9643 "2015-02-06T05:08:14Z")
Just wondering if anyone has used an event driven protocol in Ignition yet? We have a few applications where they make a lot of sense. If you have how was your experience and what protocols did you use? I have had mi… --- ## [Issues with single quotes and commas in data being loaded](https://forum.inductiveautomation.com/t/issues-with-single-quotes-and-commas-in-data-being-loaded/9612)
**Author:** [@destino](https://forum.inductiveautomation.com/u/destino)\ **Replies:** 5\ **Last updated:** [February 5, 2015, 11:47pm UTC](https://forum.inductiveautomation.com/t/issues-with-single-quotes-and-commas-in-data-being-loaded/9612 "2015-02-05T23:47:39Z")
Greetings. I'm after some guidance about how folks deal with text that contains commas and/or single quotes when they are submitted as part of an insert or update to a SQL Server Database. Is there any inbuilt functi… --- ## [Mobile client takes multiple tries to login](https://forum.inductiveautomation.com/t/mobile-client-takes-multiple-tries-to-login/9569)
**Author:** [@Chris\_George](https://forum.inductiveautomation.com/u/Chris_George)\ **Replies:** 2\ **Last updated:** [February 5, 2015, 9:58pm UTC](https://forum.inductiveautomation.com/t/mobile-client-takes-multiple-tries-to-login/9569 "2015-02-05T21:58:00Z")
Sorry this ground has been trod in previous posts. I tried the proposed solutions and none of them seem to work. My mobile client won’t launch immediately on iPhone 6 or iPhone 5 or Android. It takes 1-7 restarts before … --- ## [Listing 3rd party licenses](https://forum.inductiveautomation.com/t/listing-3rd-party-licenses/9665)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 2\ **Last updated:** [February 5, 2015, 9:26pm UTC](https://forum.inductiveautomation.com/t/listing-3rd-party-licenses/9665 "2015-02-05T21:26:31Z")
If I develop a module and use 3rd party code in it, is there a place to display the required licenses? or an EULA for the module? --- ## [Web browser URL for client](https://forum.inductiveautomation.com/t/web-browser-url-for-client/9663)
**Author:** [@jhortig](https://forum.inductiveautomation.com/u/jhortig)\ **Replies:** 2\ **Last updated:** [February 5, 2015, 5:41pm UTC](https://forum.inductiveautomation.com/t/web-browser-url-for-client/9663 "2015-02-05T17:41:19Z")
I'm using using the web browser to display html files in Ignition. On the server computer the URL to my file is: file:///D:/Maint.html - everything works fine. Doing the same on a client I get the message: … --- ## [Trouble displaying historical table data](https://forum.inductiveautomation.com/t/trouble-displaying-historical-table-data/9637)
**Author:** [@dgillis](https://forum.inductiveautomation.com/u/dgillis)\ **Replies:** 3\ **Last updated:** [February 5, 2015, 5:32pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-historical-table-data/9637 "2015-02-05T17:32:17Z")
Hi everyone. First off, I’m relatively new to Ignition. I’m having trouble displaying table data the way I’d like to. Ignition is running on a Win7 x64 system. I have updated from 7.7.1 to 7.7.2 in the process of tro… --- ## [Impossible to stop this alarm](https://forum.inductiveautomation.com/t/impossible-to-stop-this-alarm/9507)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 3\ **Last updated:** [February 5, 2015, 4:32pm UTC](https://forum.inductiveautomation.com/t/impossible-to-stop-this-alarm/9507 "2015-02-05T16:32:57Z")
Hi all, I’m loosing my mind trying to stop an alarm from coming up. Every second or two for a couple weeks now I’ve been getting an alarm from a tag. Originally the tag was configured with the alarm, but when I notice… --- ## [Bar chart data property](https://forum.inductiveautomation.com/t/bar-chart-data-property/9661)
**Author:** [@pascal](https://forum.inductiveautomation.com/u/pascal)\ **Replies:** 2\ **Last updated:** [February 5, 2015, 3:45pm UTC](https://forum.inductiveautomation.com/t/bar-chart-data-property/9661 "2015-02-05T15:45:32Z")
Hello everyone, I’m actually facing a problem with the Bar chart component in the 7.7.2 Version of Ignition. When i bind the data property to a SQL query, i have nothing displayed on the chart (as you can see int he att… --- ## [UDP Config](https://forum.inductiveautomation.com/t/udp-config/9662)
**Author:** [@TomPedlar](https://forum.inductiveautomation.com/u/TomPedlar)\ **Replies:** 0\ **Last updated:** [February 5, 2015, 3:28pm UTC](https://forum.inductiveautomation.com/t/udp-config/9662 "2015-02-05T15:28:15Z")
Hi, I’m trying to configure a UDP connection using version 7.7.2.rc1 but can’t get it to connect. My settings are :- Name Concentration Port 10003 Address 10.0.0.10 Message Delimiter Type Fixed Size Message De… --- ## [Database transaction closed](https://forum.inductiveautomation.com/t/database-transaction-closed/3787)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 4\ **Last updated:** [February 5, 2015, 10:46am UTC](https://forum.inductiveautomation.com/t/database-transaction-closed/3787 "2015-02-05T10:46:24Z")
Am I using the database transaction correctly? It appears to me that the transaction timeout is not be reset because when I select a small amount of rows it works fine. A large set of rows throws the error. I am rece… --- ## [Connecting MariaDB to Ignition](https://forum.inductiveautomation.com/t/connecting-mariadb-to-ignition/9659)
**Author:** [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\ **Replies:** 0\ **Last updated:** [February 5, 2015, 6:19am UTC](https://forum.inductiveautomation.com/t/connecting-mariadb-to-ignition/9659 "2015-02-05T06:19:14Z")
I made up a quick and dirty document on how to connect MariaDB to Ignition. It’s attached below. MariaDB Ignition Tutorial.pdf (1010 KB) --- ## [7.7.2 Upgrade - CPU Usage Issues](https://forum.inductiveautomation.com/t/7-7-2-upgrade-cpu-usage-issues/9658)
**Author:** [@Jerry\_Wu](https://forum.inductiveautomation.com/u/Jerry_Wu)\ **Replies:** 0\ **Last updated:** [February 5, 2015, 6:08am UTC](https://forum.inductiveautomation.com/t/7-7-2-upgrade-cpu-usage-issues/9658 "2015-02-05T06:08:50Z")
I'm having issues upgrading from 7.7.2 from 7.7.1. Prior to the upgrade, CPU usage is 7-11%. After upgrade it shoots up to 57-66% (occasionally higher). Tags in the database are not able to maintain connection and scr… --- ## [Select last DB entry](https://forum.inductiveautomation.com/t/select-last-db-entry/9656)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 5\ **Last updated:** [February 5, 2015, 3:45am UTC](https://forum.inductiveautomation.com/t/select-last-db-entry/9656 "2015-02-05T03:45:23Z")
From the following query, what do I need to add to be able to select the last row only. Can either be the index number or t\_stamp. SELECT ACC\_2\_Piston\_Pressure, Back\_Pressure\_SP, Back\_Pressure\_Time, Charged\_Volume, … --- ## [COUNT Query Not Working](https://forum.inductiveautomation.com/t/count-query-not-working/9655)
**Author:** [@Automator59](https://forum.inductiveautomation.com/u/Automator59)\ **Replies:** 2\ **Last updated:** [February 4, 2015, 11:43pm UTC](https://forum.inductiveautomation.com/t/count-query-not-working/9655 "2015-02-04T23:43:28Z")
I am trying to get a count of the number of rows in a MS SQL database through a script query. I have a Popup Calendar object and when the user selects the date, it will check to see if that week is in the database (coun… --- ## [Binding 2 or more bits to Fill Paint property](https://forum.inductiveautomation.com/t/binding-2-or-more-bits-to-fill-paint-property/9654)
**Author:** [@CA\_HMIDev](https://forum.inductiveautomation.com/u/CA_HMIDev)\ **Replies:** 1\ **Last updated:** [February 4, 2015, 8:38pm UTC](https://forum.inductiveautomation.com/t/binding-2-or-more-bits-to-fill-paint-property/9654 "2015-02-04T20:38:05Z")
Hi there. I'd like to have the 'Fill Paint' property of a conveyor belt depend on 2 bits. When 2 bits are true, the belt is green. When either one of the 2 bits is true, the color is different (according to which 1 of th… --- ## [Barcode Scanner Component Help](https://forum.inductiveautomation.com/t/barcode-scanner-component-help/9653)
**Author:** [@DWeber](https://forum.inductiveautomation.com/u/DWeber)\ **Replies:** 0\ **Last updated:** [February 4, 2015, 5:01pm UTC](https://forum.inductiveautomation.com/t/barcode-scanner-component-help/9653 "2015-02-04T17:01:36Z")
I am trying to use the barcode scanner component. I want the operator to scan a barcode without having to select a text box and have the barcode automatically captured. How exactly does this component work? --- ## [Ignition Client Lost Comm from Master Server](https://forum.inductiveautomation.com/t/ignition-client-lost-comm-from-master-server/9632)
**Author:** [@xion8x8](https://forum.inductiveautomation.com/u/xion8x8)\ **Replies:** 5\ **Last updated:** [February 4, 2015, 3:48pm UTC](https://forum.inductiveautomation.com/t/ignition-client-lost-comm-from-master-server/9632 "2015-02-04T15:48:07Z")
Today my customer encountered intermittent gateway lost comm on client computer every few seconds. Two client computers had encountered this today (not at the same time, few hours apart). Both clients have been running c… --- ## [How to show day before for date](https://forum.inductiveautomation.com/t/how-to-show-day-before-for-date/9650)
**Author:** [@pstojakovic](https://forum.inductiveautomation.com/u/pstojakovic)\ **Replies:** 4\ **Last updated:** [February 4, 2015, 12:02am UTC](https://forum.inductiveautomation.com/t/how-to-show-day-before-for-date/9650 "2015-02-04T00:02:37Z")
What is the script to display date, one day before today(current date), for Date Range component? for example I have this: import datetime date\_component = system.gui.getParentWindow(event).getComponentForPath('Root Cont… --- ## [Checking if a user is in an AD Hybrid user source](https://forum.inductiveautomation.com/t/checking-if-a-user-is-in-an-ad-hybrid-user-source/9635)
**Author:** [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Replies:** 2\ **Last updated:** [February 3, 2015, 10:40pm UTC](https://forum.inductiveautomation.com/t/checking-if-a-user-is-in-an-ad-hybrid-user-source/9635 "2015-02-03T22:40:49Z")
Hi Guys, I have 2 user sources, 1 is a local and 1 is an AD Hybrid I would like to be able to open a different window on a clients startup depending on if the user (windows login) is in the AD Hybrid or not. can yo… --- ## [Easy Chart customizing background color](https://forum.inductiveautomation.com/t/easy-chart-customizing-background-color/9648)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [February 3, 2015, 9:13pm UTC](https://forum.inductiveautomation.com/t/easy-chart-customizing-background-color/9648 "2015-02-03T21:13:41Z")
We have a request from a customer regarding dynamically changing the background colour of the easy chart based on a tag value. The charts look like this , for a standard application we developed to record CIP ( Clean In… --- ## [My first script... does not work](https://forum.inductiveautomation.com/t/my-first-script-does-not-work/9591)
**Author:** [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\ **Replies:** 7\ **Last updated:** [February 3, 2015, 5:47pm UTC](https://forum.inductiveautomation.com/t/my-first-script-does-not-work/9591 "2015-02-03T17:47:31Z")
I am trying to set the Date (immediate) of a Calendar object when a window is first opened. So I create a script on the internalFrameOpened event of the window. I first tried the Set property ta\\b. This got me the path t… --- ## [Refresh OPC Value](https://forum.inductiveautomation.com/t/refresh-opc-value/9614)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 7\ **Last updated:** [February 3, 2015, 3:55pm UTC](https://forum.inductiveautomation.com/t/refresh-opc-value/9614 "2015-02-03T15:55:34Z")
Is there a way to refresh a tags OPC value? I have tags that are running in a 10 minute scan class, what I'm looking to do is when the user opens a window to view an individual tag, I want to update that tag's OPC value… --- ## [Controllogix v21+ Connection Path](https://forum.inductiveautomation.com/t/controllogix-v21-connection-path/9647)
**Author:** [@sfitze](https://forum.inductiveautomation.com/u/sfitze)\ **Replies:** 1\ **Last updated:** [February 3, 2015, 3:01pm UTC](https://forum.inductiveautomation.com/t/controllogix-v21-connection-path/9647 "2015-02-03T15:01:42Z")
Is there any plans to implement connection paths in the new ControlLogix v21+ driver? --- ## [Mass Inserts MySQL](https://forum.inductiveautomation.com/t/mass-inserts-mysql/9646)
**Author:** [@EricFrancoeur](https://forum.inductiveautomation.com/u/EricFrancoeur)\ **Replies:** 1\ **Last updated:** [February 3, 2015, 2:33pm UTC](https://forum.inductiveautomation.com/t/mass-inserts-mysql/9646 "2015-02-03T14:33:06Z")
Hello, Well I have to insert a 1000 to 10000 rows array (dtaMSSQLAllPieces) with a wooping 7 columns into my MySQL database (ProdRestigouche) I'm testing the runPrepUdpate with a Transaction Token and the behavior se… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1797) [Next page](https://forum.inductiveautomation.com/latest.md?page=1799)