Submarine Reporter for Excel 2010 BETA 1.3 UPDATED 10/28/2011

[rcm1616]

ORIGINAL: cantona2

Thanks for the effors guys

I got the tool to load and work properly I think. The date of last loaded is 30/11/42, last date in game vs Herb. However all the fields are empy and there are no records at all. Does this work like Tracker where you see nothing in the first turn you load but yes thereafter? One more dumbass question, do I have to import records manually at every turn like we update in Tracker?

Records are visible directly after every new load (turn or multiple turns - depends on which kind of import you choose)
Are you sure, that you have correctly set from/to dates? There is no date validation in scripts, so it's possible to set dates incorrectly. Last time, I have set from date: 7/12/42 and to date: 31/12/41 everything looks fine.
Program seems run correctly, but no record imported... Maybe you've made same mistake.

[michaelm75au]

ORIGINAL: bk19@mweb.co.za

ORIGINAL: saw

Not having any luck with this in open office either. No buttons (have Macros enabled under tools setting).

Any ideas? Looks like a great tool.

Sorry I don't have OpenOffice installed. I am surprised by your posting though. I had understood that this product pretty much covered much of what was in the Office suite.

The VB code seems to be commented out when I loaded it into OpenOffice.
Maybe it is the version of excel you have built it under. OO might not be fully enabled for newer Excels - from memory it shows 2007 in its save list.

I actually managed to get it to restore the VB code in OO 3.3 but it complains about syntax errors on some of the VB code.

[rjopel]

I keep getting the same error when I try and run it.

When trying to import a single record

Run-time error "53":

File not found


When Import from Archive

Run-time error "13":

Type mismatch

[cantona2]

ORIGINAL: rcm1616

ORIGINAL: cantona2

Thanks for the efforts guys

I got the tool to load and work properly I think. The date of last loaded is 30/11/42, last date in game vs Herb. However all the fields are empty and there are no records at all. Does this work like Tracker where you see nothing in the first turn you load but yes thereafter? One more dumbass question, do I have to import records manually at every turn like we update in Tracker?

Records are visible directly after every new load (turn or multiple turns - depends on which kind of import you choose)
Are you sure, that you have correctly set from/to dates? There is no date validation in scripts, so it's possible to set dates incorrectly. Last time, I have set from date: 7/12/42 and to date: 31/12/41 everything looks fine.
Program seems run correctly, but no record imported... Maybe you've made same mistake.

Indeed I did. I have it working now [&o]

[saw]

Thanks, for the info. Probably will try to load into into EXCEL on my work laptop and then back save it to an earlier version for use in open Office.

[PaxMondo]

ORIGINAL: cantona2

ORIGINAL: rcm1616

ORIGINAL: cantona2

Thanks for the efforts guys

I got the tool to load and work properly I think. The date of last loaded is 30/11/42, last date in game vs Herb. However all the fields are empty and there are no records at all. Does this work like Tracker where you see nothing in the first turn you load but yes thereafter? One more dumbass question, do I have to import records manually at every turn like we update in Tracker?

Records are visible directly after every new load (turn or multiple turns - depends on which kind of import you choose)
Are you sure, that you have correctly set from/to dates? There is no date validation in scripts, so it's possible to set dates incorrectly. Last time, I have set from date: 7/12/42 and to date: 31/12/41 everything looks fine.
Program seems run correctly, but no record imported... Maybe you've made same mistake.

Indeed I did. I have it working now [&o]

+1

[rcm1616]

ORIGINAL: rjopel

I keep getting the same error when I try and run it.

When trying to import a single record

Run-time error "53":

File not found


When Import from Archive

Run-time error "13":

Type mismatch

Do you have last version 1.1a?

[bk19@mweb.co.za]

ORIGINAL: saw

Thanks, for the info. Probably will try to load into into EXCEL on my work laptop and then back save it to an earlier version for use in open Office.

Hi, I am busy with a software patch for this at the moment. I have done exactly the same as you intended and saved the file as a *.xls file. This triggered some failures which I have now programmed around, although with a small cost in performance during initial database construction time. Fortunately this step is a once off so things could have been worse. It is the fastest of three different approaches I took. If there is a faster one, I have not found it yet.

A second problem exists in the Pivotable definitions. Apparently something in this definition is not portable to earlier versions. I have no idea what that is exactly. I am trying to finger the precise cause of this complaint at the moment.

Once that is done I intend to install OpenOffice and investigate Michaelm's observation that the macro code is all commented out (disabled).

[rcm1616]

ORIGINAL: bk19@mweb.co.za

ORIGINAL: saw

Thanks, for the info. Probably will try to load into into EXCEL on my work laptop and then back save it to an earlier version for use in open Office.

Hi, I am busy with a software patch for this at the moment. I have done exactly the same as you intended and saved the file as a *.xls file. This triggered some failures which I have now programmed around, although with a small cost in performance during initial database construction time. Fortunately this step is a once off so things could have been worse. It is the fastest of three different approaches I took. If there is a faster one, I have not found it yet.

