# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=33 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 34 --- ## [FactoryPMI with RS232](https://forum.inductiveautomation.com/t/factorypmi-with-rs232/1005)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [February 19, 2009, 7:17pm UTC](https://forum.inductiveautomation.com/t/factorypmi-with-rs232/1005 "2009-02-19T19:17:13Z")
Does factoryPMI have support for communicating over RS232? If not would importing the javax.comm be a possibility? --- ## [Output Console](https://forum.inductiveautomation.com/t/output-console/1002)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 5\ **Last updated:** [February 19, 2009, 6:35pm UTC](https://forum.inductiveautomation.com/t/output-console/1002 "2009-02-19T18:35:48Z")
Something changed with the output console during one of the recent upgrades. It used to only display whatever I intentionally output with "print", but now it includes all of the lines of diagnostic text that is also disp… --- ## [Easy Chart Pen Legend Display](https://forum.inductiveautomation.com/t/easy-chart-pen-legend-display/1004)
**Author:** [@dmusser](https://forum.inductiveautomation.com/u/dmusser)\ **Replies:** 1\ **Last updated:** [February 19, 2009, 5:03pm UTC](https://forum.inductiveautomation.com/t/easy-chart-pen-legend-display/1004 "2009-02-19T17:03:33Z")
I have an Easy Chart that displays Ten pens. Four of the pens are needed on the graph to represent set points and almost always stay at the same data point. However, on the pen legend I would like to be able to hide thes… --- ## [Reporting Plugin - displaying dynamic property dataset](https://forum.inductiveautomation.com/t/reporting-plugin-displaying-dynamic-property-dataset/1003)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [February 19, 2009, 5:00pm UTC](https://forum.inductiveautomation.com/t/reporting-plugin-displaying-dynamic-property-dataset/1003 "2009-02-19T17:00:16Z")
I’m not sure if this is a bug or not, but I noticed that when creating a table to display a dynamic dataset property for the reporting plugin, the fields do not evaluate correctly. For example, I have two similar datase… --- ## [Error in Graph after upgrading to FPMI 3.3.1](https://forum.inductiveautomation.com/t/error-in-graph-after-upgrading-to-fpmi-3-3-1/996)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [February 18, 2009, 11:59pm UTC](https://forum.inductiveautomation.com/t/error-in-graph-after-upgrading-to-fpmi-3-3-1/996 "2009-02-18T23:59:48Z")
I have some graphs that were functioning correctly before the upgrade using the Chart component. Now when I run them, the graph is not displaying and I get the following error com.inductiveautomation.factorypmi.commo… --- ## [Missing titled border for container](https://forum.inductiveautomation.com/t/missing-titled-border-for-container/999)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [February 18, 2009, 5:54pm UTC](https://forum.inductiveautomation.com/t/missing-titled-border-for-container/999 "2009-02-18T17:54:37Z")
I added a container to my window and noticed that the titled border option did not show up under border properties. I then went to an existing window that had a container with a titled border and the option showed a titl… --- ## [Displaying Images using HTML in project/reporting plugin](https://forum.inductiveautomation.com/t/displaying-images-using-html-in-project-reporting-plugin/997)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 2\ **Last updated:** [February 17, 2009, 8:51pm UTC](https://forum.inductiveautomation.com/t/displaying-images-using-html-in-project-reporting-plugin/997 "2009-02-17T20:51:23Z")
Once again I have rather specific inquiry. I was wondering if there is a way I can display an image from a website in the reporting plugin. In the regular design environment, I noticed I can make a given label’s text equ… --- ## [SQLTag™ Provider Status Problem](https://forum.inductiveautomation.com/t/sqltag-provider-status-problem/994)
**Author:** [@famador](https://forum.inductiveautomation.com/u/famador)\ **Replies:** 2\ **Last updated:** [February 17, 2009, 5:50am UTC](https://forum.inductiveautomation.com/t/sqltag-provider-status-problem/994 "2009-02-17T05:50:55Z")
Hi, I just installed the latest version FSQL & FPMI. I'm having problems with my SQLTags. I'm running MS SQL 2008 Express and everything is running fine except for the SQLTag Provider. Right now under the SQLTags S… --- ## [Database Buffered Group Settings](https://forum.inductiveautomation.com/t/database-buffered-group-settings/998)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [February 17, 2009, 12:04am UTC](https://forum.inductiveautomation.com/t/database-buffered-group-settings/998 "2009-02-17T00:04:58Z")
I was wondering, I had read in a posting somewhere on this site about the Buffered Group Settings in FSQL. They are under the advanced tab of the group which needs to be enabled by the end user. Anyway I had some quest… --- ## [Using two databases in the same group](https://forum.inductiveautomation.com/t/using-two-databases-in-the-same-group/989)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 4\ **Last updated:** [February 16, 2009, 5:08pm UTC](https://forum.inductiveautomation.com/t/using-two-databases-in-the-same-group/989 "2009-02-16T17:08:11Z")
I am working on an application where all of my machine data is in MSSQL and the customer and order data is in access. I can read each individual value OK but running multiple queries to Access is slow and Access is not … --- ## [Calculated tags from OPC tags](https://forum.inductiveautomation.com/t/calculated-tags-from-opc-tags/993)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 2\ **Last updated:** [February 14, 2009, 8:32pm UTC](https://forum.inductiveautomation.com/t/calculated-tags-from-opc-tags/993 "2009-02-14T20:32:30Z")
I have a few OPC flow rate tags that I would like to add together to create a total flow rate tag. For example flow1+flow2+flow3=Total flow. I then want to log the calculated tag in the same table with the OPC tags. I'm … --- ## [Chart overlays](https://forum.inductiveautomation.com/t/chart-overlays/952)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 26\ **Last updated:** [February 13, 2009, 8:17pm UTC](https://forum.inductiveautomation.com/t/chart-overlays/952 "2009-02-13T20:17:57Z")
I have a problem. Lets say i have batch data that tracks the batch time and the batch temp. Now, in the reporting plugin, i have successfully used the batch time as my x axis. (btw - that seemed to have taken me foreve… --- ## [JAVA downloader script](https://forum.inductiveautomation.com/t/java-downloader-script/992)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [February 13, 2009, 6:05pm UTC](https://forum.inductiveautomation.com/t/java-downloader-script/992 "2009-02-13T18:05:23Z")
Here is a snippet of what Carl had wrote. What I am trying to do is, is to have the downloads go to a directory on the hard drive and not the desktop. print "Connecting to %s"%string from ftplib import FTP ftp =… --- ## [Dictionaries](https://forum.inductiveautomation.com/t/dictionaries/991)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 2\ **Last updated:** [February 13, 2009, 1:57pm UTC](https://forum.inductiveautomation.com/t/dictionaries/991 "2009-02-13T13:57:31Z")
I'm having a problem iterating over python dictionaries. I can create dictionaries and access items via their keys, but if I run the following code, it fails on lines 6 and 9 on a "non-sequence" error, although it works … --- ## [Control decimal places on Y-axis of chart](https://forum.inductiveautomation.com/t/control-decimal-places-on-y-axis-of-chart/987)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 7\ **Last updated:** [February 12, 2009, 6:52pm UTC](https://forum.inductiveautomation.com/t/control-decimal-places-on-y-axis-of-chart/987 "2009-02-12T18:52:07Z")
I have two charts that are placed one above the other. My problem is the Y-axis values sometimes have 2 decimal, 3 decimal, or 4 decimal places and the two charts adjust to being different widths. Is there a way to alw… --- ## [Getting the value of a counter before it's reset](https://forum.inductiveautomation.com/t/getting-the-value-of-a-counter-before-its-reset/981)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [February 11, 2009, 8:07pm UTC](https://forum.inductiveautomation.com/t/getting-the-value-of-a-counter-before-its-reset/981 "2009-02-11T20:07:40Z")
I have a tag called DailySweeps that has an integer values and is counting the number of sweeps a machine makes during the day. There is a 2nd tag called ResetSweeps that is currently False. When ResetSweeps goes True,… --- ## [FPMI code error message when pressing button](https://forum.inductiveautomation.com/t/fpmi-code-error-message-when-pressing-button/988)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [February 11, 2009, 6:11pm UTC](https://forum.inductiveautomation.com/t/fpmi-code-error-message-when-pressing-button/988 "2009-02-11T18:11:36Z")
I have a button that has some code underneath it. Also in the root container where this button is located I have a dynamic property. The name of the dynamic property in the root container is : prod\_date The code i ha… --- ## [Using Arrays](https://forum.inductiveautomation.com/t/using-arrays/985)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 5\ **Last updated:** [February 11, 2009, 4:43pm UTC](https://forum.inductiveautomation.com/t/using-arrays/985 "2009-02-11T16:43:40Z")
I'm uploading data in a table, at each line I'm verifying that the part number already exist in the table, if it does not I'm trying to save the part number to an array to display at the end of the upload. My code is a… --- ## [Chart selection off when title boarder used](https://forum.inductiveautomation.com/t/chart-selection-off-when-title-boarder-used/986)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [February 11, 2009, 12:29am UTC](https://forum.inductiveautomation.com/t/chart-selection-off-when-title-boarder-used/986 "2009-02-11T00:29:44Z")
On may chart I decided to use a title boarder. Now when I try to select a point on the chart the selection point is above my actual plotted point. Attached is a picture of the issue. --- ## [Finding Orphaned Records](https://forum.inductiveautomation.com/t/finding-orphaned-records/982)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 5\ **Last updated:** [February 10, 2009, 9:21pm UTC](https://forum.inductiveautomation.com/t/finding-orphaned-records/982 "2009-02-10T21:21:16Z")
I know I can use either a left or right outer join to find records that exist in 2 tables and the records that exist in 1 but not the other. So how would I exclude the records that exist in both tables to show only the … --- ## [Line breaks in a Message Box](https://forum.inductiveautomation.com/t/line-breaks-in-a-message-box/984)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [February 10, 2009, 6:47pm UTC](https://forum.inductiveautomation.com/t/line-breaks-in-a-message-box/984 "2009-02-10T18:47:15Z")
Is it possible to control the display of text in a message box, like breaks or text color? --- ## [Reporting Plugin - Multiple Datasets?](https://forum.inductiveautomation.com/t/reporting-plugin-multiple-datasets/983)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [February 10, 2009, 4:27pm UTC](https://forum.inductiveautomation.com/t/reporting-plugin-multiple-datasets/983 "2009-02-10T16:27:44Z")
Hi. I wish to use the reporting plugin to generate a report based on multiple data tables. However, it appears that I cannot configure the report viewer with dynamic properties (such as additional datasets). Therefore, t… --- ## [String Conversion Error](https://forum.inductiveautomation.com/t/string-conversion-error/979)
**Author:** [@csimon1](https://forum.inductiveautomation.com/u/csimon1)\ **Replies:** 3\ **Last updated:** [February 10, 2009, 12:27am UTC](https://forum.inductiveautomation.com/t/string-conversion-error/979 "2009-02-10T00:27:11Z")
I am playing with FactorySQL to get a good feel of how it would work for our usage and came up with an error. I am trying to read a recipe from a DB to the Kepware simulation OPC. THe database is created with a column … --- ## [Open File Path & Loop to Read Records & Check If Record Exis](https://forum.inductiveautomation.com/t/open-file-path-loop-to-read-records-check-if-record-exis/980)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [February 9, 2009, 11:04pm UTC](https://forum.inductiveautomation.com/t/open-file-path-loop-to-read-records-check-if-record-exis/980 "2009-02-09T23:04:29Z")
I need to open a file path to import records from csv file into my database using PMI. My data consist of: Primary Key : Information 1 5.5 2 3.4 3 … --- ## [Number of entries in a list](https://forum.inductiveautomation.com/t/number-of-entries-in-a-list/978)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [February 7, 2009, 9:44pm UTC](https://forum.inductiveautomation.com/t/number-of-entries-in-a-list/978 "2009-02-07T21:44:59Z")
What's the easiest way to find out the number of entries in a list? Al --- ## [Automated reports](https://forum.inductiveautomation.com/t/automated-reports/975)
**Author:** [@thierryv](https://forum.inductiveautomation.com/u/thierryv)\ **Replies:** 5\ **Last updated:** [February 6, 2009, 9:01pm UTC](https://forum.inductiveautomation.com/t/automated-reports/975 "2009-02-06T21:01:58Z")
Hi, I am testing both FPMI and Dream Report. The nice thing about Dream Report is that you can say i.e. to generate a report in PDF each day and send it to person a and b and also save a copy of the report to a certain p… --- ## [Table not available](https://forum.inductiveautomation.com/t/table-not-available/976)
**Author:** [@thierryv](https://forum.inductiveautomation.com/u/thierryv)\ **Replies:** 3\ **Last updated:** [February 6, 2009, 5:39pm UTC](https://forum.inductiveautomation.com/t/table-not-available/976 "2009-02-06T17:39:53Z")
When I setup a new group in FSQL and try to start it I get the error " Table Not Available". Automatically create table is checked. Sometimes it works, sometimes not. I am already doing some logging so the db-connection … --- ## [Report Designer Plugin Aggregrate function (key)](https://forum.inductiveautomation.com/t/report-designer-plugin-aggregrate-function-key/808)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 4\ **Last updated:** [February 6, 2009, 5:22pm UTC](https://forum.inductiveautomation.com/t/report-designer-plugin-aggregrate-function-key/808 "2009-02-06T17:22:19Z")
I am looking to perform a subtract function on a column of a dataset (with 2 rows) from within the report plugin. I want to do just the opposite of what the TOTAL key does. Is there an easy way to do this? Thanks --- ## [How to save without a "save dialog"](https://forum.inductiveautomation.com/t/how-to-save-without-a-save-dialog/977)
**Author:** [@thierryv](https://forum.inductiveautomation.com/u/thierryv)\ **Replies:** 1\ **Last updated:** [February 6, 2009, 3:32pm UTC](https://forum.inductiveautomation.com/t/how-to-save-without-a-save-dialog/977 "2009-02-06T15:32:42Z")
I am trying to save a report when clicking a button. In the action event for that button I have the following code: report = event.source.parent.getComponent('Report Viewer') report.saveAsPDF("c:\\TestReport.pdf") The… --- ## [Re-Install Problems](https://forum.inductiveautomation.com/t/re-install-problems/973)
**Author:** [@csimon1](https://forum.inductiveautomation.com/u/csimon1)\ **Replies:** 2\ **Last updated:** [February 6, 2009, 1:35pm UTC](https://forum.inductiveautomation.com/t/re-install-problems/973 "2009-02-06T13:35:27Z")
I have been testing FactorySQL and had to remove it from my laptop for other reason. I now want to re-install it and I get an error message stating that I need to Stop the FactorySQL Tray Application first. My comput… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=32) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=34)