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.