Re: [GNC] Unable to add prices to some securities

[Alan Taylor]

It is the latest MacOS.
Apologies, I should have said MySQL Lite ... this is included with GnuCash I 
thought ?
It was an option previously ...

BRgds/Alan
On Mar 20, 2019, 13:18 +0800, Adrien Monteleone 
, wrote:
> What OS are you on?
>
> I think on Windows you have to install SQLite or MySQL separately. MacOS 
> comes with SQLite and I think (don’t remember) most Linux distributions do as 
> well. MySQL has to be installed separately for both MacOS and some Linux 
> distributions, a few come with it already and some substitute MariaDB. (older 
> versions of OS X, 10.6 at least, used to come with MySQL, but they moved that 
> to a separate installation some years ago.)
>
> The are no other options in the drop down because those database drivers are 
> not installed on the machine.
>
> Regards,
> Adrien
>
> > On Mar 19, 2019, at 11:58 PM, Alan Taylor  
> > wrote:
> >
> > More things not working properly …
> > In the Save As dialogue there is no way to select sql - click on the 
> > displayed xml does not reveal any other possibilities
> > Also the price editor dialogue does not allow selection of a namespace. 
> > There should be several, but it displays “All non-currency” with no other 
> > selections possible.
> >
> > Tried a reinstallation (3.4), no change.
> >
> > BRgds/Alan
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to add prices to some securities

[Adrien Monteleone]

What OS are you on?

I think on Windows you have to install SQLite or MySQL separately. MacOS comes 
with SQLite and I think (don’t remember) most Linux distributions do as well. 
MySQL has to be installed separately for both MacOS and some Linux 
distributions, a few come with it already and some substitute MariaDB. (older 
versions of OS X, 10.6 at least, used to come with MySQL, but they moved that 
to a separate installation some years ago.)

The are no other options in the drop down because those database drivers are 
not installed on the machine.

Regards,
Adrien

> On Mar 19, 2019, at 11:58 PM, Alan Taylor  wrote:
> 
> More things not working properly …
> In the Save As dialogue there is no way to select sql - click on the 
> displayed xml does not reveal any other possibilities
> Also the price editor dialogue does not allow selection of a namespace. There 
> should be several, but it displays “All non-currency” with no other 
> selections possible.
> 
> Tried a reinstallation (3.4), no change.
> 
> BRgds/Alan


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to add prices to some securities

[Alan Taylor]

Thanks Bucky but no joy, both with Yahoo and Apply.
After testing I do have a clue.
For the securities that are problematic, doing a manual ADD using the Price 
Database window appears to be normal (using apply and ok) but at conclusion 
nothing has been saved if looking for prices under the security in the left 
hand window. For these securities, there are NO prices at all, just the 
security name. However, the entered price IS used to update the default 
Portfolio report, so it is going somewhere ?
Does not seem to be specific to any particular exchange.

BRgds/Alan
On 19 Mar 2019, 23:05 +0800, Bucky Carr , wrote:
>
> Forgot to mention. For the Online Price update, I switched from
> Alphavantage to Yahoo_JSON and it seems to be working fine.
>
>
> On 3/19/2019 8:47 AM, Alan Taylor wrote:
> > And of course the Online Price update does not work, I have updated Perl 
> > etc. as per the WIKI.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to add prices to some securities

[Alan Taylor]

More things not working properly …
In the Save As dialogue there is no way to select sql - click on the displayed 
xml does not reveal any other possibilities
Also the price editor dialogue does not allow selection of a namespace. There 
should be several, but it displays “All non-currency” with no other selections 
possible.

Tried a reinstallation (3.4), no change.

BRgds/Alan


BRgds/Alan
On 19 Mar 2019, 23:05 +0800, Bucky Carr , wrote:
>
> Forgot to mention. For the Online Price update, I switched from
> Alphavantage to Yahoo_JSON and it seems to be working fine.
>
>
> On 3/19/2019 8:47 AM, Alan Taylor wrote:
> > And of course the Online Price update does not work, I have updated Perl 
> > etc. as per the WIKI.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[John Ralls]

> On Mar 19, 2019, at 9:05 PM, suk wah Bernstein  
> wrote:
> 
> tried moving icon from within Finder window to Dock. didn't work.

Does that mean that you weren't able to get it to stay in the Dock?

> 
> moved Gnucash icon onto desktop.
> clicked icon. still cannot open after 'verification'

Is it verifying every time you try to open it? That should happen only the 
first time you try to open it after copying it to Applications.

> 
> opened Applications/Utilities/Terminal. 
> typed in /Applications/Gnucash.app/Contents/MacOS/Gnucash
> 
> now what do i do? 

Press Return

> 
> 'copy any output after that and paste it into a reply.' what does this mean?

It means that you drag your mouse over the output with the button held down so 
that the text is highlighted. Let go of the mouse and hold down the command-key 
while pressing C. Open a reply email, click in it, then hold down the 
command-key while pressing V. The text from Terminal that you highlighted will 
be copied into the email.

Regards,
John Ralls

