# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1310 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1311 --- ## [OpenTSDB for historian database?](https://forum.inductiveautomation.com/t/opentsdb-for-historian-database/7871)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [March 12, 2019, 7:28am UTC](https://forum.inductiveautomation.com/t/opentsdb-for-historian-database/7871 "2019-03-12T07:28:09Z")
OpenTSDB for historian database could be a way to store large amount of historian data ? http://opentsdb.net/overview.html --- ## [Can this be Done? I don't understand the scope](https://forum.inductiveautomation.com/t/can-this-be-done-i-dont-understand-the-scope/23230)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 2\ **Last updated:** [March 11, 2019, 11:39pm UTC](https://forum.inductiveautomation.com/t/can-this-be-done-i-dont-understand-the-scope/23230 "2019-03-11T23:39:59Z")
How would I compare the value of a “Numeric Text Field” on windows 1 to the value another “Numeric Text Field” on windows 2. I’m trying to do this with script, but when I look at my Property Reference the other windows … --- ## [How to auto move popup window by mouse action?](https://forum.inductiveautomation.com/t/how-to-auto-move-popup-window-by-mouse-action/9853)
**Author:** [@janlly](https://forum.inductiveautomation.com/u/janlly)\ **Replies:** 3\ **Last updated:** [March 11, 2019, 7:46pm UTC](https://forum.inductiveautomation.com/t/how-to-auto-move-popup-window-by-mouse-action/9853 "2019-03-11T19:46:46Z")
i can used function to get point x,Y: system.gui.convertPointToScreen(event.x, event.y, event) but i don't know how to set the popup window startinglocation value? --- ## [Deleted Windows Folders Keep Appearing Back](https://forum.inductiveautomation.com/t/deleted-windows-folders-keep-appearing-back/23223)
**Author:** [@mbhagotra](https://forum.inductiveautomation.com/u/mbhagotra)\ **Replies:** 0\ **Last updated:** [March 11, 2019, 6:22pm UTC](https://forum.inductiveautomation.com/t/deleted-windows-folders-keep-appearing-back/23223 "2019-03-11T18:22:25Z")
I’m using Ignition 7.9.10 and I’ve noticed that folders in the Windows section of the Project Pane that I’ve deleted in the past keep coming back. The folders I’m deleting are empty or contain empty subfolders. Has any… --- ## [Saving Image from IP Camera Viewer](https://forum.inductiveautomation.com/t/saving-image-from-ip-camera-viewer/23215)
**Author:** [@brian.dame](https://forum.inductiveautomation.com/u/brian.dame)\ **Replies:** 0\ **Last updated:** [March 11, 2019, 3:31pm UTC](https://forum.inductiveautomation.com/t/saving-image-from-ip-camera-viewer/23215 "2019-03-11T15:31:06Z")
Hi, I’m looking for a solution to a problem that I’m having with with storing stills from an IP Camera. I have Axis F1025 camera’s and am using a F44 Control unit for product inspection. Connecting to their feeds and giv… --- ## [File Explorer Component not finding existent path on load](https://forum.inductiveautomation.com/t/file-explorer-component-not-finding-existent-path-on-load/23210)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 1\ **Last updated:** [March 11, 2019, 2:17pm UTC](https://forum.inductiveautomation.com/t/file-explorer-component-not-finding-existent-path-on-load/23210 "2019-03-11T14:17:57Z")
I have a File Explorer component in a parameterized popup window. The popup window gets fed a folder location to be fed to the File Explorer Selected Path component. Now on opening, I see the file path in the Selected … --- ## [Equipment Schedule: Removing days and hours](https://forum.inductiveautomation.com/t/equipment-schedule-removing-days-and-hours/8638)
**Author:** [@ropsukamp](https://forum.inductiveautomation.com/u/ropsukamp)\ **Replies:** 6\ **Last updated:** [March 11, 2019, 1:28pm UTC](https://forum.inductiveautomation.com/t/equipment-schedule-removing-days-and-hours/8638 "2019-03-11T13:28:35Z")
Hi guys, I've been thinking of using the equipment schedule component for a different purpose. The way our company monitors project progression is very similar to the way the this component works so I'd like to use it … --- ## [Create a list from power table](https://forum.inductiveautomation.com/t/create-a-list-from-power-table/23195)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 7\ **Last updated:** [March 11, 2019, 11:24am UTC](https://forum.inductiveautomation.com/t/create-a-list-from-power-table/23195 "2019-03-11T11:24:57Z")
I have Power Table component that has a checkbox column name ‘Request’, this is tied to sql query. I also have a button name ‘Request Materials’ i Have Many colums in this table but we will focus on the one i need to u… --- ## [Alarm query status](https://forum.inductiveautomation.com/t/alarm-query-status/23153)
**Author:** [@oisin.gribben](https://forum.inductiveautomation.com/u/oisin.gribben)\ **Replies:** 3\ **Last updated:** [March 11, 2019, 9:40am UTC](https://forum.inductiveautomation.com/t/alarm-query-status/23153 "2019-03-11T09:40:55Z")
We are trying to run a client tag change script on an ignition edge install. in the script we are running the system.alarm.querystatus function but it doesn’t seem to be working. Is there any issues with running this f… --- ## [Changing Component Background with Script](https://forum.inductiveautomation.com/t/changing-component-background-with-script/23204)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 2\ **Last updated:** [March 11, 2019, 2:08am UTC](https://forum.inductiveautomation.com/t/changing-component-background-with-script/23204 "2019-03-11T02:08:52Z")
Hello: I can’t get this to work and I don’t know what I’m doing wrong. (I get no errors, but does not change colors!) ‘’‘if “W1Flow” \> “W1Setpoint” : W1FPress = event.source W1FPress.background = system.gui.color(255… --- ## [Coloring Python Syntax Inside a Label automatically. (pygments package)](https://forum.inductiveautomation.com/t/coloring-python-syntax-inside-a-label-automatically-pygments-package/23202)
**Author:** [@MicroVAX\_II](https://forum.inductiveautomation.com/u/MicroVAX_II)\ **Replies:** 3\ **Last updated:** [March 11, 2019, 1:49am UTC](https://forum.inductiveautomation.com/t/coloring-python-syntax-inside-a-label-automatically-pygments-package/23202 "2019-03-11T01:49:32Z")
Hi, For training purposes, we would like to color python syntax inside a label. The pygments python package would work the best for me. What are some best methods to import this package into ignition? (Linux and Window… --- ## [Urllib2 Certificate In Ignition Jython](https://forum.inductiveautomation.com/t/urllib2-certificate-in-ignition-jython/17509)
**Author:** [@michael.thompson](https://forum.inductiveautomation.com/u/michael.thompson)\ **Replies:** 3\ **Last updated:** [March 11, 2019, 12:07am UTC](https://forum.inductiveautomation.com/t/urllib2-certificate-in-ignition-jython/17509 "2019-03-11T00:07:40Z")
I am trying to integrate a python script into my Ignition project. The script uses urllib2 library to access a 3rd party API. A certificate is required for API access. The code works in Python 2.5, but I get this error w… --- ## [Transactions (system.db)](https://forum.inductiveautomation.com/t/transactions-system-db/23199)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 1\ **Last updated:** [March 10, 2019, 1:12pm UTC](https://forum.inductiveautomation.com/t/transactions-system-db/23199 "2019-03-10T13:12:05Z")
Is there a way for ignition to prevent two transactions from going at the same time. example two clients make the same exact action(executing a DB transaction, the same transaction) , at the same exact time( I know i… --- ## [Selecting Matching Records from Different Historian Tables](https://forum.inductiveautomation.com/t/selecting-matching-records-from-different-historian-tables/23198)
**Author:** [@Sam.Naji](https://forum.inductiveautomation.com/u/Sam.Naji)\ **Replies:** 1\ **Last updated:** [March 10, 2019, 1:09pm UTC](https://forum.inductiveautomation.com/t/selecting-matching-records-from-different-historian-tables/23198 "2019-03-10T13:09:57Z")
I have several Historian tables with hundreds of records. Each table consists of two columns. One column has Date Stamp values, and the other contains integer values. I also have the Date Range component that has time v… --- ## [Global Variable](https://forum.inductiveautomation.com/t/global-variable/23194)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 4\ **Last updated:** [March 9, 2019, 10:34pm UTC](https://forum.inductiveautomation.com/t/global-variable/23194 "2019-03-09T22:34:19Z")
I can’t figure this out. I’m trying to set a GLOBAL variable. ConfimIndex = 1 I want to be able to read ConfirmIndex from anywhere in the program(all screens) I have tried system.util.getGlobal()\[ConfirmIndex\] = 1 B… --- ## [Observation on my system logins(desktop client vs Mobile)](https://forum.inductiveautomation.com/t/observation-on-my-system-logins-desktop-client-vs-mobile/23192)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 1\ **Last updated:** [March 9, 2019, 3:23pm UTC](https://forum.inductiveautomation.com/t/observation-on-my-system-logins-desktop-client-vs-mobile/23192 "2019-03-09T15:23:57Z")
With the upcoming release of Ignition 8 and the perspective module, I just wanted to share some internal tracking I have been doing to make sure we are dedicating our resources to the needs of our customers. Basically I … --- ## [Power Table in script](https://forum.inductiveautomation.com/t/power-table-in-script/23185)
**Author:** [@brian.ankeny](https://forum.inductiveautomation.com/u/brian.ankeny)\ **Replies:** 0\ **Last updated:** [March 8, 2019, 10:59pm UTC](https://forum.inductiveautomation.com/t/power-table-in-script/23185 "2019-03-08T22:59:55Z")
Is there a way to change the displayed column names for a power table through scripting? I added logic to a property change script to update the columnAttributesData but the power table doesn’t apply the changes. --- ## [Tag missing box over a block? Not sure what this means](https://forum.inductiveautomation.com/t/tag-missing-box-over-a-block-not-sure-what-this-means/23181)
**Author:** [@jparsons](https://forum.inductiveautomation.com/u/jparsons)\ **Replies:** 2\ **Last updated:** [March 8, 2019, 9:04pm UTC](https://forum.inductiveautomation.com/t/tag-missing-box-over-a-block-not-sure-what-this-means/23181 "2019-03-08T21:04:37Z")
Hello, I started working with ignition yesterday and I have come a long way since but I have been dealing with this issue all day. I do not know what this means. I assume there is some tag issue but this is part of a da… --- ## [Deleting Nested datatypes](https://forum.inductiveautomation.com/t/deleting-nested-datatypes/23180)
**Author:** [@jparsons](https://forum.inductiveautomation.com/u/jparsons)\ **Replies:** 1\ **Last updated:** [March 8, 2019, 8:20pm UTC](https://forum.inductiveautomation.com/t/deleting-nested-datatypes/23180 "2019-03-08T20:20:00Z")
Hello, I accidentally dragged a datatype into itself creating a nested datatype. I can’t delete it. Does anyone know of a way to do that besides deleting the whole thing and rebuilding the datatype? --- ## [Upgrading from 7.5?](https://forum.inductiveautomation.com/t/upgrading-from-7-5/23178)
**Author:** [@slishj](https://forum.inductiveautomation.com/u/slishj)\ **Replies:** 1\ **Last updated:** [March 8, 2019, 8:18pm UTC](https://forum.inductiveautomation.com/t/upgrading-from-7-5/23178 "2019-03-08T20:18:18Z")
Product engineer here. Working with maintenance technician to duplicate a station in a system that was installed in our facility ~7 years ago. How much of a nightmare would it be to upgrade our Ignition from 7.5? TBH, t… --- ## [Gateway failing to start](https://forum.inductiveautomation.com/t/gateway-failing-to-start/23173)
**Author:** [@michael.palmer](https://forum.inductiveautomation.com/u/michael.palmer)\ **Replies:** 4\ **Last updated:** [March 8, 2019, 6:42pm UTC](https://forum.inductiveautomation.com/t/gateway-failing-to-start/23173 "2019-03-08T18:42:46Z")
ok, so I have a test computer that I was running something like 7.3 or something. I wanted to see the beta 8 software so i upgraded to that. Everything seemed fine except I wanted to go back to the latest version, so I… --- ## [Java mission control/Client slowdown](https://forum.inductiveautomation.com/t/java-mission-control-client-slowdown/23147)
**Author:** [@akettner](https://forum.inductiveautomation.com/u/akettner)\ **Replies:** 5\ **Last updated:** [March 8, 2019, 6:28pm UTC](https://forum.inductiveautomation.com/t/java-mission-control-client-slowdown/23147 "2019-03-08T18:28:33Z")
The first time I posted this was in General Discussion, which might be the wrong place so I will try here. I have a small Ignition application that has been running fine for about a month, and now things seem to be slow… --- ## [Display Label on Each point of an XYChart](https://forum.inductiveautomation.com/t/display-label-on-each-point-of-an-xychart/23159)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 2\ **Last updated:** [March 8, 2019, 4:08pm UTC](https://forum.inductiveautomation.com/t/display-label-on-each-point-of-an-xychart/23159 "2019-03-08T16:08:42Z")
Hi All, As the title says, I would like to have a label on top of each XYChart’s point. The final goal is shown in the picture below: I know how to display the value for each point: from org.jfree.chart.labels imp… --- ## [SQL Problem with date variable](https://forum.inductiveautomation.com/t/sql-problem-with-date-variable/23160)
**Author:** [@keith.hyder](https://forum.inductiveautomation.com/u/keith.hyder)\ **Replies:** 4\ **Last updated:** [March 8, 2019, 2:50pm UTC](https://forum.inductiveautomation.com/t/sql-problem-with-date-variable/23160 "2019-03-08T14:50:46Z")
Having issue with my date argument. Not sure what else to do to get it to accept. date = system.date.now() value1 = system.date.format(date, "yyyy/MM/dd HH:mm:ss") system.gui.messageBox(value1) query = ''' SELECT Rtrim… --- ## [MSSQL read only account causing 18456 errors](https://forum.inductiveautomation.com/t/mssql-read-only-account-causing-18456-errors/23156)
**Author:** [@jaysteffen](https://forum.inductiveautomation.com/u/jaysteffen)\ **Replies:** 0\ **Last updated:** [March 8, 2019, 1:23pm UTC](https://forum.inductiveautomation.com/t/mssql-read-only-account-causing-18456-errors/23156 "2019-03-08T13:23:58Z")
I have a MSSQL database connection set up with a read only account. The connection is valid but when I check event viewer on the SQL server it is showing several 18456 events. Looking into it further, it is because it … --- ## [Using SQL Queries in charts (sparkline)](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [March 6, 2019, 12:38pm UTC](https://forum.inductiveautomation.com/t/using-sql-queries-in-charts-sparkline/23091 "2019-03-06T12:38:42Z")
I’m trying to use an SQL query to populate the data in a sparkline chart, however I get the following error in the diagnostics viewer on the component: data$CONFIG: Config Error My query is simply: SELECT logged\_on, ba… --- ## [Docked screen is different in Designer and in Launcher](https://forum.inductiveautomation.com/t/docked-screen-is-different-in-designer-and-in-launcher/23139)
**Author:** [@bchristenson](https://forum.inductiveautomation.com/u/bchristenson)\ **Replies:** 4\ **Last updated:** [March 7, 2019, 10:02pm UTC](https://forum.inductiveautomation.com/t/docked-screen-is-different-in-designer-and-in-launcher/23139 "2019-03-07T22:02:59Z")
Hi, I have a docked window that I use in all my screens. However in my designer i get everything fitted like i want it but when I lanch this project some objects keep moving or are not on the same spot as they are in my… --- ## [Passing server path to PDF Viewer losing "\\"](https://forum.inductiveautomation.com/t/passing-server-path-to-pdf-viewer-losing/23142)
**Author:** [@nicklas.thystrup](https://forum.inductiveautomation.com/u/nicklas.thystrup)\ **Replies:** 1\ **Last updated:** [March 7, 2019, 9:25pm UTC](https://forum.inductiveautomation.com/t/passing-server-path-to-pdf-viewer-losing/23142 "2019-03-07T21:25:15Z")
I have created a popup with the PDF viewer component on it and am passing in the filepath as a string custom property on the screen. However, when I pass in a network file path such as \\192.178.89.199\\Ignition Shared Fi… --- ## [Opening a 7.8.2 Project with 7.9.10 Client](https://forum.inductiveautomation.com/t/opening-a-7-8-2-project-with-7-9-10-client/23117)
**Author:** [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\ **Replies:** 8\ **Last updated:** [March 7, 2019, 5:55pm UTC](https://forum.inductiveautomation.com/t/opening-a-7-8-2-project-with-7-9-10-client/23117 "2019-03-07T17:55:42Z")
As the title says I have an old server that is in dire need of an upgrade. My big problem is that I have about 50 terminals in the field that autostart the JNLP file, AND are locked into Java 1.6 JRE. I was hoping that… --- ## [Tag Historian, retire all tags](https://forum.inductiveautomation.com/t/tag-historian-retire-all-tags/23133)
**Author:** [@denis.palomanes](https://forum.inductiveautomation.com/u/denis.palomanes)\ **Replies:** 0\ **Last updated:** [March 7, 2019, 5:11pm UTC](https://forum.inductiveautomation.com/t/tag-historian-retire-all-tags/23133 "2019-03-07T17:11:36Z")
Hello, We have a couple of thousand tags duplicated in the table “sqlth\_te” with retired = null. We are thinking about to set retired = “date” to all the tags, and restarts Ignition. When this happens, Ignition will be … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1309) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1311)