PCM.daily banner
22-01-2020 22:40
PCM.daily
Users Online
· Guests Online: 17

· Members Online: 3
maxmat52, Bikex, valverde321

· Total Members: 140,268
· Newest Member: Jiegx12
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.
 
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
Ad Bot
Posted on 22-01-2020 22:40
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
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
Reupload Databases for PCM 2005 & PCM 2006 Pro Cycling Manager 2006 8 08-11-2019 15:22
Question PCM 14: General 3 23-07-2019 17:35
Silly and Pointless (yet serious) Question PCM 14: General 3 17-07-2019 07:45
Question about PCM Games 3 08-07-2019 14:31
Technical issue - Why does it says error ? Pro Cycling Manager 2008 1 07-07-2019 13:31
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Umm.... ???
Umm.... ???
PCM16: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet Vien 19,234 PCM$
bullet df_Trek 12,401 PCM$
bullet baseba... 11,404 PCM$
bullet jseadog1 11,392 PCM$
bullet Yellow... 10,076 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet baseball... 12,956 PCM$
bullet jseadog1 12,355 PCM$
bullet trekbmc 11,294 PCM$
bullet Marcovdw 11,093 PCM$
bullet Vien 10,000 PCM$

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