How can I extract data from a PanelView Plus or its connected 1746 L532 and transfer this information in CSV or XML format to another computer? I operate several machines that provide data such as average run time, speed, and number of stops. My IT department is looking for a solution to enable data collection that can be compiled into daily reports. We're currently utilizing FactoryTalk ME, but I'm uncertain whether Studio is necessary for this task. We reached out to our production software vendor, AMTECH, but their proposal exceeded $100,000 and only included basic product counting and calculations for production rate, which feeds data back to their server. If anyone has suggestions or insights on cost-effective solutions, I’d greatly appreciate your input. Thank you!
To enhance your data logging capabilities, consider integrating a DSP into your network or upgrading one or more of your existing PV+ units to a Red Lion system. The Crimson 3.0 software excels in data collection and can seamlessly log information in CSV format, making it easy to manage your data. Additionally, it supports FTP operations, enabling you to transfer these collected files directly to your IT department’s FTP server. Recently, I utilized a DSP to log data from a CompactLogix controller that I was not previously familiar with. Thanks to its tag import features, I was able to set everything up in just a couple of hours. I even recreated some of the HMI screens for web browser-based remote monitoring, providing the same experience as being directly in front of the PVc. This approach proved far more efficient than trying to determine whether a PanelView Compact could log data or enable remote access. Since you are currently working with a PV+, you might be able to modify your existing application to facilitate this process, potentially saving money and just requiring your investment in time. However, I’m uncertain if the PV+ series fully supports CSV format or has resolved all existing bugs related to their logging features.
In the Objects section under ActiveX Controls, you will find the MEDataStorePlus object, which is capable of recording up to 100 Analog or DINT values and 50 Strings. For further information, be sure to check out this thread: [PLC Talk Thread](http://www.plctalk.net/qanda/showthread.php?t=93413). Additionally, you might want to explore Vorne.com, an excellent resource for andon boards that leverage Excel Reporter to generate insightful reports. This solution offers features like charts, downtime tracking, OEE analysis, and a variety of other key production statistics. Their pricing starts at just a few hundred dollars and can extend up to $7,200, depending on the specific display board you select.
The information displayed on your PVP terminals is likely sourced from the SLC 5/03 processor. While it's possible to store logged data from the PVP on a network PC, interpreting this data without FactoryTalk View (FTV) tools can be quite challenging. What communication protocol are you utilizing to connect the SLC CPU with the HMI terminal? Are you using DF-1 or DH-485 protocols, and which port—Channel 0 (DB9) or Channel 1 (RJ45)—is being used? To accomplish the IT task at hand, consider linking the SLC CPU to a 1761-NET-ENI Ethernet network adapter (you can find more information here: http://literature.rockwellautomation.com/idc/groups/literature/documents/um/1761-um006_-en-p.pdf). This adapter can then connect to a Local Area Network (LAN) where a PC equipped with RSLinx Classic (more details available at: http://www.rockwellautomation.com/rockwellsoftware/products/rslinx.page#ordering-information) can either provide relevant data to other network locations in a raw format or populate a spreadsheet on the same PC. Implementing this solution should cost you less than $1,000 at the most basic functionality level.
Thank you for your assistance! I am currently connected to the SLC 1747-L532 via RS232 on DF1 Channel 1. I'm considering an upgrade to the L552 model and integrating it into a network. Additionally, I'm curious if the PV+ can be set up on a separate Ethernet network while still maintaining the RS232 connection to the SLC. The information currently shown on the PV+ is generated by the SLC through ladder logic programming. I have come across various solutions online and plan to discuss these options with my IT specialist to see what he can comprehend. This is all new to me, but it seems feasible. As far as I understand, there’s no need for continuous updates; we plan to send the information once per shift. It's important to note that they’re not currently seeking constant readouts, although this may change once they start reviewing the data. I appreciate all the insightful feedback—thank you!
Upgrading to an SLC 5/05 eliminates the necessity for the 1761-NET-ENI adapter. With RSLinx Classic Single Node, which is priced around $360.00 as of the last update, you can efficiently transfer data using Dynamic Data Exchange (DDE) directly into a local Excel spreadsheet. This makes it easy for your IT team to access the information. Additionally, your IT department can leverage the data provided by RSLinx Classic in applications developed with Visual Basic (VB). For further details, check out this discussion on [PLC Talk](http://www.plctalk.net/qanda/showthread.php?t=27949) and learn more about VB application integration [here](http://www.plctalk.net/qanda/showthread.php?s=&threadid=1093&highlight=dde).
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.