Bug 365818

Summary:	OFX Import Ignores Requested Date Range
Product:	[Applications] kmymoney	Reporter:	Brendan <KDE>
Component:	importer	Assignee:	KMyMoney Devel Mailing List <kmymoney-devel>
Status:	RESOLVED FIXED
Severity:	normal	CC:	kde, ralf.habacker
Priority:	NOR
Version:	unspecified
Target Milestone:	---
Platform:	Compiled Sources
OS:	Linux
Latest Commit:	https://commits.kde.org/kmymoney/7bc87e6af0f4a5dd9a7eb9a75b78816004d29a90	Version Fixed In:	4.8.1,5.0.0
Sentry Crash Report:

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