csv2ofx error

[cabaer]

I should have mentioned: this was a yodlee csv file. I am assuming it does have the right format as there are NO customization options on Yodlee that I found.But thanks for the link. I will post there as well.

Date: Fri, 16 Mar 2012 07:25:10 -0700
From: ml-node+s1415818n4478307h43 at n4.nabble.com
To: cabaer at hotmail.com
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
	
	

	

	
	
		If you reply to this email, your message will be added to the discussion below:
		http://gnucash.1415818.n4.nabble.com/csv2ofx-error-tp4471950p4478307.html
	
	
		
		To unsubscribe from csv2ofx error, click here.

		NAML
	 		 	   		  

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