Re: MySQL Server connection timeout or keep-alive

[John Ralls]

> On Apr 3, 2018, at 1:06 PM, Colin Law  wrote:
> 
> On 3 April 2018 at 19:40, Paul Neuwirth  > wrote:
> > ...
> I am wondering, if no keep-alive is going to be implemented, if a
> connection loss could be catched and connect again..
> the error message is:
> "Unable to save to database."
> 
> That is not unreasonable on connection loss. What happens after that?

I think that the session dies and given the current architecture that’s 
probably the right thing to do. GnuCash isn’t yet a database front end and the 
database connection code is tied into loading the database into memory. An 
outright crash or freeze would be bad, but restarting GnuCash or switching to a 
different book and switching back is at present the only safe course.

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: gnucash 3.0 crashes opening accounts file

[John Ralls]

> On Apr 3, 2018, at 10:45 AM, pjlbyrne  wrote:
> 
> Hmm lots of errors running setup-mingw64.ps1 (see below).
> 
> Perhaps the script needs modifying so it uses my work web proxy?
> 
> I will have a look tomorrow.

Quite likely, I don’t have any proxies in place and didn’t take that 
possibility into account. I’m also not at all sure that Mingw-w64’s package 
manager will work through a proxy, so you may need to figure out how to make 
the proxy transparent to shell file retrieval programs.

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: gnucash 3.0 crashes opening accounts file

[John Ralls]

> On Apr 3, 2018, at 10:37 AM, pjlbyrne  wrote:
> 
> Thanks again again. I had not only to run powershell with administrator
> priviliges, but also type 'Set-ExecutionPolicy Unrestricted' before running
> the script. Perhaps script execution policy is restricted by default at my
> workplace for security reasons.

No, that’s the default setting on Windows 10.

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: 2.6.19 crash: one account recovered, one not yet recovered [RESOLVED]

[John Ralls]

> On Apr 3, 2018, at 10:32 AM, Rich Shepard  wrote:
> 
> On Tue, 3 Apr 2018, Rich Shepard wrote:
> 
>> How can I use the binary business.gnucash file to recover the account? If
>> so, I can bring all registers up to date manually using bank and credit
>> card statements.
> 
>  Tried opening the business.gnucash file and it worked! while the non-log
> files in the personal/ subdirectory have a datetimestamp associated with
> them (e.g., personal.gnucash.20180403092939.gnucash), those in the business/
> subdirectory do not.
> 

Does business.gnucash use the SQLite3 backend? If so, that would explain the 
absence of backups, and I suggest you set up some OS-level backup mechanism for 
it.

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: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[Waitman Gobble]

I don't see such abbreviation, but I understand how it could be problematic. 
It's like a piece is good most of the time but the whole thing might not be 
desired. To look at all day. It just depends.

Sent from ProtonMail mobile

 Original Message 
On Apr 3, 2018, 9:36 PM, Phil wrote:

> I am not getting any truncation in the summary bar on Arch.
>
> - Phil
>
> On 04/03/2018 04:59 PM, lj wrote:
>> Thanks everyone for the replies. Unless I missed something, nobody
>> else is seeing it, but everyone else who reported is running Windows
>> or Mac. No other Linux users reported seeing or not seeing the issue.
>>
>> I did a little digging (dangerous when you don't really know what you
>> are doing) and I see calls like gtk_cell_rendered_set_fixed_size for
>> the summary window with a 'width' parameter of 50. The truncation I'm
>> seeing "Net Ass" is exactly 50 pixels wide (as measured with Gimp).
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> [https://lists.gnucash.org/mailman/listinfo/gnucash-user](> href=)">https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> [https://wiki.gnucash.org/wiki/Mailing_Lists](> href=)">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]( href=)">https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> [https://wiki.gnucash.org/wiki/Mailing_Lists]( href=)">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: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[Phil]

I am not getting any truncation in the summary bar on Arch.

- Phil


On 04/03/2018 04:59 PM, lj wrote:
> Thanks everyone for the replies. Unless I missed something, nobody
> else is seeing it, but everyone else who reported is running Windows
> or Mac. No other Linux users reported seeing or not seeing the issue.
>
> I did a little digging (dangerous when you don't really know what you
> are doing) and I see calls like gtk_cell_rendered_set_fixed_size for
> the summary window with a 'width' parameter of 50. The truncation I'm
> seeing "Net Ass" is exactly 50 pixels wide (as measured with Gimp).
>
> ___
> 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: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[Roger Miskowicz]

I am using Ubuntu 16.04.4 LTS and see something similar in the Grand Total
Summary Bar.  I not sure what the Summary Bar is reporting.

On Tue, Apr 3, 2018 at 7:59 PM, lj  wrote:

> Thanks everyone for the replies. Unless I missed something, nobody else is
> seeing it, but everyone else who reported is running Windows or Mac. No
> other Linux users reported seeing or not seeing the issue.
>
> I did a little digging (dangerous when you don't really know what you are
> doing) and I see calls like gtk_cell_rendered_set_fixed_size for the
> summary window with a 'width' parameter of 50. The truncation I'm seeing
> "Net Ass" is exactly 50 pixels wide (as measured with Gimp).
>
> ___
> 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: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[lj]

Thanks everyone for the replies. Unless I missed something, nobody else is 
seeing it, but everyone else who reported is running Windows or Mac. No other 
Linux users reported seeing or not seeing the issue.


I did a little digging (dangerous when you don't really know what you are 
doing) and I see calls like gtk_cell_rendered_set_fixed_size for the summary 
window with a 'width' parameter of 50. The truncation I'm seeing "Net Ass" is 
exactly 50 pixels wide (as measured with Gimp).


___
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: MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

On Tuesday 2018-04-03 22:06, Colin Law wrote:


Date: Tue, 3 Apr 2018 22:06:08
From: Colin Law 
To: Paul Neuwirth 
Cc: John Ralls , gnucash-user 
Subject: Re: MySQL Server connection timeout or keep-alive

On 3 April 2018 at 19:40, Paul Neuwirth  wrote:


...

I am wondering, if no keep-alive is going to be implemented, if a
connection loss could be catched and connect again..
the error message is:
"Unable to save to database."



That is not unreasonable on connection loss. What happens after that?

Colin



Indeed, I did not try yet. I always restarted gnucash when it happened.
___
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: Fast reactions to 2.7.8

[Dave H]

Split also has a label :-)

Cheers Dave H.

On 4 April 2018 at 02:33, Adrien Monteleone 
wrote:

> Now that I’ve got 3.0 properly up and running, I see the Save and Close
> buttons have labels on the right side, but no others do.
>
> Regards,
> Adrien
>
> > On Mar 31, 2018, at 10:25 AM, Adrien Monteleone <
> adrien.montele...@gmail.com> wrote:
> >
> > That’s certainly a thorough run-down on changing themes.
> >
> > But is there a way to edit a theme to make the button label visible? I
> see one could download a theme and go through all that trouble, only to
> find out the theme is hiding the labels. That could turn into quite a trial
> and error process and certainly result in having to choose a less desirable
> theme, just to have a label on a button.
> >
> > On that note, is having a label on a button not done in the UI code?
> Looking at the button reference I see each one would need both an icon and
> a label or mnemonic label. I suppose the theme could choose or not to show
> the label, but it would have to be programmed in first. If all of those
> toolbar buttons are icons only...
> >
> > (sorry, I haven’t taken a look at the code yet)
> >
> > I would then suspect that in order for GnuCash to offer a toggle, it
> would have to at the least, branch the code on that preference to display
> buttons with or without labels, and then the question, “Are the labels are
> visible?” would depend on the user’s GTK theme. It appears the GTK devs
> either didn’t think this one through, or they are trying to enforce a
> certain look. Or maybe they can’t be made invisible by the theme at all,
> and this is entirely decided in UI code.
> >
> > Regards,
> > Adrien
> >
> >> On Mar 31, 2018, at 7:37 AM, Geert Janssens 
> wrote:
> >>
> >> Op dinsdag 27 maart 2018 18:44:38 CEST schreef Stan Brown:
> >>> (1) Not a fan of the toolbar showing icons without words. I _hate_ an
> >>> interface where you have to hover over every single icon until you can
> find
> >>> the one you want.
> >>>
> >>> Many programs offer "words only", "icons only", and "icons and words"
> as
> >>> choices. I couldn't find anything like that. Please add it.
> >>>
> >>> (2) At first I thought performance was horrendously slow, when I was
> >>> entering transactions in the general ledger. Turns out the actual
> issue was
> >>> that the Tab key, instead of advancing to the next field, just gave
> focus
> >>> to the "Save" button at upper left. This was on windows 8, with Build
> ID:
> >>> git 2.7.8+ (2018-03-25).
> >>
> >> A more general note. I have done some experimentation about what can be
> done
> >> to tweak the gnucash user interface in the absence of the Theme
> selector we
> >> used to have for gnucash 2.x (that was removed from gtk for gtk3, not
> >> something gnucash had any say in).
> >>
> >> It turns out that apart from really starting to customize css settings
> one can
> >> also install custom themes. It's still a bit of manual work but it's
> much less
> >> complicated than looking for individual settings. What follows can be
> used as
> >> a basis to document this on the gui tweak wiki page.
> >>
> >> Note this custom theme will affect all gtk3 based applications on your
> system!
> >>
> >> Short summary:
> >> 1. Download an appropriate gtk3 theme from www.gnome-look.org
> >> 2. Install the theme in a directory where gtk3 looks for themes
> >> 3. create or adjust a settings.ini file to tell gtk3 to use this theme
> >>
> >> Slightly longer with platform dependent remarks:
> >>
> >>
> >> 1. Go to the gnome-look.org website
> >> 2. Click the "Gtk3 Themes" link (*not* the Gtk2 one)
> >> 3. Select a theme you like
> >> Alternatively you can search for keywords (like "dark") in the top right
> >> corner and then filter on "Gtk3 Theme category"
> >> 4. If you have found a theme you like, download the proper file (in the
> files
> >> section of the theme page).
> >>
> >> Note depending on your operating system you may not be able to open all
> theme
> >> files. I have seen for example .deb archives which are specifically
> targeted
> >> at the Debian linux distribution and derivates such as Ubuntu. While
> Ubuntu
> >> and Debian users can install those themes via their package manager
> these
> >> themes are not useful for other platforms.
> >> Theme files ending with .zip, .tar.gz or tar.xz are likely installable
> on all
> >> platforms, although you may have to find a proper application to
> extract them.
> >> On Windows 7-Zip is a good candiate,  linux users can probably extract
> the
> >> files directly from their file manager.
> >>
> >> So...
> >> Let's take the theme "Eye-friendly Dark RBC" as an example (it's not
> the best
> >> theme but it can serve as an example). The file to download is
> "Eye-friendly-
> >> Dark-RBC.tar.gz"
> >>
> >> 5. Extract this file using an appropriate tool. This  should give you a
> >> directory named "Eye-friendly-Dark-RBC"
> >>
> >> 6. Move this directory to a location on your system that's parsed by
> gtk.

