# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1607 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1608 --- ## [Export certain columns to excel sheet](https://forum.inductiveautomation.com/t/export-certain-columns-to-excel-sheet/5120)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [September 7, 2012, 11:22pm UTC](https://forum.inductiveautomation.com/t/export-certain-columns-to-excel-sheet/5120 "2012-09-07T23:22:09Z")
I have this code to export table to excel sheet but i need to export certain column only for example column name 1,2,3,4,7 but no need for column 6 table = event.source.parent.getComponent("AlarmTable") filePath = s… --- ## [Report initial load reportLoading finished but report blank](https://forum.inductiveautomation.com/t/report-initial-load-reportloading-finished-but-report-blank/5084)
**Author:** [@DomArmstrong](https://forum.inductiveautomation.com/u/DomArmstrong)\ **Replies:** 8\ **Last updated:** [September 7, 2012, 10:58pm UTC](https://forum.inductiveautomation.com/t/report-initial-load-reportloading-finished-but-report-blank/5084 "2012-09-07T22:58:54Z")
Having an issue where I am printing multiple reports at a time. I'm using the reportLoading flag to check whether the report is ready to print: \[code\]if event.propertyName == "reportLoading": reportLoading = event.sou… --- ## [How can I make a project display correctly on an iPad 2?](https://forum.inductiveautomation.com/t/how-can-i-make-a-project-display-correctly-on-an-ipad-2/4852)
**Author:** [@tomearp](https://forum.inductiveautomation.com/u/tomearp)\ **Replies:** 11\ **Last updated:** [September 7, 2012, 5:01pm UTC](https://forum.inductiveautomation.com/t/how-can-i-make-a-project-display-correctly-on-an-ipad-2/4852 "2012-09-07T17:01:54Z")
Hello, I'm having some trouble getting a project to display correctly on an iPad 2. I have tried all manner of main window sizes and various combinations of "Fit to Device" and "Start Maximised" etc. etc. No matter w… --- ## [Hiding report layers](https://forum.inductiveautomation.com/t/hiding-report-layers/5104)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 2\ **Last updated:** [September 7, 2012, 8:10am UTC](https://forum.inductiveautomation.com/t/hiding-report-layers/5104 "2012-09-07T08:10:53Z")
Is there any way to programmatically hide layers in a report? I have a report that needs to be visible on screen in its entirety, but when printed it should only print the data, as the report layout will be pre-printed… --- ## [Subreports option missing from report designer](https://forum.inductiveautomation.com/t/subreports-option-missing-from-report-designer/5107)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 2\ **Last updated:** [September 7, 2012, 7:54am UTC](https://forum.inductiveautomation.com/t/subreports-option-missing-from-report-designer/5107 "2012-09-07T07:54:06Z")
The 'Subreport' option (reportmill.com/support/Subreports.pdf) appears to be missing from the 'Add Shapes' menu in the report designer. Is this intentional? Thanks. --- ## [Mobile module - click event problem](https://forum.inductiveautomation.com/t/mobile-module-click-event-problem/4644)
**Author:** [@idelamer](https://forum.inductiveautomation.com/u/idelamer)\ **Replies:** 12\ **Last updated:** [September 6, 2012, 3:23pm UTC](https://forum.inductiveautomation.com/t/mobile-module-click-event-problem/4644 "2012-09-06T15:23:24Z")
I noticed this problem on 7.4.3-beta1 and 7.5.0. I'm using the Mobile Skeleton project. When in one of the "Main Windows", clicking anywhere on the screen will cause the "Back" button to fire, and will return to the Na… --- ## [Existing PDF report](https://forum.inductiveautomation.com/t/existing-pdf-report/5106)
**Author:** [@systemparadox](https://forum.inductiveautomation.com/u/systemparadox)\ **Replies:** 1\ **Last updated:** [September 6, 2012, 3:07pm UTC](https://forum.inductiveautomation.com/t/existing-pdf-report/5106 "2012-09-06T15:07:13Z")
I'm trying to create a report to fill-in an existing PDF, but a collection of problems have conspired against me: The "Ignition Reporting Features" documentation page (inductiveautomation.com/supp ... atures.htm) menti… --- ## [Alarms Itempath](https://forum.inductiveautomation.com/t/alarms-itempath/5094)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [September 6, 2012, 8:14am UTC](https://forum.inductiveautomation.com/t/alarms-itempath/5094 "2012-09-06T08:14:08Z")
In Navigation bar there is an Alarm counting with below scripting code runScript("system.alert.queryAlertStatus(" + "activeAndAcked=" + toInt({Root Container.Alarms.activeAndAcked}) + "," + "activeAndUnacked=" + toI… --- ## [Tag import export](https://forum.inductiveautomation.com/t/tag-import-export/4461)
**Author:** [@marioquark](https://forum.inductiveautomation.com/u/marioquark)\ **Replies:** 17\ **Last updated:** [September 6, 2012, 7:20am UTC](https://forum.inductiveautomation.com/t/tag-import-export/4461 "2012-09-06T07:20:33Z")
importing a client tag previously exported on file: --- ## [Docked Window North Changing sizes](https://forum.inductiveautomation.com/t/docked-window-north-changing-sizes/5102)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [September 6, 2012, 12:22am UTC](https://forum.inductiveautomation.com/t/docked-window-north-changing-sizes/5102 "2012-09-06T00:22:46Z")
I have a window docked north and another window docked west. when i resize the window docked west the window docked north seems to resize or reposition it self when i open or close windows. this wouldn't be a problem bu… --- ## [Device using dynamic DNS](https://forum.inductiveautomation.com/t/device-using-dynamic-dns/4945)
**Author:** [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Replies:** 9\ **Last updated:** [September 5, 2012, 11:46pm UTC](https://forum.inductiveautomation.com/t/device-using-dynamic-dns/4945 "2012-09-05T23:46:13Z")
Hello All! I have a customer who wants to connect Ignition to a Allen Bradley device (micrologix) using a dynamic DNS (the device and Ignition are both in local). The connection always gets 'Faulted' using the dynamic … --- ## [Bind font on components](https://forum.inductiveautomation.com/t/bind-font-on-components/5101)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [September 5, 2012, 11:37pm UTC](https://forum.inductiveautomation.com/t/bind-font-on-components/5101 "2012-09-05T23:37:06Z")
Why does the font property on components not have the ability to be binded? I was thinking I could store the font in the database and if we ever wanted to change the font throughout the project we would only need to cha… --- ## [Scheduled Execution for Stored Procedure Transaction Groups](https://forum.inductiveautomation.com/t/scheduled-execution-for-stored-procedure-transaction-groups/5057)
**Author:** [@miketob](https://forum.inductiveautomation.com/u/miketob)\ **Replies:** 1\ **Last updated:** [September 5, 2012, 10:44pm UTC](https://forum.inductiveautomation.com/t/scheduled-execution-for-stored-procedure-transaction-groups/5057 "2012-09-05T22:44:34Z")
Hello Guys, It would be nice to have the same functionality of "Scheduled Execution" that is now present for Standard Transaction groups in the Stored Procedure groups (and all other group types) Best Regards --- ## [Ntp 64bits format in datetime](https://forum.inductiveautomation.com/t/ntp-64bits-format-in-datetime/5093)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 6\ **Last updated:** [September 5, 2012, 7:30pm UTC](https://forum.inductiveautomation.com/t/ntp-64bits-format-in-datetime/5093 "2012-09-05T19:30:11Z")
Hi, How can I convert "with expression" a ntp time format (64 bits format) in human readable format with expression ? In python, there is no problem with time.ctime(utc\_seconds), but can't find a simple way to make it … --- ## [Error MemoryForwardTransaction](https://forum.inductiveautomation.com/t/error-memoryforwardtransaction/5063)
**Author:** [@weertske](https://forum.inductiveautomation.com/u/weertske)\ **Replies:** 11\ **Last updated:** [September 5, 2012, 7:19pm UTC](https://forum.inductiveautomation.com/t/error-memoryforwardtransaction/5063 "2012-09-05T19:19:57Z")
The following error is filling up my log. Any idea what I can do to stop the problem? --- ## [Back button navigation](https://forum.inductiveautomation.com/t/back-button-navigation/5100)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 8\ **Last updated:** [September 5, 2012, 6:43pm UTC](https://forum.inductiveautomation.com/t/back-button-navigation/5100 "2012-09-05T18:43:22Z")
Has anyone ever made a reverse navigationlike this before? I would think that using tags to keep track of the recent windows would slow down the project? --- ## [Find in Script Module Editor](https://forum.inductiveautomation.com/t/find-in-script-module-editor/5089)
**Author:** [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Replies:** 3\ **Last updated:** [September 5, 2012, 6:36pm UTC](https://forum.inductiveautomation.com/t/find-in-script-module-editor/5089 "2012-09-05T18:36:26Z")
Minor issue, but it appears that the "Find" (Ctrl-F) feature in Global search mode in the Script Module Editor not only highlights the search text in the current module, but also puts the little highlight patches on any … --- ## [Graph Accuracy - Magic Spikes, Appear & Dissapear](https://forum.inductiveautomation.com/t/graph-accuracy-magic-spikes-appear-dissapear/5080)
**Author:** [@Sean49](https://forum.inductiveautomation.com/u/Sean49)\ **Replies:** 17\ **Last updated:** [September 5, 2012, 5:28pm UTC](https://forum.inductiveautomation.com/t/graph-accuracy-magic-spikes-appear-dissapear/5080 "2012-09-05T17:28:37Z")
Hi, On our trend displays trend lines are showing spikes where there should be none. (see attached files and video ) The problem seems to be related to when another trend line makes a change. Any trend line can affect t… --- ## [Red Lion](https://forum.inductiveautomation.com/t/red-lion/5095)
**Author:** [@hazey](https://forum.inductiveautomation.com/u/hazey)\ **Replies:** 2\ **Last updated:** [September 4, 2012, 10:24pm UTC](https://forum.inductiveautomation.com/t/red-lion/5095 "2012-09-04T22:24:20Z")
Hi guys, what is the best method or protocol to connect a Red Lion Data Station to Ignition? I want to transfer information to Data Station (Marquee) from Ignition Database. thx hazey --- ## [Root container opaque](https://forum.inductiveautomation.com/t/root-container-opaque/5088)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 9\ **Last updated:** [September 4, 2012, 3:32pm UTC](https://forum.inductiveautomation.com/t/root-container-opaque/5088 "2012-09-04T15:32:12Z")
I tried setting my root container opaque property to false so it would just show through to my client background color, but it just shows grey. is it possible to make the root container opaque? Thank you, --- ## [Mobile project](https://forum.inductiveautomation.com/t/mobile-project/5086)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 1\ **Last updated:** [August 31, 2012, 11:08pm UTC](https://forum.inductiveautomation.com/t/mobile-project/5086 "2012-08-31T23:08:04Z")
I've got some 1024\* sized windows for a computer launched client I'm trying to figure out the best way to create an optimized mobile applet from an existing project. I was assuming this task would be best approached by… --- ## [Property copy/paste](https://forum.inductiveautomation.com/t/property-copy-paste/5083)
**Author:** [@onestank](https://forum.inductiveautomation.com/u/onestank)\ **Replies:** 2\ **Last updated:** [August 31, 2012, 8:07pm UTC](https://forum.inductiveautomation.com/t/property-copy-paste/5083 "2012-08-31T20:07:03Z")
Have found times that I design a window and then need to changed the properties of multiple items of the same type. Like when I need to add CTG functionality to multiple things instead of having to add custom property a… --- ## [Recipe Load Fail from Transaction Group](https://forum.inductiveautomation.com/t/recipe-load-fail-from-transaction-group/5087)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 2\ **Last updated:** [August 31, 2012, 6:02pm UTC](https://forum.inductiveautomation.com/t/recipe-load-fail-from-transaction-group/5087 "2012-08-31T18:02:28Z")
Hey guys, I'm starting to fool around with doing some recipe loading from a database via Ignition transaction groups. I got everything working except for a failure indication. I'm selecting a recipe number from a OP… --- ## [dataQuality inconsistent on components](https://forum.inductiveautomation.com/t/dataquality-inconsistent-on-components/5082)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 3\ **Last updated:** [August 31, 2012, 3:33pm UTC](https://forum.inductiveautomation.com/t/dataquality-inconsistent-on-components/5082 "2012-08-31T15:33:32Z")
We're using the 'dataQuality' meta-property on one of our windows to determine if the window has completed loading before a script my be ran by the operator. It seems that not all the components have consistent behavior … --- ## [Popup Calendar european format](https://forum.inductiveautomation.com/t/popup-calendar-european-format/5077)
**Author:** [@quper](https://forum.inductiveautomation.com/u/quper)\ **Replies:** 2\ **Last updated:** [August 31, 2012, 9:03am UTC](https://forum.inductiveautomation.com/t/popup-calendar-european-format/5077 "2012-08-31T09:03:45Z")
Hello, Is it possible to change popup calendar date/time style? Now it displays first day of week Sunday, I would like week to start from Monday. Also I would like it to display 24H time format without AM/PM. I can c… --- ## [Mark components in template to not resize](https://forum.inductiveautomation.com/t/mark-components-in-template-to-not-resize/5081)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [August 30, 2012, 4:19pm UTC](https://forum.inductiveautomation.com/t/mark-components-in-template-to-not-resize/5081 "2012-08-30T16:19:45Z")
Is there a way to mark components in a template so they will not change size when a template is resized? I tried changing their layout to anchored, but there was no effect. Thank you --- ## [Easy Chart customizer problem](https://forum.inductiveautomation.com/t/easy-chart-customizer-problem/5078)
**Author:** [@quper](https://forum.inductiveautomation.com/u/quper)\ **Replies:** 1\ **Last updated:** [August 30, 2012, 9:17am UTC](https://forum.inductiveautomation.com/t/easy-chart-customizer-problem/5078 "2012-08-30T09:17:23Z")
Hi, I have problem with Easy Chart Customizer. Since yesterday I am not able to edit SQL Tags Historian Pens and add new tag pens in Easy Chart. I am still able to delete tag pens and and browse tag pens. Same with Datab… --- ## [Auditing table target name correspondence](https://forum.inductiveautomation.com/t/auditing-table-target-name-correspondence/5067)
**Author:** [@quper](https://forum.inductiveautomation.com/u/quper)\ **Replies:** 3\ **Last updated:** [August 30, 2012, 7:52am UTC](https://forum.inductiveautomation.com/t/auditing-table-target-name-correspondence/5067 "2012-08-30T07:52:14Z")
Hi, I have auditing table in designer which is filled by system auditing function. There is column with tag pathes (Action Target). For example I have tagpathes: RVP01/Register/Rest\_of\_tag\_path RVP01/Register/Rest\_of\_ta… --- ## [Reset Time Meter Value at Midnight](https://forum.inductiveautomation.com/t/reset-time-meter-value-at-midnight/5074)
**Author:** [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Replies:** 4\ **Last updated:** [August 29, 2012, 10:52pm UTC](https://forum.inductiveautomation.com/t/reset-time-meter-value-at-midnight/5074 "2012-08-29T22:52:48Z")
I am trying to measure the uptime and downtime of our process. I have setup a transaction group where an expression tag named uptime uses the time meter to determine the uptime of our process. How can I get the time … --- ## [Save File Script Help](https://forum.inductiveautomation.com/t/save-file-script-help/5073)
**Author:** [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\ **Replies:** 1\ **Last updated:** [August 29, 2012, 8:06pm UTC](https://forum.inductiveautomation.com/t/save-file-script-help/5073 "2012-08-29T20:06:14Z")
I'm using the system.file.saveFile to save a file to a location on the server. It already returns the file path but is there a way to pull out what the user typed for a file name? openFilePath = system.file.openFile(… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1606) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1608)