wish: option to choose to import OFX name to payee or memo

Bug #462919 reported by David Tombs
56
This bug affects 9 people
Affects Status Importance Assigned to Milestone
HomeBank
Fix Released
Wishlist
Maxime DOYEN

Bug Description

HomeBank 4.0.4
Ubuntu 9.10 RC, AMD64

When importing transactions for a credit card, typically the NAME field will be a payee and not really the description of the transaction. So, every time I import I have to manually copy the information from the Description field to the Payee field.

It would be good to have an option during import to do NAME -> Payee instead of NAME -> Description.

Thanks!

Maxime DOYEN (mdoyen)
Changed in homebank:
importance: Undecided → Wishlist
Maxime DOYEN (mdoyen)
Changed in homebank:
status: New → Confirmed
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: none → 4.3
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

Upgrade to v4.2, you can uses automated assigments for that.
Let me know if it suit your needs ?

Changed in homebank:
assignee: nobody → Maxime DOYEN (mdoyen)
milestone: 4.3 → none
status: Confirmed → Incomplete
Revision history for this message
David Tombs (dgtombs) wrote :

Hi,

Unfortunately, I don't think the automated assignment will fix the problem. I would like all of the imported transactions to use NAME -> Payee, whereas automated assignment will only let me select transactions based on keywords. Thanks!

Setting back to confirmed.

Changed in homebank:
status: Incomplete → Confirmed
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

Are you importing from QIF or OFX ?

Revision history for this message
David Tombs (dgtombs) wrote :

QFX.

Revision history for this message
Maxime DOYEN (mdoyen) wrote :

Maybe I should add an option like the one for memo field.

Revision history for this message
David Tombs (dgtombs) wrote :

I'm not sure what you're referring to, but I think a "Copy Description to Payee" option would be perfect.

Maxime DOYEN (mdoyen)
summary: - import should have the option of assigning payees
+ import OFX name to payee instaed of description
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: none → 4.5
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: 4.5 → 4.6
Maxime DOYEN (mdoyen)
tags: added: file-import-export
Maxime DOYEN (mdoyen)
summary: - import OFX name to payee instaed of description
+ option to choose to import OFX name to payee or description
Changed in homebank:
milestone: none → 4.6
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Confirmed → In Progress
Maxime DOYEN (mdoyen)
summary: - option to choose to import OFX name to payee or description
+ wish: option to choose to import OFX name to payee or description
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: 5.0 → 4.7
Maxime DOYEN (mdoyen)
Changed in homebank:
status: In Progress → Incomplete
status: Incomplete → Confirmed
Revision history for this message
dleigh (david-leighweb) wrote : Re: wish: option to choose to import OFX name to payee or description

Why is this a wishlist level issue? According to the OFX standard <NAME> and <PAYEE> are both to be interpreted as "payee" and there is an explicit <MEMO> field for memos. To me, this is clearly a bug in HomeBank not being compliant with the standard, and it's a real pain.

http://www.ofx.net/DownloadPage/Files/OFX2.1.1.zip

Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: none → 5.0.1
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Confirmed → In Progress
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: 5.0.1 → 5.1
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

@dleight:
this is a wish, because it is.
It's fine to provide ofx specification by at last you should have red it more carefully.

HomeBank uses libofx to import ofx/qfx file, and maybe some gap vs the specification may exists.
As an output of the libofx parsing process we get optional name and/or memo field and this requires to be mapped to HB fields, so it may be an option to the user to select how to map this field, what will exist soon.

BTW: page 210 (and some more) of ofx specification (and also in libofx doc http://libofx.coeus.ca/html/index.html):
 "<NAME> Name of payee or description of transaction"

Maxime DOYEN (mdoyen)
Changed in homebank:
status: In Progress → Fix Committed
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: 5.1 → 5.2
Maxime DOYEN (mdoyen)
summary: - wish: option to choose to import OFX name to payee or description
+ wish: option to choose to import OFX name to payee or memo
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

So at last with change, for each account (and this change be set into prefs a default)
- you can choose to import NAME as Payee (default), or Memo
- then MEMO can be
   - ignored
   - append to info
   - append to memo
   - append to payee

Revision history for this message
dleigh (david-leighweb) wrote : Re: [Bug 462919] Re: wish: option to choose to import OFX name to payee or memo

Very cool! Thanks!

== David Leigh == <email address hidden> == http://david.leighweb.com == Sent
from my Android phone ==

On Aug 11, 2016 22:00, "Maxime Doyen" <email address hidden> wrote:

> So at last with change, for each account (and this change be set into
> prefs a default)
> - you can choose to import NAME as Payee (default), or Memo
> - then MEMO can be
> - ignored
> - append to info
> - append to memo
> - append to payee
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/462919
>
> Title:
> wish: option to choose to import OFX name to payee or memo
>
> Status in HomeBank:
> Fix Committed
>
> Bug description:
> HomeBank 4.0.4
> Ubuntu 9.10 RC, AMD64
>
> When importing transactions for a credit card, typically the NAME
> field will be a payee and not really the description of the
> transaction. So, every time I import I have to manually copy the
> information from the Description field to the Payee field.
>
> It would be good to have an option during import to do NAME -> Payee
> instead of NAME -> Description.
>
> Thanks!
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/homebank/+bug/462919/+subscriptions
>

Revision history for this message
dleigh (david-leighweb) wrote :

By the way, what version will this option appear in? I just downloaded 5.1.1 today and I can't find that option.
Thank you very much.

Revision history for this message
Maxime DOYEN (mdoyen) wrote :

Target is 5.2.
But I'm going to see if I can backport this in 5.0.2

Revision history for this message
Maxime DOYEN (mdoyen) wrote :

backported to 5.1.2

Changed in homebank:
milestone: 5.2 → 5.1.2
Revision history for this message
dleigh (david-leighweb) wrote :

Excellent! I look forward to that soon. Thanks.

== David Leigh == <email address hidden> == http://david.leighweb.com == Sent
from my Android phone ==

On Nov 20, 2016 06:08, "Maxime Doyen" <email address hidden> wrote:

> backported to 5.1.2
>
> ** Changed in: homebank
> Milestone: 5.2 => 5.1.2
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/462919
>
> Title:
> wish: option to choose to import OFX name to payee or memo
>
> Status in HomeBank:
> Fix Committed
>
> Bug description:
> HomeBank 4.0.4
> Ubuntu 9.10 RC, AMD64
>
> When importing transactions for a credit card, typically the NAME
> field will be a payee and not really the description of the
> transaction. So, every time I import I have to manually copy the
> information from the Description field to the Payee field.
>
> It would be good to have an option during import to do NAME -> Payee
> instead of NAME -> Description.
>
> Thanks!
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/homebank/+bug/462919/+subscriptions
>

Maxime DOYEN (mdoyen)
Changed in homebank:
status: Fix Committed → Fix Released
Revision history for this message
reginaldo (reginaldo-re) wrote :

Maxime, I just intalled HB 5.1.2 from Ubuntu PPA and this feature is not functional.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.