Need some advice for an S7 and HMI

Coops · Jan 10, 2007

I have a Siemens S7 314 PLC and a Siemens 370B Touch Screen HMI. I need to send some information to a pc in excel format (.csv).

What are the best (easiest) ways of sending this information.....i've tried using the data logger built in to the HMI but can only store this logged information to a storage card on the HMI is there away of sending this data to a pc using any of the ports on the hmi (ethernet, usb etc).

Look forward to your replies....Thanks.

10BaseT. · Jan 10, 2007

try the Smart Access server .

Francie Bellew · Jan 10, 2007

Coops · Jan 10, 2007

Havent tried either of these methods before. Setup an S7 to talk to an OPC server before but didnt really want that kinda cost to setup the pc with softnet etc..

zova · Jan 10, 2007

What kind of software are you using with your MP370?

I can explain how to do it in IWS.

Coops · Jan 11, 2007

Not sure what you mean nova.....as the mp370 comes with the standard siemens software on, and then we use wincc flexible to program it.

JesperMP · Jan 11, 2007

What are the best (easiest) ways of sending this information

I think that what 10baseT suggest is to log to a .csv file on the panel, and then get access to that file from remote via smartaccess. This is an easy way.

Another relatively easy approach is to use an all-in-one package that is easier to setup than Siemens Net + homegrown scripts in excel or access.
Deltalogic has one such package at 400 Euro per license:
http://www.deltalogic.de/index.php?target=software/aglink/easylog.htm

What type of online connection do you have ?

Coops · Jan 11, 2007

JesperMP said:
I think that what 10baseT suggest is to log to a .csv file on the panel, and then get access to that file from remote via smartaccess. This is an easy way.

This sounds like a possible idea......just got to work out how to use smartaccess.

JesperMP · Jan 11, 2007

Wait. I think the option you need is sm@rtservice, not sm@rtaccess.

zova · Jan 11, 2007

Coops said:
Not sure what you mean nova.....as the mp370 comes with the standard siemens software on, and then we use wincc flexible to program it.

You can buy MP370 without wincc and use alternative software.

http://www.open-platform-program.com/Solutions/InduSoft_Press_Release.asp

Rookie_Eng · Jan 11, 2007

Writing to a file

We typically use VBscript within WinCC Flexible to write .csv, recipe files and so forth using the file system object over an ethernet connection. Usually on the higher end TP's from Siemen's the ethernet card is already included. A method to write to a specific PC could be to create a shared folder on that pc and write to that folder. Below is some very simple code to write to a text file.

Function WriteLineToFile
Const ForReading = 1, ForWriting = 2
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fspenTextFile("c:\testfile.txt", ForWriting, True)
f.WriteLine "Hello world!"
f.WriteLine "VBScript is fun!"
Set f = fspenTextFile("c:\testfile.txt", ForReading)
WriteLineToFile = f.ReadAll
End Function

In your case replace "c:\" with your shared folder name and add the necessary variables you wish to write to the f.writeline commandline.

Coops · Jan 12, 2007

Thanks for the replys fella's.....i will probably go with connecting it to the network via ethernet and writing to a shared folder on another computer...but probably use the built in data logger to write to the files.

Cheers

aikona · Jan 12, 2007

If you write a csv file to a shared directory : don't open it with Excel cause the MP370 will stop writing to it, copy the log file to another place and then open it .

We copy at midnight and plonk it into a mysql database

Cheers

Aikona

Need some advice for an S7 and HMI

Coops

Member

10BaseT.

Member

Francie Bellew

Member

Coops

Member

zova

Member

Coops

Member

JesperMP

Lifetime Supporting Member + Moderator

Coops

Member

JesperMP

Lifetime Supporting Member + Moderator

zova

Member

Rookie_Eng

Member

Coops

Member

aikona

Member

Similar Topics