# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1451 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1452 --- ## [Can't Launch Client on Ignition Gateway PC](https://forum.inductiveautomation.com/t/cant-launch-client-on-ignition-gateway-pc/11648)
**Author:** [@hgarner](https://forum.inductiveautomation.com/u/hgarner)\ **Replies:** 2\ **Last updated:** [July 12, 2016, 5:52pm UTC](https://forum.inductiveautomation.com/t/cant-launch-client-on-ignition-gateway-pc/11648 "2016-07-12T17:52:17Z")
I am having an issue launching a client on the PC where Ignition is installed. I can launch the same client successfully from the Gateway homepage from another PC on the network. I have tried launching directly from the … --- ## [Best way to construct timestamp from elements](https://forum.inductiveautomation.com/t/best-way-to-construct-timestamp-from-elements/11919)
**Author:** [@george](https://forum.inductiveautomation.com/u/george)\ **Replies:** 1\ **Last updated:** [July 12, 2016, 2:45pm UTC](https://forum.inductiveautomation.com/t/best-way-to-construct-timestamp-from-elements/11919 "2016-07-12T14:45:46Z")
I want to construct a timestamp from individual elements (year, month, day, hour, minute, second). The elements are initially coming from a PLC and then I'm writing into a database. This script (admittedly with some ha… --- ## [Insert into SQL Server – use NULL vs. empty string?](https://forum.inductiveautomation.com/t/insert-into-sql-server-use-null-vs-empty-string/11917)
**Author:** [@bfaivre](https://forum.inductiveautomation.com/u/bfaivre)\ **Replies:** 1\ **Last updated:** [July 12, 2016, 8:34am UTC](https://forum.inductiveautomation.com/t/insert-into-sql-server-use-null-vs-empty-string/11917 "2016-07-12T08:34:20Z")
Hello, My table in SQL Server is setup not to allow NULL values. When using runPrepUpdate, if the text field I’m using is blank, runPrepUpdate inserts an empty string instead of using NULL. Is there a way to use NULL b… --- ## [Ignition OPC tag to translate int to value?](https://forum.inductiveautomation.com/t/ignition-opc-tag-to-translate-int-to-value/11916)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 1\ **Last updated:** [July 11, 2016, 3:44pm UTC](https://forum.inductiveautomation.com/t/ignition-opc-tag-to-translate-int-to-value/11916 "2016-07-11T15:44:01Z")
I have a memory register in a PLC that has an Int value that translates to a letter revision. I can make a script on the page that translate it at run time, or create a second expression tag that updates on change, but … --- ## [Timestamp source : System/Value](https://forum.inductiveautomation.com/t/timestamp-source-system-value/11876)
**Author:** [@Amarth](https://forum.inductiveautomation.com/u/Amarth)\ **Replies:** 5\ **Last updated:** [July 11, 2016, 7:01am UTC](https://forum.inductiveautomation.com/t/timestamp-source-system-value/11876 "2016-07-11T07:01:20Z")
Hello, I'm trying to save history of a boolean tag to the database, using the History function of the tag. As it is a boolean, I choosed the scanclass. Doing that, the Timestamp Source is greyed and set to "System" wh… --- ## [Add a new cursor to the chart module both displaying values](https://forum.inductiveautomation.com/t/add-a-new-cursor-to-the-chart-module-both-displaying-values/11909)
**Author:** [@rmdalisay](https://forum.inductiveautomation.com/u/rmdalisay)\ **Replies:** 2\ **Last updated:** [July 11, 2016, 12:02am UTC](https://forum.inductiveautomation.com/t/add-a-new-cursor-to-the-chart-module-both-displaying-values/11909 "2016-07-11T00:02:28Z")
Hi everyone! I have a similar question to this post: https://inductiveautomation.com/forum/viewtopic.php?f=50&t=13130&p=47840&hilit=two+cursors#p47840 I need to have another x-trace in my easy chart. I tested the Not… --- ## [7.8.3 vs 7.7.2 using PDF Viewer and JFrame/Swing](https://forum.inductiveautomation.com/t/7-8-3-vs-7-7-2-using-pdf-viewer-and-jframe-swing/11901)
**Author:** [@SteveW](https://forum.inductiveautomation.com/u/SteveW)\ **Replies:** 2\ **Last updated:** [July 8, 2016, 8:43am UTC](https://forum.inductiveautomation.com/t/7-8-3-vs-7-7-2-using-pdf-viewer-and-jframe-swing/11901 "2016-07-08T08:43:07Z")
I'm having an issue with an app when testing on 7.8.3. In the 7.7.2 version, we use the most recent version of the PDF Viewer module. The user selects an item to view and the PDF is displayed in a floating JFrame windo… --- ## [Leased Tags not going off scan](https://forum.inductiveautomation.com/t/leased-tags-not-going-off-scan/11908)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 1\ **Last updated:** [July 8, 2016, 2:36am UTC](https://forum.inductiveautomation.com/t/leased-tags-not-going-off-scan/11908 "2016-07-08T02:36:44Z")
Hi, I have set up 3 different leased scan classes to poll at different speeds. LeasedFast 500ms/2000ms Leased 1000ms/10000ms LeasedSlow 5000ms/30000ms I have been having pretty terrible communications … --- ## [Access regional variation of currently selected language?](https://forum.inductiveautomation.com/t/access-regional-variation-of-currently-selected-language/11902)
**Author:** [@Bob](https://forum.inductiveautomation.com/u/Bob)\ **Replies:** 2\ **Last updated:** [July 7, 2016, 7:28pm UTC](https://forum.inductiveautomation.com/t/access-regional-variation-of-currently-selected-language/11902 "2016-07-07T19:28:15Z")
Ignition 7.8.3 Windows Server 2012 I am testing localization using regional variations. I have different translation text for a Button component Text property. I have different translations for English (Canada) and E… --- ## [How do I make a manual sample form? updated](https://forum.inductiveautomation.com/t/how-do-i-make-a-manual-sample-form-updated/11893)
**Author:** [@iheartada](https://forum.inductiveautomation.com/u/iheartada)\ **Replies:** 1\ **Last updated:** [July 7, 2016, 4:15pm UTC](https://forum.inductiveautomation.com/t/how-do-i-make-a-manual-sample-form-updated/11893 "2016-07-07T16:15:45Z")
I am trying to make a manual sample entry form however I am stuck after I add the location selector and then definition selector. I am stuck on linking the attributes to the sample entry forms. Edit According to the … --- ## [Designer Starts with a lot of login windows](https://forum.inductiveautomation.com/t/designer-starts-with-a-lot-of-login-windows/11899)
**Author:** [@jruben84](https://forum.inductiveautomation.com/u/jruben84)\ **Replies:** 0\ **Last updated:** [July 6, 2016, 2:20pm UTC](https://forum.inductiveautomation.com/t/designer-starts-with-a-lot-of-login-windows/11899 "2016-07-06T14:20:30Z")
Hi, Before upgrading Ignition in our server, we tried it first by means of install a trial. The instalation was successfully done, the ignition service starts well but when I clic on “Iniciar Designer” (Start Designer) … --- ## [Store Image into SQL 2008](https://forum.inductiveautomation.com/t/store-image-into-sql-2008/11895)
**Author:** [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\ **Replies:** 2\ **Last updated:** [July 6, 2016, 12:39pm UTC](https://forum.inductiveautomation.com/t/store-image-into-sql-2008/11895 "2016-07-06T12:39:37Z")
I'm having an issue saving images to the sql 2008, I get an The index 2 is out of range error, my table has 2 columns ndx INT and image VARBINARY(max) below is the code I'm using, I have also attached the error code. p… --- ## [Close client through scripting](https://forum.inductiveautomation.com/t/close-client-through-scripting/11898)
**Author:** [@BrandonSHill](https://forum.inductiveautomation.com/u/BrandonSHill)\ **Replies:** 1\ **Last updated:** [July 6, 2016, 12:36pm UTC](https://forum.inductiveautomation.com/t/close-client-through-scripting/11898 "2016-07-06T12:36:56Z")
I'm attempting to create an onClick event on a component that will close the client. I want to disable the menu bar for aesthetics-sake, but still want to be able to close the client elsewhere. Any ideaas how to do thi… --- ## [Siemens UDT / Array](https://forum.inductiveautomation.com/t/siemens-udt-array/11897)
**Author:** [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\ **Replies:** 0\ **Last updated:** [July 6, 2016, 8:12am UTC](https://forum.inductiveautomation.com/t/siemens-udt-array/11897 "2016-07-06T08:12:17Z")
Hi, i have this atleast 1 DB that has an array 0..5, of an UDT, where a bunch of real's (float) are declared. I am trying to make a data type in ignition calling it "udtPumpSlag", and then add opc tags trying to match … --- ## [SQL null value Tag value change eventq](https://forum.inductiveautomation.com/t/sql-null-value-tag-value-change-eventq/11892)
**Author:** [@AHigginbotham](https://forum.inductiveautomation.com/u/AHigginbotham)\ **Replies:** 4\ **Last updated:** [July 5, 2016, 8:12pm UTC](https://forum.inductiveautomation.com/t/sql-null-value-tag-value-change-eventq/11892 "2016-07-05T20:12:39Z")
I'm having an issue with a change event triggering when the SQL sends a null Value This is my SQL call Select isnull(ps.OrderNumber,0) FROM DAL.dc.vCurrentPressStatus ps where Press = 'RC805' This is my Value Ch… --- ## [Database Rounding errors](https://forum.inductiveautomation.com/t/database-rounding-errors/11891)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 2\ **Last updated:** [July 5, 2016, 4:40pm UTC](https://forum.inductiveautomation.com/t/database-rounding-errors/11891 "2016-07-05T16:40:03Z")
is there an issue of rounding errors when using float math on database tables? Using MySQL and Ignition V7.8.2. I am keeping track of manually added ingredients added into fermentation tanks and updating an ingredient … --- ## [CSV format?](https://forum.inductiveautomation.com/t/csv-format/11890)
**Author:** [@StefanGronberg](https://forum.inductiveautomation.com/u/StefanGronberg)\ **Replies:** 1\ **Last updated:** [July 5, 2016, 2:57pm UTC](https://forum.inductiveautomation.com/t/csv-format/11890 "2016-07-05T14:57:27Z")
Hi, i have been trying to find in what format the CSV file needs to be to import into ignition. A straight export from Siemens TIA Portal gives a csv file that cant be directly imported. Right now the CSV file looks so… --- ## [Export dataset from tables with cells color?](https://forum.inductiveautomation.com/t/export-dataset-from-tables-with-cells-color/11888)
**Author:** [@aqua](https://forum.inductiveautomation.com/u/aqua)\ **Replies:** 1\ **Last updated:** [July 4, 2016, 4:09pm UTC](https://forum.inductiveautomation.com/t/export-dataset-from-tables-with-cells-color/11888 "2016-07-04T16:09:35Z")
Hello. I have dataset in table with different colors of cells based on difference of temperatures. The question is next: can I export dataset from table to some format (for example, HTML) with color cells? --- ## [New Ignition module and strange message](https://forum.inductiveautomation.com/t/new-ignition-module-and-strange-message/11554)
**Author:** [@thierry38](https://forum.inductiveautomation.com/u/thierry38)\ **Replies:** 4\ **Last updated:** [July 2, 2016, 1:56pm UTC](https://forum.inductiveautomation.com/t/new-ignition-module-and-strange-message/11554 "2016-07-02T13:56:37Z")
Hi, We’re working to developp a new Ignition driver module and we’re trying to solve an issue whose effect is to display a lot of strange “\[DeviceSubscriptionItem\] : No node set!” :cry: It’s occured after the followin… --- ## [system.print.createPrintJob](https://forum.inductiveautomation.com/t/system-print-createprintjob/11871)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 3\ **Last updated:** [June 30, 2016, 10:26pm UTC](https://forum.inductiveautomation.com/t/system-print-createprintjob/11871 "2016-06-30T22:26:42Z")
anyone have an example of how to use scripting function system.print.createPrintJob() to print a screen? I want to automatically print a window with an EasyChart based on an event from scripting. Thanks --- ## [List of scripting extensions / methods for HMI items?](https://forum.inductiveautomation.com/t/list-of-scripting-extensions-methods-for-hmi-items/11845)
**Author:** [@abishur](https://forum.inductiveautomation.com/u/abishur)\ **Replies:** 14\ **Last updated:** [June 30, 2016, 3:28pm UTC](https://forum.inductiveautomation.com/t/list-of-scripting-extensions-methods-for-hmi-items/11845 "2016-06-30T15:28:51Z")
I'm trying to make better use of / understand the scripting abilities of Ignition. Is there a comprehensive list of extensions and lists associated with the various HMI items? For example what all can I do with a cont… --- ## [Update a property when a tag changes](https://forum.inductiveautomation.com/t/update-a-property-when-a-tag-changes/11874)
**Author:** [@eyudes](https://forum.inductiveautomation.com/u/eyudes)\ **Replies:** 6\ **Last updated:** [June 30, 2016, 2:47pm UTC](https://forum.inductiveautomation.com/t/update-a-property-when-a-tag-changes/11874 "2016-06-30T14:47:17Z")
Hello everyone! I have a template that show two labels depending on a value. If the value is 1, the label1 is shown and the other one is hidden, in contrast, when is 2, the label2 is shown and label1 is hidden. To do i… --- ## [Problem changing text field via script](https://forum.inductiveautomation.com/t/problem-changing-text-field-via-script/11881)
**Author:** [@jsteward](https://forum.inductiveautomation.com/u/jsteward)\ **Replies:** 2\ **Last updated:** [June 30, 2016, 1:40pm UTC](https://forum.inductiveautomation.com/t/problem-changing-text-field-via-script/11881 "2016-06-30T13:40:20Z")
I'm sure I'm missing something very obvious, but I'm having a problem setting the .text property of a Text Field after a double click. I would like the current date / time to be entered into a Text field when the user d… --- ## [Audit log for User Management](https://forum.inductiveautomation.com/t/audit-log-for-user-management/11880)
**Author:** [@xion8x8](https://forum.inductiveautomation.com/u/xion8x8)\ **Replies:** 0\ **Last updated:** [June 30, 2016, 12:36am UTC](https://forum.inductiveautomation.com/t/audit-log-for-user-management/11880 "2016-06-30T00:36:06Z")
Hi All, Are there any audit log for user management in Ignition? (user create, user edit, etc) I cannot find it anywhere in Ignition. --- ## [Moving analog indicator: Set positive direction](https://forum.inductiveautomation.com/t/moving-analog-indicator-set-positive-direction/11873)
**Author:** [@richardNZ15](https://forum.inductiveautomation.com/u/richardNZ15)\ **Replies:** 2\ **Last updated:** [June 29, 2016, 9:22pm UTC](https://forum.inductiveautomation.com/t/moving-analog-indicator-set-positive-direction/11873 "2016-06-29T21:22:28Z")
I am using analog indicators to show position of servo drives. Say for instance i have a linear horizontal movement that spans 2000mm. I have drawn the screen to try and mimic the actual position in the plant. In this c… --- ## [How do I upload an image to the ignition image folder/db](https://forum.inductiveautomation.com/t/how-do-i-upload-an-image-to-the-ignition-image-folder-db/11875)
**Author:** [@Jhahn](https://forum.inductiveautomation.com/u/Jhahn)\ **Replies:** 1\ **Last updated:** [June 28, 2016, 8:14pm UTC](https://forum.inductiveautomation.com/t/how-do-i-upload-an-image-to-the-ignition-image-folder-db/11875 "2016-06-28T20:14:21Z")
I would like to be script a way for a user to be able to upload a picture to the ignition image folder currently its going to a network share and is kinda slow. I think pulling from the ignition image folder would be fa… --- ## [SQL query tag - tag path malformed](https://forum.inductiveautomation.com/t/sql-query-tag-tag-path-malformed/11853)
**Author:** [@jackswiggett](https://forum.inductiveautomation.com/u/jackswiggett)\ **Replies:** 1\ **Last updated:** [June 28, 2016, 2:42pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-tag-path-malformed/11853 "2016-06-28T14:42:12Z")
I have created a query tag called "P001\_settings" inside a folder called "Processes". It is connected to a MySQL data table with the query "SELECT \* from test.P001\_settings" (which is working as expected). I am trying t… --- ## [Writing Date and Time Periodically to Micrologix PLC](https://forum.inductiveautomation.com/t/writing-date-and-time-periodically-to-micrologix-plc/11817)
**Author:** [@dturner](https://forum.inductiveautomation.com/u/dturner)\ **Replies:** 4\ **Last updated:** [June 28, 2016, 1:06pm UTC](https://forum.inductiveautomation.com/t/writing-date-and-time-periodically-to-micrologix-plc/11817 "2016-06-28T13:06:40Z")
I am looking for a way to periodically write the date and time from the Ignition gateway to a Micrologix PLC. I am trying to sync the clocks. Can this be done using Ignition or will I need to find another solution? --- ## [Mitsubishi modbus addressing](https://forum.inductiveautomation.com/t/mitsubishi-modbus-addressing/11862)
**Author:** [@joshi.pradnya06](https://forum.inductiveautomation.com/u/joshi.pradnya06)\ **Replies:** 9\ **Last updated:** [June 28, 2016, 12:32pm UTC](https://forum.inductiveautomation.com/t/mitsubishi-modbus-addressing/11862 "2016-06-28T12:32:32Z")
I am using ignition v7.3.7 to read-write 16 bit integer tag to Mitsubishi PLC. My application requires an array of 100 to store 100 recipe tags. At present I have used 'D' datatype (for e.g D1000) for modbus addressing. … --- ## [Table Headers](https://forum.inductiveautomation.com/t/table-headers/11766)
**Author:** [@steven\_hargraves](https://forum.inductiveautomation.com/u/steven_hargraves)\ **Replies:** 10\ **Last updated:** [June 28, 2016, 12:03pm UTC](https://forum.inductiveautomation.com/t/table-headers/11766 "2016-06-28T12:03:20Z")
Greetings IA Forum My project has a lot of tables. I would like a better way to set the text in the table's header ? I am currently opening the table's 'Table Customiser' and typing 'Billet Number ' into the header fie… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1450) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1452)