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

Choose the export format to include all fields and then select the date format

The excel report will be downloaded

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

Save as a csv file

Import in the data

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

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)

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.

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.

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

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)

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 data will import

The system will report that the two records were successfully imported.

The system will report that the two records were successfully imported.

The two imported records appear with a record showing for each athlete that was included in the multiple athlete field

These can be opened  either individually or in group mode (as shown here)

0 Comments

Add your comment

E-Mail me when someone replies to this comment