[GNC] Trouble importing bills via csv

[Alan Johnson]

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";"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 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: 6036 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20240224/1a66d404/attachment.p7s>