RE: New tool: WitpDecoder; No more spreadsheets! (Full Version)

All Forums >> [Current Games From Matrix.] >> [World War II] >> War In The Pacific - Struggle Against Japan 1941 - 1945



Message

Honda -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 10:30:17 AM)

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



Sneer -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 11:04:09 AM)

incredible
excellent work



Florian Geyer -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 11:52:33 AM)

Get always this errormessage,after trying to load a saved game.
Whats wrong[&:] ?


C:\Matrix Games\War in the Pacific\SAVE\WitP Decoder 1>echo off
WitP-Decoder V0.1 (C) 2006 by M.Baumeister. Please wait!
Couldn't write things to the DB due to
java.sql.SQLException: Unique constraint violation: SYS_CT_71
java.sql.SQLException: Unique constraint violation: SYS_CT_71
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.ac.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.BaseData.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.ak.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)

at de.retsiemuab.witpDecoder.y.a(Unknown Source)
at de.retsiemuab.witpDecoder.g.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.T.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
No DB entry for this turn found?????
Got an Exception java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at de.retsiemuab.witpDecoder.p.a(Unknown Source)
at de.retsiemuab.witpDecoder.p.a(Unknown Source)
at de.retsiemuab.witpDecoder.T.a(Unknown Source)
at de.retsiemuab.witpDecoder.y.a(Unknown Source)
at de.retsiemuab.witpDecoder.g.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.T.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)





Andy Mac -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 12:26:00 PM)

This would be incredibly usefull for the allies in 44 45 where the sheer scale of ops is daunting



JamesM -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 12:39:18 PM)

One word "WOW"!



Bliztk -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 1:15:04 PM)

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



Sneer -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 2:55:38 PM)

wrong thread



saj42 -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 3:01:52 PM)

Wow this is the best thing since patch 1.3 [&o][&o][&o]



Mike Dixon -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 4:21:05 PM)

Jolly good show!

[image]local://upfiles/568/62AF583CB6FB4437A0EC9FD56AAC1763.jpg[/image]



ny59giants -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 4:44:14 PM)

Woos,
Can your Utility be used in conjunction with Bodhi's Utility?
Bodhi's is good for utilizing the SigInt information, among other things.



Admiral DadMan -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 4:52:18 PM)


quote:

ORIGINAL: ny59giants

Woos,
Can your Utility be used in conjunction with Bodhi's Utility?
Bodhi's is good for utilizing the SigInt information, among other things.

Yes it can. Bodhi's Utility only reads the generated .txt report files



Woos -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 7:42:01 PM)

quote:

ORIGINAL: Florian Geyer

Get always this errormessage,after trying to load a saved game.
Whats wrong[&:] ?

Couldn't write things to the DB due to
java.sql.SQLException: Unique constraint violation: SYS_CT_71
java.sql.SQLException: Unique constraint violation: SYS_CT_71

This is very likely a problem in the save game file. I put several integrity constraints into the DB (among them several uniqueness constraints). I already had to remove one due to the leader bug. This might be another one which needs removal (and addition to the inconsistencies tab).

Alas I can not say from the error message which constraint is the culprit (the DB is not very forthcoming with understandable messages in these cases). You got a PM with my e-mail address. Forgot to mention it in the PM, please tell my the scenario the save game is based upon.

BTW, here DB="Database" not "Dive Bomber".



Helpless -> RE: New tool: WitpDecoder; No more spreadsheets! (11/15/2006 7:50:01 PM)

actually I do get similar error

D:\Games\War in the Pacific\SAVE\myanalisys1>echo off
WitP-Decoder V0.1 (C) 2006 by M.Baumeister. Please wait!
Couldn't write things to the DB due to
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_82 tabl
e: FactoryTypes
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_82 tabl
e: FactoryTypes
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.ac.a(Unknown Source)
at de.retsiemuab.witpDecoder.I.a(Unknown Source)
at de.retsiemuab.witpDecoder.data.BaseData.a(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.ak.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)

at de.retsiemuab.witpDecoder.y.a(Unknown Source)
at de.retsiemuab.witpDecoder.g.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.T.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)
No DB entry for this turn found?????
Got an Exception java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at java.util.ArrayList.RangeCheck(Unknown Source)
at java.util.ArrayList.get(Unknown Source)
at de.retsiemuab.witpDecoder.p.a(Unknown Source)
at de.retsiemuab.witpDecoder.p.a(Unknown Source)
at de.retsiemuab.witpDecoder.T.a(Unknown Source)
at de.retsiemuab.witpDecoder.y.a(Unknown Source)
at de.retsiemuab.witpDecoder.g.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.T.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)


