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:
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.
You will find the script in this GitHub repository:
Please use pip to install these Python-modules first:
pip install fints lxml
The scripts config File (settings.yml) is in yaml Syntax. This parameters must be defined:
- 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
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.
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”
I’m playing a lot with Kubernetes on OpenStack. So when I decide to open up this blog, it was an easy decision that this site should be hosted in K8s.
Here is the schema how this site is being accessed.
A little bit about me.
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.