CTHUB - ARC File Upload - Githubissues

bcgov / cthub

Apache License 2.0

1 stars 5 forks source link

CTHUB - ARC File Upload #294

Open shayjeff opened 1 month ago

shayjeff commented 1 month ago

Describe the task Add the ARC data file to CTHUB.

Purpose The purpose of this task is to enable the business area the ability to uploading ARC data by into CTHUB.

Acceptance Criteria

[ ] Add ARC to upload dropdown so that it appears in Metabase
[ ] User should get error if cell value is not in the "Values" list.
[ ] User should get get an error if values are missing in a column where missing values are not allowed.
[ ] User should get an error if the value is not numeric.

Development Checklist:

[ ] New tables to contain ARC data and region data (joined)
[ ] Create service for upload
[ ] Keep in mind the region field will come in as a string but will need to be split up if it contains more than one, joined to the region table (get_or_create)

Additional context

Not sure if the user should get datetime errors for date columns
Economic Region: Not sure how Across BC value would work. What if one person selects all economic regions of BC and another person chooses Across BC.

katerinkus commented 1 week ago

@shayjeff I have added details about ARC to the card and it is ready to go.