Add date to file uploads #69

New issue

Closed

opened 2026-07-08 21:33:47 +00:00 by eliribble · 0 comments

eliribble commented

2026-07-08 21:33:47 +00:00

Owner

Currently the fileupload.file table has a created column which tracks when the file was uploaded. We want to add a new column, date, which is meant to be the date to use when interpreting the file. For example, a file may have been created in previous years and the data may have been valid at that time. We still mark that the file was created when the system receives it, but the "date" of the file is when the data within the file is valid.

As part of this we'll need to augment the API for creating file upload resources to require the "date" field. We'll also need to update the UI for doing file uploads so that it defaults to today's date, but allows the user to set the date to an arbitrary value.

Currently the `fileupload.file` table has a `created` column which tracks when the file was uploaded. We want to add a new column, `date`, which is meant to be the date to use when interpreting the file. For example, a file may have been created in previous years and the data may have been valid at that time. We still mark that the file was created when the system receives it, but the "date" of the file is _when the data within the file is valid_. As part of this we'll need to augment the API for creating file upload resources to require the "date" field. We'll also need to update the UI for doing file uploads so that it defaults to today's date, but allows the user to set the date to an arbitrary value.