Schwab transactions not downloading
No error message, but it says the transactions download. does not. I am having to download and post new clearing transactions manually. Is this a Schwab error or moneydance error? Any idea on when fixed?
Showing page 6 out of 6. View the first page
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
151 Posted by tbhimdi on 16 Jan, 2021 01:04 PM
@Stuart
I did what you asked, here are the results:
1) I've never touched my backups dir, it's currently set to "C:\Users\name\.moneydance\archive\backups"
2) Ran the improved script three times (snippets attached).
2a) Opened up moneydance, ran script, closed moneydance (result #1)
2b) Opened up moneydance, ran script, closed moneydance (result #2)
2c) Opened up moneydance, updated Schwab Checking (bottom bar said downloading 3101 transactions, but no new transactions came up), ran script (result #3)
3) I compared yesterday's moneydancearchive to the latest just now. With only the three actions above, today's moneydancearchive has increased in size (181.10MB to 189.96MB).
152 Posted by Stuart Beesley ... on 16 Jan, 2021 01:34 PM
I don't think it's the txns (unless I don't understand something) as the numbers are all the same (except the last with just 5 more)?
I am writing a script right now to analysis the data directory (I will also include in toolbox)... I'll upload it a bit later....
in the meantime, perhaps post a screen shot of the contents of your something.moneydance folder
(not support)
153 Posted by tbhimdi on 16 Jan, 2021 01:41 PM
The name.moneydance subfolder under ".moneydance/archive/backups" or ".moneydance/Documents"?
154 Posted by Stuart Beesley ... on 16 Jan, 2021 02:02 PM
Find your config.dict file, take a look with a text editor.
Look for this line:
"current_accountbook" = "/Users/xx/Documents/Moneydance/something.moneydance"
This is the dataset name.
Now look inside this directory (or on a Mac right click and show package contents)
155 Posted by Stuart Beesley ... on 16 Jan, 2021 02:03 PM
(put differently, look inside the file/folder that you say is now xxxMB)
156 Posted by tbhimdi on 16 Jan, 2021 02:15 PM
My current_accountbook lists:
"C:\\Users\\name\\.moneydance\\archive\\backups\\name.moneydance"
The content of its directory is screenshotted, attached.
157 Posted by Stuart Beesley ... on 16 Jan, 2021 02:35 PM
WARNING - DO NOT DELETE OR CHANGE ANY FILES...
OK, now open safe folder (which is 194MB)
what's the size of
- archive folder - attach folder - tiksync folder
Then look in the tiksync folder
- what's the size of trunk file? - what's the size of the in and out folders..?
(not support, just a user)
158 Posted by tbhimdi on 16 Jan, 2021 02:54 PM
Screenshots attached.
159 Posted by Stuart Beesley ... on 16 Jan, 2021 03:11 PM
Wow, "out" is 164MB!
Lastly, look in the "out" folder... are there lots for today's date...? In fact every time you open MD is the out dir getting 3101 files larger? I wondering if it downloading 3101 bank txns, "touching" 3101 records, which is creating 3101 change files..?
Also, you can now also run this script.. Let me know if it works... (Again, it's readonly)
In fact you can run this, restart MD, run it again and see if the numbers of files shoots up....
160 Posted by hannasm on 16 Jan, 2021 03:12 PM
Is there an ETA on the fix moving from preview to a stable release? Would
someone from infinite kind be able to update us when this is released?
161 Posted by tbhimdi on 16 Jan, 2021 03:37 PM
Opening and closing Moneydance doesn't change the size or number of files in the out folder (160.42MB and 364 files). I then opened Moneydance again, downloaded Schwab Checking transactions (it said downloading 3108 transactions), no new transactions showed up (there shouldn't be any new, that's good), but the out folder then showed 169.29MB and 366 files. A jump of ~9MB from adding nothing.
The files in the out folder go back to November, but a large number of them are from this month and last. This morning, I only updated Schwab twice (as described in today's posts), no new transactions added from those downloads, but there are now four TXN files with today's date with a total of 17.73MB. This is just from download transactions for a single account, no new transactions added.
After doing the above, I then ran the new script (Result #1). Then closed Moneydance and ran it again (Result #2).
Script results attached.
162 Posted by Stuart Beesley ... on 16 Jan, 2021 04:52 PM
Hi, a few points...
- Attached is a better script.. Please run this... - Your dataset is in an odd location. It's in the backup location?? - How do you open your dataset? The App icon, or double-clicking a filename? - Your problem seems to be these (repeating) files:
3.3MB out\20210116125541_037.txn
6.0MB out\20210116125546_258.txn
.. and daily there is a 9.3MB out file....
Try this... exit MD. Run the script... Turn off your Wifi/network connection.. restart MD (so txns cannot download)... exit MD... rerun the script... Does the file count/size increase?
I think we need to peek inside of of these large out files... I suggest you answer the above first, and run the test....
(not support)
163 Posted by Stuart Beesley ... on 16 Jan, 2021 05:13 PM
.
164 Posted by tbhimdi on 16 Jan, 2021 05:32 PM
I open the dataset by just double-clicking the Moneydance shortcut (it points to moneydance.exe in my ProgramFiles directory). That auto-opens my only moneydance file. No syncing anywhere, it's only used on a single machine.
I don't know why it would be in an odd location, where should it be? Should I move it or just do a full clean moneydance install and do an import of my current moneydance data so that it's then located in the location it's supposed to be?
Regardless of my above questions, I ran the new script as you asked. Ran Moneydance, ran the script (Result #1). Exited Moneydance, disabled the network, ran Moneydance, ran the script (Result #2), tried to download Schwab (to make sure network was down, it errored with a network error, that's good), exited Moneydance.
Results snippet attached.
165 Posted by Stuart Beesley ... on 16 Jan, 2021 05:45 PM
So, your Sync Out directory is 177.5MB with 366 files and it does look like it's to do with the bank downloads... If you run the test one last time, this time with the network connected, does the out file count increase and also the size by 9MB again?
NOTE: Your base database is only 14.9MB..!
I'm not sure about a reinstall, just yet...
I suggest we peek inside the last large. out file, and confirm it's the bank downloads... Email me and I'll provide exact instructions...
166 Posted by Stuart Beesley ... on 16 Jan, 2021 06:14 PM
PS - can you post your errlog.txt too (in case there are errors being logged).
167 Posted by Stuart Beesley ... on 16 Jan, 2021 06:36 PM
PPS - I've just learned that if you have the console window open, then you get more debug messages... So, exit MD, run script, turn off network, start MD, quickly go to console window and keep it open, then try the bank download... exit MD, rerun script, post the err log.txt file....
168 Posted by Stuart Beesley ... on 16 Jan, 2021 09:10 PM
Ok. So we have established a few things.
1/ your Schwab download IS downloading all txns every time. It’s generating a 6MB .txn file in the out directory. We’ve looked at this file and it’s 1000s of lines of downloaded records.
2 your console log says...
—- FI refresh is forced
Ignoring extraneous OFX tag: 20210115
Ignoring extraneous OFX tag: 20210116
—- But we need to test again whilst the console viewer is open.
3/ you don’t have sync on and your txn files are building up and making a massive dataset size.
At this point, I recommend you create a brand new post with these details, and also upload the more complete console output we just generated, so that support can properly respond to all these points.
169 Posted by tbhimdi on 16 Jan, 2021 09:59 PM
Thanks to Stuart's tireless debugging and help, he's been able to narrow down the issue. I've opened a thread for it here:
https://infinitekind.tenderapp.com/discussions/online-banking/17896-schwab-downloads-all-3000-old-transactions-every-time-and-generates-a-new-6mb-out-directory-txn-file-every-time
170 Posted by kennylucius on 16 Jan, 2021 10:19 PM
Yes, thank you Stuart. Been following along and hoping for a solution.
171 Posted by Stuart Beesley ... on 17 Jan, 2021 12:49 AM
The developer has just told me that he’s applied a slight tweak to the connection parameters to address this. It’s live now. ‘They shouldn't need to do anything, but clicking "refresh" in the Online->Setup Online Banking window should force the refresh of the connection parameters’. If you have this issue you refresh, have console window open, and try again.
(update: the fix isn't working)