csv2ofx error

[reubano]

cabaer wrote
> 
> 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:
> 
> C:\Program Files,gnu-csv2ofx\mulicheng-csv2ofx-c4316e2>python csv2ofx
> Using Default Mappings
> Open File C:\Users\Ca\Downloads\ExportData.csv
> Traceback <most recent call last>:
>   File "C: \Python27\lib\site-packages\csv2ofx\_init_.py", line 219, in
> OnExport
>      csv2ofx_export <path,mapping,grid>
>   File "C: \Python27\lib\site-packages\csv2ofx\_init_.py", line 16, in
> export
>      if mapping[' skip' ]<row,grit>: continue
>   File "C: \Python27\lib\site-packages\csv2ofx\mappings. py", line 104, in
> <lambda>
>     '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<col_name>>>
>   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... 
> 

Does your csv file match the default mappings template? It's based on a
yodlee export. I would see if mulicheng has an example csv and try to get
that to work first. Then modify your csv file to match the template. Also,
you may want to try posting on mulicheng's github issues page
https://github.com/mulicheng/csv2ofx/issues

--
View this message in context: http://gnucash.1415818.n4.nabble.com/csv2ofx-error-tp4471950p4478307.html
Sent from the GnuCash - User mailing list archive at Nabble.com.