{"action":"created","issue":{"url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/issues/56","repository_url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb","labels_url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/issues/56/labels{/name}","comments_url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/issues/56/comments","events_url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/issues/56/events","html_url":"https://github.com/unfoldingWord-dev/translationDatabaseWeb/issues/56","id":93612289,"number":56,"title":"Add Alternate Language Names to langnames.json","user":{"login":"jag3773","id":107731,"avatar_url":"https://avatars.githubusercontent.com/u/107731?v=3","gravatar_id":"","url":"https://api.github.com/users/jag3773","html_url":"https://github.com/jag3773","followers_url":"https://api.github.com/users/jag3773/followers","following_url":"https://api.github.com/users/jag3773/following{/other_user}","gists_url":"https://api.github.com/users/jag3773/gists{/gist_id}","starred_url":"https://api.github.com/users/jag3773/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jag3773/subscriptions","organizations_url":"https://api.github.com/users/jag3773/orgs","repos_url":"https://api.github.com/users/jag3773/repos","events_url":"https://api.github.com/users/jag3773/events{/privacy}","received_events_url":"https://api.github.com/users/jag3773/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/labels/HIGH%20Priority","name":"HIGH Priority","color":"993300"}],"state":"open","locked":false,"assignee":{"login":"vleong2332","id":11132446,"avatar_url":"https://avatars.githubusercontent.com/u/11132446?v=3","gravatar_id":"","url":"https://api.github.com/users/vleong2332","html_url":"https://github.com/vleong2332","followers_url":"https://api.github.com/users/vleong2332/followers","following_url":"https://api.github.com/users/vleong2332/following{/other_user}","gists_url":"https://api.github.com/users/vleong2332/gists{/gist_id}","starred_url":"https://api.github.com/users/vleong2332/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vleong2332/subscriptions","organizations_url":"https://api.github.com/users/vleong2332/orgs","repos_url":"https://api.github.com/users/vleong2332/repos","events_url":"https://api.github.com/users/vleong2332/events{/privacy}","received_events_url":"https://api.github.com/users/vleong2332/received_events","type":"User","site_admin":false},"milestone":null,"comments":9,"created_at":"2015-07-07T19:43:07Z","updated_at":"2016-02-04T13:36:55Z","closed_at":null,"body":"We need to add all of the known alternate language names to the langnames.json export.\r\nFirst priority:\r\n\r\n* [x] Include English names for all languages (we already have this info in http://td.unfoldingword.org/data-sources/wikipedia/).  We also have the description field from http://www.iana.org/assignments/language-subtag-registry/language-subtag-registry that has the English name of the language.\r\n\r\nSecondary priority:\r\n* [ ] See if we can find and import other \"alternate\" names for languages.  Possibly scraping ethnologue."},"comment":{"url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/issues/comments/179842405","html_url":"https://github.com/unfoldingWord-dev/translationDatabaseWeb/issues/56#issuecomment-179842405","issue_url":"https://api.github.com/repos/unfoldingWord-dev/translationDatabaseWeb/issues/56","id":179842405,"user":{"login":"vleong2332","id":11132446,"avatar_url":"https://avatars.githubusercontent.com/u/11132446?v=3","gravatar_id":"","url":"https://api.github.com/users/vleong2332","html_url":"https://github.com/vleong2332","followers_url":"https://api.github.com/users/vleong2332/followers","following_url":"https://api.github.com/users/vleong2332/following{/other_user}","gists_url":"https://api.github.com/users/vleong2332/gists{/gist_id}","starred_url":"https://api.github.com/users/vleong2332/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vleong2332/subscriptions","organizations_url":"https://api.github.com/users/vleong2332/orgs","repos_url":"https://api.github.com/users/vleong2332/repos","events_url":"https://api.github.com/users/vleong2332/events{/privacy}","received_events_url":"https://api.github.com/users/vleong2332/received_events","type":"User","site_admin":false},"created_at":"2016-02-04T13:36:55Z","updated_at":"2016-02-04T13:36:55Z","body":"Here's a source: http://joshuaproject.net/assets/media/data/jpharvfielddataonly.zip\r\nIt's MS Access file. In there, there's a table called something like `LangAltNames`.\r\n\r\nThe table can be exported to a `.csv` from MS Access. We can definitely do a one-time import of the data and put it in a `LanguageAltName` model. Then give `Language` a property to return the string of alternate names - like `Language.cc_all`. At least this is how I think I can work it out. Of course this would be a problem for searching since property is not a database field.\r\n\r\nWhat do you think, @paltman? Can we extract the table by code and integrate the data (most likely an array of strings) into `Language` as a field?"}}