Some financial orgs include commas as thousands, hundreds thousands, etc., separator in CSV to beautify the display. They treat it as a free format string value...
A single opening and a single closing double quotes, I believe, are ignored by the importer ... correct me if I am wrong. -----Original Message----- From: David H <hell...@gmail.com> Sent: Saturday, February 24, 2024 7:02 PM To: Alan Johnson <a...@argentwolf.org> Cc: Adrien Monteleone <adrien.montele...@lusfiber.net>; gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Trouble importing bills via csv 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-invoi > ces.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_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;"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. > _______________________________________________ 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.
