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

[David Cousens]

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.