[GNC] Exporting reports to spreadsheet - Solved

[flywire]

https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html

That's a great question George which has been annoying me for ages so I
flicked it over to the LibreOffice Ask site:
https://ask.libreoffice.org/t/open-html-file-in-calc-from-os/90615

It would make a good tip for our docs.
___
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.

Re: [GNC] Exporting reports to spreadsheet - Solved

[Carsten Hütter]

Very useful hint. Thanks a lot!


Am 18.04.23 um 09:00 schrieb flywire:

https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html

That's a great question George which has been annoying me for ages so I
flicked it over to the LibreOffice Ask site:
https://ask.libreoffice.org/t/open-html-file-in-calc-from-os/90615

It would make a good tip for our docs.
___
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.

Re: [GNC] set up Gnucash on a new device

[Fred Bone]

On 17 April 2023 at 18:38, Adrien Monteleone said:

> Ah, forgot about the 'S' variant. If I'm not mistaken, it is also 
> possible to convert a regular installation to 'S', but you'd have to know
> you did it. It won't be an accident.

Other way round.

You can install Windows in "S" mode (or get a machine with it 
preinstalled), and then revert to normal, but you can't change *to* "S" 
mode. It wouldn't make sense, because "S" mode is supposed to guarantee 
that only "approved" programs are present, and once the machione ahs been 
running in normal mode that guarantee can't apply.


___
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.

[GNC] Transferring data from one set of books to another

[Rich Shepard]

I have two sets of books: business and personal; still running gnucash-3.11
on my Slackware64-14.2 desktop; it does all I need it to do. I updated my
customer list in the personal book rather than the busienss book by mistake.
Is there a way for me to transform those data from person to business
without having to manually re-keyboard all of them?

TIA,

Rich

___
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.

Re: [GNC] Transferring data from one set of books to another

[Gyle McCollam]

Rich,
I don't know if it is possible, but have you checked out whether you can export 
this information?  Then you can import into your business system.  I don't use 
for business, but it seems like you should be able to do this.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com   email


From: gnucash-user  on 
behalf of Rich Shepard 
Sent: Tuesday, April 18, 2023 10:46 AM
To: gnucash-user@gnucash.org 
Subject: [GNC] Transferring data from one set of books to another

I have two sets of books: business and personal; still running gnucash-3.11
on my Slackware64-14.2 desktop; it does all I need it to do. I updated my
customer list in the personal book rather than the busienss book by mistake.
Is there a way for me to transform those data from person to business
without having to manually re-keyboard all of them?

TIA,

Rich

___
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.

Re: [GNC] set up Gnucash on a new device

[Stan Brown]

On 2023-04-17 15:32, Keith N. McKenna wrote:
> Paul Kroitor wrote:
>>  From the web I see that this was a known issue with Windows 10 in the
>> past, apparently caused by the file association for .exe files being
>> corrupted, but I don't see reports anywhere for Windows 11. If this
>> was the case, it would presumably happen with other .exe files as well.
>>
>> Some places suggest resetting all file associations to their defaults,
>> which you could try (but you'd have to recustomize any you had
>> modified). There are some registry fixes (.reg files) floating around
>> to "fix this" but I would take that with a boatload of salt unless you
>> were sure the source was reliable.
> 
> It is possible that the system that the op has is an S mode operating
> system. I had a similar problem with an inexpensive Gateway convertible
> that I picked up to take with me when I am on the road. It will only
> accept programs that are approved by Microsoft. So if it isn't in the
> store you cannot load it on your system.



Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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.

Re: [GNC] Transferring data from one set of books to another

[Rich Shepard]

On Tue, 18 Apr 2023, Gyle McCollam wrote:


I don't know if it is possible, but have you checked out whether you can
export this information? Then you can import into your business system. I
don't use for business, but it seems like you should be able to do this.


Gyle,

Not according to the gnucash-guide.

Rich
___
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.

Re: [GNC] Transferring data from one set of books to another [RESOLVED]

[Rich Shepard]

On Tue, 18 Apr 2023, Rich Shepard wrote:


I have two sets of books: business and personal; still running gnucash-3.11
on my Slackware64-14.2 desktop; it does all I need it to do. I updated my
customer list in the personal book rather than the busienss book by mistake.
Is there a way for me to transform those data from person to business
without having to manually re-keyboard all of them?


All fixed. I opened two instances of gnucash on my 24" monitor, displayed
the personal books Business -> Customers page on both. Selected a row,
opened the edit dialog box, and copied the lines to a New Customer in the
business books.

Can't seem to delete the rows in the personal book so I'll just leave them
there.

Rich
___
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.

[GNC] Missing QFX import option in version 5

[Marilyn Kistler]

I was very disappointed to find QFX is no longer an option for importing
files in Gnucash 5.0.
What is the plan for this file type?

Marilyn Kistler
___
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.

Re: [GNC] Missing QFX import option in version 5

[Murugan Muruganandam]

assuming you are using windows you can download the nightly release where this 
has been resolved

https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe



Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Marilyn Kistler 
Sent: Tuesday, April 18, 2023 12:50 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Missing QFX import option in version 5

I was very disappointed to find QFX is no longer an option for importing
files in Gnucash 5.0.
What is the plan for this file type?

Marilyn Kistler
___
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.

Re: [GNC] Missing QFX import option in version 5

[Carsten Hütter]

And this is the corresponding link to the flatpak package, in case you 
are a Linux user:



https://code.gnucash.org/builds/flatpak/stable/gnucash-stable-C5.0-77-gd9ba9a4c83-D5.0-1-gc4e1f0b4.flatpakref

Greetings

Carsten


Am 18.04.2023 um 18:57 schrieb Murugan Muruganandam:


assuming you are using windows you can download the nightly release where this 
has been resolved

https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe



Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of Marilyn Kistler 
Sent: Tuesday, April 18, 2023 12:50 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Missing QFX import option in version 5

I was very disappointed to find QFX is no longer an option for importing
files in Gnucash 5.0.
What is the plan for this file type?

Marilyn Kistler
___
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.




___
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.

Re: [GNC] Missing QFX import option in version 5

[Marilyn Kistler]

Thank you!

On Tue, Apr 18, 2023 at 12:57 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

>
> assuming you are using windows you can download the nightly release where
> this has been resolved
>
>
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Marilyn Kistler  >
> *Sent:* Tuesday, April 18, 2023 12:50 PM
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] Missing QFX import option in version 5
>
> I was very disappointed to find QFX is no longer an option for importing
> files in Gnucash 5.0.
> What is the plan for this file type?
>
> Marilyn Kistler
> ___
> 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.

[GNC] Crash on CSV transaction import

[jvernice]

I am using the nightly build 5.0.77 on Windows 11.  Ever since upgrading to
5.0 (and above nightly builds) I am unable to import transactions from CSV.
The system crashes when I select the CSV import profile or when I try to
create a new one.  The crash accors immediately after selecting the profile
OR after assigning the AMOUNT column. I have resorted to the latest pre-5.0
build in order to import from CSV.  Unfortunately, my Fidelity checking
account only allows for CSV export, so this is an essential means for me to
import into gnucash. Thank you everyone for all your help.

___
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.

Re: [GNC] [Resolved] gnucash 4.8 does not save settings

[Dale Osborn]

Hello, Geert,

First of all, thank you for your efforts in the creation of 
GnuCash.  Although I am using it only for personal finances I 
can see that there is an enormous volume of code in the 
package relative to businesses.  We users are in debt to developers like you.


Thank you as well for explaining the motivation for adopting 
flatpaks.  I can well understand that it is not practical for 
the GnuCash team to build separate packages for the myriad 
distributions active in the field.


I was going to keep a well-running version 3.8 on my laptop 
while adapting to version 4.8 that came with my updated Mint 
21 on my desktop.  However, version 3.8 warned me that it 
could not handle something created by 4.8 (thanks for the 
warning) so I purged gnucash from both machines and installed 
the 4.13 flatpak on both.  Both are accepting and storing 
configuration settings, so that is no longer a problem.


Sharing the configuration files turned out to be very 
simple.  I symlinked from ~/.var/app/org.gnucash.GnuCash to a 
folder that is mirrored by SyncThing.


