9/13/2019 10:45 AM | |
Joined: 10/10/2005 Last visit: 8/29/2024 Posts: 1917 Rating: (136) |
Hello sixthomas, I'm not sure, but perhaps could be the FAQ meanful for you: How do you convert Data Logs (".csv" format) downloaded from the external load memory of the S7-1200 CPU into an easily readable Excel file? With best regards |
9/13/2019 3:32 PM | |
Joined: 4/7/2016 Last visit: 7/3/2024 Posts: 172 Rating: (38) |
Apologies to the moderators if this should be a different thread, but this is a specific reply to Cicero’s post on this thread. This is a problem that I have struggled with and I thought your post was the breakthrough discovery I was looking for. I followed your link, downloaded the Excel utility and ran it on a couple of log files I have. And I am damned if I can see what difference it has made. Okay the resulting file is an Excel file not a .csv file, but that is not exactly difficult to do manually. The point is that the data within is still just as utterly unusable. In exactly the same way, if you try to use the text to columns utility within Excel you get a hopelessly inconsistent result. The best technique I have found is to open the log file in a pure text editor and do a find and replace on commas replacing them with decimal points. Then open the file in Excel and do a text to columns with semi-colon as the only field separator. The result is a lot better but still a long way from perfect, and inconsistent enough to make me doubt that I can realistically develop an Excel macro to tidy it up. I have come to the point of abandoning the data logger in TIA Portal and using an external third-party data logger that allows me to specify the format of the log file. That at least gives consistent results. |
9/16/2019 3:31 PM | |
Joined: 1/24/2014 Last visit: 8/5/2024 Posts: 127 Rating: (6) |
... ok I feel ***, but not really, see the attach file |
Follow us on