|
Lachi's Editor (Version 0.6, February 28)
|
| Lachi |
Posted on 31-07-2010 05:00
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I just uploaded a improved version: https://www.file-u...6.rar.html
IMPORTANT: You can use the column layouts from the previous version. They are saved in the folder GridLayouts.
Functions:
Quick access to the most important tables.
Automatic filter to see only data of your own team
Column header tooltip shows the full column name if it gets truncated because the column is too small.
Customizable Layouts: You can change the column order and column width. These settings will be saved and restored anytime you open the table again. Also there is a interface to move and resize the columns more easily.
Multiple sorting: Hold CTRL while clicking the column headers. The sorting will be in the order of the clicks. To change to sorting order of a column just click the header again.
Grouping of column values: For example you could group the cyclists by birth year. If you click on the thin line above the column headers you can drag the "button" of the desired column into the empty space.
Almost all tables are linked: Ex.: If you open STA_race you can see all linked stage in STA_stage. Also you cannot enter a number in fkIDrace in STA_stage which does not exist in STA_race.
Default values + Auto-generated Ids help you when adding new rows.
This editor uses the same extract, import functions as the Full Editor and therefore should be able to work with all Databases.
Warning: Do not overwrite your saves or DBs until this editor left the testing stage.
Feel free to suggest any further improvements.
Already requested and coming in a future version:
- Undo button: To revert the most recent change
- Table subsets: To display only a subset of the columns of one table
- Foreign key management: You don't have to search the ID in another table but can select it from a list
- Translated column headers: Example, in DYN_cyclist the column 'gene_sz_lastname' would read 'Last name'
(This feature is implemented but no columns have been translated, please contact me if you want to help translate them)
Edited by Lachi on 28-02-2011 20:49
|
| |
|
|
| CrueTrue |
Posted on 31-07-2010 12:33
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Good idea, Lachi. Very useful when you need to fix something in a save game.
I just tried importing a save game from the middle of the season, and it loaded just fine (and rather quickly).
My only suggestion so far is to rename it. Full / Fool Editor -- I see plenty of misunderstandings coming up. |
| |
|
|
| Lachi |
Posted on 31-07-2010 19:28
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I thought it would be funny to have a similar sounding name wich is written different but I already considered changing the name because it could create confusion. I just cannot think of a good name, i guess I have to call it Lachi-Editor or so.
Edit: I forgot some features:
- There is a grouping feature. If you click on the fine line above the column headers you can drag the "buttons" up into to empty space to group the data using that column. You can group multiple columns.
- You can sort multiple columns. Just Hold CTRL while clicking the column headers to add additional sorting. You can still alter the sorting direction by clicking the header a second time. To apply another sorting, just click a column without holding CTRL.
Also I could add the feature of then Hannes Converter where it is possible to only load selected tables to reduce the loading (and waiting time). Maybe I will add a "late load", which means the table are loaded when you open them for the first time. The table links cannot work in such a case (of course)
Edited by Lachi on 31-07-2010 19:36
|
| |
|
|
| Lachi |
Posted on 02-08-2010 00:13
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I just released a new version, see first post
@CrueTrue: If you upload it to your site please note that I changed the name.
Edited by Lachi on 02-08-2010 00:15
|
| |
|
|
| CrueTrue |
Posted on 02-08-2010 14:00
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
It's been a few years since I had lessons in German, but I'm quite sure that I know the meaning of:
"Datei existiert nicht auf unserem Server!"
 Can you reupload it? |
