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 baxterkangaro...@yahoo.com
On Sunday, August 7, 2022, 06:04:14 PM EDT,
<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: 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
(davidcousen...@gmail.com)
----------------------------------------------------------------------
Message: 1
Date: Sun, 7 Aug 2022 16:13:11 -0400
From: Robert Simmons <rsimmo...@gmail.com>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
Message-ID:
<CA+QLa9Cv5hnG9=iXn19W=+7bwmqs7scvwha0eqimwaacw_7...@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 <rsimmo...@gmail.com>
To: gnucash-user@gnucash.org
Subject: Re: [GNC] gncJobNextID in gncJob.c not in gncJob.h
Message-ID:
<CA+QLa9AfEGH1wA66Jr+sAD8S1Yt7C=4brctjk8x-hpjwgdh...@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" <rvklas...@gmail.com>
To: Eric Hammond <e...@jehammond.net>
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Request for two new features in GnuCash
Message-ID: <67d3b7ba-5e92-48fe-8865-2f931dc5e...@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 <e...@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.ellenber...@gmail.com>
> To: Eric Hammond <e...@jehammond.net>, "gnucash-user@gnucash.org"
> <gnucash-user@gnucash.org>
> Subject: Re: [GNC] Request for two new features in GnuCash
> Message-ID: <1e0d8ed8-6ba0-b5b8-4190-8664b349f...@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 <flywi...@gmail.com>
> To: Gnucash Users <gnucash-user@gnucash.org>
> Subject: [GNC] Request for two new features in GnuCash
> Message-ID:
> <CAOthWL0tL=4ivF+1s=6fu_maq6nqfuu1mak3m-zt_f6p1uu...@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.brow...@gmail.com>
> To: Chris Good <goodchri...@gmail.com>
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID:
> <cafmgiz8tcnprm2vku57ef0axvdzgv8bvu0i-7wyz+mvva7u...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
>> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchri...@gmail.com> wrote:
>> From: Tom Browder <tom.brow...@gmail.com>
>> Sent: Sunday, 7 August 2022 12:37 AM
>> To: Chris Good <goodchri...@gmail.com>
>> Cc: gnucash-user@gnucash.org
>> Subject: Re: [GNC] Third party OFX/CVS providers
>>
>>
>>
>> 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
>>
>>
>>
>> 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" <f...@mandfb.me.uk>
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] gnucash-user Digest, Vol 233, Issue 16
> Message-ID: <62ef9a86.28284.2f1a9...@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@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." <sunfis...@yahoo.com>
> To: gnucash-user@gnucash.org, Tom Browder <tom.brow...@gmail.com>,
> Chris Good <goodchri...@gmail.com>
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID: <046aba80-7c9c-4aaa-a29d-953442079...@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.brow...@gmail.com>
>> wrote:
>>> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchri...@gmail.com> wrote:
>>> From: Tom Browder <tom.brow...@gmail.com>
>>> Sent: Sunday, 7 August 2022 12:37 AM
>>> To: Chris Good <goodchri...@gmail.com>
>>> Cc: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Third party OFX/CVS providers
>>>
>>>
>>>
>>>> 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
>>>
>>>
>>>
>>> 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@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 <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:
>
><sj0pr19mb44450340e5332d96385c00058f...@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.brow...@gmail.com> wrote:
>>
>>> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchri...@gmail.com> wrote:
>>> From: Tom Browder <tom.brow...@gmail.com>
>>> Sent: Sunday, 7 August 2022 12:37 AM
>>> To: Chris Good <goodchri...@gmail.com>
>>> Cc: gnucash-user@gnucash.org
>>> Subject: Re: [GNC] Third party OFX/CVS providers
>>>
>>>
>>>
>>>> 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
>>>
>>>
>>>
>>> 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@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@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@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.brow...@gmail.com>
To: rick1 <ri...@dreskin.net>
Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: Re: [GNC] Convert PDF to OFX/CVS
Message-ID:
<cafmgiz_twrurnoqz3sf63keco3secuooht4loy7ztwcwu1a...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Sun, Aug 7, 2022 at 13:10 rick1 via gnucash-user <
gnucash-user@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 <kangaro...@yahoo.com>
To: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: [GNC] transfe money from one account to another
Message-ID: <63467870.1092418.1659908631...@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 baxterkangaro...@yahoo.com
------------------------------
Message: 6
Date: Sun, 7 Aug 2022 15:00:14 -0700
From: Greg Feneis <mfen...@gmail.com>
To: Gnucash Users <gnucash-user@gnucash.org>
Subject: Re: [GNC] Third party OFX/CVS providers
Message-ID:
<CAJdmZ-UU_DL=vu6mlkevvdqzcem-266vg_qaozf2gu2_mgw...@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 <gmccol...@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
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email
>
> ________________________________
> From: gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org> on
> behalf of flywire <flywi...@gmail.com>
> Sent: Saturday, August 6, 2022 9:36 PM
> To: Gnucash Users <gnucash-user@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@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@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: davidcousen...@gmail.com
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Request for two new features in GnuCash
Message-ID: <8ace0b726ef1ca356de0ec1bda0fdf2119eca5a9.ca...@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.ellenber...@gmail.com>
> To: Eric Hammond <e...@jehammond.net>, "gnucash-user@gnucash.org"
> <gnucash-user@gnucash.org>
> Subject: Re: [GNC] Request for two new features in GnuCash
> Message-ID: <1e0d8ed8-6ba0-b5b8-4190-8664b349f...@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 <flywi...@gmail.com>
> To: Gnucash Users <gnucash-user@gnucash.org>
> Subject: [GNC] Request for two new features in GnuCash
> Message-ID:
> <CAOthWL0tL=4ivF+1s=6fu_maq6nqfuu1mak3m-zt_f6p1uu...@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.brow...@gmail.com>
> To: Chris Good <goodchri...@gmail.com>
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID:
> <cafmgiz8tcnprm2vku57ef0axvdzgv8bvu0i-7wyz+mvva7u...@mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchri...@gmail.com> wrote:
> > From: Tom Browder <tom.brow...@gmail.com>
> > Sent: Sunday, 7 August 2022 12:37 AM
> > To: Chris Good <goodchri...@gmail.com>
> > Cc: gnucash-user@gnucash.org
> > Subject: Re: [GNC] Third party OFX/CVS providers
> >
> >
> >
> > 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
> >
> >
> >
> > 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" <f...@mandfb.me.uk>
> To: gnucash-user@gnucash.org
> Subject: Re: [GNC] gnucash-user Digest, Vol 233, Issue 16
> Message-ID: <62ef9a86.28284.2f1a9...@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@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." <sunfis...@yahoo.com>
> To: gnucash-user@gnucash.org, Tom Browder <tom.brow...@gmail.com>,
> Chris Good <goodchri...@gmail.com>
> Subject: Re: [GNC] Third party OFX/CVS providers
> Message-ID: <046aba80-7c9c-4aaa-a29d-953442079...@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.brow...@gmail.com>
> wrote:
> > On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchri...@gmail.com> wrote:
> > > From: Tom Browder <tom.brow...@gmail.com>
> > > Sent: Sunday, 7 August 2022 12:37 AM
> > > To: Chris Good <goodchri...@gmail.com>
> > > Cc: gnucash-user@gnucash.org
> > > Subject: Re: [GNC] Third party OFX/CVS providers
> > >
> > >
> > >
> > > 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
> > >
> > >
> > >
> > > 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@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 <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:
> <
> sj0pr19mb44450340e5332d96385c00058f...@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.brow...@gmail.com> wrote:
>
> > On Sat, Aug 6, 2022 at 21:25 Chris Good <goodchri...@gmail.com> wrote:
> > > From: Tom Browder <tom.brow...@gmail.com>
> > > Sent: Sunday, 7 August 2022 12:37 AM
> > > To: Chris Good <goodchri...@gmail.com>
> > > Cc: gnucash-user@gnucash.org
> > > Subject: Re: [GNC] Third party OFX/CVS providers
> > >
> > >
> > >
> > > 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
> > >
> > >
> > >
> > > 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@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@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@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@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
*********************************************
_______________________________________________
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.
