--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFcF9ZJ--3-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFciKzu--3-0%40tutanota.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFdnLh3--3-0%40tutanota.com.
[...]But by all means, please correct me if I am wrong, or have missed something.
So now that I have attained some success, and see the light at the end of the tunnel, it looks like I will have to do ~ the following:
1.Manually download CSV file from bank.
2.Do some pre-processing, either manually or with macros in Emacs, or (more likely) programatically, using scripts and sed, etc. to remove parens and $s.
3.Run the actual bean-import.
4.Run some post processing (I would like to change date: metadata name to transaction_date: because I think it's more descriptive).
5.And then finally hand copy these transactions into my main .beancount file, double checking and tweaking (aka "clearing") them in the process, categorizing remaining ones into Expense accounts and perhaps updating my scripts in the process.
I suppose 2, 4, and 5 could be done all in Emacs, but I'll just have to figure out some workflow now that works for me.
Also not mentioned is somehow programatically inserting the other leg of the transaction (which Expense account). I agree with Martin's basic philosophy on this, and still plan on manually reviewing everything, however I am already seeing that the bulk of transactions are the same places in my case and could easily be categorized with some simple matching (either in a post matching script or within bean-extract using categorizer). I need to look into this more, and also experiment or read up on how the de-duplication works, as I think it's probably related.
Anyway, I will continue to report on what I find as I go along, and even though I'm not getting any replies
hopefully this will either encourage others to try and set this up or perhaps help other noobs who come along later looking for more in depth info (or perhaps stumble across similar error messages searching the internet) and it eventually helps someone.
Helpful tips, encouraging words, or even just letting me know if anyone is actually reading my idiotic ramblings are always welcomed. :D
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFmJI7Y--B-0%40tutanota.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNT9Wvhd9EtFvp_F6sNKBV4NAFBmw_yJyu_umkHPwY%2Bsw%40mail.gmail.com.
def dumb_categorizer(txn): # At this time the txn has only one posting try: posting1 = txn.postings[0] except IndexError: return txn # Guess the account(s) of the other posting(s) if 'nutella' in txn.narration.lower(): account = 'Expenses:Food' else: return txn # Make the other posting(s) posting2 = posting1._replace( account=account, units=-posting1.units ) # Insert / Append the posting into the transaction if posting1.units < posting2.units: txn.postings.append(posting2) else: txn.postings.insert(0, posting2) return txn
OK, stayed up late last night and actually got all my character stripping accomplished in Python within the provided tools. Yay me (first Python code I ever wrote)! :)
OK so basic CSV importers are working, now trying to figure out where to stick the categorizer code I found here: https://bitbucket.org/blais/beancount/pull-requests/24/improve-ingestimporterscsv/diff
I been trying here and there without success as of yet. Any hints/pointers would be greatly appreciated!
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
24. Jun 2018 15:21 by bl...@furius.ca:
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNT9Wvhd9EtFvp_F6sNKBV4NAFBmw_yJyu_umkHPwY%2Bsw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFsdlPg--3-0%40tutanota.com.
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
25. Jun 2018 16:33 by trs...@tutanota.com:
OK, stayed up late last night and actually got all my character stripping accomplished in Python within the provided tools. Yay me (first Python code I ever wrote)! :)
OK so basic CSV importers are working, now trying to figure out where to stick the categorizer code I found here: https://bitbucket.org/blais/beancount/pull-requests/24/improve-ingestimporterscsv/diff
I been trying here and there without success as of yet. Any hints/pointers would be greatly appreciated!
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
24. Jun 2018 15:21 by bl...@furius.ca:
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNT9Wvhd9EtFvp_F6sNKBV4NAFBmw_yJyu_umkHPwY%2Bsw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFsdlPg--3-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHmWkuU--3-0%40tutanota.com.
I suppose I should have included a link to the CSV importer source: https://bitbucket.org/blais/beancount/src/80d30d6896cf5fdcff8c1156cab77107ee8e0f96/beancount/ingest/importers/csv.py?at=default&fileviewer=file-view-default
Down toward the bottom (line 283) is where the categorizer gets called.
Last night at my local LUG, I volunteered to do a talk next month on plain text accounting, and got the green light. So it would be nice to get this working by then. :)
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
25. Jun 2018 16:33 by trs...@tutanota.com:
OK, stayed up late last night and actually got all my character stripping accomplished in Python within the provided tools. Yay me (first Python code I ever wrote)! :)
OK so basic CSV importers are working, now trying to figure out where to stick the categorizer code I found here: https://bitbucket.org/blais/beancount/pull-requests/24/improve-ingestimporterscsv/diff
I been trying here and there without success as of yet. Any hints/pointers would be greatly appreciated!
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
24. Jun 2018 15:21 by bl...@furius.ca:
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNT9Wvhd9EtFvp_F6sNKBV4NAFBmw_yJyu_umkHPwY%2Bsw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFsdlPg--3-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHmWkuU--3-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHmaD4f--F-0%40tutanota.com.
OK, I am successfully calling dumb_categorizer from CSV Importer by defining it at beginning of .config file, and then passing categorizer = dumb_categorizer to CSV Importer. I know this because I replaced it with a simple print("something") and I got a bunch of "something" on stdout. So the categorizer is getting called, it's just either not matching or not attaching the other leg... ?
Any help would be greatly appreciated.
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
19. Jul 2018 08:52 by trs...@tutanota.com:
I suppose I should have included a link to the CSV importer source: https://bitbucket.org/blais/beancount/src/80d30d6896cf5fdcff8c1156cab77107ee8e0f96/beancount/ingest/importers/csv.py?at=default&fileviewer=file-view-default
Down toward the bottom (line 283) is where the categorizer gets called.
Last night at my local LUG, I volunteered to do a talk next month on plain text accounting, and got the green light. So it would be nice to get this working by then. :)
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
25. Jun 2018 16:33 by trs...@tutanota.com:
OK, stayed up late last night and actually got all my character stripping accomplished in Python within the provided tools. Yay me (first Python code I ever wrote)! :)
OK so basic CSV importers are working, now trying to figure out where to stick the categorizer code I found here: https://bitbucket.org/blais/beancount/pull-requests/24/improve-ingestimporterscsv/diff
I been trying here and there without success as of yet. Any hints/pointers would be greatly appreciated!
TRS-80
--
Securely sent with Tutanota. Claim your encrypted mailbox today!
https://tutanota.com
24. Jun 2018 15:21 by bl...@furius.ca:
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNT9Wvhd9EtFvp_F6sNKBV4NAFBmw_yJyu_umkHPwY%2Bsw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LFsdlPg--3-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHmWkuU--3-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHmaD4f--F-0%40tutanota.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHmzwng--3-0%40tutanota.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/LHnLRo---3-0%40tutanota.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/660e92ff-2ba4-4c47-9fbd-eb76b8ec6571%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNo9eyhKOLsaa%3DgrHV%3D-_fmBKv6D6J5kAr4HcVy9BTTEQ%40mail.gmail.com.