{"id":1401,"date":"2010-12-17T17:55:40","date_gmt":"2010-12-18T01:55:40","guid":{"rendered":"http:\/\/www.curlybrace.com\/words\/?p=1401"},"modified":"2010-12-17T18:00:15","modified_gmt":"2010-12-18T02:00:15","slug":"converting-yodlees-csv-financial-data-to-ofx","status":"publish","type":"post","link":"https:\/\/www.curlybrace.com\/words\/2010\/12\/converting-yodlees-csv-financial-data-to-ofx\/","title":{"rendered":"Converting Yodlee&#8217;s CSV Financial Data to OFX"},"content":{"rendered":"<p>I was attempting to use <a href=\"https:\/\/github.com\/mulicheng\/csv2ofx\">csv2ofx<\/a> to convert <a href=\"http:\/\/www.yodlee.com\/ymc_home.shtml\">Yodlee MoneyCenter&#8217;s<\/a> exported comma separated value data into an OFX file, for use in GnuCash.  I repeatedly got an error when exporting:<\/p>\n<blockquote><p><tt>KeyError: 'Split Type'<\/tt><\/p><\/blockquote>\n<p>This turned out to be due to two bad lines written to the top of each file.  Removing those led to additional errors, &#8220;<tt>KeyError: 'Account Name'<\/tt>&#8221; and &#8220;<tt>KeyError: 'Transaction Id'<\/tt>&#8220;.<\/p>\n<p>In the end, I had to load the CSV file into a spreadsheet and perform the following steps:<\/p>\n<ol>\n<li \/>Delete a few lines at the top, which list the account name.\n<li \/>Add column &#8220;Account Name&#8221;, populate it with the name of the account.\n<li \/>Add column &#8220;Transaction Id&#8221;, populate it with an incrementing list of numbers.\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>I was attempting to use csv2ofx to convert Yodlee MoneyCenter&#8217;s exported comma separated value data into an OFX file, for use in GnuCash. I repeatedly got an error when exporting: KeyError: &#8216;Split Type&#8217; This turned out to be due to &hellip; <a href=\"https:\/\/www.curlybrace.com\/words\/2010\/12\/converting-yodlees-csv-financial-data-to-ofx\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[],"class_list":["post-1401","post","type-post","status-publish","format-standard","hentry","category-finance"],"_links":{"self":[{"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/posts\/1401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/comments?post=1401"}],"version-history":[{"count":6,"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/posts\/1401\/revisions"}],"predecessor-version":[{"id":1467,"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/posts\/1401\/revisions\/1467"}],"wp:attachment":[{"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/media?parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/categories?post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.curlybrace.com\/words\/wp-json\/wp\/v2\/tags?post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}