[GNC] Feature request: Import assistant, room for big improvements

Kalpesh Patel kalpesh.patel at usa.net
Tue Jan 16 06:57:20 EST 2024 

Use the 'Append' capabilities to keep both sets of information in the description firld. In the matcher window you will see a ability to check box at the bottom of the matches. Albeit it changes your workflows and with few import iteration you'll be able to keep track of both info. I wish there was per transaction selection rather than all or nothing deal for that import iteration.

-----Original Message-----
From: David Cousens <davidcousens49 at gmail.com> 
Sent: Tuesday, January 16, 2024 1:13 AM
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Feature request: Import assistant, room for big improvements

>From memory David the import matcher process is common to all the front 
>ends to
read different file formats. It's been a while since I went through the code after Geert rewrote the CSV front end but I doubt that it has changed all that much. I have found the Bayesian matcher works fairly well apart from a few specific transactions where there is insufficient information in the data record to correctly assign. I typically only have to manually assign may be 10 records out of more than 50-60 records imported for my credit card account each month.

I haven't yet imported anything under v5.5. but will be catching up in a few days. Being able to edit/add data to the description and or memo fields would be something I would find useful too as the imported bank data often has limited info about what the purchase was for 
 

David Cousens




On Mon, 2024-01-15 at 22:48 -0600, David Carlson wrote:
> Which import assistant is being discussed here?  The Generic assistant 
> behind the OFX and QIF imports is quite limited in placing new 
> transactions into the desired account or in matching incoming 
> transactions to correct pre-existing transactions, but the new CSV 
> transaction importer is better, if harder to configure optimally.  
> Also, I think they all have changed in recent GnuCash releases, so tell us which release you are currently using.
> 
> I doubt that the Generic assistant can be improved very much unless it 
> is completely rewritten.
> 
> 
> On Mon, Jan 15, 2024 at 10:26 PM Phyllis Bruce <pobruce46 at gmail.com> wrote:
> 
> > 👍
> > 
> > 
> > > On Jan 15, 2024, at 10:17 PM, Derek Atkins <derek at ihtfp.com> wrote:
> > > 
> > > 
> > > No, I would call that the description.
> > > -derek
> > > Sent using my mobile device. Please excuse any typos.
> > > 
> > > > On January 15, 2024 23:06:07 Phyllis Bruce <pobruce46 at gmail.com> wrote:
> > > > 
> > > > Thanks, David.  I think I am being unclear.  My research 
> > > > provides what
> > you
> > > > call the transfer account for unmatched items.  That's all good.  
> > > > It is
> > the
> > > > memo field which I use to remind me of what I did that is not 
> > > > available
> > in
> > > > the reconciliation screen.  For instance I want to remember that 
> > > > I paid Amazon for *smart plugs*, or Sandi paid me $70 for *her 
> > > > share of
> > groceries
> > > > at Christmas*.  Would you call that the "action"?
> > > > 
> > > > On Mon, Jan 15, 2024 at 3:21 PM David Cousens 
> > > > <davidcousens49 at gmail.com
> > > 
> > > > wrote:
> > > > 
> > > > > Ulrich,
> > > > > 
> > > > > There is nothing to stop you supplying the transfer account
> > information in
> > > > > an
> > > > > import record if it is available. There is a header which can 
> > > > > be
> > assigned
> > > > > to the
> > > > > appropriate column of your input file for the transfer account.
> > > > > 
> > > > > The first time you import with a given account name in he 
> > > > > record you
> > will
> > > > > be
> > > > > asked to specify the internal GnuCash account to which it corresponds.
> > > > > After
> > > > > that it will be matched to that account.
> > > > > 
> > > > > The Bayesian process only assigns a probable account in cases 
> > > > > where the import record does not specify the  transfer 
> > > > > account.
> > > > > 
> > > > > David Cousens
> > > > > 
> > > > > > On Mon, 2024-01-15 at 20:17 +0100, Ulrich Grün wrote:
> > > > > > Hello fellow GnuCash users,
> > > > > > 
> > > > > > I wonder if there are plans on improving the import filter, 
> > > > > > for
> > importing
> > > > > > bank transfers.
> > > > > > The situation now is, that some hidden engine tries to learn 
> > > > > > from
> > doing.
> > > > > > But the truth is, that even after one year of importing bank
> > transfers, I
> > > > > > have to check every single transaction, since errors keep occurring.
> > If I
> > > > > > miss an error, this transaction is put in the wrong ledger account.
> > > > > > 
> > > > > > E-boekhouden.nl uses an import assistant where you can 
> > > > > > specify a
> > ledger
> > > > > > account number, other keywords and/or amounts of money. The 
> > > > > > import assistant puts the transactions into the right ledger 
> > > > > > account, with
> > far
> > > > > > less errors than with GnuCash. In fact, only where a 
> > > > > > specific keyword, leger number or amount is missing, or 
> > > > > > where no import rule is made
> > for a
> > > > > > specific payment, the transaction has to be placed into the 
> > > > > > right
> > general
> > > > > > ledger by hand.
> > > > > > 
> > > > > > Have a nice day!
> > > > > > 
> > > > > > --
> > > > > > नमस्ते (Namasté),
> > > > > > Ulrich
> > > > > > 
> > > > > > 
> > > > > 
> > ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°
> > `°º¤ø,¸¸
> > ,ø
> > > > > > ¤º°`°º¤ø
> > > > > > 
> > > > > > " Can't talk to you without talking to me; we're guilty of 
> > > > > > the same
> > old
> > > > > > thing.
> > > > > >   Thinking a lot about less and less, and forgetting the 
> > > > > > Love we bring "
> > > > > >                                [Grateful Dead, in: 'Althea']
> > > > > > 
> > > > > > 
> > > > > 
> > ¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°
> > `°º¤ø,¸¸
> > ,ø
> > > > > > ¤º°`°º¤ø
> > > > > >                      Mijn blog: ✡ theskepticaltheist.eu ✡ 
> > > > > > _______________________________________________
> > > > > > 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.
> > > > > 
> > > > _______________________________________________
> > > > 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