Read a csv file to save in SQL

Ignition
1

Hi there.

Can anybody help me?. I need to collect registers from a CSV file (PC) to save it in SQL. Do I mus to use any database connection or driver?. The PC is connected to our LAN.

Thanks.

2

I’d suggest connecting the Gateway to a shared folder containing the CSV file and use scripting to parse the CSV into tags. Then use transaction groups to insert into the database.
If you do a search of the forum for CSV there are plenty of scripting examples.