WitpDecoder; Now providing some overview

Gary Grigsby's strategic level wargame covering the entire War in the Pacific from 1941 to 1945 or beyond.

Moderators: Joel Billings, wdolson, Don Bowen, mogami

Post Reply
User avatar
Arkady
Posts: 1261
Joined: Fri May 31, 2002 1:37 pm
Location: 27th Penal Battalion
Contact:

RE: Why using a DB with integrity constraints is usefull

Post by Arkady »

anyone have clusters for stock scenario #15 ?

I'll make them during weekend but if anyone can save me some time...[;)]
Image
User avatar
FeurerKrieg
Posts: 3400
Joined: Wed Jun 15, 2005 8:43 pm
Location: Denver, CO

RE: Why using a DB with integrity constraints is usefull

Post by FeurerKrieg »

The cluster for China is subject to change, based on how much or little of the rail network has been 'liberated' from those lousy Chinese peasants.
Image
Upper portion used with permission of www.subart.net, copyright John Meeks
User avatar
viberpol
Posts: 858
Joined: Thu Oct 20, 2005 3:16 pm
Location: Global village, Poland, EU

RE: Why using a DB with integrity constraints is usefull

Post by viberpol »

Woos, let me join the group of people grateful for the great tool you delivered [&o]
I have just noticed been informed about:

The following units have either no leader or a foreign one:
11th Division
13th Naval Construction Ba
13th/A Division
145th IJA Base Force
146th IJN Base Force
147th IJN Base Force
149th IJA Base Force
14th Construction Battalio
2nd AA Regiment
32nd NLF
35th/A Division
48th Road Construction Bat
66th Naval Garrison Unit
AD-3161
AG-101
AG-104
AG-106
AG-107
AG-110
AG-115
AG-2052
AG-2057
AG-2058
AG-2059
AG-2060
AG-2061
AG-2062
AG-2081
AG-2082
AG-2083
AG-2084
AG-2090
AG-2091
AG-2093
AG-355
AG-356
AG-357
AG-358
AG-359
AG-360
AG-362
AG-363
AG-367
AG-5031
AG-5033
AG-5068
AG-5069
AG-5071
AG-5087
AG-5088
AG-5112
AG-5113
AG-5114
AG-5115
AG-5117
AG-5138
AG-5139
AG-5141
AG-5143
AG-5160
AG-5161
AG-5162
AG-5163
AG-5164
AG-5165
Aiyo Maru
Akiura Maru
Alaska Maru
America Maru
Aoki Maru
Asahisan Maru
Atlantic Maru
Ayazono Maru
Ayo Maru
Canberra Maru
Chiburi
Chinzei Maru
Chosan Maru
Daishin Maru
Eihuku Maru
Enryaku Maru
France Maru
Haguro Maru
Haisho Maru
Hakubasan Maru
Haruta Maru
Heian Maru
Himejima Maru
Hohuku Maru
Hokusui Maru
I-40
Ikunta Maru
Ikushima Maru
Janbi Maru
Jokuja Maru
Kaijo Torakku SD-21
Kaijo Torakku SD-23
Kaijo Torakku SD-24
Kaijo Torakku SD-7
Kaika Maru
Kaiyo Maru #1
Kako
Kamo Maru
Karachi Maru
Kenshin Maru
Kimikawa Maru
Kinkai Maru
Kohoku Maru
Kozan Maru No. 2
Kusagaki
Mamiya
Manei Maru
Meishu Maru
Mikuma
Minko Maru
Mishima Maru
Mukahi Maru
Nagata Maru
Nagoya Maru
Nichiyu Maru No. 1
Nichiyu Maru No. 2
Nitian Maru
Noshiro
Oigawa Maru
PC-192
PC-33
Ponope Base Force
RO-112
Reiyo Maru
Roko Maru
Ryoka Maru
Ryuun Maru
SS 20
Sabang Maru
Satsuma Maru
Shinei Maru
Shinragi Maru
Shinrei Maru
Shoei Maru No. 2
Showa Maru #5
Sonan Maru #6
Soya Maru
TF7044
TF7086
TF7169
Taishi Maru
Taiyo Maru
Takamisan Maru
Takane Maru
Takasaki
Takuei Maru
Tango Maru
Tatsuura Maru
Teikai Maru
Teiyu Maru
Tekkai Maru
Tenposan Maru
Terukawa Maru
Toei Maru
Tsukushi Maru
Ume Maru
Victoria Maru
W.24
W.41
Yaezakura
Yahagi
Yamafuku Maru
Yamashita Maru
Yokosuka 7th SNLF
Yozan Maru
Yusho Maru
Yuzan Maru
Zinzan Maru