A second problem exists in the Pivotable definitions. Apparently something in this definition is not portable to earlier versions. I have no idea what that is exactly. I am trying to finger the precise cause of this complaint at the moment.

Once that is done I intend to install OpenOffice and investigate Michaelm's observation that the macro code is all commented out (disabled).

I found interesting, maybe useful tool for migrating to OOffice. Look here: http://www.business-spreadsheets.com/vba2oo.asp

If you are able to port data import scripts to earlier version of excel, pivot tables definitions are no big deal . It can be done manually (in 20-30 minutes).

[rjopel]

ORIGINAL: rcm1616

ORIGINAL: rjopel

I keep getting the same error when I try and run it.

When trying to import a single record

Run-time error "53":

File not found


When Import from Archive

Run-time error "13":

Type mismatch

Do you have last version 1.1a?

I downloaded 1.1a and am trying to loac from archive from 7 Dec to 31 Dec. I've tried 7/12/1941 to 31/12/1941 and the all of 42 and I only get 8 ships and multiple
Run time error "70"
Permisison denied

errors

[rcm1616]

Do you have last version 1.1a?

[/quote]

I downloaded 1.1a and am trying to loac from archive from 7 Dec to 31 Dec. I've tried 7/12/1941 to 31/12/1941 and the all of 42 and I only get 8 ships and multiple
Run time error "70"
Permisison denied

errors
[/quote]

Try to click Debug on error window, then press F5 in debugging window, program will continue to run.

If i'm not wrong, its problem caused by script trying to create temporary file with same name as existing which may be deleted, but filesystem didn't make it in time. (slower HDD, or disk may be busy with reading/writing something else)

Or try to load from archive only one or few day at once. I know, that's no solution, but kind of workaround...
I will try fix this bug later.

[rjopel]

ORIGINAL: rcm1616



Do you have last version 1.1a?

I downloaded 1.1a and am trying to loac from archive from 7 Dec to 31 Dec. I've tried 7/12/1941 to 31/12/1941 and the all of 42 and I only get 8 ships and multiple
Run time error "70"
Permisison denied

errors
[/quote]

Try to click Debug on error window, then press F5 in debugging window, program will continue to run.

If i'm not wrong, its problem caused by script trying to create temporary file with same name as existing which may be deleted, but filesystem didn't make it in time. (slower HDD, or disk may be busy with reading/writing something else)

Or try to load from archive only one or few day at once. I know, that's no solution, but kind of workaround...
I will try fix this bug later.

[/quote]

I got that to work with th F5 command. I did notice as it loads it starts out as DDMMYY and then switches to MMDDYY on the 13th. The Combat Reports tab then shows me hitting a sub on Oct 12 41 (10/12/1941) YYYY/M = 1941/10

I suspect this messes with my monthly totals.

[rcm1616]

[/quote]

I got that to work with th F5 command. I did notice as it loads it starts out as DDMMYY and then switches to MMDDYY on the 13th. The Combat Reports tab then shows me hitting a sub on Oct 12 41 (10/12/1941) YYYY/M = 1941/10

I suspect this messes with my monthly totals.
[/quote]

I'm sorry rjopel. Version I have uploaded last time was not 1.1a. Please try download it again. There are implemented some improvements from Bruce, which solved problem with incorrect format of date.

[bk19@mweb.co.za]

ORIGINAL: rjopel
I got that to work with th F5 command. I did notice as it loads it starts out as DDMMYY and then switches to MMDDYY on the 13th. The Combat Reports tab then shows me hitting a sub on Oct 12 41 (10/12/1941) YYYY/M = 1941/10

I suspect this messes with my monthly totals.

This change in the date format is not a good sign at all. Did you change the default system data format? Have you run the game on different computers where the default date format was different?

You now have me wondering whether a programmatic solution exists to detect this change and normalise the date format to a consistent form automatically.

[rjopel]

I have not changed the default date format from "English (United States)" M/d/yyyy

I don't have a another computer to test on.

[nashvillen]

rjopel: you could just send me your data, I will look at it on my computer... [:D]

[rjopel]

Fat chance you Jap spy.

[bk19@mweb.co.za]

Ropel,

I have just PM'd you with some info.

Please check your mailbox.

[nashvillen]

I have loaded the SubmarineReporter_B11a, made the settings as they should be, turned on macros. All I can load is the last day's Allied sub kill (6/4/1943). I have tried to load other allied days and other japanese days with nothing loading. When I do an archive load, there will be a small window flash, then it jumps to the combat reports tab with no data.

I have no error messages. What am I missing, please?

[rcm1616]

ORIGINAL: nashvillen

I have loaded the SubmarineReporter_B11a, made the settings as they should be, turned on macros. All I can load is the last day's Allied sub kill (6/4/1943). I have tried to load other allied days and other japanese days with nothing loading. When I do an archive load, there will be a small window flash, then it jumps to the combat reports tab with no data.

I have no error messages. What am I missing, please?

Check from/to dates. It's looks like incorrect date settings.