PCM.daily banner
24-05-2013 03:32
PCM.daily
Users Online
· Guests Online: 12

· Members Online: 0

· Total Members: 82,807
· Newest Member: zlev11
Advertisements
View Thread
PCM.daily :: Pro Cycling Manager 2012 :: PCM 12: Databases
 Print Thread
Lachis Editor v10 for PCM 2012 (July, 8)
Lachi
#1 Print Post
Posted on 30-06-2012 04:07
User Avatar

Grand Tour Specialist


Posts: 5169
Joined: 29.06.07
PCM$: 110.00

The previous version of my editor has problems reading the numbers in the table DYN_team_race in the PCM 2012 databases.
Although I am not sure if these values make any sense, I still updated my editor so that it can read and display all numbers correctly.

Also I added a feature to look up the values in the linked table, so instead of the numeric team Id you see the team name now. But it is possible to switch to the numbers.

Features:
- Faster then previous version
- Numbers are displayed nicer
- Look-up of linked tables (fkID...)
- Recognizes totally wrong numbers
- Possibility to only see data from own team
- Table layouts can be customized and saved
- Individual table layouts for each game version
- Works with all versions of the game (hopefully)
- Translated to 3 languages: English, German, Portuguese
- Partially translated to: French, Spanish
- Referential integrity for foreign keys (fkID...)
- Tables linked to parent table

WARNING: This version is considered a test version, so better don't overwrite your save, just in case.

To unpack this archive, you need a tool like 7-zip, which can be downloaded for free: http://www.7-zip....

To run this editor, you need to have Microsoft .Net Framework 3.5 SP1 installed.
Lachi attached the following file:
lachiseditor_v10p.7z
Edited by Lachi on 25-02-2013 15:50
 
jseadog1
#2 Print Post
Posted on 30-06-2012 04:22
User Avatar

Classics Specialist


Posts: 3408
Joined: 18.07.10
Location: Pennsylvania, United States
PCM$: 330.13

Thanks!

Jersey Galleries - (2012 - 2011) - Fantasy Stages

img14.picoodle.com/i5cv/jseadog1/hqj9_af5_ucfxs.png

img14.picoodle.com/i524/jseadog1/uuns_ac4_ucfxs.png
 
http://www.facebook.com/johnclark12
JohnWayn3
#3 Print Post
Posted on 30-06-2012 05:09
Amateur


Posts: 19
Joined: 23.06.12
PCM$: 110.00

Just tried editing my season 2 backup, and the race planner still works after editing Smile Thanks!!
 
Abelbaba
#4 Print Post
Posted on 30-06-2012 05:35
User Avatar

Neo-Pro


Posts: 329
Joined: 13.12.11
Location: Amsterdam, The Netherlands
PCM$: 390.00

are you updating your planner tool too?
 
lluuiiggii
#5 Print Post
Posted on 30-06-2012 05:38
User Avatar

Team Leader


Posts: 7098
Joined: 30.07.10
Location: Brazil
PCM$: 441.00

Abelbaba wrote:
are you updating your planner tool too?

Lachi wrote:
Thank you both.

Sadly Cyanide did change so much in their DB, that I cannot fix it easily.

Furthermore Cyanide removed some information from the DB, so even if I would update my planner, it would not be as useful as before. Not in the DB anymore: stage profile, type of race (TT, TTT, Normal).

Therefore I will not update my planner at the moment.


Good to see the editor converted to PCM12 Smile
pcmdaily.com/images/awards/2012/member.png

 
Abelbaba
#6 Print Post
Posted on 30-06-2012 05:51
User Avatar

Neo-Pro


Posts: 329
Joined: 13.12.11
Location: Amsterdam, The Netherlands
PCM$: 390.00

ah, thanks
 
kaktus412
#7 Print Post
Posted on 30-06-2012 17:28
Amateur


Posts: 9
Joined: 04.05.12
Location: Denmark
PCM$: 110.00

Thank you!!!!!! Work Perfecto! Banana
 
Dizzle
#8 Print Post
Posted on 04-07-2012 22:43
User Avatar

Neo-Pro


Posts: 340
Joined: 30.06.11
Location: Denmark
PCM$: 100.00

I receive an error when trying to edit coloums like dyn_sponsor and dyn_manager.
Here is the error report.
Spoiler:

i.imgur.com/L2fCE.png
 
Lachi
#9 Print Post
Posted on 05-07-2012 00:23
User Avatar

Grand Tour Specialist


Posts: 5169
Joined: 29.06.07
PCM$: 110.00

That is a bug in the datagrid I am using from an other software company.
It seems to only occur when you install a certain patch from Microsoft.
I don't plan upgrading to the latest version of the datagrid because I would have to reprogram certain stuff.

But I could make a version for you with limited functions, just to see if it works.
Download Editor for PCM2012 here / Download Season planner here
 
Dizzle
#10 Print Post
Posted on 05-07-2012 01:41
User Avatar

Neo-Pro


Posts: 340
Joined: 30.06.11
Location: Denmark
PCM$: 100.00

Lachi wrote:
That is a bug in the datagrid I am using from an other software company.
It seems to only occur when you install a certain patch from Microsoft.
I don't plan upgrading to the latest version of the datagrid because I would have to reprogram certain stuff.

