How to Import Data from a .csv file into a form with one or multiple Tables
Importing data into tables need to be performed correctly or all of the rows in the .csv spreadsheet will be read as individual rows and a separate record will be created for each row. However, if you are importing in data into a table you need multiple rows from a spreadsheet to be imported into one record. Follow the steps below to successfully import data into tables.
In the athlete history, the record shows the table entries and the non tables entries
You can see in the athlete history that the option fields are filled down for all possible rows, however any numeric fields that are not in a table do not fill down so as not to affect any averages or totals that may have been set to appear for that field. However, during the import process, all fields that are not a table field need to be filled down (e.g. Best Distance 1 and Best Distance 2) if you want the system to identify the three rows of data as one record.
#1: The single selection field conditions is filled down in the athlete history display (which is correct
#2: The numeric field that is not in a table does not fill down (which used to affect reimport)
#3: The Table with 2 rows of data in it only displays over 2 rows (correct for reimport)
#4:The Table with 3 rows of data in it displays over 3 rows (correct for reimport)
However, if you generated a .csv spreadsheet from this record, you would need to fill down all fields that are not table rows before you could re-import it back in
In the image here both of the records that have data entered in them have been exported to a csv file (the cells corresponding to table entries have been highlighted yellow). Previously, if you were going to reimport this data back into the system you would have to manually fill down an numeric fields that were not filled (e.g. the fields Best Distance are not autofilled, so 55 would have to be copied into the two blank cells on the 29/07/2013 record, and 44 would have to be copied into the two blank cells for the 7/08/2013 record etc.). If the autofill was not completed each row in the spreadsheet would be imported as an individual entry (e.g. 6 separate record), as opposed to only 2 records with table data.
Now, during the import process you can specify that any rows of data entered for an athlete on the same date are treated as the same record.
Now, if you generate a .csv file from the system, you can import it back into the system without having to manually fill down any numeric fields
To Import Data into an Event Form with a table, follow the usual import steps
Check the Date and map the columns to the field name, and click on "Treat all records for the same user on the same day as a single record"
You may be asked to map across any options with different spelling or casing to the system. Do this, and select to send or skip your alerts
The import report will say that the exact number of rows that have been imported
If you run a report for the athlete/s and the date range you imported it in you will see only 2 records (with 6 rows of data) have been imported
All of the data has been imported correctly into 2 records (before the "import as the same record was built" 6 individual records would have appeared)
If you are importing in data from a different source you will need to make the athlete's name and the date are written for EACH row
If you are importing in data from an external source, or from historical records stored in a different format, you will need to ensure that each row has the correct date and the athlete's name. If it is not, the data will be split during import