[GNC] What determines the order of transaction is CSV file?

[David H]

I’m a bit surprised that the csv export doesn’t include the txn id and date
on the splits instead of leaving them blank though.

Cheers David H.

On Sat, 24 Dec 2022 at 10:57 am, David Cousens <davidcousens49 at gmail.com>
wrote:

> Phyllis,
> Export Transactions to CSV by default places additional splits on
> succeeding
> lines. You can force a single line export with the split information on
> the same
> line with one of the options in the export dialogue. as David H pointed
> out.
>
> David
>
> On Fri, 2022-12-23 at 18:14 -0600, Phyllis Bruce wrote:
> > How will thee port handle multiple splits?
> >
> > > On Dec 23, 2022, at 5:07 PM, David Cousens <davidcousens49 at gmail.com>
> wrote:
> > >
> > > 
> > > Dave,
> > >
> > > Not sure how you achieved that. I just exported one of my accounts and
> it
> > > appears to be in date order from the first transaction entered (2015)
> until
> > > the
> > > last (a few days ago). I haven't checked the whole file but the first
> and
> > > last
> > > hundred or so transactions at each end are all in data order. My
> > > transactions
> > > are usually imported from downloaded OFX files so they are generally
> > > imported in
> > > date order. I used the first to last option in the export dialogue
> rather
> > > than
> > > the date range. As long as the first date is before the last date that
> > > should
> > > work the same though AFAIK
> > >
> > > David Cousens
> > >
> > > > On Fri, 2022-12-23 at 21:24 +0000, Dr. David Kirkby wrote:
> > > > I exported a list of transactions, then opened them in the
> LibraOffice
> > > > spreadsheet. The transactions seem to be in a random order. Since
> they are
> > > > split across multiple lines, it would not be possible to just sort
> them on
> > > > the date column. I'm sure there must be some logic to it, but I
> can't see
> > > > it. Below is a list of the dates of the transactions. Is there a way
> to
> > > > get
> > > > them saved in chronological order?
> > > >
> > > > 01/03/2022
> > > >
> > > > 25/02/2022
> > > >
> > > > 25/02/2022
> > > >
> > > > 28/02/2022
> > > >
> > > > 28/02/2022
> > > >
> > > > 28/02/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 02/03/2022
> > > >
> > > > 02/03/2022
> > > >
> > > > 02/03/2022
> > > >
> > > > 03/03/2022
> > > >
> > > > 25/02/2022
> > > >
> > > > 28/02/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 25/02/2022
> > > >
> > > > 25/02/2022
> > > >
> > > > 25/02/2022
> > > >
> > > > 28/02/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > 02/03/2022
> > > >
> > > > 02/03/2022
> > > >
> > > >
> > > > 25/02/2022
> > > >
> > > > 01/03/2022
> > > >
> > > > Dr David Kirkby Ph.D
> > > > Email: drkirkby at kirkbymicrowave.co.uk Web:
> > > > https://www.kirkbymicrowave.co.uk/
> > > > Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
> > > > Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.
> > > > _______________________________________________
> > > > 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.
> > >
> > > _______________________________________________
> > > 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.
>
> _______________________________________________
> 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.
>