Starter data set to use for development

[petertrotman]

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!

[jtannas]

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.

[whonut]

JSON or YAML is probably best.

[jtannas]

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]

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]

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]

Update 3: Up to 10 entries AdventureLookupSampleData.zip

[petertrotman]

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?

[melkor220]

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.