{"action":"created","issue":{"url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/issues/80","repository_url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker","labels_url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/issues/80/labels{/name}","comments_url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/issues/80/comments","events_url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/issues/80/events","html_url":"https://github.com/BiologicalRecordsCentre/BRCtracker/issues/80","id":378659703,"node_id":"MDU6SXNzdWUzNzg2NTk3MDM=","number":80,"title":"DF website - user table","user":{"login":"kitenetter","id":16039111,"node_id":"MDQ6VXNlcjE2MDM5MTEx","avatar_url":"https://avatars3.githubusercontent.com/u/16039111?v=4","gravatar_id":"","url":"https://api.github.com/users/kitenetter","html_url":"https://github.com/kitenetter","followers_url":"https://api.github.com/users/kitenetter/followers","following_url":"https://api.github.com/users/kitenetter/following{/other_user}","gists_url":"https://api.github.com/users/kitenetter/gists{/gist_id}","starred_url":"https://api.github.com/users/kitenetter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kitenetter/subscriptions","organizations_url":"https://api.github.com/users/kitenetter/orgs","repos_url":"https://api.github.com/users/kitenetter/repos","events_url":"https://api.github.com/users/kitenetter/events{/privacy}","received_events_url":"https://api.github.com/users/kitenetter/received_events","type":"User","site_admin":false},"labels":[{"id":845984654,"node_id":"MDU6TGFiZWw4NDU5ODQ2NTQ=","url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/labels/Scheme%20websites","name":"Scheme websites","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":{"login":"BirenRathod","id":5941255,"node_id":"MDQ6VXNlcjU5NDEyNTU=","avatar_url":"https://avatars3.githubusercontent.com/u/5941255?v=4","gravatar_id":"","url":"https://api.github.com/users/BirenRathod","html_url":"https://github.com/BirenRathod","followers_url":"https://api.github.com/users/BirenRathod/followers","following_url":"https://api.github.com/users/BirenRathod/following{/other_user}","gists_url":"https://api.github.com/users/BirenRathod/gists{/gist_id}","starred_url":"https://api.github.com/users/BirenRathod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BirenRathod/subscriptions","organizations_url":"https://api.github.com/users/BirenRathod/orgs","repos_url":"https://api.github.com/users/BirenRathod/repos","events_url":"https://api.github.com/users/BirenRathod/events{/privacy}","received_events_url":"https://api.github.com/users/BirenRathod/received_events","type":"User","site_admin":false},"assignees":[{"login":"BirenRathod","id":5941255,"node_id":"MDQ6VXNlcjU5NDEyNTU=","avatar_url":"https://avatars3.githubusercontent.com/u/5941255?v=4","gravatar_id":"","url":"https://api.github.com/users/BirenRathod","html_url":"https://github.com/BirenRathod","followers_url":"https://api.github.com/users/BirenRathod/followers","following_url":"https://api.github.com/users/BirenRathod/following{/other_user}","gists_url":"https://api.github.com/users/BirenRathod/gists{/gist_id}","starred_url":"https://api.github.com/users/BirenRathod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BirenRathod/subscriptions","organizations_url":"https://api.github.com/users/BirenRathod/orgs","repos_url":"https://api.github.com/users/BirenRathod/repos","events_url":"https://api.github.com/users/BirenRathod/events{/privacy}","received_events_url":"https://api.github.com/users/BirenRathod/received_events","type":"User","site_admin":false},{"login":"kitenetter","id":16039111,"node_id":"MDQ6VXNlcjE2MDM5MTEx","avatar_url":"https://avatars3.githubusercontent.com/u/16039111?v=4","gravatar_id":"","url":"https://api.github.com/users/kitenetter","html_url":"https://github.com/kitenetter","followers_url":"https://api.github.com/users/kitenetter/followers","following_url":"https://api.github.com/users/kitenetter/following{/other_user}","gists_url":"https://api.github.com/users/kitenetter/gists{/gist_id}","starred_url":"https://api.github.com/users/kitenetter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kitenetter/subscriptions","organizations_url":"https://api.github.com/users/kitenetter/orgs","repos_url":"https://api.github.com/users/kitenetter/repos","events_url":"https://api.github.com/users/kitenetter/events{/privacy}","received_events_url":"https://api.github.com/users/kitenetter/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/milestones/4","html_url":"https://github.com/BiologicalRecordsCentre/BRCtracker/milestone/4","labels_url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/milestones/4/labels","id":3771822,"node_id":"MDk6TWlsZXN0b25lMzc3MTgyMg==","number":4,"title":"Priority for DF launch","description":"","creator":{"login":"kitenetter","id":16039111,"node_id":"MDQ6VXNlcjE2MDM5MTEx","avatar_url":"https://avatars3.githubusercontent.com/u/16039111?v=4","gravatar_id":"","url":"https://api.github.com/users/kitenetter","html_url":"https://github.com/kitenetter","followers_url":"https://api.github.com/users/kitenetter/followers","following_url":"https://api.github.com/users/kitenetter/following{/other_user}","gists_url":"https://api.github.com/users/kitenetter/gists{/gist_id}","starred_url":"https://api.github.com/users/kitenetter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kitenetter/subscriptions","organizations_url":"https://api.github.com/users/kitenetter/orgs","repos_url":"https://api.github.com/users/kitenetter/repos","events_url":"https://api.github.com/users/kitenetter/events{/privacy}","received_events_url":"https://api.github.com/users/kitenetter/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":5,"state":"open","created_at":"2018-10-26T15:10:00Z","updated_at":"2018-11-08T12:25:32Z","due_on":"2018-11-09T08:00:00Z","closed_at":null},"comments":2,"created_at":"2018-11-08T10:05:39Z","updated_at":"2018-11-08T15:21:43Z","closed_at":null,"author_association":"NONE","body":"We need to ensure the user table is correct (currently has incorrect email addresses against some people). Suggest this:\r\n- Can you let me have a CSV download of the user (= People) table\r\n- I will highlight the email addresses that need to change (this is quite a small proportion I think)\r\n- I will highlight the entries that we set up with dummy emails - these can be removed\r\n- @BirenRathod to run SQL to update the emails and remove the dummy entries\r\n"},"comment":{"url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/issues/comments/437033686","html_url":"https://github.com/BiologicalRecordsCentre/BRCtracker/issues/80#issuecomment-437033686","issue_url":"https://api.github.com/repos/BiologicalRecordsCentre/BRCtracker/issues/80","id":437033686,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNzAzMzY4Ng==","user":{"login":"kitenetter","id":16039111,"node_id":"MDQ6VXNlcjE2MDM5MTEx","avatar_url":"https://avatars3.githubusercontent.com/u/16039111?v=4","gravatar_id":"","url":"https://api.github.com/users/kitenetter","html_url":"https://github.com/kitenetter","followers_url":"https://api.github.com/users/kitenetter/followers","following_url":"https://api.github.com/users/kitenetter/following{/other_user}","gists_url":"https://api.github.com/users/kitenetter/gists{/gist_id}","starred_url":"https://api.github.com/users/kitenetter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kitenetter/subscriptions","organizations_url":"https://api.github.com/users/kitenetter/orgs","repos_url":"https://api.github.com/users/kitenetter/repos","events_url":"https://api.github.com/users/kitenetter/events{/privacy}","received_events_url":"https://api.github.com/users/kitenetter/received_events","type":"User","site_admin":false},"created_at":"2018-11-08T15:21:43Z","updated_at":"2018-11-08T15:21:43Z","author_association":"NONE","body":"@BirenRathod I have now made all the corrections to email addresses, and deleted users with dummy emails. There is no need to run any SQL for this.\r\n\r\nHowever, I note that we have a lot of user names that end with one, or sometime multiple, spaces. This causes failures when trying to save edits, and this is likely to cause problems for users when they log on and try to save their passwords. \r\n\r\nIs it possible to run a query to remove the spaces from the end of user names in the underlying table?"}}
{"actor":{"display_login":"kitenetter"}}