Export online DB values to Excel in Simatic Manager

sskcoepge

Member
Join Date
Feb 2010
Location
India
Posts
3
Hello,

Currently I am working on a project in which I need to export online data from a shared data block DB in Simatic Manager to excel sheet after every equal interval of time (say after every 10 seconds). The online data is constantly changing with time. After every 10 seconds the updated data from DB should be exported to excel, but without overwriting the existing data exported earlier in excel sheet.Is there any way of implementing this?


Thanks
 
...

Donno how you do it... OPC ? HMI device ?

If you have a panel, then use a script that is called every 10 seconds, use append method.


Hello,

Currently I am working on a project in which I need to export online data from a shared data block DB in Simatic Manager to excel sheet after every equal interval of time (say after every 10 seconds). The online data is constantly changing with time. After every 10 seconds the updated data from DB should be exported to excel, but without overwriting the existing data exported earlier in excel sheet.Is there any way of implementing this?


Thanks
 
Thanks... I am trying with the OPC option.
I think instead of using DB locations, if memory locations in PLC (Siemens S7 300) are used and direct connection is established between PLC and OPC server.....then later making Excel application in PC as OPC client....it may be possible to read the values at memory locations and log them at equal interval of time.
I think in Simatic Manager there is a way of configuring the OPC server, but I am not aware of how to configure it.Any idea about it?
Also, in Simatic Manager there is a way of reading online memory values in Variable table.But I couldn't get any functionality in Variable table to export the values.
Can someone please help? Thanks...

Donno how you do it... OPC ? HMI device ?

If you have a panel, then use a script that is called every 10 seconds, use append method.
 
I think in Simatic Manager there is a way of configuring the OPC server, but I am not aware of how to configure it.Any idea about it?
You should use Simatic OPC Server for this. It has built in configurator, which can import S7 projects. After you can simply connect to OPC Server and get all data in DB.
 
Last edited:
You should use Simatic OPC Server for this. It has built in configurator, which can import S7 projects. After you can simply connect to OPC Server and get all data in DB.

Thanks ssantiago...what are the hardware/software requirements for configuring the Simatic OPC server. How to configure it?
I am using Siemens S7300 PLC, Simatic Manager STEP7 V5.4, CP 5611 card. Thanks...
 
I don't remmember requirements for S7 OPC Server, but it seems like you have all nececary things.
Configuring of it was wery simle. After instaling you have launched server and its agent in system tray. From agent you can launch configurator. Here you should configure connection and plc. In main indow of configurator there are two tabs. At tab 2 it's necesry to set "chanel 1" (if i'm not mistaken in terminology) as "S7 OPC Connection". At tab 1 you creates new connection you configures data of s7 programm. For that tab good context help. After it just start server.
I was saving data to text file via small C# programm, I wrote myself.
 

Similar Topics

Hey all, Having an issue with a 1756-L73 (v20) where I'm getting a fatal error when trying to save the program online *only when selecting yes on...
Replies
5
Views
6,026
Hello, Does anyone know how to export the EDD files for a device in DeltaV Explorer 12.3? I can export the .fhx, but I have no idea how to get...
Replies
5
Views
78
Hi, I'm trying to export data from a DataGrid to Excel using VBA, but I'm getting an error "Object doesn't support this property or method". The...
Replies
0
Views
57
Hello to all, Is it possible to export Codesys symbols to .txt, .csv or .xml in a similar manner like exporting symbol table in STEP 7? For...
Replies
0
Views
102
Good morning, I have a Emerson/GE PLC with Cimplicity SCADA. I need to export data of a specific point/object to a CSV file and load the CSV file...
Replies
7
Views
205
Back
Top Bottom