WitpDecoder; Now providing some overview

[blam0]

Has anyone compiled clusters for the Stock Scenario 15?

TIA

[jcjordan]

Woos - everything was going along fine with this till today. I'm playing a mod chs 2.08 into 1/12/42 of me vs IJ AI. I started to load decoder up & then I get the following error. I've looked at my cluster & clusterbases files & nothing seems amiss & a Phil base was captured last turn by AI. Any help on where to look?

java.sql.SQLException: error in script file line: 43 Header not allowed or too long in statement [SET TABLE "Clusters" SOURCE HEADER "ClusterID,Clustername
"]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at de.retsiemuab.witpDecoder.ba.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
Couldn't open DB. Exiting.
Exception in thread "main" java.lang.NullPointerException
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

[Ron Saueracker]

ORIGINAL: Kid

You know I'm really interested in this utility but reading this thread make me think you have to be an IT expert to install and run it. [:(]

You said it Rick! I'm more than a wee bit intimidated.[&:]

[Martti]

Cluster files for stock scenario 15:

http://koti.mbnet.fi/~zombie/clusterbases.csv
http://koti.mbnet.fi/~zombie/clusters.csv

Next some dire warnings:

Files are only minimally tested
Should work also on other stock full-map scenarios but not tested
No whining

[Woos]

ORIGINAL: jcjordan
java.sql.SQLException: error in script file line: 43 Header not allowed or too long in statement [SET TABLE "Clusters" SOURCE HEADER "ClusterID,Clustername
"]

That is an error that actually shouldn't occur (wouldn't you say that of all errors
I suspect the problem stems from a bug hsqldb has with .csv-files and database compaction. Anyone getting this error should have a look at his witp.script file at the line specified in the error message. It should look about

Code: Select all

SET TABLE "Clusters" SOURCE HEADER ....

and thus forgets to specify the .csv-file for the clusters table. Fix it by replacing the line with

Code: Select all

SET TABLE "Clusters" SOURCE "clusters.csv;ignore_first=true"

Making a first a backup copy of the witp.script file might be a good idea as it is indispensable for database operation.

Now if someone could explain to me, why the code-tag in this BBS creates that much whitespace .......

[blam0]

ORIGINAL: Martti

Cluster files for stock scenario 15:

http://koti.mbnet.fi/~zombie/clusterbases.csv
http://koti.mbnet.fi/~zombie/clusters.csv

Next some dire warnings:

Files are only minimally tested
Should work also on other stock full-map scenarios but not tested
No whining

[&o][&o][&o][&o]

Thanks!!

[1EyedJacks]

Hi Woo,

I really enjoy your tool set. It works good with Big B's Mod. I was wondering if there was a way to:

A) dump info to a delimited file

B) set up the leader screen to track changes in leader stats by turn.

I'd really like to see when leaders stats go up and compare the increases to what took place on the turn. I can check by hand thru a spreadsheet with a delimited file but it would be too cool if I could do that straight from your tool.

Thanks again for sharing this tool!

[Woos]

Hello Jack,

A) is available in V0.3b with the "Dump to CSV" menu. No guarantees though.

Concerning B): So do leader stats change at all? I read some discussions where it wasn't clear.

[Cpt Sherwood]

Hi Woos, this utility is looking good. I have it working on a stock senario 15 game I am playing against the AI. But I am trying to get it to work on a starting PBEM game using Alaska Warriors senario 196. I am getting an error when I try to initialize the DB: Here is the error

java.lang.NumberFormatException: For input string: "45 QF HA GUN""

java.sql.SQLException: S1000 General error java.lang.NumberFormatException: For input string: "45 QF HA GUN"" in statement [
SET TABLE WITPDEV SOURCE "WITPdev.csv;ignore_first=true"]
Couldn't set up a working DB template. Bad, Bad.

Is it having a problem with a string starting with a number? Thanks, I am sure you will get the problems ironed out sometime.

edit: looking at the error seems more that it is looking for an integer, not a string. And I got the error with and without the CSV files.

Edit again - I know what the error is. Alaska Warrior used " instead of in to indicate inches in the dev table. I am fixing that now.

A new error:
Could not create or initialize the database

java.sql.SQLException: Integrity constraint violation - no parent ShipsUpgradeOnlyToExistingTypes table: ShipClasses
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.aW.a(Unknown Source)
at de.retsiemuab.witpDecoder.aF.a(Unknown Source)
at de.retsiemuab.witpDecoder.aW.b(Unknown Source)
at de.retsiemuab.witpDecoder.aA.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.retsiemuab.witpDecoder.s.c(Unknown Source)
at de.retsiemuab.witpDecoder.f.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at de.retsiemuab.witpDecoder.F.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)

Couldn't set up a working DB template. Bad, Bad.

Any ideas? I will be looking back at previous postings in this thread.

I am using version 3b - but this senario is derived from CHS so it might not work.

[Martti]

If I may make a request for version 0.4: ability to read multiple save files at once. So I don't have to load hundreds of files one at a time when a new version comes out.

[JoePirulo]

Thank you Woos. Very helpfull tool for playing WitP!!
Max.

[Woos]

