Export

Syntax

Export              [ISO Date]
Export Delimiter    character

Parameters

• ISO Date: Optional keyword. When present, all date fields are exported in ISO format (YYYY-MM-DD).
• Export Delimiter character: Optional. Sets the delimiter character between fields. The default is a comma. Use tab (case-insensitive) for a tab delimiter, or any single character (e.g., *, |).

Description

Generates a delimited text file containing selected database fields and event results. The default format is comma-separated values (CSV). If a field contains a comma, that field is enclosed in double quotes.

Remarks

• Direct the output to a file using the Destination command.
• If no Field or Event commands follow Export, all database fields are exported.
• Use Select commands to filter which records are exported.
• Use Squeeze between two Field commands to concatenate fields (e.g., first and last names).
• Use No Column Headers to suppress the header row.
• Use Records/Page to limit the number of records exported.
• To export event results (time, place, pace), use the same Event, Place, and Pace commands as in a regular listing. Run Event to Database first if you need those values as database fields.
• For a quick export of all fields and the entire database, use the Export option from the Files menu instead.

Examples

Export selected fields to a CSV file:

Export
Destination         5K.csv
Field               FIRST NAME
Field               LAST NAME
Field               ADDRESS
Field               CITY
Field               STATE
Field               ZIP

Export all fields for female runners:

Export
Destination         female.csv
Select              SEX
=                   F

Export with event results (net time, pace, gun time):

Export
Destination         results_upload.csv
Field               registration_id
Event               TIME
Minus               start
Place
Field Header        Net Time
Pace                10K
Event               TIME
Minus               0:00:10
Field Header        Gun Time

Use a custom delimiter:

Export
Export Delimiter    *
Destination         results.txt
Field               FIRST NAME
Field               LAST NAME

Export dates in ISO format:

Export              ISO Date
Destination         entries.csv