pet-rescue icon indicating copy to clipboard operation
pet-rescue copied to clipboard

External Form Upload: add ability for staff to import a CSV of user form submissions

Open kasugaijin opened this issue 4 months ago • 3 comments

Log in as staff and go to /staff/external_form_upload and you will see a place for organizations to upload data via a CSV from a third party form, e.g., google forms.

To do

  • add a note to the above description that currently we only support google form CSVs
  • add a route and controller action (create) that will take the submitted CSV and execute the CSV import service. Note that we currently have app/services/organizations/csvimportservice but please add a new directory importers to app/services/organizations and rename the existing csvimportservice to google_csv_import_service.rb and put it in that new directory - flexible on naming if you can think of better!
  • manually test things. You will need to get an example of a google form CSV
  • write tests that ensure the flow works as expected e.g., incude a dummy CSV and make sure you test that it creates Form Answers for users with a matching email, and skips those where there is no email match.

Questons? Ask away...

kasugaijin avatar Oct 04 '24 22:10 kasugaijin