PCM.daily banner
23-11-2024 22:21
PCM.daily
Users Online
· Guests Online: 91

· Members Online: 2
Jakstar22, matfield

· Total Members: 161,796
· Newest Member: PogPatrol23
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?
 
Ad Bot
Posted on 23-11-2024 22:21
Bot Agent

Posts: Countless
Joined: 23.11.09
IP: None  
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
Hold your breath my guys!!
Hold your breath my guys!!
PCM 08: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,376 PCM$
bullet df_Trek 17,374 PCM$
bullet Marcovdw 15,345 PCM$
bullet jseadog1 13,552 PCM$
bullet baseba... 10,439 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,890 PCM$
bullet df_Trek 15,520 PCM$
bullet Marcovdw 14,800 PCM$
bullet jseadog1 13,500 PCM$
bullet baseball... 7,332 PCM$

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


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