<div dir="ltr">Hi, Jack<br><div><div class="gmail_extra"><br><div class="gmail_quote">2017-12-01 20:18 GMT-03:00 Jack <span dir="ltr"><<a href="mailto:ostroffjh@users.sourceforge.net" target="_blank">ostroffjh@users.sourceforge.net</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello Gilberto,<span class="gmail-"><br>
<br>
On <a href="tel:2017.12.01%2016" value="+12017120116" target="_blank">2017.12.01 16</a>:05, Gilberto wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Since Monday I'm dealing with a problem [1] while importing the credit card's ofx file.<br>
As you can see it is not detecting duplication and all transactions are with inverted type (Charge and Payment).<br>
Anyone has seen this?<br>
<br>
Regards,<br>
Gilberto.<br>
<br>
environment:<br>
OpenSUSE 42.3<br>
Kmymoney Version 4.8.0-35.3<br>
KDE Development Platform 4.14.33<br>
<br>
[1] <a href="https://www.dropbox.com/s/z7ckm8zghd0j1x3/kmymoney-ofx-" rel="noreferrer" target="_blank">https://www.dropbox.com/s/z7ck<wbr>m8zghd0j1x3/kmymoney-ofx-</a> importing-issue.png?dl=0<br>
</blockquote>
<br></span>
Before any other details, my personal guess is that your bank made some change to how they prepare the OFX file. I would suggest calling them just in case they know and are willing to say anything, although I consider that unlikely.</blockquote><div><br></div><div>I've done it. They said there weren't change in their export utility.<br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> Also, do you know of anything else that changed recently that might have an effect on this? (<br>
<br>
There have certainly been reports of repeated imports not matching, although I do not recall any issue of all amounts being negated (the inversion you see.)<br></blockquote><div><br></div><div>Yes, since about october have done the match manually after import - but recently the amounts being negated make things very difficult <br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
To help, we need some additional information. Are you using libofx or aqbanking? <br></blockquote><div><br></div><div>I think is libofx - have never used aqbanking. <br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> Are you importing a downloaded ofx file, or using direct connect? <br></blockquote><div><br></div><div>ofx file <br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> If you import the file a third time, does it match the second import, or create yet a third copy of each transaction?</blockquote><div><br></div><div>It match (duplication is detected)<br></div><div> <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> Can you provide one example of the section of the ofx file for just one of the transactions? Be sure not to include any sensitive information such as account number or password, but those should not occur within a transaction.<br></blockquote><div><br></div><div><BANKTRANLIST><br><DTSTART>20170928</DTSTART><br><DTEND>20171126</DTEND><br><STMTTRN><TRNTYPE>CREDIT</TRNTYPE><br><DTPOSTED>20171110</DTPOSTED><br><TRNAMT>-1200.04</TRNAMT><br><FITID>2017111054640000000055100000000000</FITID><br><MEMO>PGTO DEBITO CONTA 200211</MEMO><br></STMTTRN><br><STMTTRN><TRNTYPE>PAYMENT</TRNTYPE><br><DTPOSTED>20171027</DTPOSTED><br><TRNAMT>24.00</TRNAMT><br><FITID>2017102754640000000055100000000001</FITID><br><MEMO>LUMIERE PALMAS PALMAS BRA</MEMO><br></STMTTRN><br><STMTTRN><TRNTYPE>PAYMENT</TRNTYPE><br><DTPOSTED>20171027</DTPOSTED><br><TRNAMT>7.10</TRNAMT><br><FITID>2017102754640000000055100000000002</FITID><br><MEMO>E J DA ROCHA ME PALMAS BRA</MEMO><br></STMTTRN><br></BANKTRANLIST></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
Another question - do you import ofx files from any other banks, and if so, do you see the problem with them, or only with this one credit card?<span class="gmail-HOEnZb"><font color="#888888"><br></font></span></blockquote><div><br></div><div>From the same bank, but checking account - have problems with matching as well - but not the negative one.<br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span class="gmail-HOEnZb"><font color="#888888">
<br>
<br>
Jack<br>
</font></span></blockquote></div>Thank you<br></div></div></div>