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

[David Cousens]

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.