# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1630 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1631 --- ## [Table and Dropdown Insert to DB issue](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 3\ **Last updated:** [June 17, 2018, 8:00pm UTC](https://forum.inductiveautomation.com/t/table-and-dropdown-insert-to-db-issue/18495 "2018-06-17T20:00:30Z")
I can get 1 row to insert but not all the rows in the table. It should loop through each one and avoid the rows where column 1 is blank. --- ## [Other Complementary Trending/Analytic Software Used](https://forum.inductiveautomation.com/t/other-complementary-trending-analytic-software-used/18472)
**Author:** [@jgoodwill](https://forum.inductiveautomation.com/u/jgoodwill)\ **Replies:** 2\ **Last updated:** [June 17, 2018, 12:33pm UTC](https://forum.inductiveautomation.com/t/other-complementary-trending-analytic-software-used/18472 "2018-06-17T12:33:23Z")
I'm still fairly new to Ignition and control system design and I'm curious what other software packages do people use to complement Ignition? While I absolutely love Ignition so far for at the HMI level of controlling m… --- ## [Equipment Schedule refresh help](https://forum.inductiveautomation.com/t/equipment-schedule-refresh-help/18490)
**Author:** [@Brian](https://forum.inductiveautomation.com/u/Brian)\ **Replies:** 2\ **Last updated:** [June 16, 2018, 4:56pm UTC](https://forum.inductiveautomation.com/t/equipment-schedule-refresh-help/18490 "2018-06-16T16:56:52Z")
I'm having trouble refreshing the Equipment Schedule component via scripting. I currently have the Scheduled Items dataset bound to a SQL query, with the polling mode set to absolute and a relatively long time period (n… --- ## [Tag Provider Times Out](https://forum.inductiveautomation.com/t/tag-provider-times-out/18489)
**Author:** [@1jeffwill11](https://forum.inductiveautomation.com/u/1jeffwill11)\ **Replies:** 1\ **Last updated:** [June 16, 2018, 2:14am UTC](https://forum.inductiveautomation.com/t/tag-provider-times-out/18489 "2018-06-16T02:14:34Z")
How many Tags can be typically provided by a single OPC Server before communication problems start to occur? --- ## [Dataset to string index syntax issue. Help please!](https://forum.inductiveautomation.com/t/dataset-to-string-index-syntax-issue-help-please/18465)
**Author:** [@john.eichler](https://forum.inductiveautomation.com/u/john.eichler)\ **Replies:** 5\ **Last updated:** [June 15, 2018, 11:55pm UTC](https://forum.inductiveautomation.com/t/dataset-to-string-index-syntax-issue-help-please/18465 "2018-06-15T23:55:14Z")
Hi I’m new to Ignition so this is probably a very basic problem. Ignition v7.9. I have put together a simple template called ‘Analogue\_Input\_UDT’. The intended function is to display the analogue input in a numeric lab… --- ## [BasicStroke assitance](https://forum.inductiveautomation.com/t/basicstroke-assitance/18486)
**Author:** [@leversole](https://forum.inductiveautomation.com/u/leversole)\ **Replies:** 6\ **Last updated:** [June 15, 2018, 7:48pm UTC](https://forum.inductiveautomation.com/t/basicstroke-assitance/18486 "2018-06-15T19:48:58Z")
Still trying to learn... I have read and re-read the Class java.awt.BasicStroke information and am still not getting it... from org.jfree.chart.plot import ValueMarker from java.awt import BasicStroke marker=ValueM… --- ## [Organizing client launcher applications](https://forum.inductiveautomation.com/t/organizing-client-launcher-applications/18484)
**Author:** [@dboyd](https://forum.inductiveautomation.com/u/dboyd)\ **Replies:** 0\ **Last updated:** [June 15, 2018, 5:08pm UTC](https://forum.inductiveautomation.com/t/organizing-client-launcher-applications/18484 "2018-06-15T17:08:49Z")
Is there a way to organize (hide, group, etc) the list of applications that are shown in the client launcher? --- ## [UaTcpStackClient: Received PublishResponse for unknown requestHandle](https://forum.inductiveautomation.com/t/uatcpstackclient-received-publishresponse-for-unknown-requesthandle/18115)
**Author:** [@chi](https://forum.inductiveautomation.com/u/chi)\ **Replies:** 8\ **Last updated:** [June 15, 2018, 3:32pm UTC](https://forum.inductiveautomation.com/t/uatcpstackclient-received-publishresponse-for-unknown-requesthandle/18115 "2018-06-15T15:32:57Z")
When Ignitions OPC-UA client (V7.8.5) is used with a certain OPC-UA Server (Tani) the log is filled with warnings. Any ideas what might be causing this? INFO | jvm 2 | 2018/05/22 11:45:23 | WARN \[UaTcpStackClien… --- ## [Trying to access a template repeater in a script fired from a mouseClicked event](https://forum.inductiveautomation.com/t/trying-to-access-a-template-repeater-in-a-script-fired-from-a-mouseclicked-event/18476)
**Author:** [@jarredutt](https://forum.inductiveautomation.com/u/jarredutt)\ **Replies:** 3\ **Last updated:** [June 15, 2018, 12:22pm UTC](https://forum.inductiveautomation.com/t/trying-to-access-a-template-repeater-in-a-script-fired-from-a-mouseclicked-event/18476 "2018-06-15T12:22:55Z")
Hello all, I am trying to print out the contents of a template repeater that I’m using as a sort of customized report page. The idea is that they view the graphical representation of the data on one window, and they can… --- ## [Non-datetime Based Scatter Plot](https://forum.inductiveautomation.com/t/non-datetime-based-scatter-plot/18480)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 2\ **Last updated:** [June 15, 2018, 1:30am UTC](https://forum.inductiveautomation.com/t/non-datetime-based-scatter-plot/18480 "2018-06-15T01:30:01Z")
Hi, I would like to display a scatter plot/chart with trend line that isn’t datetime-based. The domain needs to be in ‘hours from start’. A picture tells 1000 words. This is what I want (ignore markers): Is this po… --- ## [Saving and restoring files to and from a database](https://forum.inductiveautomation.com/t/saving-and-restoring-files-to-and-from-a-database/18458)
**Author:** [@ssilk76](https://forum.inductiveautomation.com/u/ssilk76)\ **Replies:** 4\ **Last updated:** [June 14, 2018, 8:34pm UTC](https://forum.inductiveautomation.com/t/saving-and-restoring-files-to-and-from-a-database/18458 "2018-06-14T20:34:02Z")
I am pretty ignorant when it comes to the true power of the database side of ignition. One thing I was wondering is if I can store entire files such as images (.jpg) or drawings (.dxf) in the database itself and be abl… --- ## [Query change causes Null Pointer Exception Error](https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477)
**Author:** [@paul.winslow](https://forum.inductiveautomation.com/u/paul.winslow)\ **Replies:** 2\ **Last updated:** [June 14, 2018, 7:38pm UTC](https://forum.inductiveautomation.com/t/query-change-causes-null-pointer-exception-error/18477 "2018-06-14T19:38:25Z")
Hi All, I'm using Version 7.9.7 and when I need to change a sql query I keep getting a null pointer exception error every time I accept the change. The only way to get out of it is to cancel the changes and delete the cu… --- ## [Template Repeater - Rearrange items by clicking and dragging](https://forum.inductiveautomation.com/t/template-repeater-rearrange-items-by-clicking-and-dragging/18466)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 4\ **Last updated:** [June 14, 2018, 7:12pm UTC](https://forum.inductiveautomation.com/t/template-repeater-rearrange-items-by-clicking-and-dragging/18466 "2018-06-14T19:12:26Z")
Hi, One for the Java experts out there looking for a challenge! I have a template repeater that displays recipe steps and their configuration using a dataset parameter that is initially populated via a SQL query. I mi… --- ## [Insert Select Query results into another DB Table](https://forum.inductiveautomation.com/t/insert-select-query-results-into-another-db-table/18470)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 3\ **Last updated:** [June 14, 2018, 6:13pm UTC](https://forum.inductiveautomation.com/t/insert-select-query-results-into-another-db-table/18470 "2018-06-14T18:13:37Z")
I have a named query using parameters to make a select that returns multiple rows, for example: I want to insert the results into another table, how do I pass the results one row at a time into the insert query? my … --- ## [History data being quarantined as duplicate incorrectly](https://forum.inductiveautomation.com/t/history-data-being-quarantined-as-duplicate-incorrectly/16645)
**Author:** [@kcabatic](https://forum.inductiveautomation.com/u/kcabatic)\ **Replies:** 2\ **Last updated:** [June 14, 2018, 3:44pm UTC](https://forum.inductiveautomation.com/t/history-data-being-quarantined-as-duplicate-incorrectly/16645 "2018-06-14T15:44:32Z")
Hey, I was just wondering if anyone had encountered to this issue with script function system.tag.storeTagHistory We use this twice to write locally and into remote provider: system.tag.storeTagHistory("localprovid… --- ## [SNMP Kimera driver to read and write float](https://forum.inductiveautomation.com/t/snmp-kimera-driver-to-read-and-write-float/18469)
**Author:** [@guipinper](https://forum.inductiveautomation.com/u/guipinper)\ **Replies:** 1\ **Last updated:** [June 14, 2018, 3:38pm UTC](https://forum.inductiveautomation.com/t/snmp-kimera-driver-to-read-and-write-float/18469 "2018-06-14T15:38:04Z")
I’m using the Kimera driver to connect Ignition to a Wiener crate but I’m not being able to read nor write floats to a SNMP tag. I can r/w with integers. About reading: When I try to read I always get the value “9” whic… --- ## [Alarm Status Table details button update on new tag selection](https://forum.inductiveautomation.com/t/alarm-status-table-details-button-update-on-new-tag-selection/18462)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [June 14, 2018, 2:00am UTC](https://forum.inductiveautomation.com/t/alarm-status-table-details-button-update-on-new-tag-selection/18462 "2018-06-14T02:00:40Z")
Hi, When you display the details for an alarm in the alarm status table, it shows for the currently selected alarm, but upon selecting another alarm it doesn't update the details pane for new alarm. How would I go ab… --- ## [Websocket for real time high performant SCADA](https://forum.inductiveautomation.com/t/websocket-for-real-time-high-performant-scada/18194)
**Author:** [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Replies:** 106\ **Last updated:** [June 14, 2018, 12:00pm UTC](https://forum.inductiveautomation.com/t/websocket-for-real-time-high-performant-scada/18194 "2018-06-14T12:00:34Z")
Websocket (ws://) is becoming a preferred protocol than http:// for high speed real time applications like stock market trading, online gaming etc. I think, SCADA manufacturers who adopt this technology will have a stron… --- ## [OPCBrowseTag.getDataType() =\> system.tag.addtag()](https://forum.inductiveautomation.com/t/opcbrowsetag-getdatatype-system-tag-addtag/18460)
**Author:** [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\ **Replies:** 2\ **Last updated:** [June 14, 2018, 1:46am UTC](https://forum.inductiveautomation.com/t/opcbrowsetag-getdatatype-system-tag-addtag/18460 "2018-06-14T01:46:51Z")
Does anyone have a x-ref for Java data type to the string data type accepted by system.tag.addtag() ? Possible basic values are Int1, Int2, Int4, Int8, Float4, Float8, Boolean, String, DataSet, and DateTime. Possible a… --- ## [Getting incorrect values for certain tags from Tag Historian queries in Report](https://forum.inductiveautomation.com/t/getting-incorrect-values-for-certain-tags-from-tag-historian-queries-in-report/18459)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 0\ **Last updated:** [June 13, 2018, 8:20pm UTC](https://forum.inductiveautomation.com/t/getting-incorrect-values-for-certain-tags-from-tag-historian-queries-in-report/18459 "2018-06-13T20:20:22Z")
I’m trying to have a table show different values for a machine at 9 am each day. I wrote a script data source that does this, but I think the raw data I’m pulling from must be off or I’m not pulling the raw data correctl… --- ## [Bar Chart colors](https://forum.inductiveautomation.com/t/bar-chart-colors/18457)
**Author:** [@leversole](https://forum.inductiveautomation.com/u/leversole)\ **Replies:** 2\ **Last updated:** [June 13, 2018, 8:14pm UTC](https://forum.inductiveautomation.com/t/bar-chart-colors/18457 "2018-06-13T20:14:30Z")
I have a chart (bar chart on a report), the data set has multiple rows and three columns, lets call them date, value1, and value2...sometimes, the first row can have a null in one of the value columns, this seems to set… --- ## [Get Label text in template, from Template Repeater (Dataset - Template Parameters) SQL Query](https://forum.inductiveautomation.com/t/get-label-text-in-template-from-template-repeater-dataset-template-parameters-sql-query/18454)
**Author:** [@stan.arimah](https://forum.inductiveautomation.com/u/stan.arimah)\ **Replies:** 2\ **Last updated:** [June 13, 2018, 7:53pm UTC](https://forum.inductiveautomation.com/t/get-label-text-in-template-from-template-repeater-dataset-template-parameters-sql-query/18454 "2018-06-13T19:53:54Z")
Hey, I thought this would be simple enough to do, but I can't seem to get it figured correctly. I have a tank template that has a ClyndricalTank component, a Text label (Tank Name), and a text field (current volume). … --- ## [Data Source Scripting](https://forum.inductiveautomation.com/t/data-source-scripting/18453)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 3\ **Last updated:** [June 13, 2018, 6:29pm UTC](https://forum.inductiveautomation.com/t/data-source-scripting/18453 "2018-06-13T18:29:32Z")
I’m trying to run a script that will filter out the motor speed that doesn’t specifically have the timestamp of 9 am on every day and show two columns of the date at 9 am and the motor speed at that time for multiple day… --- ## [Slide Out Side Menu / Off-Screen Pop-Up](https://forum.inductiveautomation.com/t/slide-out-side-menu-off-screen-pop-up/18268)
**Author:** [@bill.diblasi](https://forum.inductiveautomation.com/u/bill.diblasi)\ **Replies:** 9\ **Last updated:** [June 13, 2018, 6:09pm UTC](https://forum.inductiveautomation.com/t/slide-out-side-menu-off-screen-pop-up/18268 "2018-06-13T18:09:30Z")
I am creating an West Side Menu (Pop-Up window) that slides in from off-screen. There is also a Modal Window (Main Window) which fades in and covers the remainder of the working area. When the side menu slides back off… --- ## [Printing Schedule Reports](https://forum.inductiveautomation.com/t/printing-schedule-reports/18431)
**Author:** [@jarredutt](https://forum.inductiveautomation.com/u/jarredutt)\ **Replies:** 6\ **Last updated:** [June 13, 2018, 5:37pm UTC](https://forum.inductiveautomation.com/t/printing-schedule-reports/18431 "2018-06-13T17:37:05Z")
Hello all, One of the requirements for my current project is to have the ability print out the schedule generated by the schedule manager in Ignition, however I can't seem to find a viable option to do this. Has anyone d… --- ## [Data Visualization Advice (Graphing Question...)](https://forum.inductiveautomation.com/t/data-visualization-advice-graphing-question/16024)
**Author:** [@sanderson](https://forum.inductiveautomation.com/u/sanderson)\ **Replies:** 8\ **Last updated:** [June 13, 2018, 5:20pm UTC](https://forum.inductiveautomation.com/t/data-visualization-advice-graphing-question/16024 "2018-06-13T17:20:17Z")
So I'm collecting data on a production line that I've been graphing as a simple time series, but I don't think a time series is an accurate representation of the data, nor does it make it easy to derive the information I… --- ## [IP Camera Viewer - BL2002M1EI - TKH Security](https://forum.inductiveautomation.com/t/ip-camera-viewer-bl2002m1ei-tkh-security/18440)
**Author:** [@Myllka](https://forum.inductiveautomation.com/u/Myllka)\ **Replies:** 1\ **Last updated:** [June 13, 2018, 4:48pm UTC](https://forum.inductiveautomation.com/t/ip-camera-viewer-bl2002m1ei-tkh-security/18440 "2018-06-13T16:48:25Z")
Hi, We're trying to use an ip camera (BL2002M1EI - TKH Security) on ignition but we got some problems: -the component doesn't always connect to the camera, and show an error 403. After refreshing the address in the com… --- ## [Modbus RTU Connection](https://forum.inductiveautomation.com/t/modbus-rtu-connection/18447)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 4\ **Last updated:** [June 13, 2018, 3:16pm UTC](https://forum.inductiveautomation.com/t/modbus-rtu-connection/18447 "2018-06-13T15:16:52Z")
I have an older Modbus RTU device that I'm trying to connect to via Ignition, but I don't think it has an IP address for the Modbus RTU over TCP driver. How can I establish a connection with it using that driver? --- ## [Report Tables query](https://forum.inductiveautomation.com/t/report-tables-query/18427)
**Author:** [@harryzhou4498](https://forum.inductiveautomation.com/u/harryzhou4498)\ **Replies:** 21\ **Last updated:** [June 13, 2018, 3:10pm UTC](https://forum.inductiveautomation.com/t/report-tables-query/18427 "2018-06-13T15:10:09Z")
I want to use a report table to display certain values taken from tags such as motor speed, motor current, etc. Additionally, I want this data to be shown each day for the past 30 days or so on the table. How can I do th… --- ## [User admin tool](https://forum.inductiveautomation.com/t/user-admin-tool/18425)
**Author:** [@joehahn](https://forum.inductiveautomation.com/u/joehahn)\ **Replies:** 2\ **Last updated:** [June 13, 2018, 2:41pm UTC](https://forum.inductiveautomation.com/t/user-admin-tool/18425 "2018-06-13T14:41:08Z")
I am using 7.9.5 on windows I just discovered a security flaw that was not there before the update. When signed in as a developer only , I can escalate access with in the designer. Step 1. Create a new internal use… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1629) [Next page](https://forum.inductiveautomation.com/latest.md?page=1631)