WitpDecoder; Now providing some overview

[Woos]

Hmm, since it seems I can give christmas gifts to lots of people with just one intermediate release, let's do it. Basically no new functionality but

• VSWG gets his database dump into .csv although I'm not sure he will like it. I discovered an easy way to do it, but it produces no column names (find them in the witp.script file) and the DB layout is copyied 1:1 (so no denormalization). Also the output format might change anytime the database schema changes (it just dumps the data using the database internal meta information). No further support (like "please tell me what that table means") is available for this feature. BTW, you have to delete all the created *csv.csv files by hand before you can do it again. Otherwise you get a NullPointerException.
• Feurer should be able to read in his demoted leaders.
• qgaliana, grunt6971 (and everyone else) will be able to select leaders also by rank, improving the probability to actually find a promising leader in the in-game selection dialog dramatically (Thanks guys for the tip). You will have to work out yourself, which ranks combine which with nationality, though.
• Rainer gets not yet available ships in the inconsitency tab marked (NYA).
• Calculation of used Naval and Merchant points should finally(!) be correct.
• Probably some more inconsistencies in save files which witpDecoder can now read in, that I forgot about. There are too many to still remember single ones.

Get the new .jar file from http://extweb.retsiemuab.de/witp/witpDecoder3b.jar and overwrite your witpDecoder2.jar file with it (don't forget to change the number). And to avoid the usual question, yes, this really is a .jar file. If you download it and get a .zip file or even a bunch of files, you have a browser problem (called IE).

Have fun and if it doesn't work go back to V0.3 (see first post for redownload address) as I'm offline for the comming days.

[VSWG]

ORIGINAL: Woos

[*] VSWG gets his database dump into .csv although I'm not sure he will like it. I discovered an easy way to do it, but it produces no column names (find them in the witp.script file) and the DB layout is copyied 1:1 (so no denormalization). Also the output format might change anytime the database schema changes (it just dumps the data using the database internal meta information). No further support (like "please tell me what that table means") is available for this feature. BTW, you have to delete all the created *csv.csv files by hand before you can do it again. Otherwise you get a NullPointerException.

Woah, thanks!!! [X(] [:D]

I'll have a look asap!

Merry Christmas!! [:)]

[FeurerKrieg]

Great news, thanks Woos! I'll be gone for a few days, but when I get back, and get caught up on any turns in my in-box, I'll give it a go and let you know how it goes. Thanks for your help!

[Oliver Heindorf]

ORIGINAL: Woos
And to avoid the usual question, yes, this really is a .jar file. If you download it and get a .zip file or even a bunch of files, you have a browser problem (called IE).

LOL !

[:'(]

thanks !!!! [&o][&o][&o][&o][&o]

[vertical]

Wow, this utility looks fantastic.  Might have to repurchase WitP soon.

[VSWG]

The database dump is great! [:)] I'll see if I can create a couple of Excel-files that pull some data from those .csv-files. In case someone else is interested in this: the most interesting files and their contents are:


BaseStatusCSV.csv

BaseID, PosX, PosY, HQ ID, AirfieldMax, AirfieldCurrent, AirfieldExpansion, PortMax, PortCurrent, PortExpansion, FortCurrent, FortExpansion, StoredFuel, StoredSupply, StoredOil, StoredResources, BaseName, FactoryCount, BaseType, NationalityID, OriginalNationalityID, AppearingFuel, AppearingSupply, AppearingOil, AppearingResources


ShipStatusCSV.csv

ShipID, ShipClassID, HarborLocID, TFID, Endurance, Fuel, LoadedRes, LoadedSupp, LoadedOil, LoadedFuel, LoadedUnitID, ExpDay, ExpNight, CommanderID, ShipName, NationalityID, BuildSpeed, TurnsTillAvail


TFStatusCSV.csv

TF ID, PosX, PosY, CommanderID, HomeHarborID, TargetID, Targetx, TargetY, MissionID, NationalityID


LCUStatusCSV.csv

LCU ID, PosX, PosY, PrepLoc, PrepPerc, Exp, Morale, Fatigue, CommanderID, HQ ID, TargetID, TargetX, TargetY, StoredSupply, Name, SuffixID, LCUTypeID, Comment, NationalityID, TurnsTillAvail, FragmentToParent, FragmentNumber

[BB57]

Thanks Woos, 3b fixed problem noted above in my PBEM game. Now the witpdecoder.log file tells me Cornelis, J. C. no parent LeadersCommandAbilityMustExist table. Deleted witp.* and *.csv files and reinitialized twice and got the same message.  I feel the problem is in the save file and not in witpdecoder. Anyone have any ideas on how to fix or are we doomed to no witpdecoder for this game?
 
 

