Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Unofficial EDBTR Database Editor Re-release

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's Eagle Day to Bombing the Reich >> Unofficial EDBTR Database Editor Re-release Page: [1] 2 3 4 5   next >   >>
Login
Message << Older Topic   Newer Topic >>
Unofficial EDBTR Database Editor Re-release - 10/7/2013 2:30:14 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
Unofficial EDBTR Database Editor Re-release

I have finally decided to re-upload the unofficial EDBTR database editor that was briefly released to a select few a couple of years ago. I am not the original creator of this editor (he wishes to remain anonymous), but I was a beta tester for it.


This editor makes possible to adjust the following things in the EDBTR database:

Aircraft: Name, type, bitmap, speed, altitude, climb rate, manueverability, durability, armour rating, endurance, maximum load, maintanence time, factory production requirements, factory production dates, Allied aircraft replacement rates, and weapon types.

Aircraft groups: Group name, aircraft used, number of aircraft, base location, headquarters, group commander, and group starting stats.

Locations: Type (factory, airbase, radar site, etc), headquarters, and location coordinates.

Pilots: Name, rank, experience, group, leadership, and delay factor.

Group leader pilots: Name, rank, experience, group, leadership, and delay factor.

Weapons: Name, type, capacity, range, effect, penetration, accuracy, and production.

Scenario editor: Start date, starting industry points, starting terror points, points needed to win, and aircraft in pool.

Sound effects: Sound played per sound effect.


----------------------------------------------------------------------------------------------

Installing and usage:

You must have Microsoft Excel and Visual Basic installed.

1. Back up ALL of your original .dat files located in your C:\Matrix Games\Gary Grigsby's Eagle Day to the Bombing of the Reich\DAT folder (or wherever you have the DAT folder installed).

2. Upon unzipping, place the EDBTR Editor v1.15.xls file into your C:\Matrix Games\Gary Grigsby's Eagle Day to the Bombing of the Reich\DAT folder (or wherever you have the DAT folder installed).

3. Open the file. You will see a row of tabs at the bottom. Make sure click the one that says 'aircraft'. Now at the top, you will see some tabs, such as load BoB 40. Click on one that you wish to mod. This will load it into the editor.

4. Go to the top of the page and look for the Excel 'Window' tab. Click on it, then click on 'Unfreeze Panes' tab. This will allow you to scroll through the editor now. You may need to do this for each editor tab you click.

5. To save your changes after modding is complete, you must be on the 'aircraft' page. Now click 'save BoB 40', or whichever .dat file you had loaded.

6. Now load you game and see if your mod works. Changes may not work properly on saved games. You will probably need to start a new game first.


If you are getting editor error messages, please try the following:

1. Open the command prompt. (Start Menu, Run, then type: cmd)

2. Type: cd\documents and settings

3. Press the Enter key

4. Now type: del /S /A:H /A:-H *.EXD

5. Press the Enter key


This database editor cannot modify any of the hard-coded core files. Therefore, some of the game's problems cannot be resolved with this editor alone. But it's better than nothing.

Please see the included readme file for installation and usage instructions.

Much thanks to the original creator of this great editor. Maybe now we can breath some life back into this abandoned and dying game by fixing certain problems. Mod away, and please share!


Unofficial EDBTR Editor v1.10c (works better with older versions of Microsoft Excel): http://www.filedropper.com/unofficialedbtreditorv110c

Unofficial EDBTR Database Editor v1.15: http://rapidshare.com/share/68456DA582B2CF5F578CBFF580850FCC

(thanks Creeper for providing the date bug fix in 1.15 version!)

< Message edited by K 19 -- 10/14/2013 2:08:13 AM >
Post #: 1
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 3:03:22 AM   
warshipbuilder


Posts: 1960
Joined: 2/23/2013
From: C-eh-n-eh-d-eh
Status: offline
DUDE! I think you may have just made a ton of new friends!!!!

_____________________________

warshipbuilder

Any ship can be a minesweeper, once.
ED/BTR Ressurection Project
https://www.bombercommandmuseumarchives.ca/

(in reply to K 19)
Post #: 2
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 4:09:11 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
We'll see...

Here's an EDBTR mod I made a few years ago, and decided to upload it again. Please check it out:

http://www.matrixgames.com/forums/tm.asp?m=3429813&mpage=1&key=�

< Message edited by K 19 -- 10/7/2013 4:10:04 AM >

(in reply to warshipbuilder)
Post #: 3
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 6:54:24 AM   
Turner


Posts: 299
Joined: 9/14/2010
From: Sweden
Status: offline
Nice, but the editor seems unable to load the files properly.

_____________________________

"There are no desperate situations, only desperate people." - Heinz Guderian

