[GNC] gnucash-user Digest, Vol 233, Issue 22
James Baxter
kangaroo52 at yahoo.com
Mon Aug 8 09:54:14 EDT 2022
I am looking for something that I may have already. I have had Linux Mint loaded on this laptop for about a month. also have been playing with Gnucash about 3 weeks. still getting us to this, As I find it very nice program.
As i dont know if I have a problem with the two of them, I don't know. So if anybody know if Gnucash will bring down the items it needs to work with.
I am looking to do a schooling on Linux, go from there.
thanksJames Baxterkangaroo52 at yahoo.com
On Sunday, August 7, 2022, 06:04:14 PM EDT, <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: gncJobNextID in gncJob.c not in gncJob.h (Robert Simmons)
2. Re: gncJobNextID in gncJob.c not in gncJob.h (Robert Simmons)
3. Re: Request for two new features in GnuCash (R. Victor Klassen)
4. Re: Convert PDF to OFX/CVS (Tom Browder)
5. transfe money from one account to another (James Baxter)
6. Re: Third party OFX/CVS providers (Greg Feneis)
7. Re: Request for two new features in GnuCash
(davidcousens49 at gmail.com)
----------------------------------------------------------------------
Message: 1
Date: Sun, 7 Aug 2022 16:13:11 -0400
From: Robert Simmons <rsimmons0 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
Message-ID:
<CA+QLa9Cv5hnG9=iXn19W=+7bWmQs7sCVwHA0EqimwAACW_7few at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
I have a workaround.
Here's the Python for anyone who needs it. This sets the Job ID counter to
3, but you would change that 3 to whatever the ID you want.
import pathlib
import sqlite3
target = pathlib.Path('test.gnucash')
con = sqlite3.connect(target)
cur = con.cursor()
cur.execute('UPDATE slots SET int64_val = int64_val + 1 WHERE name =
"counters/gncJob"')
con.commit()
con.close()
Alternatively, if you're creating many Jobs using Python bindings, just
keep a count and use this alternative update. This takes a integer variable
"count" that you calculate while using Python bindings.
cur.execute(f'UPDATE slots SET int64_val = int64_val + {count} WHERE name =
"counters/gncJob"')
------------------------------
Message: 2
Date: Sun, 7 Aug 2022 16:14:44 -0400
From: Robert Simmons <rsimmons0 at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
Message-ID:
<CA+QLa9AfEGH1wA66Jr+sAD8S1Yt7C=4bRCTjk8X-hPJWGDhP_w at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Little error there. I improved the query while writing: "This sets the Job
ID counter to 3, but you would change that 3 to whatever the ID you want."
should be "This increments the Job ID to the next"
------------------------------
Message: 3
Date: Sun, 7 Aug 2022 16:33:14 -0400
From: "R. Victor Klassen" <rvklassen at gmail.com>
To: Eric Hammond <eric at jehammond.net>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Request for two new features in GnuCash
Message-ID: <67D3B7BA-5E92-48FE-8865-2F931DC5EC9D at gmail.com>
Content-Type: text/plain; charset=utf-8
I routinely pay invoices from multiple accounts. We have pseudo customers for each farmers market we attend. After the market is done I create an invoice for the appropriate ?customer ?. I pay it twice. The first time with the amount that was paid by credit or debit card- to an account connected to the payment processor- and then the balance to petty cash.
I have to edit the proposed payment amount the first time and then not close the invoice window before paying it again (I could close it and come back if I forgot but that?s not the efficient workflow)
Is this what you want?
Sent from my iPhone
> On Aug 7, 2022, at 3:18 PM, Eric Hammond <eric at jehammond.net> wrote:
>
> ?Thanks again to all who answered my two part question (next time I will make it two separate questions...)
>
> Frank, I already have that selected. The problem is not how transactions are entered or displayed.
> If I am entering a manual transaction, I can add any number of splits no problem.
> The issue is specifically with the Bill, or Invoice, "Process Payment" form which only allows one payment amount, and one transfer account (from the account tree).
> If I bypass the "Process Payment" by using manual transactions the Bill or Invoice is not closed.
>
> All the best,
> Eric Hammond
>
>
> Message: 6
> Date: Sun, 7 Aug 2022 06:19:40 +0200
> From: "Frank H. Ellenberger" <frank.h.ellenberger at gmail.com>
> To: Eric Hammond <eric at jehammond.net>, "gnucash-user at gnucash.org"
> <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Request for two new features in GnuCash
> Message-ID: <1e0d8ed8-6ba0-b5b8-4190-8664b349fe02 at gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
>
>
>> Am 07.08.22 um 03:04 schrieb Eric Hammond:
>> The second is the ability to pay bills from more than one source. Example I purchase an oscilloscope and pay for it with a cash incentive from the company and a bank transfer for the rest. My solution at the present is not pretty, nor helpful if I look at it next year.
>
> Then it's time to claim your easter egg ;-):
> Edit->Peeferences->Register Defaults,
> select Default Style: "Auto-Split ledger" or "Transaction Journal"
>
> More details in
> https://www.gnucash.org/docs/v4/C/gnucash-help/set-prefs.html#prefs-reg-def
>
> Then you can easily enter the differnt amounts.
>
> Regards
> Frank
>
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 7 Aug 2022 17:44:36 +1000
> From: flywire <flywire0 at gmail.com>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: [GNC] Request for two new features in GnuCash
> Message-ID:
> <CAOthWL0tL=4ivF+1s=6fu_Maq6NqFUU1maK3m-ZT_f6p1UuheA at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> More cat skinning:
>
>> * the ability to have two separate (at least) GnuCash file systems:
> *
>
> In Windows (or probably any GUI) double-click file in data folder and it
> will use file association to open the file (in GnuCash).
>
> Alternatively, for each file: right-click file, create a shortcut, drag
> shortcut to desktop. Same as above from desktop.
>
>
> ------------------------------
>
> Message: 8
> Date: Sun, 7 Aug 2022 06:28:50 -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:
> <CAFMGiz8TCnPRm2VkU57EF0aXVDZgV8BvU0i-7WYz+MVVa7uutg at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
>> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchris96 at gmail.com> wrote:
>> From: Tom Browder <tom.browder at gmail.com>
>> Sent: Sunday, 7 August 2022 12:37 AM
>> To: Chris Good <goodchris96 at gmail.com>
>> Cc: gnucash-user at gnucash.org
>> Subject: Re: [GNC] Third party OFX/CVS providers
>>
>>
>>
>> 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
>>
>>
>>
>> Hi Tom,
>>
>>
>>
>> I was actually suggesting you just highlight the transactions in the pdf statement and copy/paste them into a
>>
>> spreadsheet or text file before using a scripting language to reformat them but if you can programmatically
>> extract the text that would be better long term.
>
> But I did see Peter West's warning about checking results
> carefully--it's not always the expected result. Although I hope the
> products from the same source are consistent enough to make it
> reasonably fool proof. (See my comments below.)
>
>> I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows me to select text (as they want me to pay for a fancy tool - BOO) but if you send the pdf to Edge or Chrome you can select just the transaction text.
>
> Yes, I now see my "PDF COmplete" on Windows can do that--I never
> thought of doing that until now.
>
>> Thanks for the info re Raku.
>
> You're welcome! I'm always happy for programmers to learn about Raku
>
>> Finance::Quote is just for getting stock prices from websites (usually) so not useful for this task.
>
> Right, but good to know for later.
>
>> Are you sure you cannot export transactions from your bank? All mine do although sometimes it is hard to find.
>
> Yes, and I agree it's sometimes hard to find. Yesterday I did find one
> bank (the bank I'm leaving) does have two choices of download for the
> credit card: CSV and OFX. That is very helpful for working on a
> transformation algorithm. I did look at the PDF to text transformation
> on one of the new bank's statements (definitely nothing but PDFs) and
> it looks surprisingly usable, so that's exciting.
>
> I was too hasty in my outright condemnation of PDF to text because I
> had worked on a project with a PDF expert to generate PDF as a native
> file and saw how easy it is to get things out of place. I usually
> create beautiful, and accurate, PDFs by writing the PostScript code
> and relying on Ghostscript's ps2pdf converter. Thus going backwards in
> the workflow is a little different for my longtime mindset.
>
> Best regards,
>
> -Tom
>
>
> ------------------------------
>
> Message: 9
> Date: Sun, 07 Aug 2022 11:57:10 +0100
> From: "Fred Bone" <Fred at mandfb.me.uk>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash-user Digest, Vol 233, Issue 16
> Message-ID: <62EF9A86.28284.2F1A96F6 at Fred.mandfb.me.uk>
> Content-Type: text/plain; charset=US-ASCII
>
> On 06 August 2022 at 19:48, James Baxter said:
>
>> 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.
>
> Kindly pay attention to:
>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>
> and please trim your posts.
>
>
>
> ------------------------------
>
> Message: 10
> Date: Sun, 07 Aug 2022 16:12:54 +0300
> From: "David T." <sunfish62 at yahoo.com>
> To: gnucash-user at gnucash.org, Tom Browder <tom.browder at gmail.com>,
> Chris Good <goodchris96 at gmail.com>
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID: <046ABA80-7C9C-4AAA-A29D-953442079DCC at yahoo.com>
> Content-Type: text/plain; charset=utf-8
>
> I can't imagine having so many transactions that the time it took to program the process would in the end save me time in doing the accounting.
>
> My method for processing pdf statements is to open the pdf statement in one window and enter my transactions in GnuCash in another-- the old fashioned way: by keying them in. This is remarkably quick in most cases, due to autofill-- and it gives me a sanity check on the data that's getting input (does that transaction look right?). It works pretty well for me.
>
> David T.
>
>
>
>> On August 7, 2022 2:28:50 PM GMT+03:00, Tom Browder <tom.browder at gmail.com> wrote:
>>> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchris96 at gmail.com> wrote:
>>> From: Tom Browder <tom.browder at gmail.com>
>>> Sent: Sunday, 7 August 2022 12:37 AM
>>> To: Chris Good <goodchris96 at gmail.com>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: [GNC] Third party OFX/CVS providers
>>>
>>>
>>>
>>>> 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
>>>
>>>
>>>
>>> Hi Tom,
>>>
>>>
>>>
>>> I was actually suggesting you just highlight the transactions in the pdf statement and copy/paste them into a
>>>
>>> spreadsheet or text file before using a scripting language to reformat them but if you can programmatically
>>> extract the text that would be better long term.
>>
>> But I did see Peter West's warning about checking results
>> carefully--it's not always the expected result. Although I hope the
>> products from the same source are consistent enough to make it
>> reasonably fool proof. (See my comments below.)
>>
>>> I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows me to select text (as they want me to pay for a fancy tool - BOO) but if you send the pdf to Edge or Chrome you can select just the transaction text.
>>
>> Yes, I now see my "PDF COmplete" on Windows can do that--I never
>> thought of doing that until now.
>>
>>> Thanks for the info re Raku.
>>
>> You're welcome! I'm always happy for programmers to learn about Raku
>>
>>> Finance::Quote is just for getting stock prices from websites (usually) so not useful for this task.
>>
>> Right, but good to know for later.
>>
>>> Are you sure you cannot export transactions from your bank? All mine do although sometimes it is hard to find.
>>
>> Yes, and I agree it's sometimes hard to find. Yesterday I did find one
>> bank (the bank I'm leaving) does have two choices of download for the
>> credit card: CSV and OFX. That is very helpful for working on a
>> transformation algorithm. I did look at the PDF to text transformation
>> on one of the new bank's statements (definitely nothing but PDFs) and
>> it looks surprisingly usable, so that's exciting.
>>
>> I was too hasty in my outright condemnation of PDF to text because I
>> had worked on a project with a PDF expert to generate PDF as a native
>> file and saw how easy it is to get things out of place. I usually
>> create beautiful, and accurate, PDFs by writing the PostScript code
>> and relying on Ghostscript's ps2pdf converter. Thus going backwards in
>> the workflow is a little different for my longtime mindset.
>>
>> Best regards,
>>
>> -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: 11
> Date: Sun, 7 Aug 2022 09:25:27 -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:
> <SJ0PR19MB44450340E5332D96385C00058F609 at SJ0PR19MB4445.namprd19.prod.outlook.com>
>
> Content-Type: text/plain; charset="UTF-8"
>
> On Windows I would recommend Ocular which is a PDF viewer and light editor
> that you can find in the Windows Store. Ocular allows copying text.
>
> Ocular is open source, ad free, and make by KDE so you won't have to worry
> about them taking features away like mentioned with Adobe.
>
>> On Sun, Aug 7, 2022, 7:28 AM Tom Browder <tom.browder at gmail.com> wrote:
>>
>>> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchris96 at gmail.com> wrote:
>>> From: Tom Browder <tom.browder at gmail.com>
>>> Sent: Sunday, 7 August 2022 12:37 AM
>>> To: Chris Good <goodchris96 at gmail.com>
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: [GNC] Third party OFX/CVS providers
>>>
>>>
>>>
>>>> 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
>>>
>>>
>>>
>>> Hi Tom,
>>>
>>>
>>>
>>> I was actually suggesting you just highlight the transactions in the pdf
>> statement and copy/paste them into a
>>>
>>> spreadsheet or text file before using a scripting language to reformat
>> them but if you can programmatically
>>> extract the text that would be better long term.
>>
>> But I did see Peter West's warning about checking results
>> carefully--it's not always the expected result. Although I hope the
>> products from the same source are consistent enough to make it
>> reasonably fool proof. (See my comments below.)
>>
>>> I notice with my PDF statement that (free) Adobe Acrobat DC no longer
>> allows me to select text (as they want me to pay for a fancy tool - BOO)
>> but if you send the pdf to Edge or Chrome you can select just the
>> transaction text.
>>
>> Yes, I now see my "PDF COmplete" on Windows can do that--I never
>> thought of doing that until now.
>>
>>> Thanks for the info re Raku.
>>
>> You're welcome! I'm always happy for programmers to learn about Raku
>>
>>> Finance::Quote is just for getting stock prices from websites (usually)
>> so not useful for this task.
>>
>> Right, but good to know for later.
>>
>>> Are you sure you cannot export transactions from your bank? All mine do
>> although sometimes it is hard to find.
>>
>> Yes, and I agree it's sometimes hard to find. Yesterday I did find one
>> bank (the bank I'm leaving) does have two choices of download for the
>> credit card: CSV and OFX. That is very helpful for working on a
>> transformation algorithm. I did look at the PDF to text transformation
>> on one of the new bank's statements (definitely nothing but PDFs) and
>> it looks surprisingly usable, so that's exciting.
>>
>> I was too hasty in my outright condemnation of PDF to text because I
>> had worked on a project with a PDF expert to generate PDF as a native
>> file and saw how easy it is to get things out of place. I usually
>> create beautiful, and accurate, PDFs by writing the PostScript code
>> and relying on Ghostscript's ps2pdf converter. Thus going backwards in
>> the workflow is a little different for my longtime mindset.
>>
>> Best regards,
>>
>> -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.
>>
>
>
> ------------------------------
>
> 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 19
> *********************************************
> _______________________________________________
> 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: 4
Date: Sun, 7 Aug 2022 15:46:05 -0500
From: Tom Browder <tom.browder at gmail.com>
To: rick1 <rick1 at dreskin.net>
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: [GNC] Convert PDF to OFX/CVS
Message-ID:
<CAFMGiz_TwrUrNOQz3Sf63keco3seCUOOHT4Loy7ZTWCWU1Aj8Q at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Sun, Aug 7, 2022 at 13:10 rick1 via gnucash-user <
gnucash-user at gnucash.org
wrote:
?
> What Mr. Browder really needs is a different bank. For a bank to not
> provide a usable digital download ought to be disqualifying.
I agree, Rick, and I am looking. But it?s not trivial changing banks with
all the set ups with auto payments, etc. Anyway, I love the excuse to
program for the existing situation.
On that note, I?m looking for the ofx and csv import test in the source to
get some hints.
Cheers!
-Tom
>
------------------------------
Message: 5
Date: Sun, 7 Aug 2022 21:43:51 +0000 (UTC)
From: James Baxter <kangaroo52 at yahoo.com>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: [GNC] transfe money from one account to another
Message-ID: <63467870.1092418.1659908631812 at mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8
Yes, I see some people show yooou how to transfee money from one acc (Checking acc to Saving Acc)so when in that place. i am watching one person do that, but I dont see all of what he is doing.
the same page where you place your spending, but I dont see how you get the account on the page.
I start with the checking acc, as i wish to place $25.00 into my saving account to keep the bank from charging me .so am I missing something. you need an account in there, But where.
ThanksJames Baxterkangaroo52 at yahoo.com
------------------------------
Message: 6
Date: Sun, 7 Aug 2022 15:00:14 -0700
From: Greg Feneis <mfeneis at gmail.com>
To: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Third party OFX/CVS providers
Message-ID:
<CAJdmZ-UU_DL=vu6MLKeVVDqzCEm-266vG_QAoZf2GU2_MGW1ig at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Same.
Making FI data available to the user to download without Quicken to hold
the user's hand seems like at best an afterthought in the design of most FI
websites. I find I really have to dig for it at many sites.
Kind regards,
Greg Feneis
On Sat, Aug 6, 2022 at 7:16 PM Gyle McCollam <gmccollam at live.com> wrote:
> I have a Citibank credit card and I use the online banking tool to
> download a QFX file, but I went to their website and to the activity (not
> Statements) and selected the activity/statement month. Then I selected the
> download icon and it gave me the following:
> [cid:dc3e8429-3ab4-4639-9150-ff3c3a03ffd5]
> As you can see there are many formats to choose from. I don't know what
> type of statement you are downloading, but I would think if they give you
> these options on a credit card, they may give you these options on another
> type of account. However, it wouldn't be the first time the left hand
> didn't know what the right hand was doing.
>
> I've added an attachment in case the picture doesn't get through.
>
>
> Thank You,
>
> Gyle McCollam
>
> Gyle McCollam
>
> gmccollam at live.com<mailto:gmccollam at gyleshomes.com> email
>
> ________________________________
> From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on
> behalf of flywire <flywire0 at gmail.com>
> Sent: Saturday, August 6, 2022 9:36 PM
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: [GNC] Third party OFX/CVS providers
>
> 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 .
> _______________________________________________
> 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.
> _______________________________________________
> 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: 7
Date: Mon, 08 Aug 2022 08:00:47 +1000
From: davidcousens49 at gmail.com
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Request for two new features in GnuCash
Message-ID: <8ace0b726ef1ca356de0ec1bda0fdf2119eca5a9.camel at gmail.com>
Content-Type: text/plain; charset="UTF-8"
Eric
AFAIK you can do this by making a payment of less than the due amount from one
account and then makea second (or more) payment from another account to the same
invoice - just cant do it in a single step.
David Cousens
On Sun, 2022-08-07 at 19:17 +0000, Eric Hammond wrote:
> Thanks again to all who answered my two part question (next time I will make
> it two separate questions...)
>
> Frank, I already have that selected. The problem is not how transactions are
> entered or displayed.
> If I am entering a manual transaction, I can add any number of splits no
> problem.
> The issue is specifically with the Bill, or Invoice, "Process Payment" form
> which only allows one payment amount, and one transfer account (from the
> account tree).
> If I bypass the "Process Payment" by using manual transactions the Bill or
> Invoice is not closed.
>
> All the best,
> Eric Hammond
>
>
> Message: 6
> Date: Sun, 7 Aug 2022 06:19:40 +0200
> From: "Frank H. Ellenberger" <frank.h.ellenberger at gmail.com>
> To: Eric Hammond <eric at jehammond.net>, "gnucash-user at gnucash.org"
> <gnucash-user at gnucash.org>
> Subject: Re: [GNC] Request for two new features in GnuCash
> Message-ID: <1e0d8ed8-6ba0-b5b8-4190-8664b349fe02 at gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
>
>
> Am 07.08.22 um 03:04 schrieb Eric Hammond:
> > The second is the ability to pay bills from more than one source. Example I
> > purchase an oscilloscope and pay for it with a cash incentive from the
> > company and a bank transfer for the rest. My solution at the present is not
> > pretty, nor helpful if I look at it next year.
>
> Then it's time to claim your easter egg ;-):
> Edit->Peeferences->Register Defaults,
> select Default Style: "Auto-Split ledger" or "Transaction Journal"
>
> More details in
> https://www.gnucash.org/docs/v4/C/gnucash-help/set-prefs.html#prefs-reg-def
>
> Then you can easily enter the differnt amounts.
>
> Regards
> Frank
>
>
>
> ------------------------------
>
> Message: 7
> Date: Sun, 7 Aug 2022 17:44:36 +1000
> From: flywire <flywire0 at gmail.com>
> To: Gnucash Users <gnucash-user at gnucash.org>
> Subject: [GNC] Request for two new features in GnuCash
> Message-ID:
> <CAOthWL0tL=4ivF+1s=6fu_Maq6NqFUU1maK3m-ZT_f6p1UuheA at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> More cat skinning:
>
> > * the ability to have two separate (at least) GnuCash file systems:
> *
>
> In Windows (or probably any GUI) double-click file in data folder and it
> will use file association to open the file (in GnuCash).
>
> Alternatively, for each file: right-click file, create a shortcut, drag
> shortcut to desktop. Same as above from desktop.
>
>
> ------------------------------
>
> Message: 8
> Date: Sun, 7 Aug 2022 06:28:50 -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:
> <CAFMGiz8TCnPRm2VkU57EF0aXVDZgV8BvU0i-7WYz+MVVa7uutg at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchris96 at gmail.com> wrote:
> > From: Tom Browder <tom.browder at gmail.com>
> > Sent: Sunday, 7 August 2022 12:37 AM
> > To: Chris Good <goodchris96 at gmail.com>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: [GNC] Third party OFX/CVS providers
> >
> >
> >
> > 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
> >
> >
> >
> > Hi Tom,
> >
> >
> >
> > I was actually suggesting you just highlight the transactions in the pdf
> > statement and copy/paste them into a
> >
> > spreadsheet or text file before using a scripting language to reformat them
> > but if you can programmatically
> > extract the text that would be better long term.
>
> But I did see Peter West's warning about checking results
> carefully--it's not always the expected result. Although I hope the
> products from the same source are consistent enough to make it
> reasonably fool proof. (See my comments below.)
>
> > I notice with my PDF statement that (free) Adobe Acrobat DC no longer allows
> > me to select text (as they want me to pay for a fancy tool - BOO) but if you
> > send the pdf to Edge or Chrome you can select just the transaction text.
>
> Yes, I now see my "PDF COmplete" on Windows can do that--I never
> thought of doing that until now.
>
> > Thanks for the info re Raku.
>
> You're welcome! I'm always happy for programmers to learn about Raku
>
> > Finance::Quote is just for getting stock prices from websites (usually) so
> > not useful for this task.
>
> Right, but good to know for later.
>
> > Are you sure you cannot export transactions from your bank? All mine do
> > although sometimes it is hard to find.
>
> Yes, and I agree it's sometimes hard to find. Yesterday I did find one
> bank (the bank I'm leaving) does have two choices of download for the
> credit card: CSV and OFX. That is very helpful for working on a
> transformation algorithm. I did look at the PDF to text transformation
> on one of the new bank's statements (definitely nothing but PDFs) and
> it looks surprisingly usable, so that's exciting.
>
> I was too hasty in my outright condemnation of PDF to text because I
> had worked on a project with a PDF expert to generate PDF as a native
> file and saw how easy it is to get things out of place. I usually
> create beautiful, and accurate, PDFs by writing the PostScript code
> and relying on Ghostscript's ps2pdf converter. Thus going backwards in
> the workflow is a little different for my longtime mindset.
>
> Best regards,
>
> -Tom
>
>
> ------------------------------
>
> Message: 9
> Date: Sun, 07 Aug 2022 11:57:10 +0100
> From: "Fred Bone" <Fred at mandfb.me.uk>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] gnucash-user Digest, Vol 233, Issue 16
> Message-ID: <62EF9A86.28284.2F1A96F6 at Fred.mandfb.me.uk>
> Content-Type: text/plain; charset=US-ASCII
>
> On 06 August 2022 at 19:48, James Baxter said:
>
> > 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.
>
> Kindly pay attention to:
>
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of gnucash-user digest..."
>
> and please trim your posts.
>
>
>
> ------------------------------
>
> Message: 10
> Date: Sun, 07 Aug 2022 16:12:54 +0300
> From: "David T." <sunfish62 at yahoo.com>
> To: gnucash-user at gnucash.org, Tom Browder <tom.browder at gmail.com>,
> Chris Good <goodchris96 at gmail.com>
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID: <046ABA80-7C9C-4AAA-A29D-953442079DCC at yahoo.com>
> Content-Type: text/plain; charset=utf-8
>
> I can't imagine having so many transactions that the time it took to program
> the process would in the end save me time in doing the accounting.
>
> My method for processing pdf statements is to open the pdf statement in one
> window and enter my transactions in GnuCash in another-- the old fashioned
> way: by keying them in. This is remarkably quick in most cases, due to
> autofill-- and it gives me a sanity check on the data that's getting input
> (does that transaction look right?). It works pretty well for me.
>
> David T.
>
>
>
> On August 7, 2022 2:28:50 PM GMT+03:00, Tom Browder <tom.browder at gmail.com>
> wrote:
> > On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchris96 at gmail.com> wrote:
> > > From: Tom Browder <tom.browder at gmail.com>
> > > Sent: Sunday, 7 August 2022 12:37 AM
> > > To: Chris Good <goodchris96 at gmail.com>
> > > Cc: gnucash-user at gnucash.org
> > > Subject: Re: [GNC] Third party OFX/CVS providers
> > >
> > >
> > >
> > > 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
> > >
> > >
> > >
> > > Hi Tom,
> > >
> > >
> > >
> > > I was actually suggesting you just highlight the transactions in the pdf
> > > statement and copy/paste them into a
> > >
> > > spreadsheet or text file before using a scripting language to reformat
> > > them but if you can programmatically
> > > extract the text that would be better long term.
> >
> > But I did see Peter West's warning about checking results
> > carefully--it's not always the expected result. Although I hope the
> > products from the same source are consistent enough to make it
> > reasonably fool proof. (See my comments below.)
> >
> > > I notice with my PDF statement that (free) Adobe Acrobat DC no longer
> > > allows me to select text (as they want me to pay for a fancy tool - BOO)
> > > but if you send the pdf to Edge or Chrome you can select just the
> > > transaction text.
> >
> > Yes, I now see my "PDF COmplete" on Windows can do that--I never
> > thought of doing that until now.
> >
> > > Thanks for the info re Raku.
> >
> > You're welcome! I'm always happy for programmers to learn about Raku
> >
> > > Finance::Quote is just for getting stock prices from websites (usually) so
> > > not useful for this task.
> >
> > Right, but good to know for later.
> >
> > > Are you sure you cannot export transactions from your bank? All mine do
> > > although sometimes it is hard to find.
> >
> > Yes, and I agree it's sometimes hard to find. Yesterday I did find one
> > bank (the bank I'm leaving) does have two choices of download for the
> > credit card: CSV and OFX. That is very helpful for working on a
> > transformation algorithm. I did look at the PDF to text transformation
> > on one of the new bank's statements (definitely nothing but PDFs) and
> > it looks surprisingly usable, so that's exciting.
> >
> > I was too hasty in my outright condemnation of PDF to text because I
> > had worked on a project with a PDF expert to generate PDF as a native
> > file and saw how easy it is to get things out of place. I usually
> > create beautiful, and accurate, PDFs by writing the PostScript code
> > and relying on Ghostscript's ps2pdf converter. Thus going backwards in
> > the workflow is a little different for my longtime mindset.
> >
> > Best regards,
> >
> > -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: 11
> Date: Sun, 7 Aug 2022 09:25:27 -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:
> <
> SJ0PR19MB44450340E5332D96385C00058F609 at SJ0PR19MB4445.namprd19.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="UTF-8"
>
> On Windows I would recommend Ocular which is a PDF viewer and light editor
> that you can find in the Windows Store. Ocular allows copying text.
>
> Ocular is open source, ad free, and make by KDE so you won't have to worry
> about them taking features away like mentioned with Adobe.
>
> On Sun, Aug 7, 2022, 7:28 AM Tom Browder <tom.browder at gmail.com> wrote:
>
> > On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchris96 at gmail.com> wrote:
> > > From: Tom Browder <tom.browder at gmail.com>
> > > Sent: Sunday, 7 August 2022 12:37 AM
> > > To: Chris Good <goodchris96 at gmail.com>
> > > Cc: gnucash-user at gnucash.org
> > > Subject: Re: [GNC] Third party OFX/CVS providers
> > >
> > >
> > >
> > > 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
> > >
> > >
> > >
> > > Hi Tom,
> > >
> > >
> > >
> > > I was actually suggesting you just highlight the transactions in the pdf
> > statement and copy/paste them into a
> > > spreadsheet or text file before using a scripting language to reformat
> > them but if you can programmatically
> > > extract the text that would be better long term.
> >
> > But I did see Peter West's warning about checking results
> > carefully--it's not always the expected result. Although I hope the
> > products from the same source are consistent enough to make it
> > reasonably fool proof. (See my comments below.)
> >
> > > I notice with my PDF statement that (free) Adobe Acrobat DC no longer
> > allows me to select text (as they want me to pay for a fancy tool - BOO)
> > but if you send the pdf to Edge or Chrome you can select just the
> > transaction text.
> >
> > Yes, I now see my "PDF COmplete" on Windows can do that--I never
> > thought of doing that until now.
> >
> > > Thanks for the info re Raku.
> >
> > You're welcome! I'm always happy for programmers to learn about Raku
> >
> > > Finance::Quote is just for getting stock prices from websites (usually)
> > so not useful for this task.
> >
> > Right, but good to know for later.
> >
> > > Are you sure you cannot export transactions from your bank? All mine do
> > although sometimes it is hard to find.
> >
> > Yes, and I agree it's sometimes hard to find. Yesterday I did find one
> > bank (the bank I'm leaving) does have two choices of download for the
> > credit card: CSV and OFX. That is very helpful for working on a
> > transformation algorithm. I did look at the PDF to text transformation
> > on one of the new bank's statements (definitely nothing but PDFs) and
> > it looks surprisingly usable, so that's exciting.
> >
> > I was too hasty in my outright condemnation of PDF to text because I
> > had worked on a project with a PDF expert to generate PDF as a native
> > file and saw how easy it is to get things out of place. I usually
> > create beautiful, and accurate, PDFs by writing the PostScript code
> > and relying on Ghostscript's ps2pdf converter. Thus going backwards in
> > the workflow is a little different for my longtime mindset.
> >
> > Best regards,
> >
> > -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.
> >
>
> ------------------------------
>
> 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 19
> *********************************************
> _______________________________________________
> 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.
------------------------------
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 22
*********************************************
More information about the gnucash-user
mailing list