Bridgemate and EBU Score
We use the above set up and for one player when we put the EBU number in the bridgemate their name does not appear on the bridgemate but it does in EBU Score at the end, it’s only this one player. Can anyone advise how to solve please.
Comments
Hi David
I am not sure but I think it depends on how EBUScore and Bridgemate Control Software (BCS) link to the "BMPlayerDB.mdb" file. I assume the person who does not get named on the Bridgemates is fairly new to the club. I suspect that BCS is looking at a different file. Go to BCS <> Tools <> Options and then look in the "File Locations" Tab and note where the "BMPlayerDB.mdb" file is pointed. Now open EBUScore go into the last event click on "Bridgemate Scoring" and then click on the "Admin" tab and see if "BMPlayerDB.mdb" is in the same location (it is under "National Database Look Up File". I would suggest changing the location in BCS to the same as EBUScore. To do that go back to the "File Locations" tab in BCS and under "BMPlayerDB.mdb database file" click on the the button to the left of "Other Folder" and then click on "Select Folder". Remember that you will only be able to go to "folder" level not file level. So if EBUScore points to C:\EBUScore\BMPlayerDB.mdb then you need only select C:\EBUScore in the dialog box.
Hope this helps. Sorry if this is incorrect
Have a look in your Bridgemate settings in EBU Score and see what the Name Source is set to.
Bridgemates always seem to get confused by a single player using their EBU number.
I go to Bridgemate Scoring and use Write Names. Sometimes I have to do it several times
Alan
Thanks for Feedback, I’ll try again tonight and see if the suggestion help.
Hi David, Gordon and Jonathan
If the file is the same on EBUScore and BCS then I think it has something to do with the EBU database. We have one member that also does not appear on the Bridgemates like your player. They have played 4 times at our club over the last 3 months, today was the latest that they came. We originally set up an EBU number and had no problems in submitting the results to the EBU with the correct name and EBU number showing on the submitted list of players. I have been into the EBUScore Player database and downloaded the National Player list. However, when I click on their name and then click on "Set EBU details" I am told that "the surname XXXXX cannot be found on the EBU database". I know the surname spelling is correct and that the surname used does not throw up a problem when we upload the results to the EBU. I can even click on their name and get all the same details (name and EBU number) just incase we need to change it. So it makes me think that there might be a problem in downloading the National Database to EBUScore to be stored in "BMPlayerDB.mdb" file.
Hi David,
If it is just one player I would suspect that either the player is not currently an EBU member or has chosen to be anonymous. If you can email me (ebuscore@ebu.co.uk) with the details of the player then I will check.
When you click “Download EBU Database” in EBUScore this only downloads information about current members.
Jonathan
Is it possible please to be guided as to how frequently we should download the EBU Database?(BMPlayer.mdb) We're a club where most players are both members of the EBU (and our club) and have been playing many years. Just occasionally we'll get someone new to the game, so I thought for us once a month might be sensible. We play twice a week, so every session would seem overkill.
Most grateful for guidance/advice! 👍
I agree that once a month would seem fine. Jonathan
When you click on Player Database in EBU Score there is a message telling you if you don't have the latest EBU Membership Database.
We are using Bridgemates, BridgeWebs and EBUScore. BCS is set to use the Player & EBU Names Table. Is this BMPlayerDB.mdb from EBUScore? When I export a copy of the EBUScore Player Database to CSV file PlayerDB is it from BMPlayerDB.mdb? When running Download EBU Database does it update BMPlayerDB.mdb? I have recently run Set EBU Details which has thrown out a load of error messages 'not in downloaded EBU Database'. As I haven't run Download EBU database this year that explains the error message? Does this mean that EBUScore has a separate lookup table which is out of sync with the master EBU database?
A very useful question which doubtless will be clarified, I will certainly watch this thread with interest. 👀
The 'Player' Names is from the Player Database selected in EBUScore - the database it calls 'Player Database'
The 'EBU' Names is from the downloaded EBU database of (some) EBU Members, the file that EBUScore will prompt you to download the program thinks the database is out of date.
With the option to use 'Player and EBU Names Table', BCS creates a lookup based on the PIDs and the EBU numbers in the Player Database and the EBU numbers in the EBU database.
We are using Bridgemates, BridgeWebs and EBUScore. BCS is set to use the Player & EBU Names Table. Is this BMPlayerDB.mdb from EBUScore?
-->As described by Robin above. BMPlayerDB.mdb is the downloaded EBU database.
When I export a copy of the EBUScore Player Database to CSV file PlayerDB is it from BMPlayerDB.mdb?
-->No. Its from the program Player Names Table.
When running Download EBU Database does it update BMPlayerDB.mdb?
-->Yes
I have recently run Set EBU Details which has thrown out a load of error messages 'not in downloaded EBU Database'. As I haven't run Download EBU database this year that explains the error message? Does this mean that EBUScore has a separate lookup table which is out of sync with the master EBU database?
-->The error refers to the latest one that was downloaded and means the EBUNo didnt exist in that file.
Jeffery /Robin, thanks for your input.
To summarise there are two databases -
Playerdb - Local Player Names Table
BMPlayerDB - Downloaded EBU database
These are merged to create a lookup table used by BCS, containing name, PID and EBU number.
They are not merged. In the Name Source you instruct BCS to check either the PlayerDB or the BMPlayerDB or the PlayerDB first, BMPlayerDB second. This allows clubs to use their own Player ID number, or the EBU number, or both.
The PlayerDB is put in a loaded by EBUScore into a table in the shared EBUScore/BCS Database.
The BMPlayerDB is in a file with its location pointed at by the 'Set Lookup File location' button.