Import CSV Bills & Invoices - Notes field

[JP Liew]

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 <mikee at saxicola.co.uk>
To: gnucash-devel at gnucash.org 
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 <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  

_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel