Magic Contest: Documents
File specifications: Microsoft Access
Tel: +46 171 47 50 37
Mobile: +46 70 742 77 42
Alternate e-mail address:
As described in File specifications you can create a text file that Magic Contest can import into the internal member list. That is the official way to do it, and when doing it that way everything will work correctly in case the text file follows the specifications.
There is also another way to do it if you are a little bit handy using Microsoft Access. Remember that this opens up new exiting ways to mess up Magic Contest and the member list in case you make a mistake. It is however not that difficult if you know your way around Microsoft Access, so please give it a try.
First you must make sure that you have created a database through Magic Contest:
The database is typically saved in the following folder:
C:\Program Files\Magic Contest\Magic Contest Documents
using the following name:
Connect to database
Then you need to set up a connection to the Magic database:
The reason for this is that Magic Contest saves the member file in Microsoft Access 97 format, so if you open that right away with a later version unwanted things may take place later.
Use member numbers
The next step is to tell Magic to understand your member numbers:
This quick reference assumes that you have official member numbers that you want to use in Magic. If not, you can ignore the UseMemberID step and leave that field blank. Then the data in the PlayerID field will work as member numbers (read more about this below).
Add players to the Player table
Next step is to add players to the Player table. This can be done in several ways, one being to import data from a text file, another to enter data manually, a third to run a query and that way transfer data from an existing database. This I leave entirely to you to figure out, but while inserting data you must consider the following:
Use the Sort1 and Sort2 fields correctly
Under normal circumstances Sort1 = LastName and Sort2 = FirstName. However, some special names, typically last names starting with "van", "van der", "de", "d'", and so on, are sorted according to the main part of the name. If so you need to set Sort1 accordingly:
There is also a special case in Iceland where the phone book is sorted according to the first name and where the second name is not a family name but your father's or mother's first name + "son" or "daughter" in Icelandic. Here Sort1 = FirstName and Sort2 = LastName.
Use the PlayerID field
This is a counter that gives the internal PlayerID used in all other Magic Contest database tables. In case you really want to play around with all Magic Contest database tables, this field is the internal player identifier.
If you do not have national member numbers you can use the PlayerID field instead. Leave MemberID blank and make sure not to enter -1 in UseMemberID as described above.