|
Excel Editor (Version 5, July 1st)
|
| Lachi |
Posted on 28-06-2011 22:33
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I made a new "editor".
You can use it to extract the DB into excel.
This is a very basic tool but it should be faster than the full editor.
You can select which tables to open in excel because it can take quite some time to import bigger tables into an excel sheet.
Also you can select which tables you want to export back to the database.
I only tested it with Excel 2010. It should work with Excel 2007 for sure and maybe even with Excel 2003. It does not work with earlier versions due to missing XML functionality.
Version 5 allows to open additional tables at any time once you extracted the database.
Lachi attached the following file:
Edited by Lachi on 01-07-2011 22:36
|
| |
|
|
| CrueTrue |
Posted on 28-06-2011 22:52
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
I get a "Path not found" error in Excel 2007.
Debugging highlights a "ChDir strPath" in modCDB. |
| |
|
|
| Ad Bot |
Posted on 23-11-2024 16:06
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| roturn |
Posted on 28-06-2011 22:57
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Same here with Excel 2007. |
| |
|
|
| Lachi |
Posted on 29-06-2011 22:08
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I uploaded another version, please try again.
|
| |
|
|
| CrueTrue |
Posted on 29-06-2011 22:09
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Same problem as before. |
| |
|
|
| Lachi |
Posted on 29-06-2011 22:20
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
Did you extract all three files from the RAR into the same folder? |
| |
|
|
| roturn |
Posted on 29-06-2011 22:28
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Still the problem. Exactly the one CT described above.
All 3 files are in the same folder. |
| |
|
|
| Lachi |
Posted on 29-06-2011 22:41
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
What does happen after you clicked the button and selected the cdb?
Do you see a window like the one on the attached picture?
If yes, is there a folder called Data which contains another folder with the xml files?
BTW: I uploaded another version, please try that if you can answer both questions with yes.
Lachi attached the following image:
Edited by Lachi on 29-06-2011 22:47
|
| |
|
|
| roturn |
Posted on 29-06-2011 22:53
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
No, it immediately says path not found and then the window with the debugging and help buttons.
Clicking on debugging will open some files with the "ChDir strPath" being marked yellow. |
| |
|
|
| Lachi |
Posted on 29-06-2011 23:13
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
OK, I think I found the error. Try version 4 please. |
| |
|
|
| roturn |
Posted on 29-06-2011 23:16
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
It`s working now I think and looks pretty good. |
| |
|
|
| Pierre-Rolland |
Posted on 30-06-2011 00:35
|
Free Agent
Posts: 124
Joined: 17-03-2009
PCM$: 200.00
|
It's strange, Every time I need open another table, I need to extract again a DB and open the table....
|
| |
|
|
| Lachi |
Posted on 30-06-2011 15:35
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
No, you don't have to:
1. Select the DB
2.a Select all tables you want to open (use CTRL to select multiple tables)
2.b Select no tables and click Cancel instead. This will open all tables.
3. Select the sheet of the table you want to edit
But I will add another button to select a table without extracting again in version 5. |
| |
|
|
| titleist82 |
Posted on 30-06-2011 15:48
|
Breakaway Specialist
Posts: 754
Joined: 03-04-2007
PCM$: 1060.00
|
v04 works fine for me (office 2003)
nice job! |
| |
|
|
| pjstvv |
Posted on 06-07-2011 00:36
|
Amateur
Posts: 10
Joined: 03-03-2009
PCM$: 200.00
|
How do you read .cdb file? I can't manage to do that... |
| |
|
|
| Lachi |
Posted on 06-07-2011 00:52
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
There are 4 buttons in the excel file.
None of them is labeled "read .cdb file".
First button "Extract CDB":
You have to select a database file or a save, then wait until the tables have been extracted.
(Now you have to select the tables, see next button. Or you click on CANCEL to open all)
Second button "Open table"
You have to select the table(s) you want to open, then wait until the selected tables have been imported into excel.
Third button "Build CDB"
Does the opposite as the first button
Fourth button "Clear all"
Never click this button unless you know what you are doing. You have been warned.
So what exactly is your question?
Also I am really wondering why you would want to use this tool as it is the "worst" editor for people without a clue. Excel is excellent for mass changes but it has none of the good features of the Fast Editor or my editor.
Edited by Lachi on 06-07-2011 00:57
|
| |
|
|
| cunego59 |
Posted on 09-09-2011 18:06
|
Team Manager
Posts: 6508
Joined: 14-09-2008
PCM$: 1090.00
|
Just a quick question? Is there any way to make this editor work with Open Office? Because although I activate Macros, nothing happens when I click the Extract CDB button.
|
| |
|
|
| Lachi |
Posted on 09-09-2011 18:17
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
I don't have OO but I was told that it works well. Maybe download the latest version of OO if you don't have it already.
BTW: Did you extract all the files into a folder? |
| |
|
|
| cunego59 |
Posted on 09-09-2011 18:22
|
Team Manager
Posts: 6508
Joined: 14-09-2008
PCM$: 1090.00
|
I will try it with the newest version. Yes, all three files are in one folder. I guess I don't need to put the savegame I want to edit in any specific place?
|
| |
|
|
| Lachi |
Posted on 09-09-2011 18:42
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
No, you don't have to move the save game.
|
| |
|
