Extracting tag values to excel

mittman

Member
Join Date
Sep 2011
Location
Ames
Posts
1
Hi,
I've got data captured in a tag data base on a Comactlogix L32E controller. Is there a way to get the tag values (~2500 tags with 7 datapoints per tag) into a excel file without purchasing additional software? The PLC is currently connected to a PC running RS Logix 5000,RSLinx Classic Lite and Factory talk view, via ethernet and serial connections. The data I'm after has been saved as a System Log so the data is structured as follows:

System Log _Log_Record (3000)
System Log_1 _Log_Record
Year DINT
Month DINT
etc..
Any input would be appreciated.
Thanks
 
mittman- are you wanting to stream the data or is this just a one time thing? If you want to capture it in real time I'm just about positive you'll need the full version of RSLinx.

Here's a tutorial I found:

http://www.plcdev.com/connecting_controllogix_excel

You say you also have Factory Talk view. Is there also a Panelview Plus on the system? You may be able to set up the View Point webserver and get the data that way as talked about here:

http://www.dougbrock.com/FactoryAutomation/2010/02/08/panelview-plus-webserver-its-free-2/

If you are just trying to get the data from the CPU and save it to an Excel spread sheet manually then try this:

Open the PLC project with RSLogix 5000 programming software. Right-click on the Controller Tags folder, and choose the Export Tags option from the pop-up menu. Make sure to select the RSLogix 5000 Import/Export File (*.CSV) option in the Save as Type combo-box and the All Tags in Project in the Scope box. Click the Export button to create the CSV file with the Tags Database configuration.

Edit- I just tried the above, and it doesn't export the values of the tag.

Found this thread though:

http://www.plctalk.net/qanda/showthread.php?t=48372
 
Last edited:

Similar Topics

Can anyone tell me how to extract/export tag "values" from a ControlLogix processor? I have used the Tag Upload Download Tool and the Export/Tags...
Replies
8
Views
25,918
I am attempting to access HMI tag properties (Description, Minimum, Maximum values) to populate a numeric input. Is there a clean way to do this...
Replies
0
Views
373
Is there a way to export PIDE tag settings into an excel spreadsheet? Also EUMAX,EUMIN etc. This is in RSlogix 5000 . If not if anyone is...
Replies
0
Views
1,211
Hello I am able to read tag values from a PLC after providing the tag name using an open source Ethernet/IP library. I wanted to know if it is...
Replies
7
Views
3,701
I want to export the controller Tags from the Monitor Tag tab in RSLogix 5000, ver 13. If I export, I get everything except the Values. What I...
Replies
3
Views
1,674
Back
Top Bottom