Trippin' with Jagdgeschwader 11

(in reply to K 19)
Post #: 4
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 6:56:26 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline

quote:

ORIGINAL: Turner

Nice, but the editor seems unable to load the files properly.


Works fine for me. Can you please tell me what the problem is?

(in reply to Turner)
Post #: 5
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 7:00:07 AM   
Turner


Posts: 299
Joined: 9/14/2010
From: Sweden
Status: offline
Clicking on 'load BTR 43' f ex give a error;


Runtime error nr '40036'.:

Program or objectdefined error.

_____________________________

"There are no desperate situations, only desperate people." - Heinz Guderian

Trippin' with Jagdgeschwader 11

(in reply to K 19)
Post #: 6
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 7:12:11 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
A few things to try:

- Be sure you have the latest version of .Net Framework installed

- Enable macros upon opening the editor



< Message edited by K 19 -- 10/7/2013 7:22:38 AM >

(in reply to Turner)
Post #: 7
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 8:22:43 AM   
Turner


Posts: 299
Joined: 9/14/2010
From: Sweden
Status: offline
Ok thanks will do when back home. Seems to be a great modding tool look forward to getting into it.

_____________________________

"There are no desperate situations, only desperate people." - Heinz Guderian

Trippin' with Jagdgeschwader 11

(in reply to K 19)
Post #: 8
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 9:15:01 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
I hope you can get it to work on your PC.

This editor is capable of fixing a lot of the game's shortcomings, including that overpowered Ta problem mentioned in the other thread.

(in reply to Turner)
Post #: 9
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 12:35:44 PM   
littleike

 

Posts: 159
Joined: 10/3/2007
Status: offline
Hi K 19

first many thanks for your effort to make this wonderful game live!

I tried to install the editor in the Dat directory and enable macro.
Module load and all sheets seems ok but i get an error when i select the missions tab.
The error is referred to this code statement

Dim sort As Boolean

The description of the error that i translate is this:

Compilation error
Member existing in a module from what object module derives

