Thanks! Will test this out.
On Friday, December 8, 2023 at 3:33:44 AM UTC-5 Red S wrote:
> Argh, don’t have my laptop now, so this is hard, but with the init
> function, the right hand fields in the dictionary are internal, and fixed.
> The left hand side corresponds to your csv file.
>
> Date,Description,Amount,Unapplied,Balance
> def custom_init(self): self.max_rounding_error = 0.04
> self.filename_pattern_def = '<change_this>.*' self.header_identifier =
> 'Date,Description,Amount,Unapplied,Balance', self.date_format = '%m/%d/%Y' #
> <--- this is incorrect, change this self.header_map = { "Description":
> 'payee', "Date": 'date', "Amount": 'amount', "Balance": 'balance', }
>
> I can’t remember of the top of my head if you need a
> get_balance_statement() function to generate the balance assertion. If
> you do, it’ll look like this
> <https://github.com/redstreet/beancount_reds_importers/blob/47afef6b4e8b0de6a0aef403bdfa993f9de8dcd5/beancount_reds_importers/importers/schwab/schwab_csv_checking.py#L49-L54>
> .
>
> This is all untested. If that doesn’t work, let me know.
>
>
>
> On Friday, December 8, 2023 at 12:19:53 AM UTC-8 Red S wrote:
>
>> Hello there,
>> Author here. Given how simple your csv file is, I’d suggest using
>> Beancount’s built in csv importer
>> <https://beancount.github.io/docs/api_reference/beancount.ingest.html#beancount.ingest.importers.csv>.
>>
>> Something like this in your my.import file (untested):
>> csv.Importer({Col.DATE: 'Date', Col.NARRATION1: 'Description',
>> Col.AMOUNT: 'Amount', }, 'Assets:Bank1', 'USD', ('Date','Description',
>> 'Amount','Unapplied','Balance')),
>>
>> The only advantage you get with my reds-importers is balance assertions.
>> I'll post and example in a minute.
>>
>>
>>
>> On Thursday, December 7, 2023 at 7:06:19 PM UTC-8 [email protected]
>> wrote:
>>
>>> I have what I think may be a very simple CSV file:
>>>
>>> Column headers are these:
>>> Date,Description,Amount,Unapplied,Balance
>>>
>>> Corresponding data fields look like this:
>>> Dec 1, 2023,PAYMENT,$951.28,$951.28,$25,000.62
>>>
>>> I have had some success using Red's ofx importer framework, but am
>>> really struggling to figure out the CSV importer from the examples in the
>>> git repo. I started with the Discover example that looks like this:
>>>
>>> from beancount_reds_importers.libreader import csvreader
>>> from beancount_reds_importers.libtransactionbuilder import banking
>>>
>>> class Importer(csvreader.Importer, banking.Importer):
>>> IMPORTER_NAME = """ Discover credit card .csv importer."""
>>>
>>> def custom_init(self):
>>> self.max_rounding_error = 0.04
>>> self.filename_pattern_def = 'Discover.*'
>>> self.header_identifier = 'Trans. Date,Post
>>> Date,Description,Amount,Category'
>>> self.date_format = '%m/%d/%Y'
>>> self.header_map = {
>>> "Category": 'payee',
>>> "Description": 'memo',
>>> "Trans. Date": 'date',
>>> "Post Date": 'postDate',
>>> "Amount": 'amount',
>>> }
>>>
>>> def skip_transaction(self, ot):
>>> return False
>>>
>>> def prepare_processed_table(self, rdr):
>>> # Need to invert numbers supplied by Discover
>>> rdr = rdr.convert('amount', lambda x: -1 * x)
>>> return rdr
>>>
>>> I'm pretty sure I don't need the def skip_transaction(self, ot) and def
>>> prepare_processed_table(self, rdr): bits, but am at a loss to figure out
>>> what fields I need to modify in the def custom_init(self) for my situation.
>>> There is not an example CSV file for that importer in the repo so it makes
>>> it a little more challenging for me to hack on it. I think I don't need the
>>> "Unapplied" column but am not sure. Even just some hints would be really
>>> helpful.
>>>
>>> Thank you in advance!
>>> Chris
>>>
>>
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/07526f71-d609-4619-babc-d035c67871aen%40googlegroups.com.
