# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1397 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1398 --- ## [Deciphering a key associated with property overrides](https://forum.inductiveautomation.com/t/deciphering-a-key-associated-with-property-overrides/16567)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 4\ **Last updated:** [January 15, 2018, 11:07pm UTC](https://forum.inductiveautomation.com/t/deciphering-a-key-associated-with-property-overrides/16567 "2018-01-15T23:07:59Z")
I'm trying to dig down on the overrides of a list of UDT instances to get their overrides and have them in at least a semi-readable format. I have some messy code that gets a list of the OverrideMap objects for each inst… --- ## [openURL won't open 2010 Excel xlsx file](https://forum.inductiveautomation.com/t/openurl-wont-open-2010-excel-xlsx-file/5570)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 16\ **Last updated:** [January 15, 2018, 10:57pm UTC](https://forum.inductiveautomation.com/t/openurl-wont-open-2010-excel-xlsx-file/5570 "2018-01-15T22:57:15Z")
I have a button on a window that uses system.net.openURL to open an excel file on a network share. The path is something like '\\\\SharedSystem\\LAB\\Rotation 2013.xls' The lab manager updates that file on a regular basis … --- ## [Issue reading the individual bits within a 16 bit Word](https://forum.inductiveautomation.com/t/issue-reading-the-individual-bits-within-a-16-bit-word/16599)
**Author:** [@SMortensen](https://forum.inductiveautomation.com/u/SMortensen)\ **Replies:** 1\ **Last updated:** [January 15, 2018, 9:43pm UTC](https://forum.inductiveautomation.com/t/issue-reading-the-individual-bits-within-a-16-bit-word/16599 "2018-01-15T21:43:13Z")
Can someone tell me what I am doing wrong? I am trying to read the individual bits within a 16 bit Word and assign each bit to a Tag. Each time I try, I end up with a "Config Error" in the Tag Diagnostics. Below is my se… --- ## [Designer Launch IP Issue](https://forum.inductiveautomation.com/t/designer-launch-ip-issue/16598)
**Author:** [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Replies:** 2\ **Last updated:** [January 15, 2018, 9:12pm UTC](https://forum.inductiveautomation.com/t/designer-launch-ip-issue/16598 "2018-01-15T21:12:28Z")
I have 2 clients, each with distinct VPN software and internal gateway IPs, though I'm only ever connected to one VPN at a time. 1st IP: 192.168.0.72:8088 2nd IP: 10.1.1.193:8088 I've had no issues with the 1st gatewa… --- ## [QAD MFG - OpenEdge DB Querying](https://forum.inductiveautomation.com/t/qad-mfg-openedge-db-querying/16495)
**Author:** [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\ **Replies:** 4\ **Last updated:** [January 15, 2018, 6:49pm UTC](https://forum.inductiveautomation.com/t/qad-mfg-openedge-db-querying/16495 "2018-01-15T18:49:17Z")
I'm attempting to pull live customer order information from an existing ERP system (QAD MFG). The backing data store for their system is a Progress OpenEdge Database. I've successfully installed the OpenEdge JDBC driver … --- ## [Your favorite Jython modules?](https://forum.inductiveautomation.com/t/your-favorite-jython-modules/16529)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 2\ **Last updated:** [January 15, 2018, 5:41pm UTC](https://forum.inductiveautomation.com/t/your-favorite-jython-modules/16529 "2018-01-15T17:41:20Z")
I've been wanting to import NumPy but it looks like due to this being Jython 2.5, that won't be possible. Do you guys have any alternatives, or any other favorite modules you use in Ignition? --- ## [How to assign roles for diferents windows?](https://forum.inductiveautomation.com/t/how-to-assign-roles-for-diferents-windows/16580)
**Author:** [@anibal.marquez](https://forum.inductiveautomation.com/u/anibal.marquez)\ **Replies:** 1\ **Last updated:** [January 12, 2018, 10:57pm UTC](https://forum.inductiveautomation.com/t/how-to-assign-roles-for-diferents-windows/16580 "2018-01-12T22:57:56Z")
I need to implement a system in which only certain users will enter and some will be able to Edit and others only display information without being able to modify them. --- ## [Disabled Button Executes mouseClicked Event Handler](https://forum.inductiveautomation.com/t/disabled-button-executes-mouseclicked-event-handler/16577)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 1\ **Last updated:** [January 12, 2018, 6:26pm UTC](https://forum.inductiveautomation.com/t/disabled-button-executes-mouseclicked-event-handler/16577 "2018-01-12T18:26:01Z")
I am using some standard push buttons to fire off scripts that perform database tasks. The buttons are enabled/disabled based on various conditions. When the buttons are disabled they still fire the mouseClicked event,… --- ## [Report charting with XY chart question](https://forum.inductiveautomation.com/t/report-charting-with-xy-chart-question/16575)
**Author:** [@Jhahn](https://forum.inductiveautomation.com/u/Jhahn)\ **Replies:** 2\ **Last updated:** [January 12, 2018, 4:20pm UTC](https://forum.inductiveautomation.com/t/report-charting-with-xy-chart-question/16575 "2018-01-12T16:20:54Z")
I have a Table/data set that contains the following numbers Reading | Frequency 1.20 | 2 1.30 | 4 1.40 | 6 1.50 |8 If i set the domain key to Frequency and t… --- ## [SQL parts per hour, min, dynamic](https://forum.inductiveautomation.com/t/sql-parts-per-hour-min-dynamic/16517)
**Author:** [@juang](https://forum.inductiveautomation.com/u/juang)\ **Replies:** 14\ **Last updated:** [January 12, 2018, 1:41pm UTC](https://forum.inductiveautomation.com/t/sql-parts-per-hour-min-dynamic/16517 "2018-01-12T13:41:44Z")
Hello, I need to write a a query to report cases per hour, or pallets per hour. the way i have it, it is. i have Runlog table, in that table i have create an entry every time a pallet it is creater with the runid, pal… --- ## [Alarm escalation alternatives](https://forum.inductiveautomation.com/t/alarm-escalation-alternatives/16309)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 4\ **Last updated:** [January 12, 2018, 11:47am UTC](https://forum.inductiveautomation.com/t/alarm-escalation-alternatives/16309 "2018-01-12T11:47:09Z")
Hi, My client would like Alarms to escalate if they are not acknowledged or cleared for some amount of time. They were hoping to be able to change the alarm priority in realtime, which i've discovered we can't do (alar… --- ## [Edit UDT Type (not instance) through script](https://forum.inductiveautomation.com/t/edit-udt-type-not-instance-through-script/16572)
**Author:** [@Esn](https://forum.inductiveautomation.com/u/Esn)\ **Replies:** 1\ **Last updated:** [January 12, 2018, 11:01am UTC](https://forum.inductiveautomation.com/t/edit-udt-type-not-instance-through-script/16572 "2018-01-12T11:01:30Z")
Hi, I need to add a lot of tags to different UDT Types. I can easily create the tags using the system.tag.addTag() function in the script console, but it seems like I cannot add tags to an UDT Type using script. Am I d… --- ## [Report - Retreive Historical Tag Values Greater than X](https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566)
**Author:** [@mlatour](https://forum.inductiveautomation.com/u/mlatour)\ **Replies:** 0\ **Last updated:** [January 11, 2018, 8:38pm UTC](https://forum.inductiveautomation.com/t/report-retreive-historical-tag-values-greater-than-x/16566 "2018-01-11T20:38:47Z")
I was looking to see if it's possible to use the "Tag Historian Query" in the report builder for a tag, but only retrieve values for the tag that are greater than X. We're trying to get the average flow rate over a shif… --- ## [Set IP Camera Viewer Video Mode by Scripting](https://forum.inductiveautomation.com/t/set-ip-camera-viewer-video-mode-by-scripting/16549)
**Author:** [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\ **Replies:** 6\ **Last updated:** [January 11, 2018, 7:27pm UTC](https://forum.inductiveautomation.com/t/set-ip-camera-viewer-video-mode-by-scripting/16549 "2018-01-11T19:27:26Z")
Is there a way to set the IP Camera Viewer Video Mode property by scripting? I have noticed the property is an int datatype. I have tried setting it to 0 and 1 and can't seem to get it to change. --- ## [Julian Date conversion](https://forum.inductiveautomation.com/t/julian-date-conversion/16562)
**Author:** [@k.jain](https://forum.inductiveautomation.com/u/k.jain)\ **Replies:** 7\ **Last updated:** [January 11, 2018, 5:10pm UTC](https://forum.inductiveautomation.com/t/julian-date-conversion/16562 "2018-01-11T17:10:43Z")
Hello, I am trying to store both standard and julian date in mysql database. The query I am using is: INSERT INTO table(StartTime,EndTime,WorkOrder,Shift,trigger,State,JulianDate) VALUES('2018-01-10 19:00:00',null,null,n… --- ## [Jython bin() Not Working](https://forum.inductiveautomation.com/t/jython-bin-not-working/16542)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 8\ **Last updated:** [January 11, 2018, 4:33pm UTC](https://forum.inductiveautomation.com/t/jython-bin-not-working/16542 "2018-01-11T16:33:16Z")
in need to use scripting to do bit manipulation from a DINT I cannot get the jython bin() to work. Is there another version of this in scripting? --- ## [Null Tags and Unknown Quality](https://forum.inductiveautomation.com/t/null-tags-and-unknown-quality/16564)
**Author:** [@stewar2](https://forum.inductiveautomation.com/u/stewar2)\ **Replies:** 0\ **Last updated:** [January 11, 2018, 3:07pm UTC](https://forum.inductiveautomation.com/t/null-tags-and-unknown-quality/16564 "2018-01-11T15:07:54Z")
Hi, I’ve been emailing back and forth with support since Friday but haven’t recieved an email back in a few days so I thought I’d give a shout here to see if anyone could help out. The tags are coming back null with unk… --- ## [Alarm History Report](https://forum.inductiveautomation.com/t/alarm-history-report/16550)
**Author:** [@jose.granero](https://forum.inductiveautomation.com/u/jose.granero)\ **Replies:** 0\ **Last updated:** [January 10, 2018, 6:08pm UTC](https://forum.inductiveautomation.com/t/alarm-history-report/16550 "2018-01-10T18:08:47Z")
I've created a simple alarm history report which just has a table showing the following fields: Event time Active duration Display path Name Event Value I want this last value to be the one which caused the alarm tr… --- ## [Spectre and Meltdown](https://forum.inductiveautomation.com/t/spectre-and-meltdown/16546)
**Author:** [@ClayBuysse](https://forum.inductiveautomation.com/u/ClayBuysse)\ **Replies:** 4\ **Last updated:** [January 11, 2018, 12:38am UTC](https://forum.inductiveautomation.com/t/spectre-and-meltdown/16546 "2018-01-11T00:38:24Z")
Windows recently issued a few updates related to the Spectre and Meltdown bugs. These updates have caused some unforeseen problems with some of my other software and I'm wondering if anyone out there has seen any Igniti… --- ## [Micrologix 1400 TCP and/or UDP Ports Used](https://forum.inductiveautomation.com/t/micrologix-1400-tcp-and-or-udp-ports-used/16554)
**Author:** [@dturner](https://forum.inductiveautomation.com/u/dturner)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 9:25pm UTC](https://forum.inductiveautomation.com/t/micrologix-1400-tcp-and-or-udp-ports-used/16554 "2018-01-10T21:25:52Z")
What ports, UDP and TCP, does the Allen-Bradley Micrologix 1400 driver use to communicate to a Micrologix 1400? I need to configure a router to allow traffic from the PLC to the Ignition Gateway. --- ## [Custom where clause in Transaction Group](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548)
**Author:** [@Peter.Dmitriev](https://forum.inductiveautomation.com/u/Peter.Dmitriev)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 6:14pm UTC](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548 "2018-01-10T18:14:44Z")
Hello, I’m running into issues with AND statement in custom WHERE clause in standard transaction group. Single condition WHERE clause works fine. This works: This doesn’t work: Can anybody advise on what am I … --- ## [Modbus On Deif Delomatic DM400 Gas](https://forum.inductiveautomation.com/t/modbus-on-deif-delomatic-dm400-gas/16530)
**Author:** [@Mike\_Hodgson](https://forum.inductiveautomation.com/u/Mike_Hodgson)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 5:05pm UTC](https://forum.inductiveautomation.com/t/modbus-on-deif-delomatic-dm400-gas/16530 "2018-01-10T17:05:45Z")
Hi, I've a couple of DM400 Gas engine controllers on a site that the client needs data collected from. The Modbus is on port 30000 which Ignition says has a connection, but trying to read the holding registers 0-880 do… --- ## [Expression Tag Type Conversion Error](https://forum.inductiveautomation.com/t/expression-tag-type-conversion-error/16547)
**Author:** [@stewar2](https://forum.inductiveautomation.com/u/stewar2)\ **Replies:** 0\ **Last updated:** [January 10, 2018, 4:56pm UTC](https://forum.inductiveautomation.com/t/expression-tag-type-conversion-error/16547 "2018-01-10T16:56:49Z")
When converting from a Int4 in a expression tag, the Ignition website suggests to use Float4. So I convert my Int4 data point to float with an expression tag, and then evaluate the newly converted tag with the expression… --- ## [Hourglass or other visual indication to indicate history retrieval in progress?](https://forum.inductiveautomation.com/t/hourglass-or-other-visual-indication-to-indicate-history-retrieval-in-progress/16540)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [January 10, 2018, 4:12pm UTC](https://forum.inductiveautomation.com/t/hourglass-or-other-visual-indication-to-indicate-history-retrieval-in-progress/16540 "2018-01-10T16:12:57Z")
Is there any simple way to indicate that the historian is updating when, for example, I change the selected date range for a table or chart? e.g., show the hourglass cursor icon or similar. There are some five to seven… --- ## [Create SQL Database Table via Python](https://forum.inductiveautomation.com/t/create-sql-database-table-via-python/16532)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [January 10, 2018, 8:28am UTC](https://forum.inductiveautomation.com/t/create-sql-database-table-via-python/16532 "2018-01-10T08:28:26Z")
Hi, Is it possible to create a database table in the project's default SQL provider (e.g. MySQL) in Ignition? (Python?) I have tried to use this: SQLCreate = "CREATE TABLE cfgTrends (Area NVARCHAR(25) NOT NULL)" … --- ## [Disk Space Calculation](https://forum.inductiveautomation.com/t/disk-space-calculation/4972)
**Author:** [@rfbuehler](https://forum.inductiveautomation.com/u/rfbuehler)\ **Replies:** 4\ **Last updated:** [January 9, 2018, 7:53pm UTC](https://forum.inductiveautomation.com/t/disk-space-calculation/4972 "2018-01-09T19:53:50Z")
Does anyone have a formula that will allow me to calculate the ammount of disk space required to historical archives? --- ## [Programatically Access Project Browser](https://forum.inductiveautomation.com/t/programatically-access-project-browser/16522)
**Author:** [@salbrechtsen](https://forum.inductiveautomation.com/u/salbrechtsen)\ **Replies:** 2\ **Last updated:** [January 9, 2018, 6:13pm UTC](https://forum.inductiveautomation.com/t/programatically-access-project-browser/16522 "2018-01-09T18:13:58Z")
This might be a long shot, but is there a way to programmatically (through scripting) read folders in the project scope? I am particularly interested in reading/iterating over the folder structure in Project templates fo… --- ## [SQL Query Help - Bulk Insert](https://forum.inductiveautomation.com/t/sql-query-help-bulk-insert/16527)
**Author:** [@jreynolds](https://forum.inductiveautomation.com/u/jreynolds)\ **Replies:** 2\ **Last updated:** [January 9, 2018, 3:59pm UTC](https://forum.inductiveautomation.com/t/sql-query-help-bulk-insert/16527 "2018-01-09T15:59:42Z")
I'm getting a syntax error when I run the following query, from a button. Query: getFrom=r'\\\\wtz-svr-fs-01\\FileShare\\Wentzville\\SeqPublic\\WEN-201 LOC\\Container Management System\\MARS\_Import\\TVS Updated CSV\_Fixed.c… --- ## [VisionWindowOpened Script fires on designer update](https://forum.inductiveautomation.com/t/visionwindowopened-script-fires-on-designer-update/14048)
**Author:** [@lporath](https://forum.inductiveautomation.com/u/lporath)\ **Replies:** 8\ **Last updated:** [January 9, 2018, 2:32pm UTC](https://forum.inductiveautomation.com/t/visionwindowopened-script-fires-on-designer-update/14048 "2018-01-09T14:32:32Z")
Every time I push a designer update to my clients the VisionWindowOpened Script fires causing problems with my application. Is there a way to stop that script from running after an update or an update flag I could use t… --- ## [Client permissions](https://forum.inductiveautomation.com/t/client-permissions/16509)
**Author:** [@Claus\_Nielsen](https://forum.inductiveautomation.com/u/Claus_Nielsen)\ **Replies:** 9\ **Last updated:** [January 9, 2018, 2:23pm UTC](https://forum.inductiveautomation.com/t/client-permissions/16509 "2018-01-09T14:23:12Z")
Hello all, Working on a little project where I need to start a transaction on a database, and up until now I have just used named queries to run SQL commands. Starting a transaction is not possible using named queries … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1396) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1398)