This software is provided "as is". Use it at your own risk. The
executables are still an alpha version. Initial tests have not
revealed any compatibility problem with the game or samrol's editor.
Anyway, the author declines any responsibility for the
consequences of the usage of these programs.
Feel free to circulate it if you like it. No restrictions are place on
its usage or distribution.
ET2CSV
------
et2csv.exe reads "dbase.cdb" and generates the following files:
- "rider.csv", list of riders in the DB, and their parameters
- "team.csv", list of teams in the DB, and their parameters
- "dire.csv", list of directors (informative)
- "country.csv", list of countries (informative)
These files can be easily read and manipulated with any spreadsheet
application, such as Excel.
The file "dbase.cdb" must be in the directory where et2csv.exe is run.
Information not relevant for the Eurotour Cycling Manager is not
extracted. Lost information includes:
- Palmarés
- Biography
- Rider characteristics
- Most team parameters (bike manufacturer, sponsors and staff like that)
CSV2ET
------
csv2et.exe reads "rider.csv", "team.csv" and "dire.csv" and generates
"dbase-out.cdb" from them. Some notes:
- The files "rider.csv", "team.csv", "dire.csv" and "start.cdb" must be
in the directory where csv2et.exe is run
- "rider.csv" and "team.csv" must respect the format generated by
et2csv.exe. Misordered columns or supposedly numeric fields with text
will lead to an invalid "dbase-out.cdb" (error checking is not the
biggest strength of the current version)
- "dire.csv" and "country.csv" are not loaded into "dbase.cdb" for
compatibility reasons with the Editor by samrol. "dire.csv" is only
read to obtain the list of directors of a team. Directors in "dire.csv"
can only be associated to one single team; therefore, some teams won't
have any director associated to them. In this case, an existing but
arbitrary director id will be written in "dbase.cdb".
What can you do with the CSV files?
-----------------------------------
Once imported into Excel, you can
- Copy and paste rider definitions
- Use templates to define riders
- Perform bulk modification of parameters*
- Visualize riders list sorted by any field (climbing ability, TT,
team, role, ...)
- Merge databases in a less painful way**
- Massively delete riders. Useful if you want to create from scrath the
1973 peloton database.
- Add new teams easily, and edit their budget
* Bulk modification of parameters
For instance, say you want to augment the differences in climbing
capabilities among riders. You can insert a new column, compute the
value of their cells as
mnt_new = 1.4*mnt - 40
copy *the values* of the cells in this value, and paste them in the mnt
columnt. The result is
90 -> 86
60 -> 44
40 -> 16
Fat-assess will now climb as true ones.
** Merge databases in a less painful way
Say you have created the biggest database of slovenian riders, and a
japanese colleague sends you an update with all asian teams. Copy &
paste works great here. In case there are repeated ids, unique ones can
be easily generated in Excel. Overlapped DBs is a worse case. But still
manageable. Say you have added 300 riders to the original DB. Someone
else added 400, 200 of which are the same. What should you do? Paste
the 300 and the 400 new riders in a new sheet, sort them by name, and
find and delete (this is the most boring part) the 200 duplicated ones.
Add the result to your list of original riders and, voilá!, your
DB is now 200 riders longer.
Contents of the csv files
-------------------------
That's all. Enjoy!
For any question, bug report, suggestion or any other kind of feedback,
send an e-mail to allroch@yahoo.com
(c)allroch
