csv2ofx error

Colin Law clanlaw at googlemail.com
Sat Mar 17 09:29:56 EDT 2012


On 17 March 2012 13:21, Ca Baer <cabaer at hotmail.com> wrote:
>
> " Also,  you may want to try posting on mulicheng's github issues page https://github.com/mulicheng/csv2ofx/issues "
> NO way! A forum where you have to pay to post a question!? Not going to happen!

Did you see issue #2 there?

Colin

>
>> Date: Fri, 16 Mar 2012 07:25:10 -0700
>> From: reubano at gmail.com
>> To: gnucash-user at gnucash.org
>> Subject: Re: csv2ofx error
>>
>>
>> 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.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.



-- 
gplus.to/clanlaw



More information about the gnucash-user mailing list