Skip to main content

Import

Syntax​

Import              [~]filename.csv
[Field rs_field_name1]
[Field rs_field_name2]
...

Parameters​

  • [~]filename.csv: The comma-delimited ASCII file to import. Use ~ if the file is in the race folder; otherwise, it's assumed to be in the RunScore folder.
  • rs_field_name: Optional. Specifies the RunScore field name corresponding to a column in the CSV file. If used, the order of these Field commands must match the column order in the CSV.

Description​

Imports data from a comma-delimited file (typically .csv) into the RunScore database.

Remarks​

The command expects the first line of the CSV file to contain field headers. If these headers match your RunScore field names exactly, no Field commands are needed. If they don't match, or if the order is different, you must use Field commands to map the CSV columns (in order) to the correct RunScore fields. The command appends the imported data to the existing database and rebuilds search fields. Use Import Replace to update existing records based on a key field (like bib number). The delimiter can be changed with Import Delimiter.

Examples​

To import a CSV file where the headers match RunScore fields:

Import              ~registrations.csv

To import a CSV file where headers don't match, mapping CSV columns 1 and 2 to RunScore's first name and last name:

Import              ~online_reg.csv
Field               first name
Field               last name
... etc. for other columns ...