csv2ofx error

[cabaer]

after direct import into gnucash failed for some of my accounts I went the yodlee/csv2ofx route (not easy for a computer illiterate person! I thought python was a reptile)

I got pretty far but upon conversion I get this error in the command prompt window when I try to convert a yodlee csv file:

C:\Program Files,gnu-csv2ofx\mulicheng-csv2ofx-c4316e2>python csv2ofx

Using Default Mappings

Open File C:\Users\Ca\Downloads\ExportData.csv

Traceback :

File "C: \Python27\lib\site-packages\csv2ofxinit.py", line 219, in OnExport

csv2ofx_export <path,mapping,grid>

File "C: \Python27\lib\site-packages\csv2ofxinit.py", line 16, in export

if mapping[' skip' ]<row,grit>: continue

File "C: \Python27\lib\site-packages\csv2ofx\mappings. py", line 104, in 'skip': lambda row,grid: fromCSVCol<row,grit, 'Split Type'> == 'Split',

File "C: \Python27\lib\site-packages\csv2ofx\csvutils.py", line 62, in fromCSVCol

return xmlize <grid, GetValue,<row,grid,GetColPos>>

File "C: \Python27\lib\site-packages\csv2ofx\csvutils.py", line 46, in GetColPos

terurn self.col_map[col_name]

KeyError: 'Split Type'

GoodBye

It does not create an output file (tried both ofx and qif)

Help would be greatly appreciated. Somebody must understand this...

[djmuhlestein]

Your CSV file should have a column titled 'Split Type'. You can leave the contents on each transaction blank if they are not splits or I believe if you put 'Split' for the value then that transaction is counted part of the previous line instead of a new transaction.

Unfortunately, Yodlee changes their CSV format from time to time so to use this utility the mappings file has to be updated accordingly.

[cabaer]

The file has the following column headings:

Status Date Original DescriptionSplit Type Category Currency Amount User Description Memo Classification I went ahead and deleted the column Split Type but still get the exact same error! Don't get this at all.Went ahead and typed 'split' in each row in the split column. Still same error...

Date: Mon, 19 Mar 2012 09:15:07 -0700 From: reply@reply.github.com To: cabaer@hotmail.com Subject: Re: [csv2ofx] csv2ofx error (#7)

Your CSV file should have a column titled 'Split Type'. You can leave the contents on each transaction blank if they are not splits or I believe if you put 'Split' for the value then that transaction is counted part of the previous line instead of a new transaction.

Unfortunately, Yodlee changes their CSV format from time to time so to use this utility the mappings file has to be updated accordingly.

---

Reply to this email directly or view it on GitHub: https://github.com/mulicheng/csv2ofx/issues/7#issuecomment-4576780

[djmuhlestein]

This issue is that the column is supposed to be there. Not that it isn't there. If you don't have it you'll get the error.

[cabaer]

I know, it's there by default (Yodlee export). I just thought I try and delete it to see what happens. Exact same error with or without 'Split Type' column.

Date: Mon, 19 Mar 2012 10:39:35 -0700 From: reply@reply.github.com To: cabaer@hotmail.com Subject: Re: [csv2ofx] csv2ofx error (#7)

This issue is that the column is supposed to be there. Not that it isn't there. If you don't have it you'll get the error.

---

Reply to this email directly or view it on GitHub: https://github.com/mulicheng/csv2ofx/issues/7#issuecomment-4579128

[djmuhlestein]

Perhaps the problem is it is in the mapping but shouldn't be, or something like that. I haven't looked at it for years.