No Suitable Backend Found - sqlite3 on High Sierra

2018-04-02 Thread 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

RE: virus download version 3.0

2018-04-02 Thread 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:

Re: GnuCash 3.0 Released

2018-04-02 Thread 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

Re: virus download version 3.0

2018-04-02 Thread 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

Re: virus download version 3.0

2018-04-02 Thread 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

Re: virus download version 3.0

2018-04-02 Thread 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. > >

Re: "loadable only by GnuCash 2.6.20 and later"

2018-04-02 Thread 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

Re: GnuCash 3.0 Released

2018-04-02 Thread 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?

Re: 2.7.8 fails to find environment file

2018-04-02 Thread 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

Re: virus download version 3.0

2018-04-02 Thread 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. > >

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

2018-04-02 Thread 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

Re: virus download version 3.0

2018-04-02 Thread 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

RE: virus download version 3.0

2018-04-02 Thread 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

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

2018-04-02 Thread 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

Re: virus download version 3.0

2018-04-02 Thread 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?

virus download version 3.0

2018-04-02 Thread 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

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

2018-04-02 Thread 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

"loadable only by GnuCash 2.6.20 and later"

2018-04-02 Thread 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

Re: Gnucash 3.0 release crashes during loading

2018-04-02 Thread 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

Re: Record Auto Insurance expense

2018-04-02 Thread 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

Re: 2.7.8 fails to find environment file

2018-04-02 Thread 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

Re: Gnucash 3.0 release crashes during loading

2018-04-02 Thread 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

Re: invoice - Modify the customer

2018-04-02 Thread 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

RE: Finance::Quote Yahoo_JSON Alpha Vantage

2018-04-02 Thread 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

Gnucash 3.0 release crashes during loading

2018-04-02 Thread 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:

Re: Finance::Quote Yahoo_JSON Alpha Vantage

2018-04-02 Thread 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

Record Auto Insurance expense

2018-04-02 Thread 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

Re: gnucash-user Digest, Vol 181, Issue 7

2018-04-02 Thread 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

Re: MySQL Server connection timeout or keep-alive

2018-04-02 Thread 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

Re: GnuCash 3.0 Released

2018-04-02 Thread 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

Re: GnuCash 3.0 Released

2018-04-02 Thread 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

Re: GnuCash 3.0 Released

2018-04-02 Thread 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. > >

Re: GnuCash 3.0 Released

2018-04-02 Thread 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

Re: GnuCash 3.0 Released

2018-04-02 Thread 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:

MySQL Server connection timeout or keep-alive

2018-04-02 Thread 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

Re: invoice - Modify the customer

2018-04-02 Thread 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

GnuCash 3.0 Released

2018-04-02 Thread 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

invoice - Modify the customer

2018-04-02 Thread 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

Re: Billing credit card charges to customers

2018-04-02 Thread 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

support

2018-04-02 Thread 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

Re: Version 3: Improved SQLite response?

2018-04-02 Thread 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

Re: GNUCash not compiling with latest Archlinux updates

2018-04-02 Thread 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

Re: Unrealized loss

2018-04-02 Thread 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.

Re: Unrealized loss

2018-04-02 Thread 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"

Billing credit card charges to customers

2018-04-02 Thread 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:

Re: Unrealized loss

2018-04-02 Thread 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

Re: Price Editor/Database lag

2018-04-02 Thread 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

Version 3: Improved SQLite response?

2018-04-02 Thread 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

Re: Price Editor/Database lag

2018-04-02 Thread 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

Re: Price Editor/Database lag

2018-04-02 Thread 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 >

Re: Unrealized loss

2018-04-02 Thread 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,

Re: Unrealized loss

2018-04-02 Thread 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

Re: Unrealized loss

2018-04-02 Thread 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

Re: GNUCash not compiling with latest Archlinux updates

2018-04-02 Thread 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

GNUCash not compiling with latest Archlinux updates

2018-04-02 Thread 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

Re: Running Reports over a Windows 10 Network

2018-04-02 Thread 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