Host Engineering Forum

General Category => General Discussion => Topic started by: fluidpowerman on September 24, 2015, 02:03:38 PM

Title: Logging Data to Excel or Access
Post by: fluidpowerman on September 24, 2015, 02:03:38 PM
Looking for some input Please.  I occasionally run into projects where I want to log data to a database. I am looking for ideas on better ways to do this.

Currently I am using the DoMore PLC with the Cmore HMI and logging data to my computer via the KepDirect OPC.  I am using the Datanet enterprise, a web based program that uses Access platform as a database.  I have found it to be a bit cumbersome with limited flexibility.

My project:

Operator inputs the following

Company name
Address
Purchase order number
Test Number (Is generated in the PLC logic)
Maximum Pressure

The user then starts the test and the pressure will increase.  The pressure values are logged at 5 second intervals until the test is complete.  once the test is complete the operator will generate a report with the customers information entered by the operator and a graph is generated with the logged data.  This information is now stored in the database for future reference.

I was wondering if anyone has done similar projects and might suggest programs, training, or other support I might consider.

Thanks for the input


Title: Re: Logging Data to Excel or Access
Post by: ATU on September 24, 2015, 10:20:49 PM
I have not done an application, but I have seen similar test station setups using LabView.
Title: Re: Logging Data to Excel or Access
Post by: fluidpowerman on September 25, 2015, 09:32:14 AM
Thank you for the feedback.  I haven't used Labview but have used Dasylab which is a similar but not as intricate program. 


Title: Re: Logging Data to Excel or Access
Post by: HB_GUY on October 22, 2015, 07:49:41 PM
I created a simple send data to webserver example here.
http://forum.hosteng.com/index.php/topic,1672.0.html

This could easily be adapted to log that data to a database. (That is actually how I am going to use it)

Maybe it will help you.