Entries from a spreadsheet or other coaches
LynxPad imports entries two ways: a comma or semi-colon delimited text file (one line per entry, in a fixed column order), or Lynx files (lynx.evt and lynx.ppl) from another copy of LynxPad. You don't need MileSplit or another entry service.
When fields land in the wrong columns, the file's columns are not in the order LynxPad expects, or the file uses a different delimiter than the one you chose.
How to fix it
Delimited file from a spreadsheet
- Put the columns in this order for an individual entry: A, Last Name, First Name, Gender (M or F), Team Name, Event Number, Entry Mark, Event Entry (leave blank), Event Measure (M or E).
- A relay line is: L, Team Name, Designation (A, B, C), Relay Gender (M, F or X), Event Number, Entry Time.
- Keep a delimiter for every blank field so the later fields stay in place. One entry per line, one line per event for the same athlete.
- Save as a comma or semi-colon delimited text file.
- In LynxPad, open the competition and click File | Import, then Comma Delimited Entries… or Semi-Colon Delimited Entries… to match the file, and open it.
- Read the Import Results dialog. Lines with errors are skipped and listed there.
- Example lines:
A;Doe;John;M;Hurricane High School;1;21.23;M;andL;Hurricane High School;A;M;12;4:01.44; - LynxPad importing entries from Excel walks through the spreadsheet side, and Getting Entries from MileSplit into LynxPad covers MileSplit files.
- Example lines:
Entries from coaches using their own LynxPad
- Set up the competition with events, team names and affiliations, then send the coaches your lynx.cmp and lynx.evt files, or a backup zip made with File | Backup… (named LPadBkUp_xxx-yy.zip).
- Each coach opens your competition in LynxPad (File | Restore… for a backup zip), adds their athletes, assigns them to events, enters seed marks and saves, without entering athlete IDs.
- Each coach then sends you the competition directory (at least the PPL, EVT and LSF files), or exports with File | Export | Comma Delimited Entries… (or Semi-Colon) using the delimiter you asked for.
- With your master competition open, click File | Import | Lynx Files…, browse to the coach's folder, select the EVT and PPL files and click OK. Seed marks in the LSF file come in automatically.
- Repeat for each coach, then assign ID numbers and seed the events.
For skipped entries or duplicated athletes, see Import error. The record layout is in Creating competition data from multiple sources, and backups in Backing up and restoring a competition.
Good to know
Lynx Files import skips athletes and events that already exist. A delimited file imported twice creates duplicate athletes instead, so import each file once.