{"action":"created","issue":{"url":"https://api.github.com/repos/SysPete/Icecat-Schema/issues/1","repository_url":"https://api.github.com/repos/SysPete/Icecat-Schema","labels_url":"https://api.github.com/repos/SysPete/Icecat-Schema/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/SysPete/Icecat-Schema/issues/1/comments","events_url":"https://api.github.com/repos/SysPete/Icecat-Schema/issues/1/events","html_url":"https://github.com/SysPete/Icecat-Schema/issues/1","id":155687426,"number":1,"title":"Open icecat documentation","user":{"login":"eduardelatorre","id":6890212,"avatar_url":"https://avatars.githubusercontent.com/u/6890212?v=3","gravatar_id":"","url":"https://api.github.com/users/eduardelatorre","html_url":"https://github.com/eduardelatorre","followers_url":"https://api.github.com/users/eduardelatorre/followers","following_url":"https://api.github.com/users/eduardelatorre/following{/other_user}","gists_url":"https://api.github.com/users/eduardelatorre/gists{/gist_id}","starred_url":"https://api.github.com/users/eduardelatorre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eduardelatorre/subscriptions","organizations_url":"https://api.github.com/users/eduardelatorre/orgs","repos_url":"https://api.github.com/users/eduardelatorre/repos","events_url":"https://api.github.com/users/eduardelatorre/events{/privacy}","received_events_url":"https://api.github.com/users/eduardelatorre/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-19T09:06:04Z","updated_at":"2016-06-01T16:39:27Z","closed_at":null,"body":"Hello Peter, my name is Edu (from Spain)\r\nThat's not an issue, but i don't know who to contact with you through github, so sorry.\r\n\r\nI'm trying to download product info fron Open Icecat and save it into a MySQL DB\r\nOpen Icecat info is quite incomplete and a crazy\r\n\r\nFor example, How do you know how to geneterate sid or tid?\r\nWell i only want if it's possible and if you have it open icecat documentation.\r\nThe one i have it's old, incomplete and horrible.\r\n\r\nSorry for stealing your time\r\nMy email eduardelatorre@gmail.com\r\n\r\nEdu."},"comment":{"url":"https://api.github.com/repos/SysPete/Icecat-Schema/issues/comments/223051830","html_url":"https://github.com/SysPete/Icecat-Schema/issues/1#issuecomment-223051830","issue_url":"https://api.github.com/repos/SysPete/Icecat-Schema/issues/1","id":223051830,"user":{"login":"SysPete","id":6115812,"avatar_url":"https://avatars.githubusercontent.com/u/6115812?v=3","gravatar_id":"","url":"https://api.github.com/users/SysPete","html_url":"https://github.com/SysPete","followers_url":"https://api.github.com/users/SysPete/followers","following_url":"https://api.github.com/users/SysPete/following{/other_user}","gists_url":"https://api.github.com/users/SysPete/gists{/gist_id}","starred_url":"https://api.github.com/users/SysPete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SysPete/subscriptions","organizations_url":"https://api.github.com/users/SysPete/orgs","repos_url":"https://api.github.com/users/SysPete/repos","events_url":"https://api.github.com/users/SysPete/events{/privacy}","received_events_url":"https://api.github.com/users/SysPete/received_events","type":"User","site_admin":false},"created_at":"2016-06-01T16:39:27Z","updated_at":"2016-06-01T16:39:27Z","body":"Best to use an example from the XML (yours might be newer than this):\r\n```\r\n      <Language Code=\"croatian\" ID=\"29\" ShortCode=\"HR\" Sid=\"10132\">\r\n       <Countries>\r\n         <Country Code=\"BA\" ID=\"12\" System_Of_Measurement=\"metric\"/>\r\n       </Countries>\r\n        <Name ID=\"270273\" Value=\"Croatian\" langid=\"1\"/>\r\n        <Name ID=\"270274\" Value=\"Croatian\" langid=\"2\"/>\r\n        <Name ID=\"270275\" Value=\"Croatian\" langid=\"3\"/>\r\n        <Name ID=\"270276\" Value=\"Croatian\" langid=\"4\"/>\r\n        <Name ID=\"270277\" Value=\"Croatian\" langid=\"5\"/>\r\n        <Name ID=\"270278\" Value=\"Croatian\" langid=\"6\"/>\r\n        <Name ID=\"270280\" Value=\"Hrvatski\" langid=\"29\"/>\r\n        <Name ID=\"863448\" Value=\"Croatian\" langid=\"42\"/>\r\n      </Language>\r\n```\r\nThe Language tag gives us langid=29 (ID attribute). This is the only attribute we need to link any other XML files to the Language table. The Name tags provide possible translations of the language name into other languages and as we see here croatian in croat is actually \"Hrvatski\". The sid that I generate simply links the possible translations back to the Language table so if you do something like:\r\n\r\n```\r\n$schema->resultset('Language')->names\r\n```\r\nThen the returned resultset will represent the Name tags in the above XML.\r\n\r\nI don't currently make use of the Countries data since it does not fit with my target application but I plan to add this at some point in the future.\r\n\r\nHope this helps."}}
{"actor":{"display_login":"SysPete"}}