I have changed the email address registered with the list to 
one that will not generate the acceptance requests you 
encountered.  This email is from the new address.


I think it is time to close this thread.

Thanks again,
Dale

At 11:00 AM 4/14/2023, Geert Janssens wrote:

Before you go the flatpak route though, it may be worth 
figuring out why your settings are not saved. Are there any 
messages in your trace file ?


A known issue with saving settings is when you have 
applications installed in /usr/local. Or more specifically 
if there are schema files in 
/usr/local/share/glib-2.0/schemas/. In that case gnucash 
fails to find its own schema files in 
/usr/share/glib-2.0/schemas/. This issue was fixed for gnucash 4.13.


Regards,

Geert



Op vrijdag 14 april 2023 15:51:08 CEST schreef Papa Oz:

> Hello, Carsten, and thanks for the reply.

>

> Please forgive the anti-spam thing.  I had put @gnucash.org in my address

> book and I assumed all list-oriented traffic would come through their

> server.  Now that I see how it works I will probably have to change my

> registration to a different address that lacks the filtering.  Meanwhile

> you are "allowed".

>

> All the files are within my home directory tree and I checked the

> permissions already.  There are some symlinks involved.  They work with 3.8

> but I suppose something might have changed in 4.8 such that they are a

> problem.

>

> I did notice that the developers have gone the flatpak 
route.  I am not fond


> of flatpaks, which is why I mentioned deb in my post.  I suspect the

> sandbox aspect of flatpaks will give me some trouble sharing files between

> two systems.  But I guess I will have to add gnucash to my very small

> collection of flatpaks and figure out how to work out the sharing.

>

> Thank you for your recommendation of 4.13.  I will give it a try.

>

> -Original Message-

> From: Carsten Hütter 

> Sent: Apr 14, 2023 7:17 AM

> To: Papa Oz , 

> Subject: Re: [GNC] gnucash 4.8 does not save settings

>

> Hi Papa Oz!

>

> First of all: I'd recommend updating to a more current version both of

> GnuCash (latest 4.x is 4.14 from 2023-03-25) and Finance::Quote (latest is

> 1.54 from 2022-12-26). GnuCash 5.0 still has some issues.

>

> The developers decided to publish the stable GnuCash Linux versions as

> flatpak, not as deb packages. So in order to get the cutting edge version

> without building from source code, you have to install flatpak. I'm on

> Ubuntu 22.04 LTS, only limited experience with other Linux flavors

> (switched from OpenSUSE sometime in the last century or millennium), but

> the following instructions should work more or less: $ sudo apt install

> flatpakThe latest GnuCash 4.x flatpak on code.gnucash.org is 4.13 from

> 2023-03-18, can be downloaded here:

> https://code.gnucash.org/builds/flatpak/maint/gnucash-maint-C4.13-164-g207b

> 105b9c-D4.13-7-g96300db7.flatpakrefCan be installed with: $ cd

> ~/Downloads/GnuCash/  # Change to location of your flatpak file $ flatpak

> install gnucash-maint-C4.13-164-g207b105b9c-D4.13-7-g96300db7.flatpakref  #

> sudo not neededAnd started with: $ flatpak run org.gnucash.GnucashThere you

> go. Each flatpak package includes it's own current Finance::Quote.

>

> To get the gnucash starter icon in your environment, you 
may need to install


> the Linux mint 21 cinnamon flatplak plugin: $ sudo apt install

> flatpak-plugin-cinnamonOn my system there are two flatpak GnuCash versions

> installed, which reside peacefully next door to each other: $ flatpak list

> --app

> Name Application 
ID Version


>  Zweig Ursprung

>Installation GnuCash  org.gnucash.GnuCash

> 4.13-164-g207b105b9c+ maint-C4.13-164-g207b105b9c-D4.13-7-g96300db7

> gnucash1-origin system GnuCash 

Re: [GNC] Transferring data from one set of books to another

[david whiting]

