Each IBEScore GAME CODE account comes with player database space on a web server, which stores the names of players who have taken part in your games. When a game is finalised, the database adds any new players and updates their most recent finalised game.
The database can be edited from a browser, to update and record players’ ID numbers and contact details including their current bridge online usernames.
Players’ id numbers can be club numbers, national federation numbers, or anything that your bridge club uses to identify players. Each player can have more than one id number, eg a club number, an BBO username and a national organisation number.
Player IDs are an important component of IBEScore’s database. They serve two functions:
- Shortcut to name entry: typing an ID can identify a player at the beginning of the game and is an alternative to locating or typing a name
- Masterpoints: National ID numbers are included in the files which IBEScore uploads to national federation masterpoint aggregating servers.
Editing the database
The player database is not enclosed in the App, so it can only be edited at www.brianbridge.net/ibescore.
Log in at www.brianbridge.net/ibescore. Click on the “Game” tab followed by the “Player database” button. You will now be shown the player database and you can make edits.
You must click the “Save” button after you have edited the database. If you leave the website without clicking “Save”, new edits will be lost.
You can:
- Add a player: Type the new player’s name into the box next to “Find”, then click “+ Add player”. You cannot add a player with the same name as an existing player.
- Remove a player: In the database, find the player’s row, and click on the “x” button at the far right end of the row.
- Change a player’s IDs, name, E-mail or phone number: In the player’s row, click in the box that you want to change and type in the new text.
The format for a player’s national federation number is EBU:00324235
The format for a player’s club number is club:35
The format for the ID field of a player with multiple ids is EBU:00324235,ACBL:52345,club:35
Do not use any punctuation other than commas (to separate ids) and colons (to separate the id type from the code). For a club number, use the word club exactly and in lower case.
To find a entry in the database by name, type a forename or surname, or part thereof, in the box next to “Find”, then click “Find” to show the first match. Click “Find” again to show the second match, and so forth.
Remember to click “Save” frequently.
Bulk lookup of national numbers
IBEScore allows you to look up national numbers in England in your database at once. We are working to extend this range to other national federations.
To fill in your players’ numbers in bulk, take the following action on the website database screen:
- Click on “Advanced” (below the database table)
- In the popup window, click on the select box and choose “Fill in ID numbers”
- Make sure “EBU numbers” is selected
- Click “Execute”. This may take up to 10 minutes.
For help in this area please do contact us at ibescore@gmail.com
Importing and exporting the database
IBEScore allows you to import and export your account database, either with IBEScore’s own csv format or directly to some Bridge result hosting sites eg Bridgewebs. This is done using the “Advanced” button (below the database table).
When you click on “Advanced” a popup will appear, from which you will be able to select “Update from BridgeWebs”, “Update to BridgeWebs”, “Export to disk”, “Import from disk”, or “Fill in ID numbers” (discussed above).
Update from Bridgewebs / update to Bridgewebs: This will attempt to retrieve or put any new entries from or to Bridgewebs respectively. Fill in the form with your BridgeWebs account and password respectively, click “Execute” and wait for up to 10 minutes.
Export to disk: This will allow you to create a file on your computer with the current contents of your IBEScore database. You can use this file to populate the database of another IBEScore account, or as a backup file.
Import from disk: Select a file on your computer from which to overwrite the current contents of your IBEScore database. This can be useful if populating a blank database, or restoring a database which has taken a turn in the wrong direction. Be warned that this action is irreversible, and you may wish to Export a backup first.