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

Phyllis Bruce pobruce46 at gmail.com
Fri Dec 23 19:14:19 EST 2022


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.


More information about the gnucash-user mailing list