Open up Hannes Converter 2007 V2.0
Load up your database by clicking on the plug looking button and finding your file (my documents/PCM2007/database/solo/*******)
Select DYN_cyclist_career and DYN_cyclist by CTRL clicking them, and open both.
Open both side by side, so you can see both files and data.
If you did not sign any new riders in the year 2007 right at the start of the season, go to point 2.
Do the following however, if you signed any new riders before the start of the 2007 season, ie when the game began.
1. In the DYN_cyclist file, click on the "fkIDteam" heading to sort the riders into their teams. Find your team by scrolling down until you recognise a rider from your team.
Take note (write down somewhere) the "IDcyclist" number of each of your transfers from the start of the season.
Now go to the DYN_cyclist_career file and sort by "IDcyclist". Go to each of your riders who you signed from the start of the season, and selecting the row they belong on, click "kopeiren" (copy).
Repeat that for each of your pre-season transfers.
2. Look at the DYN_cyclist_career file.
Sort the file by clicking the "fkIDcyclist" heading.
Take note of the first large number in the "ID_cyclist_career" column that appears for the same "fkIDcyclist" value.
Eg.
ID_cyclist_career fkIDcyclist fkIDteam gene_i_year
1 1 3 2007
2 2 12 2007
3867 3 50 2007
3 4 8 2007
2475 4 27 2007
In this case you'd take note of 2475 as its a repeat of "fkICcyclist" number 4, whoever that may be!
Take note also of the first large number that appears in the "ID_cyclist_career" that belongs to a single "fkIDcyclist" value.
In the case above this would be 3867, belonging to "fkIDcyclist" number 3.
Sort the file by the "ID_cyclist_career" heading.
Select all rows from the first large number you took note of, to the second large number. (eg, 2475-3867)
Press delete.
Click save in the DYN_cyclist_career file.
Click the save button in the Hannes Converter program. Select your database, click yes to overwrite it, select DYN_cyclist_career file, click save.
Problem solved. Any further problems you may have, feel free to ask for further guidance/help.
Edited by rjc_43 on 15-01-2008 17:57