> 
> On Tue, Mar 19, 2019 at 8:52 PM John Ralls  
> wrote:
> Some users have found that dragging the GnuCash icon from Applications to to 
> the Dock allows GnuCash to start.
> 
> If that still fails, try opening /Applications/Utilities/Terminal. It will 
> open a window with a command prompt. At that prompt type
>   /Applications/Gnucash.app/Contents/MacOS/Gnucash
> 
> copy any output after that and paste it into a reply.
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 19, 2019, at 8:36 PM, suk wah Bernstein  
> > wrote:
> > 
> > thanks for reminder about copying the list.
> > 
> >  after "verifying gnucash" a window pops up, asking if i want to open this 
> > thing from internet, i click 'yes', then gnucash icon in dock disappears. 
> > 
> > i tried again. still doesn't work.
> > 
> > thanks,
> > love and respect
> > suk wah
> > 
> > On Tue, Mar 19, 2019 at 8:16 PM John Ralls  
> > wrote:
> > Please remember to copy the list on all replies. Reply all (the double 
> > arrow icon) works well.
> > 
> > A dmg is a MacOS disk image file. That's the kind of file that we use to 
> > distribute the GnuCash packages from Sourceforge and Github. After 
> > downloading  most browsers will open it on their own, but if your's doesn't 
> > you can find it in your downloads folder and double-click it. It will open 
> > as a Finder window showing a bunch of files including Gnucash.
> > 
> > You unmount by control-clicking with the mouse inside that Finder window 
> > and selecting "unmount Gnucash-Intel-3.4.dmg" from the resulting context 
> > menu.
> > 
> > Regards,
> > John Ralls
> > 
> > 
> > > On Mar 19, 2019, at 7:57 PM, suk wah Bernstein 
> > >  wrote:
> > > 
> > > namaskar john,
> > > 
> > > sorry i don't know what dmg is. 
> > > 
> > > wild guess. does it mean to download GnuCash 3.4 Mac OS X Intel?
> > > 
> > > thanks so much,
> > > love and respect
> > > suk wah
> > > 
> > > On Tue, Mar 19, 2019 at 7:44 PM John Ralls 
> > >  wrote:
> > > 
> > > 
> > > > On Mar 19, 2019, at 5:19 PM, suk wah Bernstein 
> > > >  wrote:
> > > > 
> > > > MacBook Pro
> > > > Intel core i5
> > > > 
> > > > please instruct. thanks so much.
> > > 
> > > The process is to download the dmg, open it, and drag GnuCash somewhere; 
> > > the Applications folder is popular. After the copy completes eject the 
> > > dmg then double click the icon in the Applications folder. You should 
> > > first get a dialog box from GateKeeper telling you that GnuCash is 
> > > something that you downloaded from the internet, are you sure you want to 
> > > run it? Tell that yes, then you'll get another dialog with a progress bar 
> > > called something like "Verifying GnuCash". When that finishes GnuCash 
> > > should start, but doesn't always. If it doesn't, double click on the icon 
> > > again and it should start up.
> > > 
> > > If that's what you did and it didn't work, please detail what happened 
> > > that's different.
> > > 
> > > Regards,
> > > John Ralls
> > > 
> > 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[Chris Tsuji]

   HI,
   I am using Mac os 10.14.3
   After I unstuffed GNUCash, I moved the entire folder, gnucash 3.3 into
   my application folder and then restared my computer.
   After the restart, i went to the application folder and opened the
   gnucash folder and double clicked on the gnucash icon.
   It opened okay and I had no problems.

   I have not tried gnucash 3.4 yet.
   Hope that helps.

   Chris tsuji
   San Jose

   Sent: Tuesday, March 19, 2019 at 9:05 PM
   From: "suk wah Bernstein" 
   To: "John Ralls" 
   Cc: "gnucash-user mailing list" 
   Subject: Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH
   tried moving icon from within Finder window to Dock. didn't work.
   moved Gnucash icon onto desktop.
   clicked icon. still cannot open after 'verification'
   opened Applications/Utilities/Terminal.
   typed in /Applications/Gnucash.app/Contents/MacOS/Gnucash
   now what do i do?
   'copy any output after that and paste it into a reply.' what does this
   mean?
   On Tue, Mar 19, 2019 at 8:52 PM John Ralls
   
   wrote:
   > Some users have found that dragging the GnuCash icon from
   Applications to
   > to the Dock allows GnuCash to start.
   >
   > If that still fails, try opening /Applications/Utilities/Terminal. It
   will
   > open a window with a command prompt. At that prompt type
   > /Applications/Gnucash.app/Contents/MacOS/Gnucash
   >
   > copy any output after that and paste it into a reply.
   >
   > Regards,
   > John Ralls
   >
   >
   > > On Mar 19, 2019, at 8:36 PM, suk wah Bernstein <
   > sukwahbernst...@gmail.com> wrote:
   > >
   > > thanks for reminder about copying the list.
   > >
   > > after "verifying gnucash" a window pops up, asking if i want to
   open
   > this thing from internet, i click 'yes', then gnucash icon in dock
   > disappears.
   > >
   > > i tried again. still doesn't work.
   > >
   > > thanks,
   > > love and respect
   > > suk wah
   > >
   > > On Tue, Mar 19, 2019 at 8:16 PM John Ralls <
   > jra...@ceridwen.fremont.ca.us> wrote:
   > > Please remember to copy the list on all replies. Reply all (the
   double
   > arrow icon) works well.
   > >
   > > A dmg is a MacOS disk image file. That's the kind of file that we
   use to
   > distribute the GnuCash packages from Sourceforge and Github. After
   > downloading most browsers will open it on their own, but if your's
   doesn't
   > you can find it in your downloads folder and double-click it. It will
   open
   > as a Finder window showing a bunch of files including Gnucash.
   > >
   > > You unmount by control-clicking with the mouse inside that Finder
   window
   > and selecting "unmount Gnucash-Intel-3.4.dmg" from the resulting
   context
   > menu.
   > >
   > > Regards,
   > > John Ralls
   > >
   > >
   > > > On Mar 19, 2019, at 7:57 PM, suk wah Bernstein <
   > sukwahbernst...@gmail.com> wrote:
   > > >
   > > > namaskar john,
   > > >
   > > > sorry i don't know what dmg is.
   > > >
   > > > wild guess. does it mean to download GnuCash 3.4 Mac OS X Intel?
   > > >
   > > > thanks so much,
   > > > love and respect
   > > > suk wah
   > > >
   > > > On Tue, Mar 19, 2019 at 7:44 PM John Ralls <
   > jra...@ceridwen.fremont.ca.us> wrote:
   > > >
   > > >
   > > > > On Mar 19, 2019, at 5:19 PM, suk wah Bernstein <
   > sukwahbernst...@gmail.com> wrote:
   > > > >
   > > > > MacBook Pro
   > > > > Intel core i5
   > > > >
   > > > > please instruct. thanks so much.
   > > >
   > > > The process is to download the dmg, open it, and drag GnuCash
   > somewhere; the Applications folder is popular. After the copy
   completes
   > eject the dmg then double click the icon in the Applications folder.
   You
   > should first get a dialog box from GateKeeper telling you that
   GnuCash is
   > something that you downloaded from the internet, are you sure you
   want to
   > run it? Tell that yes, then you'll get another dialog with a progress
   bar
   > called something like "Verifying GnuCash". When that finishes GnuCash
   > should start, but doesn't always. If it doesn't, double click on the
   icon
   > again and it should start up.
   > > >
   > > > If that's what you did and it didn't work, please detail what
   happened
   > that's different.
   > > >
   > > > Regards,
   > > > John Ralls
   > > >
   > >
   >
   >
   ___
   gnucash-user mailing list
   gnucash-user@gnucash.org
   To update your subscription preferences or to unsubscribe:
   [1]https://lists.gnucash.org/mailman/listinfo/gnucash-user
   If you are using Nabble or Gmane, please see
   [2]https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
   -
   Please remember to CC this list on all your replies.
   You can do this by using Reply-To-List or Reply-All.

References

   1. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   2. https://wiki.gnucash.org/wiki/Mailing_Lists
___
gnucash-user mailing list

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[suk wah Bernstein]

tried moving icon from within Finder window to Dock. didn't work.

moved Gnucash icon onto desktop.
clicked icon. still cannot open after 'verification'

opened Applications/Utilities/Terminal.
typed in /Applications/Gnucash.app/Contents/MacOS/Gnucash

now what do i do?

'copy any output after that and paste it into a reply.' what does this mean?

On Tue, Mar 19, 2019 at 8:52 PM John Ralls 
wrote:

