from qjrl.trn into Swiss Perfect
QJRL.trn, the Qld
Junior rating system database, is available as a Swiss Perfect
tournament file – registration of players in tournaments has never
For tournament organisers/arbiters not yet familiar with using the
player import facility, there are some steps to follow first to set
up the database for use.
Download QJRL.trn from the Ratings page - the file will be named
QJRL0910.TRN or similar (the download dialog box will
show into which folder the file will be downloaded – change to a
preferred folder if you wish before clicking Save, but
in either case note which folder is being used).
Copy the file to your Swiss Perfect folder C:\SP98 (or use the
Browse button to locate your Swiss Perfect folder). You
are now ready to start importing player details.
Start Swiss Perfect and initiate a new tournament – call it Test or
When ready to start, click Player -> Import. A dialog box will open
saying "Importing from C:\SP98\QJRL.TRN. Use
Options/Import Setup if you want to change the database." (If the
specified database is NOT QJRL.trn, then you do want to change the
database – press ESC then from the SP menu bar select Options ->
Import setup, locate and click on the file QJRL.TRN to highlight it,
then click Open.
The Import Player Setup screen appears, used for identifying
(‘mapping’) each data column (‘field’) in the database. The screen
should be already filled in for you. NOTE PARTICULARLY that the
Rating Loc. Field must be completed – if it is blank key in LOC_RTG.
In the Surname Field Options make sure the ‘First name is part of
Surname’ box is NOT ticked. If it is, click the button to disable it
(i.e. remove the tick).
Click the Save Mapping As.. button. In the new Enter Mapping Name
box type QJRL. Click OK – QJRL now appears in the Mapping Name box.
When used in future, use the arrow beside the Mapping Name to drop
down the saved names, and click QJRL – the saved mapping will be
opened ready for use.
Click OK. A dialog box appears – ‘The database file has no index for
searching. Do you want to create one?’ Click Yes. The Import Player
screen appears, with all players on the masterfile listed in the
left window (the file is actually broken up into chunks – the first
includes surnames Abbott - Bambrick, the next Bancroft -
Bradley-Woods, and so on, depending on when the QJRL.trn was
Click the Find button. The Find Player screen appears. In the Search
by segment make sure Surname is enabled, then in Search for type
your first player’s surname (upper or lower case makes no
difference) e.g roberts. Click OK. The first Roberts in the file is
found (Roberts, Hugh B). Scroll down to find the player you want –
Roberts, Billy GC. A quick check of the Selected Player details in
the right segment will confirm you have the right player.
Click the Import button. A new box tells you ‘Roberts successfully
imported’ Click OK – Billy Roberts has now been added, with his file
details, to your List of Players.
Click Find again and search for the next player, then import. If a
player is not found on the QJRL.trn, register him manually from the
SP menu Player -> Add new. Make sure the Birth Date, Club and Gender
fields are filled in.