Database dump

[michaelm75au]

Hi
I got tired of swapping back and forth between the database screens while trying to find some info in the scenario database. So knocked up a quick tool on the weekend to dump the individual databases to a CSV file.
It still is in progress but someone may find the output useful ,especially if you load it up into Excel/Access and cross reference the data. Just skimming the the output some of the figures seem to have been incorrectly entered( eg a naval gun (dev# 7) has a load cost of 9999 but a like gun (dev#8) has a cost of only 9).
============================================
23/08/2004
I have completed my new database export program (witpload v1.7).
The zip file is attached.

Don't forget to rename the extension to .zip after downloading the file.


Michael

[Mr.Frag]

has a load cost of 9999 but a like gun (dev#8) has a cost of only 9).

Don't assume incorrect ... 9999 has a meaning. [;)]

[michaelm75au]

I mean the cost of 9 (for 5.5in/50 3YT) seems incorrect. The similiar gun (5.5in/40 QF) has 9999 (which means it is static).

[michaelm75au]

I have completed my WITP dump utility.Only data that is shown in the Editor is dumped and I have randomly checked most of the data.
The output is raw, but used with a spreadsheet or database I have found it useful. It is better than trying to trace things through multiple screens of the Editor. It is most useful in seeing who has what devices assigned to them.
The reason I have done this is to help with user-built scenarios. NOT to complain about discrepancies with items within the database. Looking at the dump may help others answer their own questions on TOEs and "who is on which base" and where are all the supplies at the start of the scenario.
I am sure that this is not the correct way, but I have attached the small utility to dump the scenario files. Detach the file and rename the extension to .exe.

The program is run as "witpdump.exe /s#", where # is the scenario number. The WP scenario files are assumed to be in the current directory and the CSV files are also created here, eg. witpdump /s15 will dump the files for scenario #15.

Enjoy.
[:o]
Some of you have had problem with the utility crashing at the end. I have found what could be causing this and have re-compiled the code (version 1.3). Sorry about that.
I run the dump on all the scenario file about 30 times in a row, without any errors being detected.

v1.4 Ship class extract only was doing first 999 items. Corrected to do all 1999.

I have updated the attachement.
Don't forget to rename the extension to .exe after downloading the file.

[Apollo11]

Hi all,

ORIGINAL: michaelm

I have completed my WITP dump utility.Only data that is shown in the Editor is dumped and I have randomly checked most of the data.
The output is raw, but used with a spreadsheet or database I have found it useful. It is better than trying to trace things through multiple screens of the Editor. It is most useful in seeing who has what devices assigned to them.
The reason I have done this is to help with user-built scenarios. NOT to complain about discrepancies with items within the database. Looking at the dump may help others answer their own questions on TOEs and "who is on which base" and where are all the supplies at the start of the scenario.
I am sure that this is not the correct way, but I have attached the small utility to dump the scenario files. Detach the file and rename the extension to .exe.

The program is run as "witpdump.exe /s#", where # is the scenario number. The WP scenario files are assumed to be in the current directory and the CSV files are also created here, eg. witpdump /s15 will dump the files for scenario #15.

Enjoy.

Thanks!!!


Leo "Apollo11"

[Apollo11]

Hi all,

ORIGINAL: michaelm

I have completed my WITP dump utility.Only data that is shown in the Editor is dumped and I have randomly checked most of the data.
The output is raw, but used with a spreadsheet or database I have found it useful. It is better than trying to trace things through multiple screens of the Editor. It is most useful in seeing who has what devices assigned to them.
The reason I have done this is to help with user-built scenarios. NOT to complain about discrepancies with items within the database. Looking at the dump may help others answer their own questions on TOEs and "who is on which base" and where are all the supplies at the start of the scenario.
I am sure that this is not the correct way, but I have attached the small utility to dump the scenario files. Detach the file and rename the extension to .exe.

The program is run as "witpdump.exe /s#", where # is the scenario number. The WP scenario files are assumed to be in the current directory and the CSV files are also created here, eg. witpdump /s15 will dump the files for scenario #15.

Enjoy.

I tried using your "WitPDump" program and it did crate the CSV files but it ended with crash (I think it created all files and that crash was just on end before exit).

I am attaching the screenshot of error (crash) message...


BTW, have you, perhaps, compared dump results from your WitPDump and CSV file other people posted (like "Oznoyng")?

http://www.matrixgames.com/default.asp? ... m%3D687862


Leo "Apollo11"

[tanjman]

michaelm,

Great utility, I just used it on scenario 4 and imported all of the csv files into Quatro Pro with no problems. Thank you for your excellent work [&o] its going to make creating scenarios much easier.

[Apollo11]

Hi all,

One other thing just come to my mind...


Do you think you can reverse the process of "WitPDump" and using CSV files create back the WitP database files?


That way we can, for example, add 9999 delay to units (land units, ships, TFs) to whatever scenario we want!


Leo "Apollo11"

[Herrbear]

All I get when I try to download the file is a file called witpdump.txt.

Am I doing something wrong?

[tanjman]

Herrbear,

When you download the witpdump.txt save it as witpdump.exe. It worked for me, used it less than a hour ago to dump scenario 4.

ORIGINAL: Herrbear

All I get when I try to download the file is a file called witpdump.txt.

Am I doing something wrong?

[Apollo11]

Hi all,

ORIGINAL: tanjman

It worked for me, used it less than a hour ago to dump scenario 4.

Did you get the error message at the end of run like I did (please see pictures above)?


Leo "Apollo11"

[tanjman]

Leo,

I ran it it from the dos prompt (Windows XP) got the error message report option which I clicked do not send. Other than that it worked fine. How did you run it. BTW I copied the scenario files to another folder to run wiptdump from, just incase something went wrong.

ORIGINAL: Apollo11

Hi all,

ORIGINAL: tanjman

It worked for me, used it less than a hour ago to dump scenario 4.

Did you get the error message at the end of run like I did (please see pictures above)?


Leo "Apollo11"

[Apollo11]

Hi all,

ORIGINAL: tanjman

I ran it it from the dos prompt (Windows XP) got the error message report option which I clicked do not send. Other than that it worked fine. How did you run it. BTW I copied the scenario files to another folder to run wiptdump from, just incase something went wrong.

Then it is the same for you and me.

I think program does all it should do and only terminates abnormaly.


BTW I tried running it from "Command Prompt" ("DOS-like" window inside WinXP) and directly from windows (I use "Total Commander" and can run commands directly) - I also tried running in main scenery folder and in temp folder but it was all the same.


Leo "Apollo11"

[michaelm75au]

I must admit I only compiled and ran this on my WIN98 machine.

It did once abnormally terminate on me ,even made my video go crazy but I could not reproduce it [ sounds a bit like WITP]. It could even e the complier I am using.

As far as I could tell it still produced the files. I will be having a look later to see why it should be doing this. I also noticed a couple of spelling errors in the reference table file which I will also fix up.

I can fix the crash I may drop the utility off at Spooky's fansite.
Sorry for any inconvience.

Michael

[Apollo11]

Hi all,

ORIGINAL: michaelm

I must admit I only compiled and ran this on my WIN98 machine.

That must be it then... Win98 compared to Win2k/WinXP machines...

It did once abnormally terminate on me ,even made my video go crazy but I could not reproduce it [ sounds a bit like WITP]. It could even e the complier I am using.

As far as I could tell it still produced the files. I will be having a look later to see why it should be doing this.

I also think that it is only abnormal termination of program and that your utility does all work as it should be (i.e. dumps out the all data into CSV files).

I also noticed a couple of spelling errors in the reference table file which I will also fix up.

I can fix the crash I may drop the utility off at Spooky's fansite.

Did you see Michael Wodd's reference info about database contents (i.e. types of variables he used):

http://www.matrixgames.com/default.asp? ... m%3D687911

Please check this to have 100% acuracy!!!

Sorry for any inconvience.

No problem at all... this is just very very small inconviniece.

Thanks again for your program!


Leo "Apollo11"

[carnifex]

attachment missing

[Apollo11]

Hi all,

ORIGINAL: carnifex

attachment missing

Yes... attachment Michael originally posted is missing because new and exciting things are comming soon... Michael will be posting it... [:)]


Leo "Apollo11"