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

[kasugaijin]

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]

@wandergithub this issue is related to what you just worked on if you are interested?

[wandergithub]

Yes, I'm in.

[kasugaijin]

@wandergithub i got an email notification with some questions, but I think you may have deleted the comment? Let me know what questions you have!