Page 5 of 29
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 7:58 pm
by Woos
ORIGINAL: scout1
Fired up *.bat and got windows/tabs, but no data whatsoever. I'm sure I've missed something. But what ?
What would you normally do to load something (like a save game). Do it here also
Or maybe you forgot to speak out the "Java good! C## bad!" mantra (see post 71)[;)]
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 8:05 pm
by scout1
All great journeys occur one step at a time ..... Did it and got ALL kind of exceptions in a typical windows pop up that 1) won't let me copy it and 2) says "OK" (that really pisses me off).
Suggestions ?
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 8:21 pm
by scout1
Does the save game file have to be in the sub directory ?
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 8:47 pm
by Woos
ORIGINAL: scout1
Did it and got ALL kind of exceptions in a typical windows pop up that 1) won't let me copy it and 2) says "OK" (that really pisses me off).
Grummel, on Linux (where I'm developing the thing) these windows do allow their content to be copied. [:@]
OK new version of witpDecoder2.jar is online (under the URL shown above) which is back to printing errors to the console so they can be copied (special bonus: The industry tab has some first content: Spoilage overview).
If you are getting multiple exceptions, did you use the correct scenario for witpload to generate your .csv files? See
post 58. Also normally the first exception (note: "exception" not "error message") should end the loading process and throw you back to the empty window.
Save game can of course be anywhere. That's why you get a File-Requester to locate it.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 8:58 pm
by Helpless
ORIGINAL: scout1
All great journeys occur one step at a time ..... Did it and got ALL kind of exceptions in a typical windows pop up that 1) won't let me copy it and 2) says "OK" (that really pisses me off).
Suggestions ?
Usually all the errors go to the cmd window which could be copied, not the pop up. [&:] In worst case you might press "Pint Screen" and copy an image of error.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 9:02 pm
by scout1
I'm probably hosing things up here ....
Loaded new version of *.jar and tried again. Got same error messages ....
"
couldn't write things to DB due to
java.sgl.SQLException : Numeric Value out of range
at ..... (whole bunch if stuff) ...... "
Still can't copy and paste .... What have I screwed up ? Sc 005 was generated from
sc 015, which us want I'm trying to grab ....
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 10:35 pm
by witpqs
How about just make the errors go to a log file?
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 11:42 pm
by Reg
ORIGINAL: witpqs
How about just make the errors go to a log file?
Code: Select all
C:\MatrixGames\WITP\SAVE\my_analysis\witpdecoder.bat > Errors.txt
does the same job.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sat Nov 18, 2006 11:51 pm
by Reg
I got the following errors on attempting to load a CHS Scenario 159 about 30 (game) days old using the second version of decoder2.jar.
A standard scenario save file loads just fine for me.
===== Listing of errors on WitpDecoder load ====
F:\Matrix Games\War in the Pacific\SAVE\WitpDecoder-Save18Scen159>echo off
WitP-Decoder V0.1 (C) 2006 by M.Baumeister. Please wait!
TF7017 has probably been hit by a leader bug and is led by no or a foreign officer.
Get that fixed!
In the mean time I'm using a replacement officer.
TF7018 has probably been hit by a leader bug and is led by no or a foreign officer.
Get that fixed!
In the mean time I'm using a replacement officer.
TF7062 has probably been hit by a leader bug and is led by no or a foreign officer.
Get that fixed!
In the mean time I'm using a replacement officer.
TF7154 has probably been hit by a leader bug and is led by no or a foreign officer.
Get that fixed!
In the mean time I'm using a replacement officer.
Couldn't write things to the DB due to java.sql.SQLException: Integrity constraint
violation - no parent SYS_FK_136 table: BaseStatus
<<list of java error references>>
==== Extracts from witp.script (which creates WitpDecoder database) ====
CREATE CACHED TABLE "BaseStatus"("baseID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY, ...
CREATE CACHED TABLE "TFStatus"(... ,"homeHarborID" SMALLINT DEFAULT 0 NOT NULL, ... ,CONSTRAINT SYS_FK_136 FOREIGN KEY("homeHarborID") REFERENCES "BaseStatus"("baseID") ON DELETE CASCADE,
==== Conclusion ====
My save game file contains a Task Force with a non-existent home base!! (plus the usual leader bugs)
If Woos agrees with this conclusion, I think it may put a pressure on Andrew and the team to make sure the CHS scenarios are totally consistant (Sorry about that).
I will now trawl though the game and see if I can identify the errant Task Force.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 12:02 am
by Helpless
I have no problem to run witpdecoder on CHS. If later on it got screwed by the game code itself , nothing could be done by scenario developers.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 2:23 am
by Reg
ORIGINAL: Helpless
I have no problem to run witpdecoder on CHS. If later on it got screwed by the game code itself , nothing could be done by scenario developers.
After a bit more testing I will agree on this.
As an allied player the saved games I tried to load were on the Allied orders phase. I ran a turn so I could access the Japanese task forces and the error changed to Task Force destination base (SYS_FK_137). I also got errors on LCU prep destination on other test runs. Perhaps the AI is having issues with the changes to the bases in CHS. (Further info: I was running all areas under computer control).
Woos, maybe this is just something to be aware of if players use computer control.
For your info, check out TF62 below and in the next post. The TF destination is open ocean but Palau is displayed as destination in the TF list. Maybe this is what is upsetting the load process.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 2:26 am
by Woos
ORIGINAL: Reg
Couldn't write things to the DB due to java.sql.SQLException: Integrity constraint
violation - no parent SYS_FK_136 table: BaseStatus
<<list of java error references>>
==== Extracts from witp.script (which creates WitpDecoder database) ====
CREATE CACHED TABLE "BaseStatus"("baseID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY, ...
CREATE CACHED TABLE "TFStatus"(... ,"homeHarborID" SMALLINT DEFAULT 0 NOT NULL, ... ,CONSTRAINT SYS_FK_136 FOREIGN KEY("homeHarborID") REFERENCES "BaseStatus"("baseID") ON DELETE CASCADE,
==== Conclusion ====
My save game file contains a Task Force with a non-existent home base!! (plus the usual leader bugs)
The conclusion was correct if ..... WitP had not the interesting idea of saving Dot bases in several different ways (as I just found out; I'm beginning to wonder if the Matrixgames guys still understand their save game format). And the version you have only recognizes two of those ways and drops bases saved in the third one. So you might want to look for a TF with a dot base as home base (or send me your save file + .csv files).
Saving error reports into a file is something I will probably do in a future version (I want to get rid of the console).
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 2:28 am
by Reg
Note TF62 as above.
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 2:34 am
by scout1
Got one of my scenario's to work (in some manner), and all I can say is
OH MY GOD, this tool is truely KICK ASS. I think I died and went to heaven ....
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 3:00 am
by scout1
If the boys haven't used this tool (otr something like it), it's a crime. Just ran it on one of my games with GoodBoyladdie and found that I have
12 occurences where 1 leader commands more than one unit
15 occurences where I have no leader or a foreign one
I'm really looking forward to the potential of this toolset ... God, I might even get to think strategically now, instead of just as the supply sargenr who really doesn't have a good picture of what is really going on .....
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 9:00 pm
by Woos
V0.2 is available as zip-File from the old location
http://extweb.retsiemuab.de/witp/witpdecoder.zip
Should be better in handling dot bases. Has a useful documentation PDF file and finally the industry Tab is working so knowing where to send the Oil and Res transports is easier (the last spreadsheet I wanted to replace). See below
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 9:17 pm
by Helpless
Spoilage stats kicks ass.. [&o] [:)]
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 10:34 pm
by BaitBoy
[&o][&o][&o]
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 11:43 pm
by jrcar
Amazing, thanks you. Looking froward to using it. The Poilage stats will be very handy.
Cheers
Rob
RE: New tool: WitpDecoder; No more spreadsheets!
Posted: Sun Nov 19, 2006 11:50 pm
by scout1
Looking forward to this update ....
Now, just so that I'm clear. If I have 4 games, slots 005, 006, 007 and 010, all of which are the same exact scenario, I still need an independent subdirectory for each fully populated to run the info on each. True ? Not complaining, just want to make sure I follow directions ....
And since I haven't gotten that far yet, is the info provided available to be printed for offline evaluation ? IE is it limited to screen viewing only or are there options ?
Grand looking tool thus far AND I haven't found a way to break it yet ..[;)]