pdf to kmymoney

[Aaron Mehl]

 No, I am using Linux and windows.But Linux is my main box.Hmn.I know what awk is, but okular is new to me.If I can do this as a script and hands off it would be the best.I will experiment and see what i come up with...Aaron     On Monday, December 28, 2020, 10:14:42 AM EST, <pjfarley3 at earthlink.net> wrote:  
 
 #yiv3216725230 #yiv3216725230 -- _filtered {} _filtered {} _filtered {}#yiv3216725230 #yiv3216725230 p.yiv3216725230MsoNormal, #yiv3216725230 li.yiv3216725230MsoNormal, #yiv3216725230 div.yiv3216725230MsoNormal {margin:0in;font-size:11.0pt;font-family:sans-serif;}#yiv3216725230 a:link, #yiv3216725230 span.yiv3216725230MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv3216725230 span.yiv3216725230EmailStyle18 {font-family:sans-serif;color:windowtext;}#yiv3216725230 .yiv3216725230MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv3216725230 div.yiv3216725230WordSection1 {}#yiv3216725230 
I had the same issue.  My bank statements are also PDF and my bank provides no online access from KMM or any checking program other than Quicken, so I download the PDF from my bank website and use pdftotext (yes, there is a Windows version) to extract the statement to a text file that can then be processed by any text-processing language of your choice.  My original bank statement text processing code was written (by me) in gawk, then later I switched to an awk derivative called miller.

  

For my bank’s PDF’s I found this to be the most effective way to extract the text, which (for the most part) preserves columns and headings from the PDF version.  The key is the “-layout” and “-enc UTF-8” options:

  

C:\MyBankFolder>  pdftotext -eol dos -cfg sample-xpdfrc -layout -nopgbrk -enc UTF-8 Bank-statement.PDF bank-statement.txt

  

Writing text-processing code to strip out only the transactions from the text file is something you have to write yourself.

  

The pdftotext executable download for Windows can be found here:

  

https://www.xpdfreader.com/download.html

  

Select the “Windows 32/64-bit” download under “Download the Xpdf command line tools:”.

  

If you are interested, a very good Windows gawk can be found here:

  

https://sourceforge.net/projects/ezwinports/files/

  

The miller language executable is available here:

  

https://github.com/johnkerl/miller

  

HTH

  

Peter

  

From: KMyMoney <kmymoney-bounces at kde.org> On Behalf Of Aaron Mehl
Sent: Monday, December 28, 2020 8:47 AM
To: KMyMoney Users' Mailing List <kmymoney at kde.org>
Subject: pdf to kmymoney

  

Hi all,

My bank statements are in pdf format.

I am looking for a clean easy way to import them into KMyMoney.

I googled and found a non-clean answer, paste it as text in excel and export as csv. 

The problem was the the huge amount of manual clean up I had to do.

I see a command line utility pdftotext but I still need a csv file to import. Is there a utility that will turn this text file into csv or some other way to do this.

Thanks,

Aaron
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20201228/a35c51ec/attachment.htm>