NCSECU Transactions Not Downloading

mdubbie's Avatar

mdubbie

20 Feb, 2021 01:38 PM

Greetings:

2 days ago I began receiving this error and transactions for the bank will not download. I removed the account number for privacy. Any suggestions?

There was an error communicating with your financial institution. The details of this error are below.

Bank Name: State Employees Credit Union - NC
Account: CU Checking
Account Number: XXXXXXXX

A communication or parsing error occurred. This could be the result of a network problem, a proxy error, or misconfigured server.
Error Description: javax.net.ssl.SSLProtocolException: Connection reset

Showing page 2 out of 5. View the first page

  1. 31 Posted by sth on 05 Mar, 2021 06:56 PM

    sth's Avatar

    @Stuart, if like Schwab they have restricted the access to a single IP address (or a few addresses) then Sean will have to set up a machine to tunnel all the connections through so they come from a single IP address. It doesn't matter what the OFX settings are if NCSECU is filtering at a firewall.

  2. 32 Posted by Stuart Beesley ... on 05 Mar, 2021 07:17 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    .

  3. 33 Posted by sth on 05 Mar, 2021 09:30 PM

    sth's Avatar

    That is a good sign!

  4. 34 Posted by Dana on 09 Mar, 2021 04:08 PM

    Dana's Avatar

    I sent the following message to NC SECU. I encourage anyone who hasn't yet contacted them to do so.

    When I contacted them last year, they referred me to the CSV download option, so I have attempted to circumvent that suggestion in my message.

    -------------------

    I am again receiving an error when downloading transactions into Moneydance Financial Software. I am aware that SECU only officially supports Quicken, but downloading into Moneydance has worked for many years. This or a very similar problem occurred about a year ago but was resolved in a manner that allowed Moneydance to continue to download transactions.

    I have been following this issue for a couple of weeks on the Moneydance support forums. I am contacting SECU to request that you work with Moneydance/Infinite Kind staff to resolve this issue in a way that addresses whatever concerns caused the recent change but still allows Moneydance users to directly download transaction information.

    I am aware that SECU makes CSV file downloads available. This file type is cumbersome to the point of being unusable for routine (daily) transaction download. While I would very much prefer that SECU continue to allow direct connection downloads into Moneydance, a nominally workable alternative would be to allow the download of Web Connect formatted files via web browser. This is a tedious and cumbersome method of importing transactions, but produces usable results (unlike the CSV import).

    Again, I implore and strongly urge SECU to allow the continued use of Direct Connect downloads by all members and not exclude those of us who prefer to utilize the excellent Moneydance financial software or similar alternatives over Quicken. I used Quicken for a long time prior to switching to Moneydance and have found Moneydance to be a far superior product in both function and developer support.

    Please forward this to the appropriate department for review and please also include Crayton G. Matthews, CFP AFC, Vice-President, Member Services Support.

    Thank you for your attention and any assistance you can provide,

    -----------------------------------

    The following is the (mostly canned) response I received:

    Date: 3/9/2021
    Subject: RE:Quicken
    From: Rebecca Howington
     
    Dear Member,

    Thank you for your message. We currently have restricted access to 3rd parties using the OFX channel (a "direct connection" to account info) except for the software that we have a history with (Quicken). We are looking at the possibility of adding an FDX channel, which will open up connections to many more trusted 3rd party services. We will add MoneyDance to our list of applications to review while we are vetting other applications and connectivity methods. While we do not have an available timeline for this possible update, please know we are working diligently towards that end. We apologize for any inconvenience this current situation may be causing you.

    We also appreciate your feedback and suggestions regarding the .CSV file. We will submit your suggestions to the appropriate department for review.

    If you have any more questions or issues, please visit your local branch, contact us through secure messaging, or call the Member Services at (888)732-8562. As always, thank you for supporting your Credit Union.

  5. 35 Posted by Stuart Beesley ... on 09 Mar, 2021 06:04 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    .

  6. 36 Posted by Stuart Beesley ... on 11 Mar, 2021 11:43 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    .

  7. 37 Posted by margopowell on 12 Mar, 2021 06:49 PM

    margopowell's Avatar

    Stuart I would be interested in trying to get a custom connection profile working. It has been a month since I tried to login to NCSECU. Let me know what I need to provide you to get this working

  8. 38 Posted by Stuart Beesley ... on 12 Mar, 2021 07:22 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    .

  9. 39 Posted by Stuart Beesley ... on 13 Mar, 2021 12:57 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    GOOD NEWS - With @margopowell's help I have created a script to create a custom connection profile for NCSECU - and it seems to work. Margo reports successful downloads...

    DISCLAIMER: I have no affiliation with Moneydance. It's entirely possible that these won't work for you. Pretty much the worst that can happen is that your bank logon / service profile won't work - but then it's not working anyway.. You can always just delete the profile and start again, if you wish. PLEASE ALWAYS BACKUP YOUR DATA FIRST AND TEST ON A TEST COPY BEFORE APPLYING TO YOUR LIVE DATASET! It is worth mentioning that the IK developer has given his ‘acknowledgement’ to my usaa version of this script.

    This fix is interim until IK release a proper fix/update... NOTE: This script deletes your existing NCSECU bank/logon profile and creates a new custom NCSECU profile for you. Once MD is fixed, you can at some point delete this and let Moneydance create a new profile; but this is a standard thing to do anyway.

    The instructions are here. The walkthrough seems long, but that’s because we are trying to make this very simple.
    [https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sour...]

    This will be a one-time process (no science degree required - honest). Basically, you will be doing this:
    1) Ensure you know your current UserID and Password/Pin (required)
    2) Gather your current account information. (required)
    3) Get the script from the links provided here.
    4) Run the script provided.
    5) Add extra accounts within Moneydance (will be required if you have any)

    We anticipate this (including the required items) will be about a 20-minute process.

    The script is called:

    ofx_create_new_secu_bank_custom_profile.py
    

    FYI - When you click these links below, you will see a blank screen (depending on your browser) and the file(s) will auto download to your downloads folder

    You download the latest useful_scripts.zip package from my site: https://yogi1967.github.io/MoneydancePythonScripts/
    The specific link is: https://github.com/yogi1967/MoneydancePythonScripts/raw/master/usef...

    The first thing to do is read the latest walk through PDF guide: ofx_create_new_secu_bank_custom_profile.pdf. The Latest guide (now version 6f) is always here:
    [https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sour...]

    READ THE LATEST GUIDE BEFORE YOU DO ANYTHING ELSE

    Quick details:
    - This script runs in Moneybot. Moneydance>Window>Show Moneybot console>open (this script) > RUN

    Once you have run the script and you have proven that it's working you can then just use the standard Moneydance Online menu to link your additional NCSECU account(s)

    CREATE NEW CUSTOM PROFILE SCRIPT: This will delete any/all existing NCSECU profiles, and then create a new one from scratch. This allows up to max 1 checking account and up to max 1 credit card account..

    If anyone needs something different, I will consider (based on demand)

    The script will change/edit any existing NCSECU profiles, related userid, passwords, authentication, and also update the link to your MD bank / CC account(s).

    PLEASE BACKUP FIRST -> Menu File Export Backup

    I highly suggest you work on a test dataset, or even set up a new one with a checking and credit card account..

    Once run:
    - carefully review the moneybot console.. Did the script complete..? Are the messages OK? If not, stop. Any problems, contact me. - Then RESTART Moneydance. You must do this - Then launch Help>Show Console - With Console open, try downloading...... Do not keep doing this as the bank may block you. If it doesn't work, then the OFX header and data will be useful. - Error 2003 means you have either entered an incorrect account number, or you have Checking and Savings mixed up, or your CC number has changed - the connection is actually working OK if you see this error.

    If anyone runs this script, let us know? If you have any problems work, let us know....

    If you get connection problems, please try disabling proxies, VPNs, Pi-Hole, Browser blockers, DNS Sinkholes, Cookie blockers to eliminate these as potential problems

    (not support, just a fellow user and creator of (the very free and most-excellent Toolbox 🧰 extension for Moneydance..) https://yogi1967.github.io/MoneydancePythonScripts/

  10. 40 Posted by cgrinds on 13 Mar, 2021 01:47 PM

    cgrinds's Avatar

    Hi Stuart - Thanks for putting this together. I went through the steps, restarted, and no luck. The correct user-agent is being sent but the server rejects the request saying we've gotten some OFX with no headers.

    Last section of log file below

    connecting to: https://onlineaccess.ncsecu.org/secuofx/secu.ofx with method: POST
    Connecting with https headers:
    POST /secuofx/secu.ofx HTTP/1.1
    Host: onlineaccess.ncsecu.org
    Content-Type: application/x-ofx
    Accept-Language: en-us
    Date: Sat, 13 Mar 2021 08:36:58 EST
    Accept: */*
    User-Agent: InetClntApp/3.0
    Content-Length: 657
    Cache-Control: no-cache
    Connection: close
    
    ---end headers
    HTTP/1.1 200 OK
    Cache-Control: no-store, must-revalidate, no-cache
    Pragma: no-cache
    Connection: close
    Content-Type: text/html
    Content-Length: 245
    Connection: close
    
    HTTP response headers: 
    content-length: [245]
    content-type: [text/html]
    connection: [close]
    cache-control: [no-store, must-revalidate, no-cache]
    pragma: [no-cache]
    Reading message from https://onlineaccess.ncsecu.org/secuofx/secu.ofx
    >>>>>>>>
    
    <html>uh oh, we've gotten some OFX with no headers: <html>
    
  11. 41 Posted by Stuart Beesley ... on 13 Mar, 2021 02:01 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    what happens if you restart MD and try again?

  12. 42 Posted by Stuart Beesley ... on 13 Mar, 2021 02:02 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    To clarify, don't re-run the script, just retry the connection after a restart?

  13. 43 Posted by cgrinds on 13 Mar, 2021 02:09 PM

    cgrinds's Avatar

    I did that a couple of times before posting. Same error.

  14. 44 Posted by Scott Kirkpatri... on 13 Mar, 2021 02:10 PM

    Scott Kirkpatrick's Avatar

    I was able to successfully download all accounts. A month's worth of
    transactions on 7 accounts is a lot to process! Thank you very much!

  15. 45 Posted by Stuart Beesley ... on 13 Mar, 2021 02:17 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @margopowell 😃 +1 (=1)

  16. 46 Posted by Stuart Beesley ... on 13 Mar, 2021 02:18 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @Scott Kirkpatrick 😃 +1 (=2)

  17. 47 Posted by Stuart Beesley ... on 13 Mar, 2021 02:19 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @cgrinds - what version of MD? If MD2021 - please try preview build 3036/3039. I saw this originally, but then it was OK. Do you have a proxy, VPN, cache blockers, pihole etc?

  18. 48 Posted by cgrinds on 13 Mar, 2021 02:26 PM

    cgrinds's Avatar

    I'm on 3034, but the pi-hole suggestion was spot on.
    After disabling pi-hole, transactions downloaded without issue.

    Thanks!

    SIGH - why on earth would OFX connections be blocked by pi-hole. Off to figure that out...

  19. 49 Posted by Stuart Beesley ... on 13 Mar, 2021 02:27 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @cgrinds 😃 +1 (=3)

  20. 50 Posted by margopowell on 13 Mar, 2021 03:30 PM

    margopowell's Avatar

    Stuart you are the BEST!

    I was able to get my NC SECU accounts up and running.
    As Stuart indicates in his instructions you only need to run the script once - I was an idiot and ran it twice (which wiped out my previous account setup). You run the script once for your first account and then update the rest of your SECU accounts via Menu Bar > Online > Setup Online Banking Account.

    Stuart - thanks IMMENSELY FOR YOUR time and effort to make downloads work again for my SECU account and I am now off to work on your USAA patch to allow downloads there as well.

  21. 51 Posted by panthersfan on 13 Mar, 2021 04:22 PM

    panthersfan's Avatar

    I want to give this a try but am away from
    my computer access for a few days. It will be mid week before I can do it. Thank you Stuart for your attempts to help.

    Lisa P. Cunningham

  22. 52 Posted by Stuart Beesley ... on 14 Mar, 2021 10:14 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    All, NC SECU specific instructions are now available as a PDF within the package - link above on post 39. (thanks @dtd)

  23. 53 Posted by hleofxquotes on 14 Mar, 2021 02:31 PM

    hleofxquotes's Avatar
  24. 54 Posted by cgrinds on 14 Mar, 2021 03:08 PM

    cgrinds's Avatar

    @hleofxquotes thanks! That works too.

    Is it possible to setup the fi properties via the UI, but then download ofx files from the command line? That would help with some automation I have around this.

  25. 55 Posted by hleofxquotes on 14 Mar, 2021 04:00 PM

    hleofxquotes's Avatar

    download ofx files from the command line

    I have a test version that will let you download via command-line

    You can keep multiple versions of hleofxquotes. Each "installation" is fully self-enclosed in its own directory.

  26. 56 Posted by cgrinds on 14 Mar, 2021 04:22 PM

    cgrinds's Avatar

    @hleofxquotes excellent! that worked well for downloading SECU

  27. 57 Posted by Terry on 14 Mar, 2021 04:56 PM

     Terry's Avatar

    Great work!

  28. 58 Posted by Stuart Beesley ... on 14 Mar, 2021 05:15 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    @Terry 😃 +1 (=4)

  29. Support Staff 59 Posted by Sean Reilly on 15 Mar, 2021 10:51 PM

    Sean Reilly's Avatar

    Hi All,

    Huge thanks to Stuart Beesley for figuring out the magic parameters to get this connection working again. I've pushed the updates out to the existing connections, so if you'd like to switch back to using the official NCSECU connection, please take the following steps for each account:

    1) Select your account 2) Select the Online->Setup Online Banking menu 3) Click the Disable button. If no Disable button appears, then you should see the setup wizard at which point please proceed to step 5 4) Online->Setup Online Banking menu, again 5) Click the New Connection button, and select "State Employees Credit Union - NC" from the list of connections that appear 6) Continue to set up the connection as normal

    Please let us know if this doesn't work for you.

    All the best,
    Sean

    --
    Sean Reilly
    Developer, The Infinite Kind
    https://infinitekind.com

  30. 60 Posted by mdubbie on 15 Mar, 2021 11:13 PM

    mdubbie's Avatar

    Greetings:

    I do wish to thank Stuart Beesley and other's for working on a solution. I did try what Sean suggested and now I am receiving this error:

    There was an error communicating with your financial institution. The details of this error are below.

    Bank Name: State Employees Credit Union - NC

    A communication or parsing error occurred. This could be the result of a network problem, a proxy error, or misconfigured server.
    Error Description: javax.net.ssl.SSLProtocolException: Connection reset

    Mark

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