Re: Running Reports over a Windows 10 Network

[mahon . finbar]

Yes, I found that the first time I tried to reconcile an a/c it hung for quite 
a while, to the point where I thought it had really hung. Advice on here said 
hang in there.

Works fine now. Using W10.

Barry

On March 31, 2018 9:24:32 AM GMT+02:00, "Maf. King"  wrote:
>On Friday, 30 March 2018 11:45:45 BST Alan Culpitt via gnucash-user
>wrote:
>> I am using GNUCash 2.6.19 on 2x Windows 10 PCs networked together to
>access
>> our joint financial information stored on my wife's computer.  We
>have a
>> number of saved reports.   If I try to run one of the saved reports
>it
>> takes a very long time to run, 10-15 minutes, the first time but then
>> subsequently if I run another report, it works fine. Any suggestions?
>> 
>
>
>Hi Alan,
>
>There have been previous posts about the first report taking ages to
>render on 
>Windows.  I don't use that OS and can't remember if there is a solution
>yet, 
>but I don't think it is related to your file being on a network share.
>
>Just thought I'd chime in to let you know that you are not alone!
>
>Maf.
>
>___
>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.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
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 not compiling with latest Archlinux updates

[Sanjay Chakravarty]

Dear All

After updating my Arch linux yesterday, gnucash started giving library 
load errors for libicui18n.so and libicuuc.so. It demands version 60 
whereas after Arch updates, I have version 61. I can bypass these errors 
by softlinking version 60 to 61. But after that I get an error that 
there is an undefined symbol ucol_setAttribute_60 in library 
/usr/lib/libjavascriptcoregtk-1.0.so.0.


I uninstalled gnucash and tried recompiling using AUR. (yaourt gnucash) 
I get the same error which I have reproduced below


gnc.module-WARNING **: 15:35:01.496: Failed to dlopen() 
'../../../../src/html/.libs/libgncmod-html.so': 
/usr/lib/libjavascriptcoregtk-1.0.so.0: undefined symbol: 
ucol_setAttribute_60


How can I get an updated gnucash for Arch at this point, or do I need to 
wait for 2.6.20 ?


Warm regards
Sanjay

___
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 not compiling with latest Archlinux updates

[Phil]

Hey Sanjay,

I ran into the same issue the other day. Reinstalling webkitgtk fixed my
issue.


Phil



On 04/02/2018 03:36 AM, Sanjay Chakravarty wrote:
> Dear All
>
> After updating my Arch linux yesterday, gnucash started giving library
> load errors for libicui18n.so and libicuuc.so. It demands version 60
> whereas after Arch updates, I have version 61. I can bypass these
> errors by softlinking version 60 to 61. But after that I get an error
> that there is an undefined symbol ucol_setAttribute_60 in library
> /usr/lib/libjavascriptcoregtk-1.0.so.0.
>
> I uninstalled gnucash and tried recompiling using AUR. (yaourt
> gnucash) I get the same error which I have reproduced below
>
> gnc.module-WARNING **: 15:35:01.496: Failed to dlopen()
> '../../../../src/html/.libs/libgncmod-html.so':
> /usr/lib/libjavascriptcoregtk-1.0.so.0: undefined symbol:
> ucol_setAttribute_60
>
> How can I get an updated gnucash for Arch at this point, or do I need
> to wait for 2.6.20 ?
>
> Warm regards
> Sanjay
>
> ___
> 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: Unrealized loss

[cageda]

De: "John Ralls"  
À: cag...@free.fr 
Cc: "gnucash-user"  
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction (or even a few ) on a particular day triggered an unrealized 
loss as big as my yearly income. 

What I would like at this stage is simply set GC NOT to SHOW unrealized 
losses/gains. No legal problem as I'm only managing my personal familyaccounts. 

TIA for you help 
Regards 
Alain 




___
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: Unrealized loss

[cageda]

De: cag...@free.fr 
À: "John Ralls"  
Cc: "gnucash-user"  
Envoyé: Lundi 2 Avril 2018 13:51:03 
Objet: Re: Unrealized loss 




De: "John Ralls"  
À: cag...@free.fr 
Cc: "gnucash-user"  
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction (or even a few ) on a particular day triggered an unrealized 
loss as big as my yearly income. 

What I would like at this stage is simply set GC NOT to SHOW unrealized 
losses/gains. No legal problem as I'm only managing my personal familyaccounts. 

TIA for you help 
Regards 
Alain 


I tried the following: 
C an equity account "Unrealized loss" : EUR 7.70 
D an income account "Realized loss" : EUR 7.70 
The total Equity remained the same - 7.70 
I changed the signs and the total equity remained at - 7.70 
I don't get it. 
TIA 
Alain 




___
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: Unrealized loss

[David T. via gnucash-user]

Alain,
Your new transaction is balanced, and won't affect the imbalance in another 
transaction. 
I personally find the unrealized gains issue to be exceedingly difficult to 
understand. Since you say you don't care about this, just ignore it. 
David T 
 
 
  On Mon, Apr 2, 2018 at 17:02, cag...@free.fr wrote:   


De: cag...@free.fr 
À: "John Ralls"  
Cc: "gnucash-user"  
Envoyé: Lundi 2 Avril 2018 13:51:03 
Objet: Re: Unrealized loss 




De: "John Ralls"  
À: cag...@free.fr 
Cc: "gnucash-user"  
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction (or even a few ) on a particular day triggered an unrealized 
loss as big as my yearly income. 

What I would like at this stage is simply set GC NOT to SHOW unrealized 
losses/gains. No legal problem as I'm only managing my personal familyaccounts. 

TIA for you help 
Regards 
Alain 


I tried the following: 
C an equity account "Unrealized loss" : EUR 7.70 
D an income account "Realized loss" : EUR 7.70 
The total Equity remained the same - 7.70 
I changed the signs and the total equity remained at - 7.70 
I don't get it. 
TIA 
Alain 




___
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

[John Ralls]

Other artifacts, certainly, but it would be an unusual computer that puts a 
network between its RAM and CPU.

Regards,
John Ralls


