# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1496 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1497 --- ## [stringFormat error with %c conversion and constants](https://forum.inductiveautomation.com/t/stringformat-error-with-c-conversion-and-constants/9750)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 1\ **Last updated:** [February 27, 2015, 4:00pm UTC](https://forum.inductiveautomation.com/t/stringformat-error-with-c-conversion-and-constants/9750 "2015-02-27T16:00:47Z")
New for v7.7.2 (v7.7.2-rc1 worked) custom property 'abc' expression: stringFormat('%c', 0) yields: java.lang.Exception: Error executing expression binding on ReportPlay.Root Container.abc at com.inductiveautoma… --- ## [Duplicate entry checking with Azure database](https://forum.inductiveautomation.com/t/duplicate-entry-checking-with-azure-database/9747)
**Author:** [@dfarnes](https://forum.inductiveautomation.com/u/dfarnes)\ **Replies:** 4\ **Last updated:** [February 27, 2015, 2:01pm UTC](https://forum.inductiveautomation.com/t/duplicate-entry-checking-with-azure-database/9747 "2015-02-27T14:01:32Z")
I have a short script which saves a product name to a Azure SQL database. My question is how to test for and disallow duplicate names. I know I can put a constraint on the database which will throw an exception if a dupl… --- ## [Can't open the screens in the designer](https://forum.inductiveautomation.com/t/cant-open-the-screens-in-the-designer/9753)
**Author:** [@Don\_t\_shoot](https://forum.inductiveautomation.com/u/Don_t_shoot)\ **Replies:** 2\ **Last updated:** [February 27, 2015, 5:59am UTC](https://forum.inductiveautomation.com/t/cant-open-the-screens-in-the-designer/9753 "2015-02-27T05:59:21Z")
I Reinstalled the ignition software, and I backuped by using ".gwbk"and ".proj" files to restore .And when I want to open the screens in the designer , there is an error and said "Unable to open the window xxxx" and the… --- ## [Transferring project without backing up gateway](https://forum.inductiveautomation.com/t/transferring-project-without-backing-up-gateway/9722)
**Author:** [@CA\_HMIDev](https://forum.inductiveautomation.com/u/CA_HMIDev)\ **Replies:** 1\ **Last updated:** [February 26, 2015, 11:58pm UTC](https://forum.inductiveautomation.com/t/transferring-project-without-backing-up-gateway/9722 "2015-02-26T23:58:11Z")
Hello. I'm wondering if there's a way to transfer projects from one server to another without backing up and restoring the gateway. I'm working on multiple projects on my server which I eventually hope to deploy to serve… --- ## [Highlight Button while pressed](https://forum.inductiveautomation.com/t/highlight-button-while-pressed/9732)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 3\ **Last updated:** [February 26, 2015, 11:44pm UTC](https://forum.inductiveautomation.com/t/highlight-button-while-pressed/9732 "2015-02-26T23:44:12Z")
I was wondering if there is a way to indicated visually that a button is being pressed. In FactoryTalk when pushing a button like a momentary push button the button has a highlight ring around it as long as the button is… --- ## [IA Scripting: system.tag.getAttribute requires TagProvider](https://forum.inductiveautomation.com/t/ia-scripting-system-tag-getattribute-requires-tagprovider/8787)
**Author:** [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\ **Replies:** 10\ **Last updated:** [February 26, 2015, 7:34pm UTC](https://forum.inductiveautomation.com/t/ia-scripting-system-tag-getattribute-requires-tagprovider/8787 "2015-02-26T19:34:29Z")
My code seems to make sense and it looks like it would work fine: tag = "MyTag" if system.tag.exists(tag): doc = system.tag.getAttribute(tag, "Documentation") ...do stuff... But I keep getting the error: ..… --- ## [Table column font](https://forum.inductiveautomation.com/t/table-column-font/9738)
**Author:** [@Didi71](https://forum.inductiveautomation.com/u/Didi71)\ **Replies:** 5\ **Last updated:** [February 26, 2015, 8:13am UTC](https://forum.inductiveautomation.com/t/table-column-font/9738 "2015-02-26T08:13:25Z")
Hello everybody. Is it possible (and how to) to set a specific font for each column of a table component (regardless from column values)? Thanks in advance. --- ## [Convert NI VI](https://forum.inductiveautomation.com/t/convert-ni-vi/9744)
**Author:** [@the\_msp](https://forum.inductiveautomation.com/u/the_msp)\ **Replies:** 0\ **Last updated:** [February 25, 2015, 12:50pm UTC](https://forum.inductiveautomation.com/t/convert-ni-vi/9744 "2015-02-25T12:50:51Z")
I have written a National Instruments LabView Virutal Instrument. The purpose of the VI is to transpose pixels moved into length. The mouse is fixed and a cable passes by the optical sensor inside a machined track. An ev… --- ## [Help with create Own alarm status?](https://forum.inductiveautomation.com/t/help-with-create-own-alarm-status/9739)
**Author:** [@Sebastian\_coor](https://forum.inductiveautomation.com/u/Sebastian_coor)\ **Replies:** 2\ **Last updated:** [February 25, 2015, 12:00pm UTC](https://forum.inductiveautomation.com/t/help-with-create-own-alarm-status/9739 "2015-02-25T12:00:09Z")
I am wondering if you have some tips for this: We want to create our own alarm status fo when the user click or double click on the alarm event it will take him direct to the windows where the alarm is realted. Ex: If … --- ## [Kepware OPC DA - the OPC Server is faulted](https://forum.inductiveautomation.com/t/kepware-opc-da-the-opc-server-is-faulted/9742)
**Author:** [@TimOSullivan](https://forum.inductiveautomation.com/u/TimOSullivan)\ **Replies:** 1\ **Last updated:** [February 24, 2015, 11:17pm UTC](https://forum.inductiveautomation.com/t/kepware-opc-da-the-opc-server-is-faulted/9742 "2015-02-24T23:17:35Z")
Hi, I have a Kepware V4.5 OPC DA server on a PC that handles all IO to Wonderware InTouch PCs. I've SQL Bridge running on a Windows Server that also communicates with Kepware. Ignition connects to Kepware and shows con… --- ## [V7.6 Alarm Journal export to CSV](https://forum.inductiveautomation.com/t/v7-6-alarm-journal-export-to-csv/6529)
**Author:** [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Replies:** 7\ **Last updated:** [February 24, 2015, 9:20pm UTC](https://forum.inductiveautomation.com/t/v7-6-alarm-journal-export-to-csv/6529 "2015-02-24T21:20:17Z")
Hi Guys, Is there an easy way to export the new Alarm Journal table to CSV? Cheers for any help. Tim... --- ## [Timeout exeception trying to view large database schema tree](https://forum.inductiveautomation.com/t/timeout-exeception-trying-to-view-large-database-schema-tree/9741)
**Author:** [@sfitze](https://forum.inductiveautomation.com/u/sfitze)\ **Replies:** 0\ **Last updated:** [February 24, 2015, 1:37pm UTC](https://forum.inductiveautomation.com/t/timeout-exeception-trying-to-view-large-database-schema-tree/9741 "2015-02-24T13:37:26Z")
I am connected to a large Oracle database and when I open the Query Browser it tries to load the schema tree and times out. Is there a parameter that I can change to increase this timeout. I can query the database fine… --- ## [Slow Gateway and tag problem](https://forum.inductiveautomation.com/t/slow-gateway-and-tag-problem/9727)
**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\ **Replies:** 7\ **Last updated:** [February 24, 2015, 1:10am UTC](https://forum.inductiveautomation.com/t/slow-gateway-and-tag-problem/9727 "2015-02-24T01:10:54Z")
I had a problem today where Ignition wasn’t working properly. Some of the problems were: 1. Tag Quality cycling between good and bad every 10 seconds from multiple Scan Classes 2. Lots of errors to do with failing dat… --- ## [Using MAX function in Report Designer](https://forum.inductiveautomation.com/t/using-max-function-in-report-designer/9737)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 1\ **Last updated:** [February 23, 2015, 10:27pm UTC](https://forum.inductiveautomation.com/t/using-max-function-in-report-designer/9737 "2015-02-23T22:27:15Z")
According to the online help for the MAX function: max(dataset, column OR number, number...) Finds and returns the maximum value in the given column of the given dataset, or the max value in a series of numbers speci… --- ## [\[7.7.2\] Alarming Override in an UDT does not work](https://forum.inductiveautomation.com/t/7-7-2-alarming-override-in-an-udt-does-not-work/9518)
**Author:** [@Amarth](https://forum.inductiveautomation.com/u/Amarth)\ **Replies:** 12\ **Last updated:** [February 23, 2015, 10:24pm UTC](https://forum.inductiveautomation.com/t/7-7-2-alarming-override-in-an-udt-does-not-work/9518 "2015-02-23T22:24:14Z")
Hello, Since 7.7.2, I can not override the alarming section of a UDT-instance. Clicking on "Apply" or "OK" does not save the overridding anymore. I tried the same operation on a 7.7.1 and it does work. Operations: C… --- ## [Ugly bug inside the Calendar Week View component](https://forum.inductiveautomation.com/t/ugly-bug-inside-the-calendar-week-view-component/9711)
**Author:** [@Didi71](https://forum.inductiveautomation.com/u/Didi71)\ **Replies:** 8\ **Last updated:** [February 23, 2015, 8:05pm UTC](https://forum.inductiveautomation.com/t/ugly-bug-inside-the-calendar-week-view-component/9711 "2015-02-23T20:05:05Z")
Hello everybody. We are using Ignition version 7.7.2 (b2014121709) with Java 1.8.0\_25 running on Windows 7 64 bit and we are detecting a bug inside the Calendar Week View component. Steps to reproduce the behavior: (… --- ## [Dynamically resize width from right to left?](https://forum.inductiveautomation.com/t/dynamically-resize-width-from-right-to-left/9736)
**Author:** [@CA\_HMIDev](https://forum.inductiveautomation.com/u/CA_HMIDev)\ **Replies:** 2\ **Last updated:** [February 23, 2015, 8:04pm UTC](https://forum.inductiveautomation.com/t/dynamically-resize-width-from-right-to-left/9736 "2015-02-23T20:04:58Z")
Hello. I have a component which I would like to resize based on the current value of another component. Unfortunately, resizing appears to only work one way (from left to right). Is it possible to reverse the direction a… --- ## [Script to list the template parameters (input parameters)](https://forum.inductiveautomation.com/t/script-to-list-the-template-parameters-input-parameters/9734)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 2\ **Last updated:** [February 23, 2015, 4:23pm UTC](https://forum.inductiveautomation.com/t/script-to-list-the-template-parameters-input-parameters/9734 "2015-02-23T16:23:05Z")
Hi, I’m looking a way to list by script the template parameters (of a template object). when I use : getDynamicProps() getDropTargetProperty() all the parameters are returned, but I would like to filter only inputs pa… --- ## [Unknown tag writing](https://forum.inductiveautomation.com/t/unknown-tag-writing/9043)
**Author:** [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\ **Replies:** 10\ **Last updated:** [February 23, 2015, 9:22am UTC](https://forum.inductiveautomation.com/t/unknown-tag-writing/9043 "2015-02-23T09:22:31Z")
Hello for everyone. Week ago i got some bad bug: I create a memory tag and in a timer script writing this: HasAlarm = system.db.runScalarQuery("SELECT COUNT(\*) FROM alert\_log where sent = 0") system.tag.write("gsm\_sms/… --- ## [Alarm Display Path "Description" from SQL Table](https://forum.inductiveautomation.com/t/alarm-display-path-description-from-sql-table/9696)
**Author:** [@ccooper](https://forum.inductiveautomation.com/u/ccooper)\ **Replies:** 3\ **Last updated:** [February 22, 2015, 8:33pm UTC](https://forum.inductiveautomation.com/t/alarm-display-path-description-from-sql-table/9696 "2015-02-22T20:33:19Z")
I am trying to run a script that calls a SQL query to to look up and display an alarms Display Path (description). I have the alarm "descriptions" in a SQL table along with a unique alarm code for each alarm. Currently I… --- ## [Print Report](https://forum.inductiveautomation.com/t/print-report/9714)
**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\ **Replies:** 6\ **Last updated:** [February 20, 2015, 3:00pm UTC](https://forum.inductiveautomation.com/t/print-report/9714 "2015-02-20T15:00:52Z")
When right clicking on the report screen and choosing print, I'm getting this error... Comparison method violates its general contract! Any ideas? I'm on version 7.5.12 running Java 7u75 --- ## [Report Grouping Based on Time Interval](https://forum.inductiveautomation.com/t/report-grouping-based-on-time-interval/9721)
**Author:** [@Samn265](https://forum.inductiveautomation.com/u/Samn265)\ **Replies:** 2\ **Last updated:** [February 20, 2015, 11:07am UTC](https://forum.inductiveautomation.com/t/report-grouping-based-on-time-interval/9721 "2015-02-20T11:07:48Z")
I am using Ignition 7.7.2 In the report designer how do you group data based on time interval? I would like to make selectable criteria based on the “DownTime Start” column, so I can say I need this date (or date range… --- ## [Template canvas - Layout Positionning](https://forum.inductiveautomation.com/t/template-canvas-layout-positionning/9660)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [February 20, 2015, 12:49am UTC](https://forum.inductiveautomation.com/t/template-canvas-layout-positionning/9660 "2015-02-20T00:49:34Z")
What are the possibles values for thelayout positioning option of the template canvas repeater ? --- ## [Barcode in Report Table](https://forum.inductiveautomation.com/t/barcode-in-report-table/9730)
**Author:** [@scicco](https://forum.inductiveautomation.com/u/scicco)\ **Replies:** 2\ **Last updated:** [February 19, 2015, 9:40pm UTC](https://forum.inductiveautomation.com/t/barcode-in-report-table/9730 "2015-02-19T21:40:28Z")
Hello, I’m trying to display a barcode in a report table. I can’t figure out how to use the actual barcode object in the table so I’m dragging the field I want and then changing its font to Code 39. It displays a barc… --- ## [Sending pdf in email](https://forum.inductiveautomation.com/t/sending-pdf-in-email/9726)
**Author:** [@stuartd](https://forum.inductiveautomation.com/u/stuartd)\ **Replies:** 10\ **Last updated:** [February 19, 2015, 6:27pm UTC](https://forum.inductiveautomation.com/t/sending-pdf-in-email/9726 "2015-02-19T18:27:50Z")
Hey, so I am trying to set up a report viewer to display a report, then have an option to send it off in an email. I have the report able to be set to a pdf viewer, I can also open it outside of Ignition. but when i try … --- ## [Finding Components in Project Script](https://forum.inductiveautomation.com/t/finding-components-in-project-script/9728)
**Author:** [@Howell](https://forum.inductiveautomation.com/u/Howell)\ **Replies:** 1\ **Last updated:** [February 19, 2015, 3:12am UTC](https://forum.inductiveautomation.com/t/finding-components-in-project-script/9728 "2015-02-19T03:12:51Z")
I'm trying to find a way to have a function that can be called by any of the components in a window. Unless I am missing something, I think the correct way to do this would be to use a project script. In the function… --- ## [Data from dataset to another dataset](https://forum.inductiveautomation.com/t/data-from-dataset-to-another-dataset/9725)
**Author:** [@pjgonzales](https://forum.inductiveautomation.com/u/pjgonzales)\ **Replies:** 3\ **Last updated:** [February 19, 2015, 3:02am UTC](https://forum.inductiveautomation.com/t/data-from-dataset-to-another-dataset/9725 "2015-02-19T03:02:48Z")
I have a dataset that uses a SQL query to bring in a running total from a flow meter for every previous day of the month at midnight. Example: day31 24:00:00 800 gpm day1 24:00:00 1000 gpm day2 24:00:00 1500 gpm da… --- ## [Deployment practices](https://forum.inductiveautomation.com/t/deployment-practices/9723)
**Author:** [@bellm](https://forum.inductiveautomation.com/u/bellm)\ **Replies:** 4\ **Last updated:** [February 19, 2015, 2:40am UTC](https://forum.inductiveautomation.com/t/deployment-practices/9723 "2015-02-19T02:40:30Z")
I am new to Ignition and wanted to know what the best work flow for developing and deploying it on our product would be. So currently what I have done is I developed the screens and tested them at my desk using my lapt… --- ## [Limit to SFC instances?](https://forum.inductiveautomation.com/t/limit-to-sfc-instances/9703)
**Author:** [@HCIdivision17](https://forum.inductiveautomation.com/u/HCIdivision17)\ **Replies:** 3\ **Last updated:** [February 18, 2015, 4:10pm UTC](https://forum.inductiveautomation.com/t/limit-to-sfc-instances/9703 "2015-02-18T16:10:39Z")
What order of magnitude of sequential function chart instances starts to become "too many"? To illustrate, I would like to begin a network transaction and wait for it to change state. As it clicks along, I want an SFC … --- ## [Report Viewer add dataset](https://forum.inductiveautomation.com/t/report-viewer-add-dataset/9690)
**Author:** [@heikki](https://forum.inductiveautomation.com/u/heikki)\ **Replies:** 3\ **Last updated:** [February 18, 2015, 11:35am UTC](https://forum.inductiveautomation.com/t/report-viewer-add-dataset/9690 "2015-02-18T11:35:13Z")
Hi, I'm trying to create basic template for report view. The problem is that my report should include dataset from custom property, which may have columns from one to n. For what I have learned from report view compone… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1495) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1497)