# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=50 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 51 --- ## [Arranging the windows in a project in tabs](https://forum.inductiveautomation.com/t/arranging-the-windows-in-a-project-in-tabs/413)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 3\ **Last updated:** [November 21, 2007, 7:01pm UTC](https://forum.inductiveautomation.com/t/arranging-the-windows-in-a-project-in-tabs/413 "2007-11-21T19:01:08Z")
How do you arrange some of the windows in a project in the form of tabs as shown in the screen shot 'Dairy Packaging Plant'. --- ## [Kepware on remote desktop](https://forum.inductiveautomation.com/t/kepware-on-remote-desktop/410)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 2\ **Last updated:** [November 19, 2007, 6:00pm UTC](https://forum.inductiveautomation.com/t/kepware-on-remote-desktop/410 "2007-11-19T18:00:09Z")
Hi Colby: Thanks a lot for your help the other day. I misplaced some of my notes and can't remember how to start kepware remotely from the run menu. something like mtsc /s or something like that to start terminal serv… --- ## [Saving a table to an excel file](https://forum.inductiveautomation.com/t/saving-a-table-to-an-excel-file/375)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 5\ **Last updated:** [November 19, 2007, 5:58pm UTC](https://forum.inductiveautomation.com/t/saving-a-table-to-an-excel-file/375 "2007-11-19T17:58:57Z")
Hi Guys, The following code throws the error shown: table = event.source.parent.getComponent("Root Container.Alarms.AlarmTable") fpmi.db.exportExcel("mytestdata.xls", 1, table.data) Error: Traceback (innermost last): … --- ## [Alarms via e-mail or pager](https://forum.inductiveautomation.com/t/alarms-via-e-mail-or-pager/324)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 4\ **Last updated:** [November 19, 2007, 5:56pm UTC](https://forum.inductiveautomation.com/t/alarms-via-e-mail-or-pager/324 "2007-11-19T17:56:17Z")
I want to monitor a temperature (refrigerator) 24/7. If it goes above my alarm set point I want to either send an e-mail to me, OR call my pager number. Any ideas? John --- ## [Having a problem](https://forum.inductiveautomation.com/t/having-a-problem/409)
**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\ **Replies:** 1\ **Last updated:** [November 19, 2007, 5:53pm UTC](https://forum.inductiveautomation.com/t/having-a-problem/409 "2007-11-19T17:53:58Z")
I am having a problem that is difficult to describe in writing. Anyone available today? --- ## [How to get column names of a dataset](https://forum.inductiveautomation.com/t/how-to-get-column-names-of-a-dataset/407)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 5\ **Last updated:** [November 15, 2007, 4:59pm UTC](https://forum.inductiveautomation.com/t/how-to-get-column-names-of-a-dataset/407 "2007-11-15T16:59:25Z")
Is there a way to get the column names of a dataset through scripting? For example, I would like to determine what columns comprise a chart component's dataset. --- ## [Can user defined functions be used in an expression?](https://forum.inductiveautomation.com/t/can-user-defined-functions-be-used-in-an-expression/408)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 6\ **Last updated:** [November 15, 2007, 4:15pm UTC](https://forum.inductiveautomation.com/t/can-user-defined-functions-be-used-in-an-expression/408 "2007-11-15T16:15:27Z")
Can a user defined function be used within a expression? For example, I want to bind a property to 'myfunction(parameter)' within an expression. --- ## [Scripting error](https://forum.inductiveautomation.com/t/scripting-error/405)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 7\ **Last updated:** [November 15, 2007, 3:51am UTC](https://forum.inductiveautomation.com/t/scripting-error/405 "2007-11-15T03:51:46Z")
The following error is occured by the script below it. Any Ideas? Error: Traceback (innermost last): File "", line 28, in ? TypeError: Unable to convert row 5, column 1 to type class java.lang.String at org.python.co… --- ## [Shown An update in progress](https://forum.inductiveautomation.com/t/shown-an-update-in-progress/403)
**Author:** [@pnendel](https://forum.inductiveautomation.com/u/pnendel)\ **Replies:** 3\ **Last updated:** [November 14, 2007, 10:20am UTC](https://forum.inductiveautomation.com/t/shown-an-update-in-progress/403 "2007-11-14T10:20:38Z")
Hi When I draw a new graph, How i can shown a "update in progress" ?? I use Factory PMI with a loww bandwtih connection and the graph can take more a minute to draw the curve. --- ## [Windows Cache control](https://forum.inductiveautomation.com/t/windows-cache-control/404)
**Author:** [@pnendel](https://forum.inductiveautomation.com/u/pnendel)\ **Replies:** 1\ **Last updated:** [November 13, 2007, 8:41am UTC](https://forum.inductiveautomation.com/t/windows-cache-control/404 "2007-11-13T08:41:17Z")
Hi, I can't found the windows cache control as explain in factory PMI manual. I work with factory PMI 2.2.0. --- ## [Multiple datasourses for a project](https://forum.inductiveautomation.com/t/multiple-datasourses-for-a-project/401)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 4\ **Last updated:** [November 9, 2007, 5:44pm UTC](https://forum.inductiveautomation.com/t/multiple-datasourses-for-a-project/401 "2007-11-09T17:44:20Z")
Hi, I realize that I can point a project to a particular datasource by selecting it as the 'Primary Datasource'. How can I utilize two different datasources for the same project? --- ## [Important Update Released - 4.0.4](https://forum.inductiveautomation.com/t/important-update-released-4-0-4/400)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [November 7, 2007, 9:00pm UTC](https://forum.inductiveautomation.com/t/important-update-released-4-0-4/400 "2007-11-07T21:00:49Z")
Hi Everyone- Just wanted to let you know that we released version 4.0.4 this morning, and we highly recommend that users with 4.0.x upgrade. Primarily it fixes a bug with OPC subscription rates on standard groups, whic… --- ## [DateExtract](https://forum.inductiveautomation.com/t/dateextract/399)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 4\ **Last updated:** [November 5, 2007, 10:36pm UTC](https://forum.inductiveautomation.com/t/dateextract/399 "2007-11-05T22:36:17Z")
I have some data in a dataset in a table. I want to use : dateExtract({Root Container.Alarms.AlarmTable.data}\[0,"clear\_time"\],"second") to get the seconds value of the datetime value in the table (Row 0 in column clea… --- ## [Industrial components - post ideas here](https://forum.inductiveautomation.com/t/industrial-components-post-ideas-here/206)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 2\ **Last updated:** [November 4, 2007, 12:31pm UTC](https://forum.inductiveautomation.com/t/industrial-components-post-ideas-here/206 "2007-11-04T12:31:10Z")
This thread is a place to gather ideas for industrial components for FactoryPMI. This is a great place to post requests for components that are common in other HMI applications. Here are some ideas so far: 7 segment/14… --- ## [Active Directory](https://forum.inductiveautomation.com/t/active-directory/397)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 4\ **Last updated:** [November 1, 2007, 10:44am UTC](https://forum.inductiveautomation.com/t/active-directory/397 "2007-11-01T10:44:00Z")
From what I understand, to use Active Directory for user access, All you need to do is add an authenticating profile and select 'Active Directory'. Fill in the 'Name', 'Domain', 'Gateway Username', 'Gateway Password', 'P… --- ## [Table Row Count](https://forum.inductiveautomation.com/t/table-row-count/396)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 2\ **Last updated:** [October 30, 2007, 3:02pm UTC](https://forum.inductiveautomation.com/t/table-row-count/396 "2007-10-30T15:02:14Z")
After I added a table bound to a SQL query, I want to access the number of rows in the table, without doing a separate query. Is there a table property that keeps the rowcount? --- ## [Default Current Date in MySQL 5.0](https://forum.inductiveautomation.com/t/default-current-date-in-mysql-5-0/295)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 5\ **Last updated:** [October 29, 2007, 7:27pm UTC](https://forum.inductiveautomation.com/t/default-current-date-in-mysql-5-0/295 "2007-10-29T19:27:09Z")
How would you default the current date in MySQl 5.0 Table Designer? --- ## [Expose default authentication profile via SQLTags or Jython](https://forum.inductiveautomation.com/t/expose-default-authentication-profile-via-sqltags-or-jython/395)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 2\ **Last updated:** [October 25, 2007, 3:24am UTC](https://forum.inductiveautomation.com/t/expose-default-authentication-profile-via-sqltags-or-jython/395 "2007-10-25T03:24:10Z")
Could system SQLTags be set up to control the default authentication profile? What about FPMI Jython functions to add/remove/edit users? (Injection attack comes to mind unless it authenticates against the user's group)… --- ## [OPC Server](https://forum.inductiveautomation.com/t/opc-server/394)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [October 24, 2007, 10:34am UTC](https://forum.inductiveautomation.com/t/opc-server/394 "2007-10-24T10:34:03Z")
Kind of a big idea for little gain, but interesting nonetheless. An OPC server in FactorySQL so that other applications (small utilities to full HMIs) can tie into SQLTags or SQL databases. I've recommended Software To… --- ## [Writing user input text from PMI to db](https://forum.inductiveautomation.com/t/writing-user-input-text-from-pmi-to-db/393)
**Author:** [@KeithB](https://forum.inductiveautomation.com/u/KeithB)\ **Replies:** 4\ **Last updated:** [October 23, 2007, 8:03pm UTC](https://forum.inductiveautomation.com/t/writing-user-input-text-from-pmi-to-db/393 "2007-10-23T20:03:22Z")
I am trying to get user loaded text from PMI inserted into a db. I need it to write to the db on a change in a sensor value ( on/off ). I have created the table and have written the attached script: if event.source.… --- ## [PLC5 PD Blocks](https://forum.inductiveautomation.com/t/plc5-pd-blocks/392)
**Author:** [@rollie715](https://forum.inductiveautomation.com/u/rollie715)\ **Replies:** 6\ **Last updated:** [October 19, 2007, 4:14pm UTC](https://forum.inductiveautomation.com/t/plc5-pd-blocks/392 "2007-10-19T16:14:21Z")
I would like to archive data from PID blocks addressing components found in the PD files such as PD90:20.OUT which is a valid address in the PLC5 using RLInx Pro. I get an error message saying Error Getting Details A… --- ## [Schedule email from FactoryPMI Gateway](https://forum.inductiveautomation.com/t/schedule-email-from-factorypmi-gateway/391)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 6\ **Last updated:** [October 18, 2007, 5:39pm UTC](https://forum.inductiveautomation.com/t/schedule-email-from-factorypmi-gateway/391 "2007-10-18T17:39:37Z")
With our network architecture, the FactoryPMI Gateway has access to the corporate email server. The FactorySQL database server does not have access to the email server. I would like to have an email sent at 7:00 AM ev… --- ## [Short cut's](https://forum.inductiveautomation.com/t/short-cuts/390)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [October 17, 2007, 7:03pm UTC](https://forum.inductiveautomation.com/t/short-cuts/390 "2007-10-17T19:03:45Z")
Is there a way to keep items that I’ve created on different projects available for all my projects on a tab or in another file or available from a file like the image path. Ex buttons that print or export to excel, butt… --- ## [Calendar](https://forum.inductiveautomation.com/t/calendar/388)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 11\ **Last updated:** [October 15, 2007, 9:13pm UTC](https://forum.inductiveautomation.com/t/calendar/388 "2007-10-15T21:13:35Z")
I've added a "calendar" control to my screen, where the operator can select a future production date for an order. But, I'm having a hard time using the mouse click event to write the date to a table. I had assumed that … --- ## [Does FactorySQL support ControlLogix UDDTs?](https://forum.inductiveautomation.com/t/does-factorysql-support-controllogix-uddts/60)
**Author:** [@integrator\_adam72](https://forum.inductiveautomation.com/u/integrator_adam72)\ **Replies:** 4\ **Last updated:** [October 15, 2007, 6:35pm UTC](https://forum.inductiveautomation.com/t/does-factorysql-support-controllogix-uddts/60 "2007-10-15T18:35:06Z")
Does FactorySQL support ControlLogix User defined data types? Is there something special that you need to do with RSLinx or buy? --- ## [Row Selection](https://forum.inductiveautomation.com/t/row-selection/371)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 6\ **Last updated:** [October 15, 2007, 5:10pm UTC](https://forum.inductiveautomation.com/t/row-selection/371 "2007-10-15T17:10:41Z")
I'm having a problem with the "selection background color" on a table. Here is the scenario: Let's say the operator has created a table of ten orders in a certain sequence. He then wants to move the order with sequence … --- ## [Unable to reach the configuration page from outside network](https://forum.inductiveautomation.com/t/unable-to-reach-the-configuration-page-from-outside-network/387)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 2\ **Last updated:** [October 12, 2007, 7:58pm UTC](https://forum.inductiveautomation.com/t/unable-to-reach-the-configuration-page-from-outside-network/387 "2007-10-12T19:58:44Z")
When I connect to the machine hosting the PMI from outside the network like (ipaddress:port#), I am able to see all the projects and launch them. I am also able to launch the designer, but when I try to get to the config… --- ## [Automatic printing in Windows](https://forum.inductiveautomation.com/t/automatic-printing-in-windows/386)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [October 11, 2007, 7:13pm UTC](https://forum.inductiveautomation.com/t/automatic-printing-in-windows/386 "2007-10-11T19:13:05Z")
Do you get weird requests from customers to print things automatically. A post from the Mrplc forum mentions Batchprint. For $60 you have all sorts of scheduled printing options and can turn a directory into a print queu… --- ## [I have new forum for answer about PLC com to put you Qc](https://forum.inductiveautomation.com/t/i-have-new-forum-for-answer-about-plc-com-to-put-you-qc/384)
**Author:** [@nuttaphong191](https://forum.inductiveautomation.com/u/nuttaphong191)\ **Replies:** 1\ **Last updated:** [October 10, 2007, 8:36pm UTC](https://forum.inductiveautomation.com/t/i-have-new-forum-for-answer-about-plc-com-to-put-you-qc/384 "2007-10-10T20:36:30Z")
I have new forum for answer about PLC com to put you Qc tryplc.com/Forum/index.php --- ## [Jython DATETIME Tip](https://forum.inductiveautomation.com/t/jython-datetime-tip/383)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 3\ **Last updated:** [October 10, 2007, 4:02pm UTC](https://forum.inductiveautomation.com/t/jython-datetime-tip/383 "2007-10-10T16:02:06Z")
This tip can help you to determine the amount of time that has lapsed between two DATETIME values in MySQL. I had a situation where I needed to determine the amount of time that had lapsed between (2) DATETIME values i… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=49) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=51)