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 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 to import the bills. > > Alan > > On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user 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;L > > > ia > > > 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_p > > > > os > > > > 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;"Liab > > > > il > > > > 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 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.
