# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=15 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 16 --- ## [Excel Export to in-use file try...except problem](https://forum.inductiveautomation.com/t/excel-export-to-in-use-file-try-except-problem/2191)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 2\ **Last updated:** [September 14, 2010, 4:42pm UTC](https://forum.inductiveautomation.com/t/excel-export-to-in-use-file-try-except-problem/2191 "2010-09-14T16:42:08Z")
Hi all, When I try to export to a file that is in use, it fails (as it should) with a java.io.fileNotFoundException. What I'd like to do is catch the error and print my own message, but the error doesn't seem to be ge… --- ## [History Partitions on Historisation Tags](https://forum.inductiveautomation.com/t/history-partitions-on-historisation-tags/2169)
**Author:** [@Oriol](https://forum.inductiveautomation.com/u/Oriol)\ **Replies:** 2\ **Last updated:** [September 7, 2010, 8:47am UTC](https://forum.inductiveautomation.com/t/history-partitions-on-historisation-tags/2169 "2010-09-07T08:47:59Z")
Hi, I need to get the value of some historised tag. As I know the moment (datetime), I've to get the name of the partition of history data inside the table sqlt\_partitions. But the question is: how are the columns star… --- ## [Minimize project on Button Click](https://forum.inductiveautomation.com/t/minimize-project-on-button-click/2156)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [August 30, 2010, 6:27pm UTC](https://forum.inductiveautomation.com/t/minimize-project-on-button-click/2156 "2010-08-30T18:27:03Z")
I would like to minimize my FPMI project in code on a button click or menu item selection. Is this possible? I am running a project in full screen mode and allow the user to link to an email page that is opened in a br… --- ## [Simplify nested Update, Select and IsNull statement](https://forum.inductiveautomation.com/t/simplify-nested-update-select-and-isnull-statement/2117)
**Author:** [@Jared](https://forum.inductiveautomation.com/u/Jared)\ **Replies:** 1\ **Last updated:** [August 11, 2010, 12:48pm UTC](https://forum.inductiveautomation.com/t/simplify-nested-update-select-and-isnull-statement/2117 "2010-08-11T12:48:24Z")
This question started as an email exchange. Come to find out, the Update with the included IsNull statement was working, FSQL was just giving a bogus write-back value, it was sending the table the correct info (1 o… --- ## [Update Non Default Data Source](https://forum.inductiveautomation.com/t/update-non-default-data-source/2096)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 2\ **Last updated:** [August 9, 2010, 11:17am UTC](https://forum.inductiveautomation.com/t/update-non-default-data-source/2096 "2010-08-09T11:17:12Z")
Hi I am having some problems with an update script that is updating a database table that is not in the Default data source. The script is been run from an action performed of a button. I get an error while executing s… --- ## [Can't start FPMI Service, Error 1067](https://forum.inductiveautomation.com/t/cant-start-fpmi-service-error-1067/2095)
**Author:** [@philrenTN](https://forum.inductiveautomation.com/u/philrenTN)\ **Replies:** 1\ **Last updated:** [August 4, 2010, 8:40pm UTC](https://forum.inductiveautomation.com/t/cant-start-fpmi-service-error-1067/2095 "2010-08-04T20:40:43Z")
Hello, I'm running FactoryPMI (version 3.3 something? Not sure how to find the version number if I can't start the service) on a Windows SBS2003 machine. Last night, windows update ran and installed a security update, an… --- ## [Mysql Optimization](https://forum.inductiveautomation.com/t/mysql-optimization/2086)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 0\ **Last updated:** [July 27, 2010, 9:03pm UTC](https://forum.inductiveautomation.com/t/mysql-optimization/2086 "2010-07-27T21:03:01Z")
Can somebody post their my.cnf from Mysql (Linux OS)? I am looking for someone running a large database with heavy updates/inserts from Transactional groups. We are running 130 groups around 5000 to 6000 items with multi… --- ## [Query running causing perfromance issue](https://forum.inductiveautomation.com/t/query-running-causing-perfromance-issue/2020)
**Author:** [@rthomas](https://forum.inductiveautomation.com/u/rthomas)\ **Replies:** 8\ **Last updated:** [July 20, 2010, 5:13pm UTC](https://forum.inductiveautomation.com/t/query-running-causing-perfromance-issue/2020 "2010-07-20T17:13:14Z")
In my slow query log i see the following query running very often causing performance hang in my factory PMI clients. I believe that it is an internal sql from either FPMI or FSQL, as i have no sql like this. SELECT … --- ## [KepServerEX V4 to V5](https://forum.inductiveautomation.com/t/kepserverex-v4-to-v5/2053)
**Author:** [@Justin](https://forum.inductiveautomation.com/u/Justin)\ **Replies:** 1\ **Last updated:** [July 20, 2010, 3:12pm UTC](https://forum.inductiveautomation.com/t/kepserverex-v4-to-v5/2053 "2010-07-20T15:12:29Z")
I will be upgrading from KepServerEX version 4 to version 5 soon and would like to know if there have been any issues with FactorySQL. I am hoping this is a seemless change and FactorySQL refreshes the OPC server correc… --- ## [Updating related tables](https://forum.inductiveautomation.com/t/updating-related-tables/2047)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [July 19, 2010, 8:48pm UTC](https://forum.inductiveautomation.com/t/updating-related-tables/2047 "2010-07-19T20:48:41Z")
I have 3 MySQL tables in a parent-child-grandchild relationship. Each table has a unique auto-generated integer id. The child table includes a reference to the parent id and the grandchild includes a reference to the c… --- ## [Enable/disable components between windows](https://forum.inductiveautomation.com/t/enable-disable-components-between-windows/2038)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 2\ **Last updated:** [July 16, 2010, 8:09pm UTC](https://forum.inductiveautomation.com/t/enable-disable-components-between-windows/2038 "2010-07-16T20:09:22Z")
How can I use a button in one window to enable a button in a different window? --- ## [Usability](https://forum.inductiveautomation.com/t/usability/1024)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 13\ **Last updated:** [July 15, 2010, 11:37pm UTC](https://forum.inductiveautomation.com/t/usability/1024 "2010-07-15T23:37:54Z")
On the dynamic properties form, you have keyboard shortcuts for the buttons. (this is good!) Could you add shortcuts for the Name/Description/Type fields as well? Or at least make the name field active on opening so I do… --- ## [How to use the tab strip?](https://forum.inductiveautomation.com/t/how-to-use-the-tab-strip/1125)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 4\ **Last updated:** [July 8, 2010, 10:53am UTC](https://forum.inductiveautomation.com/t/how-to-use-the-tab-strip/1125 "2010-07-08T10:53:36Z")
Maybe this is really obvious, but I can't figure it out. How does the tab strip control work? I'd like to have something like the demo application, where there are tabs across the top of a page, or down one side of the p… --- ## [Gentoo Linux Ebuilds for Ignition 7.1.2 and 7.1.3b1](https://forum.inductiveautomation.com/t/gentoo-linux-ebuilds-for-ignition-7-1-2-and-7-1-3b1/1979)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 1\ **Last updated:** [July 3, 2010, 2:14pm UTC](https://forum.inductiveautomation.com/t/gentoo-linux-ebuilds-for-ignition-7-1-2-and-7-1-3b1/1979 "2010-07-03T14:14:53Z")
I got around to testing these new versions. The attachment contains all the helper files and install scripts for 7.1.2 build 5273, and 7.1.3-beta1 build 5293. V7.1.2 is marked stable for x86 & amd64. V7.1.3-beta1 is m… --- ## [Parsing .csv and .txt files in FPMI](https://forum.inductiveautomation.com/t/parsing-csv-and-txt-files-in-fpmi/1995)
**Author:** [@Cas](https://forum.inductiveautomation.com/u/Cas)\ **Replies:** 8\ **Last updated:** [July 2, 2010, 8:28pm UTC](https://forum.inductiveautomation.com/t/parsing-csv-and-txt-files-in-fpmi/1995 "2010-07-02T20:28:05Z")
Hi, everyone. I would like to use FPMI to open a .csv (comma delimited) or a .txt (tab delimited) file and parse each element into a text box on a FPMI window. Imagine the simplest case: A file called Numbers.csv has th… --- ## [Return To Launch Page](https://forum.inductiveautomation.com/t/return-to-launch-page/1991)
**Author:** [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Replies:** 2\ **Last updated:** [July 2, 2010, 10:44am UTC](https://forum.inductiveautomation.com/t/return-to-launch-page/1991 "2010-07-02T10:44:30Z")
Hi I am trying to write a global event that will If the system is inactivate and it is not on the launch Page close all windows and return to Launch Page This is the code I have written.It is returning to the launch … --- ## [How to center a new window](https://forum.inductiveautomation.com/t/how-to-center-a-new-window/1996)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 1\ **Last updated:** [July 1, 2010, 3:18pm UTC](https://forum.inductiveautomation.com/t/how-to-center-a-new-window/1996 "2010-07-01T15:18:18Z")
Dear All, I also got another little problem. :frowning: It's that I want to open a window and place it at the center of the screen when user clicks the menu. Let's say I want to open a window named Sample. I tried it… --- ## [Delete from where?](https://forum.inductiveautomation.com/t/delete-from-where/1990)
**Author:** [@Justin](https://forum.inductiveautomation.com/u/Justin)\ **Replies:** 4\ **Last updated:** [June 30, 2010, 5:49pm UTC](https://forum.inductiveautomation.com/t/delete-from-where/1990 "2010-06-30T17:49:51Z")
Easy question for most, but I'm not able to find a good example. I am trying to delete a record (row) from a MySql db table using the action script on a button. To keep it simple, the intended row to be deleted will be… --- ## [SQL Native Connection with SQL Express 2008 R2](https://forum.inductiveautomation.com/t/sql-native-connection-with-sql-express-2008-r2/1989)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 6\ **Last updated:** [June 30, 2010, 1:05pm UTC](https://forum.inductiveautomation.com/t/sql-native-connection-with-sql-express-2008-r2/1989 "2010-06-30T13:05:13Z")
Hi, I am trying to make a database connection to SQL Express 2008 R2 running on Windows 2008 Server 64 Bit but the connection is failing when I try to connect. I check connecting remotely with the SQL Server Studio an… --- ## [Need to load records from SQL into tags in PLC](https://forum.inductiveautomation.com/t/need-to-load-records-from-sql-into-tags-in-plc/1978)
**Author:** [@NHOutbacker](https://forum.inductiveautomation.com/u/NHOutbacker)\ **Replies:** 4\ **Last updated:** [June 29, 2010, 6:34pm UTC](https://forum.inductiveautomation.com/t/need-to-load-records-from-sql-into-tags-in-plc/1978 "2010-06-29T18:34:33Z")
I have a table in SQL that I would like to download into an array of tags in my PLC (via OPC server, of course). The table contains employee information and all I need is the employee name and corresponding employeeID. … --- ## [Tricky SQL query](https://forum.inductiveautomation.com/t/tricky-sql-query/1984)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [June 29, 2010, 3:43am UTC](https://forum.inductiveautomation.com/t/tricky-sql-query/1984 "2010-06-29T03:43:40Z")
I would appreciate help with the following SQL problem. I have 2 tables as follows: Test\_1: id -- a b c Test\_2: id Test\_1\_id Comment Finished ---------------------------------- 1 a Test a 2 b … --- ## [Gentoo Linux ebuilds for 7.1.1 and 7.1.2](https://forum.inductiveautomation.com/t/gentoo-linux-ebuilds-for-7-1-1-and-7-1-2/1916)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 9\ **Last updated:** [June 24, 2010, 6:48pm UTC](https://forum.inductiveautomation.com/t/gentoo-linux-ebuilds-for-7-1-1-and-7-1-2/1916 "2010-06-24T18:48:16Z")
I spent a good part of the day integrating Ignition into a portage overlay. Gentoo uses OpenRC for its initscripts, so the Ubuntu style scripts in the download aren’t compatible. Gentoo also strongly discourages embedd… --- ## [Standard Chart XY Bar Renderer Change Margin in Code](https://forum.inductiveautomation.com/t/standard-chart-xy-bar-renderer-change-margin-in-code/1964)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [June 23, 2010, 4:06pm UTC](https://forum.inductiveautomation.com/t/standard-chart-xy-bar-renderer-change-margin-in-code/1964 "2010-06-23T16:06:33Z")
Carl, Do you have some code I could use to change the margin value on my standard charts XY Bar Renderer dataset? I am making a histogram and depending on the size of the bins the margin needs to change so the bars do… --- ## [Letter Head in Report Viewer](https://forum.inductiveautomation.com/t/letter-head-in-report-viewer/1962)
**Author:** [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\ **Replies:** 1\ **Last updated:** [June 22, 2010, 4:02pm UTC](https://forum.inductiveautomation.com/t/letter-head-in-report-viewer/1962 "2010-06-22T16:02:43Z")
Hi all, I have a question. Now I'm a beginner in using PMI designer and trying to update a report that is written by another programmer. In this report, there is a logo (like a letterhead) and a table. The problem is tha… --- ## [FPMI going into demo mode?](https://forum.inductiveautomation.com/t/fpmi-going-into-demo-mode/1953)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [June 18, 2010, 6:06pm UTC](https://forum.inductiveautomation.com/t/fpmi-going-into-demo-mode/1953 "2010-06-18T18:06:02Z")
It seems to be happening more often now. We are using the hasp license because the original computer that had the license on it crashed a while back. Sometimes during normal work hours all of our clients screens wil… --- ## [Creating multiple records in MySQL](https://forum.inductiveautomation.com/t/creating-multiple-records-in-mysql/1950)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [June 17, 2010, 5:59pm UTC](https://forum.inductiveautomation.com/t/creating-multiple-records-in-mysql/1950 "2010-06-17T17:59:35Z")
I have 2 tables, A and B. A contains 100 records, B contains a subset of 80 of those records. Both tables use ID as an index. I want to create 20 new records in B for the records that are missing when compared with A… --- ## [Open Sourced Linux Router](https://forum.inductiveautomation.com/t/open-sourced-linux-router/1197)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 4\ **Last updated:** [June 16, 2010, 4:01pm UTC](https://forum.inductiveautomation.com/t/open-sourced-linux-router/1197 "2010-06-16T16:01:20Z")
Hey Guys. I dont know if many of you are involved with the networking side of things as much as I am forced to be, But if you need a solid, powerful cheap router, you should check out www.vyatta.org. It also has instrus… --- ## [SQL Server Express 2005 connection](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 4\ **Last updated:** [June 15, 2010, 1:38am UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171 "2010-06-15T01:38:02Z")
If you use the Express (free) version of SQL Server 2005 you need to add the following connection string: 'instance=SQLEXPRESS;' under "Extra Connection Properties" of the FPMI Gateway datasource connection. If you … --- ## [Can security be applied at the project level?](https://forum.inductiveautomation.com/t/can-security-be-applied-at-the-project-level/1018)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 11\ **Last updated:** [June 14, 2010, 9:36pm UTC](https://forum.inductiveautomation.com/t/can-security-be-applied-at-the-project-level/1018 "2010-06-14T21:36:22Z")
I am creating a number of projects. Each for a different geographical region. The client does not want users from one region (project) to be able to access/control information from another region (project). This could … --- ## [PostgreSQL and timezones](https://forum.inductiveautomation.com/t/postgresql-and-timezones/1923)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 1\ **Last updated:** [June 14, 2010, 9:34pm UTC](https://forum.inductiveautomation.com/t/postgresql-and-timezones/1923 "2010-06-14T21:34:53Z")
This was mentioned in a different thread, but I thought it would find more viewers here. Postgres has it's own concept of which timezone it's in. In the postgresql.cong file there is a line timezone = If this is se… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=14) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=16)