plc.myforum.ro Forum Index plc.myforum.ro
PLCs users www.plc.myforum.ro!
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

OPC Record and Playback

 
Post new topic   Reply to topic    plc.myforum.ro Forum Index -> Other HMI
View previous topic :: View next topic  
Author Message
Customs
Junior
Junior


Joined: 03 Feb 2016
Posts: 2

PostPosted: 26/01/2017 12:54    Post subject: OPC Record and Playback Reply with quote

Does this actually exist?

What would be the most convenient solution for recording values from the OPC server and later write them back for simulation/training purpose?


ps.Moderators: feel free to move this post if posted in wrong category.
Back to top
View user's profile Send private message
tampa
Junior
Junior


Joined: 20 Jan 2017
Posts: 8
Location: usa

PostPosted: 26/01/2017 15:12    Post subject: Re: OPC Record and Playback Reply with quote

Customs wrote:
Does this actually exist?

What would be the most convenient solution for recording values from the OPC server and later write them back for simulation/training purpose?


ps.Moderators: feel free to move this post if posted in wrong category.

did you see that
http://plc.myforum.ro/opc-datalogger-pro-vt7235.html?highlight=opc+data+logger
Back to top
View user's profile Send private message
Customs
Junior
Junior


Joined: 03 Feb 2016
Posts: 2

PostPosted: 26/01/2017 15:56    Post subject: Reply with quote

To get data from the opc server is not a big issue. Kepware does actually have a built-in datalogger for this purpose.
My problem is to get the data back to the OPC in the same order as they where logged.
Back to top
View user's profile Send private message
tampa
Junior
Junior


Joined: 20 Jan 2017
Posts: 8
Location: usa

PostPosted: 26/01/2017 19:39    Post subject: Reply with quote

Customs wrote:
To get data from the opc server is not a big issue. Kepware does actually have a built-in datalogger for this purpose.
My problem is to get the data back to the OPC in the same order as they where logged.


Microsoft Excel is a powerful tool for data analysis and reporting. The Process IT Development Excel OPC Server is a combined OPC Server and OPC Client, designed to serve data from Excel spreadsheets.
OPC Record and Playback Re: OPC Record and Playback
use Excel OPC Server from
http://www.procdev.com/excelopcsvr.asp
You can read write to OPC
OPC DA 3.0 Server
The OPC Server supports reading and writing of Excel data. There is a one-to-one mapping between an OPC item and an Excel Sheet/Cell.
Macro Execution
The OPC server can be configured to run macros defined in the Excel spreadsheet on a regular basis.
Built-In OPC Client
The calculations performed in a spreadsheet will often use live process data from the plant. The built-in OPC client allows for very efficient updating of cells in the spreadsheet from OPC data residing in DCS or SCADA system.


That means you can use OPC to read on Excel as logging data and write to OPC what you need when you need.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    plc.myforum.ro Forum Index -> Other HMI All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
Fa-ti si tu propriul forum GRATUIT, pe www.myforum.ro