Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Provide ability to download CSV #11

Closed
tkaymak opened this issue May 13, 2018 · 6 comments
Closed

Provide ability to download CSV #11

tkaymak opened this issue May 13, 2018 · 6 comments

Comments

@tkaymak
Copy link

tkaymak commented May 13, 2018

As a workaround to #10 it would be sufficient for me as a user to be able to programmatically download the CSV (upper right corner of the page ($event=csvExport), after selecting the from_date and to_date. The CSV contains the full information for the account.

@grindsa
Copy link
Owner

grindsa commented May 21, 2018

Hi James,

Thanks for pointing me to the CSV download option. I was not aware of it. Give me a couple of days to incorporate the information into the transaction list.

Cheers
Joern

@grindsa
Copy link
Owner

grindsa commented Jun 2, 2018

starting from v0.8 dkb-robo uses the csv-file as main imput to create the transaction list. Each transaction dictionary contains follwoing data:

  • amount - Betrag
  • bdate - Buchungstag
  • customerreferenz - Kundenreferenz
  • date - bdate (for backwards compability)
  • mandatereference - Mandatsreferenz
  • peer - Auftraggeber / Begünstigter
  • peeraccount - Kontonummer
  • peerbic - BLZ
  • peerid: - Gläubiger-ID
  • postingtext - Buchungstext
  • reasonforpayment - Verwendungszweck
  • text - postingtext + reasonforpayment (for backwards compability)
  • vdate - Wertstellung

Hope it helps...

/Gs

@tkaymak
Copy link
Author

tkaymak commented Jun 4, 2018

awesome! :)

@fischmir
Copy link

How can I download that information to CSV? As I am new to Python etc., could you please guide me to the right direction?

Thank you!

@DominikRoB
Copy link
Contributor

DominikRoB commented Jan 15, 2023

@fischmir As a beginner, you may want to check out the library pandas. It's useful for handling data and can also be used to save data to csv.

import pandas as pd

# [...] - Login and creation of dkb-robo instance etc here

transactions = dkb.get_transactions(
                transactions_link, account_type, date_from, date_to
            )
df_of_transactions = pd.DataFrame(transactions)

df_of_transactions.to_csv("filename.csv", index=False)

@fischmir
Copy link

@DominikRoB Thank you!

pip install pandas beforehand

That worked so far. As far as I understood, I can read transactions. Does anyone know any repository how we can send/create transactions ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants