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
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.
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
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.
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!