Re: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[Dave H]

Yes checked last night and mine are the same on Windows 7/10 and Mac High
Sierra as they were in 2.6.19.

Cheers Dave H.

On 4 April 2018 at 01:59, Adrien Monteleone 
wrote:

> Mine is polite. It shows the same thing it showed in 2.6.19. This is on
> MacOS High Sierra.
>
> Regards,
> Adrien
>
> > On Apr 2, 2018, at 9:52 PM, Dave H  wrote:
> >
> > Hi lj, on Windows 10 mine says "$, Grand Total:
> > Net Assets: $999,999.99
> > Profits: $99,999.99".
> >
> > I'll have to compare with my MacOS/Windows versions at home to see if
> they
> > are different.  Not sure what the Grand Total is supposed to be and
> whether
> > it's alwys been blank as I don't usually pay much attention to this line
> :-)
> >
> > Cheers Dave H.
> >
> >
> >
> > On 3 April 2018 at 12:10, lj  wrote:
> >
> >> Using: gnucash-3.0 on 32-bit Slackware Linux 14.2; Gtk+3-3.18.9
> >>
> >> When viewing the accounts tree, my summary bar at the bottom displays
> >> this, exactly:
> >>$:  Net Ass Profits:
> >>
> >> On 2.6.x it displays "$:  Net Assets: (number)   Profits: (number)
> >> Obviously something is getting truncated for me at 3.0, in a bad way.
> >>
> >> If I click on the summary bar, it reverses colors, and changes to the
> >> expected text with Net Assets and Profits. As soon as I click anywhere
> >> else, it goes back to that "Net Ass Profits". (It seems to be acting
> like
> >> it is a pull-down menu but with only 1 option. 2.6.x had 2 options
> there.)
> >>
> >> Is anyone else seeing this?
> >>
> >> ___
> >> 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.
>
> ___
> 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: MySQL Server connection timeout or keep-alive

[Colin Law]

On 3 April 2018 at 19:40, Paul Neuwirth  wrote:

> > ...
> I am wondering, if no keep-alive is going to be implemented, if a
> connection loss could be catched and connect again..
> the error message is:
> "Unable to save to database."
>

That is not unreasonable on connection loss. What happens after that?

Colin
___
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: GnuCash 3.0 Released QFX Import problem

[stdenis0--- via gnucash-user]

David C.

 

Thanks for the suggestion to revert back to 2.6.20 I just finished the install 
and it seems to be working. I know it is always hard to get every thing to 
function correctly but I appreciate all the work that all the developers have 
put into getting GnuCash 3.0 working.

 

Joe St. Denis  

 

From: David Carlson  
Sent: Tuesday, April 3, 2018 2:25 PM
To: John Ralls 
Cc: stden...@yahoo.com; Gnucash Users 
Subject: Re: GnuCash 3.0 Released QFX Import problem

 

So what John is saying is that is a known bug that has a very high priority to 
get fixed but it may take a while before the fix is implemented so you may want 
to revert to 2.6.20 if you need that function now.

David C

 

On Tue, Apr 3, 2018 at 9:06 AM, John Ralls mailto:jra...@ceridwen.us> > wrote:



> On Apr 3, 2018, at 6:46 AM, stdenis0--- via gnucash-user 
> mailto:gnucash-user@gnucash.org> > wrote:
>
> I tried to import two QFX files into Gnucash 3, I know that some
> transactions were not entered into Gnucash 3  so they should have been
> listed but in both imports I got a blank screen.
>

Sounds like https://bugzilla.gnome.org/show_bug.cgi?id=793461 
.

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: To those experiencing crashes of release 3.0 in windows

[Jack Slater]

Windows 10 pc. I have not updated and based on what I’m seeing, I better wait?

> On Apr 3, 2018, at 1:44 PM, David Carlson  wrote:
> 
> One possible work-around to this problem that may or may not work is to
> create a new user on your windows machine just to run GnuCash.  It is
> fairly easy to delete that new user later when done with it.
> 
> While I make that suggestion, I do not personally recommend it, so use at
> your own risk.
> 
> David C
> ___
> 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.

To those experiencing crashes of release 3.0 in windows

[David Carlson]

One possible work-around to this problem that may or may not work is to
create a new user on your windows machine just to run GnuCash.  It is
fairly easy to delete that new user later when done with it.

While I make that suggestion, I do not personally recommend it, so use at
your own risk.

David C
___
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: MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

> >> Hello,
> >> is it possible to change somewhere the connection timeout to a
> >> MySQL server on the client side?
> >> Or could it be possible to implement a keep-alive?
> >> Everytime the connection is lost, I need to restart gnucash.  
> >
> > I don't think that it's possible from the client. IIUC (and I'm not
> > a MySQL expert, but if you're using it you should be or you should
> > hire one) it's a server-side parameter called wait_timeout.
> >
> > No, we're not going to add a keep-alive.
> > https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
> > says that a connection pool is the right way to handle this, but
> > the database abstraction library we use doesn't support that so
> > it's not going to get added any time soon.  
> 
> However if GnuCash fails in a non-recoverable way when you lose the
> connection I would have thought that would be a bug.  What exact
> symptom are you seeing?
> 
> Colin

I am wondering, if no keep-alive is going to be implemented, if a
connection loss could be catched and connect again..
the error message is:
"Unable to save to database."

regards,
paul
___
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: MySQL Server connection timeout or keep-alive

[Paul Neuwirth]

> > Hello,
> > is it possible to change somewhere the connection timeout to a MySQL
> > server on the client side?
> > Or could it be possible to implement a keep-alive?
> > Everytime the connection is lost, I need to restart gnucash.  
> 
> I don't think that it's possible from the client. IIUC (and I'm not a
> MySQL expert, but if you're using it you should be or you should hire
> one) it's a server-side parameter called wait_timeout.
> 
> No, we're not going to add a keep-alive.
> https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
> says that a connection pool is the right way to handle this, but the
> database abstraction library we use doesn't support that so it's not
> going to get added any time soon.
> 
> Regards,
> John Ralls
> 
> 

Thank you for the explanation. I solved it on server side. I would
have prefered a solution on client-side, because it's a global server
setting and affects all connections..

Paul
___
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: GNUCash 3.0 crashes on load

[Joseph Vernice]

Thank you, John.  The perl install (Windows 10) solved the issue when 
opening XML format gnucash files, but mysql files still take 10 minutes 
to load AND now gnucash crashes after opening the SQL file.
I just re-installed 2.6.19 and will wait for a fix as there seems to be 
quite a few experiencing with the same issue.


I appreciate all of the work that the developers have put into gnucash.

Apr 3, 2018, at 7:05 AM, Joseph Vernice  wrote:

Gnucash crashes on opening an XML file (backup of my normally used mysql file). 
Mysql file eventually loads after 10-15 minutes. It takes only 50 seconds with 
version 2.6.19

I have the following error in my gnucash log after 10+ minute loading of mysql 
data file... :

WARN  Could not spawn perl: Failed to execute child process (No 
such file or directory)

Any ideas?  Thank you!

This is Windows, right? That error is normal on Windows unless you've run the 
"Install Online Quotes" tool, as Windows systems don't normally have perl.

  On Windows, slow loading of SQL is 
