Hi Mike, Thanks for your reply.
I tried \n at the notes field but it just got imported as test\nnotes\nline3 below is my test data "tt163175101012","13/04/2014","000003","","test\nnotes\nline3","13/04/2014","Arduino Compatible board with Ethernet plus socket for XBee,nRF24L01+ and SDCard","Material","Income:Sales","1","25","","","","1","1","GST Received","","13/04/2014","","","" Also thanks for your code, will take a look. Cheers JP ________________________________ From: Mike Evans <[email protected]> To: [email protected] Sent: Wednesday, June 18, 2014 9:12 PM Subject: Re: Import CSV Bills & Invoices - Notes field On Wed, 18 Jun 2014 01:36:04 -0700 JP Liew <[email protected]> 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 _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