But I could make a version for you with limited functions, just to see if it works.

Well, if you could, that would be great. I can't edit the latest sponsor names, since it won't let me edit anything in these two coloums. But it works fine for riders and contracts.
i.imgur.com/L2fCE.png
 
Lachi
#11 Print Post
Posted on 05-07-2012 12:49
User Avatar

Grand Tour Specialist


Posts: 5169
Joined: 29.06.07
PCM$: 110.00

@Dizzle: Try this version, maybe it helps. Like I said, this version wont wokr properly concerning the table layout but it should not have any influence on the editing itself.

@anybody else: No need to download this unless you have the same problem as Dizzle.
Edited by Lachi on 05-07-2012 15:41
 
Ad Bot
Posted on 24-05-2013 03:32
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
Dizzle
#12 Print Post
Posted on 05-07-2012 13:50
User Avatar

Neo-Pro


Posts: 340
Joined: 30.06.11
Location: Denmark
PCM$: 100.00

Lachi wrote:
@Dizzle: Try this version, maybe it helps. Like I said, this version wont wokr properly concerning the table layout but it should not have any influence on the editing itself.

Thanks, it worked for sponsor and manager, but the editor freezes when I try to open the team folder or cyclists folder.
i.imgur.com/L2fCE.png
 
Lachi
#13 Print Post
Posted on 05-07-2012 15:40
User Avatar

Grand Tour Specialist


Posts: 5169
Joined: 29.06.07
PCM$: 110.00

Sorry, then I am out of ideas.

You could try my excel editor in case you have excel.
(This "editor" basically is an easy way to open tables (folder in your words) in Excel.)
Download Editor for PCM2012 here / Download Season planner here
 
Lachi
#14 Print Post
Posted on 08-07-2012 06:25
User Avatar

Grand Tour Specialist


Posts: 5169
Joined: 29.06.07
PCM$: 110.00

New version released, see first post
Lachi attached the following image:


[309.23Kb]
Download Editor for PCM2012 here / Download Season planner here
 
Zitouni
#15 Print Post
Posted on 09-07-2012 12:24
Amateur


Posts: 8
Joined: 23.06.09
PCM$: 100.00

I receive en error when I extract the .cbd. It is a career in the beginning of 3rd season.
-> An error occured - Il existe un caractère non valide dans le codage donné. Ligne 481564 , position30
then a new one -> La référence d'objet n'est pas définir à une instance d'un objet.

I think you are french, if you're not, I can translate.

Intersted in my cdb to debug?

 
Lachi
#16 Print Post
Posted on 09-07-2012 12:39
User Avatar

Grand Tour Specialist


Posts: 5169
Joined: 29.06.07
PCM$: 110.00

I am not French but I can read it without problems.

As it says in the error message, there is a character in the database which is not valid when using XML files. Normally this is caused by letters like é if the database has not been created properly.

Was it possible to open the save in the previous seasons?
What DB are you using?

You can upload the DB but it is not a bug in my program but a problem with the data itself, therefore I don't need it for debugging. But I could try to find the wrong character if you want.


Download Editor for PCM2012 here / Download Season planner here
 
Zitouni
#17 Print Post
Posted on 09-07-2012 12:45
Amateur


Posts: 8
Joined: 23.06.09
PCM$: 100.00

It was the real name DB on pcm forum.
I tried only near the end of season2 and it did not work. But I can try to create a new career with this db and check if the problem comes form the origin db.


That would be great if we could identify the wrong character but I really don't know how to do that.
 
Zitouni
#18 Print Post
Posted on 09-07-2012 12:54
Amateur


Posts: 8
Joined: 23.06.09
PCM$: 100.00

Welll it works with the same db after creation of the career.
So either it happens with generation of new players or I with my managers name - I may have kept "Prénom" for the first name
 
Jona8366
#19 Print Post
Posted on 09-07-2012 13:11
User Avatar

Amateur


Posts: 10
Joined: 26.09.10
Location: Dybbøl, Denmark, Europe, World
PCM$: 100.00

I love this editor. Thanks lachi!
 
jamesnice
#20 Print Post
Posted on 09-07-2012 15:09
Amateur


Posts: 4
Joined: 09.07.12
PCM$: 100.00

Lachi, my riders are stuck on a stage. Which columns do I need to change? I tried changing the rider's status from STAGE to FREE but the riders still stay on their trainingscamp. Are there other columns I need to alter?
 

Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
Lachis Season Planner v27beta for PCM 2012 (September, 8) PCM 12: General 165 23-05-2013 21:17
Rafal Majka [2012] PCM 12: Stories 47 23-05-2013 19:37
Pcm Fast Editor PCM 12: Technical issues 3 23-05-2013 13:55
Dutch Eredivisie 2012-13 Football 359 21-05-2013 21:08
Problems with Lachi`s db editor in W8 PCM 12: Technical issues 2 19-05-2013 22:42
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Caravane Publicitaire
Caravane Publicitaire
Tour de France 2008
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet mbjerten 3,361 PCM$
bullet evilhumer 1,608 PCM$
bullet Kapparr 1,541 PCM$
bullet terradda 1,273 PCM$
bullet thore56 1,084 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
Render time: 0.27 seconds