CSV import to MySQL

Been struggling getting a foreign database data exported to a CSV imported into Ignition to store into MySQL tables. Issue I am having is there are 1000s of records to import, and going through each record to insert " " is not practical to format the data so the system.dataset.fromCSV(data_string) script function works properly.

Doing a little digging I came across the Add In for MySQL

This will allow for any Excel file to be imported directly into a MySQL table.

I had the customer’s IT guy save the exported data as an *.XLS file , and using this utility imported 1000s of records into MySQL in minutes without using any script.

4 Likes