The importer has had some upgrades in the past couple years. You can sort
by description in the importer, select multiple transactions with similar
descriptions, mass assign to a particular account, mass rename the
description too, via the right click menu.
On Tue, 16 Apr 2024, 4:14 am Adrien Laveau, <adrien.lav...@gmail.com> wrote:
> Hello,
>
> Thank you both for your time answering my question.
>
> At the moment my data being in GNC or not is not a big deal.
> I have the CSV/XLS fiel extracts (sadly my banks do not connect with GNC
> online systems).
> It is of the following form :
> Description Amount Date
> DescA xx 2024/03/12
> DescB yy ...
> DescC zz
> DescB ii
> DescB aa
> DescC rr
> ...
>
> And I want DescA to go in one transfer, DescB to go in another one and C in
> another one.
> I have understood your method and remember it, but for the moment I cannot
> use it as the "initial répartition" is not done.
>
> And also it does not seem to solve the problem of future transaction witj
> the same description.
> Indeed I plan to regularly get the CSV from sll my accountd and import them
> in GNC and I would have expected those new transaction to take the correct
> transfer action.
>
> The best guess I have now is to do it in Excel before importing and having
> the mapping I am looking for, directly in Excel.
>
> Thanks again
>
> El lun., 15 abr. 2024 14:12, Kevin Buckley via gnucash-user <
> gnucash-user@gnucash.org> escribió:
>
> > On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt <
> list+gnuc...@jdlh.com>
> > wrote:
> > >
> > > Hello, Adrien, and welcome to MusicBrainz!
> >
> > Surely: "... welcome to GnuCash!" ?
> >
> > >
> > > On 2024-04-14 13:03, Adrien Laveau wrote:
> > >
> > > > Hello community,
> > > >
> > > > I uploaded 5 years worth of bank account transaction to gnu-cash.
> > > >
> > > > I would like the apply the same transfer information to all the
> > > > transactions having the same description and keep applying it
> > > > automatically to all future transaction.
> > >
> > >
> > > It sounds like you want to do two different things:
> > >
> > > 1. Change the details ("transfer column info") which you have already
> > > imported into your book file to match your desired contents.
> > > 2. Ensure that GnuCash uses your desired contents for future
> > > transactions which you enter into GnuCash using the "same description".
> > >
> > > I don't have easy suggestions for #1, except to go through transactions
> > > one by one and correct them. It may be tedious, but you only have to do
> > > it once. (I have a difficult suggestion: to edit the GnuCash XML book
> > > file. This is dangerous but sometimes effective. It requires skills in
> > > working with XML and file formats.)
> > >
> >
> > As someone who's not completely unfamiliar with editing GnuCash's
> > XML, I would like to say that doing what you are suggesting you
> > want to do here, by editing the XML, is going to be a large task,
> > because you would have to identify the various GUIDs (32 character
> > strings of text that give you no clue as to what each one is) that,
> > in the XML file, take the place of what you see, as the transfer
> > account, in the Register.
> >
> > As Jim implies, it could be done, but I'm not sure you would want
> > to.
> >
> > There may, depending on how cleanly your old data was imported,
> > be a bit of a "saving grace", as to what you are trying to do,
> > via an approach that doesn't mean you need to go through ALL
> > your TXNs one by one. You might still need to address a small
> > number of outliers.
> >
> > It does, however, mean "Deleting" some things, but don't stop
> > reading yet, as it's not as bad as it sounds.
> >
> > As I understand things, you have ended up with a lot of TXNs that
> > look like, where Desc1 is the same string every time
> >
> > Description: Desc1, Transfer account: XFR1
> > Description: Desc1, Transfer account: XFR2
> > Description: Desc1, Transfer account: XFR1
> > Description: Desc1, Transfer account: XFR3
> > Description: Desc1, Transfer account: XFR3
> > Description: Desc1, Transfer account: XFR2
> > Description: Desc1, Transfer account: XFR1
> >
> > scattered across any number of accounts, whereas you want all
> > those TXNs to be going into a single Transfer account: let's
> > say, XFR1.
> >
> > So, I need to assume that, after you imported them, you have a
> > chart of accounts (and let's assume the transfer accounts are
> > all Expenses, so as to have a top-level account to work with)
> > something akin to the following, where all of your imported
> > TXNs are in one of three NEW transfer accounts, so
> >
> > Expenses
> > +- XFR1
> > +- XFR2
> > +- XFR3
> >
> > and that there's nothing but your imported TXNs that have those
> > new transfer accounts associated with them.
> >
> > If you ended up importing your old data so that your old TXNs
> > ended up associated with existing transfer accounts, then stop
> > reading, as you are going to have to do them, one-by-one.
> >
> > Still with me?
> >
> > OK, if you go to Delete account XFR2, you will be asked if you
> > want to delete all of its TXNs, OR have them "Moved to" another
> > account, which, for your needs, would be "Expenses:XFR1".
> >
> > Similary, when you come to delete XFR3, all its TXNs could
> > placed into XFR1 as well.
> >
> > I hope that makes sense, and that your data allows you to try
> > that approach.
> >
> > This should go without saying, but, please make a back-up before
> > you start attempting to edit your data in these "slightly less
> > than typical" ways.
> >
> >
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user@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@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@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.