| |
|
|
| Ad Bot |
Posted on 22-11-2024 20:33
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Lachi |
Posted on 02-08-2010 14:02
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
xx
Edited by Lachi on 09-08-2010 23:38
|
| |
|
|
| Lachi |
Posted on 09-08-2010 23:39
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I just uploaded a new version, details see first post |
| |
|
|
| Bert Boor |
Posted on 10-08-2010 10:25
|
Amateur
Posts: 3
Joined: 10-08-2010
PCM$: 200.00
|
I cant find my saved files. They are not in the solo map. And when I use the editor from the game itself they are there |
| |
|
|
| roturn |
Posted on 10-08-2010 10:45
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
They must be there. Try to go to the right folder step by step.
MyDocuments->ProCyclingManager2010->Database->Solo->Databasefolder(can be named PCMDailyExpansion or different)->Your database
|
| |
|
|
| Bert Boor |
Posted on 10-08-2010 11:12
|
Amateur
Posts: 3
Joined: 10-08-2010
PCM$: 200.00
|
Thx, I was looking under program files. I found it.
I wanted to edit my teams balance and so I did. But as soon as started PCM again, it was not edited.
I did this under DYN_manager / fin_i_solde |
| |
|
|
| roturn |
Posted on 10-08-2010 11:15
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Did you click "Export to cdb" in the end and overwrote the old savegame? (make a backup before)
If you save somewhere else or call it different, you must choose the new one in the game. |
| |
|
|
| Bert Boor |
Posted on 10-08-2010 12:29
|
Amateur
Posts: 3
Joined: 10-08-2010
PCM$: 200.00
|
Now I did. Thx for your help  |
| |
|
|
| Snuble |
Posted on 10-08-2010 20:26
|
Free Agent
Posts: 119
Joined: 06-06-2008
PCM$: 200.00
|
Is it possible to change the date?
I managed to get the account overdrawn, and i didnt get edit the money untill desember 31st.
Now ive given me enough money to be above the negative limit, but even so i get fired because I apperantly still dont have enough money (which i do.. so the game just dont see it yet)..
How can i change the date to desember 30th?
They have this great beer here in England, I really love it. Its called Pint.
--Frank Strandli, Norwegian x-football player --
|
| |
|
|
| Lachi |
Posted on 10-08-2010 20:57
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Firstly, this thread is about my editor not how to edit the database.
Secondly, there are millions of threads about changing the date, so you could have found a solution easily by searching this forum.
But here is how to do it:
Look in GAM_config, there is a column called gene_i_date. You have to enter dates as UNIX timestamp. If you do not know how to convert a date into such a timestamp, google for it. |
| |
|
|
| Snuble |
Posted on 10-08-2010 21:21
|
Free Agent
Posts: 119
Joined: 06-06-2008
PCM$: 200.00
|
Lachi wrote:
Firstly, this thread is about my editor not how to edit the database.
Secondly, there are millions of threads about changing the date, so you could have found a solution easily by searching this forum.
But here is how to do it:
Look in GAM_config, there is a column called gene_i_date. You have to enter dates as UNIX timestamp. If you do not know how to convert a date into such a timestamp, google for it.
Hey.
Thanks. Ive actually searched around abit, but i couldnt find it in the millions of threads.
But now i found the "search" thing, which might have worked if i used it..lol.. soz for that, and thanx for the answer.
They have this great beer here in England, I really love it. Its called Pint.
--Frank Strandli, Norwegian x-football player --
|
| |
|
|
| Snuble |
Posted on 10-08-2010 21:36
|
Free Agent
Posts: 119
Joined: 06-06-2008
PCM$: 200.00
|
Lachi..
I am very sorry to disturb you yet again, and I understand that this thread is about your database (which i really like very much..thank you!!! ), and not about how to use it, but I gotta ask one last question as this is something ive never seen before.
Ive changed the time to desember 30th, but i still get the msg about failed season (ive won the cont.league, and 4 out of 6 objectives, so it has to do with the economy which ive now changed).
I tried to change the date to november 1st, but as soon as I try to go to NOvember 2nd, i get the same msg about loosing the team.
Is is possible to change this in you editor? and if it is, would you be a sport and help me out?
again.. sorry to disturb!
They have this great beer here in England, I really love it. Its called Pint.
--Frank Strandli, Norwegian x-football player --
|
| |
|
|
| LoStaffan |
Posted on 10-08-2010 22:04
|
Free Agent
Posts: 137
Joined: 25-06-2010
PCM$: 200.00
|
impressive pace of improvements ... really excellent work |
| |
|
|
| Lachi |
Posted on 11-08-2010 09:52
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Snuble: You do not disturb me. But if you ask the question in the wrong thread, you risk that it will not be seen by people who could answer your question.
I cannot solve your problem, because I just don't know how. If you do not find a solution by searching this forum, or you do not find a thread about similar stuff, you should start a new thread. |
| |
|
|
| facmanpob |
Posted on 11-08-2010 10:08
|
Domestique
Posts: 426
Joined: 29-07-2008
PCM$: 200.00
|
Just thought I'd say that, as usual, you've created a really user-friendly tool to help the community. Brilliant!  |
| |
|
|
| LoStaffan |
Posted on 11-08-2010 16:40
|
Free Agent
Posts: 137
Joined: 25-06-2010
PCM$: 200.00
|
think, i would love some "search function" too.
primarily meant as a table search function...  |
| |
|
