You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

Reply
 
Thread Tools Display Modes
Old June 8th, 2015, 12:23 PM   #1
roxusa
Lifetime Supporting Member
United States

roxusa is offline
 
Join Date: Nov 2008
Location: NJ
Posts: 968
panelview plus data collection

Is there any way to collect data from a Panelview Plus or the 1746 L532 it is talking to and send this information (CSV or XML) to another computer.
I have several machines running that do display average run time, speed, number of stops etc. My IT is hoping I can give them data collection that they can process into daily reports. We are currently running Factory Talk ME, Not sure if this would require Studio or not,
We contacted the Vendor of our production Software (AMTECH) and their proposal was over 100k which basically only took a photo eye count of products being produced and did the math to determine rate and if they were running and feed this info back from each machine to the sever running their software.
Anyone have any Ideas..............Thanks
  Reply With Quote
Old June 8th, 2015, 12:33 PM   #2
OkiePC
Lifetime Supporting Member
United States

OkiePC is offline
 
OkiePC's Avatar
 
Join Date: Mar 2005
Location: ENE of Nowhere Oklahoma
Posts: 11,617
Stick a DSP on the network or upgrade one (or more) of the PV+ units to a Red Lion.

Crimson 3.0 is very good at collecting data and logging to csv format. It supports FTP operations so it can push those collected files over to the IT dept. FTP server for them too.

I recently used a DSP for some logging from a Compactlogix controller I had never seen. Using the tag import capabilities, it only took a couple of hours to get it all set up and working and I even got some of the HMI screens recreated so you can view it with a web browser for remote monitoring like you were standing in front of the PVc. This was much easier than trying to figure out if and how a Panelview Compact could log data for them, let alone remote access.

Since you are using a PV+, I think you can modify the application in order to get them to do this without having to spend anything except your time. I am not sure if they support csv format. I am not sure they have all the bugs worked out of their logging features.
__________________
You've been taken, but you don't know it yet.
  Reply With Quote
Old June 8th, 2015, 12:36 PM   #3
cwal61
Member
United States

cwal61 is offline
 
Join Date: Jan 2011
Location: NC
Posts: 1,238
Under Objects, ActiveX Controls you should see a MEDataStorePlus object. It will write upto 100 Analog or DINT and 50 Strings. Check out this Thread.
http://www.plctalk.net/qanda/showthread.php?t=93413

You may also want to look at Vorne.com it's an andon board that use Excel Reporter to create reports. Works very well. Provides Charts, Downtime, OEE, and other production stats. I think they start as low as few hundred and go up to $7200 depending on the display board chosen.
  Reply With Quote
Old June 8th, 2015, 12:53 PM   #4
dmargineau
Lifetime Supporting Member
United States

dmargineau is offline
 
dmargineau's Avatar
 
