FinTS (HBCI) to OFX export, for using with YNAB

I’ve started using YNAB for controlling my financials. So YNAB does have an file-based import feature for transactions.
It supports these file types:

  • QFX and OFX
  • QIF
  • CSV

My bank provides the transactions only as CSV export in the GUI and this CSV is not compatible with YNAB.

I have build a Python script which connects to the banks FinTS API for download the transactions and write them to a OFX file.

GitHub

You will find the script in this GitHub repository:

https://github.com/IamRFC1918/fintsToOFX

Dependencies

Please use pip to install these Python-modules first:

pip install fints lxml 

Parameters

The scripts config File (settings.yml) is in yaml Syntax. This parameters must be defined:

account:
  blz: 76010085
  acc: 12345678
  username: 'xxxxxx'
  api: 'https://hbci.postbank.de/banking/hbci.do' 
  • blz: bank code
  • acc: bank account number
  • username: bank login Name or Number
  • api: FinTS (HBCI) API URL

Run the Script

➜  fintsToOFX git:(master) ✗ python3 GetTransactions.py
Password:
Transactions for the last x Days:2

The script first asks you for your banking password or PIN. The second input is how many days in the past you will request.

The script will save the OFX file on your Desktop. Maybe it’s necessary that you edit the Path on Lines 88-90.

OpenID Connect (OAuth 2.0) with ADFS

Last Friday, one of my Colleagues was calling me: Is it possible to authenticate our OpenStack Management Tools against our Active Directory with Oauth 2.0? Single-sing on as additional Feature would be nice.

So we have a complete published ADFS HA Setup in our Environment and using this for a few other Logins, but all with SAML 2.0.

So the good news are that with ADFS 4.0 which are integrated in Windows Server 2016, Microsoft has implemented the complete support for OAuth 2.0.

The configuration is easy, as I describe in the following.

Continue reading “OpenID Connect (OAuth 2.0) with ADFS”

About Frank

A little bit about me.

I’m Frank.
While I was in the preparation phase for my Citrix CCE-N certification I decided to create this Blog.

I’m an employee at noris network AG since 2015 as Senior IT Systems Engineer.

In this position I work a lot with Windows Server and server roles (AD, ADFS, CA, IIS, etc..), Exchange Server, Citrix (Virtual Apps and Desktops, NetScaler), Docker, Kubernetes and others. You will find some Blogposts about this also on this Site.

Fell free to comment every post. I like to have your opinion.