I am James Baxter email kangaroo52@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 baxterkangaro...@yahoo.com On Saturday, August 6, 2022, 12:00:41 PM EDT, gnucash-user-requ...@gnucash.org <gnucash-user-requ...@gnucash.org> wrote: Send gnucash-user mailing list submissions to gnucash-user@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-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@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 <rsimmo...@gmail.com> To: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> Subject: Re: [GNC] Build From Source Near Impossible Message-ID: <CA+QLa9Bw4x_ZKjyidMH2B4TVsaEGZjKwDCMd=j1rp_4c1vf...@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@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@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@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 <goodchri...@gmail.com> To: gnucash-user@gnucash.org Subject: Re: [GNC] Third party OFX/CVS providers Message-ID: <38d880c6-a3f4-4b11-b797-6b6aeb5e5...@gmail.com> Content-Type: text/plain; charset=us-ascii > Message: 5 > Date: Fri, 5 Aug 2022 19:47:45 -0500 > From: Tom Browder <tom.brow...@gmail.com> > To: Gnucash Users <gnucash-user@gnucash.org> > Subject: Re: [GNC] Third party OFX/CVS providers > Message-ID: > <CAFMGiz_m8U0ae6=gSL19AEkHV2HDkSkLTM0yC=cs3jkwzxj...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > >> On Wed, Aug 3, 2022 at 17:39 Tom Browder <tom.brow...@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.brow...@gmail.com> To: Chris Good <goodchri...@gmail.com> Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Third party OFX/CVS providers Message-ID: <cafmgiz8n06yec-1q4ow1ak211fsgmmbdtk9x1nnrrgtkxms...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" On Sat, Aug 6, 2022 at 08:51 Chris Good <goodchri...@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 <gfowl...@outlook.com> To: Tom Browder <tom.brow...@gmail.com> Cc: Chris Good <goodchri...@gmail.com>, GnuCash users group <gnucash-user@gnucash.org> Subject: Re: [GNC] Third party OFX/CVS providers Message-ID: <sj0pr19mb4445775d2faec9a3a89651478f...@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.brow...@gmail.com> wrote: > On Sat, Aug 6, 2022 at 08:51 Chris Good <goodchri...@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@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.brow...@gmail.com> To: Glenn Fowler <gfowl...@outlook.com> Cc: Chris Good <goodchri...@gmail.com>, GnuCash users group <gnucash-user@gnucash.org> Subject: Re: [GNC] Third party OFX/CVS providers Message-ID: <cafmgiz8k_rdbtoa9nbptzs_ybok-f5v0-zyqdy0uns3nzie...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" On Sat, Aug 6, 2022 at 10:43 AM Glenn Fowler <gfowl...@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@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 ********************************************* _______________________________________________ gnucash-user mailing list gnucash-user@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.