Hi,
I saw that in the last version of PP was added PDF import from J&T Direktbank which is a German bank of J&T FINANCE GROUP.
I have account in J&T Banka Slovak branch.
I’d like to make log from PDF import debugger but it make some strange things.
First of all, the PDF report is in Slovak language.
Some characters are shifted before or after each other.
Here is text from text extractor from PDF:
PDFBox Version: 1.8.17
Portfolio Performance Version: 0.67.2
-----------------------------------------
VÝPIS Z ÚČTU
VKLADOVÝ ÚČET S VÝOP VDENOU LHE OTOU
IBAN: SK53 8 032 000 0 309 0 2049 2781
Názov účtu: VFsd7, KMRhQ ToA.
ZkU vVMfs
Mena účtu: EUR
H hB Fx u 4/5 1 1
Za obdobie: 31. 12. 2023 - 02. 01. 2024 1 2190 Piešťany
Dátum výpisu: 02. 01. 2024
Číslo výpisu: 1/2024
Adresa trvalého
pobytu/sídla KlientaA.: STZFra 82/41
92101, Piešťany
Súhrn
Aktuálna úroková sadzba (p.a.): ,3 50 %
Výpovedná lehota: 41 dní
Počiatočný zostatok 3 000,00 EUR
Kreditné obraty (+) 3,74UE R
z toho pripísané hrubé úroky (+) 3,7E4UR
Debetné obraty (-) - 0,71UE R
z toho poplatky (-) 0,0E0UR
Konečný zostatok 3 ,300 03 EUR
Rozpis transakcií
Dátum Typ transakcie Číslo protiúčtu Suma (EUR)
Valuta Správa pre príjemcu Názov protiúčtu Poplatok
Detail transakcie
02. 01. 4022 Vysporiadanie úroku vkladu 3,74
31. 12. 2023
31. 12. 202aD 3ň z úrokov -0,71
Váš vklad je chránený v rámci zákonného systému poistenia pohľadávok z vkladov. Informácie o poistenia môžete
nájst na https://www.jtbanka.sk/poistenia-pohladavok.
Strana č.: 1/1 IBAN: SK5383200000003990242781
J&T BANKA, a.s., Sokolovská 700/113a, 186 00 Praha 8, Česká republika, IČ: 471 15 378, zapísaná v obchodnom registri vedenom Mestským súdom v Prahe, spis. zn.: B 1731,
podnikajúca na území Slovenskej republiky prostredníctvom organizačnej zložky J&T AB NKA, a.s., pobočka zahraničnej banky, vD ořákovo nábrežie 8, 811 02 rB atislava,
Slovenská republika, IČO: 35 964 693, zapísaná v obchodnom registri vedenom Mestským súdom rB atislava III, oddiel OP , vložka 1320/B.
Komfort linka : 0800 90 0 500, zo zahraničia : +421 223 607 187, info@jtbanka.sk, www.jtbanka.sk.
And here is original PDF (I highlight some string differences):
Looks like it is a problem with the older version of PDFBox used in PP.
I have extracted text from PDF with PDFBox 1.8.17 and with newer versions (2.0.30 and 3.0.1) and there is no problem.
PDFBox 1.8.17
VÝPIS Z ÚČTU
VKLADOVÝ ÚČET S VÝOP VDENOU LHE OTOU
IBAN: SK53 8 032 000 0 309 0 2049 2781
PDFBox 2.0.30
VÝPIS Z ÚČTU
VKLADOVÝ ÚČET S VÝPOVEDNOU LEHOTOU
IBAN: SK53 8320 0000 0039 9024 2781 Dfčýv Dnežs
Okay, that is a reason to consider updating PDFBox.
So far I tried to avoid that, because we only have the text output of test documents. If we use a new PDFBox version that generates the text slightly different, then a) we have no way to easily notice, b) no way to update the test documents and c) we easily break the existing importer.
I have seen other changes - Deutsche Bank PDF documents have a slightly different output with new PDFBox version.
I think a conservative approach could be to include both PDFBox versions with PP and have the importer decide which format to use. This way we can also run experiments before we kick out the old PDFBox version.
Looking at the current output from the Slovak dokument such as 0,0E0UR or even worse 3 ,300 03 EUR (3.003,03 EUR) it doesn’t make sense to try to parse it in the importer. @segi Are the numbers okay with the later versions?
Hi @AndreasB ,
now I understand how complicated it is to update PDFBox.
Maybe it will be a good solution to have both versions of PDFBox and the new one will be implemented for text extractor for debugging and in time more and more articles will work with new version of PDFBox. Because I expect that some old reports will be replaced by new ones and need to be redebugged. Unless I am wrong
And yes. I have checked it and with the latest version the numbers are correct.
first of all, I`m not a developer, but I can imagine that a developer like @Nirus needs further assistance from you. I assume it would help a lot, if you describe in english language what kind of transactions are made in this pdf and then add the slovakian word from the PDF as reference.
Hello,
This is about crediting interest on a term deposit.
I put it into DeepL and it looks good translated:
STATEMENT OF ACCOUNT
TERM DEPOSIT ACCOUNT
Account Number: 3290058877/8320
Account name: hnuiH, MDTxA KGkux ROqVw
Account currency: EUR
For the period: 14/05/2024 - 14/11/2024 phwUFq 5641
Date of statement: 14.11.2024 26871 fOOGfgqN
Statement number: 2/2024
Permanent address
Customer's residence/headquarters: LqmQxT 5411
165461, SMvllxIn
Summary
Current interest rate (p.a.): 3.70%
Date of deposit: 14/05/2024
Deposit maturity date: 14.11.2024
Initial balance EUR 10 153,48
Credit turnover (+) EUR 189,38
of which gross interest credited (+) EUR 189,38
Debit turnover (-) - EUR 10 342,86
of which fees (-) EUR 0,00
Ending balance EUR 0,00
Breakdown of transactions
Date Type of transaction Counter-account number Amount (EUR)
Currency Message to beneficiary Name of counter-account Fee
Transaction detail
14/11/2024 Deposit interest settlement 189,38
14.11.2024 Current interest rate (p.a.): 3,70 %
14.11.2024 Interest tax -35,98
14.11.2024 Termination of deposit Ot05 5016 9672 2168 9100 0780 -10 306,88
14/11/2024 Counter-account bank: JTBPSKBAXXX ZjNir TZWDG
Your deposit is protected under the statutory deposit claims insurance scheme. For information about the insurance you can
can be found at https://www.jtbanka.sk/poistenia-pohladavok.
Page no: 1/1 Account number: 3290058877/8320
J&T BANKA, a.s., Sokolovská 700/113a, 186 00 Prague 8, Czech Republic, ID No.: 471 15 378, registered in the Commercial Register maintained by the Municipal Court in Prague, file no. B 1731,
doing business in the territory of the Slovak Republic through the organizational component J&T BANKA, a.s., branch of a foreign bank, Dvořákovo nábrežie 8, 811 02 Bratislava,
35 964 693, registered in the Commercial Register kept by the Municipal Court of Bratislava III, Section PO, Insert 1320/B.
Comfort line: 0800 900 500, from abroad: +421 232 607 187, info@jtbanka.sk, www.jtbanka.sk.
Hello @segi
We have updated the PDFBox plugin to version 3.x and could try again.
If you want, you could post a new PDF debug here. The others are no longer usable.
Please create a PDF debug and post it here.
The best way to find out how this works is to watch the video tutorial.
PDFBox Version: 3.0.6
Portfolio Performance Version: 0.81.5
System: win32 | x86_64 | 21.0.5+11-LTS | Azul Systems, Inc.
-----------------------------------------
VÝPIS Z ÚČTU
TERMÍNOVANÝ VKLADOVÝ ÚČET
Číslo účtu: 476fg486fgh/56160
Názov účtu: hlkjsa, ZoyNX KQpFj MgMCa
Mena účtu: EUR
Za obdobie: 31. 12. 2023 - 14. 05. 2024 lfWzhw gť/kí
Dátum výpisu: 14. 05. 2024 61612 HmqQAbbs
Číslo výpisu: 1/2024
Adresa trvalého
pobytu/sídla Klienta: k. EgHxqh bfg51
4df52, NmvTaWWY
Súhrn
Aktuálna úroková sadzba (p.a.): 3,80 %
Dátum zriadenia vkladu: 14. 11. 2023
Dátum splatnosti vkladu: 14. 05. 2024
Počiatočný zostatok 10 000,00 EUR
Kreditné obraty (+) 189,48 EUR
z toho pripísané hrubé úroky (+) 189,48 EUR
Debetné obraty (-) - 10 189,48 EUR
z toho poplatky (-) 0,00 EUR
Konečný zostatok 0,00 EUR
Rozpis transakcií
Dátum Typ transakcie Číslo protiúčtu Suma (EUR)
Valuta Správa pre príjemcu Názov protiúčtu Poplatok
Detail transakcie
14. 05. 2024 Vysporiadanie úroku vkladu 189,48
14. 05. 2024 Aktuálna úroková sadzba (p.a.): 3,80 %
14. 05. 2024 Daň z úrokov -36,00
14. 05. 2024 Ukončenie vkladu SK80 8320 0000 0029 0004 7946 -10 153,48
14. 05. 2024 Banka protiúčtu: JTBPSKBAXXX zTmbW oWWIo
Váš vklad je chránený v rámci zákonného systému poistenia pohľadávok z vkladov. Informácie o poistenia môžete
nájst na https://www.jtbanka.sk/poistenia-pohladavok .
Strana č.: 1/1 Číslo účtu: b+9f8b49cf8g87
J&T BANKA, a.s., Sokolovská 700/113a, 186 00 Praha 8, Česká republika, IČ: 471 15 378, zapísaná v obchodnom registri vedenom Mestským súdom v Prahe, spis. zn.: B 1731,
podnikajúca na území Slovenskej republiky prostredníctvom organizačnej zložky J&T BANKA, a.s., pobočka zahraničnej banky, Dvořákovo nábrežie 8, 811 02 Bratislava,
Slovenská republika, IČO: 35 964 693, zapísaná v obchodnom registri vedenom Mestským súdom Bratislava III, oddiel PO, vložka 1320/B.
Komfort linka: 0800 900 500, zo zahraničia: +421 232 607 187, info@jtbanka.sk, www.jtbanka.sk.
P.S. If I use the ‘Copy to clipboard’ button, it doesn’t include the apostrophes.
P.P.S. It is not possible to anonymize words that end with a comma. In this document, my name is written as “last name, first name.” And also a string with a slash.
