I’m just going to leave this here for now.
If anyone downloads and tries please let me know.
Will update this with various steps, but all documentation is either on the GitHub README or within the TRXN8R Spreadsheet itself.
TRXN8R is designed to be read-only, as in it WILL SHOULD NOT MESS UP YOUR DATA.
You simply:
Configure TRXN8R with the local file path to your usual Foundation Workbook
Select the name of the Transactions worksheet to use (so you can duplicate/use a temp one, or if you have custom naming schemes, whatever).
Select an ImportConfig which you define on a Worksheet (maps the CSV columns to Transactions)
TADA - Review the Final Transactions Worksheet and copy/paste whichever ones you want.
HUGE LIMITATION - Account Info Not Used for Deduplicating Yet
If, like me, you try to import CSVs from multiple accounts, you may find that there are duplicated transactions, because the deduplication process only looks at Date, Description, Amount right now.
Nothing is programmed to consider the Accounts.
I have big dreams for that ImportConfig, including parsing account numbers from file names, and using different configs based on file name patterns (or something else?).
What would you like to see?
Please let me know!
Contribute?
Please do! Fork the code, file an issue, hit me up, steal it, whatever.
Why?
Originally, to get Tiller’s attention and hopefully a Sr. Engineering job.
Now I think I might shift into being a data scientist if that falls through.
I’m good at DevOps though…so…?!
I would truly love to work with Financial tools, in that realm, with what seems like a nice, family-like, group of people, who TRULY CARE ABOUT THEIR COMMUNITY!
Right Time!
Just saw the announcement for Excel come across a Press Release service today.
If that is the case…this is perfect timing to get a Power Query based Excel Foundation.
Noticed a few posts on the forum mentioning it as well.
Sleepy
Sorry for the quick/rough post. I am sleepy. I hope that this is a happy surprise for Tiller’s Friday Morning.
Users?
Sorry if this isn’t friendly yet. Post questions/replies/thoughts here or through GitHub issues.
IT WILL BE THE FRIENDLIST THING EVER ONCE IT IS DONE!
There are things called Custom Transformer Functions now for each CSV file.
Super powerful, but it means you need to write one to handle your CSVs.
Try it out, I really don’t know how hard/easy this is.
Hoping to make it easy for everyone!
Download, Extract, Configure the Paths, Review the Results, Copy/Paste Resulting Transactions back into the Tiller Sample, Refresh Data, and then you shouldn’t see the same transactions again.
Try copy/pasting lines of CSV files, modifying things, pasting in your own if you can.
Thanks for your submission here @GregSweats ! When we were looking at your self assessment sheet we noticed your note about AutoCat for Excel using powerquery and just wanted to share we’re about 88% through building AutoCat directly in the Excel add-in and hope to release it publicly soon. Just didn’t want to you to live stream your AutoCat build only to find out we beat you to the punch
Sorry for the delay on responding to your concept, @GregSweats, but it took some time for our judging panel to process what you built…
What we like:
The ambition of a configurable, push button import tool for Excel
The integration of advanced platform tools like Power Query
Your entertaining presentation & graphical style (e.g. “ TRXN8R’s Rawrply”)
What didn’t quite line up to our contest goals:
Dependence on scripts
Feels incomplete
Too complex for most users to get up and running
To honor all the sweat you’ve put into this and to recognize this project may inspire or provide a starting point to future builders, we are excited to extend your Tiller subscription by one year.