There is a facility to upload any results using formatted text files. This page describes the format required
You can have a look at a couple of examples. The required file should be a csv. If you cannot download the csv file, try the txt file.
The format is flexible and best reviewed by looking at the examples. Each line of the file can consists of options (preceded by #) or data. The options themselves are followed by actual values. The options are not case-sensitive so upper or lower or any combination will do.
The field separator is determined from the first line and can be a semicolon, tab or comma as necessary to suit the software used to create the file.
N.B. A tab is best as this suits the csv format better for use in Spreadsheets, the examples are shown with a ";" purely to show where they go.
- Version - version number to allow the bridgewebs software to detect any changes
- Comment - all comment lines are ignored
- Aggregate - 1, Any value indicates aggregate
- Boards - no of boards
- Butler - 1, Any value indicates butler
- Crossimp - 1, Any value indicates cross imps
- Capmax - 0 (25), A value for capping IMPs in Team Matrix Totals
- Capmin - 0 (25), A value for capping IMPs in Team Matrix Totals
- Date - shows at the top of the competition page, format DD/MM/YYYY
- Director - director name, if available
- Individual - 1, Any value indicates an Individual
- Matches - nn, Indicates number of matches scored
- Scorer - scorer name, if available
- Source - program name/release of source software
- Description - shows on Ranking page
- StratEBU - no of levels of EBU Stratification e.g. 2,3,4 (assuming 1 is not valid)
- Swiss - 1, Any value indicates Swiss Event or one of the next 2
- Swisspairs - 1, Any value indicates Swiss Pairs
- Swissteams - 1, Any value indicates Swiss Teams
- Teams - 1, Any value indicates teams
- Teamseight - 1, Any value indicates teams of eight and implies teams
- Title - title to add to calendar
- Winners - No of winners = 1 or 2
- Scores - followed by column fields and subsequently the results for North South, repeat for East West or twice more for Individual (§1)
- Position - Position
- Pair - Pair No
- Name1 - First Player
- Name2 - Second Player
- Name3 - Third Player (Teams Only)
- Name4 - Fourth Player (Teams Only)
- Name5 - Fifth Player (Teams Only)
- Name6 - Sixth Player (Teams Only)
- Name7 - Seventh Player (Teams Only)
- Name8 - Eighth Player (Teams Only)
- Team - Team Number
- Teamname - Name of Team
- Score - Score (usually percentage)
- Tops - Tops
- Factor - Factor instead of Tops
- Factored - Factored Score
- Unfactored - Unfactored Score
- Percent - % result
- Played - Boards played
- Adjust - adjustments
- Mpts - Master Points
- Green - Green Points
- Sslams - Number of Small Slams
- Gslams - Number of Grand Slams
- Green - Green Points
- Cat - Category
- Strat - EBU Stratification Level e.g. A B C D
- Mptsa - Stratification level A MPTS.
- Mptsb - Stratification level B MPTS.
- Mptsc - Stratification level C MPTS.
- Mptsd - Stratification level D MPTS.
- Boards - Assumes a number of columns corresponding to the Boards option given above
- Matches - Assumes a number of columns corresponding to the Matches option given above
- Wins - Wins/draws expressed as e.g 2.5 etc.
- Travellers - followed by column fields and subsequently the boards (§1)
- NS - NS Pair No
- EW - EW Pair No
- N - N Player No (if Individual)
- E - E Player No (if Individual)
- S - S Player No (if Individual)
- W - W Player No (if Individual)
- Score - Score shown as + and - or:
- NSScore - NS Score
- EWScore - EW Score
- Pts - Scored points shown as + and - or:
- NSpts - NS points
- EWpts - EW points
- Bid - Contract Bid
- Made - Total Tricks made
- By - Bid by
- Lead - Lead
- Boardformat - extra options for #Board line (§2)
- Board - Board No
- Session - Session No
- Datum - Butler Datum
- Board - followed by board no and rounds for the actual board on following line until next Board option.
(§1) For Scores and Travellers, the columns can follow the option on the line or to make it easier on the next line so that the columns below line up with the title, see the examples
(§2) The #Board format is assumed to be #board followed by a board number, you can also supply a session number and the butler datum, in which case supply a #Boardformat line before the first #Board.
This Bridgewebs Import format is mainly used to upload prepared results. However, it can also be used to upload "Duplicate" results with "Travellers" prepared on a spreadsheet and calculate a simple "Duplicate" result for you.
Basic Format Example:
#Version;std1
#Date;16/08/2011
#Title;Wednesday Pairs
#Boards;24
#Scores
Position;Pair;Name1;Name2;Score;Tops;Percent;Boards
1;5;Sue;Mick;137;216;63.43;4;0;0;3;2;3;7;4;6;7;1;1;6;4;6;2;0;5;8;0;2;5;4;0;7;2;8
................
#Scores
Position;Pair;Name1;Name2;Score;Tops;Percent;Boards
1;5;Sue;Mick;137;216;63.43;4;0;0;3;2;3;7;4;6;7;1;1;6;4;6;2;0;5;8;0;2;5;4;0;7;2;8
................
#Travellers
NS;EW;NSScore;EWScore;NSPts;EWPts;Contract;Tricks;By
#Board;1
2;4;;50;0;8;4S;9;S
|