# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=30 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 31 --- ## [Java Script assistance](https://forum.inductiveautomation.com/t/java-script-assistance/1105)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 10\ **Last updated:** [April 23, 2009, 6:33pm UTC](https://forum.inductiveautomation.com/t/java-script-assistance/1105 "2009-04-23T18:33:19Z")
I will be the first to admit I dont know much about if any about JAVA. Attached is the code I am using on a button. y=0 z=0 #from ftplib import FTP import sys import fpmi sys.add\_package("org.python.core") from java.… --- ## [Type conversions](https://forum.inductiveautomation.com/t/type-conversions/1106)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 2\ **Last updated:** [April 23, 2009, 4:32pm UTC](https://forum.inductiveautomation.com/t/type-conversions/1106 "2009-04-23T16:32:32Z")
I'm trying to do something that I thought would be really easy, but my attempt is turning into a code hairball. I must be missing something. I have a series of strings that represent math sequences. Sometimes, the stri… --- ## [Sun/Oracle Merger... good or bad](https://forum.inductiveautomation.com/t/sun-oracle-merger-good-or-bad/1104)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 2\ **Last updated:** [April 22, 2009, 10:56pm UTC](https://forum.inductiveautomation.com/t/sun-oracle-merger-good-or-bad/1104 "2009-04-22T22:56:30Z")
sun.com/aboutsun/pr/2009-04/ ... 0420.1.xml Is it just me, or does this scare everybody? Depending on what Oracle is thinking, they could outright just kill MySQL development. I hope not, MySQL is faster then ever … --- ## [Displaying a table value](https://forum.inductiveautomation.com/t/displaying-a-table-value/1103)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [April 22, 2009, 9:56pm UTC](https://forum.inductiveautomation.com/t/displaying-a-table-value/1103 "2009-04-22T21:56:45Z")
I'm trying to display the value in a particular column of a table. The value can be either blank (the value in the database is NULL) or an integer. If I try to use an expression like {Root Container.Table.data}\[{R… --- ## [Copying values from one PLC to another](https://forum.inductiveautomation.com/t/copying-values-from-one-plc-to-another/1100)
**Author:** [@kjoari](https://forum.inductiveautomation.com/u/kjoari)\ **Replies:** 5\ **Last updated:** [April 22, 2009, 3:57pm UTC](https://forum.inductiveautomation.com/t/copying-values-from-one-plc-to-another/1100 "2009-04-22T15:57:22Z")
We have a system today where we are copying values from one PLC to another PLC (different brands). An example of this is a temperature from one PLC that is copied to other PLC's where it is used for calculation. What … --- ## [Submit reading to a Web Service](https://forum.inductiveautomation.com/t/submit-reading-to-a-web-service/1087)
**Author:** [@fahadaz](https://forum.inductiveautomation.com/u/fahadaz)\ **Replies:** 5\ **Last updated:** [April 21, 2009, 10:39pm UTC](https://forum.inductiveautomation.com/t/submit-reading-to-a-web-service/1087 "2009-04-21T22:39:48Z")
How can I submit reading to a Web Service? --- ## [Easy Chart group control](https://forum.inductiveautomation.com/t/easy-chart-group-control/1101)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 4\ **Last updated:** [April 21, 2009, 8:16pm UTC](https://forum.inductiveautomation.com/t/easy-chart-group-control/1101 "2009-04-21T20:16:27Z")
A feature that would be a benefit to our company is the ability to turn on or off pens at the group level. Turning each one on/off individually works but it would be much faster. It would be even better if this were expo… --- ## [Reading files](https://forum.inductiveautomation.com/t/reading-files/1102)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 0\ **Last updated:** [April 21, 2009, 5:37pm UTC](https://forum.inductiveautomation.com/t/reading-files/1102 "2009-04-21T17:37:25Z")
I've been working on a file parser, and have seen something I don't quite understand. If I read and write a file line by line, it takes much longer within the fpmi environment than within a python IDE (such as SPE). I… --- ## [Multiple reports on screen, printing without popup](https://forum.inductiveautomation.com/t/multiple-reports-on-screen-printing-without-popup/1099)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 21, 2009, 3:51pm UTC](https://forum.inductiveautomation.com/t/multiple-reports-on-screen-printing-without-popup/1099 "2009-04-21T15:51:13Z")
I have a screen where there are 4 different reports. Currently I have checkboxes for which reports the user wants to print. So if they place a checkmark in reports 1 and 3 they get reports 1 and 3. However each time a re… --- ## [Tag limit?](https://forum.inductiveautomation.com/t/tag-limit/1091)
**Author:** [@kjoari](https://forum.inductiveautomation.com/u/kjoari)\ **Replies:** 5\ **Last updated:** [April 21, 2009, 8:10am UTC](https://forum.inductiveautomation.com/t/tag-limit/1091 "2009-04-21T08:10:09Z")
I am considering the product FactorySQL. What is the limit for number of tags that can be used (bidirectional) in the system? 100.000? 1 million? How many tags have been tested "live" with this system? --- ## [Rounding OPC item values](https://forum.inductiveautomation.com/t/rounding-opc-item-values/1098)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 6\ **Last updated:** [April 20, 2009, 7:42pm UTC](https://forum.inductiveautomation.com/t/rounding-opc-item-values/1098 "2009-04-20T19:42:48Z")
I was wondering if there was an easier way to round a given value to, lets say 2 decimal places, rather than scaling up the value, converting to an integer, and scaling back down. I know I can create an action item to ro… --- ## [Table component request](https://forum.inductiveautomation.com/t/table-component-request/1094)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 20, 2009, 5:17pm UTC](https://forum.inductiveautomation.com/t/table-component-request/1094 "2009-04-20T17:17:29Z")
I am not sure if this has been mentioned before but thought it might make a nice improvement if it is possible. In the table component have a setting where you can select how the cells respond when the data contained i… --- ## [SQL Tags in Driven mode](https://forum.inductiveautomation.com/t/sql-tags-in-driven-mode/1095)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 20, 2009, 5:04pm UTC](https://forum.inductiveautomation.com/t/sql-tags-in-driven-mode/1095 "2009-04-20T17:04:55Z")
I was wondering, when you use SQL tags in driven mode, does all tags using driven mode get read or does only the tag being used get read? Example: Have 78 SQLtags which read in from the PLC's the accumulated value. The… --- ## [Database structure and "quality\_code"](https://forum.inductiveautomation.com/t/database-structure-and-quality-code/1096)
**Author:** [@kjoari](https://forum.inductiveautomation.com/u/kjoari)\ **Replies:** 3\ **Last updated:** [April 20, 2009, 10:42am UTC](https://forum.inductiveautomation.com/t/database-structure-and-quality-code/1096 "2009-04-20T10:42:48Z")
I have studied the database-structure that is created by FacotrySQL. I do see that each tag gets its own "column" in the database-table. And that all tags in one group only share the same "quality\_code" column. If you h… --- ## [SQL Tags Configuration Error](https://forum.inductiveautomation.com/t/sql-tags-configuration-error/1090)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 9\ **Last updated:** [April 18, 2009, 1:27pm UTC](https://forum.inductiveautomation.com/t/sql-tags-configuration-error/1090 "2009-04-18T13:27:50Z")
I am posting this in the FactoryPMI since this the only place I see this problem. I have an Omron CS1 PLC, Kepware OPC Server and your software. I have several values in Kepware defined as Long BCD. I can browse with… --- ## [Performance problems on FactorySQL start/restart](https://forum.inductiveautomation.com/t/performance-problems-on-factorysql-start-restart/1085)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 7\ **Last updated:** [April 17, 2009, 3:58pm UTC](https://forum.inductiveautomation.com/t/performance-problems-on-factorysql-start-restart/1085 "2009-04-17T15:58:28Z")
I've noticed when I start a customer's system that it was taking a long time to settle down to a steady state. I was able to replicate this behaviour by stopping and then restarting FactorySQL. When I did this, I notic… --- ## [Using an expression to check a dataset contains data](https://forum.inductiveautomation.com/t/using-an-expression-to-check-a-dataset-contains-data/1089)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [April 16, 2009, 4:21pm UTC](https://forum.inductiveautomation.com/t/using-an-expression-to-check-a-dataset-contains-data/1089 "2009-04-16T16:21:29Z")
Is it possible using the expression language to check whether a dataset contains any values? Specifically, I want to only enable a button if a dataset actually contains data. Al --- ## [Audio alerts not sounding](https://forum.inductiveautomation.com/t/audio-alerts-not-sounding/1086)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [April 15, 2009, 9:13pm UTC](https://forum.inductiveautomation.com/t/audio-alerts-not-sounding/1086 "2009-04-15T21:13:18Z")
I've just tried using audio alerts in FactorySQL - previously I sounded an alarm when there were any unacknowledged alarms using a global event script in each client. It would appear that the audio alerts 'Continue unt… --- ## [Child Tables](https://forum.inductiveautomation.com/t/child-tables/1078)
**Author:** [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\ **Replies:** 2\ **Last updated:** [April 15, 2009, 2:03pm UTC](https://forum.inductiveautomation.com/t/child-tables/1078 "2009-04-15T14:03:02Z")
For some reason, I can't get this to work. Hopefully someone will have an answer for me. I am looking to put 2 tables in the same window. The 1st is an Alarm Occurance table which basically just counts the number of … --- ## [Expression/Jython](https://forum.inductiveautomation.com/t/expression-jython/1084)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 14, 2009, 3:31pm UTC](https://forum.inductiveautomation.com/t/expression-jython/1084 "2009-04-14T15:31:32Z")
I know that the two are different and are used differently. Such as Jython using the FPMI usualy goes under buttons and other type action items. Where as Expression is used in other location. My question is: Is there a… --- ## [Authentication](https://forum.inductiveautomation.com/t/authentication/1083)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 13, 2009, 6:56pm UTC](https://forum.inductiveautomation.com/t/authentication/1083 "2009-04-13T18:56:28Z")
I am trying to redo some of my authentication and move it from an internal to a database setting. If my understanding is correct you can use multiple diffferent authentication profiles. So in my Internal one I still ha… --- ## [Please wait](https://forum.inductiveautomation.com/t/please-wait/1074)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 6\ **Last updated:** [April 13, 2009, 6:29pm UTC](https://forum.inductiveautomation.com/t/please-wait/1074 "2009-04-13T18:29:35Z")
Hi, I just want to let you know that I notice that lately ( since version 4.2.9) I have been getting the Please wait... operation in progress windows when I save, but the windows is not closing it is staying up I have … --- ## [List Selection: protect from no value selected](https://forum.inductiveautomation.com/t/list-selection-protect-from-no-value-selected/1081)
**Author:** [@robertkjonesjr](https://forum.inductiveautomation.com/u/robertkjonesjr)\ **Replies:** 5\ **Last updated:** [April 13, 2009, 6:00pm UTC](https://forum.inductiveautomation.com/t/list-selection-protect-from-no-value-selected/1081 "2009-04-13T18:00:03Z")
This post (http://www.inductiveautomation.com/forum/viewtopic.php?f=23&t=2716&p=3623#p3623) shows how to use an expression and script to protect against running code when no item is selected in a drop down list. Along t… --- ## [Export, Handshake on execution failure](https://forum.inductiveautomation.com/t/export-handshake-on-execution-failure/1080)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 2\ **Last updated:** [April 13, 2009, 5:50pm UTC](https://forum.inductiveautomation.com/t/export-handshake-on-execution-failure/1080 "2009-04-13T17:50:52Z")
Hi, I don't know if this has been reported before, but I notice that when you export a stored procedure group the Write Handshake on execution failure is not exported so when you import your changes this option is not … --- ## [Order of the Items](https://forum.inductiveautomation.com/t/order-of-the-items/1082)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 0\ **Last updated:** [April 13, 2009, 5:31pm UTC](https://forum.inductiveautomation.com/t/order-of-the-items/1082 "2009-04-13T17:31:42Z")
Hi, It would be nice to have a way (drag n drop or up/down buttons) to change the order of the items of a group. Today the system order the items on the order they were created but sometimes it is easy to look at a li… --- ## [Unexpected I/O error during deserialization](https://forum.inductiveautomation.com/t/unexpected-i-o-error-during-deserialization/1079)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [April 13, 2009, 4:34pm UTC](https://forum.inductiveautomation.com/t/unexpected-i-o-error-during-deserialization/1079 "2009-04-13T16:34:58Z")
I was trying to make a help window that has a textbox filled with some lengthy instruction. after saving I receive the error message in the subject when trying to open the window. I have provided the window as an attach… --- ## [FactorySQL Redundancy Setup](https://forum.inductiveautomation.com/t/factorysql-redundancy-setup/1076)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [April 9, 2009, 9:25pm UTC](https://forum.inductiveautomation.com/t/factorysql-redundancy-setup/1076 "2009-04-09T21:25:17Z")
I just configured two different server machines to run FPMI/FSQL/MySQL etc. They are on different networks, but can obviously access one another via the internet. Currently they are running independently. I plan on setti… --- ## [PropertiesLoading not false as soon as table load completes](https://forum.inductiveautomation.com/t/propertiesloading-not-false-as-soon-as-table-load-completes/1077)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [April 9, 2009, 4:22pm UTC](https://forum.inductiveautomation.com/t/propertiesloading-not-false-as-soon-as-table-load-completes/1077 "2009-04-09T16:22:03Z")
I have a screen with a table and about 10 buttons. The table displays data from the database depending on which button the user clicks on. Each button changes the query that the table is bound to. A few of them take s… --- ## [OPC Server Redundancy](https://forum.inductiveautomation.com/t/opc-server-redundancy/1075)
**Author:** [@vipulss](https://forum.inductiveautomation.com/u/vipulss)\ **Replies:** 1\ **Last updated:** [April 9, 2009, 3:53pm UTC](https://forum.inductiveautomation.com/t/opc-server-redundancy/1075 "2009-04-09T15:53:49Z")
We have two SCADA Servers in redundant mode. Both SCADA Servers have OPC servers running on them with similar tag configuration. Can FSQL connect to this OPC servers in a redundant manner. i.e. If one OPC server fails … --- ## [Configuration Page error 403](https://forum.inductiveautomation.com/t/configuration-page-error-403/1073)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [April 8, 2009, 5:18pm UTC](https://forum.inductiveautomation.com/t/configuration-page-error-403/1073 "2009-04-08T17:18:16Z")
I just finished installing FactoryPMI and when I try going to the configuration page I receive error 403. I can get to the main page and launch the designer, but cannot get to the configuration page. I am going to the… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=29) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=31)