You can import customers as csv file, so you just need to get a way of
exporting customers. One way you can do this is to save your gnucash file
in sqlite format (if you don't use that already) and then open the file in
something like sqlitebrowser https://sqlitebrowser.org/ Here you can view
the customers table ("Browse data" and select the customers table) which
you can then export as a csv file. It won't be in the right format to
import, so you'll need to open it in a spreadsheet program and move some
columns around and delete some columns that aren't needed. You can see the
import format here:
https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html

David

On Tue, 18 Apr 2023 at 16:25, Rich Shepard  wrote:

> On Tue, 18 Apr 2023, Gyle McCollam wrote:
>
> > I don't know if it is possible, but have you checked out whether you can
> > export this information? Then you can import into your business system. I
> > don't use for business, but it seems like you should be able to do this.
>
> Gyle,
>
> Not according to the gnucash-guide.
>
> Rich
> ___
> 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.
>


-- 
David Whiting
___
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.

Re: [GNC] Transferring data from one set of books to another

[david whiting]

Ah, I sent this before I saw your other reply that got separated from this
thread.

David

On Tue, 18 Apr 2023 at 20:17, david whiting  wrote:

> You can import customers as csv file, so you just need to get a way of
> exporting customers. One way you can do this is to save your gnucash file
> in sqlite format (if you don't use that already) and then open the file in
> something like sqlitebrowser https://sqlitebrowser.org/ Here you can view
> the customers table ("Browse data" and select the customers table) which
> you can then export as a csv file. It won't be in the right format to
> import, so you'll need to open it in a spreadsheet program and move some
> columns around and delete some columns that aren't needed. You can see the
> import format here:
> https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html
>
> David
>
> On Tue, 18 Apr 2023 at 16:25, Rich Shepard 
> wrote:
>
>> On Tue, 18 Apr 2023, Gyle McCollam wrote:
>>
>> > I don't know if it is possible, but have you checked out whether you can
>> > export this information? Then you can import into your business system.
>> I
>> > don't use for business, but it seems like you should be able to do this.
>>
>> Gyle,
>>
>> Not according to the gnucash-guide.
>>
>> Rich
>> ___
>> 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.
>>
>
>
> --
> David Whiting
>


-- 
David Whiting
___
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.

[GNC] Please don't double post

[Stan Brown]

Lately there seems to be a rash of double posts.

Maybe people, especially new subscribers, are unaware of how mailing
lists work. There is always a lag between when you hit Send and when the
message appears in your inbox. It may be a few seconds, or it may be a
few minutes. Please give _at_least_ 10 minutes before you assume your
email wasn't sent and send it again.

And, of course, don't re-send just because you didn't get answers right
away. Not everybody checks the list every few minutes, so it may take a
day or more till you get the answer you're looking for. Re-posting
doesn't cut that time down.

There's a lot of traffic on this list, and the double posts just make it
that much harder for recipients to manage. Thanks in advance for your
consideration!

-- 
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
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.

Re: [GNC] Transferring data from one set of books to another

[Rich Shepard]

On Tue, 18 Apr 2023, david whiting wrote:


One way you can do this is to save your gnucash file in sqlite format (if
you don't use that already)...


David,

I've been using SQLite for a very long time so I can easily work with single
tables. Now, I'm using the default database.


It won't be in the right format to import, so you'll
need to open it in a spreadsheet program and move some columns around and
delete some columns that aren't needed. You can see the import format
here:
https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html


Thanks very much.

Regards,

Rich
___
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.

Re: [GNC] Transferring data from one set of books to another

[Rich Shepard]

On Tue, 18 Apr 2023, david whiting wrote:


Ah, I sent this before I saw your other reply that got separated from this
thread.


David,

No harm done. The SQLite info is useful.

Regards,

Rich
___
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.

Re: [GNC] GNC 5.0 Online Quotes Not Working

[Murugan Muruganandam]

Adam

this issue was fixed in the later releases, download and install the following 
release

https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe



Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of Adam 
Griffis 
Sent: Tuesday, April 18, 2023 3:35 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] GNC 5.0 Online Quotes Not Working

Hi All,

GNC 5.0
Finance::Quote 1.54
Windows 11

I sent this earlier today, but it wasn't from the account I was
subscribed with so I'm not sure what happened to it. Sending --
hopefully that's not an issue.

I upgraded from 4.13 to 5.0, and now my online quotes functionality is
not working correctly. When I run it from the price database window,
you can see the cmd prompt open, but then it closes almost
immediately.

After running it, it DOES update one currency item (EUR), but none of
the stocks get updated. In the security editor window, it shows what
source is currently selected, but in the dropdown to change the
source, everything is grayed out and can't be changed.

I've also tried running it from the command line but with no success.

Please see screenshots.

Thanks!
Adam
___
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.

Re: [GNC] GNC 5.0 Online Quotes Not Working

[Fross, Michael]

Thanks for the link Murugan.  I don't believe these are official releases,
so I'm assuming they may not have gone through all of the standard testing
/ reviews normally associated with a release.

I wonder if my fear is unfounded or if my assumption is even true...

Michael

On Tue, Apr 18, 2023 at 2:44 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> Adam
>
> this issue was fixed in the later releases, download and install the
> following release
>
>
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of Adam Griffis  >
> Sent: Tuesday, April 18, 2023 3:35 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] GNC 5.0 Online Quotes Not Working
>
> Hi All,
>
> GNC 5.0
> Finance::Quote 1.54
> Windows 11
>
> I sent this earlier today, but it wasn't from the account I was
> subscribed with so I'm not sure what happened to it. Sending --
> hopefully that's not an issue.
>
> I upgraded from 4.13 to 5.0, and now my online quotes functionality is
> not working correctly. When I run it from the price database window,
> you can see the cmd prompt open, but then it closes almost
> immediately.
>
> After running it, it DOES update one currency item (EUR), but none of
> the stocks get updated. In the security editor window, it shows what
> source is currently selected, but in the dropdown to change the
> source, everything is grayed out and can't be changed.
>
> I've also tried running it from the command line but with no success.
>
> Please see screenshots.
>
> Thanks!
> Adam
> ___
> 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.

Re: [GNC] GNC 5.0 Online Quotes Not Working

[John Ralls]

Murugan,

Please don't call nightly builds "releases", it will confuse newbies.

Regards,
John Ralls

> On Apr 18, 2023, at 12:43 PM, Murugan Muruganandam 
>  wrote:
> 
> Adam
> 
> this issue was fixed in the later releases, download and install the 
> following release
> 
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
> 
> 
> 
> Saludos Cordiales
> 
> 
> Murugan
> 
> 
> From: gnucash-user 
>  on behalf of 
> Adam Griffis 
> Sent: Tuesday, April 18, 2023 3:35 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] GNC 5.0 Online Quotes Not Working
> 
> Hi All,
> 
> GNC 5.0
> Finance::Quote 1.54
> Windows 11
> 
> I sent this earlier today, but it wasn't from the account I was
> subscribed with so I'm not sure what happened to it. Sending --
> hopefully that's not an issue.
> 
> I upgraded from 4.13 to 5.0, and now my online quotes functionality is
> not working correctly. When I run it from the price database window,
> you can see the cmd prompt open, but then it closes almost
> immediately.
> 
> After running it, it DOES update one currency item (EUR), but none of
> the stocks get updated. In the security editor window, it shows what
> source is currently selected, but in the dropdown to change the
> source, everything is grayed out and can't be changed.
> 
> I've also tried running it from the command line but with no success.
> 
> Please see screenshots.
> 
> Thanks!
> Adam
> ___
> 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.

