Re: [GNC] Use same transfer column info for identical description

2024-04-17 Thread Christopher Lam
Glad it went well. If there are improvement ideas please file in
bugs.gnucash.org

On Tue, 16 Apr 2024, 5:59 pm Adrien Laveau,  wrote:

> Hello!
> I went deeper into the importer yesterday night. I sorted 1400 transaction
> in 2h. It could be of course improved but honestly the experience was
> great.
> I have done the hard work and quicker than expected.
>
> Let's see for future updates how the automatic detection works.
>
> Thanks everyone
>
> El mar., 16 abr. 2024 5:19, Christopher Lam 
> escribió:
>
>> 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, 
>> 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 

Re: [GNC] Use same transfer column info for identical description

2024-04-16 Thread Adrien Laveau
Hello!
I went deeper into the importer yesterday night. I sorted 1400 transaction
in 2h. It could be of course improved but honestly the experience was
great.
I have done the hard work and quicker than expected.

Let's see for future updates how the automatic detection works.

Thanks everyone

El mar., 16 abr. 2024 5:19, Christopher Lam 
escribió:

> 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, 
> 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 

Re: [GNC] Use same transfer column info for identical description

2024-04-15 Thread Christopher Lam
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,  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 

Re: [GNC] Use same transfer column info for identical description

2024-04-15 Thread Kevin Buckley via gnucash-user
On Tuesday, April 16th, 2024 at 04:13, Adrien Laveau  
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.

Thanks for clarifying that.

It would then appear that "fixing up" the data, prior to importing.
is the way to go, as that will be easier than doing so once you have
imported your data into GnuCash.

> 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.

Righto, so it's "future imports" from similar data that you are 
hoping to have automaically "corrected" and not future entries 
added via the register.

Again, I feel that "adjustting" th edata so that the Import does
what you want, is going to be the easiest way forwards.


___
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.


Re: [GNC] Use same transfer column info for identical description

2024-04-15 Thread Adrien Laveau
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 
> 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.
>
>
>
>
> 

Re: [GNC] Use same transfer column info for identical description

2024-04-15 Thread Kevin Buckley via gnucash-user
On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt  
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.


Re: [GNC] Use same transfer column info for identical description

2024-04-14 Thread Jim DeLaHunt

Hello, Adrien, and welcome to MusicBrainz!

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.)


For #2, GnuCash automatically fills in the contents of a transaction by 
matching the Description text you type in to the most recent transaction 
with that same Description text. So, to get new transactions to match 
your desired content, first edit the most recent existing transaction 
with that description to match your desired content. Then, when you 
enter a new transaction, type in the same Description text, and let 
GnuCash fill in the content from the most recent transaction into your 
new transaction.


See the /GnuCash Manual/, section 6.2.1. *Entering Directly in the 
Register Window* 
 
for more information.


Do these future transactions happen one a predictable schedule? You 
might also find it useful to make Scheduled Transactions to enter 
them. See the /GnuCash Manual/, section 6.13. *Scheduling Transactions* 
 for 
more information on using scheduled transactions.




I found old topics about that saying it had to be done manually. Has it changed?


I am not sure which "old topics" you are referring to, nor what "it" you 
mean, which has to be done manually. Do you mean old messages to the 
gnucash-user list? It would help if you could link to the specific 
messages in the list archives 
.


___
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.


[GNC] Use same transfer column info for identical description

2024-04-14 Thread Adrien Laveau
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.

I found old topics about that saying it had to be done manually. Has it
changed?

Thank you

Adrien
___
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.