Matrix Games Forums

I wrote a small cmd-script that copies the CSV files WitpStaff generates and adds labels to the top of the new files.

You have to save it to your harddisk and then edit the first three set commands in the file with the text editor of your choice. Then simply start it.

I hope I made no errors.

You can get it here

I didn't see anything about my error message (or any similar to it).

I initialized the db and loaded 6 days, one at a time, into the db. When I tried to load the next day, I got an error that LCUsMarchOnlyToExistingBases table...

Not sure how to debug this problem. Don't know why Staff failed. Any help would be appreciated. I've been trying to sort out "the Staff" for over a week now and do need the help to manage the Empire.

Running WinXP Svc Pack 2, I believe.

Peace,
Doc

ORIGINAL: doc smith

I didn't see anything about my error message (or any similar to it).

I initialized the db and loaded 6 days, one at a time, into the db. When I tried to load the next day, I got an error that LCUsMarchOnlyToExistingBases table...

There are a couple of us who have reported this, but I know as the threads get longer it gets progressively more difficult to find anything...

At least in the reported cases, it seems to be associated with an LCU that was in Reserve during combat and is now in pursuit. The witpstaff author (Woos) has a fix in mind for the next version (No, I have no idea when that is).

A workaround is to go to the unit in question, and set it to move to a base. Save the file with this change (under a new number, of course, so you don't overwrite your "real" file). In my experience, this new file can then be read.

I'm on 12-19 in a PBEM, and the "5d AvgGain" column is still blank on my Logistics/storage tab.  Shouldn't I have something?

As a guess, I am playing 2 day turns.  Any chance it's looking back 5 days and not finding something exactly 5 days prior?

I have one suggestion:

On the WitpStaff aircraft tab, I think it would be useful to add a column for the engines types used by the aircraft.
I know I can find this info in game, but I prefer to use your excel-type format for comparing aircraft when doing AC production planning.

Great tool thanks for all the hard work on it.

New version 0.7a to try. Solves some of the problems (most importantly the LCUsMarchOnlyToExistingBases one) and adds a few new features such as

* Engines and ServiceRatings for planes
* Conversions and rearm costs for Ships
* A new "Bases" map-overview showing where your factories are and at which bases surplus/lack of resources exists (makes it easier to target the correct harbors).
* Individual(!) Dumps to CSV (not the DumpAll dump) now have labels! (After lots of fighting with java.nio). Plus a "Current OOB" dump.

Not in yet: Changing the 5d overview to 6 days so that it works also in 2 and 3 day turn games (sorry, erstad, forgot it and now don't want to boot back into Linux).

Just unzip and overwrite the existing witpDecoder2.jar with it. Since I don't know exactly anymore what I agreed with Matrixgames 1 1/2 years or so ago concerning releases it is not going to be mentioned in the first post. Gives some advantage to people actually reading the thread

Oh, and
a) Database format has changed! You have to delete your database to use it.
b) Absolutely no guarantee from me. Even less from Matrixgames.

I successfully loaded my last 5 saves in my current game versus the AI. Everything looks good so far. Thanks!

I have aproblem similar to Lord Sunderland's post of 4 August. I an running scenario 001, one day turns. Windows XP Svc Pk 2. WitPStaff is working fine until around 16 Dec then when I try to upload the latest save game file, I get a fatal error. WitpDecoder says:

There is a problem with LCU 3332 (13th Tank) as follows:
Couldn't write things to the DB due to java.sql.SQLException: Integrity constraint violation - no parent LCUsMarchOnlyToExistingBases table: LCUStatus
java.sql.SQLException: Integrity constraint violation - no parent LCUsMarchOnlyToExistingBases table: LCUStatus
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.data.j.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.j.b(Unknown Source)
at de.retsiemuab.witpDecoder.data.p.c(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aU.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bq.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.W.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aQ.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)


The stuff in bold is what's shown on the error message. As indicated, the rest comes from the end of the Decoder rpt.

Hope you can give some help. It does provide some useful information.

Peace,
Doc Smith

Doc,

bonus points for a good bug report, malus points for not reading the post two above yours.

I am using the 0.7a version.
I created a new database and loaded my last save (as Japan, Dec 29th 1941) into it.
On the "Ship Classes" tab "Ship Type: CV" "Nationality: Japanese" "Availability: Current Only" the CV Zuikaku is missing from the list, despite being active (not sunk) and in a Task Force.
Also 6 of the 10 BBs are missing and some CAs etc.; I did not check the other types.

Aehm, how about contemplating about the meaning of

Shipclasses

OK, WitpStaff Question for turn 0/1 ....

I want to build a database/csv file for ALL the bases relative to port size, resources, oil, refineries, Light Industry, etc .....
Playing as only the IJN, I only get the data from those bases held by the IJN. I ran a second attempt playing against an IJN AI and loading the Allied data to complete the package and WitpStaff informs me that this turn is in the past for this scenario .... Too bad ....

Am I

1) doing anything wrong ?
2) trying something impossible ?
3) screwing up how to do some thing that is easy ?
4) somewhere in between.....

Again, looking for the starting game data on ALL bases (Allied or Japanese) for planning purposes .....

Did you delete the appropriate DB folder and then reinitialise the DB thereby starting afresh ?

--Damian--

ORIGINAL: n01487477

Did you delete the appropriate DB folder and then reinitialise the DB thereby starting afresh ?

--Damian--

Started a new game. Saved under a new file. Created a new DB folder .... Thought that would be overkill ..... Still resisting ... ?

Probably a silly Q, but is witpstaff configured (starting) to that new DB folder ? Otherwise I'm a little confused why you're having a problem too [;)]... 

ORIGINAL: n01487477

Probably a silly Q, but is witpstaff configured (starting) to that new DB folder ? Otherwise I'm a little confused why you're having a problem too [;)]... 

probably my lack of knowledge as to how to use it. Getting ready to delete the original db and start anew. Does seem odd that I can't merely start a new game, a new db and run from there though .... It's got to be my lack of knowledge ....

You can not at the same time load Allied / IJN data into the same WitpStaff database. The tool is written to maintain FoW even in games against the AI. If you want to see the side of the AI you need a second database. You can read the same savefiles into the second database (as long as it is from an AI game).

For the second database you must convince WitpStaff to allow you to create another DB. Just Select "Change Database Directory" from the File Menu and click cancle. WitpStaff then allows you to generate a new database (and I think I explained that in the documentation). The number of database you can create is only limited by the disk capacity. You switch between them with "Change Database Directory".
You should start reading manuals.

ORIGINAL: Woos

You can not at the same time load Allied / IJN data into the same WitpStaff database. The tool is written to maintain FoW even in games against the AI. If you want to see the side of the AI you need a second database. You can read the same savefiles into the second database (as long as it is from an AI game).

For the second database you must convince WitpStaff to allow you to create another DB. Just Select "Change Database Directory" from the File Menu and click cancle. WitpStaff then allows you to generate a new database (and I think I explained that in the documentation). The number of database you can create is only limited by the disk capacity. You switch between them with "Change Database Directory".
You should start reading manuals.

Reading manuals is probably the appropriate task here ....[&o]

Being an engineer though, you NEVER EVER READ THE MANUAL ..... [;)]

So I am at a disadvantage. Thank you for your suggestion though ....

Does WitPStaff work for Scen 6 (Dec8 start campaign) ? I am at work and cannot check right now..[8D]

"Ship tonnage" might be a nice feature to add to ship classes, it is now important for port size, ship docking, etc...