Add MPs, IMPs, DD, tourney, date/time to LIN files

[0 carbon]

When we download LIN files for analysis and store them, we get the hands, but little else. Could some basic info be added as notes?, eg:

• date/time
  
• MPs or IMPs or points
  
• DD - double dummy maxes for each suit/nt
  
• tourney name if any
  

Then when we revisit them later we have more context.

 

It would also be nice if some of this were in the filename too, eg,

2009-07-31-2359.92~4Hxx6~99.57%.lin

2009-12-31-2359.92~3NT-1~3.57IMPs.lin

for archiving/viewing instead of

8888888.lin

 

I would put the score (IMPs or MPs) as scored by the declarer.

 

tOM

[inquiry]

You don't have to wait for someone to help you in this way. I suggest you consider the following.

 

Call up all the hands you are interested.

 

Copy and paste into Excel

 

You will have to figure out a cool way to deal with the fact that Movie and Lin hyperlinks are in the same cell. I had it working once, so it can be done. Delete the link to lin, keep the movie link.

 

Use GetURL command to extract the http://bridgebase.com/myhands.... php...=lin pn| etc filne stuff

 

From the http:// to the equal sign is the same length, extract using Right and or left command just the lin file info for each hand into a new column.

 

Copy the entire column, paste into notepad. Replace each |pc with |pg||pc, and replace all qx| with pc|qx (except the first qx). Save file as a whatever dot lin. (if you don't do this last find and replace, you will never see the last card played or any passed hands, as they are skipped when you review the files.

 

You will ahve all the hands in a lin file and the corresponding excel file has all the other info you wanted about each hand.

 

Better yet, if you are clever at programming or if someone around here is, you can pull it directly from the html you get when you search myhands... the key stuff is this...

 

<tr class="tourneyOdd">
 <td class="handnum">1</td>
 <td>14:06</td>

 <td class="north">miamiwiz</td>
 <td class="south">JEC</td>
 <td class="east">mlodybog</td>
 <td class="west">megi1</td>
 <td class="result">4<span style="color:red">♥</span>N-1</td>
 <td class="negscore">-50</td>

 <td class="negscore">-10.00</td>
 <td class="movie"><A href="http://www.bridgebase.com/tools/handviewer.html?myhand=M-65064906-1247162476" onclick="javascript:hv_popuplin('pn|JEC,megi1,miamiwiz,mlodybog|st%7C%7Cmd%7C3S6QAH6KDTKAC24578%2CS39JKH57D3479JC36%2CS245H389TJAD2QCTK%2C%7Crh%7C%7Cah%7CBoard%201%7Csv%7Co%7Cmb%7C2H%7Cmb%7Cp%7Cmb%7C2N%7Cmb%7Cp%7Cmb%7C3C%7Can%7Cc%20or%20sp%20feature%7Cmb%7Cp%7Cmb%7C4H%7Cmb%7Cp%7Cmb%7Cp%7Cmb%7Cp%7Cpc%7CD6%7Cpc%7CDT%7Cpc%7CDJ%7Cpc%7CDQ%7Cpc%7CD2%7Cpc%7CD5%7Cpc%7CDK%7Cpc%7CD9%7Cpc%7CC2%7Cpc%7CC3%7Cpc%7CCK%7Cpc%7CCA%7Cpc%7CS8%7Cpc%7CSQ%7Cpc%7CSK%7Cpc%7CS4%7Cpc%7CS3%7Cpc%7CS5%7Cpc%7CS7%7Cpc%7CSA%7Cpc%7CDA%7Cpc%7CD7%7Cpc%7CS2%7Cpc%7CD8%7Cpc%7CS6%7Cpc%7CSJ%7Cpc%7CH3%7Cpc%7CST%7Cpc%7CCT%7Cpc%7CCJ%7Cpc%7CC4%7Cpc%7CC6%7Cpc%7CCQ%7Cpc%7CC5%7Cpc%7CD4%7Cpc%7CH8%7Cpc%7CHJ%7Cpc%7CH2%7Cpc%7CHK%7Cpc%7CH5%7Cpc%7CH6%7Cpc%7CH7%7Cpc%7CHT%7Cpc%7CHQ%7Cpc%7CC9%7Cmc%7C9%7C');this.style.color='red';return false;">Movie</A> or <A HREF="fetchlin.php?id=65064906&when_played=1247162476">Lin</A></td>
 <td class="traveller"><A HREF="hands.php?traveller=1167-1247162476-857260&username=jec">Traveller</A></td>
</tr>

 

As you can see, the two key info you want is called td class=movie above, so a short program could extract the necessary information without going through excel, I just like having it all neat in columns. You can also find all doubled contracts, all slams, all hands you decleared, all hands you defended, etc, by using excel to extract info from the contract field into new columns. I have used this to find all opening bids by my side, all slams, all doubled contracts, etc.

 

When I get home, I will try to remember to post a file showing how this looks in Excel, along with an example Lin file.

[0 carbon]

Thanks, I may try that, create a SED script or something.

 

But simpler if each LIN file were already named something like:

2009-07-31-2359.92~4Hxx6~99.57%.lin

 

Then you can view/choose the LIN files in Program Explorer right after a download, not after a bunch of tedious manipulations.