That is what to be expected as this is a PBEM played for about 10 months now... but hmm...[X(]


I wonder what does this part mean
TF7044
TF7086
TF7169

My Allied opponent has my leaders??
Ctangus, beware! [:D]
Przy lackim orle, przy koniu Kiejstuta Archanioł Rusi na proporcach błysł
User avatar
siRkid
Posts: 4177
Joined: Tue Jan 29, 2002 10:00 am
Location: Orland FL

RE: Why using a DB with integrity constraints is usefull

Post by siRkid »

I don't have time to read the entire thread so can someone tell me if an ally player can use this tool on a stock game?
Former War in the Pacific Test Team Manager and Beta Tester for War in the East.

Image
User avatar
wworld7
Posts: 1726
Joined: Tue Feb 25, 2003 2:57 am
Location: The Nutmeg State

RE: Why using a DB with integrity constraints is usefull

Post by wworld7 »

ORIGINAL: Kid

I don't have time to read the entire thread so can someone tell me if an ally player can use this tool on a stock game?


Kid,

From what I read it is only for the evil empire at present. Stay tuned for further details.

Flipper
Flipper
User avatar
siRkid
Posts: 4177
Joined: Tue Jan 29, 2002 10:00 am
Location: Orland FL

RE: Why using a DB with integrity constraints is usefull

Post by siRkid »

ORIGINAL: flipperwasirish

ORIGINAL: Kid

I don't have time to read the entire thread so can someone tell me if an ally player can use this tool on a stock game?


Kid,

From what I read it is only for the evil empire at present. Stay tuned for further details.

Flipper

Thanks, I'll stay tuned. Maybe we could start somekind of movement to get a good guy version.[;)]
Former War in the Pacific Test Team Manager and Beta Tester for War in the East.

Image
User avatar
ny59giants
Posts: 9902
Joined: Mon Jan 10, 2005 12:02 pm

RE: Why using a DB with integrity constraints is usefull

Post by ny59giants »

Thanks, I'll stay tuned. Maybe we could start somekind of movement to get a good guy version.

He is working on an Allied version and should be on the shelves in time for Christmas. [:D][:D]
[center]Image[/center]
Martti
Posts: 237
Joined: Sat Apr 02, 2005 5:20 pm

RE: Why using a DB with integrity constraints is usefull

Post by Martti »

I just started a fresh scenario 15 (stock), saved the game immediately before changing anything and loaded it into WITPDecoder. Look what popped up:

The following leaders lead more than one (currently available) unit:
Maruyama, M.(IJ Army) 25th Division
2nd Division

No wonder the leader bugs appear early; apparently they are hardcoded into scenarios!
User avatar
treespider
Posts: 5781
Joined: Sun Jan 30, 2005 7:34 am
Location: Edgewater, MD

Cluster creation

Post by treespider »

Clusters -

I can get the program to recognize line -1 - The scenario name however none of my clusters appear in the table


Any suggestions?
Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910
User avatar
treespider
Posts: 5781
Joined: Sun Jan 30, 2005 7:34 am
Location: Edgewater, MD

RE: Cluster creation

Post by treespider »

In addition

After creating the cluster files, when I first start witpdecoder I receive an error:

"Couldn't set up a working DB template. Exiting.

I notice that a witp.lck file is created in the analysis folder and then erased whill the above is processing.

In addition my witp.* files are created normally.

If I click on witpdecoder a second time after the first failure and I leave the witp.* files that were created when I first tried to start the program, the program starts fine with the exception of not recognizing my clusters.
Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910
Woos
Posts: 277
Joined: Sun Jun 05, 2005 5:12 pm
Location: Germany

RE: Why using a DB with integrity constraints is usefull

Post by Woos »

ORIGINAL: viberpol

I have just noticed been informed about:

The following units have either no leader or a foreign one:
[Long list deleted]
I feel sorry for you having to click through all the pop-ups during reading in the save file. I expected that the most someone would get were maybe 5. Seems I have to add an "Ignore" button to save you from more pop-ups of the same type.

BTW, did you check all/some of the reported inconsistencies if witpDecoder is right? There are sure still bugs in it, like e.g.
ORIGINAL: viberpol
I wonder what does this part mean
TF7044
TF7086
TF7169
which displays a 7000 too high TF number.

Other questions:
* Pre-release of V0.3 with capabilities for Allies (although still lacking UI changes) will probably be available on Friday or the weekend. I'll be on a business trip for the next three days, so minimal fancyness must do.
* @treespider: If you get unexplainable errors during database initialization, look in the witpdecoder.log file, which should show you a more elaborate error report. Probably some syntax error in the clusterbases.csv file. You do have one, don't you? If you want to try again with an improved file, you have to remove the witp.* files to get witpdecoder to initialize its database again.

Sorry, no more support since ... see above.

User avatar
treespider
Posts: 5781
Joined: Sun Jan 30, 2005 7:34 am
Location: Edgewater, MD

RE: Why using a DB with integrity constraints is usefull

Post by treespider »

* @treespider: If you get unexplainable errors during database initialization, look in the witpdecoder.log file, which should show you a more elaborate error report. Probably some syntax error in the clusterbases.csv file. You do have one, don't you? If you want to try again with an improved file, you have to remove the witp.* files to get witpdecoder to initialize its database again.

Sorry, no more support since ... see above.

Currently using this program on a PBEM where I am the Japanese.

Although I am not fluent in computer-eez the witpdecoder log file mentioned some error in line 91 and as as far as I could tell it was refering to the clusterbases.csv file.

When I checked Line 91 of the clusterbases.csv file I noticed that this was the start of a cluster controlled by the Allies.

Low and behold when I deleted all of the Allied controlled bases from my clusterbases file the program worked like a charm!

Note to users: Clusterbases can only have bases controlled by the Japanese when looking at a PBEM!!!
Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910
Woos
Posts: 277
Joined: Sun Jun 05, 2005 5:12 pm
Location: Germany

RE: Why using a DB with integrity constraints is usefull

Post by Woos »

ORIGINAL: treespider
Low and behold when I deleted all of the Allied controlled bases from my clusterbases file the program worked like a charm!

Note to users: Clusterbases can only have bases controlled by the Japanese when looking at a PBEM!!!
Since I never tested clusters using a PBEM savefile, I can't say that is impossible, but I still think it's unlikely. More probably one of the deleted lines had a syntax error or contained a non-existing baseID. But most importantly it is now working for you.
User avatar
viberpol
Posts: 858
Joined: Thu Oct 20, 2005 3:16 pm
Location: Global village, Poland, EU

RE: Why using a DB with integrity constraints is usefull

Post by viberpol »

ORIGINAL: Woos
ORIGINAL: viberpol

I have just noticed been informed about:

The following units have either no leader or a foreign one:
[Long list deleted]
I feel sorry for you having to click through all the pop-ups during reading in the save file. I expected that the most someone would get were maybe 5. Seems I have to add an "Ignore" button to save you from more pop-ups of the same type.

BTW, did you check all/some of the reported inconsistencies if witpDecoder is right? There are sure still bugs in it, like e.g.
ORIGINAL: viberpol
I wonder what does this part mean
TF7044
TF7086
TF7169
which displays a 7000 too high TF number.


Yes, Woos, I did check that list, it seems mostly right, however I cannot say that the ALL occurencies were reported right. This is a hell long list.. [:)]

BTW: it's a long played game, updating from 1.6 patches forward to 1.804, so...
It can happen, bur really -- the "ignore" button would be a nice addition. [;)]

EDITED: It shows not only commanders in active ships but these in the pipeline as well.
See: Yahagi, she has the Allied commander (Craven) and is not ready yet..

Tried to figure out how the leader tab works out..
And must say, I am confused, because cannot find in the real game the leaders queried.
Was looking for an air IJN squadron leader with air and aggresivenes ratings.
So: Air Unit, IJNavy, air:5, aggr:5 found: Mori S. 77/88
But I cannot find him when trying to change the fighter squadron unit.
Morover, some of them are said to be leading SHIPS..
confused = is the query searches only for CAPTAINS?
Or is it possible that it shows leaders that are not actually (not yet? or killed?) in game?

Another case:
Trying to check the user created scenario (mod by AlaskanWarior for inconsistences).
Database seems to load just fine. But when opening the save file, the following exception occurs:

Couldn't write things to the DB due to
java.sql.SQLException: Numeric value out of range
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.ai.a(Unknown Source)
at de.retsiemuab.witpDecoder.d.a(Unknown Source)
at de.retsiemuab.witpDecoder.O.b(Unknown Source)
at de.retsiemuab.witpDecoder.b.a(Unknown Source)
at de.retsiemuab.witpDecoder.as.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
at de.retsiemuab.witpDecoder.B.a(Unknown Source)
at de.retsiemuab.witpDecoder.h.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.Y.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)