https://bugzilla.gnome.org/show_bug.cgi?id=792105, though do note that on the 
first load there are a couple of data conversions that can take quite a while 
on any machine. Crash on load of XML has several bugs:

https://bugzilla.gnome.org/show_bug.cgi?id=794934
https://bugzilla.gnome.org/show_bug.cgi?id=794933
https://bugzilla.gnome.org/show_bug.cgi?id=793768
https://bugzilla.gnome.org/show_bug.cgi?id=782144

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: GnuCash 3.0 Released QFX Import problem

[David Carlson]

So what John is saying is that is a known bug that has a very high priority
to get fixed but it may take a while before the fix is implemented so you
may want to revert to 2.6.20 if you need that function now.

David C

On Tue, Apr 3, 2018 at 9:06 AM, John Ralls  wrote:

>
>
> > On Apr 3, 2018, at 6:46 AM, stdenis0--- via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > I tried to import two QFX files into Gnucash 3, I know that some
> > transactions were not entered into Gnucash 3  so they should have been
> > listed but in both imports I got a blank screen.
> >
>
> Sounds like https://bugzilla.gnome.org/show_bug.cgi?id=793461 <
> https://bugzilla.gnome.org/show_bug.cgi?id=793461>.
>
> 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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

Hmm lots of errors running setup-mingw64.ps1 (see below).

Perhaps the script needs modifying so it uses my work web proxy?

I will have a look tomorrow.

CP




powershell output
--

PS C:\users\pbyrne\Downloads> Set-ExecutionPolicy Unrestricted

Execution Policy Change
The execution policy helps protect you from scripts that you do not trust.
Changing the execution policy might expose
you to the security risks described in the about_Execution_Policies help
topic. Do you want to change the execution
policy?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):
PS C:\users\pbyrne\Downloads> Get-ExecutionPolicy
Unrestricted
PS C:\users\pbyrne\Downloads> get-ExecutionPolicy
Unrestricted
PS C:\users\pbyrne\Downloads> .\setup-mingw64.ps1


Directory: C:\


ModeLastWriteTime Length Name
- -- 
d03/04/2018 18:34gcdev64


Directory: C:\gcdev64


ModeLastWriteTime Length Name
- -- 
d03/04/2018 18:34downloads
Downloading c:\\gcdev64\\downloads\msys2.exe from
http://repo.msys2.org/distrib/i686/msys2-i686-20161025.exe
Installing c:\\gcdev64\\downloads\msys2.exe --script c:\\gcdev64\input.qs
Get-Item : Cannot find path 'HKCU:\SOFTWARE\Microsoft\HTML Help Workshop'
because it does not exist.
At C:\users\pbyrne\Downloads\setup-mingw64.ps1:159 char:25
+ $installed_hh = get-item   -path "hkcu:\SOFTWARE\Microsoft\HTML Help
Workshop" | foreach-object{$_.GetValue("Inst
allDir")}
+ CategoryInfo  : ObjectNotFound: (HKCU:\SOFTWARE\...L Help
Workshop:String) [Get-Item], ItemNotFoundExcep
   tion
+ FullyQualifiedErrorId :
PathNotFound,Microsoft.PowerShell.Commands.GetItemCommand

Downloading c:\\gcdev64\\downloads\\htmlhelp.exe from
http://download.microsoft.com/download/0/a/9/0a939ef6-e31c-430f-a3
df-dfae7960d564/htmlhelp.exe
Installing c:\\gcdev64\\downloads\
You cannot call a method on a null-valued expression.
At C:\users\pbyrne\Downloads\setup-mingw64.ps1:97 char:22
+ $proc.waitForExit  ()
+ CategoryInfo  : InvalidOperation: (waitForExit:String) [],
RuntimeException
+ FullyQualifiedErrorId : InvokeMethodOnNull

Downloading c:\\gcdev64\\downloads\innosetup-5.5.9-unicode.exe from
http://files.jrsoftware.org/is/5/innosetup-5.5.9-uni
code.exe
Installing c:\\gcdev64\\downloads\innosetup-5.5.9-unicode.exe  /verysilent
/suppressmsgboxes /nocancel /norestart /dir="
C:\Program Files (x86)\inno"
Updating the installation. Accept the proposed changes. If the window
doesn't close on its own then close it and re-run
the script when it finishes.
:: Synchronizing package databases...
error: failed retrieving file 'mingw32.db' from repo.msys2.org : Connection
timed out after 1 milliseconds
error: failed retrieving file 'mingw32.db' from downloads.sourceforge.net :
Connection timed out after 1 millisecond
s
error: failed retrieving file 'mingw32.db' from www2.futureware.at :
Connection timed out after 1 milliseconds
error: failed to update mingw32 (download library error)
error: failed retrieving file 'mingw64.db' from repo.msys2.org : Connection
timed out after 1 milliseconds
error: failed retrieving file 'mingw64.db' from downloads.sourceforge.net :
Connection timed out after 1 millisecond
s
error: failed retrieving file 'mingw64.db' from www2.futureware.at :
Connection timed out after 1 milliseconds
error: failed to update mingw64 (download library error)
error: failed retrieving file 'msys.db' from repo.msys2.org : Connection
timed out after 1 milliseconds
error: failed retrieving file 'msys.db' from downloads.sourceforge.net :
Connection timed out after 10006 milliseconds
error: failed retrieving file 'msys.db' from www2.futureware.at : Connection
timed out after 1 milliseconds
error: failed to update msys (download library error)
error: failed to synchronize any databases
error: failed to init transaction (download library error)
Now we'll install the dependencies. Accept the installation as usual. About
half-way through it will stop with a message
 about fontconfig. Just type "Return" at it and it will resume after a
minute or two (be patient!) and complete the inst
allation.
warning: file-5.28-2 is up to date -- skipping
warning: flex-2.6.1-1 is up to date -- skipping
warning: gawk-4.1.4-1 is up to date -- skipping
warning: gettext-0.19.7-3 is up to date -- skipping
warning: grep-2.26-1 is up to date -- skipping
warning: m4-1.4.17-4 is up to date -- skipping
warning: pacman-5.0.1-1 is up to date -- skipping
warning: pactoys-git-r2.07ca37f-1 is up to date -- skipping
warning: sed-4.2.2-2 is up to date -- skipping
warning: wget-1.18-1 is up to date -- skipping
warning: skipping target: texinfo
resolving dependencies...
looking for conflicting packages...

Packages (85) db-5.3.28-2  do

Re: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

Thanks again again. I had not only to run powershell with administrator
priviliges, but also type 'Set-ExecutionPolicy Unrestricted' before running
the script. Perhaps script execution policy is restricted by default at my
workplace for security reasons.



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

2.6.19 crash: one account recovered, one not yet recovered

[Rich Shepard]

  Running GC-2.6.19 on Slackware-14.2 here. I have two accounts, personal
and business.

  This morning I entered three transactions in the personal checking
account, saved each, then tried to open the business file. Gnucash said it
could not find that file, then shut down.

  Reading the gnucash-guide I recovered the personal account by opening
personal.gnucash.20180403092939.gnucash. However, when I looked in the
business directory all I find are log files.

  I last accessed the business account on March 23rd. By habit, I always
save transactions before exiting; in any case, gnucash won't let me exit
without saving unless I explicitly tell it to do so, and I don't.

  Looking at my daily incremental backups I cannot find the last time there
was a business.guncash.*.gnucash file. In my business subdirectory I have
these files:

business.gnucash
business.gnucash.20180323100319.log
business.gnucash.20180323130653.log
business.gnucash.20180323130712.log

  The business.gnucash file is timestamped Mar 23 13:07, as are the latter
two .log files.

  How can I use the binary business.gnucash file to recover the account? If
so, I can bring all registers up to date manually using bank and credit card
statements.

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
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: 2.6.19 crash: one account recovered, one not yet recovered [RESOLVED]

[Rich Shepard]

On Tue, 3 Apr 2018, Rich Shepard wrote:


How can I use the binary business.gnucash file to recover the account? If
so, I can bring all registers up to date manually using bank and credit
card statements.


  Tried opening the business.gnucash file and it worked! while the non-log
files in the personal/ subdirectory have a datetimestamp associated with
them (e.g., personal.gnucash.20180403092939.gnucash), those in the business/
subdirectory do not.

  All's well here once again.

Whew!

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
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: virus download version 3.0

[John Ralls]

It's Microsoft's fault, not yours. Thanks for reporting it.

For those interested I've submitted gnucash-3.0.setup.exe to Microsoft's 
false-positive reporting facility and gotten case number  
82655139-6978-4eeb-80c2-7e1e72f820a6.

Regards,
John Ralls


