PCM.daily banner
22-12-2024 02:31
PCM.daily
Users Online
· Guests Online: 33

· Members Online: 0

· Total Members: 162,193
· Newest Member: bianka
View Thread
PCM.daily » Pro Cycling Manager 2022 » PCM 22: Database
 Print Thread
Any good excel editors around?
timpiej
I need to copy large data into my DB I need to be able to use excel.

I used to do this with the Excel Editor by Lachi but when I use it I get a notification about macros and when I enable them and click 'Extract CDB' nothing happens, none of the other buttons work either.

Does anyone know a better editor? A way to fix my problem? Or anything that doesn't make me enter data per data in the fast editor Pfft
 
Ulrich Ulriksen
The advanced editor (in the 2013 downloads section) creates XML files for every table.

So extract the DB in the advanced editor. Then go to the exports directory where you installed the editor. In that you will find an xml file for every table. You can open and edit those in excel and resave as an xml file in excel in the same place.

Then go back into the editor and compile the db.

Although excel editor should still work, you might check your security settings in excel, I think the default turns off all macros.
Man Game: McCormick Pro Cycling
 
timpiej
Ulrich Ulriksen wrote:
The advanced editor (in the 2013 downloads section) creates XML files for every table.

So extract the DB in the advanced editor. Then go to the exports directory where you installed the editor. In that you will find an xml file for every table. You can open and edit those in excel and resave as an xml file in excel in the same place.

Then go back into the editor and compile the db.

Although excel editor should still work, you might check your security settings in excel, I think the default turns off all macros.


Hey, cheers for the reply. I know about the advanced editor. The problem is I've run into problems with it because sometimes the format of the editor and the actual tables differ which results in either the advanced editor not being able to create the .cdb or creating a faulty DB.
The excel editor in that case has the advantage that you can extract the tables you want, copy/paste everything in it you want, create the DB and be done.
It used to work like a charm, I didn't change the excel version I'm working in, tried enabling macro's in the 'Trust Center' in excel and everything works but the buttons (extract cdb, open table, build cdb, clear all). And those are kind of the only buttons I need to have working in the exporter Grin
 
Ulrich Ulriksen
Sorry those didn't work. I have never had that issue with the advanced editor in 10 years of using it on 6 different versions. Don't typically edit save games so that might be why.

Only other thought I would have is to delete and redownload the excel editor, maybe your version has been corrupted.
Man Game: McCormick Pro Cycling
 
Ad Bot
Posted on 22-12-2024 02:31
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
timpiej
Ulrich Ulriksen wrote:
Sorry those didn't work. I have never had that issue with the advanced editor in 10 years of using it on 6 different versions. Don't typically edit save games so that might be why.

Only other thought I would have is to delete and redownload the excel editor, maybe your version has been corrupted.


I will see what gives once I actually do it, I'm still building my DB so the copy pasting data is only for when it's all done. Thanks for the help!
 
timpiej
Edit: double post
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Kilometre 0
Kilometre 0
PCM10: Official Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,676 PCM$
bullet df_Trek 17,674 PCM$
bullet Marcovdw 15,745 PCM$
bullet jseadog1 13,752 PCM$
bullet baseba... 10,539 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,990 PCM$
bullet df_Trek 15,820 PCM$
bullet Marcovdw 15,200 PCM$
bullet jseadog1 13,700 PCM$
bullet baseball... 7,432 PCM$

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