Event data with a multiple athlete field can be imported into the system
You can export out and import in data into the system even there is a multiple athlete field in the event form. Previously, this caused an issue which has since been resolved. Additionally, the import should only create one group entry (e.g. not a group entry of a group entry).
To export out data for an Event Form run a report on the Reports Page and select Excel
Choose the export format to include all fields and then select the date format
The excel report will be downloaded
When the data is exported out, you can edit the data and date. Do NOT change the Multiple Athletes List the data will not import for the athletes removed from the list
Save as a csv file
Import in the data
Match the athlete: you need to match the athletes using "About". Do NOT try and match the column containing multiple athletes (e.g., the multiple athlete section field), or the import will fail
Map the date and data as you would for any data import. Ensure the multiple athlete field IS mapped across correctly in this phase (e.g. the field containing the list of athletes is mapped to the field in the system that identifies this)
Import in the data.
The confirmation message will say that only 2 records were imported. This is because the system uses the FIRST record and then applies it to all athletes listed. This avoids duplicates and enables one single entry to then be applied to all athletes in the multiple athlete field
Once a report is run, the data appears, and the First entry for each date have applied to the athletes in the multiple athlete list.
Click on a record to open in either group or single entry mode
Opened in Group entry mode. It can be edited and saved again
Opened in single entry mode
N.B. The system is essentially enabling exports and imports without having to manipulate the spreadsheet and delete extra rows of data. User can just import in two records with all of the names completed in the multiple athlete field (as shown here)
Upload the file with the 2 records using the standard import work flow
Map the two athletes named in the About column (don't map the multiple athletes field or the import will fail)
Import the data as per normal
The data will import
The system will report that the two records were successfully imported.
0 Comments
Add your comment