PCM.daily banner
21-11-2024 11:16
PCM.daily
Users Online
· Guests Online: 62

· Members Online: 2
StijnL, Caspi

· Total Members: 161,769
· Newest Member: Losiuda
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2008
 Print Thread
CDB Starter Kit
impish
Also das tool konvertiert eine CDB Datenbank in XML Files welche in den Editor der 2008 Version geladen werden können.

HowTo:
Zuerst eine gewünschte CDB Datenbank in den ....\Pro Cycling Manager 2008\DatabaseEditor\Database\ Ordner kopieren.

Nun den Editor2008 starten und diese Datenbank müsste im linken Fenster erscheinen. Die Tabelle auswählen und auf den Laden Button des Editors drücken.

Wahrscheinlich stürzt das Teil dabei ab aber es sollte nun ein Ordner enstanden wurden sein der den namen der Datenbank trägt. Schaut mal unter ....\Pro Cycling Manager 2008\DatabaseEditor\Database\Exports\{DATENBANKNAME}\. In diesen Ordener findet ihr nun die Datei Export.xml und genau die brauchen wir.

Nun startet ihr das tool (also CDB Starter Kit) und wält nach drücken der Open / Export.xml das vorhin erzeugte file ....\Pro Cycling Manager 2008\DatabaseEditor\Database\Exports\{DATENBANKNAME}\Export.xml aus.

Nach ca. 10 sekunden sollte nun die erforderlichen Datein in diesen Ordner generiert wiorden sein, und ihr könnt mit der Arbeit beginnen. (Wichtig ist es noch aus einen vom Editor 2008 erstellten Ordner alle *.eyo.sch Dateien in eueren neuen Ordner zu kopieren - der Editor2008 erzeugt diese Dateien wenn man zb. die Official Release 2008 cdb einmal mit den editor gestartet hat)

Falls ihr fehlermeldungen bekommt, welche im Fenster des Tools angezeigt werden so hilft es meistens die Export.xml mit UltraEdit oder einen anderen Editor zu öffnen. Und fügt gleich zu Beginn folgende Zeile ein.

===============================
<?xml version="1.0" encoding="iso-8859-1"?>
===============================


Das File neu speichern und nochmals mit CDB Starter Kit konvertieren.

https://www.livesports.at/CDB_StarterK...terKit.exe eventuell benötigt ihr .Net (sollte aber heut zu Tage - eh jeder haben)

habe das tool mit der giant silver von 2007 (also basis pcm 2006) getestet und es hat die 6 tabellen ohne probleme erzeugt.

HINWEIS: DAS TOOL ERSTELLT NUR DATEN WELCHE IM EDITOR VERWENDET WERDEN. ALSO FÃœR CDB MACHER IST ES SICHER EINE GROSSE HILFE UM ZU BEGINN DIE MÃœHSAME DATENKLOPFEREI SICH ZU ERSPAREN.
Edited by impish on 14-06-2008 19:41
 
Setzel
ENGLISH !!!????
Eating my daily Breakfast at 9 pm

i56.tinypic.com/2zoxd05.jpg
 
p3druh
Could you translate that to English since most people here don't speak German?
img401.imageshack.us/img401/3756/91640730.png
 
impish
maybe during greece vs. russia......
 
impish
ENGLISH
This tool converts old databases (2005, 2006, 2007) to an editor 2008 working version.

HOWTO:
At first copy an old *.cdb database into your ....\Pro Cycling Manager 2008\DatabaseEditor\Database\ folder.

Now start Original PCM Editor 2008, and if its okay your copied database will be displayed in the left window. At next choose this table and press the load-button.

Normaly the editor crashed becasue its a cyanide product, but we love cyanide and if you take a look at this folder .....\Pro Cycling Manager 2008\DatabaseEditor\Database\Exports\{DATENBANKNAME}\ a file called export.xml survive the crash.

**)
Now start CDB_StarterKit and after press the Open/Export.xml show windows where this export.xml file is stored.

After 10 seconds the tool creates the missing *.eyo files. If you get an error message displayed in the textfield open this export.xml file with an edotr like UltraEdit and paste on the top following line. (only the xml line)

===============================
<?xml version="1.0" encoding="iso-8859-1"?>
===============================

and go back to **)

Now it must work. At last we need *.eyo.sch files which PCM EDITOR 2008 creates. So copy all *.eyo.sch files from an allready with editor opened folder and copy it to our folder.

Now you can start PCM EDITOR 2008 and something wonderful is happening you get a old database for 2008.

