Schwab transactions not downloading

David Greene's Avatar

David Greene

23 Oct, 2020 02:36 PM

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

  1. 151 Posted by tbhimdi on 16 Jan, 2021 01:04 PM

    tbhimdi's Avatar

    @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).

  2. 152 Posted by Stuart Beesley ... on 16 Jan, 2021 01:34 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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)

  3. 153 Posted by tbhimdi on 16 Jan, 2021 01:41 PM

    tbhimdi's Avatar

    The name.moneydance subfolder under ".moneydance/archive/backups" or ".moneydance/Documents"?

  4. 154 Posted by Stuart Beesley ... on 16 Jan, 2021 02:02 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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)

  5. 155 Posted by Stuart Beesley ... on 16 Jan, 2021 02:03 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    (put differently, look inside the file/folder that you say is now xxxMB)

  6. 156 Posted by tbhimdi on 16 Jan, 2021 02:15 PM

    tbhimdi's Avatar

    My current_accountbook lists:
    "C:\\Users\\name\\.moneydance\\archive\\backups\\name.moneydance"

    The content of its directory is screenshotted, attached.

  7. 157 Posted by Stuart Beesley ... on 16 Jan, 2021 02:35 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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)

  8. 158 Posted by tbhimdi on 16 Jan, 2021 02:54 PM

    tbhimdi's Avatar
  9. 159 Posted by Stuart Beesley ... on 16 Jan, 2021 03:11 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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....

  10. 160 Posted by hannasm on 16 Jan, 2021 03:12 PM

    hannasm's Avatar

    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?

  11. 161 Posted by tbhimdi on 16 Jan, 2021 03:37 PM

    tbhimdi's Avatar

    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.

  12. 162 Posted by Stuart Beesley ... on 16 Jan, 2021 04:52 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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....

    • Do you have Sync turned on or OFF - I suspect off....?

    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)

  13. 163 Posted by Stuart Beesley ... on 16 Jan, 2021 05:13 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    .

  14. 164 Posted by tbhimdi on 16 Jan, 2021 05:32 PM

    tbhimdi's Avatar

    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.

  15. 165 Posted by Stuart Beesley ... on 16 Jan, 2021 05:45 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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...

  16. 166 Posted by Stuart Beesley ... on 16 Jan, 2021 06:14 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    PS - can you post your errlog.txt too (in case there are errors being logged).

  17. 167 Posted by Stuart Beesley ... on 16 Jan, 2021 06:36 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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....

  18. 168 Posted by Stuart Beesley ... on 16 Jan, 2021 09:10 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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.

  19. 169 Posted by tbhimdi on 16 Jan, 2021 09:59 PM

    tbhimdi's Avatar

    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

  20. 170 Posted by kennylucius on 16 Jan, 2021 10:19 PM

    kennylucius's Avatar

    Yes, thank you Stuart. Been following along and hoping for a solution.

  21. 171 Posted by Stuart Beesley ... on 17 Jan, 2021 12:49 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    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)

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

Recent Discussions

18 Jan, 2021 12:26 AM
17 Jan, 2021 11:08 PM
17 Jan, 2021 11:08 PM
17 Jan, 2021 10:49 PM
17 Jan, 2021 09:58 PM