# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1564 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1565 --- ## [Sqltag property and pointer to tags](https://forum.inductiveautomation.com/t/sqltag-property-and-pointer-to-tags/6895)
**Author:** [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Replies:** 1\ **Last updated:** [August 12, 2013, 6:12pm UTC](https://forum.inductiveautomation.com/t/sqltag-property-and-pointer-to-tags/6895 "2013-08-12T18:12:58Z")
Sqltag properties fields (string, datetime int,...) and a new kind of type : a pointer to another sqltag in order to configure some links beetween tags --- ## [Can I import my sql database to Iginition database?](https://forum.inductiveautomation.com/t/can-i-import-my-sql-database-to-iginition-database/7013)
**Author:** [@hlee](https://forum.inductiveautomation.com/u/hlee)\ **Replies:** 1\ **Last updated:** [August 12, 2013, 3:44pm UTC](https://forum.inductiveautomation.com/t/can-i-import-my-sql-database-to-iginition-database/7013 "2013-08-12T15:44:25Z")
I am trying to replicate HMI we have in Ignition. I need to move the past data in my sql database to Ignition database first. Is this possible? Thanks in advance! --- ## [GMail Alert Notification Error](https://forum.inductiveautomation.com/t/gmail-alert-notification-error/7007)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 2\ **Last updated:** [August 10, 2013, 1:53pm UTC](https://forum.inductiveautomation.com/t/gmail-alert-notification-error/7007 "2013-08-10T13:53:28Z")
Hi I am testing out the new alerting/Pipelines in 7.6.2 and I am getting this error when ever I try to send an Email notification. I am using the same server setting as my legacy system 7.5.7 which is sending e-mails o… --- ## [Bar chart](https://forum.inductiveautomation.com/t/bar-chart/6805)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 1\ **Last updated:** [August 9, 2013, 10:56pm UTC](https://forum.inductiveautomation.com/t/bar-chart/6805 "2013-08-09T22:56:58Z")
Is there any way to keep my y axis auto ranged but only keep integer scaling? I am showing counts and do not need fractional values displayed. --- ## [Expression date](https://forum.inductiveautomation.com/t/expression-date/7012)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 0\ **Last updated:** [August 9, 2013, 7:44pm UTC](https://forum.inductiveautomation.com/t/expression-date/7012 "2013-08-09T19:44:38Z")
I have a DateTime tag inside my UDT which I would like to be a date depending on another tag within my UDT and I had thought to use this: forceQuality(if(hasChanged({\[.\]stateWatch}), coalesce(now(),0), coalesce({\[.\]Se… --- ## [No tag value](https://forum.inductiveautomation.com/t/no-tag-value/7010)
**Author:** [@cacordova](https://forum.inductiveautomation.com/u/cacordova)\ **Replies:** 1\ **Last updated:** [August 9, 2013, 7:36pm UTC](https://forum.inductiveautomation.com/t/no-tag-value/7010 "2013-08-09T19:36:36Z")
Hi, I setup a modbus tcp driver device on Ignition and it's connected. Then I added the the "Is Connected" tag and it's also enabled, but when I try and add a tag like V2010 there's no value, the tag diagnostic is either… --- ## [Tag change script runs when saving](https://forum.inductiveautomation.com/t/tag-change-script-runs-when-saving/7002)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 3\ **Last updated:** [August 8, 2013, 8:32pm UTC](https://forum.inductiveautomation.com/t/tag-change-script-runs-when-saving/7002 "2013-08-08T20:32:30Z")
I have a tag change script that sends out an email. Every time I save and publish a change everyone on the list recieves an erroneous email. the script runs even though the tags value hasn't changed. Is there a way to … --- ## [Launch Icon Scaling/Proportions](https://forum.inductiveautomation.com/t/launch-icon-scaling-proportions/6370)
**Author:** [@Ehren](https://forum.inductiveautomation.com/u/Ehren)\ **Replies:** 10\ **Last updated:** [August 8, 2013, 4:11pm UTC](https://forum.inductiveautomation.com/t/launch-icon-scaling-proportions/6370 "2013-08-08T16:11:17Z")
Hey gents, this morning I have updated my current project’s install version from 7.5.5(b1255) to 7.5.7(b1387) in order to try to use v1.5 of the IALabs PDF Viewer (which the marketplace won’t serve me the correct file, o… --- ## [Problem with createSProcCall and MS SQL Procedure parameters](https://forum.inductiveautomation.com/t/problem-with-createsproccall-and-ms-sql-procedure-parameters/7004)
**Author:** [@Mike.Covington](https://forum.inductiveautomation.com/u/Mike.Covington)\ **Replies:** 0\ **Last updated:** [August 8, 2013, 12:44pm UTC](https://forum.inductiveautomation.com/t/problem-with-createsproccall-and-ms-sql-procedure-parameters/7004 "2013-08-08T12:44:57Z")
I have come across an issue with createSProcCall and calling MS-SQL stored procedures that have defaulted parameters. When passing in named or indexed parameters with registerInParam, it seems that you have to explicitly… --- ## [Format/Animation Copier](https://forum.inductiveautomation.com/t/format-animation-copier/7003)
**Author:** [@ccooper](https://forum.inductiveautomation.com/u/ccooper)\ **Replies:** 0\ **Last updated:** [August 8, 2013, 12:13pm UTC](https://forum.inductiveautomation.com/t/format-animation-copier/7003 "2013-08-08T12:13:50Z")
I have used other HMI packages that have a Format and Animation Copy feature that proved to be extremely handy when developing. This pertains to text and other simple objects on the screen. Get an object formatted (color… --- ## [Pro Soft Card With Allen Bradley SLC 5/03](https://forum.inductiveautomation.com/t/pro-soft-card-with-allen-bradley-slc-5-03/4118)
**Author:** [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\ **Replies:** 2\ **Last updated:** [August 7, 2013, 11:05pm UTC](https://forum.inductiveautomation.com/t/pro-soft-card-with-allen-bradley-slc-5-03/4118 "2013-08-07T23:05:39Z")
Has anyone used a Pro Soft MVI46-DFNT Ethernet I/P card to communicate to Ignition? Talking with Pro Soft they say It acts like a SLC 5/05 so would Ignitions SLC driver work with this card? --- ## [On-Call Rosters - Can we select a specific Contact Info?](https://forum.inductiveautomation.com/t/on-call-rosters-can-we-select-a-specific-contact-info/6998)
**Author:** [@RRRancher](https://forum.inductiveautomation.com/u/RRRancher)\ **Replies:** 0\ **Last updated:** [August 7, 2013, 6:57pm UTC](https://forum.inductiveautomation.com/t/on-call-rosters-can-we-select-a-specific-contact-info/6998 "2013-08-07T18:57:12Z")
We have users in the User Sources. And when we build a call roster, we select a user source and then select one or more users from that user source for the roster. If the user has more than one Contact Info profile, th… --- ## [Option to specify size, gui input message box scripting](https://forum.inductiveautomation.com/t/option-to-specify-size-gui-input-message-box-scripting/6995)
**Author:** [@jtx2](https://forum.inductiveautomation.com/u/jtx2)\ **Replies:** 1\ **Last updated:** [August 7, 2013, 4:04pm UTC](https://forum.inductiveautomation.com/t/option-to-specify-size-gui-input-message-box-scripting/6995 "2013-08-07T16:04:27Z")
We use touchscreens with frequent operator interactions using input, message, etc. boxes. It would be very helpful if the gui scripting functions would include size paramaters, ex. system.gui.inputBox(message, defaultTex… --- ## [Create a sql table script](https://forum.inductiveautomation.com/t/create-a-sql-table-script/6990)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 2\ **Last updated:** [August 6, 2013, 7:15pm UTC](https://forum.inductiveautomation.com/t/create-a-sql-table-script/6990 "2013-08-06T19:15:34Z")
I would like to create a table using an event driven script so that I might make future installations require only the Ignition backup instead of restoring irrelevant data to my fresh databases. So I want to have a way o… --- ## [Convert milliseconds to Hour:Minute:Second format](https://forum.inductiveautomation.com/t/convert-milliseconds-to-hour-minute-second-format/6982)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 3\ **Last updated:** [August 6, 2013, 2:39pm UTC](https://forum.inductiveautomation.com/t/convert-milliseconds-to-hour-minute-second-format/6982 "2013-08-06T14:39:41Z")
I want to display the accumulated value in a timer in hour:minute:second format. Timer is in milliseconds and is an INT4 OPC tag. --- ## [Adding an extra ' to a SQL query](https://forum.inductiveautomation.com/t/adding-an-extra-to-a-sql-query/6984)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 1\ **Last updated:** [August 5, 2013, 9:38pm UTC](https://forum.inductiveautomation.com/t/adding-an-extra-to-a-sql-query/6984 "2013-08-05T21:38:00Z")
I have a calendar that picks a date, input for entering in shift begin and end. All of this gets concatenated to a where string. Works fine except I need to add an extra \` around the date/time sof the query doesn't do … --- ## [Pulling Stock Quotes into Ignition](https://forum.inductiveautomation.com/t/pulling-stock-quotes-into-ignition/6972)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 1\ **Last updated:** [August 5, 2013, 7:47pm UTC](https://forum.inductiveautomation.com/t/pulling-stock-quotes-into-ignition/6972 "2013-08-05T19:47:43Z")
What would be a way to go about pulling into NASDAQ values from the web? Something like what is shown here nasdaq.com/markets/rice.aspx --- ## [Dropdown list binding](https://forum.inductiveautomation.com/t/dropdown-list-binding/6970)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 5\ **Last updated:** [August 2, 2013, 5:15pm UTC](https://forum.inductiveautomation.com/t/dropdown-list-binding/6970 "2013-08-02T17:15:13Z")
I have a dropdown list which gets its data from a one column returning select query. I would like to add a static value to this list which does not come from the database. How can I append my dataset with this one value? … --- ## [\[Easy\] Storing PDF's](https://forum.inductiveautomation.com/t/easy-storing-pdfs/6961)
**Author:** [@randomranger](https://forum.inductiveautomation.com/u/randomranger)\ **Replies:** 7\ **Last updated:** [August 1, 2013, 11:40pm UTC](https://forum.inductiveautomation.com/t/easy-storing-pdfs/6961 "2013-08-01T23:40:53Z")
Hello there, I have what should be an easy question for you guys. I have many PDF's that I wish to have access to in ignition. I was wondering, what is the best way to store many (anywhere from 50 to over a thousand) PDF… --- ## [Issues with opening windows from a tree](https://forum.inductiveautomation.com/t/issues-with-opening-windows-from-a-tree/6789)
**Author:** [@chruby](https://forum.inductiveautomation.com/u/chruby)\ **Replies:** 1\ **Last updated:** [August 1, 2013, 9:05pm UTC](https://forum.inductiveautomation.com/t/issues-with-opening-windows-from-a-tree/6789 "2013-08-01T21:05:29Z")
I am having issues when I logout of a project and log back in that when I select a window from the tree it will open that window but it will highlight random windows in the tree. If I try to open the random window in th… --- ## [Table Word Wrap](https://forum.inductiveautomation.com/t/table-word-wrap/6938)
**Author:** [@allenr8](https://forum.inductiveautomation.com/u/allenr8)\ **Replies:** 5\ **Last updated:** [August 1, 2013, 8:35pm UTC](https://forum.inductiveautomation.com/t/table-word-wrap/6938 "2013-08-01T20:35:55Z")
Is it possible to get my text to wrap in a table? I have a SQL query and I'm pulling in four columns and one of them is a note column that can get quite lengthy. I have seen that you can put an in front of text to ge… --- ## [Historian Timestamp Interpretation](https://forum.inductiveautomation.com/t/historian-timestamp-interpretation/6946)
**Author:** [@apimente](https://forum.inductiveautomation.com/u/apimente)\ **Replies:** 3\ **Last updated:** [August 1, 2013, 7:39pm UTC](https://forum.inductiveautomation.com/t/historian-timestamp-interpretation/6946 "2013-08-01T19:39:01Z")
Dear Friends, I'd would like to know how can i interpret the timestamp value in the history tables. Ignition write a raw value and i want to convert this number into a human legible data and time value. Thanks in adv… --- ## [Is there a way to set a z-order for buttons?](https://forum.inductiveautomation.com/t/is-there-a-way-to-set-a-z-order-for-buttons/6952)
**Author:** [@Bob](https://forum.inductiveautomation.com/u/Bob)\ **Replies:** 4\ **Last updated:** [July 31, 2013, 9:39pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-set-a-z-order-for-buttons/6952 "2013-07-31T21:39:48Z")
I have an image with buttons on top of it. I am resizing/redrawing the image, but then the buttons are behind the image. Is there a way to keep the buttons in the foreground without having to re-add them to the window? … --- ## [Table selectedRow does not change when selecting interval](https://forum.inductiveautomation.com/t/table-selectedrow-does-not-change-when-selecting-interval/3818)
**Author:** [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\ **Replies:** 1\ **Last updated:** [July 31, 2013, 8:08pm UTC](https://forum.inductiveautomation.com/t/table-selectedrow-does-not-change-when-selecting-interval/3818 "2013-07-31T20:08:29Z")
If I have a table component with "single interval" selection mode, when I click and drag my mouse across multiple rows, or select additional rows by holding control or shift and clicking, the selectedRow propertyChange s… --- ## [\[Moderate\]\[EDIT2\] Display Picture in Table](https://forum.inductiveautomation.com/t/moderate-edit2-display-picture-in-table/6936)
**Author:** [@randomranger](https://forum.inductiveautomation.com/u/randomranger)\ **Replies:** 9\ **Last updated:** [July 31, 2013, 6:46pm UTC](https://forum.inductiveautomation.com/t/moderate-edit2-display-picture-in-table/6936 "2013-07-31T18:46:01Z")
I have a database table with a column of type BLOB. In this column I have inserted pictures. I simply want to know how to get the picture in the database to show up on a table. I searched around and nothing was of much h… --- ## [\[Easy\] Uploading to Gateway](https://forum.inductiveautomation.com/t/easy-uploading-to-gateway/6964)
**Author:** [@randomranger](https://forum.inductiveautomation.com/u/randomranger)\ **Replies:** 2\ **Last updated:** [July 31, 2013, 6:43pm UTC](https://forum.inductiveautomation.com/t/easy-uploading-to-gateway/6964 "2013-07-31T18:43:27Z")
Simple question. Is there anyway that I can upload a file to the gateway off of a client computer? And can I download to the client from the Gateway? If I missed anything please let me know. --- ## [Ignition Gateway Shutting down unexpectedly, repeatedly](https://forum.inductiveautomation.com/t/ignition-gateway-shutting-down-unexpectedly-repeatedly/6962)
**Author:** [@dfenter](https://forum.inductiveautomation.com/u/dfenter)\ **Replies:** 5\ **Last updated:** [July 31, 2013, 6:25pm UTC](https://forum.inductiveautomation.com/t/ignition-gateway-shutting-down-unexpectedly-repeatedly/6962 "2013-07-31T18:25:15Z")
We are having an issue where the ignition gateway is shutting down unexpectedly, and repeatedly. I have looked at the console, and it looks like something is triggering a gateway/project shutdown script. There are mult… --- ## [Restart Client via Script](https://forum.inductiveautomation.com/t/restart-client-via-script/6960)
**Author:** [@drettberg](https://forum.inductiveautomation.com/u/drettberg)\ **Replies:** 1\ **Last updated:** [July 31, 2013, 2:30pm UTC](https://forum.inductiveautomation.com/t/restart-client-via-script/6960 "2013-07-31T14:30:25Z")
I would like to execute a script from a window that will either restart the client or that will allow me to execute the client startup script. Is there a good way to do either of these? --- ## [Is there a way to force event to fire?](https://forum.inductiveautomation.com/t/is-there-a-way-to-force-event-to-fire/6951)
**Author:** [@Bob](https://forum.inductiveautomation.com/u/Bob)\ **Replies:** 3\ **Last updated:** [July 31, 2013, 1:31pm UTC](https://forum.inductiveautomation.com/t/is-there-a-way-to-force-event-to-fire/6951 "2013-07-31T13:31:27Z")
Is there a way to force an event to fire such as the mouseClicked or mousePressed event of a button? --- ## [Interactive client console](https://forum.inductiveautomation.com/t/interactive-client-console/6959)
**Author:** [@DomArmstrong](https://forum.inductiveautomation.com/u/DomArmstrong)\ **Replies:** 0\ **Last updated:** [July 31, 2013, 11:26am UTC](https://forum.inductiveautomation.com/t/interactive-client-console/6959 "2013-07-31T11:26:15Z")
Like a combination of the script playground and the diagnostics console (think Chrome console). Also being able to use pdb would be lovely. [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1563) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?no_subcategories=false&page=1565)