how to import matches from a Darts for Windows 2008 database
Starting from version 2.2.0.23, Darts for Windows 2008 now supports import of matches from other Darts for Windows 2008 databases.
The import function also imports players and team names if they not exist in the target database. If the match(es) you are importing
also exists in an existing tournament in the target database and the match from the drawsheet in that tournament has no match from the matchlog assigned to it,
then the import funtion will update the draw with the result and match id from that match.
In our sample I'm going to import 39 matches from Ladbrokes.com 2007 into my database. The target database will
contain all the players from the tournament and also the draw, but no data from the matches.
If you don't know how to create a tournament (the tournament is not needed to get the import function to work), have a look at this article.
the draw and the matchlog screens before the import
As you can see, the matchlog is empty and the draw contain (only some of the matches are visible in this sample) only the names of all the players in the first round. There are no results either in the draw.
the import screen
We are now ready to start the import. The import option is located in the menu Tools -> Import as shown in the picture below.
Click on the Import match to open the "Open database to import from" dialog box.
Browse to the file you are going to import from (default directory is
Matches from the matchlog in the source database
The import screen has now been filled with all the matches from the source database. In this sample we are going to import
all the matches, but as you can see, the second column on the left has a check box in each row where you can click
on the match(es) you wish to import. To check all the matches, click on the "Check/uncheck all" check box in the toolbar (see picture below).
Ok, now we have marked all the matches we are going to import. To start the import process, simply click on the
button in the toolbar marked with a diskette icon (see picture below).
Click the "Save" button to start the import
Import in progress....
Import done !
the matchlog after the import
As you can see, the matchlog in the destination database (the one we use) has now been filled with all
the matches from the source database. We have now access to all the scoresheets and stats from these matches.
To view the scoresheets from a match, simply doubleclick on the row containing the match you wish to see.
the drawsheet after the import
When we started the import we did not have any of the results from the first round matches in the drawsheet.
When we imported the matches, all the first round matches were assigned a match from the matchlog, but wait... the matchlog also
contained some of the second round matches. Why aren't those matches assigned to a match in the matchlog ?
The answer is rather simple: As long as the match is not in the draw, the matches from the matchlog will not be assigned to the drawsheet. If we had updated the drawsheet before the import we would have all the matches in the draw assigned to a match in the matchlog, but wait...there is a cure for this one too (from version 2.2.0.24 and above).
Open the matclog by pressing the keyboard shortcut CTRL-M or open the matchlog from the menu "View ->Matchlog"
To assign the match from the matchlog, we simply drag and drop the "Loyd-Barneveld" into the correct position in the drawsheet. You will be asked to confirm the assigning by a dialog box (see picture below)
We click "Save" and then you will se that the background colour will change from white to a darker colour. This indicates that the operation was successful and the macth has been assigned to the drawsheet.
Continue to drag and drop all the second round matches until the draw is updated. |
||
©2006-2007 Roger Boyesen |