# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=677 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 678 --- ## [Storage Provider inside Edit Tag](https://forum.inductiveautomation.com/t/storage-provider-inside-edit-tag/71796)
**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 9:10pm UTC](https://forum.inductiveautomation.com/t/storage-provider-inside-edit-tag/71796 "2023-03-29T21:10:52Z")
I am using a trial gateway license. I created a database connection in the gateway to MSSQL server. The connect status is valid. I then created a blank project in the designer. In the tag browser I added a tag from the s… --- ## [\[Perspective\] PowerShell Script + system.util.execute](https://forum.inductiveautomation.com/t/perspective-powershell-script-system-util-execute/53718)
**Author:** [@Davide3i](https://forum.inductiveautomation.com/u/Davide3i)\ **Replies:** 15\ **Last updated:** [March 29, 2023, 8:15pm UTC](https://forum.inductiveautomation.com/t/perspective-powershell-script-system-util-execute/53718 "2023-03-29T20:15:11Z")
Hello. I’d like to know if there are any ways to receive a feedback from system.util.execute after executing a PowerShell script. If not, I suppose my best option will be to write the output to a .log file and the read… --- ## [Perspective Pipes - Helpful Tools](https://forum.inductiveautomation.com/t/perspective-pipes-helpful-tools/71794)
**Author:** [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Replies:** 0\ **Last updated:** [March 29, 2023, 7:51pm UTC](https://forum.inductiveautomation.com/t/perspective-pipes-helpful-tools/71794 "2023-03-29T19:51:42Z")
I've been searching forums and feature requests to see what others are recommending for working with pipes within Perspective designer sessions. Personally, I believe pipes have come a long-way, and I'm now a regular use… --- ## [Indication if SQL BRIDGE is the best option](https://forum.inductiveautomation.com/t/indication-if-sql-bridge-is-the-best-option/71772)
**Author:** [@Lucas\_Bevilaqua](https://forum.inductiveautomation.com/u/Lucas_Bevilaqua)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 7:27pm UTC](https://forum.inductiveautomation.com/t/indication-if-sql-bridge-is-the-best-option/71772 "2023-03-29T19:27:12Z")
A customer has several machines in his plant, with several PLC's. The initial idea was to insert production data for each machine into a database table respectively. For example: Machine 1: You will insert data in the… --- ## [Ignition Redundancy](https://forum.inductiveautomation.com/t/ignition-redundancy/71572)
**Author:** [@Ricardo\_javier\_reyes](https://forum.inductiveautomation.com/u/Ricardo_javier_reyes)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 7:25pm UTC](https://forum.inductiveautomation.com/t/ignition-redundancy/71572 "2023-03-29T19:25:09Z")
Could anyone help me to make a link between a master and a backup gateway? --- ## [Table color count?](https://forum.inductiveautomation.com/t/table-color-count/71791)
**Author:** [@Micky\_Vue](https://forum.inductiveautomation.com/u/Micky_Vue)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 7:18pm UTC](https://forum.inductiveautomation.com/t/table-color-count/71791 "2023-03-29T19:18:54Z")
Hi everyone, I was wondering if it's possible to do a sum count of a certain color on a table? For example: Is it possible to count the total number of cells in a column that is green? --- ## [MES/PLC Heartbeat Tags](https://forum.inductiveautomation.com/t/mes-plc-heartbeat-tags/71786)
**Author:** [@tgjonaj](https://forum.inductiveautomation.com/u/tgjonaj)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 6:39pm UTC](https://forum.inductiveautomation.com/t/mes-plc-heartbeat-tags/71786 "2023-03-29T18:39:52Z")
Hello, I have a production site that's mainly Beckhoff PLCs and one of the requirements they have is a heartbeat tag that both MES and the PLC will write to (PLC writes a 1, then I respond with a 0). However, every once… --- ## [Download files stored in database using ignition Perspective](https://forum.inductiveautomation.com/t/download-files-stored-in-database-using-ignition-perspective/71699)
**Author:** [@KEERTHANA\_HEMANTH](https://forum.inductiveautomation.com/u/KEERTHANA_HEMANTH)\ **Replies:** 10\ **Last updated:** [March 29, 2023, 5:33pm UTC](https://forum.inductiveautomation.com/t/download-files-stored-in-database-using-ignition-perspective/71699 "2023-03-29T17:33:51Z")
Hi, I have a table in my sql server database with filename, filedata and id. I need to give user the access to download the files stored in my database. Kindly help me resolve this issue --- ## [Trying to scale an OPC integer down to a float](https://forum.inductiveautomation.com/t/trying-to-scale-an-opc-integer-down-to-a-float/71778)
**Author:** [@Cole\_Townsend](https://forum.inductiveautomation.com/u/Cole_Townsend)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 4:30pm UTC](https://forum.inductiveautomation.com/t/trying-to-scale-an-opc-integer-down-to-a-float/71778 "2023-03-29T16:30:52Z")
So I am trying to scale an integer that is coming from an OPC source down to a float. For example, if the source gives me 578, I want the tag to have the value 5.78. The issue I am running into here is that if I pull th… --- ## [Generate table to database with PostgreSQL does not generate data](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750)
**Author:** [@Julio\_Cesar\_Aguilar](https://forum.inductiveautomation.com/u/Julio_Cesar_Aguilar)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 4:21pm UTC](https://forum.inductiveautomation.com/t/generate-table-to-database-with-postgresql-does-not-generate-data/71750 "2023-03-29T16:21:10Z")
Hello everyone, I have this problem, I am working with PostgresSQL, it is supposed that through the tranciscion group I generate data and create a table within the database but I stop generating data at a certain point, … --- ## [Subplot gap on standard chart](https://forum.inductiveautomation.com/t/subplot-gap-on-standard-chart/17306)
**Author:** [@JNelson](https://forum.inductiveautomation.com/u/JNelson)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/subplot-gap-on-standard-chart/17306 "2023-03-29T16:18:04Z")
I need a way to set the subplot gap on a standard chart. I can do it on the Easy Chart by going to getComponent('Easy Chart').setSubplotGap(x) Any ideas? --- ## [urllib2.HTTPError: HTTP Error 422: Unprocessable Entity](https://forum.inductiveautomation.com/t/urllib2-httperror-http-error-422-unprocessable-entity/71762)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 5\ **Last updated:** [March 29, 2023, 3:52pm UTC](https://forum.inductiveautomation.com/t/urllib2-httperror-http-error-422-unprocessable-entity/71762 "2023-03-29T15:52:29Z")
I am trying to read API. The following python code works: import requests import json url = '.....' headers = { 'accept': 'application/json', 'SY-API-KEY': '.....', … --- ## [Sneding SMS in language other than English](https://forum.inductiveautomation.com/t/sneding-sms-in-language-other-than-english/71758)
**Author:** [@Anna\_Goldberg](https://forum.inductiveautomation.com/u/Anna_Goldberg)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 3:43pm UTC](https://forum.inductiveautomation.com/t/sneding-sms-in-language-other-than-english/71758 "2023-03-29T15:43:41Z")
Hello, Maybe someone have encountered this issue: I'm trying to send an SMS message using the Airlink LX40 modem. The Messages sent in English work fine, but when I send a message in Hebrew, I receive just meaningless … --- ## [Maximum amount of device connections in Gateway](https://forum.inductiveautomation.com/t/maximum-amount-of-device-connections-in-gateway/71735)
**Author:** [@f.boz](https://forum.inductiveautomation.com/u/f.boz)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 2:31pm UTC](https://forum.inductiveautomation.com/t/maximum-amount-of-device-connections-in-gateway/71735 "2023-03-29T14:31:12Z")
Hi all. I'm designing a new Ignition system where I have a lot of different types of devices like Rockwell, Siemens, Opto22, even OPC Servers, etc. The plant has three areas with about 10 devices each one (30 devices t… --- ## [User interaction logging](https://forum.inductiveautomation.com/t/user-interaction-logging/71661)
**Author:** [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 2:03pm UTC](https://forum.inductiveautomation.com/t/user-interaction-logging/71661 "2023-03-29T14:03:58Z")
I want to log what the operator is doing: def Log(self,Para): msg = str(self.session.props.host) + '/' msg += str(self.page.props.title) msg += str(self.page.props.path) + '/' try: msg += str(self.parent.parent.meta… --- ## [Gateway Tag Change Script help (probably syntax)](https://forum.inductiveautomation.com/t/gateway-tag-change-script-help-probably-syntax/71766)
**Author:** [@Cameronin](https://forum.inductiveautomation.com/u/Cameronin)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 1:47pm UTC](https://forum.inductiveautomation.com/t/gateway-tag-change-script-help-probably-syntax/71766 "2023-03-29T13:47:13Z")
I'm trying to use a gateway tag change script to get a value change in a tank (with corresponding start and end times) so I can get flow in to the tank from two historicised flow meters (using tagHistoryQuery), and calcu… --- ## [Connecting Arduino communicating in OPC to Ignition SCADA](https://forum.inductiveautomation.com/t/connecting-arduino-communicating-in-opc-to-ignition-scada/71761)
**Author:** [@Mohamed\_AbdelGhaffar](https://forum.inductiveautomation.com/u/Mohamed_AbdelGhaffar)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 12:10pm UTC](https://forum.inductiveautomation.com/t/connecting-arduino-communicating-in-opc-to-ignition-scada/71761 "2023-03-29T12:10:57Z")
Has anyone tried to connect an Arduino to ignition scada through OPCDA ? Arduino is connected through a serial port and I have Arduino OPC server already installed and functioning as well as output parameters can be rea… --- ## [Transaction Group Execution Identifier](https://forum.inductiveautomation.com/t/transaction-group-execution-identifier/71749)
**Author:** [@Chris.Hawkey](https://forum.inductiveautomation.com/u/Chris.Hawkey)\ **Replies:** 2\ **Last updated:** [March 29, 2023, 12:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-execution-identifier/71749 "2023-03-29T12:35:00Z")
Hello! I am struggling to come up with a solution to my problem. I was hoping to use transaction groups to continuously store process data when a boolean tag is high. That part is easy. I was also hoping to generate … --- ## [jyThon-Python-Other?](https://forum.inductiveautomation.com/t/jython-python-other/71720)
**Author:** [@Alan\_Cannon](https://forum.inductiveautomation.com/u/Alan_Cannon)\ **Replies:** 17\ **Last updated:** [March 29, 2023, 12:07pm UTC](https://forum.inductiveautomation.com/t/jython-python-other/71720 "2023-03-29T12:07:12Z")
i was creating my own style of logging and i found a strange issue i do not understand, so apologies if this is in the wrong forum\\channel i originally did not have the top 2 lines, so i added these during dev ( Fol… --- ## [Last Date of Project Use](https://forum.inductiveautomation.com/t/last-date-of-project-use/71748)
**Author:** [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\ **Replies:** 1\ **Last updated:** [March 29, 2023, 9:05am UTC](https://forum.inductiveautomation.com/t/last-date-of-project-use/71748 "2023-03-29T09:05:28Z")
Hi everyone, Does anyone know if there is any built-in way to obtain the "last accessed" date of an Ignition project? Whether that would be located in the internal database (I only see "LASTMODIFIED" in the "PROJECTS" t… --- ## [Perspective powerchart question](https://forum.inductiveautomation.com/t/perspective-powerchart-question/71754)
**Author:** [@jiyoung\_hwang1](https://forum.inductiveautomation.com/u/jiyoung_hwang1)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 8:40am UTC](https://forum.inductiveautomation.com/t/perspective-powerchart-question/71754 "2023-03-29T08:40:19Z")
As shown in the attached, the trend range looks like this from 20 to 29 I want to change the range to 0-100 how do i change this? Please tell me --- ## [Igniton edge with 10+ modbus TCP connection](https://forum.inductiveautomation.com/t/igniton-edge-with-10-modbus-tcp-connection/71613)
**Author:** [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\ **Replies:** 4\ **Last updated:** [March 29, 2023, 4:02am UTC](https://forum.inductiveautomation.com/t/igniton-edge-with-10-modbus-tcp-connection/71613 "2023-03-29T04:02:30Z")
The ignition edge license supports up to 2 connections. For 10+ Modbus TCP devices, what's the cost effective way to achieve the connections? Any suggestion is appreciated. --- ## [How to Identify if window is Popup or main or docked after adding those](https://forum.inductiveautomation.com/t/how-to-identify-if-window-is-popup-or-main-or-docked-after-adding-those/71743)
**Author:** [@Urvish\_Mehta](https://forum.inductiveautomation.com/u/Urvish_Mehta)\ **Replies:** 3\ **Last updated:** [March 29, 2023, 2:02am UTC](https://forum.inductiveautomation.com/t/how-to-identify-if-window-is-popup-or-main-or-docked-after-adding-those/71743 "2023-03-29T02:02:51Z")
Hello I am trying to find out if my window is Main or Pop up? if you right click on folder, you will see Symbols for Window type at creation but not once it's created, All windows looks like main window. Let me know… --- ## [Alarm Pipeline - Notify multiple rosters dynamically](https://forum.inductiveautomation.com/t/alarm-pipeline-notify-multiple-rosters-dynamically/57716)
**Author:** [@JohnIrving](https://forum.inductiveautomation.com/u/JohnIrving)\ **Replies:** 6\ **Last updated:** [March 29, 2023, 1:56am UTC](https://forum.inductiveautomation.com/t/alarm-pipeline-notify-multiple-rosters-dynamically/57716 "2023-03-29T01:56:20Z")
I have an application where both individual users and rosters can be assigned to a particular alarm at run time. For the individual users, I achieved this with a calculated roster that reads in my list of assigned users … --- ## [Has anyone used this third-party BASP driver module?](https://forum.inductiveautomation.com/t/has-anyone-used-this-third-party-basp-driver-module/71742)
**Author:** [@Ryan\_Allen](https://forum.inductiveautomation.com/u/Ryan_Allen)\ **Replies:** 1\ **Last updated:** [March 28, 2023, 10:38pm UTC](https://forum.inductiveautomation.com/t/has-anyone-used-this-third-party-basp-driver-module/71742 "2023-03-28T22:38:44Z")
Found an integrator named Crucial Controls that appears to freely share the module they developed to directly interface with Control Wave PLCs. (BSAP for anyone searching for this later) Module: Does anyone have first… --- ## [Sql server database connection](https://forum.inductiveautomation.com/t/sql-server-database-connection/71721)
**Author:** [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\ **Replies:** 2\ **Last updated:** [March 28, 2023, 9:37pm UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection/71721 "2023-03-28T21:37:01Z")
I am not a sql server administrator but am owner of several databases. Normally if I need a new database I ask my organization's DBA to create a blank database and make me the owner of that database so I can create table… --- ## [system.tag.queryTagHistory: losing data when the intervalMinutes is set higher](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-losing-data-when-the-intervalminutes-is-set-higher/59132)
**Author:** [@jstaebell](https://forum.inductiveautomation.com/u/jstaebell)\ **Replies:** 2\ **Last updated:** [March 28, 2023, 9:19pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-losing-data-when-the-intervalminutes-is-set-higher/59132 "2023-03-28T21:19:16Z")
Hello, First time posting so please let me know if I am doing anything wrong. I am trying to pull the history of a tag with intermittent data. There will be several seconds of readings; however, most of the time the rea… --- ## [\[IGN-7075\] OIDC User Info URL requires GET instead of POST](https://forum.inductiveautomation.com/t/ign-7075-oidc-user-info-url-requires-get-instead-of-post/68862)
**Author:** [@Ethan\_Brown](https://forum.inductiveautomation.com/u/Ethan_Brown)\ **Replies:** 2\ **Last updated:** [March 28, 2023, 8:55pm UTC](https://forum.inductiveautomation.com/t/ign-7075-oidc-user-info-url-requires-get-instead-of-post/68862 "2023-03-28T20:55:26Z")
We're having trouble retrieving our UserInfo when authenticating via OIDC because it seems Ignition tries to retrieve with a POST and our organization requires a GET. Is there any chance this could be an option in the fu… --- ## [Edge Datalogging](https://forum.inductiveautomation.com/t/edge-datalogging/71717)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 8\ **Last updated:** [March 28, 2023, 8:14pm UTC](https://forum.inductiveautomation.com/t/edge-datalogging/71717 "2023-03-28T20:14:07Z")
Hi Folks, Looking for ideas / suggestions on this one. Normally, we have machines with edge installed for local basic HMI local access and MQTT. Send a message every hour just to update machine run time and some temps… --- ## [\[bug-15415\]How to go about finding the tag populating gateway logs with error](https://forum.inductiveautomation.com/t/bug-15415-how-to-go-about-finding-the-tag-populating-gateway-logs-with-error/29805)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 18\ **Last updated:** [March 28, 2023, 8:04pm UTC](https://forum.inductiveautomation.com/t/bug-15415-how-to-go-about-finding-the-tag-populating-gateway-logs-with-error/29805 "2023-03-28T20:04:13Z")
I looked at my logs today and found it filled with several pages with the same error on an expression tag. How do I go about figuring out which tag this is? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=676) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=678)