> On Apr 2, 2018, at 8:56 PM, Dave via gnucash-user  
> wrote:
> 
> Thank you for your assistance and sorry for the false positive report I put
> out there.
> 
> I'll be more careful with Windows Defender from now on.
> 
> Thanks for everyone's work on GnuCash.  It's extremely helpful.
> 
> Dave E.
> 
> 
> -Original Message-
> From: Robert Heller  
> Sent: Tuesday, April 03, 2018 11:36 AM
> To: Dave H 
> Cc: dtep...@yahoo.com; Gnucash Users ; Robert
> Heller 
> Subject: Re: virus download version 3.0
> 
> I think "Windows Defender" detects any exe that is not "Official Microsoft"
> as a "virus", unless an exception is set.
> 
> 
> At Tue, 3 Apr 2018 13:01:15 +1000 Dave H  wrote:
> 
>> 
>> Symantec Endpoint Protection on Win 10 Enterprise here didn't detect any
>> issues with the file.
>> 
>> Cheers Dave H.
>> 
>> On 3 April 2018 at 12:35, Dave via gnucash-user 
>> wrote:
>> 
>>> Downloaded from official GnuCash.org which lead me to the official
> Source
>>> Forge download page.
>>> 
>>> For Windows 10 OS
>>> 
>>> Windows Defender detected.
>>> 
>>> Trojan Win32 Azden/B!cl
>>> 
>>> Dave
>>> 
>>> -Original Message-
>>> From: Frank H. Ellenberger 
>>> Sent: Tuesday, April 03, 2018 10:29 AM
>>> To: dtep...@yahoo.com; gnucash-user@gnucash.org
>>> Subject: Re: virus download version 3.0
>>> 
>>> Hi,
>>> 
>>> Am 03.04.2018 um 04:20 schrieb Dave via gnucash-user:
 Hi.
 
 
 
 I'm getting a virus when I download version 3.0
>>> 
>>> * From which URL did you download?
>>> * Did you verify the signature?
>>> * Which AV reported which message?
>>> 
>>> * Can you cross check with https://www.virustotal.com or similar?
>>> 
>>> Regards
>>> Frank
>>> 
>>> ___
>>> 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.
>> 
>> 
> 
> -- 
> Robert Heller -- 978-544-6933
> Deepwoods Software-- Custom Software Services
> http://www.deepsoft.com/  -- Linux Administration Services
> hel...@deepsoft.com   -- Webhosting Services
> 
> 
> ___
> 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: Importing Quicken

[David T. via gnucash-user]

cicko,

I also like what you’ve done. I will add some edits there. 

Personally, I think the “Benefits” section is pointless; this page is about the 
migration from Quicken—not why someone should use GnuCash. I would recommend 
deleting it altogether, but I defer to you, since you created it.

You mention multi-currency problems with QIF, saying that GnuCash only handles 
one currency per file. However, I am under the impression that the problem of 
multiple currencies had to do with the *QIF* specification, and not GnuCash. In 
other words, the problem isn't that GnuCash doesn’t handle multiple currencies, 
it’s that QIF doesn’t. Can anyone confirm that for me?

Cheers,
David

> On Apr 3, 2018, at 5:15 PM, David Carlson  wrote:
> 
> cicko,
> 
> A very nice start.
> 
> I would add that those with large data files extending back several years
> should consider:
> 
> 1. not importing all of it.
> 
> 2. if you want to import it all, break down your export QIF process to one
> asset or liability account at a time and for limited time intervals such as
> one year at a time.
> 
> The one account at a time procedure makes it possible for GnuCash to detect
> most transfers between accounts so they are not duplicated during the
> import.  I would recommend that to all users.
> 
> I think that split memos are still not imported as of recent GnuCash
> releases up to 2.6.17 or so, but do not quote me on that.  I have not tried
> it recently.
> 
> David C
> 
> 
> 
> On Tue, Apr 3, 2018 at 5:02 AM, cicko  wrote:
> 
>> I have just copied the instructions from the FAQ page into a separate page
>> on
>> the GnuCash wiki, dedicated to Quicken migration:
>> 
>> https://wiki.gnucash.org/wiki/Quicken_Migration
>> 
>> This is a general hint to anyone considering or performing an actual
>> migration from Quicken to GnuCash, to consult the knowledge shared in this
>> page, try to apply it, and provide some feedback so that the instructions
>> can be improved over time.
>> 
>> 
>> 
>> --
>> 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.
>> 
> ___
> 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: Price Editor/Database lag

[DGPickett via gnucash-user]

I started vmstat -tw 11 in a wide xterm and I do see a lot of swap out for
some but not all delays.  The not-first delays seem to be smaller now.  The
first delay did 3K+ so, later ones did 2K+, 300+ or almost no so.  Almost no
so may indicate the container is not dealing well with the volume and
requests it gets, even when it has all the ram it desires.  Is the tree
keyed on category, symbol, date reverse like the display?

*First:*

$ vmstat -tw 11
procs ---memory-- ---swap--
-io -system-- cpu -timestamp-
 r  b swpd free buffcache   si   sobi   
bo   in   cs  us  sy  id  wa  st EDT
 5  0  2690184   14634026604   7888046   16   109  
123  117   16  70   9  20   1   0 2018-04-03 12:17:40
 6  1  2687992   12718426896   793168  2270   641  
164 2051 5894  88  12   0   0   0 2018-04-03 12:17:51
 5  2  2688552   28853226828   778192  173  151   694 
2167 2089 7312  78  18   3   0   0 2018-04-03 12:18:02
 5  0  2688400   26131627028   781584   260   329  
143 1798 6898  68  30   2   0   0 2018-04-03 12:18:13
 3  0  2685660   25796428028   791768  2140   486 
1114 2294 7585  48  33  16   2   0 2018-04-03 12:18:24
 2  0  2685636   24595228076   79159610 7  
139 2496 7604  30  37  32   1   0 2018-04-03 12:18:35
 1  0  2685272   23749628280   791948   32049  
267 3459 8448  31  22  46   1   0 2018-04-03 12:18:46
 0  0  2685244   17517628980   79343630   179  
134 3407 8631  44  13  42   2   0 2018-04-03 12:18:57
 0  0  2685204   21988429200   7931605019  
230 3655 8706  32  13  54   1   0 2018-04-03 12:19:08
 2  0  2685056   19353629260   812132   140  1700  
118 2710 8191  61  10  27   2   0 2018-04-03 12:19:19
 3  0  2685040   17945229312   81221620 2  
124 1875 8148  81   9  10   0   0 2018-04-03 12:19:30
 1  0  2722160   30416422520   721880   20 339531 
3555 2212 7960  78  10  11   0   0 2018-04-03 12:19:41
^C
*
Later:*

$ vmstat -tw 11
procs ---memory-- ---swap--
-io -system-- cpu -timestamp-
 r  b swpd free buffcache   si   sobi   
bo   in   cs  us  sy  id  wa  st EDT
 3  0  2721700   26362423340   7356886   16   109  
123  119   20  70   9  20   1   0 2018-04-03 12:20:23
 2  0  2721676   25974023392   73556420 3   
86 2907 8945  57  11  32   0   0 2018-04-03 12:20:34
 0  0  2721640   25654823476   7358483011  
185 3634 8735  37  13  49   1   0 2018-04-03 12:20:45
 1  0  2721616   25082023540   73583620 2  
253 3601 8358  30  12  57   1   0 2018-04-03 12:20:56
 6  0  2721604   25031623596   73573210 1  
140 2443 8143  70  10  20   0   0 2018-04-03 12:21:07
 6  0  2720948   24504423672   735940   66067  
128 1901 7925  80   9  11   0   0 2018-04-03 12:21:18
 1  0  2720932   23954823736   7366682059  
139 2719 8306  56  11  33   1   0 2018-04-03 12:21:29
 2  0  2744192   30570023672   6870841 2115 2 
2266 2686 8077  64  12  23   0   0 2018-04-03 12:21:40
 2  0  2744148   29758423760   68742850 7  
120 1975 8049  75  10  15   0   0 2018-04-03 12:21:51
 5  0  2744060   26157223852   689276   280   183  
111 3459 8838  36  17  45   2   0 2018-04-03 12:22:02
 5  0  2744048   28747223900   68919210 9  
306 3690 8710  32  13  54   1   0 2018-04-03 12:22:13
 1  0  2744008   28328823968   68931630 4  
220 2173 8488  65  12  23   1   0 2018-04-03 12:22:24
 3  0  2744004   27920424028   68926800 1  
110 1773 8291  74  10  16   0   0 2018-04-03 12:22:35
 3  0  2743988   27651224112   68901610 1  
216 2224 8250  68   9  23   1   0 2018-04-03 12:22:46
 5  1  2743188   26456424160   689260   980   115  
120 2628 8056  66   9  25   0   0 2018-04-03 12:22:57
 3  0  2743156   27505224208   68942820 2  
124 3673 8813  46  12  41   1   0 2018-04-03 12:23:08
 2  0  2743128   27145624284   68940420 2  
195 2569 8044  67  10  22   1   0 2018-04-03 12:23:19
 2  0  2743080   26514024336   68938870 8  
149 1651 8070  76   9  15   0   0 2018-04-03 12:23:30
 0  0  2743036   26003224388   68919240 4  
121 2802 8166  51 

Re: GNUCash 3.0 crashes on load

[John Ralls]

