I’ve been encountering a strange bug over the last few months using the CSV Line Item Importer for Venmo (since I’m still having trouble getting Tiller to auto-sync my Venmo transactions).
The tool sometimes does not import all of the transactions from a CSV. There might be 12 and it would only bring in 8 of them. I’ve had this happen on multiple occasions. I would download a CSV statement from Venmo, perform the required steps to prep it for import, and then upload it to the tool. Upon importing, I would find I was missing a few transactions. I’ve confirmed that all of the transaction IDs were unique as well (amongst themselves and my existing Tiller transactions).
I’ve done some debugging and I think the bug may be related to how the timestamp is getting parsed/interpreted by the tool. In the first link below of my November CSV, the last 4 records weren’t getting imported by the tool. What they had in common was (1) being at the end of the list and (2) having a shorter timestamp (in number of characters). But, if I modify those timestamps to be end of day (2022-11-26 23:59:59), then the tool finally imports them.
- Original CSV data — docs [dot] google [dot] com/spreadsheets/d/1D8icwhNOyLOgCSCzcz82q9nidB8ECNJEnwSlBTgap6o/edit?usp=sharing
- Modified CSV data — docs [dot] google [dot] com/spreadsheets/d/14rEyEnaBgetbUMriATTE8vvqvsYN_dAKeIcUcLhw7Lk/edit?usp=sharing
(sorry, it’s not letting me share links or screenshots — my first post here so didn’t get a chance to check the post guidelines beforehand )
I tried to find the source code online to debug further but seems like it isn’t available. Is this import issue something that could be backlogged to fix?
cc: @randy I think we discussed this when we met at the happy hour in Seattle a while back — just now getting around to sharing some examples!