{"action":"created","issue":{"url":"https://api.github.com/repos/epogrebnyak/cbr-db/issues/9","labels_url":"https://api.github.com/repos/epogrebnyak/cbr-db/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/epogrebnyak/cbr-db/issues/9/comments","events_url":"https://api.github.com/repos/epogrebnyak/cbr-db/issues/9/events","html_url":"https://github.com/epogrebnyak/cbr-db/issues/9","id":90621275,"number":9,"title":"Direct import of data to tables 'bank', 'plan', 'sprav102' in final database.","user":{"login":"epogrebnyak","id":9265326,"avatar_url":"https://avatars.githubusercontent.com/u/9265326?v=3","gravatar_id":"","url":"https://api.github.com/users/epogrebnyak","html_url":"https://github.com/epogrebnyak","followers_url":"https://api.github.com/users/epogrebnyak/followers","following_url":"https://api.github.com/users/epogrebnyak/following{/other_user}","gists_url":"https://api.github.com/users/epogrebnyak/gists{/gist_id}","starred_url":"https://api.github.com/users/epogrebnyak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/epogrebnyak/subscriptions","organizations_url":"https://api.github.com/users/epogrebnyak/orgs","repos_url":"https://api.github.com/users/epogrebnyak/repos","events_url":"https://api.github.com/users/epogrebnyak/events{/privacy}","received_events_url":"https://api.github.com/users/epogrebnyak/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/epogrebnyak/cbr-db/labels/critical-path","name":"critical-path","color":"fbca04"},{"url":"https://api.github.com/repos/epogrebnyak/cbr-db/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/epogrebnyak/cbr-db/labels/pri-high","name":"pri-high","color":"eb6420"},{"url":"https://api.github.com/repos/epogrebnyak/cbr-db/labels/stage-data-import","name":"stage-data-import","color":"006b75"}],"state":"open","locked":false,"assignee":{"login":"repo2156","id":12769545,"avatar_url":"https://avatars.githubusercontent.com/u/12769545?v=3","gravatar_id":"","url":"https://api.github.com/users/repo2156","html_url":"https://github.com/repo2156","followers_url":"https://api.github.com/users/repo2156/followers","following_url":"https://api.github.com/users/repo2156/following{/other_user}","gists_url":"https://api.github.com/users/repo2156/gists{/gist_id}","starred_url":"https://api.github.com/users/repo2156/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/repo2156/subscriptions","organizations_url":"https://api.github.com/users/repo2156/orgs","repos_url":"https://api.github.com/users/repo2156/repos","events_url":"https://api.github.com/users/repo2156/events{/privacy}","received_events_url":"https://api.github.com/users/repo2156/received_events","type":"User","site_admin":false},"milestone":null,"comments":14,"created_at":"2015-06-24T09:21:17Z","updated_at":"2015-07-03T20:28:44Z","closed_at":null,"body":"This data needs not to be truncated, so it shouldn't go to raw database, foes to final database.\r\n\r\nDesired behaviour:\r\nthe functions read data from dbf file (generator), create sql bulk insert statement and execute it.   \r\nfunctions can be called from cli interface.\r\n\r\nNote: \r\n- must also add regn/name of \"private data\" bank(s)\r\n- bank names imported only from form 101, assumes to be the same in other forms\r\n- this feature allows to skip some 'import tables' commands\r\n- user: for latest names/account always unpack latest date file (overwrites existing files)\r\n- may use functions to bulk-insert data to table in database (see code in lines 46-100 \r\nhttps://github.com/zimBop/dbfToMysql/blob/master/functions.php, - it assembles insert quesry of 500 items)\r\n\r\nform\t|\tDBF file\t|\tdatabase table\t|\tcontent\r\n-----------\t|\t-----------\t|\t-----------\t|\t-----------\r\n101\t|\tmmyyyy_N.DBF\t|\tbank\t|\tbank names\r\n101\t|\tmmyyyyN1.DBF\t|\tbank\t|\tbank names\r\n101\t|\tNAMES.DBF\t|\tplan\t|\tform 101 account names\r\n102\t|\tSPRAV1.DBF \t|\tsprav102\t|\tform 102 account names\r\n\r\n*Command line syntax:*\r\n```\r\nbankform.py import plan <FORM> \r\n    imports account names (form 101 and 102) to final database\r\nbankform.py import bank <FORM>\r\n    imports bank names to final database (based on form 101 and private data)\r\n```"},"comment":{"url":"https://api.github.com/repos/epogrebnyak/cbr-db/issues/comments/118421394","html_url":"https://github.com/epogrebnyak/cbr-db/issues/9#issuecomment-118421394","issue_url":"https://api.github.com/repos/epogrebnyak/cbr-db/issues/9","id":118421394,"user":{"login":"repo2156","id":12769545,"avatar_url":"https://avatars.githubusercontent.com/u/12769545?v=3","gravatar_id":"","url":"https://api.github.com/users/repo2156","html_url":"https://github.com/repo2156","followers_url":"https://api.github.com/users/repo2156/followers","following_url":"https://api.github.com/users/repo2156/following{/other_user}","gists_url":"https://api.github.com/users/repo2156/gists{/gist_id}","starred_url":"https://api.github.com/users/repo2156/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/repo2156/subscriptions","organizations_url":"https://api.github.com/users/repo2156/orgs","repos_url":"https://api.github.com/users/repo2156/repos","events_url":"https://api.github.com/users/repo2156/events{/privacy}","received_events_url":"https://api.github.com/users/repo2156/received_events","type":"User","site_admin":false},"created_at":"2015-07-03T20:28:44Z","updated_at":"2015-07-03T20:28:44Z","body":"The sequence:\r\n\r\n    python bankform.py import plan 101\r\n    python bankform.py import plan 102\r\n    python bankform.py import bank\r\n\r\nis works as expected. The last command executed will depend on the current SPRAV1.dbf and NAMES.dbf, no?"}}