> On Apr 1, 2018, at 8:57 PM, David Carlson  wrote:
> 
> There could be other artifacts in the system such as network lags that may 
> also come into play.
> 
> David C 
> 
> On Sun, Apr 1, 2018, 10:12 PM John Ralls  > wrote:
> Entirely possible. I’m not too familiar with the GtkTreeList implementation.
> 
> Regards,
> John Ralls
> 
> 
> > On Apr 1, 2018, at 6:59 PM, David  > > wrote:
> >
> > John,
> >
> > OK, that makes sense, except the lag can occur pretty randomly as I select 
> > lists of symbols, select symbols from that list, ask for an add window, or 
> > work in the add window with date, price.  (I select the most recent month 
> > end nav so it is cloned with the add, just needs a new date and price.)  
> > Maybe it is going into thrashing?
> >
> > Thanks,
> >
> > David
> >
> >
> > -Original Message-
> > From: John Ralls mailto:jra...@ceridwen.us>>
> > To: David mailto:dgpick...@aol.com>>
> > Cc: Gnucash Users  > >
> > Sent: Sun, Apr 1, 2018 3:48 pm
> > Subject: Re: Price Editor/Database lag
> >
> > Please remember to copy the list on all replies.
> >
> > The data file is read exactly once, when it's loaded. After that everything 
> > is stored in GnuCash objects. That's what "all of the data is always in 
> > memory" means. We store data as either XML or in a SQL database, so mmap() 
> > won't do anything for us.
> >
> > The likely problem is that the Price Editor is based on a GtkTreeView, and 
> > its model needs to be loaded every time you open the Price Editor. We could 
> > indeed get a pretty big performance enhancement by hiding the Price Editor 
> > on close instead of destroying it.
> >
> > Yes, the price db could be kept apart from book data, but it isn't. That 
> > would be a pretty big design change, and I think better left until we're 
> > ready to change to query-as-needed database use as that will bring about a 
> > lot of incompatible storage changes.
> >
> > Regards,
> > John Ralls
> >
> > > On Apr 1, 2018, at 8:40 AM, David  > >   > > >> wrote:
> > >
> > > That is an OK excuse for one delay, not delay after delay not in sync 
> > > with any part of the edit process.
> > >
> > > It is a bug if it reloads the database, rather than keeping an in memory 
> > > and in file model that can be updated, and an in file model that only 
> > > gets updated at save time. Also, it should mmap64() the file, so it is 
> > > cached in RAM, not read from scratch. An unsorted flat file pretending to 
> > > be a database would outperform this.
> > >
> > > The price history might be kept outside the books files, as it is a cache 
> > > of public data, and can be shared with all if they use the same key 
> > > symbols, updated once for all sets of books!
> > >
> > >
> > >
> > > -Original Message-
> > > From: John Ralls mailto:jra...@ceridwen.us> 
> > > >>
> > > To: DGPickett mailto:dgpick...@aol.com> 
> > > >>
> > > Cc: gnucash-user  > >   > > >>
> > > Sent: Sun, Apr 1, 2018 9:39 am
> > > Subject: Re: Price Editor/Database lag
> > >
> > >
> > >
> > > > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> > > > mailto:gnucash-user@gnucash.org> 
> > > > >> wrote:
> > > >
> > > > Since I was collecting prices daily, I guess my price database is pretty
> > > > large, and my family finances are in there for about 5 years. I have xml
> > > > database, and compressed, but I checked my save intervals, even 
> > > > increased
> > > > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > > > drive, so anyy database should stay in memory.
> > >
> > > GnuCash isn’t yet a database application, so all of the data is always in 
> > > memory regardless of the backend. If the delay you experience is in 
> > > opening the price db dialog then it’s probably due to loading the 
> > > dialog’s tree model from the price db.
> > >
> > > 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-Li

Re: Price Editor/Database lag

[David via gnucash-user]

I just discovered my swap was all turned off.  It might also explain very un-VM 
messages like "Your computer does not have enough free memory to automatically 
analyze the problem and send a report to the developers."  Now I have a huge, 
dedicated drive SSD swap (which one article said was a bad idea, but maybe any 
churn wear will be more distributed on a huge (150G) swap).  Let me see if that 
helps!

Of course, I am also moving my price source to Yahoo_JSON.

 

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: gnucash-user 
Sent: Sun, Apr 1, 2018 11:09 pm
Subject: Re: Price Editor/Database lag


Entirely possible. I’m not too familiar with the GtkTreeList implementation.


Regards,
John Ralls




On Apr 1, 2018, at 6:59 PM, David  wrote:


John,

OK, that makes sense, except the lag can occur pretty randomly as I select 
lists of symbols, select symbols from that list, ask for an add window, or work 
in the add window with date, price.  (I select the most recent month end nav so 
it is cloned with the add, just needs a new date and price.)  Maybe it is going 
into thrashing?


 Thanks,

David

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: Gnucash Users 
Sent: Sun, Apr 1, 2018 3:48 pm
Subject: Re: Price Editor/Database lag

Please remember to copy the list on all replies.

The data file is read exactly once, when it's loaded. After that everything is 
stored in GnuCash objects. That's what "all of the data is always in memory" 
means. We store data as either XML or in a SQL database, so mmap() won't do 
anything for us.

The likely problem is that the Price Editor is based on a GtkTreeView, and its 
model needs to be loaded every time you open the Price Editor. We could indeed 
get a pretty big performance enhancement by hiding the Price Editor on close 
instead of destroying it.

Yes, the price db could be kept apart from book data, but it isn't. That would 
be a pretty big design change, and I think better left until we're ready to 
change to query-as-needed database use as that will bring about a lot of 
incompatible storage changes.

Regards,
John Ralls

> On Apr 1, 2018, at 8:40 AM, David  wrote:
> 
> That is an OK excuse for one delay, not delay after delay not in sync with 
> any part of the edit process.
> 
> It is a bug if it reloads the database, rather than keeping an in memory and 
> in file model that can be updated, and an in file model that only gets 
> updated at save time.  Also, it should mmap64() the file, so it is cached in 
> RAM, not read from scratch.  An unsorted flat file pretending to be a 
> database would outperform this.
> 
> The price history might be kept outside the books files, as it is a cache of 
> public data, and can be shared with all if they use the same key symbols, 
> updated once for all sets of books!
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: DGPickett 
> Cc: gnucash-user 
> Sent: Sun, Apr 1, 2018 9:39 am
> Subject: Re: Price Editor/Database lag
> 
> 
> 
> > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> >  wrote:
> > 
> > Since I was collecting prices daily, I guess my price database is pretty
> > large, and my family finances are in there for about 5 years. I have xml
> > database, and compressed, but I checked my save intervals, even increased
> > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > drive, so anyy database should stay in memory.
> 
> GnuCash isn’t yet a database application, so all of the data is always in 
> memory regardless of the backend. If the delay you experience is in opening 
> the price db dialog then it’s probably due to loading the dialog’s tree model 
> from the price db.
> 
> 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.

Version 3: Improved SQLite response?

[Tom Browder]

First let me say I have been a user of GNU Cash (on Windows) for many
years, and I greatly appreciate the efforts of all the developers.
Thank you all so much!

My question:

