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 <a...@argentwolf.org> 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. > > 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;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.
