ECats Sims Scoring System Upload File Format ver 2

To be able to upload from a third party scoring program to the ECats Sims Scoring System, the program must be able to create four text files. These files are called C.TXT, P.TXT, R.TXT and E.TXT and are described below. To upload these files a small Windows 95/98/NT/2000 program will be supplied free of charge which will upload any .txt files in the directory in which it has been installed.
C.TXT

Example:

	1	"false"	18	3	"false"	"A Bridge Club"	"Any Town"	"In a County"	"England"	"Bill Smith "	"044 27782  72"	"044-78782 8782"	"someone@internet.com"	"true"	3	"5.6.27"	" "	" "

Description:

This file consists of one record (line) only and contains the details of the club playing. Many of the fields are not necessary for the purpose of scoring, however they must be included with their default values if no data is put in them. They are for internal use and future expansion. The fields are separated by a TAB character (ASCII 9 ) and each record is separated by a CRLF (ASCII 13) (ASCII 10). Textual fields are further delimited by enclosing them in " (ASCII 34) .

Structure:

Field	Data Type	Comments	Default Value	
TAB				
Spare	numeric (long)	Not Used	1	
TAB				
Two_winners	"true" or "false"	Is a two winner movement? 	"false"	
TAB				
Number of Boards played	Number (int)	Not important	0	
TAB				
Number of Boards per Round	Number (int)	Not important	0	
TAB				
Contract Recorded? 	"true" or "false"	"false" by default	"false"	
TAB				
Club Name	Text 50 chrs	Compulsory	Compulsory	
TAB				
Town	Text 50 chrs		""	
TAB				
County	Text 50 chrs		""	
TAB				
Country	Text 50 chrs	Compulsory (Spelling to be agreed)	Compulsory	
TAB				
Local Contact Name	Text 50		""	
TAB				
Local Contact Phone Number	Text 50	Compulsory	Compulsory	
TAB				
Local Contact Fax Number	Text 50		""	
TAB				
Local Contact Email	Text 50		""	
TAB				
Spare	"true" / "false"		"false"	
TAB				
Session	numeric (int)	This identifies what set of boards the results are for. The session number for each day will be given in the documentation for the event	Compulsary	
TAB				
Program Version	Text 5 chrs	This is used by the import program and is important	To be assigned later	
TAB				
Date of event	Text 50chrs	format "dd/mm/yyyy" 	""	
TAB				
Event Name	Text 100 chrs		""	
CRLF				

P.TXT

Example:

	1	0	1	"F Smith & Mrs E Brown"	"F Smith"	"Mrs E Brown"	"NS"	"nx123"	"ab123"
Description:

This file consists of one record (line) per pair and contains the details of the Players. Some of the fields are not necessary for the purpose of scoring, however they must be included with their default values if no data is put in them. They are for internal use and future expansion. No 'phantom' pairs should be entered, the scoring program deals with sit outs automatically. The fields are separated by a TAB character (ASCII 9 ) and each record is separated by a CRLF (ASCII 13) (ASCII 10). Textual fields are further delimited by enclosing them in " (ASCII 34) .

Structure:

Field	Data Type	Comments	Default Value	
TAB				
Spare	Number (long)	Not Used	0	
TAB			0	
Spare	Number (long)	Not Used		
TAB				
Pair Number	Number (int)	Can not be <=0 and must be unique no two pairs can have the same number even if one pair are playing NS and the other are playing EW	Compulsory	
TAB				
Players Names (combined)	text 50 chrs	Compulsory	Compulsory	
TAB				
Player1 Name	text 50 chrs	This is the first players name and is split for the purpose of assigning Master Points	Compulsory	
TAB				
Player2 Name	text 50 chrs	This is the second players name and is split for the purpose of assigning Master Points	Compulsory	
TAB				
Played NS or EW	text 2 chrs	Whether the pair player NS or EW ("NS" / "EW")	Compulsory	
TAB				
Player 1 id	text 50 chrs	Unique NBO Player ref 
(EBU no)	Optional	
TAB				
Player 2 id	text 50 chrs	Unique NBO Player ref 
(EBU no)	Optional	
CRLF				

R.TXT

Example:

	1	""	""	1	1	11	460	0	0	""	""	""	2	2	""	3	0	1
Description:

This file consists of one record (line) per line on the traveller and contains the details of the play. Many of the fields are not necessary for the purpose of scoring, however they must be included with their default values if no data is put in them. They are for internal use and future expansion. No 'phantom' pairs should be entered,or any blank results to allow for sit outs, the scoring program deals with sit outs automatically The fields are separated by a TAB character (ASCII 9 ) and each record is separated by a CRLF (ASCII 13) (ASCII 10). Textual fields are further delimited by enclosing them in " (ASCII 34) .

Structure:

Field	Data Type	Comments	Default Value	
TAB				
Spare	number (long)	Not Used	0	
TAB				
Spare	text 50 chrs	Not Used	""	
TAB				
Section	Text 50 chrs	Not Used	""	
TAB				
Board Number	number (int)	Can not be 0		
TAB				
Pair number NS	Number (int)	Must exist in the P.txt file		
TAB				
Pair number EW	Number (int)	Must exist in the P.txt file		
TAB				
NS score Plus	Number (int)	Scores are entered in their full format ie a score of 460 is entered as 460 and not 46 as in some programs		
TAB				
NS Score Minus	Number (int)	Scores are entered in their full format ie a score of 460 is entered as 460 and not 46 as in some programs		
TAB				
Spare	Number (int)	Not Used	0	
TAB				
Contract	text 10	Not Used	""	
TAB				
Tricks	text 20chrs	Not Used	""	
TAB				
Bid by	text 1 chrs	Not Used	""	
TAB				
Match Points NS	Numeric (double)	Not important as these are recalculated after upload	0	
TAB				
Match Points EW	Numeric (double)	Not important as these are recalculated after upload	0	
TAB				
Adjustment	Text 10 chrs	Format "A6040" for a 60% 40% etc if there is an adjustment anything in the NS score Plus or the NS score minus fileds is ignored	""	
TAB				
Session	Number (int)	Session Number	1	
TAB				
Spare	Number (int)	Not Used	0	
TAB				
Spare	Number (int)	Not Used	0	
CRLF				

E.txt

Example:

End

Description:

This is a small text file with just the word "End" in it, this file is the last one to be uploaded and is used to test whether all the files have uploaded successfully. It is important that this file exsists with the others, otherwise the results will not be imported into the main scores.