# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=25 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 26 --- ## [Nested IF to write to multiple tags](https://forum.inductiveautomation.com/t/nested-if-to-write-to-multiple-tags/1277)
**Author:** [@kristophercasey](https://forum.inductiveautomation.com/u/kristophercasey)\ **Replies:** 7\ **Last updated:** [September 4, 2009, 10:25pm UTC](https://forum.inductiveautomation.com/t/nested-if-to-write-to-multiple-tags/1277 "2009-09-04T22:25:49Z")
Hi, I am having difficulty in getting this to work any help would be great. Thank you. What I am trying to accomplish is to first check to make sure the other bay is not started, write to a tag if either product 1 is s… --- ## [Database Organization Best Practices](https://forum.inductiveautomation.com/t/database-organization-best-practices/1274)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 6\ **Last updated:** [September 4, 2009, 4:19pm UTC](https://forum.inductiveautomation.com/t/database-organization-best-practices/1274 "2009-09-04T16:19:49Z")
Hello Everyone, The more I wade in to the world of FSQL and FPMI, the more tables I seem to acquire. I fear that if I just keep throwing them all into the same database that it is going to become an unmanageable night… --- ## [List Component Background Color](https://forum.inductiveautomation.com/t/list-component-background-color/1275)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [September 3, 2009, 3:47pm UTC](https://forum.inductiveautomation.com/t/list-component-background-color/1275 "2009-09-03T15:47:48Z")
I'm seeing something strange. I added a list component, set the border to 'No Border', and the background color to the same color as the parent. But, no matter what I do, the list box switches to white as soon as I save … --- ## [Global Scripts and IP filters](https://forum.inductiveautomation.com/t/global-scripts-and-ip-filters/1231)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 6\ **Last updated:** [September 2, 2009, 9:15pm UTC](https://forum.inductiveautomation.com/t/global-scripts-and-ip-filters/1231 "2009-09-02T21:15:22Z")
Quick question. In another post, I was trying to popup a report, populate the report and PRINT the report using a Global Script Timer. That works fine, but I have a question about REFINING it. Can I RELIABLY print fro… --- ## [How to reset an event meter item](https://forum.inductiveautomation.com/t/how-to-reset-an-event-meter-item/1272)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 6\ **Last updated:** [September 2, 2009, 6:18pm UTC](https://forum.inductiveautomation.com/t/how-to-reset-an-event-meter-item/1272 "2009-09-02T18:18:51Z")
I have a PLC tag reporting on a photoeye that counts from 0 to 200 whenever it is blocked, then it resets to zero and when it is blocked again, it starts counting again. I want to know the number of times this is reset … --- ## [FSQL & DB to FPMI Status Diagnostics](https://forum.inductiveautomation.com/t/fsql-db-to-fpmi-status-diagnostics/1269)
**Author:** [@dmusser](https://forum.inductiveautomation.com/u/dmusser)\ **Replies:** 1\ **Last updated:** [September 1, 2009, 8:55pm UTC](https://forum.inductiveautomation.com/t/fsql-db-to-fpmi-status-diagnostics/1269 "2009-09-01T20:55:39Z")
I have ran into problems where the groups stop logging (normally due to operator error) and where the database job services stop (note: I am using SQL Server). I am looking to create a diagnostics screen in FPMI that sho… --- ## [Reporting Plugin, Report Designer Layout](https://forum.inductiveautomation.com/t/reporting-plugin-report-designer-layout/1271)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [September 1, 2009, 7:47pm UTC](https://forum.inductiveautomation.com/t/reporting-plugin-report-designer-layout/1271 "2009-09-01T19:47:32Z")
It would be convenient to have resizable panes on the report designer. On the 'Keys' tab, if the fieldnames are too long then you can't read them. Thanks --- ## [Enable/Disable pens in script](https://forum.inductiveautomation.com/t/enable-disable-pens-in-script/1270)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 3\ **Last updated:** [September 1, 2009, 4:28pm UTC](https://forum.inductiveautomation.com/t/enable-disable-pens-in-script/1270 "2009-09-01T16:28:04Z")
I am using the Easy Chart with a pens table that has about 900 pens defined. I then manage groups of pens that can be loaded by changing the charts 'Pens' query binding. Some of these groups have several pens. A reque… --- ## [Hiding the Menu Bar](https://forum.inductiveautomation.com/t/hiding-the-menu-bar/1067)
**Author:** [@Nate](https://forum.inductiveautomation.com/u/Nate)\ **Replies:** 7\ **Last updated:** [September 1, 2009, 3:34pm UTC](https://forum.inductiveautomation.com/t/hiding-the-menu-bar/1067 "2009-09-01T15:34:02Z")
All clients to hide the menu bar? Yes No 0voters Choose up to 2 options Vote now!Show results There is currently no way to remove the menu bar from a FactoryPMI client. Being able to remove the menu bar… --- ## [Need some ideas on implementing GANTT chart](https://forum.inductiveautomation.com/t/need-some-ideas-on-implementing-gantt-chart/1254)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [August 31, 2009, 10:46pm UTC](https://forum.inductiveautomation.com/t/need-some-ideas-on-implementing-gantt-chart/1254 "2009-08-31T22:46:20Z")
I have a data set, it is created from a query that populates a table, I wish to take this dataset and use it to populate a GANTT chart. However the data in the dataset is not correctly laid out for use in the GANTT chart… --- ## [Dataset length vs width](https://forum.inductiveautomation.com/t/dataset-length-vs-width/1268)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [August 31, 2009, 3:53pm UTC](https://forum.inductiveautomation.com/t/dataset-length-vs-width/1268 "2009-08-31T15:53:40Z")
I know that there is a command called LEN() and if used on a dataset will tell you how many records long the dataset is. My question is, is there a similar command for determining the number of columns? I am using a … --- ## [Folder not showing all groups within it are running](https://forum.inductiveautomation.com/t/folder-not-showing-all-groups-within-it-are-running/1259)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 3\ **Last updated:** [August 31, 2009, 3:20pm UTC](https://forum.inductiveautomation.com/t/folder-not-showing-all-groups-within-it-are-running/1259 "2009-08-31T15:20:29Z")
I don't know if this is a feature request, problem, or bug. If all groups are started within a folder, it doesn't show the green icon in front of the folder. That is, if each group is started individually, one at a time.… --- ## [Data collection stopped](https://forum.inductiveautomation.com/t/data-collection-stopped/1264)
**Author:** [@andrewhall](https://forum.inductiveautomation.com/u/andrewhall)\ **Replies:** 2\ **Last updated:** [August 31, 2009, 3:14pm UTC](https://forum.inductiveautomation.com/t/data-collection-stopped/1264 "2009-08-31T15:14:33Z")
I had a data type problem in my MSSQL database table. I went into the MSSQL database table design and changed the datatype of a tag. At the same time i deleted a test tag (column) in the table. I did not delete the ta… --- ## [Daylight Savings Time](https://forum.inductiveautomation.com/t/daylight-savings-time/612)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 10\ **Last updated:** [August 31, 2009, 1:32am UTC](https://forum.inductiveautomation.com/t/daylight-savings-time/612 "2009-08-31T01:32:29Z")
Do you guys have some recommendations on how to properly handle Daylight Savings time? How is the 1 hour "overlap" data in the fall handled by FactorySQL and FactoryPMI? I believe the t\_stamp value is obtained from t… --- ## [Date range slider problem](https://forum.inductiveautomation.com/t/date-range-slider-problem/1266)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [August 28, 2009, 8:43pm UTC](https://forum.inductiveautomation.com/t/date-range-slider-problem/1266 "2009-08-28T20:43:07Z")
On a screen I am developing I have two daterange sliders. The first slider is working properly. What I want to be able to do is have the selected start and end daterange from the first daterange slider to populate the… --- ## [SQL Design](https://forum.inductiveautomation.com/t/sql-design/1236)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 6\ **Last updated:** [August 28, 2009, 7:57pm UTC](https://forum.inductiveautomation.com/t/sql-design/1236 "2009-08-28T19:57:19Z")
Let's say I am connecting to a bunch of machines that are quite different. For instance, let's say I wanted to monitor and record the motor speed of each machine, but the number of motors varied between 1 and 8 (but some… --- ## [Sequential Index's used as a Filter](https://forum.inductiveautomation.com/t/sequential-indexs-used-as-a-filter/1262)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 3\ **Last updated:** [August 27, 2009, 5:00pm UTC](https://forum.inductiveautomation.com/t/sequential-indexs-used-as-a-filter/1262 "2009-08-27T17:00:31Z")
First off, an example of what I have: I have a table that contains 50 rows Columns are: ndx, motor\_current, t\_stamp the ndx is numbered 1 thru 50 the motor\_current values are anywhere from 0 to 4000 I want to get a… --- ## [Audit Log Help, Where is it?](https://forum.inductiveautomation.com/t/audit-log-help-where-is-it/1263)
**Author:** [@cezipper](https://forum.inductiveautomation.com/u/cezipper)\ **Replies:** 1\ **Last updated:** [August 27, 2009, 4:33pm UTC](https://forum.inductiveautomation.com/t/audit-log-help-where-is-it/1263 "2009-08-27T16:33:04Z")
I can not find any list of what the audit log codes mean (I am looking in the Factory PMI project audit table). Such as the ACTION\_TYPEs "OT" and "LS". Please direct me to it. Thanks, Charles Zipper --- ## [Runtime Hour](https://forum.inductiveautomation.com/t/runtime-hour/1260)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 3\ **Last updated:** [August 26, 2009, 4:55pm UTC](https://forum.inductiveautomation.com/t/runtime-hour/1260 "2009-08-26T16:55:40Z")
Is it possible to have the runtime hour feature have a selectable time base. --- ## [Netbook IA Installation](https://forum.inductiveautomation.com/t/netbook-ia-installation/1256)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 3\ **Last updated:** [August 20, 2009, 8:12pm UTC](https://forum.inductiveautomation.com/t/netbook-ia-installation/1256 "2009-08-20T20:12:27Z")
I looked but have not found anything here on this so here goes... I want to be able to have a simple, inexpensive method to bring to customers to sample FPMI & FSQL datalogging. I was thinking about getting one of the… --- ## [FSQL to Database Connection Problem Alerts](https://forum.inductiveautomation.com/t/fsql-to-database-connection-problem-alerts/1253)
**Author:** [@HandledException](https://forum.inductiveautomation.com/u/HandledException)\ **Replies:** 6\ **Last updated:** [August 19, 2009, 9:37pm UTC](https://forum.inductiveautomation.com/t/fsql-to-database-connection-problem-alerts/1253 "2009-08-19T21:37:36Z")
Hello Everyone, How would one go about setting up alerts for when FSQL has problems connecting to a given database? Does FSQL have any built-in functionality which does this, or do you have to roll your own solution? … --- ## [FactorySQL Front End On Remote Computer](https://forum.inductiveautomation.com/t/factorysql-front-end-on-remote-computer/425)
**Author:** [@WildeKurt](https://forum.inductiveautomation.com/u/WildeKurt)\ **Replies:** 7\ **Last updated:** [August 19, 2009, 8:15pm UTC](https://forum.inductiveautomation.com/t/factorysql-front-end-on-remote-computer/425 "2009-08-19T20:15:39Z")
For support purposes, is it possible to have multiple PC's with the FactorySQL front end installed to support one instance of the FactorySQL service which would be running in our data center. If so, would we need to pur… --- ## [Missing some events logged as Alerts](https://forum.inductiveautomation.com/t/missing-some-events-logged-as-alerts/1251)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [August 19, 2009, 5:54pm UTC](https://forum.inductiveautomation.com/t/missing-some-events-logged-as-alerts/1251 "2009-08-19T17:54:54Z")
I have a group that is updating every 30 seconds and writing to a table. In that group I have tag BrokenBottle, that I have a digital alert set for. Each time there is a broken bottle event, this tag goes high for 5 se… --- ## [Upgrading JDBC Drivers](https://forum.inductiveautomation.com/t/upgrading-jdbc-drivers/1224)
**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Replies:** 4\ **Last updated:** [August 19, 2009, 5:44pm UTC](https://forum.inductiveautomation.com/t/upgrading-jdbc-drivers/1224 "2009-08-19T17:44:20Z")
I have had to help a few people with this recently, so I thought I'd consolidate the information here. FactoryPMI connects to databases using what are called JDBC drivers. You can add new drivers and update existing dr… --- ## [Global Tag change](https://forum.inductiveautomation.com/t/global-tag-change/1255)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 2\ **Last updated:** [August 19, 2009, 5:16pm UTC](https://forum.inductiveautomation.com/t/global-tag-change/1255 "2009-08-19T17:16:48Z")
I just ran into an issue where I had to change a Tag within FSQL from one PLC to another. I had many different FSQL groups that contained the tag that needed to be updated probably 15 to 20 different updates. I did thi… --- ## [Looking for a time duration of an event](https://forum.inductiveautomation.com/t/looking-for-a-time-duration-of-an-event/1237)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [August 19, 2009, 4:52pm UTC](https://forum.inductiveautomation.com/t/looking-for-a-time-duration-of-an-event/1237 "2009-08-19T16:52:18Z")
I have not done a lot of work on the FSQL side of things and should know how to do this, but I find I am having trouble getting it to work, so I figured I would get some expert advise. I have a tag, that I am alerting … --- ## [Group trigger based on current time](https://forum.inductiveautomation.com/t/group-trigger-based-on-current-time/1248)
**Author:** [@jimjohnson](https://forum.inductiveautomation.com/u/jimjohnson)\ **Replies:** 5\ **Last updated:** [August 18, 2009, 10:18pm UTC](https://forum.inductiveautomation.com/t/group-trigger-based-on-current-time/1248 "2009-08-18T22:18:22Z")
I am wanting to run a stored prcedure with no inputs / outputs on a 1 minute period starting at a specific number of seconds of each minute. The stored procedure is doing some intense house keeping tasks, and I actually… --- ## [Alarm History acknowledgements use only Default datasource](https://forum.inductiveautomation.com/t/alarm-history-acknowledgements-use-only-default-datasource/1249)
**Author:** [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\ **Replies:** 1\ **Last updated:** [August 18, 2009, 4:08pm UTC](https://forum.inductiveautomation.com/t/alarm-history-acknowledgements-use-only-default-datasource/1249 "2009-08-18T16:08:42Z")
I'm using the Alarm History widget available on the downloads page, and it works quite well. on this current project, however, I'm logging data into an Oracle database, but using a MySQL database for the alarms. (Mostly … --- ## [Calendar Components Questions](https://forum.inductiveautomation.com/t/calendar-components-questions/1252)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [August 18, 2009, 4:06pm UTC](https://forum.inductiveautomation.com/t/calendar-components-questions/1252 "2009-08-18T16:06:42Z")
Is is possible to use Calendar component to select the month then be able to use some sort of scripting to pick the start and end of the month. Example: Select JUNE so the begining would be JUNE 1st and the END would be … --- ## [Right to left](https://forum.inductiveautomation.com/t/right-to-left/1250)
**Author:** [@Danesh](https://forum.inductiveautomation.com/u/Danesh)\ **Replies:** 1\ **Last updated:** [August 17, 2009, 4:03pm UTC](https://forum.inductiveautomation.com/t/right-to-left/1250 "2009-08-17T16:03:59Z")
Dear All, I want to design a FactoryPMI application in Farsi language with Right to left layout. Is it possible? If yes, How can I do? M.J.Danesh [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=24) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=26)