Tools to import data

[dlebauer]

LOW PRIORITY UNTIL THERE IS A USE CASE!

Goal

Enable ingestion of new datasets

Steps

• update spreadsheet template to match current schema
• create a tool that will add data curated in that template into the data-raw/*/*csv files

Approach

(not set in stone, but current thinking)

• use googlesheets4 to read directly from google sheets
• map natural keys (defined in template README) to foreign keys
• any other changes
• validation checks
• append to tables

Requirements

• Functions
• Tests
• Documentation (Data Entry Vignette)