The Eurovision Song Contest
EuroScore software

Introduction

This is the software used to generate the 2005 scorecard, the 2006 scorecard, the 2007 scorecard, and the 2008 scorecard.

A primary dependency of this software is that it assumes your site will be set up as mine is:

   /                              Site root directory

   /eurovision                    Eurovision main index directory
   /eurovision/euroscore.html     This file :-)

   /eurovision/2005               Files for 2005
   /eurovision/2005/index.html    Eurovision 2005 index

For 2005-2007:
   /images/eurovision/2005/semi   Semi-final 2005 images (.jpeg)
   /images/eurovision/2005/final  Final 2005 images (.jpeg)

For 2008:
   /images/eurovision/2008/semi1  First semi-final images (.jpeg)
   /images/eurovision/2008/semi2  Second semi-final images (.jpeg)
   /images/eurovision/2005/final  Final images (.jpeg)

Paths are relative (i.e. "../../images/etc etc").
Other years (2006, 2007, ...) are to be laid out in the same manner.

Preparing the data (the easy way)

EuroScore reads a CSV format data file, in a specific layout. However it is easiest to use a database package (such as Works) to generate the database.

Eurovision 2005 data files
eurovision2005.wdb	Scoring information, Works 4.0 database file.	17K
eurovision2005.csv	Scoring information, Comma Separated data file.	6K
Eurovision 2006 data files
eurovision2006.wdb	Scoring information, Works 4.0 database file.	17K
eurovision2006.csv	Scoring information, Comma Separated data file.	6K
Eurovision 2007 data files
eurovision2007.wdb	Scoring information, Works 4.0 database file.	18K
eurovision2007.csv	Scoring information, Comma Separated data file.	7K
Eurovision 2008 data files
eurovision2008.wdb	Scoring information, Works 4.0 database file.	19K
eurovision2008.csv	Scoring information, Comma Separated data file.	7K

Preparing the data (the hard way)

The data should be laid out as follows:

Short country name	String	This is the "short" version of the country name (i.e. Bosnia instead of Bosnia & Herzegovina).
Score	Number	This is the number of points awarded. This should be blank (not zero!) for countries that did not qualify in the semi-final.
Associated image	String	This is an image to include with the score, empty (i.e. "") if no image. If the country did not qualify in the semi final, the images will be looked for in the path: `../../images/eurovision/<year>/semi/` If the country took part in the final, the path will be: `../../images/eurovision/<year>/final/` The extension ".jpeg" is automatically appended. AS OF 2008: If the song did not pass the semi-finals, the first two characters of the image name is either '1' or '2' followed by an exclamation mark. Thus "1!country" is for 'country' in the first semi-final; likewise "2!country" would be for 'country' in the second semi-final.
Gave 1 point to?	String	This is the "short" version of the country that was awarded one point by the current country.
Gave 2 points to?	String	As above.
Gave 3 points to?	String	As above.
Gave 4 points to?	String	As above.
Gave 5 points to?	String	As above.
Gave 6 points to?	String	As above.
Gave 7 points to?	String	As above.
Gave 8 points to?	String	As above.
Gave 10 points to?	String	As above.
Gave 12 points to?	String	As above.
Comment	String	If a comment is wanted, include it here; otherwise this should be blank (not "").
Full country name	String	This is the 'complete and full' name of the country, if required; else blank.
Abbreviated country name	String	This is a shorter name of the country, if required; else blank.
Song name	String	This is the title of the song.

Here is an example. This is one complete line, only split to look nicer on-screen:

"Bosnia",79,"21bosherz","Hungary","Romania","Norway","Moldova", "Albania","Greece","Macedonia","Turkey","Serbia","Croatia", "but 1<sup>st</sup> in my heart","Bosnia & Herzegovina", "Bosnia & H.","Zovi"

Of note is the fact that the comment and country names must be given in HTML form (i.e. "&" instead of "&").

However, I'm sure you'll agree that the use of software such as Works will make things so much easier!

Using EuroScore

Place EuroScore.exe and the .csv file into the same directory.

Run EuroScore:

   EuroScore <year> <csv file>

The year is the year, "2005", just that.
The CSV file is the name of the CSV file containing the data for the scorecard you wish to generate.

For example:

   EuroScore 2005 Eurovision2005.csv

If all goes to plan, the command prompt will reappear after a short delay. The scorecard has been created with the file name scorecard<year>.html, in this case scorecard2005.html.

The software

EuroScore is a 32bit DOS application. It runs from the command prompt, but because it is a 32bit DOS application it requires Windows 95 or later.
It is not a "DOS extended" application so it will not run on DOS/Windows platforms previous to Windows 95.

The software provided below is v0.05 (which supports both single and multiple semi-finals).

EuroScore software (for 32-bit DOS (Windows 95+))
euroscore_005.exe		EuroScore installer, v0.05.		264K

Save this installer to your harddisc, and then run it to install the EuroScore software, plus the source codes.

The source codes are intended to be compiled using OpenWatcom 1.2 (or later), but should be fairly easy to port to other compilers/platforms. Apart from some "//" style comments and some DOSisms relating to paths, the code is generic C.

You can also browse the source code:

Country.c (86Kb) CSVloader.c (43Kb) EuroScore.h (12Kb) ImageSize.c (12Kb) MemTrace.c (48Kb) WrapperCode.c (25Kb)

Back to the Eurovision index

The Eurovision Song Contest EuroScore software