Reports are showing the same value for each month (YNAB 4)

Hi, I posted about this a little while ago but still haven't found a fix.

All of my reports now look like this, there's no difference between each month:

It's also running *incredibly* slowly. I've tried re-installing from scratch but it still does it.

Any suggestions please? Thank you

10replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Sky Blue Harp said:
    It's also running *incredibly* slowly.

     Have you tried compacting your database? Ctrl-Alt-Shift-C

    Like 1
  • Thank you! Just tried that and unfortunately it's still the same - very slow and the reports are corrupted

    Like
    • Sky Blue Harp We no longer offer support for YNAB 4, so we aren't able to take a closer look at what's going on here. Did you ever have a chance to try uninstalling and reinstalling the program?

      Like 1
  • Thank you, appreciate that the software is no longer officially supported - was just hoping someone else may have ran into the problem and had a fix... annoyingly I was using YNAB 4 for years, and it did this within a week of support being dropped! :(

     

    Anyway sorry for the ramble - yes I have tried uninstalling and re-installing, same problem unfortunately. I think my database is maybe corrupt

    Like
  • I'm just playing around and thought I'd try importing my data to another service, but it says my database is corrupted. I've loaded the .yfull file into Visual Studio Code - any suggestions on what to look for please? Ideally I'd be able to fix this and keep using YNAB!

    Like
      • dakinemaui
      • dakinemaui
      • 1 mth ago
      • 1
      • Reported - view

      Sky Blue Harp If you have backups, you might try to find something recent that doesn't have the corruption. (Importing to another service is a good way to test that, good thinking!)

      If you use Dropbox/Cloud Sync, they have backups available for the past 30 days or so, I believe.

      Like 1
      • a_different_joel
      • Amused by the incorrigible nYNAB
      • A_different_joel
      • 1 mth ago
      • 1
      • Reported - view

      Sky Blue Harp since you're using VS Code you might be able to make your way through LINQPad... you could try getting a JSON context plugin to verify the JSON is is OK, and then look for transactions (via linq) with crazy high values or way too old or way too in the future dates. 

      I saw once in the old forum someone had a date set for like 1700 or something, and YNAB loops through all the months from then when loading, which takes a while.  Something like that could be the slowness for example.

      If nothing else, you might be able to figure out a better place to look in the file. 

      Notepad++ also has a JSON viewer that can at least verify the JSON as well. (Although I guess VS Code probably does too now that I posted it, doh)

      Like 1
    • a_different_joel Thank you! Unfortunately it broke quite a few months ago and I've been trying on and off to fix it, so I don't have any working backups to restore from.

      a_different_joel Great tip on verifying the JSON - I've ran it through a few things now and all of them come back and say it's valid :( Will try LINQPAD now too.

      Like
      • a_different_joel
      • Amused by the incorrigible nYNAB
      • A_different_joel
      • 4 wk ago
      • 1
      • Reported - view

      Sky Blue Harp  I was able to play with a couple apps this morning.  VS Code has some JSON Path plugins, which might work OK too.  There's also some websites you can paste in the JSON and view JSONPath expression results too, for example $.transactions[?(@.amount > 2000)]  which worked fine, but I personally dont know if you can compare (convert string to date) dates with just path expression.

      For LINQPad 5, I was able to use the JSON Context driver from https://github.com/rdavisau/jsondatacontext-linqpad/releases/ (click Assets then get the lpx, not compatible with LINQPad  v6).  Then using a C# Statements I could query on the transaction amounts, and dates.  For example:

      Budgets.First().transactions.Where(x=>DateTime.Parse(x.date) < new DateTime(2012,05,01)).Dump();

      and

      Budgets.First().transactions.Where(x=>x.amount > 2000).Dump();

      Hope that helps!

      Like 1
    • a_different_joel thank you! it's all a bit over my head to be honest but I will give it a go :)

      Like
Like1 Follow
  • 1 Likes
  • 3 wk agoLast active
  • 10Replies
  • 140Views
  • 5 Following