I tried SQLite early after it was considered usable by ordinary users,
but was disappointed to see that the response time (loading saved
views on start) on my large DB was not significantly different from
the flat file.  (To be fair, I didn't spend much time experimenting
because I didn't want to get out of sync with the flat file DB.)

Is there any specific SQLite improvement planned for Version 3?

Thanks.

Best regards,

-Tom
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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

[David via gnucash-user]

 PS: No, swap does not prevent this.

I did notice that it struck just once during the first symbol, and then not 
again until I did a null update, so maybe it trashes the in-memory object after 
every mod., and reinstates it from scratch.  But for that, I would expect the 
delay to be more synchronous in the cycle of actions.

 
An object that lived in a mmap'd file could be updated in place at RAM speeds, 
is potentially visible to many processes, yet even if the app crashes, is saved 
by the dirty page writer.  I have noticed that mmap() is one of the most 
neglected aspects of C/C++/JAVA/??? -- direct access to VM with memory objects 
visible to multiple processes by mmap() or file calls, access to all free RAM 
as your cache.

 

-Original Message-
From: David 
To: jralls 
Cc: gnucash-user 
Sent: Mon, Apr 2, 2018 11:30 am
Subject: Re: Price Editor/Database lag


I just discovered my swap was all turned off.  It might also explain very un-VM 
messages like "Your computer does not have enough free memory to automatically 
analyze the problem and send a report to the developers."  Now I have a huge, 
dedicated drive SSD swap (which one article said was a bad idea, but maybe any 
churn wear will be more distributed on a huge (150G) swap).  Let me see if that 
helps!

Of course, I am also moving my price source to Yahoo_JSON.

 

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: gnucash-user 
Sent: Sun, Apr 1, 2018 11:09 pm
Subject: Re: Price Editor/Database lag


Entirely possible. I’m not too familiar with the GtkTreeList implementation.


Regards,
John Ralls




On Apr 1, 2018, at 6:59 PM, David  wrote:


John,

OK, that makes sense, except the lag can occur pretty randomly as I select 
lists of symbols, select symbols from that list, ask for an add window, or work 
in the add window with date, price.  (I select the most recent month end nav so 
it is cloned with the add, just needs a new date and price.)  Maybe it is going 
into thrashing?


 Thanks,

David

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: Gnucash Users 
Sent: Sun, Apr 1, 2018 3:48 pm
Subject: Re: Price Editor/Database lag

Please remember to copy the list on all replies.

The data file is read exactly once, when it's loaded. After that everything is 
stored in GnuCash objects. That's what "all of the data is always in memory" 
means. We store data as either XML or in a SQL database, so mmap() won't do 
anything for us.

The likely problem is that the Price Editor is based on a GtkTreeView, and its 
model needs to be loaded every time you open the Price Editor. We could indeed 
get a pretty big performance enhancement by hiding the Price Editor on close 
instead of destroying it.

Yes, the price db could be kept apart from book data, but it isn't. That would 
be a pretty big design change, and I think better left until we're ready to 
change to query-as-needed database use as that will bring about a lot of 
incompatible storage changes.

Regards,
John Ralls

> On Apr 1, 2018, at 8:40 AM, David  wrote:
> 
> That is an OK excuse for one delay, not delay after delay not in sync with 
> any part of the edit process.
> 
> It is a bug if it reloads the database, rather than keeping an in memory and 
> in file model that can be updated, and an in file model that only gets 
> updated at save time.  Also, it should mmap64() the file, so it is cached in 
> RAM, not read from scratch.  An unsorted flat file pretending to be a 
> database would outperform this.
> 
> The price history might be kept outside the books files, as it is a cache of 
> public data, and can be shared with all if they use the same key symbols, 
> updated once for all sets of books!
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: DGPickett 
> Cc: gnucash-user 
> Sent: Sun, Apr 1, 2018 9:39 am
> Subject: Re: Price Editor/Database lag
> 
> 
> 
> > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> >  wrote:
> > 
> > Since I was collecting prices daily, I guess my price database is pretty
> > large, and my family finances are in there for about 5 years. I have xml
> > database, and compressed, but I checked my save intervals, even increased
> > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > drive, so anyy database should stay in memory.
> 
> GnuCash isn’t yet a database application, so all of the data is always in 
> memory regardless of the backend. If the delay you experience is in opening 
> the price db dialog then it’s probably due to loading the dialog’s tree model 
> from the price db.
> 
> 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 li

Re: Unrealized loss

[Dale Alspach]

Alain,

Here is a scenario that could produce what you are seeing.
1. Sometime in the past you entered a commodity, e.g., stock, mutual
fund, something that uses units and prices.
2. On the date the balance sheet starts showing an unrealized gain or
loss a different unit price for this commodity became available to
gnucash. This usually happens through the price editor tool. Depending
on the Commodity settings in the report, gnucash computed a current
price for the commodity and compared the value computed using this price
to the cost(s) at entry time(s) of the commodity. This difference is
included in the unrealized gains and losses.

The next suggestion should be followed on a copy of your gnucash file in
case there are unpleasant effects.

If you have rarely used the price editor (as your messages seem to
indicate), then it may be easy to locate the commodity and delete any
recorded prices. That should fix your issue.

Dale


On 04/02/2018 07:52 AM, David T. via gnucash-user wrote:
> 
> Alain,
> Your new transaction is balanced, and won't affect the imbalance in another 
> transaction. 
> I personally find the unrealized gains issue to be exceedingly difficult to 
> understand. Since you say you don't care about this, just ignore it. 
> David T 
>  
>  
>   On Mon, Apr 2, 2018 at 17:02, cag...@free.fr wrote:   
> 
> 
> De: cag...@free.fr 
> À: "John Ralls"  
> Cc: "gnucash-user"  
> Envoyé: Lundi 2 Avril 2018 13:51:03 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> De: "John Ralls"  
> À: cag...@free.fr 
> Cc: "gnucash-user"  
> Envoyé: Dimanche 1 Avril 2018 15:34:43 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> 
> 
> On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote: 
> 
> 
> Hello. 
> 
> I have have had an "unrealized loss" showing on my balance sheet for years. I 
> haven't bothered too much as the amount is extremely small. (€7.70). 
> 
> I had kind advice on this forum as to identify the date on which the loss 
> showed up and the procedure to cancel it. I did find the date but stangely 
> not the transaction. So I'm not going to keep trying to cancel the loss any 
> longer. 
> 
> I read that, without actually "cancelling" the loss, it is possible to 
> prevent it from showing. I know that this is not legal for a company, but my 
> book keeping is fully personal so I'd like to know the procedure. 
> 
> 
> 
> 
> “Cancelling” isn’t really the right term. You need to record the loss as 
> either expense or negative income depending on how you handle capital gains. 
> There’s an explanation of how to do this in [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] . 
> 
> Regards, 
> John Ralls 
> 
> 
> 
> I have identified the day on which the unrealized lossed first appeared. I 
> have drawn a transaction report for that day (and the day before). There is 
> no transaction that can remotely explain the loss. 
> I do not handle foreign currencies. Regarding shares I do not use trader 
> accounts or split transactions including profits or losses. I do not enter 
> share values into GC until the day I sell them. There is no way in the 
> meantime GC can take into account a difference in value. 
> 
> Something might help identify where the problem comes from: I had another 
> instance with an unrealized loss as big as my total yearly income. It went 
> away a few weeks (or months I'm not sure) after it showed up. There is no way 
> a single transaction (or even a few ) on a particular day triggered an 
> unrealized loss as big as my yearly income. 
> 
> What I would like at this stage is simply set GC NOT to SHOW unrealized 
> losses/gains. No legal problem as I'm only managing my personal 
> familyaccounts. 
> 
> TIA for you help 
> Regards 
> Alain 
> 
> 
> I tried the following: 
> C an equity account "Unrealized loss" : EUR 7.70 
> D an income account "Realized loss" : EUR 7.70 
> The total Equity remained the same - 7.70 
> I changed the signs and the total equity remained at - 7.70 
> I don't get it. 
> TIA 
> Alain 
> 
> 
> 
> 
> ___
> 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 ca

Billing credit card charges to customers

[VN Alexander]

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.

Re: Unrealized loss

[cageda]

It's not comfortable for an accountant's mind to have Assets and Liabilities 
with different totals :-) 

I understand there is a way not to show Unrealized losses but I am at a loss to 
find it. 

Alain 






De: "David T."  
À: cag...@free.fr, "John Ralls"  
Cc: "gnucash-user"  
Envoyé: Lundi 2 Avril 2018 14:52:46 
Objet: Re: Unrealized loss 

Alain, 

Your new transaction is balanced, and won't affect the imbalance in another 
transaction. 

I personally find the unrealized gains issue to be exceedingly difficult to 
understand. Since you say you don't care about this, just ignore it. 

David T 




On Mon, Apr 2, 2018 at 17:02, cag...@free.fr 
 wrote: 



De: [ mailto:cag...@free.fr | cag...@free.fr ] 
À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] > 
Envoyé: Lundi 2 Avril 2018 13:51:03 
Objet: Re: Unrealized loss 




De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > 
À: [ mailto:cag...@free.fr | cag...@free.fr ] 
Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | 
gnucash-user@gnucash.org ] > 
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | cag...@free.fr 
] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] | [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html  ] ] . 

Regards, 
John Ralls 



I have identified the day on which the unrealized lossed first appeared. I have 
drawn a transaction report for that day (and the day before). There is no 
transaction that can remotely explain the loss. 
I do not handle foreign currencies. Regarding shares I do not use trader 
accounts or split transactions including profits or losses. I do not enter 
share values into GC until the day I sell them. There is no way in the meantime 
GC can take into account a difference in value. 

