# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=36 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 37 --- ## [Designed screen disappeared, why?](https://forum.inductiveautomation.com/t/designed-screen-disappeared-why/910)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [December 28, 2008, 6:29pm UTC](https://forum.inductiveautomation.com/t/designed-screen-disappeared-why/910 "2008-12-28T18:29:45Z")
I was doing a goto meeting with Travis today. The problem was that a table kept comming up as some sort of serializing issue with a certain line of code. Travis thought he almost had it and that the probem had to do with… --- ## [Hourly averages and end of the day summary](https://forum.inductiveautomation.com/t/hourly-averages-and-end-of-the-day-summary/908)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 3\ **Last updated:** [December 26, 2008, 10:25pm UTC](https://forum.inductiveautomation.com/t/hourly-averages-and-end-of-the-day-summary/908 "2008-12-26T22:25:55Z")
I’m using FSQL to logging data every minute into a SQL 2000 DB. I would like to create hourly averages and end of the day summary data from the data stored in the one minute table. I have t\_stamp, \_DateTimeLocal and \_Tim… --- ## [Real-time trends not visible over WAN](https://forum.inductiveautomation.com/t/real-time-trends-not-visible-over-wan/906)
**Author:** [@vipulss](https://forum.inductiveautomation.com/u/vipulss)\ **Replies:** 2\ **Last updated:** [December 26, 2008, 8:58pm UTC](https://forum.inductiveautomation.com/t/real-time-trends-not-visible-over-wan/906 "2008-12-26T20:58:21Z")
We have hosted a Factory PMI/SQL application on a server. We are not able to see the real-time trends over the WAN. The whole trend window is blank, no lines, however the time keeps changing. If a pen is checked/unchecke… --- ## [Question about groups](https://forum.inductiveautomation.com/t/question-about-groups/909)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 0\ **Last updated:** [December 24, 2008, 11:50pm UTC](https://forum.inductiveautomation.com/t/question-about-groups/909 "2008-12-24T23:50:36Z")
a while back I was in contact with Colby there at IA. We were having an error was occuring in a block group. While investigating this it was found that if you had an OPC item configured but it was disabled it would cause… --- ## [updateRow not updated my table dataset](https://forum.inductiveautomation.com/t/updaterow-not-updated-my-table-dataset/905)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [December 24, 2008, 12:09am UTC](https://forum.inductiveautomation.com/t/updaterow-not-updated-my-table-dataset/905 "2008-12-24T00:09:22Z")
newValue = event.newValue oldValue = event.oldValue row = event.row column = event.column if(newValue == "pre" or newValue == "post"): fpmi.db.runPrepStmt("UPDATE tblMaltDataSNB SET TestType = ? WHERE MALTSNBID = ?",\[n… --- ## [Table vs View question](https://forum.inductiveautomation.com/t/table-vs-view-question/904)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 0\ **Last updated:** [December 23, 2008, 9:07pm UTC](https://forum.inductiveautomation.com/t/table-vs-view-question/904 "2008-12-23T21:07:42Z")
New query, new Questions. Ok lets start with what I have. I have one table called progmode1, I have one view called djt\_mt\_info\_to\_prodtrack. In each of these I have a column called ‘jobtask’. In each of these I h… --- ## [How can I log data from a CSV file into MySQL via FSQL?](https://forum.inductiveautomation.com/t/how-can-i-log-data-from-a-csv-file-into-mysql-via-fsql/901)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 17\ **Last updated:** [December 23, 2008, 7:25pm UTC](https://forum.inductiveautomation.com/t/how-can-i-log-data-from-a-csv-file-into-mysql-via-fsql/901 "2008-12-23T19:25:34Z")
I am dealing with several different non-opc sensor systems that create a CSV text file output rather than logging to a database. I want this data to integrate with an FPMI based plant floor system. I'm wondering if I can… --- ## [Find Text](https://forum.inductiveautomation.com/t/find-text/902)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 1\ **Last updated:** [December 22, 2008, 7:37pm UTC](https://forum.inductiveautomation.com/t/find-text/902 "2008-12-22T19:37:08Z")
Just a thought... I was scrolling through a slightly lengthy Jython script earlier looking for one variable in particular and thought it would be neat if there was a 'find' or 'search' command in the action configuration… --- ## [Change in dropdown behavior for selectedStringValue](https://forum.inductiveautomation.com/t/change-in-dropdown-behavior-for-selectedstringvalue/900)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [December 19, 2008, 11:24pm UTC](https://forum.inductiveautomation.com/t/change-in-dropdown-behavior-for-selectedstringvalue/900 "2008-12-19T23:24:46Z")
I just upgraded FPMI to the newest version (3 .3.0) today and notice that the selectedStringValue now returns the same as selectedLabel instead of being the string form of selectedValue. Is this by design or a bug? --- ## [FPMI wont start](https://forum.inductiveautomation.com/t/fpmi-wont-start/468)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 3\ **Last updated:** [December 19, 2008, 11:01pm UTC](https://forum.inductiveautomation.com/t/fpmi-wont-start/468 "2008-12-19T23:01:59Z")
I updated to java 6, not FPMI service will not start. In the windows logs, it says something about a loadlibrary not found --- ## [Dynamic property question](https://forum.inductiveautomation.com/t/dynamic-property-question/899)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [December 19, 2008, 10:51pm UTC](https://forum.inductiveautomation.com/t/dynamic-property-question/899 "2008-12-19T22:51:18Z")
I have a two drop down boxes. The one, we will call screen select, has a fixed number of items. It can only have a value of 1, 2, or 3. The other, we will call mechanic select, drop down box has a query that runs off of … --- ## [Problems with ActiveX Installation](https://forum.inductiveautomation.com/t/problems-with-activex-installation/898)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 2\ **Last updated:** [December 19, 2008, 5:35pm UTC](https://forum.inductiveautomation.com/t/problems-with-activex-installation/898 "2008-12-19T17:35:34Z")
I have dowloaded the Plugin ActiveX (ActiveXPlugin-1\[1\].0.2.fplg file), but when I installed the plugin in FPMI, in the Activation Status column, show me the next message: Activated CD-Key:???-??? (un-activate) I hav… --- ## [Error opening the demo project with designer](https://forum.inductiveautomation.com/t/error-opening-the-demo-project-with-designer/897)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 2\ **Last updated:** [December 18, 2008, 4:02pm UTC](https://forum.inductiveautomation.com/t/error-opening-the-demo-project-with-designer/897 "2008-12-18T16:02:50Z")
The OS is Windows 2000 Server SP4 java.lang.NoClassDefFoundError: com/calmetrics/factoryhmi/application/gateway/DataSet at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(Unknow… --- ## [Easy chart right click menu](https://forum.inductiveautomation.com/t/easy-chart-right-click-menu/896)
**Author:** [@cdmac73401](https://forum.inductiveautomation.com/u/cdmac73401)\ **Replies:** 1\ **Last updated:** [December 17, 2008, 6:46pm UTC](https://forum.inductiveautomation.com/t/easy-chart-right-click-menu/896 "2008-12-17T18:46:25Z")
If you right click on the Easy chart window, you get a popup with several options to view, save, and print. Where is the code for this located? I would like to add my "pen edit" button to this menu to pop-up the pen edit… --- ## [Click to Graph refresh](https://forum.inductiveautomation.com/t/click-to-graph-refresh/894)
**Author:** [@cdmac73401](https://forum.inductiveautomation.com/u/cdmac73401)\ **Replies:** 7\ **Last updated:** [December 17, 2008, 6:32pm UTC](https://forum.inductiveautomation.com/t/click-to-graph-refresh/894 "2008-12-17T18:32:19Z")
I am using a modified version of your click to graph goodie. When pens are added to the graph, the screen will not show the added pens unless the chart property "Pens" is set to Poll at some rate. Can this be accomplishe… --- ## [Launching project with specific login](https://forum.inductiveautomation.com/t/launching-project-with-specific-login/895)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 3\ **Last updated:** [December 17, 2008, 4:52pm UTC](https://forum.inductiveautomation.com/t/launching-project-with-specific-login/895 "2008-12-17T16:52:00Z")
Hello. I have a rather straight-forward question about project launching. Is it possible to launch a project with a specific user name and password? I am basically looking to have the user login to a website and be able … --- ## [SQL code questions](https://forum.inductiveautomation.com/t/sql-code-questions/893)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [December 13, 2008, 11:11pm UTC](https://forum.inductiveautomation.com/t/sql-code-questions/893 "2008-12-13T23:11:55Z")
I have a query with the following code: SELECT TOP (100) PERCENT machine, SUM(CASE WHEN lunch = 1 THEN (runtime) END) AS lunch\_time, SUM(CASE WHEN paperwrk = 1 THEN (runtime) END) AS paper\_w… --- ## [Numeric Text Field](https://forum.inductiveautomation.com/t/numeric-text-field/892)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [December 10, 2008, 10:17pm UTC](https://forum.inductiveautomation.com/t/numeric-text-field/892 "2008-12-10T22:17:38Z")
What would be a good way to save the last value entered into a Numeric Text Field when you either log off of an app. or close it. --- ## [Access Client Concurrent](https://forum.inductiveautomation.com/t/access-client-concurrent/888)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 11\ **Last updated:** [December 9, 2008, 10:58pm UTC](https://forum.inductiveautomation.com/t/access-client-concurrent/888 "2008-12-09T22:58:39Z")
I made a project in Factory PMI, which monitored online variables (waste and operation of machine) of 5 machines (the machine are connected in ethernet network environment) with the Easy Chart component. The servers t… --- ## [Compare row's timestamp with next row's timestamp](https://forum.inductiveautomation.com/t/compare-rows-timestamp-with-next-rows-timestamp/891)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 2\ **Last updated:** [December 8, 2008, 9:27pm UTC](https://forum.inductiveautomation.com/t/compare-rows-timestamp-with-next-rows-timestamp/891 "2008-12-08T21:27:08Z")
Here is the lowdown: I’m putting together some reports on data that FSQL is collecting for us. I need to get the time from one event to the next using the timestamps. I think it can be done in a SQL statement rather tha… --- ## [Automatic FactorySQL Backup?](https://forum.inductiveautomation.com/t/automatic-factorysql-backup/889)
**Author:** [@dmcglynn](https://forum.inductiveautomation.com/u/dmcglynn)\ **Replies:** 1\ **Last updated:** [December 8, 2008, 5:14pm UTC](https://forum.inductiveautomation.com/t/automatic-factorysql-backup/889 "2008-12-08T17:14:10Z")
I saw a thread on here regarding FactoryPMI Automatic Backup, but I didn't see anything about FactorySQL. I looked at the help file included with the software, and didn't find anything there either. Can you tell me if … --- ## [Trigger button event from pressing another button](https://forum.inductiveautomation.com/t/trigger-button-event-from-pressing-another-button/886)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [December 2, 2008, 6:01pm UTC](https://forum.inductiveautomation.com/t/trigger-button-event-from-pressing-another-button/886 "2008-12-02T18:01:23Z")
I have three buttons. Button1 Button2 Button3 Button1 and Button2 do two seperate functions. Is it possible to have Button3, when pressed, trigger the actionperfromed on both Button1 and Button2 at the same time? T… --- ## [Install KepServer](https://forum.inductiveautomation.com/t/install-kepserver/884)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 4\ **Last updated:** [December 1, 2008, 6:18pm UTC](https://forum.inductiveautomation.com/t/install-kepserver/884 "2008-12-01T18:18:30Z")
I have downloaded the new version of Inductive Automation Software (FPMI 3.2.5 & FSQL 4.2.7). I want to install in Windows Server 2003 SP2, but in the installation process send me the next popup error: "Error opening… --- ## [Wrong version of FPMI being reported by applet](https://forum.inductiveautomation.com/t/wrong-version-of-fpmi-being-reported-by-applet/885)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [December 1, 2008, 6:15pm UTC](https://forum.inductiveautomation.com/t/wrong-version-of-fpmi-being-reported-by-applet/885 "2008-12-01T18:15:15Z")
I noticed that when I view the 'About FactoryPMI' page from a windowed application it correctly displays the version as 3.2.5 (build 2184), but when I view it from an applet, the version is displayed as 3.2.3 (build 2002… --- ## [MSSQL indexes and keys and FPMI](https://forum.inductiveautomation.com/t/mssql-indexes-and-keys-and-fpmi/883)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [December 1, 2008, 5:52pm UTC](https://forum.inductiveautomation.com/t/mssql-indexes-and-keys-and-fpmi/883 "2008-12-01T17:52:09Z")
I am looking for a way to better my databases. I have been reading a lot but some knowledge still eludes me. I understand the basics of indexes, to overly simplify an index is similar in nature to a what an index does in… --- ## [Document Viewer](https://forum.inductiveautomation.com/t/document-viewer/824)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 2\ **Last updated:** [November 28, 2008, 2:59am UTC](https://forum.inductiveautomation.com/t/document-viewer/824 "2008-11-28T02:59:27Z")
Hello, We have a 32" LCD set on a wall with a cycling screen, to show the status of different machines. I would like to add a few things to this: Weather Utility Status I found the document viewer plugin and paste… --- ## [Return a date string given the day number/count](https://forum.inductiveautomation.com/t/return-a-date-string-given-the-day-number-count/882)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [November 26, 2008, 9:09pm UTC](https://forum.inductiveautomation.com/t/return-a-date-string-given-the-day-number-count/882 "2008-11-26T21:09:37Z")
I am looking for a way to get the Month number and Day number given the number of days into a given year. I have a date code that I can capture that is 4 digits. The first digit is the year number, in the case of this … --- ## [E\_unknown\_item\_name](https://forum.inductiveautomation.com/t/e-unknown-item-name/881)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 5\ **Last updated:** [November 26, 2008, 7:03pm UTC](https://forum.inductiveautomation.com/t/e-unknown-item-name/881 "2008-11-26T19:03:52Z")
I'm trying to bring in tags from a new PLC (SLC 5/05) and when I try browsing the OPC, I get the following error: Browse failed with message:E\_UNKNOWN\_ITEM\_NAME. The error log may provide more information. Also, refreshi… --- ## [OutOfBounds error, accessing member of dataset, row selector](https://forum.inductiveautomation.com/t/outofbounds-error-accessing-member-of-dataset-row-selector/880)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 7\ **Last updated:** [November 26, 2008, 6:59pm UTC](https://forum.inductiveautomation.com/t/outofbounds-error-accessing-member-of-dataset-row-selector/880 "2008-11-26T18:59:34Z")
Quick question, I am currently starting to use the report plugin to replace some older access driven reports we have. In this report, I am using a sql query into the Row Selector to do filtering based on Time of Day. I… --- ## [FPMI Send Email question](https://forum.inductiveautomation.com/t/fpmi-send-email-question/878)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [November 22, 2008, 8:27pm UTC](https://forum.inductiveautomation.com/t/fpmi-send-email-question/878 "2008-11-22T20:27:29Z")
I would like to use the fpmi.net.sendEmail(“djtemail","postmaster@thompsonmailing.com”,subject,body,0,recipients) to send emails from an FPMI page. On this page I would have 10 check boxes with certain peoples names in … [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=35) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=37)