darts for windows toplogo
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
nopic

nopic

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.

nopic

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 \database), click on the file and then on the "Open" button in the dialog box (see picture below).

nopic

Matches from the matchlog in the source database nopic

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).

nopic

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).

nopic

Click the "Save" button to start the import

nopic

Import in progress....

nopic

Import done !

nopic

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.

nopic

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).

nopic

Open the matclog by pressing the keyboard shortcut CTRL-M or open the matchlog from the menu "View ->Matchlog"
All the matches who is assigned to a match in the matchlog has a different background colour, so we only have to concentrate on those with whit background colour. We have none of the second round matches assigned so we scroll to the match "R2 - Colin Lloyd vs. Raymond van Barneveld". Make sure the matchlog screen is in the foreground of the tournament screen. (as show in the picture below)

nopic

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)

nopic

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.

nopic

Continue to drag and drop all the second round matches until the draw is updated.


  ©2006-2007 Roger Boyesen