Re: [GNC] GNC 5.0 Online Quotes Not Working

[Murugan Muruganandam]

thanks John

sorry for the confusion.

michael , Adam,  nighly releases are patchsets for testing.  you can use the 
same for testing purposes.








Saludos Cordiales


Murugan


From: John Ralls 
Sent: Tuesday, April 18, 2023 4:32 PM
To: Murugan Muruganandam 
Cc: Adam Griffis ; gnucash-user@gnucash.org 

Subject: Re: [GNC] GNC 5.0 Online Quotes Not Working

Murugan,

Please don't call nightly builds "releases", it will confuse newbies.

Regards,
John Ralls

> On Apr 18, 2023, at 12:43 PM, Murugan Muruganandam 
>  wrote:
>
> Adam
>
> this issue was fixed in the later releases, download and install the 
> following release
>
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user 
>  on behalf of 
> Adam Griffis 
> Sent: Tuesday, April 18, 2023 3:35 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] GNC 5.0 Online Quotes Not Working
>
> Hi All,
>
> GNC 5.0
> Finance::Quote 1.54
> Windows 11
>
> I sent this earlier today, but it wasn't from the account I was
> subscribed with so I'm not sure what happened to it. Sending --
> hopefully that's not an issue.
>
> I upgraded from 4.13 to 5.0, and now my online quotes functionality is
> not working correctly. When I run it from the price database window,
> you can see the cmd prompt open, but then it closes almost
> immediately.
>
> After running it, it DOES update one currency item (EUR), but none of
> the stocks get updated. In the security editor window, it shows what
> source is currently selected, but in the dropdown to change the
> source, everything is grayed out and can't be changed.
>
> I've also tried running it from the command line but with no success.
>
> Please see screenshots.
>
> Thanks!
> Adam
> ___
> 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.

Re: [GNC] GNC 5.0 Online Quotes Not Working

[Adam Griffis]

I also appreciate the link. That version is indeed working correctly for
me, and I am aware it’s not an official release… I believe the next
official release is coming out at the end of the month?

I’ll be sure to upgrade to that when it’s released.

Thanks again,
Adam

On Tue, Apr 18, 2023 at 22:29 Fross, Michael  wrote:

> Thanks for the link Murugan.  I don't believe these are official releases,
> so I'm assuming they may not have gone through all of the standard testing
> / reviews normally associated with a release.
>
> I wonder if my fear is unfounded or if my assumption is even true...
>
> Michael
>
> On Tue, Apr 18, 2023 at 2:44 PM Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
>
>> Adam
>>
>> this issue was fixed in the later releases, download and install the
>> following release
>>
>>
>> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
>>
>>
>>
>> Saludos Cordiales
>>
>>
>> Murugan
>>
>> 
>> From: gnucash-user > hotmail@gnucash.org> on behalf of Adam Griffis <
>> adam.grif...@gmail.com>
>> Sent: Tuesday, April 18, 2023 3:35 PM
>> To: gnucash-user@gnucash.org 
>> Subject: [GNC] GNC 5.0 Online Quotes Not Working
>>
>> Hi All,
>>
>> GNC 5.0
>> Finance::Quote 1.54
>> Windows 11
>>
>> I sent this earlier today, but it wasn't from the account I was
>> subscribed with so I'm not sure what happened to it. Sending --
>> hopefully that's not an issue.
>>
>> I upgraded from 4.13 to 5.0, and now my online quotes functionality is
>> not working correctly. When I run it from the price database window,
>> you can see the cmd prompt open, but then it closes almost
>> immediately.
>>
>> After running it, it DOES update one currency item (EUR), but none of
>> the stocks get updated. In the security editor window, it shows what
>> source is currently selected, but in the dropdown to change the
>> source, everything is grayed out and can't be changed.
>>
>> I've also tried running it from the command line but with no success.
>>
>> Please see screenshots.
>>
>> Thanks!
>> Adam
>>
> ___
>> 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.

Re: [GNC] Missing QFX import option in version 5

[David Carlson]

The easiest option which wasn't mentioned is to revert either back to your
former release or to 4.14 and then wait for the next release in the 5.x
series which will also include fixes for many other issues.

On Tue, Apr 18, 2023 at 1:27 PM Marilyn Kistler  wrote:

> Thank you!
>
> On Tue, Apr 18, 2023 at 12:57 PM Murugan Muruganandam <
> m.muruganan...@hotmail.com> wrote:
>
> >
> > assuming you are using windows you can download the nightly release where
> > this has been resolved
> >
> >
> >
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
> >
> >
> >
> > Saludos Cordiales
> >
> >
> > Murugan
> > --
> > *From:* gnucash-user  > hotmail@gnucash.org> on behalf of Marilyn Kistler <
> mgkist...@gmail.com
> > >
> > *Sent:* Tuesday, April 18, 2023 12:50 PM
> > *To:* gnucash-user@gnucash.org 
> > *Subject:* [GNC] Missing QFX import option in version 5
> >
> > I was very disappointed to find QFX is no longer an option for importing
> > files in Gnucash 5.0.
> > What is the plan for this file type?
> >
> > Marilyn Kistler
> > ___
> > 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.
>


