PCM.daily banner
14-08-2020 20:32
PCM.daily
Users Online
· Guests Online: 22

· Members Online: 1
Marcovdw

· Total Members: 143,211
· Newest Member: pakard
Donate
View Thread
PCM.daily » Pro Cycling Manager 2013 » PCM 13: Databases
 Print Thread
Technical question about databases
giorgio4600
Hi all,

I have an question about database compatibility. I would like to have and 2006 database (PCMFreaks 2006 DB), which is created to Pro cycling manager 2012, but I havenĀ“t this version. I have an 2011 and 2013. So do you think that 2006 database will work on Pro cycling manager 2013? Or itĀ“s necesary to buy a 2012 version? Thanks for your reply.

Best regards

Banana
Jiri
 
Lachi
The databases structures are not compatible. Maybe it would be possible to copy the data to another database structure but I cannot help you with that.
But I think you should find the old games really cheap.
 
Ad Bot
Posted on 14-08-2020 20:31
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
matt17br
If the database was created for PCM 12 then it would be somewhat easy to copy the stuff over to PCM 11 or PCM 13 with Excel Editor (credits to the guy above me).

Once you figured out how it works it's gonna be fairly easy to convert it all. Should you need some explanations we're here Wink
Manager of pcmdaily.com/files/Micros17/ged.png Generali pcmdaily.com/files/Micros17/ged.png
 
http://v.ht/Matt17
giorgio4600
Ohhh...So, great, IĀ“m gonna try it. But first of all, do you have some tips how to do it? Do you think that I have to copy the data from database 2006 to some structure of database for Pro cycling manager 2011 or 13 isnĀ“t it? Thanks for your help. I really appreciate it.
 
giorgio4600
Maybe one more question, I know that itĀ“s out off topic, but I hope that maybe you could help me. I find the PCM norge 2007 database. But the torrent isnĀ“t working, do you think, that there is some possibility to find it? Or reupload it? Thank you guys
 
matt17br
giorgio4600 wrote:
Ohhh...So, great, IĀ“m gonna try it. But first of all, do you have some tips how to do it? Do you think that I have to copy the data from database 2006 to some structure of database for Pro cycling manager 2011 or 13 isnĀ“t it? Thanks for your help. I really appreciate it.

You can't copy-paste the data completely because there are some very small structural changes between those 2 games. Nonetheless, it should be easy to copy column by column, and especially with stats, you can copy them all easily.
To make your life easier you can download two copies of the excel editor and put one in a folder called "Excel1" or anything else and the other in a folder called "Excel2" and so on. Then don't forget to rename the second one to exporter2.xls or anything not to make them conflict and so you can use them at the same time.

Maybe one more question, I know that itĀ“s out off topic, but I hope that maybe you could help me. I find the PCM norge 2007 database. But the torrent isnĀ“t working, do you think, that there is some possibility to find it? Or reupload it? Thank you guys

You could try on pcm focus, they should have it on their server.
Manager of pcmdaily.com/files/Micros17/ged.png Generali pcmdaily.com/files/Micros17/ged.png
 
http://v.ht/Matt17
giorgio4600
OK, great, I will try it and I hope that it will work. Thank you very much for your help.
 
giorgio4600
Hi, I must apologize, but I donĀ“t know how to do it in excel editor. I normally use LachiĀ“s editor, but this excel editor IĀ“m little bit out of idea how to do it. When I start the exporter.xls, there will be the table with some button (export CDB,...) but when I click on it, it didnĀ“t work. Do you have some idea how to do it? Thanks for your help. And sorry, that I wasting your time.
 
giorgio4600
Ok, so editor is finally works. So whatĀ“s now? I donĀ“t understand "copy column by column"...Do you mean column from database 2006 to column in some other database or what? Thank you Smile I hope that we could do that
 
matt17br
giorgio4600 wrote:
Ok, so editor is finally works. So whatĀ“s now? I donĀ“t understand "copy column by column"...Do you mean column from database 2006 to column in some other database or what? Thank you Smile I hope that we could do that

Good to know you got it to work Wink
First exteact the 2006 db cdb and open all the important tables you want to copy (dyn_cyclist, dyn_team, sponsors, sta_race and sta_stage, all the palmares related tables).
Now in exporter2.xls open the base db of pcm 13 and open the same tables.
Now copy the data of each column in the corresponding columns, if you find out that the structure of the db is the same for some consecutive columns you can copy paste more data at the same time.
Manager of pcmdaily.com/files/Micros17/ged.png Generali pcmdaily.com/files/Micros17/ged.png
 
http://v.ht/Matt17
giorgio4600
UFFFF,...takes some times and nerves, but finished. I done it, but I have one problem. When I click on build CDB, it starts exporting, but after a while...i says that the program doesnĀ“t work and needs to be closed... :-/ do you have an idea?
 
giorgio4600
Oh god, I made some mistake, that I do it in exporter2.xls, so there is a problem, I should do it in exporter.xls and copy from exporter2.xls. So I have to do it again, but now it will finally works I hope. So thank you. After I will do it, I will share this work for others who wants to play it. Thank you again man, I save me a lot of nerves ;-)
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
question errorlog PCM 20: Database 2 26-06-2020 10:56
Databases from PCM 2019? PCM 20: Database 6 23-06-2020 21:11
Reupload Databases for PCM 2010 Pro Cycling Manager 2010 5 21-06-2020 20:55
Reupload PCM 2005 & PCM 2006 Databases Pro Cycling Manager 2006 9 17-06-2020 18:44
Reupload PCM 2007 Databases Pro Cycling Manager 2007 2 17-06-2020 18:36
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Teamcom Interface 2
Teamcom Interface 2
Tour de France 2014
Fantasy Betting
Current bets:
bullet Il Lombardia: Winner

Best gamblers:
bullet dominox 3,130 PCM$
bullet baseba... 3,102 PCM$
bullet jseadog1 3,000 PCM$
bullet df_Trek 2,826 PCM$
bullet Yellow... 2,780 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet baseball... 15,856 PCM$
bullet jseadog1 15,355 PCM$
bullet Marcovdw 13,993 PCM$
bullet dominox 12,345 PCM$
bullet trekbmc 11,294 PCM$

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