I wasn't sure what to title this, but I've been working on an excel spreadsheet that contains information about not only wads, but the maps within those wads. I wanted a way to be able to quickly load up maps by a particular author, or in a particular series. Thus began a pretty lengthy cataloguing process.
This excel file (download link: http://s000.tinyupload.com/index.ph...200761099277648) contains the results of the first 1000+ wads that I've catalogued.
How to use the search:
Searching currently only filters the map tab - just type in whatever you want to the search box and it will filter based on that. It looks for inclusion, not exact matches. So doom would match to doom, doom 2, doom the way id did, etc. You can be more specific by using "" ie. "doom the way id did" would only find those maps.
You can use - to filter your results. ie ("ultimate doom" -romero) would result in all the ultimate doom maps that romero did not do.
You can use + to force a field. ie ("doom 2" + romero) would only result in the "doom 2" matches that romero is involved in.
You can use +/- with "", but you need to enclose the +/- inside the quotes. ie. "+doom 2"
If you want to use the batch file stuff to launch maps, the info is below. If you just want to see who built what, use the stuff above.
How this works:
1) Click the button in the "Main" tab to search for map criteria (implemented to check the map tab only, and far from perfect, see below) in order to generate a list of maps.
2) This list copied into a "results" tab, which you can then order or adjust as you like.
3) Press the "generate batch file" button on the main tab and that creates a list of batch files.
4) Copy into a text file and run as a batch. (Assuming you have correctly inputted your port path and skill level on the "main" tab.)
To run a series like the Odessa series, for example, you would search for all the Odessa maps, and the batch file will automatically load each wad appropriately and direct you to the correct map.)
Stuff about the batch file generator: I forgot to mention that the batch info that is generated works under the assumption that the batch file is in the parent folder, and that the parent folder contains all the wads. I have my own file structure for storing wads, but as I work through them to add them to this db, I copy the .wad file into a separate folder where I store the batch.
EDIT: An important assumption that is made with the batch files is that the wads are all stored in a single directory (at least the ones that you are referencing), AND that a sub-directory holds the ports.
In other words, to get this working I have copied out wads into a DoomWads folder, and inside of that folder have placed my port installs. You could also use shortcuts I think. So far if you include all the listed wads and the three source ports, the directory is about 4 gigs.
Things I'm still working on:
More maps / wads. There are obviously thousands more maps, if not wads, to go. I should also probably include vanilla / limit removing compatibility (as well as other source port specific stuff).
Better search functionality. Searching the wads as well.
Better implementation of port selection.
Putting this into an actual DB and then building a front end off of that, either some kind of launching program or some kind of web based thing. But that's a long way away.
Last edited by 7hm on Sep 6 2016 at 17:44