Cyanides Editor only worked with
- STA_race
- STA_stgae
- DYN_cyclist
- DYN_team
- DYN_Country
- STA_UCI_class

testet it with 2005, 2006, 2007 and Giant cdb files. Angry

https://www.livesports.at/CDB_StarterK...terKit.exe .Net must be installed.


impi
 
impish
screenshoot from testing with giant 2007 (based on PCM 2006)


www.livesports.at/Giant_Test.JPG

www.livesports.at/Giant_Test2.JPG

www.livesports.at/Giant_Test3.JPG

www.livesports.at/Giant_Test4.JPG
 
jolly_antunes
Forget Dankan, if this really works you're my GodPfft
 
Dankan
Remember I'm in strong advantage here, since I'm already working on the "huge" project with other tools Wink
 
http://www.linkedin.com/in/danielsanchezbadorrey
MarcoPRT
No matter who launches a db or not, the only thing we want is bigger and better projects.Wink
img8.imageshack.us/img8/5599/steamgif0tvvj8sv8z.gif
 
mrlol
well, I'm with Dankan, as I spot a lot of errors on the screen...
norwegian rider with team spain dutch rider riding with italy, Gerolsteiner has as short name miche, Dynatek has Davitamon and so on...
 
www.leoadriaansenfotografie.nl
impish
i never create a database, its not my buisness (dankan, plakker and other guys do it create - based on my ideaWink - how to blow up the cdb structure), this tool is only to convert old databases to the new 2008er structure, and believe my it works - giant2007 with one button klick converted to 2008 in 10 seconds.......and after this only database creaters can handle this file. the result are a not playable version but the base structure.

btw the countrys are wrong because this screenie is done before STA_country was imported.
Edited by impish on 15-06-2008 07:21
 
Ad Bot
Posted on 21-11-2024 11:16
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
Mercury
Great work, impish - as always. Wink

Have you looked into fixing Kicker for 08-databases yet!? At least DYN_cyclist causes the tool to create an overflow error upon export. Can you perhaps fix that and make a lot of us really happy? Smile
 
http://www.pcmgeeks.dk/news.php
wackojackohighcliffe
i will wait for peoples opinions before trying this - good work though
 
CrueTrue
Very well done, Impish. Unfortunately, the link for the file is down. Could someone reupload it, please?
 
http://www.pcmdaily.com
impish
the link is down because

*) i have small problems to interpret the xml language code corectly (special characters didnt accept correctly by editor)
*) i wait for the release to test if changing really works - because its not enough that it runs in editor
*) trying to convert a whole cdb from 2006 to 2008 and if this okay you get more infos

impish
 
Crommy
I have to say, if it works, this is quite simply a pretty incredible tool Wink
emoticons4u.com/happy/042.gif
 
Addy291
I haven't tried it, but appreciate the technicalities of it, great work impishSmile
YORKSHIRE BORN, YORKSHIRE BRED...
 
impish
after midnight i got a great idea and now it looks great, to continue with my spare time to create this tool.

At the moment i try it with PCM2008, PCM2007,PCM2006 (Giant) CDB Files.

In this example i like to get an PCM2008 CDB based on PCM2006 (Giant). I use a filter in this case to import only STA_STAGE and STA_RACE into 2008 Structure.

STA_STAGE uses the same structure only STA-RACE use a new COLUMN (and kicked 4 old one).

The Tool creates the new CDB.xml file set a warning that Database Creator must change something per hand.

<Column ColumnName="fkIDtype_race" ColumnID="41" ColumnType="Int8">
<WARNING = Source CDB didnt has this Information!!>
<BASE = c:\CDB_Converter\2008_OfficialRelease\>
<SOURCE = c:\CDB_Converter\2006_OfficialRelease_Giant\>
<TABLE = STA_race>
<COLUMN = fkIDtype_race>
<TYPE = CELLS>
</Column>
 
wackojackohighcliffe
if you look closely, nearly all the files dont match eg. the shortname for dfl(kurzname) is milram continental and their website is scott.br

this is the same for nearly all the teams:cry:
 
impish
because dyn_team wasn't imported in this case
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Peleton
Peleton
PCM09: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,376 PCM$
bullet df_Trek 17,374 PCM$
bullet Marcovdw 15,345 PCM$
bullet jseadog1 13,552 PCM$
bullet baseba... 10,439 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,890 PCM$
bullet df_Trek 15,520 PCM$
bullet Marcovdw 14,800 PCM$
bullet jseadog1 13,500 PCM$
bullet baseball... 7,332 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.35 seconds