PCM.daily banner
21-09-2020 13:10
PCM.daily
Users Online
· Guests Online: 26

· Members Online: 1
ivaneurope

· Total Members: 144,233
· Newest Member: NitroKuite
Donate
View Thread
PCM.daily » Pro Cycling Manager 2013 » PCM 13: Technical issues
 Print Thread
Exporting modded .cdb, errors in Excel editor
ShortsNL
Hey guys,

I need help getting my modded PCMDaily DB to work.

Basically, what I did was this:

-Take the PCMDaily2013DB for PCM13
-Update the starting year to 2017
-Changed some minor things like reputation levels of sponsors

I recreated a DB for that and it worked so far. I called it Test.cdb. You can find it here: https://sdrv.ms/19...

Next, I got the DYN_cyclist and DYN_Team tables from my PCM11 Save, and tried to mod them accordingly, to make them work in my PCM13 game. I removed the columns from my PCM11 save that are no longer in PCM13, and emptied out others to make it look like a starting .cdb for PCM13. You can find the modded tables here: https://sdrv.ms/Js...

Finally, I tried to put them into my PCM13 start .cdb, by pasting the new tables over in Excel Editor, replacing the old ones. However, when I then try to build the .cdb, it gives an error on both DYN_cyclist and DYN_team. You can see how I did it and try it here: https://sdrv.ms/1h...

I want to find out what's causing the error so I can fix it. My question is:
-Can someone explain to me how I can find what's causing it?
-Or can someone find the error so I can fix it?

Thanks in advance!
 
Lachi
What error do you get? I am on vacation, so I cannot try to build the cdb.
 
Ad Bot
Posted on 21-09-2020 13:10
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
ShortsNL
I simply get this:

https://s22.postim.../excel.jpg

Same for DYN_team.

If it would give me more information, I would know where to look, but right now I have no idea what's causing the error.
 
Lachi
This error means, that Excel cannot create the XML file, so there must be something wrong with the data. Make sure that there are no empty rows or columns. Also make sure that you did not delete any columns by mistake. Finally it is important that the data type of one column is correct across all rows (You cannot enter text if the column should contain numbers, list of numbers have to complete: opening braket, number, semicolon, number (and so on), closing braket)
Edited by Lachi on 29-12-2013 18:25
 
ShortsNL
Thanks man.

So does that meat it has to be the format or the syntax?

I'm asking this because I basically imported my entire rider and team list across, and edited things quite a bit, because I had to make new teams (copied over from the original 2013 DB), assign riders to them, and link the teams to PCM13 sponsors. Could the error also be because I linked something in a wrong way? Like for example a rider assigned to a non-existent team or some other non-existent value?

Edit:

Another example: Since I ported all the riders over from my PCM11 save, there were riders that are not with a picture in the PCMDailyDB for PMC13, because they retired in real life.

However, these riders do still have a picture in PCM11, and coming from there, they still have a value in gene_sz_tga_photo, even though in PCM13 there is no picture for them. Could things like these be a cause?
Edited by ShortsNL on 28-12-2013 00:23
 
CrueTrue
No, the editor doesn't check for links, double ID's or anything. The only thing that matters is that the type of data is correct. For example, the editor can expect a number, letters or (numbers) or something else. If this is incorrect, it can crash/not export.
 
http://www.pcmdaily.com
Lachi
I now tried to test your excel "test new.xlsm" but you messed up somehow.
I am not sure what you did but as I said before, Microsoft Excel cannot export the data of the sheets DYN_cyclist and DYN_team to XML.

You might be able to fix it by re-linking the columns of these sheets to the XML source as follows:
1.Open the Excel file
2.Open the XML Source task pane
(Read "Using the XML Source task pane" in the link below /
Ask google if you don't see the Developer tab in your Excel)
3.Select DYN_cyclist
4.Navigate to the sheet DYN_cyclist
5.Link all columns in that sheet to the source by:
5.a)Selecting the column
5.b)Double clicking the matching name in the source
6.Verify whether you can export the data through the mapped XML *
(as explained in "Using the XML Source task pane")
7.Repeat steps 3 to 6 for DYN_team
* In case the data is not exportable, read what I and CrueTrue wrote

More info about about XML in Excel can be found here: https://office.mic...06396.aspx
 
ShortsNL
Lachi, you are the greatest.

It just worked. I couldn't get round to doing it, and just did it. It worked straightaway. I booted up the CDB and everything looks like I wanted it to. I can't believe I just successfully ported my carreer from PCM11 to PCM13 Grin

Thanks so much man. I don't think anyone else could have helped me like you did, and you did it. Your knowledge once again astounds me man. You've got my vote for most helpful forum member next year.

Please, stay supporting the community with your editors, planners and technical support. I can't tell you how much you're helped me over the years, with all these things. And once again, you pull through for me.

Amazing man, just amazing. Thanks so much.
 
Lachi
You're welcome.

Enjoy your career.
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
Lachi Editor -> Edit something special PCM 19: General 8 17-09-2020 10:42
Database editor not working PCM 20: Technical issues 3 23-08-2020 17:00
SaveGame Editor PCM 20: Technical issues 7 20-08-2020 11:42
Lachis Editor v34 for PCM 2019 (August, 1st) PCM 19: General 18 30-07-2020 19:13
Database-Editor for PCM 2020, where is Lachi PCM 20: General 11 30-07-2020 12:41
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Mountain terrain
Mountain terrain
PCM13: Official Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet dominox 3,709 PCM$
bullet jseadog1 3,600 PCM$
bullet baseba... 3,302 PCM$
bullet df_Trek 3,206 PCM$
bullet Yellow... 3,180 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet baseball... 16,456 PCM$
bullet jseadog1 15,955 PCM$
bullet Marcovdw 14,593 PCM$
bullet dominox 12,945 PCM$
bullet fintas 11,525 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 2.35 seconds