> Some users have found that dragging the GnuCash icon from Applications to
> to the Dock allows GnuCash to start.
>
> If that still fails, try opening /Applications/Utilities/Terminal. It will
> open a window with a command prompt. At that prompt type
>   /Applications/Gnucash.app/Contents/MacOS/Gnucash
>
> copy any output after that and paste it into a reply.
>
> Regards,
> John Ralls
>
>
> > On Mar 19, 2019, at 8:36 PM, suk wah Bernstein <
> sukwahbernst...@gmail.com> wrote:
> >
> > thanks for reminder about copying the list.
> >
> >  after "verifying gnucash" a window pops up, asking if i want to open
> this thing from internet, i click 'yes', then gnucash icon in dock
> disappears.
> >
> > i tried again. still doesn't work.
> >
> > thanks,
> > love and respect
> > suk wah
> >
> > On Tue, Mar 19, 2019 at 8:16 PM John Ralls <
> jra...@ceridwen.fremont.ca.us> wrote:
> > Please remember to copy the list on all replies. Reply all (the double
> arrow icon) works well.
> >
> > A dmg is a MacOS disk image file. That's the kind of file that we use to
> distribute the GnuCash packages from Sourceforge and Github. After
> downloading  most browsers will open it on their own, but if your's doesn't
> you can find it in your downloads folder and double-click it. It will open
> as a Finder window showing a bunch of files including Gnucash.
> >
> > You unmount by control-clicking with the mouse inside that Finder window
> and selecting "unmount Gnucash-Intel-3.4.dmg" from the resulting context
> menu.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 19, 2019, at 7:57 PM, suk wah Bernstein <
> sukwahbernst...@gmail.com> wrote:
> > >
> > > namaskar john,
> > >
> > > sorry i don't know what dmg is.
> > >
> > > wild guess. does it mean to download GnuCash 3.4 Mac OS X Intel?
> > >
> > > thanks so much,
> > > love and respect
> > > suk wah
> > >
> > > On Tue, Mar 19, 2019 at 7:44 PM John Ralls <
> jra...@ceridwen.fremont.ca.us> wrote:
> > >
> > >
> > > > On Mar 19, 2019, at 5:19 PM, suk wah Bernstein <
> sukwahbernst...@gmail.com> wrote:
> > > >
> > > > MacBook Pro
> > > > Intel core i5
> > > >
> > > > please instruct. thanks so much.
> > >
> > > The process is to download the dmg, open it, and drag GnuCash
> somewhere; the Applications folder is popular. After the copy completes
> eject the dmg then double click the icon in the Applications folder. You
> should first get a dialog box from GateKeeper telling you that GnuCash is
> something that you downloaded from the internet, are you sure you want to
> run it? Tell that yes, then you'll get another dialog with a progress bar
> called something like "Verifying GnuCash". When that finishes GnuCash
> should start, but doesn't always. If it doesn't, double click on the icon
> again and it should start up.
> > >
> > > If that's what you did and it didn't work, please detail what happened
> that's different.
> > >
> > > Regards,
> > > John Ralls
> > >
> >
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[John Ralls]

Some users have found that dragging the GnuCash icon from Applications to to 
the Dock allows GnuCash to start.

If that still fails, try opening /Applications/Utilities/Terminal. It will open 
a window with a command prompt. At that prompt type
  /Applications/Gnucash.app/Contents/MacOS/Gnucash

copy any output after that and paste it into a reply.

Regards,
John Ralls


> On Mar 19, 2019, at 8:36 PM, suk wah Bernstein  
> wrote:
> 
> thanks for reminder about copying the list.
> 
>  after "verifying gnucash" a window pops up, asking if i want to open this 
> thing from internet, i click 'yes', then gnucash icon in dock disappears. 
> 
> i tried again. still doesn't work.
> 
> thanks,
> love and respect
> suk wah
> 
> On Tue, Mar 19, 2019 at 8:16 PM John Ralls  
> wrote:
> Please remember to copy the list on all replies. Reply all (the double arrow 
> icon) works well.
> 
> A dmg is a MacOS disk image file. That's the kind of file that we use to 
> distribute the GnuCash packages from Sourceforge and Github. After 
> downloading  most browsers will open it on their own, but if your's doesn't 
> you can find it in your downloads folder and double-click it. It will open as 
> a Finder window showing a bunch of files including Gnucash.
> 
> You unmount by control-clicking with the mouse inside that Finder window and 
> selecting "unmount Gnucash-Intel-3.4.dmg" from the resulting context menu.
> 
> Regards,
> John Ralls
> 
> 
> > On Mar 19, 2019, at 7:57 PM, suk wah Bernstein  
> > wrote:
> > 
> > namaskar john,
> > 
> > sorry i don't know what dmg is. 
> > 
> > wild guess. does it mean to download GnuCash 3.4 Mac OS X Intel?
> > 
> > thanks so much,
> > love and respect
> > suk wah
> > 
> > On Tue, Mar 19, 2019 at 7:44 PM John Ralls  
> > wrote:
> > 
> > 
> > > On Mar 19, 2019, at 5:19 PM, suk wah Bernstein 
> > >  wrote:
> > > 
> > > MacBook Pro
> > > Intel core i5
> > > 
> > > please instruct. thanks so much.
> > 
> > The process is to download the dmg, open it, and drag GnuCash somewhere; 
> > the Applications folder is popular. After the copy completes eject the dmg 
> > then double click the icon in the Applications folder. You should first get 
> > a dialog box from GateKeeper telling you that GnuCash is something that you 
> > downloaded from the internet, are you sure you want to run it? Tell that 
> > yes, then you'll get another dialog with a progress bar called something 
> > like "Verifying GnuCash". When that finishes GnuCash should start, but 
> > doesn't always. If it doesn't, double click on the icon again and it should 
> > start up.
> > 
> > If that's what you did and it didn't work, please detail what happened 
> > that's different.
> > 
> > Regards,
> > John Ralls
> > 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[suk wah Bernstein]

thanks for reminder about copying the list.

 after "verifying gnucash" a window pops up, asking if i want to open this
thing from internet, i click 'yes', then gnucash icon in dock disappears.

i tried again. still doesn't work.

thanks,
love and respect
suk wah

On Tue, Mar 19, 2019 at 8:16 PM John Ralls 
wrote:

> Please remember to copy the list on all replies. Reply all (the double
> arrow icon) works well.
>
> A dmg is a MacOS disk image file. That's the kind of file that we use to
> distribute the GnuCash packages from Sourceforge and Github. After
> downloading  most browsers will open it on their own, but if your's doesn't
> you can find it in your downloads folder and double-click it. It will open
> as a Finder window showing a bunch of files including Gnucash.
>
> You unmount by control-clicking with the mouse inside that Finder window
> and selecting "unmount Gnucash-Intel-3.4.dmg" from the resulting context
> menu.
>
> Regards,
> John Ralls
>
>
> > On Mar 19, 2019, at 7:57 PM, suk wah Bernstein <
> sukwahbernst...@gmail.com> wrote:
> >
> > namaskar john,
> >
> > sorry i don't know what dmg is.
> >
> > wild guess. does it mean to download GnuCash 3.4 Mac OS X Intel?
> >
> > thanks so much,
> > love and respect
> > suk wah
> >
> > On Tue, Mar 19, 2019 at 7:44 PM John Ralls <
> jra...@ceridwen.fremont.ca.us> wrote:
> >
> >
> > > On Mar 19, 2019, at 5:19 PM, suk wah Bernstein <
> sukwahbernst...@gmail.com> wrote:
> > >
> > > MacBook Pro
> > > Intel core i5
> > >
> > > please instruct. thanks so much.
> >
> > The process is to download the dmg, open it, and drag GnuCash somewhere;
> the Applications folder is popular. After the copy completes eject the dmg
> then double click the icon in the Applications folder. You should first get
> a dialog box from GateKeeper telling you that GnuCash is something that you
> downloaded from the internet, are you sure you want to run it? Tell that
> yes, then you'll get another dialog with a progress bar called something
> like "Verifying GnuCash". When that finishes GnuCash should start, but
> doesn't always. If it doesn't, double click on the icon again and it should
> start up.
> >
> > If that's what you did and it didn't work, please detail what happened
> that's different.
> >
> > Regards,
> > John Ralls
> >
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Still can't update price quotes

[Elias K Gardner]

I think I tracked it down. First gnc-fq-dump alphavantage APPL returns
"This stock quote cannot be used by GnuCash!". Next I tried gnc-fq-dump
yahoo-json APPL and go the same error, however if I use yahoo_json with a
stock in my gnucash price database it correctly gives me the price. I have
a number of stocks so on David's advice I switch all of my stocks to
yahoo-json, tried to get quotes and got the same "There was an unknown
error while retrieving the price quotes". I then looked at each security
closer and found one that seemed odd and disabled it. I no longer get the
unknown error and my prices are up to date.

Thank you all

On Fri, Mar 8, 2019 at 1:18 PM D  wrote:

> How many quotes are you attempting to retrieve? If it's more than five,
> you're likely to run into Alphavantage's throttling. That is a major reason
> why many users switched onward to Yahoo-json.
>
> David
>
> On March 8, 2019, at 11:25 PM, rmcas...@gmail.com wrote:
>
> Hi,
>
> I'm having the same problem. All source works with 'gnc-fq-dump', but
> gnucash still giving error message "Unable to retrieve quotes for these
> items:".
>
> The last time I update the price quotes was 01st March, after that my
> linux system update perl5 packages and I couldn't update any price
> quotes anymore. I don't know with have some relation, but it was only
> thing I saw different.
>
> I hope it's helps to find out the problem.
>
> Rafael Casali
>
>
> On Fri, 2019-03-08 at 07:57 -0800, John Ralls wrote:
> > Unfortunately there are no logs.
> >
> > Have you triple-checked that you have the Alphavantage API key set
> > correctly?
> >
> > To troubleshoot further first check that quote retrieval works at
> > all: Try
> >   gnc-fq-dump alphavantage AAPL
> > from the command line. You'll probably need to specify a full path to
> > gnc-fq-dump, and you'll need to set ALPHAVANTAGE_API_KEY in the
> > environment. If that works try one of your own stocks (unless you
> > hold Apple in which case you already have). If that works then
> > disable quote retrieval on all but that stock inside of GnuCash and
> > try to get prices. If that works then there's some security that's
> > causing F::Q to blow up and you need to figure out which one.
> >
> > The best way to do that is called "binary search": You disable half
> > of the active ones and try. If that fails, disable half of the rest
> > and try again. Keep doing that until it succeeds. At that
> > point  reenable the most recent set that you disabled and disable the
> > others. Keep doing that until you've found one security that fails.
> > Re-enable all of the rest and try. If it fails then you need to
> > repeat the process, perhaps several times, to find all of the
> > securities that fail.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Mar 7, 2019, at 9:15 PM, Elias K Gardner 
> > > wrote:
> > >
> > > Thanks John I just double checked all of my securities. They all
> > > either have online quotes disabled or are set to alphavantage, no
> > > Yahoo left. Is there a log or something to get more details about
> > > the error?
> > >
> > > On Thu, Mar 7, 2019 at 10:59 AM John Ralls <
> > > jra...@ceridwen.fremont.ca.us> wrote:
> > > Make sure that you have no securities using any yahoo source except
> > > yahoo_json (which BTW still works well and unlike alphavantage
> > > doesn't throttle). Any attempt to use the other yahoo sources will
> > > cause the entire retrieval to fail.
> > >
> > > Regards,
> > > John Ralls
> > >
> > >
> > > > On Mar 7, 2019, at 7:34 AM, Elias K Gardner 
> > > > wrote:
> > > >
> > > > My apologies I left out the error, its:  "
> > > >
> > > > On Thu, Mar 7, 2019 at 10:32 AM Elias K Gardner <
> > > > zork...@gmail.com> wrote:
> > > >
> > > > > I'm still getting the"" error when trying to update my price
> > > > > database. I
> > > > > got an alpha advantage key, put it in gnucash, and updated my
> > > > > Finance::Quote perl module to 1.47. At one point that seemed to
> > > > > sort of
> > > > > work but now I just get the "" error. Most of my quotes are
> > > > > approaching a
> > > > > year old. The absolute newest is from November 2018.
> > > > >
> > > > > Any suggestions on what I can do? I've searched this list
> > > > > multiple times
> > > > > already without luck. I fear that I broke something in one of
> > > > > my many
> > > > > attempts to fix this over the past year. Maybe I should start
> > > > > fresh. I've
> > > > > attempted to purge gnucash and reinstall but this does not seem
> > > > > to start
> > > > > everything fresh and frankly purging perl is a little over my
> > > > > head without
> > > > > clear guidance. Someday I'll reinstall ubuntu entirely (using
> > > > > 18.10 now, no
> > > > > fresh install for a few years) but thats become a bigger and
> > > > > bigger chore.
> > > > >
> > > > > I'm open to any suggestions. Much appreciated.
> > > > > 
> > > > >
> > > > ___
> > > > gnucash-user mailing list
> > > > 

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[John Ralls]

Please remember to copy the list on all replies. Reply all (the double arrow 
icon) works well.

A dmg is a MacOS disk image file. That's the kind of file that we use to 
distribute the GnuCash packages from Sourceforge and Github. After downloading  
most browsers will open it on their own, but if your's doesn't you can find it 
in your downloads folder and double-click it. It will open as a Finder window 
showing a bunch of files including Gnucash.

You unmount by control-clicking with the mouse inside that Finder window and 
selecting "unmount Gnucash-Intel-3.4.dmg" from the resulting context menu.

Regards,
John Ralls


