I see. Yes, i first edited a copy of the weeklysave. And placed the new file in the same folder. But it works now, as i know this was not the right folder.

Hello lachi, nice tool.

I wanted to know if for a next version, we will be able to see name of values instead ID's for collumn with parentheses ()
like in STA_race gene_i_list_team or in STA_type_leader_specialisation.

Oh and last thing, in DYN_palmares, it will be nice to can see the rider name in "ID palmares_cyclist" if you can do that it will be very great.

Good job

No. I think that would be useless because the column would have to be extremely wide. Also it wouldn't be possible to edit these columns any longer.

Furthermore I am only interested in programming generic solutions and I am pretty sure that would be a performance killer if the tool would have to look up every number whenever you scroll the list.

But I was thinking about a way to edit the numbers using a drop down list.

Ok thanks for the answer, you're right.

But if you just do the feature for palmares_cyclist it will be so usefull for DB maker who must do a big work in palmares. ^^

Sorry but I cannot follow, there is no list in that table as far as I know.

I guess he's talking about, instead of showing the IDs in fkIDpalmares_cyclist in DYN_palmares, show directly the cyclist name (gene_sz_full_name) from DYN_palmares_cyclist.

My editor is designed to show gene_sz_full_name instead of the ID.

But if there are errors in the table it cannot work because the editor tries to resolve all IDs in the fkID column.
If an ID cannot be resolved, then the tables cannot be linked and this makes it impossible to show the linked values from the other table. (obviously)

So basically don't write crap into these columns and it will work.

Oh ok, shit, DYN_palmares is too big to find all mistakes...

If by "mistakes" you mean un-matching IDs, etc, the Fast Editor "Clean Up" function does a good job in showing them (even if we're not sure whether it's 100% compatible with PCM12 atm)

In fact it is rather easy to find unmatching IDs.
Take my excel editor and open both tables.
Then sort DYN_palmares_cyclist by ID.
Now add a column next to fkIDpalmares_cyclist on the sheet DYN_palmares.
In the topmost field of the newly created column you enter a formula to lookup the names (see Formula below).
Now you only have to use the filter to find the errors (see image).

You could delete the rows with the errors, then delete the added column and finally create another DB which should work in my other editor.

Formula:

This is probably a stupid question, but is it possible to edit finances etc. when you have started your career?

Thanks for your help guys

I am pretty sure that I answered this in another thread. Yes you can. Bank account would be in DYN_manager. Then there are the sponsors in DYN_sponsor and the contracts in DYN_contract_cyclist.

where are theese located ?

Can´t get your editor to work unfortunately. Can you post a step-by-step guide maybe ?

I click on extract cdb and when i go to cyclist or team i see the tables but as soon as i click anywhere, it crashes :



any ideas ? Am operating on Windows 7.

That error only occurs when you install a certain patch from Microsoft. I cannot help you there. Use another editor.

About your first question. What do you mean with where? The tables are in the database. A table has columns. Look at the column headers or the content to find out what it contains.

Not sure if this is the best place to post the following, but got a query which I guess may be related to this editor.

I've edited the teams (rosters) within the DB_Nationi database so that each team just includes the riders who will be taking part in the Olympic Road Race tomorrow. This worked fine, but caused a couple of issues:

1) I cannot control a race with teams such as Slovakia who only have 1 rider (Sagan)...the game only gives the 'Quick Simulation' option in both stage and classic modes.

2) Even more annoyingly, I can set up a custom list of teams to start the race, choose my team and have all my riders start, only to find that the AI of Germany for example has chosen to leave out Greipel The whole reason I cut down the team rosters was to avoid this...I thought that the AI would be forced to pick its entire team...

anything I can edit in DB / any help much appreciated, thanks!

The startlist feature was re-added in the latest patch. Use that method instead - that's more likely to work

how do you set it up

could someone please do a step by step guide
because the Microsoft .Net Framework 3.5 SP1 will not install

Sorry I cannot follow. If you have problems installing .NET Framework, then please contact Microsoft support.
Or are you stuck extracting my tool. You need a tool like 7-zip to extract the files from the archive you just downloaded.