Yes, if your field contains the separator character you should
double-quote it, but *only* in that case. Id's, dates, et cetera will
not, so no reason to quote them.
The OP had quotes on most if not all fields and none of them were necessary.
Regards,
Adrien
On 2/26/24 8:23 AM, Kalpesh Patel
.
-Original Message-
From: David H
Sent: Saturday, February 24, 2024 7:02 PM
To: Alan Johnson
Cc: Adrien Monteleone ;
gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Trouble importing bills via csv
Alan,
Your file imports fine here after I add the vendor, create the Accounts Payable
So basically you got rid of the quotes around everything as I suggested :-)
Cheers David H.
On Sun, 25 Feb 2024 at 11:17, Alan Johnson via gnucash-user <
gnucash-user@gnucash.org> wrote:
> So, I was working on it and here was that worked as I was playing with
> it. I'm using LibreOffice to edit
So, I was working on it and here was that worked as I was playing with
it. I'm using LibreOffice to edit the CSVs.
Edit the filter on the "save as" dialog, then I set the field delimiter
and deleted the string delimiter and unchecked 'quote all text cells'.
Then I was able to successfully able
Aha I read that as you'd tried it with and without the header line
nothing was said about the quotes :-)
On Sun, 25 Feb 2024 at 10:11, Alan Johnson wrote:
> I did read the manual, hence my usage of the quotes. I had done it before
> without.
>
> I'll make a video and send it out shortly.
>
>
I did read the manual, hence my usage of the quotes. I had done it
before without.
I'll make a video and send it out shortly.
Alan
On Sun, 2024-02-25 at 10:02 +1000, David H wrote:
> Alan,
>
> Your file imports fine here after I add the vendor, create the
> Accounts Payable liability,
There is the caveat, noted in that link, that if you use the same
delimiter for your account tree as the CSV, then (and only then) do you
need to enclose account references in double-quotes. (this is generally
a CSV thing, not something specific to GnuCash)
Regards,
Adrien
On 2/24/24 6:02
Alan,
Your file imports fine here after I add the vendor, create the Accounts
Payable liability, remove the header line and remove the double quotes that
you have plastered around every field for some reason which probably causes
the other errors.
It might pay to read up on Gnucash Bills
I tried that with the same result. GNC says it ignored that line, and that's
fine.
I'm concerned with the error messages indicating that the vendor and accounts
don't exist. Have I input that data incorrectly?
Feb 24, 2024 13:00:20 Adrien Monteleone :
> Although you should be able to have
Although you should be able to have header row(s), perhaps remove it and
try again.
The Documentation for this is worded oddly, but the samples provided
don't show header info at all.
https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html
Regards,
Adrien
On 2/24/24
10 matches
Mail list logo