> On Mar 19, 2019, at 7:57 PM, suk wah Bernstein  
> wrote:
> 
> namaskar john,
> 
> sorry i don't know what dmg is. 
> 
> wild guess. does it mean to download GnuCash 3.4 Mac OS X Intel?
> 
> thanks so much,
> love and respect
> suk wah
> 
> On Tue, Mar 19, 2019 at 7:44 PM John Ralls  
> wrote:
> 
> 
> > On Mar 19, 2019, at 5:19 PM, suk wah Bernstein  
> > wrote:
> > 
> > MacBook Pro
> > Intel core i5
> > 
> > please instruct. thanks so much.
> 
> The process is to download the dmg, open it, and drag GnuCash somewhere; the 
> Applications folder is popular. After the copy completes eject the dmg then 
> double click the icon in the Applications folder. You should first get a 
> dialog box from GateKeeper telling you that GnuCash is something that you 
> downloaded from the internet, are you sure you want to run it? Tell that yes, 
> then you'll get another dialog with a progress bar called something like 
> "Verifying GnuCash". When that finishes GnuCash should start, but doesn't 
> always. If it doesn't, double click on the icon again and it should start up.
> 
> If that's what you did and it didn't work, please detail what happened that's 
> different.
> 
> Regards,
> John Ralls
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[John Ralls]

> On Mar 19, 2019, at 5:19 PM, suk wah Bernstein  
> wrote:
> 
> MacBook Pro
> Intel core i5
> 
> please instruct. thanks so much.

The process is to download the dmg, open it, and drag GnuCash somewhere; the 
Applications folder is popular. After the copy completes eject the dmg then 
double click the icon in the Applications folder. You should first get a dialog 
box from GateKeeper telling you that GnuCash is something that you downloaded 
from the internet, are you sure you want to run it? Tell that yes, then you'll 
get another dialog with a progress bar called something like "Verifying 
GnuCash". When that finishes GnuCash should start, but doesn't always. If it 
doesn't, double click on the icon again and it should start up.

If that's what you did and it didn't work, please detail what happened that's 
different.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[Roger Oliver]

That worked. Thanks. You are correct, my intention was to experiment with
3.4. I thought I would try copying the stylesheet file to the test computer
as well. That did not work, I suspect because the picture file is not in
the test computer.

I take it that 3.4 will install with the Spanish accounting terms, etc., on
a Window 7 computer with the Windows language set to Spanish. Is that
correct? Spanish is not a language choice on the list when installing the
program but it installed on our working computer in Spanish anyway. That
was a boon for us.

Roger

The program looks good. Seems familiar and maybe a little easier on the
eyes.

On Tue, Mar 19, 2019, 2:01 PM Geert Janssens 
wrote:

> Op dinsdag 19 maart 2019 20:33:32 CET schreef rmom...@gmail.com:
> > Thanks Geert,
> >
> > Windows 7. I found the file in
> C:/Users/TOSHIBA/.gnucash/saved-reports-2.4.
> > Out of curiosity, I looked for it on my Windows 10 computer and didn't
> find
> > it. I didn't see anything special for Windows 10 in the wiki. Not
> important
> > really as long as the update takes care of that.
> >
> > You said, " If you want to force the migration, you should move the
> > directory aside before running gnucash 3.x." Will it work to copy the 2.4
> > file to the 3.4 directory? I saved the 2.4 file from the working pc to a
> > USB.  I'm guessing I'll have to delete the 3.4 saved reports file, if it
> > even exists as I have not saved any reports on the test computer. I would
> > like to give it a try.
> >
> > Roger
>
> Hi Roger,
>
> If I understand correctly from your reply to John, the new computer is
> only to
> experiment with 3.4. It will not be used to actually upgrade from 2.6 to
> 3.4 ?
>
> In that case you can indeed copy the saved-reports-2.4 file to the new pc.
>
> If you enter a Windows Explorer on that PC, and type
> %appdata%\GnuCash
> in its address bar, that should open the proper location to store the
> saved
> reports file for gnucash 3.4 (provided you have run gnucash 3.4 before at
> least once). Note don't copy the file there while gnucash is running. It
> may
> be overwritten as gnucash closes.
>
> Regards,
>
> Geert
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] macOS Mojave 10.14.3 cannot open GNUCASH

[suk wah Bernstein]

MacBook Pro
Intel core i5

please instruct. thanks so much.

love
suk wah
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Almost ready to give up

[WestTown55]

Hi,

I'm having the exact same issue trying to connect GnuCash with Chase. From
what I gather from this post, it's no longer possible to connect Chase with
GnuCash to automatically download the transactions. Is that correct?

Is the auto-download online banking setup easier with other banks? I have
Chase as my primary, but have been considering switching from Chase for a
while. 

Thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[Adrien Monteleone]

Roger, just for reference, while the computer in question could certainly be 
named ’TOSHIBA’ the file path you gave indicated this is the name of the 
current user. (they may have been given the same name)

If you had created a user called ‘Roger’ then the path would be 
C:/Users/Roger/.gnucash and the computer name could still remain ‘TOSHIBA’.

In any event, it would be a rare case to need the computer name to find a file. 
(this might be needed if the file were on another computer on a network)

Regards,
Adrien

> On Mar 19, 2019, at 2:13 PM,   wrote:
> 
> Thanks John,
> 
> I stumbled on the file on the computer we use for accounting in
> C:/Users/TOSHIBA/.gnucash. By $HOME do you mean the name of the computer,
> this case TOSHIBA? I looked for it on my Windows 10 PC but didn't find it.
> Not important. 
> 
> I only want to play with version 3.4 on the other computer to see if there
> are any glitches I'll have to deal with. That sort of thing is time
> consuming. The version we have installed is working fine so it is a
> cost(time)/benefit issue. Don't want to spend more time learning and fixing
> the software than we spend doing the work.
> 
> Roger


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Example of multi-split feature of CSV importer?

[Adrien Monteleone]

I never understood the need or benefit to differentiate simple vs. split 
transactions since *all* transactions are split into two entries at least once. 
Perhaps dropping that distinction is in order, or does it serve some purpose 
that isn’t outweighed by the confusion it causes?

Regards,
Adrien

> On Tue, Mar 19, 2019 at 5:45 AM Michael Hendry 
> wrote:
> 
>> David,
>> 
>> The guide says:
>> 
>> "Every transaction in GnuCash has at least two splits, but a transaction
>> can have more than two splits. A transaction with only two splits is called
>> a simple transaction, since it only involves the current account and a
>> single remote account. A transaction with three or more accounts is called
>> a split transaction.”
>> 
>> A recurrent observation on this list is that GnuCash is based on the
>> traditional paper-and-pen double-entry bookkeeping system, often linked
>> with the comment that many of the queries that come up are not problems
>> with GnuCash but with the poster’s lack of understanding of the manual
>> system.
>> 
>> There seems to be no good reason for introducing the term “split”, and
>> wielding  Occam’s Razor I suggest:
>> 
>> "Every transaction in GnuCash has at least two Ledger Entries, but a
>> transaction can have more than two Ledger Entries.”
>> 
>> “A transaction with two Ledger Entries is called a simple transaction.”
>> 
>> “A transaction with more than two Ledger Entries is called a compound
>> transaction.”
>> 
>> These three statements are entirely in keeping with bookkeeping usage,
>> whereas saying that a transaction with three “splits” is a split
>> transaction and then that one with two “splits” is something else is
>> muddling.
>> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Saving visible Accounts columns between GnuCash runs

[James Walker]

Hello all,

I'm very new to GnuCash and enjoying the program so far.

I've got a particular issue which I can't find a solution to after extensive 
searching of the manual.

In the chart of accounts, I want many more columns to be visible than are 
displayed by default:

[cid:image001.jpg@01D4DE4E.997CB810]


[cid:image002.png@01D4DE4E.997CB810]

However, after I exit the program, my customised field arrangement is lost. How 
do you get the order and display settings of Accounts columns to persist on 
save?

No matter what I select from the dropdown, all the non-default fields are lost 
after closing and restarting GnuCash. I can't see any other method in the 
interface to save the Accounts view configuration.

This is quite frustrating having to spend a minute each time I start GnuCash, 
setting up the chart of accounts screen again...

Kind regards,
James Walker


[cid:image004.jpg@01D4DE4E.997CB810]James Walker, 
Director
ja...@heron-web.com

Heron Web
07475931048
www.heron-web.com
3 Farm Lane, Crawley, Oxfordshire, OX29 9TL

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[Geert Janssens]

Op dinsdag 19 maart 2019 20:33:32 CET schreef rmom...@gmail.com:
> Thanks Geert,
> 
> Windows 7. I found the file in C:/Users/TOSHIBA/.gnucash/saved-reports-2.4.
> Out of curiosity, I looked for it on my Windows 10 computer and didn't find
> it. I didn't see anything special for Windows 10 in the wiki. Not important
> really as long as the update takes care of that.
> 
> You said, " If you want to force the migration, you should move the
> directory aside before running gnucash 3.x." Will it work to copy the 2.4
> file to the 3.4 directory? I saved the 2.4 file from the working pc to a
> USB.  I'm guessing I'll have to delete the 3.4 saved reports file, if it
> even exists as I have not saved any reports on the test computer. I would
> like to give it a try.
> 
> Roger

Hi Roger,

If I understand correctly from your reply to John, the new computer is only to 
experiment with 3.4. It will not be used to actually upgrade from 2.6 to 3.4 ?

In that case you can indeed copy the saved-reports-2.4 file to the new pc.

If you enter a Windows Explorer on that PC, and type
%appdata%\GnuCash
in its address bar, that should open the proper location to store the saved 
reports file for gnucash 3.4 (provided you have run gnucash 3.4 before at 
least once). Note don't copy the file there while gnucash is running. It may 
be overwritten as gnucash closes.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[rmomxtx]

Thanks Geert,

Windows 7. I found the file in C:/Users/TOSHIBA/.gnucash/saved-reports-2.4.
Out of curiosity, I looked for it on my Windows 10 computer and didn't find
it. I didn't see anything special for Windows 10 in the wiki. Not important
really as long as the update takes care of that.

You said, " If you want to force the migration, you should move the
directory aside before running gnucash 3.x." Will it work to copy the 2.4
file to the 3.4 directory? I saved the 2.4 file from the working pc to a
USB.  I'm guessing I'll have to delete the 3.4 saved reports file, if it
even exists as I have not saved any reports on the test computer. I would
like to give it a try. 

Roger

-Original Message-
From: Geert Janssens  
Sent: Tuesday, March 19, 2019 11:43 AM
To: gnucash-user@gnucash.org
Cc: rmom...@gmail.com; 'John Ralls' 
Subject: Re: [GNC] Saved report configurations

