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
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.
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
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?
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
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.
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.
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
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.
