|
Technical question about databases
|
|
| Ad Bot |
Posted on 24-11-2024 19:09
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| giorgio4600 |
Posted on 09-09-2015 09:25
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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
Jiri |
| |
|
|
| Lachi |
Posted on 10-09-2015 10:20
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
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 |
Posted on 10-09-2015 10:25
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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 
|
| |
|
|
| giorgio4600 |
Posted on 11-09-2015 20:31
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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 |
Posted on 11-09-2015 20:39
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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 |
Posted on 11-09-2015 21:30
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
|
| |
|
|
| giorgio4600 |
Posted on 12-09-2015 08:03
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
OK, great, I will try it and I hope that it will work. Thank you very much for your help. |
| |
|
|
| giorgio4600 |
Posted on 13-09-2015 10:44
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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 |
Posted on 13-09-2015 12:09
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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  I hope that we could do that |
| |
|
|
| matt17br |
Posted on 13-09-2015 12:53
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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 I hope that we could do that
Good to know you got it to work
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.
|
| |
|
|
| giorgio4600 |
Posted on 13-09-2015 14:05
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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 |
Posted on 13-09-2015 14:15
|
Junior Rider
Posts: 48
Joined: 06-07-2010
PCM$: 200.00
|
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 ;-) |
| |
|
