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/yyyy date format.

1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and
Prejudice;pc;Expenses:Books;1;30.00;;;;X;;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.00;;;;X;;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 <adrien.montele...@lusfiber.net>:
>
> > 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: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 "000005" 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";"action
> >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab
> >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted"
> >> ;"memo_posted";"accu_splits"
> >> "111-7425790-5888250";05/11/23;"000005";;;05/11/23;"Low Profile Fuse
> >> Kit";;"Expenses:Auto:2016 Big
> >> Country:BigCountryMaintenance";1;12;;;;;;;05/11/23;05/11/23;"Liabilitie
> >> 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 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.

Reply via email to