Skip to main content

Event To Database

Syntax​

Event to Database
Event               event_name
Database Field      field_for_time
[Command]
Database Field      field_for_command_result
...

Parameters​

  • event_name: The source event whose data will be moved.
  • field_for_time: The database field where the event time will be stored.
  • field_for_command_result: The database field where the result of the optional command will be stored.

Description​

Moves event-related information (time, place, pace, division place, etc.) from an event into specified fields in the database.

Remarks​

This is useful for creating results suitable for mailing (like postcards sorted by ZIP code) or for storing calculated values needed for series scoring. Supported commands that can have their results stored include: EVENT, PLACE, PACE, RATE, POINTS, DIVISION PLACE, DIVISION TOTAL, DIV WINNING TIME, AGE GRADE, AGE GRADE PERCENT, PERFORMANCE FACTOR, TEAM PLACE, TEAM POSITION, DISTANCE COMPLETED, LAPS COMPLETED, TIME DIFFERENCE, and TOTAL_TIME_DIFFERENCE. This command cannot be used with Combine Events; use Merge Events first if needed.

Examples​

To move time, pace, place, division place, and division total into database fields:

Event to Database
Event               TIME
Database field      RACE1
Pace                10K
Database field      PACE
Division Place      DIV
Database field      DIVPLACE
Place
Database field      PLACE
Division Total
Database field      DIVTOTAL