Any comments?
Przy lackim orle, przy koniu Kiejstuta Archanioł Rusi na proporcach błysł
Ursa MAior
Posts: 1414
Joined: Wed Apr 20, 2005 10:10 am
Location: Hungary, EU

RE: Why using a DB with integrity constraints is usefull

Post by Ursa MAior »

Amazing. Please help a lazy reader how to make the ind tab to work!
Image
Art by the amazing Dixie
User avatar
saj42
Posts: 1132
Joined: Tue Apr 19, 2005 12:02 pm
Location: Somerset, England

RE: Why using a DB with integrity constraints is usefull

Post by saj42 »

I'm playing Scen 157. Everything works fine except the Industry tab. I see the spoilage stats but no data in the main industry section - it says no clusters found. OK I must be doing something stupid with something that should be so simple.

I'm using clusters 1 to 11 (Japan to India from sample in the install) and edited the clusterbases file to get the correct base IDs from the witploc file. Still no joy.
'spose I'll just keep trying 'til it works.
Image
Banner by rogueusmc
User avatar
treespider
Posts: 5781
Joined: Sun Jan 30, 2005 7:34 am
Location: Edgewater, MD

RE: Why using a DB with integrity constraints is usefull

Post by treespider »

ORIGINAL: Tallyho!

I'm playing Scen 157. Everything works fine except the Industry tab. I see the spoilage stats but no data in the main industry section - it says no clusters found. OK I must be doing something stupid with something that should be so simple.

I'm using clusters 1 to 11 (Japan to India from sample in the install) and edited the clusterbases file to get the correct base IDs from the witploc file. Still no joy.
'spose I'll just keep trying 'til it works.


Woos said it wasn't the case-- but once i eliminated the bases that I didn't control from my clusterbases file it worked fine.
Here's a link to:
Treespider's Grand Campaign of DBB

"It is not the critic who counts, .... The credit belongs to the man who is actually in the arena..." T. Roosevelt, Paris, 1910
Ursa MAior
Posts: 1414
Joined: Wed Apr 20, 2005 10:10 am
Location: Hungary, EU

RE: Why using a DB with integrity constraints is usefull

Post by Ursa MAior »

ORIGINAL: Tallyho!

I'm playing Scen 157. Everything works fine except the Industry tab. I see the spoilage stats but no data in the main industry section - it says no clusters found. OK I must be doing something stupid with something that should be so simple.

I'm using clusters 1 to 11 (Japan to India from sample in the install) and edited the clusterbases file to get the correct base IDs from the witploc file. Still no joy.
'spose I'll just keep trying 'til it works.


How do you create clusters? You need clusters to make industry tab work?
Image
Art by the amazing Dixie
Woos
Posts: 277
Joined: Sun Jun 05, 2005 5:12 pm
Location: Germany

RE: Why using a DB with integrity constraints is usefull

Post by Woos »

How do you create clusters? You need clusters to make industry tab work?

Please see the "Industry Tab" section in the documentation.

Most probable reason for it not working if you have created the respective files is a syntax error in one of the files.
Next most probable reason is that you didn't reinitialize the database after creating these files. Delete the witp.* files in the directory to do that and start witpDecoder then (Warning, you loose everything you have read into witpdecoder by that).

If you then still have problems, maybe you removed the "-1" entry from the clusters.csv file? That entry has to stay (see the doc, as I would like to add) but the text should of course be adapted.

BTW, did no one yet notice the glaring bug (so glaring that I didn't notice it for a week ;-) concerning the Industry tab: The last cluster is never displayed. Now how do I declare that a feature?

Concerning the leader list: Yes I also noticed some strange things there, but it basically simply takes the information stored in the save game. So if the save games says "can lead a plane" it is displayed by the leader tab in that category. If the game uses someone like that to captain a ship, there is nothing I can do about (but I will check for bugs once I got the Allies working because I also have seen the "no where to be found" effect).
User avatar
siRkid
Posts: 4177
Joined: Tue Jan 29, 2002 10:00 am
Location: Orland FL

RE: Why using a DB with integrity constraints is usefull

Post by siRkid »

Hey Pry is updating the data base and I was thinking that maybe this tool could be of some use. Now I don't fully understand how it work but from reading some of these post it looks like it can be used to verify some database info. Anyone know if Pry is using it?
Former War in the Pacific Test Team Manager and Beta Tester for War in the East.

Image
Post Reply

Return to “War In The Pacific - Struggle Against Japan 1941 - 1945”