I have tried to load a saved first turn for the CHS scenario. Does it suppose to handle modified scenarios?



Woos -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 1:36:20 AM)

quote:

Original: Florian Geyer
java.sql.SQLException: Unique constraint violation: SYS_CT_71
java.sql.SQLException: Unique constraint violation: SYS_CT_71
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)


Interestingly I get a different error when loading the save file provided by you. That error (the one I get) is caused ..... how should I put it .... well, Cpt. A.Takagi is no longer following your orders as TF65 commander. Consequently he has been replaced with 1st Lt. T. Ellis of the US Army ;-)

So files with a full-blown leader bug (where replacement has actually happened) will not load into witpDecoder. Nice to know, so now I know that the bug has not yet happened to me. Also I'm not willing to remove the integrity constraint which disallows USN captains for IJN ships (I don't want to end up with a database messed up similar to the WitP save game files).

Proposal: I can change the programm so all ships with a wrong nation captain will be added to the DB using a non-descript IJN captain named e.g. "I.ComeFromUsnavy" or so (better names are willingly accepted). For Allied players that would probably be a Cpt. "C.anIBanzai". He will always show up in the inconsistencies tab if assigned. OK?

BTW, the problem with password protected files has been found. It's all your own fault. Really! It happens only because you are all using more complex passwords than the one I used for testing. I will call this the "Only people with stupid passwords really need help in a PBEM" feature and will remove that feature in the next version on popular demand (due out in a few days once I get better error handling running).



bbbf -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 2:38:50 AM)

I resent having a capital letter in my password being called stupid![:D][:D]

Especially as it wasn't actually my idea (I took over the game from someone else)

Good news though, it will make managing the unmanageable so much easier.



FeurerKrieg -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 7:37:34 AM)

So a password with lowercase letters and numbers won't load?



Woos -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 9:48:10 AM)

quote:

ORIGINAL: bbbf
I resent having a capital letter in my password being called stupid![:D][:D]

You got that one wrong. If the game doesn't load, the password is too complex. And only very, very few passwords are not too complex. So don't even try too find a weoking one, it would be easily guessable by your opponent (that's also the reason I will not tell you what passwords do currently work. Players who knew that their opponent has successfully loaded the PBEM into witpDecoder could be tempted to try a bit of guessing).



FeurerKrieg -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 9:53:51 AM)

Hi Woos,

Great work so far. Is this the final word on password protected save files? Or are you working on a way to be able to open them, even with slightly complex passwords?



huggarn -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 10:06:11 AM)

Im  in love!

I though about doing an app like this for myself for ages.





Sneer -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 2:18:46 PM)

i got this error also on savegames that are in turn 1 with no password games
so no chance for bug
there must be sth else




Woos -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 6:07:07 PM)

quote:

ORIGINAL: Feurer Krieg
Is this the final word on password protected save files?

Which word do you mean, this one?
> I will call this the "Only people with stupid passwords
> really need help in a PBEM" feature and will remove that
> feature in the next version on popular demand

Yes, that's final although I'm still searching for the passage that says that I'm not working on it. Maybe I should stop trying to make jokes in a foreign language.

quote:

ORIGINAL: Sneer
i got this error also on savegames that are in turn 1 with no password games
so no chance for bug
there must be sth else

Uh, which error? Florian's problem was not caused by passwords, but by the leader bug (see post 44). Helpless' problem I had not yet time to analyse.



Rob Brennan UK -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 6:11:17 PM)

Woos ! .. I think you might have converted me to play japan with this tool [&o][&o][&o]. Japanese industry and requirements always left me baffled ( and i'm not setting up XL files to play a darn game, XL is for work [;)]).

As many people have already stated .. FANTASTIC !. many many thanks



Woos -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 7:30:23 PM)

quote:

ORIGINAL: Helpless
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_82 table: FactoryTypes
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)

I have tried to load a saved first turn for the CHS scenario.

The error is caused by the "United States" base claiming to have a factory building aircraft 209 (a whole 15 of it). But there is no aircraft 209 (at least not in the WITPair.csv file you provided). Would be in the Russian section anyway.

So it's an CHS error. Sorry, CHS games can currently not read into witpDecoder (maybe after you reassigned that factory, but I would assume factories building non-existing aircrafts don't show up in the game UI).

quote:


Japanese industry and requirements always left me baffled