Op dinsdag 19 maart 2019 18:08:29 CET schreef rmom...@gmail.com:
> Version 2.6.17
> 
> I looked at the wiki and am not sure where to start. If possible, just 
> need to know:
> 
> What is the name of the file where the saved report configurations are 
> stored?
> Should those saved configurations be available when I update versions?
> 
> Thanks,
> Roger
> 
The file is called saved-reports-2.x where 'x' depends on your gnucash
version as does its location. For 2.6.17 the filename will be
saved-reports-2.4 and it will be stored in DOT_GNUCASH_DIR as described for
your OS (which you haven't provided yet) under
https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DIR

For GnuCash 3.0 and up the file will be in
https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME for your
OS. GnuCash will look for a file named saved-reports-2.8 first in there and
if missing it will try to open saved-reports-2.4 in the same directory.

As for updates, if you update gnucash from 2.6.x to 3.x it will copy these
saved reports from the old location to the new one for you, but only if the
new location didn't exist yet! So if you ran tests on your new PC with only
3.x and then install 2.6.x on that system, the migration will not run again
after upgrading to 3.x. If you want to force the migration, you should move
the https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME
directory aside before running gnucash 3.x.

Regards,

Geert

> -Original Message-
> From: John Ralls 
> Sent: Tuesday, March 19, 2019 10:43 AM
> To: rmom...@gmail.com
> Cc: GnuCash 
> Subject: Re: [GNC] Saved report configurations
> 
> > On Mar 19, 2019, at 9:33 AM,  
> 
> wrote:
> > Where are the saved report configurations kept. Apparently they are 
> > not part of the GnuCash data file. I installed vs 3.4 on another 
> > computer to test it and opened the data file transferred via USB. 
> > The saved report configurations are not there. Found one file that 
> > may be where they are stored, same name as the data file with the 
> > extension .LCK
> 
> It depends on what operating system and GnuCash version, see 
> https://wiki.gnucash.org/wiki/Configuration_Locations.
> 
> Regards,
> John Ralls
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. 
> - 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[rmomxtx]

Thanks John,

I stumbled on the file on the computer we use for accounting in
C:/Users/TOSHIBA/.gnucash. By $HOME do you mean the name of the computer,
this case TOSHIBA? I looked for it on my Windows 10 PC but didn't find it.
Not important. 

I only want to play with version 3.4 on the other computer to see if there
are any glitches I'll have to deal with. That sort of thing is time
consuming. The version we have installed is working fine so it is a
cost(time)/benefit issue. Don't want to spend more time learning and fixing
the software than we spend doing the work.

Roger

-Original Message-
From: John Ralls  
Sent: Tuesday, March 19, 2019 11:32 AM
To: rmom...@gmail.com
Cc: GnuCash 
Subject: Re: [GNC] Saved report configurations

The filename is "saved-reports-2.6" in 2.6.17 and unless you're on a Mac it
will be in $HOME/.gnucash. Running GnuCash will migrate everything in that
directory to its new home and make any necessary format upgrades (for
example, that file's name gets changed to "saved-reports-2.8") as long as
the new location doesn't already exist. If you've already run GnuCash 3.4 it
will, so you should delete that directory after copying in $HOME/.gnucash
and before restarting GnuCash 3.4.

Regards,
John Ralls


> On Mar 19, 2019, at 10:08 AM,  
wrote:
> 
> Version 2.6.17
> 
> I looked at the wiki and am not sure where to start. If possible, just 
> need to know:
> 
> What is the name of the file where the saved report configurations are 
> stored?
> Should those saved configurations be available when I update versions?
> 
> Thanks,
> Roger
> 
> -Original Message-
> From: John Ralls 
> Sent: Tuesday, March 19, 2019 10:43 AM
> To: rmom...@gmail.com
> Cc: GnuCash 
> Subject: Re: [GNC] Saved report configurations
> 
> 
> 
>> On Mar 19, 2019, at 9:33 AM,  
> wrote:
>> 
>> Where are the saved report configurations kept. Apparently they are 
>> not part of the GnuCash data file. I installed vs 3.4 on another 
>> computer to test it and opened the data file transferred via USB. The 
>> saved report configurations are not there. Found one file that may be 
>> where they are stored, same name as the data file with the extension 
>> .LCK
> 
> It depends on what operating system and GnuCash version, see 
> https://wiki.gnucash.org/wiki/Configuration_Locations.
> 
> Regards,
> John Ralls
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[Geert Janssens]

Op dinsdag 19 maart 2019 18:08:29 CET schreef rmom...@gmail.com:
> Version 2.6.17
> 
> I looked at the wiki and am not sure where to start. If possible, just need
> to know:
> 
> What is the name of the file where the saved report configurations are
> stored?
> Should those saved configurations be available when I update versions?
> 
> Thanks,
> Roger
> 
The file is called saved-reports-2.x where 'x' depends on your gnucash version 
as does its location. For 2.6.17 the filename will be saved-reports-2.4 and it 
will be stored in DOT_GNUCASH_DIR as described for your OS (which you haven't 
provided yet) under
https://wiki.gnucash.org/wiki/Configuration_Locations#DOT_GNUCASH_DIR

For GnuCash 3.0 and up the file will be in 
https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME for your 
OS. GnuCash will look for a file named saved-reports-2.8 first in there and if 
missing it will try to open saved-reports-2.4 in the same directory.

As for updates, if you update gnucash from 2.6.x to 3.x it will copy these 
saved reports from the old location to the new one for you, but only if the 
new location didn't exist yet! So if you ran tests on your new PC with only 
3.x and then install 2.6.x on that system, the migration will not run again 
after upgrading to 3.x. If you want to force the migration, you should move 
the https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME
directory aside before running gnucash 3.x.

Regards,

Geert

> -Original Message-
> From: John Ralls 
> Sent: Tuesday, March 19, 2019 10:43 AM
> To: rmom...@gmail.com
> Cc: GnuCash 
> Subject: Re: [GNC] Saved report configurations
> 
> > On Mar 19, 2019, at 9:33 AM,  
> 
> wrote:
> > Where are the saved report configurations kept. Apparently they are
> > not part of the GnuCash data file. I installed vs 3.4 on another
> > computer to test it and opened the data file transferred via USB. The
> > saved report configurations are not there. Found one file that may be
> > where they are stored, same name as the data file with the extension
> > .LCK
> 
> It depends on what operating system and GnuCash version, see
> https://wiki.gnucash.org/wiki/Configuration_Locations.
> 
> Regards,
> John Ralls
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[John Ralls]

The filename is "saved-reports-2.6" in 2.6.17 and unless you're on a Mac it 
will be in $HOME/.gnucash. Running GnuCash will migrate everything in that 
directory to its new home and make any necessary format upgrades (for example, 
that file's name gets changed to "saved-reports-2.8") as long as the new 
location doesn't already exist. If you've already run GnuCash 3.4 it will, so 
you should delete that directory after copying in $HOME/.gnucash and before 
restarting GnuCash 3.4.

Regards,
John Ralls


> On Mar 19, 2019, at 10:08 AM,   wrote:
> 
> Version 2.6.17
> 
> I looked at the wiki and am not sure where to start. If possible, just need
> to know:
> 
> What is the name of the file where the saved report configurations are
> stored? 
> Should those saved configurations be available when I update versions?
> 
> Thanks,
> Roger
> 
> -Original Message-
> From: John Ralls  
> Sent: Tuesday, March 19, 2019 10:43 AM
> To: rmom...@gmail.com
> Cc: GnuCash 
> Subject: Re: [GNC] Saved report configurations
> 
> 
> 
>> On Mar 19, 2019, at 9:33 AM,  
> wrote:
>> 
>> Where are the saved report configurations kept. Apparently they are 
>> not part of the GnuCash data file. I installed vs 3.4 on another 
>> computer to test it and opened the data file transferred via USB. The 
>> saved report configurations are not there. Found one file that may be 
>> where they are stored, same name as the data file with the extension 
>> .LCK
> 
> It depends on what operating system and GnuCash version, see
> https://wiki.gnucash.org/wiki/Configuration_Locations.
> 
> Regards,
> John Ralls
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[Maf. King]

On Tuesday, 19 March 2019 17:08:29 GMT rmom...@gmail.com wrote:
> Version 2.6.17
> 
> I looked at the wiki and am not sure where to start. If possible, just need
> to know:
> 
> What is the name of the file where the saved report configurations are
> stored?

saved-reports-2.4  ( I think)  In a folder that depends on you OS - use the 
wiki to figure out what GNC_DATA_HOME is for you.

> Should those saved configurations be available when I update versions?

Yes.

> 
> Thanks,
> Roger
> 
> -Original Message-
> From: John Ralls 
> Sent: Tuesday, March 19, 2019 10:43 AM
> To: rmom...@gmail.com
> Cc: GnuCash 
> Subject: Re: [GNC] Saved report configurations
> 
> > On Mar 19, 2019, at 9:33 AM,  
> 
> wrote:
> > Where are the saved report configurations kept. Apparently they are
> > not part of the GnuCash data file. I installed vs 3.4 on another
> > computer to test it and opened the data file transferred via USB. The
> > saved report configurations are not there. Found one file that may be
> > where they are stored, same name as the data file with the extension
> > .LCK
> 
> It depends on what operating system and GnuCash version, see
> https://wiki.gnucash.org/wiki/Configuration_Locations.
> 
> Regards,
> John Ralls
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[rmomxtx]

Version 2.6.17

I looked at the wiki and am not sure where to start. If possible, just need
to know:

What is the name of the file where the saved report configurations are
stored? 
Should those saved configurations be available when I update versions?

Thanks,
Roger

-Original Message-
From: John Ralls  
Sent: Tuesday, March 19, 2019 10:43 AM
To: rmom...@gmail.com
Cc: GnuCash 
Subject: Re: [GNC] Saved report configurations



> On Mar 19, 2019, at 9:33 AM,  
wrote:
> 
> Where are the saved report configurations kept. Apparently they are 
> not part of the GnuCash data file. I installed vs 3.4 on another 
> computer to test it and opened the data file transferred via USB. The 
> saved report configurations are not there. Found one file that may be 
> where they are stored, same name as the data file with the extension 
> .LCK

It depends on what operating system and GnuCash version, see
https://wiki.gnucash.org/wiki/Configuration_Locations.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Saved report configurations

[John Ralls]

> On Mar 19, 2019, at 9:33 AM,   wrote:
> 
> Where are the saved report configurations kept. Apparently they are not part
> of the GnuCash data file. I installed vs 3.4 on another computer to test it
> and opened the data file transferred via USB. The saved report
> configurations are not there. Found one file that may be where they are
> stored, same name as the data file with the extension .LCK

It depends on what operating system and GnuCash version, see 
https://wiki.gnucash.org/wiki/Configuration_Locations.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Saved report configurations

[rmomxtx]

Where are the saved report configurations kept. Apparently they are not part
of the GnuCash data file. I installed vs 3.4 on another computer to test it
and opened the data file transferred via USB. The saved report
configurations are not there. Found one file that may be where they are
stored, same name as the data file with the extension .LCK

 

Thanks,

Roger 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Order of transactions

[Derek Atkins]

Adrien Monteleone  writes:

> I understood that already, but thanks for the detail.
>
> What doesn’t work is sorting off the  part, because the sorting
> stops at “.”, correct?

Correct.

> That’s why you can’t use “:” in the faux timestamp as the sorting will
> stop before it gets to the minutes portion, and why you have to use a
> 24 hour notation because “a/am” or “p/pm” will be ignored.

Indeed.  You would need to explitly use an HHMM number in 24-hour format
without punctuation.

> Regards,
> Adrien

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek
-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to add prices to some securities

[Bucky Carr]

Forgot to mention. For the Online Price update, I switched from 
Alphavantage to Yahoo_JSON and it seems to be working fine.



On 3/19/2019 8:47 AM, Alan Taylor wrote:

And of course the Online Price update does not work, I have updated Perl etc. 
as per the WIKI.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unable to add prices to some securities

[Bucky Carr]

This might not be what you are seeing, but I found that I need to 
press the "Apply" button after entering each security's info and when 
done, then press "OK" button. If I skipped the "Apply" step, the info 
was not saved / updated.


HTH...

On 3/19/2019 8:47 AM, Alan Taylor wrote:

Hello,

I am running the latest GnuCash on the latest MacOS.
In Price Database | Add , I can add prices to some securities but not others. 
On the ones that won’t update, the dialogue box appears normal but nothing gets 
saved (no prices saved under the security name).
Nothing obvious linking the failures or successes.
The standard Portfolio report does appear to update to contain the new price, 
but it shows no signs of being stored anywhere.
And of course the Online Price update does not work, I have updated Perl etc. 
as per the WIKI.

I guess the first order of business is to get the manual update working …

Cheers/Al;an


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Unable to add prices to some securities

[Alan Taylor]

Hello,

I am running the latest GnuCash on the latest MacOS.
In Price Database | Add , I can add prices to some securities but not others. 
On the ones that won’t update, the dialogue box appears normal but nothing gets 
saved (no prices saved under the security name).
Nothing obvious linking the failures or successes.
The standard Portfolio report does appear to update to contain the new price, 
but it shows no signs of being stored anywhere.
And of course the Online Price update does not work, I have updated Perl etc. 
as per the WIKI.

I guess the first order of business is to get the manual update working …

Cheers/Al;an
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] no printer to select in print dialog

[Geert Janssens]

Op maandag 11 maart 2019 04:48:03 CET schreef Chris Roy-Smith:
> On 10/3/19 7:45 pm, Colin Law wrote:
> > Thanks Chris.  That could indeed be useful.  One should always
> > remember, though, that with a ppa one is reliant on the integrity of
> > the packager to build what you are expecting.  There is nothing to
> > stop someone modifying the code for nefarious purposes and building it
> > into a ppa.  Looking at the packagers profile, however, there does not
> > seem to be anything that would lead one to worry about his/her
> > integrity.
> > 
> > Colin
> 
> I also tried running GnuCash using this command
> 
> flatpak run --device=all org.gnucash.GnuCash
> 
> But I still don't get any printers!
> 
> perhaps I misunderstood the notes at
> 
> http://docs.flatpak.org/en/latest/search.html?q=device_keywords=yes
> ea=default
> 
> regards, Chris
> 

Hi Chris,

This part was new to me so it took me some research to figure out what's 
happening.

The --device option is not meant for printers. It's for accessing controllers 
or webcams. For printing flatpak provides a portal mechanism.

On the other side GnuCash does not handle printing directly. It relies on the 
underlying toolkits to do so.

For example for check printing we delegate to Gtk's built-in print 
functionality. Gtk is aware of the flatpak portal mechanism, so your printers 
should show up if you try to print a check.

For report printing, GnuCash delegates the request to webkit's built-in 
printing functionality (as we rely on webkit for displaying reports). 
Unfortunately webkit seems to be unaware of the flatpak portal mechanism. 
Hence no printers are listed.

I'm not sure if we can work around this in GnuCash or with flatpak command 
switches. That is to be investigated. I have opened
https://bugs.gnucash.org/show_bug.cgi?id=797146
to track this further.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] End of year rollover

[Adrien Monteleone]

Welcome to GnuCash!

There is a ‘close books’ procedure you can use that zeros expenses and income 
to equity as ‘retained earnings/losses’ but you don’t have to use it. GnuCash 
does not require that you clear anything out at the end of the year. (and doing 
so can impact your ability to run reports in some cases)

There are people with 10+ years of data in very large files (with lots of stock 
tracking) and other than some slow loading times, there aren’t any major 
issues. (there are work arounds for the slow loading - somewhat)

Some people do a close books and open a new file each year. But that process 
requires archiving reports and the data files. It also means you can’t run 
reports for multiple years without external help (like from a spread sheet) or 
you can’t run reports that cross yearly boundaries. (say from 4Q18 to 1Q19) And 
if you want to look at prior year(s) data, you have to open each of those files 
separately.

The Chart of Accounts tab has an available column for totals that show all data 
in the entire book. (running totals from when you started using GnuCash) It 
also has a column you can make visible for totals just for this accounting 
period. (year) That way you can have an ‘at a glance’ view of your accounts 
without running Income Statements or Balance Sheets. (but those are available 
of course if you need them) The Summary Bar also shows current net worth and 
retained earnings/losses.

My personal workflow is to not use the close books procedure, make the current 
period totals visible on the Accounts tab, as well as keep open a YTD P, and 
a monthly P for last month and this month. I run Balance Sheets as needed. I 
also never close GnuCash except for upgrades. Thus I don’t experience the data 
file loading but a few times a year. And it is still relatively painless. 
(special note - loading is significantly slower if you leave reports open when 
closing the app. They will be loading on re-opening the program which takes 
some time)

As for reconciled transactions, they don’t ‘go away.’ But you can filter your 
register views if you don’t want to see them. (or any transaction before a 
certain date, say in the previous year)

Regards,
Adrien

> On Mar 19, 2019, at 5:36 AM, garage cowboy  wrote:
> 
> Hi   - I am a new gnucash user  ( just a few weeks).
> 
> First of all, congratulations and thanks to all those  who have contributed
> to  this great product.
> 
> My question is about EOFY processes   - I am used to products  which have
> an end of year rollover process which clears reconciled transactions   - is
> there equivalent function in gnucash?  What is the recommended approach?
> am wondering  what will happen in a few years  when there are thousand of
> transactions in the xml  file.
> 
> Also interested in contributing to the cause  but not a developer.
> 
> regards,
> 
> GC


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.