Storing data in Excel (Modicon M340, Magelis/Vijeo HMI)

I'm building a test station for water pumps. The HMI will display GPM, KWh, pressure, vacuum and speed.

Client currently manually writes down these values to keep for QC purposes. They want the data automatically entered in an Excel file.

How can this be done?


Thanks

This can store in a CSV file. Excel can open the file.

http://www.infoplc.net/files/descargas/schneider/infoplc_net_vdesigner_4_5_advanced_data_logging.pdf

This thread will also help.
http://www.plctalk.net/qanda/showthread.php?t=75592

Regards,
Garry
http://www.accautomation.ca

Does the PLC support Modbus?

gclshortt said:

This can store in a CSV file. Excel can open the file.

http://www.infoplc.net/files/descargas/schneider/infoplc_net_vdesigner_4_5_advanced_data_logging.pdf

This thread will also help.
http://www.plctalk.net/qanda/showthread.php?t=75592

Regards,
Garry
http://www.accautomation.ca

Click to expand...

Thanks, I'll read up on these.

Archie said:

Does the PLC support Modbus?

Click to expand...

Yes

Later today I will create a demo app from AdvancedHMI to show how to read from a Modbus device and write it to an Excel spreadsheet. I'll post a link to it here when I get it done.

I created a quick demo project that will read from a ModbusTCP device and write the value to an Excel spreadsheet. You can download the project from here:

https://sourceforge.net/projects/advancedhmi/files/advancedhmi/3.5/SampleProjects/

It is called AdvancedHMIModbusToExcel.zip

To run the program as is, extract the downloaded file and run \AdvancedHMI\bin\Debug\AdvancedHMI.exe

If you want to customize it, you will need to download and install Visual Studio from here:

https://www.visualstudio.com/en-us/products/visual-studio-community-vs.aspx

Also to add.... If you want this to also show the values from your PLC and use as the HMI:

- Open solution in Visual Studio
- Project->Build
- In the Solution Explorer, double click MainForm
- Click on the ModbusTCPCom1 at the bottom
- Set the IPAddress to the address of your PLC
- From the ToolBox, add a DigitalPanelMeter
- In the Properties Window, set PLCAddressValue to the Modbus address such as 40001
- Run the application (F5)

Interesting project.

Not sure how quickly you need to or can transfer the data to Excel.
Another option is to log the data at the M340 and store it there.
Subsequently you may create a batch file in Windows to connect to the controller via ftp and extract the log file, as required or periodically.
Excel will be able to open the file and use the data after that.

Archie said:

I created a quick demo project that will read from a ModbusTCP device and write the value to an Excel spreadsheet. You can download the project from here:

https://sourceforge.net/projects/advancedhmi/files/advancedhmi/3.5/SampleProjects/

It is called AdvancedHMIModbusToExcel.zip

To run the program as is, extract the downloaded file and run \AdvancedHMI\bin\Debug\AdvancedHMI.exe

If you want to customize it, you will need to download and install Visual Studio from here:

https://www.visualstudio.com/en-us/products/visual-studio-community-vs.aspx

Click to expand...

Thank you, I'll take a look and see if I can incorporate it in this project.

AutomationCtrl said:

Interesting project.

Not sure how quickly you need to or can transfer the data to Excel.
Another option is to log the data at the M340 and store it there.
Subsequently you may create a batch file in Windows to connect to the controller via ftp and extract the log file, as required or periodically.
Excel will be able to open the file and use the data after that.

Click to expand...

They test a pump for ~30mins and they want the data stored after each pump.

Do you have a working example of using the processor and batch file?

Hello rankhornjp,

The batch file created in Notepad and saved as a .bat would be something like the following:


:: set the user name used to log into the FTP server
echo user USER>> ftpcmd.dat
:: set the password used to log into the FTP server
echo USER>> ftpcmd.dat
:: do a binary download instead of ASCII
echo bin>> ftpcmd.dat
:: specify which file you desire from the the PLC and where it goes on computer
echo put C:\Users\USER\Desktop\LogData.log /usr/log/LogData.log>> ftpcmd.dat
:: quit the FTP script
echo quit>> ftpcmd.dat
:: execute the FTP command to run with the generated file above
ftp -n -s:ftpcmd.dat 192.168.0.2
:: delete the generated file
del ftpcmd.dat


I have done this with the Modicon SoMachine based controllers ( M241/M251) thus the file and directory names above.

Alter to .csv instead of .log and check the acctual directory path for the log files in the M340 controller/SD card and your computer. As far as I know, creating a .csv in the M340 is possible but I've never done it before. Accessing it via ftp seems to be possible per the following :

http://www.schneider-electric.co.uk...ang=en&id=FA198219&locale=en_US&redirect=true

Creating the .csv file in the M340 seems to be possible with the BMX NOR 0200H module for the M340.

http://www.guilleviniag.com/downloads/Products/Schneider/M340/Manuals/M340 NOR 0200H Manual.pdf