Import CSV Bills & Invoices - Notes field

Mike Evans mikee at saxicola.co.uk
Wed Jun 18 07:12:59 EDT 2014


On Wed, 18 Jun 2014 01:36:04 -0700
JP Liew <jpliew at yahoo.com> wrote:

> Hi all, 
> 
> I did a search and was not able to find an answer to my question. 
> 
> Basically, I would like to write an eBay or Paypal sales to GnuCash 
> invoice converter that will export eBay/PayPal sales to GnuCash CSV file that 
> can be imported by the "Import Bills & Invoices".  The prototype 
> works ok except I was not able to figure out how to deal with multi-line
>  Notes. 
> 
> In GnuCash, a user can type multi-line notes, however in CSV, I 
> was not able to find a way to code the CR / LF in the Notes field. 
> 
> If anyone has done this before, could you share some lights please?
> If not, can any let me know the actual src that is dealing with the part of the import please? 
> 
> https://github.com/Gnucash/gnucash/tree/master/src/import-export/csv-imp
> 
> 
> Cheers 
> John 
>  
Hi John.

You should just be able to insert '\n' where you want the newline.

Regarding e-bay to invoices, I wrote a utility to create Bills from ebay purchases, there may be something useful in there.

https://github.com/EvansMike/pycash/tree/master/ebay2gnuCash

Mike E


-- 
Anti NSA?  Use PGP.
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x00CDB13500D7AB53  



More information about the gnucash-devel mailing list