ORIGINAL: Cpt Sherwood
But I am trying to get it to work on a starting PBEM game using Alaska Warriors senario 196.
...
this senario is derived from CHS so it might not work.

Exactly. V0.3b does not work with several mods for exactly the ShipClasses problem. V0.4 will fix that problem but there is still no guarantee. An I'm pretty sure for example that witpdecoder will not work with RHS.

@Martti
Loading several files at once is on the list. Only problem (at least for 0.4) will be that you will still have to click away all the warnings that pop-up. Or I will have to add some more global variables (Uh Oh).

[ctangus]

Since you're still working on it, I have a few suggestions that might prove useful. They'd be useful to me at least. [;)]

1. Include a "Supply stored" column in the Industry tab. This would be useful for both the Allies & Japanese: how's my supply situation in China? Am I burning up too much supply in the HI due to my industrial expansion?

2. Leaders tab: Units that can lead an air unit don't show what unit they're currently leading. However, it doesn't look like you're importing the different air units into your database currently so I suspect that would take more effort to implement.

3. Ship updates tab: That tab is not only useful for upgrading ships, but it's also useful for locating ships of similiar class. (I often try to use the same-class ships together.) It would be helpful to show ships that have no more upgrades available.

4. Ship classes tab: cruise speed & capacity are also useful data in figuring out how best to use merchants (particularly in CHS where both sides have 20,000 different merchant classes). Those also appear to be fields you're not importing, though.

Great stuff, as always. [:)]

[High Command]

Hello
&nbsp;
&nbsp;
I have a problem?
&nbsp;
I play pr Email, and have entered Password in the .BAT file, by replasing the word saying enterpasswordhere...&nbsp;&nbsp; and it still say i have wrang password?
&nbsp;
Can anyone help me in fainding out what the problem is?
&nbsp;
&nbsp;
&nbsp;

[Martti]

ORIGINAL: High Command

Hello


I have a problem?

I play pr Email, and have entered Password in the .BAT file, by replasing the word saying enterpasswordhere...   and it still say i have wrang password?

Can anyone help me in fainding out what the problem is?

The "REM java ... password" line is an example - it does not actually do anything. Enter your password at the end of the last line - the line beginning with "java -Djava...".

[qgaliana]

Woos - one comment on the leader tab.
&nbsp;
When I do a search I seem to get some leaders&nbsp;in there that aren't actually available in the game yet.
&nbsp;
From the csv files for the scenario it seems your utility is showing leaders once their availability date has arrived (fine so far), but the scenario often has them assigned to a ship that has not yet appeared. So although your utility lists them as available and unassigned they actually aren't.
&nbsp;
Any way to filter or fix this?

[Javakamp]

I just downloaded and installed wiptdecoder. When I try to load a save game file for CHS as the Allies I ght this message.

There is a problem with LCU 2564 (Fort Nepean) as follows:
Couldn't write things to the DB due to

java.sql.SQLException: Integrity constraint violation - no parent PreparationOnlyForExistigTargets table: BaseStatus
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.aW.a(Unknown Source)
at de.retsiemuab.witpDecoder.ag.c(Unknown Source)
at de.retsiemuab.witpDecoder.ag.a(Unknown Source)
at de.retsiemuab.witpDecoder.A.b(Unknown Source)
at de.retsiemuab.witpDecoder.ae.a(Unknown Source)
at de.retsiemuab.witpDecoder.ba.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.retsiemuab.witpDecoder.s.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at de.retsiemuab.witpDecoder.F.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



Any help would be appreciated.

Thanks

[Cpt Sherwood]

ORIGINAL: Javakamp

I just downloaded and installed wiptdecoder. When I try to load a save game file for CHS as the Allies I ght this message.

There is a problem with LCU 2564 (Fort Nepean) as follows:
Couldn't write things to the DB due to

java.sql.SQLException: Integrity constraint violation - no parent PreparationOnlyForExistigTargets table: BaseStatus
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.aW.a(Unknown Source)
at de.retsiemuab.witpDecoder.ag.c(Unknown Source)
at de.retsiemuab.witpDecoder.ag.a(Unknown Source)
at de.retsiemuab.witpDecoder.A.b(Unknown Source)
at de.retsiemuab.witpDecoder.ae.a(Unknown Source)
at de.retsiemuab.witpDecoder.ba.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.retsiemuab.witpDecoder.s.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at de.retsiemuab.witpDecoder.F.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



Any help would be appreciated.

Thanks

As stated above, it does not currently work on CHS or CHS derived senarios.

[Charbroiled]

Works fine for me using CHS.

[Woos]

Javakamp,

it's all in the error report

There is a problem with LCU 2564 (Fort Nepean) as follows:
Couldn't write things to the DB due to

java.sql.SQLException: Integrity constraint violation - no parent PreparationOnlyForExistigTargets table: BaseStatus

Look in game at the "Fort Nepean" unit. It will prepare for a non-existing base. Fix it and save. You will be able to load that new save (unless more problems are in the save file).

Maybe I should remove the exception trace. It seems to confuse people and distract from the important information.

@qgaliana
That could be an explanation for those annoying unfindable leaders. But I vaguely remember other problems before I restricted the "Lead Objects" table to only ready-built LCUs/ships. Will have to look into that.