> On Apr 3, 2018, at 7:05 AM, Joseph Vernice  wrote:
> 
> Gnucash crashes on opening an XML file (backup of my normally used mysql 
> file). Mysql file eventually loads after 10-15 minutes. It takes only 50 
> seconds with version 2.6.19
> 
> I have the following error in my gnucash log after 10+ minute loading of 
> mysql data file... :
> 
> WARN  Could not spawn perl: Failed to execute child process 
> (No such file or directory)
> 
> Any ideas?  Thank you!

This is Windows, right? That error is normal on Windows unless you've run the 
"Install Online Quotes" tool, as Windows systems don't normally have perl.

 On Windows, slow loading of SQL is 
https://bugzilla.gnome.org/show_bug.cgi?id=792105, though do note that on the 
first load there are a couple of data conversions that can take quite a while 
on any machine. Crash on load of XML has several bugs:

https://bugzilla.gnome.org/show_bug.cgi?id=794934
https://bugzilla.gnome.org/show_bug.cgi?id=794933
https://bugzilla.gnome.org/show_bug.cgi?id=793768
https://bugzilla.gnome.org/show_bug.cgi?id=782144

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: Fast reactions to 2.7.8

[Adrien Monteleone]

Now that I’ve got 3.0 properly up and running, I see the Save and Close buttons 
have labels on the right side, but no others do.

Regards,
Adrien

> On Mar 31, 2018, at 10:25 AM, Adrien Monteleone  
> wrote:
> 
> That’s certainly a thorough run-down on changing themes.
> 
> But is there a way to edit a theme to make the button label visible? I see 
> one could download a theme and go through all that trouble, only to find out 
> the theme is hiding the labels. That could turn into quite a trial and error 
> process and certainly result in having to choose a less desirable theme, just 
> to have a label on a button.
> 
> On that note, is having a label on a button not done in the UI code? Looking 
> at the button reference I see each one would need both an icon and a label or 
> mnemonic label. I suppose the theme could choose or not to show the label, 
> but it would have to be programmed in first. If all of those toolbar buttons 
> are icons only...
> 
> (sorry, I haven’t taken a look at the code yet)
> 
> I would then suspect that in order for GnuCash to offer a toggle, it would 
> have to at the least, branch the code on that preference to display buttons 
> with or without labels, and then the question, “Are the labels are visible?” 
> would depend on the user’s GTK theme. It appears the GTK devs either didn’t 
> think this one through, or they are trying to enforce a certain look. Or 
> maybe they can’t be made invisible by the theme at all, and this is entirely 
> decided in UI code.
> 
> Regards,
> Adrien
> 
>> On Mar 31, 2018, at 7:37 AM, Geert Janssens  
>> wrote:
>> 
>> Op dinsdag 27 maart 2018 18:44:38 CEST schreef Stan Brown:
>>> (1) Not a fan of the toolbar showing icons without words. I _hate_ an
>>> interface where you have to hover over every single icon until you can find
>>> the one you want.
>>> 
>>> Many programs offer "words only", "icons only", and "icons and words" as
>>> choices. I couldn't find anything like that. Please add it.
>>> 
>>> (2) At first I thought performance was horrendously slow, when I was
>>> entering transactions in the general ledger. Turns out the actual issue was
>>> that the Tab key, instead of advancing to the next field, just gave focus
>>> to the "Save" button at upper left. This was on windows 8, with Build ID:
>>> git 2.7.8+ (2018-03-25).
>> 
>> A more general note. I have done some experimentation about what can be done 
>> to tweak the gnucash user interface in the absence of the Theme selector we 
>> used to have for gnucash 2.x (that was removed from gtk for gtk3, not 
>> something gnucash had any say in).
>> 
>> It turns out that apart from really starting to customize css settings one 
>> can 
>> also install custom themes. It's still a bit of manual work but it's much 
>> less 
>> complicated than looking for individual settings. What follows can be used 
>> as 
>> a basis to document this on the gui tweak wiki page.
>> 
>> Note this custom theme will affect all gtk3 based applications on your 
>> system!
>> 
>> Short summary:
>> 1. Download an appropriate gtk3 theme from www.gnome-look.org
>> 2. Install the theme in a directory where gtk3 looks for themes
>> 3. create or adjust a settings.ini file to tell gtk3 to use this theme
>> 
>> Slightly longer with platform dependent remarks:
>> 
>> 
>> 1. Go to the gnome-look.org website
>> 2. Click the "Gtk3 Themes" link (*not* the Gtk2 one)
>> 3. Select a theme you like
>> Alternatively you can search for keywords (like "dark") in the top right 
>> corner and then filter on "Gtk3 Theme category"
>> 4. If you have found a theme you like, download the proper file (in the 
>> files 
>> section of the theme page).
>> 
>> Note depending on your operating system you may not be able to open all 
>> theme 
>> files. I have seen for example .deb archives which are specifically targeted 
>> at the Debian linux distribution and derivates such as Ubuntu. While Ubuntu 
>> and Debian users can install those themes via their package manager these 
>> themes are not useful for other platforms.
>> Theme files ending with .zip, .tar.gz or tar.xz are likely installable on 
>> all 
>> platforms, although you may have to find a proper application to extract 
>> them. 
>> On Windows 7-Zip is a good candiate,  linux users can probably extract the 
>> files directly from their file manager.
>> 
>> So...
>> Let's take the theme "Eye-friendly Dark RBC" as an example (it's not the 
>> best 
>> theme but it can serve as an example). The file to download is "Eye-friendly-
>> Dark-RBC.tar.gz"
>> 
>> 5. Extract this file using an appropriate tool. This  should give you a 
>> directory named "Eye-friendly-Dark-RBC"
>> 
>> 6. Move this directory to a location on your system that's parsed by gtk. 
>> This 
>> is platform dependent:
>> - Linux: $HOME/.local/share/themes/
>> - OS X: Here I'm not sure. Possibly
>>   $HOME/.local/share/themes/ (like on linux)
>> or  $HOME/Library/Application Support/themes/
>> I suspect the firs

Re: gnucash 3.0 crashes opening accounts file

[John Ralls]

> On Apr 3, 2018, at 7:20 AM, pjlbyrne  wrote:
> 
> Huh, the VB script to install gnucash devenv on windows fails silently, and
> the wiki web registration has a broken captcha link - problems problems
> problems!

The VB script isn't very good at error messages and can be frustrating to get 
right. Fortunately it's for the old Mings-classic environment for 2.6.x and 
before. You don't really want to use that.

Instead, run mingw64-setup.ps1 with administrator privs. That sets up the 
Mingw-w64 environment we use to build GnuCash-3.x.

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: gnucash 3.0 crashes opening accounts file

[John Ralls]

> On Apr 3, 2018, at 7:24 AM, pjlbyrne  wrote:
> 
> It would be useful if debug builds were available on the automated build
> server. Then I could download it, run it get the crash and boot up visual
> studio to get stacktrace etc.

No you couldn't. GnuCash is built with gcc in a Mingw-w64 environment. gcc 
generates DWARF symbols that Visual Studio doesn't understand.

Nice thought, though.

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: GnuCash 3.0 Released

[Adrien Monteleone]

I want to add my thanks here to the devs for their hard work and patience with 
the rest of us as we stumble through the hiccups and quirks of a new version.

I see a new feature has creeped in and I like it.

Now, on startup, you not only get a Bills Due Reminder window, but also an 
Invoices Due Reminder - very handy, Thanks!

Regards,
Adrien

> On Apr 3, 2018, at 3:49 AM, Alen Siljak  wrote:
> 
> Congratulations on that big milestone!
> And thank you for all the time and effort that went into this application.
> 
>> Sent: Monday, April 02, 2018 at 10:17 PM
>> From: "John Ralls" 
>> To: Gnucash-User 
>> Cc: gnucash-devel , gnucash-annou...@gnucash.org
>> Subject: GnuCash 3.0 Released
>> 
>> GnuCash 3.0 released
>> 
> ___
> 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: Billing credit card charges to customers

[Adrien Monteleone]

If you mean by automatically, no there is not a way.

You’ll have to manually add those charges as line items to your invoices.

Check Bugzilla and if you don’t see it in the list, file an enhancement request 
(abbreviated RFE) for this.

Ideally, this should also be possible with any split so that you can flag the 
split or transaction to be on a ‘re-billable’ list that you can then choose 
from when making an invoice.

Regards,
Adrien

> On Apr 2, 2018, at 11:18 AM, VN Alexander  wrote:
> 
> When I'm recording my credit card charge statements in GnuCash is there a way 
> to make individual purchases show up on customer invoices?
> 
> ___
> 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: What does your Summary Bar say in Gnucash-3.0? Mine is rude

[Adrien Monteleone]

Mine is polite. It shows the same thing it showed in 2.6.19. This is on MacOS 
High Sierra.

Regards,
Adrien

