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

Phyllis Bruce pobruce46 at gmail.com
Fri Dec 23 20:48:23 EST 2022


Thanks, DC!  That information will be helpful to me if I have a need to
export to another app.  I;ll check it out.

On Fri, Dec 23, 2022 at 6:56 PM 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.
>
>


More information about the gnucash-user mailing list