If i delete the statement all seem ok (but i don't know if this is correct or cause some other issue in another place).

A final question:

I tried to load BTR 43 and all is loaded correctly apart i cannot load any savegame (it seems the button does nothing)
Am i doing something wrong?
(Saves are in the BTR directory as usual).

Final: How we read the graphic about altitude performance? (What positive and negative scale signify?)

Again thanks for your wonderful work.

(in reply to K 19)
Post #: 10
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 3:03:25 PM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
quote:

ORIGINAL: littleike

Hi K 19

first many thanks for your effort to make this wonderful game live!

I tried to install the editor in the Dat directory and enable macro.
Module load and all sheets seems ok but i get an error when i select the missions tab.
The error is referred to this code statement

Dim sort As Boolean

The description of the error that i translate is this:

Compilation error
Member existing in a module from what object module derives

If i delete the statement all seem ok (but i don't know if this is correct or cause some other issue in another place).

A final question:

I tried to load BTR 43 and all is loaded correctly apart i cannot load any savegame (it seems the button does nothing)
Am i doing something wrong?
(Saves are in the BTR directory as usual).

Final: How we read the graphic about altitude performance? (What positive and negative scale signify?)

Again thanks for your wonderful work.


Hi. I'm sorry to hear you are having problems. Please remember that I'm not the original creator of this editor, but was a beta tester.

Both the Missions and Savegame tabs are not functional. I would strongly recommend against trying to use them. I know the original creator hadn't finished implementing all the features he wanted to before quitting work on it.

And for the aircraft performance chart, I believe that's another unfinished feature. Just remember this isn't an official editor, and it was never fully completed. Use this editor at your own risk. And remember to always back up your original files first!

< Message edited by K 19 -- 10/7/2013 4:13:37 PM >

(in reply to littleike)
Post #: 11
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 4:50:01 PM   
littleike

 

Posts: 159
Joined: 10/3/2007
Status: offline
Don't worry K 19.

I think you made a very special service to this community to resume this program also if it has some bugs.

I hope that some excel guru in this forum could be able to investigate and adopt this orfan child!

(in reply to K 19)
Post #: 12
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 4:50:56 PM   
Creeper

 

Posts: 177
Joined: 11/8/2008
From: Germany
Status: offline
Hi K 19,

thanks for sharing this excel tool and to remind me,
that i was a beta tester too, a few years ago.
Those were the days we all had the hope, that
Harley would provide us with new bug fixes for EDBTR!

@Turner: I get the same error message like you got when trying to load the dat files with V1.10c.
Nevertheless after looking in my old EDBTR directory I found a newer beta excel sheet
(V1.14 date: 02/01/2010) that seems to work without the error message.
Please try it and see if it's work for you, too.

V1.14 link removed, because of a serious bug!

New link: Editor V1.15

@littleike: In order to load a savegame file, you need an external program called 'btr_decode.exe', which decrypt the savegame file.
IIRC the author of the editor had to remove it, because there was the possibility to 'cheat' in a PBEM game.


< Message edited by Creeper -- 10/13/2013 10:14:54 PM >

(in reply to K 19)
Post #: 13
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 5:27:30 PM   
littleike

 

Posts: 159
Joined: 10/3/2007
Status: offline
Thank Creeper for your infrmation.

I made a few test:

- If i launch the editor and i try to load something in the initial mask i also receive the run time error.
- If i launch the program don't do nothing and only go through the tabs i can see all the displays but when i click on the mission tab i get the error i just described.
- if i delete the highlighted statement "Dim sort as boolean" in the mission tab and save the xls and then reload the program i get no more the run time error if i try to load something as before.

That's all i have seen.

@Creeper - i would like to test your 1.14 version but the link don't function for me!!!

< Message edited by littleike -- 10/7/2013 5:28:40 PM >

(in reply to Creeper)
Post #: 14
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 8:53:57 PM   
warshipbuilder


Posts: 1960
Joined: 2/23/2013
From: C-eh-n-eh-d-eh
Status: offline
I had no problem downloading 1.14. If anybody else has a problem, contact me and I will email it to you direct. It is 2.65MB, so it is not a huge file.

OK so now does anybody have that btr_decode.exe and would like to u/l it?

< Message edited by warshipbuilder -- 10/7/2013 8:59:46 PM >


_____________________________

warshipbuilder

Any ship can be a minesweeper, once.
ED/BTR Ressurection Project
https://www.bombercommandmuseumarchives.ca/

(in reply to littleike)
Post #: 15
RE: Unofficial EDBTR Editor Re-release - 10/7/2013 9:51:18 PM   
Turner


Posts: 299
Joined: 9/14/2010
From: Sweden
Status: offline

quote:

ORIGINAL: Creeper
@Turner: I get the same error message like you got when trying to load the dat files with V1.10c.
Nevertheless after looking in my old EDBTR directory I found a newer beta excel sheet
(V1.14 date: 02/01/2010) that seems to work without the error message.
Please try it and see if it's work for you, too.
Link: V1.14


That certainly did the trick! Good stuff, thanks!

_____________________________

"There are no desperate situations, only desperate people." - Heinz Guderian

Trippin' with Jagdgeschwader 11

(in reply to Creeper)
Post #: 16
RE: Unofficial EDBTR Editor Re-release - 10/8/2013 12:43:16 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
Hi Creeper. Long time no see! How have you been?

I didn't realize there was a v1.14 of this editor. I guess editor development went on longer than I thought! Anyway, I never get any error messages when using v1.10c, but v1.14 doesn't work at all for me. Lol. I have no idea why. Probably because I'm using an old Excel version. Hehe.

It's too bad what happened with the developers. We tried to keep the game alive by releasing an editor and mods, but they basically squashed any attempts. We were fixing game problems through the editor and releasing these fixes as mods. We were doing their job for them, and they didn't like it. So petty. Then after all that, they turn around and abandon the game. They basically killed the game. Lol. It figures.

< Message edited by K 19 -- 10/8/2013 3:01:06 AM >

(in reply to Creeper)
Post #: 17
RE: Unofficial EDBTR Database Editor Re-release - 10/8/2013 4:42:59 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
Everyone, there seems to be some compatibility issues running the editor on newer versions of Excel. The editor was created with Excel 2003, and many of the Visul Basic commands are no longer recognized by newer versions of Excel. So if you are getting error messages in the editor, try to get hold of an earlier version of Excel (2003 or earlier). This should solve your error problems.

(in reply to K 19)
Post #: 18
RE: Unofficial EDBTR Database Editor Re-release - 10/8/2013 7:49:38 AM   
JeffroK


Posts: 6391
Joined: 1/26/2005
Status: offline
Excellent, boy did they stuff up by not supporting this.

My only minor problem is that I dont have excel and use open office, any idea if it will still run???

_____________________________

Interdum feror cupidine partium magnarum Europae vincendarum

(in reply to K 19)
Post #: 19
RE: Unofficial EDBTR Database Editor Re-release - 10/8/2013 8:29:38 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
Hi. Honestly, I don't know about Open Office. But please give it a try and let us know if it works!

(in reply to JeffroK)
Post #: 20
RE: Unofficial EDBTR Editor Re-release - 10/8/2013 9:05:48 AM   
Creeper

 

Posts: 177
Joined: 11/8/2008
From: Germany
Status: offline

quote:

ORIGINAL: K 19

Hi Creeper. Long time no see! How have you been?

I didn't realize there was a v1.14 of this editor. I guess editor development went on longer than I thought! Anyway, I never get any error messages when using v1.10c, but v1.14 doesn't work at all for me. Lol. I have no idea why. Probably because I'm using an old Excel version. Hehe.



Hi K 19!
Yeah, it's 3 or 4 years ago that we last wrote each other.
Good to see you're back again!!

I have no clue what's the difference between V1.10c and V1.14
There is no changelog.
But if one of these versions is working so far, it doesn't matter.


(in reply to K 19)
Post #: 21
RE: Unofficial EDBTR Editor Re-release - 10/8/2013 9:09:08 AM   
Creeper

 

Posts: 177
Joined: 11/8/2008
From: Germany
Status: offline

quote:

ORIGINAL: littleike

I hope that some excel guru in this forum could be able to investigate and adopt this orfan child!



I hope it, too!!
Loading the dat files took over 10 minutes with my computer!
Saving the files is much faster, only 2-3 minutes.

This editor needs some speed fixes!


(in reply to littleike)
Post #: 22
RE: Unofficial EDBTR Editor Re-release - 10/8/2013 3:27:50 PM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
quote:

ORIGINAL: Creeper


quote:

ORIGINAL: K 19

Hi Creeper. Long time no see! How have you been?

I didn't realize there was a v1.14 of this editor. I guess editor development went on longer than I thought! Anyway, I never get any error messages when using v1.10c, but v1.14 doesn't work at all for me. Lol. I have no idea why. Probably because I'm using an old Excel version. Hehe.



Hi K 19!
Yeah, it's 3 or 4 years ago that we last wrote each other.
Good to see you're back again!!

I have no clue what's the difference between V1.10c and V1.14
There is no changelog.
But if one of these versions is working so far, it doesn't matter.



Yes, 3 or 4 years! Good to see you again too.

And I have no idea what the exact differences are between the two versions either. Lol. Maybe more labels were added designating certain previously unknown values? I know he was always updating the unknown values with labels in the editor once we figured out what they were through our testing. Plus I believe he was always trying to make the editor more stable.

I tried loading v1.14 with Excel 2010, but I couldn't get it to load properly. Error messages. Strangely, v1.10c loaded fine with no errors in Excel 2002... but wouldn't properly load v1.14. I kept getting Visual Basic errors (even though it's installed). Looks like I might have to revert back to V1.10c with Excel 2002.


< Message edited by K 19 -- 10/9/2013 3:36:35 AM >

(in reply to Creeper)
Post #: 23
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 12:28:38 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
Creeper, your PM inbox is full. I cannot message you.

(in reply to K 19)
Post #: 24
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 6:45:29 AM   
Creeper

 

Posts: 177
Joined: 11/8/2008
From: Germany
Status: offline
Ooops, now it is empty again..thanks!

(in reply to K 19)
Post #: 25
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 9:28:33 AM   
JeffroK


Posts: 6391
Joined: 1/26/2005
Status: offline
Using Open Office I can open the file and view data from probably the BOB41 files.

When I hit the load BTR43 button nothing changes and I cant see anything which implies its working??

PS I am a card carrying luddite so getting this far is amazing!

_____________________________

Interdum feror cupidine partium magnarum Europae vincendarum

(in reply to Creeper)
Post #: 26
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 9:43:59 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline
Not working. It should load upon clicking. Can you get hold of a copy of Excel?

(in reply to JeffroK)
Post #: 27
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 9:55:51 AM   
JeffroK


Posts: 6391
Joined: 1/26/2005
Status: offline
Costs money

I'll see if I can get my hands on a copy

_____________________________

Interdum feror cupidine partium magnarum Europae vincendarum

(in reply to K 19)
Post #: 28
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 10:02:26 AM   
K 19

 

Posts: 131
Joined: 9/25/2013
Status: offline

(in reply to JeffroK)
Post #: 29
RE: Unofficial EDBTR Editor Re-release - 10/9/2013 11:04:52 AM   
JeffroK


Posts: 6391
Joined: 1/26/2005
Status: offline
Found a copy compliments of some Govt Dept, best use of tax payer funds for years!

I had to load v14 as v10 was coming up with 40036 error.

Uploaded BTR43 with no problems.

Now to trash the stats!!!!!!!

_____________________________

Interdum feror cupidine partium magnarum Europae vincendarum

(in reply to K 19)
Post #: 30
Page:   [1] 2 3 4 5   next >   >>
All Forums >> [New Releases from Matrix Games] >> Gary Grigsby's Eagle Day to Bombing the Reich >> Unofficial EDBTR Database Editor Re-release Page: [1] 2 3 4 5   next >   >>
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

1.047