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

Bondora pdf importer do not import this pdf debug #4525

Closed
Nirus2000 opened this issue Feb 12, 2025 · 6 comments · Fixed by #4528
Closed

Bondora pdf importer do not import this pdf debug #4525

Nirus2000 opened this issue Feb 12, 2025 · 6 comments · Fixed by #4528
Labels

Comments

@Nirus2000
Copy link
Member

Hey,

"somehowdifferent" ;) but a similar problem occured to me when trying to import a bondora pdf. It works just fine except when there is a SEPA payment. If i import until the day before or from the day after everything works just fine.

Thank you

PDFBox Version: 3.0.3
Portfolio Performance Version: 0.74.0
System: win32 | x86_64 | 21.0.5+11-LTS | Azul Systems, Inc.
-----------------------------------------
Summary
Opening € 
First Last
Payments in €
Date 2/1/2025 - 2/4/2025 Payments out €0
Account reference number GG XXXX Closing €
Go & Grow
Date Payment type In Out Balance
2/1/2025 Go & Grow returns € €
Up to 4%* p.a. returns €
Up to 6.75%* p.a. returns € €
...
....
2/4/2025 SEPA payment €X,000 €
Up to 4%* p.a. returns €
Up to 6.75%* p.a. returns €X,000 €
Total €

Originally posted by @KiwiKDo in #4517

@Nirus2000
Copy link
Member Author

Hello @KiwiKDo
unfortunately your PDF debug is not usable, because you have anonymized the amounts.
We only process complete PDF debugs.

Please watch the tutorial video carefully and post a “complete” PDF debug.

  • Otherwise, please do not change or delete any other data.
  • The personal data must be replaced 1 to 1.
  • Other changes, such as replacing the date or similar, are also counterproductive.
  • !! ONLY YOUR OWN PERSONAL DATA !!!
  • No PDFs which are converted to PDF from a browser or similar
  • No self-scanned paper slips

e. G.

  • Name → Max Mustermann and so on…
  • Address → Blumenstraße
  • IBAN and deposit numbers: The numbers 1 to 1.

No more and no less… One post per PDF debug please.
End.

Video tutorial:
Extract PDF documents for debugging

@KiwiKDo
Copy link

KiwiKDo commented Feb 12, 2025

Hello @Nirus2000
thank you for correcting the issue tracking.
Unfortunatly I dont feel comfortable sharing my financial statements on github so "Leave all other information intact, especially amounts, dates, and security names." is no option for me.

Maybe the error message is helping you. Looks like maybe the note pattern "SEPA payment" might just be missing.
Image

Before posting this I recognized the the german "SEPA-Banküberweisung" is present in the regex. So I changed my Bondora report to german and the import works just fine. In conclusion most likely "SEPA payment" just have to be added.

If I can help you in any other way feel free to ask.

@Nirus2000
Copy link
Member Author

Nirus2000 commented Feb 13, 2025

Hello @KiwiKDo

Unfortunatly I dont feel comfortable sharing my financial statements on github so "Leave all other information intact, especially amounts, dates, and security names." is no option for me.

There is no need to worry. What should a security name or ISIN contain “personal” data... or an amount or number?
We have not written that these should make sense or be authentic. Whether there is a 5 instead of a 1, or a BA instead of an IE... doesn't matter.

Before posting this I recognized the the german "SEPA-Banküberweisung" is present in the regex. So I changed my Bondora report to german and the import works just fine. In conclusion most likely "SEPA payment" just have to be added.

That's a bad answer... we just don't know from your example what formatting your amounts have.

€1.62
€1,62
€1'000.62
€1 000,00
0,22 €
0.22 €
1,064.4 €
1.064,4 €
5'630,99 €
5'630.99 €
...

... and so on. And now ?!

@Nirus2000
Copy link
Member Author

Closes...

@github-project-automation github-project-automation bot moved this from Wait for reply to Done in Importer (PDF, CSV, IB-Flex) Feb 13, 2025
@KiwiKDo
Copy link

KiwiKDo commented Feb 13, 2025

hello @Nirus2000
a lot of effort in writing text and rude tone with no intention to solve the issue. I do get the reason for this vibe.

  1. "We have not written that these should make sense or be authentic." You did by: "Leave all other information intact, especially amounts, dates, and security names." and strongly implying changing would not be ok.
  2. my answer is not bad but most likely the solution (as import works just fine wtih every other pattern and amount pattern is the same pattern anyway and ->
  3. the formatting of the relevant amount can be seen in my export, yes it is an X instead of a digit, my bad - but still...
  4. if I could change all amounts and upload these things, I said feel free to ask.
  5. it is you product, not mine and should be in your interest to fix it. I fixed the issue for me anyway

If you have an interest in fixing this, here you go:

PDFBox Version: 3.0.3
Portfolio Performance Version: 0.74.0
System: win32 | x86_64 | 21.0.5+11-LTS | Azul Systems, Inc.
-----------------------------------------
Summary
Opening €1,111.11
First Last
Payments in €1,111.11
Date 2/4/2025 - 2/4/2025 Payments out €1
Account reference number GG1111111 Closing €1,111.11
Go & Grow
Date Payment type In Out Balance
2/4/2025 SEPA payment €1,111 €1,111.11
Up to 4%* p.a. returns €1
Up to 6.75%* p.a. returns €1,111 €1,111.11
Total €1,111.11

@Nirus2000
Copy link
Member Author

Nirus2000 commented Feb 13, 2025

Objective: “Interesting that you put so much energy into writing instead of solving the actual problem.”

Ironic: "Thanks for the helpful analysis. Problem solved!"

Direct: "The tone doesn't help. Can we get back to the solution?"

Casual: "Sure, a bit of drama never hurts. To the point?"

The last is the best 💯

Ironic-objective: "Impressive how you convey this mood in text form. Almost audible!"
I need these source code. 👍🏻

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

Successfully merging a pull request may close this issue.

2 participants