Creating a csv file

About this task

You can create a csv file to list the details of the various items to be imported. These files can be created and saved as type CSV or TSV, with or without a header row, which is a set of column headings corresponding to specific column names within the tables in the database. Each row of the file should have the information, that is added to each column in the database table, separated by a comma for a CSV file or tab for a TSV file.

Below is an example of the content of a CSV file with a header included

FORENAME,SURNAME,EMAIL

Fred,Bloggs,Fbloggs@example.com

John,Smith,JSmith@example.com

David,Brown,DBrown@example.com

Mary,Smith,MSmith@example.com

Below is an example of the content of a CSV file with no header

Fred,Bloggs,Fbloggs@example.com

John,Smith,JSmith@example.com

David,Brown,DBrown@example.com

Mary,Smith,MSmith@example.com

When you have created your csv file, map this data to the Remote Control database using a template that will import the data into the correct tables in the database.