Elmajestin Posted November 20, 2019 Report Share Posted November 20, 2019 Hi Everyone, I'm new in Unilogic and I would like kwon how to export data tables to Excel since a HMI button. The PLC reference is USP-104-B10. Please, it's urgente. Quote Link to comment Share on other sites More sharing options...
Swervomotor Posted November 27, 2019 Report Share Posted November 27, 2019 You can use the built in functions to send a CSV file: HMI button sets a bit--> "Store DTI to File" Make sure to set "F" to 1 so it saves a CSV file onto the SD card--> Then when the "H" status finishes (1-->0) you can use the built in "FTP Send" to send that CSV file you named in the "Store DTI to File" Then go find it and open in Excel (import as CSV). Now if you want to import it back into the PLC after you make changes to the file you need to reverse this process: save as CSV (on computer) "FTP Receive" "Convert CSV to UDTF" "Load DTI from File" 1 Quote Link to comment Share on other sites More sharing options...
Elmajestin Posted November 28, 2019 Author Report Share Posted November 28, 2019 Thanks Swervomotor for answer. The problem is that the SD port is damaged, I wanted to know if this date table can be exported directly to the computer. Quote Link to comment Share on other sites More sharing options...
Saragani Posted November 29, 2019 Report Share Posted November 29, 2019 No, it can't Quote Link to comment Share on other sites More sharing options...
Isakovic Posted November 30, 2019 Report Share Posted November 30, 2019 If you have a program that is on the plc you can read DT values and export to Excel via UniLogic. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.