Some financial orgs include commas as thousands, hundreds thousands, etc.,
separator in CSV to beautify the display. They treat it as a free format string
value...
A single opening and a single closing double quotes, I believe, are ignored by
the importer ... correct me if I am wrong.
-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
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 Importing at
https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and
the examples therein :-
You'll note a complete absence of double quotes in the following example and no
header line.
Hope this helps,
Cheers David H.
Note on double quotes
If you use the field separator character within a field, the field value should
be enclosed in double quotes. Only for the fields description (desc) and notes,
can you also include a double quote within a quoted field value, by doubling
the double quote. E.g. "This field value uses the separator, and a ""quoted""
word", would be imported as This field value uses the separator, and a "quoted"
word.
Example content for two bills; one of 2 entries, and one of 3 entries. The
first is saved and posted, the second only saved. Using comma field separator,
decimal point and dd/mm/ date format.
1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and
Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts
Payable;;X
1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic
principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts
Payable;;X
1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate
Guide;pc;Expenses:Books;1;10.01;;;
1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner &
drinks;pc;Expenses:Dining;1;10.01;;;
1205;15/12/2018;2044;PO 21099;;16/12/2018;UG
course;pc;Expenses:Education;1;10.01;;;
On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user <
gnucash-user@gnucash.org> wrote:
> 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 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-invoi
> ces.html
> >
> > Regards,
> > Adrien
> >
> > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote:
> >> Hello,
> >> I'm having some issues importing a bill via CSV. I set up a trial
> >> run and I'm getting the below errors. Vendor "05" does not
> >> exist, however that is the vendor ID for Amazon in my file. It
> >> says account "Liabilities:Accounts Payable" does not exist (but it
> >> does). It says the Expense account also does not exist (but it
> >> does) and then it proceeds to ignore the line.
> >> How do I correct this for proper import? I've had the same issue on
> >> the Customer invoice import side as well.
> >> This is on Ubuntu with Flatpak 5.5
> >> Here is the raw CSV import:
> >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac
> >> tion
> >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t
> >> axab
> >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted"
> >> ;"memo_posted";"accu_splits"
> >> "111-7425790-5888250";05/11/23;"05";;;05/11/23;"Low Profile
> >> Fuse
> >> Kit";;"Expenses:Auto:2016 Big
> >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil
> >> itie
> >> s:Accounts Payable";;"N"
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update
