Skip to main content

Import Replace

Syntax​

Import Replace      [~]filename.csv

Parameters​

  • [~]filename.csv: The comma-delimited ASCII file containing update data. The first field in this file must be the key field (typically the bib number) used for matching.

Description​

Imports data from a CSV file, updating existing records in the database that match on the key field (first column) and appending records that don't match.

Remarks​

This is useful for updating or correcting registration data, especially in chip/tag races where some finishers might initially only have a bib number recorded. If a bib number from the import file exists in the database, the entire database record is replaced with the data from the import file. If the bib number doesn't exist, the record is added as a new entry.

Examples​

To update existing records and add new ones from sample.csv (assuming the first column is bib number):

Import Replace      ~sample.csv