{"action":"created","issue":{"url":"https://api.github.com/repos/DarkFenX/Pyfa-experimental/issues/2","labels_url":"https://api.github.com/repos/DarkFenX/Pyfa-experimental/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/DarkFenX/Pyfa-experimental/issues/2/comments","events_url":"https://api.github.com/repos/DarkFenX/Pyfa-experimental/issues/2/events","html_url":"https://github.com/DarkFenX/Pyfa-experimental/issues/2","id":100454675,"number":2,"title":"phobos2pyfa not currently working","user":{"login":"blitzmann","id":3904767,"avatar_url":"https://avatars.githubusercontent.com/u/3904767?v=3","gravatar_id":"","url":"https://api.github.com/users/blitzmann","html_url":"https://github.com/blitzmann","followers_url":"https://api.github.com/users/blitzmann/followers","following_url":"https://api.github.com/users/blitzmann/following{/other_user}","gists_url":"https://api.github.com/users/blitzmann/gists{/gist_id}","starred_url":"https://api.github.com/users/blitzmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blitzmann/subscriptions","organizations_url":"https://api.github.com/users/blitzmann/orgs","repos_url":"https://api.github.com/users/blitzmann/repos","events_url":"https://api.github.com/users/blitzmann/events{/privacy}","received_events_url":"https://api.github.com/users/blitzmann/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-12T03:02:38Z","updated_at":"2015-08-12T08:00:08Z","closed_at":null,"body":"Had a bit of a snag when trying to get this to work:\r\n\r\n    ....\r\n    processing phbmetadata\r\n    applying conversion: basic attributes relocation\r\n    Traceback (most recent call last):\r\n      File \"C:/Users/Ryan/Copy/Git/blitzmann/Pyfa-experimental/scripts/phobos2pyfa.py\", line 182, in <module>\r\n        process_conversions(edb_session, json_path)\r\n      File \"C:/Users/Ryan/Copy/Git/blitzmann/Pyfa-experimental/scripts/phobos2pyfa.py\", line 159, in process_conversions\r\n        conversion(edb_session, json_path)\r\n      File \"C:/Users/Ryan/Copy/Git/blitzmann/Pyfa-experimental/scripts/phobos2pyfa.py\", line 140, in move_basic_attribs\r\n        attribute_value = row.get(invtypes_name)\r\n    AttributeError: 'str' object has no attribute 'get'\r\n\r\nIt stems from this in `move_basic_attribs`:\r\n\r\n    for row in load_table(json_path, 'invtypes'):\r\n        for invtypes_name, attribute_id in basic_attributes.items():\r\n            attribute_value = row.get(invtypes_name)\r\n\r\nrow in this case is a string of the item's ID, and not the dict of attributes as I assume it should be. So I change this to `for _, row in load_table(json_path, 'invtypes').items()`. But, when commiting the changes, I get a SQLite exception about NULL:\r\n\r\n    Traceback (most recent call last):\r\n      File \"C:\\Users\\Ryan\\Copy\\WinPython-32bit-3.4.3.5\\python-3.4.3\\lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 1139, in _execute_context\r\n        context)\r\n      File \"C:\\Users\\Ryan\\Copy\\WinPython-32bit-3.4.3.5\\python-3.4.3\\lib\\site-packages\\sqlalchemy\\engine\\default.py\", line 450, in do_execute\r\n        cursor.execute(statement, parameters)\r\n    sqlite3.IntegrityError: NOT NULL constraint failed: invgroups.categoryID\r\n\r\nNot knowing the backend well enough yet to determine if this should or shouldn't be null, not sure how to handle this."},"comment":{"url":"https://api.github.com/repos/DarkFenX/Pyfa-experimental/issues/comments/130209989","html_url":"https://github.com/DarkFenX/Pyfa-experimental/issues/2#issuecomment-130209989","issue_url":"https://api.github.com/repos/DarkFenX/Pyfa-experimental/issues/2","id":130209989,"user":{"login":"DarkFenX","id":275209,"avatar_url":"https://avatars.githubusercontent.com/u/275209?v=3","gravatar_id":"","url":"https://api.github.com/users/DarkFenX","html_url":"https://github.com/DarkFenX","followers_url":"https://api.github.com/users/DarkFenX/followers","following_url":"https://api.github.com/users/DarkFenX/following{/other_user}","gists_url":"https://api.github.com/users/DarkFenX/gists{/gist_id}","starred_url":"https://api.github.com/users/DarkFenX/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DarkFenX/subscriptions","organizations_url":"https://api.github.com/users/DarkFenX/orgs","repos_url":"https://api.github.com/users/DarkFenX/repos","events_url":"https://api.github.com/users/DarkFenX/events{/privacy}","received_events_url":"https://api.github.com/users/DarkFenX/received_events","type":"User","site_admin":false},"created_at":"2015-08-12T08:00:08Z","updated_at":"2015-08-12T08:00:08Z","body":"I have these issues 'quick-fixed' locally, but as i don't have time for proper fix - i haven't pushed anything yet."}}