Bug 365818 - OFX Import Ignores Requested Date Range
Summary: OFX Import Ignores Requested Date Range
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: importer (show other bugs)
Version: unspecified
Platform: Compiled Sources Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-18 15:56 UTC by Brendan
Modified: 2019-08-29 01:26 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 4.8.1,5.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Brendan 2016-07-18 15:56:13 UTC
When I import transactions from Citibank they ignore the requested date range (last update, today minus and pick a date) and send everything they have available. This account was opened recently but Citibank has historical data from the beginning of the year that they send each time I import the data. These transactions are already in the old credit card so they need to be ignored.

It would be very helpful if the OFX import process ignored the transactions that it receives from the bank that are outside of the range requested by KMM. In other words, If I request the past 30 days of transactions and my bank send transactions for the past 6 months, KMM should ignore all of the transactions older than 30 days.

Reproducible: Always

Steps to Reproduce:
1. Open a credit card at Citibank :-)
2. Make some transactions for a week or two
3. Setup online banking for this account
4. Request your transactions for the past 1 day

Actual Results:  
You get transactions older than 1 day

Expected Results:  
You only get transactions for the past 1 day

All of my other banks honor the requested date range so this is hard for most people to reproduce.
Comment 1 Glenn 2016-07-19 07:00:39 UTC
Exact same problem:  importing OFX transactions for my Citibank card pulled down the entire year.  If I delete the transactions, the next import pulls them all back down again, even when I configured the Start date of import to be the Last update date (just a few days ago).
Comment 2 Albert Astals Cid 2017-01-21 00:23:04 UTC
Git commit 32bcdfebc6476cf6595ea5dcd8d442cd56a511c5 by Albert Astals Cid, on behalf of Jeff Lundblad.
Committed on 21/01/2017 at 00:22.
Pushed by aacid into branch '4.8'.

Only import OFX requested date range

Only import transactions that are newer than or equal to the "Start date of import" in the account's online settings

Tested on Citi credit card OFX downloads which nearly always download 2 years worth of transactions regardless of the date range that the OFX request requests.

REVIEW: 128478

M  +35   -1    kmymoney/plugins/ofximport/ofximporterplugin.cpp

https://commits.kde.org/kmymoney/32bcdfebc6476cf6595ea5dcd8d442cd56a511c5
Comment 3 Albert Astals Cid 2017-01-21 00:23:44 UTC
Git commit 7bc87e6af0f4a5dd9a7eb9a75b78816004d29a90 by Albert Astals Cid, on behalf of Jeff Lundblad.
Committed on 21/01/2017 at 00:23.
Pushed by aacid into branch 'master'.

Only import OFX requested date range

Only import transactions that are newer than or equal to the "Start date of import" in the account's online settings

Tested on Citi credit card OFX downloads which nearly always download 2 years worth of transactions regardless of the date range that the OFX request requests.

REVIEW: 128478

M  +35   -1    kmymoney/plugins/ofximport/ofximporterplugin.cpp

https://commits.kde.org/kmymoney/7bc87e6af0f4a5dd9a7eb9a75b78816004d29a90