# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=55 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 56 --- ## [Logging historical data from realtime tables in MySQL/FSQL](https://forum.inductiveautomation.com/t/logging-historical-data-from-realtime-tables-in-mysql-fsql/243)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [March 14, 2007, 5:04pm UTC](https://forum.inductiveautomation.com/t/logging-historical-data-from-realtime-tables-in-mysql-fsql/243 "2007-03-14T17:04:58Z")
I have 15 air units that are represented by 15 FactorySQL groups all logging to one table air\_units. I use the column AU in my WHERE clause to determine which air unit I want. Each air unit has 9 properties. What's the… --- ## [Info on DOS prompts in Windows XP](https://forum.inductiveautomation.com/t/info-on-dos-prompts-in-windows-xp/241)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [March 9, 2007, 1:26am UTC](https://forum.inductiveautomation.com/t/info-on-dos-prompts-in-windows-xp/241 "2007-03-09T01:26:43Z")
Here's info on where what used to be the autoexec.bat and config.sys reside - they're really just settings for the NTVDM - the DOS emulator virtual machine. support.microsoft.com/kb/165214/en-us --- ## [Problem found with MySQL connector, FSQL 3.0.0](https://forum.inductiveautomation.com/t/problem-found-with-mysql-connector-fsql-3-0-0/236)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [March 6, 2007, 2:55am UTC](https://forum.inductiveautomation.com/t/problem-found-with-mysql-connector-fsql-3-0-0/236 "2007-03-06T02:55:20Z")
Hey all- As part of the 3.0.0, we upgraded the mysql connector that we include to the latest available from the 1.0 line on their website (new version 1.0.9). Unfortunately, it looks like they made some big changes fro… --- ## [SQL Server Express 2005 - FSQL Native Driver](https://forum.inductiveautomation.com/t/sql-server-express-2005-fsql-native-driver/235)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [March 5, 2007, 7:40pm UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-fsql-native-driver/235 "2007-03-05T19:40:56Z")
FactorySQL will work fine with a DSN (ODBC) connection to an SQL Server Express edition. The following applies if you want to use a native FactorySQL (.NET) driver. It's using some sort of named connection instead of TCP… --- ## [Open window in a new location](https://forum.inductiveautomation.com/t/open-window-in-a-new-location/232)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 3\ **Last updated:** [March 3, 2007, 3:26pm UTC](https://forum.inductiveautomation.com/t/open-window-in-a-new-location/232 "2007-03-03T15:26:02Z")
How can I specify where a new window opens? It seems like openWindow() only places a window where it was last saved in the designer. --- ## [Newline character for popup windows](https://forum.inductiveautomation.com/t/newline-character-for-popup-windows/233)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [March 3, 2007, 3:16pm UTC](https://forum.inductiveautomation.com/t/newline-character-for-popup-windows/233 "2007-03-03T15:16:50Z")
Is there a newline character for the following fpmi.gui popup windows. confirm() errorBox() messageBox() warningBox() The dialog boxes do get wider to accomodate more text, but don't break the lines. They don't seem to… --- ## [Getting started with Python/Jython](https://forum.inductiveautomation.com/t/getting-started-with-python-jython/231)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [March 2, 2007, 8:59pm UTC](https://forum.inductiveautomation.com/t/getting-started-with-python-jython/231 "2007-03-02T20:59:29Z")
Getting started with Python/Jython scripting from the FactoryPMI Help. This seems to come up a lot. As explained below, Jython and Python are identical languages. Because of the popularity of the Python language, there… --- ## [FactorySQL 3.0 and Upcoming Development](https://forum.inductiveautomation.com/t/factorysql-3-0-and-upcoming-development/230)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [March 2, 2007, 7:57pm UTC](https://forum.inductiveautomation.com/t/factorysql-3-0-and-upcoming-development/230 "2007-03-02T19:57:59Z")
Hello all- FactorySQL 3.0 has just been released, and it represents a great deal of feedback and suggestions from our integrators and users. We rely heavily on these suggestions when evaluating ideas for changes & fea… --- ## [Table component - copying data from it](https://forum.inductiveautomation.com/t/table-component-copying-data-from-it/226)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [March 2, 2007, 6:06pm UTC](https://forum.inductiveautomation.com/t/table-component-copying-data-from-it/226 "2007-03-02T18:06:59Z")
I just noticed that a user can select data from a table and copy/paste to Excel. I have exported a table's data to a CSV with fpmi.db.exportCSV. This is equally useful! --- ## [PostgreSQL - How do I expose database to different IP/users?](https://forum.inductiveautomation.com/t/postgresql-how-do-i-expose-database-to-different-ip-users/227)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [March 1, 2007, 11:42pm UTC](https://forum.inductiveautomation.com/t/postgresql-how-do-i-expose-database-to-different-ip-users/227 "2007-03-01T23:42:41Z")
I'm using PostgreSQL 8.1. It's currently set up to accept connections for the users: dbuser and postgres on localhost (127.0.0.1). How can I accept communication to certain databases or users over different IP addresses? … --- ## [Move forward/backward toolbar buttons and others](https://forum.inductiveautomation.com/t/move-forward-backward-toolbar-buttons-and-others/225)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [February 28, 2007, 4:04am UTC](https://forum.inductiveautomation.com/t/move-forward-backward-toolbar-buttons-and-others/225 "2007-02-28T04:04:50Z")
An integrator verbally requested Z order toolbar buttons (move forward, backward, to front, to back). Thanks to the development team for including it in 2.0.0\_6! Another integrator requested toolbar buttons for: align … --- ## [Problem browsing in FactorySQL with RSLinx](https://forum.inductiveautomation.com/t/problem-browsing-in-factorysql-with-rslinx/223)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [February 28, 2007, 2:15am UTC](https://forum.inductiveautomation.com/t/problem-browsing-in-factorysql-with-rslinx/223 "2007-02-28T02:15:59Z")
If you're having trouble browsing your PLC tags with RSLinx it might be because RSLinx is set to run as an application instead of a service and FactorySQL is running as a service. To correct go to Start Menu-\>Rockwell… --- ## [SQL Server data types](https://forum.inductiveautomation.com/t/sql-server-data-types/222)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [February 28, 2007, 1:41am UTC](https://forum.inductiveautomation.com/t/sql-server-data-types/222 "2007-02-28T01:41:11Z")
Bumped into this FAQ on MS SQL Server data types. It's pretty useful sql-server-helper.com/faq/da ... s-p01.aspx --- ## [AND 4 columns to return a single value](https://forum.inductiveautomation.com/t/and-4-columns-to-return-a-single-value/217)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 7\ **Last updated:** [February 27, 2007, 11:29pm UTC](https://forum.inductiveautomation.com/t/and-4-columns-to-return-a-single-value/217 "2007-02-27T23:29:07Z")
I have 4 column id like to return for each transmitter, ALM\_LL, ALM\_L, ALM\_H and ALM\_HH. Is there a way to summarize these 4 columns in the query so it returns a single value of these 4 columns being ANDED? --- ## [Images](https://forum.inductiveautomation.com/t/images/216)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 2\ **Last updated:** [February 27, 2007, 3:39pm UTC](https://forum.inductiveautomation.com/t/images/216 "2007-02-27T15:39:13Z")
Does anyone know where I can find more images for use in FPMI, like more pumps, tanks etc? --- ## [Save windows, components get moved around](https://forum.inductiveautomation.com/t/save-windows-components-get-moved-around/214)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 3\ **Last updated:** [February 27, 2007, 2:01am UTC](https://forum.inductiveautomation.com/t/save-windows-components-get-moved-around/214 "2007-02-27T02:01:53Z")
Everytime i go to save a window, even if its unedited, the either the windows dimensions change, or some of the components get moved around. Why is this, and how do i cause it to stop? --- ## [Confirm exit dialog](https://forum.inductiveautomation.com/t/confirm-exit-dialog/213)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 3\ **Last updated:** [February 23, 2007, 10:08pm UTC](https://forum.inductiveautomation.com/t/confirm-exit-dialog/213 "2007-02-23T22:08:13Z")
Thanks for the "Save & Exit" button on the Conform Exit dialog in new FPMI Designer. I would like to see something similar when you open a different project. --- ## [Launch program from FPMI](https://forum.inductiveautomation.com/t/launch-program-from-fpmi/211)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 2\ **Last updated:** [February 23, 2007, 8:32pm UTC](https://forum.inductiveautomation.com/t/launch-program-from-fpmi/211 "2007-02-23T20:32:44Z")
How can I launch a program from an FPMI control (i.e. a button). I'd like to use the FPMI URL (localhost:8080/gateway/launch/project.jnlp) to launch this project and others from an overview project. Can I? Should I? --- ## [SQL Query to turn a database on it's side for graphing](https://forum.inductiveautomation.com/t/sql-query-to-turn-a-database-on-its-side-for-graphing/123)
**Author:** [@KeithB](https://forum.inductiveautomation.com/u/KeithB)\ **Replies:** 15\ **Last updated:** [February 22, 2007, 4:09pm UTC](https://forum.inductiveautomation.com/t/sql-query-to-turn-a-database-on-its-side-for-graphing/123 "2007-02-22T16:09:16Z")
Application: Leak test where PLC readings are 5 ms apart. Issue: Tags are created for each reading due to speed. Factory SQL creates a table with each of the tags as columns. I need to graph the value for each tag… --- ## [Triggered data logging](https://forum.inductiveautomation.com/t/triggered-data-logging/209)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 8\ **Last updated:** [February 20, 2007, 11:54pm UTC](https://forum.inductiveautomation.com/t/triggered-data-logging/209 "2007-02-20T23:54:24Z")
I plan an application that would log data from several PLCs via links that have variable and potentially pretty small bandwidth. Therefore, I would like to control the tags that FSQL queries and makes active in my OPC s… --- ## [Button that exports to a customized csv file](https://forum.inductiveautomation.com/t/button-that-exports-to-a-customized-csv-file/205)
**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\ **Replies:** 5\ **Last updated:** [February 15, 2007, 4:59am UTC](https://forum.inductiveautomation.com/t/button-that-exports-to-a-customized-csv-file/205 "2007-02-15T04:59:45Z")
I am trying to create a button that updates a dataset and exports to a customized csv file. Desired results: 1. updates the dynamic dataset "Room\_Temps" on my button. 2. output to .CSV using fpmi.file.writeFile() to th… --- ## [When is Longhorn slated to release?](https://forum.inductiveautomation.com/t/when-is-longhorn-slated-to-release/73)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 2\ **Last updated:** [February 14, 2007, 6:25am UTC](https://forum.inductiveautomation.com/t/when-is-longhorn-slated-to-release/73 "2007-02-14T06:25:37Z")
Anybody know about Microsofts latest OS? Does it have an official name yet? --- ## [How do I get gateway info in FactoryPMI](https://forum.inductiveautomation.com/t/how-do-i-get-gateway-info-in-factorypmi/208)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [February 14, 2007, 6:06am UTC](https://forum.inductiveautomation.com/t/how-do-i-get-gateway-info-in-factorypmi/208 "2007-02-14T06:06:31Z")
How do I find out where my gateway is and what port FactoryPMI is running on? --- ## [Data Sets](https://forum.inductiveautomation.com/t/data-sets/201)
**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\ **Replies:** 3\ **Last updated:** [February 13, 2007, 7:29pm UTC](https://forum.inductiveautomation.com/t/data-sets/201 "2007-02-13T19:29:58Z")
I am not really understanding how to set up a data set. --- ## [Logging BCD data](https://forum.inductiveautomation.com/t/logging-bcd-data/191)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 2\ **Last updated:** [February 13, 2007, 3:28pm UTC](https://forum.inductiveautomation.com/t/logging-bcd-data/191 "2007-02-13T15:28:17Z")
To log data from Automation Direct PLCs, I use KEPDirect, their version of KEPServer. The data is sent coded BCD, but just looks like 2s complement to FSQL and the database. Is there a FSQL function to convert it? --- ## [Article - Data collection: Improving efficiency on the plant](https://forum.inductiveautomation.com/t/article-data-collection-improving-efficiency-on-the-plant/203)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [February 13, 2007, 3:00pm UTC](https://forum.inductiveautomation.com/t/article-data-collection-improving-efficiency-on-the-plant/203 "2007-02-13T15:00:29Z")
A Dec 2003 article that I stumbled across by Ron Iannacone. I'm impressed with where he was going in 2003. It confirms a lot of our approach. It's worth mentioning that FactorySQL/FactoryPMI do fit into his description… --- ## [NULL values in PyDataSet](https://forum.inductiveautomation.com/t/null-values-in-pydataset/195)
**Author:** [@torulf](https://forum.inductiveautomation.com/u/torulf)\ **Replies:** 10\ **Last updated:** [February 13, 2007, 8:25am UTC](https://forum.inductiveautomation.com/t/null-values-in-pydataset/195 "2007-02-13T08:25:21Z")
How is a NULL value returned from a fpmi.db.runQuery represented, and can I test for it somehow? The reason for my question is that the Bar Chart component seems unhappy when passed NULL values converted by fpmi.db.toD… --- ## [Ghost SQL query](https://forum.inductiveautomation.com/t/ghost-sql-query/194)
**Author:** [@torulf](https://forum.inductiveautomation.com/u/torulf)\ **Replies:** 7\ **Last updated:** [February 13, 2007, 8:23am UTC](https://forum.inductiveautomation.com/t/ghost-sql-query/194 "2007-02-13T08:23:56Z")
Hi Support, While editing a project I cleaned up my database removing a table no longer needed. Having done that I get an error message from FactoryPMI complaining about the deleted table. The strange thing is that the… --- ## [Tiled image (texture) support](https://forum.inductiveautomation.com/t/tiled-image-texture-support/198)
**Author:** [@integrator\_adam72](https://forum.inductiveautomation.com/u/integrator_adam72)\ **Replies:** 1\ **Last updated:** [February 12, 2007, 6:59pm UTC](https://forum.inductiveautomation.com/t/tiled-image-texture-support/198 "2007-02-12T18:59:18Z")
I'd like to have a background pattern for my window that looks like polished metal. I can find an image, but the only way that I can make it the background is by putting it in the root container and anchoring it to stret… --- ## [Importing MySQL data from non-MySQL backup file](https://forum.inductiveautomation.com/t/importing-mysql-data-from-non-mysql-backup-file/200)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [February 12, 2007, 6:53pm UTC](https://forum.inductiveautomation.com/t/importing-mysql-data-from-non-mysql-backup-file/200 "2007-02-12T18:53:01Z")
I have a backup of SQL data from another database in the form of hundreds of thousands of lines of INSERT queries. How can I feed these into MySQL? INSERT INTO graph\_chiller (graph\_chiller\_ndx, c1\_inlet\_temp, c1\_juice… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=54) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=56)