I could not have created these hundreds of pages concerning tournaments results and players profiles by using a WYSIWYG tool, it would have taken too much time because in this case the presentation is always the same and the contents is changing often.

It would have been boring so I decided to generate pages from references pages that would only contain information and no layout. This way I can change the complete layout of these generated pages within minutes.
To be more precise a reference page is a file called index.txt which looks like a flat database.

Part of this formalism is inspired from Dr Wu's results form for ranking list, but as we developed our own solutions separately, both processes have not yet converged but we progress slowly.

Below is an extract of the reference page for the European Championships 1997 in Stockholm:

Name,European Championships
Town,Stockholm
Country,SWE
Year,1997
Month,August
Day,2-7
Detailed_place,Globen Annex
Photo,photo.jpg,320,247,Gaël Marziou
Countries_number,26
Players,224
#------------------------------------------------
Event,OF1-5
Score,7-21,21-16,21-19
Gold,Christiane Pape,GER
Silver,Ilona Sasvarine-Paulik,HUN
Bronze,Lone Rasmussen,DEN
Bronze2,Gertrudis Laemers,NED
#------------------------------------------------
Event,OF6-A
Score,21-18,21-17
Gold,Jolana Davidkova,CZE
Silver,Michelle Sevin,FRA
Bronze,Eva Pestova,CZE
Bronze2,Michala Zakova,CZE
#------------------------------------------------
Event,OM1-5
Score,21-15,21-19
Gold,Rolf Erik Paulsen,NOR
Silver,Bruno Benedetti,FRA
Bronze,Manfred Dollmann,AUT
Bronze2,Christophe DURAND,FRA

First, I chose ':' as field delimiter but I dropped it because I wanted to be able to specify URLs in field (e.g for photography author reference) which contain this char, then I chose ';' and dropped it also due to the fact that I wanted to be able to use HTML entities (e.g for accents like ë). Also this allows to load in or save from Excel spreadsheets using CSV format. In the future, those tools could be adapted to use a database in place of CSV files, this would be useful if we were able to generate dynamic pages from it.
Then, I have written tools in perl that understands this formalism and generates HTML pages for the tournament and updates the pages of the medallists. I have chosen perl as programming language because it is very well suited to text parsing and is widely available on various platform including UNIX and Windows which I use both, and finally perl is free.
You can take a look at these tools, reuse them if you want:

• results_profiles.pl the core, it generates all tournaments and players pages by using following modules:
  • IPTTC.pm contains definitions of variables used by all other modules.
  • IPTTC::Country.pm defines COUNTRY class and all related methods.
  • IPTTC::Event.pm defines EVENT class and all related methods.
  • IPTTC::Medal.pm defines MEDAL class and all related methods.
  • IPTTC::Player.pm defines PLAYER class and all related methods.
  • IPTTC::Photo.pm defines PHOTO class and all related methods.
  • IPTTC::Record.pm defines RECORD class and all related methods.
  • IPTTC::Tournament.pm defines TOURNAMENT class and all related methods.
• wput.pl (stands for 'web put') transfers automatically a directory to a web site using FTP.
• wdel.pl (stands for 'web delete') deletes automatically a directory from a web site using FTP.
• wdiff.pl (stands for 'web diff') find what files have changed of have been added in generated pages in order to build a list of files to transfer to web site using wput.pl.
• mk_index.pl generates an index.txt file from a ranking database tournament file.
• mk_gallery.pl generates an HTML gallery of mdeals..

Gaël MARZIOU