Re: [GNC] Third party OFX/CVS providers

2022-08-10 Thread flywire
That never used to be the case but it's still pretty useless for a tax return: Please note that if you wish to download transactions that is more than the 12 month period, you must choose the 'View Statement' option. However, please be advised that it does not have the facility to transfer them in

Re: [GNC] Third party OFX/CVS providers

2022-08-09 Thread Tom Browder
On Sun, Aug 7, 2022 at 09:32 Tom Browder wrote: > On Sun, Aug 7, 2022 at 09:09 Christopher Lam > wrote: > >> You may try this service which is free for personal use. (Not mine) >> >> https://bankstatementconverter.com/ >> > That does a good job, at least on my test pdf statements from

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Fred Bone
On 08 August 2022 at 10:30, Adrien Monteleone said: > Kalpesh, > > Thanks for the links. I have a need for a PDF to CSV solution for other > software and this looks like it is a good fit for me. (folks may be > shocked how many large businesses in 2022 can't generate decent business >

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Glenn Fowler
I couldn't agree more. I took all of my automations and scripts and roughly calculated that I am saving at least a week every year in time. That's a free week of vacation! Now multiply that every single year and with the scripts and automations continually being added it has a compound effect.

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Adrien Monteleone
Here's a use case: Vendor invoices containing 10+ line items that need to be entered into both an accounting package and an inventory/POS system. Multiply that case by a dozen or more a week. And compound it by said 'PDF' invoice being a *scan*. (which of course means really good OCR needs

Re: [GNC] Third party OFX/CVS providers

2022-08-08 Thread Adrien Monteleone
Kalpesh, Thanks for the links. I have a need for a PDF to CSV solution for other software and this looks like it is a good fit for me. (folks may be shocked how many large businesses in 2022 can't generate decent business documents/data in a proper electronic format for using in various

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread flywire
Oh, security isn't a thing anymore? Maybe supply your DOB and mother's maiden name too so they don't have to get it from social media. On Sun, Aug 7, 2022 at 09:09 Christopher Lam https://lists.gnucash.org/mailman/listinfo/gnucash-user>> wrote: >* You may try this service which is free for

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Phyllis Bruce
n case the picture doesn't get through. > > > > > > Thank You, > > > > Gyle McCollam > > > > Gyle McCollam > > > > gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > > > > F

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Greg Feneis
ol...@live.com<mailto:gmccol...@gyleshomes.com> email > > > From: gnucash-user on > behalf of flywire > Sent: Saturday, August 6, 2022 9:36 PM > To: Gnucash Users > Subject: [GNC] Third party OFX/CVS providers > > My Citibank statements are only avai

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Tom Browder
On Sun, Aug 7, 2022 at 09:09 Christopher Lam wrote: > You may try this service which is free for personal use. (Not mine) > > https://bankstatementconverter.com/ > Thanks, Christopher, I’ll give it a shot. -Tom ___ gnucash-user mailing list

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Christopher Lam
You may try this service which is free for personal use. (Not mine) https://bankstatementconverter.com/ On Thu, 4 Aug 2022, 6:40 am Tom Browder, wrote: > My current bank (US, Hancock Whitney) unfortunately does not provide > account data in a digital format other than monthly PDF statements

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Glenn Fowler
, 7:28 AM Tom Browder wrote: > On Sat, Aug 6, 2022 at 21:25 Chris Good wrote: > > From: Tom Browder > > Sent: Sunday, 7 August 2022 12:37 AM > > To: Chris Good > > Cc: gnucash-user@gnucash.org > > Subject: Re: [GNC] Third party OFX/CVS providers > > &

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread David T. via gnucash-user
Sat, Aug 6, 2022 at 21:25 Chris Good wrote: >> From: Tom Browder >> Sent: Sunday, 7 August 2022 12:37 AM >> To: Chris Good >> Cc: gnucash-user@gnucash.org >> Subject: Re: [GNC] Third party OFX/CVS providers >> >> >> >> On Sat, Aug 6, 2022

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread Tom Browder
On Sat, Aug 6, 2022 at 21:25 Chris Good wrote: > From: Tom Browder > Sent: Sunday, 7 August 2022 12:37 AM > To: Chris Good > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] Third party OFX/CVS providers > > > > On Sat, Aug 6, 2022 at 08:51 Chris Good wrote: > &

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Chris Good
From: Tom Browder Sent: Sunday, 7 August 2022 12:37 AM To: Chris Good Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Third party OFX/CVS providers On Sat, Aug 6, 2022 at 08:51 Chris Good mailto:goodchri...@gmail.com> > wrote: .., Can you copy the text out of the pdf sta

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Kalpesh Patel
] Third party OFX/CVS providers Message-ID: Content-Type: text/plain; charset="UTF-8" On Wed, Aug 3, 2022 at 17:39 Tom Browder wrote: > My current bank (US, Hancock Whitney) unfortunately does not provide > account data in a digital format other than monthl

