RE: Import Invoice problem

2017-06-23 Thread Bruce Danielson
Of John A Brown Sent: Wednesday, June 21, 2017 3:04 PM To: Mike Evans Cc: gnucash-user@gnucash.org Subject: Re: Import Invoice problem 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 wrote: > Can you post a sample of the fi

RE: Import Invoice problem

2017-06-23 Thread Bruce Danielson
o: Mike Evans Cc: gnucash-user@gnucash.org Subject: Re: Import Invoice problem 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 wrote: > Can you post a sample of the file you are trying in import? > > Obviously

RE: Import Invoice problem

2017-06-23 Thread Bruce Danielson
lling id) is null. Buster -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+danielsonb=logroom@gnucash.org] On Behalf Of John A Brown Sent: Wednesday, June 21, 2017 3:04 PM To: Mike Evans Cc: gnucash-user@gnucash.org Subject: Re: Import Invoice problem Attached to t

Re: Import Invoice problem

2017-06-22 Thread John A Brown
Nelson, the date format like 2017-05-25 is referred to in GnuCash as "ISO". I used the DD/MM/ format for a long time. I developed an application that stored monthy files with the designation abcd0617.dbf for the abcd file for June 2017. During the second year of deployment I realized that thos

Re: Import Invoice problem

2017-06-21 Thread John A Brown
Mike E, As I understand strings, 000502 is a string. 502 is also a string. Those strings are not equal. So if the Invoice ID is stored as a string, each of 000502, 502, and 0502 are unique ID's. In GnuCash Tutorial and Concepts Guide > Managing Business finances > Business Features > Accounts Rec

Re: Import Invoice problem

2017-06-21 Thread Nelson Handcock
Hi, comparing your file to mine, I think you also have some information missing that should be there... I think there should be a date_opened value (column 2). I guess it may be set to the current system date if not provided, but I've never tried not having it in my import files. I'm intrigued by

Re: Import Invoice problem

2017-06-21 Thread Mike Evans
Please file a bug report too. I just read the guide and the fact it should be a string isn't mentioned there either. Mike E ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remem

Re: Import Invoice problem

2017-06-21 Thread Mike Evans
The id's are stored as text strings, change the ID to 000502 and try again. Maybe (probably) the importer should do this for you but currently it just read the string. Mike E On Wed, 21 Jun 2017 17:03:46 -0500 John A Brown wrote: > Attached to this email is a file named mybadfile.csv. > >

Re: Import Invoice problem

2017-06-21 Thread John A Brown
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 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 >

Re: Import Invoice problem

2017-06-21 Thread Mike Evans
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 wrote: > Hello, > > I am using GnuCash 2.6.16 in Windows 7. (I did update GnuCash.) The error > happens when I click File -> Im

Import Invoice problem

2017-06-21 Thread John A Brown
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 t