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 <christopher....@gmail.com>
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, <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.
