adventurelookup icon indicating copy to clipboard operation
adventurelookup copied to clipboard

Published 20 hours ago • verified publisher icon petertrotman

Starter data set to use for development

Open petertrotman opened this issue 8 years ago • 8 comments

In order to help with the development of components that interact with the data, we could really do with a starter set of data.

I'm going to go ahead and create some dummy information, but it would be really useful if someone would take the time to create a few records (10-20) which contain all of the information described in the DB schema as indicated here:

https://docs.google.com/document/d/1ZYi8-XMcvkivsAJZizaNADNl2dpC3zb8yEJVsNNZFlA/edit

Let me know if you can help!

petertrotman avatar Sep 12 '16 12:09 petertrotman

I've got some spare time these days. How would you like the records written up?

Btw: I have pretty limited development experience, mostly with VBA and SQL in MS Access. It's nothing to write home about, but enough to understand most of what's going and to google the rest.

jtannas avatar Oct 12 '16 05:10 jtannas

JSON or YAML is probably best.

whonut avatar Oct 12 '16 06:10 whonut

I'll go with JSON. I'm slapping together an Access DB to (mostly) mimic the data structure in the UX document, then using CSV-to-JSON to generate the data.

Any objections? Things I should know?

jtannas avatar Oct 14 '16 04:10 jtannas

Day 1 of Progress: AdventureLookupSampleData.zip

Notes:

  • Initial Structure complete & ready for comment
  • The Setting/Environment relationship is fuzzy right now. It feels like it needs a region field in there (e.g. Setting="Forgotten Realms", Region="Sword Coast", Environments="Coastline, Woodlands, Grassland, Harbor, City, etc..."
  • Editions Added
  • 700+ races added
  • 16 publishers
  • 24 Settings

jtannas avatar Oct 14 '16 06:10 jtannas

The JSON data is here. Sorry about the delay. I got distracted by other projects, so not much data entry is done yet. I threw in some dummy data to get at least 5 sample records, and more actual data should be in soon.

Day 2 of Progress: AdventureLookupSampleData.zip

Notes:

  • Dumped out a sample of the adventure summary data into a csv and a json file (included)
  • Revised the data structure to add regions, multiple environments
  • Merged the NPC & Monster tables, using a field to distinguish between them.
    When you get down to it monsters are also NPCs, so the data structures seem to be about the same
  • Added a data entry form for my own convenience

jtannas avatar Oct 18 '16 06:10 jtannas

Update 3: Up to 10 entries AdventureLookupSampleData.zip

jtannas avatar Oct 19 '16 06:10 jtannas

Hey @jtannas it looks great - thanks a lot! I can sort of use .accdb files with a tool that I found, but it would be easier to work with in another format. Is there any way to export the database to .sql or a series or .csv files?

petertrotman avatar Oct 19 '16 08:10 petertrotman

adventure lookupSampleDataCSV.zip

Hey I saw your request for .csv files. I went ahead and just exported the data in his sample as csv files. Some of them are empty. Hope that helps.

melkor220 avatar Oct 19 '16 18:10 melkor220