{"action":"created","issue":{"url":"https://api.github.com/repos/code-dot-org/code-dot-org/issues/23206","repository_url":"https://api.github.com/repos/code-dot-org/code-dot-org","labels_url":"https://api.github.com/repos/code-dot-org/code-dot-org/issues/23206/labels{/name}","comments_url":"https://api.github.com/repos/code-dot-org/code-dot-org/issues/23206/comments","events_url":"https://api.github.com/repos/code-dot-org/code-dot-org/issues/23206/events","html_url":"https://github.com/code-dot-org/code-dot-org/pull/23206","id":333971789,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk2MDU3MTU2","number":23206,"title":"Add several improvements to JotForm import:","user":{"login":"aoby","id":8405316,"node_id":"MDQ6VXNlcjg0MDUzMTY=","avatar_url":"https://avatars0.githubusercontent.com/u/8405316?v=4","gravatar_id":"","url":"https://api.github.com/users/aoby","html_url":"https://github.com/aoby","followers_url":"https://api.github.com/users/aoby/followers","following_url":"https://api.github.com/users/aoby/following{/other_user}","gists_url":"https://api.github.com/users/aoby/gists{/gist_id}","starred_url":"https://api.github.com/users/aoby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aoby/subscriptions","organizations_url":"https://api.github.com/users/aoby/orgs","repos_url":"https://api.github.com/users/aoby/repos","events_url":"https://api.github.com/users/aoby/events{/privacy}","received_events_url":"https://api.github.com/users/aoby/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-20T08:21:59Z","updated_at":"2018-06-20T15:10:21Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/code-dot-org/code-dot-org/pulls/23206","html_url":"https://github.com/code-dot-org/code-dot-org/pull/23206","diff_url":"https://github.com/code-dot-org/code-dot-org/pull/23206.diff","patch_url":"https://github.com/code-dot-org/code-dot-org/pull/23206.patch"},"body":" 1. Skip (but don't blow up) for submissions without an environment.\r\n 2. Strip utf8mb4 chars from submissions\r\n 3. Improve nearest workshop logic to first check attendances and to\r\n handle duplicate enrollments. Also leverage `ORDER BY` to push the heavy lifting to MySql and simplify the query.\r\n 4. Add a `sync_from_jotform` instance method to `Pd::SurveyQuestion` for convenience in updating a single form's questions."},"comment":{"url":"https://api.github.com/repos/code-dot-org/code-dot-org/issues/comments/398786681","html_url":"https://github.com/code-dot-org/code-dot-org/pull/23206#issuecomment-398786681","issue_url":"https://api.github.com/repos/code-dot-org/code-dot-org/issues/23206","id":398786681,"node_id":"MDEyOklzc3VlQ29tbWVudDM5ODc4NjY4MQ==","user":{"login":"aoby","id":8405316,"node_id":"MDQ6VXNlcjg0MDUzMTY=","avatar_url":"https://avatars0.githubusercontent.com/u/8405316?v=4","gravatar_id":"","url":"https://api.github.com/users/aoby","html_url":"https://github.com/aoby","followers_url":"https://api.github.com/users/aoby/followers","following_url":"https://api.github.com/users/aoby/following{/other_user}","gists_url":"https://api.github.com/users/aoby/gists{/gist_id}","starred_url":"https://api.github.com/users/aoby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aoby/subscriptions","organizations_url":"https://api.github.com/users/aoby/orgs","repos_url":"https://api.github.com/users/aoby/repos","events_url":"https://api.github.com/users/aoby/events{/privacy}","received_events_url":"https://api.github.com/users/aoby/received_events","type":"User","site_admin":false},"created_at":"2018-06-20T15:10:21Z","updated_at":"2018-06-20T15:10:21Z","author_association":"CONTRIBUTOR","body":"![](https://github.trello.services/images/mini-trello-icon.png) [Investigate sync_jotform error - maybe bc of emoji?](https://trello.com/c/csnfPi8i/652-investigate-syncjotform-error-maybe-bc-of-emoji)"}}
{"actor":{"display_login":"aoby"}}