IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
RSLinx OPC Data Logging, Trying to find a simple enough way to write .csv with RSLinx and OPC
jamesfkelly
post Nov 3 2009, 12:27 PM
Post #1


Hi, I am New!
*

Group: MrPLC Member
Posts: 4
Joined: 2-November 09
Member No.: 39,883
Country:Ireland
Ireland


Greetings all,

I am fairly new to the PLC world, having doing most of my work before hand using DCS's in massive projects. I am currently working with AB compactlogix for a small enough project, designing a test/simulation rig. I am trying to find a simple way to log streaming data into a flat file (i.e. a .csv file) at a rate of 100Hz. I know technically I can do so using trending, but that method will not really suit my needs. I have looked into OPC Data Logger, but cannot get it to connect to the RSLinx OPC server. (I am running RSLinx Classic Pro - Single node)

I have been banging my head against the wall now for a weeks and am getting almost nowhere, and basically I am looking for suggestions as to the best way to get data logging capabilities for roughly 200 points with out over doing it (i.e. having to by way more software then i need).

Thanks much,
James
Go to the top of the page
 
+Quote Post
Skeet
post Nov 3 2009, 01:58 PM
Post #2


Hi, I am New!
*

Group: MrPLC Member
Posts: 2
Joined: 1-April 05
Member No.: 7,389



QUOTE (jamesfkelly @ Nov 3 2009, 01:27 PM) *
Greetings all,

I am fairly new to the PLC world, having doing most of my work before hand using DCS's in massive projects. I am currently working with AB compactlogix for a small enough project, designing a test/simulation rig. I am trying to find a simple way to log streaming data into a flat file (i.e. a .csv file) at a rate of 100Hz. I know technically I can do so using trending, but that method will not really suit my needs. I have looked into OPC Data Logger, but cannot get it to connect to the RSLinx OPC server. (I am running RSLinx Classic Pro - Single node)

I have been banging my head against the wall now for a weeks and am getting almost nowhere, and basically I am looking for suggestions as to the best way to get data logging capabilities for roughly 200 points with out over doing it (i.e. having to by way more software then i need).

Thanks much,
James


The simplest (and cheapest) solution I found this summer was from these guys:
http://www.opclogger.com/products.php

The non-Pro version is only 70 bucks or so and does .csv data recording. The next version up supports MySQL and MS-SQL as well.
Skeet
Go to the top of the page
 
+Quote Post
Wassim
post Nov 3 2009, 02:08 PM
Post #3


Hi, I am New!
*

Group: MrPLC Member
Posts: 3
Joined: 20-October 09
Member No.: 39,759
Country:Canada
Canada


Have you tried Matrikon Analytics? it's easy and connects to RSlinx perfectly... it won't hurt to try it. it's free for 30 days:

http://www.matrikonanalytics.com/products/excelreporter.aspx

Wassim Daoud
Global Solutions Architect
MatrikonOPC

QUOTE (jamesfkelly @ Nov 3 2009, 01:27 PM) *
Greetings all,

I am fairly new to the PLC world, having doing most of my work before hand using DCS's in massive projects. I am currently working with AB compactlogix for a small enough project, designing a test/simulation rig. I am trying to find a simple way to log streaming data into a flat file (i.e. a .csv file) at a rate of 100Hz. I know technically I can do so using trending, but that method will not really suit my needs. I have looked into OPC Data Logger, but cannot get it to connect to the RSLinx OPC server. (I am running RSLinx Classic Pro - Single node)

I have been banging my head against the wall now for a weeks and am getting almost nowhere, and basically I am looking for suggestions as to the best way to get data logging capabilities for roughly 200 points with out over doing it (i.e. having to by way more software then i need).

Thanks much,
James

Go to the top of the page
 
+Quote Post
jamesfkelly
post Nov 4 2009, 05:24 AM
Post #4


Hi, I am New!
*

Group: MrPLC Member
Posts: 4
Joined: 2-November 09
Member No.: 39,883
Country:Ireland
Ireland


QUOTE (jamesfkelly @ Nov 3 2009, 05:27 PM) *
Greetings all,

I am fairly new to the PLC world, having doing most of my work before hand using DCS's in massive projects. I am currently working with AB compactlogix for a small enough project, designing a test/simulation rig. I am trying to find a simple way to log streaming data into a flat file (i.e. a .csv file) at a rate of 100Hz. I know technically I can do so using trending, but that method will not really suit my needs. I have looked into OPC Data Logger, but cannot get it to connect to the RSLinx OPC server. (I am running RSLinx Classic Pro - Single node)

I have been banging my head against the wall now for a weeks and am getting almost nowhere, and basically I am looking for suggestions as to the best way to get data logging capabilities for roughly 200 points with out over doing it (i.e. having to by way more software then i need).

Thanks much,
James



Thanks lads, I am going to go ahead and try out both and see which works better for myself.

Cheers,
James
Go to the top of the page
 
+Quote Post
BobLfoot
post Nov 4 2009, 01:03 PM
Post #5


The Wizard
Group Icon

Group: MrPLC Admin
Posts: 2,556
Joined: 27-March 06
From: Southern Indiana
Member No.: 19,234
Country:United States
United States


QUOTE (jamesfkelly @ Nov 3 2009, 12:27 PM) *
Greetings all,

I am fairly new to the PLC world, having doing most of my work before hand using DCS's in massive projects. I am currently working with AB compactlogix for a small enough project, designing a test/simulation rig. I am trying to find a simple way to log streaming data into a flat file (i.e. a .csv file) at a rate of 100Hz. I know technically I can do so using trending, but that method will not really suit my needs. I have looked into OPC Data Logger, but cannot get it to connect to the RSLinx OPC server. (I am running RSLinx Classic Pro - Single node)

I have been banging my head against the wall now for a weeks and am getting almost nowhere, and basically I am looking for suggestions as to the best way to get data logging capabilities for roughly 200 points with out over doing it (i.e. having to by way more software then i need).

Thanks much,
James

James - have you looked in the downloads section at the RSlinx Excel DDE example I posted there. With RSlinx Pro and Excel VBA you should be able to gather the data you are looking for to an excel spreadsheet and the save as a csv file. I'l plan on packing 32 or 64 Ints of data at a time and transferring the packet rather than trying real time transfer. network latency will kill you otherwise.


--------------------
BobLfoot

"Poor Planning on your part does not a crisis on my part make"
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 




RSS Lo-Fi Version Time is now: 20th November 2009 - 09:28 PM