User Tools

Site Tools


bboextractor

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
bboextractor [2020/06/02 17:11]
jonathan
bboextractor [2020/10/22 10:38] (current)
jonathan
Line 1: Line 1:
-**BBO Extractor** is a free utility for creating the XML files required to upload BBO results to Bridgewebs ​and to the EBU.+**BBO Extractor** is a free utility for creating the XML files required to upload BBO results to BridgewebsEBU, ECats and others.
  
 The BBO Extractor website can be found [[https://​mirgo2.co.uk/​bboextractor/​|here]]. The BBO Extractor website can be found [[https://​mirgo2.co.uk/​bboextractor/​|here]].
Line 9: Line 9:
 To create the names file download the names spreadsheet [[https://​www.ebu.co.uk/​documents/​ebuscore/​ExampleNames.xlsx|here]]. Add in the information for the players from your club in columns A-D. Column F will then provide the names in the format needed for the names file. You then just need to copy column F and save it in a new Notepad document. To create the names file download the names spreadsheet [[https://​www.ebu.co.uk/​documents/​ebuscore/​ExampleNames.xlsx|here]]. Add in the information for the players from your club in columns A-D. Column F will then provide the names in the format needed for the names file. You then just need to copy column F and save it in a new Notepad document.
  
-To install BBO Extractor use Chrome ​Web Browser ​to go to the [[https://​chrome.google.com/​webstore/​category/​extensions?​hl=en-US|Chrome Store]]. +To install BBO Extractor use Chrome ​web browser ​to go to the [[https://​chrome.google.com/​webstore/​category/​extensions?​hl=en-US|Chrome Store]]. Search for BBO Extractor and click Add to Chrome.
- +
-Search for BBO Extractor and click Add to Chrome.+
  
 You are now ready to use BBO Extractor. You are now ready to use BBO Extractor.
  
 **Producing Results** **Producing Results**
 +
 +You need to use Chrome web browser for producing the results.
  
 Provided the event you are producing results for was in the last few days then you will find the event in the list [[http://​webutil.bridgebase.com/​v2/​tarchive.php?​m=pairs&​f=p&​d=Pairs|here]]. Provided the event you are producing results for was in the last few days then you will find the event in the list [[http://​webutil.bridgebase.com/​v2/​tarchive.php?​m=pairs&​f=p&​d=Pairs|here]].
Line 21: Line 21:
 You can use Ctrl + f to search in the list, once you find the event right click and open the results in a new tab. You can use Ctrl + f to search in the list, once you find the event right click and open the results in a new tab.
  
-Then click the BBX button in your browser:+Then click the BBX button in your browser ​(on the right, highlighted in yellow below):
  
 {{ :​extractor01.png?​nolink&​600 |}} {{ :​extractor01.png?​nolink&​600 |}}
  
-BBO Extractor will now open each scorecard ​in turn and download the information,​ you will see tabs open and closing. Do not disturb it during this period, it will tell you once it is done. At this point it will download a CSV file. It will then calculate the makeable contracts and download a PBN file.+BBO Extractor will now open each traveller ​in turn and download the information,​ you will see tabs opening ​and closing. It will take about 2 minutes. Do not disturb it during this period, it will tell you once it is done. At this point it will download a CSV file. It will then calculate the makeable contracts and download a PBN file.
  
-Next go [[https://​dds.bridgewebs.com/​bbotoxml/​bbotoxml.htm?​p=1|here]]. Enter the name of the club and the club's EBU number. For UMS charge rate enter one of the following numbers:+Next go to the BBO to XML Web App which is found [[https://​dds.bridgewebs.com/​bbotoxml/​bbotoxml.htm?​p=1|here]]. Enter the name of the club and the club's EBU number. For UMS charge rate enter one of the following numbers:
  
   * 10 - Normal session with Master Points and NGS   * 10 - Normal session with Master Points and NGS
Line 33: Line 33:
   * 12 - Session with Master Points but no NGS   * 12 - Session with Master Points but no NGS
  
-If using code 11 then enter 0 in each of the Master Points boxes, otherwise leave those boxes blank.+If using code 11 then change MP Scale from Club to manual, otherwise leave it at Club and Master Point awards will be populated automatically. 
 + 
 +Click Load Names, it will prompt for the names text file you created earlier.
  
-Click Load Names, it will prompt for the text file you created ​earlier.+Still using the BBO to XML Web App click the Create XML file button. This will prompt for the CSV file that BBO Extractor downloaded in the previous step, the CSV file will be in your Downloads folder. The newly created ​XML file will also be saved to your Downloads folder.
  
-Then click each of the Create XML buttons in turnEach one will prompt ​for the CSV file that BBO Extractor downloaded ​in the previous step, the CSV file will be in your Downloads folder. The XML files will also be saved to your Downloads folder.+You now need to login to [[https://​www.ebu.co.uk/​members/​v2/​|My EBU]] as the club (or as a scorer ​for the club) and submit the XML file in the normal way (as documented [[https://​www.ebu.co.uk/​member-wiki/​myebu:​file-submission|here]]). Then go to your Bridgewebs site and click Administration in the left hand menu and then Results Administration under that. The XML file should ​be uploaded as a results file and the PBN file as a deal file.
  
-You will now have 2 XML files, one with UMS in the name and one without. The one with UMS in the name is for EBU. You now need to login to My EBU as the club (or as a scorer for the club) and submit this file in the normal way (as documented [[https://​www.ebu.co.uk/​member-wiki/​myebu:​file-submission|here]]). The other XML file (without UMS) is for BridgewebsGo to your Bridgewebs site and click Administration in the left hand menu and then Results Administration under that. The XML file should be uploaded as a results ​file and the PBN file as a deal file.+If any score corrections are required these can be done using the '​Review / Edit CSV' button top left on the BBO to XML Web App pageThis saves importing ​the results ​in to EBUScore to make score corrections which was previously required.
  
-If you have any issues ​with any of this please ​contact [[jonathan@ebu.co.uk|Jonathan Lillycrop]],​ Club Liaison Officer.+English Bridge Union members who experience ​any issues ​can contact [[jonathan@ebu.co.uk|Jonathan Lillycrop]], ​EBU Club Liaison Officer. For other assistance please contact [[bboextractor@bridgepal.co.uk|Mirna and John Goacher]].
bboextractor.1591117866.txt.gz · Last modified: 2020/06/02 17:11 by jonathan