|
Editing from DB to DB
|
| roturn |
Posted on 28-01-2011 08:36
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
As I normally write all lines by hand I need some help.
What is the easiest way to copy some teams and all their riders from one DB into another.
As I want to add this teams into my career is there something I must take care about? Any other tables than DYN_Cyclist or DYN_team?
Also is it better to copy the lines from savegame to savegame instead from normal db to savegame?
Hope you understand what I mean  |
| |
|
|
| Vardavagor |
Posted on 28-01-2011 09:16
|
Amateur
Posts: 4
Joined: 27-03-2008
PCM$: 200.00
|
Use the XML Model .... but take care about the rider id ... im sure you would ^^ Lacis Editor for example saves the XML-Data everytime you open a DB
Open XML Model with normal Editor makes Copying straightforward
i can give some answer, but im not a DB expert, for the other questions.
Maybe DYN_CONTRACT?
DB -> SG or SG -> SG ...don't think theres a difference.
EDIT: Sure there is a difference ...
DB -> SG:
take care about Riders Potentials (= 0 in open SG, dont know when a 0 Potential is fullfilled with the estimated one.)
DYN_CONTRACT should be filled up i think
Edited by Vardavagor on 28-01-2011 09:20
|
| |
|
|
| Ad Bot |
Posted on 24-11-2024 13:56
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| CrueTrue |
Posted on 28-01-2011 09:21
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
If you want to add it to a save game, it 's probably best to start a save gave with the DB that you're adding from.
You have to be aware of several things, though:
1. Conflicting IDs. Cyclist ID, team ID or contract ID (dyn_contract_cyclist) - check that you're not "doubling" them between the DBs.
2. DYN_palmares, DYN_palmares_cyclist, DYN_palmares_team. If you change the ID of either a team or a cyclist, you may have to change it in DYN_palmares_cyclist and DYN_palmares_team. Again, check that the palmares-IDs do not conflict. |
| |
|
|
| roturn |
Posted on 28-01-2011 09:22
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Thanks for the answer.
The XML copy&paste was also my first idea, but hoped that there is an easier way with Excel for example. Then I can sort by TeamID for example and copy all riders of this team by one step. In the XML they are alphabetical I think and so I have to copy every rider one by one.
I can open it with Excel but the last line says something like Don`t delete or edit this one, so I am not sure if I can add lines in Excel.
BUT DYN_Contract_Cyclist is also a good question. Do I have to edit this one, too or is this happening automatically on 01/01?
Edited by roturn on 28-01-2011 09:23
|
| |
|
|
| roturn |
Posted on 28-01-2011 09:26
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
CrueTrue wrote:
2. DYN_palmares, DYN_palmares_cyclist, DYN_palmares_team. If you change the ID of either a team or a cyclist, you may have to change it in DYN_palmares_cyclist and DYN_palmares_team. Again, check that the palmares-IDs do not conflict.
If all riders and teams are completely new, do I really have to edit the palmares tables then?
My steps would be like:
-edit DYN_Team
-edit DYN_cyclist
always check that no ID`s are double
-edit DYN_Contract_Cyclist if necessary |
| |
|
|
| CrueTrue |
Posted on 28-01-2011 09:44
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Use the Full Editor for this. Open the Exports folder - this contains all the tables and columns in Excel files (1 per table).
DYN_contract_cyclist is necessary if you add it to an on-going save game. Otherwise, the riders won't be contracted with their teams. You wouldn't have to edit it if you were adding the teams and riders to a DB.
Concerning the palmares. I don't know what team you intend to add, but there are several things to be aware of:
1) Even though the teams and riders are new, they can still have a link in the palmares section. There are plenty of riders there who are not in the DB (due to historical results)
2) If you want their current team to show up properly in the history section, uou have to add it to DYN_palmares.
It's not essential in terms of playing the game, but if you want it the historical data to show up properly, you will have to edit DYN_palmares, DYN_palmares_cyclist and DYN_palmares_team. |
| |
|
|
| roturn |
Posted on 28-01-2011 10:55
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Then it is like I expected. Thanks a lot.
Historical things doesn`t matter. Just need some more riders as I also added some races.
The teams I add are small Conti Teams, so they won`t be in the palmares probably. But I will have a look.
I am more used into Lachi`s Editor, but the xml`s are also there, so I guess I can use them in Excel, too.
But the last line says "DUMMY - DO NOT EDIT OR DELETE THIS ROW"
So can I add more lines below this line or do I have to add this line on the last line again after adding all necessary lines?
I just realize that I can edit almost everything but I am still quite new into teams and equipment 
Edited by roturn on 28-01-2011 10:56
|
| |
|
|
| roturn |
Posted on 28-01-2011 11:21
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Just edited a team in DYN_Team.
All riders in DYN_Cyclist and in DYN_Contract_cyclists
In game I can see the team and riders but if I click a rider it crashes.
Also the country flag are pink, but this might be a local.cdb problem, will check it later.
Do I have to define the cyclists somewhere else or maybe not clicking them before 01/01?
Just checked: No double ID`s (Team, contract, cyclist)
Edited by roturn on 28-01-2011 11:48
|
| |
|
|
| CrueTrue |
Posted on 28-01-2011 12:09
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Well, try to wait and see if it also crashes after 1/1. |
| |
|
|
| roturn |
Posted on 28-01-2011 12:39
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Unfortunately still crashing in the new season. ;(
And it`s just the first of 8 teams.
Maybe someone can have a look on it.
It`s IdTeam11, Petrochemical Tabriz Cycling.
https://www.multiu...3KZ0QNXPU8 |
| |
|
|
| titleist82 |
Posted on 28-01-2011 13:27
|
Breakaway Specialist
Posts: 754
Joined: 03-04-2007
PCM$: 1060.00
|
there's no country with id 80 in sta_country table! |
| |
|
|
| roturn |
Posted on 28-01-2011 13:33
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Thanks. This is the problem.
Why did I start with that team... All other new teams are European. |
| |
|
|
| roturn |
Posted on 28-01-2011 14:41
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Almost finished now but got a new error.
For some reasons it worked with Tabriz... but not with the other teams now.
The XML start now with:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<NewDataSet xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance">
instead of
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
and they can`t be loaded in the editor. Is there a way to make this undo without doing everything again?
If someone can have a look on it?
https://www.multiu...NMPQ3DXRP9
Edited by roturn on 28-01-2011 14:56
|
| |
|
|
| Lachi |
Posted on 28-01-2011 15:10
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
roturn wrote:
I am more used into Lachi`s Editor, but the xml`s are also there, so I guess I can use them in Excel, too.
But the last line says "DUMMY - DO NOT EDIT OR DELETE THIS ROW"
Generally, you shouldn't use my editor to do edit the xml tables in Excel because I changed data types and added lines like the mentioned one. If it still works: You are lucky / If not: You have been warned.
roturn wrote:
The XML start now with:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<NewDataSet xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance">
instead of
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
You can just replace the text with the correct one. |
| |
|
|
| roturn |
Posted on 28-01-2011 15:15
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
I tried it with replacing but didn`t worked afterwards.
Obviously I was lucky the first time and unlucky the next times.
Will do it again with the Full Editor but unfortunately it took incredibly long to load my DB and crashes often. |
| |
|
|
| titleist82 |
Posted on 28-01-2011 16:28
|
Breakaway Specialist
Posts: 754
Joined: 03-04-2007
PCM$: 1060.00
|
i've managed to make the contract table work by replacing "FALSE" with "0" and TRUE with "1"
still working on the cyclists table... |
| |
|
|
| roturn |
Posted on 28-01-2011 16:39
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Wait. Thanks for all.
But just did it with Full Editor V4. And seems to work.
|
| |
|
