[GNC] gnucash-user Digest, Vol 233, Issue 16

Sat Aug 6 15:48:39 EDT 2022

 I am James Baxter email kangaroo52 at yahoo.comas i found this next part and i am not good with Linux and Gnucash.org. I am looking to know how to place that code into this linux or where it is design to go.

 I changed my mind. I now have an YNAB account and found that is has a> well-documented API. Not only that, I was able to link it successfully to
> my two banks and access my checking, savings, and credit card transactions!
> It might be possible to use the API to periodically download bank and
> credit card transactions into YNAB's standard JSON format, then convert
> that into the OFX format, and then upload the OFX into GnuCash.
> 
> I'm proceeding on the project with the hope of success. If anyone is
> interested in following it, the Raku (formerly Perl 6, see https://raku.org)
> module skeleton is on my Github repo now at
> https://github.com/tbrowder/API-YNAB.git. (Note I may soon change the title
> to something like YNAB2OFX or YNAB-OFX--suggestions are very welcome.)
> 
> The downside, assuming I have success, is that YNAB has a subscription fee
> of about $15 per month plus tax (cancel any time) or $100 plus tax a year,
> sums well worth it if I can get a periodic good OFX-to-GnuCash import.
I am still getting us to both Linux and Gnucash. also need to know if there is an icon (desk top) item so it will be easly to use.
thanksJames BaxterKangaroo52 at yahoo.com

    On Saturday, August 6, 2022, 12:00:41 PM EDT, gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org> wrote:  

 Send gnucash-user mailing list submissions to
    gnucash-user at gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
    gnucash-user-request at gnucash.org

You can reach the person managing the list at
    gnucash-user-owner at gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."

Today's Topics:

  1. Re:  Build From Source Near Impossible (Robert Simmons)
  2. Re:  Third party OFX/CVS providers (Chris Good)
  3. Re:  Third party OFX/CVS providers (Tom Browder)
  4. Re:  Third party OFX/CVS providers (Glenn Fowler)
  5. Re:  Third party OFX/CVS providers (Tom Browder)

----------------------------------------------------------------------

Message: 1
Date: Sat, 6 Aug 2022 09:07:06 -0400
From: Robert Simmons <rsimmons0 at gmail.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Build From Source Near Impossible
Message-ID:
    <CA+QLa9Bw4x_ZKjyidMH2B4TVsaEGZjKwDCMd=j1RP_4c1VFyfg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

First of all, Impish is already EOL. You will need to use a flavor of 22.04
LTS for the following. The documentation for how to build GnuCash is
confusing and not all in one place. The following begins with a fresh
install of Lubuntu 22.04 LTS. I use Vagrant so that everything is
deterministically built once I have finished figuring out the correct set
of steps. But, Vagrant is not a requirement; you don't have to use that.
The patch used below is the following. Put it in your /tmp directory before
starting.
https://pastebin.com/qUmxyyLq

sudo patch /etc/apt/sources.list /tmp/sources_list.patch
sudo apt-get build-dep gnucash
mkdir ~/opt
wget
https://github.com/Gnucash/gnucash/releases/download/4.11/gnucash-4.11.tar.gz
mkdir build-gnucash-4.11
tar -zxvf gnucash-4.11.tar.gz
cd build-gnucash-4.11/
cmake -DWITH_PYTHON=ON -DCMAKE_INSTALL_PREFIX=$HOME/opt ../gnucash-4.11
make
make install

I hope this helps.

On Sat, Aug 6, 2022 at 7:03 AM crusadeon09 via gnucash-user <
gnucash-user at gnucash.org> wrote:

