{"action":"created","issue":{"url":"https://api.github.com/repos/asascience-open/ooi-ui-services/issues/465","labels_url":"https://api.github.com/repos/asascience-open/ooi-ui-services/issues/465/labels{/name}","comments_url":"https://api.github.com/repos/asascience-open/ooi-ui-services/issues/465/comments","events_url":"https://api.github.com/repos/asascience-open/ooi-ui-services/issues/465/events","html_url":"https://github.com/asascience-open/ooi-ui-services/pull/465","id":123497950,"number":465,"title":"new vocab updates","user":{"login":"FBRTMaka","id":3743882,"avatar_url":"https://avatars.githubusercontent.com/u/3743882?v=3","gravatar_id":"","url":"https://api.github.com/users/FBRTMaka","html_url":"https://github.com/FBRTMaka","followers_url":"https://api.github.com/users/FBRTMaka/followers","following_url":"https://api.github.com/users/FBRTMaka/following{/other_user}","gists_url":"https://api.github.com/users/FBRTMaka/gists{/gist_id}","starred_url":"https://api.github.com/users/FBRTMaka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FBRTMaka/subscriptions","organizations_url":"https://api.github.com/users/FBRTMaka/orgs","repos_url":"https://api.github.com/users/FBRTMaka/repos","events_url":"https://api.github.com/users/FBRTMaka/events{/privacy}","received_events_url":"https://api.github.com/users/FBRTMaka/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/asascience-open/ooi-ui-services/labels/in%20progress","name":"in progress","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-12-22T15:10:21Z","updated_at":"2015-12-22T16:05:21Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/asascience-open/ooi-ui-services/pulls/465","html_url":"https://github.com/asascience-open/ooi-ui-services/pull/465","diff_url":"https://github.com/asascience-open/ooi-ui-services/pull/465.diff","patch_url":"https://github.com/asascience-open/ooi-ui-services/pull/465.patch"},"body":"@oceanzus , @birdage , @Bobfrat , @ednad , @DanielJMaher \r\n\r\nHey all, I made some significant changes to how the asset names are interpreted based on the reference designators.\r\n\r\n@oceanzus , @ednad  I created a separate sql file that will load to a new table via the manage.py file.  I'm not married to this implementation, so if you need/want to make any changes let me know and I can update that.\r\n\r\n@Bobfrat , @birdage, at this point it's really a consistency check and an exercise of rebuilding the DB with this new data.  We should get together today if possible to work out what need to do to keep the UI happy.\r\n\r\n@birdage , lets look in detail at line 115 of routes.py and if we need to keep that or off load that hack to be on uframes plate instead.\r\n\r\nLet me know if you need a hand setting it back up!"},"comment":{"url":"https://api.github.com/repos/asascience-open/ooi-ui-services/issues/comments/166659612","html_url":"https://github.com/asascience-open/ooi-ui-services/pull/465#issuecomment-166659612","issue_url":"https://api.github.com/repos/asascience-open/ooi-ui-services/issues/465","id":166659612,"user":{"login":"FBRTMaka","id":3743882,"avatar_url":"https://avatars.githubusercontent.com/u/3743882?v=3","gravatar_id":"","url":"https://api.github.com/users/FBRTMaka","html_url":"https://github.com/FBRTMaka","followers_url":"https://api.github.com/users/FBRTMaka/followers","following_url":"https://api.github.com/users/FBRTMaka/following{/other_user}","gists_url":"https://api.github.com/users/FBRTMaka/gists{/gist_id}","starred_url":"https://api.github.com/users/FBRTMaka/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FBRTMaka/subscriptions","organizations_url":"https://api.github.com/users/FBRTMaka/orgs","repos_url":"https://api.github.com/users/FBRTMaka/repos","events_url":"https://api.github.com/users/FBRTMaka/events{/privacy}","received_events_url":"https://api.github.com/users/FBRTMaka/received_events","type":"User","site_admin":false},"created_at":"2015-12-22T16:05:20Z","updated_at":"2015-12-22T16:05:20Z","body":"It was created with pg_dump.  What do you use to export the sql file with insert statements instead of COPY ?\r\n\r\n\r\nOn Dec 22, 2015, at 10:39 AM, James Case <notifications@github.com<mailto:notifications@github.com>> wrote:\r\n\r\n\r\n@FBRTMaka<https://github.com/FBRTMaka> I think the separate vocab sql file approach is fine. How was that file produced? It needs to be insert statements and set up like the other 2 sql files.\r\n\r\n—\r\nReply to this email directly or view it on GitHub<https://github.com/asascience-open/ooi-ui-services/pull/465#issuecomment-166650020>.\r\n\r\n\r\nThis e-mail message and any attached file is the property of the sender and is sent in confidence to the addressee only.\r\nInternet communications are not secure and RPS is not responsible for their abuse by third parties, any alteration or corruption in transmission or for any loss or damage caused by a virus or by other means.\r\n \r\nAny advice contained in this e-mail is for information purposes only.\r\n\r\nRPS Group Plc, company number: 208 7786 (England). Registered office: 20 Western Avenue Milton Park Abingdon Oxfordshire OX14 4SH.\r\nRPS Group Plc web link: <http://www.rpsgroup.com>\r\n"}}