> On Apr 2, 2018, at 9:52 PM, Dave H  wrote:
> 
> Hi lj, on Windows 10 mine says "$, Grand Total:
> Net Assets: $999,999.99
> Profits: $99,999.99".
> 
> I'll have to compare with my MacOS/Windows versions at home to see if they
> are different.  Not sure what the Grand Total is supposed to be and whether
> it's alwys been blank as I don't usually pay much attention to this line :-)
> 
> Cheers Dave H.
> 
> 
> 
> On 3 April 2018 at 12:10, lj  wrote:
> 
>> Using: gnucash-3.0 on 32-bit Slackware Linux 14.2; Gtk+3-3.18.9
>> 
>> When viewing the accounts tree, my summary bar at the bottom displays
>> this, exactly:
>>$:  Net Ass Profits:
>> 
>> On 2.6.x it displays "$:  Net Assets: (number)   Profits: (number)
>> Obviously something is getting truncated for me at 3.0, in a bad way.
>> 
>> If I click on the summary bar, it reverses colors, and changes to the
>> expected text with Net Assets and Profits. As soon as I click anywhere
>> else, it goes back to that "Net Ass Profits". (It seems to be acting like
>> it is a pull-down menu but with only 1 option. 2.6.x had 2 options there.)
>> 
>> Is anyone else seeing this?
>> 
>> ___
>> 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.

___
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: No Suitable Backend Found - sqlite3 on High Sierra

[Adrien Monteleone]

For posterity, this is solved by following John’s instructions from comment 1 
in bug 794933: https://bugzilla.gnome.org/show_bug.cgi?id=794933

Regards,
Adrien

> On Apr 2, 2018, at 11:45 PM, Adrien Monteleone  
> wrote:
> 
> I was previously using 2.6.19 with sqlite3 backend.
> 
> I downloaded 3.0 dmg from the git link.
> 
> Closed GnuCash 2.6.19, replaced it with 3.0, fired it up and got the “No 
> Suitable Backend” error.
> 
> No changes have been made to my sqlite installation in between.
> 
> I also tried File > Open, but the only format option given is ‘file’ and the 
> error is the same.
> 
> Yes, the file is a proper .gnucash file and was open just moments before by 
> 2.6.19.
> 
> I tried the download from SourceForge with the same result. Both files were 
> verified with the supplied hashes.
> 
> Any ideas?
> 
> Regards,
> Adrien
> 

___
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: Transferring data from Quicken Home and Business 2007

[Ken Schneider]

On 04/03/2018 06:14 AM, cicko wrote:

Hi, Paul,

While this may not directly and completely answer your question, there is
now a wiki page dedicated to this topic:

https://wiki.gnucash.org/wiki/Quicken_Migration



The only change I would suggest is to export just your category list 
(you can limit this to just the categories you use), no data, from 
Quicken and import the qif file to create your 'account tree'. You may 
need to edit your primary accounts as to why type they are. After this 
you can export/import your data one account at a time.
I'm not a long time user of GC but this is what helped me to migrate all 
of my Quicken data.


HTH

Ken
___
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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

It would be useful if debug builds were available on the automated build
server. Then I could download it, run it get the crash and boot up visual
studio to get stacktrace etc.



--
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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

Huh, the VB script to install gnucash devenv on windows fails silently, and
the wiki web registration has a broken captcha link - problems problems
problems!



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

Texhad an issue compiling for PCLinuxos....

[Doug]

Offline Tex

Administrator
Super Villain
**
Posts: 18933
Space City, Tx
View Profile Personal Message (Offline) 

Re: GnuCash
« Reply #2 on: Today at 01:28:20 AM »

Quote

I've spent hours on this and this is what it gives me even though the library 
is installed in /usr/lib64/gnucash. I'm tired of it for now.

[tex@localhost SPECS]$ gnucash
gnucash: error while loading shared libraries: libgncmod-gnome-utils.so: cannot 
open shared object file: No such file or directory
(end)

Can anyone help me point Tex in the right direction please? (I will forward it 
to PCLibuxOS)

regards, Doug (not a developer! merely an intermediary...)
___
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: GnuCash 3.0 Released QFX Import problem

[John Ralls]

> On Apr 3, 2018, at 6:46 AM, stdenis0--- via gnucash-user 
>  wrote:
> 
> I tried to import two QFX files into Gnucash 3, I know that some
> transactions were not entered into Gnucash 3  so they should have been
> listed but in both imports I got a blank screen. 
> 

Sounds like https://bugzilla.gnome.org/show_bug.cgi?id=793461 
.

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 3.0 crashes on load

[Joseph Vernice]

Gnucash crashes on opening an XML file (backup of my normally used mysql 
file). Mysql file eventually loads after 10-15 minutes. It takes only 50 
seconds with version 2.6.19


I have the following error in my gnucash log after 10+ minute loading of 
mysql data file... :


WARN  Could not spawn perl: Failed to execute child 
process (No such file or directory)


Any ideas?  Thank you!

___
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: Record Auto Insurance expense

[subscriptions]

On 04/02/2018 09:03 PM, David Carlson wrote:
Vendors is a business feature, and it is not recommended for 
non-business users.


It is usually easiest to open up your checking, credit card or cash 
account register to enter all the transactions for each of those 
accounts.  Then enter a transaction with a transfer to 
Expense:Auto:Insurance or whatever account name that you want to use, 
creating new accounts when you want to.


Have fun.

David C

On Mon, Apr 2, 2018 at 5:44 PM, subscriptions 
> wrote:


How do you actually record a auto insurance expense? Do you just
go to expense accounts / Auto / Fees and enter it there and do a
transfer from Checking account or would you create a Vendor
(GEICO) and then a bill?

Kinda a novice at this.

jdegraw

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



Thank you. I did exactly that. :)

Accounting has always been my weak spot. I m moving from quickbooks to 
GNUC as it actually looks simpler to me and less confusing then QBs. 
Seems in QBs you dont get such a clear picture of what its doing in the 
background. Especially when you run into a balance problem. With GNUC I 
can quickly find issues and correct them.


Thanks for the reply,

jdegraw

___
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: GnuCash 3.0 Released QFX Import problem

[stdenis0--- via gnucash-user]

I tried to import two QFX files into Gnucash 3, I know that some
transactions were not entered into Gnucash 3  so they should have been
listed but in both imports I got a blank screen. 

Joe St. Denis

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: GnuCash 3.0 Released

[John Ralls]

Please use the list. Do not email developers directly.

Regards,
John Ralls

> On Apr 3, 2018, at 1:58 AM, Peter Jackson  wrote:
> 
> Gnucash 3.0 will not load on Windows 10 version 1709. I have reverted to 
> 2.6.19
> 
> Peter
> 
> 
> Nurton Court
> Middleton-on-the-Hill
> Ludlow SY8 4BD
> Tel: 01568 750 248 Mob: 07955 586 476
> 
> On 3 April 2018 at 04:54, John Ralls  > wrote:
> 
> 
> > On Apr 2, 2018, at 8:13 PM, William Jackson  > > wrote:
> >
> >>MySQL and SQLite3 date storage has changed a bit. Once converted, MySQL 
> >> and SQLite3 database will be loadable only by GnuCash 2.6.19 and later.
> >
> > Was PostgreSQL omitted from this statement accidentally, or do the
> > changes not apply to that database backend?
> 
> The changes don’t apply to Postgresql.
> 
> 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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

Also, an 'ESIG.log' file is written to in C:\ at the time that gnucash
crashes. It is in binary format. I can't find any info about it on the
interwebs. Anyone know what kind of beast it is?
CP



--
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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

