Parse CSV File
Parse a CSV file and import into a database. This sample parses a CSV file and updates the Northwind database with new customers. You can get sample Northwind databases here.
This Linx Solution uses the File, Database, and Utilities plugins.
To run the sample
- Open the ParseCSVFile solution with Linx Designer.
- Click on the Settings button.
- On the Settings tab change the values of the Settings to suit your environment (if you need help with the database connection string, have a look at this help topic).
- Open the sample Process you want to run from the Solution Explorer pane on the left.
- Click the Debug or Run buttons to run the Process.
How it works
There are three processes:
Parses the CSV file using the TextFileRead function and inserts the records into the database.
Writes the imported customers to file using the TextFileWrite function to check that the import succeeded.
Deletes the imported customers.