# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=542 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 543 --- ## [Xy chart : bar chart time display](https://forum.inductiveautomation.com/t/xy-chart-bar-chart-time-display/81372)
**Author:** [@JinGeun\_Kim](https://forum.inductiveautomation.com/u/JinGeun_Kim)\ **Replies:** 3\ **Last updated:** [November 3, 2023, 6:30am UTC](https://forum.inductiveautomation.com/t/xy-chart-bar-chart-time-display/81372 "2023-11-03T06:30:11Z")
Hello! In the photo, the data inside the blue pen is '2023-11-02 18', but on the chart it appears as '11/02 17'. Why is this like this? The same goes for the red pen. please help me! --- ## [Pip install openpyxl - error](https://forum.inductiveautomation.com/t/pip-install-openpyxl-error/81348)
**Author:** [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\ **Replies:** 15\ **Last updated:** [November 3, 2023, 5:22am UTC](https://forum.inductiveautomation.com/t/pip-install-openpyxl-error/81348 "2023-11-03T05:22:18Z")
How to install openpyxl in ignition? i can't able install can any one help me out --- ## [Client Tag Values Change in Developer Affecting Clients](https://forum.inductiveautomation.com/t/client-tag-values-change-in-developer-affecting-clients/81434)
**Author:** [@BillS](https://forum.inductiveautomation.com/u/BillS)\ **Replies:** 1\ **Last updated:** [November 3, 2023, 12:17am UTC](https://forum.inductiveautomation.com/t/client-tag-values-change-in-developer-affecting-clients/81434 "2023-11-03T00:17:51Z")
Hello, I was under the impression that since 7.1.6? or thereabouts changes had been made so that the VALUES set in the development environment to vision client tags did not get sent out to the vision clients when saving… --- ## [Tag import error using csv file](https://forum.inductiveautomation.com/t/tag-import-error-using-csv-file/80143)
**Author:** [@Abhilash\_Bhattachary](https://forum.inductiveautomation.com/u/Abhilash_Bhattachary)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 11:13pm UTC](https://forum.inductiveautomation.com/t/tag-import-error-using-csv-file/80143 "2023-11-02T23:13:56Z")
I am trying to import tags on ignition using csv file for the first time and I am facing an error which I am not able to eliminate. I am a novice at using iginition and learning. This is the error I get: Tag errors occ… --- ## [Error : Unable to get the view config: View config is undefined](https://forum.inductiveautomation.com/t/error-unable-to-get-the-view-config-view-config-is-undefined/80067)
**Author:** [@SHIJI\_SASI](https://forum.inductiveautomation.com/u/SHIJI_SASI)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 10:44pm UTC](https://forum.inductiveautomation.com/t/error-unable-to-get-the-view-config-view-config-is-undefined/80067 "2023-11-02T22:44:51Z")
Hi, I am using Version: 8.1.32 restored the .gwbk File. I Can't open any view. Getting error like "ExecutionException: java.lang.Exception: Unable to get the view config: View config is undefined. caused by Exception: … --- ## [8.1 Redundancy with Kepware OPC](https://forum.inductiveautomation.com/t/8-1-redundancy-with-kepware-opc/81331)
**Author:** [@nagas](https://forum.inductiveautomation.com/u/nagas)\ **Replies:** 3\ **Last updated:** [November 2, 2023, 9:56pm UTC](https://forum.inductiveautomation.com/t/8-1-redundancy-with-kepware-opc/81331 "2023-11-02T21:56:21Z")
A customer has a redundant 8.1 system that we are discussing redoing the OPC systems. They are using KepDirect (retired) for their many AutomationDirect controllers and KepServerEx for their many Siemens/TI 505 controll… --- ## [Dataset Property Written by Script not Updating](https://forum.inductiveautomation.com/t/dataset-property-written-by-script-not-updating/81411)
**Author:** [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Replies:** 12\ **Last updated:** [November 2, 2023, 9:33pm UTC](https://forum.inductiveautomation.com/t/dataset-property-written-by-script-not-updating/81411 "2023-11-02T21:33:57Z")
I have this script that takes in a dataset (of tag pens from an easy chart) and replaces the storage provider portion of the path and places the resulting dataset in a different dataset property. It seems like the scrip… --- ## [How calculate integral of history tag](https://forum.inductiveautomation.com/t/how-calculate-integral-of-history-tag/27741)
**Author:** [@chris.roys](https://forum.inductiveautomation.com/u/chris.roys)\ **Replies:** 8\ **Last updated:** [November 2, 2023, 9:22pm UTC](https://forum.inductiveautomation.com/t/how-calculate-integral-of-history-tag/27741 "2023-11-02T21:22:02Z")
Hello I want to have integral of a history tag in selected range. The history only log data when I have change in value so multiply it by time not valid option here. appreciate for any idea. --- ## [Trouble with httpClient .getAsync Callbacks](https://forum.inductiveautomation.com/t/trouble-with-httpclient-getasync-callbacks/81306)
**Author:** [@Cole\_Townsend](https://forum.inductiveautomation.com/u/Cole_Townsend)\ **Replies:** 25\ **Last updated:** [November 2, 2023, 9:14pm UTC](https://forum.inductiveautomation.com/t/trouble-with-httpclient-getasync-callbacks/81306 "2023-11-02T21:14:56Z")
Hey guys, I am trying to set up some asynchronous API calls on my gateway but I am having trouble getting my callback function to run properly. I have tried a few different things, but have been coming up short. I am … --- ## [Report Error! Need Help!](https://forum.inductiveautomation.com/t/report-error-need-help/81412)
**Author:** [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\ **Replies:** 0\ **Last updated:** [November 2, 2023, 8:34pm UTC](https://forum.inductiveautomation.com/t/report-error-need-help/81412 "2023-11-02T20:34:59Z")
Hi there, I am getting below results on a column for Null values. com.inductiveautomation.reporting.common.api.query results$Row what can be the cause? Thanks --- ## [Formatting Issue with Report using Excel](https://forum.inductiveautomation.com/t/formatting-issue-with-report-using-excel/81408)
**Author:** [@Carson\_Hunter](https://forum.inductiveautomation.com/u/Carson_Hunter)\ **Replies:** 0\ **Last updated:** [November 2, 2023, 6:51pm UTC](https://forum.inductiveautomation.com/t/formatting-issue-with-report-using-excel/81408 "2023-11-02T18:51:58Z")
Thanks to prior comments I was able to build a functional report that was exactly as requested. There is a possibility though that the report will be needed in excel instead of pdf as it is right now. Currently this is … --- ## [SQL Pivot and Unpivot help](https://forum.inductiveautomation.com/t/sql-pivot-and-unpivot-help/67693)
**Author:** [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Replies:** 28\ **Last updated:** [November 2, 2023, 6:53pm UTC](https://forum.inductiveautomation.com/t/sql-pivot-and-unpivot-help/67693 "2023-11-02T18:53:24Z")
I have spent hours on even this one SQL pivot. I would like to master SQL pivots or at least get much better with them. I got one unpivot to work here a while back: I have right now, this super fast query. Column o… --- ## [Nanodac Modbus TCP help needed](https://forum.inductiveautomation.com/t/nanodac-modbus-tcp-help-needed/62078)
**Author:** [@Off\_In\_The\_Woods](https://forum.inductiveautomation.com/u/Off_In_The_Woods)\ **Replies:** 8\ **Last updated:** [November 2, 2023, 6:48pm UTC](https://forum.inductiveautomation.com/t/nanodac-modbus-tcp-help-needed/62078 "2023-11-02T18:48:05Z")
Hi all, We have a Nanodac datalogger we’re trying to get connected via Modbus TCP to our gateway. Currently I have the Modbus TCP driver configured, and the driver is happy and connected to the gateway. I’ve tried add… --- ## [NamedQuery to return PK value after inserting row](https://forum.inductiveautomation.com/t/namedquery-to-return-pk-value-after-inserting-row/81405)
**Author:** [@jbb5310](https://forum.inductiveautomation.com/u/jbb5310)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 6:28pm UTC](https://forum.inductiveautomation.com/t/namedquery-to-return-pk-value-after-inserting-row/81405 "2023-11-02T18:28:58Z")
Can I have a named query that inserts a row and returns the primary key created? I --- ## [Trouble with Office 365 SMTP](https://forum.inductiveautomation.com/t/trouble-with-office-365-smtp/81404)
**Author:** [@Ryan\_Corey](https://forum.inductiveautomation.com/u/Ryan_Corey)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 6:00pm UTC](https://forum.inductiveautomation.com/t/trouble-with-office-365-smtp/81404 "2023-11-02T18:00:37Z")
I have a client who was originally using Office 365 SMTP settings for their alarm notifications. They were using the smtp.office365.com hostname. As of last week, these stopped working and the following error was in the … --- ## [\[IGN-6631\] noInterpolation not working on system.tag.queryTagHistory through Gateway Network](https://forum.inductiveautomation.com/t/ign-6631-nointerpolation-not-working-on-system-tag-querytaghistory-through-gateway-network/68889)
**Author:** [@drojas](https://forum.inductiveautomation.com/u/drojas)\ **Replies:** 6\ **Last updated:** [November 2, 2023, 5:59pm UTC](https://forum.inductiveautomation.com/t/ign-6631-nointerpolation-not-working-on-system-tag-querytaghistory-through-gateway-network/68889 "2023-11-02T17:59:14Z")
I have 2 gateways (local site pc and remote centralized server) and are connected to each other via the Gateway Network. I created a Remote Tag Provider and Remote History Provider on the central server. Both are query… --- ## [TCP Communication Loss - Barcode Scanning](https://forum.inductiveautomation.com/t/tcp-communication-loss-barcode-scanning/81259)
**Author:** [@Thomas\_Magill](https://forum.inductiveautomation.com/u/Thomas_Magill)\ **Replies:** 6\ **Last updated:** [November 2, 2023, 5:58pm UTC](https://forum.inductiveautomation.com/t/tcp-communication-loss-barcode-scanning/81259 "2023-11-02T17:58:04Z")
We have integrated Zebra FS20 barcode scanners into Ignition through TCP protocol, but are experiencing occasional loss of data on the order of 1 per 3000 messages. I am able to confirm 100% reads from the scanner, so le… --- ## [Login Authentication Restrictions To Components](https://forum.inductiveautomation.com/t/login-authentication-restrictions-to-components/81387)
**Author:** [@dcan87](https://forum.inductiveautomation.com/u/dcan87)\ **Replies:** 6\ **Last updated:** [November 2, 2023, 5:54pm UTC](https://forum.inductiveautomation.com/t/login-authentication-restrictions-to-components/81387 "2023-11-02T17:54:53Z")
I have a pop-up that is triggered on double click of subview in a table, with drop-down components that write to memory tags when changed. I would like the ability to change those controlled through login authentication. … --- ## [Query binding giving "Syntax Error on Token: 'End of Expression'" error, but works when testing the Named Query](https://forum.inductiveautomation.com/t/query-binding-giving-syntax-error-on-token-end-of-expression-error-but-works-when-testing-the-named-query/25832)
**Author:** [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\ **Replies:** 7\ **Last updated:** [November 2, 2023, 5:09pm UTC](https://forum.inductiveautomation.com/t/query-binding-giving-syntax-error-on-token-end-of-expression-error-but-works-when-testing-the-named-query/25832 "2023-11-02T17:09:10Z")
For easier reading, here’s the query: DECLARE @downtimeDivisor AS INT = 1 IF :downtimeFormat = 'hour' OR :downtimeFormat = 'hours' SET @downtimeDivisor = 3600; ELSE IF :downtimeFormat = 'minute' OR :downtimeFormat … --- ## [Script cross reference](https://forum.inductiveautomation.com/t/script-cross-reference/51224)
**Author:** [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\ **Replies:** 3\ **Last updated:** [November 2, 2023, 4:37pm UTC](https://forum.inductiveautomation.com/t/script-cross-reference/51224 "2023-11-02T16:37:42Z")
I have recently inherited a project that has a fair amount of scripting, and I am being tasked with extending the project to account for additional equipment that fits the pattern of existing equipment. In reviewing the… --- ## [Resize view as per device resolution](https://forum.inductiveautomation.com/t/resize-view-as-per-device-resolution/81371)
**Author:** [@Shubham\_Nikate](https://forum.inductiveautomation.com/u/Shubham_Nikate)\ **Replies:** 2\ **Last updated:** [November 2, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/resize-view-as-per-device-resolution/81371 "2023-11-02T16:18:07Z")
I created Project in perspective and now I'm facing the problem of resizing when i open my project in perspective workstation. I want that in every screen where i open my project the popup view will cover the whole empty… --- ## [Automatic login](https://forum.inductiveautomation.com/t/automatic-login/81382)
**Author:** [@Francesco\_Vittadini](https://forum.inductiveautomation.com/u/Francesco_Vittadini)\ **Replies:** 4\ **Last updated:** [November 2, 2023, 4:13pm UTC](https://forum.inductiveautomation.com/t/automatic-login/81382 "2023-11-02T16:13:45Z")
Hello I've found this article for nightly 8.1 and automatic login but I'm not able to find the place where I have to flag This is a screenshot of my Ignition version and an image of my General project option … --- ## [Mouseover text for touchscreen applications?](https://forum.inductiveautomation.com/t/mouseover-text-for-touchscreen-applications/81393)
**Author:** [@Derek\_Lyons](https://forum.inductiveautomation.com/u/Derek_Lyons)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 3:56pm UTC](https://forum.inductiveautomation.com/t/mouseover-text-for-touchscreen-applications/81393 "2023-11-02T15:56:21Z")
Good day all, I'm quite new to Ignition and have been playing around with Vision while I am waiting for official training next month. One of the features I like a lot is the mouseover text option in the property editor… --- ## [Enable CORS- use web dev API for reactjs](https://forum.inductiveautomation.com/t/enable-cors-use-web-dev-api-for-reactjs/53402)
**Author:** [@Ricardo\_Sanchez](https://forum.inductiveautomation.com/u/Ricardo_Sanchez)\ **Replies:** 10\ **Last updated:** [November 2, 2023, 3:50pm UTC](https://forum.inductiveautomation.com/t/enable-cors-use-web-dev-api-for-reactjs/53402 "2023-11-02T15:50:32Z")
I have a question about the consumption of information with API. generate an API in web dev at the time of testing in postman everything is fine but when consuming it in react it throws me the following error: Access … --- ## [Using runScript](https://forum.inductiveautomation.com/t/using-runscript/81391)
**Author:** [@Why\_Me](https://forum.inductiveautomation.com/u/Why_Me)\ **Replies:** 1\ **Last updated:** [November 2, 2023, 3:44pm UTC](https://forum.inductiveautomation.com/t/using-runscript/81391 "2023-11-02T15:44:36Z")
How do i format this to get the int output? toInt(runScript("len(system.alarm.queryStatus(state='AlarmAcked')")) --- ## [Allen Bradley timeout](https://forum.inductiveautomation.com/t/allen-bradley-timeout/81383)
**Author:** [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\ **Replies:** 6\ **Last updated:** [November 2, 2023, 2:17pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-timeout/81383 "2023-11-02T14:17:19Z")
I have a DH+ network with AllenBradley , I am using an AllenBradley gateway to read the DH+ plcs throught ethernet, but I have many timeout errors in IGNITION from those PLCs, any idea? thanks --- ## [Language Translation in Perspective - translating sentences with dynamic labels/texts](https://forum.inductiveautomation.com/t/language-translation-in-perspective-translating-sentences-with-dynamic-labels-texts/72855)
**Author:** [@Rohit\_Das](https://forum.inductiveautomation.com/u/Rohit_Das)\ **Replies:** 13\ **Last updated:** [November 2, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/language-translation-in-perspective-translating-sentences-with-dynamic-labels-texts/72855 "2023-11-02T12:47:33Z")
Hi, I'm trying to translate my perspective project from English to Spanish and I'm kind of stuck on how to translate some sentences with dynamic texts/popup labels. For eg : "Do you want to move the \[item\] from \[HELD\] … --- ## [CRC "Cyclic Redundancy Check"](https://forum.inductiveautomation.com/t/crc-cyclic-redundancy-check/78902)
**Author:** [@Hamza\_DAZARA](https://forum.inductiveautomation.com/u/Hamza_DAZARA)\ **Replies:** 10\ **Last updated:** [November 2, 2023, 12:37pm UTC](https://forum.inductiveautomation.com/t/crc-cyclic-redundancy-check/78902 "2023-11-02T12:37:10Z")
Is it possible to generate a CRC (cyclic redundancy check) in ignition ? --- ## [Question regarding Ignition Gateway and MySQL connection](https://forum.inductiveautomation.com/t/question-regarding-ignition-gateway-and-mysql-connection/81339)
**Author:** [@Anthony\_Buddini](https://forum.inductiveautomation.com/u/Anthony_Buddini)\ **Replies:** 11\ **Last updated:** [November 2, 2023, 12:33pm UTC](https://forum.inductiveautomation.com/t/question-regarding-ignition-gateway-and-mysql-connection/81339 "2023-11-02T12:33:36Z")
Hi, I'm having issues with the connection between Ignition Gateway and MySQL server 8.0. I'm using Ignition Perspective and I've got the Gateway running on one VM whereas the MySQL server runs on another VM. The Error … --- ## [Handling Modbus Unsigned DINTs (UDINT)](https://forum.inductiveautomation.com/t/handling-modbus-unsigned-dints-udint/81341)
**Author:** [@Sam\_Oostendorp](https://forum.inductiveautomation.com/u/Sam_Oostendorp)\ **Replies:** 3\ **Last updated:** [November 2, 2023, 12:15pm UTC](https://forum.inductiveautomation.com/t/handling-modbus-unsigned-dints-udint/81341 "2023-11-02T12:15:26Z")
I am trying to write to a modbus tag of type UDINT from Ignition. For example this tag is in HR1714-HR1715 (MW1714, unsigned DINT). Because this is of type unsigned but ignition integers are signed it is writing to the w… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=541) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=543)