Join Date: Dec 2011
Location: Midwest
Posts: 2,507
The data you are displaying on the PVP terminals is originating within (I presume)the SLC 5/03 processor; while PVP logged data could be stored onto a network PC, "comprehending" it without FTV tools could be quite a task.
What comms protocol are you using between the SLC CPU and the HMI terminal and what port are you using for it (DF-1/DH-485, Channel 0 (DB9)/Channel 1 (RJ45)?
You could accomplish the IT required task by connecting the SLC CPU to a 1761-NET-ENI (http://literature.rockwellautomation...06_-en-p.pdf); the Ethernet network adapter could then be connected to a LAN where a PC running RSLinx Classic (http://www.rockwellautomation.com/ro...ormation)could either"serve" the pertinent data to any other network location in raw form or fill a same PC(as RSLinx) spreadsheet.
This will probably cost you (in its lowest functionality) less than $1000.00.
  Reply With Quote
Old June 8th, 2015, 01:40 PM   #5
roxusa
Lifetime Supporting Member
United States

roxusa is offline
 
Join Date: Nov 2008
Location: NJ
Posts: 968
Thanks
Currently connected to SLC 1747-L532 via RS232 DF1 Channel 1 I believe.
Looked at upgrading to L552 and putting on a network. Also wondering if the PV+ could go on an Ethernet Network separate and still run the RS232 to SLC
The Information displayed on PV+ now is generated in SLC through ladder logic.
I see several approaches to this posted and will go over with my IT guy on what all he can understand. Its all new to me but looks as though it has been done.
I do not need to continually update the information, only send it once per shift, as far as I know I don't believe they are looking for a constant readout. that may change once they start seeing the info.
I appreciate all the feedback-Thank You
  Reply With Quote
Old June 8th, 2015, 01:59 PM   #6
dmargineau
Lifetime Supporting Member
United States

dmargineau is offline
 
dmargineau's Avatar
 
Join Date: Dec 2011
Location: Midwest
Posts: 2,507
Updating to an SLC 5/05 will eliminate the need of the 1761-NET-ENI adapter.
RSLinx Classic Single Node (some $360.00 last checked)could transfer data via DDE (Dynamic Data Exchange) to a local Excel spreadsheet where your IT department could "pick it up" from.(http://www.plctalk.net/qanda/showthread.php?t=27949)
By the way, your IT department also could use RSLinx Classic provided data within a VB (Visual Basic) developed application.(http://www.plctalk.net/qanda/showthr...&highlight=dde)
  Reply With Quote
Old June 8th, 2015, 02:16 PM   #7
Ken Roach
Lifetime Supporting Member + Moderator
United States

Ken Roach is online now
 
Ken Roach's Avatar
 
Join Date: Apr 2002
Location: Seattle, WA
Posts: 17,320
The DataStorePlus ActiveX object is probably the best native tool in the PV+ to do logging to a CSV file.

You can enable and disable the DataStore Plus object so that it starts a new CSV file, and then grab the old one over FTP. The PV+ will happily connect to an Ethernet network at the same time as it communicates to controllers over a serial network connection.

One of the tricky parts of using ActiveX objects in the PV+ is that they have to be on an active screen to run; if the screen closes, so does the ActiveX.

I typically have a navigation bar that never closes, so I just put my ActiveX objects that need to run constantly onto the offscreen portion of the nav bar.

You can also do a background screen that never closes; I have used a "splash screen" where the main screen is an "On Top" rather than a "Replace" type screen. The splash screen just contains some customer logos and revision information, and a single big transparent "Open Display" button.
  Reply With Quote
Old June 8th, 2015, 03:42 PM   #8
roxusa
Lifetime Supporting Member
United States

roxusa is offline
 
Join Date: Nov 2008
Location: NJ
Posts: 968
Thanks
I will look into this option since the PV+'s are already ethernet ready
  Reply With Quote
Old April 16th, 2018, 11:46 AM   #9
RoyTKok
Member
United States

RoyTKok is offline
 
Join Date: Nov 2014
Location: Boston
Posts: 2
Collecting CSV Files Automatically

Dream Report is a new Rockwell Encompass product as of January 2018. It offers an FTP file collector that can automatically collect CSV files from remote FTP Servers (PanelView Panels) and transfer them on a schedule basis to a directory of your choice. Dream Report can then automatically process those files, extracting new data, and store the results in an RDB of your choice - MDB file, SQL Express MySQL, Oracle, etc. It will then use that stored data for any report or dashboard generation that you wish.
  Reply With Quote
Old April 16th, 2018, 12:00 PM   #10
roxusa
Lifetime Supporting Member
United States

roxusa is offline
 
Join Date: Nov 2008
Location: NJ
Posts: 968
Thanks
I ended up using a 1766-32BXB to collect data through MSG's from the various PLC's and then used RSLinx OPC to collect data into Exell
__________________
B.Pedersen
if you are going to assume, assume you're wrong.
  Reply With Quote
Old April 16th, 2018, 04:59 PM   #11
janner_10
Lifetime Supporting Member
United Kingdom

janner_10 is offline
 
Join Date: Dec 2014
Location: Tewkesbury
Posts: 1,301
Quote:
Originally Posted by roxusa View Post
Thanks
I ended up using a 1766-32BXB to collect data through MSG's from the various PLC's and then used RSLinx OPC to collect data into Exell
This would of been my suggestion, get the data to excel and pass it on to the IT guys!
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Panelview Plus Data Log File Transfer Dustin11H3 LIVE PLC Questions And Answers 20 January 8th, 2020 08:37 AM
Transferring logged data betwen PanelView Plus and PC ddeshi2 LIVE PLC Questions And Answers 1 March 13th, 2014 04:30 AM
Data Collection Christoff84 LIVE PLC Questions And Answers 6 August 20th, 2007 07:53 PM
MPI comunication Manuel Raposo LIVE PLC Questions And Answers 22 July 16th, 2007 08:24 AM
Data Collection TimothyMoulder LIVE PLC Questions And Answers 12 June 30th, 2004 05:36 PM


All times are GMT -4. The time now is 08:07 AM.


.