Import Invoice problem

[John A Brown]

Nelson,

the date format like 2017-05-25 is referred to in GnuCash as "ISO". I used
the DD/MM/YYYY 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 those files
would be sorted by the operating system by month and year with all of the
June files together and all of the July files together but the years were
not in order. It would have been convenient for me if they had been sorted
chronologically. When I started work in the open source community Linux and
MySQL utilized the 2017-05-25 format. I realized that format allowed
alphabetical sorting used by the operating systems for sorting files by
name would also sort those files chronologically. So now I name my backup
files abcBU20170525112131.zip which is year month day hour minute second.
They show up chronologically when sorted by name.

GnuCash backup files utilizes that naming convention for it's backup files.
It is a good thing.

Kind Regards, John Brown

On Wed, Jun 21, 2017 at 5:57 PM, Nelson Handcock <nelson.handcock at gmail.com>
wrote:

> 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 the date format you use - in my load files I use
> "DD/MM/YYYY" - but again maybe that is dependent on your own GN settings
> too
>
> Hope this helps...
>
>
> Thanks & Regards,
>
> Nelson Handcock
> 0409 149919
>
> http://www.linkedin.com/in/nelsonhandcockaustralia
>
> On Thu, Jun 22, 2017 at 8:20 AM, Mike Evans <mikee at saxicola.co.uk> wrote:
>
> > 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 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.
> >
> _______________________________________________
> 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.
>