wish: qif option (info to desc; payee to desc)

Bug #916690 reported by Julien MOTTIN
32
This bug affects 4 people
Affects Status Importance Assigned to Milestone
HomeBank
Fix Released
Wishlist
Maxime DOYEN

Bug Description

wish:

As lots of banks provide their customers with erroneous .qif files, and sometimes fill their "Payee" field with unwanted information (date, amount and/or payement mean) it would be nice to perform massive edit of the records, and in particular to be able move all the payees field to description, so that automatic affect can then correctly set Payee and Category fields.

If needed, I can help providing detailed scenario and/or give a hand for the dev!

BR,
Julien Mottin

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

So it is more an import option than a massive edition which is required.
I will see this.

summary: - New Features : massive edit (info to desc; payee to desc)
+ whish: qif option (info to desc; payee to desc)
Maxime DOYEN (mdoyen)
Changed in homebank:
assignee: nobody → Maxime Doyen (mdoyen)
importance: Undecided → Wishlist
status: New → Confirmed
Maxime DOYEN (mdoyen)
summary: - whish: qif option (info to desc; payee to desc)
+ wish: qif option (info to desc; payee to desc)
Revision history for this message
Franck (alci) wrote :

I'm marking my bug report as a duplicate of this one. Here was the description (with a link to a (kind of) specification stating that P field might be payee OR description) :

When importing a qif file from my bank, description of the transaction are imported as "Payee" in HomeBank.
When looking at the file, I can see this text as the letter 'P' in the qif format.
These are "Non-investment transaction format", so P stands as Payee/Description, according to http://svn.gnucash.org/trac/browser/gnucash/branches/1.8/src/import-export/qif-import/file-format.txt

Then I cannot use the information to auto-assign a category latter... (see bug #493162)

A solution would be to let the user choose between Payee or Description when importing a Non-investment transaction from a qif file, as the format does not differanciate between the two.

Maxime DOYEN (mdoyen)
tags: added: report
Maxime DOYEN (mdoyen)
tags: added: file-import-export
removed: report
Maxime DOYEN (mdoyen)
Changed in homebank:
milestone: none → 4.6
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

the problem would be the M qif field which is mapped to Memo into HomeBank.
What to do if P a M are both filled into the qif file, concatenate (and in what order) ?

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

With this change, you can for every account (and set default into prefs):
- import or ignore Memo
- swap Memo/Payee

Changed in homebank:
status: In Progress → Fix Committed
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

backported to 5.1.2

Changed in homebank:
milestone: 5.2 → 5.1.2
Maxime DOYEN (mdoyen)
Changed in homebank:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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