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.

There are three processes:

  • ImportCustomers
    Parses the CSV file using the TextFileRead function and inserts the records into the database.
  • ExportImportedCustomers
    Writes the imported customers to file using the TextFileWrite function to check that the import succeeded.
  • DeleteImportedCustomers
    Deletes the imported customers.

To run the sample

  1. Open the ParseCSVFile solution with Linx Designer.
  2. Click on the Settings button.
  3. 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).
  4. Open the sample Process you want to run from the Solution Explorer pane on the left.
  5. Click the Debug or Run buttons to run the Process.

Download

https://linx.software/wp-content/uploads/2017/04/ParseCSVFile-5.zip

Video

Linx 5 ParseCSV Example