Okay - I might just build a debug version myself and run it up in Visual
Studio - I don't know how much effort that is from cold, though I see from a
quick shufti that the build requires 'mingw support scripts' - which doesn't
inspire me with much confidence :-(

P




--
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: gnucash 3.0 crashes opening accounts file

[David Carlson]

Actually, whatever references there may be to earlier 2.6.whatever releases
would just be for historical completeness at this point.  The version that
needs to be fixed is 3.0 and the cause may have different symptoms with
different data files or on different computers with different histories of
previously installed versions of GnuCash.  In fact, being installed over a
previous version of GnuCash may be the key thing to trigger the bug.  Keep
reporting whatever you see with 3.0

David C

On Tue, Apr 3, 2018 at 7:44 AM, pjlbyrne  wrote:

> I am not convinced that the issues reported in that bug are the same as
> what
> I reported. Also: they apply to older versions of gnucash, and I have only
> seen this issue with version 3.0. I have been using gnucash for years on
> both windows and (debian) linux with no problems.
>
> Cheers
> Patrick
>
>
>
>
> --
> 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.
>
___
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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

I am not convinced that the issues reported in that bug are the same as what
I reported. Also: they apply to older versions of gnucash, and I have only
seen this issue with version 3.0. I have been using gnucash for years on
both windows and (debian) linux with no problems.

Cheers
Patrick




--
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: gnucash 3.0 crashes opening accounts file

[pjlbyrne]

OK - thanks David!

Patrick



--
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: 2.7.8 fails to find environment file

[lj]

John Ralls wrote:

By the way, why does 3.0 start up with:
"This is a development version. It may or may not work."


Did you build 3.0 from a git checkout or from a tarball? It’s only supposed to 
print that message when you build from git...


Built from tarball downloaded from Sourceforge.

___
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: gnucash 3.0 crashes opening accounts file

[David Carlson]

P,

it seems that a few windows users are having similar crashes or slow
starts.  There is an earlier thread abut this that refers to GnuCash bug
792105.  The developers are currently gathering input to figure out what is
happening.

David C

On Tue, Apr 3, 2018 at 5:26 AM, pjlbyrne  wrote:

> Hi,
>
> I just downloaded and installed gnucash 3.0 on my Windows 7 machine. When I
> start it the app window comes up, but after I select the accounts file in
> the file open dialog I get this error dialog.
>
> 
>
> Any ideas?
>
> Cheers - P
>
>
>
>
>
> --
> 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.
>
___
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: Importing Quicken

[David Carlson]

cicko,

A very nice start.

I would add that those with large data files extending back several years
should consider:

1. not importing all of it.

2. if you want to import it all, break down your export QIF process to one
asset or liability account at a time and for limited time intervals such as
one year at a time.

The one account at a time procedure makes it possible for GnuCash to detect
most transfers between accounts so they are not duplicated during the
import.  I would recommend that to all users.

I think that split memos are still not imported as of recent GnuCash
releases up to 2.6.17 or so, but do not quote me on that.  I have not tried
it recently.

David C



On Tue, Apr 3, 2018 at 5:02 AM, cicko  wrote:

> I have just copied the instructions from the FAQ page into a separate page
> on
> the GnuCash wiki, dedicated to Quicken migration:
>
> https://wiki.gnucash.org/wiki/Quicken_Migration
>
> This is a general hint to anyone considering or performing an actual
> migration from Quicken to GnuCash, to consult the knowledge shared in this
> page, try to apply it, and provide some feedback so that the instructions
> can be improved over time.
>
>
>
> --
> 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.
>
___
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: Finance::Quote Yahoo_JSON Alpha Vantage

[Les]

Thanks Chris!  All good now (except for currencies not completing), but 
can live with it.


Les
On 04/03/2018 03:59 AM, Chris Good wrote:

-Original Message-

 From Chris Good:
...

Hi Les,

Sorry you had problems following my instructions.

The quickest way to reinstall the standard files over the modified files is:
  From a command prompt (Windows) or Terminal (Linux):
cpan
install Finance::Quote
quit

However, if you wish to tell me what your operating system is, and try
to run the gnc-fq-helper command as per
https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_fix_a_.22system_error.22
_or_.2 2unknown_error.22_when_getting_stock_quotes.3F
and tell me the response, I will try to help you.

I.e.
Windows from a command prompt:
cd \Program Files\gnucash\bin
echo (yahoo "CSCO") | perl gnc-fq-helper

Linux, from a terminal:
echo '(yahoo "CSCO")' | gnc-fq-helper

Regards, Chris Good


From: Les 
Sent: Tuesday, 3 April 2018 6:10 PM
To: Chris Good ; gnucash-user@gnucash.org
Subject: Re: Finance::Quote Yahoo_JSON Alpha Vantage

Sorry, Chris.  I should have mentioned the OS, etc.  I am running Linux Mint 
18.2
and GC 2.6.17.

If I understand, all I have to to do is reinstall F::Q?

Thanks,
Les

Hi Les,

Yes reinstall Finance::Quote using the method I said.

Regards, Chris Good



___
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 3.0 crashes opening accounts file

[pjlbyrne]

Hi,

I just downloaded and installed gnucash 3.0 on my Windows 7 machine. When I
start it the app window comes up, but after I select the accounts file in
the file open dialog I get this error dialog.

 

Any ideas?

Cheers - P





--
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: No suitable back-end

[cicko]

I just experienced this message so I'll share the scenario. Not sure if this
should be reported as a bug (it could).

Windows, GC 3.0, XML backend.
- Using Save As option
- select an existing file (book.sql.gnucash)
- leave backend on xml (accidentally)
- click Save As

The reported message pops up.

When using sqlite3 data format option, correcting the selection, the error
message is "The server at URL Z:\... experienced an error or encountered bad
or corrupt data".



--
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: Transferring data from Quicken Home and Business 2007

[cicko]

Hi, Paul,

While this may not directly and completely answer your question, there is
now a wiki page dedicated to this topic:

https://wiki.gnucash.org/wiki/Quicken_Migration

I am in the same boat as you and I have (so far) converted only the current
financial year to GnuCash so that I can run the tax reports off these. 
However, I would definitely like to migrate the whole book (some 20 years of
data, I think) just for the sake of being able to access it in the future.
Quicken tends to get old and my original file might not be accessible after
the next Windows update or something similar. I like the fact that, with
GnuCash, all my data can be stored in an sqlite database, which can easily
be read in many other ways.
In any case, any hints and tips for transition will hopefully be assembled
on the wiki page and assist people going through the same process.



--
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: Importing Quicken

[cicko]

I have just copied the instructions from the FAQ page into a separate page on
the GnuCash wiki, dedicated to Quicken migration:

https://wiki.gnucash.org/wiki/Quicken_Migration

This is a general hint to anyone considering or performing an actual
migration from Quicken to GnuCash, to consult the knowledge shared in this
page, try to apply it, and provide some feedback so that the instructions
can be improved over time.



--
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: Gnucash 3.0 release crashes during loading

[cicko]

Guys, you might be affected by this

https://bugzilla.gnome.org/show_bug.cgi?id=792105

So, just see if you have the same symptoms and, if so, follow the progress
on the issue of slow loading and contribute some new facts.
This issue currently affects sqlite (in some cases?) and that may or may not
be your case.
John has already reported that improvements are being made in loading of
slots and splits (if I remember well), as well as other optimizations, which
should improve the situation.



--
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: Finance::Quote Yahoo_JSON Alpha Vantage

[Chris Good]

> -Original Message-
>From Chris Good:
...
> > Hi Les,
> >
> > Sorry you had problems following my instructions.
> >
> > The quickest way to reinstall the standard files over the modified files is:
> >  From a command prompt (Windows) or Terminal (Linux):
> > cpan
> > install Finance::Quote
> > quit
> >
> > However, if you wish to tell me what your operating system is, and try
> > to run the gnc-fq-helper command as per
> > https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_fix_a_.22system_error.22
> > _or_.2 2unknown_error.22_when_getting_stock_quotes.3F
> > and tell me the response, I will try to help you.
> >
> > I.e.
> > Windows from a command prompt:
> > cd \Program Files\gnucash\bin
> > echo (yahoo "CSCO") | perl gnc-fq-helper
> >
> > Linux, from a terminal:
> > echo '(yahoo "CSCO")' | gnc-fq-helper
> >
> > Regards, Chris Good
> >
> From: Les 
> Sent: Tuesday, 3 April 2018 6:10 PM
> To: Chris Good ; gnucash-user@gnucash.org
> Subject: Re: Finance::Quote Yahoo_JSON Alpha Vantage
> 
> Sorry, Chris.  I should have mentioned the OS, etc.  I am running Linux Mint 
> 18.2
> and GC 2.6.17.
> 
> If I understand, all I have to to do is reinstall F::Q?
> 
> Thanks,
> Les

Hi Les,

Yes reinstall Finance::Quote using the method I said.

Regards, Chris Good

___
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: GnuCash 3.0 Released

[Alen Siljak]

Congratulations on that big milestone!
And thank you for all the time and effort that went into this application.

> Sent: Monday, April 02, 2018 at 10:17 PM
> From: "John Ralls" 
> To: Gnucash-User 
> Cc: gnucash-devel , gnucash-annou...@gnucash.org
> Subject: GnuCash 3.0 Released
>
> GnuCash 3.0 released
> 
___
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: Gnucash 3.0 release crashes during loading

[randix]

Got it, thanks.

Wonder what the issue is with 3.0, at least for you and me. Oh well, I'll
wait a while before trying again...



--
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: Gnucash 3.0 release crashes during loading

[Chen Thomas]

>From the directory of gnucash (stable).

It is there.

-Original Message-
From: gnucash-user  On 
Behalf Of randix
Sent: Tuesday, April 3, 2018 4:16 PM
To: gnucash-user@gnucash.org
Subject: RE: Gnucash 3.0 release crashes during loading

2.6.20???  I thought 2.6.19 was the last stable before 3.0 (which I've 
uninstalled).  Where did you find it to download?



--
Sent from: 
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucash.1415818.n4.nabble.com%2FGnuCash-User-f1415819.html&data=02%7C01%7C%7C72e1851292ca44643c5f08d5993b454e%7C84df9e7fe9f640afb435%7C1%7C0%7C636583402191321434&sdata=kw0ydprdGE6izBMYB6b1Mer%2FQQsexyvT4XbrIAumsR0%3D&reserved=0
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C72e1851292ca44643c5f08d5993b454e%7C84df9e7fe9f640afb435%7C1%7C0%7C636583402191321434&sdata=Hfmvt6qezXmbMC1aL6sEm8h%2FdCPqEuLKAodh%2Fo%2Fc5gE%3D&reserved=0
If you are using Nabble or Gmane, please see 
https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C72e1851292ca44643c5f08d5993b454e%7C84df9e7fe9f640afb435%7C1%7C0%7C636583402191321434&sdata=fLUkhRhsBHP5fmwuYDMjpkogAqcMLPHqWv8VKvTYLkg%3D&reserved=0
 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: Gnucash 3.0 release crashes during loading

[randix]

2.6.20???  I thought 2.6.19 was the last stable before 3.0 (which I've
uninstalled).  Where did you find it to download?



--
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: Finance::Quote Yahoo_JSON Alpha Vantage

[Les]

Sorry, Chris.  I should have mentioned the OS, etc.  I am running Linux 
Mint 18.2 and GC 2.6.17.


If I understand, all I have to to do is reinstall F::Q?

Thanks,
Les
On 04/02/2018 07:00 PM, Chris Good wrote:

Message: 5
Date: Mon, 2 Apr 2018 17:59:28 -0500
From: Les 
To: gnucash-user@gnucash.org
Subject: Re: Finance::Quote Yahoo_JSON Alpha Vantage
Message-ID: <2fde53e2-985e-0030-9b87-68b6f5f0f...@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed

I followed the instructions on adding modes for quote.pm and
alphavantage.pm as described.? However, I am no longer able to update
any my stocks now.? I have obviously done something wrong. Is there any
way to undo these modes and revert back to my previous files?

Thanks.

Les

On 04/01/2018 08:51 PM, Chris Good wrote:

Hi,

I have no problems using Yahoo_JSON as a quote source for my 16 stocks

for

which I download prices only weekly.

However, I have been working with another user and it seems Yahoo_JSON

fails

when there are many stocks and/or prices for them are requested often.



I suggest people who run into Yahoo _JSON problems use Alpha Vantage as

the

quote source.

See


https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3
F



Alpha Vantage purposefully fails quote requests if it detects a user

hogging

their web server resources by returning an Information message that

says:

Please consider optimizing your API call frequency

and pausing for approx. 20 seconds.



If you use Alpha Vantage, there have been mods made to Finance::Quote so
that usage complies with the Alpha Vantage recommendations that only 1

price

request per second is made in order to ensure that the webserver

resources

are shared amongst all users.



If the information message is detected for a particular stock (or

currency

conversion thanks Mike Alexander), then Finance::Quote also pauses for

20

seconds, then retries up to 4 times.

As this means you should not have to retry getting prices for all stocks

or

currencies if you have a failure, and this will minimise usage of the

Alpha

Vantage web server, I suggest people install the modified perl programs.



The modified Finance::Quote perl programs are currently not yet

incorporated

into the latest version of Finance::Quote (1.47), and as the

Finance::Quote

maintainers are, like everyone else, busy, it may be a long time (it has
been over a year in the past) before these mods are included in the next
release of Finance::Quote.



To install these mods without waiting for them to be incorporated in
Finance::Quote:



1. Make sure the standard Quote.pm and AlphaVantage.pm files are

writable.



For Windows 10 these files are usually:

C:\strawberry\perl\site\lib\Finance\Quote.pm

C:\strawberry\perl\site\lib\Finance\Quote\AlphaVantage.pm

Using File Manager, right click on the file, Properties, Untick 'Read

Only',

then OK



For Ubuntu Linux, these files are usually:

/usr/local/share/perl/5.22.1/Finance/Quote.pm

/usr/local/share/perl/5.22.1/Finance/Quote/AlphaVantage.pm

  From a terminal:

cd /usr/local/share/perl/5.22.1/Finance

sudo chmod 666 Quote.pm Quote/AlphaVantage.pm



2. To install the modified Quote.pm:

Open
https://raw.githubusercontent.com/mtalexander/finance-

quote/6ee43ea08b504617

142139fda41ae45be865fa38/lib/Finance/Quote.pm

in a browser, click in the code, then  use Control-A to highlight it

all,

then paste it into a text editor

(say Notepad for Windows, or gedit for Linux), then 'Save As' over the

top

of the existing
Quote.pm.



3. To install the modified AlphaVantage.pm:

Open
https://github.com/mtalexander/finance-

quote/blob/6ee43ea08b504617142139fda4

1ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm



in a browser, click in the code, then  use Control-A to highlight it

all,

then paste it into a text editor

(say Notepad for Windows, or gedit for Linux), then 'Save As' over the

top

of the existing
AlphaVantage.pm.




Sorry, I don't have a Mac so I cannot provide instructions.



If you want to check on the progress of the Pull Request to incorporate
these changes in Finance::Quote, please see:

https://github.com/finance-quote/finance-quote/pull/85

Regards, Chris Good

Hi Les,

Sorry you had problems following my instructions.

The quickest way to reinstall the standard files over the modified files is:
 From a command prompt (Windows) or Terminal (Linux):
cpan
install Finance::Quote
quit

However, if you wish to tell me what your operating system is, and try to
run the gnc-fq-helper command as per
https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_fix_a_.22system_error.22_or_.2
2unknown_error.22_when_getting_stock_quotes.3F
and tell me the response, I will try to help you.

I.e.
Windows from a command prompt:
cd \Program Files\gnucash\bin
echo (yahoo "CSCO") | perl gnc-fq-helper

Linux, from a terminal:
echo '(yahoo "CSCO")' | gnc-fq-helper

Regards, Chris Good



___
gnucash-user mailing list

Re: ver 3.0 reports running faster

[John Walker]

I want to endorse Dave E.  I have been watching people's comments with 
great interest.  On my W10 machine, Windows Defender merely commented 
that the setup package did not come from a trusted source.


I trust the GNU people but just to be sure used 'MD5 and SHA Checksum 
Utility' and compared it to the provided value towards the last third of 
the original release announcement.  All good.


Startup of GNUCash is now considerably faster.  Reports are lightning 
fast.  These to me are the most significant changes.


No rude descriptions in the Accounts register summary although I did 
have to rearrange the window so I could read everything in each column - 
a once only exercise in exchange for clearer type and better contrasts.


My only (small) criticism is that some of the icons have colours which 
make them look ghosted instead of just being light colours.


A question:  when one opens the 'Edit Report Options' window, is there a 
way to make the default window longer so that more accounts show when 
the accounts tab is shown?


Once again, congratulations for all the hard work you have done.

John W
On 3/04/2018 5:22 PM, Dave via gnucash-user wrote:

Thanks to those who worked so hard!

  


The program seems to run faster now, especially when making reports.

  


OS Windows 10

  


Dave E.

___
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: Gnucash 3.0 release crashes during loading

[Chen Thomas]

I have the same issue when I upgraded it to 3.0 from 2.6.19. 

After I opened 3.0, the initial screen opened, then nothing happened.

Now I downgraded it to 2.6.20.

OS: Windows 10 Pro (up to date)

Thanks,
thomas

-Original Message-
From: gnucash-user  On 
Behalf Of randix
Sent: Tuesday, April 3, 2018 8:48 AM
To: gnucash-user@gnucash.org
Subject: Re: Gnucash 3.0 release crashes during loading

I'm running Windows 10.  Just downloaded 3.0 and tried to install it twice. 
Each time after the install, I click to run the program and it does...
nothing.  Even if I try and run it as an administrator.



--
Sent from: 
https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucash.1415818.n4.nabble.com%2FGnuCash-User-f1415819.html&data=02%7C01%7C%7C13fa56180b5946378a4208d598fca957%7C84df9e7fe9f640afb435%7C1%7C0%7C636583133287432277&sdata=Won0Zx1unxD2QXuVTGJtBNQnavj7ALSB28KhYSe%2FjCA%3D&reserved=0
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C13fa56180b5946378a4208d598fca957%7C84df9e7fe9f640afb435%7C1%7C0%7C636583133287432277&sdata=7sdDlx4wbTytC9Aqv1PRYHwkjpTF0yhnLWIv8BxECl8%3D&reserved=0
If you are using Nabble or Gmane, please see 
https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C13fa56180b5946378a4208d598fca957%7C84df9e7fe9f640afb435%7C1%7C0%7C636583133287432277&sdata=80xX4pr1tJPcrME83FKEhU%2BiPXz5OwcQ22DYtxFIBjo%3D&reserved=0
 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.

ver 3.0 reports running faster

[Dave via gnucash-user]

Thanks to those who worked so hard!

 

The program seems to run faster now, especially when making reports.

 

OS Windows 10

 

Dave E.

___
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: MySQL Server connection timeout or keep-alive

[Colin Law]

On 2 April 2018 at 22:28, John Ralls  wrote:
>
>
>> On Apr 2, 2018, at 8:39 AM, Paul Neuwirth  wrote:
>>
>> Hello,
>> is it possible to change somewhere the connection timeout to a MySQL
>> server on the client side?
>> Or could it be possible to implement a keep-alive?
>> Everytime the connection is lost, I need to restart gnucash.
>
> I don't think that it's possible from the client. IIUC (and I'm not a MySQL 
> expert, but if you're using it you should be or you should hire one) it's a 
> server-side parameter called wait_timeout.
>
> No, we're not going to add a keep-alive. 
> https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
>  says that a connection pool is the right way to handle this, but the 
> database abstraction library we use doesn't support that so it's not going to 
> get added any time soon.

However if GnuCash fails in a non-recoverable way when you lose the
connection I would have thought that would be a bug.  What exact
symptom are you seeing?

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