# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=946 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 947 --- ## [Help request to fix system.db.runPrepUpdate issue](https://forum.inductiveautomation.com/t/help-request-to-fix-system-db-runprepupdate-issue/48884)
**Author:** [@zeyad.mohamed](https://forum.inductiveautomation.com/u/zeyad.mohamed)\ **Replies:** 3\ **Last updated:** [October 18, 2021, 8:40pm UTC](https://forum.inductiveautomation.com/t/help-request-to-fix-system-db-runprepupdate-issue/48884 "2021-10-18T20:40:41Z")
For some reason I cannot update the data table in the postgres database from the ignition script by using the system.db.runPrepUpdate function. Would you please help me out to fix the issue --- ## [Access to Component Events value](https://forum.inductiveautomation.com/t/access-to-component-events-value/52068)
**Author:** [@g.jaime](https://forum.inductiveautomation.com/u/g.jaime)\ **Replies:** 3\ **Last updated:** [October 18, 2021, 8:10pm UTC](https://forum.inductiveautomation.com/t/access-to-component-events-value/52068 "2021-10-18T20:10:18Z")
I have the FileUpload component and what I want to do is access the values of the onFileReceived event. Example: I defined a variable called “filename” when uploading a file And I want to access this variable from a… --- ## [Git Auto-Commit with Password](https://forum.inductiveautomation.com/t/git-auto-commit-with-password/51963)
**Author:** [@jacob.ramirez](https://forum.inductiveautomation.com/u/jacob.ramirez)\ **Replies:** 8\ **Last updated:** [October 18, 2021, 8:03pm UTC](https://forum.inductiveautomation.com/t/git-auto-commit-with-password/51963 "2021-10-18T20:03:36Z")
Has anyone been able to get the auto-commit on the designer to save working when the remote repo authentication requires a personal access token? When I commit my changes through the command prompt, it asks me for my pe… --- ## [MODBUS Addressing High and Low Bytes](https://forum.inductiveautomation.com/t/modbus-addressing-high-and-low-bytes/52070)
**Author:** [@pridesleap](https://forum.inductiveautomation.com/u/pridesleap)\ **Replies:** 2\ **Last updated:** [October 18, 2021, 6:52pm UTC](https://forum.inductiveautomation.com/t/modbus-addressing-high-and-low-bytes/52070 "2021-10-18T18:52:31Z")
Hello all. I have connected to a device using OPC MODBUS RTU over TCP. I’m receiving good data for most of the points I need to bring into the SCADA but I have a question about splitting up a 16bit packed register. I ne… --- ## [How to fix TypeError: Unable to covert row 1, column 1 to type class java.lang.Integer](https://forum.inductiveautomation.com/t/how-to-fix-typeerror-unable-to-covert-row-1-column-1-to-type-class-java-lang-integer/52061)
**Author:** [@jill.zhao](https://forum.inductiveautomation.com/u/jill.zhao)\ **Replies:** 2\ **Last updated:** [October 18, 2021, 4:09pm UTC](https://forum.inductiveautomation.com/t/how-to-fix-typeerror-unable-to-covert-row-1-column-1-to-type-class-java-lang-integer/52061 "2021-10-18T16:09:38Z")
my code is want to get a new dataset, but on the line systme.tag.writeblocking line ,it said the type error, could you please help fix it ? thanks pressurecycles=\[\] i=0 for i in range(0,len(pressure\_range)): press… --- ## [\[IGN-3883\]Vision - Find/Replace tool not finding results unless resources are open](https://forum.inductiveautomation.com/t/ign-3883-vision-find-replace-tool-not-finding-results-unless-resources-are-open/52047)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 0\ **Last updated:** [October 18, 2021, 6:22am UTC](https://forum.inductiveautomation.com/t/ign-3883-vision-find-replace-tool-not-finding-results-unless-resources-are-open/52047 "2021-10-18T06:22:29Z")
I’ve recently upgraded a v7.9.5 project to 8.1.5, and i’m trying to use find/replace to replace a bunch of things, but they’re not showing up in the results. If I open a Template that I know has the term and then search,… --- ## [Alarm Status Table](https://forum.inductiveautomation.com/t/alarm-status-table/52015)
**Author:** [@xavo1992](https://forum.inductiveautomation.com/u/xavo1992)\ **Replies:** 4\ **Last updated:** [October 18, 2021, 3:50pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table/52015 "2021-10-18T15:50:22Z")
Hi developers, i need yours help… I want to configure the viewing characteristics of the alarm table so that when entering the page it is already configured automatically, but i did find the solution. I want to see some… --- ## [Blank main desktop after project update](https://forum.inductiveautomation.com/t/blank-main-desktop-after-project-update/51530)
**Author:** [@andreas](https://forum.inductiveautomation.com/u/andreas)\ **Replies:** 1\ **Last updated:** [October 18, 2021, 3:34pm UTC](https://forum.inductiveautomation.com/t/blank-main-desktop-after-project-update/51530 "2021-10-18T15:34:07Z")
Hi all, On our operator station we have two 4k monitors. When launching a new client it opens on the main monitor. In our client we have a button to open an additional desktop on the second monitor. When we save some n… --- ## [How to fix IndexError: index out of range: 0](https://forum.inductiveautomation.com/t/how-to-fix-indexerror-index-out-of-range-0/52043)
**Author:** [@jill.zhao](https://forum.inductiveautomation.com/u/jill.zhao)\ **Replies:** 4\ **Last updated:** [October 18, 2021, 3:24pm UTC](https://forum.inductiveautomation.com/t/how-to-fix-indexerror-index-out-of-range-0/52043 "2021-10-18T15:24:39Z")
I try to get a list of number of cycles in time history, but I could not get the list and it show me that indexerror, could you please help me to fix it in ignition 8.1, thank you Sum\_w= for i in range(0,len(pressure\_r… --- ## [Cell Coloring using Style](https://forum.inductiveautomation.com/t/cell-coloring-using-style/52055)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 2\ **Last updated:** [October 18, 2021, 2:29pm UTC](https://forum.inductiveautomation.com/t/cell-coloring-using-style/52055 "2021-10-18T14:29:12Z")
Hello everyone, I am trying to change the color of a cell in a perspective table based on the value of two columns. Currently, I am doing this in the script mapping of data property binding. The script is: output\_jso… --- ## [How to Bit write with Modbus v2?](https://forum.inductiveautomation.com/t/how-to-bit-write-with-modbus-v2/3121)
**Author:** [@Tjoeben](https://forum.inductiveautomation.com/u/Tjoeben)\ **Replies:** 12\ **Last updated:** [October 18, 2021, 2:52pm UTC](https://forum.inductiveautomation.com/t/how-to-bit-write-with-modbus-v2/3121 "2021-10-18T14:52:39Z")
I use the Modbus v2 driver, and in the manual there is no explication how to write to a single bit in a holding register in the PLC (Modicon compact A984-130). --- ## [Pro Level Debugging](https://forum.inductiveautomation.com/t/pro-level-debugging/51991)
**Author:** [@claude.hager](https://forum.inductiveautomation.com/u/claude.hager)\ **Replies:** 4\ **Last updated:** [October 18, 2021, 12:18pm UTC](https://forum.inductiveautomation.com/t/pro-level-debugging/51991 "2021-10-18T12:18:08Z")
I am a long time professional developer in my company’s IT department, primarily using Visual Studio. I have recently been using Ignition to create Industrial applications and to support engineers and technicians across … --- ## [Perspective Alarm Status Table Background color change?](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-background-color-change/52052)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 1\ **Last updated:** [October 18, 2021, 12:13pm UTC](https://forum.inductiveautomation.com/t/perspective-alarm-status-table-background-color-change/52052 "2021-10-18T12:13:11Z")
Can anyone give a hint, how to change the background color of the Perspective Alarm Status Table, when it’s empty, no alarms present? And also hide the annoying message “No results found” and the icon? I tried with s… --- ## [Retreive a list of existing tag groups](https://forum.inductiveautomation.com/t/retreive-a-list-of-existing-tag-groups/52053)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 0\ **Last updated:** [October 18, 2021, 10:40am UTC](https://forum.inductiveautomation.com/t/retreive-a-list-of-existing-tag-groups/52053 "2021-10-18T10:40:28Z")
Continuing the discussion from \[Feature-2684\]Scripting - Tag group - Create / Delete: I just came to a situation when this would be a very useful feature… --- ## [How to fix ValueError, math domain error](https://forum.inductiveautomation.com/t/how-to-fix-valueerror-math-domain-error/52020)
**Author:** [@jill.zhao](https://forum.inductiveautomation.com/u/jill.zhao)\ **Replies:** 4\ **Last updated:** [October 18, 2021, 4:30am UTC](https://forum.inductiveautomation.com/t/how-to-fix-valueerror-math-domain-error/52020 "2021-10-18T04:30:55Z")
Hi I try to use math.log in my function, but it does not return any values, I get ValueError, math domain error, how do I fix it? Thank you. N= x=0 for x in range(0,len(stressrange)): stressval=stressrange/1000 logv… --- ## [Ignition 8.1 UI scaling](https://forum.inductiveautomation.com/t/ignition-8-1-ui-scaling/45037)
**Author:** [@cluo087](https://forum.inductiveautomation.com/u/cluo087)\ **Replies:** 0\ **Last updated:** [March 30, 2021, 3:08am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-ui-scaling/45037 "2021-03-30T03:08:30Z")
Hi guys, OS: Windows 10 Ignition version: Version: 8.1.2 (b2021020311) Java Version: 11.0.9+11-LTS (from gateway status page) Issue: If my windows display scaling is set to 125%, then the vision client scales up and… --- ## [Changing PowerChart to display on change instead of value?](https://forum.inductiveautomation.com/t/changing-powerchart-to-display-on-change-instead-of-value/51964)
**Author:** [@isabellapitco](https://forum.inductiveautomation.com/u/isabellapitco)\ **Replies:** 2\ **Last updated:** [October 18, 2021, 1:30am UTC](https://forum.inductiveautomation.com/t/changing-powerchart-to-display-on-change-instead-of-value/51964 "2021-10-18T01:30:20Z")
Exactly as the title says. I have a tag I want to display in a PowerChart that just contains string data, so I don’t want to chart its actual value on a plot, just whether it has changed. As I’ve been imagining it, I wou… --- ## [Perspective table - every second cell-selection starts cell edit](https://forum.inductiveautomation.com/t/perspective-table-every-second-cell-selection-starts-cell-edit/52025)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 0\ **Last updated:** [October 16, 2021, 2:38pm UTC](https://forum.inductiveautomation.com/t/perspective-table-every-second-cell-selection-starts-cell-edit/52025 "2021-10-16T14:38:28Z")
Try this: Add the Table component to a view. Set the columns to ‘city’, ‘country’ and ‘population’ and enable editing for each. Set cells | allowEditOn : single-click. Hit the Preview mode button. Now click around the… --- ## [Recipe DB to OPC Transaction](https://forum.inductiveautomation.com/t/recipe-db-to-opc-transaction/52027)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 4\ **Last updated:** [October 16, 2021, 10:30pm UTC](https://forum.inductiveautomation.com/t/recipe-db-to-opc-transaction/52027 "2021-10-16T22:30:54Z")
I am working on testing a Transaction Group using DB to OPC for recipe Data stored in a database. I am trying to figure out how to use a memory tag to trigger the ID of the row of data I want for that recipe and then wri… --- ## [MSSQL query between 2 dates](https://forum.inductiveautomation.com/t/mssql-query-between-2-dates/51958)
**Author:** [@hinton](https://forum.inductiveautomation.com/u/hinton)\ **Replies:** 3\ **Last updated:** [October 16, 2021, 7:59pm UTC](https://forum.inductiveautomation.com/t/mssql-query-between-2-dates/51958 "2021-10-16T19:59:23Z")
I’m pretty new to Ignition, and I have seen other threads related to this topic, but have not found anything that resolves this issue. I need to use the report viewer with a date range component to set the start and end… --- ## [Perspective table disable editing on certain rows](https://forum.inductiveautomation.com/t/perspective-table-disable-editing-on-certain-rows/52016)
**Author:** [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Replies:** 2\ **Last updated:** [October 16, 2021, 12:20pm UTC](https://forum.inductiveautomation.com/t/perspective-table-disable-editing-on-certain-rows/52016 "2021-10-16T12:20:37Z")
I am using a Perspective application to manage passwords for our various control systems. Based on the user’s rights they will be able to see the password or ‘\*\*\*\*\*\*\*\*’. If they have rights to the password they can edit … --- ## [How to block data in a power tables column](https://forum.inductiveautomation.com/t/how-to-block-data-in-a-power-tables-column/51999)
**Author:** [@jshaffer09](https://forum.inductiveautomation.com/u/jshaffer09)\ **Replies:** 4\ **Last updated:** [October 15, 2021, 10:47pm UTC](https://forum.inductiveautomation.com/t/how-to-block-data-in-a-power-tables-column/51999 "2021-10-15T22:47:52Z")
Is there a way to block everthing other than numeric values from be entered in to a power tables column? --- ## [DB for Tag Provider](https://forum.inductiveautomation.com/t/db-for-tag-provider/51795)
**Author:** [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\ **Replies:** 6\ **Last updated:** [October 15, 2021, 10:32pm UTC](https://forum.inductiveautomation.com/t/db-for-tag-provider/51795 "2021-10-15T22:32:48Z")
HI. What is the best solution when choosing a database for a Tagprovider? Should the database be locally on the same server as the gateway or remote on another server? best regards. --- ## [Java fonts and Windows](https://forum.inductiveautomation.com/t/java-fonts-and-windows/51969)
**Author:** [@MCC](https://forum.inductiveautomation.com/u/MCC)\ **Replies:** 9\ **Last updated:** [October 15, 2021, 9:45pm UTC](https://forum.inductiveautomation.com/t/java-fonts-and-windows/51969 "2021-10-15T21:45:06Z")
This archived old thread seems closest to what I am chasing except I’m on Windows rather than Linux. I have a customer running Ignition 7.9.18 and recently noticed that a bunch of their text fields don’t display properl… --- ## [Vision Client Launcher: Update Dialog - Disable](https://forum.inductiveautomation.com/t/vision-client-launcher-update-dialog-disable/52014)
**Author:** [@robwarren](https://forum.inductiveautomation.com/u/robwarren)\ **Replies:** 4\ **Last updated:** [October 15, 2021, 8:55pm UTC](https://forum.inductiveautomation.com/t/vision-client-launcher-update-dialog-disable/52014 "2021-10-15T20:55:54Z")
Hello, Is there a way to disable the “You should update your client launcher Version” dialog that pops up when I launch my project? Currently we build a custom installer that allows us to drop a shortcut on the desktop… --- ## [Xy Chart Fill Beneath graph?](https://forum.inductiveautomation.com/t/xy-chart-fill-beneath-graph/52002)
**Author:** [@downerczx](https://forum.inductiveautomation.com/u/downerczx)\ **Replies:** 2\ **Last updated:** [October 15, 2021, 7:41pm UTC](https://forum.inductiveautomation.com/t/xy-chart-fill-beneath-graph/52002 "2021-10-15T19:41:30Z")
Is it possible to fill the area under the lines so it is solid colored? --- ## [How to insert dataset to a databse](https://forum.inductiveautomation.com/t/how-to-insert-dataset-to-a-databse/52000)
**Author:** [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Replies:** 3\ **Last updated:** [October 15, 2021, 6:48pm UTC](https://forum.inductiveautomation.com/t/how-to-insert-dataset-to-a-databse/52000 "2021-10-15T18:48:06Z")
Hello I would like to insert a dataset (shown below with 2 rows and 10 columns) into a database but I am not how to do this! I have tried this script but it is not working: data= self.view.custom.part.spec.data … --- ## [Remove tag provider on tag path string in expression tag binding](https://forum.inductiveautomation.com/t/remove-tag-provider-on-tag-path-string-in-expression-tag-binding/51975)
**Author:** [@phandc](https://forum.inductiveautomation.com/u/phandc)\ **Replies:** 2\ **Last updated:** [October 15, 2021, 4:37pm UTC](https://forum.inductiveautomation.com/t/remove-tag-provider-on-tag-path-string-in-expression-tag-binding/51975 "2021-10-15T16:37:05Z")
Hi, everyone. I have a power chart and I want to bind a historical tag path to pen\[0\].data.source property of the power chart for displaying the tag value. However, when I made a binding with a view’s param, it automati… --- ## [Programming Set IP address for OPC-UA Device?](https://forum.inductiveautomation.com/t/programming-set-ip-address-for-opc-ua-device/51995)
**Author:** [@TheColonel26](https://forum.inductiveautomation.com/u/TheColonel26)\ **Replies:** 1\ **Last updated:** [October 15, 2021, 4:31pm UTC](https://forum.inductiveautomation.com/t/programming-set-ip-address-for-opc-ua-device/51995 "2021-10-15T16:31:09Z")
I would like to be able to programmatically set the host name of a Allen Bradley Device Connection (For OPC-UA) on the gateway using a python script. Basically I want to be able to let the user set the IP address to the… --- ## [Programically Change Database Connection?](https://forum.inductiveautomation.com/t/programically-change-database-connection/51993)
**Author:** [@TheColonel26](https://forum.inductiveautomation.com/u/TheColonel26)\ **Replies:** 1\ **Last updated:** [October 15, 2021, 4:28pm UTC](https://forum.inductiveautomation.com/t/programically-change-database-connection/51993 "2021-10-15T16:28:07Z")
I would like to be able to set the Connect URL, and the Database name in a Database connection on the gateway using a python script. Is this possible? If so how would I go about it? [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=945) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=947)