error importing qfx java.lang.NumberFormatException: For input string: "R" CONTINUED

Rob's Avatar

Rob

21 Sep, 2020 08:24 PM

You guys closed this discussion but I wanted to add a comment and can't re-open it

  1. 1 Posted by Rob on 21 Sep, 2020 08:25 PM

    Rob's Avatar

    revzoom
    Sep 16, 2020 @ 08:48 PM

    Please help with this error. This is a new error for me.
    Details are as follows.
    1) 2020.1 (1928) The version and build number of Moneydance it is that you are / were using.
    2) Synchrony Bank: The name of the Bank
    3) MasterCard: The name of the Credit Card Company?
    4) See the Subject Line: The exact text of any error messages you may be receiving when attempting to import your data.
    5) Manually importing a file from your bank's website.
    6)Mac 10.14.6
    Thanks!

    1 Posted by revzoom on Sep 17, 2020 @ 08:01 AM

    revzoom's Avatar
    Today the download worked, so it must have been a problem with the bank.

    revzoom closed this discussion on Sep 17, 2020 @ 08:01 AM.

    revzoom re-opened this discussion on Sep 19, 2020 @ 09:25 AM

    2 Posted by revzoom on Sep 19, 2020 @ 09:26 AM

    revzoom's Avatar
    And today, the error is back. Transaction file attached.

    3 Posted by revzoom on Sep 19, 2020 @ 09:42 AM

    revzoom's Avatar
    I found a difference in two files downloaded from Synchrony
    I found this in the file that does not work.
       <DTSTART>R
    <DTEND>R
    This is from the file that does import without error, but the date is not current.
                            <DTSTART>20200717
    <DTEND>20200717

    SUPPORT STAFF4 Posted by Maddy on Sep 19, 2020 @ 11:35 AM

    Maddy's Avatar
    Thank you for reporting back!

    We are very pleased to hear that.

    I'll close this discussion for now, but do not hesitate to contact us again, if you need further assistance.

    --
    Maddy, Infinite Kind Support

    Maddy closed this discussion on Sep 19, 2020 @ 11:35 AM.

  2. 2 Posted by Rob on 21 Sep, 2020 08:31 PM

    Rob's Avatar

    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):

    There was an error importing the file 'Transaction 5.qfx': java.lang.NumberFormatException: For input string: "R"

    I discovered the same code in the file that did not work:
       <DTSTART>R
    <DTEND>R

    So, I edited the file to put in the proper date sequence
       <DTSTART>20020824
    <DTEND>20020915

    Opened the file and all the transactions were downloaded successfully.

    ===================================

    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
       <DTSTART>R
    <DTEND>R
    commands and just load the file anyway if it finds VALID data.

    That is my input/comment and I am sticking to it! Thanks -- Rob Harris

  3. 3 Posted by derekkent23 on 21 Sep, 2020 09:56 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Rob

    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?

    Taking a look at the OFX specification it is apparent that if present both <DTSTART> and <DTEND> should be used to define the date range of the included transactions.

    For example, my bank OFX file includes

    <DTSTART>20200810</DTSTART>
     <DTEND>20200908</DTEND>

    And this conforms to the example in the OFX Specification page 238 relating to a statement download.

    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.

    Food for thought.

  4. 4 Posted by larry on 22 Sep, 2020 03:28 AM

    larry's Avatar

    I am getting the same error - There was an error importing the file 'Transaction 5.qfx': java.lang.NumberFormatException: For input string: "R"

    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?
    I agree with Rob's assessment: "My guess is that IK should consider IGNORING the
    R R
    commands and just load the file anyway if it finds VALID data."

    I just answered my own question. I should be able to d/l using the QIF format.

  5. 5 Posted by Rob on 22 Sep, 2020 01:01 PM

    Rob's Avatar

    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.

  6. Support Staff 6 Posted by Maddy on 23 Sep, 2020 08:14 AM

    Maddy's Avatar

    Hi all,
    We are sorry to hear about the problem you've encountered and thank you for reporting it.

    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.

    Thank you for your patience and sorry for the inconvenience.

    --
    Maddy, Infinite Kind Support

  7. 7 Posted by Oscar Tamyo on 24 Sep, 2020 05:32 PM

    Oscar Tamyo's Avatar

    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.

  8. Support Staff 8 Posted by Maddy on 25 Sep, 2020 08:05 AM

    Maddy's Avatar

    Hi Oscar,

    As I mentioned in my previous reply, our development team is currently working on implementing a fix to correct the problem.

    I have flagged this discussion and you will be notified as soon as, this is confirmed.

    --
    Maddy, Infinite Kind Support

  9. 9 Posted by Rob on 23 Oct, 2020 04:11 PM

    Rob's Avatar

    This is a reply to (Posted by Oscar Tamyo on Sep 24, 2020 @ 01:32 PM)

    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:

    <BANKTRANLIST>
    <DTSTART>R
    <DTEND>R
    -------------------------------------
    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:

    <BANKTRANLIST>
    <DTSTART>20200924
    <DTEND>20201021

    Close the application (Wordpad or notepad) by clicking the "X" and be sure to SAVE it.

    Now just double-click the transaction file you just saved and it will be accepted by Moneydance. Good luck.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac