|
Copy stats from other DB
|
| jferrarif1 |
Posted on 21-06-2016 23:34
|
Free Agent
Posts: 116
Joined: 06-10-2013
PCM$: 1200.00
|
Hi, I was wondering how can I copy the stats from other DBs, like you did with the Exp Pack Lite (you copied the stats from your 2016DB).
Is possible to do it? Thanks |
| |
|
|
| matt17br |
Posted on 21-06-2016 23:48
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Yes, you need to use the excel editor you can find in the download section of pcm 16. I've posted several tips on how to copy columns from a db to another using the editor, so you can easily find them thanks to the forum search.
|
| |
|
|
| jferrarif1 |
Posted on 22-06-2016 00:50
|
Free Agent
Posts: 116
Joined: 06-10-2013
PCM$: 1200.00
|
Thanks, I found some interesting tips.
I only want to copy the stats. So I have to copy all the columns (cyclist ID, name, team, all the stat columns...) or only the stats? And I also have to copy the Dyn_team table or only the Dyn_cyclist one? Thanks for help |
| |
|
|
| matt17br |
Posted on 22-06-2016 00:57
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
That depends on the situation you are in. What are you trying to copy? Is that copying stats having two dbs with same riders and teams already or copying stats having two completely different dbs?
|
| |
|
|
| jferrarif1 |
Posted on 22-06-2016 01:05
|
Free Agent
Posts: 116
Joined: 06-10-2013
PCM$: 1200.00
|
I'm trying to copy the stats from a complete db to the official cyanide db. I suppose I have to copy almost everything because the official db contains only a few riders and teams.
But I'll try to sort the cyclists alphabetically and copy the columns one by one |
| |
|
|
| matt17br |
Posted on 22-06-2016 02:10
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Nah if you want to do that you'll need to copy not only cyclists and teams, but also sponsors, sponsors regions, brand contracts and all the tables that have been modified. It's very complicated, or should I say long, but since most of the tables are unchanged almost, you can copy column by column for most parts.
|
| |
|
|
| Ad Bot |
Posted on 25-11-2024 13:40
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| jferrarif1 |
Posted on 22-06-2016 11:39
|
Free Agent
Posts: 116
Joined: 06-10-2013
PCM$: 1200.00
|
Ok, I'll keep it in mind |
| |
|
|
| ivaneurope |
Posted on 22-06-2016 12:20
|
Classics Specialist
Posts: 2933
Joined: 09-05-2011
PCM$: 300.00
|
matt17br wrote:
Nah if you want to do that you'll need to copy not only cyclists and teams, but also sponsors, sponsors regions, brand contracts and all the tables that have been modified. It's very complicated, or should I say long, but since most of the tables are unchanged almost, you can copy column by column for most parts.
And it's time consuming - keep that in mind. I gave up making 2016 DB for the PCM14.
|
| |
|
|
| depappie |
Posted on 25-07-2016 19:36
|
Neo-Pro
Posts: 259
Joined: 20-03-2007
PCM$: 200.00
|
Is it possible to open the DB for PCM2016 in kingsoft so i can sort the columns? don't care about editing, just to view would be good. I wanrt to copy the stats over on the PCM2011 Database Editor and cant see an easier way to do it. The Excel Exporter doesnt seem to like Kingsoft.
Edited by depappie on 25-07-2016 19:41
|
| |
|
|
| Lachi |
Posted on 25-07-2016 22:07
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
the excel exporter is a special tool build for excel.
if kingsoft can open xml files, then you can use the full editor from cyanide to extract the data. In kingsoft you can then open the different xml files. |
| |
|