Something might help identify where the problem comes from: I had another 
instance with an unrealized loss as big as my total yearly income. It went away 
a few weeks (or months I'm not sure) after it showed up. There is no way a 
single transaction (or even a few ) on a particular day triggered an unrealized 
loss as big as my yearly income. 

What I would like at this stage is simply set GC NOT to SHOW unrealized 
losses/gains. No legal problem as I'm only managing my personal familyaccounts. 

TIA for you help 
Regards 
Alain 


I tried the following: 
C an equity account "Unrealized loss" : EUR 7.70 
D an income account "Realized loss" : EUR 7.70 
The total Equity remained the same - 7.70 
I changed the signs and the total equity remained at - 7.70 
I don't get it. 

TIA 
Alain 




___ 
gnucash-user mailing list 
[ mailto:gnucash-user@gnucash.org | gnucash-user@gnucash.org ] 
To update your subscription preferences or to unsubscribe: 
[ https://lists.gnucash.org/mailman/listinfo/gnucash-user | 
https://lists.gnucash.org/mailman/listinfo/gnucash-user ] 
If you are using Nabble or Gmane, please see [ 
https://wiki.gnucash.org/wiki/Mailing_Lists | 
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: Unrealized loss

[Adrien Monteleone]

Your transaction isn’t going to remove/reverse the unrealized loss because the 
unrealized loss isn’t really in the books. It’s a virtual calculation.

For example let’s say you acquired 100 ozt of silver bullion on January 1st at 
$16.91 per ounce:

Dr. Assets:Silver Bullion   $1691
Cr. Assets:Cash $1691

Now, the price has changed and that silver is only worth $16.46 per ounce as of 
March 1st. (and this new price was downloaded or input manually into the Price 
Editor) GnuCash will inform you on certain reports that you have an unrealized 
loss of $45. ($1691-$1646)

If you still hold the asset and just want the information line to go away, 
remove any price in the database using the Price Editor that is AFTER the 
original price.

Otherwise, to realize this loss, you’d have to sell the silver. (you don’t 
realize a loss or gain until you part with the asset)

Let’s say you've decided to stop by your local coin shop and sell everything. 
This would be your transaction that would ‘realize’ the loss from the sale:

Dr. Assets:Cash $1646
Dr. Equity$45
(memo: Loss from sale of silver bullion)
Cr. Assets:Silver Bullion   $1691

Now the loss has been formally rolled into Equity and the notation won’t appear 
on the report. (but as noted, you should only enter such a transaction if you 
actually parted with the asset.)

Regards,
Adrien

> On Apr 2, 2018, at 7:01 AM, cag...@free.fr wrote:
> 
> 
> 
> 
> De: cag...@free.fr 
> À: "John Ralls"  
> Cc: "gnucash-user"  
> Envoyé: Lundi 2 Avril 2018 13:51:03 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> De: "John Ralls"  
> À: cag...@free.fr 
> Cc: "gnucash-user"  
> Envoyé: Dimanche 1 Avril 2018 15:34:43 
> Objet: Re: Unrealized loss 
> 
> 
> 
> 
> 
> 
> On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote: 
> 
> 
> Hello. 
> 
> I have have had an "unrealized loss" showing on my balance sheet for years. I 
> haven't bothered too much as the amount is extremely small. (€7.70). 
> 
> I had kind advice on this forum as to identify the date on which the loss 
> showed up and the procedure to cancel it. I did find the date but stangely 
> not the transaction. So I'm not going to keep trying to cancel the loss any 
> longer. 
> 
> I read that, without actually "cancelling" the loss, it is possible to 
> prevent it from showing. I know that this is not legal for a company, but my 
> book keeping is fully personal so I'd like to know the procedure. 
> 
> 
> 
> 
> “Cancelling” isn’t really the right term. You need to record the loss as 
> either expense or negative income depending on how you handle capital gains. 
> There’s an explanation of how to do this in [ 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
> https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] . 
> 
> Regards, 
> John Ralls 
> 
> 
> 
> I have identified the day on which the unrealized lossed first appeared. I 
> have drawn a transaction report for that day (and the day before). There is 
> no transaction that can remotely explain the loss. 
> I do not handle foreign currencies. Regarding shares I do not use trader 
> accounts or split transactions including profits or losses. I do not enter 
> share values into GC until the day I sell them. There is no way in the 
> meantime GC can take into account a difference in value. 
> 
> Something might help identify where the problem comes from: I had another 
> instance with an unrealized loss as big as my total yearly income. It went 
> away a few weeks (or months I'm not sure) after it showed up. There is no way 
> a single transaction (or even a few ) on a particular day triggered an 
> unrealized loss as big as my yearly income. 
> 
> What I would like at this stage is simply set GC NOT to SHOW unrealized 
> losses/gains. No legal problem as I'm only managing my personal 
> familyaccounts. 
> 
> TIA for you help 
> Regards 
> Alain 
> 
> 
> I tried the following: 
> C an equity account "Unrealized loss" : EUR 7.70 
> D an income account "Realized loss" : EUR 7.70 
> The total Equity remained the same - 7.70 
> I changed the signs and the total equity remained at - 7.70 
> I don't get it. 
> TIA 
> Alain 
> 
> 
> 
> 
> ___
> 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,

Re: GNUCash not compiling with latest Archlinux updates

[Sanjay Chakravarty]

Thanks, Phil. I will try that out.

Warm regards
Sanjay


On 04/02/2018 04:43 PM, Phil wrote:

Hey Sanjay,

I ran into the same issue the other day. Reinstalling webkitgtk fixed my
issue.


Phil



On 04/02/2018 03:36 AM, Sanjay Chakravarty wrote:

Dear All

After updating my Arch linux yesterday, gnucash started giving library
load errors for libicui18n.so and libicuuc.so. It demands version 60
whereas after Arch updates, I have version 61. I can bypass these
errors by softlinking version 60 to 61. But after that I get an error
that there is an undefined symbol ucol_setAttribute_60 in library
/usr/lib/libjavascriptcoregtk-1.0.so.0.

I uninstalled gnucash and tried recompiling using AUR. (yaourt
gnucash) I get the same error which I have reproduced below

gnc.module-WARNING **: 15:35:01.496: Failed to dlopen()
'../../../../src/html/.libs/libgncmod-html.so':
/usr/lib/libjavascriptcoregtk-1.0.so.0: undefined symbol:
ucol_setAttribute_60

How can I get an updated gnucash for Arch at this point, or do I need
to wait for 2.6.20 ?

Warm regards
Sanjay

___
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: Version 3: Improved SQLite response?

[John Ralls]

> On Apr 2, 2018, at 8:24 AM, Tom Browder  wrote:
> 
> First let me say I have been a user of GNU Cash (on Windows) for many
> years, and I greatly appreciate the efforts of all the developers.
> Thank you all so much!
> 
> My question:
> 
> I tried SQLite early after it was considered usable by ordinary users,
> but was disappointed to see that the response time (loading saved
> views on start) on my large DB was not significantly different from
> the flat file.  (To be fair, I didn't spend much time experimenting
> because I didn't want to get out of sync with the flat file DB.)
> 
> Is there any specific SQLite improvement planned for Version 3?
> 

Other than a bit of profiling to speed up loading at the beginning of a 
session, no. It's still used as an object store, not as an active database, so 
it has no impact on the program's performance once the book is loaded. It 
doesn't use any views or even joins, though I will soon push a change for 3.1 
that uses subqueries instead of huge lists of guids to load slots and splits.

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.

support

[Maroon Khalil]

Dear support,

When creating an invoice with a specific customer by error

We are not able to change the customer name

If we change it by edit , it will create another customer number under the
same name ,, so it will not recognize that this is the same customer
Please advice its urgent

Regards
Maroon


___
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

[Irving Duran]

I think the only way to do it would be if you itemize within your invoice
and create a PDF of such invoice.


Thank You,

Irving Duran

On Mon, 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.

invoice - Modify the customer

[Maroon Khalil]

hi

When creating an invoice with a specific customer by error

We are not able to change the customer name

If we change it by edit , it will create another customer number under the
same name ,, so it will not recognize that this is the same customer
Please advice 

Regards
Maroon


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

[John Ralls]

GnuCash 3.0 released

The GnuCash development team proudly announces GnuCash 3.0, the first release 
in our new 3.x stable series.
New Features for Users:

The headline item for this release is that GnuCash now uses the Gtk+-3.0 
Toolkit and the WebKit2Gtk API. This change was forced on us by some major 
Linux distributions dropping support for the WebKit1 API. Unfortunately the 
Webkit project doesn't support Microsoft Windows so that platform will continue 
to use the WebKit1 API, though with Gtk3. We've selected Gtk+-3.14.0 as the 
minimum version because it fully supports CSS theming.
New editors to remove outdated or incorrect match data from the import 
maps, a new user interfacs for managing files associated with transactions, an 
improved facility for removing old prices from the price database, and a way to 
remove deleted files from the history list in the file menu.
New Reports: A Reconciliation Report based on the Transaction Report,a 
Income GST Report, and a Cashflow Barchart report.
A new CSV importer largely rewritten in C++, adding new features including 
the ability to re-import CSV files exported from GnuCash, along with a separate 
CSV price importer.
A new preference panel for the Alphavantage API key so that Finance::Quote 
users need not edit /etc/gnucash/environment. We've removed all references to 
the various Yahoo! quote sources and made Alphavantage the default.
Data file directories are now located appropriately to the operating 
system's conventions by default:
Windows: CSIDL_APPDATA/Gnucash
MacOS: $HOME/Application Support/Gnucash
Linux: $XDG_CONFIG_HOME/gnucash (or the default $HOME/.config/gnucash)
It's still possible to overried with the environment variable GNC_DOC_PATH, 
which replaces GNC_DOT_DIR in earlier versions of GnuCash.
Accounts in the Bayes import map are now linked by GUID instead of names so 
that the matcher won't have to be retrained if you rename an account. The 
Bayesian import maps are also stored in a flatter structure to allow faster 
access, especially in SQL. These changes mean that if you have Bayesian mapping 
data, once converted your database will be loadable only by GnuCash 2.6.20 and 
later.
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.
Numerics are rewritten to allow for more significant digits. The old 
6-digit-maximum fraction is now 9-digits, and prices may have up to 18 digit 
precision.
Chart Reports appearance is improved, including more modern chart colours 
as suggested by http://clrs.cc/.
Transaction Report improvements, including regular expression filtering and 
many more options and features including a "Subtotal Summary Grid" The subtotal 
summary-grid will tabulate subtotals - prime-sortkey vertically, sec-sortkey 
horizontally. For example, with prime-sortkey = accounts, sec-sortkey = date, 
sec-subtotal = monthly will produce a monthly time series table.
The About dialog box layout is improved and now includes the detected 
Finance::Quote version.
GnuCash will always build the locale-specific tax modules. This was 
optional when building with autotools and never enabled when building with 
cmake. Note that the only supported tax locales are en_US and de_DE.
On Macs the Reconcile Window's menu moved to the menubar.
GnuCash no longer supports Guile-1.8 and now does support Guile-2.2

New Features for Developers:

Several parts of the engine and the SQL backend are rewritten in C++, an 
effort that will continue in the next development cycle. KVP is now private to 
libgncmod-engine and accessible outside via qof_instance_set and 
qof_instance_get. KVP and GUID are reimplemnted in C++ using boost::variant and 
boost::UUID respectively.
C++ unit tests require GoogleTest. While it's possible to use prebuilt 
libgtest and libgmock on some distros, building static libraries for GnuCash is 
preferred. It may be necessary to provide the paths to the googletest and 
googlemock source with CMake parameters GTEST_ROOT and GMOCK_ROOT respectively.
The date implementation is migrated to boost::date-time, replacing a Glib 
GDateTime implementation. This makes the earliest date recordable 1 January 
1400CE instead of 1 January 1CE. We doubt any users will be affected.
We've reorganized the code into a core library directory, libgnucash, and 
application-specific directory, gnucash. The python bindings are now in a 
top-level directory, bindings; code pinched from other projects is in borrowed, 
the account templates, check templates, and pixmaps are consolidated in data, 
and common holds the cmake modules and test framework code. The bin directory's 
contents have moved to the top level gnucash directory and bin is removed. 
There are now directories for gschema, gtkbuilder and ui files directly in 
gnucash. In principle all files of each type 

Re: invoice - Modify the customer

[Adrien Monteleone]

No need to post to the list twice.

Please read through the Help Guide & the Tutorial & Concepts Guide posted on 
the website: http://gnucash.org/docs.phtml

Particularly, read over Chapter 7 of the Help “Business Features” and Section 
III of the Tutorial & Concepts Guide “Managing Business Finances”.

You need to create your customers first.

Then create an invoice. When you create the invoice, you select the customer 
you want to use.

If you already have a customer but assigned the wrong name to them, simply edit 
the customer - DO NOT attempt to do this from within the invoice.

Once you have changed the name of the customer, re-open the invoice, chose the 
Edit button, and re-select the customer, now with the new name.

Regards,
Adrien

> On Apr 2, 2018, at 2:55 PM, Maroon Khalil  wrote:
> 
> hi
> 
> When creating an invoice with a specific customer by error
> 
> We are not able to change the customer name
> 
> If we change it by edit , it will create another customer number under the
> same name ,, so it will not recognize that this is the same customer
> Please advice 
> 
> Regards
> Maroon
> 
> 
> ___
> 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.

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.
Thank you
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 Released

[C M Reinehr]

John,

Thanks for all your hard work. GnuCash is an invaluable piece of software.

Cheers!

CMR


On 04/02/2018 03:17 PM, John Ralls wrote:

GnuCash 3.0 released

The GnuCash development team proudly announces GnuCash 3.0, the first release 
in our new 3.x stable series.
New Features for Users:

 The headline item for this release is that GnuCash now uses the Gtk+-3.0 
Toolkit and the WebKit2Gtk API. This change was forced on us by some major 
Linux distributions dropping support for the WebKit1 API. Unfortunately the 
Webkit project doesn't support Microsoft Windows so that platform will continue 
to use the WebKit1 API, though with Gtk3. We've selected Gtk+-3.14.0 as the 
minimum version because it fully supports CSS theming.
 New editors to remove outdated or incorrect match data from the import 
maps, a new user interfacs for managing files associated with transactions, an 
improved facility for removing old prices from the price database, and a way to 
remove deleted files from the history list in the file menu.
 New Reports: A Reconciliation Report based on the Transaction Report,a 
Income GST Report, and a Cashflow Barchart report.
 A new CSV importer largely rewritten in C++, adding new features including 
the ability to re-import CSV files exported from GnuCash, along with a separate 
CSV price importer.
 A new preference panel for the Alphavantage API key so that Finance::Quote 
users need not edit /etc/gnucash/environment. We've removed all references to 
the various Yahoo! quote sources and made Alphavantage the default.
 Data file directories are now located appropriately to the operating 
system's conventions by default:
 Windows: CSIDL_APPDATA/Gnucash
 MacOS: $HOME/Application Support/Gnucash
 Linux: $XDG_CONFIG_HOME/gnucash (or the default $HOME/.config/gnucash)
 It's still possible to overried with the environment variable 
GNC_DOC_PATH, which replaces GNC_DOT_DIR in earlier versions of GnuCash.
 Accounts in the Bayes import map are now linked by GUID instead of names 
so that the matcher won't have to be retrained if you rename an account. The 
Bayesian import maps are also stored in a flatter structure to allow faster 
access, especially in SQL. These changes mean that if you have Bayesian mapping 
data, once converted your database will be loadable only by GnuCash 2.6.20 and 
later.
 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.
 Numerics are rewritten to allow for more significant digits. The old 
6-digit-maximum fraction is now 9-digits, and prices may have up to 18 digit 
precision.
 Chart Reports appearance is improved, including more modern chart colours 
as suggested by http://clrs.cc/.
 Transaction Report improvements, including regular expression filtering and many 
more options and features including a "Subtotal Summary Grid" The subtotal 
summary-grid will tabulate subtotals - prime-sortkey vertically, sec-sortkey 
horizontally. For example, with prime-sortkey = accounts, sec-sortkey = date, 
sec-subtotal = monthly will produce a monthly time series table.
 The About dialog box layout is improved and now includes the detected 
Finance::Quote version.
 GnuCash will always build the locale-specific tax modules. This was 
optional when building with autotools and never enabled when building with 
cmake. Note that the only supported tax locales are en_US and de_DE.
 On Macs the Reconcile Window's menu moved to the menubar.
 GnuCash no longer supports Guile-1.8 and now does support Guile-2.2

New Features for Developers:

 Several parts of the engine and the SQL backend are rewritten in C++, an 
effort that will continue in the next development cycle. KVP is now private to 
libgncmod-engine and accessible outside via qof_instance_set and 
qof_instance_get. KVP and GUID are reimplemnted in C++ using boost::variant and 
boost::UUID respectively.
 C++ unit tests require GoogleTest. While it's possible to use prebuilt 
libgtest and libgmock on some distros, building static libraries for GnuCash is 
preferred. It may be necessary to provide the paths to the googletest and 
googlemock source with CMake parameters GTEST_ROOT and GMOCK_ROOT respectively.
 The date implementation is migrated to boost::date-time, replacing a Glib 
GDateTime implementation. This makes the earliest date recordable 1 January 
1400CE instead of 1 January 1CE. We doubt any users will be affected.
 We've reorganized the code into a core library directory, libgnucash, and 
application-specific directory, gnucash. The python bindings are now in a 
top-level directory, bindings; code pinched from other projects is in borrowed, 
the account templates, check templates, and pixmaps are consolidated in data, 
and common holds the cmake modules and test framework code. The bin directory's 
contents have moved to the top l

Re: GnuCash 3.0 Released

[Tom Browder]

On Mon, Apr 2, 2018 at 3:49 PM, C M Reinehr  wrote:
> John,
>
> Thanks for all your hard work. GnuCash is an invaluable piece of software.

Amen, Brother!

-Tom
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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

[Doug]

Thanks for the hard work. I will report the upgrade to PCLinuxOS (my distro of 
choice for many years).

regards, Doug (Australia)

On Mon, 2 Apr 2018 15:49:10 -0500
C M Reinehr  wrote:

> John,
> 
> Thanks for all your hard work. GnuCash is an invaluable piece of software.
> 
> Cheers!
> 
> CMR
> 
> 
> On 04/02/2018 03:17 PM, John Ralls wrote:
> > GnuCash 3.0 released
> >
> > The GnuCash development team proudly announces GnuCash 3.0, the first 
> > release in our new 3.x stable series.
> > New Features for Users:
> >
> >  The headline item for this release is that GnuCash now uses the 
> > Gtk+-3.0 Toolkit and the WebKit2Gtk API. This change was forced on us by 
> > some major Linux distributions dropping support for the WebKit1 API. 
> > Unfortunately the Webkit project doesn't support Microsoft Windows so that 
> > platform will continue to use the WebKit1 API, though with Gtk3. We've 
> > selected Gtk+-3.14.0 as the minimum version because it fully supports CSS 
> > theming.
> >  New editors to remove outdated or incorrect match data from the import 
> > maps, a new user interfacs for managing files associated with transactions, 
> > an improved facility for removing old prices from the price database, and a 
> > way to remove deleted files from the history list in the file menu.
> >  New Reports: A Reconciliation Report based on the Transaction Report,a 
> > Income GST Report, and a Cashflow Barchart report.
> >  A new CSV importer largely rewritten in C++, adding new features 
> > including the ability to re-import CSV files exported from GnuCash, along 
> > with a separate CSV price importer.
> >  A new preference panel for the Alphavantage API key so that 
> > Finance::Quote users need not edit /etc/gnucash/environment. We've removed 
> > all references to the various Yahoo! quote sources and made Alphavantage 
> > the default.
> >  Data file directories are now located appropriately to the operating 
> > system's conventions by default:
> >  Windows: CSIDL_APPDATA/Gnucash
> >  MacOS: $HOME/Application Support/Gnucash
> >  Linux: $XDG_CONFIG_HOME/gnucash (or the default 
> > $HOME/.config/gnucash)
> >  It's still possible to overried with the environment variable 
> > GNC_DOC_PATH, which replaces GNC_DOT_DIR in earlier versions of GnuCash.
> >  Accounts in the Bayes import map are now linked by GUID instead of 
> > names so that the matcher won't have to be retrained if you rename an 
> > account. The Bayesian import maps are also stored in a flatter structure to 
> > allow faster access, especially in SQL. These changes mean that if you have 
> > Bayesian mapping data, once converted your database will be loadable only 
> > by GnuCash 2.6.20 and later.
> >  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.
> >  Numerics are rewritten to allow for more significant digits. The old 
> > 6-digit-maximum fraction is now 9-digits, and prices may have up to 18 
> > digit precision.
> >  Chart Reports appearance is improved, including more modern chart 
> > colours as suggested by http://clrs.cc/.
> >  Transaction Report improvements, including regular expression 
> > filtering and many more options and features including a "Subtotal Summary 
> > Grid" The subtotal summary-grid will tabulate subtotals - prime-sortkey 
> > vertically, sec-sortkey horizontally. For example, with prime-sortkey = 
> > accounts, sec-sortkey = date, sec-subtotal = monthly will produce a monthly 
> > time series table.
> >  The About dialog box layout is improved and now includes the detected 
> > Finance::Quote version.
> >  GnuCash will always build the locale-specific tax modules. This was 
> > optional when building with autotools and never enabled when building with 
> > cmake. Note that the only supported tax locales are en_US and de_DE.
> >  On Macs the Reconcile Window's menu moved to the menubar.
> >  GnuCash no longer supports Guile-1.8 and now does support Guile-2.2
> >
> > New Features for Developers:
> >
> >  Several parts of the engine and the SQL backend are rewritten in C++, 
> > an effort that will continue in the next development cycle. KVP is now 
> > private to libgncmod-engine and accessible outside via qof_instance_set and 
> > qof_instance_get. KVP and GUID are reimplemnted in C++ using boost::variant 
> > and boost::UUID respectively.
> >  C++ unit tests require GoogleTest. While it's possible to use prebuilt 
> > libgtest and libgmock on some distros, building static libraries for 
> > GnuCash is preferred. It may be necessary to provide the paths to the 
> > googletest and googlemock source with CMake parameters GTEST_ROOT and 
> > GMOCK_ROOT respectively.
> >  The date implementation is migrated to boost::date-time, replacing a 
> > Glib GDateTime implementation. This makes the earliest date recordabl

Re: GnuCash 3.0 Released

[Fross, Michael]

Couldn't agree more.  It's the only piece of software that I really don't
think I could live without.  John, Geert, and the entire development team -
THANK YOU.

Michael

On Mon, Apr 2, 2018 at 3:56 PM, Tom Browder  wrote:

> On Mon, Apr 2, 2018 at 3:49 PM, C M Reinehr  wrote:
> > John,
> >
> > Thanks for all your hard work. GnuCash is an invaluable piece of
> software.
>
> Amen, Brother!
>
> -Tom
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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

[Les]

Ditto!  Great job!

Les


On 04/02/2018 04:00 PM, Fross, Michael wrote:

Couldn't agree more.  It's the only piece of software that I really don't
think I could live without.  John, Geert, and the entire development team -
THANK YOU.

Michael

On Mon, Apr 2, 2018 at 3:56 PM, Tom Browder  wrote:


On Mon, Apr 2, 2018 at 3:49 PM, C M Reinehr  wrote:

John,

Thanks for all your hard work. GnuCash is an invaluable piece of

software.

Amen, Brother!

-Tom
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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

[John Ralls]

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

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-user Digest, Vol 181, Issue 7

[Maroon Khalil]

Hi Adrien,,

Thank you for your answer,
What you mentioned is clear
The point is : if I issued an invoice by mistake to a specific customer ,
so I need to change the customer of that invoice,

that¹s not doable ,!!!

One more thing we noticed is that if you create a new invoice with same
invoice number it create it with no issue , so you get 2 invoices under
the same number ( this shouldn¹t happen by the way)


Please let me know 

regards



On 4/2/18, 4:23 PM, "gnucash-user-requ...@gnucash.org"
 wrote:

>Send gnucash-user mailing list submissions to
>gnucash-user@gnucash.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>or, via email, send a message with subject or body 'help' to
>gnucash-user-requ...@gnucash.org
>
>You can reach the person managing the list at
>gnucash-user-ow...@gnucash.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of gnucash-user digest..."
>
>
>Today's Topics:
>
>   1. Re: invoice - Modify the customer (Adrien Monteleone)
>   2. MySQL Server connection timeout or keep-alive (Paul Neuwirth)
>   3. Re: GnuCash 3.0 Released (C M Reinehr)
>   4. Re: GnuCash 3.0 Released (Tom Browder)
>   5. Re: GnuCash 3.0 Released (Doug)
>   6. Re: GnuCash 3.0 Released (Fross, Michael)
>   7. Re: GnuCash 3.0 Released (Les)
>
>
>--
>
>Message: 1
>Date: Mon, 2 Apr 2018 15:22:43 -0500
>From: Adrien Monteleone 
>To: GnuCash User List 
>Subject: Re: invoice - Modify the customer
>Message-ID: 
>Content-Type: text/plain;charset=utf-8
>
>No need to post to the list twice.
>
>Please read through the Help Guide & the Tutorial & Concepts Guide posted
>on the website: http://gnucash.org/docs.phtml
>
>Particularly, read over Chapter 7 of the Help ?Business Features? and
>Section III of the Tutorial & Concepts Guide ?Managing Business Finances?.
>
>You need to create your customers first.
>
>Then create an invoice. When you create the invoice, you select the
>customer you want to use.
>
>If you already have a customer but assigned the wrong name to them,
>simply edit the customer - DO NOT attempt to do this from within the
>invoice.
>
>Once you have changed the name of the customer, re-open the invoice,
>chose the Edit button, and re-select the customer, now with the new name.
>
>Regards,
>Adrien
>
>> On Apr 2, 2018, at 2:55 PM, Maroon Khalil  wrote:
>> 
>> hi
>> 
>> When creating an invoice with a specific customer by error
>> 
>> We are not able to change the customer name
>> 
>> If we change it by edit , it will create another customer number under
>>the
>> same name ,, so it will not recognize that this is the same customer
>> Please advice 
>> 
>> Regards
>> Maroon
>> 
>> 
>> ___
>> 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.
>
>
>
>--
>
>Message: 2
>Date: Mon, 2 Apr 2018 17:39:44 +0200
>From: Paul Neuwirth 
>To: gnucash-user@gnucash.org
>Subject: MySQL Server connection timeout or keep-alive
>Message-ID: <20180402173944.427d3...@iota.swabian.net>
>Content-Type: text/plain; charset=US-ASCII
>
>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.
>Thank you
>Paul
>
>
>--
>
>Message: 3
>Date: Mon, 2 Apr 2018 15:49:10 -0500
>From: C M Reinehr 
>To: gnucash-user@gnucash.org
>Subject: Re: GnuCash 3.0 Released
>Message-ID: <422fb2d2-163c-66c0-3267-f53cc619b...@reinehr.net>
>Content-Type: text/plain; charset=utf-8; format=flowed
>
>John,
>
>Thanks for all your hard work. GnuCash is an invaluable piece of software.
>
>Cheers!
>
>CMR
>
>
>On 04/02/2018 03:17 PM, John Ralls wrote:
>> GnuCash 3.0 released
>>
>> The GnuCash development team proudly announces GnuCash 3.0, the first
>>release in our new 3.x stable series.
>> New Features for Users:
>>
>>  The headline item for this release is that GnuCash now uses the
>>Gtk+-3.0 Toolkit and the WebKit2Gtk API. This change was forced on us by
>>some major Linux distributions dropping support for the WebKit1 API.
>>Unfortunately the Webkit project doesn't support Microsoft Windows so
>>that platform will continue to use the WebKit1 API, though with Gtk3.
>>We've selected Gtk+-3.14.0 as the minimum version because it fully
>>supports CSS theming.
>>  New editors to remove outdated or incorrect match data from the
>>import maps, a new user inte

Re: support

[Maroon]

Hi Adrien,,

Thank you for your answer,
What you mentioned is clear
The point is : if I issued an invoice by mistake to a specific customer ,
so I need to change the customer of that invoice,

that’s not doable ,!!!

One more thing we noticed is that if you create a new invoice with same
invoice number it create it with no issue , so you get 2 invoices under
the same number ( this shouldn’t happen by the way)


Please let me know

regards



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

Record Auto Insurance expense

[subscriptions]

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.

Re: Finance::Quote Yahoo_JSON Alpha Vantage

[Les]

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

  


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

  


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

[habesz85]

Hello guys,

I experience the following error during the loading of gnucash 3.0;


 

I already tried a clean install, tried rebooting, did not work.

Any ideas?

Thanks,
Tamás



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

> 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 

Re: invoice - Modify the customer

[Adrien Monteleone]

Yes, you can change the customer. But after the invoice is created, you need to 
click the Edit Invoice button on the toolbar in order to do this. When you 
click that button, you’ll get a window just like the one when you first created 
the invoice. Re-select your customer and then continue. The invoice will now be 
assigned to the new customer.

On the second question, yes, you can create duplicate invoice numbers. Your 
options are to change the invoice number to something else, or don’t specify an 
invoice number and let the system automatically create one for you. If you have 
a numbering pattern other than simply 1,2,3 et cetera, you can change the 
settings for the numbering pattern in File > Properties > Counters.

Regards,
Adrien

p.s. - Again, I’m not sure if you have a setting mixed up or not, but there is 
no need to post to the list twice. You did so originally with the subject line 
’support’ and another with the subject line ‘invoice - Modify the customer’ now 
you’ve replied via the ’support’ thread which I did not reply to, and have also 
replied to the mailing list digest without changing the subject line. So now 
instead of one conversation thread people can follow, they have 3. Please, just 
hit ‘reply-list’ or ‘reply-all’ one time to this message and refrain from 
copying that reply to other message threads. If you are using the digest, 
please be sure to replace the subject line with the one specific to your topic, 
and only quote what is relevant to your topic, not the entire digest.


> On Apr 2, 2018, at 5:25 PM, Maroon Khalil  wrote:
> Hi Adrien,,
> 
> Thank you for your answer,
> What you mentioned is clear
> The point is : if I issued an invoice by mistake to a specific customer ,
> so I need to change the customer of that invoice,
> 
> that’s not doable ,!!!
> 
> One more thing we noticed is that if you create a new invoice with same
> invoice number it create it with no issue , so you get 2 invoices under
> the same number ( this shouldn’t happen by the way)
> 
> 
> Please let me know
> 
> regards

>> On Apr 2, 2018, at 3:22 PM, Adrien Monteleone  
>> wrote:
>> 
>> No need to post to the list twice.
>> 
>> Please read through the Help Guide & the Tutorial & Concepts Guide posted on 
>> the website: http://gnucash.org/docs.phtml
>> 
>> Particularly, read over Chapter 7 of the Help “Business Features” and 
>> Section III of the Tutorial & Concepts Guide “Managing Business Finances”.
>> 
>> You need to create your customers first.
>> 
>> Then create an invoice. When you create the invoice, you select the customer 
>> you want to use.
>> 
>> If you already have a customer but assigned the wrong name to them, simply 
>> edit the customer - DO NOT attempt to do this from within the invoice.
>> 
>> Once you have changed the name of the customer, re-open the invoice, chose 
>> the Edit button, and re-select the customer, now with the new name.
>> 
>> Regards,
>> Adrien
>> 
>>> On Apr 2, 2018, at 2:55 PM, Maroon Khalil  wrote:
>>> 
>>> hi
>>> 
>>> When creating an invoice with a specific customer by error
>>> 
>>> We are not able to change the customer name
>>> 
>>> If we change it by edit , it will create another customer number under the
>>> same name ,, so it will not recognize that this is the same customer
>>> Please advice 
>>> 
>>> Regards
>>> Maroon
>>> 
>>> 
>>> ___
>>> 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

[randix]

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

...
(Should I write this up at bugzilla.gnome.org ?)


Sure.

We should be be using CMAKE_INSTALL_FULL_SYSCONFDIR to set the path so that
it always works no matter what cmake does with it, and cmake’s unique
understanding of the gnu coding standard leads it to do some strange things
with sysconfdir.



OK I will open a bug report. I confirmed same behavior with 3.0.

I'm also opening another bug report about the Export PDF button for reports. 
It does Print instead of export.


By the way, why does 3.0 start up with:
"This is a development version. It may or may not work."
(Written to stdout)
It does work. Really!

___
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

[David Carlson]

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 <
subscripti...@renuecomputers.com> 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.
>
___
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

[Dave H]

I also am running Windows 10 (Enterprise - version 1709, build 16299.309)
and just updated from 2.6.19 to 3.0 (eng_au) without any issues apart from
the gigantic tabs across the top of the window which no doubt I'll have to
tweak to reduce the size to the same size they were in 2.6.9.

Cheers Dave H.


On 3 April 2018 at 10:48, randix  wrote:

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

"loadable only by GnuCash 2.6.20 and later"

[Jim DeLaHunt]

3.0!  Many thanks to the GnuCash developers. I have been lurking on the 
gnucash-devel list, so I have overheard all the discussion and care you 
put into this huge accomplishment, and I can only imagine all the work 
that you put in between posts.  I appreciate it!


Still, I have a question about the 3.0 release announcement 
. 
It said, "[Changes in the Bayes import maps] mean that if you have 
Bayesian mapping data, once converted your database will be loadable 
only by GnuCash 2.6.20 and later." That implies to me that there exists 
a version 2.6.20.


Is there in fact a GnuCash 2.6.20?

The GnuCash.org "other versions" page 
 says, "Old Stable Release 
(2.6.19)". I don't see a mention of 2.6.20.


The Sourceforge.net files/gnucash (stable) directory 
 
has a directory named "2.6.20", containing a "-setup.exe", ".tar.gz", 
and ".tar.bz2" files, but no "dmg" file (for Mac OS).


Looking through my archive of the gnucash-user list, I see an 
announcement for 2.6.19 
 
in December 2017, but no announcement of 2.6.20.


Is a release of 2.6.20 coming soon, and I should just be patient and 
wait for it?  Or am I misunderstanding the reference to 2.6.20 in the 
3.0 announcement?


For me (running GnuCash on Mac OS X), the issue is that the changes in 
the Bayes import maps, while welcome, will make my upgrade irreversible. 
I would feel more comfortable if I could upgrade to 2.6.20 first, then 
to 3.0. That would give me (the illusion of) a downgrade path.


Again, many thanks for 3.0! I look forward to using it, whether it be 
sooner or later.


--
--Jim DeLaHunt, j...@jdlh.com http://blog.jdlh.com/ (http://jdlh.com/)
  multilingual websites consultant

  355-1027 Davie St, Vancouver BC V6E 4L2, Canada
 Canada mobile +1-604-376-8953

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

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

[lj]

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.

virus download version 3.0

[Dave via gnucash-user]

Hi.

 

I'm getting a virus when I download version 3.0

 



___
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

[Frank H. Ellenberger]

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.

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

[David Carlson]

Our developers have been very busy recently preparing this very major
update.  Thanks.

Since it is a major update, it is expected that there will be some bugs
other than the few that were already known at the time of the release.  The
American developers are now facing an April 17 Tax filing date.

Let's let them rest and file their tax returns before working on new bugs
in this series.  We should document them so they get are not forgotten, but
unless they are deal breakers, let them age a little before expecting them
to be fixed.

Again, thanks, developers.

David C

On Mon, Apr 2, 2018 at 9:10 PM, 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.

RE: virus download version 3.0

[Dave via gnucash-user]

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.

Re: virus download version 3.0

[David Carlson]

That would be very important to verify the authenticity of that virus
report because it is not even labelled as from a known reliable AV service
it may be spam.

David C

On Mon, Apr 2, 2018 at 9:28 PM, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

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

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

[Dave H]

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.

Re: virus download version 3.0

[Dave H]

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.

Re: 2.7.8 fails to find environment file

[John Ralls]

> On Apr 2, 2018, at 5:59 PM, lj  wrote:
> 
> John Ralls wrote:
>>> ...
>>> (Should I write this up at bugzilla.gnome.org ?)
>> Sure.
>> We should be be using CMAKE_INSTALL_FULL_SYSCONFDIR to set the path so that
>> it always works no matter what cmake does with it, and cmake’s unique
>> understanding of the gnu coding standard leads it to do some strange things
>> with sysconfdir.
> 
> OK I will open a bug report. I confirmed same behavior with 3.0.
> 
> I'm also opening another bug report about the Export PDF button for reports. 
> It does Print instead of export.
> 
> By the way, why does 3.0 start up with:
>"This is a development version. It may or may not work."
> (Written to stdout)
> It does work. Really!

Mike Evans beat you to the export PDF button, so I closed yours as a duplicate. 
“Exporting” to PDF is done via the print function in WebKit because WebKit is 
basically an Apple library and that’s how they make PDFs. 

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

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

[William Jackson]

> 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?
___
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: "loadable only by GnuCash 2.6.20 and later"

[John Ralls]

> On Apr 2, 2018, at 6:44 PM, Jim DeLaHunt  wrote:
> 
> 3.0!  Many thanks to the GnuCash developers. I have been lurking on the 
> gnucash-devel list, so I have overheard all the discussion and care you put 
> into this huge accomplishment, and I can only imagine all the work that you 
> put in between posts.  I appreciate it!
> 
> Still, I have a question about the 3.0 release announcement 
> . It 
> said, "[Changes in the Bayes import maps] mean that if you have Bayesian 
> mapping data, once converted your database will be loadable only by GnuCash 
> 2.6.20 and later." That implies to me that there exists a version 2.6.20.
> 
> Is there in fact a GnuCash 2.6.20?

Not yet, because I’m having a bit of trouble getting the Mac Intel package to 
build. It should get released in the next day or three.

As long as you’re using the XML backend you’ll have a backup to roll back to 
that will still load with 2.6.19, though you’ll lose any changes you’ve made in 
3.0. Or you can wait a few days.

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

[Robert Heller]

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.

Re: virus download version 3.0

[Adrien Monteleone]

If so, it is something new in Windows 8+. On Win7, Windows Defender doesn’t do 
this.

Could very well be a false positive if others are scanning and not getting a 
hit. A cursory search shows Windows Defender has been throwing this out as 
false positive since at least October.

See this topic for submitting false-positives so Microsoft can remove them from 
the signature files: 
https://stackoverflow.com/questions/48301141/windows-defender-detecting-exe-as-trojanwin32-azden-acl-virus

Regards,
Adrien

> On Apr 2, 2018, at 10:36 PM, Robert Heller  wrote:
> 
> 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: virus download version 3.0

[John Ralls]

More likely it wants executables to be code signed, but if that’s the case it 
would be better if they’d say “this binary isn’t code signed so we can’t tell 
if it’s clean or not”.

I have Apple code signing set up for the Mac-Intel bundles mostly because Apple 
makes it easy. With Microsoft it’s more complicated and I haven’t put in the 
effort.

Regards,
John Ralls

> On Apr 2, 2018, at 8:36 PM, Robert Heller  wrote:
> 
> 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: GnuCash 3.0 Released

[John Ralls]

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

RE: virus download version 3.0

[Dave via gnucash-user]

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.

No Suitable Backend Found - sqlite3 on High Sierra

[Adrien Monteleone]

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.