Thanks :)
It works now ( bean-extract config.py Revolut-CHF.myname.csv) with
this config.py:
import os, sys
# beancount doesn't run from this directory
sys.path.append(os.path.dirname(__file__))
# importers located in the importers directory
from importers import revolut
CONFIG = [
revolut.Importer('/Revolut-CHF.*\.csv',
'Assets:MyName:Liquidity:Revolut:CHF', 'CHF'),
]
Would it be possible the use some regex to change the category if in
the revolut statement is a description with "*Restaurant *"?
Thanks for the help:)
On Saturday, November 16, 2019 at 5:03:15 PM UTC+1, Patrick Ruckstuhl
wrote:
Hi,
sure. I'm using smart_importer so you can leave that out if you
don't use it
import sys
from os import path
sys.path.insert(0, path.join(path.dirname(__file__)))
from importers.revolut import importer as revolutimp
from beancount.ingest import extract
from smart_importer import apply_hooks, PredictPostings
from smart_importer.detector import DuplicateDetector
CONFIG = [
apply_hooks(revolutimp.Importer('/Revolut-CHF.*\.csv',
'Assets:Patrick:Liquidity:Revolut:CHF', 'CHF'),
[PredictPostings(), DuplicateDetector()]),
apply_hooks(revolutimp.Importer('/Revolut-GBP.*\.csv',
'Assets:Patrick:Liquidity:Revolut:GBP', 'GBP'),
[PredictPostings(), DuplicateDetector()]),
apply_hooks(revolutimp.Importer('/Revolut-USD.*\.csv',
'Assets:Patrick:Liquidity:Revolut:USD', 'USD'),
[PredictPostings(), DuplicateDetector()]),
apply_hooks(revolutimp.Importer('/Revolut-EUR.*\.csv',
'Assets:Patrick:Liquidity:Revolut:EUR', 'EUR'),
[PredictPostings(), DuplicateDetector()]),
]
extract.HEADER = ''
On 16.11.2019 16:52, [email protected] <javascript:> wrote:
Thanks :)
This is for "bean-extract", right?
Can you also provide me the correct entry for the config.py?
On Saturday, November 16, 2019 at 3:58:14 PM UTC+1, Patrick
Ruckstuhl wrote:
Hi,
That's what I'm currently using. It stores original values as
meta information in original key and conversions as
originalIn and originalOut
|
||from dateutil.parser import parse
from io import StringIO
from beancount.ingest import importer
from beancount.core import data
from beancount.core import amount
from beancount.core.number import D
from beancount.ingest.importers.mixins import identifier
import csv
class Importer(identifier.IdentifyMixin,
importer.ImporterProtocol):
"""An importer for Revolut CSV files."""
def __init__(self, regexps, account, currency):
identifier.IdentifyMixin.__init__(self, matchers=[
('filename', regexps)
])
self.account = account
self.currency = currency
def name(self):
return super().name() + self.account
def file_account(self, file):
return self.account
def extract(self, file, existing_entries):
entries = []
with StringIO(file.contents()) as csvfile:
reader = csv.DictReader(csvfile, ['Date',
'Reference','PaidOut', 'PaidIn', 'ExchangeOut', 'ExchangeIn',
'Balance', 'Category', 'Notes'], delimiter=';',
skipinitialspace=True)
next(reader)
for row in reader:
metakv = {
'category': row['Category'].strip(),
}
exchangeIn = row['ExchangeIn'].strip()
exchangeOut = row['ExchangeOut'].strip()
if exchangeIn and exchangeOut:
metakv['originalIn'] = exchangeIn
metakv['originalOut'] = exchangeOut
elif exchangeIn:
metakv['original'] = exchangeIn
elif exchangeOut:
metakv['original'] = exchangeOut
meta = data.new_metadata(file.name
<http://file.name>, 0, metakv)
entry = data.Transaction(
meta,
parse(row['Date'].strip()).date(),
'*',
'',
(row['Reference'].strip() + ' ' +
row['Notes'].strip()).strip(),
data.EMPTY_SET,
data.EMPTY_SET,
[
data.Posting(self.account,
amount.Amount(D(row['PaidIn'].strip()) -
D(row['PaidOut'].strip()), self.currency), None, None, None,
None),
]
)
entries.append(entry)
return entries
|
On 16.11.2019 14:45, [email protected] wrote:
Hi
Does anybody has a Revolut statement (csv) parser to import
the transactions to beancounts?
Example rows:
Completed Date ; Description ; Paid Out (CHF) ; Paid In
(CHF) ; Exchange Out; Exchange In; Balance (CHF); Category;
Notes
Nov 16, 2019 ; Top-Up by *8753 ; ; 600.00 ; ; ; 703.83;
general;
Nov 16, 2019 ; Paypal *collintanaw FX Rate Fr1 = US$1.0066 ;
403.30 ; ; USD 405.96 ; ; 103.83; services;
Thanks for help :)
--
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/90613531-9c08-45a5-8dfc-7be50029c224%40googlegroups.com
<https://groups.google.com/d/msgid/beancount/90613531-9c08-45a5-8dfc-7be50029c224%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
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] <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/31a28fff-21f2-4005-a1a9-bfb7efd41696%40googlegroups.com
<https://groups.google.com/d/msgid/beancount/31a28fff-21f2-4005-a1a9-bfb7efd41696%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
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]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/58ad6d89-1eb3-4ca3-8a8a-b3d96217e080%40googlegroups.com
<https://groups.google.com/d/msgid/beancount/58ad6d89-1eb3-4ca3-8a8a-b3d96217e080%40googlegroups.com?utm_medium=email&utm_source=footer>.
