[GNC] gnucash-user Digest, Vol 252, Issue 33
Anon20x
Anon20x at proton.me
Sun Mar 17 18:47:15 EDT 2024
Hi,
Will you please unsub me from the mailing list, thankyou!
On Monday, March 18th, 2024 at 2:00 AM, gnucash-user-request at gnucash.org <gnucash-user-request at gnucash.org> wrote:
>
>
> Send gnucash-user mailing list submissions to
> gnucash-user at gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-request at gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-owner at gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
>
>
> Today's Topics:
>
> 1. Re: How to import MT940 and/or online banking missing in 5.5
> (Frank H. Ellenberger)
> 2. UNSUBCRIBE and Lemmy.World
> (lists.gnucash.org.quantum270 at passmail.net)
> 3. Re: UNSUBCRIBE and Lemmy.World (Ken Farley)
> 4. Re: UNSUBCRIBE and Lemmy.World (Michael or Penny Novack)
> 5. Re: 5.5-1 crashing on macOS 14.3 (Mike Alexander)
> 6. Re: UNSUBCRIBE and Lemmy.World (Ken Farley)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 16 Mar 2024 17:00:11 +0100
> From: "Frank H. Ellenberger" frank.h.ellenberger at gmail.com
>
> To: john jralls at ceridwen.us, An Ku prooffes at gmail.com
>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] How to import MT940 and/or online banking missing
> in 5.5
> Message-ID: 2453b79d-5d8f-44f2-b66b-7491ac58ad50 at gmail.com
>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> I suspect, Andr? is aWindows user and needs to upgrade to 5.5-1:
> https://sourceforge.net/projects/gnucash/files/gnucash (stable)/5.5/gnucash-5.5-1.setup.exe
>
> Regards
> Frank
>
> Am 16.03.24 um 08:07 schrieb john:
>
> > MT940 and CAMT.053 imports are done with File>Import>Import Using AQBanking. Note that CAMT.053 is under XML, not CAMT in the import selector.
> >
> > Regards,
> > John Ralls
> >
> > > On Mar 14, 2024, at 13:44, An Ku prooffes at gmail.com wrote:
> > >
> > > Dear all
> > >
> > > Unfortunately, my bank's CSV export is useless as it does not state
> > > recipients or any useful information of transactions apart from the amount
> > > and date/time of execution. They do however provide the option to download
> > > MT940 as well as camt.053 (apart form PDFs). I understand there used to be
> > > an option to import MT940 transactions through an online banking module,
> > > but I cannot find it anywhere in the UI (I'm using windows and am on v5.5).
> > > I found references to an external online banking package but no how to make
> > > it run on a windows machine.
> > >
> > > I'd appreciate any help on:
> > >
> > > - Importing an MT940 file directly
> > > - Importing an camt.053 file directly
> > > - Converting either MT940 or camt.053 files to CSV
> > >
> > > Thank you and kind regards,
> > > Andr?
> > > _______________________________________________
> > > 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: 2
> Date: Sat, 16 Mar 2024 19:35:37 +0000
> From: lists.gnucash.org.quantum270 at passmail.net
> To: gnucash-user at gnucash.org
> Subject: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID:
> 171061775343.8.2420981101855662130.287866314 at passmail.net
>
> Content-Type: text/plain; charset=utf-8
>
> Will you please unsub me from the emails, it's too much! Also I've tried multiple times using the unsub button in the email and it apparently doesn't work.
>
> I thoroughly appreciate your time and commitment to GNU Cash and the community and I recommend a lemmy.world community (an independent kind of reddit) too much gets lost for those who can't simply search the post history.
>
>
>
>
> On Sunday, March 17th, 2024 at 2:00 AM, gnucash-user-request at gnucash.org gnucash-user-request at gnucash.org wrote:
>
> > Send gnucash-user mailing list submissions to
> > gnucash-user at gnucash.org
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > or, via email, send a message with subject or body 'help' to
> > gnucash-user-request at gnucash.org
> >
> > You can reach the person managing the list at
> > gnucash-user-owner at gnucash.org
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of gnucash-user digest..."
> >
> > Today's Topics:
> >
> > 1. How to import MT940 and/or online banking missing in 5.5 (An Ku)
> > 2. Re: Bill total does not match real total (Alan Johnson)
> > 3. Re: How to import MT940 and/or online banking missing in 5.5
> > (john)
> > 4. Re: How to import MT940 and/or online banking missing in 5.5
> > (Gyle McCollam)
> >
> > ----------------------------------------------------------------------
> >
> > Message: 1
> > Date: Thu, 14 Mar 2024 13:44:04 +0100
> > From: An Ku prooffes at gmail.com
> >
> > To: gnucash-user at gnucash.org
> > Subject: [GNC] How to import MT940 and/or online banking missing in
> > 5.5
> > Message-ID:
> > CAFHnGB9XGxZv-6mN5Toak9keiNwUHY=GofocrLk8ioY3V-dhWA at mail.gmail.com
> >
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Dear all
> >
> > Unfortunately, my bank's CSV export is useless as it does not state
> > recipients or any useful information of transactions apart from the amount
> > and date/time of execution. They do however provide the option to download
> > MT940 as well as camt.053 (apart form PDFs). I understand there used to be
> > an option to import MT940 transactions through an online banking module,
> > but I cannot find it anywhere in the UI (I'm using windows and am on v5.5).
> > I found references to an external online banking package but no how to make
> > it run on a windows machine.
> >
> > I'd appreciate any help on:
> >
> > - Importing an MT940 file directly
> > - Importing an camt.053 file directly
> > - Converting either MT940 or camt.053 files to CSV
> >
> > Thank you and kind regards,
> > Andr?
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Fri, 15 Mar 2024 22:33:29 -0400
> > From: Alan Johnson alan at argentwolf.org
> >
> > To: adrien.monteleone at lusfiber.net, gnucash-user at lists.gnucash.org
> > Subject: Re: [GNC] Bill total does not match real total
> > Message-ID:
> > 51bd6de630d64f56859e78705a1de99191b9c3a5.camel at argentwolf.org
> >
> > Content-Type: text/plain; charset="utf-8"
> >
> > I looked at the trial. The core they offer has a number of modules you
> > can use for free/self hosted/open source. ?The accounting packages
> > require a subscription/paid service. ?
> >
> > On Mon, 2024-03-11 at 11:56 -0500, Adrien Monteleone wrote:
> >
> > > I'm not sure if it is still entirely open source, but it started that
> > > way. I think they've added on features that are closed. (some may
> > > simply
> > > be built with Odoo itself) The base package is still available as far
> > > as
> > > I'm aware, and it is pretty powerful, but likely overkill for most
> > > small
> > > businesses. They also don't make it easy to build it and get up and
> > > running, preferring to 'guide' you to their paid support offerings.
> > >
> > > Odoo is more of a tool to build an app, rather than a business app
> > > itself.
> > >
> > > Regards,
> > > Adrien
> > >
> > > On 3/11/24 10:33 AM, Michael or Penny Novack wrote:
> > >
> > > > Well ... if it is really "open software" they would have to make
> > > > the
> > > > source code available for free (technically can charge reasonable
> > > > cost
> > > > for a copy on medium -- the 'rule" was made before we got things by
> > > > download). The "open software" rules do NOT forbid charging for
> > > > providing executables, support, etc. The originally concept was
> > > > that
> > > > nobody could charge excessively for that or somebody else would
> > > > step in
> > > > and provide at a more reasonable price. Yes, I am old enough to
> > > > have
> > > > followed the original "open software" discussions real time.
> > >
> > > _______________________________________________
> > > 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.
> >
> > -------------- next part --------------
> > A non-text attachment was scrubbed...
> > Name: smime.p7s
> > Type: application/pkcs7-signature
> > Size: 5197 bytes
> > Desc: not available
> > URL: http://lists.gnucash.org/pipermail/gnucash-user/attachments/20240315/270097c8/attachment-0001.p7s
> >
> > ------------------------------
> >
> > Message: 3
> > Date: Sat, 16 Mar 2024 08:07:00 +0100
> > From: john jralls at ceridwen.us
> >
> > To: An Ku prooffes at gmail.com
> >
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: [GNC] How to import MT940 and/or online banking missing
> > in 5.5
> > Message-ID: 2459A8EE-391E-4B09-998A-47BD9213F411 at ceridwen.us
> >
> > Content-Type: text/plain; charset=utf-8
> >
> > MT940 and CAMT.053 imports are done with File>Import>Import Using AQBanking. Note that CAMT.053 is under XML, not CAMT in the import selector.
> >
> > Regards,
> > John Ralls
> >
> > > On Mar 14, 2024, at 13:44, An Ku prooffes at gmail.com wrote:
> > >
> > > Dear all
> > >
> > > Unfortunately, my bank's CSV export is useless as it does not state
> > > recipients or any useful information of transactions apart from the amount
> > > and date/time of execution. They do however provide the option to download
> > > MT940 as well as camt.053 (apart form PDFs). I understand there used to be
> > > an option to import MT940 transactions through an online banking module,
> > > but I cannot find it anywhere in the UI (I'm using windows and am on v5.5).
> > > I found references to an external online banking package but no how to make
> > > it run on a windows machine.
> > >
> > > I'd appreciate any help on:
> > >
> > > - Importing an MT940 file directly
> > > - Importing an camt.053 file directly
> > > - Converting either MT940 or camt.053 files to CSV
> > >
> > > Thank you and kind regards,
> > > Andr?
> > > _______________________________________________
> > > 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: Sat, 16 Mar 2024 13:26:05 +0000
> > From: Gyle McCollam gmccollam at live.com
> >
> > To: john jralls at ceridwen.us, An Ku prooffes at gmail.com
> >
> > Cc: "gnucash-user at gnucash.org" gnucash-user at gnucash.org
> >
> > Subject: Re: [GNC] How to import MT940 and/or online banking missing
> > in 5.5
> > Message-ID:
> > CY4PR1001MB21998B83F9848AC2FEDBAB74CA2F2 at CY4PR1001MB2199.namprd10.prod.outlook.com
> >
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Just a reminder that "File>Import>Import Using AQBanking" is not an option on the menu for Windows Build ID: 5.5+(2023-12-16)
> >
> > Thank You,
> >
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > gmccollam at live.commailto:gmccollam at gyleshomes.com email
> >
> > ________________________________
> > From: gnucash-user gnucash-user-bounces+gylemc=gmail.com at gnucash.org on behalf of john jralls at ceridwen.us
> >
> > Sent: Saturday, March 16, 2024 3:07 AM
> > To: An Ku prooffes at gmail.com
> >
> > Cc: gnucash-user at gnucash.org gnucash-user at gnucash.org
> >
> > Subject: Re: [GNC] How to import MT940 and/or online banking missing in 5.5
> >
> > MT940 and CAMT.053 imports are done with File>Import>Import Using AQBanking. Note that CAMT.053 is under XML, not CAMT in the import selector.
> >
> > Regards,
> > John Ralls
> >
> > > On Mar 14, 2024, at 13:44, An Ku prooffes at gmail.com wrote:
> > >
> > > Dear all
> > >
> > > Unfortunately, my bank's CSV export is useless as it does not state
> > > recipients or any useful information of transactions apart from the amount
> > > and date/time of execution. They do however provide the option to download
> > > MT940 as well as camt.053 (apart form PDFs). I understand there used to be
> > > an option to import MT940 transactions through an online banking module,
> > > but I cannot find it anywhere in the UI (I'm using windows and am on v5.5).
> > > I found references to an external online banking package but no how to make
> > > it run on a windows machine.
> > >
> > > I'd appreciate any help on:
> > >
> > > - Importing an MT940 file directly
> > > - Importing an camt.053 file directly
> > > - Converting either MT940 or camt.053 files to CSV
> > >
> > > Thank you and kind regards,
> > > Andr?
> > > _______________________________________________
> > > 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.
> >
> > ------------------------------
> >
> > 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 252, Issue 32
> > *********************************************
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 16 Mar 2024 17:40:04 -0400
> From: Ken Farley farleykj at gmail.com
>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID: 8347e821-c582-42a8-9f43-c23a588569a9 at gmail.com
>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Unsubscribing isn't done by the list, it's just posts of questions like
> yours.
>
> To unsubscribe, you need to go to:
>
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
> To be honest, I don't allow the deluge of emails to come to me, either.
> Too many to have to sift through every day.
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 16 Mar 2024 19:40:50 -0400
> From: Michael or Penny Novack stepbystepfarm at comcast.net
>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID: dd3c457d-11b0-4014-bed2-b1c71cd68c83 at comcast.net
>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 3/16/2024 5:40 PM, Ken Farley wrote:
>
> > Unsubscribing isn't done by the list, it's just posts of questions
> > like yours.
> >
> > To unsubscribe, you need to go to:
> >
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >
> > To be honest, I don't allow the deluge of emails to come to me,
> > either. Too many to have to sift through every day.
>
>
> << not about gnucash -- but about this specific issue >>
>
>
> If you are an EMAIL user (not WEBMAIL) then your email client (Outlook,
> Thunderbird, etc.) almost certainly provides a facility for you to
> create "message filter rules". You can then add a rule so that emails
> coming from a particular source (say this email list) get moved to a
> dedicated folder instead of appearing in your inbox). The only emails
> that show up in the inbox here are ones for which I haven't written a rule.
>
> Then you either sift through them in this other folder or not depending
> on whether you have time. Nor do they have to take up space in that
> folder forever as you can specify retention policy for that folder.
>
> Webmail users --- I have no idea if whatever provider you are using
> offers similar facilities.
>
> Michael D Novack
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 16 Mar 2024 20:17:57 -0400
> From: Mike Alexander mta at umich.edu
>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] 5.5-1 crashing on macOS 14.3
> Message-ID: CCD31BED-BA4A-4BA8-9C58-0C6F8899052C at umich.edu
>
> Content-Type: text/plain; charset=UTF-8; format=flowed;
> markup=markdown
>
> Sorry for the late reply, I didn't see this because of the subject
> change.
>
> The bug in F9nance::Quote has been fixed. I don't know if the fix is in
> a version that has been released, but if not it will be in the next one.
>
> Mike
>
> On 9 Mar 2024, at 10:06, john wrote:
>
> > Good that you've gotten it working. Maybe open an issue at
> > https://github.com/finance-quote/finance-quote/issues about
> > YahooWeb.pm not setting the right error code when it fails to get a
> > quote.
> >
> > And please, in the future, start a new thread or at least change the
> > subject when you digress like that. This one was supposed to be about
> > a hard crash of GnuCash itself.
> >
> > Regards,
> > John Ralls
> >
> > > On Mar 8, 2024, at 23:30, Tom Teixeira tjteixeira at earthlink.net
> > > wrote:
> > >
> > > I did end up making time to investigate today, and the problem ended
> > > up being just one fund that no longer works with YahooWeb. This
> > > particular fund is a "stable value" fund so checking the value is
> > > somewhat superfluous. As it turns out, it does with with
> > > AlphaVantage.
> > >
> > > Again, thanks to David Reiser for the information to explicitly
> > > specify x86_64 architecture when running on Apple silicon.
> > >
> > > On 3/8/24 3:25 PM, Tom Teixeira wrote:
> > >
> > > > Thanks for the suggestion. I won't have time today to investigate,
> > > > but will do some targeted debugging, either by removing stocks from
> > > > my list to update, or by creating a new Gnucash file with only one
> > > > stock.
> > > >
> > > > On 3/8/24 2:51 PM, David Reiser wrote:
> > > >
> > > > > We are now into my mental weeds as far as real knowledge goes, but
> > > > > I have had some success at thrashing around to fix self-induced
> > > > > perl challenges.
> > > > >
> > > > > Since the error happens on both architectures, that suggests
> > > > > something is missing. I think YahooWeb is relatively recent in the
> > > > > F::Q realm. And F::Q hasn?t managed dependency declarations as
> > > > > well as I?d like.
> > > > >
> > > > > The error complains about a ?row method?. YahooWeb uses
> > > > > HTML::TableExtract which might be the source of the row
> > > > > information. Try installing the appropriate arch version of
> > > > > HTML::TableExtract on each machine and see if that works.
> > > > > --
> > > > > Dave Reiser
> > > > > dbreiser at icloud.com
> > > > >
> > > > > > On Mar 8, 2024, at 1:03?PM, Tom Teixeira
> > > > > > tjteixeira at earthlink.net wrote:
> > > > > >
> > > > > > I spoke too soon: while getting an individual quote with
> > > > > > gnucash-cli works:
> > > > > >
> > > > > > /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli --quotes
> > > > > > dump yahooweb MSFT
> > > > > >
> > > > > > Application Path
> > > > > > /Applications/Gnucash-5.5.app/Contents/MacOS/gnucash-cli
> > > > > > Finance::Quote fields GnuCash uses:
> > > > > > symbol: MSFT <=== required
> > > > > > date: 03/08/2024 <=== recommended
> > > > > > currency: USD <=== required
> > > > > > last: 407.16 <=\
> > > > > > nav: <=== one of these
> > > > > > price: <=/
> > > > > >
> > > > > > trying to "Get Quotes" in my "Price Database" does not. I get a
> > > > > > dialog box with
> > > > > >
> > > > > > Price retrieval failed: Unrecognized Finance::Quote Error: Can't
> > > > > > call method "rows" on an undefined value at
> > > > > > /Library/Perl/5.34/Finance/Quote/YahooWeb.pm line 101.
> > > > > >
> > > > > > I have another, Intel-based Mac. After upgrading this to Sonoma
> > > > > > 14.4 release version, and re-installing Finance::Quote, it gets
> > > > > > the same error.
> > > >
> > > > _______________________________________________
> > > > 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.
> >
> > _______________________________________________
> > 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: 6
> Date: Sat, 16 Mar 2024 22:48:27 -0400
> From: Ken Farley farleykj at gmail.com
>
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] UNSUBCRIBE and Lemmy.World
> Message-ID: f5a56aba-ebca-458b-b357-d2a89b69d2bf at gmail.com
>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> Nah. Filters that store all that stuff are for things I need to look at.
> I find it much more efficient to go to:
>
> https://lists.gnucash.org/pipermail/gnucash-user
>
> and browse through the messages to see the very small percentage of them
> I'm interested in. That way I don't have to delete a pile of unwanted
> stuff, on my computer and also on my e-mail provider's site.
>
>
> ------------------------------
>
> 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 252, Issue 33
> *********************************************
More information about the gnucash-user
mailing list