{"action":"created","issue":{"url":"https://api.github.com/repos/Stanford-Online/edx-platform/issues/602","repository_url":"https://api.github.com/repos/Stanford-Online/edx-platform","labels_url":"https://api.github.com/repos/Stanford-Online/edx-platform/issues/602/labels{/name}","comments_url":"https://api.github.com/repos/Stanford-Online/edx-platform/issues/602/comments","events_url":"https://api.github.com/repos/Stanford-Online/edx-platform/issues/602/events","html_url":"https://github.com/Stanford-Online/edx-platform/pull/602","id":210919085,"number":602,"title":"Add new formatted answer column to ORA2","user":{"login":"vagupta16","id":3294346,"avatar_url":"https://avatars2.githubusercontent.com/u/3294346?v=3","gravatar_id":"","url":"https://api.github.com/users/vagupta16","html_url":"https://github.com/vagupta16","followers_url":"https://api.github.com/users/vagupta16/followers","following_url":"https://api.github.com/users/vagupta16/following{/other_user}","gists_url":"https://api.github.com/users/vagupta16/gists{/gist_id}","starred_url":"https://api.github.com/users/vagupta16/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vagupta16/subscriptions","organizations_url":"https://api.github.com/users/vagupta16/orgs","repos_url":"https://api.github.com/users/vagupta16/repos","events_url":"https://api.github.com/users/vagupta16/events{/privacy}","received_events_url":"https://api.github.com/users/vagupta16/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":22,"created_at":"2017-02-28T22:19:51Z","updated_at":"2017-04-03T18:04:19Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Stanford-Online/edx-platform/pulls/602","html_url":"https://github.com/Stanford-Online/edx-platform/pull/602","diff_url":"https://github.com/Stanford-Online/edx-platform/pull/602.diff","patch_url":"https://github.com/Stanford-Online/edx-platform/pull/602.patch"},"body":"The ORA2 responses collection process currently does not correctly decode the raw answers retrieved from MySQL, which are JSON strings.\r\n\r\nORA2 workflow:\r\n\r\nlms/djangoapps/instructor_task/api.py:submit_ora2_request_task() -->\r\nlms/djangoapps/instructor_task/tasks.py:get_ora2_responses() -->\r\nlms/djangoapps/instructor_task/tasks_helper.py:push_ora2_responses_to_s3() -->\r\n\r\nthe above calls the shared method API at lms/djangoapps/instructor_task/tasks_helper.py:_push_csv_responses_to_s3() using the csv_fn titled collect_email_ora2_data or collect_anonymous_ora2_data, both of which are located at lms/djangoapps/instructor/utils.py\r\n\r\nThe above methods then call lms/djangoapps/instructor/collect_ora2_data(), which returns the relevant header and rows.\r\n\r\nThis header and rows are pushed by _push_csv_responses_to_s3 to a ReportStore (lms/djangoapps/instructor_task/models.py).\r\n\r\nTo avoid modifying shared code, I modified the collect_ora2_data() method to actually iterate through the header and all of the rows to append a formatted, true Unicode version of the raw answer.\r\n\r\n\r\nNOTE: Still looking for a good way to actually test this. "},"comment":{"url":"https://api.github.com/repos/Stanford-Online/edx-platform/issues/comments/291224105","html_url":"https://github.com/Stanford-Online/edx-platform/pull/602#issuecomment-291224105","issue_url":"https://api.github.com/repos/Stanford-Online/edx-platform/issues/602","id":291224105,"user":{"login":"stvstnfrd","id":7300975,"avatar_url":"https://avatars3.githubusercontent.com/u/7300975?v=3","gravatar_id":"","url":"https://api.github.com/users/stvstnfrd","html_url":"https://github.com/stvstnfrd","followers_url":"https://api.github.com/users/stvstnfrd/followers","following_url":"https://api.github.com/users/stvstnfrd/following{/other_user}","gists_url":"https://api.github.com/users/stvstnfrd/gists{/gist_id}","starred_url":"https://api.github.com/users/stvstnfrd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stvstnfrd/subscriptions","organizations_url":"https://api.github.com/users/stvstnfrd/orgs","repos_url":"https://api.github.com/users/stvstnfrd/repos","events_url":"https://api.github.com/users/stvstnfrd/events{/privacy}","received_events_url":"https://api.github.com/users/stvstnfrd/received_events","type":"User","site_admin":false},"created_at":"2017-04-03T18:04:19Z","updated_at":"2017-04-03T18:04:19Z","body":"@vagupta16 I like that final option best; it makes it obvious that they didn't just hit `ENTER` during their response, but that these really are distinct parts."}}
{"actor":{"display_login":"stvstnfrd"}}