Attached to this email is a file named mybadfile.csv. Thank you, John Brown
On Wed, Jun 21, 2017 at 3:36 PM, Mike Evans <[email protected]> wrote: > Can you post a sample of the file you are trying in import? > > Obviously you may want to hide any sensitive data. > > Mike E > > On Wed, 21 Jun 2017 14:28:18 -0500 > John A Brown <[email protected]> wrote: > > > Hello, > > > > I am using GnuCash 2.6.16 in Windows 7. (I did update GnuCash.) The error > > happens when I click File -> Import -> Import Bills & Invoices. I choose > > Invoice000502.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=502". The "id=502" it is referring to is the > > first field which is listed as id and I understand this field is invoice > > number. The data in this file for owner_id (customer number) is 8351 and > > there is a customer with customer number 8351. > > > > I experimented and tried different things but it always gives the same > > error. I did utilize invoice import feature in an earlier GnuCash version > > successfully. I have carefully compared my format to that described in > Help > > -> GnuCash Tutorial and Concepts Guide -> Importing Business Data -> > Import > > Bills or Invoices. I worked on this 12 days ago with GnuCash 2.6.5 and I > > got past this error and got the sample to import. I updated GnuCash and > > tried to get it to import the next invoice. I can't seem to get this > > solved. > > > > Any help or suggestions would be appreciated. Is there any way to see a > > more detailed explanation of the error like in a log file? > > > > Kind Regards, John A Brown > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > 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 > [email protected] > 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. >
id,date_opened,owner_id,billing_id,notes,date,description,action,account,quantity,price, disc_type, disc_how, discount, taxable, taxincluded, tax_table,date_posted,due_date, account_posted,memo_posted,accu_splits 502,,8559,,,2017-05-25,Quadbill White 1000,ea,Income:Forms:Quadbill,1,180.00,%,0,0,,,,,,,, 502,,8559,,,2017-05-25,UPS Shipping Cost,ea,Income:Shipping Income,1,14.13,%,0,0,,,,,,,,
_______________________________________________ gnucash-user mailing list [email protected] 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.
