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, 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;Lia > bilities: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;Li > abilities: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";"ac > > tion > > >> > > ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t > > axab > > >> > > le";"taxincluded";"tax_table";"date_posted";"due_date";"account_pos > > ted" > > >> ;"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;"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.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ 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.
