Import Invoice causes error

[Bruce Danielson]

Hey John - Nelson's advice on getting the latest version might help the crashing problem.  The specific error you get is in regards to Customer ID which does not exist.  Check what's in the "owner ID" column to see that all are valid customer ID's.  Any mismatch, no matter how subtle or slight, will cause that row to be deleted & ignored.  And yes leave the header row in - it gets ignored anyway.
Bruce


-----Original Message-----
From: gnucash-user [mailto:gnucash-user-bounces+danielsonb=logroom.com at gnucash.org] On Behalf Of Nelson Handcock
Sent: Friday, June 09, 2017 4:52 PM
To: John A Brown
Cc: gnucash-user at gnucash.org
Subject: Re: Import Invoice causes error

Hi John,

Well for a start you are 11 full versions of Gnucash out of date - the current release is 2.6.16.

I recommend you getting the most recent version of the software for a start!

I have attached a sample that works for me - feel free to use it as a template.
If you leave the header row in the file when you import it, it will be rejected by the importer, but it will help ensure you have all the correct columns defined in your file.


Thanks & Regards,

Nelson Handcock


On Sat, Jun 10, 2017 at 2:22 AM, John A Brown <johnbrowngreybeard at gmail.com>
wrote:

> Hello,
>
> GnuCash is a very good program and the open source support community 
> is wonderful!
>
> I am using GnuCash 2.6.5 in Windows 7. The error happens when I click 
> File
> -> Import -> Import Bills & Invoices. I choose Invoice000500.csv, 
> -> invoice,
> comma separated. When I get this information entered the Preview 
> window displays the actual information that is in the file. When I 
> click OK I get an error telling me "ROW 1 DELETED, 
> CUSTOMER_DOES_NOT_EXIST; id=1234". The "id=1234" it is referring to is 
> the first field which is listed as id and I understand this field is 
> invoice number, not customer ID. I experimented a little and actually 
> put in a valid customer ID in the first field rather than the invoice 
> number which is supposed to be there. The same error message shows up saying that the valid customer ID does not exist.
>
> Then GnuCash.exe crashes and I get the error message "gnucash.exe has 
> stopped working". When I restart gnucash the lock file prevents the 
> data file from opening and I have to instruct it to "open anyway".
>
> I have utilized Invoice import feature successfully in the past so I 
> have confidence that the format is correct. I have carefully compared 
> my format to that described in Help -> GnuCash Tutorial and Concepts 
> Guide -> Importing Business Data -> Import Bills or Invoices.
>
> BTW I think there might be a confusing language in the Guide about 
> importing. It mentions "data must be in a fixed field length, comma 
> separated line format". My opinion is that the format shown is comma 
> separated. The format is specifically not fixed field length. The 
> guide also instructs the menu selections to get to this import feature 
> is Business -> Invoice & Bill Import when the correct menu selections 
> are  File -> Import -> Import Bills & Invoices.
>
> Kind Regards, John A Brown
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>