# Ignition **URL:** https://forum.inductiveautomation.com/c/ignition/6.md?page=1615 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1616 --- ## [Show file stored in Database](https://forum.inductiveautomation.com/t/show-file-stored-in-database/4790)
**Author:** [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\ **Replies:** 8\ **Last updated:** [July 11, 2012, 1:01pm UTC](https://forum.inductiveautomation.com/t/show-file-stored-in-database/4790 "2012-07-11T13:01:26Z")
I'm having trouble getting a BLOB file from the database to show in the client. Has anyone done this? I've been able to write file to the database but not able to view them. --- ## [Writing Historical Data to Database - Problem with 7.3](https://forum.inductiveautomation.com/t/writing-historical-data-to-database-problem-with-7-3/3990)
**Author:** [@PeterThornton](https://forum.inductiveautomation.com/u/PeterThornton)\ **Replies:** 4\ **Last updated:** [July 10, 2012, 8:35pm UTC](https://forum.inductiveautomation.com/t/writing-historical-data-to-database-problem-with-7-3/3990 "2012-07-10T20:35:52Z")
I have a script which imports data from CSV files and inserts it directly into the History Partition tables. Since we upgraded to 7.3.3 at the start of February, this functionality has stopped working. My script is still… --- ## [Remove date/time from table](https://forum.inductiveautomation.com/t/remove-date-time-from-table/4799)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 1\ **Last updated:** [July 10, 2012, 6:14pm UTC](https://forum.inductiveautomation.com/t/remove-date-time-from-table/4799 "2012-07-10T18:14:53Z")
I have a table with multiple columns including date/time, when I need to clear all values in a given row I just set the tag for each cell to zero ie: (system.tag.writeToTag('M100', 0) but im not sure how to clear the dat… --- ## [Database start up](https://forum.inductiveautomation.com/t/database-start-up/4798)
**Author:** [@titus](https://forum.inductiveautomation.com/u/titus)\ **Replies:** 4\ **Last updated:** [July 10, 2012, 5:19pm UTC](https://forum.inductiveautomation.com/t/database-start-up/4798 "2012-07-10T17:19:50Z")
How do i go about starting up this database thing so that i can use the easy chart to trend values from the tags i have --- ## [Sqltag history with value timestamp](https://forum.inductiveautomation.com/t/sqltag-history-with-value-timestamp/4796)
**Author:** [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Replies:** 1\ **Last updated:** [July 10, 2012, 4:35pm UTC](https://forum.inductiveautomation.com/t/sqltag-history-with-value-timestamp/4796 "2012-07-10T16:35:55Z")
Hi, With 7.5.0 (and beta5 7.5.1), it is no more possible to use the value time stamp with sqltag history. As soon as you select this option, a new scanclass is created “exempt” is created in sqlth\_scinfo and associated… --- ## [Function to Refresh Providers?](https://forum.inductiveautomation.com/t/function-to-refresh-providers/4758)
**Author:** [@JohnLynx](https://forum.inductiveautomation.com/u/JohnLynx)\ **Replies:** 2\ **Last updated:** [July 10, 2012, 3:52pm UTC](https://forum.inductiveautomation.com/t/function-to-refresh-providers/4758 "2012-07-10T15:52:48Z")
bump I'm in a situation where I'll need an HMI button capable of refreshing tags for my client. The application is set up with Kepware communicating via radio set at a low scan rate. Mainly a way to reinitialize t… --- ## [Ubuntu update uninstalls license](https://forum.inductiveautomation.com/t/ubuntu-update-uninstalls-license/4797)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 3\ **Last updated:** [July 10, 2012, 3:27pm UTC](https://forum.inductiveautomation.com/t/ubuntu-update-uninstalls-license/4797 "2012-07-10T15:27:04Z")
So I'm on site and notice that the gateway (running on Ubuntu) needs serveral months of patches installed. I do that, reboot (required due to new kernel), and the gateway is in trial mode and there is no sign of the inst… --- ## [Help for custom Driver](https://forum.inductiveautomation.com/t/help-for-custom-driver/4788)
**Author:** [@GermainN](https://forum.inductiveautomation.com/u/GermainN)\ **Replies:** 5\ **Last updated:** [July 10, 2012, 8:23am UTC](https://forum.inductiveautomation.com/t/help-for-custom-driver/4788 "2012-07-10T08:23:01Z")
Hi, I’m implementing a custom driver that reads a HTML page in a equipement that has an embedded web server. This driver just reads the datas in a table in this page, create the opc-ua nodes on connect() with the heade… --- ## [Available Historical Tags in a chert property binding](https://forum.inductiveautomation.com/t/available-historical-tags-in-a-chert-property-binding/4791)
**Author:** [@phassler](https://forum.inductiveautomation.com/u/phassler)\ **Replies:** 3\ **Last updated:** [July 10, 2012, 2:04am UTC](https://forum.inductiveautomation.com/t/available-historical-tags-in-a-chert-property-binding/4791 "2012-07-10T02:04:00Z")
I am seeing duplicate tags in the ‘Available Historical Tags’ list when binding a tag history to a chart. I think this has something to do with retired tags in the sqlth\_te table. I was making a number of changes as… --- ## [runScript in tag expression](https://forum.inductiveautomation.com/t/runscript-in-tag-expression/4786)
**Author:** [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\ **Replies:** 2\ **Last updated:** [July 9, 2012, 9:15pm UTC](https://forum.inductiveautomation.com/t/runscript-in-tag-expression/4786 "2012-07-09T21:15:47Z")
Hi, Is it possible to put a runScript who call a function module in a tag? The call works well in a button and a link property. But does not work in the expression of a tag, this is my error image. Thanks. --- ## [PDF Viewer Blurry](https://forum.inductiveautomation.com/t/pdf-viewer-blurry/4785)
**Author:** [@richrich](https://forum.inductiveautomation.com/u/richrich)\ **Replies:** 6\ **Last updated:** [July 9, 2012, 8:48pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-blurry/4785 "2012-07-09T20:48:23Z")
Hello, I have installed a demo version of Ignition V7.5.0. I have a PDF document loaded into the PDF Viewer. The rendering of the text in the PDF file is blurry as if when reading the file, ignition converted it to a… --- ## [Reading CLICK Modbus Analogs](https://forum.inductiveautomation.com/t/reading-click-modbus-analogs/4789)
**Author:** [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Replies:** 5\ **Last updated:** [July 9, 2012, 5:24pm UTC](https://forum.inductiveautomation.com/t/reading-click-modbus-analogs/4789 "2012-07-09T17:24:08Z")
I’m trying to read a couple of analog values from a CLICK plc. I am able to read and write the discrete vales but all analog values I try to read come back as 0. I have tried reading the address 428673 as both Float an… --- ## [Serial Module Download](https://forum.inductiveautomation.com/t/serial-module-download/4784)
**Author:** [@mcgheeiv](https://forum.inductiveautomation.com/u/mcgheeiv)\ **Replies:** 1\ **Last updated:** [July 7, 2012, 4:28pm UTC](https://forum.inductiveautomation.com/t/serial-module-download/4784 "2012-07-07T16:28:53Z")
Downloaded the serial module from the download page for some proof of principle testing but quickly ran into errors (Port XXXX not open) and found the following topic: viewtopic.php?f=70&t=8358&p=27028 Since I had no… --- ## [Problem with Data Types instances](https://forum.inductiveautomation.com/t/problem-with-data-types-instances/4757)
**Author:** [@2Gi\_Technologie](https://forum.inductiveautomation.com/u/2Gi_Technologie)\ **Replies:** 6\ **Last updated:** [July 7, 2012, 7:28am UTC](https://forum.inductiveautomation.com/t/problem-with-data-types-instances/4757 "2012-07-07T07:28:51Z")
hi, My first instance is ok :: {uf} is solve The second is bad, the third and all other. if I only instance it works. you can see on the image. Thanks. --- ## [Alarm history demo screen and acknowledgements](https://forum.inductiveautomation.com/t/alarm-history-demo-screen-and-acknowledgements/4782)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 1\ **Last updated:** [July 6, 2012, 11:14pm UTC](https://forum.inductiveautomation.com/t/alarm-history-demo-screen-and-acknowledgements/4782 "2012-07-06T23:14:21Z")
I have imported the alarm history screen from the demo application into my application because we want to use the date range feature. I am using my alarm database and displaying alarms ok. However, it appears that the a… --- ## [TypeError: Unable to convert row x, column y to type class](https://forum.inductiveautomation.com/t/typeerror-unable-to-convert-row-x-column-y-to-type-class/4781)
**Author:** [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\ **Replies:** 1\ **Last updated:** [July 6, 2012, 9:25pm UTC](https://forum.inductiveautomation.com/t/typeerror-unable-to-convert-row-x-column-y-to-type-class/4781 "2012-07-06T21:25:57Z")
Using the following data, why am I getting the error that follows it? header: \['id', 'flags', 'group', 'displayname', 'devicename', 'lastpolltime', 'lastpolltime\_alm', 'ap', 'ap\_alm', 'tf', 'tf\_alm', 'dp', 'dp\_alm', '… --- ## [ControlLogix "Browse Pending" Issues on Server Reboot](https://forum.inductiveautomation.com/t/controllogix-browse-pending-issues-on-server-reboot/4777)
**Author:** [@bpirtle](https://forum.inductiveautomation.com/u/bpirtle)\ **Replies:** 4\ **Last updated:** [July 6, 2012, 8:31pm UTC](https://forum.inductiveautomation.com/t/controllogix-browse-pending-issues-on-server-reboot/4777 "2012-07-06T20:31:42Z")
We are having some issues with some OPC-UA data collectors getting permanently "stuck" at "Connected" state with "Browse Pending" status and no data available to clients. Please see attached screenshots with more infor… --- ## [Print to Image](https://forum.inductiveautomation.com/t/print-to-image/4767)
**Author:** [@Jerry\_H](https://forum.inductiveautomation.com/u/Jerry_H)\ **Replies:** 11\ **Last updated:** [July 6, 2012, 1:44pm UTC](https://forum.inductiveautomation.com/t/print-to-image/4767 "2012-07-06T13:44:57Z")
I would like to print to Image an Active X (IE) window. All works except the Active X (IE) is Blank. --- ## [Role priority](https://forum.inductiveautomation.com/t/role-priority/4768)
**Author:** [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Replies:** 3\ **Last updated:** [July 6, 2012, 11:04am UTC](https://forum.inductiveautomation.com/t/role-priority/4768 "2012-07-06T11:04:05Z")
Hello! Is there a way to establish role preferences in Ignition. To explain it better, if I have installed ignition with 4 users license, and there's 4 people connected to that server using the role 'User', and I am th… --- ## [Historizing tags](https://forum.inductiveautomation.com/t/historizing-tags/4761)
**Author:** [@SamJaimes](https://forum.inductiveautomation.com/u/SamJaimes)\ **Replies:** 6\ **Last updated:** [July 6, 2012, 10:59am UTC](https://forum.inductiveautomation.com/t/historizing-tags/4761 "2012-07-06T10:59:23Z")
Hello everyone! Does any knows what is the limit historizing tags with SQL Historian? and with the Historical Group? Thanks! --- ## [Expected ';'](https://forum.inductiveautomation.com/t/expected/4765)
**Author:** [@Ehren](https://forum.inductiveautomation.com/u/Ehren)\ **Replies:** 4\ **Last updated:** [July 6, 2012, 1:57am UTC](https://forum.inductiveautomation.com/t/expected/4765 "2012-07-06T01:57:59Z")
Hey guys, I hope this is in the right section... This is probably a simple fix; each time we start a client or designer NOT locally on the server (i.e. from my laptop connected to the same switch or other PC on the … --- ## [Indirect tag string?](https://forum.inductiveautomation.com/t/indirect-tag-string/4774)
**Author:** [@cja7928](https://forum.inductiveautomation.com/u/cja7928)\ **Replies:** 2\ **Last updated:** [July 5, 2012, 8:42pm UTC](https://forum.inductiveautomation.com/t/indirect-tag-string/4774 "2012-07-05T20:42:22Z")
how would I write a value to a tag where the tag name changes depending on a variable? example: I have a bunch of tags - 'PN001' through 'PN100' and I have a variable that defines what the number portion of the tag… --- ## [Database Connection Failing with high CPU Usage](https://forum.inductiveautomation.com/t/database-connection-failing-with-high-cpu-usage/4743)
**Author:** [@Brett\_Yeomans](https://forum.inductiveautomation.com/u/Brett_Yeomans)\ **Replies:** 8\ **Last updated:** [July 5, 2012, 6:43pm UTC](https://forum.inductiveautomation.com/t/database-connection-failing-with-high-cpu-usage/4743 "2012-07-05T18:43:41Z")
We have a problem where the database connection keeps faulting. Existing graphs fail to load and if left on screen “Loading” the connection faults with “Cannot get a connection, pool error Timeout waiting for idle objec… --- ## [SQL Query Lookup](https://forum.inductiveautomation.com/t/sql-query-lookup/4773)
**Author:** [@drettberg](https://forum.inductiveautomation.com/u/drettberg)\ **Replies:** 2\ **Last updated:** [July 5, 2012, 6:37pm UTC](https://forum.inductiveautomation.com/t/sql-query-lookup/4773 "2012-07-05T18:37:26Z")
I want to filter a SQL Query on a table using the 2nd column of the selected item in a list. SELECT a\_LongName FROM Employee WHERE HomeLocation\_ID = {Root Container.Locations.data}\[{Root Container.Locations.data},1\] … --- ## [Client Tags Not Reading](https://forum.inductiveautomation.com/t/client-tags-not-reading/4741)
**Author:** [@gadgetguru69](https://forum.inductiveautomation.com/u/gadgetguru69)\ **Replies:** 5\ **Last updated:** [July 5, 2012, 6:03pm UTC](https://forum.inductiveautomation.com/t/client-tags-not-reading/4741 "2012-07-05T18:03:18Z")
Well i have came across a wierd one today. We are running 7.5 with 2 projects running. We are having issues with the clients not reading OPC data when they are started up. You can let it set for several minutes and somet… --- ## [Email Alert, dynamic recipients](https://forum.inductiveautomation.com/t/email-alert-dynamic-recipients/4766)
**Author:** [@marioquark](https://forum.inductiveautomation.com/u/marioquark)\ **Replies:** 2\ **Last updated:** [July 5, 2012, 5:53pm UTC](https://forum.inductiveautomation.com/t/email-alert-dynamic-recipients/4766 "2012-07-05T17:53:13Z")
I need to specify an address list for alarms for each project. This list should be updated via screen, so i need a mem tag or db data. I've noticed the recipients in the alert profile are not writable by the client and… --- ## [SQL formating](https://forum.inductiveautomation.com/t/sql-formating/4769)
**Author:** [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\ **Replies:** 2\ **Last updated:** [July 5, 2012, 5:50pm UTC](https://forum.inductiveautomation.com/t/sql-formating/4769 "2012-07-05T17:50:52Z")
I have a textbox bound to this SQL query: SELECT TOP 1 "{Root Container.MotorID}" FROM dbo.motorrun ORDER BY t\_stamp DESC which will select a float8 value from my table. I want to change the format of this value for th… --- ## [SQL Syntax error](https://forum.inductiveautomation.com/t/sql-syntax-error/4770)
**Author:** [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\ **Replies:** 3\ **Last updated:** [July 5, 2012, 5:28pm UTC](https://forum.inductiveautomation.com/t/sql-syntax-error/4770 "2012-07-05T17:28:16Z")
param1 = event.source.parent.getComponent('Container').getComponent('Group').getComponent('lblJobNumber').text param2 = results system.nav.openWindow('Popups/Create New Wroker Order', {'jobNumber' : param1}) system.nav.… --- ## [Allowing users to change their password from Client](https://forum.inductiveautomation.com/t/allowing-users-to-change-their-password-from-client/4764)
**Author:** [@jrice](https://forum.inductiveautomation.com/u/jrice)\ **Replies:** 3\ **Last updated:** [July 5, 2012, 4:59pm UTC](https://forum.inductiveautomation.com/t/allowing-users-to-change-their-password-from-client/4764 "2012-07-05T16:59:45Z")
Is there a way to allow users to change their password from a client? Haven't been able to find a script or other method of doing this. Thanks, Jeff --- ## [Modbus bit in word write](https://forum.inductiveautomation.com/t/modbus-bit-in-word-write/4762)
**Author:** [@Paul](https://forum.inductiveautomation.com/u/Paul)\ **Replies:** 3\ **Last updated:** [July 5, 2012, 3:45pm UTC](https://forum.inductiveautomation.com/t/modbus-bit-in-word-write/4762 "2012-07-05T15:45:26Z")
Is it possible to bit write into a word using latest version of Ignition by the way of Modbus I/P? It seems to read bits correctly however it does not wish to write them. The limited success I do have in writing seems to… [Previous page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1614) [Next page](https://forum.inductiveautomation.com/c/ignition/6.md?page=1616)