How to organize data for more than one partner

 

How to organize data for more than one partner


In any case it is necessary to subdivide the data in separate options. Each option should contain the data that in some way belongs together (e.g. separate options for each convention).


We will use a simple example assuming that you play Precision with partner1 and SAYC with partner2.

Method 1 : all data in one single local file


The data may look like this


BBOalert,Precision&SAYC

Option,common

Shortcut,HH,Hallo

Option,System Precision,myID+partner1ID

,1C,16+HCP any shape

Option,System SAYC,myID+partner2ID

,1C,13-22HCP 3+!C

Option


Then when you play with partner1, BBOalert will automatically enable two options : “common” and “Precision”. If you play with partner2 “common” and “SAYC” will be enabled


You can keep the file locally on your PC and distribute copies by mail to both partners. Each of you should open the file with the Notepad, select and copy all data into the clipboard and paste it into BBOalert. This method is not practical. Therefore :

Method 2 : all data in one single GoogleDocs file


The same data can be kept in a GoogleDocs file: 


https://docs.google.com/document/d/1xES0gezCEuXubLxPhjK1vJeCvw7f_jPJS3Wjdwh6G3M/edit?usp=sharing


This has several advantages :


  • There is only one source of information

  • Concurrent editing by all partners (e.g. to add own recorded alerts to the file)

  • Trusted data storage

  • Version control


BBOalert can’t access GoogleDocs files directly because of Google's security policy. However the

document can be published as a HTML page.


To obtain the URL link to that page :


  • “File” menu

  • “Publish to the web” command

  • Press “Publish” button

  • The URL link will be displayed in the dialog box as below




Copy this URL link into clipboard and paste it directly into BBOalert - “Data”/Paste (New)”



The URL link will be recorded and can be accessed at the bottom of the “Data” menu in BBOalert.



Then you will be able to select manually between Precision and SAYC system



Or it will be selected automatically if user ID’s of both players match.

In our example the file contains only a few records but in reality the file size can grow quickly to thousands. Managing huge files is not practical. Therefore :

Method 3 : data split in several GoogleDocs files


We can store each option in a separate GoogleDoc file :


https://docs.google.com/document/d/1zkfmhzsouN9pDnR8g2ZIThidUs9rpKmgzYqpB7AT31A/edit?usp=sharing

https://docs.google.com/document/d/1ifKkZmW_64jZx0a4-BhkTdonowxHXWfxJHDVfTCt4lo/edit?usp=sharing

https://docs.google.com/document/d/1BKNQeJ1LXkBx_AjKpnFBUw4MZCuCBQdPpjeIxSINM7E/edit?usp=sharing


To get all pieces of data back together in one stream we will create a loader file containing the list of

published URLs (each file should be published to the web, also the loader file)


The loader file :


https://docs.google.com/document/d/11ss8xQor5k1uNwyI411xu9AM6dv33uXaM8AfDiVy6AE/edit?usp=sharing


And its published URL :


https://docs.google.com/document/d/e/2PACX-1vQL5qWlUQKrzW1-qcwUdRCGBnRhPxX9AgEd2cMet7fOq_XsetyefBduNBzrO0O0IS1QW-I8XXrUHbQh/pub


Copy this link to the clipboard and paste it into BBOalert :



Note : The record count is not the same as before because extra blank lines are added.


And to be complete, one potential problem can be mentioned : if you play with one partner you could

wish not to load the data of the other partner. Therefore :




Method 4 : separate loader files for each partner


You can make two separate loader files containing only the necessary links. It is like assembling a car

with only the options ordered by a customer.


Loader files :


https://docs.google.com/document/d/13QVyvt_rgodoZHRD_9ZR2g8mBUSPTojkhtj-bnDP_Z8/edit?usp=sharing

https://docs.google.com/document/d/1sIwT7vFV3t6d-2874OqoI820APxc_LiDbxyJEl3Lm5s/edit?usp=sharing


With respective HTML web URL links


https://docs.google.com/document/d/e/2PACX-1vTXnZs4ipaYrjQxqTiopHqARZw_1QQS5nQl8KNZn9Hv8rVe2wxLe96hvz5uDU5IsrSwKFzCnQgJNduz/pub

https://docs.google.com/document/d/e/2PACX-1vRhOAYquw6oyrqtulSH4FhBzKsuv2kiEmKw3tos-oidLwzTJbqJmyjKxopu2vf3jaXWnhoGeFalKh39/pub


Each of these links can be used to load data restricted to one or the other partner (system). Both links will be recorded in the “Data” menu for quick access :


 



 

Comments