Scenario Database

[MarkSheppard]

Started this little database to make finding interesting scenarios easier for everyone - all the scenarios are in now.

version 1.0 is attached as an XLS file, which just about any serious spreadsheet program can use; from there, it's just a matter of sorting the data to bring what you'd like to the top.

It's arranged like so:

Slot No--------------Title--------------------------------Battle/Front--------------Date------------Side 1----------Side 2---------Best Played As
36---------Goering Regiment at Uman---------Eastern Front 1941---------08/02/41---------Soviet---------German---------Germans
8---------------Dickens I Hill 445 -----------------------Italy 1944-------------03/15/44---------ANZAC------German
37--------Valentine's Day Air Mail-------------Pacific Theatre 1942--------02/14/42---------Japan---------Dutch
39-------------Bloody Ridge-----------------------Guadalcanal 1942---------09/13/42---------Japan---------USMC


So if you only want to look for eastern front battles, just sort column C alphabetically, and look for the row of eastern front battles. You could then add a secondary sorting feature to sort them by "best as" to find those scenarios best played as either germans or soviets easily.

[dlazov]

Mark,

Thanks!

Once your done could you repost or update?

[MarkSheppard]

I just updated it, so far 227 out of 359 are in

[dlazov]

Mark,

Cool, your smoking....

104-236 are blank or you know that, sorry.

Once your done do you mind if I convert this to a SQL Server Database? I could make some snappy web pages on it.

I could not host it, but it would be cool to build it out in web format.

[MarkSheppard]

That's an excellent idea, an online web-based database of stock SPWW2 scenarios..

One of the problems I'm coming across is how to classify the scenarios; I don't want to get too specific; and I wonder if it's more appropriate to write:

"Poland 1944"
"Germany 1945"
"Hungary 1944"

than simply "Eastern Front 1944/45"

[Double_Deuce]

dlazov said:
Once your done do you mind if I convert this to a SQL Server Database? I could make some snappy web pages on it.

I could not host it, but it would be cool to build it out in web format.

I have access to a windows server but no little if anything about MsSQL. What about using MySQL? I have some Linux accounts with that available as well.

What would be needed to get this up and running online?

[MarkSheppard]

Version 1.0 uploaded; using it as a base here are some rough statistics, I didn't count every thing so this is sort of incomplete:

12 Scenarios dealing with the Arnheim (A Bridge too Far) Campaign

12 Scenarios dealing with the Balkans 1940-1944

4 Scenarios dealing with the Battle of the Bulge

3 Scenarios dealing with Burma 1942-1943

2 Scenarios dealign with China 1937-1944

3 Scenarios Dealing with Crete 1941

1 Scenario dealing with East Africa 1940

121 Scenarios dealing in one way or another with the Eastern Front 1941-1945

4 Scenarios dealing with Finland 1941-1944

25 Scenarios dealing with France 1940

2 Scenarios dealing with Guadalcanal 1942

4 Scenarios dealing with Hungary 1944-1945

3 Hypothetical scenarios set in Germany 1945, Gibraltar 1940, and Sweden 1940

4 Scenarios set in Italy 1943-1944

5 Scenarios dealing with Iwo Jima 1945

2 Scenarios Dealing with Kursk 1943

30 Scenarios Dealing with Normandy 1944 (and possibly France 1944)

26 Scenarios Dealing with North Africa 1940-1942

6 Scenarios dealing with Norway 1940

5 Scenarios dealing with the PTO from 1941-1942

2 Scenarios Dealing with the Phillipines 1941-1945

23 Scenarios dealing with Poland 1939

4 Scenarios dealing with Sicily 1943

4 Scenarios Dealing with the Spanish Civil War

8 Scenarios dealing with Stalingrad 1942

23 Scenarios dealing with the Western Front 1942-1945

3 Scenarios dealing with the Winter War

[Double_Deuce]

OK, its just a start and more can be added. My skills are limited so don't expect anything too fancy or complicated (I'm using a scripting program for this with some minor html editing).

I can envision a DB for WinSPMBT like this and ones for the campaigns for each version as well.

Anyone can edit this data at present so please don't play around in it too much. At some point I can add security levels (if we block visitor editing) and email notice whenever a file is edited. If we keep it open more or less then more people can plug stuff in and take off some of the workload.

Questions and comments are welcome.

WinSPWW2 Scenario Online Database

[PatG]

It looks great. Thanks for doing the work.

A "nice to have" would be to lock the official scenarios but allow users to add their own. If so extra columns to allow others to rate the scenarios, to list any special requirements(e.g. custom oobs) and to specify where to get the scenario would also be useful.

<edit>
maybe a wiki format?

[MarkSheppard]

Highly cool.

You know, adding the scenario descriptions to the database would only add what, 400 kb to them.

I'll put in scenarios 0-5's descriptiosn and then we can see if it's good or if it becomes too unweildy that way as viewed.