# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=11 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 12 --- ## [Calender and database structure](https://forum.inductiveautomation.com/t/calender-and-database-structure/4695)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 0\ **Last updated:** [June 24, 2012, 11:04pm UTC](https://forum.inductiveautomation.com/t/calender-and-database-structure/4695 "2012-06-24T23:04:35Z")
I was wandering if anyone out here in the forums have any examples of the monthly calender that is used as a "meeting room scheduler". IA's crm would be a cool example. --- ## [SuSe Studio Question for Linux Community](https://forum.inductiveautomation.com/t/suse-studio-question-for-linux-community/4676)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 1\ **Last updated:** [June 21, 2012, 3:14pm UTC](https://forum.inductiveautomation.com/t/suse-studio-question-for-linux-community/4676 "2012-06-21T15:14:10Z")
susestudio.com I was hoping to inquire if anybody in here has used this and how useful or not it would be to build a distributable Ignition Installation? --- ## [Slide Show](https://forum.inductiveautomation.com/t/slide-show/382)
**Author:** [@Darrel](https://forum.inductiveautomation.com/u/Darrel)\ **Replies:** 4\ **Last updated:** [June 11, 2012, 6:25pm UTC](https://forum.inductiveautomation.com/t/slide-show/382 "2012-06-11T18:25:16Z")
I have a need for a demo screen mounted on a wall that needs to show a slide show of random or predesigned selections of a projects windows. What is the best way to accomplish this. Also a non logged in viewer may need… --- ## [Modbus](https://forum.inductiveautomation.com/t/modbus/4513)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 5\ **Last updated:** [June 11, 2012, 3:38pm UTC](https://forum.inductiveautomation.com/t/modbus/4513 "2012-06-11T15:38:12Z")
Not sure if this is the exact area of the forum for this, but I could use some help with the addressing. The attached images describe the registers. I have the device setup vis the IP and it shows connected but I am not … --- ## [Column color for table component](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 3\ **Last updated:** [June 11, 2012, 3:11pm UTC](https://forum.inductiveautomation.com/t/column-color-for-table-component/1373 "2012-06-11T15:11:10Z")
I can see where we can set the background color for a row, but not a column. Will this be something in the works, or will I just have to satisfy myself with changing the color of the text? Or-- even more likely-- am I … --- ## [Problems with the connection with a PLC S7-300 & CP343-1Lean](https://forum.inductiveautomation.com/t/problems-with-the-connection-with-a-plc-s7-300-cp343-1lean/4528)
**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\ **Replies:** 4\ **Last updated:** [May 25, 2012, 5:25pm UTC](https://forum.inductiveautomation.com/t/problems-with-the-connection-with-a-plc-s7-300-cp343-1lean/4528 "2012-05-25T17:25:56Z")
Hi, I have a problem with the connection with a CP 343-1 Lean(communication target of siemens) that is the intermediate with a plc S7 300, i tried also to try with another type CP 343 and with it works very well, Do you… --- ## [Remote Web Pages Not working](https://forum.inductiveautomation.com/t/remote-web-pages-not-working/4478)
**Author:** [@jimjohnson](https://forum.inductiveautomation.com/u/jimjohnson)\ **Replies:** 3\ **Last updated:** [May 15, 2012, 10:24pm UTC](https://forum.inductiveautomation.com/t/remote-web-pages-not-working/4478 "2012-05-15T22:24:11Z")
Sorry if this is a common beginner question, but I can't get the web pages for Ignition to come up on any computer other than the server. I just installed my first ignition (trial) and have configured the SQL and PLC u… --- ## [SQL Server help for speeding up query](https://forum.inductiveautomation.com/t/sql-server-help-for-speeding-up-query/4349)
**Author:** [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Replies:** 1\ **Last updated:** [May 15, 2012, 5:17pm UTC](https://forum.inductiveautomation.com/t/sql-server-help-for-speeding-up-query/4349 "2012-05-15T17:17:22Z")
I have the following query in sql server 2008 r2 SELECT dh.deviceid, dh.archived, lastpoll, esttemperature, esttemperature\_alarm, staticpressure, staticpressure\_alarm, differentialpressure, differentialpressure\_alarm,… --- ## [Serial "toolkit" for Integrators](https://forum.inductiveautomation.com/t/serial-toolkit-for-integrators/197)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 7\ **Last updated:** [May 15, 2012, 1:48pm UTC](https://forum.inductiveautomation.com/t/serial-toolkit-for-integrators/197 "2012-05-15T13:48:49Z")
I'm putting together a "toolkit" of serial and Ethernet cables and adapters. I'll put together a few sets with cheap online prices so if anyone's interested, I can get you set up for a reasonable price. Here's what I hav… --- ## [PLC cable pinouts](https://forum.inductiveautomation.com/t/plc-cable-pinouts/196)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 5\ **Last updated:** [May 15, 2012, 5:18am UTC](https://forum.inductiveautomation.com/t/plc-cable-pinouts/196 "2012-05-15T05:18:43Z")
I'm looking for pinout diagrams of proprietary PLC cables. This is a good place to post requests or actual information --- ## [DateRange component events](https://forum.inductiveautomation.com/t/daterange-component-events/4416)
**Author:** [@quper](https://forum.inductiveautomation.com/u/quper)\ **Replies:** 7\ **Last updated:** [May 14, 2012, 3:34pm UTC](https://forum.inductiveautomation.com/t/daterange-component-events/4416 "2012-05-14T15:34:45Z")
Hi! I need to fire event when I move DateRange component slider. I was trying to do that with MouseReleased event, but it does not work on slider himself. It works on every other place of DateRange component around that… --- ## [Can't connect to the Lookout OPC Server](https://forum.inductiveautomation.com/t/cant-connect-to-the-lookout-opc-server/2041)
**Author:** [@robinbilliards](https://forum.inductiveautomation.com/u/robinbilliards)\ **Replies:** 4\ **Last updated:** [April 23, 2012, 7:17pm UTC](https://forum.inductiveautomation.com/t/cant-connect-to-the-lookout-opc-server/2041 "2012-04-23T19:17:01Z")
In server explorer, see the "properties" of LookoutOPCServer. Under registry tab, is the CatIDs set or not? If it's not registered, run these two commands in "Run", 1. regsvr32 "c:\\program files\\national instruments\\shar… --- ## [Navigation and dataset question](https://forum.inductiveautomation.com/t/navigation-and-dataset-question/4304)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 17, 2012, 3:22pm UTC](https://forum.inductiveautomation.com/t/navigation-and-dataset-question/4304 "2012-04-17T15:22:49Z")
I have a table on a screen title 'Production Standard by Customer' At the bottom of that screen I have an edit button and an add button. Both of these buttons with bring up a popup type of screen where the user can eithe… --- ## [Linux Tweaks for Ignition](https://forum.inductiveautomation.com/t/linux-tweaks-for-ignition/1957)
**Author:** [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\ **Replies:** 4\ **Last updated:** [April 11, 2012, 8:50pm UTC](https://forum.inductiveautomation.com/t/linux-tweaks-for-ignition/1957 "2012-04-11T20:50:11Z")
If you make or have any changes you do to your linux server running ignition list them here. Your preference may or may not be something someone else will like on the server. Kyle has a nice how-to for a base here: h… --- ## [PostgreSQL 9.1](https://forum.inductiveautomation.com/t/postgresql-9-1/4262)
**Author:** [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Replies:** 2\ **Last updated:** [April 7, 2012, 9:31pm UTC](https://forum.inductiveautomation.com/t/postgresql-9-1/4262 "2012-04-07T21:31:43Z")
Doing some testing with latest and greatest PostgreSQL.... Immediately ran into a data type issue with boolean columns. Appears Postgres no longer automatically casts integer zeros and ones into booleans when inserting… --- ## [Double-click default behavior](https://forum.inductiveautomation.com/t/double-click-default-behavior/1267)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 2\ **Last updated:** [April 6, 2012, 8:20pm UTC](https://forum.inductiveautomation.com/t/double-click-default-behavior/1267 "2012-04-06T20:20:17Z")
It would be nice if the "Choose Property" dialog box would automatically close when you double-click an item from out of the list box. Currently, you have to click to select the property and then click the OK button. D… --- ## [Request Help Printing a report](https://forum.inductiveautomation.com/t/request-help-printing-a-report/4195)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [March 26, 2012, 11:01pm UTC](https://forum.inductiveautomation.com/t/request-help-printing-a-report/4195 "2012-03-26T23:01:21Z")
I have a report that I have designed. every 5min I have a timer that checks to see if it is time to print the report. Can I, from within the timer script, using a if clause, print the report? Here is the code I have … --- ## [Remote SCADA Network Access Security](https://forum.inductiveautomation.com/t/remote-scada-network-access-security/4210)
**Author:** [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Replies:** 3\ **Last updated:** [March 26, 2012, 5:27pm UTC](https://forum.inductiveautomation.com/t/remote-scada-network-access-security/4210 "2012-03-26T17:27:28Z")
Ok, here's the deal. I have a client that I (alone) VPN into to access the Ignition gateway and other SCADA stuff. The Ignition SCADA network is isolated except for my IPCop DSL interface, which is configured to block ev… --- ## [Resize Objects](https://forum.inductiveautomation.com/t/resize-objects/4170)
**Author:** [@rdrazo](https://forum.inductiveautomation.com/u/rdrazo)\ **Replies:** 3\ **Last updated:** [March 19, 2012, 8:01pm UTC](https://forum.inductiveautomation.com/t/resize-objects/4170 "2012-03-19T20:01:37Z")
Hi, I´m new in factory PMI, I want to resize a circle shape, we need to simulate the diameter of a roll to be consumed, I can´t find the size property for Jhyton or something like this, Thanks --- ## [Slow Factory SQL](https://forum.inductiveautomation.com/t/slow-factory-sql/4102)
**Author:** [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\ **Replies:** 4\ **Last updated:** [March 13, 2012, 3:28pm UTC](https://forum.inductiveautomation.com/t/slow-factory-sql/4102 "2012-03-13T15:28:43Z")
Hi, I am facing lot of issues with factory SQL .I am using SQL server 2000 SP 4 for Database , RS OPC gateway for OPC server. Yesterday my factory SQL crash i have configured redundant system but still it didn't work.… --- ## [JDBC driver for Progress 9.1E](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362)
**Author:** [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Replies:** 9\ **Last updated:** [March 13, 2012, 2:31pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362 "2012-03-13T14:31:32Z")
I am hoping to be able to connect to Progress 9.1E database. Help/// --- ## [Connect Win911 to Ignition](https://forum.inductiveautomation.com/t/connect-win911-to-ignition/2931)
**Author:** [@erikburns](https://forum.inductiveautomation.com/u/erikburns)\ **Replies:** 5\ **Last updated:** [February 25, 2012, 2:04am UTC](https://forum.inductiveautomation.com/t/connect-win911-to-ignition/2931 "2012-02-25T02:04:51Z")
Can I connect Win911 to Ignition using the OpcCom Module? Is there any other way to connect Win911 to Ignition so that an Ack get through to Ignition? --- ## [Securing Ignition on Linux](https://forum.inductiveautomation.com/t/securing-ignition-on-linux/4030)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 3\ **Last updated:** [February 21, 2012, 10:55pm UTC](https://forum.inductiveautomation.com/t/securing-ignition-on-linux/4030 "2012-02-21T22:55:13Z")
Or just securing Linux. How do you do it? What are the pitfalls and gotchya's? I'm starting this thread as a place to share best practices to secure your installation. Linux is a growing platform with an enviable secur… --- ## [Accessing mySQL query data via OPC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317)
**Author:** [@erikburns](https://forum.inductiveautomation.com/u/erikburns)\ **Replies:** 5\ **Last updated:** [February 17, 2012, 1:02pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317 "2012-02-17T13:02:43Z")
I am interested in connecting Win911 to a query in mySQL to get alarm data. (I am populating a table with data and querying the last row). Can anyone help me configure my OPC to connect to my database? I also have Ope… --- ## [How to find data in Ignition Designer?](https://forum.inductiveautomation.com/t/how-to-find-data-in-ignition-designer/3821)
**Author:** [@ratanak](https://forum.inductiveautomation.com/u/ratanak)\ **Replies:** 1\ **Last updated:** [January 4, 2012, 7:12pm UTC](https://forum.inductiveautomation.com/t/how-to-find-data-in-ignition-designer/3821 "2012-01-04T19:12:55Z")
Hi Everyone, I have data stored in MySQL database. When I go to Ignition Designer, where can I find that data? Thanks, Nak --- ## [How to copy data from MySQL server to PLC register](https://forum.inductiveautomation.com/t/how-to-copy-data-from-mysql-server-to-plc-register/3817)
**Author:** [@ratanak](https://forum.inductiveautomation.com/u/ratanak)\ **Replies:** 8\ **Last updated:** [January 4, 2012, 7:11pm UTC](https://forum.inductiveautomation.com/t/how-to-copy-data-from-mysql-server-to-plc-register/3817 "2012-01-04T19:11:05Z")
Hi everyone, I am working on a project that is involving writing and reading data to and from PLC. I have Ignition, RSLogix 5000, and PLC (Allen-Bradley), but I don’t know how to use these tools so that I can read and … --- ## [FSQL and AB PLC](https://forum.inductiveautomation.com/t/fsql-and-ab-plc/3781)
**Author:** [@talhajee1](https://forum.inductiveautomation.com/u/talhajee1)\ **Replies:** 4\ **Last updated:** [December 21, 2011, 4:51pm UTC](https://forum.inductiveautomation.com/t/fsql-and-ab-plc/3781 "2011-12-21T16:51:06Z")
Hi , I have factory SQL and AB PLC.My question is how can i acces data from PLC. I know i have to use OPC server but can i use Inductive automation OPC UA without installing it. Talha --- ## [Canonical to remove Sun Java from Ubuntu](https://forum.inductiveautomation.com/t/canonical-to-remove-sun-java-from-ubuntu/3775)
**Author:** [@jsham](https://forum.inductiveautomation.com/u/jsham)\ **Replies:** 1\ **Last updated:** [December 19, 2011, 6:43pm UTC](https://forum.inductiveautomation.com/t/canonical-to-remove-sun-java-from-ubuntu/3775 "2011-12-19T18:43:02Z")
Seems to be an important notice on Ubuntu systems... automatic updates will remove the Sun-Java packages from Ubuntu versions 10.04+ soon... https://lists.ubuntu.com/archives/ubuntu-security-announce/2011-December/0015… --- ## [FPMI going into demo mode and expires](https://forum.inductiveautomation.com/t/fpmi-going-into-demo-mode-and-expires/3749)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 4\ **Last updated:** [December 15, 2011, 5:05pm UTC](https://forum.inductiveautomation.com/t/fpmi-going-into-demo-mode-and-expires/3749 "2011-12-15T17:05:18Z")
Is there anything we can do to keep FPMI from going into demo mode. It happens quite often now and we have to restart the service to get it back running in licensed mode. --- ## [Dynamic object](https://forum.inductiveautomation.com/t/dynamic-object/3728)
**Author:** [@bach](https://forum.inductiveautomation.com/u/bach)\ **Replies:** 6\ **Last updated:** [December 13, 2011, 12:37am UTC](https://forum.inductiveautomation.com/t/dynamic-object/3728 "2011-12-13T00:37:06Z")
Dear everyone, Please help me to create a dynamic object (please see a picture in the attached file). When pressing a button (boolean: 1 ON, 0 - OFF), all black to be the pink colour one and the all white bar to be the… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=10) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=12)