# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1280 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1281 --- ## [Report with excel formulae](https://forum.inductiveautomation.com/t/report-with-excel-formulae/39738)
**Author:** [@BenKearney](https://forum.inductiveautomation.com/u/BenKearney)\ **Replies:** 1\ **Last updated:** [October 16, 2020, 3:45pm UTC](https://forum.inductiveautomation.com/t/report-with-excel-formulae/39738 "2020-10-16T15:45:52Z")
Hi, I’d like to be able to create a xlsx report that contains several columns of data, followed by several columns of excel formulae that the user can inspect if required. Is this possible and how can I do it? Thanks! --- ## [Force Coil](https://forum.inductiveautomation.com/t/force-coil/6031)
**Author:** [@txlittle](https://forum.inductiveautomation.com/u/txlittle)\ **Replies:** 8\ **Last updated:** [October 16, 2020, 3:21pm UTC](https://forum.inductiveautomation.com/t/force-coil/6031 "2020-10-16T15:21:49Z")
Hello I want to force a coil using modbus protocol TCP, but the modbus driver provided by ignition doesn´t have this option, How i can make that possible??? --- ## [Stored Procedure Vs Direct Mapping with Table when migrate a Legacy System](https://forum.inductiveautomation.com/t/stored-procedure-vs-direct-mapping-with-table-when-migrate-a-legacy-system/39716)
**Author:** [@pepcoder](https://forum.inductiveautomation.com/u/pepcoder)\ **Replies:** 6\ **Last updated:** [October 16, 2020, 2:25pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-vs-direct-mapping-with-table-when-migrate-a-legacy-system/39716 "2020-10-16T14:25:35Z")
Hi , We are working on a project related to migrating a legacy system from an old SQL server to the latest version . Along with that , the Factory SQL , Old Ignition transaction groups also we are migrating on a new ser… --- ## [Chart in reports](https://forum.inductiveautomation.com/t/chart-in-reports/12445)
**Author:** [@accyroy](https://forum.inductiveautomation.com/u/accyroy)\ **Replies:** 8\ **Last updated:** [October 16, 2020, 1:27pm UTC](https://forum.inductiveautomation.com/t/chart-in-reports/12445 "2020-10-16T13:27:06Z")
The report module is my real weakness. I'm trying to get it to just display a simple chart, but it just wont do what I want. I've attached an image of what I want to accomplish. I have a 3 column dataset: Group S… --- ## [8.1.0-RC3 can't set up report schedule](https://forum.inductiveautomation.com/t/8-1-0-rc3-cant-set-up-report-schedule/39739)
**Author:** [@BenKearney](https://forum.inductiveautomation.com/u/BenKearney)\ **Replies:** 2\ **Last updated:** [October 16, 2020, 12:19pm UTC](https://forum.inductiveautomation.com/t/8-1-0-rc3-cant-set-up-report-schedule/39739 "2020-10-16T12:19:34Z")
Hi, When I try to assign a schedule to my report, all elements within the schedule pane are greyed out. Is this a bug or have I forgotten a step since I last use the reporting module? Thanks --- ## [How to show default values in settings page extended from RecordEditForm](https://forum.inductiveautomation.com/t/how-to-show-default-values-in-settings-page-extended-from-recordeditform/39719)
**Author:** [@mpervaiz](https://forum.inductiveautomation.com/u/mpervaiz)\ **Replies:** 2\ **Last updated:** [October 16, 2020, 12:15pm UTC](https://forum.inductiveautomation.com/t/how-to-show-default-values-in-settings-page-extended-from-recordeditform/39719 "2020-10-16T12:15:16Z")
I am building a module and for my module I have a confg settings page (extended from RecordEditForm). I want to know how to add the default value text for each field as in other config pages (like in attached image) --- ## [How to create stacked bar chart in Perspective](https://forum.inductiveautomation.com/t/how-to-create-stacked-bar-chart-in-perspective/39740)
**Author:** [@phi.nguyen](https://forum.inductiveautomation.com/u/phi.nguyen)\ **Replies:** 1\ **Last updated:** [October 16, 2020, 9:47am UTC](https://forum.inductiveautomation.com/t/how-to-create-stacked-bar-chart-in-perspective/39740 "2020-10-16T09:47:30Z")
Hi everyone , i know its pretty dumb to ask this but can i ask for how to make this? --- ## [Translation manager of power table](https://forum.inductiveautomation.com/t/translation-manager-of-power-table/39697)
**Author:** [@vincent.hu](https://forum.inductiveautomation.com/u/vincent.hu)\ **Replies:** 2\ **Last updated:** [October 16, 2020, 7:25am UTC](https://forum.inductiveautomation.com/t/translation-manager-of-power-table/39697 "2020-10-16T07:25:04Z")
When translation manager is used to translate the header of power table, it shows garbled code. The date of power table is bound with SQL query. However, when I manually add the column of data, it can be translated norma… --- ## [How can i get or print selected id when i double click the selected row in the Power Table?](https://forum.inductiveautomation.com/t/how-can-i-get-or-print-selected-id-when-i-double-click-the-selected-row-in-the-power-table/39653)
**Author:** [@vincent.canda](https://forum.inductiveautomation.com/u/vincent.canda)\ **Replies:** 2\ **Last updated:** [October 16, 2020, 6:21am UTC](https://forum.inductiveautomation.com/t/how-can-i-get-or-print-selected-id-when-i-double-click-the-selected-row-in-the-power-table/39653 "2020-10-16T06:21:51Z")
I want to get the ID of the selected rows in the power table using extension function (double click). Reference: Thank you, --- ## [OPC-DA Unknown Quality](https://forum.inductiveautomation.com/t/opc-da-unknown-quality/14809)
**Author:** [@hcarroll](https://forum.inductiveautomation.com/u/hcarroll)\ **Replies:** 6\ **Last updated:** [October 16, 2020, 4:53am UTC](https://forum.inductiveautomation.com/t/opc-da-unknown-quality/14809 "2020-10-16T04:53:59Z")
I'm trying to connect to data from a remote machine running Wonderware system platform using OPC-DA. I'm able to connect to the da server, but I'm unable to browse tags except the system $sys tags. If I use the Matrikon … --- ## [Ignition 8.1.0rc1 sql date issue](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558)
**Author:** [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Replies:** 4\ **Last updated:** [October 16, 2020, 4:48am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-0rc1-sql-date-issue/39558 "2020-10-16T04:48:43Z")
In my previous ignition 8.0.10RC1, if I select a data from a sql table it will not contain the red line highlight data It will only show 2020-05-13 this date, time will not have but after update to 8.1.0RC1 it wi… --- ## [\[BUG-826\] Error handling route. route=/hello/:project\_name/:tab\_id, route-group=perspective, route-path=/hello](https://forum.inductiveautomation.com/t/bug-826-error-handling-route-route-hello-project-name-tab-id-route-group-perspective-route-path-hello/39599)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 9\ **Last updated:** [October 16, 2020, 4:12am UTC](https://forum.inductiveautomation.com/t/bug-826-error-handling-route-route-hello-project-name-tab-id-route-group-perspective-route-path-hello/39599 "2020-10-16T04:12:50Z")
I am continuously getting above error in log file every 10 Seconds! How to stop it? Why is it coming? Restart Ignition is the only solution? INFO | jvm 1 | 2020/10/12 22:14:24 | W \[g.D.Route \] \[… --- ## [Calendar object multi-day selection](https://forum.inductiveautomation.com/t/calendar-object-multi-day-selection/39736)
**Author:** [@curtduquette](https://forum.inductiveautomation.com/u/curtduquette)\ **Replies:** 0\ **Last updated:** [October 15, 2020, 11:58pm UTC](https://forum.inductiveautomation.com/t/calendar-object-multi-day-selection/39736 "2020-10-15T23:58:35Z")
I am trying to find a way to add a calendar event to multiple days, weeks, or even months based on user day selection. Is there a way to select multiple days, highlight those days on the graphic (month or week view), an… --- ## [System.tag.browse ignores filter parameter when the path is an AtomicTag?](https://forum.inductiveautomation.com/t/system-tag-browse-ignores-filter-parameter-when-the-path-is-an-atomictag/39735)
**Author:** [@bradley.falzon](https://forum.inductiveautomation.com/u/bradley.falzon)\ **Replies:** 0\ **Last updated:** [October 15, 2020, 11:30pm UTC](https://forum.inductiveautomation.com/t/system-tag-browse-ignores-filter-parameter-when-the-path-is-an-atomictag/39735 "2020-10-15T23:30:02Z")
I’m trying to use system.tag.browse function to recursively move up a folder structure until a certain UDT instance is found. The function accepts a tagPath and returns the instance or None. It does this recursively, se… --- ## [Problem launching Ignition from docker](https://forum.inductiveautomation.com/t/problem-launching-ignition-from-docker/39727)
**Author:** [@dpascucci](https://forum.inductiveautomation.com/u/dpascucci)\ **Replies:** 6\ **Last updated:** [October 15, 2020, 11:09pm UTC](https://forum.inductiveautomation.com/t/problem-launching-ignition-from-docker/39727 "2020-10-15T23:09:21Z")
Hello everyone, I’m trying to run an ignition instance from docker, but I set the default port 8088 and I have another instance of ignition running in the local OS. I tried to change the port but I can’t load the gatew… --- ## [Accessing com.inductiveautomation.ignition packages in Python](https://forum.inductiveautomation.com/t/accessing-com-inductiveautomation-ignition-packages-in-python/39702)
**Author:** [@bradley.falzon](https://forum.inductiveautomation.com/u/bradley.falzon)\ **Replies:** 3\ **Last updated:** [October 15, 2020, 10:16pm UTC](https://forum.inductiveautomation.com/t/accessing-com-inductiveautomation-ignition-packages-in-python/39702 "2020-10-15T22:16:43Z")
Hi, I’d like to use some of the helper functions scattered throughout com.inductiveautomation.ignition from within Python. In this specific case com.inductiveautomation.ignition.common has QualifiedPathUtils and I’d lov… --- ## [Tag Group Configuration - Write Only Tags](https://forum.inductiveautomation.com/t/tag-group-configuration-write-only-tags/39734)
**Author:** [@plarochelle](https://forum.inductiveautomation.com/u/plarochelle)\ **Replies:** 2\ **Last updated:** [October 15, 2020, 9:33pm UTC](https://forum.inductiveautomation.com/t/tag-group-configuration-write-only-tags/39734 "2020-10-15T21:33:06Z")
Hi All, We’re working on an Ignition 8 project with a large number of tags and trying to configure tag groups in the most performant way possible. We have ~25,000 tags which are for lack of a better term ‘write only’. … --- ## [Import Tags csv/xml/json in a custom OPC-UA like module](https://forum.inductiveautomation.com/t/import-tags-csv-xml-json-in-a-custom-opc-ua-like-module/39680)
**Author:** [@pabaribrinda](https://forum.inductiveautomation.com/u/pabaribrinda)\ **Replies:** 10\ **Last updated:** [October 15, 2020, 8:22pm UTC](https://forum.inductiveautomation.com/t/import-tags-csv-xml-json-in-a-custom-opc-ua-like-module/39680 "2020-10-15T20:22:38Z")
I want to be able to import tags, not from the designer, but when a new device is created. Device belongs to a custom module, an extension to opc-ua sdk example. Can you guide me to a direction that I should explore? I w… --- ## [Force a chart to show null data](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728)
**Author:** [@leversole](https://forum.inductiveautomation.com/u/leversole)\ **Replies:** 3\ **Last updated:** [October 15, 2020, 8:14pm UTC](https://forum.inductiveautomation.com/t/force-a-chart-to-show-null-data/39728 "2020-10-15T20:14:43Z")
I have tried everything I know to get the nulls out of a summary pivot query, not having any luck, what I want is the chart to show the date (with no data) in the proper sequence with dates that have data. Here is an ex… --- ## [Transferring certification to a new employer](https://forum.inductiveautomation.com/t/transferring-certification-to-a-new-employer/39729)
**Author:** [@RichardPriest](https://forum.inductiveautomation.com/u/RichardPriest)\ **Replies:** 2\ **Last updated:** [October 15, 2020, 7:41pm UTC](https://forum.inductiveautomation.com/t/transferring-certification-to-a-new-employer/39729 "2020-10-15T19:41:12Z")
Currently I’m Gold Certified under the name of my previous employer who released me when I was working on the exam. The company shows as a Gold integrator, presumably only because of my passing of the exam. What is the … --- ## [Ignition 8 Perspective Help](https://forum.inductiveautomation.com/t/ignition-8-perspective-help/39660)
**Author:** [@delbert\_edric](https://forum.inductiveautomation.com/u/delbert_edric)\ **Replies:** 7\ **Last updated:** [October 15, 2020, 6:38pm UTC](https://forum.inductiveautomation.com/t/ignition-8-perspective-help/39660 "2020-10-15T18:38:25Z")
Hey Guys, I was wondering if anyone can tell me the Python script that can allow me to get a component from a different view in perspective. I am still trying to figure this one out myself by reading ignition 8’s manual… --- ## [Tag quality via SparkPlug](https://forum.inductiveautomation.com/t/tag-quality-via-sparkplug/34456)
**Author:** [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Replies:** 1\ **Last updated:** [October 15, 2020, 6:28pm UTC](https://forum.inductiveautomation.com/t/tag-quality-via-sparkplug/34456 "2020-10-15T18:28:47Z")
Our company is implementing an embedded device which generates SparkPlug MQTT traffic directly, and we cannot use Ignition Edge or the Cirrus Link MQTT Transmission module. We have come across use cases where we would l… --- ## [Tab Strip Scripting and Binding](https://forum.inductiveautomation.com/t/tab-strip-scripting-and-binding/39600)
**Author:** [@steven.cox](https://forum.inductiveautomation.com/u/steven.cox)\ **Replies:** 19\ **Last updated:** [October 15, 2020, 6:01pm UTC](https://forum.inductiveautomation.com/t/tab-strip-scripting-and-binding/39600 "2020-10-15T18:01:15Z")
Hi all, I am new to Ignition and scripting (and everything else). I am adding a Tab Strip to the project I am using to learn. I have the Tab Strip bound to a Named Query that returns 2 columns. An id and a name. Bas… --- ## [Is there a way to have 2 components side by side in Perspective](https://forum.inductiveautomation.com/t/is-there-a-way-to-have-2-components-side-by-side-in-perspective/39687)
**Author:** [@codersmurf](https://forum.inductiveautomation.com/u/codersmurf)\ **Replies:** 5\ **Last updated:** [October 15, 2020, 4:58pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-have-2-components-side-by-side-in-perspective/39687 "2020-10-15T16:58:37Z")
So I have some text and the value beside it, the flex container Doesn’t seem to allow me to this.Thx, Jake --- ## [Roster Management and system.roster scripting](https://forum.inductiveautomation.com/t/roster-management-and-system-roster-scripting/39698)
**Author:** [@WKetcham](https://forum.inductiveautomation.com/u/WKetcham)\ **Replies:** 5\ **Last updated:** [October 15, 2020, 4:40pm UTC](https://forum.inductiveautomation.com/t/roster-management-and-system-roster-scripting/39698 "2020-10-15T16:40:38Z")
Just upgraded an gateway to 8.0.15 a few weeks ago and we just noticed that the Roster Management component no longer has the ability to remove a user from a roster group????? I didn't really like the built-in Roster Ma… --- ## [8.1.0-RC3 log flooded with tags.history.annotation.query.DB Errors](https://forum.inductiveautomation.com/t/8-1-0-rc3-log-flooded-with-tags-history-annotation-query-db-errors/39723)
**Author:** [@mitchell-ACS](https://forum.inductiveautomation.com/u/mitchell-ACS)\ **Replies:** 0\ **Last updated:** [October 15, 2020, 4:02pm UTC](https://forum.inductiveautomation.com/t/8-1-0-rc3-log-flooded-with-tags-history-annotation-query-db-errors/39723 "2020-10-15T16:02:39Z")
Since updating to RC3 I've been getting lots of these mqtt engine Error executing annotation query. errors, seems to correspond with the refresh rate on my power chart. org.postgresql.util.PSQLException: ERROR: rela… --- ## [Flex repeater dynamic rearrange transform](https://forum.inductiveautomation.com/t/flex-repeater-dynamic-rearrange-transform/36877)
**Author:** [@ijustdunnoaname1](https://forum.inductiveautomation.com/u/ijustdunnoaname1)\ **Replies:** 0\ **Last updated:** [July 20, 2020, 7:33pm UTC](https://forum.inductiveautomation.com/t/flex-repeater-dynamic-rearrange-transform/36877 "2020-07-20T19:33:36Z")
I have a SQL query returning a list of machines. Within that list, I’m trying to change the order of how they’re displayed on a Flex repeater based on whether the machine is running or stopped. I’m able to get the flex … --- ## [Role-based security with remote Edge gateways](https://forum.inductiveautomation.com/t/role-based-security-with-remote-edge-gateways/39718)
**Author:** [@RichardPriest](https://forum.inductiveautomation.com/u/RichardPriest)\ **Replies:** 0\ **Last updated:** [October 15, 2020, 2:42pm UTC](https://forum.inductiveautomation.com/t/role-based-security-with-remote-edge-gateways/39718 "2020-10-15T14:42:37Z")
I’m setting up a test platform with an Azure cloud gateway and remote tag providers from 3 Edge gateways running on physical machines at my location. Perspective sessions on the cloud gateway will be the only client type… --- ## [\[FEATURE-822\] Gateway webpage Devices status missing device name](https://forum.inductiveautomation.com/t/feature-822-gateway-webpage-devices-status-missing-device-name/37576)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [October 15, 2020, 1:30pm UTC](https://forum.inductiveautomation.com/t/feature-822-gateway-webpage-devices-status-missing-device-name/37576 "2020-10-15T13:30:40Z")
v8.0.15 Which device status am I looking at? :slight\_smile: --- ## [How to move windows from vision to perspective](https://forum.inductiveautomation.com/t/how-to-move-windows-from-vision-to-perspective/39713)
**Author:** [@berkay.cinar](https://forum.inductiveautomation.com/u/berkay.cinar)\ **Replies:** 1\ **Last updated:** [October 15, 2020, 1:22pm UTC](https://forum.inductiveautomation.com/t/how-to-move-windows-from-vision-to-perspective/39713 "2020-10-15T13:22:47Z")
Hello, I am very new to ignition. My windows are created under vision in project browser. But we dont have license for vision we have license for perspective. Can I move my windows into perspective? Can I see my project… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1279) [Next page](https://forum.inductiveautomation.com/latest.md?page=1281)