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

[Adrien Monteleone]

I was about to suggest the order was not random, but that if you 
exported multiple accounts, you'd see them in order, by-account. (so 
sorted on account first, then by date)

Exporting individual accounts might produce a more sane result. While 
I'm sure there are use cases, I'd think there is rare utility in 
exporting all accounts at once. I'd limit myself to my 'source' 
accounts, usually assets, from which funds flow out. That way, I don't 
get duplicate transaction info in the CSV.

Regards,
Adrien

On 12/24/22 6:32 AM, Dr. David Kirkby wrote:
> On Fri, 23 Dec 2022 at 21:24, Dr. David Kirkby <
> drkirkby at kirkbymicrowave.co.uk> 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?
>>
> 
> I made some progress on this. If export transactions on Linux,  the order
> is indeed random. (I have not tried Windows yet). But if I export an
> individual register (bank account for example), having first sorted them in
> whatever order I want (date, amount etc), then they remain in the order I
> sorted them in.
> 
> I'm reluctant to claim it's a bug, as it might be my fault. There are no
> options on the export function to export transactions in any particular
> order. I would have thought date is the most logical as a default.