tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/18327-ncsecu-transactions-not-downloadingInfinite Kind: Discussion 2023-11-24T09:30:28Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-05T18:56:19Z2021-03-05T18:56:19ZNCSECU Transactions Not Downloading<div><p>@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.</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-05T19:17:55Z2021-03-14T15:10:33ZNCSECU Transactions Not Downloading<div><p>.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-05T21:30:26Z2021-03-05T21:30:26ZNCSECU Transactions Not Downloading<div><p>That is a good sign!</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-09T16:08:21Z2021-03-09T18:56:48ZNCSECU Transactions Not Downloading<div><p>I sent the following message to NC SECU. I encourage anyone who hasn't yet contacted them to do so.</p>
<p>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.</p>
<hr>
<p>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.</p>
<p>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.</p>
<p>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).</p>
<p>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.</p>
<p>Please forward this to the appropriate department for review and please also include Crayton G. Matthews, CFP AFC, Vice-President, Member Services Support.</p>
<p>Thank you for your attention and any assistance you can provide,</p>
<hr>
<p>The following is the (mostly canned) response I received:</p>
<p>Date: 3/9/2021<br>
Subject: RE:Quicken<br>
From: Rebecca Howington</p>
<p>Dear Member,</p>
<p>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.</p>
<p>We also appreciate your feedback and suggestions regarding the .CSV file. We will submit your suggestions to the appropriate department for review.</p>
<p>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.</p></div>Danatag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-09T18:04:19Z2021-03-13T12:58:36ZNCSECU Transactions Not Downloading<div><p>.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-11T11:43:34Z2021-03-13T12:58:14ZNCSECU Transactions Not Downloading<div><p>.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-12T18:49:56Z2021-03-12T18:49:57ZNCSECU Transactions Not Downloading<div><p>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</p></div>margopowelltag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-12T19:22:02Z2021-03-13T12:58:25ZNCSECU Transactions Not Downloading<div><p>.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T12:57:24Z2021-03-14T10:13:18ZNCSECU Transactions Not Downloading<div><p>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...</p>
<p>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.</p>
<p>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.</p>
<p>The instructions are here. The walkthrough seems long, but that’s because we are trying to make this very simple.<br>
[<a href="https://github.com/yogi1967/MoneydancePythonScripts/raw/master/source/useful_scripts/ofx_create_new_secu_bank_custom_profile.pdf">https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sour...</a>]</p>
<p>This will be a one-time process (no science degree required - honest). Basically, you will be doing this:<br>
1) Ensure you know your current UserID and Password/Pin (required)<br>
2) Gather your current account information. (required)<br>
3) Get the script from the links provided here.<br>
4) Run the script provided.<br>
5) Add extra accounts within Moneydance (will be required if you have any)</p>
<p>We anticipate this (including the required items) will be about a 20-minute process.</p>
<p>The script is called:<br></p>
<pre>
<code>ofx_create_new_secu_bank_custom_profile.py</code>
</pre>
<p><strong>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</strong></p>
<p>You download the latest useful_scripts.zip package from my site: <a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a><br>
The specific link is: <a href="https://github.com/yogi1967/MoneydancePythonScripts/raw/master/useful_scripts.zip">https://github.com/yogi1967/MoneydancePythonScripts/raw/master/usef...</a></p>
<p>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:<br>
[<a href="https://github.com/yogi1967/MoneydancePythonScripts/raw/master/source/useful_scripts/ofx_create_new_secu_bank_custom_profile.pdf">https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sour...</a>]</p>
<p>READ THE LATEST GUIDE BEFORE YOU DO ANYTHING ELSE</p>
<p>Quick details:<br>
- This script runs in Moneybot. Moneydance>Window>Show Moneybot console>open (this script) > RUN</p>
<p><strong>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)</strong></p>
<p>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..</p>
<p><em>If anyone needs something different, I will consider (based on demand)</em></p>
<p>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).</p>
<p><strong>PLEASE BACKUP FIRST -> Menu File Export Backup</strong></p>
<p>I highly suggest you work on a test dataset, or even set up a new one with a checking and credit card account..</p>
<p>Once run:<br>
- carefully review the moneybot console.. Did the script complete..? Are the messages OK? If not, stop. Any problems, contact me. - Then RESTART Moneydance. <em>You must do this</em> - 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.</p>
<p>If anyone runs this script, let us know? If you have any problems work, let us know....</p>
<p><strong>If you get connection problems, please try disabling proxies, VPNs, Pi-Hole, Browser blockers, DNS Sinkholes, Cookie blockers to eliminate these as potential problems</strong></p>
<p>(not support, just a fellow user and creator of (the very free and most-excellent Toolbox 🧰 extension for Moneydance..) <a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T13:47:13Z2021-03-13T13:47:13ZNCSECU Transactions Not Downloading<div><p>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.</p>
<p>Last section of log file below</p>
<pre>
<code>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></code>
</pre></div>cgrindstag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:01:52Z2021-03-13T14:01:52ZNCSECU Transactions Not Downloading<div><p>what happens if you restart MD and try again?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:02:46Z2021-03-13T14:02:46ZNCSECU Transactions Not Downloading<div><p>To clarify, don't re-run the script, just retry the connection after a restart?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:09:06Z2021-03-13T14:09:06ZNCSECU Transactions Not Downloading<div><p>I did that a couple of times before posting. Same error.</p></div>cgrindstag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:10:36Z2021-03-13T14:10:37ZNCSECU Transactions Not Downloading<div><p>I was able to successfully download all accounts. A month's worth of<br>
transactions on 7 accounts is a lot to process! Thank you very much!</p></div>Scott Kirkpatricktag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:17:51Z2021-03-13T14:17:51ZNCSECU Transactions Not Downloading<div><p>@margopowell 😃 +1 (=1)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:18:11Z2021-03-13T14:24:08ZNCSECU Transactions Not Downloading<div><p>@Scott Kirkpatrick 😃 +1 (=2)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:19:47Z2021-03-13T14:19:47ZNCSECU Transactions Not Downloading<div><p>@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?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:26:58Z2021-03-13T14:26:58ZNCSECU Transactions Not Downloading<div><p>I'm on 3034, but the pi-hole suggestion was spot on.<br>
<strong>After disabling pi-hole, transactions downloaded without issue.</strong></p>
<p>Thanks!</p>
<p>SIGH - why on earth would OFX connections be blocked by pi-hole. Off to figure that out...</p></div>cgrindstag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T14:27:37Z2021-03-13T14:27:37ZNCSECU Transactions Not Downloading<div><p>@cgrinds 😃 +1 (=3)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T15:30:49Z2021-03-13T15:31:58ZNCSECU Transactions Not Downloading<div><p>Stuart you are the BEST!</p>
<p>I was able to get my NC SECU accounts up and running.<br>
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.</p>
<p>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.</p></div>margopowelltag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-13T16:22:26Z2021-03-13T16:22:26ZNCSECU Transactions Not Downloading<div><p>I want to give this a try but am away from<br>
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.</p>
<p>Lisa P. Cunningham</p></div>panthersfantag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T10:14:18Z2021-03-14T10:14:18ZNCSECU Transactions Not Downloading<div><p>All, NC SECU specific instructions are now available as a PDF within the package - link above on post 39. (thanks @dtd)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T14:31:15Z2021-03-14T14:31:15ZNCSECU Transactions Not Downloading<div><p>I've added a new configuration file for 'SECU' for hleofxquotes tool</p>
<ul>
<li><a href="https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/ofx-SECU.txt">https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/ofx-SECU.txt</a></li>
<li><a href="https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/Download_OFX">https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/Download_OFX</a></li>
</ul></div>hleofxquotestag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T15:08:50Z2021-03-14T15:08:50ZNCSECU Transactions Not Downloading<div><p>@hleofxquotes thanks! That works too.</p>
<p>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.</p></div>cgrindstag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T16:00:36Z2021-03-14T16:00:36ZNCSECU Transactions Not Downloading<div><blockquote>
<p>download ofx files from the command line</p>
</blockquote>
<p>I have a test version that will let you download via command-line</p>
<ul>
<li>Wiki: <a href="https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/Download_OFX_Command_Line">https://bitbucket.org/hleofxquotesteam/hleofxquotes/wiki/Download_O...</a></li>
<li>Download: <a href="https://bitbucket.org/hleofxquotesteam/hleofxquotes-test/downloads/">https://bitbucket.org/hleofxquotesteam/hleofxquotes-test/downloads/</a></li>
</ul>
<p>You can keep multiple versions of hleofxquotes. Each "installation" is fully self-enclosed in its own directory.</p></div>hleofxquotestag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T16:22:21Z2021-03-14T16:22:21ZNCSECU Transactions Not Downloading<div><p>@hleofxquotes excellent! that worked well for downloading SECU</p></div>cgrindstag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T16:56:09Z2021-03-14T16:56:09ZNCSECU Transactions Not Downloading<div><p>Great work!</p></div> Terrytag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-14T17:15:50Z2021-03-14T17:15:50ZNCSECU Transactions Not Downloading<div><p>@Terry 😃 +1 (=4)</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-15T22:51:56Z2021-03-15T22:51:56ZNCSECU Transactions Not Downloading<div><p>Hi All,</p>
<p>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:</p>
<p>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</p>
<p>Please let us know if this doesn't work for you.</p>
<p>All the best,<br>
Sean</p>
<p>--<br>
Sean Reilly<br>
Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/490464652021-03-15T23:13:30Z2021-03-20T21:40:32ZNCSECU Transactions Not Downloading<div><p>Greetings:</p>
<p>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:</p>
<p>There was an error communicating with your financial institution. The details of this error are below.</p>
<p>Bank Name: State Employees Credit Union - NC</p>
<p>A communication or parsing error occurred. This could be the result of a network problem, a proxy error, or misconfigured server.<br>
Error Description: javax.net.ssl.SSLProtocolException: Connection reset</p>
<p>Mark</p></div>mdubbie