[GNC] Third party OFX/CVS providers

2022-08-06 Thread flywire
My Citibank statements are only available as pdf and I use https://github.com/flywire/pdf_statement_reader . It is based on tabula and forks another project to make it functional. More config info at https://github.com/marlanperumal/pdf_statement_reader/issues/34 .

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Tom Browder
On Sat, Aug 6, 2022 at 18:40 Peter West wrote: > The other great tool for processing pdfs is PDFBox. It’s a java jar file, > so you need to have a reasonably recent JVM installed. > ... Thanks, Peter. And God bless you and yours! -Tom ___

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Peter West
The other great tool for processing pdfs is PDFBox. It’s a java jar file, so you need to have a reasonably recent JVM installed. https://pdfbox.apache.org/ I’m still using version2. Here are the commandline tools. https://pdfbox.apache.org/2.0/commandline.html

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Tom Browder
On Sat, Aug 6, 2022 at 11:43 AM Glenn Fowler wrote: > > My scripts are in PowerShell. For GhostScript I'm just using CLI: Thanks, Glenn, that's close to what I've found for Linux: $ gs -sDEVICE=txtwrite -o output.txt input.pdf It just needs some tweaking and post-conversion parsing (very

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Glenn Fowler
My scripts are in PowerShell. For GhostScript I'm just using CLI: "C:\Program Files\gs\gs9.56.1\bin\gswin64c.exe" -dBATCH -dNOPAUSE -dQUIET -dNoCancel -sDEVICE=txtwrite -sOutputFile=%stdout "InputFile.pdf" This give you the whole PDF and now just parse the text. For iText7 I am using PSWritePDF

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Tom Browder
On Sat, Aug 6, 2022 at 10:43 AM Glenn Fowler wrote: > > Look into GhostScript and iText7. I have used both to pull text out of PDF's > easily in scripts. What program language? Can you show me an example of your code to do that? Thanks. -Tom ___

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Glenn Fowler
Look into GhostScript and iText7. I have used both to pull text out of PDF's easily in scripts. On Sat, Aug 6, 2022, 10:36 AM Tom Browder wrote: > On Sat, Aug 6, 2022 at 08:51 Chris Good wrote: > .., > > > Can you copy the text out of the pdf statement? > > > Getting "organized" text

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Tom Browder
On Sat, Aug 6, 2022 at 08:51 Chris Good wrote: .., > Can you copy the text out of the pdf statement? Getting "organized" text programmatically out of PDF is a giant pain. My current approach is almost completely programmatic. BTW, Raku is the "sister" language of Perl, and it is a "scripting"

Re: [GNC] Third party OFX/CVS providers

2022-08-06 Thread Chris Good
> Message: 5 > Date: Fri, 5 Aug 2022 19:47:45 -0500 > From: Tom Browder > To: Gnucash Users > Subject: Re: [GNC] Third party OFX/CVS providers > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > >> On Wed, Aug 3, 2022 at 17:39 Tom

Re: [GNC] Third party OFX/CVS providers

2022-08-05 Thread Tom Browder
On Wed, Aug 3, 2022 at 17:39 Tom Browder wrote: > My current bank (US, Hancock Whitney) unfortunately does not provide > account data in a digital format other than monthly PDF statements for > personal accounts. I know third-party programs, such as YNAB (ynab.com), > can get access my bank

[GNC] Third party OFX/CVS providers

2022-08-03 Thread Tom Browder
My current bank (US, Hancock Whitney) unfortunately does not provide account data in a digital format other than monthly PDF statements for personal accounts. I know third-party programs, such as YNAB (ynab.com), can get access my bank while I can't, but I don't want the baggage that comes with