Export Data table from HMI button

[Elmajestin]

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.

[Swervomotor]

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"

 

 

[Elmajestin]

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.

[Saragani]

No, it can't

[Isakovic]

If you have a program that is on the plc you can read DT values and export to Excel via UniLogic.