tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/63331-error-importing-qfx-javalangnumberformatexception-for-input-string-r-continuedInfinite Kind: Discussion 2021-01-22T16:20:25Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-21T20:25:51Z2020-09-21T20:25:51Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>revzoom<br>
Sep 16, 2020 @ 08:48 PM</p>
<p>Please help with this error. This is a new error for me.<br>
Details are as follows.<br>
1) 2020.1 (1928) The version and build number of Moneydance it is that you are / were using.<br>
2) Synchrony Bank: The name of the Bank<br>
3) MasterCard: The name of the Credit Card Company?<br>
4) See the Subject Line: The exact text of any error messages you may be receiving when attempting to import your data.<br>
5) Manually importing a file from your bank's website.<br>
6)Mac 10.14.6<br>
Thanks!</p>
<p>1 Posted by revzoom on Sep 17, 2020 @ 08:01 AM</p>
<p>revzoom's Avatar<br>
Today the download worked, so it must have been a problem with the bank.</p>
<p>revzoom closed this discussion on Sep 17, 2020 @ 08:01 AM.</p>
<p>revzoom re-opened this discussion on Sep 19, 2020 @ 09:25 AM</p>
<p>2 Posted by revzoom on Sep 19, 2020 @ 09:26 AM</p>
<p>revzoom's Avatar<br>
And today, the error is back. Transaction file attached.</p>
<p>3 Posted by revzoom on Sep 19, 2020 @ 09:42 AM</p>
<p>revzoom's Avatar<br>
I found a difference in two files downloaded from Synchrony<br>
I found this in the file that does not work.<br>
R R<br>
This is from the file that does import without error, but the date is not current.<br>
20200717 20200717</p>
<p>SUPPORT STAFF4 Posted by Maddy on Sep 19, 2020 @ 11:35 AM</p>
<p>Maddy's Avatar<br>
Thank you for reporting back!</p>
<p>We are very pleased to hear that.</p>
<p>I'll close this discussion for now, but do not hesitate to contact us again, if you need further assistance.</p>
<p>-- Maddy, Infinite Kind Support</p>
<p>Maddy closed this discussion on Sep 19, 2020 @ 11:35 AM.</p></div>Robtag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-21T20:31:02Z2020-09-21T20:33:01Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>Ok, now you can see the discussion that was closed above. My comment is that I was getting this error when I tried to open the transaction file as created synchrony bank (Sam's Mastercard):</p>
<p>There was an error importing the file 'Transaction 5.qfx': java.lang.NumberFormatException: For input string: "R"</p>
<p>I discovered the same code in the file that did not work:<br>
R R</p>
<p>So, I edited the file to put in the proper date sequence<br>
20020824 20020915</p>
<p>Opened the file and all the transactions were downloaded successfully.</p>
<p>===================================</p>
<p>My point to Infinite Kind is that I don't think the dates in those commands even matter since each transaction has its own date on each one. My guess is that IK should consider IGNORING the<br>
R R<br>
commands and just load the file anyway if it finds VALID data.</p>
<p>That is my input/comment and I am sticking to it! Thanks -- Rob Harris</p></div>Robtag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-21T21:56:09Z2020-09-22T06:56:06Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>I am not support staff, just a user.<br>
Hi Rob</p>
<p>Have you considered that the OFX file provided by your bank is not conforming to the OFX specification and as such Moneydance is correct in flagging an import error?</p>
<p>Taking a look at the OFX specification it is apparent that if present both and should be used to define the date range of the included transactions.</p>
<p>For example, my bank OFX file includes</p>
<p>20200810<br>
20200908</p>
<p>And this conforms to the example in the OFX Specification page 238 relating to a statement download.</p>
<p>In your position, I would be asking my bank are they conforming to the OFX specification and if so, why have they not used a valid date range and what does the “R” mean in this context.</p>
<p>Food for thought.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-22T03:28:21Z2020-09-22T03:38:19Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>I am getting the same error - There was an error importing the file 'Transaction 5.qfx': java.lang.NumberFormatException: For input string: "R"</p>
<p>I can do as stated, that is change the R & R to reflect the correct date. It seems that this fix will have to be applied manually each time that data is downloaded. Am i correct in my assumption?<br>
I agree with Rob's assessment: "My guess is that IK should consider IGNORING the<br>
R R<br>
commands and just load the file anyway if it finds VALID data."</p>
<p>I just answered my own question. I should be able to d/l using the QIF format.</p></div>larrytag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-22T13:01:42Z2020-09-22T13:01:42Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>You both have good points. I first contacted Synchrony and they gave me the same answer all banks give. Contact Quicken support. If you say "Moneydance" they consider you a "quack" (since they do not recognize it) and brush you off. Anyway, as Larry says, I don't understand what ignoring the "R" would do or even why the date range is required for individual transactions with dates.</p></div>Robtag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-23T08:14:55Z2020-09-23T08:14:55Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>Hi all,<br>
We are sorry to hear about the problem you've encountered and thank you for reporting it.</p>
<p>Unfortunately some other customers have been reporting the same error, so please be reassured that his issue has been raised with our lead developer, and we're working to get this resolved. I'll update you as soon as we have more information.</p>
<p>Thank you for your patience and sorry for the inconvenience.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-24T17:32:49Z2020-09-24T17:32:51Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>I also just recently started having the same problem with Sam's Mastercard downloads. Can someone in layman terms explain to me how you overcame this problem. I see mention of start and stop dates but my Sam's MC website does not have a feature to pick a range of dates. Only completed activities. Thanks in advance for your help.</p></div>Oscar Tamyotag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-09-25T08:05:01Z2020-09-25T08:05:01Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>Hi Oscar,</p>
<p>As I mentioned in my previous reply, our development team is currently working on implementing a fix to correct the problem.</p>
<p>I have flagged this discussion and you will be notified as soon as, this is confirmed.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/486500122020-10-23T16:11:02Z2020-10-23T16:12:05Zerror importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED<div><p>This is a reply to (Posted by Oscar Tamyo on Sep 24, 2020 @ 01:32 PM)</p>
<p>To work around this, download transactions from the Sams MC website and there will be a file called "Transaction.qfx" (if you have more than one it will have a number in the name). Locate the latest file (the one you just downloaded), right click on it and open it with notepad or wordpad. Look down in the file and you will see the following lines about 30-40 lines in:</p>
<p><br>
R</p>
<h2><a name="-dtend-r" class="anchor" href="#-dtend-r"></a> R</h2>
<p>I don't know or care what the "R" means, I just know Moneydance will not accept it until you make a small edit. Make the lines look like the following lines using the first date of the period (usually the date after the last statement date; if your last statement date was September 23rd then you put "20200924" as the starting date since it is the next day). I use yesterday as the ending date since you can't download today's transactions normally. So assuming yesterday was October 21st you would use "20201021" as the ending date. When you do it, it should now look like this:</p>
<p><br>
20200924 20201021</p>
<p>Close the application (Wordpad or notepad) by clicking the "X" and be sure to SAVE it.</p>
<p>Now just double-click the transaction file you just saved and it will be accepted by Moneydance. Good luck.</p></div>Rob