# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=22 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 23 --- ## [i18N support](https://forum.inductiveautomation.com/t/i18n-support/1369)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 1\ **Last updated:** [November 10, 2009, 4:05am UTC](https://forum.inductiveautomation.com/t/i18n-support/1369 "2009-11-10T04:05:15Z")
We just got an RFP for a French language system. What support does FPMI have for languages other than English? ie: manuals, designer etc. (I know I can make the running screens French) --- ## [Invoke Later](https://forum.inductiveautomation.com/t/invoke-later/1371)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [November 10, 2009, 4:04am UTC](https://forum.inductiveautomation.com/t/invoke-later/1371 "2009-11-10T04:04:11Z")
I'm using the following code to select a particular field from a table and store the value in my root container, if(len({Root Container.Table 1.data}), if({Root Container.Table 1.selectedRow} != -1, toInt({Root Conta… --- ## [Problem About Zoom in and Zom out bottons provided on bar](https://forum.inductiveautomation.com/t/problem-about-zoom-in-and-zom-out-bottons-provided-on-bar/1367)
**Author:** [@Shailesh](https://forum.inductiveautomation.com/u/Shailesh)\ **Replies:** 1\ **Last updated:** [November 9, 2009, 2:37pm UTC](https://forum.inductiveautomation.com/t/problem-about-zoom-in-and-zom-out-bottons-provided-on-bar/1367 "2009-11-09T14:37:49Z")
Historical trends : For hostrical trends we can select From Date and To Date using bar with time.There are two buttons provided Zoom In and Zoom Out on this selection control.If we use Zoom out or Zoom in till last it… --- ## [CSV Export Format](https://forum.inductiveautomation.com/t/csv-export-format/1365)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 5\ **Last updated:** [November 9, 2009, 3:49am UTC](https://forum.inductiveautomation.com/t/csv-export-format/1365 "2009-11-09T03:49:46Z")
Hi, It would be nice to have the format of the CSV export a record or row per group to make the task of creating new groups easier. I know it will not be an easy task, a little complicated because you may have to gro… --- ## [Problem with Millisecond part of Timestamp](https://forum.inductiveautomation.com/t/problem-with-millisecond-part-of-timestamp/1364)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 4\ **Last updated:** [November 8, 2009, 3:39am UTC](https://forum.inductiveautomation.com/t/problem-with-millisecond-part-of-timestamp/1364 "2009-11-08T03:39:26Z")
Hi , with FactorySQL, the millisecond part of the datetime is not logged with the data. I am suing the FactorySQL Timestamp to be logged along with OPC Items in a Standard Group. The Millisecond part is always 000 --- ## [Custom Pointers](https://forum.inductiveautomation.com/t/custom-pointers/1353)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 14\ **Last updated:** [November 6, 2009, 9:04pm UTC](https://forum.inductiveautomation.com/t/custom-pointers/1353 "2009-11-06T21:04:06Z")
Is it possible to import or create additional mouse pointer options? I just jumped through some hoops and did the same sort of thing with a floating image, but man, it would be easier if I could just change the pointer. … --- ## [Apply Color from Database to Each Row in Table](https://forum.inductiveautomation.com/t/apply-color-from-database-to-each-row-in-table/1357)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 7\ **Last updated:** [November 4, 2009, 1:12am UTC](https://forum.inductiveautomation.com/t/apply-color-from-database-to-each-row-in-table/1357 "2009-11-04T01:12:23Z")
Hello Everyone, What is the best/easiest way to use a color from the database for a each row in a table? I am saving the color in the database as "color(int, int, int, int)", but I don't know how to map that color to … --- ## [Synch time based groups](https://forum.inductiveautomation.com/t/synch-time-based-groups/1362)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 5\ **Last updated:** [November 3, 2009, 8:03pm UTC](https://forum.inductiveautomation.com/t/synch-time-based-groups/1362 "2009-11-03T20:03:23Z")
Hi, I have a problem that I am trying to resolve maybe someone has some idea. I am using FactorySQL for logging datapoints to SQL server using Stored Procedure groups. There are a total of 1093 datapoints each datapo… --- ## [Known Issue: Slow startup on systems with many alerts](https://forum.inductiveautomation.com/t/known-issue-slow-startup-on-systems-with-many-alerts/1363)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [November 3, 2009, 5:48pm UTC](https://forum.inductiveautomation.com/t/known-issue-slow-startup-on-systems-with-many-alerts/1363 "2009-11-03T17:48:54Z")
We have become aware of an issue that affects systems that store alerts to the alert log, and results in gradual increase of system startup time. The issue is caused by the lack of a database index on the CLEAR\_TIME c… --- ## [FPMI Client on a Netbook](https://forum.inductiveautomation.com/t/fpmi-client-on-a-netbook/1360)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 5\ **Last updated:** [November 3, 2009, 3:41am UTC](https://forum.inductiveautomation.com/t/fpmi-client-on-a-netbook/1360 "2009-11-03T03:41:48Z")
I'm wondering if anyone has tried running the FPMI Client on a Netbook? If you have what netbook did you use and what was your experience with it? --- ## [Data not being Added to MYSql database](https://forum.inductiveautomation.com/t/data-not-being-added-to-mysql-database/1359)
**Author:** [@zeithof4](https://forum.inductiveautomation.com/u/zeithof4)\ **Replies:** 2\ **Last updated:** [November 2, 2009, 6:13pm UTC](https://forum.inductiveautomation.com/t/data-not-being-added-to-mysql-database/1359 "2009-11-02T18:13:33Z")
I am just trying to set up an application, much like the one in the quick start. I am using RSLinx to a Control Logix processor. I am able to browse the tags, add them to a standard group, and run the group. All of th… --- ## [Reporting Plug-in Allignment and multiple page layout](https://forum.inductiveautomation.com/t/reporting-plug-in-allignment-and-multiple-page-layout/1361)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 0\ **Last updated:** [November 2, 2009, 4:55pm UTC](https://forum.inductiveautomation.com/t/reporting-plug-in-allignment-and-multiple-page-layout/1361 "2009-11-02T16:55:30Z")
Attached is a blank daily production sheet. So far I have been able to pull this into the reporting plug in. And I was able to populate data from an SQL query into this report. However I am not sure that I am doing thing… --- ## [Alerting trouble](https://forum.inductiveautomation.com/t/alerting-trouble/1358)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [November 2, 2009, 4:44pm UTC](https://forum.inductiveautomation.com/t/alerting-trouble/1358 "2009-11-02T16:44:13Z")
I am trying to setup an alert so I can query the FSQL\_Alert\_Status table. The device has a tag called status which is 0 when it is off and 1 when it is on. I setup an alert that has an expression command of the status … --- ## [Pass in window parameter on startup](https://forum.inductiveautomation.com/t/pass-in-window-parameter-on-startup/134)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 11\ **Last updated:** [October 30, 2009, 5:17pm UTC](https://forum.inductiveautomation.com/t/pass-in-window-parameter-on-startup/134 "2009-10-30T17:17:40Z")
Hi guys: Our apps continue to expand here, and I am thinking of consolidating them into fewer, larger ones. Many are opened by users from an intranet menu item. I would like to simplify them getting to the screens the… --- ## [Correct runPrepStmt syntax](https://forum.inductiveautomation.com/t/correct-runprepstmt-syntax/1348)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 2\ **Last updated:** [October 30, 2009, 1:29pm UTC](https://forum.inductiveautomation.com/t/correct-runprepstmt-syntax/1348 "2009-10-30T13:29:29Z")
The user manual says that the syntax for runPrepStmt is: runPrepStmt(Query, \[Datasource\], Parameters\[\]) where \[Datasource\] is optional. Is this correct, or is it actually: runPrepStmt(Query, Parameters\[\], \[Datas… --- ## [SQL BLOB to IMAGE](https://forum.inductiveautomation.com/t/sql-blob-to-image/1356)
**Author:** [@sai](https://forum.inductiveautomation.com/u/sai)\ **Replies:** 1\ **Last updated:** [October 29, 2009, 9:09pm UTC](https://forum.inductiveautomation.com/t/sql-blob-to-image/1356 "2009-10-29T21:09:08Z")
I have an application where the user will make a selection from a combo box that is bound to a table in a MYSQL (remote) database. I need to be able to load an associate BLOB (jpg) from the database and show it on the… --- ## [Paintable Canvas Component](https://forum.inductiveautomation.com/t/paintable-canvas-component/833)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 4\ **Last updated:** [October 29, 2009, 5:45pm UTC](https://forum.inductiveautomation.com/t/paintable-canvas-component/833 "2009-10-29T17:45:40Z")
I have had a situation where I was unable to save the project when the paintable canvas component I was working on is still selected (meaning, the resize handles are still visible). When I do a "save", it returns an erro… --- ## [Cursor won't change](https://forum.inductiveautomation.com/t/cursor-wont-change/202)
**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\ **Replies:** 7\ **Last updated:** [October 29, 2009, 5:40pm UTC](https://forum.inductiveautomation.com/t/cursor-wont-change/202 "2009-10-29T17:40:59Z")
I select the cursor to "hand" on a container. After I save the project it goes back to "default". --- ## [Startup Error](https://forum.inductiveautomation.com/t/startup-error/1202)
**Author:** [@mschoenwald](https://forum.inductiveautomation.com/u/mschoenwald)\ **Replies:** 4\ **Last updated:** [October 29, 2009, 5:39pm UTC](https://forum.inductiveautomation.com/t/startup-error/1202 "2009-10-29T17:39:12Z")
When I start the FactoryPMI Designer I get this error. java.lang.ArrayIndexOutOfBoundsException: No such child: 2 at java.awt.Container.getComponent(Unknown Source) at com.jidesoft.swing.JideSplitPane.setDividersVisi… --- ## [Word Wrap](https://forum.inductiveautomation.com/t/word-wrap/1355)
**Author:** [@BeyondWireless](https://forum.inductiveautomation.com/u/BeyondWireless)\ **Replies:** 2\ **Last updated:** [October 29, 2009, 11:31am UTC](https://forum.inductiveautomation.com/t/word-wrap/1355 "2009-10-29T11:31:08Z")
i have a label in FactoryPMI, but cant get the text to word-wrap. I have tried the word wrap tick-box in the property editor (Data-\>Text), and changed the size of the text box - it does not seem to work? --- ## [Correct Syntax for using Dynamic Properties to build a tag?](https://forum.inductiveautomation.com/t/correct-syntax-for-using-dynamic-properties-to-build-a-tag/1354)
**Author:** [@rthomas](https://forum.inductiveautomation.com/u/rthomas)\ **Replies:** 1\ **Last updated:** [October 28, 2009, 11:35pm UTC](https://forum.inductiveautomation.com/t/correct-syntax-for-using-dynamic-properties-to-build-a-tag/1354 "2009-10-28T23:35:11Z")
In the expression editor, I would like to use dynamic properties to build the path and tag name, use the value of that derived tag as input to a function and the result will be used as the "label" . Can this be done an… --- ## [Reporting Plugin, is this possible](https://forum.inductiveautomation.com/t/reporting-plugin-is-this-possible/1345)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 13\ **Last updated:** [October 28, 2009, 8:38pm UTC](https://forum.inductiveautomation.com/t/reporting-plugin-is-this-possible/1345 "2009-10-28T20:38:24Z")
I need some help creating a report. This report will create labels for all electrical boxes on a given machine. The source of this data resides in three tables. Below is the data I want on the form. Jboxes Equipment D… --- ## [Data Backups](https://forum.inductiveautomation.com/t/data-backups/1352)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 6\ **Last updated:** [October 27, 2009, 8:18pm UTC](https://forum.inductiveautomation.com/t/data-backups/1352 "2009-10-27T20:18:22Z")
This is kind of related to FPMI I guess, so I'll post it here. Let's say I am doing some development on a project. I've added my database to the customer's server (SQLServer 2005) and they started adding some data. In … --- ## [Partial Selection from a Dataset (Not SQL Table)](https://forum.inductiveautomation.com/t/partial-selection-from-a-dataset-not-sql-table/1349)
**Author:** [@pdalwalla](https://forum.inductiveautomation.com/u/pdalwalla)\ **Replies:** 2\ **Last updated:** [October 27, 2009, 5:54am UTC](https://forum.inductiveautomation.com/t/partial-selection-from-a-dataset-not-sql-table/1349 "2009-10-27T05:54:51Z")
I was wondering if there is a way to select an entire column from a dataset. From what I saw it seems like: 1. You can select a single value from a dataset (row,column) 2. You can use a column selector and hide it to sel… --- ## [Multiple recordsets](https://forum.inductiveautomation.com/t/multiple-recordsets/1323)
**Author:** [@mortendc](https://forum.inductiveautomation.com/u/mortendc)\ **Replies:** 2\ **Last updated:** [October 26, 2009, 8:05am UTC](https://forum.inductiveautomation.com/t/multiple-recordsets/1323 "2009-10-26T08:05:48Z")
Hi I have been trying out the trial version of FSQL for a few days now trying to solve a specific task I have. I need to get order data from MSSQL database to Allen Bradley CLX. I’m currently using a RSview/VBA applic… --- ## [Formatting % in numeric text field or table](https://forum.inductiveautomation.com/t/formatting-in-numeric-text-field-or-table/1351)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [October 24, 2009, 1:28am UTC](https://forum.inductiveautomation.com/t/formatting-in-numeric-text-field-or-table/1351 "2009-10-24T01:28:40Z")
When I try to change the display format on a numeric text field or table to 0.00% it adds two 0's to it. for example I have the number 30 when it is displayed it shows 3000.00%. Thanks for the help. --- ## [LED Display with Occasional Marquee Message](https://forum.inductiveautomation.com/t/led-display-with-occasional-marquee-message/1310)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 4\ **Last updated:** [October 23, 2009, 10:20pm UTC](https://forum.inductiveautomation.com/t/led-display-with-occasional-marquee-message/1310 "2009-10-23T22:20:50Z")
Hello Everyone, After playing more with the led displays I started thinking how cool it would be to implement an occasional marquee across them. I know if you had too many of them, or if they fired too fast it would q… --- ## [Enable and Disable Timers via Scripting](https://forum.inductiveautomation.com/t/enable-and-disable-timers-via-scripting/1350)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 3\ **Last updated:** [October 23, 2009, 9:14pm UTC](https://forum.inductiveautomation.com/t/enable-and-disable-timers-via-scripting/1350 "2009-10-23T21:14:02Z")
Hello Everyone, I found some time to work on my LED Marquee project, but I seem to have run into a snag… I can’t seem to change the timer running attribute using scripting. I don’t get any errors, but my code doesn’t … --- ## [Bind dataset col value to LED](https://forum.inductiveautomation.com/t/bind-dataset-col-value-to-led/1346)
**Author:** [@johandk](https://forum.inductiveautomation.com/u/johandk)\ **Replies:** 1\ **Last updated:** [October 23, 2009, 4:24pm UTC](https://forum.inductiveautomation.com/t/bind-dataset-col-value-to-led/1346 "2009-10-23T16:24:02Z")
Hi, I have a SQL tag, whose value is a dataset. It only has one row. I am trying to bind one of the columns values to a LED display. I'm very new to FactoryPMI - please help. Thanks, Johan --- ## [Resetting Retentive Hour meter](https://forum.inductiveautomation.com/t/resetting-retentive-hour-meter/1347)
**Author:** [@Luis\_Cardona](https://forum.inductiveautomation.com/u/Luis_Cardona)\ **Replies:** 1\ **Last updated:** [October 23, 2009, 3:21pm UTC](https://forum.inductiveautomation.com/t/resetting-retentive-hour-meter/1347 "2009-10-23T15:21:13Z")
I wan use the retentive hour meter to accumulate specific downtime in real time but i would to resetting based on specific parameter. They are any way to reset this retentive hour meter? Thanks [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=21) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=23)