# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=574 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 575 --- ## [Mongodb gateway calls throw unhandled exceptions](https://forum.inductiveautomation.com/t/mongodb-gateway-calls-throw-unhandled-exceptions/79123)
**Author:** [@sherman](https://forum.inductiveautomation.com/u/sherman)\ **Replies:** 8\ **Last updated:** [September 15, 2023, 12:33am UTC](https://forum.inductiveautomation.com/t/mongodb-gateway-calls-throw-unhandled-exceptions/79123 "2023-09-15T00:33:57Z")
I'm trying to build a functional interface to a basic mongodb database, and boy is it not falling into place easily. I have already given up on building a general gateway script executor so I can call normal mongodb meth… --- ## [Cannot delete user source](https://forum.inductiveautomation.com/t/cannot-delete-user-source/57696)
**Author:** [@ASF](https://forum.inductiveautomation.com/u/ASF)\ **Replies:** 8\ **Last updated:** [September 15, 2023, 12:19am UTC](https://forum.inductiveautomation.com/t/cannot-delete-user-source/57696 "2023-09-15T00:19:26Z")
Currently picking up a project started by someone else who has left. There were two user sources in addition to the default; temp and temp\_0, noted as “temporary user source profile created during password reset”. I was … --- ## [Dnp3 communication issue](https://forum.inductiveautomation.com/t/dnp3-communication-issue/78818)
**Author:** [@SOMNATH\_PAUL](https://forum.inductiveautomation.com/u/SOMNATH_PAUL)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 11:30pm UTC](https://forum.inductiveautomation.com/t/dnp3-communication-issue/78818 "2023-09-14T23:30:39Z")
I am using Pheonix rtu i(ILC-191-ETH-2TX).Sometimes tags are shown and sometime not. Also we are write and read from the browser .But that time values are shown bad in in ignition design launcher. --- ## [Report Data Differs from Power Chart](https://forum.inductiveautomation.com/t/report-data-differs-from-power-chart/78777)
**Author:** [@cole.young34](https://forum.inductiveautomation.com/u/cole.young34)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 11:12pm UTC](https://forum.inductiveautomation.com/t/report-data-differs-from-power-chart/78777 "2023-09-14T23:12:56Z")
Hi I have a report that is doing a tag history query with the following settings. On the preview tab, it appears that it is returning the Min value as the Max value for the flowHr1 data key. \ \202… --- ## [Tag Event Script 'Value Changed' firing twice?](https://forum.inductiveautomation.com/t/tag-event-script-value-changed-firing-twice/17709)
**Author:** [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Replies:** 7\ **Last updated:** [September 14, 2023, 10:39pm UTC](https://forum.inductiveautomation.com/t/tag-event-script-value-changed-firing-twice/17709 "2023-09-14T22:39:08Z")
Hey folks, 7.9.7 x64 Java 1.8.0\_144 Windows 7 We have a boolean notification tag from the PLC that, on value change, triggers a SQL query. The script is executing, and the query is correct. The problem I am experie… --- ## [Engineering uniti in email notification](https://forum.inductiveautomation.com/t/engineering-uniti-in-email-notification/78727)
**Author:** [@Francesco\_Aria](https://forum.inductiveautomation.com/u/Francesco_Aria)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 10:35pm UTC](https://forum.inductiveautomation.com/t/engineering-uniti-in-email-notification/78727 "2023-09-14T22:35:15Z")
Good morning. In a pipe line in an email notification block, is possible also send the engineering unit of the tag immediately after an {eventValue}? Thanks --- ## [Perspective Video Component "Error Loading Media"](https://forum.inductiveautomation.com/t/perspective-video-component-error-loading-media/79185)
**Author:** [@Subin\_Adhikari](https://forum.inductiveautomation.com/u/Subin_Adhikari)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 10:11pm UTC](https://forum.inductiveautomation.com/t/perspective-video-component-error-loading-media/79185 "2023-09-14T22:11:35Z")
Respected Gurus, Is there in anyway I can Configure the video component "Preloader" as "Loading Video..." instead of "Error Loading Media" as shown in the gif ? I literally have to wait around 2 seconds due to the netwo… --- ## ["Statement does not return results" Error on INSERT INTO script](https://forum.inductiveautomation.com/t/statement-does-not-return-results-error-on-insert-into-script/76009)
**Author:** [@Mason\_Stevens](https://forum.inductiveautomation.com/u/Mason_Stevens)\ **Replies:** 2\ **Last updated:** [July 6, 2023, 4:38pm UTC](https://forum.inductiveautomation.com/t/statement-does-not-return-results-error-on-insert-into-script/76009 "2023-07-06T16:38:42Z")
Hello All. I am setting up a dynamic checklist and am running into some issues getting the MSSQL queries to pan out. The broad scope is to update initials from a text-box into a database that my checklist table reads its… --- ## [DNP Protocol - Analog Input Event with Time](https://forum.inductiveautomation.com/t/dnp-protocol-analog-input-event-with-time/79172)
**Author:** [@Eric\_Breternitz](https://forum.inductiveautomation.com/u/Eric_Breternitz)\ **Replies:** 5\ **Last updated:** [September 14, 2023, 8:04pm UTC](https://forum.inductiveautomation.com/t/dnp-protocol-analog-input-event-with-time/79172 "2023-09-14T20:04:41Z")
Ignition implementation of DNP Protocol lacks the support for Object 2 - Binary Input Event with Time and for Object 32 - Analogue Input Event with Time. More precisely Object 2: Variations 0, 2, and 3 as well Object 32… --- ## [Perspective limitations?](https://forum.inductiveautomation.com/t/perspective-limitations/49775)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 22\ **Last updated:** [May 3, 2023, 8:43pm UTC](https://forum.inductiveautomation.com/t/perspective-limitations/49775 "2023-05-03T20:43:23Z")
I have only ever done projects with vision. I code more than using the wizards. What limitations I be aware of? I have a customer that is interested in mobile aspects - so it will be a perspective project… pro’s and co… --- ## [INSERT INTO table Error](https://forum.inductiveautomation.com/t/insert-into-table-error/79180)
**Author:** [@Jesus\_Ibarra](https://forum.inductiveautomation.com/u/Jesus_Ibarra)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 7:16pm UTC](https://forum.inductiveautomation.com/t/insert-into-table-error/79180 "2023-09-14T19:16:25Z")
Hi!! I´m having some problems with my script , i am using system.db.runPrepUpdate in order to insert new information into my table but every time that the script is been executing my table is updated with the same… --- ## [Converting an array to a usable dataset](https://forum.inductiveautomation.com/t/converting-an-array-to-a-usable-dataset/79167)
**Author:** [@t.cobbs](https://forum.inductiveautomation.com/u/t.cobbs)\ **Replies:** 2\ **Last updated:** [September 14, 2023, 4:47pm UTC](https://forum.inductiveautomation.com/t/converting-an-array-to-a-usable-dataset/79167 "2023-09-14T16:47:39Z")
Good Morning Community, I have an array output, but I can't seem to figure out how to convert that into a dataset that can be used in a standard vision table. Any assistance would be greatly appreciated. Ignition v: 8.… --- ## [Network Diagram Resource for Projects](https://forum.inductiveautomation.com/t/network-diagram-resource-for-projects/79169)
**Author:** [@egranizo](https://forum.inductiveautomation.com/u/egranizo)\ **Replies:** 0\ **Last updated:** [September 14, 2023, 3:50pm UTC](https://forum.inductiveautomation.com/t/network-diagram-resource-for-projects/79169 "2023-09-14T15:50:32Z")
Hello all, With version 8.1.25, Ignition introduced the Gateway Network Diagram feature. https://docs.inductiveautomation.com/display/DOC81/Gateway+Network+Diagram#GatewayNetworkDiagram-GatewayNetworkDiagramDetails I … --- ## [Reporting - decimal separator problem](https://forum.inductiveautomation.com/t/reporting-decimal-separator-problem/79158)
**Author:** [@Balazs\_Schaffer](https://forum.inductiveautomation.com/u/Balazs_Schaffer)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 2:56pm UTC](https://forum.inductiveautomation.com/t/reporting-decimal-separator-problem/79158 "2023-09-14T14:56:57Z")
error.zip (430.3 KB) We use Ignition reporting. We have in our country comma for decimal separator. In designer we set the Number Format into #,##0.00 When we choose it, in the small dialog the locale-correct examples … --- ## [Can Ignition's Allen-Bradley SLC driver read complete data block as an array?](https://forum.inductiveautomation.com/t/can-ignitions-allen-bradley-slc-driver-read-complete-data-block-as-an-array/79154)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 3\ **Last updated:** [September 14, 2023, 2:07pm UTC](https://forum.inductiveautomation.com/t/can-ignitions-allen-bradley-slc-driver-read-complete-data-block-as-an-array/79154 "2023-09-14T14:07:33Z")
I'm converting an old application to Ignition. Most of the data is stored in integer format in N11, N200, etc. Do I need to create a tag for N200.0, N200.1, etc. or is there a means to read the whole lot as one array. (… --- ## [writeBlocking reliability](https://forum.inductiveautomation.com/t/writeblocking-reliability/79079)
**Author:** [@pick](https://forum.inductiveautomation.com/u/pick)\ **Replies:** 5\ **Last updated:** [September 14, 2023, 1:11pm UTC](https://forum.inductiveautomation.com/t/writeblocking-reliability/79079 "2023-09-14T13:11:21Z")
Hello, I have Siemen PLC type s7 1200 connected to Ignition throught the Ignition OPC UA server. The PLC send information to Ignition with an OPC tag "CW\_PLC\_MES" and Ignition answer back with and OPC tag "CW\_MES\_PLC". … --- ## [Power Table: problems with formatting the border / intercell spacing](https://forum.inductiveautomation.com/t/power-table-problems-with-formatting-the-border-intercell-spacing/51572)
**Author:** [@reto.kunz](https://forum.inductiveautomation.com/u/reto.kunz)\ **Replies:** 24\ **Last updated:** [September 14, 2023, 9:54am UTC](https://forum.inductiveautomation.com/t/power-table-problems-with-formatting-the-border-intercell-spacing/51572 "2023-09-14T09:54:14Z")
Hello everyone, I run into problems with displaying a nice looking table in Vision. Using the standard vertical / horizontal grid always generates lines which overlap with the boarder. Those double lines look weird. Try… --- ## [Setting Perspective Custom Session Properties from Device Launcher](https://forum.inductiveautomation.com/t/setting-perspective-custom-session-properties-from-device-launcher/79049)
**Author:** [@jeff.tieberg](https://forum.inductiveautomation.com/u/jeff.tieberg)\ **Replies:** 6\ **Last updated:** [September 14, 2023, 9:24am UTC](https://forum.inductiveautomation.com/t/setting-perspective-custom-session-properties-from-device-launcher/79049 "2023-09-14T09:24:42Z")
I am in the design phase of a project and we are currently using Perspective as our graphical platform. One of the key elements required by our client is proving to be difficult to find a solution for. There are two sec… --- ## [Script won't execute on Value Change event](https://forum.inductiveautomation.com/t/script-wont-execute-on-value-change-event/79082)
**Author:** [@Liem\_Nguyen](https://forum.inductiveautomation.com/u/Liem_Nguyen)\ **Replies:** 16\ **Last updated:** [September 14, 2023, 8:09am UTC](https://forum.inductiveautomation.com/t/script-wont-execute-on-value-change-event/79082 "2023-09-14T08:09:34Z")
Hi all, I'm new to ignition and I am following the courses from the inductive university. However I fail to figure out something that is not working for me regarding binding a script to a tag value change event. I've c… --- ## [Time difference between SQL table and Ignition Perspective](https://forum.inductiveautomation.com/t/time-difference-between-sql-table-and-ignition-perspective/79133)
**Author:** [@Soundararajans\_S](https://forum.inductiveautomation.com/u/Soundararajans_S)\ **Replies:** 7\ **Last updated:** [September 14, 2023, 8:03am UTC](https://forum.inductiveautomation.com/t/time-difference-between-sql-table-and-ignition-perspective/79133 "2023-09-14T08:03:16Z")
Am facing an issue related to Time. Am logging shift timing using update query to SQL table. The same vale am show cased in Table. I found time difference between both is showing 9 minutes something. Checked time zone a… --- ## [Dropdown Table: Row Selection Problems](https://forum.inductiveautomation.com/t/dropdown-table-row-selection-problems/78149)
**Author:** [@Craig\_Simpson](https://forum.inductiveautomation.com/u/Craig_Simpson)\ **Replies:** 4\ **Last updated:** [September 14, 2023, 7:31am UTC](https://forum.inductiveautomation.com/t/dropdown-table-row-selection-problems/78149 "2023-09-14T07:31:19Z")
Hi, I have a problem returning the user selection of a row in a dropdown table. I am passing production routing details to string array tags from our ERP system, as the length of each routing will vary every time. The a… --- ## [\[FEATURE\] Allow styling dates in the datetime picker calendar component](https://forum.inductiveautomation.com/t/feature-allow-styling-dates-in-the-datetime-picker-calendar-component/79132)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [September 14, 2023, 6:52am UTC](https://forum.inductiveautomation.com/t/feature-allow-styling-dates-in-the-datetime-picker-calendar-component/79132 "2023-09-14T06:52:49Z")
Please add the ability to style calendar dates within the Datetime picker component. E.g. the coloured "16" below. E.g. something like this: --- ## [Loading the Checkbox and popup calendar data to ignition dashboard from SQL table](https://forum.inductiveautomation.com/t/loading-the-checkbox-and-popup-calendar-data-to-ignition-dashboard-from-sql-table/78995)
**Author:** [@Riya\_Kaundal](https://forum.inductiveautomation.com/u/Riya_Kaundal)\ **Replies:** 14\ **Last updated:** [September 14, 2023, 3:46am UTC](https://forum.inductiveautomation.com/t/loading-the-checkbox-and-popup-calendar-data-to-ignition-dashboard-from-sql-table/78995 "2023-09-14T03:46:45Z")
when i try to load the data from SQL table to popup calendar and checkbox error is occurring. error below is for checkbox:- Traceback (most recent call last): File "\", line 13, in \ TypeErr… --- ## [System.util.execute shell script and exit codes](https://forum.inductiveautomation.com/t/system-util-execute-shell-script-and-exit-codes/79116)
**Author:** [@wdougmiller](https://forum.inductiveautomation.com/u/wdougmiller)\ **Replies:** 2\ **Last updated:** [September 14, 2023, 2:01am UTC](https://forum.inductiveautomation.com/t/system-util-execute-shell-script-and-exit-codes/79116 "2023-09-14T02:01:08Z")
Is there a way to execute a shell script and get the exit code? ive tried system.util.execute, but it doesnt seem to be recording a response --- ## [How to use PyVisa or maybe sockets in Ignition to talk to VISA/SCPI device?](https://forum.inductiveautomation.com/t/how-to-use-pyvisa-or-maybe-sockets-in-ignition-to-talk-to-visa-scpi-device/20634)
**Author:** [@cmaynes](https://forum.inductiveautomation.com/u/cmaynes)\ **Replies:** 37\ **Last updated:** [August 15, 2022, 11:28am UTC](https://forum.inductiveautomation.com/t/how-to-use-pyvisa-or-maybe-sockets-in-ignition-to-talk-to-visa-scpi-device/20634 "2022-08-15T11:28:59Z")
I am using Ignition 7.9.4, which uses Jython 2.5. I have an old Agilent VISA/SCPI device I want to talk to. I don't know the name of the device and want to display a list of connected devices/instruments to the user to… --- ## [LED Display inside a Vision popup doesn't follow the same formatting as when viewed alone in the Designer](https://forum.inductiveautomation.com/t/led-display-inside-a-vision-popup-doesnt-follow-the-same-formatting-as-when-viewed-alone-in-the-designer/79047)
**Author:** [@sherman](https://forum.inductiveautomation.com/u/sherman)\ **Replies:** 2\ **Last updated:** [September 14, 2023, 12:07am UTC](https://forum.inductiveautomation.com/t/led-display-inside-a-vision-popup-doesnt-follow-the-same-formatting-as-when-viewed-alone-in-the-designer/79047 "2023-09-14T00:07:31Z")
I have a little popup widget with an LED display, and I set the format to #.#. It seems just fine inside its view in the Designer: However, in the F11 test of the deployed vision client, when I access the popup, it … --- ## [CIP Connection Size Parameter](https://forum.inductiveautomation.com/t/cip-connection-size-parameter/14681)
**Author:** [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\ **Replies:** 47\ **Last updated:** [September 13, 2023, 11:53pm UTC](https://forum.inductiveautomation.com/t/cip-connection-size-parameter/14681 "2023-09-13T23:53:43Z")
I'm connecting to a very large V28 Logix Processor (30k+ tags) that we are trying to read relatively fast (ideally ~1s scan for most tags). I was wondering if there is a good way to optimize communications to a controll… --- ## [Long running stored procedure](https://forum.inductiveautomation.com/t/long-running-stored-procedure/79036)
**Author:** [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Replies:** 11\ **Last updated:** [September 13, 2023, 10:31pm UTC](https://forum.inductiveautomation.com/t/long-running-stored-procedure/79036 "2023-09-13T22:31:11Z")
I have a stored procedure that (unfortunately) takes longer than 60 seconds to run. On the upside, I only need to run it once a day. I would like to set it up as a gateway timer or scheduled task to run once a day. Bu… --- ## [Looking for a Chart Feature](https://forum.inductiveautomation.com/t/looking-for-a-chart-feature/79121)
**Author:** [@Roger\_Denison](https://forum.inductiveautomation.com/u/Roger_Denison)\ **Replies:** 1\ **Last updated:** [September 13, 2023, 10:26pm UTC](https://forum.inductiveautomation.com/t/looking-for-a-chart-feature/79121 "2023-09-13T22:26:41Z")
I have a Labview project that I am trying to emulate in Ignition Vision. It includes a chart graph that mimics the pushing and pulling on a load cell. The graph looks like this: They start with a yellow band at the… --- ## [\[IGN-2793\] One-Shot Button icon position](https://forum.inductiveautomation.com/t/ign-2793-one-shot-button-icon-position/79109)
**Author:** [@Chad\_Invie](https://forum.inductiveautomation.com/u/Chad_Invie)\ **Replies:** 2\ **Last updated:** [September 13, 2023, 10:10pm UTC](https://forum.inductiveautomation.com/t/ign-2793-one-shot-button-icon-position/79109 "2023-09-13T22:10:52Z")
I have added a one-shot button to a Perspective view and the property to change the icon position is missing. Additionally, the documentation shows the icon on the left, but for some reason, my version of the Ignition (… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=573) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=575)