each book needs to have a setting that specifies which publication the items were originally published in, if at all.

For each book, create a page where you can view the puzzles included in that book

Load the app

It downloads the puzzles and the publications and the scripts and such and displays information depending on what you click on.

For each publication, you should be able to go to a page that shows just the puzzles from that publication.

/api/puzzles - list all puzzles
/api/publications - list of all publications

Once there is a Google Sheet created that contains all of the puzzles (see #2), create a Cloud Function that can read in that sheet and import the data into Cloud Firestore.

variety_puzzles collection:

• name: title of the puzzle (string)
• publication: where it was originally published (publication_id)
• publication_date: when it was originally published (date)
• page_link: link to the puzzle page, if it's still available
• puzzle_link: link to the puzzle document for direct download, if available
• answer_link: link to the puzzle answer document, for direct download, if available

publications collection:

• id: publication index, auto-increment
• name: name of the publication
• link: link to the publication (if available)
• description: detailed description

books collection:

• id: book index, auto-increment
• name: title of the book
• isbn: isbn of the book
• status: in print? out of print?
• link: link to purchase book, if available
• description: description of the book

Admins should be able do the following tasks:

• List the existing users
• View an individual user to see their profile
• Make a user an admin or remove admin access for a user
• Disable a user so they can't login anymore
• Delete a user

• One tab with all the Atlantic Puzzler puzzles, numbered, with issue dates and links where available
• One tab with all the WSJ puzzles, numbered, with issue dates and links
• One tab for each of the Atlantic Puzzler books, numbered and referencing the main Atlantic index

Currently, we have a well-organized archive of many of the hex puzzles from 1997-1995 with most of the puzzles and solutions scanned from the pages of The Atlantic.

Google Drive is a great way to collect these files and organize them, but we need a way to store the archive files so they can be served easily from a website and converted to images and such.

For this, we need a way to sync the files from Drive to Cloud Storage.

To do this, we can use a Cloud Function.

The cloud function should first collect a lit of all the files within the following Google Shared Drive Folder:

https://drive.google.com/drive/folders/16gAEPIqARsXaHjtzhZUBrZgJwqVl2utN

Within there, there is a folder for each year from 1977-2009. Within each folder there is are several files, but the two we care about area:

• YYYY-MM-DD Puzzle Title.pdf (puzzle)
• YYYY-MM-DD Puzzle Title (solution).pdf (solution)

Once we have the list, for each puzzle, we should also get the list of all puzzles from firestore. That will allow us to verify the puzzle information is accurate before we store it. We may want to store the files using the ID from the database instead of the name from firestore?

We should store PDFs, but for each file, we probably also want to have the PNG files and thumbnails. Use the puzzle ID for all of these?

We will also need a report that shows what we have and don't have so we can complete the archive.

On the puzzle list, there is a column that shows the publication but it's not currently clickable.