# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1742 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1743 --- ## [7.7 Crosstab Basics](https://forum.inductiveautomation.com/t/7-7-crosstab-basics/11588)
**Author:** [@EricFrancoeur](https://forum.inductiveautomation.com/u/EricFrancoeur)\ **Replies:** 1\ **Last updated:** [April 27, 2016, 12:57pm UTC](https://forum.inductiveautomation.com/t/7-7-crosstab-basics/11588 "2016-04-27T12:57:07Z")
I know, I know, I didn't have time to upgrade to 7.8 yet... Ok I have a dataset of Logs, Sorted by Diameter Size, Length and Volume in M3: \[attachment=1\]Dataset.jpg\[/attachment\] And I want a Cross tab table showing t… --- ## [Error message when try to save in designer](https://forum.inductiveautomation.com/t/error-message-when-try-to-save-in-designer/11589)
**Author:** [@vanko25](https://forum.inductiveautomation.com/u/vanko25)\ **Replies:** 0\ **Last updated:** [April 27, 2016, 12:49pm UTC](https://forum.inductiveautomation.com/t/error-message-when-try-to-save-in-designer/11589 "2016-04-27T12:49:32Z")
Hi all! I am having error message when try to either save chages to a project or create a new one. The message is a problem with writing to a db. It is like that: GatewayException: Executing INSERT INTO PROJECT\_CHAN… --- ## [Build failed for sdk7.7.8](https://forum.inductiveautomation.com/t/build-failed-for-sdk7-7-8/11579)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 4\ **Last updated:** [April 27, 2016, 10:29am UTC](https://forum.inductiveautomation.com/t/build-failed-for-sdk7-7-8/11579 "2016-04-27T10:29:08Z")
Hi I am trying to compile my module for SDK 7.7.8 on 64 bit version of Ignition 7.7.8. I get following error on build: BUILD FAILED C:\\Ignition-ModuleSDK-7.7.8\\gatewaycomm\\Build\\build.xml:83: java.io.FileNotFoundExcept… --- ## [Differences between OPC server in version 7.7 and 7.8](https://forum.inductiveautomation.com/t/differences-between-opc-server-in-version-7-7-and-7-8/11582)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 3\ **Last updated:** [April 27, 2016, 10:28am UTC](https://forum.inductiveautomation.com/t/differences-between-opc-server-in-version-7-7-and-7-8/11582 "2016-04-27T10:28:10Z")
Hi, I find that the tag path for OPC tags (expose option set to true) in 7.7.8 is for example "ns=2:s=\[System\]Gateway/Redundancy/IsActive" where as in 7.8 it was "ns=2;s=\[System\]Gateway/Redundancy/IsActive" (the : ins… --- ## [Gateway is running in emergency activation mode](https://forum.inductiveautomation.com/t/gateway-is-running-in-emergency-activation-mode/11587)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 1\ **Last updated:** [April 27, 2016, 10:27am UTC](https://forum.inductiveautomation.com/t/gateway-is-running-in-emergency-activation-mode/11587 "2016-04-27T10:27:06Z")
On my newly installed version 7.7.8 and activation of the Developer License key I get a warning "This Gateway is running in emergency activation mode. 7 days, 11 hours, 43 minutes, 27 seconds remaining." What does it me… --- ## [Visibility in Script -\> visible = True but item doesn't show](https://forum.inductiveautomation.com/t/visibility-in-script-visible-true-but-item-doesnt-show/11586)
**Author:** [@ian](https://forum.inductiveautomation.com/u/ian)\ **Replies:** 1\ **Last updated:** [April 27, 2016, 5:06am UTC](https://forum.inductiveautomation.com/t/visibility-in-script-visible-true-but-item-doesnt-show/11586 "2016-04-27T05:06:06Z")
To sum up, my question is this: why the script does not work in the invisibile component's component to make the component visible? Here is the details: I have a Template named AToggleBit with a Multi-State Indicat… --- ## [Ports used by client](https://forum.inductiveautomation.com/t/ports-used-by-client/11585)
**Author:** [@malleblas](https://forum.inductiveautomation.com/u/malleblas)\ **Replies:** 3\ **Last updated:** [April 27, 2016, 2:47am UTC](https://forum.inductiveautomation.com/t/ports-used-by-client/11585 "2016-04-27T02:47:11Z")
Hi, I was wondering what ports are used by the client that connects to the gateway so that we can firewall our system as tight as possible. Regards, Michael --- ## [Treatment of bit(n) type in mysql where n\>1](https://forum.inductiveautomation.com/t/treatment-of-bit-n-type-in-mysql-where-n-1/11584)
**Author:** [@driverk](https://forum.inductiveautomation.com/u/driverk)\ **Replies:** 1\ **Last updated:** [April 26, 2016, 10:37pm UTC](https://forum.inductiveautomation.com/t/treatment-of-bit-n-type-in-mysql-where-n-1/11584 "2016-04-26T22:37:27Z")
We have been qualifying MySQL 5.7 and found that the bit type is handled differently in Ignition for bit(n) where n\>1. We went back and checked MySQL 5.6 and found this also to be the case. Assume a create table statem… --- ## [OPC UA Connection To Top Server Reset](https://forum.inductiveautomation.com/t/opc-ua-connection-to-top-server-reset/11124)
**Author:** [@tjcorbin](https://forum.inductiveautomation.com/u/tjcorbin)\ **Replies:** 4\ **Last updated:** [April 26, 2016, 10:06am UTC](https://forum.inductiveautomation.com/t/opc-ua-connection-to-top-server-reset/11124 "2016-04-26T10:06:46Z")
We have a Gateway with an OPC-UA connection to a Top Server IO Server which generally works fine. However, the Top-Server is polling PLC's over VPN connections to several sites. Periodically (say 7-14 days) for variou… --- ## [Internal Property no longer accessible from script module?](https://forum.inductiveautomation.com/t/internal-property-no-longer-accessible-from-script-module/11578)
**Author:** [@ian](https://forum.inductiveautomation.com/u/ian)\ **Replies:** 1\ **Last updated:** [April 26, 2016, 9:55am UTC](https://forum.inductiveautomation.com/t/internal-property-no-longer-accessible-from-script-module/11578 "2016-04-26T09:55:07Z")
I read this post to help me understand how I can access internal property of a template in one of my GUI components' script. I have two properties in a Template, one is Template property called MyIsInactive and the oth… --- ## [Ignition byte tag config error](https://forum.inductiveautomation.com/t/ignition-byte-tag-config-error/11320)
**Author:** [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\ **Replies:** 14\ **Last updated:** [April 26, 2016, 5:37am UTC](https://forum.inductiveautomation.com/t/ignition-byte-tag-config-error/11320 "2016-04-26T05:37:50Z")
On my latest project with Ignition, I found ‘interesting’… bug? My Ignition v7.8.1 64bit is connected to Siemens S7-414 PLC. I have a bunch of BYTE tags, defined for alarming and statuses. What’s happening is, that som… --- ## [Dynamic displaying of local pictures in a directory](https://forum.inductiveautomation.com/t/dynamic-displaying-of-local-pictures-in-a-directory/11464)
**Author:** [@jwpain](https://forum.inductiveautomation.com/u/jwpain)\ **Replies:** 5\ **Last updated:** [April 26, 2016, 12:13am UTC](https://forum.inductiveautomation.com/t/dynamic-displaying-of-local-pictures-in-a-directory/11464 "2016-04-26T00:13:13Z")
Hi all, Using a template repeater, I am trying to display all pictures in a particular folder. Currently as I have it the template is simply a paintable canvas. On button click, the path to the all .jpg files that I wa… --- ## [Expressions: dateFormat vs dateExtract of 'Day Of Week'](https://forum.inductiveautomation.com/t/expressions-dateformat-vs-dateextract-of-day-of-week/11562)
**Author:** [@jimmylooo](https://forum.inductiveautomation.com/u/jimmylooo)\ **Replies:** 3\ **Last updated:** [April 25, 2016, 8:31pm UTC](https://forum.inductiveautomation.com/t/expressions-dateformat-vs-dateextract-of-day-of-week/11562 "2016-04-25T20:31:39Z")
Not sure this is a bug of not, but it seems buggy to me. When you use: dateFormat(toDate('2016-04-22'),'u') It returns 5 According to Ignition Help Documentation dateFormat returns (1 = Monday, ..., 7 = Sunday) so… --- ## [Error in starting 64 bit version](https://forum.inductiveautomation.com/t/error-in-starting-64-bit-version/11571)
**Author:** [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Replies:** 11\ **Last updated:** [April 25, 2016, 5:37pm UTC](https://forum.inductiveautomation.com/t/error-in-starting-64-bit-version/11571 "2016-04-25T17:37:55Z")
Hi I installed 64bit JDK/JRE and the 64 bit version of Ignition (version 7.6.4) on Windows 10 Laptop. When I run the GCU it gives error : "A service specific error occured: 1. More help is available by typing NET HELPMSG… --- ## [How to serialize a dataset?](https://forum.inductiveautomation.com/t/how-to-serialize-a-dataset/11567)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 2\ **Last updated:** [April 25, 2016, 4:38pm UTC](https://forum.inductiveautomation.com/t/how-to-serialize-a-dataset/11567 "2016-04-25T16:38:46Z")
Is there a slick way to serialize a DataSet for storage in a DB blob or bytea field? I'm trying to provide users the ability to save trend pages by saving the EasyChart ChartConfiguration datasets to the database. Python… --- ## [Sending automatically emails](https://forum.inductiveautomation.com/t/sending-automatically-emails/11555)
**Author:** [@jruben84](https://forum.inductiveautomation.com/u/jruben84)\ **Replies:** 6\ **Last updated:** [April 25, 2016, 4:14pm UTC](https://forum.inductiveautomation.com/t/sending-automatically-emails/11555 "2016-04-25T16:14:16Z")
Hi, I am looking for a way to send reports (pdf or html) attached in a email, that runs automatically at certain time. In fact, I can send reports when I push a button, but I want to send it without user intervention, f… --- ## [HSQL Error in 7.8.2](https://forum.inductiveautomation.com/t/hsql-error-in-7-8-2/11425)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 3\ **Last updated:** [April 25, 2016, 3:32pm UTC](https://forum.inductiveautomation.com/t/hsql-error-in-7-8-2/11425 "2016-04-25T15:32:18Z")
I am getting the below error in 7.8.2, which I would think is not possible since the move to SQLLite, it appears to be coming from a large record insert from SF engine. Any ideas? 10:09:48 AM HSQLDataStore Error stor… --- ## [Using time/date tags in SQL WHERE caluse](https://forum.inductiveautomation.com/t/using-time-date-tags-in-sql-where-caluse/11574)
**Author:** [@Mr.K001](https://forum.inductiveautomation.com/u/Mr.K001)\ **Replies:** 3\ **Last updated:** [April 25, 2016, 3:20pm UTC](https://forum.inductiveautomation.com/t/using-time-date-tags-in-sql-where-caluse/11574 "2016-04-25T15:20:27Z")
Hey guys, I use different formats of expression tags(time intervals) in my SQL WHERE clause. I get this error when I open a window that uses a query: SELECT t\_stamp, column1 AS 'part1', column2 AS 'part2' FROM t… --- ## [Template for getting name of tag with value](https://forum.inductiveautomation.com/t/template-for-getting-name-of-tag-with-value/10803)
**Author:** [@GKrueger](https://forum.inductiveautomation.com/u/GKrueger)\ **Replies:** 9\ **Last updated:** [April 25, 2016, 2:54pm UTC](https://forum.inductiveautomation.com/t/template-for-getting-name-of-tag-with-value/10803 "2016-04-25T14:54:45Z")
Does anyone know if there is a template out there that would let me drag a tag value onto a display for a numeric input component and have it automatically populate a label next to it with the .name parameter of the same… --- ## [system.db.runQuery fails when inserting into temporary table](https://forum.inductiveautomation.com/t/system-db-runquery-fails-when-inserting-into-temporary-table/11573)
**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\ **Replies:** 0\ **Last updated:** [April 25, 2016, 12:27pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-fails-when-inserting-into-temporary-table/11573 "2016-04-25T12:27:10Z")
I have the script shown below that tries to run an SQL query against an MS SQL database. The query runs fine in Management Studio. The code fails every time with the error shown below. The problem line is: insert i… --- ## [Creating auto-backup](https://forum.inductiveautomation.com/t/creating-auto-backup/11568)
**Author:** [@jruben84](https://forum.inductiveautomation.com/u/jruben84)\ **Replies:** 4\ **Last updated:** [April 24, 2016, 7:26pm UTC](https://forum.inductiveautomation.com/t/creating-auto-backup/11568 "2016-04-24T19:26:39Z")
Hi, Is there a way for turn-off or set up more time to the auto-backup setting? I got this: 02:06:37 PM LocalDBManagerImpl Creating auto-backup of internal database “settings”… 02:03:22 PM LocalDBManagerImpl Creating… --- ## [Redundancy. Master and Back-up both showing Active?](https://forum.inductiveautomation.com/t/redundancy-master-and-back-up-both-showing-active/11570)
**Author:** [@Clkman](https://forum.inductiveautomation.com/u/Clkman)\ **Replies:** 0\ **Last updated:** [April 24, 2016, 1:52pm UTC](https://forum.inductiveautomation.com/t/redundancy-master-and-back-up-both-showing-active/11570 "2016-04-24T13:52:29Z")
Hi, I'm messing around with redundancy and under a connection failure test between the master and backup, I had both the master and backup showing active at the same time. Is this correct or have I incorrectly set up r… --- ## [Reset 'focus on selected alarm'](https://forum.inductiveautomation.com/t/reset-focus-on-selected-alarm/11569)
**Author:** [@thierryv](https://forum.inductiveautomation.com/u/thierryv)\ **Replies:** 0\ **Last updated:** [April 24, 2016, 6:13am UTC](https://forum.inductiveautomation.com/t/reset-focus-on-selected-alarm/11569 "2016-04-24T06:13:53Z")
How can I reset the 'Focus on selected alarm' in a alarm journal? I see there is a method 'isAlarmFocused' to see wether there is a focus or not but I see nothing to reset it. Thx --- ## [How can I get a license for my own module?](https://forum.inductiveautomation.com/t/how-can-i-get-a-license-for-my-own-module/11566)
**Author:** [@adnaram](https://forum.inductiveautomation.com/u/adnaram)\ **Replies:** 1\ **Last updated:** [April 22, 2016, 10:47pm UTC](https://forum.inductiveautomation.com/t/how-can-i-get-a-license-for-my-own-module/11566 "2016-04-22T22:47:18Z")
I devellops a module for my company. We have a gateway in developer mode and one for production. I signed the module using your marketplace. My module is still in trial mode, even with the module signed converted from… --- ## [Anyone use Ignition for Scrum?](https://forum.inductiveautomation.com/t/anyone-use-ignition-for-scrum/11542)
**Author:** [@adonnell](https://forum.inductiveautomation.com/u/adonnell)\ **Replies:** 5\ **Last updated:** [April 22, 2016, 8:49pm UTC](https://forum.inductiveautomation.com/t/anyone-use-ignition-for-scrum/11542 "2016-04-22T20:49:22Z")
Has anyone created a Scrum application with Ignition? Including a Scrum board, burn down charts, etc. Also, any ideas on how one would create a post-it note that could be dragged from one column of the scrum board to … --- ## [Export SQL Table as .CSV?](https://forum.inductiveautomation.com/t/export-sql-table-as-csv/11565)
**Author:** [@a\_holburn](https://forum.inductiveautomation.com/u/a_holburn)\ **Replies:** 1\ **Last updated:** [April 22, 2016, 7:35pm UTC](https://forum.inductiveautomation.com/t/export-sql-table-as-csv/11565 "2016-04-22T19:35:25Z")
Hey guys, I'm a fairly new user of ignition, and I'm loving it so far. I've got a bit a of a problem that I'm not sure how to solve with jython: I want to export an entire SQL table as a .CSV. Basically, I want to buil… --- ## [Problem returning String array or Integer array values](https://forum.inductiveautomation.com/t/problem-returning-string-array-or-integer-array-values/11564)
**Author:** [@Bob](https://forum.inductiveautomation.com/u/Bob)\ **Replies:** 0\ **Last updated:** [April 22, 2016, 6:09pm UTC](https://forum.inductiveautomation.com/t/problem-returning-string-array-or-integer-array-values/11564 "2016-04-22T18:09:05Z")
Using Ignition 7.8.2 I am testing with the code below where spectrumCompressed has been tried as both a string array and an integer array because the strings actually just represent integers: import datetime startTi… --- ## [Auto-backup settings](https://forum.inductiveautomation.com/t/auto-backup-settings/11563)
**Author:** [@jruben84](https://forum.inductiveautomation.com/u/jruben84)\ **Replies:** 0\ **Last updated:** [April 22, 2016, 5:22pm UTC](https://forum.inductiveautomation.com/t/auto-backup-settings/11563 "2016-04-22T17:22:08Z")
Hi, My auto-backup database process (not the scheduled) takes more than 1 minute, and when I am working with gateway scripts, and I save my changes, my designer freezes and I need to wait more than one minute for get ba… --- ## [Using Ignition database shrink tool on Linux](https://forum.inductiveautomation.com/t/using-ignition-database-shrink-tool-on-linux/11561)
**Author:** [@driverk](https://forum.inductiveautomation.com/u/driverk)\ **Replies:** 1\ **Last updated:** [April 22, 2016, 2:44pm UTC](https://forum.inductiveautomation.com/t/using-ignition-database-shrink-tool-on-linux/11561 "2016-04-22T14:44:03Z")
First, I realize that this may be less of a priority now that there are versions for 7.7 and 7.8 that deal with the internal database growth issue. We are using 7.7.6 in production. We have been testing 7.8.2, but we h… --- ## [Hide and show tabs based on role in tab strip navigation](https://forum.inductiveautomation.com/t/hide-and-show-tabs-based-on-role-in-tab-strip-navigation/11547)
**Author:** [@sudhamoorthy](https://forum.inductiveautomation.com/u/sudhamoorthy)\ **Replies:** 6\ **Last updated:** [April 22, 2016, 9:31am UTC](https://forum.inductiveautomation.com/t/hide-and-show-tabs-based-on-role-in-tab-strip-navigation/11547 "2016-04-22T09:31:54Z")
Hi, I have created a project in which i'm using tab strip for navigation between windows. Is it possible to hide and show the tabs based on some role? For example, i want to show the user management tab only to the a… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1741) [Next page](https://forum.inductiveautomation.com/latest.md?page=1743)