Recently every single transaction coming into my Google sheet is duplicating. Same account ID, same transaction ID, same post date, same amount. Checking account, credit cards, investment accounts, …
None of the topics I can find on resolving duplicates seem to apply. I don’t have more than one account connected, they aren’t in a single account, they are across multiple banks, the banks aren’t on the trouble institution list, …
I used the community extension to find duplicates, but there are 500+ of them. I can’t use the tool to bulk delete them. The tool searches all transactions going back years, and many of them are historically valid “duplicates” (e.g. NY Saves 529 program uses the same memo line for multiple valid contributions – they aren’t real duplicates).
There have been some recent changes to the Fill process and here’s a 12/5/2024 update from Tiller with a suggestion on how to resolve duplicates. I’d make a file copy first to have easy access for compare/restore and also to report the Transaction ID(s) for duplicates to Tiller support, in the event the issue persists.
Of course, keep in mind any other changes (besides Fill) that need to be redone that have occurred after the restore point.
Getting lots of duplicates here too. I just turned off ‘sync every 6 hours’ as it is looking like a not ready for primetime release.
Frankly, suggesting users revert back to another version is terrible service IMO. These things should be tested thoroughly before being released to avoid this.
Thanks for your feedback, @ACree. I’m sorry that you ran into this duplicates issue as well.
We did thoroughly test to the level that was possible. Since Tiller allows you to make limitless customizations to your Google Sheets there is no way we could properly test all possible scenarios.
@enyc let me know if reverting to a prior version and re-filling does it solve it for you.
I restored to a prior sheets version (this morning) and ran the update again and got the same thing again - a download of thousands of duplicate transactions going back to 2021. Any ideas on how to fix this?
Sorry, this is due to a push we made earlier today that changed the way we set watermarks. There was an edge case that didn’t show up in our testing. If someone had balances but no transactions on a fill the transaction watermark didn’t get properly migrated (to the new method) and therefore Tiller Money Feeds thought none of that accounts’ transactions had been filled.
Really sorry for the inconvenience!!
We recommend restoring to a version of your Google Sheet from before 12:41PM EST today. This will ensure that when you fill again the migration happens properly and you shouldn’t get duplicates.
I want to push back against the advice to use the dupe detector. It’s logic is really, really bad.
And there’s no way to say “just flag duplicates since the last time Tiller Sync broke” … nope, it runs against all transactions, in my case years of txns that are not dupes. In my sheet it finds 500+ “dupes”.
It’s got to run back that far because that’s likely the extent of the duplicates @enyc - the add-on thinks it never filled the data for some of those accounts that didn’t get properly migrated.
Right now I think the duplicates would get reintroduced but we just pushed a change to try and address it before i happens to more people who don’t use Auto Fill and that might make it so you can revert to a prior version then fill without getting the duplicates. I am waiting for confirmation from the dev team on if that push would allow for a restore then re-fill.
Holy Cow. I don’t have a lot of confidence in this tool now; I’m not certain the data I see is accurate . I spent hours getting it all set up during my trial period, and only a week ago was I charged for the full year. One of my sheets had 500+ dups and another had 960 dups. IF this becomes a regular thing, I’ll be demanding a refund.
@Mark.S can you please confirm that you’re still not seeing duplicates? The duplicates were ending up in the sheet after the second time the sheet was filled in most cases.
