"SJG IDs" instead of Pyramid Names in Pyramid 3 Bundle

[Extrarius]

I just bought the pyramid 3 bundle and was excited to go read some articles I'd been looking forward to only to find that the issues in the zip file are named in a way that is nonsense to me. I did figure out that you can decipher the number to get the issue number, and I was a tiny bit less frustrated until I started unzipping the sub zips to find the internals of those follow a completely different scheme (having the issue number plainly along with the title).

I'd find the bundle infinitely easier to use if the contents were named like individual pyramids instead of SJG IDa that mean nothing to me. Having to open each file to get the title in order to name the sensibly is a lot of work to put on every customer

[Pragmatic]

Not sure how much this will help (given what you describe), but now that you have the Pyramid 3 bundle:

Link to Pyramid 3 Index on the SJ Games forum

[ravenfish]

Huh. I'm glad I acquired the Pyramid pdfs piecemeal. SJGames has always taken a decidedly minimalist approach with online selling, but this takes the cake. If I paid good money for a large set of electronic book files, and found that the seller couldn't even be bothered to label them, I would be looking for ways to get a refund.

[Extrarius]

I eventually wrote a python script to extract them how I like:

import re
import zipfile
import os

#Names of all 122 issues of Pyramid 3
pyramid_names = [
    "Tools of the Trade: Wizards",
    "Looks Like a Job for... Superheroes",
    "Venturing Into the Badlands: Post Apocalypse",
    "Magic on the Battlefield",
    "Horror & Spies",
    "Space Colony Alpha",
    "Urban Fantasy",
    "Cliffhangers",
    "Space Opera",
    "Crime and Grime",
    "Cinematic Locations",
    "Tech and Toys",
    "Thaumatology",
    "Martial Arts",
    "Transhuman Space",
    "Historical Exploration",
    "Modern Exploration",
    "Space Exploration",
    "Tools of the Trade: Clerics",
    "Infinite Worlds",
    "Cyberpunk",
    "Banestorm",
    "Action Adventures",
    "Bio-Tech",
    "Epic Magic",
    "Underwater Adventures",
    "Monsters in Space",
    "Thaumatology II",
    "Psionics",
    "Spaceships",
    "Monster Hunters",
    "Fears of Days Past",
    "Low-Tech",
    "Alternate Gurps",
    "Aliens",
    "Dungeon Fantasy",
    "Tech and Toys II",
    "The Power of Myth",
    "Steampunk",
    "Vehicles",
    "Fantasy World Building",
    "Noir",
    "Thaumatology III",
    "Alternate Gurps II",
    "Monsters",
    "Weird Science",
    "The Rogue's Life",
    "Secret Magic",
    "World-Hopping",
    "Dungeon Fantasy II",
    "Tech and Toys III",
    "Low-Tech II",
    "Action",
    "Social Engineering",
    "Military Sci-Fi",
    "Prehistory",
    "Gunplay",
    "Urban Fantasy II",
    "Conspiracies",
    "Dungeon Fantasy III",
    "Way of the Warrior",
    "Transhuman Space II",
    "Infinite Worlds II",
    "Pirates and Swashbucklers",
    "Alternate GURPS III",
    "The Laws of Magic",
    "Tools of the Trade: Villains",
    "Natural Magic",
    "Psionics II",
    "Fourth Edition Festival",
    "Spaceships II",
    "Alternate Dungeons",
    "Monster Hunters II",
    "Wild West",
    "Hero's Jackpot",
    "Dungeon Fantasy IV",
    "Combat",
    "Unleash Your Soul",
    "Space Atlas",
    "Fantasy Threats",
    "Horrific Creations",
    "Magical Creations",
    "Alternate GURPS IV",
    "Perspectives",
    "Cutting Edge",
    "Organizations",
    "Low Tech III",
    "The End Is Nigh",
    "Alternate Dungeons 2",
    "After the End",
    "Thaumatology IV",
    "Zombies",
    "Cops and Lawyers",
    "Spaceships III",
    "Overland Adventures",
    "Tech and Toys IV",
    "Strange Powers",
    "Welcome to Dungeon Fantasy",
    "Death and Beyond",
    "Pyramid Secrets",
    "Humor",
    "Epic",
    "Setbacks",
    "Dungeon Fantasy Roleplaying Game",
    "Cinematic Magic",
    "Dungeon Fantasy Roleplaying Game II",
    "Monster Hunters III",
    "Dungeon Fantasy Roleplaying Game III",
    "Thaumatology V",
    "Deep Space",
    "Combat II",
    "Action II",
    "Dungeon Fantasies",
    "Mind Over Magic",
    "Technomancer",
    "Locations",
    "Hot Spots",
    "Dungeon Trips",
    "After the End II",
    "Alternate GURPS V",
    "Travels and Tribulations",
    "All Good Things",
]

#Replace colons with a dash to be windows-friendly
colon_pattern = re.compile(r'''\s*:\s*''')
pyramid_names = [colon_pattern.sub(" - ", name) for name in pyramid_names]

#Pattern of zip entries to extract number and type
file_pattern = re.compile(r'''^SJG37-2([67]\d\d)\.(pdf|zip)$''', re.IGNORECASE)

def extract(zz, src, dest):
    path = os.path.dirname(dest)
    if path and not os.path.isdir(path):
        os.makedirs(path)
    with zz.open(src) as sfp:
        with open(dest, "wb") as dfp:
            dfp.write(sfp.read())

if not os.path.isdir("Pyramid 3"):
    os.mkdir("Pyramid 3")

with zipfile.ZipFile("Pyramid_Volume_3_Bundle.zip") as zz:
    for item in zz.infolist():
        m = file_pattern.match(item.filename)
        if not m:
            print("ERROR:", item)
            continue
        num = int(m.group(1)) - 600
        if m.group(2).lower() == "pdf":
            extract(zz, item, os.path.join("Pyramid 3", f"{num} - {pyramid_names[num - 1]}.pdf"))
        elif m.group(2).lower() == "zip":
            extract(zz, item, os.path.join("Pyramid 3", f"{num} - {pyramid_names[num - 1]}.zip"))
        #print(num, ")", item, "=", pyramid_names[num - 1], "|", m.group(1).lower())

Put it in the same folder as the "Pyramid_Volume_3_Bundle.zip" and it'll extract everything into a "Pyramid 3" folder with correct names. It doesn't unzip the contained zip files, so you have to do that step manually but there are only a few.

[Blind Mapmaker]

I applaud your efforts, Extrarius. That's a really nice way of helping the community.

As for the supposed "minimalist approach", I got to say that I've only seen this problem with bundles and special stuff like Kickstarters and then only with some files. At least the Warehouse doesn't drop like every fourth download like DriveThruRPG. And let's not forget that minimalist means no blasted DRM either.