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