search

CSI4999Capstone / Memento-Health

Memento Health is an easy-to-use and secure web application dedicated to creating fully customizable forms to be used by healthcare professionals to assist in gathering, analyzing, and managing patient data.
GNU General Public License v3.0
0 stars 1 forks source link

Implement importing patients from an external system using a CSV file. #77

Closed yonimn2000 closed 3 years ago

yonimn2000 commented 3 years ago

Implement importing patients from an external system using a CSV file. It will live under Patients/Import.

You will need to create a view (or more) and the required actions (there's already a blank Import action under PatientsController).

Keep it simple. Suppose the input file has a header row and the columns in the following order (with a sample data row):

Patients.CSV

ExternalId,FullName,Birthday
Whatever234,John Doe,01/01/1900

Remember that the patient might not have an external ID. Then it is just null and you will have a row like this: ,John Doe,01/01/1900 (a comma at the beginning).

If a patient exists already when importing (same external ID if exists, else, both full name and birthday), ignore the row.

Please also create a 10+ patients CSV file and attach it here. Do not include it in the project source files.

yonimn2000 commented 3 years ago

@rahman-mahmudur Please submit your work for initial review by Friday 10/15 6 PM.

rahman-mahmudur commented 3 years ago

patients.csv Test file for all possible cases

yonimn2000 commented 3 years ago

Thanks. Please update the CSV file to include invalid records too: like no name, invalid birthday, etc.

rahman-mahmudur commented 3 years ago

Failure test file patients_failure_test.csv

rahman-mahmudur commented 3 years ago

Will finish this by tomorrow for final review.