# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1310 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1311 --- ## [Modbus TCP Tag Error : Null Value](https://forum.inductiveautomation.com/t/modbus-tcp-tag-error-null-value/37912)
**Author:** [@rochd.abdelilah](https://forum.inductiveautomation.com/u/rochd.abdelilah)\ **Replies:** 6\ **Last updated:** [August 19, 2020, 3:39pm UTC](https://forum.inductiveautomation.com/t/modbus-tcp-tag-error-null-value/37912 "2020-08-19T15:39:31Z")
Hello everyone, I hope this will find you well! I’m trying to connect to a Modbus TCP enabled battery to retrieve data from it. I checked first the good connection through the tool “Simply Modbus”. As it can be noticed… --- ## [Inserting table Data into database](https://forum.inductiveautomation.com/t/inserting-table-data-into-database/37603)
**Author:** [@rajeshbabu](https://forum.inductiveautomation.com/u/rajeshbabu)\ **Replies:** 4\ **Last updated:** [August 19, 2020, 3:29pm UTC](https://forum.inductiveautomation.com/t/inserting-table-data-into-database/37603 "2020-08-19T15:29:36Z")
In perspective we tried below code to fetch the value from table dynamically getting updated and insert these values into the table in database. But it fetches only the last row of the table and enter that value in the… --- ## [T\_stamp 1 hour different issue](https://forum.inductiveautomation.com/t/t-stamp-1-hour-different-issue/37909)
**Author:** [@pawel.kondol1](https://forum.inductiveautomation.com/u/pawel.kondol1)\ **Replies:** 0\ **Last updated:** [August 19, 2020, 1:34pm UTC](https://forum.inductiveautomation.com/t/t-stamp-1-hour-different-issue/37909 "2020-08-19T13:34:01Z")
Hello, I have problem with date. I have simple script: import datetime t\_stamp = datetime.datetime.now() print (t\_stamp) # Run a query that will update the values of the row matching the id. query = "INSERT INTO \[I… --- ## [Ignition 8 SDK - how to add MDC key session-id for perspective](https://forum.inductiveautomation.com/t/ignition-8-sdk-how-to-add-mdc-key-session-id-for-perspective/37902)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [August 19, 2020, 12:58pm UTC](https://forum.inductiveautomation.com/t/ignition-8-sdk-how-to-add-mdc-key-session-id-for-perspective/37902 "2020-08-19T12:58:29Z")
In gateway logs there is a MDC key session-id with a “short” id In a module which depends from perspective I would like to known how to add this mdc to the logger or if there is a specific logger class to use Is it pos… --- ## [Perspective File Upload cvs files](https://forum.inductiveautomation.com/t/perspective-file-upload-cvs-files/37884)
**Author:** [@jmorris](https://forum.inductiveautomation.com/u/jmorris)\ **Replies:** 1\ **Last updated:** [August 19, 2020, 12:34pm UTC](https://forum.inductiveautomation.com/t/perspective-file-upload-cvs-files/37884 "2020-08-19T12:34:46Z")
Hi, Which is the best way to import a csv file into Perspective? Using the File Upload object we can get the file Bytes, but how can we convert the Bytes back to a Column/Row kind of structure? We also try to use pyth… --- ## [Diagnostics Logs - OPC UA Error](https://forum.inductiveautomation.com/t/diagnostics-logs-opc-ua-error/37887)
**Author:** [@JessicaG](https://forum.inductiveautomation.com/u/JessicaG)\ **Replies:** 1\ **Last updated:** [August 19, 2020, 12:04pm UTC](https://forum.inductiveautomation.com/t/diagnostics-logs-opc-ua-error/37887 "2020-08-19T12:04:17Z")
I am having the following error in the Diagnostics Logs, did not have the problem when i was working in windows, when i changed to ubuntu it came out: at com.inductiveautomation.ignition.gateway.opcua.server.DeviceManag… --- ## [Named query parameters](https://forum.inductiveautomation.com/t/named-query-parameters/23079)
**Author:** [@WChester](https://forum.inductiveautomation.com/u/WChester)\ **Replies:** 8\ **Last updated:** [August 19, 2020, 11:56am UTC](https://forum.inductiveautomation.com/t/named-query-parameters/23079 "2020-08-19T11:56:57Z")
I created 4 named queries that used 4 columns(see picture) The only difference between the queries was that I changed the selected column. I then created 4 text field and list box combinations with 4 custom paramete… --- ## [How to query data from two database (PeopleSoft and Microsoft SQL) into one power table](https://forum.inductiveautomation.com/t/how-to-query-data-from-two-database-peoplesoft-and-microsoft-sql-into-one-power-table/25974)
**Author:** [@jdenchev](https://forum.inductiveautomation.com/u/jdenchev)\ **Replies:** 19\ **Last updated:** [August 19, 2020, 11:42am UTC](https://forum.inductiveautomation.com/t/how-to-query-data-from-two-database-peoplesoft-and-microsoft-sql-into-one-power-table/25974 "2020-08-19T11:42:49Z")
How to query data from two database (PeopleSoft and Microsoft SQL) into one power table --- ## [Perspective version of layout](https://forum.inductiveautomation.com/t/perspective-version-of-layout/37898)
**Author:** [@Yfactor](https://forum.inductiveautomation.com/u/Yfactor)\ **Replies:** 2\ **Last updated:** [August 19, 2020, 10:01am UTC](https://forum.inductiveautomation.com/t/perspective-version-of-layout/37898 "2020-08-19T10:01:39Z")
Hi there, I just started using Perspective and I created a header using coordinate component and added a label in there. I placed it in the center but when I launch the label is not in the center… How can I have the lab… --- ## [Query stops updating](https://forum.inductiveautomation.com/t/query-stops-updating/37843)
**Author:** [@Toobor](https://forum.inductiveautomation.com/u/Toobor)\ **Replies:** 2\ **Last updated:** [August 19, 2020, 9:27am UTC](https://forum.inductiveautomation.com/t/query-stops-updating/37843 "2020-08-19T09:27:57Z")
Hi, I have a XY Chart and a table. Both objects have the same query-binding as dataSource. Both queries have a polling rate of 20 sec. The problem is that the queries stops updating after a while. I verified this by ad… --- ## [Upgrade redundant pair memory tag issue](https://forum.inductiveautomation.com/t/upgrade-redundant-pair-memory-tag-issue/35646)
**Author:** [@erik.forsgren](https://forum.inductiveautomation.com/u/erik.forsgren)\ **Replies:** 3\ **Last updated:** [August 19, 2020, 9:23am UTC](https://forum.inductiveautomation.com/t/upgrade-redundant-pair-memory-tag-issue/35646 "2020-08-19T09:23:37Z")
I have problem when upgrading our redundant gateways. I lose the information in memory tags. I created a simple client that shows values of different datatypes during upgrade of a gateway pair. The buttons are just a la… --- ## [Exchange error when trying to import](https://forum.inductiveautomation.com/t/exchange-error-when-trying-to-import/33846)
**Author:** [@ecallaghan](https://forum.inductiveautomation.com/u/ecallaghan)\ **Replies:** 3\ **Last updated:** [August 19, 2020, 7:33am UTC](https://forum.inductiveautomation.com/t/exchange-error-when-trying-to-import/33846 "2020-08-19T07:33:25Z")
Hello. I’ve tried (not all at once) importing all of the Exchange .zip files marked Beginner and get an error every time I try. You can see this error, I’ve attached a screen shot. Is there something I’m doing wrong? t… --- ## [\[feature-47\]Keyboard shortcut to switch between opened windows in designer](https://forum.inductiveautomation.com/t/feature-47-keyboard-shortcut-to-switch-between-opened-windows-in-designer/37759)
**Author:** [@Neo](https://forum.inductiveautomation.com/u/Neo)\ **Replies:** 2\ **Last updated:** [August 19, 2020, 4:06am UTC](https://forum.inductiveautomation.com/t/feature-47-keyboard-shortcut-to-switch-between-opened-windows-in-designer/37759 "2020-08-19T04:06:47Z")
Is there is keyboard shortcut to switch between windows/templates that are open in designer, similar to ctrl+PgUp, ctrl+PgDn in Excel to switch between sheets? Apparently, it works in Scripting section where we can use … --- ## [\[help\] Perspective Timeseries Chart](https://forum.inductiveautomation.com/t/help-perspective-timeseries-chart/37891)
**Author:** [@ctobal.torres](https://forum.inductiveautomation.com/u/ctobal.torres)\ **Replies:** 0\ **Last updated:** [August 19, 2020, 2:07am UTC](https://forum.inductiveautomation.com/t/help-perspective-timeseries-chart/37891 "2020-08-19T02:07:47Z")
Hello everyone A pleasure to meet you and also share knowledge with through this forum. I’m using a free version of ignition before I buy an official version. However, I’m developing something similar to the demo yo… --- ## [onEditCellCommit trigger true and false](https://forum.inductiveautomation.com/t/oneditcellcommit-trigger-true-and-false/37881)
**Author:** [@mbai1](https://forum.inductiveautomation.com/u/mbai1)\ **Replies:** 2\ **Last updated:** [August 19, 2020, 12:39am UTC](https://forum.inductiveautomation.com/t/oneditcellcommit-trigger-true-and-false/37881 "2020-08-19T00:39:55Z")
I am using the onEditCellCommit in table component to trigger a message handler. I knew that I can useif event.column =='delete' : in my script , but if my column in delete is a boolean, how can I call the true and false… --- ## [Raspberry Pi Build Recommendations](https://forum.inductiveautomation.com/t/raspberry-pi-build-recommendations/37882)
**Author:** [@MikeAllgood](https://forum.inductiveautomation.com/u/MikeAllgood)\ **Replies:** 0\ **Last updated:** [August 18, 2020, 8:26pm UTC](https://forum.inductiveautomation.com/t/raspberry-pi-build-recommendations/37882 "2020-08-18T20:26:58Z")
I am working on a personal project using Raspberry Pi’s and Maker Edition. The issue is I am not a RPi person (first time using one), nor am I a Linux person, so I keep running into issues. I’ve found that some of these… --- ## [Sql Server 2019](https://forum.inductiveautomation.com/t/sql-server-2019/37836)
**Author:** [@Marisa](https://forum.inductiveautomation.com/u/Marisa)\ **Replies:** 2\ **Last updated:** [August 18, 2020, 7:22pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019/37836 "2020-08-18T19:22:39Z")
Does anyone know if Ignition is compatitable with SQL Server 2019, the docs list as high as 2017. Thanks Marisa --- ## [Unicode font issues](https://forum.inductiveautomation.com/t/unicode-font-issues/37840)
**Author:** [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\ **Replies:** 4\ **Last updated:** [August 18, 2020, 7:08pm UTC](https://forum.inductiveautomation.com/t/unicode-font-issues/37840 "2020-08-18T19:08:30Z")
In Ignition 7.9, we’re able to render arrows from the unicode characters (0x2190 - 0x2200), and sometimes use those on labels as a clarification for the operators. No matter what font is chosen in 7.9, it will always sh… --- ## [Saving Tag Properties](https://forum.inductiveautomation.com/t/saving-tag-properties/37870)
**Author:** [@DavidB](https://forum.inductiveautomation.com/u/DavidB)\ **Replies:** 0\ **Last updated:** [August 18, 2020, 5:26pm UTC](https://forum.inductiveautomation.com/t/saving-tag-properties/37870 "2020-08-18T17:26:34Z")
I’m very new to Ignition and MQTT so please forgive me if some of my terminologies aren’t quite right. I’ve been able to set up a Node-Red flow that is sending some tags into ignition using the sparkplug\_b format. Along… --- ## [Trying to use Ignition to work with Rockwell’s Studio 5000 Emulate.](https://forum.inductiveautomation.com/t/trying-to-use-ignition-to-work-with-rockwell-s-studio-5000-emulate/37746)
**Author:** [@Mark.Foltarz](https://forum.inductiveautomation.com/u/Mark.Foltarz)\ **Replies:** 34\ **Last updated:** [August 18, 2020, 5:01pm UTC](https://forum.inductiveautomation.com/t/trying-to-use-ignition-to-work-with-rockwell-s-studio-5000-emulate/37746 "2020-08-18T17:01:47Z")
I am trying to use Ignition to work with Rockwell’s Studio 5000 Emulate. I have been able to get Ignition to work with the emulator without signing and encrytption. However, when I try to set up a connection using Bas… --- ## [Bit Toggles on Client Update](https://forum.inductiveautomation.com/t/bit-toggles-on-client-update/37865)
**Author:** [@steven.rehnborg](https://forum.inductiveautomation.com/u/steven.rehnborg)\ **Replies:** 2\ **Last updated:** [August 18, 2020, 5:07pm UTC](https://forum.inductiveautomation.com/t/bit-toggles-on-client-update/37865 "2020-08-18T17:07:03Z")
I am using a tag to monitor the hour of the day for calculations. For example, at 11:53 PM the hour of the day is 23. I run a script when the hour changes to perform some calculations and storage of data. At the end o… --- ## [Tag clash errors](https://forum.inductiveautomation.com/t/tag-clash-errors/37758)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 5\ **Last updated:** [August 18, 2020, 4:45pm UTC](https://forum.inductiveautomation.com/t/tag-clash-errors/37758 "2020-08-18T16:45:20Z")
We had storms roll through here yesterday that dropped our power in various parts of the facility. single-phasing, all phases dropping, coming back, then doing it again. Enough to make life interesting trying to get thin… --- ## [Rewriting Perspective URLs](https://forum.inductiveautomation.com/t/rewriting-perspective-urls/37830)
**Author:** [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\ **Replies:** 6\ **Last updated:** [August 18, 2020, 4:29pm UTC](https://forum.inductiveautomation.com/t/rewriting-perspective-urls/37830 "2020-08-18T16:29:08Z")
--- ## [Use script to add plot to time series chart perspective](https://forum.inductiveautomation.com/t/use-script-to-add-plot-to-time-series-chart-perspective/37867)
**Author:** [@mbai1](https://forum.inductiveautomation.com/u/mbai1)\ **Replies:** 0\ **Last updated:** [August 18, 2020, 4:19pm UTC](https://forum.inductiveautomation.com/t/use-script-to-add-plot-to-time-series-chart-perspective/37867 "2020-08-18T16:19:12Z")
I am currently working on use onEditCellCommit in table.event to create plot into time series chart (with message handler in time series chart). but the code is not working without any errors. I am wondering if i can use… --- ## [\[BUG\] v8.0.15 Unable to switch (open other) projects in Designer](https://forum.inductiveautomation.com/t/bug-v8-0-15-unable-to-switch-open-other-projects-in-designer/37833)
**Author:** [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Replies:** 1\ **Last updated:** [August 18, 2020, 4:13pm UTC](https://forum.inductiveautomation.com/t/bug-v8-0-15-unable-to-switch-open-other-projects-in-designer/37833 "2020-08-18T16:13:40Z")
v8.0.15 I;ve noticed on multiple gateways that i’m unable to open another project from the Designer file menu. When I try, this all I see and I’ve left it for 30mins over lunch before. --- ## [Parse csv File into Database through Perspective](https://forum.inductiveautomation.com/t/parse-csv-file-into-database-through-perspective/37832)
**Author:** [@morgan.mcclean](https://forum.inductiveautomation.com/u/morgan.mcclean)\ **Replies:** 1\ **Last updated:** [August 18, 2020, 4:12pm UTC](https://forum.inductiveautomation.com/t/parse-csv-file-into-database-through-perspective/37832 "2020-08-18T16:12:44Z")
Hi, I was wondering if someone could help me with uploading a csv file to an MSSQL Database through a Perspective Session? I have looked at the File Upload Guide however I am looking to directly put the csv data into co… --- ## [Message handler script with perspective table component property](https://forum.inductiveautomation.com/t/message-handler-script-with-perspective-table-component-property/37816)
**Author:** [@mbai1](https://forum.inductiveautomation.com/u/mbai1)\ **Replies:** 7\ **Last updated:** [August 18, 2020, 3:41pm UTC](https://forum.inductiveautomation.com/t/message-handler-script-with-perspective-table-component-property/37816 "2020-08-18T15:41:29Z")
In my message handler code, I have a script trying to access the selection data in table component in perspective. I am getting error that data is not a attribute: but in the table.props. selection I can see the dat… --- ## [Update report viewer before print out](https://forum.inductiveautomation.com/t/update-report-viewer-before-print-out/37862)
**Author:** [@pawel.kondol1](https://forum.inductiveautomation.com/u/pawel.kondol1)\ **Replies:** 0\ **Last updated:** [August 18, 2020, 3:11pm UTC](https://forum.inductiveautomation.com/t/update-report-viewer-before-print-out/37862 "2020-08-18T15:11:17Z")
Hi, I would like to run this script that will update 3 properties on Report Viewer and then print out the report. However, I am getting print out before the custom properties are updated. Can’t paste script. So pasted… --- ## [Swipe gesture for template repeater, possible?](https://forum.inductiveautomation.com/t/swipe-gesture-for-template-repeater-possible/37802)
**Author:** [@SBL\_MC](https://forum.inductiveautomation.com/u/SBL_MC)\ **Replies:** 4\ **Last updated:** [August 18, 2020, 3:15pm UTC](https://forum.inductiveautomation.com/t/swipe-gesture-for-template-repeater-possible/37802 "2020-08-18T15:15:22Z")
Hi all, Does anyone know if this is possible to create a scroll function for a template repeater? Meaning the scroll gesture should scroll down in the list of repeated templates. --- ## [How to set number format for perspective linear scale](https://forum.inductiveautomation.com/t/how-to-set-number-format-for-perspective-linear-scale/37859)
**Author:** [@dkyerger](https://forum.inductiveautomation.com/u/dkyerger)\ **Replies:** 0\ **Last updated:** [August 18, 2020, 2:18pm UTC](https://forum.inductiveautomation.com/t/how-to-set-number-format-for-perspective-linear-scale/37859 "2020-08-18T14:18:20Z")
I’m using a linear scale in a perspective view. The labels on the scale (not the ones on the indicators) show differing numbers of decimal places depending on value. I see ways to style the labels, but I don’t see a way … [Previous page](https://forum.inductiveautomation.com/latest.md?page=1309) [Next page](https://forum.inductiveautomation.com/latest.md?page=1311)