# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=10 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 11 --- ## [Strange behaviour in Factory SQL](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465)
**Author:** [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\ **Replies:** 5\ **Last updated:** [December 5, 2012, 6:03am UTC](https://forum.inductiveautomation.com/t/strange-behaviour-in-factory-sql/5465 "2012-12-05T06:03:00Z")
Hi, From last couple of months i am observing a strange behaviour in FSQL.In some store procedure groups data from some PLC tags is not coming. All tags are from the same PLC but still this issue appear. If i put same t… --- ## [Automatic Popups and Print jobs](https://forum.inductiveautomation.com/t/automatic-popups-and-print-jobs/1183)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 29\ **Last updated:** [November 30, 2012, 8:46pm UTC](https://forum.inductiveautomation.com/t/automatic-popups-and-print-jobs/1183 "2012-11-30T20:46:13Z")
I have this "PANELVIEW" made by a WONDERFUL company...... lol.... I am now trying to do away with it and replace it with a touchscreen computer. The only REAL function of this PV is to display a flow chart based on an … --- ## [Copy file from FTP server to New file in Machine](https://forum.inductiveautomation.com/t/copy-file-from-ftp-server-to-new-file-in-machine/4856)
**Author:** [@jmehta](https://forum.inductiveautomation.com/u/jmehta)\ **Replies:** 6\ **Last updated:** [November 21, 2012, 10:48pm UTC](https://forum.inductiveautomation.com/t/copy-file-from-ftp-server-to-new-file-in-machine/4856 "2012-11-21T22:48:05Z")
File on machine is getting created but not showing any data. Have Test.txt file on server and want to copy the content of it to new file on machine. Following is the code. def getTestFile(): import os import system f… --- ## [Data Loss FactorySQL-\>MSSQL](https://forum.inductiveautomation.com/t/data-loss-factorysql-mssql/5379)
**Author:** [@thaiauto](https://forum.inductiveautomation.com/u/thaiauto)\ **Replies:** 4\ **Last updated:** [November 21, 2012, 5:22pm UTC](https://forum.inductiveautomation.com/t/data-loss-factorysql-mssql/5379 "2012-11-21T17:22:53Z")
Hi, I am the end customer, our machine OEM use FactorySQL to link between Siemens PLC and MSSQL. I have an issue, some data which come already in the FactorySQL but it has not record into the MSSQL table. Could you … --- ## [Recommend SQL database](https://forum.inductiveautomation.com/t/recommend-sql-database/5269)
**Author:** [@Stuntman](https://forum.inductiveautomation.com/u/Stuntman)\ **Replies:** 3\ **Last updated:** [November 12, 2012, 5:15pm UTC](https://forum.inductiveautomation.com/t/recommend-sql-database/5269 "2012-11-12T17:15:37Z")
I am looking to implement ignition with a database for the first time. My question concerns whether to use a free or purchased database. I have completed projects in the past with Wonderware using a MS SQL Express databa… --- ## [MySQL Cloud databases?](https://forum.inductiveautomation.com/t/mysql-cloud-databases/5348)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 5\ **Last updated:** [November 5, 2012, 6:24pm UTC](https://forum.inductiveautomation.com/t/mysql-cloud-databases/5348 "2012-11-05T18:24:09Z")
We currently have MySQL with a few schemas running on Gateway server and we are thinking about possibly using hosted MySQL through Rackspace to lighten the load on our Ignition server and to have scalablilty for the futu… --- ## [MySQL db running outside of gateway](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356)
**Author:** [@rcorkern](https://forum.inductiveautomation.com/u/rcorkern)\ **Replies:** 3\ **Last updated:** [November 5, 2012, 6:23pm UTC](https://forum.inductiveautomation.com/t/mysql-db-running-outside-of-gateway/5356 "2012-11-05T18:23:01Z")
Has anyone tried running MySQL outside of the Ignition gateway? I'm curious to know what the drawbacks are of running MySQL on another server or in a hosted environment. We want to be scalable to run multiple projects a… --- ## [ControlLogix tags not visible](https://forum.inductiveautomation.com/t/controllogix-tags-not-visible/5333)
**Author:** [@CDRiley](https://forum.inductiveautomation.com/u/CDRiley)\ **Replies:** 10\ **Last updated:** [October 30, 2012, 8:17pm UTC](https://forum.inductiveautomation.com/t/controllogix-tags-not-visible/5333 "2012-10-30T20:17:53Z")
I have several ControlLogix connections that are operating normally. Once device, though, is giving problems. I can browse to the device, global tags, and I can see the "first tier" of some tags. Under that tier, we h… --- ## [MySQL 5.6 and Fractional Seconds in Timestamp Values](https://forum.inductiveautomation.com/t/mysql-5-6-and-fractional-seconds-in-timestamp-values/5351)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 1\ **Last updated:** [October 30, 2012, 7:06pm UTC](https://forum.inductiveautomation.com/t/mysql-5-6-and-fractional-seconds-in-timestamp-values/5351 "2012-10-30T19:06:38Z")
Seeing as Oracle hit RC status as of September, I was wondering if we'll be able to rely on Ignition using the added support for fractional seconds when passing a DateTime field. dev.mysql.com/doc/refman/5.6/en/ ... co… --- ## [ABB Commander 1900](https://forum.inductiveautomation.com/t/abb-commander-1900/5342)
**Author:** [@palmer\_md](https://forum.inductiveautomation.com/u/palmer_md)\ **Replies:** 1\ **Last updated:** [October 29, 2012, 3:00pm UTC](https://forum.inductiveautomation.com/t/abb-commander-1900/5342 "2012-10-29T15:00:11Z")
I have a customer who has a bunch of ABB Commander 1900 circular chart recorders that control their production line. They do not want to replace all this control with a PLC just yet, but want to do data collection. The… --- ## [Remote Connection with MYSQL](https://forum.inductiveautomation.com/t/remote-connection-with-mysql/5297)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 6\ **Last updated:** [October 20, 2012, 3:48pm UTC](https://forum.inductiveautomation.com/t/remote-connection-with-mysql/5297 "2012-10-20T15:48:24Z")
Hi, I have two PC each one have Ignition and MYSQL DB. As per attached(1) Diagram . 1- when i try to define MYSQL(1) in Ignition(2) it give me fault jdbc:mysql://192.168.3.3:3306/test and same when i defined MYSQL(2) … --- ## [FPMI Serialization Error](https://forum.inductiveautomation.com/t/fpmi-serialization-error/5034)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [September 17, 2012, 4:40pm UTC](https://forum.inductiveautomation.com/t/fpmi-serialization-error/5034 "2012-09-17T16:40:15Z")
I just started having this problem today. Some of my buttons, instead of going to their respective screens, will come up with a serialization error. Here is the text from the error message. com.inductiveautomation.facto… --- ## [MySql install Parameters](https://forum.inductiveautomation.com/t/mysql-install-parameters/5144)
**Author:** [@NetNathan](https://forum.inductiveautomation.com/u/NetNathan)\ **Replies:** 2\ **Last updated:** [September 14, 2012, 10:53pm UTC](https://forum.inductiveautomation.com/t/mysql-install-parameters/5144 "2012-09-14T22:53:26Z")
When installing MySQL to use with Ignition, are there any install parameters that are important.. to make sure it communicates effectively with Ignition? --- ## [Modbus Addressing in a Data Type Structure](https://forum.inductiveautomation.com/t/modbus-addressing-in-a-data-type-structure/5128)
**Author:** [@email4jab](https://forum.inductiveautomation.com/u/email4jab)\ **Replies:** 0\ **Last updated:** [September 11, 2012, 4:37pm UTC](https://forum.inductiveautomation.com/t/modbus-addressing-in-a-data-type-structure/5128 "2012-09-11T16:37:39Z")
Hello, I'd like to set up a Data Type, reference an address as a parameter (FirstAddress) type Integer and then reference that address with an offset to each tag in the structure. For example if my Data Type was all Bool… --- ## [Hide Table Column if no values exist](https://forum.inductiveautomation.com/t/hide-table-column-if-no-values-exist/5119)
**Author:** [@jkrugerud](https://forum.inductiveautomation.com/u/jkrugerud)\ **Replies:** 0\ **Last updated:** [September 7, 2012, 5:17pm UTC](https://forum.inductiveautomation.com/t/hide-table-column-if-no-values-exist/5119 "2012-09-07T17:17:56Z")
I am running the following query to populate a table: \[size=85\]\[color=#FF0000\]SELECT \* FROM ( SELECT pvp.MaterialDescription, pvp.CurrentPrice, cb.ShortDesc FROM po\_vendor\_prices\_1270 as pvp JOIN Codes\_Branch as cb … --- ## [Modbus software tool](https://forum.inductiveautomation.com/t/modbus-software-tool/5050)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 0\ **Last updated:** [August 24, 2012, 3:48pm UTC](https://forum.inductiveautomation.com/t/modbus-software-tool/5050 "2012-08-24T15:48:34Z")
I found a free Modbus scanner that may be of use to others. The software can poll both serial and Ethernet devices and also includes a discovery tool. The data is reported in a variety of formats. Attached is a screen p… --- ## [Hollysys LM3106 Address Mapping Help](https://forum.inductiveautomation.com/t/hollysys-lm3106-address-mapping-help/5025)
**Author:** [@Ikeprof](https://forum.inductiveautomation.com/u/Ikeprof)\ **Replies:** 3\ **Last updated:** [August 17, 2012, 12:49am UTC](https://forum.inductiveautomation.com/t/hollysys-lm3106-address-mapping-help/5025 "2012-08-17T00:49:58Z")
Appreciate any help in advance. Connected just fine to a Hollysys LM3106 PLC Processor via ethernet to serial convertor. Am able to read coils just fine from the unit. Have 3 memory locations in the PLC that I am at… --- ## [FactorySQL Command Timeout](https://forum.inductiveautomation.com/t/factorysql-command-timeout/4984)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 3\ **Last updated:** [August 14, 2012, 5:33pm UTC](https://forum.inductiveautomation.com/t/factorysql-command-timeout/4984 "2012-08-14T17:33:16Z")
Hi it seems that factorysql is using the default 30 second command timeout with sql server. I have a group which executes every minute and take sometimes more than 30 seconds to execute, causing a timeout error. Coul… --- ## [How can i access MYSQL through web](https://forum.inductiveautomation.com/t/how-can-i-access-mysql-through-web/4926)
**Author:** [@tamerplc](https://forum.inductiveautomation.com/u/tamerplc)\ **Replies:** 2\ **Last updated:** [August 4, 2012, 8:19pm UTC](https://forum.inductiveautomation.com/t/how-can-i-access-mysql-through-web/4926 "2012-08-04T20:19:40Z")
is there any way to access mysql through web?? what is the steps for that?? as i am out side the office and need to make edit to my database i tried to use this link " jdbc:mysql://localhost:3306/test" host: IP addr… --- ## [Ethernet/IP and Profinet](https://forum.inductiveautomation.com/t/ethernet-ip-and-profinet/4927)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [August 4, 2012, 7:41am UTC](https://forum.inductiveautomation.com/t/ethernet-ip-and-profinet/4927 "2012-08-04T07:41:03Z")
Is it correct that the current Allen Bradley Ignition driver is basically an implementation of an Ethernet/IP driver and the Siemens driver an implementation of a Profinet driver? If this is correct, is it reasonably st… --- ## [Calender Dataset](https://forum.inductiveautomation.com/t/calender-dataset/4919)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 1\ **Last updated:** [August 2, 2012, 12:30am UTC](https://forum.inductiveautomation.com/t/calender-dataset/4919 "2012-08-02T00:30:03Z")
id = event.source.parent.id Minfo = event.source.parent.getComponent('All one string').text Mcolor = event.source.parent.getComponent('Selected Color').text Mstart\_time = event.source.parent.getComponent('Start time').te… --- ## [Allen Bradley SLC 503 DF1 to wireless](https://forum.inductiveautomation.com/t/allen-bradley-slc-503-df1-to-wireless/2943)
**Author:** [@Justin](https://forum.inductiveautomation.com/u/Justin)\ **Replies:** 8\ **Last updated:** [July 30, 2012, 12:29pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-slc-503-df1-to-wireless/2943 "2012-07-30T12:29:25Z")
Has anyone tried to setup an AB PLC SLC 503 to a wireless network with reliable results? I would need a wireless adapter that supports DF1 such as the AB Net-Eni or Moxa EIP 3270, only a wireless device. Justin --- ## [SQL Server 2012?](https://forum.inductiveautomation.com/t/sql-server-2012/3884)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 6\ **Last updated:** [July 25, 2012, 10:52pm UTC](https://forum.inductiveautomation.com/t/sql-server-2012/3884 "2012-07-25T22:52:13Z")
Has anybody tried SQL Server 2012 yet? Any problems or gotchas? --- ## [FTP File Truncated](https://forum.inductiveautomation.com/t/ftp-file-truncated/1715)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [July 20, 2012, 7:49pm UTC](https://forum.inductiveautomation.com/t/ftp-file-truncated/1715 "2012-07-20T19:49:25Z")
from ftplib import FTP ftp = FTP('address.com') # connect to host, default port ftp.login('username','password') # user anonymous, passwd anonymous@ filename = fpmi.file.getTempFile("gz") #create temp fi… --- ## [Hardware section](https://forum.inductiveautomation.com/t/hardware-section/4800)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 1\ **Last updated:** [July 13, 2012, 4:16pm UTC](https://forum.inductiveautomation.com/t/hardware-section/4800 "2012-07-13T16:16:37Z")
i think there should be a hardware category, at least on the board. Anyway I was looking at doing wireless serial with these: lantronix.com/device-network ... wibox.html Always helps to hear if someone else found a de… --- ## [Automatic System Restore](https://forum.inductiveautomation.com/t/automatic-system-restore/4776)
**Author:** [@dpagnutti](https://forum.inductiveautomation.com/u/dpagnutti)\ **Replies:** 1\ **Last updated:** [July 5, 2012, 10:51pm UTC](https://forum.inductiveautomation.com/t/automatic-system-restore/4776 "2012-07-05T22:51:04Z")
Hello, Does anyone know if there's a way to perform a system restore (\*.gwbk file) from a linux shell? The idea is that we want to install the same setup on multiple servers with as little user input as possible (and… --- ## [DH+ Gateway to Connect to SLC5/04 \[SOLVED\]](https://forum.inductiveautomation.com/t/dh-gateway-to-connect-to-slc5-04-solved/4281)
**Author:** [@Alan\_T](https://forum.inductiveautomation.com/u/Alan_T)\ **Replies:** 6\ **Last updated:** [July 5, 2012, 4:28pm UTC](https://forum.inductiveautomation.com/t/dh-gateway-to-connect-to-slc5-04-solved/4281 "2012-07-05T16:28:12Z")
All, I am trying to connect Ignition to a SLC 5/04 and I am looking for a gateway device which will allow me to connect the SLC via DH+. The reason for the need to connect this way is due to Channel 0 being setup … --- ## [Booleans in table component](https://forum.inductiveautomation.com/t/booleans-in-table-component/4759)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 0\ **Last updated:** [July 3, 2012, 9:58pm UTC](https://forum.inductiveautomation.com/t/booleans-in-table-component/4759 "2012-07-03T21:58:32Z")
I'm experiencing an issue with booleans in a table component. (I'm using FactoryPMI Version: 3.3.1 (build 2549)) My table has 9 columns. The last 6 columns I want to handle as boolean values. The underlying values howe… --- ## [7.5 on ubuntu 10.10](https://forum.inductiveautomation.com/t/7-5-on-ubuntu-10-10/4706)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 13\ **Last updated:** [July 2, 2012, 6:36pm UTC](https://forum.inductiveautomation.com/t/7-5-on-ubuntu-10-10/4706 "2012-07-02T18:36:46Z")
I cannot seem to find the init.d file in the etc directory. java install seemed to go okay, and so far the igntion has too. im stuck. any help or info? i must have missed something or the file should be there.? I wante… --- ## [Write SQL Tabke](https://forum.inductiveautomation.com/t/write-sql-tabke/4727)
**Author:** [@Messias](https://forum.inductiveautomation.com/u/Messias)\ **Replies:** 2\ **Last updated:** [June 28, 2012, 6:30pm UTC](https://forum.inductiveautomation.com/t/write-sql-tabke/4727 "2012-06-28T18:30:41Z")
Hi, I need writing values that I'm reading online "PLC" to SQL table. Every time my table was modified, I have debouts correct scripts for this function. Tables= Pressure Process Column1= PS1 Column2= PS2 Thanks [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=9) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=11)