PCM.daily banner
17-12-2025 06:48
PCM.daily
Users Online
· Guests Online: 59

· Members Online: 0

· Total Members: 54,920
· Newest Member: RodrigueGauthier
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2010
 Print Thread
Can I import results
liveSTRONG7
Top  #1 Print Post
Posted on 14-08-2010 16:06
Hello,
my question is, if and how I can import stage results (written in an excel table) in a tour?
Maybe somebody can help me!
 
Lachi
Top  #2 Print Post
Posted on 14-08-2010 16:45
Do you speak about a tour within your career?
What do you want to achieve? Where did you get the stage results from? What about the race overall results?
 
liveSTRONG7
Top  #3 Print Post
Posted on 14-08-2010 17:47
I mean an result of a stage in a tour, not in the career modus.
When the stage is finished I have the possibility to export the result. And when I change something in the exportet Version, for example that not Andy Schleck is the stage winner but Denis Menchov is, can I import that changed version to the race?
 
Lachi
Top  #4 Print Post
Posted on 14-08-2010 19:47
If you want to modify the stage winner or the time, then you have to do it in the save using an editor.

You have to edit the tables DYN_classification_stage and maybe DYN_classification_race.

It is straight forward, each rider and team has one line per stage and type of classification. Just look up all the IDs in all the related tables. (STA_stage, DYN_cyclist, DYN_team, STA_classification_type, STA_classification_state)

If you already exported it to an excel, you could write down the ID of the cyclists on that sheet so that you don't have to lookup each value separately.
 
liveSTRONG7
Top  #5 Print Post
Posted on 15-08-2010 00:56
I made this list and tried to import it to the game but it wasn't possible, whats the reason for that.
I exportet an result, rewrote it and tried to import it through the impor folder...?
 
liveSTRONG7
Top  #6 Print Post
Posted on 15-08-2010 01:00
I can't attache the file, it's an .xls file with the classification tables.
For example:

<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns="urn:schemas-microsoft-comShockffice:spreadsheet"
xmlnsShock="urn:schemas-microsoft-comShockfficeShockffice"
xmlns:x="urn:schemas-microsoft-comShockffice:excel"
xmlns:ss="urn:schemas-microsoft-comShockffice:spreadsheet"
xmlns:html="https://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-comShockfficeShockffice">
<LastAuthor>Cycling Manager 4</LastAuthor>
<Created>2003-05-05T17:15:02Z</Created>
<LastSaved>2003-05-05T17:15:02Z</LastSaved>
<Version>1.0</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-comShockfficeShockffice">
<DownloadComponents/>
<LocationOfComponents HRef="file:///C:\"/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-comShockffice:excel">
<WindowHeight>5490</WindowHeight>
<WindowWidth>9660</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>0</WindowTopY>
<ActiveSheet>0</ActiveSheet>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders>
<Border ssPfftosition="Left" ss:LineStyle="Continuous" />
<Border ssPfftosition="Right" ss:LineStyle="Continuous" />
<Border ssPfftosition="Top" ss:LineStyle="Continuous" />
<Border ssPfftosition="Bottom" ss:LineStyle="Continuous" />
</Borders>
<Font/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s21">
<Borders>
<Border ssPfftosition="Left" ss:LineStyle="Continuous" />
<Border ssPfftosition="Right" ss:LineStyle="Continuous" />
<Border ssPfftosition="Top" ss:LineStyle="Continuous" />
<Border ssPfftosition="Bottom" ss:LineStyle="Continuous" />
</Borders>
<Interior/>
</Style>
<Style ss:ID="s22">
<Alignment ss:Horizontal="Center"/>
<Borders>
<Border ssPfftosition="Left" ss:LineStyle="Continuous" />
<Border ssPfftosition="Right" ss:LineStyle="Continuous" />
<Border ssPfftosition="Top" ss:LineStyle="Continuous" />
<Border ssPfftosition="Bottom" ss:LineStyle="Continuous" />
</Borders>
<Font ss:FontName="Verdana" ss:Size="18" ss:Color="#FF0000" ss:Bold="1"
ss:Italic="1"/>
<Interior/>
</Style>
<Style ss:ID="s23">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom" ss:WrapText="1"/>
<Borders>
<Border ssPfftosition="Left" ss:LineStyle="Continuous" />
<Border ssPfftosition="Right" ss:LineStyle="Continuous" />
<Border ssPfftosition="Top" ss:LineStyle="Continuous" />
<Border ssPfftosition="Bottom" ss:LineStyle="Continuous" />
</Borders>
<Font ss:FontName="Verdana" ss:Color="#000000"/>
<Interior/>
</Style>
</Styles>
<Worksheet ss:Name="Stage results">
<Table ss:ExpandedColumnCount="10" ss:ExpandedRowCount="200" x:FullColumns="1" x:FullRows="1" ss:StyleID="s21" ssGrinefaultColumnWidth="60">
<Column ss:StyleID="s21" ss:Width="64" ss:AutoFitWidth="1"/>
<Column ss:StyleID="s21" ss:Width="220" ss:AutoFitWidth="1"/>
<Column ss:StyleID="s21" ss:Width="220" ss:AutoFitWidth="1"/>
<Column ss:StyleID="s21" ss:Width="160" ss:AutoFitWidth="1"/>
<Column ss:StyleID="s21" ss:Width="220" ss:AutoFitWidth="1"/>
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s22"><Data ss:Type="String">Rank</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">Name</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">Team</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">Time</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">Player</Data></Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s23"><Data ss:Type="Number">1</Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[Francesco Secchiari]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[DOMINA VACANZE]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[3h22'06]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[]]></Data></Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s23"><Data ss:Type="Number">2</Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[Iker Flores Galarza]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[EUSKALTEL - EUSKADI]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[s.t.]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[]]></Data></Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s23"><Data ss:Type="Number">3</Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[Thomas Voeckler]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[BRIOCHES LA BOULANGERE]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[s.t.]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[]]></Data></Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s23"><Data ss:Type="Number">4</Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[Sandy Casar]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[FDJEUX.COM]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[s.t.]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[]]></Data></Cell>
</Row>
<Row ss:AutoFitHeight="1">
<Cell ss:StyleID="s23"><Data ss:Type="Number">5</Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[Christophe Mengin]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[FDJEUX.COM]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[s.t.]]></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><![CDATA[]]></Data></Cell>
</Row>

Isn't it possible to import that file?
 
liveSTRONG7
Top  #7 Print Post
Posted on 15-08-2010 11:53
I now work with Lachis editor (Version 0.4) but I don't know in which column to modify the time of each rider in a stage (in DYN_classification_stage)...?? for example that a rider wins in front of a two minute gap to the next...
Would be nice if anybody could help
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Magazine (English)
Magazine (English)
PCM 07: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 23,976 PCM$
bullet Marcovdw 21,045 PCM$
bullet df_Trek 19,674 PCM$
bullet jseadog1 17,752 PCM$
bullet baseba... 13,839 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 24,090 PCM$
bullet Marcovdw 20,500 PCM$
bullet df_Trek 17,820 PCM$
bullet jseadog1 17,700 PCM$
bullet Caspi 10,930 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.11 seconds
Copyright © 2006-2023


Powered by PHP-Fusion Copyright © 2025 PHP-Fusion Inc
Released as free software without warranties under GNU Affero GPL v3