# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=735 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 736 --- ## [Show data from a table cell to a numeric field in perspective](https://forum.inductiveautomation.com/t/show-data-from-a-table-cell-to-a-numeric-field-in-perspective/67394)
**Author:** [@Sukhwant\_Singh](https://forum.inductiveautomation.com/u/Sukhwant_Singh)\ **Replies:** 2\ **Last updated:** [December 9, 2022, 1:34am UTC](https://forum.inductiveautomation.com/t/show-data-from-a-table-cell-to-a-numeric-field-in-perspective/67394 "2022-12-09T01:34:57Z")
Show data from a table cell to a numeric field in perspective. The Numeric field is on another container. How do I set the value of the numeric column row data to this numeric field as the user clicks on the table row. … --- ## [A question of the ignition tag](https://forum.inductiveautomation.com/t/a-question-of-the-ignition-tag/67412)
**Author:** [@riklionline](https://forum.inductiveautomation.com/u/riklionline)\ **Replies:** 1\ **Last updated:** [December 9, 2022, 1:04am UTC](https://forum.inductiveautomation.com/t/a-question-of-the-ignition-tag/67412 "2022-12-09T01:04:05Z")
What is the distinction of the opc tag, memory tag, query tag, expression tag, derived tag and client tag. Can you give me an example? --- ## [Perspective: data update after network connection restore](https://forum.inductiveautomation.com/t/perspective-data-update-after-network-connection-restore/67375)
**Author:** [@tadeja.saje](https://forum.inductiveautomation.com/u/tadeja.saje)\ **Replies:** 1\ **Last updated:** [December 8, 2022, 11:00pm UTC](https://forum.inductiveautomation.com/t/perspective-data-update-after-network-connection-restore/67375 "2022-12-08T23:00:43Z")
Hi. We have Ignition Perspective 8.1.21 gateway. We make project wih Flex Repeater. We make template with text field with parameters for Flex Repeater instances. Then we make instances. Then elements of instances … --- ## [Finding References in Child Projects? Inheritance Question](https://forum.inductiveautomation.com/t/finding-references-in-child-projects-inheritance-question/67385)
**Author:** [@mschell1978](https://forum.inductiveautomation.com/u/mschell1978)\ **Replies:** 4\ **Last updated:** [December 8, 2022, 9:11pm UTC](https://forum.inductiveautomation.com/t/finding-references-in-child-projects-inheritance-question/67385 "2022-12-08T21:11:37Z")
Is there an easy way to get a list of all child projects that reference a resource in an inherited parent project? e.g. we have a parent project that provides shared scripts to a number of child projects. If making a ch… --- ## [Count Objects in an image](https://forum.inductiveautomation.com/t/count-objects-in-an-image/67405)
**Author:** [@Norman\_Mountain](https://forum.inductiveautomation.com/u/Norman_Mountain)\ **Replies:** 1\ **Last updated:** [December 8, 2022, 9:08pm UTC](https://forum.inductiveautomation.com/t/count-objects-in-an-image/67405 "2022-12-08T21:08:27Z")
Is it possible to utilize a camera such as an IP camera or even a webcam to capture an image of a tray (like a muffin pan) on a moving conveyor and and count the number of organized product in the tray as it moving down … --- ## [What would be the best (easiest) way to convert a string TAG (True) / (False) to boolean?](https://forum.inductiveautomation.com/t/what-would-be-the-best-easiest-way-to-convert-a-string-tag-true-false-to-boolean/67393)
**Author:** [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\ **Replies:** 4\ **Last updated:** [December 8, 2022, 7:46pm UTC](https://forum.inductiveautomation.com/t/what-would-be-the-best-easiest-way-to-convert-a-string-tag-true-false-to-boolean/67393 "2022-12-08T19:46:33Z")
Is there a simple way to setup a few string tags (True / False) to boolean? --- ## [Need to display cyl tank level unit = value + "L" (eg - 79L)](https://forum.inductiveautomation.com/t/need-to-display-cyl-tank-level-unit-value-l-eg-79l/67395)
**Author:** [@PINAK\_MEHTA](https://forum.inductiveautomation.com/u/PINAK_MEHTA)\ **Replies:** 1\ **Last updated:** [December 8, 2022, 7:34pm UTC](https://forum.inductiveautomation.com/t/need-to-display-cyl-tank-level-unit-value-l-eg-79l/67395 "2022-12-08T19:34:32Z")
Tried the Transform function. I am getting the desired display on props.value.value but not in the view. --- ## [Limiting Designer Query Sizes](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351)
**Author:** [@kyler.kamyszek](https://forum.inductiveautomation.com/u/kyler.kamyszek)\ **Replies:** 8\ **Last updated:** [December 8, 2022, 7:01pm UTC](https://forum.inductiveautomation.com/t/limiting-designer-query-sizes/67351 "2022-12-08T19:01:14Z")
Is there a way to limit number of rows that get returned from any query when in designer? Other than just normal db best practices? I have a large database table, and a contractor didn't put a 'Top' condition in and it… --- ## [Format data in dataset from tag history query](https://forum.inductiveautomation.com/t/format-data-in-dataset-from-tag-history-query/66780)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 6\ **Last updated:** [December 8, 2022, 6:27pm UTC](https://forum.inductiveautomation.com/t/format-data-in-dataset-from-tag-history-query/66780 "2022-12-08T18:27:39Z")
I am running ignition edge and once a day i am creating a csv file with floating point values coming from the tag historian. I have the tag history set to be one floating point value but when my csv file is created it h… --- ## [Large projekt performance problem, slowed gateway connection](https://forum.inductiveautomation.com/t/large-projekt-performance-problem-slowed-gateway-connection/67380)
**Author:** [@Michal\_Goralczyk](https://forum.inductiveautomation.com/u/Michal_Goralczyk)\ **Replies:** 2\ **Last updated:** [December 8, 2022, 5:45pm UTC](https://forum.inductiveautomation.com/t/large-projekt-performance-problem-slowed-gateway-connection/67380 "2022-12-08T17:45:04Z")
Hello, We are working on a large project of several hundred photovoltaic farms added to our SCADA ignition. Up to now everything was working very stably but we are starting to have problems with the connection between g… --- ## [Automatic navigation after 5 seconds](https://forum.inductiveautomation.com/t/automatic-navigation-after-5-seconds/67372)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 2\ **Last updated:** [December 8, 2022, 5:23pm UTC](https://forum.inductiveautomation.com/t/automatic-navigation-after-5-seconds/67372 "2022-12-08T17:23:00Z")
Hi , I have a landing page while launch, i would like to navigate to another page after 5 seconds automatically. how to achieve this in perspective? Thanks in advance --- ## [Avoid stretched bar chart](https://forum.inductiveautomation.com/t/avoid-stretched-bar-chart/67379)
**Author:** [@Dharani\_T](https://forum.inductiveautomation.com/u/Dharani_T)\ **Replies:** 2\ **Last updated:** [December 8, 2022, 5:12pm UTC](https://forum.inductiveautomation.com/t/avoid-stretched-bar-chart/67379 "2022-12-08T17:12:47Z")
Hi, I have a window with barchart as below in vision, I would like to avoid the elongated bar( I know it is elongates as it has only one column value) But is there a way to avoid this? --- ## [Encoding Issue with PostgreSQL](https://forum.inductiveautomation.com/t/encoding-issue-with-postgresql/67381)
**Author:** [@Peter.Dmitriev](https://forum.inductiveautomation.com/u/Peter.Dmitriev)\ **Replies:** 1\ **Last updated:** [December 8, 2022, 4:29pm UTC](https://forum.inductiveautomation.com/t/encoding-issue-with-postgresql/67381 "2022-12-08T16:29:41Z")
Hello, We can't connect Ignition gateway to PostgreSQL. Getting the following error: Cannot create PoolableConnectionFactory (FATAL: kein pg\_hba.conf-Eintrag für Host »10.249.99.129«, Benutzer »backup«, Datenbank »post… --- ## [\_\_str\_\_ not working as expected?](https://forum.inductiveautomation.com/t/str-not-working-as-expected/67382)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 4\ **Last updated:** [December 8, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/str-not-working-as-expected/67382 "2022-12-08T16:03:48Z")
I am making a class that records a result from an named query interaction with the database. I am trying to make it print nicely so I can log it and it looks nice. My code is class Response(object): # TODO Figure out… --- ## [Progress Bar Custom Text](https://forum.inductiveautomation.com/t/progress-bar-custom-text/53687)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 8\ **Last updated:** [December 8, 2022, 3:52pm UTC](https://forum.inductiveautomation.com/t/progress-bar-custom-text/53687 "2022-12-08T15:52:15Z")
For the perspective progress bar you can display the value and set a max, for example here is 1820 out of 3231: What I want to do is have the displayed text be “1820 / 3221”. Is there any way to do it? Thanks, Nic… --- ## [Problem writing variable to PLC Siemens S7 1500](https://forum.inductiveautomation.com/t/problem-writing-variable-to-plc-siemens-s7-1500/67376)
**Author:** [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\ **Replies:** 4\ **Last updated:** [December 8, 2022, 3:37pm UTC](https://forum.inductiveautomation.com/t/problem-writing-variable-to-plc-siemens-s7-1500/67376 "2022-12-08T15:37:21Z")
Hello, I have a project Vision 8.1.16 with connection to PLC S71500. I can read all PLC variable but when try to write a PLC variable, I have this message: Error writing to indice\_ciclo.value: Bad("Bad\_CommunicationEr… --- ## [Convert DateTime value to string for csv file](https://forum.inductiveautomation.com/t/convert-datetime-value-to-string-for-csv-file/67384)
**Author:** [@michael.black](https://forum.inductiveautomation.com/u/michael.black)\ **Replies:** 2\ **Last updated:** [December 8, 2022, 3:33pm UTC](https://forum.inductiveautomation.com/t/convert-datetime-value-to-string-for-csv-file/67384 "2022-12-08T15:33:24Z")
I have a datetime object from an ignition edge gateway tag historian being retrieved and put into a csv file. The datetime itself is still showing up as a unicode value instead of a string. I do have str() around the d… --- ## [Read history tag and extract one column](https://forum.inductiveautomation.com/t/read-history-tag-and-extract-one-column/67377)
**Author:** [@Tim\_Hansson](https://forum.inductiveautomation.com/u/Tim_Hansson)\ **Replies:** 2\ **Last updated:** [December 8, 2022, 1:19pm UTC](https://forum.inductiveautomation.com/t/read-history-tag-and-extract-one-column/67377 "2022-12-08T13:19:55Z")
Hi, I want to use a binding -\> tag history to display the value of that time I choose. In the binding I get a dataset but I wan't only the value and not the time with it. Is it possible with a expression? --- ## [How to translate File Upload components?](https://forum.inductiveautomation.com/t/how-to-translate-file-upload-components/50816)
**Author:** [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\ **Replies:** 7\ **Last updated:** [December 8, 2022, 1:15pm UTC](https://forum.inductiveautomation.com/t/how-to-translate-file-upload-components/50816 "2022-12-08T13:15:17Z")
I put “Browse” and “or Drag files here” into Translation Manager. “Browse” works, but “or Drag files here” doesn’t. So how to translate it? Usually, I use scripts instead, but there’s only system.perspective.downloa… --- ## [Property/parameter binding between views](https://forum.inductiveautomation.com/t/property-parameter-binding-between-views/67286)
**Author:** [@Theodorska](https://forum.inductiveautomation.com/u/Theodorska)\ **Replies:** 3\ **Last updated:** [December 8, 2022, 9:31am UTC](https://forum.inductiveautomation.com/t/property-parameter-binding-between-views/67286 "2022-12-08T09:31:35Z")
Hello, New guy here just trying his best. I have struggled with binding properties between views. I have managed to do it, but there must be a more efficient way of doing this. I want to change a tag path in a subview… --- ## [Perspective picture not updating?](https://forum.inductiveautomation.com/t/perspective-picture-not-updating/67317)
**Author:** [@hayden](https://forum.inductiveautomation.com/u/hayden)\ **Replies:** 5\ **Last updated:** [December 8, 2022, 8:26am UTC](https://forum.inductiveautomation.com/t/perspective-picture-not-updating/67317 "2022-12-08T08:26:13Z")
Hey, We're using a picture on our mimic to show a map of the local area. We've got a view setup where a parameter is fed in from the URL, and this should then update the picture to show a different image. I've set up a … --- ## [Trying to read file in Mapped Network Drive](https://forum.inductiveautomation.com/t/trying-to-read-file-in-mapped-network-drive/31284)
**Author:** [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\ **Replies:** 20\ **Last updated:** [December 8, 2022, 12:53am UTC](https://forum.inductiveautomation.com/t/trying-to-read-file-in-mapped-network-drive/31284 "2022-12-08T00:53:36Z")
I’m trying to read a text file in a mapped network drive named Z:. I altered the Ignition.conf file to configure the network drive. When I reviewed the wrapper logs to see if it connected successfully, I saw this so it… --- ## [When I disconnect the dualization from the computer that was entered as the existing backup account and enter my account, the gate name appears as the master account. How can I see it as the original account?](https://forum.inductiveautomation.com/t/when-i-disconnect-the-dualization-from-the-computer-that-was-entered-as-the-existing-backup-account-and-enter-my-account-the-gate-name-appears-as-the-master-account-how-can-i-see-it-as-the-original-account/67067)
**Author:** [@jiyoung\_hwang](https://forum.inductiveautomation.com/u/jiyoung_hwang)\ **Replies:** 3\ **Last updated:** [December 7, 2022, 4:36pm UTC](https://forum.inductiveautomation.com/t/when-i-disconnect-the-dualization-from-the-computer-that-was-entered-as-the-existing-backup-account-and-enter-my-account-the-gate-name-appears-as-the-master-account-how-can-i-see-it-as-the-original-account/67067 "2022-12-07T16:36:43Z")
When I disconnect the dualization from the computer that was entered as the existing backup account and enter my account, the gate name appears as the master account. How can I see it as the original account? For refere… --- ## [Perspective simple gauge text properties](https://forum.inductiveautomation.com/t/perspective-simple-gauge-text-properties/54750)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 7\ **Last updated:** [December 7, 2022, 11:28pm UTC](https://forum.inductiveautomation.com/t/perspective-simple-gauge-text-properties/54750 "2022-12-07T23:28:46Z")
Is there a way to have more control over the perspective gauge text properties? In particular it is annoying that it is not centered in the gauge out of the box: Thanks, Nick --- ## [Tag Change Event on Write when tag value is unchanged](https://forum.inductiveautomation.com/t/tag-change-event-on-write-when-tag-value-is-unchanged/67349)
**Author:** [@nicholas.robinson](https://forum.inductiveautomation.com/u/nicholas.robinson)\ **Replies:** 4\ **Last updated:** [December 7, 2022, 10:12pm UTC](https://forum.inductiveautomation.com/t/tag-change-event-on-write-when-tag-value-is-unchanged/67349 "2022-12-07T22:12:45Z")
Is there a way to generate a tag change event "on write" such that if a tag holds one value, if the exact same value is written to it but at a different point in time which is later than its last update, a tag change eve… --- ## [Tag Loading Error](https://forum.inductiveautomation.com/t/tag-loading-error/67363)
**Author:** [@Anthony\_Werner](https://forum.inductiveautomation.com/u/Anthony_Werner)\ **Replies:** 3\ **Last updated:** [December 7, 2022, 10:00pm UTC](https://forum.inductiveautomation.com/t/tag-loading-error/67363 "2022-12-07T22:00:34Z")
See above is a snippet of a screen I am working on with some tag errors. I use an embedded view and a numbering system to indirectly tag bind them. All the tags are coming into the tag browser correctly. So, the issue … --- ## [system.db.prepUpdate error](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344)
**Author:** [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\ **Replies:** 7\ **Last updated:** [December 7, 2022, 7:18pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344 "2022-12-07T19:18:29Z")
Hi there, I am suddenly getting a wierd error with the system.db.prepUpdate function. im calling it from an alarm active tag scripting function And i am getting this error which i wasnt before Error executing scrip… --- ## [8.1 report module - add/delete pens in chart](https://forum.inductiveautomation.com/t/8-1-report-module-add-delete-pens-in-chart/66929)
**Author:** [@flavien](https://forum.inductiveautomation.com/u/flavien)\ **Replies:** 2\ **Last updated:** [December 7, 2022, 6:24pm UTC](https://forum.inductiveautomation.com/t/8-1-report-module-add-delete-pens-in-chart/66929 "2022-12-07T18:24:27Z")
Hi, In report module I would like to add or delete a pen in my timeseries chart by script. Is it possible and how to do this ? --- ## [Taking Pictures from USB Camera](https://forum.inductiveautomation.com/t/taking-pictures-from-usb-camera/66403)
**Author:** [@Leonel\_Rodriguez](https://forum.inductiveautomation.com/u/Leonel_Rodriguez)\ **Replies:** 1\ **Last updated:** [December 7, 2022, 5:54pm UTC](https://forum.inductiveautomation.com/t/taking-pictures-from-usb-camera/66403 "2022-12-07T17:54:17Z")
Hi everyone Is there a way to take pictures from a USB camera and store them with Scripting? --- ## [system.alarm.queryStatus Exception with example in Docs](https://forum.inductiveautomation.com/t/system-alarm-querystatus-exception-with-example-in-docs/66923)
**Author:** [@mik977](https://forum.inductiveautomation.com/u/mik977)\ **Replies:** 1\ **Last updated:** [December 7, 2022, 5:47pm UTC](https://forum.inductiveautomation.com/t/system-alarm-querystatus-exception-with-example-in-docs/66923 "2022-12-07T17:47:39Z")
This example from the docs generates an Exception: props = \[("Group", "=", "value1"), ("Group", "=", "value2")\] state = \["ActiveUnacked", "ActiveAcked"\] alarms = system.alarm.queryStatus(any\_properties = props, state … [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=734) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=736)