-- 
David Carlson
___
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.

Re: [GNC] Configurable Year Start Day/Month

[flywire]

Your assumptions are wrong. Clearly, communication from the developer(s)
was ineffective. Full advice of the "major change" quoted in
https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106463.html
with no response to the request for guidance.

On Tue, 18 Apr 2023 at 15:20, Vincent Dawans  wrote:

> ... It seems that John Ralls mentions the problems with it in the
> discussion from 2021 you link that and hints that it might be changed in
> version 5. I don't see a change as of 5.0 yet (unless I am missing
> something) so I can only assume...
>
___
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.

Re: [GNC] Configurable Year Start Day/Month

[John Ralls]

Flywire,

Nope, accounting periods didn't get fixed so everything I said in 2021 about 
that is still true. 

> https://github.com/flywire/gnucash/blob/Fiscal-year/libgnucash/app-utils/date-utilities.scm#L557-L569

Messing around in GnuCash's internals is only supported if the result gets 
accepted via a pull request. Otherwise it's a fork and with forks you always 
run the risk that we'll change or remove the underlying code and break your 
changes. That's true no matter what language the code is written in and it's 
true of every FLOSS project I've been involved with, which at this point is 
quite a few.

Regards,
John Ralls

> On Apr 18, 2023, at 4:03 PM, flywire  wrote:
> 
> Your assumptions are wrong. Clearly, communication from the developer(s)
> was ineffective. Full advice of the "major change" quoted in
> https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106463.html
> with no response to the request for guidance.
> 
> On Tue, 18 Apr 2023 at 15:20, Vincent Dawans  wrote:
> 
>> ... It seems that John Ralls mentions the problems with it in the
>> discussion from 2021 you link that and hints that it might be changed in
>> version 5. I don't see a change as of 5.0 yet (unless I am missing
>> something) so I can only assume...
>> 
> ___
> 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.

Re: [GNC] Invoice layout changed upon upgrade from 4.13 to 4.14

[Adrien Monteleone]

The mailing list does accept attachments, but not inline images.

Of course, linking to outside file services is fine too.

As to your question, are you saying:

You have saved report configurations that now don't display properly 
because of this change?


I would think saved configurations should not change in such a 
circumstance, so perhaps this is an additional bug.


*note, in 5.0, you can now set a Saved Configuration as the default for 
all invoices.



Regards,
Adrien

On 4/17/23 6:20 PM, John W. O'Brien via gnucash-user wrote:

Hello GnuCash users,

I routinely print invoices to PDF. To help ensure quality and 
consistency in the output, I have tuned both the "default" style sheet 
and the report layout I use to generate these invoices. On multiple (low 
single digits) macOS machines (Monterey 12.6.5, mix of Intel and Apple 
Silicon), I sync the GnuCash data and config via an ownCloud instance.


A side-effect of installing the upgrade from 4.13 to 4.14 was that the 
report "Options->Layout->Row 1 Left" setting changed from "Company name, 
address and tax ID" [0] to "Empty space" [1]. I suspect this change is a 
consequence of:


     Bug 798717
     Reports > Business > Fancy Invoice duplicates company details

My concern and uncertainty is about whether this bug fix should have 
affected a configuration derived from canned report specifically to 
affix the layout, where the derived configuration is no longer clearly 
tied to the original, canned report. I would not expect that installing 
a minor update would result in a change this substantial. Am I missing 
something, should I be reporting this as a regression against 798717, 
does this seem like a new bug, or something else?


Thank you,
John

PS: I wasn't sure if the mailing list would accept PNG attachments, 
which is why I posted them separately.


[0] https://babble.saltant.net/59e0374b8f46b869/before-4.13-redacted.png
[1] https://babble.saltant.net/59e0374b8f46b869/after-4.14-redacted.png


