Importing CSV File of Table

Data can be input into a Data Base Table by importing a CSV file of the Table.

To import a CSV file of Table you should:

• ensure that the name of the CSV file ends in .csv
• run FirstBreak and select the Import CSV file item from the Operations menu
• Find the folder and select the name of the CSV file in the Import File Dialog which will appear
• Tick or cancel the Overwrite existing records? check box as required. See Note 1
• Click on the Import file button

If Table Field Names have not been included in the CSV file you will have also to select the required Table in the Select Table dialog that will appear.

Notes:

1. If a Ref in the CSV file matches the Ref of an existing Record in the Table and the Overwrite existing records? check box is ticked, the existing Record is overwritten. Contrariwise if a Ref in the CSV file matches the Ref of an existing Record in the Table and the Overwrite existing records? check box is not ticked, the line of the CSV file is skipped and the existing Record is left unchanged.
2. Since the Mix Components Table refers to Components and Mixes, you should import the Components Table and Mixes Table before importing the Mix Components Table.
3. Since the Batches Table refers to Projects and Mixes, you should import the Projects Table and Mixes Table before importing the Batches Table.
4. Since the Test Strengths Table refers to Batches and Test Ages, you should enter data into the Batches Table and Test Ages Table before entering data into the Test Strengths Table.