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.
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.
