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
Last revision Both sides next revision
switchingfromsb [2015/09/30 17:04]
ian created
switchingfromsb [2015/09/30 17:40]
ian [Switching from ScoreBridge]
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 ==== 
 +Firstly, you need to export your old player database from ScoreBridge:​\\ 
 +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