I was doing some maintenance to Mojito to address a change Google will be making to their "Apps Script" for Google Sheets. In the process of testing my changes, I accidentally deleted the version of MojitoLib (a code library) that Mojito 1.1.5.1 is using. It was as easy as clicking the mouse twice instead of once ... and it was gone, with no way to get it back (!!). Ugh ... thanks Google.
To remedy this mistake, I have released a new version of MojitoLib. However, you will either need to download a new copy of Mojito, or you can upgrade your copy of Mojito to version 1.1.5.2 (assuming you are using Mojito 1.1.5.1, which is the current version as of this writing).
To upgrade your copy of Mojito, follow the easy steps on the FAQ page.
I apologize for this accident and hope the inconvenience is minimal.
-b3
Thanks!
ReplyDeleteIt is working like a charm after the update
I noticed there might be a regression; I seem to get this error on the latest, and it repros 100% of the time for me. Waiting 10 minutes does work so it may be caching again..
ReplyDelete1.1.4.3 (2014.12.06)
Fixed bug in Budget sheet where inserting or deleting a budget row then recalculating your budgets would display an error: "Error: Unexpected error. The 'Everything else' item should be the last row in the 'BudgetItemsRange' named range!" This was caused by a data caching problem. The problem would automatically resolve itself by waiting 10 minutes for the cached data to expire. This release fixes the bug. Waiting is no longer required.
Hi Paul. I didn't actually make any code changes in version 1.1.5.2. I just restored the deleted MojitoLib library. So I'm not sure why you are seeing this problem now. I downloaded a new copy of Mojito and didn't see any problems in the budget sheet. And my existing copy (manually upgraded to 1.1.5.2) works fine too. Is it possible that you downloaded a new copy of Mojito and copied over your budgets from your old Mojito? If you don't do this just right, you can overwrite important cells and confuse Mojito's budget calculation code.
DeleteYeah, I know you didn't make changes, but wasn't sure where to mention this issue. Hmm, not sure what to tell you; I just made a new copy of the spreadsheet and deleted the "accounts" row of budgets after syncing data from 1/1 to 1/31 from my mint account. Then I clicked "recalc" and got the error dialog. If deleting that doesn't work, try deleting several others and recalc again. Btw, if there's a better way to contact you I'd be happy to!
DeleteHmmm, yes, I am seeing the issue as well. I'm not sure how long that bug has been there because I haven't changed my list of budget items for several months. I won't have time to look into this bug for a while, but there is a simple workaround in the meantime. Add or remove budget items until you get them how you like them, then wait 5 minutes. The 'Recalc' button should then work without displaying the error. Be sure to wait the full 5 minutes (or even 10 minutes to be safe). Whenever you add or remove rows from the Budget sheet, you'll need to wait 5 minutes before the budget calculation will work. (It's a data caching problem, and Mojito clears it's budget cache every 5 minutes.)
DeleteBtw, you can contact me directly at b3devs@gmail.com.
Good afternoon!
ReplyDeleteSplitting transactions might be broken? I am adjusting an amount, and I am not getting the usual Split dialog box (it worked about 4-6 weeks ago). I tried downloading a fresh copy, and that also didn't work.
Hi Dana,
DeleteSplitting transactions is working for me, but I have noticed intermittent problems when adding or updating split items when there are more than two split items for the transaction. Eventually it seems to work it self out though. I have seen this only twice in the past 6 months, probably because I usually only have two split items (?). I hope you were able to work around your issue okay.
-b3
Thanks for the reply!
DeleteMaybe I'm not doing it correctly? After the transaction has been download and not in Pending state, I should just edit the amount (i.e. where it says -$150.00, I change that to -$100.00) and after hitting enter, it should start processing it as a Split transaction?
Yeah, after changing the amount to -100, Mojito should create a new split item for the remainder (-50). It can feel particularly clunky and slow if your network connection (or your computer) is slow, but it should still work okay.
DeleteAre you seeing an error message, or does it just not appear to do anything?
btw, feel free to send email to my directly: b3devs@gmail.com
Delete