Importing racers and inscriptions
* Racers are imported from File/Import racers menu item or from the Racer's database view. * Inscriptions are imported from the RaceInscription page
Both processes work in the same way. After asking for the file to import, an Import wizard are shown giving information about the file content. You will be able to match records on the file with existing data into the ZRound database, ignore records, and view racer's competition history in order to make decission in the matching process.
File structure
The CSV (comma separated values) file must follow this structure:
| Name | Field | Data type |
|---|---|---|
| Id | ZRound racer's id. Only must be used for importing inscripcions. A new id is generated when a new racer is created into the database | Text |
| Name | First Name | Text |
| Surname | Surname | Text |
| Club | Club/Sponsor | Text |
| Transponder | Transponder | Text |
| Frecuency1 | Frecuency 1. Set 0 for digital system, i.e. 2.4Ghz | Number |
| Frecuency2 | Frecuency 2. Set 0 for digital system, i.e. 2.4Ghz | Number |
| Frecuency3 | Frecuency 3. Set 0 for digital system, i.e. 2.4Ghz | Number |
| Nick | Nick name | Text |
| Ranking | Ranking level. It's the racer's driving skill level. The meaning (high/low) will be decided on the race inscription page | Number |
Example
This file has three records. * 1st. new racer (Mike Smith) * 2nd. Existing racer 22 will be changed their transponder to “31299” and ranking 9999 for the race * 3nd. Existing racer16 will be updated with new name/transponder/nick/ranking
,"Mike","Smith","RCM MadriZ","32503","0","","","MKS",9999 22,"","","","31299","0","","","" 16,"David","Keeper","","8","0","","","DTM",500
- If the file is used for import racers (instead of inscriptions) only first record will be used.
- If the racer id don't exist on the database the will be processed as new.
- If you want to “ignore” the id (for valid entries) you must “unassign” the records in the import wizard in order to be processed as new records.
