Re: OFX Import Bug

2017-01-16 Thread Brendan Coupe
Thomas, We've had this conversation many years ago. I think you said you spent some time in Santa Monica. I was living in Redondo beach at the time. I live in Palos Verdes now (still the LA area). Have you thought about how best to deal with the two cases that I've run into? I took a quick look

Re: OFX Import Bug

2017-01-13 Thread jef...@outlook.com
On 1/13/2017 3:36 AM, Thomas Baumgart wrote: Thanks for the detailed analysis. I think it hits the nail right on the head. Date and timezone handling is all done by libOFX (I fixed something myself in that are sometime ago - wow 7 years: https://github.com/libofx/libofx/commit/166b97964de3ed39863

Re: OFX Import Bug

2017-01-13 Thread Thomas Baumgart
Hi, On Thursday 12 January 2017 09:38:25 Brendan Coupe wrote: > My mistake, I meant DTEND not DTSTOP. :) > 1) Bank that is off by 1 day: > > ofxlog.txt: 2017011100.000 > kmm-statement-0.txt: enddate="2017-01-10" > KMM Ledger: Online Statement Balance - 2017.01.10 > > 2) Bank the reports 1

Re: OFX Import Bug

2017-01-12 Thread Brendan Coupe
My mistake, I meant DTEND not DTSTOP. 1) Bank that is off by 1 day: ofxlog.txt: 2017011100.000 kmm-statement-0.txt: enddate="2017-01-10" KMM Ledger: Online Statement Balance - 2017.01.10 2) Bank the reports 1969.12.31 ofxlog.txt: DTEND is not included in this file kmm-statement-0.txt: endda

Re: OFX Import Bug

2017-01-12 Thread Thomas Baumgart
Hi, On Wednesday 11 January 2017 21:42:18 Brendan Coupe wrote: > By convert I meant that KMM converted the end date that it receives from > the OFX download into the enddate the appears in my ledger and also appears > in the text file in the thb folder. > > I created the file that Thomas mention

Re: OFX Import Bug

2017-01-11 Thread Brendan Coupe
By convert I meant that KMM converted the end date that it receives from the OFX download into the enddate the appears in my ledger and also appears in the text file in the thb folder. I created the file that Thomas mentioned and was surprised there is no field called . There is a field called . I

Re: OFX Import Bug

2017-01-11 Thread Jack
On 2017.01.11 02:54, Brendan Coupe wrote: ​No, you reversed them. 2017011000 from the manually downloaded OFX file is being converted to 1969.12.31​. From the other bank 2014121221 from the manually downloaded OFX file ends up being the day before the oldest transaction in the txt

Re: OFX Import Bug

2017-01-11 Thread Thomas Baumgart
Hi, On Tuesday 10 January 2017 23:54:53 Brendan Coupe wrote: [...] > Is there any way to capture the data from the online OFX download by KMM? > It seems likely that it does not match the manual download from these two > banks websites. Yes: create a file called ofxlog.txt in your personal home

Re: OFX Import Bug

2017-01-10 Thread Brendan Coupe
​No, you reversed them. 2017011000 from the manually downloaded OFX file is being converted to 1969.12.31​. >From the other bank 2014121221 from the manually downloaded OFX file ends up being the day before the oldest transaction in the txt file. This makes no sense and I have only seen th

Re: OFX Import Bug

2017-01-10 Thread Thomas Baumgart
Hi Brendan, yes, the formats are very different, as one (downloaded OFX) represents the data exchanged between the bank and libOFX. The txt file saved in /home/thb OTOH is the intermediate statement format that is used by all importers (OFX, QIF, HBCI, ...) and the KMyMoney statement importer.

Re: OFX Import Bug

2017-01-10 Thread Brendan Coupe
When I said the formats are different I meant very different. The manually downloaded OFX files look like this: OFXHEADER:100 DATA:OFXSGML VERSION:102 SECURITY:NONE ... 20170109 2014121221 ... The txt files saved in /home/thb look like this: I've copied Thomas (thb) so that he may be

Re: OFX Import Bug

2017-01-10 Thread Jack
Brendan, I wish I knew more about the software the banks actually use, but that is not likely to happen. I'm not surprised that the manual download might be different from the direct connect download - but that's just based on experience. I would think they were generated by the same so

Re: OFX Import Bug

2017-01-10 Thread Brendan Coupe
Jack, Your suggestion is fine for testing but a non-starter for day to day use of KMM. I can live with bogus warnings about my account balance not matching the download balance. I downloaded both the OFX and QFX files from both banks. I diff'ed them and they are pretty similar (OFX vs QFX). The

Re: OFX Import Bug

2017-01-10 Thread Jack
On 2017.01.09 23:24, Brendan Coupe wrote: I'm having a problem with 2 accounts when I import the OFX using online banking. One account shows the Online Statement Balance on 12/31/1969. Another account shows the Online Statement Balance on 1/3/2017 while the most recent transaction is on 1/