___
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.

[GNC] Errors viewing saved multicolumn reports after upgrading to GnuCash 5.0

[Chris Grinton]

Gnucash Users,

I am encountering errors when attempting to view saved multicolumn reports
after upgrading to GnuCash 5.0. I'm wondering if anybody else has
experienced similar things, and might have found a resolution/workaround.

The following steps minimally reproduce what I am seeing (although opening
existing saved multi-column reports results in a similar outcome):

   1. Create a new multicolumn report (Reports > Multicolumn > Custom
   Multicolumn Report)
   2. Save the report configuration (no changes to the empty/blank default
   report are required to reproduce the errors)
   3. Close the report, and open it again (from Reports > Saved Report
   Configurations)
   4. The following error is displayed (full screenshot attached below):

   An error occurred while running the report.

  7 (apply-smob/1 #)
   In c-interface.scm:
34:4  6 (gnc:call-with-error-handling _ _)
   In ice-9/boot-9.scm:
   829:9  5 (catch #t # …)
   In c-interface.scm:
   38:40  4 (_)
   In report-core.scm:
  745:25  3 (gnc:report-render-html #< type: "d8ba4a2e89e8…> …)
   In standard/view-column.scm:
66:4  2 (render-view #< type: "d8ba4a2e89e8479ca9f6eccd…>)
   In ice-9/boot-9.scm:
   256:9  1 (for-each _ _)
   In unknown file:
  0 (scm-error wrong-type-arg "for-each" "Not a list: ~S" # #)

   In procedure for-each: Not a list: #f

(FWIW, I am also finding GnuCash 5.0 crashes when clicking the "Save Config
As..." button while viewing a report, and have experienced various other
unexplained crashes when using reports. I'm not sure if that is related to
this specific error - I suspect not.)

[image: image.png]
___
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.

Re: [GNC] Missing QFX import option in version 5

[Joseph St. Denis via gnucash-user]

To all

Thanks you for restoring the QFX function in the Windows version. I was able to 
copy and paste the set up file and installed the update.

All the best

Joseph St Denis

Get Outlook for Android

From: gnucash-user  on 
behalf of Marilyn Kistler 
Sent: Tuesday, April 18, 2023 2:26:25 PM
To: Murugan Muruganandam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Missing QFX import option in version 5

Thank you!

On Tue, Apr 18, 2023 at 12:57 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

>
> assuming you are using windows you can download the nightly release where
> this has been resolved
>
>
> https://code.gnucash.org/builds/win32/stable/gnucash-5.0-2023-04-18-git-5.0-77-gd9ba9a4c83+.setup.exe
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Marilyn Kistler  >
> *Sent:* Tuesday, April 18, 2023 12:50 PM
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] Missing QFX import option in version 5
>
> I was very disappointed to find QFX is no longer an option for importing
> files in Gnucash 5.0.
> What is the plan for this file type?
>
> Marilyn Kistler
> ___
> 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.
___
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.

[GNC] Balance Forecast End Date

[Ryan Turner]

I've wanted this functionality for quite a while, particularly for the
forecast report.

I have attempted to add support for more preset relative dates ("3 months
from today", "1 year from today", "6 months ago", etc.) a few times in the
past, but haven't quite been able to locate where in the code this date
handling is implemented.
If someone with knowledge of the code can point me in the right direction,
I'm definitely willing to develop this feature if there's interest.

Currently, I just go through all my reports and increment the date at the
start of each month. Not ideal, but it gets the job done. /shrug

Thanks,
Ryan Turner

On 2023-04-09 21:32:34, Adrien Monteleone wrote:
> You can select a specific date, but that's about it.
>
> Regards,
> Adrien
>
> On 4/9/23 1:11 PM, Tom Veik wrote:
> > I have a question about the dates used for Balance Forecast.
> >
> > Start Date allows me to use today, that works well for me.  But for End
> > Date, I'd like to use Today + 2 months.  The selections available don't
> > allow that.
> >
> > Are there any options available that would allow me to add an item to
> > that End Date list?  Or any other way to achieve that?
___
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.