FORMS-134: (Submitter) Submit multiple forms via file upload

User Story description:

As a Submitter (i.e., Health Authority user), I would like to be able to submit forms in batch via a file upload functionality in order to save a significant amount of time when I have to submit data for multiple facilities/operators.

This Story focuses on the submission only.

Once authenticated, a submitter should be able to select a form to which they have access, and then decide to submit this form either manually or, if the option is available, via file upload.
Once the file upload selected, the user can download the template for the submission
Once the user has filled out the file, they can now submit it using the “browse“ button to select the file or they can also simply drag and drop the file into the dedicated area on the screen.
Once the file pre-loaded, the user can confirm their submission by clicking the “submit“ button.
From there, the file will be parsed and validated using the validation rules defined by the form designer on each field. Every row within the file will be the equivalent of one form submission.
During the import and validation, the user is prompted with a loading screen
Once the validation completed, a message will appear on the user screen indicating the Successful file processing or the Failed file processing, in which case a validation report will be available for download. If the import was successful, then the user will see the current status of their submission to be “Review pending“
The validation report will point out the different issues found within the files (e.g. First name missing, must be provided. Or, Incorrect format for birthdate, format must be yyyy-mm-dd)

Business Rationale:

top page

Currently, Health Authorities gather data from multiple facilities/operators to then submit this data to the Ministry of Health.

It is important for the Health Authorities to gather this data first as it feeds their own system. The current issue is that the HAs have no easy way to submit the data to the Ministry of Health. They can only do so through time consuming and painful manual form entries. As a solution they would like to have the ability to make batch submissions through a file upload functionality.

Dependencies:

top page

[List potential dependencies with other User Stories or Tasks]

#	Task or User Story	Type of Dependency
21	FORMS-208: (Admin) Allow File Submissions for Forms	Parent
56	#56: (Submitter) Upload a File as a Submission
57	FORMS-209: (Reviewer) Identify forms that were part of the same file submission	Parent

Technical Details:

top page

Questions:

Is it an all or nothing import? If one issue is found on one record, do we still insert the other valid records? All or nothing yes.
Do we accept only .csv files or also .xlsx files? XLSX would allow for cleaner uploads with advanced layout within Excel to better control input
Do we limit the size of the file?

Acceptance Criteria:

top page

[List the Acceptance Criteria]

#	Description	Notes
1	I can choose to submit data using file upload	The option should be offered to the user
2	I can browse my files or drag and drop the file I wish to upload	.csv format only. Other formats will be rejected instantly
3	I can click on submit and see my file being processed	loading screen while file is processed
4	I can view the outcome of the processing of my file either via a “File Successfully Imported“ message or via a “File Could Not be Imported“ message
5	If my file is rejected, I can download the Validation Report to consult the details of the errors

Prototype/Mockups

top page

Provide high fidelity prototype or mockoup

Out of Scope:

top page

The setup of a file upload from the perspective of the form designer is not part of this User Story
The review and validation of a file submission is not part of this User Story

Contact(s):

top page

This User Story is primarily built for the LTC

Table of Contents