|
A few questions
|
| atlanta |
Posted on 15-02-2015 14:31
|
Protected Rider
Posts: 1220
Joined: 31-07-2011
PCM$: 200.00
|
Would i be able too change the 2013 db(the one with Euskaltel annd Vaconseli in-2012 nc one)?. I would like to change the year to 2011 and obviously i wouldl need to delete the palmares of 2012 season. Is this possible?. I want to be Radioshack with Andy and Frank it will be more realistic that way. |
| |
|
|
| matt17br |
Posted on 15-02-2015 15:16
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Yes, all this is possible.
You'll need to change the starting year editing the column "starting_year" in GAM_Config from 2013 to 2011
To delete the 2012 palmares you must edit DYN_Palmares. Sort by year and just delete the entries that have got the value "2012" under value_i_year.
Lastly, if you want to edit the national champions, you have to edit the table dyn_cyclist and the column gene_i_champion or something. I'd advise you to do this with pcm fast editor that shows the meaning of the numbers representing the various national champions jerseys, it will save you a lot of time 
But why don't you just use the 2011 db and convert it to 2013? Obviously it isn't possible to totally convert the 2013 db to 2011, there will be lots of riders missing etc.
It would look like a huge amount of work, but with the excel editor by Lachi it would be much easier to do. Probably the biggest difficulty you will face will be the tables layout, but it didn't change that much since then. If you don't know anything about it I'd advise you to visit this link: https://pcmdaily.com/infusions/pro_dow...hp?did=867
Of course I'm not considering all the jerseys and stages you'd miss though...
|
| |
|
|
| atlanta |
Posted on 16-02-2015 10:59
|
Protected Rider
Posts: 1220
Joined: 31-07-2011
PCM$: 200.00
|
Thanks for your help Matt, i managed to change the year fine but deleting the palmares just takes way too long it only deletes it 1 bye 1 and it is no fun playing it that way. |
| |
|
|
| matt17br |
Posted on 16-02-2015 11:47
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
atlanta wrote:
Thanks for your help Matt, i managed to change the year fine but deleting the palmares just takes way too long it only deletes it 1 bye 1 and it is no fun playing it that way.
Use excel editor. You can delete them all by selecting them and pressing delete on your keyboard
|
| |
|
|
| atlanta |
Posted on 16-02-2015 12:32
|
Protected Rider
Posts: 1220
Joined: 31-07-2011
PCM$: 200.00
|
excel editor how do i move them from fast editor to excel? Sorry if im sounding abit stupid i just don't have a clue. |
| |
|
|
| matt17br |
Posted on 16-02-2015 12:38
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Open excel editor, load the cdb file, wait for the cdb to xml conversion, only open dyn_palmares when it will ask which tables to open, sort by year and only delete the 2012 entries. Then re export to cdb and you're done
|
| |
|
|
| atlanta |
Posted on 16-02-2015 12:41
|
Protected Rider
Posts: 1220
Joined: 31-07-2011
PCM$: 200.00
|
I do not have excel editor will apache open office work? Or is there anything free i can download to do it?. I started one with the 2013 db anyway gave Andy a update but would rather i could start from 2011 or 2010. Thanks . |
| |
|
|
| Ad Bot |
Posted on 22-12-2024 13:43
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| matt17br |
Posted on 16-02-2015 13:38
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
No, Excel Editor only works with Microsoft Office AFAIK. Tested it with Libre Office, that's basically 95% the same as OpenOffice. Those suits don't support the macros of the file exporter.xmls properly.
|
| |
|
|
| Lachi |
Posted on 16-02-2015 15:23
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Yes, the macros might not run in any other office suite.
But all you need is an editor which extracts XML files from the database. I don't know the fast editor but my editor or the full editor from Cyanide both extract XML files.
This is what you have to do:
1. Create a new database from your editing in Fast Editor or just save, if Fast editor works with XML files
(2. Open/Extract that database with another editor, if Fast Editor does not work with XML files)
3. Run something like excel (don't know the apache office suite but editing XML files should be fairly common now).
4. Open the XML file of the table DYN_palmares
5. Delete all lines except the title row
6. Save
7. Build the database using the editor from point 2 (or point 1)
Edited by Lachi on 16-02-2015 15:23
|
| |
|
|
| matt17br |
Posted on 16-02-2015 15:34
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Lachi is right, I'll just add that Full Editor V4 by Cyanide will quickly convert the cdbs to xml so that you can open the xmls in OpenOffice and edit them, Fast Editor won't do it. Here's the link: https://pcmdaily.com/infusions/pro_dow...hp?did=485
Edited by matt17br on 16-02-2015 15:34
|
| |
|
|
| atlanta |
Posted on 19-02-2015 17:37
|
Protected Rider
Posts: 1220
Joined: 31-07-2011
PCM$: 200.00
|
Thanks for you're help guys ive decided use 2005 db with Team CSC(beastly team haha). I am waiting till 2007 or 2008 to start a story i want do a story about some huge Contador Schleck battles. Armstrong needs to hurry up and retire though he is 2005 Giiro champion, 2005 TDF and 2006 TDF. He has 9 GT wins 2 behind Mercxx. |
| |
|
