|
Lachis Editor v10 for PCM 2012 (July, 8)
|
| colatryne |
Posted on 23-07-2012 13:45
|
Amateur
Posts: 3
Joined: 01-10-2008
PCM$: 200.00
|
Lachi wrote:
The editor automatically suggests the same folder as the original file. Are you sure that you edited the save or did you edit one of the backups in the weeklysave folder? It is not a big problem except that you will have to redo up to a week of gameplay if you edited the backup file.
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. |
| |
|
|
| Pierre-Rolland |
Posted on 23-07-2012 17:57
|
Free Agent
Posts: 124
Joined: 17-03-2009
PCM$: 200.00
|
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 
Edited by Pierre-Rolland on 23-07-2012 18:22
|
| |
|
|
| Lachi |
Posted on 23-07-2012 18:25
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
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.
Edited by Lachi on 23-07-2012 18:25
|
| |
|
|
| Pierre-Rolland |
Posted on 23-07-2012 18:56
|
Free Agent
Posts: 124
Joined: 17-03-2009
PCM$: 200.00
|
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. ^^
|
| |
|
|
| Lachi |
Posted on 23-07-2012 19:07
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Sorry but I cannot follow, there is no list in that table as far as I know. |
| |
|
|
| lluuiiggii |
Posted on 23-07-2012 19:47
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
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.
|
| |
|
|
| Ad Bot |
Posted on 21-11-2024 20:00
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Lachi |
Posted on 23-07-2012 19:58
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
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. |
| |
|
|
| Pierre-Rolland |
Posted on 23-07-2012 22:59
|
Free Agent
Posts: 124
Joined: 17-03-2009
PCM$: 200.00
|
Oh ok, shit, DYN_palmares is too big to find all mistakes...
|
| |
|
|
| lluuiiggii |
Posted on 23-07-2012 23:02
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
Pierre-Rolland wrote:
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)
|
| |
|
|
| Lachi |
Posted on 24-07-2012 01:26
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
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:
=VLOOKUP(B2;DYN_palmares_cyclist!A:C;2;FALSE)
Lachi attached the following image:
Edited by Lachi on 24-07-2012 01:29
|
| |
|
|
| vocalds |
Posted on 24-07-2012 13:56
|
Junior Rider
Posts: 25
Joined: 07-08-2011
PCM$: 200.00
|
This is probably a stupid question, but is it possible to edit finances etc. when you have started your career? |
| |
|
|
| Pierre-Rolland |
Posted on 25-07-2012 02:46
|
Free Agent
Posts: 124
Joined: 17-03-2009
PCM$: 200.00
|
Thanks for your help guys 
|
| |
|
|
| Lachi |
Posted on 25-07-2012 09:02
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
vocalds wrote:
This is probably a stupid question, but is it possible to edit finances etc. when you have started your career? 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. |
| |
|
|
| Whomario |
Posted on 26-07-2012 20:21
|
Free Agent
Posts: 134
Joined: 25-07-2009
PCM$: 200.00
|
Lachi wrote:
vocalds wrote:
This is probably a stupid question, but is it possible to edit finances etc. when you have started your career? 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 :
----An error occured----
Ein Aufrufziel hat einen Ausnahmefehler verursacht.
----Inner error----
Das Element wurde bereits hinzugefügt. Schlüssel im Wörterbuch: "Infragistics.Windows.Automation.Peers.DataPresenter.CellAutomationPeer". Hinzuzufügender Schlüssel: "Infragistics.Windows.Automation.Peers.DataPresenter.CellAutomationPeer".
----Stacktrace----
bei System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
bei System.Windows.Automation.Peers.AutomationPeer.UpdateChildren()
bei System.Windows.Automation.Peers.AutomationPeer.UpdateSubtree()
any ideas ? Am operating on Windows 7. |
| |
|
|
| Lachi |
Posted on 26-07-2012 21:39
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
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. |
| |
|
|
| chrisw_bwfc |
Posted on 27-07-2012 19:38
|
Junior Rider
Posts: 36
Joined: 22-07-2012
PCM$: 200.00
|
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!
Edited by chrisw_bwfc on 27-07-2012 19:39
|
| |
|
|
| CrueTrue |
Posted on 28-07-2012 00:11
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
The startlist feature was re-added in the latest patch. Use that method instead - that's more likely to work |
| |
|
|
| helloandgoodbye |
Posted on 31-07-2012 18:39
|
Amateur
Posts: 2
Joined: 31-07-2012
PCM$: 200.00
|
how do you set it up |
| |
|
|
| helloandgoodbye |
Posted on 31-07-2012 19:24
|
Amateur
Posts: 2
Joined: 31-07-2012
PCM$: 200.00
|
could someone please do a step by step guide
because the Microsoft .Net Framework 3.5 SP1 will not install
Edited by helloandgoodbye on 31-07-2012 19:51
|
| |
|
|
| Lachi |
Posted on 01-08-2012 16:59
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
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. |
| |
|