[eloso]

Woos,

In the future if you are up to adding new features I'd like to see the Reinforcement screens added. The notification for new arrivals are disabled in PBEM games. Currently, I keep a back up save prior to ending the orders phase to review prior to the next turn.

Thanks,

Oso

[Crimguy]

OK I'm officially a moron <enter everyone's affirmation here>.&nbsp; I tried following the directions, but seems that something is missing.

I've run witpload.&nbsp; It gives me several csv files, but no clusters.csv file.&nbsp; Your instructions state:

To make full use of the Industry tab you need a “clusters.csv” and a “clusterbases.csv” file
for your specific scenario. The example files provided in the witpdecoder.zip file will only
work for scenario 192. If you are using anything else, these files will probably cause false
information to be displayed if you just rename them to the correct.

Neither the Witpload or witpdecoder instructions shed any light on how to resolve this.

Thanks in advance.&nbsp; It does run - just not sure it's running properly.

[scout1]

Not a moron .... Wiptload will NOT create a custers file. This as to be done manually. Good news is that it is scenario specific (and partially time dependendent on what you've captured/had captured). Starting csv files should start to be populated by the community as this tool is more widely used ....

[Crimguy]

I feel a bit better, thx.[;)]

hmmmm. . . where can I get more info on the creation of these files (if I would like to create them myself)?

[qgaliana]

ORIGINAL: Woos

[*] qgaliana, grunt6971 (and everyone else) will be able to select leaders also by rank, improving the probability to actually find a promising leader in the in-game selection dialog dramatically (Thanks guys for the tip). You will have to work out yourself, which ranks combine which with nationality, though.

This works great - HUGE THANKS. The ranks are quickly figured out so no worries.

[Sardaukar]

ORIGINAL: Crimguy

I feel a bit better, thx.[;)]

hmmmm. . . where can I get more info on the creation of these files (if I would like to create them myself)?

I second that...the instructions to actually get it to run seem to be quite vague...[8D]

[VSWG]

Vague?&nbsp;[&:]

Note that this tab requires two .csv files which are not provided by WitpDecoder, “clusters.csv” and
“clusterbases.csv”. More correctly witpDecoder provides an example set of those files but those
are only correct for players playing Big B's Mod 192 based on Andrew Brown's Extended Map. If
you use them with any other scenario the values shown in the table may be arbitrarily wrong. You
will have to create your own files, with clusters.csv containing all the clusters you want to
distinguish numbered from 1 (and a “-1” entry showing the scenario the files were made for) and
“clusterbases.csv” containing all the baseIDs assigned to each cluster. (the “name” column in the
example clusterbases.csv is not evaluated by witpDecoder and only there to allow easier error
checking). Currently both .csv files have to be present already during database initialization to be
taken into account. This may change in the future.

To rephrase:

1. In clusters.csv you define all clusters you want to use in WitPDecoder. Each cluster gets its own cell in the format "Number, Clustername"
2. In clusterbase.csv you assign all your bases with industry to the correct cluster. Every base gets its own cell: "ClusterID (the number from clusters.csv), BaseID (you have to look this up in the editor), Basename.

Done.

[Reg]

Can you change cluster definitions (.csv files) during the game as bases change hands??

[FeurerKrieg]

Yes.

[Sardaukar]

ORIGINAL: VSWG

Vague? [&:]

To rephrase:

1. In clusters.csv you define all clusters you want to use in WitPDecoder. Each cluster gets its own cell in the format "Number, Clustername"
2. In clusterbase.csv you assign all your bases with industry to the correct cluster. Every base gets its own cell: "ClusterID (the number from clusters.csv), BaseID (you have to look this up in the editor), Basename.

Done.

And where it does say *how* you make those clusters.cvs etc. for your scenarios ? [8|]

You know, not all are computer experts...and that sort of information is essential for starters...

[VSWG]

I think everything will become clear once you open the attached example files. Use Editor, or WordPad, or MS Word, or any other program able to open text files.

[Oliver Heindorf]

yes, you can use the example files included in the zip file to make/re-structure them to your convinience and then use them with this tool.&nbsp;[;)] its some kind of work, though. I havent completed it yet, I just tested it a bit around to see how it is supposed to work.

if you ask me, Bodhi and Markus should combine their efforts - the result would be a blast.

[herwin]

ORIGINAL: Oliver Heindorf

yes, you can use the example files included in the zip file to make/re-structure them to your convinience and then use them with this tool. [;)] its some kind of work, though. I havent completed it yet, I just tested it a bit around to see how it is supposed to work.

if you ask me, Bodhi and Markus should combine their efforts - the result would be a blast.

The example files will work for CHS scenarios 155-160.