[GNC] Trouble importing bills via csv

[Alan Johnson]

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 at 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.monteleone at 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 at 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 at 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5197 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20240224/8aff510f/attachment.p7s>