{"action":"closed","issue":{"url":"https://api.github.com/repos/AtlasOfLivingAustralia/biocollect/issues/535","repository_url":"https://api.github.com/repos/AtlasOfLivingAustralia/biocollect","labels_url":"https://api.github.com/repos/AtlasOfLivingAustralia/biocollect/issues/535/labels{/name}","comments_url":"https://api.github.com/repos/AtlasOfLivingAustralia/biocollect/issues/535/comments","events_url":"https://api.github.com/repos/AtlasOfLivingAustralia/biocollect/issues/535/events","html_url":"https://github.com/AtlasOfLivingAustralia/biocollect/issues/535","id":157106364,"number":535,"title":"Add the \"sand box\" tool for bulk-loading data into surveys ","user":{"login":"pbrenton","id":8119351,"avatar_url":"https://avatars.githubusercontent.com/u/8119351?v=3","gravatar_id":"","url":"https://api.github.com/users/pbrenton","html_url":"https://github.com/pbrenton","followers_url":"https://api.github.com/users/pbrenton/followers","following_url":"https://api.github.com/users/pbrenton/following{/other_user}","gists_url":"https://api.github.com/users/pbrenton/gists{/gist_id}","starred_url":"https://api.github.com/users/pbrenton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pbrenton/subscriptions","organizations_url":"https://api.github.com/users/pbrenton/orgs","repos_url":"https://api.github.com/users/pbrenton/repos","events_url":"https://api.github.com/users/pbrenton/events{/privacy}","received_events_url":"https://api.github.com/users/pbrenton/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-05-27T00:22:17Z","updated_at":"2016-06-10T09:49:28Z","closed_at":"2016-06-10T09:49:28Z","body":"Incorporate a version of the sand box tool into BioCollect to enable bulk loading of data into individual surveys/activities. \r\n\r\nRequirements:\r\n1. Activate from a \"Data upload\" button associated with each survey on the survey list page. Need to consider whether open in modal (like AEKOS submission - preferred) or separate page would be best;\r\n2. Use the survey/activity/output data model as the reference schema for field mapping;\r\n3. Allow column header selection (dropdown list) based on schema field name labels or schema field database names. As a field is selected it is removed from available options for remaining field mapping. If a previously mapped field mapping is changed, the previously mapped field should be available for re-selection and mapping to another column;\r\n4. Need to discuss approaches to handling nested tables in forms as well as forms constructed from multiple outputs;\r\n5. Need to consider how to handle fields in the data which don't map to the survey schema - suggest we flag as unmatched and display a warning message before submit that \"Unmatched fields cannot be uploaded into this survey\" Submit/Cancel. \r\n\r\n"}}
{"actor":{"display_login":"pbrenton"}}