Then you should probably wait till the "Industry" tab is working. Because the current witpDecoder version will not help you to know how much oil to ship to Taiwan, etc. You would only see if you run out of oil completely.



Oliver Heindorf -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 7:42:22 PM)

wow ! its something I really liked to have back in 2004 [:'(]

PS : and the allied version of course ! [;)]

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



witpqs -> RE: New tool: WitpDecoder; No more spreadsheets! (11/16/2006 7:46:28 PM)

Woos,

Just an idea - can you make it so that instead of an error those kind of issues all get recorded in a certain tab and just left out of the totals? There are so many games out there that must have that kind of error in them. Even in a new scenario it's really easy for that kind of mistake to happen in the mod, and the leader bug is supposedly still alive (even though it's in hiding!).

The more gracefully the utility handles things that are broken inside the save games the more people will be able to use it. Just a thought.



Andrew Brown -> RE: New tool: WitpDecoder; No more spreadsheets! (11/17/2006 12:20:57 AM)

quote:

ORIGINAL: Woos
The error is caused by the "United States" base claiming to have a factory building aircraft 209 (a whole 15 of it). But there is no aircraft 209 (at least not in the WITPair.csv file you provided). Would be in the Russian section anyway.

So it's an CHS error. Sorry, CHS games can currently not read into witpDecoder (maybe after you reassigned that factory, but I would assume factories building non-existing aircrafts don't show up in the game UI).


There is an aircraft 209 in CHS - the P-66 Vanguard.

Andrew



Helpless -> RE: New tool: WitpDecoder; No more spreadsheets! (11/17/2006 1:01:51 AM)

That's right there is an 209 entry. It is my fault - aircraft file was missing! [:@] Most probably you've been reffering to the stock aircraft file.

I have regenerated all csv files according to instructions. Now I'm getting the error:

WitP-Decoder V0.1 (C) 2006 by M.Baumeister. Please wait!
java.sql.SQLException: Integrity constraint violation - no parent SYS_FK_162 tab
le: 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.ac.a(Unknown Source)
at de.retsiemuab.witpDecoder.M.a(Unknown Source)
at de.retsiemuab.witpDecoder.ac.b(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 set up a working DB template. Exiting.

All files seems to be in place this time. Archive has been sent.

p.s Anyone had success with CHS and witpdecoder?





Woos -> RE: New tool: WitpDecoder; No more spreadsheets! (11/17/2006 1:10:32 AM)

quote:

ORIGINAL: Andrew Brown
There is an aircraft 209 in CHS - the P-66 Vanguard.

Indeed, the save file itself also shows it. So it's a user error, no CHS error.

People, it is important to use the .csv files of the scenario the save game is from and not any .csv files. You have to specify the correct scenario number with witpload ("/s" switch if I remember correctly). Otherwise all hell will break loose when you read in a save file because the .csv files are used to initialize certain static parts of the DB (why parse a complicated save file when you can get the same information easily from a .csv file). Looks as if I should try to automate that whole .csv file thing to reduce the number of possible errors.

I just noticed this when I tried to put in routines which could handle these errors and tried them on the directory setup helpless' had sent me.

So yes, I'm writing some handling routines which will take a guess of what might be wrong and then drop or transform the database entry. But there will be no list of inconsistencies (can't compile that when I drop entries) but a pop-up window for every time such a routine has to jump to the rescue. Should get people interested in fixing scenarios and prevent them from not noticing .csv-file mistakes.

quote:

ORIGINAL: Helpless
Couldn't set up a working DB template. Exiting.

Now that error should be interesting because it happens during database initialization (i.e. while the csv files are read). But it has to wait for tomorrow evening.



Helpless -> RE: New tool: WitpDecoder; No more spreadsheets! (11/17/2006 1:25:14 AM)


quote:

ORIGINAL: Woos

Otherwise all hell will break loose when you read in a save file


Last error happens during the initialization.



jcjordan -> RE: New tool: WitpDecoder; No more spreadsheets! (11/17/2006 4:59:55 AM)

Woos, just FYI I'm getting the same error as Helpless with a new CHS game IJ (me) vs Allied AI the first time I run it & when I run the bat file again I don't get the error & the template comes up but no data show in template even though I've played a turn & 5 new files are created in the folder - witp.data, witp.script, witp.properties, witp.lck & witp.log. If I delete these 5 files, I then get the error again & can repeat the process all over again. Just FYI for any help it may do you.



Page: <<   < prev  1 [2] 3 4 5   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.625