Hello everyone! We recently received a work cell from an integrator that sends saved scanning data from the PLC to the HMI (Panel View Plus). However, when I view this in Factory View, the file location appears to be \Temp\Template.csv, but I am unsure of the exact process being used to achieve this. My main concern is how to edit this Excel sheet properly. The data is not being saved in the correct columns and some entries are incorrect. It seems like the PLC is transferring the data to the HMI, which then generates the Excel sheet. Any advice on how to address this issue would be highly appreciated.
I believe the Integrator may have utilized the Read Logix tag values and saved them to a .csv file using the Recipe2 Enhanced ActiveX Control. While I haven't personally used this control, I anticipate that the ActiveX configuration will specify which tag data is being read and where it is stored in the .csv file. In FactoryTalk View Studio ME (V12), you can access help by opening Help > Contents > FactoryTalk View ME Help from the Menu. Search for ActiveX to learn more about using ActiveX controls. When you scroll down the results, you will find instructions on how to access help for the Recipe 2 Enhanced ActiveX control.
I agree with @Mike__TI's point. I am currently seeking guidance on how to make edits to an Excel document. I have gone through the available resources but have not found much information on this specific issue. Can anyone provide assistance on editing Excel documents?
After delving into the rabbit hole, I used FTP FileZilla software to uncover the file and successfully make the necessary changes. Big thanks to @Mike__T for pointing me in the right direction.
It sounds like your integrator has created a CSV file from the PLC scan data and the HMI is presenting this on your Panel View Plus. To modify how the data is being saved, you would need to edit the PLC program itself. If you have access and proper permissions to do so, look into the PLC's export settings and ensure that the values are being assigned to the correct columns. The incorrect entries might be a separate issue and could be due to scan errors or issues in the data conversion process, so I would suggest investigating that as well. Always remember to backup the original program before making any changes. Consulting with the integrator might also prove beneficial, as they would have a deeper understanding of how everything was configured initially.
Hi there! It sounds like you're dealing with a pretty common issue when integrating PLCs with HMIs. To start, you might want to check how the data is being formatted before it's sent to the HMI. Sometimes, making sure the data types and formats match up can help with how it gets laid out in the Excel sheet. You might also want to look into any configuration options in the HMI's data export settings to see if there's a way to specify column mappings or formats. Additionally, if you can access the raw data before it reaches the HMI, double-checking that could help you identify if the issue originates there or during the transfer. Hope that helps!
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: - To edit the Excel sheet generated from the PLC data transfer to PanelView Plus, you may need to understand the process flow involved in transferring the data from the PLC to the HMI and then to the Excel sheet. You can start by checking the data transfer mechanism and the configuration settings in the PLC and HMI software.
Answer: - The issue of data not being saved in the correct columns in the Excel sheet could be due to incorrect mapping or configuration settings in the PLC or HMI software. It is important to review the data transfer process and ensure that the correct data mapping is in place to accurately display the data in the Excel sheet.
Answer: - Troubleshooting incorrect entries in the Excel sheet generated from the PLC data transfer may involve checking the data integrity at each stage of the transfer process. You can verify the data at the PLC level, the HMI level, and the Excel sheet level to identify where the discrepancies are occurring and make the necessary adjustments to correct them.
Answer: - To ensure the accuracy of the data transferred from the PLC to the Excel sheet via
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.