User Tools

Site Tools


switchingfromsb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
switchingfromsb [2015/09/30 17:04]
ian created
switchingfromsb [2017/05/03 14:45]
ian
Line 4: Line 4:
 I hope that the help files will be of some use in trying out EBUScore. I hope that the help files will be of some use in trying out EBUScore.
  
-The two programs are not compatible. ​ When you switch, you will not be able to use EBUScore to access your old sessions that you scored using ScoreBridge,​ nor use your existing Player Database.\\+The two programs are not compatible. ​ When you switch, you will not be able to use EBUScore to access your old sessions that you scored using ScoreBridge,​ nor use your existing Player Database, or custom movements.\\
 It is possible to convert your player database, but it's not an easy process: It is possible to convert your player database, but it's not an easy process:
  
-==== transferring ​your player database ====+==== Transferring ​your player database ====
  
 +If you are a BridgeWebs user, it may be possible to transfer your player database via BridgeWebs:​\\
 +  * Use ScoreBridge to upload your player database to BridgeWebs.
 +  * Launch EBUScore and click on '​Player Database'​.
 +  * Click on the '​Player Management'​ tab (top middle), and then on the '​Import PD from BridgeWebs'​ (bottom left).
 +  * You will need to have ensured that your Bridgewebs name and password are recorded in the boxes just above.
 +Because the formats of the respective databases are not identical, you might lose some vital information (such as "Club Player IDs").
 +
 +
 +**If you do not have BridgeWebs**,​ or if you want more control over which information gets transferred,​ you can transfer directly via a csv file:
 +
 +Launch ScoreBridge,​ click on '​PlayerDB'​ to get to your Player Database screen.\\
 +One of the new menu items at the top is 'Make Spreadsheet'​. ​ Click on this.\\
 +Make a note of the filename and where the file is saved.\\
 +
 +The file will also be opened, hopefully in Excel or a similar spreadsheet application.\\
 +In order for EBUScore to be able to read this file, you need to change the '​headers'​ on the top row as follows:\\
 +  * Change 'First Name' to '​Firstname'​ (i.e. remove the space).
 +  * Change 'Last Name' to '​Surname'​.
 +  * Change 'EBU Number'​ to '​NBONo'​.
 +  * Change 'Phone Number'​ to '​TelH'​.
 +  * Change 'Email Address'​ to '​email'​.
 +  * Change 'Post Code' to '​Postcode'​.
 +  * Change 'Club Member No' to '​PID'​ - if you do this, though, you need to make sure that **every** player on the list has a player ID
 +All but the '​Firstname'​ and '​Surname'​ are non-essential,​ But EBU Numbers will be very useful, and if players use 'Club Numbers'​ on bridgemates,​ for example, it would be helpful to transfer these across. ​ Otherwise, any columns not listed above can easily be ignored.\\
 +
 +Save the file with these changes, and then close down the file and ScoreBridge.
 +
 +Launch EBUScore and click on '​Player Database'​.
 +
 +{{:​screenshot_pd_import.png?​400|}}
 +
 +Click on the '​Player Management'​ tab (top middle), and then on the '​Import PD from csv' button at the bottom (circled above).
 +
 +Firstly you will be asked whether or not you wish to delete your existing database. ​ If you wish to retain Club '​player IDs' from your old database, then you will need to say '​Yes',​ even if there is nothing to delete!\\
 +If you do choose '​Yes',​ the '​deleted'​ database will be saved as a backup, and you see a prompt confirming this.  If you choose '​No',​ you will get a different prompt "PIDs in the imported file will be ignored"​. ​ Either way, just click '​OK'​.\\
 +
 +Next you will need to navigate to find the '​csv'​ file that you have just saved - you did make a note, didn't you!\\
 +Select the file SBNameData.csv and click on '​Open'​.
switchingfromsb.txt ยท Last modified: 2017/05/03 14:45 by ian