> I'm running Ubuntu, 21.10, Impish Indri.
>
> I downloaded the 4.11 tarball, gnucash-4.11.tar.bz2
>
> I followed these directions:
> https://wiki.gnucash.org/wiki/Building
> https://wiki.gnucash.org/wiki/Build_Tools
> https://wiki.gnucash.org/wiki/Building_On_Linux
>
> I tried changing repositories. I ran "sudo apt update" multiple times. The
> dependencies for 4.11 simply wouldn't install.
>
> (base) chris at chris-B550-AORUS-ELITE:~$ sudo apt-get build-dep gnucash
> Reading package lists... Done
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> Some packages could not be installed. This may mean that you have
> requested an impossible situation or if you are using the unstable
> distribution that some required packages have not yet been created
> or been moved out of Incoming.
> The following information may help to resolve the situation:
>
> The following packages have unmet dependencies:
> libgtk-3-dev : Depends: gir1.2-gtk-3.0 (= 3.24.30-1ubuntu1) but
> 3.24.30-1ubuntu1.1 is to be installed
> Depends: libgdk-pixbuf-2.0-dev (>= 2.40.0) but it is not going to be
> installed or
> libgdk-pixbuf2.0-dev (>= 2.40.0) but it is not going to be installed
> Depends: libgtk-3-0 (= 3.24.30-1ubuntu1) but 3.24.30-1ubuntu1.1 is to be
> installed
> libpython3.9-dev : Depends: libpython3.9-stdlib (= 3.9.7-2build1) but
> 3.9.7-2ubuntu0.1 is to be installed
> Depends: libpython3.9 (= 3.9.7-2build1) but 3.9.7-2ubuntu0.1 is to be
> installed
> libsepol1-dev : Depends: libsepol1 (= 3.1-1ubuntu2) but 3.1-1ubuntu2.1 is
> to be installed
> libwebkit2gtk-4.0-dev : Depends: libwebkit2gtk-4.0-37 (=
> 2.34.6-0ubuntu0.21.10.1) but 2.36.3-0ubuntu0.21.10.1 is to be installed
> Depends: gir1.2-webkit2-4.0 (= 2.34.6-0ubuntu0.21.10.1) but
> 2.36.3-0ubuntu0.21.10.1 is to be installed
> Depends: libsoup2.4-dev (>= 2.40) but it is not going to be installed
> Depends: libjavascriptcoregtk-4.0-dev (= 2.34.6-0ubuntu0.21.10.1) but it
> is not going to be installed
> libxml2-dev : Depends: libxml2 (= 2.9.12+dfsg-4ubuntu0.1) but
> 2.9.12+dfsg-4ubuntu0.2 is to be installed
> python3.9-dev : Depends: python3.9 (= 3.9.7-2build1) but 3.9.7-2ubuntu0.1
> is to be installed
> Depends: libpython3.9 (= 3.9.7-2build1) but 3.9.7-2ubuntu0.1 is to be
> installed
> E: Unable to correct problems, you have held broken packages.
>
> I tried loading them individually, but the names are just slightly off.
> https://wiki.gnucash.org/wiki/Dependencies
>
> Ubuntu sees them differently I guess. https://packages.ubuntu.com/
>
> After a couple of hours of carefully trying to build from source, I give
> up. Looks like Ubuntu Software Center has 4.11 in a flatpak.
>
> Does anyone have any better instructions? I'd even submit to watching a
> video at this point.
>
> Sent with [Proton Mail](https://proton.me/) secure email.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

------------------------------

Message: 2
Date: Sat, 6 Aug 2022 23:51:24 +1000
From: Chris Good <goodchris96 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Third party OFX/CVS providers
Message-ID: <38D880C6-A3F4-4B11-B797-6B6AEB5E5DB7 at gmail.com>
Content-Type: text/plain; charset=us-ascii

> Message: 5
> Date: Fri, 5 Aug 2022 19:47:45 -0500
> From: Tom Browder <tom.browder at gmail.com>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID:
>    <CAFMGiz_m8U0ae6=gSL19AEkHV2HDkSkLTM0yC=cs3jKwzxJV8Q at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
> 
>> On Wed, Aug 3, 2022 at 17:39 Tom Browder <tom.browder at gmail.com> 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 while I can't, but I don't want the baggage that
>> comes with it.
>> 
> 
> I changed my mind. I now have an YNAB account and found that is has a
> well-documented API. Not only that, I was able to link it successfully to
> my two banks and access my checking, savings, and credit card transactions!
> It might be possible to use the API to periodically download bank and
> credit card transactions into YNAB's standard JSON format, then convert
> that into the OFX format, and then upload the OFX into GnuCash.
> 
> I'm proceeding on the project with the hope of success. If anyone is
> interested in following it, the Raku (formerly Perl 6, see https://raku.org)
> module skeleton is on my Github repo now at
> https://github.com/tbrowder/API-YNAB.git. (Note I may soon change the title
> to something like YNAB2OFX or YNAB-OFX--suggestions are very welcome.)
> 
> The downside, assuming I have success, is that YNAB has a subscription fee
> of about $15 per month plus tax (cancel any time) or $100 plus tax a year,
> sums well worth it if I can get a periodic good OFX-to-GnuCash import.
> 
> Best regards,
> 
> -Tom
> 
Hi Tom,

Can you copy the text out of the pdf statement?
If so, you could probably write a spreadsheet macro to create a csv, ofx or qif file to import. Alternatively, if you are on Linux, use some scripting language like Perl or awk.
If you use Finance::Quote to import market prices, you already have Perl installed.

Regards, Chris Good

------------------------------

Message: 3
Date: Sat, 6 Aug 2022 09:36:53 -0500
From: Tom Browder <tom.browder at gmail.com>
To: Chris Good <goodchris96 at gmail.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Third party OFX/CVS providers
Message-ID:
    <CAFMGiz8N06yEC-1Q4ow1ak211fSgMMbDtk9x1NNrRGtkxMsoKw at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

On Sat, Aug 6, 2022 at 08:51 Chris Good <goodchris96 at gmail.com> 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" language.

Raku can also use Perl modules so I can use Finance::Quote with it if need
be. But, until I can get the bank data working, I won't be needing it.

Thanks, Chris.

-Tom

------------------------------

Message: 4
Date: Sat, 6 Aug 2022 11:36:29 -0400
From: Glenn Fowler <gfowler1 at outlook.com>
To: Tom Browder <tom.browder at gmail.com>
Cc: Chris Good <goodchris96 at gmail.com>, GnuCash users group
    <gnucash-user at gnucash.org>
Subject: Re: [GNC] Third party OFX/CVS providers
Message-ID:
    <SJ0PR19MB4445775D2FAEC9A3A89651478F619 at SJ0PR19MB4445.namprd19.prod.outlook.com>

Content-Type: text/plain; charset="UTF-8"

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 <tom.browder at gmail.com> wrote:

> On Sat, Aug 6, 2022 at 08:51 Chris Good <goodchris96 at gmail.com> 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" language.
>
> Raku can also use Perl modules so I can use Finance::Quote with it if need
> be. But, until I can get the bank data working, I won't be needing it.
>
> Thanks, Chris.
>
> -Tom
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

------------------------------

Message: 5
Date: Sat, 6 Aug 2022 10:46:53 -0500
From: Tom Browder <tom.browder at gmail.com>
To: Glenn Fowler <gfowler1 at outlook.com>
Cc: Chris Good <goodchris96 at gmail.com>, GnuCash users group
    <gnucash-user at gnucash.org>
Subject: Re: [GNC] Third party OFX/CVS providers
Message-ID:
    <CAFMGiz8K_rdBtOA9NBptzS_yBOk-F5V0-ZYqdy0unS3NZiEMkg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

On Sat, Aug 6, 2022 at 10:43 AM Glenn Fowler <gfowler1 at outlook.com> 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

------------------------------

Subject: Digest Footer

_______________________________________________

gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

------------------------------

End of gnucash-user Digest, Vol 233, Issue 16
*********************************************