# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=875 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 876 --- ## [Ignition tag historian - cumulative time spent at value](https://forum.inductiveautomation.com/t/ignition-tag-historian-cumulative-time-spent-at-value/57188)
**Author:** [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Replies:** 1\ **Last updated:** [March 15, 2022, 7:16am UTC](https://forum.inductiveautomation.com/t/ignition-tag-historian-cumulative-time-spent-at-value/57188 "2022-03-15T07:16:10Z")
Ignition 8.1, MSSQL. Hi. I am using Ignition to monitor the operating status and collect downtime codes from several CNC machines. These integer values are logged by the ignition tag historian on value change. The goal… --- ## [Siemens S7-1200 OPC UDT error](https://forum.inductiveautomation.com/t/siemens-s7-1200-opc-udt-error/56756)
**Author:** [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Replies:** 14\ **Last updated:** [March 15, 2022, 4:52am UTC](https://forum.inductiveautomation.com/t/siemens-s7-1200-opc-udt-error/56756 "2022-03-15T04:52:05Z")
I have a S7-1200 PLC with a data block containing several UDTs. OPC communications to the PLC are working and I can read individual elements from any UDT or other data point. I have re-created the UDT in ignition, ready… --- ## [OPC write back (SQL tags)](https://forum.inductiveautomation.com/t/opc-write-back-sql-tags/57179)
**Author:** [@sathianandan.dharmas](https://forum.inductiveautomation.com/u/sathianandan.dharmas)\ **Replies:** 1\ **Last updated:** [March 15, 2022, 12:56am UTC](https://forum.inductiveautomation.com/t/opc-write-back-sql-tags/57179 "2022-03-15T00:56:12Z")
Hi All, I’m not able to write to some OPC tags which are in read/write mode using the OPC write back option on a SQL tag but I’m able to write values using system.opc.writeValue() function though. Does anyone know what … --- ## [Tag Bad quality , replace null value to zero](https://forum.inductiveautomation.com/t/tag-bad-quality-replace-null-value-to-zero/57033)
**Author:** [@rigoberto.reyes](https://forum.inductiveautomation.com/u/rigoberto.reyes)\ **Replies:** 2\ **Last updated:** [March 14, 2022, 10:16pm UTC](https://forum.inductiveautomation.com/t/tag-bad-quality-replace-null-value-to-zero/57033 "2022-03-14T22:16:31Z")
Hi there. I have created a memory tag “tAirFlow” composed of the next formula (tags): {\[.\]Machine/Process/CoolerAirFlow\_01}+{\[.\]Machine/Process/CoolerAirFlow\_02}+{\[.\]Machine/Process/CoolerAirFlow\_03}+{\[.\]Machine/Proces… --- ## [Mysql, mariadb driver and allowPublicKeyRetreival](https://forum.inductiveautomation.com/t/mysql-mariadb-driver-and-allowpublickeyretreival/57156)
**Author:** [@johannes.bo](https://forum.inductiveautomation.com/u/johannes.bo)\ **Replies:** 7\ **Last updated:** [March 14, 2022, 9:07pm UTC](https://forum.inductiveautomation.com/t/mysql-mariadb-driver-and-allowpublickeyretreival/57156 "2022-03-14T21:07:54Z")
I am running Ignition v8.1.9 and have a connection to a mysql database using mariadb driver. I initially got faulty database connection: I get this to work by adding “allowPublicKeyRetrieval=true” to the extra conne… --- ## [My export to excel button creates file, without the correct file?](https://forum.inductiveautomation.com/t/my-export-to-excel-button-creates-file-without-the-correct-file/57093)
**Author:** [@Cole\_Barthel](https://forum.inductiveautomation.com/u/Cole_Barthel)\ **Replies:** 9\ **Last updated:** [March 14, 2022, 8:45pm UTC](https://forum.inductiveautomation.com/t/my-export-to-excel-button-creates-file-without-the-correct-file/57093 "2022-03-14T20:45:13Z")
I am trying to export multiple datasets from a window of graphs and tables, but for starting out I am just trying for one. I have an export to excel button with actionPerformed script uploaded below. It creates an excel … --- ## [Session Events - "Context" Argument](https://forum.inductiveautomation.com/t/session-events-context-argument/57176)
**Author:** [@Joe\_Kelly](https://forum.inductiveautomation.com/u/Joe_Kelly)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 8:43pm UTC](https://forum.inductiveautomation.com/t/session-events-context-argument/57176 "2022-03-14T20:43:28Z")
I’m working on a project that involves scanning barcodes and noticed one of the arguments is documented as: context: The user-defined context object associated with the barcode scan event. Can anyone give me an example… --- ## [system.net.httpClient POST method](https://forum.inductiveautomation.com/t/system-net-httpclient-post-method/57167)
**Author:** [@houfa\_zhu](https://forum.inductiveautomation.com/u/houfa_zhu)\ **Replies:** 14\ **Last updated:** [March 14, 2022, 8:34pm UTC](https://forum.inductiveautomation.com/t/system-net-httpclient-post-method/57167 "2022-03-14T20:34:02Z")
Hi @PGriffith, we have an application which requires Ignition to report a batch to IFS using web service when production has completed a batch. we have successfully used web service to fetch data from IFS: url = “http… --- ## [Cylindrical Tank Capacity](https://forum.inductiveautomation.com/t/cylindrical-tank-capacity/56902)
**Author:** [@Nicole\_Weiss](https://forum.inductiveautomation.com/u/Nicole_Weiss)\ **Replies:** 30\ **Last updated:** [March 14, 2022, 6:54pm UTC](https://forum.inductiveautomation.com/t/cylindrical-tank-capacity/56902 "2022-03-14T18:54:32Z")
Is there any way to have the capacity of the tank grow as the percentages of gas and the totalizer go up? Right now, the tank capacity is just set to 500,000, but as time goes on the gas percentage and totalizer are g… --- ## [How do I sum the values of a column of a table component?](https://forum.inductiveautomation.com/t/how-do-i-sum-the-values-of-a-column-of-a-table-component/33837)
**Author:** [@felipe2010silva](https://forum.inductiveautomation.com/u/felipe2010silva)\ **Replies:** 2\ **Last updated:** [March 14, 2022, 6:51pm UTC](https://forum.inductiveautomation.com/t/how-do-i-sum-the-values-of-a-column-of-a-table-component/33837 "2022-03-14T18:51:59Z")
Good night, my name is Felipe and I’m new to Ignition. I received a mission to add the hfiNumber values ​​of each process machine (eg cupper, bodymaker, decorator) to the ignition screen next to each machine. I intend to… --- ## [Ignition Keyboard and the Web Browser](https://forum.inductiveautomation.com/t/ignition-keyboard-and-the-web-browser/57157)
**Author:** [@mhicks1](https://forum.inductiveautomation.com/u/mhicks1)\ **Replies:** 6\ **Last updated:** [March 14, 2022, 5:52pm UTC](https://forum.inductiveautomation.com/t/ignition-keyboard-and-the-web-browser/57157 "2022-03-14T17:52:16Z")
I am using Ignition 8.0.6 with Web Browser 4.0.6. We are using touch screen PC’s. We have developed a simple screen to access our Share Point site. We are finding that after entering text on some fields, it shows up b… --- ## [Upgrading Ignition 7.9 on Linux User Name Not Available](https://forum.inductiveautomation.com/t/upgrading-ignition-7-9-on-linux-user-name-not-available/57159)
**Author:** [@blewis](https://forum.inductiveautomation.com/u/blewis)\ **Replies:** 3\ **Last updated:** [March 14, 2022, 5:12pm UTC](https://forum.inductiveautomation.com/t/upgrading-ignition-7-9-on-linux-user-name-not-available/57159 "2022-03-14T17:12:27Z")
I am trying to upgrade Ignition 7.9.13 to 7.9.18 on a headless Linux server x64, but during the upgrade process when the option for selecting a Linux User Name came up the user name entered does not exist on the Linux sy… --- ## [Will manual logging work on Linux Ignition as well?](https://forum.inductiveautomation.com/t/will-manual-logging-work-on-linux-ignition-as-well/57107)
**Author:** [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\ **Replies:** 5\ **Last updated:** [March 14, 2022, 4:40pm UTC](https://forum.inductiveautomation.com/t/will-manual-logging-work-on-linux-ignition-as-well/57107 "2022-03-14T16:40:30Z")
hi All Sometimes i would like to use super simple custom manual logging: def logging(msg): f = open(“C:\\PROJECTS\\IgnitionManualLoggings.txt”,“a”) now = system.date.now() m = “(” + str(now) + ") " + msg + “\\n” f.wri… --- ## [Ignition 8 on Raspberry PI](https://forum.inductiveautomation.com/t/ignition-8-on-raspberry-pi/28516)
**Author:** [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\ **Replies:** 4\ **Last updated:** [September 25, 2019, 7:44am UTC](https://forum.inductiveautomation.com/t/ignition-8-on-raspberry-pi/28516 "2019-09-25T07:44:30Z")
Hi, I just want to know if there is possible to run a server of Ignition 8 on a Raspberry PI… I don’t have one jet… but I’m planning to run a demo of an application with Ignition… i just want to know if there is a Raspb… --- ## [Using Microsoft SQL Server Management Studios while uploading files in Ignition 7.9, data is truncated](https://forum.inductiveautomation.com/t/using-microsoft-sql-server-management-studios-while-uploading-files-in-ignition-7-9-data-is-truncated/57165)
**Author:** [@SOPerator](https://forum.inductiveautomation.com/u/SOPerator)\ **Replies:** 2\ **Last updated:** [March 14, 2022, 4:08pm UTC](https://forum.inductiveautomation.com/t/using-microsoft-sql-server-management-studios-while-uploading-files-in-ignition-7-9-data-is-truncated/57165 "2022-03-14T16:08:45Z")
I am attempting to create a program similar to the one listed here But I get an error telling me that data would be truncated (see below) I’m wondering if it’s because I’m using the varbinary data type instead of the l… --- ## [Multiple Values Filter on Power Table](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138)
**Author:** [@Chris\_Mehan](https://forum.inductiveautomation.com/u/Chris_Mehan)\ **Replies:** 4\ **Last updated:** [March 14, 2022, 3:03pm UTC](https://forum.inductiveautomation.com/t/multiple-values-filter-on-power-table/53138 "2022-03-14T15:03:12Z")
I am currently working with filters on a power table and found a script that works for a single value, but I have not found a way to use jidesoft MultipleValuesFilter in it’s place; I also haven’t been able to find any g… --- ## [Script write to tag error](https://forum.inductiveautomation.com/t/script-write-to-tag-error/53885)
**Author:** [@drinaldi](https://forum.inductiveautomation.com/u/drinaldi)\ **Replies:** 42\ **Last updated:** [March 14, 2022, 2:53pm UTC](https://forum.inductiveautomation.com/t/script-write-to-tag-error/53885 "2022-03-14T14:53:28Z")
Hello, can someone please see if they have seen this error trying to write to a PLC tag? The script works fine but every once in awhile it locks up, and this is when I noticed this error in the Logs. Thanks. Bad(“Bad\_… --- ## [IsAlarmActive Through Script](https://forum.inductiveautomation.com/t/isalarmactive-through-script/57121)
**Author:** [@alainia.spencer](https://forum.inductiveautomation.com/u/alainia.spencer)\ **Replies:** 3\ **Last updated:** [March 14, 2022, 1:49pm UTC](https://forum.inductiveautomation.com/t/isalarmactive-through-script/57121 "2022-03-14T13:49:53Z")
Is there a way to figure out if there is an active alarm for a tag through script? I see that you can do it using the isAlarmActive expression function but I would like to access it via script instead. --- ## [\[BUG\] Piping, binding](https://forum.inductiveautomation.com/t/bug-piping-binding/57153)
**Author:** [@vipo](https://forum.inductiveautomation.com/u/vipo)\ **Replies:** 2\ **Last updated:** [March 14, 2022, 12:50pm UTC](https://forum.inductiveautomation.com/t/bug-piping-binding/57153 "2022-03-14T12:50:40Z")
If you do binding on a piping attribute, and then remove a pipe below in the array of pipes, the binding seems to shift places. The results are: The binding effect is on another pipe. Unable to remove bindings on attr… --- ## [How to interrupt script when the condition is false](https://forum.inductiveautomation.com/t/how-to-interrupt-script-when-the-condition-is-false/57147)
**Author:** [@splata](https://forum.inductiveautomation.com/u/splata)\ **Replies:** 1\ **Last updated:** [March 14, 2022, 12:27pm UTC](https://forum.inductiveautomation.com/t/how-to-interrupt-script-when-the-condition-is-false/57147 "2022-03-14T12:27:17Z")
hello I did make a simple countdown timer in the property of value on progress bar ,when a condition is true the timer start to count down to 0 and every is going good to here. import time if value : tiempo=10 e… --- ## [Trigger binding AFTER other bindings](https://forum.inductiveautomation.com/t/trigger-binding-after-other-bindings/57145)
**Author:** [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Replies:** 8\ **Last updated:** [March 14, 2022, 11:57am UTC](https://forum.inductiveautomation.com/t/trigger-binding-after-other-bindings/57145 "2022-03-14T11:57:17Z")
Hi- Using Perspective 8.1.14. Is there any way to trigger a binding AFTER several other bindings on the page? I have a single binding that does some slightly complex calculations on the inputs, then runs a generated q… --- ## [Perspectives on a tv](https://forum.inductiveautomation.com/t/perspectives-on-a-tv/57126)
**Author:** [@bwagner](https://forum.inductiveautomation.com/u/bwagner)\ **Replies:** 4\ **Last updated:** [March 13, 2022, 12:52am UTC](https://forum.inductiveautomation.com/t/perspectives-on-a-tv/57126 "2022-03-13T00:52:47Z")
We have tried running perspectives in a browser on several tv’s without a pc with not much luck. Does anybody know of a good tv that the browser will run perspectives in. --- ## [Sql, limited permissions, PLS help](https://forum.inductiveautomation.com/t/sql-limited-permissions-pls-help/57132)
**Author:** [@Fernando\_Alonso\_Aram](https://forum.inductiveautomation.com/u/Fernando_Alonso_Aram)\ **Replies:** 6\ **Last updated:** [March 12, 2022, 8:56pm UTC](https://forum.inductiveautomation.com/t/sql-limited-permissions-pls-help/57132 "2022-03-12T20:56:53Z")
Hello, im using transaction groups to update sql table, everything looks ok,No errors, but in the gateway, the data goes in quarintine, can´t reach de SQLserver. it sends me this mssg . ‘’\> java.sql.BatchUpdateExceptio… --- ## [No information about concurrent users in Designer](https://forum.inductiveautomation.com/t/no-information-about-concurrent-users-in-designer/57098)
**Author:** [@grzegorz.kaczmarczyk](https://forum.inductiveautomation.com/u/grzegorz.kaczmarczyk)\ **Replies:** 2\ **Last updated:** [March 12, 2022, 12:05pm UTC](https://forum.inductiveautomation.com/t/no-information-about-concurrent-users-in-designer/57098 "2022-03-12T12:05:37Z")
Hi, We have no information in the right lower corner in the Designer about 2 users working on the project. The gateway shows 2 open designer sessions. Why we can’t see it in the Designer? --- ## [Alarm notification + DB query + Notification Block](https://forum.inductiveautomation.com/t/alarm-notification-db-query-notification-block/57140)
**Author:** [@FreddyR](https://forum.inductiveautomation.com/u/FreddyR)\ **Replies:** 1\ **Last updated:** [March 12, 2022, 10:50am UTC](https://forum.inductiveautomation.com/t/alarm-notification-db-query-notification-block/57140 "2022-03-12T10:50:04Z")
Hi everyone, I have added Alarms to UDT and linked them to a Pipeline notification. How can I activate the pipeline based on DB query status? In the other words, I want some of my alarms filtered out based on status i… --- ## [Modbus client not translating tag into correct floating-point format](https://forum.inductiveautomation.com/t/modbus-client-not-translating-tag-into-correct-floating-point-format/57087)
**Author:** [@fshriver](https://forum.inductiveautomation.com/u/fshriver)\ **Replies:** 19\ **Last updated:** [March 12, 2022, 12:53am UTC](https://forum.inductiveautomation.com/t/modbus-client-not-translating-tag-into-correct-floating-point-format/57087 "2022-03-12T00:53:59Z")
I have a modus server spun up using pymodbus, it pulls data from a CSV and updates the holding registers once every second (all values are 32-bit float). I’ve written a basic client for this server, and verified that val… --- ## [\[IGN-3761, IGN-4620, IGN-4795\] SAML IDP - Save button doesn't highlight when importing new metadata](https://forum.inductiveautomation.com/t/ign-3761-ign-4620-ign-4795-saml-idp-save-button-doesnt-highlight-when-importing-new-metadata/51410)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 7\ **Last updated:** [March 12, 2022, 12:03am UTC](https://forum.inductiveautomation.com/t/ign-3761-ign-4620-ign-4795-saml-idp-save-button-doesnt-highlight-when-importing-new-metadata/51410 "2022-03-12T00:03:38Z")
In the past few weeks, we were told we had to update all of our SAML certificates. What this entails is going into the self help portal we have and switching over the certificate that the SAML connection uses. This has… --- ## [\[FEATURE-384\] Change color of vessel running, stop, etc](https://forum.inductiveautomation.com/t/feature-384-change-color-of-vessel-running-stop-etc/56983)
**Author:** [@NII](https://forum.inductiveautomation.com/u/NII)\ **Replies:** 6\ **Last updated:** [March 11, 2022, 11:01pm UTC](https://forum.inductiveautomation.com/t/feature-384-change-color-of-vessel-running-stop-etc/56983 "2022-03-11T23:01:30Z")
Is it possible to change the color of the vessel component for each state? --- ## [Missing Perspective Symbols](https://forum.inductiveautomation.com/t/missing-perspective-symbols/57018)
**Author:** [@manu](https://forum.inductiveautomation.com/u/manu)\ **Replies:** 1\ **Last updated:** [March 11, 2022, 9:05pm UTC](https://forum.inductiveautomation.com/t/missing-perspective-symbols/57018 "2022-03-11T21:05:14Z")
Hi, Using Ignition 8.1, I can’t find several symbols shown below such as positive/diaphragm pump, pneumatic valves etc… What am I missing? Image taken from Oct. 2020 video here Ignition 8.1 Perspective Symbols - YouTu… --- ## [Weird Wrapper Log entries](https://forum.inductiveautomation.com/t/weird-wrapper-log-entries/57129)
**Author:** [@peter](https://forum.inductiveautomation.com/u/peter)\ **Replies:** 5\ **Last updated:** [March 11, 2022, 8:50pm UTC](https://forum.inductiveautomation.com/t/weird-wrapper-log-entries/57129 "2022-03-11T20:50:46Z")
(This is on 8.1.15 under Ubuntu) I’m running in a VM which has two IP4 addresses 192.168.1.102 and 192.168.100.102 This VM is for testing purposes only and has a small Ignition perspective project that connects to a PL… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=874) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=876)