Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

2019-01-29 Thread John Ralls



> On Jan 29, 2019, at 6:28 AM, Adrien Monteleone 
>  wrote:
> 
> 
>> I'm curious: what are the names of the two directories that were created ? 
>> Or 
>> in other words, how are those names decided on MacOS ?
>> 
>> As far as I know on linux and Windows the names are hardcoded to use the 
>> compile time application name unless overridden by setting GNC_DATA_DIR and 
>> GNC_CONFIG_DIR environment variables. The latter (GNC_CONFIG_DIR) is only 
>> introduces in GnuCash 3.4.
>> 
>> Geert
> 
> The names matched the app name. (not including the .app extension of course)

Actually GNC_CONFIG_DIR replaces GNC_DOT_DIR in 2.6 and earlier.

One may change the path in 
Gnucash.app/Contents/Resources/etc/gnucash/environment in GnuCash 3 or 
Gnucash.app/Contents/MacOS/Gnucash in earlier versions.

Regards,
John Ralls

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


Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

2019-01-29 Thread John Ralls


> On Jan 29, 2019, at 9:08 AM, Michael Hendry  wrote:
> 
>> On 29 Jan 2019, at 16:54, Michael Hendry  wrote:
>> 
>> Progress notes on upgrade:
>> 
>> I downloaded Gnucash-Intel-2.6.21-3.dmg this morning and dragged-and-dropped 
>> Gnucash.app into my Applications folder after renaming the earlier version.
>> 
>> The verification failed when I tried to run the App.
>> 
>> 
>> I downloaded Gnucash-Intel-3.4-1.dmg also, and went through the same 
>> procedure. It appeared not to run, so I tried running it from the command 
>> line thus...
>> 
>> /Applications/Gnucash.app/Contents/MacOS/Gnucash
>> 
>> …and got the following:
>> 
>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash
>> 
>> (process:23502): gnc.gui-WARNING **: 16:10:17.947: [mac_set_languages()] 
>> Language list: en:en_GB:C
>> 
>> 
>> As I’d renamed the directory where my .gnucash files are stored, I got a 
>> warning about this, and once I’d made a new copy of this directory the 
>> program ran as normal.
>> 
>> Is there any significance in the WARNING above?
>> 
>> 
>> I’ll have another go at downloading and installing 2.6.21 and report back.
>> 
>> Regards,
>> 
>> Michael
> 
> PS Further download of 2.6.21: failed to run because it was reported to be 
> damaged:
> 
> https://www.dropbox.com/s/qor0iu0qs9uq370/Screenshot%202019-01-08%2022.54.58.png?dl=0
> 
> Michael
> (please excuse accidental personal emails to Geert and to John, which should 
> have gone only to the list).

Michael,

That screen shot is of a buffer overflow in an ahnentafel report. GnuCash 
doesn't do genealogy.

Please run the following in Terminal:
  spctl --assess --verbose path/to/Gnucash-2.6.21.app
and paste the result in a reply.

Regards,
John Ralls




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

Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

2019-01-29 Thread John Ralls



> On Jan 29, 2019, at 8:24 AM, Geert Janssens  
> wrote:
> 
> Op dinsdag 29 januari 2019 17:19:59 CET schreef John Ralls:
>>> On Jan 29, 2019, at 8:03 AM, Geert Janssens 
>>> wrote:> 
>>> Op dinsdag 29 januari 2019 15:28:01 CET schreef Adrien Monteleone:
>>>>> I'm curious: what are the names of the two directories that were created
>>>>> ?
>>>>> Or in other words, how are those names decided on MacOS ?
>>>>> 
>>>>> As far as I know on linux and Windows the names are hardcoded to use the
>>>>> compile time application name unless overridden by setting GNC_DATA_DIR
>>>>> and
>>>>> GNC_CONFIG_DIR environment variables. The latter (GNC_CONFIG_DIR) is
>>>>> only
>>>>> introduces in GnuCash 3.4.
>>>>> 
>>>>> Geert
>>>> 
>>>> The names matched the app name. (not including the .app extension of
>>>> course)> 
>>> App name as in "GnuCash" and "GnuCash-2" as in your earlier example ?
>>> That's interesting but puzzling as I don't see anything in the code that
>>> would make that happen. The default directory is hardcoded to GnuCash as
>>> of gnucash 3.x.
>>> 
>>> Perhaps John does some magic to change this in the MacOS integration repo.
>> 
>> Nope, and as far as MacOS is concerned the "App Name" which appears at the
>> left side of the menu bar and in Activity Monitor is "Gnucash", the name of
>> the executable in Gnucash.app/Contents/MacOS that's named in
>> Gnucash.app/Contents/Info.plist. The filename of the bundle (i.e.
>> Gnucash.app or whatever the user might rename it to) doesn't matter to
>> anything except the file system.
>> 
>> Regards,
>> John Ralls
> 
> Ok, that's how I understood as well. So I can only assume the two application 
> data directories are "GnuCash" and "Gnucash" (different capitalization of the 
> letter "C").
> 
> For 2.6 this directory was called "Gnucash" and in the 3.x series I renamed 
> it 
> to "GnuCash". That was under the belief that MacOS' file system was still 
> case-insensitive/case-preserving so it would be an innocent no-op for most 
> users. IIRC you recently told me it no longer is so this will affect people 
> migrating to a more recent gnucash version.

It's still true by default. Users have always had the option of making HFS+ and 
APFS filesystems case-sensitive at creation (i.e. format), but few do.

Regards,
John Ralls

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


Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

2019-01-29 Thread John Ralls


> On Jan 29, 2019, at 9:45 AM, John Ralls  wrote:
> 
> 
> 
>> On Jan 29, 2019, at 9:08 AM, Michael Hendry  wrote:
>> 
>>> On 29 Jan 2019, at 16:54, Michael Hendry  wrote:
>>> 
>>> Progress notes on upgrade:
>>> 
>>> I downloaded Gnucash-Intel-2.6.21-3.dmg this morning and 
>>> dragged-and-dropped Gnucash.app into my Applications folder after renaming 
>>> the earlier version.
>>> 
>>> The verification failed when I tried to run the App.
>>> 
>>> 
>>> I downloaded Gnucash-Intel-3.4-1.dmg also, and went through the same 
>>> procedure. It appeared not to run, so I tried running it from the command 
>>> line thus...
>>> 
>>> /Applications/Gnucash.app/Contents/MacOS/Gnucash
>>> 
>>> …and got the following:
>>> 
>>> Application Path /Applications/Gnucash.app/Contents/MacOS/Gnucash
>>> 
>>> (process:23502): gnc.gui-WARNING **: 16:10:17.947: [mac_set_languages()] 
>>> Language list: en:en_GB:C
>>> 
>>> 
>>> As I’d renamed the directory where my .gnucash files are stored, I got a 
>>> warning about this, and once I’d made a new copy of this directory the 
>>> program ran as normal.
>>> 
>>> Is there any significance in the WARNING above?
>>> 
>>> 
>>> I’ll have another go at downloading and installing 2.6.21 and report back.
>>> 
>>> Regards,
>>> 
>>> Michael
>> 
>> PS Further download of 2.6.21: failed to run because it was reported to be 
>> damaged:
>> 
>> https://www.dropbox.com/s/qor0iu0qs9uq370/Screenshot%202019-01-08%2022.54.58.png?dl=0
>> 
>> Michael
>> (please excuse accidental personal emails to Geert and to John, which should 
>> have gone only to the list).
> 
> Michael,
> 
> That screen shot is of a buffer overflow in an ahnentafel report. GnuCash 
> doesn't do genealogy.
> 
> Please run the following in Terminal:
>  spctl --assess --verbose path/to/Gnucash-2.6.21.app
> and paste the result in a reply.

Never mind, I see the problem.

Regards,
John Ralls

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

Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

2019-01-29 Thread John Ralls



> On Jan 29, 2019, at 8:03 AM, Geert Janssens  
> wrote:
> 
> Op dinsdag 29 januari 2019 15:28:01 CET schreef Adrien Monteleone:
>>> I'm curious: what are the names of the two directories that were created ?
>>> Or in other words, how are those names decided on MacOS ?
>>> 
>>> As far as I know on linux and Windows the names are hardcoded to use the
>>> compile time application name unless overridden by setting GNC_DATA_DIR
>>> and
>>> GNC_CONFIG_DIR environment variables. The latter (GNC_CONFIG_DIR) is only
>>> introduces in GnuCash 3.4.
>>> 
>>> Geert
>> 
>> The names matched the app name. (not including the .app extension of course)
> 
> App name as in "GnuCash" and "GnuCash-2" as in your earlier example ? That's 
> interesting but puzzling as I don't see anything in the code that would make 
> that happen. The default directory is hardcoded to GnuCash as of gnucash 3.x.
> 
> Perhaps John does some magic to change this in the MacOS integration repo.

Nope, and as far as MacOS is concerned the "App Name" which appears at the left 
side of the menu bar and in Activity Monitor is "Gnucash", the name of the 
executable in Gnucash.app/Contents/MacOS that's named in 
Gnucash.app/Contents/Info.plist. The filename of the bundle (i.e. Gnucash.app 
or whatever the user might rename it to) doesn't matter to anything except the 
file system.

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


Re: [GNC] 3.4 upgraded, crashes when paying invoice

2019-01-29 Thread John Ralls



> On Jan 29, 2019, at 7:04 AM, Mike stagl  wrote:
> 
> https://sourceforge.net/projects/gnucash/files/
> 
> go to gnucash (stable) and you can find source code for all the prior
> versions.

Or https://github.com/Gnucash/gnucash/releases.

Regards,
John Ralls


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


Re: [GNC] 3.4 upgraded, crashes when paying invoice

2019-01-28 Thread John Ralls



> On Jan 28, 2019, at 10:33 AM, Rich Shepard  wrote:
> 
> Environment: Slackware-14.2, Gnucash-3.4.
> 
> Upgraded over the weekend by removing -3.3, building and installing -3.4.
> The new version appeared to be working.
> 
> This morning I entered and posted a vendor invoice and tried to pay it from
> the business' checking account. After filling in the dialog box with the
> payment due date, amount, check number, and activating the print check
> checkbox, I cliked the 'Print' button. Gnucash immediately shut down.
> 
> Tried twice; same results both times.
> 
> The log file, business.gnucash.20190128100724.log (redacted) shows this:
> 
> mod trans_guid  split_guid  time_nowdate_entered
> date_posted acc_guidacc_namenum description notes
>   memoaction  reconciled  amount  value   date_reconciled
> -
> = START
> = END
> = START
> = END
> = START
> C   ce0e1808db934c5cbcbefb7eb8b5726e
> 5d11536bcc8e47fcbb06053cbb670d0e2019-01-28 10:09:59 -0800   
> 2019-01-28 10:09:59 -0800
>   2019-01-28 02:59:00 -0800   4156423033acee5d82eb51fe6343ebc2
>Checking --  Bank
>Payment n   -10826/100  -10826/100  1969-12-31 16:00:00 
> -0800
> C   ce0e1808db934c5cbcbefb7eb8b5726e
> bd652f7f85a84523b2e5c6a82534840f2019-01-28 10:09:59 -0800   
> 2019-01-28 10:09:59 -0800
>   2019-01-28 02:59:00 -0800   c42ae1c317d86e04bb5ea7ec1f21db52
>Accounts Payable
>Payment n   10826/100   10826/100   1969-12-31 16:00:00 
> -0800
> = END
> 
> I need to have gnucash working ASAP. What other information can I provide?

Please file a bug. Transaction logs are not useful. Trace files 
(https//wiki.gnucash.org/wiki/Tracefile are sometimes useful and stack traces 
(https://wiki.gnucash.org/wiki/stack_trace are the most useful for diagnosing 
crashes.

If you need to get this up-and-running ASAP then reinstall gnucash-3.3.

Regards,
John Ralls

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


Re: [GNC] custom .chk file crashes GnuCash 3.4

2019-01-23 Thread John Ralls
You are, but GnuCash shouldn’t crash if the .chk file is in the wrong place. 
Please file a bug. If you can get a stack trace of the crash that will help a 
lot.

Regards,
John Ralls

> On Jan 23, 2019, at 8:01 AM, Mike stagl  wrote:
> 
> Upon further investigation, it appears that having any custom check
> file in the folder ~/.local/share/gnucash/checks will cause this crash,
> even a working file copied from the GnuCash checks folder (with an
> altered name and GUID).
> 
> I instead placed my custom file in my GNC_DATA_HOME folder (for me
> /usr/local/share/gnucash/checks) and it appears to work again.
> 
> Maybe I wasn't supposed to have my custom file in USER_DATA_HOME?
> 
> Just my experiences,
> 
> Mike
> 
> On Wed, 2019-01-23 at 10:34 -0500, Mike wrote:
>> Gnucash 3.4 on Debian 9
>> 
>> I have been using a custom check format (.chk) file I wrote for
>> GnuCash
>> 3.2.  It worked fine until I upgraded to 3.4.  When I go to File-
>>> Print 
>> Checks, GnuCash 3.4 crashes before the dialog box even opens.
>> 
>> If I delete the custom .chk file and open GnuCash 3.4, it will print
>> a
>> default check format fine.
>> 
>> I rolled back to GnuCash 3.2 and my custom file prints fine.
>> 
>> Did anything change with 3.4 that I would need to modify in my .chk
>> file?
>> 
>> Thanks to all the contributors,
>> 
>> Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Liabilities and Net Worth in Android app

2019-02-01 Thread John Ralls



> On Feb 1, 2019, at 1:27 AM, Chris  wrote:
> 
> PS: I was surprised that the mailing list server does not offer TLS. Of 
> course the list is open but it would be nice if in 2019 it would be offered 
> since people like me need to turn off "only send emails to TLS enabled 
> servers".

Thanks for reporting that, we thought that TLS was set up on lists.gnucash.org, 
but we had a configuration error. Derek thinks that he's fixed it.

Regards,
John Ralls

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


Re: [GNC] Gnucash terminates immediately

2019-02-05 Thread John Ralls



> On Feb 5, 2019, at 6:35 AM, David Carlson  wrote:
> 
> On Tue, Feb 5, 2019, 5:30 AM Bostjan Vilfan  
>> I tried both, gnucash 3.4 as well as 2.6.26; therefore it could be
>> something with Windows 10 version 1809; in case you are able to figure out
>> something, I am enclosing link to Windows msinfo results:
>> 
> 
> 
>> Regards,
>> bostjanv
>> 
>>> __
>>> 
>>> 
> There are instructions in the Gnucash wiki on how to get error messages out
> of Gnucash, I am not online right now, so I cannot tell you exactly where,
> I just remember that it is not an easy task.
> 
> There is also a way to start Gnucash from the command line without a data
> file.  Sometimes a bad data file can cause a crash.  Again the exact
> procedure escapes me, but other users or devs may be able to help.
> 
> Sorry I cannot be more help right now.

The instructions are at https://wiki.gnucash.org/wiki/Tracefile and 
https://wiki.gnucash.org/wiki/stack_trace. The trace file is easy. The stack 
trace is hard only on windows, but is the most useful when you have a crash.

Please don't post either here: Crashes deserve bug reports.

Regards,
John Ralls

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


Re: [GNC] Help with Error While Setting Up Online Price Quotes

2019-02-04 Thread John Ralls



> On Feb 3, 2019, at 11:42 AM, James Lobash  wrote:
> 
> Help.  I was attempting to load the GnuCash Online Price retriever but
> received the following error message during the "Run gnc-fq-helper" program:
> ___
> Can't locate Date/Manip.pm in @INC (you may need to install the Date::Manip
> module) (@INC contains: C:/Perl64/site/lib C:/Perl64/lib) at gnc-fq-helper
> line 29.
> 
> BEGIN failed-compilation aborted at gnc-fq-helper line 29
> 
> 
> Am I missing a program in my installation program in order to get this to
> run, or is it something in my operating system?

You're missing a required module named Date::Manip. It's available from CPAN.

Regards,
John Ralls

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


Re: [GNC] help lost data file

2019-04-09 Thread John Ralls
Eric,

I keep mine in an encrypted dmg that I back up to Google Drive. You can put 
yours wherever you like, just make sure that it gets routinely backed up, 
ideally including offsite. $HOME/Documents/Gnucash seems an obvious choice if 
you have your Documents folder in your backup set.

Regards,
John Ralls

> On Apr 9, 2019, at 11:49 AM, Eric Rathhaus office  wrote:
> 
> Eureka! Thanks John. Yes I opened the file you noted and found the data.  I 
> made a new folder “gnu data” and saved the files as ewrofficedata.gnu.  But 
> maybe I erred in that the folder is a subdirectory of the old folder with the 
> files you suggest I delete.  Where should I locate the new folder?
> 
> 
> Kind regards,
> 
> Eric W. Rathhaus
> Law Office of Eric W. Rathhaus
> 484 Lake Park Avenue, Suite 50
> Oakland, CA 94610
> 415.577.0920 tel
> 415.737.0603 fax
> 
> www.ewrlaw.com
> 
> Confidentiality : 
> 
> The information contained in this message is legally privileged and 
> confidential information intended only for the use of the addressee(s) named 
> above.  If the reader of this message is not the intended recipient, please 
> be advised that any dissemination, distribution, or copy of the information 
> in this message, and/or the name(s) of the person(s) it is addressed to, is 
> prohibited.  If you have received this message in error, please notify us by 
> returning this email to us.  If that is not possible, we will reimburse you 
> for any costs in returning this message to us through other means.
> 
> 
> 
>> On Apr 9, 2019, at 7:12 AM, John Ralls  wrote:
>> 
>> The number of files is if anything too big. The most usual case would be 
>> only one because most people have only one book.
>> 
>> 1. test.gnucash.gcm  
>> Mar 22, 2012 at 10:00 AM
>> 2. MACS.gnucash.gcm  Mar 18, 
>> 2013 at 1:43 PM
>> 3. MACS.gnucash_2.gcm
>> Mar 22, 2012 at 9:01 AM
>> 4. ewrofficedata.gnucash.rev.gnucash.gcm Aug 7, 2013 at 
>> 11:43 PM
>> 5. ewrofficedata.gnucash.gcm Apr 5, 
>> 2019 at 11:21 PM
>> 6. ewrofficedata.gnucash.2013160900.gnucash.gcm  Mar 31, 2019 at 5:03 PM
>> 7. ewrofficedata.gnucash.20130806193744.gnucash.gcm  Aug 16, 2013 at 9:13 PM
>> 8. 
>> ewrofficedata.gnucash.20130806193744.gnucash.20130807120014.log.gnucash.gcm 
>> Today
>> 9. ewrofficedata.gnucash_2.gcm   Aug 6 
>> 2013 at 8:34 PM
>> 10 ewrofficedata copy.gnucash.gcmMar 31, 
>> 2019 at 5:10 PM
>> 
>> You wrote your first post at 5:20 PM on March 31, so the file that you had 
>> open immediately before that was #10, and the one before *that* was #6. 
>> Notice that that's a backup file from 2013, so you apparently have been 
>> working in that one for the last 5+ years. 
>> 
>> You obviously don't want to open the .gcm file, it's 
>> ewrofficedata.gnucash.2013160900.gnucash that you want to open. It's 
>> probably in the same folder as the others. Once you've confirmed that I 
>> suggest that you make a new directory and use Save As to save it to the new 
>> directory as ewrofficedata.gnucash, then delete the old directory. GnuCash 
>> will notice that it can't find the other files in your history list and ask 
>> if you want to remove them. Tell it yes. Adjust your backups as necessary to 
>> include the new directory and exclude the old one and you're set.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>>> On Apr 8, 2019, at 10:55 PM, Eric Rathhaus office  wrote:
>>> 
>>> So I used the go to command and got the first screen shot.  opening the 
>>> book folder and I get the second screen shot.  It’s odd that there are so 
>>> few files as I’ve used this program since 2012.  And when I tried to open 
>>> any of the recent gcm files, I get nothing or it says a suitable back up 
>>> can’t be found.  I getting concerned that something terriblest wrong 
>>> happened and that I need to restore from archived cloud version, much data. 
>>>  
>>> 
>>> Kind regards,
>>> 
>>> Eric W. Rathhaus
>>> Law Office of Eric W. Rathhaus
>>> 484 Lake Park Avenue, Suite 50
>>> Oakland, CA 94610
>>> 415.577.0920 tel
>>> 415.737.0603 fax
>>> 
>>> www.ewrlaw.com
>>> 
>>> Confidentiality : 
>>> 
>>> The information contained in this mess

Re: [GNC] Downgrading to 2.6.21

2019-04-06 Thread John Ralls
That's interesting. What is the path that's causing trouble with 3.5, and 
please remind me what OS you're using.

Regards,
John Ralls


> On Apr 6, 2019, at 10:04 PM, Greg Feneis  wrote:
> 
> There's a problem with 3.5 where it won't save to the usual location that I
> have saved the file to when I was using 2.6.x  For some reason 3.5 has a
> problem with path length.  I never had a problem with 2.6.21, I just
> thought I should keep up to the latest in case I wanted to ask for help
> with it.  But since it's going to give me trouble, I'll just go back to
> 2.6.21, so long as it will work with the file that was previously saved by
> 3.5.
> 
> 
> 
> 
> Kind regards,
> 
> Greg Feneis <http://www.linkedin.com/in/electromechanical>
> 
> 
> 
> 
> On Sat, Apr 6, 2019 at 7:09 PM Fross, Michael  wrote:
> 
>> If you don't mind my asking, why are you downgrading?  What have you found
>> that you prefer in 2.6.21?
>> 
>> Michael
>> 
>> On Sat, Apr 6, 2019 at 1:26 PM Greg Feneis  wrote:
>> 
>>> Hi,
>>> 
>>> I've done some work in 3.5 and I'm considering downgrading to 2.6.21.
>>> 
>>> Can 2.6.21 work with the xml .gnucash file once it was changed and saved
>>> by
>>> 3.5?
>>> 
>>> Kind regards,
>>> 
>>> Greg
>>> ___
>>> 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: [GNC] v3.5 Save Times

2019-04-06 Thread John Ralls



> On Apr 6, 2019, at 9:07 AM, Ian K via gnucash-user  
> wrote:
> 
> I have to say reading this post made me check out 3.5, as versions up to 3.3
> were really unusably slow on saving, so I was still using 2.6.21.
> I normally check the release notes when a new release comes out and the bug 
> Bug 795804 - Extremely slow save
> is still listed as a Known Issue, so I hadn't bothered.
> 
> I don't know what the devs have done but 3.5 is not only faster than 3.3,
> it's also much faster saving than 2.6.
> For example, my >8yrs worth of data file took 9.1 seconds to save on 2.6.21,
> and now on 3.5 it's 3.5 sec.
> 
> This is a huge imporvement. Maybe have another look at the bug and see if
> something has unwittingly fixed it.
> Anyway thanks!

Not unwittingly. Bob, Geert and I plus several new contributors did a lot of 
profiling to try to bring the load times down. What we've been waiting for on 
the bug report is confirmation that our efforts were successful, so please 
report your experience there.

Regards,
John Ralls

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


Re: [GNC] help lost data file

2019-04-06 Thread John Ralls
Finder displays that option only when the current directory is your home 
directory. That's the one in Users named after your user-id.

I see that you've installed GnuCash and Finance Quote Update to the MacintoshHD 
directory, aka root. This is unwise, you should move them to some subdirectory. 
Applications is a common choice. That also applies to other folders in 
MacintoshHD. Applications should go in the Applications folder and everything 
else should be in subdirectories of your Home folder.

Regards,
John Ralls


> On Apr 6, 2019, at 2:00 PM, Eric Rathhaus office  wrote:
> 
> Hi John - when I follow your directions and use “show view options” I don’t 
> find any option of show library file.  Perhaps I’m not looking in the correct 
> place.  In Finder, I use the find command which open a box, which I presume 
> is my home directory, click on the “gear”, and select “show view options.”  I 
> attach a couple of screen shots of what I see
> 
> Kind regards,
> 
> Eric W. Rathhaus
> Law Office of Eric W. Rathhaus
> 484 Lake Park Avenue, Suite 50
> Oakland, CA 94610
> 415.577.0920 tel
> 415.737.0603 fax
> 
> www.ewrlaw.com
> 
> Confidentiality : 
> 
> The information contained in this message is legally privileged and 
> confidential information intended only for the use of the addressee(s) named 
> above.  If the reader of this message is not the intended recipient, please 
> be advised that any dissemination, distribution, or copy of the information 
> in this message, and/or the name(s) of the person(s) it is addressed to, is 
> prohibited.  If you have received this message in error, please notify us by 
> returning this email to us.  If that is not possible, we will reimburse you 
> for any costs in returning this message to us through other means.
> 
> 
> 
>> On Apr 2, 2019, at 8:13 PM, John Ralls  wrote:
>> 
>> Yes, I deliberately wrote them generically. Since you've now specified the 
>> OS I can further explain that you'll find the book folder in 
>> ~/Library/Application Support/gnucash and that TextEdit is perfectly fine 
>> for examining the contents of the directories. In order to get Finder to 
>> look in ~/Library you'll need to go to your home directory, click the gear 
>> icon in the toolbar, select "Show View Options" and select "Show Library 
>> Folder", the last checkbox.
>> 
>> You'll have more success searching for filenames with Finder than with 
>> Spotlight; the latter looks at file metadata and contents rather than file 
>> names.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Apr 2, 2019, at 5:39 PM, Eric Rathhaus office  wrote:
>>> 
>>> Thanks, John.  I’m using a Mac. Will your directions still apply? 
>>> 
>>> Kind regards,
>>> 
>>> Eric W. Rathhaus
>>> Law Office of Eric W. Rathhaus
>>> 484 Lake Park Avenue, Suite 50
>>> Oakland, CA 94610
>>> 415.577.0920 tel
>>> 415.737.0603 fax
>>> 
>>> www.ewrlaw.com
>>> 
>>> Confidentiality : 
>>> 
>>> The information contained in this message is legally privileged and 
>>> confidential information intended only for the use of the addressee(s) 
>>> named above.  If the reader of this message is not the intended recipient, 
>>> please be advised that any dissemination, distribution, or copy of the 
>>> information in this message, and/or the name(s) of the person(s) it is 
>>> addressed to, is prohibited.  If you have received this message in error, 
>>> please notify us by returning this email to us.  If that is not possible, 
>>> we will reimburse you for any costs in returning this message to us through 
>>> other means.
>>> 
>>> 
>>> 
>>>> On Apr 2, 2019, at 5:02 PM, John Ralls  wrote:
>>>> 
>>>> The books directory in GNC_DATA_DIR (see 
>>>> http://wiki.gnucash.org/wiki/Configuration_Locations to see where that is 
>>>> on your OS) will have a file named after each one that you've had open 
>>>> with a .gcm extension instead of .gnucash. If you left registers open when 
>>>> you closed the .gnucash file the .gcm file will name the accounts for 
>>>> those registers, which might help you narrow down which is the one you 
>>>> want. Once you've figured that out you can use your OS's file-find utility 
>>>> to locate it.
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>>> 
>>>>> On Apr 2, 2019, at 2:27 PM, Eric Rathhaus office  wrote:
>>>>> 
>>&

[GNC] Announcement: Rebuild of the GnuCash 3.5 Windows Bundle

2019-04-09 Thread John Ralls


We've fixed a couple of problems with the Windows AIO Bundle and uploaded a new 
one to the usual places. NOTE that this is not a new release of GnuCash; the 
functioning of the program itself is unchanged.

It fixes two problems, one serious, one not so much:
* Bug 797178 - 3.5 install-fq-mods.cmd requires ssleay32.dll, but it's no 
longer installed as part of GnuCash
* Update the Bugzilla URL for the Report a GnuCash Bug Start Menu item.

A few bugs listed as "known problems" in the GnuCash-3.5 release notes have 
been tested by their reporters and marked as resolved:
* Bug 795804 - Extremely slow save
* Bug 796880 - Menu Tooltips Interfere with All Dialogs
* Bug 796962 - File save hangs
* Bug 796976 - saving file with scheduled transaction hangs: copy of scheduled 
transactions missing in tmp file?
* Bug 797144 - Dates are erased when changing the language to de_DE
* Bug 797148 - Custom Count fields won't save
* Bug 797169 - GnuCash hangs loading XML file

The SHA256 Hash for the new Windows installer is
1e14f343eaf7c2118a937a74fd51842fdce59b0bd73db5863103b27592dbaafa

It can be downloaded from:
* SourceForge: 
https://downloads.sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/gnucash-3.5-1.setup.exe
* Github: 
https://github.com/Gnucash/gnucash/releases/download/3.5/gnucash-3.5-1.setup.exe

About the Program

GnuCash is a free, open source accounting program released under the GNU 
General Public License (GPL) and available for GNU/Linux, *BSD, Solaris, Mac 
OSX, and Microsoft Windows.  Programming on GnuCash began in 1997, and its 
first stable release was in 1998.


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


Re: [GNC] Downgrading to 2.6.21

2019-04-08 Thread John Ralls
Greg,

2.6.21 and 3.x are supposed to be fully file-compatible. Earlier releases in 
the 2.6 series may not be depending on what 3.x features you use.

If you'd prefer to continue the troubleshooting in the bug tracker, file a bug.

Regards,
John Ralls


> On Apr 8, 2019, at 5:40 PM, Greg Feneis  wrote:
> 
> Just a coupe of questions,
> 
> 1.  Once the working file (xml) is saved by 3.5, does it remain backward 
> compatible with 2.6.21 in case I want to downgrade?
> 
> 2.  Should I log this bug in bugzilla?  
> 
> Kind regards,
> 
> Greg Feneis
> 
> 
> 
> On Mon, Apr 8, 2019 at 7:27 AM Greg Feneis  wrote:
> Hi John,
> 
> Sorry I missed this yesterday.  The language is English (United States), The 
> Location is United States. The current language for non-Unicode programs is 
> English (United States)
> 
> 
> 
> 
> Kind regards,
> 
> Greg Feneis
> 
> 
> 
> On Sun, Apr 7, 2019 at 4:33 PM John Ralls  wrote:
> Indeed. I just tried C:\Dropbox\My Docs\Thorough C & D\GnuCash\GnuCash 
> Docs\DeTradingWithExtraNoiseAdded.gnucash. No problem.
> 
> What are your Language and Region settings? Have you set LANG and LANGUAGES 
> in C:\Program Files (x86)\gnucash\etc\gnucash\environment? Is your userid an 
> Administrator?
> 
> Regards,
> John Ralls
> 
> 
> > On Apr 7, 2019, at 4:04 PM, Greg Feneis  wrote:
> > 
> > John,
> > 
> > I misread your instructions and only attempted to save outside of the 
> > Dropbox folder, but not in my ...\Users\Greg\... folder, so I tried this 
> > path and file name:
> > C:\Xobpord\My Docs\Thorough C & D\GnuCash\GnuCash Files\Official Working 
> > File After Testing Path Lengh Issues.gnucash (117 chars, outside of 
> > Dropbox, Failure!)
> > The error message reads:
> > "You attempted to save in H[gibberish]\Users\Greg\AppData\Roaming\GnuCash 
> > or a subdirectory thereof. This is not allowed as GnuCash reserves that 
> > directory for internal usePlease try again in a different directory. 
> > (close).
> > 
> > Then I read your email again before starting a reply and realized you 
> > spec'd the home directory, so I tried the following path and file name:
> > C:\Users\Greg\Dropbox\My Docs\Thorough C & D\GnuCash\GnuCash Files\Official 
> > Working File After Testing Path Lengh Issues.gnucash (128 chars, outside of 
> > Dropbox, inside user folder, success!)
> > 
> > So, appears with 3.5 I can only have a generous path while saving within 
> > the windows user folder? 
> > 
> > Things are getting curiouser
> > 
> > 
> > Kind regards,¯¯
> > Greg
> > 
> > On Sun, Apr 7, 2019 at 1:46 PM John Ralls  wrote:
> > Just to completely rule out Dropbox being somehow involved, could you 
> > create the same hierarchy in your home directory, i.e. 
> > c:\Users\Greg\Dropbox\My Docs\Thorough C & D\GnuCash\Gnucash Files\
> > 
> > I was able to successfully save
> > C:\Users\John Ralls\Dropbox\My Docs\Thorough C & D\GnuCash\GnuCash 
> > Docs\DeTradingWithExtraNoiseAdded.gnucash
> > and its log file 
> > C:\Users\John Ralls\Dropbox\My Docs\Thorough C & D\GnuCash\GnuCash 
> > Docs\DeTradingWithExtraNoiseAdded.gnucash.20190407134124.log
> > 
> > Regards,
> > John Ralls
> > 
> > 
> > > On Apr 7, 2019, at 10:50 AM, Greg Feneis  wrote:
> > > 
> > > Some more testing on the issue where 3.5 seems to want a shorter path 
> > > than 2.6.x did:
> > > 
> > > Just now, I exited Dropbox to see if that had something to do with it, 
> > > but pretty much the same error for all three path variations, what worked 
> > > historically with 2.6.x, no ampersand but some folder names used spaces, 
> > > and no ampersand + no spaces.  It seemed purely to do with length, but it 
> > > doesn't seem to be about total characters.
> > > 
> > > With Dropbox back on, here are some more tests:
> > > 
> > > C:\Dropbox\MyDocs\ThoroughCandD\GnuCash\test.gnucash   (52 chars) Success!
> > > 
> > > C:\Dropbox\MyDocs\ThoroughCandD\GnuCash\GnuCashFiles\test.gnucash  (65 
> > > chars) Failure!
> > > 
> > > So I shortened the name of the last folder from GnuCashFiles down to G 
> > > and still got the same problem
> > > C:\Dropbox\MyDocs\ThoroughCandD\GnuCash\G\test.gnucash  (54 chars) 
> > > Failure!
> > > 
> > > So I shortened the name of the previous folder from GnuCash down to 
> > > GnuCa, and it also failed even though it was 52 chars, the character 
> > > count that seemed

Re: [GNC] help lost data file

2019-04-08 Thread John Ralls
Interesting. A little experimentation finds that it's not sufficient to just 
select the home directory, you must have the home directory as the primary view 
in Finder. If you're using Icon or List view you can double-click on your home 
directory to make it primary. If you're in column view you can either switch 
temporarily to one of the others or you can drag your home directory to the 
sidebar and then click on it there.

There's another way, though: Select Go>Go to Folder... from the menu and then 
type into the dialog box ~/Library/Application Support/Gnucash and click Go.

Regards,
John Ralls

> On Apr 8, 2019, at 2:44 PM, Eric Rathhaus office  wrote:
> 
> Hi John - sorry to be so dense.  So those applications are old versions, I 
> believe.  But I navigated to me as user and still no option of show library 
> files appears.  I think I used to store the data in the fold err office data, 
> but all the files in that directory or old.  No matter where I’ve looked, the 
> only files I find that are recent are .log files.  I can’t find any newer 
> files with the .gnucash or the .gcm extensions.  I’m lost here and the tax 
> man is breathing down my neck. 
> 
> Kind regards,
> 
> Eric W. Rathhaus
> Law Office of Eric W. Rathhaus
> 484 Lake Park Avenue, Suite 50
> Oakland, CA 94610
> 415.577.0920 tel
> 415.737.0603 fax
> 
> www.ewrlaw.com
> 
> Confidentiality : 
> 
> The information contained in this message is legally privileged and 
> confidential information intended only for the use of the addressee(s) named 
> above.  If the reader of this message is not the intended recipient, please 
> be advised that any dissemination, distribution, or copy of the information 
> in this message, and/or the name(s) of the person(s) it is addressed to, is 
> prohibited.  If you have received this message in error, please notify us by 
> returning this email to us.  If that is not possible, we will reimburse you 
> for any costs in returning this message to us through other means.
> 
> 
> 
>> On Apr 6, 2019, at 10:12 PM, John Ralls  wrote:
>> 
>> Finder displays that option only when the current directory is your home 
>> directory. That's the one in Users named after your user-id.
>> 
>> I see that you've installed GnuCash and Finance Quote Update to the 
>> MacintoshHD directory, aka root. This is unwise, you should move them to 
>> some subdirectory. Applications is a common choice. That also applies to 
>> other folders in MacintoshHD. Applications should go in the Applications 
>> folder and everything else should be in subdirectories of your Home folder.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Apr 6, 2019, at 2:00 PM, Eric Rathhaus office  wrote:
>>> 
>>> Hi John - when I follow your directions and use “show view options” I don’t 
>>> find any option of show library file.  Perhaps I’m not looking in the 
>>> correct place.  In Finder, I use the find command which open a box, which I 
>>> presume is my home directory, click on the “gear”, and select “show view 
>>> options.”  I attach a couple of screen shots of what I see
>>> 
>>> Kind regards,
>>> 
>>> Eric W. Rathhaus
>>> Law Office of Eric W. Rathhaus
>>> 484 Lake Park Avenue, Suite 50
>>> Oakland, CA 94610
>>> 415.577.0920 tel
>>> 415.737.0603 fax
>>> 
>>> www.ewrlaw.com
>>> 
>>> Confidentiality : 
>>> 
>>> The information contained in this message is legally privileged and 
>>> confidential information intended only for the use of the addressee(s) 
>>> named above.  If the reader of this message is not the intended recipient, 
>>> please be advised that any dissemination, distribution, or copy of the 
>>> information in this message, and/or the name(s) of the person(s) it is 
>>> addressed to, is prohibited.  If you have received this message in error, 
>>> please notify us by returning this email to us.  If that is not possible, 
>>> we will reimburse you for any costs in returning this message to us through 
>>> other means.
>>> 
>>> 
>>> 
>>>> On Apr 2, 2019, at 8:13 PM, John Ralls  wrote:
>>>> 
>>>> Yes, I deliberately wrote them generically. Since you've now specified the 
>>>> OS I can further explain that you'll find the book folder in 
>>>> ~/Library/Application Support/gnucash and that TextEdit is perfectly fine 
>>>> for examining the contents of the directories. In order to get Finder to 
>>>> look in ~/Library you'll need to go to your home directory, click the ge

Re: [GNC] help lost data file

2019-04-08 Thread John Ralls
Adrien,

That's exactly what he hasn't been able to do.

Regards,
John Ralls


> On Apr 8, 2019, at 3:57 PM, Adrien Monteleone 
>  wrote:
> 
> 1. Navigate to your home directory.
> 2. View > Show View Options. (or CMD-J)
> 3. You’ll see the last option box to “Show Library Folder”
> 4. Check the box.
> 
> You might also be able to get to the Library folder directly via SHIFT-CMD-L
> 
> Regards,
> Adrien
> 
>> On Apr 8, 2019, at 4:44 PM, Eric Rathhaus office  wrote:
>> 
>> Hi John - sorry to be so dense.  So those applications are old versions, I 
>> believe.  But I navigated to me as user and still no option of show library 
>> files appears.  I think I used to store the data in the fold err office 
>> data, but all the files in that directory or old.  No matter where I’ve 
>> looked, the only files I find that are recent are .log files.  I can’t find 
>> any newer files with the .gnucash or the .gcm extensions.  I’m lost here and 
>> the tax man is breathing down my neck. 
>> 
>> Kind regards,
>> 
>> Eric W. Rathhaus
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Suggesting simple interface changes

2019-04-11 Thread John Ralls



> On Apr 10, 2019, at 8:57 PM, ChrisInAccounting  
> wrote:
> 
> I work in accounting and think it may help newbies if a few changes were
> made.
> 
> 1.  In the chart of accounts, call the page "chart of accounts" rather than
> accounts (as default).  This will help them communicate with other business
> owner's who use other accounting platforms.  "Chart of Accounts" is
> universal in accounting and will only hinder the GnuCash user if they are
> learning different uncommon lingo.
> 
> 2.  The page displaying Chart of Accounts has three columns that I would
> suggest be modified.  As it stands in version 3.5, the columns are "Account
> Name", "Description", and "Total".  This default setup is redundant, as the
> description is the same as the account name.  Again, for the benefit of new
> users, I highly suggest replacing the 'Description' column with "account
> type".  This way the user's eye can scan left to right to see the account
> name along with the type of account it is.  
> 
> I can see that the chart of accounts are listed as a hierarchy by
> account type, which is helpful, but the redundancy of having 'description'
> next to is, to me, is wasteful. Also consider that once the account list
> gets so long (under the parent of 'expenses', per se), the new user will
> have to scroll up to verify which account type they are working under rather
> than being able to quickly just eyeball to the right.  So please consider
> this modification.
> 
> 3.  Last, it would be helpful if the user could right click any account name
> and be able to run a report on it.  The "reports' tool as I currently see it
> is clunkly.  Being in the chart of accounts allows the user to go straight
> to the source to run a report on it.  Having to go to reports and scan
> through all the report options seems a little bit too long of a route, and
> less intuitive.  If this can be added, awesome.
> 
> Thank you to the developers and contributors for bringing an opensource
> accounting platform this far.  Greatly greatly appreciated.  
> 
> Any questions on the accounting side of things just drop me a line. 

It's the Accounts page because that makes for a smaller tab than "Chart of 
Accounts" would. It seems unlikely that anyone familiar with accounting would 
be at all confused... but if you'd rather have yours called "Chart of 
Accounts", right-click in the page and select "Rename Page" from the context 
menu.

The account name and description are duplicated only if you want them to be, 
but we're all about user choice: Click the down-arrow on the right side of the 
accounts page title bar and uncheck Description and check Type.

What report would you run on a single account? 

Regards,
John Ralls

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


Re: [GNC] File operations open non-existant drive

2019-04-14 Thread John Ralls
It's apparently a common problem on Windows, especially Win10. Google "windows 
insert disk" for about 33 million hits.

Regards,
John Ralls

> On Apr 14, 2019, at 7:45 PM, David T. via gnucash-user 
>  wrote:
> 
> I believe this error was mentioned in a thread last August 
> (https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079468.html). 
> 
> Unfortunately, there doesn't seem to have been a resolution other than to 
> remove the hardware. 
> 
> Sorry. 
> 
> 
> David
> 
> 
>  On Mon, Apr 15, 2019 at 6:58, wendiallen via 
> gnucash-user wrote:   Win10Pro64; GnuCash 3.5.  
> When I request any file operations, or click on
> "preferences", GnuCash attempts to read a non-existent drive K.  It's
> actually assigned to my usb card reader, as are drives J, I, & H.  Hence, I
> get an error box asking me to insert a disk.  I click "try again", and it
> moves down to drive J, then I, then H.  Then it cycles through the four
> drives again, after which it finally opens an explorer window for my hard
> drive.  Now I can select a file, or, more importantly, alter my preferences. 
> Any way around this?  Thanks.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Cannot retrieve quotes for some securities

2019-04-16 Thread John Ralls



> On Apr 15, 2019, at 9:37 PM, wendiallen via gnucash-user 
>  wrote:
> 
> Yahoo as JSON works.  Thank you.  One related question...  Since installing
> the additional software for online quotes, a command window pops up for a
> few seconds when GnuCash starts, as well as when I click "get quotes."  It's
> quite annoying.  Is there any way to suppress it?

Unfortunately it's built in to the way Perl--or any other command-line 
executable--works on Windows. To fix it you need to change perl.exe's 
"subsystem type" from "console" to "windows".

I'm not sure if Strawberry Perl has the code for that; look in C:\Strawberry 
Perl\bin for either perlw.exe, wperl.exe, or exetype.bat. if either of the 
first two are present just rename perl.exe to cperl.exe and (e.g.) wperl.exe to 
perl.exe. If not but exetype.bat is, then run:
  exetype.bat perl.exe windows.

If there's no exetype.bat you can get an exetype.pl that will do the same thing 
from CPAN,
  https://metacpan.org/pod/distribution/perl/win32/bin/exetype.pl

Regards,
John Ralls

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


Re: [GNC] Return of Capital

2019-04-17 Thread John Ralls



> On Apr 17, 2019, at 8:03 AM, cicko  wrote:
> 
> I'm trying to record the recommended transaction as
> 
> 2019-04-01 * Return of capital
>   Assets:Investments:Broker:Cash 500.00 USD
>   Assets:Investments:Broker:Shares:IPE100 IPE { 5.00 USD} [2000-01-01]
> @ 5.00 USD
>   Assets:Investments:Broker:Shares:IPE   -100 IPE {10.00 USD} [2000-01-01]
> @ 5.00 USD 
> 
> However, GC does not let me do that and reports the transaction as
> unbalanced, even after it adds the balancing split for the Trading Account.

Is IPE the SPDR Barclay's TIPS ETF? Are you sure that you got a return of 
capital and not an ordinary dividend?

Regards,
John Ralls

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


Re: [GNC] Some chinese words can not be displayed

2019-04-13 Thread John Ralls
Thanks for following up. I've made an entry on 
https://wiki.gnucash.org/wiki/GTK3 about it.

Regards,
John Ralls

> On Apr 13, 2019, at 3:51 PM, Richard Zhang  wrote:
> 
> Hi John,
> I put the settings.ini into the C:\Users\erzhang\AppData\Local\gtk-3.0 with 
> following settting:
> 
> [Settings]
> gtk-font-name=Microsoft YaHei 14
> 
> It back to normal.
> Thanks!
> BR/Richard
> 
> 
> -Original Message-
> From: Richard Zhang 
> Sent: 2019年3月27日 17:03
> To: 'John Ralls' 
> Cc: gnucash-user@gnucash.org
> Subject: RE: [GNC] Some chinese words can not be displayed
> 
> Hi John,
> Thanks for your reply.
> I will study the documents and try to fix it.
> BR//Richard
> 
> 
> -Original Message-
> From: John Ralls  
> Sent: 2019年3月25日 22:44
> To: Richard Zhang 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] Some chinese words can not be displayed
> 
> 
> 
>> On Mar 24, 2019, at 7:34 AM, Richard Zhang  wrote:
>> 
>> Hi Support,
>> I got a problem when I use the GNUCASH.
>> 
>> Environment: Window 10 Enterprise
>> Version: 1709
>> Language: English
>> 
>> Symptom: some words in menu and description can not be displayed.
>> [cid:image001.png@01D4E22A.DB249AA0]
>> 
>> Pls help.
> 
> You need to configure a font with better Unicode support. See 
> https://wiki.gnucash.org/wiki/GTK3. The hard part is figuring out which font 
> to use.
> 
> Regards,
> John Ralls
> 
> 

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


Re: [GNC] Finance::Quotes stopped working for me

2019-04-12 Thread John Ralls
Bruno,

That's weird. No, I can't think of anything associated with your mac's 
networking config that would cause perl and only perl to fail when using your 
router/modem and not your neighbors.

Regards,
John Ralls

> On Apr 12, 2019, at 8:35 PM, Bruno Acklin  wrote:
> 
> Hi John,
> 
> Thanks, confirmed that it’s nothing to do with Perl and gnucash / 
> financequote.
> 
> I connected to my neighbors Wifi and finance quote works like a charm. When I 
> go back through my router I times out again.
> Any suggestion if it is a DNS or a TCP, or UDP poor I should look for and 
> configure?
> 
> Best, Bruno
> 
>> On Mar 30, 2019, at 8:02 PM, John Ralls  
>> wrote:
>> 
>> Stockdump.pl isn't misinterpreting anything. You can pass it multiple 
>> symbols and it prepends the symbol to each message so that you know which 
>> message goes with which symbol.
>> 
>> It seems unlikely that it's a DNS issue, but you could take the laptop 
>> somewhere where there's public wifi and try from there. An Apple Store might 
>> be a good choice, because then you can show the problem to a "Genius" and 
>> see what they think.
>> 
>> I'm out of ideas for what could be borked with perl. You might try creating 
>> a new user and running stock dump as that user (you'll need to adjust 
>> permissions in your home directory) just to make sure that it isn't 
>> something goofy in your environment.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>>> On Mar 30, 2019, at 3:59 PM, Bruno Acklin  wrote:
>>> 
>>> John,
>>> 
>>> Thanks for your help and patience!
>>> 
>>> I did just that and updated Net::HTTP, as well as LWP, Date::Manip and 
>>> Finance::Quote again. All of them are confirmed up to date now.
>>> 
>>> But calling …/stockdump.pl still yields an "internal server error” 500:
>>> 
>>> Brunos-MacBook-Pro:~ backlin$ 
>>> ~/.cpan/build/Finance-Quote-1.47-FVw_VE/Examples/stockdump.pl yahoo_json 
>>> aapl
>>> $VAR1 = {
>>> 'aaplsymbol' => 'aapl',
>>> 'aaplsuccess' => 0,
>>> 'aaplerrormsg' => 'Error retrieving quote for aapl. Attempt to 
>>> fetch the URL 
>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl resulted in 
>>> HTTP response 500 (Internal Server Error)'
>>>   };
>>> 
>>> Why is stockdump.pl misinterpreting the parameters and prepending apple to 
>>> ‘symbol’ and ‘success’ and 'error msg’?
>>> 
>>> Still, calling the very URL in the error message using curl works instantly:
>>> Brunos-MacBook-Pro:~ backlin$ curl 
>>> https://query1.finance.yahoo.com/v7/finance/quote?symbols=aapl
>>> {"quoteResponse":{"result":[{"language":"en-US","region":"US","quoteType":"EQUITY","quoteSourceName":"Nasdaq
>>>  Real Time 
>>> Price","currency":"USD","fullExchangeName":"NasdaqGS","longName":"Apple ..
>>> 
>>> Could Perl address another "internal server” which times out? A DNS issue?
>>> Do you have any other suggestions to try, or can point out the program 
>>> hierarchy to trace these calls?
>>> (Again reminding that I have this problem on two independent installations, 
>>> and it appeared overnight, while gnucash on Desktop, and Perl Terminal 
>>> window on Laptop were open and running.)
>>> 
>>> Thanks, Bruno
>>> 
>>>> On Mar 28, 2019, at 6:15 PM, John Ralls  
>>>> wrote:
>>>> 
>>>> ~/.cpan/build/Finance-Quote-1.47-X/Examples/stockdump.p
>>> 
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Finance::Quotes stopped working for me

2019-04-13 Thread John Ralls
The URL is given several times in the thread, it's http, port 80. That aside, 
get real: A firewall that blocks a port when perl's LWP is the agent but not 
when curl or a web browser is?

Besides, the request isn't blocked, it's munged so that Yahoo! returns a 
500--server error response. So we have to imagine that the router can somehow 
tell that the packets are coming from curl and not messing with them or perl 
LWP and messing with them? That's a pretty amazing firewall.

Regards,
John Ralls

> On Apr 13, 2019, at 2:32 AM, Adrien Monteleone 
>  wrote:
> 
> More likely a blocked port though since the OP said curl works to retrieve 
> the same URL, but not perl. A look at the perl script will probably expose 
> the issue.
> 
> Regards,
> Adrien
> 
>> On Apr 13, 2019, at 4:29 AM, David Carlson  
>> wrote:
>> 
>> A different router could also mean a different ISP, a different DNS, and
>> that is just the starting point...
>> 
>> David Carlson
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Downgrading to 2.6.21

2019-04-11 Thread John Ralls
I managed to replicate the error on Win7 and I've debugged into it a bit. The 
gibberish in the pathname is because a wide-character string returned from 
Windows is getting interpreted as a normal-character string. But that's not the 
only problem, the path to the user-config-dir is getting overwritten with the 
candidate storage path, and that's what's causing the error.

For some reason this doesn't happen on Win10, so a parallel debugging session 
there is next.

Regards,
John Ralls


> On Apr 11, 2019, at 10:22 AM, Adrien Monteleone 
>  wrote:
> 
> Nevermind. I got lost in the thicket.
> 
> I see a message now that you already eliminated DropBox as the problem 
> because there are local paths that won’t save either.
> 
> Sorry for the noise.
> 
> Regards,
> Adrien
> 
>> On Apr 11, 2019, at 12:14 PM, Adrien Monteleone 
>>  wrote:
>> 
>> Colin,
>> 
>> This is what I understood as the point to test some messages ago.
>> 
>> Greg,
>> 
>> Several messages back someone mentioned needing to install the DropBox 
>> client to get real paths as opposed to some mapped paths. The reason for 
>> this is the mapped paths (which are displayed as real paths instead) are 
>> insanely longer than the real ones. (ostensibly using some sort of UUID in 
>> place of each path node) If you use the client, you’ll be using the real 
>> displayed paths that you see. The premise is that while DropBox is showing 
>> you what you think is the path, it is reporting something else to GnuCash. 
>> The path is being garbled by the error message because of non-standard 
>> characters in the mapped path from DropBox.
>> 
>> So the problem *might* be resolved, (or at least pinpointed) by showing FULL 
>> paths, because that would show you the path you think you are accessing 
>> isn’t really that short, it is MUCH longer.
>> 
>> Of course, this might not resolve the problem, but eliminating possibilities 
>> is part of chasing bugs. If you do have the desktop client installed, then 
>> you still have another problem, or you indeed found a bug.
>> 
>> Regards,
>> Adrien
>> 
>> 
>>> On Apr 11, 2019, at 10:58 AM, Colin Law  wrote:
>>> 
>>> And, to continue, I hit reply too soon. It is the actual path that
>>> gnucash sees not the mirage, so potentially something in the actual
>>> path is confusing GC.
>>> 
>>> Colin
>>> 
>>> On Thu, 11 Apr 2019 at 16:55, Colin Law  wrote:
>>>> 
>>>> In that case I misunderstood.  I thought the point was that Dropbox
>>>> does some clever path mapping that makes it look as if the file is at
>>>> the location you see in the browser, but actually that is a mirage.
>>>> It is actually somewhere else entirely.
>>>> 
>>>> Colin
>>>> 
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] macOS: Find... Functionality Not Present Beyond Description

2019-04-14 Thread John Ralls


> On Apr 14, 2019, at 7:50 AM, Jeff Kletsky  wrote:
> 
> 
> On 2/19/19 8:58 AM, John Ralls wrote:
>> 
>>> On Feb 18, 2019, at 6:49 PM, Jeff Kletsky  wrote:
>>> 
>>> 
>>> On 2/18/19 6:15 PM, John Ralls wrote:
>>>>> On Feb 18, 2019, at 3:31 PM, Jeff Kletsky  wrote:
>>>>> 
>>>>> I've downloaded the macOS release version of GnuCash 3.4, 3.4+ 
>>>>> (2018-12-30) and installed on two different machines, one running High 
>>>>> Sierra, the other running Mojave.
>>>>> 
>>>>> Neither machine seems to want to reveal anything in the search menu other 
>>>>> than Description and Contains. Even if another row is added, there is no 
>>>>> drop-down for any other options.
>>>>> 
>>>>> What are we missing here to get this needed functionality to work?
>>>>> 
>>>> Probably needs a re-spin of the bundle. I see that on several dialog 
>>>> boxes, I just hadn't noticed because my usual usage doesn't involve more 
>>>> than clicking OK on the Since-last-run.
>>>> 
>>>> Regards,
>>>> John Ralls
>>>> 
>>> Greatly appreciated, thanks!
>>> 
>>> We'll be able to get by until either there's a new release or I get a clean 
>>> account and builder up and running.
>> I just noticed something.
>> 
>> Do you have more than one monitor? If so, is GnuCash on the main one or (one 
>> of) the secondary one(s)? The surest way to tell which is "main" is to open 
>> System Preferences>Desktop & Screen Saver (shortcut: control-click on the 
>> desktop and select "Change Desktop Background"). Each monitor will get a 
>> dialog, and on all the secondary monitors the dialog will say "Secondary 
>> Desktop" in the title bar and will lack the close/hide/fullscreen stoplight 
>> in the upper left corner; the one on the main display will be a normal 
>> system preferences dialog with "Desktop & Screen Saver" in the title bar.
>> 
>> If it's all yes so far, try moving GnuCash to the main display and then 
>> opening the Find dialog (cmd-F or Edit>Find). Do the dropdowns work now?
>> 
>> Regards,
>> John Ralls
>> 
> 
> Yes, dual-monitor setup here.
> 
> Main window on secondary monitor
> 
> * Find Transaction window ("FTW") appears on secondary monitor
> * Pull-downs do not function
> * FTW can be dragged to primary monitor; touching pull-down area causes 
> "jump" of FTW to secondary monitor
> 
> 
> Drag main window to primary monitor
> 
> * FTW follows
> * FTW drop-downs function
> * FTW can be dragged to secondary monitor; touching pull-down area causes 
> "jump" of FTW to primary monitor
> 
> 
> 
> Also, GnuCash doesn't do well with the monitors going to sleep, usually 
> (always?) crashing on wake.
> 
> I'll watch it more carefully, but at least this one looks like a failure in 
> libgdk
> 
> 
> rocess:   Gnucash [61790]
> Path: /private/var/folders/*/Gnucash.app/Contents/MacOS/Gnucash
> Identifier:org.gnucash.Gnucash
> Version:   3.4-1 (3.4-1)
> Code Type: X86-64 (Native)
> Parent Process:??? [1]
> Responsible:   Gnucash [61790]
> User ID:
> Date/Time: 2019-04-14 07:39:13.606 -0700
> OS Version:Mac OS X 10.14.3 (18D109)
> Report Version:12
> Bridge OS Version: 3.3 (16P3133)
> Anonymous UUID:
> 
> 
> Time Awake Since Boot: 230 seconds
> 
> System Integrity Protection: enabled
> 
> Notes: Translocated Process
> 
> Crashed Thread:0  Dispatch queue: com.apple.main-thread
> 
> Exception Type:EXC_ARITHMETIC (SIGFPE)
> Exception Codes:   EXC_I386_DIV (divide by zero)
> Exception Note:EXC_CORPSE_NOTIFY
> 
> Termination Signal:Floating point exception: 8
> Termination Reason:Namespace SIGNAL, Code 0x8
> Terminating Process:   exc handler [61790]
> 
> Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
> 0   libgdk-3.0.dylib  0x00010eb6e3d4 configure_monitor + 
> 276
> 1   libgdk-3.0.dylib  0x00010eb6e49b 
> display_reconfiguration_callback + 139
> 2   com.apple.SkyLight0x7fff5909dc72 
> displayConfigFinalizedProc + 240
> 3   com.apple.SkyLight0x7fff590937f2 
> CGSPostLocalNotification + 420
> 4   com.apple.SkyLight0x7fff590933e4 (anonym

Re: [GNC] Currency Symbol

2019-04-14 Thread John Ralls


> On Apr 14, 2019, at 5:26 AM, Muhammad Bashir Al-Noimi  
> wrote:
> 
> On 2019-04-14 15:18, Muhammad Bashir Al-Noimi wrote:
>> Hi,
>> 
>> 
>> I use Turkish Lira as a primary currency in my file but I noticed after 
>> upgrading GnuCash to recent version (3.5) that "Expense Piechart" no longer 
>> recognize Turkish currency symbol (₺) while "Transaction Report" does!
>> 
>> 
>> How can I fix this issue?
>> 
>> 
>> Notes:
>> 
>>  * I'm using Microsoft Windows 10 with en_US local.
>>  * I tried to modify the currency from "Securities" window by replacing
>>₺ by £ it worked! so I believe there is something wrong about ₺ symbol.
>> 
>> 
>> https://en.wikipedia.org/wiki/Turkish_lira
>> 
> I forgot to mention some additional info:
> 
> * I use "Stylesheet : Technicolor" in "Expense Piechart" report.
> * I tried to modify "Technicolor" font from "Edit -> Style Sheets" but
>   it didn't fix the problem (default font is: Segoe UI)

The font is the right thing to change, but it looks like the piechart report 
isn't affected by the stylesheet font styles.

Chris Lam has been looking at styling the last few days, perhaps he has some 
insight.

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


Re: [GNC] GNUCASH Android

2019-05-27 Thread John Ralls



> On May 27, 2019, at 1:48 AM, Geert Janssens  
> wrote:
> 
> Op zondag 26 mei 2019 16:01:07 CEST schreef John Ralls:
>>> On May 26, 2019, at 3:27 AM, nor via gnucash-user
>>>  wrote:
>>> 
>>> I am aware that it is not a part of GNUC development. However it a lovely
>>> app on move specifically to view records/transactions from
>>> desktop.Unfortunately, Desktop XML ver 3.5 is not compatible with android
>>> version and hence cannot be imported.XML file in uncompressed. Appreciate
>>> advise.regardsnor
>> 
>> In which does the file not open, GnuCash or GnuCash for Android. On what
>> operating system for GnuCash? Have you tested earlier GnuCash versions? If
>> so, what is the latest one that works?
>> 
>> We haven't made any changes to the XML file schema in many years, so it's
>> unlikely that that's the problem.
>> 
>> Regards,
>> John Ralls
> 
> I just saw a ticket coming in on GnuCash for Android's bug tracker which 
> complains about not understanding the date format.
> 
> I can't find a public link to this ticket unfortunately, however here's the 
> content:
> 
> -
> hello, when i try to open a file saved with gnucash desktop v.3.5 (linux) i 
> receive an error on the datetime format.
> The errore says: "unable to parse transaction time - 2011-12-05 23:00:00"
> 
> I looked into the XML file but I don't see anything strange. This date is 
> under the  node.
> 
> I hope you can help me.
> thank you
> -
> 
> Did we change something in that area ?

Yes, I changed the times to save as UTC with no timezone offset instead of the 
local time with an offset to turn it back to UTC. Our parser didn't need any 
changes, seems GforA's doesn't take that into account. Since Ngewi seems to be 
busy with other stuff maybe I should make it write out a  offset on each 
date to accommodate him.

Regards,
John Ralls

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


Re: [GNC] Cannot run v3 on Windows 7 since a year

2019-05-27 Thread John Ralls
The useful part of the stack trace is at the bottom:
libstdc++-6.dll!__cxa_throw+0x5c
msvcrt.dll!free+0x39
libgnc-core-utils.dll!_ZN5boost9iterators6detail23operator_arrow_dispatchIRNS_10filesystem15directory_entryEPS4_E5applyES5_+0x11
msvcrt.dll!free+0x46
libgnc-core-utils.dll!_ZNK5boost9iterators6detail20iterator_facade_baseINS_10filesystem28recursive_directory_iteratorENS3_15directory_entryENS0_25single_pass_traversal_tagERS5_iLb0ELb0EEptEv+0x22
libgnc-core-utils.dll!gnc_path_find_localized_html_file+0x980
libgnc-core-utils.dll!gnc_path_find_localized_html_file+0xfce
libgnc-core-utils.dll!gnc_filepath_init+0xca
gnucash.exe+0x3b33
gnucash.exe+0x138b

It's throwing in a free() (probably via delete) from boost::filesystem called 
from gnc_path_find_localized_html_file.

Regards,
John Ralls

> On May 27, 2019, at 6:53 AM, Geert Janssens  
> wrote:
> 
> Unfortunately I can't interpret the Sysinternals stuff either.
> 
> Will gnucash 3.x start for a different user on your system ? That is, can you 
> log in as a user that never has used gnucash before and then try to start 
> gnucash ?
> 
> If it does, it may be tripping over some metadata on your PC or the metadata 
> migration, can you test the following:
> - locate the .gnucash directory in your user's home directory
>  This is typically c:\Users\\.gnucash
> - rename this directory to something else, like .gnucash.bkp
> - locate the %appdata%\GnuCash directory and rename it as well to something 
> like GnuCash.bkp
> - then install gnucash 3.5 and see if it starts.
> 
> Let us know if gnucash starts under these conditions.
> Note this is not intended to be your final setup! It will be missing your 
> saved reports, any open reports and tabs and other settings.
> It's a first start in trying to narrow down where it goes wrong.
> 
> Potentially a gdb backtrace could also shed a bit more light. As you had 
> Cygwin installed before, you may reinstall it and then use it to install gdb. 
> Next run gnucash from within gdb.
> 
> Geert
> 
> On zondag 21 april 2019 20:05:06 CEST Oliver Heidelbach via gnucash-user 
> wrote:
>> Yes, I had Cygwin installed and now deinstalled it accoording to their
>> uninstall instructions including removing the registry entries.
>> 
>> Same problem as before unfortunately.
>> 
>> The following is the call stack from the Sysinternals Process Explorer:
>> 
>> wow64cpu.dll!CpuGetContext+0x4
>> wow64.dll!Wow64KiUserCallbackDispatcher+0xcb
>> wow64win.dll+0x32bf9
>> ntdll.dll!KiUserCallbackDispatcher+0x1f
>> wow64win.dll+0x3fd4a
>> wow64win.dll+0x1ad9b
>> wow64.dll!Wow64SystemServiceEx+0xd7
>> wow64cpu.dll!TurboDispatchJumpAddressEnd+0x2d
>> wow64.dll!Wow64SystemServiceEx+0x1ce
>> wow64.dll!Wow64LdrpInitialize+0x42a
>> ntdll.dll!RtlImageDirectoryEntryToData+0x19a3
>> ntdll.dll!longjmp+0x2ca60
>> ntdll.dll!LdrInitializeThunk+0xe
>> USER32.dll!PeekMessageW+0x17b
>> USER32.dll!PeekMessageW+0x197
>> USER32.dll!DialogBoxIndirectParamW+0xfb
>> USER32.dll!DialogBoxIndirectParamAorW+0x108
>> USER32.dll!SoftModalMessageBox+0x757
>> USER32.dll!SoftModalMessageBox+0xa33
>> USER32.dll!MessageBoxTimeoutW+0x52
>> USER32.dll!MessageBoxTimeoutA+0x76
>> USER32.dll!MessageBoxExA+0x1b
>> USER32.dll!MessageBoxA+0x18
>> msvcrt.dll!strerror_s+0x649
>> msvcrt.dll!__threadhandle+0x466
>> msvcrt.dll!abort+0x26
>> libstdc++-6.dll!_ZN9__gnu_cxx27__verbose_terminate_handlerEv+0x163
>> libstdc++-6.dll!__cxa_throw+0x5c
>> msvcrt.dll!free+0x39
>> libgnc-core-utils.dll!_ZN5boost9iterators6detail23operator_arrow_dispatchIRN
>> S_10filesystem15directory_entryEPS4_E5applyES5_+0x11 msvcrt.dll!free+0x46
>> libgnc-core-utils.dll!_ZNK5boost9iterators6detail20iterator_facade_baseINS_1
>> 0filesystem28recursive_directory_iteratorENS3_15directory_entryENS0_25single
>> _pass_traversal_tagERS5_iLb0ELb0EEptEv+0x22
>> libgnc-core-utils.dll!gnc_path_find_localized_html_file+0x980
>> libgnc-core-utils.dll!gnc_path_find_localized_html_file+0xfce
>> libgnc-core-utils.dll!gnc_filepath_init+0xca
>> gnucash.exe+0x3b33
>> gnucash.exe+0x138b
>> ntdll.dll!RtlDeactivateActivationContextUnsafeFast+0x35f
>> 
>> 
>> I cannot interpret that, but maybe someone here can?
>> 
>> Oliver
>> 
>> Am 20.04.2019 um 11:09 schrieb Geert Janssens:
>>> Do you have other applications on your system that use guile (like
>>> Lilypond
>>> for example) ?
>>> 
>>> Regards,
>>> 
>>> Geert
>>> 
>>> Op donderdag 18 april 2019 13:26:08 CEST schreef Oliver Heidelbach via
>>> 
>>> gnucash-user:
>>

Re: [GNC] open network paths in gnucash

2019-05-24 Thread John Ralls



> On May 24, 2019, at 2:10 PM, Eric Haszlakiewicz  
> wrote:
> 
> On Fri, May 24, 2019 at 12:01 PM  wrote:
> 
> 
> 
>> By "regular file dialog" you mean the Windows native file chooser? It
>> doesn't use it because we need to add the backend selector, so we have to
>> use GtkFileChooser instead of GtkNativeFileChooser.
>> 
> 
> What's a "backend selector"?  Do you mean the "Data Format" dropdown when
> opening a completely new .gnucash file?  That isn't present when importing
> files, so the native file chooser could be used, no?

Yes. You're right, it's not present for file import, though it is for open and 
save as as well as new.

Regards,
John Ralls

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


Re: [GNC] Xcode project/buildable non X11 Mac version?

2019-05-27 Thread John Ralls
You shouldn't be surprised. It's a lot of work to build a separate GUI for each 
platform and very few FLOSS projects have the resources for that.

GnuCash's GUI is built with the Gtk framework and yes, its X11 heritage shows 
through quite strongly. If that's a deal breaker for you, too bad.

There's no "tyranny of vocal minorities" in open source. There's a tyranny of 
the tiny minority of dedicated volunteers who put millions of hours of work 
every year into open source programs and give them away. You can accept the 
gift or not, your choice.

And roger, we don't think that every download turns into a user.

Regards,
John Ralls

> On May 27, 2019, at 10:43 AM, kentsor  wrote:
> 
> John Ralls-2 wrote
>> No, no one has ever undertaken a MacOS-native UI for GnuCash. 
> 
> I'm surprised to hear that. The program could be very useful and far more
> popular, but the list of UI issues I could draw up would be a long one
> indeed. Accounting is unpleasant enough that I would not put up with a
> program that looks and works like this. If it was just a few issues I'd be
> more than willing to chip in and submit fixes as I have for two other
> projects but this is just so thoroughly painful and alien to use. 
> I've always seen it as the perpetual tyranny by the vocal minorities that is
> the bane of so many open source projects, forcing conformity to whatever pet
> linux distro of the day over mass appeal and usefulness to the general
> public. 
> 
> I would also say that download counts of a given OS build is not any
> indication of users willing to use the program. 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Xcode project/buildable non X11 Mac version?

2019-05-27 Thread John Ralls



> On May 27, 2019, at 9:33 AM, kentsor  wrote:
> 
> Much as I'd like to use a QB alternative, as a Mac user I can not stand
> looking at GNUCash as it is now. The UI is staggeringly bad. The money I
> save is not worth using this.
> 
> There must have been attempts by other Mac people to replace the UI in the
> past. Most likely abandoned years ago so it'd be old versions but that's ok,
> my accounting needs are straightforward. Where can I go to download (dare I
> hope) an old Xcode project for an UI replacement for GNUCash ? 

No, no one has ever undertaken a MacOS-native UI for GnuCash. One of the core 
developers sketched out a QT one, covering only the basics, as an experiment a 
few years ago. The code is still present and I think working in the 2.6 series. 
You can use CMake to generate an Xcode project if you're averse to compiling on 
the command line. See https://wiki.gnucash.org/wiki/Cutecash. Mind, it will 
look different from the Gtk UI that the distributed GnuCash uses, but it still 
won't look native.

Regards,
John Ralls


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


Re: [GNC] GNUCASH Android

2019-05-27 Thread John Ralls



> On May 27, 2019, at 7:28 AM, Geert Janssens  
> wrote:
> 
> On maandag 27 mei 2019 16:21:34 CEST John Ralls wrote:
>>> On May 27, 2019, at 1:48 AM, Geert Janssens 
>>> wrote:> 
>>> Op zondag 26 mei 2019 16:01:07 CEST schreef John Ralls:
>>>>> On May 26, 2019, at 3:27 AM, nor via gnucash-user
>>>>>  wrote:
>>>>> 
>>>>> I am aware that it is not a part of GNUC development. However it a
>>>>> lovely
>>>>> app on move specifically to view records/transactions from
>>>>> desktop.Unfortunately, Desktop XML ver 3.5 is not compatible with
>>>>> android
>>>>> version and hence cannot be imported.XML file in uncompressed.
>>>>> Appreciate
>>>>> advise.regardsnor
>>>> 
>>>> In which does the file not open, GnuCash or GnuCash for Android. On what
>>>> operating system for GnuCash? Have you tested earlier GnuCash versions?
>>>> If
>>>> so, what is the latest one that works?
>>>> 
>>>> We haven't made any changes to the XML file schema in many years, so it's
>>>> unlikely that that's the problem.
>>>> 
>>>> Regards,
>>>> John Ralls
>>> 
>>> I just saw a ticket coming in on GnuCash for Android's bug tracker which
>>> complains about not understanding the date format.
>>> 
>>> I can't find a public link to this ticket unfortunately, however here's
>>> the
>>> content:
>>> 
>>> -
>>> hello, when i try to open a file saved with gnucash desktop v.3.5 (linux)
>>> i
>>> receive an error on the datetime format.
>>> The errore says: "unable to parse transaction time - 2011-12-05 23:00:00"
>>> 
>>> I looked into the XML file but I don't see anything strange. This date is
>>> under the  node.
>>> 
>>> I hope you can help me.
>>> thank you
>>> -
>>> 
>>> Did we change something in that area ?
>> 
>> Yes, I changed the times to save as UTC with no timezone offset instead of
>> the local time with an offset to turn it back to UTC. Our parser didn't
>> need any changes, seems GforA's doesn't take that into account. Since Ngewi
>> seems to be busy with other stuff maybe I should make it write out a 
>> offset on each date to accommodate him.
>> 
>> Regards,
>> John Ralls
> 
> That looks like a reasonable workaround.

OK, pushed. Windows users can try tomorrow's nightly.

Regards,
John Ralls

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


Re: [GNC] GNUCASH Android

2019-05-26 Thread John Ralls


> On May 26, 2019, at 3:27 AM, nor via gnucash-user  
> wrote:
> 
> I am aware that it is not a part of GNUC development. However it a lovely app
> on move specifically to view records/transactions from
> desktop.Unfortunately, Desktop XML ver 3.5 is not compatible with android
> version and hence cannot be imported.XML file in uncompressed. Appreciate
> advise.regardsnor

In which does the file not open, GnuCash or GnuCash for Android. On what 
operating system for GnuCash? Have you tested earlier GnuCash versions? If so, 
what is the latest one that works?

We haven't made any changes to the XML file schema in many years, so it's 
unlikely that that's the problem.

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


Re: [GNC] GC CTD lost saved reports

2019-06-02 Thread John Ralls



> On Jun 2, 2019, at 11:37 AM, Elmar  wrote:
> 
> OK, this is a weird.  I was editing some of the options in a report, 
> specifically unhighlighting one account and highlighting another to include, 
> and tried to save the report.  GC crashed to desktop.  Reopening it (open 
> anyway), now GC tells me that I have no saved reports at all!  Looking in 
> .gnucash folder, I see saved-reports-2.4 (and its backup file) dated in 2018, 
> so they are there, and they are in the backup 7zip archive dated 15APR2019 
> (created by BackupGnuCash.jar along with the .gnucash.gcm and the .gnucash 
> files itself).  OTOH aqbanking works fine.  This is GC 3.5 running under 
> Linux Mint 19.1 Mate desktop.  How do I get my reports back? - Elmar

GnuCash 3 moved the configuration files, see 
https://wiki.gnucash.org/wiki/Configuration_Locations. Look for 
saved-reports-2.8 in the new location.

Regards,
John Ralls

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


Re: [GNC] Additions to price database not being displayed

2019-06-07 Thread John Ralls



> On Jun 7, 2019, at 8:31 AM, Colin Law via gnucash-user 
>  wrote:
> 
> On Fri, 7 Jun 2019 at 14:40, David Lynch via gnucash-user
>  wrote:
>> 
>> I recently upgraded from 3.3 to 3.5 on Windows 10.
>> 
>> I add prices to the share price database Tools->Price Database->FUND,
>> then click on a line then Add.
>> 
>> When I click OK in the Add dialog, the price added is not displayed. It
>> is there, however: it shows if I close the share prices, open another
>> share, close that and reopen the original share.
>> 
>> All worked as expected in 3.3. Am I doing something wrong?
> 
> I believe it is a bug, I am seeing that too.  I don't know whether it
> has been reported.

Getting windows to redraw after a data update seems to have changed with a 
recent upgrade to Gtk in the Windows builds. Bob Fewell has fixed some of them, 
please try the latest nightly from https://code.gnucash.org/builds/win32/maint 
to see if this has been fixed already. If not, please file a bug.

Regards,
John Ralls

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


Re: [GNC] Pending Edit Behavior in GnuCash

2019-06-06 Thread John Ralls


> On Jun 6, 2019, at 1:21 PM, Colin Law  wrote:
> 
> On Thu, 6 Jun 2019 at 19:04, Adrien Monteleone
>  wrote:
>> 
>> 
>>> On Jun 6, 2019, at 12:40 PM, David Carlson  
>>> wrote:
>>> 
>>> Adrien,
>>> 
>>> Looking at your comments, I have two questions.
>>> 
>>> 1. Does SQLite not allow pending edits at all? or is it after every 
>>> keystroke?  How do you avoid accidental deletions?
>> 
>> Not sure specifically what you mean by ‘pending edits'. I think writes are 
>> supposed to be instant, but I haven’t tested exactly how ‘instant’ —as by 
>> keystroke, Tab, or Enter as a commit. I don’t know that I’ve accidentally 
>> deleted something critical, certainly not an entire transaction. I might 
>> have inadvertently changed an account assignment to something I didn’t want, 
>> or selected an entire memo and deleted it when I only wanted to delete a 
>> portion of it, but that is an easy fix, especially as I’ll notice it 
>> immediately. (I wish CMD-Z ‘undo’ worked though - since it doesn’t, perhaps 
>> writes are by keystroke?) As long as the app is still open, I just make any 
>> changes I need. I’m not prevented from doing so. (I also keep the app open 
>> 24/7 and only close to do an update of GC itself, or the OS)
> 
> I believe the transaction is not saved until you hit that last Enter
> key to do it.  There is, after all, a Cancel button at the top that
> allows one to revert the transaction being edited back to what it was
> originally.

Mostly right: Committing the edit immediately generates a database update. If 
it's editing an object with a dialog box (including transactions with the 
Transfer Dialog) then clicking the OK button commits. For transactions in the 
register, it's hitting Enter, tabbing off the end, or clicking on a different 
transaction and then confirming the edit in the message box.

Regards,
John Ralls

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


Re: [GNC] File not found, file in history

2019-06-08 Thread John Ralls
Please file a bug report about the crashes and attach (don't paste!) a crash 
report from /Applications/Utilities/Console.

Regards,
John Ralls


> On Jun 8, 2019, at 11:33 AM, Centins@rq  wrote:
> 
> I think this was the problem. I recently added my Desktop to iCloud and think 
> GNUCash wouldn’t accept the remote file.
> 
> Others mentioned backups, and I have, but none were opening and GNUCash kept 
> doing the blank book thing. Confusing and finding help was hard since I 
> couldn’t find any troubleshooting till this list. 
> 
> I’ve solved the data file issue, thanks for the help, but GNUCash is still 
> crashing :|
> 
>> On Jun 8, 2019, at 6:28 AM, Greg Feneis  wrote:
>> 
>> Also, unless things have recently changed, on Macs, I recall there's a
>> curious behavior where clicking on the file you want to open doesn't
>> necessarily open that file. While it will start GnuCash, GnuCash only opens
>> the most recent file in the recent file list.
>> 
>> It happens, occasionally, that a Mac user will relocate their file and then
>> click on it to start using it. GnuCash then ( starts, tries to open the
>> most recent file in the recent file list, and can't find it because it was
>> moved, and ) claims the file the user just click on cannot be found.
>> 
>> The solution is the same as Adrian has already outlined. After GnuCash
>> starts and the errors have been dismissed, use file>open to navigate to and
>> open the correct file.
>> 
>> Kind regards, Greg Feneis
>> (Galaxy S7)
>> 
>> 
>> On Fri, Jun 7, 2019, 20:52 Adrien Monteleone 
>> wrote:
>> 
>>> Anytime you open GnuCash and it can’t open your data file it will open a
>>> ‘blank’ file because it has to have something open. That is what the
>>> Giuseppe is seeing.
>>> 
>>> Giuseppe,
>>> 
>>> Your best bet is to follow previous advice.
>>> 
>>> Open GnuCash.
>>> 
>>> Disregard any messages and pay no notice to a blank file.
>>> 
>>> Click the File menu and choose the Open option.
>>> 
>>> Navigate to where your file is stored, and select it.
>>> 
>>> Then GnuCash will remember it after close and will re-open that last used
>>> file next time.
>>> 
>>> Until and unless you get this far, I don’t know we can help much more.
>>> 
>>> If you have zero idea where your data file is stored, then we can help
>>> somewhat in that regard, just let us know that is the problem.
>>> 
>>> Regards,
>>> 
>>> Adrien
>>> 
>>> 
>>> 
>>>> On Jun 7, 2019, at 10:24 PM, Greg Feneis  wrote:
>>>> 
>>>> Please remember to send replies to the list, not just the members you are
>>>> replying to.
>>>> 
>>>> Macs aren't my strength here, but every time you start GnuCash, if
>>> GnuCash
>>>> starts with a message saying it can't find a file, then once you get past
>>>> the screen that asks you if you want to remove it from the recent file
>>>> list, what you have is GnuCash running with a default empty file. I
>>>> wouldn't bother saving that. Instead, click the file menu and select
>>> open,
>>>> then point to the file you usually use. You may have to find that file,
>>>> using the Mac's file manager, then use GnuCash file>open to get to where
>>>> the file is and open it.
>>>> 
>>>> Kind regards, Greg Feneis
>>>> (Galaxy S7)
>>>> 
>>>> 
>>>>> On Fri, Jun 7, 2019, 18:41 Giuseppe Quinn  wrote:
>>>>> 
>>>>> I’m running MacOS 10.14.5
>>>>> 
>>>>> In the attached screenshot you can see the msg I’m getting. Originally,
>>>>> the file name was empty
>>>>> 
>>>>> 
>>>>> 
>>>>> If “No” or “Yes” is selected the following window opens.
>>>>> 
>>>>> 
>>>>> 
>>>>> Nothing I tried changed anything, till I selected save and it asked for
>>> a
>>>>> name, and that’s how “WHatisthis” became the “missing” file from the
>>> first
>>>>> image. I have plenty of these files;
>>>>> 
>>>>> 
>>>>> Which are the ones I want to open, and I’ve tried opening GNUCash by
>>>>> clicking various versions of these.
>>>>> 
>>>>> HELP!!!
>>>>> 
>>>>> On Ju

Re: [GNC] Additions to price database not being displayed

2019-06-08 Thread John Ralls



> On Jun 8, 2019, at 12:40 AM, Colin Law  wrote:
> 
> On Fri, 7 Jun 2019 at 17:27, John Ralls  wrote:
>> 
>> 
>> 
>>> On Jun 7, 2019, at 8:31 AM, Colin Law via gnucash-user 
>>>  wrote:
>>> 
>>> On Fri, 7 Jun 2019 at 14:40, David Lynch via gnucash-user
>>>  wrote:
>>>> 
>>>> I recently upgraded from 3.3 to 3.5 on Windows 10.
>>>> 
>>>> I add prices to the share price database Tools->Price Database->FUND,
>>>> then click on a line then Add.
>>>> 
>>>> When I click OK in the Add dialog, the price added is not displayed. It
>>>> is there, however: it shows if I close the share prices, open another
>>>> share, close that and reopen the original share.
>>>> 
>>>> All worked as expected in 3.3. Am I doing something wrong?
>>> 
>>> I believe it is a bug, I am seeing that too.  I don't know whether it
>>> has been reported.
>> 
>> Getting windows to redraw after a data update seems to have changed with a 
>> recent upgrade to Gtk in the Windows builds. Bob Fewell has fixed some of 
>> them, please try the latest nightly from 
>> https://code.gnucash.org/builds/win32/maint to see if this has been fixed 
>> already. If not, please file a bug.
> 
> I am seeing it on Ubuntu with 3.5.  Sorry, I should have said that.

The latest 19.04? That's probably got the same gtk-3-24 that's causing the 
behavior on Windows; the catch is that there's no nightly for Ubuntu 19.04 so 
you'd have to build it yourself from git source.

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


Re: [GNC] ofxtools - a Python OFX library

2019-05-28 Thread John Ralls



> On May 28, 2019, at 7:10 AM, csingley  wrote:
> 
> Some of you might be interested in a project I've been working on:
> 
> https://pypi.org/project/ofxtools/
> 
> This originally started almost 10 years ago when I asked Jeremy Jongsma if
> he minded if I reworked his ofx.py script (he didn't).  One thing led to
> another, and I ended up implementing a superset of libofx in Python (as you
> do).  It's grown into a sort of a Swiss army knife for dealing with OFX
> data.
> 
> Y'all are all hooked up with AqBanking, so I suppose you don't have much
> need of the meat of the library.  However I have recently been beefing up
> the client utility, which might be of interest to those trying to set up
> connections to download OFX data.  It contains a listing of every FI from
> the old MS Money database that's still online, along with working connection
> parameters (URL, OFX version, ORG, FID, BROKERID, along with oddball markup
> formatting requirements for FIs like Vanguard).  You can use this to set up
> AqBanking direct connect, or download the data directly.
> 
> ofxtools can generate OFX, so it's pretty handy for writing conversion
> utilities from other formats into OFX so the data can be imported.  It can
> also edit OFX data, so it can be helpful in standardizing the bizarre
> variety of protocol implementation quirks seen at various FIs.  Working in
> Python makes it pretty easy to develop something that works.
> 
> I hope an announcement on this list isn't in poor taste - it's certainly no
> kind of commercial solicitation.  I just hope to make it easier for users of
> free software to get access to their financial data, and for developers to
> work with it.  Feedback is welcome.
> 
> Cheers, and thanks to the GnuCash developers for continuing to produce great
> software.
> 

Thanks.

A couple of things you might be interested in: We use AQBanking for OFX Direct 
Connect imports, but if you import an OFX or QFX file we use 
https://github.com/libofx/libofx.

The other is that there's a more up-to-date database of OFX Direct-Connect 
supporting institutions at https://ofxhome.com. AQBanking retrieves its 
connection parameters from there.

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


Re: [GNC] Pending Edit Behavior in GnuCash

2019-06-05 Thread John Ralls
There's also cutting, using either ctrl/cmd-X or Edit>Cut Split?

https://bugs.gnucash.org/show_bug.cgi?id=797249
https://github.com/Gnucash/gnucash/pull/517

Regards,
John Ralls


> On Jun 5, 2019, at 3:04 PM, Adrien Monteleone 
>  wrote:
> 
> Update on the bug.
> 
> I just tested this under the following circumstance:
> 
> 1. I started entering a transaction with a description that produced an 
> auto-fill of several splits.
> 2. The auto-fill contained 2 splits anchoring to the current register.
> 3. Attempting to right-click and ‘delete split’, using the toolbar button, or 
> using the Transaction > Delete Split menu entry on the 1st anchoring split 
> fired the warning and told me I *cannot* delete this split. My only choice 
> was to accept this, leave the split in place and proceed.
> 4. Attempting to delete the second anchoring split, by either means, was 
> successful, without warning, and without blowing up the transaction, because 
> there was a previous anchoring split still tying it to the current register - 
> results as expected.
> 
> I also tested a fresh transaction with a new description and deleted the 
> anchor split. It erased the transaction completely. Perhaps it should either 
> still fire the warning, or at least leave you editing the transaction without 
> deleting date/num/description/notes, et cetera until you hit Enter to commit.
> 
> Finally, I tested entering another split into a fresh transaction, without 
> putting any memo or amount on the anchoring split. When I tried to delete the 
> anchoring split, I received the warning and was not allowed to delete it.
> 
> So it seems the last of the inconsistent behavior is when entering a fresh 
> transaction and trying to delete the anchor split before entering other 
> splits. I’ll file a bug on this shortly.
> 
> Regards,
> Adrien
> 
>> On Jun 5, 2019, at 4:51 PM, Adrien Monteleone 
>>  wrote:
>> 
>> 
>> 
>>> On Jun 5, 2019, at 3:06 PM, David Carlson  
>>> wrote:
>>> 
>>> I might as well get this debate started now.  Another thread has started a
>>> discussion about unsplitting transactions, pointing out that there is an
>>> inconsistency between using the various  Transaction > [edit] Split keys
>>> and the conventional keystroke editing method using the Tab key to navigate
>>> around a transaction.
>>> I think there should be a warning for any editing action that deletes a
>>> split line, including tabbing off the anchor line.  Obviously, edits to
>>> correct account assignment errors must be allowed and not be overly
>>> encumbered by unnecessary warnings.
>>> 
>> 
>> David,
>> 
>> As I recently (a few minutes ago) noted in that other thread, this is 
>> allegedly fixed as of 3.4. (https://bugs.gnucash.org/show_bug.cgi?id=796978) 
>> Perhaps the commit didn’t work as expected. I’m getting ready to test it.
>> 
>> 
>>> GnuCash, at least in the 2.6.xx series usually prohibits leaving a
>>> transaction that contains pending edits without using the Enter key to
>>> commit the edits, but it has some exceptions which set up some difficult
>>> situations when finally trying to do a manual File > Save.  At that point
>>> it asks if you want to save edits in some register view which may even be
>>> accidental edits or keystrokes that would delete desired data.
>>> 
>>> The most common action (for me) that sets this up is to start an edit in
>>> some register then navigate to another register without first saving the
>>> pending edit.  This easily happens if the user is reviewing results from
>>> the Since Last Run assistant especially if a cat crosses the keyboard.
>> 
>> Using Sqlite backend, of course I get instant saves so I don’t see this 
>> issue anymore, but that sort of ambiguous ’save edits’ question is 
>> disconcerting if you are pretty sure you’ve committed all transactions, and 
>> now you’re being told you haven’t.
>> 
>>> 
>>> I can see the reasoning that often users may need to view other registers
>>> to compare the transaction currently being edited to something else, so I
>>> do not want to prevent that.  I would propose that the tabs containing
>>> pending edits flash in some way to catch the user's attention so he can
>>> find his way back to see if it was cat-tracks or a real pending edit.
>> 
>> Interesting idea. Though this might interfere with the custom tab colors, I 
>> like the idea of some visual indicator that something has been edited and 
>> needs attention. (perhaps a bold or ita

Re: [GNC] Trace file curiosity

2019-05-28 Thread John Ralls



> On May 28, 2019, at 9:42 AM, Greg Feneis  wrote:
> 
> Hi Folks,
> 
> I'm running 2.6.21 and took a look at recent trace files just out of
> curiosity.  They all say various things, but practically all have this one
> note in common:
> 
> * 20:33:21  WARN  Could not spawn perl: Failed to execute
> child process (No such file or directory)
> 
> Does anyone know what causes this?  I'm not having a problem or anything,
> just curious what's going on.

It's GnuCash looking for perl to see if it should enable online quotes, utterly 
routine. The message should probably be reduced to an INFO.

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


Re: [GNC] Online Banking Wedged Suddenly

2019-06-11 Thread John Ralls



> On Jun 11, 2019, at 5:00 PM, Hook  wrote:
> 
> I solved my problem.
> 
> While looking for the password info, I found some lockimng-related files in
> C:\Users\me\aqbanking\settings\users.  They looked like
> 
> uid%3a%3a0001.conf.lck.DigitalStorm-PC-17640
> uid%3a%3a0001.conf.lck
> 
> I deleted them and the expected behavior returned.
> 
> Very frustrating.

That's interesting. It would have been useful to know how old they were. Do you 
remember crashing AQBanking recently?

Regards,
John Ralls

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


Re: [GNC] Online Banking Wedged Suddenly

2019-06-10 Thread John Ralls
Nope, it's not per-session.

Regards,
John Ralls


> On Jun 10, 2019, at 9:20 AM, Jonathan Rosenberg  wrote:
> 
>> IIUC your complaint is that Get Transactions is proceeding without asking 
>> for your password on each account. There's a check box on the little dialog 
>> for entering the password to tell
>> AQBanking to save it and I suppose you must have checked it at some point. 
>> You can undo the setting in Preferences>Online Banking>Remember the PIN in 
>> memory (3rd-from-last checkbox).
> 
> But that box only takes effect AFTER I have entered a password in that
> session, yes?  GC never requests a password.
> 
> --
> Jonathan Rosenberg
> Founder & Executive Director
> Tabby's Place, a Cat Sanctuary
> http://www.tabbysplace.org/
> 
> On Sun, Jun 9, 2019 at 10:31 PM John Ralls  wrote:
>> 
>> 
>> 
>>> On Jun 9, 2019, at 10:29 AM, Hook  wrote:
>>> 
>>> I have been using v3.5 on Win 10 for some time.
>>> 
>>> Yesterday, online banking started acting weirdly.  The behavior continues
>>> today.
>>> 
>>> When I use Actions -> Online Actions -> Get Transactions ...
>>> 
>>> the action proceeds without requesting a password.  This happens for all 3
>>> accounts that I use.
>>> 
>>> I have exited and reentered GC.  No change.
>>> 
>>> Any ideas?
>>> 
>> 
>> IIUC your complaint is that Get Transactions is proceeding without asking 
>> for your password on each account. There's a check box on the little dialog 
>> for entering the password to tell AQBanking to save it and I suppose you 
>> must have checked it at some point. You can undo the setting in 
>> Preferences>Online Banking>Remember the PIN in memory (3rd-from-last 
>> checkbox).
>> 
>> Regards,
>> John Ralls
>> 
> 
> 
> -- 
> 
> Jonathan Rosenberg
> Founder & Executive Director
> Tabby's Place, a Cat Sanctuary
> http://www.tabbysplace.org/

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


Re: [GNC] Online Banking Wedged Suddenly

2019-06-09 Thread John Ralls



> On Jun 9, 2019, at 10:29 AM, Hook  wrote:
> 
> I have been using v3.5 on Win 10 for some time.
> 
> Yesterday, online banking started acting weirdly.  The behavior continues
> today.
> 
> When I use Actions -> Online Actions -> Get Transactions ...
> 
> the action proceeds without requesting a password.  This happens for all 3
> accounts that I use.
> 
> I have exited and reentered GC.  No change.
> 
> Any ideas?
> 

IIUC your complaint is that Get Transactions is proceeding without asking for 
your password on each account. There's a check box on the little dialog for 
entering the password to tell AQBanking to save it and I suppose you must have 
checked it at some point. You can undo the setting in Preferences>Online 
Banking>Remember the PIN in memory (3rd-from-last checkbox).

Regards,
John Ralls

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


Re: [GNC] no user assigned error message

2019-06-10 Thread John Ralls



> On Jun 7, 2019, at 1:05 PM, NHEngineer  wrote:
> 
> I'm a brand new user so please be easy on me.  I was a Quicken user but I'm
> not going to subscribe to the new owner's blackmail demand so I've chosen to
> try to learn gnuCASH.  I struggled through the account set-up and I thought
> I did everything right - guess I missed something.  The gnu help didn't help
> me much.  It may be the the 'no user assigned' is triggered by many
> different errors.  I search "no user assigned" here and only found two
> threads neither of which applied to my problem.
> 
> I thought I followed the instruction for setting up my checking account at
> Northway Bank in Berlin, NH properly.  It was a struggle but I thought I was
> successful.  'Thought' being the operative word.  When I tried to transfer
> from the Northway account to my gnu file, I got this error message:
> 
> <http://gnucash.1415818.n4.nabble.com/file/t378656/NoUserAssignedError.jpg> 
> 
> When I closed that window, I got this one:
> 
> <http://gnucash.1415818.n4.nabble.com/file/t378656/NoUserAssignedError02.jpg> 
> 
> Help!
> 

That means that you didn't assign a user (did you even create one?) to the bank 
account in AQBanking setup.

But before you put any more time into it, are you sure that Northway Bank even 
supports OFXDirectConnect? 
https://www.northwaybank.com/personal/online-banking, under ONLINE BANKING 
FEATURES says "Download account balances and transaction history for upload 
into Quicken or QuickBooks", implying that you can download files for import, 
not connect directly with accounting software.

There's no entry for Northway Bank in https://www.ofxhome.com, another 
indication that they might not support OFX DirectConnect. Note that OFX 
WebConnect, where you log in via the website and the browser somehow transfers 
a security token to Quicken, is *not supported* by AQBanking.

Regards,
John Ralls

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


Re: [GNC] Online Banking Wedged Suddenly

2019-06-11 Thread John Ralls



> On Jun 11, 2019, at 9:56 AM, Stephen M. Butler  wrote:
> 
> On 6/11/19 5:21 AM, Jonathan Rosenberg via gnucash-user wrote:
>> I started Gnucash, found the setting, unchecked it.  Same result.
>> When i do Actions -> Online Actions -=> Get transactions... it
>> executes without asking for the PIN/password.  This happens for all
>> accounts.
>> 
>> I exited GC & tried again  Same result.
>> 
>> BTW: if the PIN is saved in memory, then exiting GC should clear it, yes?
>> 
>> On Mon, Jun 10, 2019 at 10:18 PM John Ralls  wrote:
>>> Nope, it's not per-session.
>>> 
>>> Regards,
>>> John Ralls
> 
> 
> Reading between the lines, I think John is trying to tell you it is
> sticky.  Permanently sticky.  Once you told it to save, it knows it for
> all time.  Who knows, it might forget when we go to Y10K!

Not exactly, just that "memory" really means "storage": If the preference is 
set, AQBanking remembers persistently across sessions. If it's unset, AQBanking 
forgets it, no restarts required.

I just tested and it works that way for me. I don't understand why it works 
differently for Jonathan.

Regards,
John Ralls

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


Re: [GNC] Trustworthy easy way to install gnucash 3.5 on ubuntu?

2019-05-18 Thread John Ralls
Nope. We only change dependencies in a major release, and anyway none of those 
are new dependencies. Since Ubuntu has a GnuCash3 package already you should be 
able to install all the dependencies with 
  sudo apt-get build-dep gnucash
as explained in 
https://wiki.gnucash.org/wiki/Building_On_Linux#Building_and_Installing_the_GnuCash_Program.

Regards,
John Ralls

> On May 18, 2019, at 10:56 AM, Adrien Monteleone 
>  wrote:
> 
> Wow, last time I built GC for Xenial I didn’t have to install all of that 
> mess. Was there a major change in dependencies between 3.1 and 3.5?
> 
> Regards,
> Adrien
>> On May 18, 2019, at 11:28 AM, Stephen M. Butler  wrote:
>> 
>> On 5/17/19 5:13 AM, Nathan T Alexander wrote:
>>> OK I tried compiling it myself.
>>> 
>>> I downloaded the tarball and unzipped it into a /usr/loca/src/build-gnucash:
>>> 
>>> Then I tried to follow the instructions here: 
>>> https://wiki.gnucash.org/wiki/Building_On_Linux , so I ran:
>>> 
>>> n@g:/usr/local/src/build-gnucash-3.5$ sudo cmake 
>>> -DCMAKE_INSTALL_PREFIX=/usr/local
>>> -- Checking for module 'glib-2.0>=2.40'
>>> --   
>>> CMake Error at /usr/share/cmake-3.5/Modules/FindPkgConfig.cmake:367 
>>> (message):
>>> A required package was not found
>>> Call Stack (most recent call first):
>>> /usr/share/cmake-3.5/Modules/FindPkgConfig.cmake:532 
>>> (_pkg_check_modules_internal)
>>> common/cmake_modules/GncFindPkgConfig.cmake:253 (PKG_CHECK_MODULES)
>>> CMakeLists.txt:194 (gnc_pkg_check_modules)
>>> 
>>> 
>>> -- Configuring incomplete, errors occurred!
>>> See also "/usr/local/src/build-gnucash-3.5/CMakeFiles/CMakeOutput.log".
>>> n@g:/usr/local/src/build-gnucash-3.5$ 
>>> 
>>> 
>>> Now I am stuck, how do a learn to read the output of these messages, it is 
>>> not clear what I am supposed to do? How do I learn this stuff or what do I 
>>> do?
>>> 
>>> I just want gnucash to run.
>>> 
>> There are a lot of dependencies that you need to load first.  The
>> easiest is to run the below script (provided by another user on the list):
>> 
>> #!/bin/bash
>> clear
>> # this script was developed to install a basic development environment
>> # for GnuCash > V3 on a Linux Mint 19 OS
>> echo "Script to install development environment for GnuCash ~V3.0"
>> echo ""
>> echo "Installing build environment:"
>> echo "   build-essential"
>> sudo apt install build-essential
>> echo "   cmake"
>> sudo apt install cmake
>> echo "   ninja-build"
>> sudo apt install ninja-build
>> echo ""
>> echo "Installing GnuCash dependencies and development headers:"
>> echo "   libglib2.0 and dev headers"
>> sudo apt install libglib2.0 libglib2.0-dev
>> echo "   libxml2 libxml++2.6-dev libxml2-utils"
>> sudo apt install libxml2 libxml++2.6-dev libxml2-utils
>> echo "   libxslt1.1 libxslt1-dev"
>> sudo apt install libxslt1.1 libxslt1-dev
>> echo "   libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev"
>> sudo apt install libwebkit2gtk-4.0-37 libwebkit2gtk-4.0-dev
>> echo "   gtk+3.0 libgtk-3-dev"
>> sudo apt install gtk+3.0 libgtk-3-dev
>> echo "   zlib1g zlib1g-dev"
>> sudo apt install zlib1g zlib1g-dev
>> echo "   guile-2.0 guile-2.0-dev"
>> sudo apt install guile-2.0 guile-2.0-dev
>> echo "   swig   3.0 on LM19  2.0 on Lm18?"
>> sudo apt install swig
>> echo "   sudo apt-get install libboost-all-dev"
>> sudo apt-get install libboost-all-dev
>> echo "   libsecret-1-0 libsecret-1-0-dev"
>> sudo apt-get install libsecret-1-0 libsecret-1-0-dev
>> echo " AqBanking Tools"
>> echo "   aqbanking-tools libaqbanking-dev"
>> sudo apt-get install aqbanking-tools libaqbanking-dev
>> echo "   gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev"
>> sudo apt-get install gwenhywfar-tools libgwenhywfar60 libgwenhywfar60-dev
>> echo "   ktoblzcheck libktoblzcheck1-dev"
>> sudo apt-get install ktoblzcheck libktoblzcheck1-dev
>> echo " OFX support"
>> echo "   libofx libofx-dev"
>> sudo apt-get install libofx-dev
>> echo "   xsltproc"
>> sudo apt-get install xsltproc
>> echo " Database backend support"
>> echo "   libdbi1 libdbi-dev libdbd-pgsql libdbd-mysql libdbd-sqlite3"
>>

Re: [GNC] open network paths in gnucash

2019-05-23 Thread John Ralls



> On May 23, 2019, at 8:03 PM, Eric Haszlakiewicz  
> wrote:
> 
> Hi, I just updated to gnucash 3.5 and for the life of me I can't figure out
> how to open my files.  Now, when I try to e.g. import an qfx file, there
> doesn't seem to be anyway for me to type in the network path where it is.
> (i.e. \\myserver.example.com\some\path)
> How do I do this now?  Why isn't this using the regular file dialog?  Argh!

That's https://bugs.gnucash.org/show_bug.cgi?id=796871. The work around is to 
map it to a drive letter.

By "regular file dialog" you mean the Windows native file chooser? It doesn't 
use it because we need to add the backend selector, so we have to use 
GtkFileChooser instead of GtkNativeFileChooser.

Regards,
John Ralls

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


Re: [GNC] Upcoming report deprecation

2019-05-24 Thread John Ralls



> On May 24, 2019, at 9:54 AM, Stephen M. Butler  wrote:
> 
> 3.  I do have a version of Balance Sheet that is moving away from guile
> (haven't made it all the way yet) but better formatted that the
> non-guile version.  I haven't contributed it yet since I'm not satisfied
> with the indenting on it.  However, a less strict repository for sharing
> would be welcome.  Have to be able to bundle multiple files as a small
> package (my Balsheet-Formatted has 3 source code files).

I trust that you mean it's moving away from eguile. Writing reports without 
Guile itself would require a great deal of boilerplate code.

Regards,
John Ralls

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


Re: [GNC] Upcoming report deprecation

2019-05-24 Thread John Ralls



> On May 24, 2019, at 9:20 AM, Derek Atkins  wrote:
> 
> Hi,
> 
> On Fri, May 24, 2019 12:12 pm, Adrien Monteleone wrote:
>> 
>> 
>>> On May 24, 2019, at 7:41 AM, Geert Janssens 
>>> wrote:
>>> 
>>> 
>>> My ideal solution would have been this:
>>> - we provide an online repository with user contributed reports, similar
>>> to
>>> how kde-look or gnome-look websites host themes or wallpapers for their
>>> respective desktops
>> 
>> Is it possible to accomplish this using GitHub? Just curious...
> 
> I don't think so.  It would require people to push to github, which is
> effectively the same as current commiters.
> 
> The wiki would be a better place.  It opens it up to more people.

Gramps does exactly that with https://github.com/gramps-project/addons. 

But that's the easy part. Getting GnuCash to work with the repository is more 
difficult and time consuming. That's what Geert doesn't have time for.

Regards,
John Ralls

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


Re: [GNC] Export from Android can't open XML on Windows

2019-05-19 Thread John Ralls


> On May 19, 2019, at 12:51 PM, dragospuri  wrote:
> 
> Hello,
> 
> As the title says, the Android version of GnuCash works fine. I can export
> xml, not csv (says there are no transactions to export...). Don't know if
> that matters.
> 
> After many hours googling I got to the trace file which has these 2 probably
> important lines out of 3:
> 
> * 22:34:02 ERROR  gnc_commodity*
> dom_tree_to_commodity_ref(xmlNodePtr, QofBook*): assertion 'ret != NULL'
> failed
> 
> * 22:34:07  WARN  [GncXmlBackend::load()] Syntax error in Xml
> File 
> 
> How can I trace the NULL ref from here? Maybe correct the xml manually?
> What can I do?
> 
> Android version: 2.4.0
> Windows version: 3.5+(2019-03-30)


The first one is saying that some commodity entry in the book isn't found in 
the commodities already loaded. That's probably not the problem, especially 
since the syntax error warning is 5 seconds later.

What are the 10 or so lines in the trace file immediately before the "Syntax 
error" message?

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


Re: [GNC] Export from Android can't open XML on Windows

2019-05-20 Thread John Ralls



> On May 20, 2019, at 9:20 AM, dragospuri  wrote:
> 
> John Ralls-2 wrote
>>> On May 19, 2019, at 12:51 PM, dragospuri 
> 
>> dragospuri@
> 
>>  wrote:
>>> 
>>> Hello,
>>> 
>>> As the title says, the Android version of GnuCash works fine. I can
>>> export
>>> xml, not csv (says there are no transactions to export...). Don't know if
>>> that matters.
>>> 
>>> After many hours googling I got to the trace file which has these 2
>>> probably
>>> important lines out of 3:
>>> 
>>> * 22:34:02 ERROR 
>> 
>> gnc_commodity*
>>> dom_tree_to_commodity_ref(xmlNodePtr, QofBook*): assertion 'ret != NULL'
>>> failed
>>> 
>>> * 22:34:07  WARN 
>> 
>> [GncXmlBackend::load()] Syntax error in Xml
>>> File 
>> 
>>> 
>>> How can I trace the NULL ref from here? Maybe correct the xml manually?
>>> What can I do?
>>> 
>>> Android version: 2.4.0
>>> Windows version: 3.5+(2019-03-30)
>> 
>> 
>> The first one is saying that some commodity entry in the book isn't found
>> in the commodities already loaded. That's probably not the problem,
>> especially since the syntax error warning is 5 seconds later.
>> 
>> What are the 10 or so lines in the trace file immediately before the
>> "Syntax error" message?
>> 
>> Regards,
>> John Ralls
>> ___
>> gnucash-user mailing list
> 
>> gnucash-user@
> 
>> 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.
> 
> 
> Hi John,
> 
> Thank you for answering. I've been having this issue for a couple of years
> and have only been updating my accounts on mobile, which is a lot slower...
> 
> These are the lines around the WARNING. They go like that for thousands of
> lines above and hundreds below.
> 
> 
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bd34de0
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bd34f00
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bd34de0
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bd34de0
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bac9040
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bac90d0
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bac91f0
> * 22:34:07  INFO  [xaccOpenLog] Attempt to open disabled
> transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [xaccTransWriteLog] Attempt to write
> disabled transaction log
> * 22:34:07  INFO  [trans_cleanup_commit] get rid of rollback
> trans=0bac9280
> ** 22:34:07  WARN 

Re: [GNC] Fwd: Impossible to generate reports.

2019-05-21 Thread John Ralls
I'll be amazed if that works. GnuCash has its own instance of WebKit and 
reports don't interact with the system browser at all, unless of course one 
exports HTML from the report and then opens it with the system browser.

Which the OP might consider for a workaround.

Regards,
John Ralls

> On May 21, 2019, at 9:14 AM, David Carlson  
> wrote:
> 
> On Tue, May 21, 2019 at 8:16 AM Derek Atkins  wrote:
> 
>> Hi,
>> 
>> You are trying to configure the way Windows displays HTML pages.
>> You are not configuring GnuCash.
>> 
>> As the instructions say:
>> 
>> * Select the bottom option "Set program access and computer defaults"
>> * You are then asked to chose a configuration:
>> * Extend the "Custom" configuration section by clicking on the double down
>> arrow at the right (this step may not be necessary). If you are already
>> using a "Custom" configuration, note the settings so you can go back to
>> them once the problem is fixed.
>> * Scroll up then click on the radio button to use the "Microsoft Windows"
>> configuration.
>> 
>> So once you select "Set program access and computer defaults" you need
>> to extend the Custom configuration section and then click on the radio
>> button for "Microsoft Windows" configuration.
>> 
>> Note:  I don't use Windows, so I am just helping you follow the
>> instructions provided by others.
>> 
>> -derek
>> 
>>   Derek Atkins 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> In Windows 7 it is under Internet Options, or in Windows 10 under
> Settings.
> Choose Default Apps
> From there, scroll down to Choose Default Apps by filetype.  Scroll down to
> .html.  Click on whatever it is currently set to, such as Google Chrome.
> Change it to Microsoft Edge or something different.  Then close settings,
> reboot the computer, go back to settings and change the Default App for
> .html back to your previous App.
> 
> Now try looking at HTML reports in GnuCash.  You may still need to wait
> several minutes before they appear.
> 
> -- 
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Listsfor more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Export from Android can't open XML on Windows

2019-05-20 Thread John Ralls



> On May 20, 2019, at 11:27 AM, D via gnucash-user  
> wrote:
> 
> Not sure, but XBT is not listed as a valid ISO4217 code, so it's likely 
> Gnucash doesn't like it.
> 
> What would you use it for? What did you use it for last July 29th?
> 
> David
> 
> On May 20, 2019, at 11:35 PM, dragospuri  wrote:
> 
> 
>> Ok. I believe I have found it. It wasn't a transaction, but a .
>> Removing the following lets me open the file in gnucash:
>>   
>> 4625ffc94c6f4ed68528191dab4f5602
>> 
>>   ISO4217
>>   RON
>> 
>> 
>>   ISO4217
>>   XBT
>> 
>> 
>>   2018-07-29 00:32:29 +0300
>> 
>> user:xfer-dialog
>> 39/1254250
>>   
>> Probably XBT isn't accepted?!
>> I'm not sure yet how this will affect my transactions that involve this
>> (worried), or how to find them.
>> Thanks a lot for the help.

David,

XBT is commonly used for Bitcoin.

Dragos,

Just put it in a different namespace and change the type of the asset 
account(s) holding it to "stock". You'll need to do that outside of GnuCash.

You should file a bug with GnuCash-for-Android. If Ngewi wants to allow non-ISO 
currency codes that's his business but he should warn that it will make the 
file incompatible with GnuCash.

Regards,
John Ralls


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


Re: [GNC] * Unsaved book - Gnucash

2019-05-01 Thread John Ralls


> On May 1, 2019, at 6:46 AM, Michael Hendry  wrote:
> 
> I’m using version 3.4 on Mac OS X High Sierra.
> 
> This comes up briefly in the Gnucash title bar when I’ve finished working on 
> one file and File->Open another one, although the file that is being closed 
> has definitely been saved already.
> 
> It doesn’t seem to have any adverse effect (apart from operator anxiety).

Michael,

GnuCash is currently written to always have a book to the point that when 
switching from one to another it creates one for the brief interval while the 
old one is closed and the new one is loading. That's the indication you're 
seeing. 

Regards,
John Ralls

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


Re: [GNC] Problems with getting European share prices

2019-05-01 Thread John Ralls



> On May 1, 2019, at 1:34 PM, Eric Coates  wrote:
> 
> Hi
> 
> This is so weird it must be me ??? otherwise pandemonium would have reigned 
> here!
> 
> About two weeks ago I upgraded my system to Ubuntu 18.10 and a few days later 
> to 19.04 (ironically, I was trying to get around some problems) and installed 
> GnuCash from the standard repository; so I am running GnuCash 3.4 with 
> Finance::Quote 1.47 on Ubuntu 19.04.
> 
> As part of my usual work process, on 30^th April I updated my share prices as 
> in the past I was using Alphavantage to get UK share prices and Yahoo-JSON to 
> retrieve European prices. Then, as usual, went to check that everything was 
> OK.
> 
> Although there were no error messages and all the names of my European shares 
> were shown in the Price Database window there were no prices against any of 
> them ??? and I mean NO prices. I know that there were some there at the end 
> of March but everything had gone. Even the little triangular thingies were 
> missing. As there are only half a dozen shares in this group I thought to add 
> the prices ???by hand??? but I couldn???t do it, although I could fill I the 
> fields and clicking Apply gave no messages nothing appeared in the database.
> 
> A further oddity is that in the table of accounts there is a Present value 
> against each of the European shares ??? to get that GnuCash must be picking 
> up some price from somewhere. I???ve done some checking around and I can???t 
> find a reasonable explanation of how the price is determined.
> 
> I take an archive copy of the data file at the end of each month. I have 
> opened several of them (using the standard GnuCash 3.4) and get the same 
> behaviour with each of them.
> 
> As I said, it must be me but - any ideas of what I???m doing wrong.
> 
> Or failing that, would I be able to open the 3.5 data file with GnuCash 
> 2.6.21?
> 
> Eric
> 
> PS: For completeness:
> 
> I had not changed the Symbol for any share since the successful update at the 
> end of March. The Yahoo site shows Deutsche Post as DPW.DE (not the DPW.F I 
> had been using). Changing the symbol to DPW.DE gave no different result 
> (again, not even no error message)


Sounds like https://bugs.gnucash.org/show_bug.cgi?id=797046, fixed in GnuCash 
3.5.

Regards,
John Ralls


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


Re: [GNC] Please respond to this request for help!

2019-05-01 Thread John Ralls
Adrien,

No, but one can always use Windows Settings to remove the old installation and 
then run Windows Exploder as Admin and delete c:\Program Files (x86)\gnucash. 

Regards,
John Ralls

> On May 1, 2019, at 6:57 PM, Adrien Monteleone 
>  wrote:
> 
> Thanks for the clarification John, I was piecing things together based on 
> release notes and some searches.
> 
> Definitive answers from you and other developers are always, of course, the 
> most helpful.
> 
> Any idea why the OP’s installation is hanging on that file? Possible 
> solutions other than my guess of just trying again? I’ve seen weird things, 
> but hanging on simply copying a single file hasn’t been one of them. 
> (personally, yet)
> 
> Regards,
> Adrien
> 
>> On May 1, 2019, at 6:56 PM, John Ralls  wrote:
>> 
>> Adrien,
>> 
>> AQBanking *will* drop DTAUS support in Version 6 when that's released. As of 
>> today it still hasn't been, and the Windows and MacOS bundles still provide 
>> AQBanking 5.7.8, the latest stable release that still supports DTAUS and 
>> includes dtaus.xml.
>> 
>> Regards,
>> John Ralls
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] De-Reconciliation Settings

2019-04-29 Thread John Ralls


> On Apr 29, 2019, at 12:54 AM, David T. via gnucash-user 
>  wrote:
> 
> It was pointed out to me in another thread that one can reset specific 
> warnings flags using Action->Reset Warnings. 
> 
> I’d like to raise a couple of points with this dialog, now that I have been 
> introduced to it…
> 
> First off, the dialog is quite opaque, insofar as it is (apparently) only 
> showing warnings for which I have selected options previously. There is no 
> way for me to determine what (if any) other options I have here. I imagine it 
> would be a whole lot clearer if I could have a listing of all the various 
> options, along with their current setting. It is counterintuitive to me the 
> way it is set up here.
> 
> Be that as it may, I have three entries listed here: “Change contents of 
> reconciled split”“Remove a split from a transaction”“Commit changes to a 
> transaction”
> 
> The first setting listed here refers to the behavior of de-reconciling a 
> split in GnuCash. However, if a user changes Transaction-level data 
> elements—such as the Description field—a split will become de-reconciled. 
> Therefore, this preference is misnamed, and should be changed, since I should 
> receive an alert if I change the description and the reconcile flag gets 
> reset. Perhaps “Change reconcile flag upon edit” would be better?
> 
> Second, it seems to me that the boundary for when a split becomes 
> de-reconciled needs to be drawn differently. I know this issue was discussed 
> recently, and there were reasons given for why the logic falls the way it 
> does. However, reconciliation applies to the *split*, as shown by the fact 
> that each split in a transaction can be separately reconciled in its own 
> account. Changing the status of the split based on a change in the 
> transaction is inconsistent and illogical to me. 
> 
> I have transactions with as many as ten splits, in which several splits are 
> reconciled. If, for some reason, I then change the description of the 
> transaction, then every one of those reconciled splits will get 
> de-reconciled-- requiring me to reconcile every linked account.
> 
> Finally, I will note that the program is at least consistent, in that when 
> you change a description field, it does in fact change every cleared split in 
> that transaction. I do, however, question whether that is the correct action 
> to impose. 
> 

David,

Did you read the description at the top of the dialog? It says 
"You have requested that the following warning dialogs not be presented. To 
re-enable any of these dialogs, select the check box next to the dialog, then 
click OK."

What's unclear about that? It's not a "manage warning dialogs" dialog, but it 
doesn't claim to be. You can file an enhancement asking for one if you like.

I agree that the "change reconciled splits" is a bit misleading. The actual 
dialog with the warning is called "Change transaction with a reconciled split". 
Both the setting and the tool-tip imply that it's per-split rather than 
per-transaction.

I'm ambivalent about whether changing the transaction should de-reconcile a 
split, but it seems clear to me that changing the transaction date should as 
that affects the ordering of the split when calculating the balance, so ISTM 
that should continue to unreconcile all of the splits in the transaction.

I also noticed while checking the reset warnings dialog that it doesn't take 
effect during the current session. I filed 
https://bugs.gnucash.org/show_bug.cgi?id=797222 to track that.

Regards,
John Ralls



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


Re: [GNC] sqlite error from gnucash 2.6.19

2019-04-27 Thread John Ralls



> On Apr 27, 2019, at 10:00 AM, Jeff Abrahamson  wrote:
> 
> I opened a gnucash file (sqlite, gnucash v2.6.19, built from version
> c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace
> 
>* 18:36:09  CRIT  xaccAccountGetName: assertion
>'GNC_IS_ACCOUNT(acc)' failed
> 
> I presume this means some bit of corruption in the sqlite file, but
> googling isn't helping me know what to do about it.  Something gnucash
> specific?  Use sqlite tools directly?  Other?
> 

Don't leap to conclusions. First run GnuCash with the --debug option. That will 
provide a great deal more information that should help resolve where the error 
is coming from.

If it does prove to be a database problem next run gnucash with --log 
gnc.backend.dbi=debug which will print out all of the SQL queries. If it's 
really corrupt data then the errors will be interleaved with the queries. That 
should provide you enough information to query the database with the sqlite3 
command-line tool and figure out exactly what's wrong.

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


Re: [GNC] [GNC-dev] Recording dividend payoffs

2019-04-18 Thread John Ralls
Justin,

It's very simple: I've many years of experience with both accounting and 
GnuCash. I've run a company which paid dividends and used GnuCash to account 
for it. It works fine the way it is, it just doesn't work the way you want to 
use it. Too bad.

Then there's your admission to Maf:
> 
> On Apr 16, 2019, at 5:37 AM, Justin Mathew via gnucash-devel 
>  wrote:
> 
> Yes, I read this suggestion in gnu tutorial and concepts manual few hours ago 
> infact. I am new to accounting to be honest. Just learning it with a 
> fictitious company and transactions.
> 


Regards,
John Ralls


> On Apr 17, 2019, at 12:55 AM, Justin Mathew via gnucash-devel 
>  wrote:
> 
> And John,
> 
>> Justin,
>> 
>> No, just you. This is real simple: GnuCash provides two ways to account for 
>> reporting retained earnings, including dividends. I'm not asking you to do 
>> anything, I'm telling you how GnuCash works. Either you use one of those two 
>> ways or you use a different accounting program.
> 
> We've been over this. And I am telling you again that how GnuCash handles 
> dividends isn't the right way. Recording dividends as an expense is 
> technically wrong. It doesn't decrease the equity. And dividends can be paid 
> and recorded correctly without closing the books in today's age.
> 
> I am just surprise how reluctant you are to acknowledge that there is an 
> issue with the current system and to discuss a possible solution. You're 
> impossible man!
> 
> -
> Regards,
> Justin Mathew
> mjus...@protonmail.com

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


Re: [GNC] Return of Capital

2019-04-19 Thread John Ralls
Alen,

Yes, I saw that.
IIUC the transaction that you're creating is between IPE and AUD. That will 
cause trading account splits as they operate between any differing commodity 
pair, not just between currencies.

I presume that you're working on the transaction in split view. In that view 
GnuCash's automatic price conversion is turned off so it's to the user to enter 
values (in the split's commodity) and amounts (in the transaction currency) 
that balance in the transaction currency. The example doesn't show shares or 
price columns. If you're trying to create or edit the transaction in a currency 
account where those aren't shown it can make getting the balance right 
difficult so try switching to the IPE account to view the transaction. If it's 
still confusing post the whole transaction showing all 4 columns (i.e. shares, 
price, debit, and credit) and all splits including the trading account ones.

Aside from that you've overstated your return of capital. Consider the whole 
cycle (AUD balance reflects the cash account so decreases with debit in the 
stock account):

Description Shares  Price   Debit   Credit  
Share Bal.  AUD
Buy ISE 100 100 10  1000
100 -1000
ISE Return of Capital   
500 - 500
Sell ISE 100 @ 10   -10010  
10000 500
Buy ISE 100 @ 5 100   5 500 
100 0

The return of capital changes the basis on its own, though I think the Advanced 
Portfolio Report doesn't understand returns of capital and won't reflect the 
change in basis. When you get around to really selling the ISE then when you 
compute the capital gain you'll subtract the return of capital from the 
original basis.

Regards,
John Ralls

> On Apr 18, 2019, at 10:26 PM, cicko  wrote:
> 
> John, I've included the answer to your question(s) in the thread continuing
> on Adrien's answer. There may be something wrong with the insertion of the
> adjusting splits. 
> In both cases, you might want to follow up there. Thanks!
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Return of Capital

2019-04-19 Thread John Ralls



> On Apr 19, 2019, at 2:34 PM, cicko  wrote:
> 
> John Ralls-2 wrote
>> IIUC the transaction that you're creating is between IPE and AUD. That
>> will cause trading account splits as they operate between any differing
>> commodity pair, not just between currencies.
> 
> Right, that's what I would expect.
> 
> 
> John Ralls-2 wrote
>> The example doesn't show shares or price columns. ... If it's still
>> confusing post the whole transaction showing all 4 columns (i.e. shares,
>> price, debit, and credit) and all splits including the trading account
>> ones.
> 
> Hm, not sure which example you saw but on these screenshots there are 4
> columns. The additional two, with totals, are blank as the transaction is
> not yet posted.
> I'm using Auto-Split view.
> 
> My entry, before trying to save: https://imgur.com/i0CbKUq
> The price is a bit skewed but it is $10 for Sell and $5 for Buy split. The
> transaction seems to balance. 
> 
> Trying to save by pressing enter, the Trading split gets inserted (only 1!):
> https://imgur.com/NzAFZLC
> And from there, the dialog keeps popping up: https://imgur.com/bk8a9zb
> 
> The records for the IPE trading accounts are missing, correct. This is a
> good hint. I'd prefer to avoid them, as the balance stays the same but -
> adding the two Trading:ASX:IPE records balances and the transaction is
> saved.
> Thanks!
> 
> Here is the end-result: https://imgur.com/aOIxLxM
> 
> Your example is difficult to follow in text mode but the screenshot above
> should balance, as far as I can say.

Alen,

Sorry, I missed the imgur links when I went back to your previous post and saw 
only the text part.

Part of the problem is that you were entering the sale at a price of 0 but with 
an amount of 100 shares and a value of A$1000. In basic view GnuCash will put 
up a dialog asking whether you want it to change the amount, value, or price to 
make sense of it. Split view won't do that. That was probably also what was 
suppressing generating the trading account splits.

That's an interesting way of handling an RoC. The only downside for those of us 
with different tax rates depending on how long we hold an investment is that it 
resets the purchase date, and if we're not paying attention might make one 
think at tax time that the $500 RoC was really a capital gain.

Regards,
John Ralls

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


Re: [GNC] retained earnings between two different financial periods

2019-04-20 Thread John Ralls


> On Apr 20, 2019, at 2:33 AM, mc  wrote:
> 
> Config:
> gnucash 3.5 clean install.
> (X)ubuntu Linux 18.04
> gnucash files saved as sqlite.
> 
> Hi
> 
> I am new to gnucash and testing it.
> Most things I have tried work as expected (and extremely well ;-)  )
> 
> One question: on the page:
> www.gnucash.org/docs/v3/C/gnucash-help/tool-close-book.html 
> <https://www.gnucash.org/docs/v3/C/gnucash-help/tool-close-book.html>
> it states:
> "GnuCash’s built-in reports automatically handle concepts
> like retained earnings between two different financial periods"
> 
> However when I tested it
> gnucash does NOT appear to separate retained earnings
> between two different financial periods.
> 
> When I print a balance sheet report,
> without closing the books,
> I just get 1 net retained earnings number:
> Retained Earnings / Retained Losses
> that includes the amounts from previous years.
> 
> The P for different years works as expected.
> 
> (after closing the books, the BS report also works as expected)
> 
> What have I missed?

The Balance Sheet report calculates a "Retained Earnings" line as a "virtual" 
top-level account if it finds balances in the accounts of type Income or 
Expense, the balance being the net value of those accounts, i.e. total income - 
total expenses.

If you've previously closed your books to an account named Retained Earnings 
(which you'd normally put under an Equity top-level placeholder account) then 
it will show that balance too. So if you close your books at the end of each 
period and then run the balance sheet some time later you'll have two Retained 
Earnings lines: One for when you last closed and one for the transactions since 
then.

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


Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread John Ralls



> On Apr 20, 2019, at 5:58 AM, mc  wrote:
> 
> Config:
> gnucash 3.5 clean install.
> (X)ubuntu Linux 18.04
> gnucash files saved as sqlite.
> 
> Am new to gnucash and testing it.
> 
> I keep several versions of a gnucash file,
> saved with names like --.gnucash
> 
> After cleanly exiting gnucash by a normal Quit,,
> I may try to open an earlier saved version.
> I frequently get the message:
> 
> GnuCash could not obtain a lock for .../.gnucash
> the database may be in use by another user, in which case you should not open 
> the database.
> What would you like to do?
> open read only / create new file / open anyway / quit
> 
> I have checked that gnucash is not running,
> and there is no lock file to be found.
> I open it anyway, and it is without problems,
> other than my tabs have disappeared and there is only the default "Accounts" 
> tab.
> 
> In fact there is no .LCK file even when gnucash has a file opened.
> 
> So:
> a.  has gnucash changed the locking mechanism in v3
> or do sqlite files not use a locking mechanism?
> 
> b.  is there a possible issue with this locking mechanism?

The SQL locks are in a table inside the database, not in a separate file. The 
file will be locked if you didn't properly quit GnuCash the last time you had 
*that file* open.

The locking mechanism itself hasn't changed, but the SQL/DBI backend got a 
complete rewrite into C++ for GnuCash 3.x.

It's a computer program. Of course it's possible that there's a problem, and 
since you're doing something a bit different from what everyone else does you 
might be the first to have found it. How are you creating these "earlier saved 
versions"?

Regards,
John Ralls

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


Re: [GNC] Unexpected behaviour of locking mechanis

2019-04-20 Thread John Ralls
Colin,

Maybe a problem with your book. I just did the same exercise (stepping in the 
debugger to make sure that everything was getting called in the right places, 
it is) and didn't get any such errors.

Regards,
John Ralls


> On Apr 20, 2019, at 8:49 AM, Colin Law  wrote:
> 
> I thought I would try this with 3.5 on Ubuntu 18.10.  Using Save As
> repeatedly to sqlite3 does not result in locked files. I can go back
> and open the previous versions without issue.
> 
> However, when saving to sqlite, which I don't normally, I do see in
> the trace file
> * 16:43:29 ERROR  [error_handler()] DBI error: 19:
> UNIQUE constraint failed: books.guid
> * 16:43:29 ERROR 
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing
> SQL INSERT INTO books(guid,root_account_guid,root_template_guid)
> VALUES('2e45bf75396f1f5d2c459c4bb687b8da','f70697860ee4e46e92997a700eb37f1c','b4415e84471d47e166dd9d00f5293faf')
> * 16:43:29 ERROR 
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> books(guid,root_account_guid,root_template_guid)
> VALUES('2e45bf75396f1f5d2c459c4bb687b8da','f70697860ee4e46e92997a700eb37f1c','b4415e84471d47e166dd9d00f5293faf')
> * 16:43:29 ERROR  [commit_err()] Failed to commit: 17
> 
> Whether that is a serious issue I don't know.
> 
> Colin
> 
> On Sat, 20 Apr 2019 at 16:20, mc  wrote:
>> 
>> Thanks John
>> 
>> The SQL locks are in a table inside the database, not in a separate file"
>> That would mean there is one for each gnucash file.  Good to know.
>> 
>> "How are you creating these "earlier saved versions""
>> Just with "save as".
>> Then I do some more changes, then do another "save as" with a higher
>> version number.
>> So in one long session, I may have several earlier versions with diff
>> version numbers.
>> 
>> eg:
>> Lets call the files I have created in the session v0, v1, v2, v3.
>> I initially open v0, then (say) 1 hour later do save as v1,
>> another hour later save as v2, later save as v3, etc.
>> 
>> So the likely answer is:
>> as the lock is inside the database,
>> doing a new "Save As" to create v1
>> doesn't release the lock on the older, now superseded v0.
>> Then save as v2, doesnt release the lock on v1, etc.
>> So at the end of the session, I quit while v3 is open,
>> and only the lock on v3 is released.
>> 
>> But, v0, v1, v2 all still have locks inside their database.
>> 
>> So "save as" doesnt release locks on earlier versions used in the session,
>> Also, "Quit" also only releases the lock on the current file,
>> not the earlier versions used in this session.
>> 
>> So to release the locks
>> (if that were useful)
>> would have to go back and open, then Quit from each earlier version.
>> 
>> Thanks for your guidance.
>> 
>> mc
>> 
>> 
>> On 20/04/2019 22.53, John Ralls wrote:
>>> 
>>>> On Apr 20, 2019, at 5:58 AM, mc  wrote:
>>>> 
>>>> Config:
>>>> gnucash 3.5 clean install.
>>>> (X)ubuntu Linux 18.04
>>>> gnucash files saved as sqlite.
>>>> 
>>>> Am new to gnucash and testing it.
>>>> 
>>>> I keep several versions of a gnucash file,
>>>> saved with names like --.gnucash
>>>> 
>>>> After cleanly exiting gnucash by a normal Quit,,
>>>> I may try to open an earlier saved version.
>>>> I frequently get the message:
>>>> 
>>>> GnuCash could not obtain a lock for .../.gnucash
>>>> the database may be in use by another user, in which case you should not 
>>>> open the database.
>>>> What would you like to do?
>>>> open read only / create new file / open anyway / quit
>>>> 
>>>> I have checked that gnucash is not running,
>>>> and there is no lock file to be found.
>>>> I open it anyway, and it is without problems,
>>>> other than my tabs have disappeared and there is only the default 
>>>> "Accounts" tab.
>>>> 
>>>> In fact there is no .LCK file even when gnucash has a file opened.
>>>> 
>>>> So:
>>>> a.  has gnucash changed the locking mechanism in v3
>>>> or do sqlite files not use a locking mechanism?
>>>> 
>>>> b.  is there a possible issue with this locking mechanism?
>>> The SQL locks are in a table inside the database, not in a separate file. 
>>> The file will be locked if you did

Re: [GNC] GC won't load on Ubuntu 19.04

2019-05-02 Thread John Ralls
Boost has the annoying misfeature of versioning their library names so that 
they can't be upgraded without rebuilding everything dependent on them.  Ubuntu 
18.10 and 19.04 provide boost-1.67.0 and you built GnuCash with boost-1.65.0.

ICU has the same misfeature but GnuCash doesn't directly link it so that won't 
generally affect folks building on Linux.

Regards,
John Ralls


> On May 2, 2019, at 1:11 AM, Dennis Powless  wrote:
> 
> I ran:  sudo apt-get install libboost-all-dev
> 
> Same output as before.
> 
> D
> 
> On Thu, May 2, 2019 at 3:51 AM Dennis Powless  wrote:
> 
>> Do I need to add this as a dependency?  Libboost_reqex.so.1.65.1 ??  I see
>> boost as a dependency.
>> 
>> dennis@dennisLaptop1:~$ gnucash
>> gnucash: error while loading shared libraries: libboost_regex.so.1.65.1:
>> cannot open shared object file: No such file or directory
>> 
>> 
>> d
>> 
>> On Thu, May 2, 2019 at 2:59 AM Dennis Powless 
>> wrote:
>> 
>>> I recently upgraded to Ubuntu 19.04 and when I click on icon on the dock
>>> on the left, it attempts to open, then abruptly stops.   No GC splash
>>> screen.
>>> 
>>> I'm using GC 3.1
>>> 
>>> 
>>> Dennis
>>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Uninstall GC

2019-05-03 Thread John Ralls
Locate uses a database that's generated periodically (typically weekly) from 
cron. If you've deleted files since the last time it updated the database 
you'll get files that aren't there any more. You can run 
  sudo locate.updatedb
to regenerate. It scans all of storage traversing filesystem mounts so be 
prepared for it to take a long time.

Also notice that locate matches every path matching the pattern and if the 
pattern contains no globbing characters locate treats it as *pattern*, i.e. it 
matches any path with "pattern" (or in your instant case, "gnucash") anywhere 
in it.

I already told you how to delete all of the gnucash-installed files in .local:

find ~/.local -name gnucash -o -name *gnc* -exec rm -rf {} \;

Regards,
John Ralls


> On May 3, 2019, at 1:34 PM, Dennis Powless  wrote:
> 
> When I run  locate gnucash in terminal I get 1,000's of lines.
> 
> However, when I navigate to some of them some are empty (even with show all 
> files checked).
> 
> /home/dennis/.local/etc/gnucash/environment
> /home/dennis/.local/share/doc/gnucash/ChangeLog.1999
> /home/dennis/.local/share/gnucash/scm/gnucash/report/standard-reports/test/test-standard-category-report.scm
> /home/dennis/Applications/share/locale/ca/LC_MESSAGES/gnucash.mo
> /home/dennis/.local/lib/gnucash/scm/ccache/2.0/gnucash/gnc-modules/test/test-gnc-module-scm-init.go
> /home/dennis/Applications/libgnucash/tax/us/CMakeFiles/scm-tax-us.dir/DependInfo.cmake
> /home/dennis/.local/lib/gnucash/libgncmod-bi-import.so
> /home/dennis/.local/include/gnucash/SX-book.h
> 
> Here is a few of the directories and files  each one has numerous.
> 
> What can I delete?
> 
> dennis@dennisLaptop1:~$ whereis gnucash
> gnucash:
> 
> 
> D
> 
> On Fri, May 3, 2019 at 4:26 PM John Ralls  wrote:
> So you built in the parent directory of the sources. Not exactly recommended 
> but at least it's  not the source directory itself.
> 
> What files are left?
> 
> Regards,
> John Ralls
> 
> > On May 3, 2019, at 1:16 PM, Dennis Powless  wrote:
> > 
> > I was able to run make uninstall on the Applications directory.
> > 
> > The terminal completed the task.
> > 
> > However, there seems to be still files hanging around.
> > 
> > d
> > 
> > On Fri, May 3, 2019 at 4:07 PM Dennis Powless  wrote:
> > 
> >> dennis@dennisLaptop1:~$ locate cmake_uninstall.cmake
> >> /home/dennis/.local/share/Trash/files/gnucash-maint/cmake/
> >> cmake_uninstall.cmake.in
> >> /home/dennis/Applications/cmake_uninstall.cmake
> >> /home/dennis/Applications/gnucash-3.1/cmake/cmake_uninstall.cmake.in
> >> 
> >> Can I then run the cmake uninstall from this location?
> >> 
> >> d
> >> 
> >> On Thu, May 2, 2019 at 9:40 PM David Cousens 
> >> wrote:
> >> 
> >>> John,
> >>> 
> >>> Won't that simply remove the source directories. With that prefix Dennis
> >>> has
> >>> installed under /home/dennis/.local. If the build directory is under
> >>> ~/Applications/gnucash-3.1 then he will lose the manifest by using rm  -rf
> >>> on the source directory.
> >>> 
> >>> If he can locate the original build directory then issuing make uninstall
> >>> from a terminal open in that directory. I have adopted the practice of
> >>> putting the build directory inside the source directory and retaining both
> >>> (I once found that the make uninstall procedure seems to reference the
> >>> source directories not simply the manifest file or the build directories
> >>> but
> >>> I have never checked this out fully) until after I have removed a build.
> >>> It
> >>> doesn't cause any problems and keeps everything you need for an uninstall
> >>> together.
> >>> 
> >>> Dennis
> >>> Your build directory is unlikely to be gnucash-3.1, that is most likely
> >>> the
> >>> source directory. Where it is located is the directory from which you
> >>> originally executed the cmake command since you used absolute addressing
> >>> to
> >>> the source. It may be  inside gnucash-3.1 if you used the mkdir 
> >>> and
> >>> cd  commands from the terminal open atgnucash-3.1 before issuing
> >>> the
> >>> make command. Here  is a generic notation for a filename for a
> >>> build
> >>> file. It will have whatever name you gave it at the time. The attached
> >>> screenshot gives you the directory structure and files in the build

Re: [GNC] GC won't load on Ubuntu 19.04

2019-05-02 Thread John Ralls
Right.

The problem is that you build GnuCash on Ubuntu 18.04 that provides 
libboost-regex.so.1.65.0 then upgraded to Ubuntu 19.04 that provides 
libboost-regex.so.1.67.0 instead. When the linker tries to assemble gnucash to 
run it it can't find libboost-regex.so.1.65.0 because it's no longer there. It 
raises the error you reported:
gnucash: error while loading shared libraries: libboost_regex.so.1.65.1:
cannot open shared object file: No such file or directory

* You can try to find libboost-1.65 and install it alongside libboost-1.67  
(you'll also need to get whatever version of ICU was provided on Ubuntu 18.04). 
Don't use apt, it doesn't understand having two versions of the same package 
installed and you'll break a lot of other stuff if you remove the current boost 
and ICU libraries. 

* You can rebuild GnuCash so that it's linked to the newer libraries. 

* You can trash your self-build GnuCash and get the newer one from apt.

The last option is the safest because that way the next time you upgrade apt 
will upgrade GnuCash along with everything else.

Regards,
John Ralls


> On May 2, 2019, at 1:17 PM, Dennis Powless  wrote:
> 
> So, just to be clear I wasn't trying to build GC, just run it and after an 
> upgraded ubuntu.  From what I can tell, I'll need to uninstall GC and then 
> reinstall it. 
> 
> I'll try to fully uninstall GC and then install GC.  I'd like to have v 3.5, 
> but I've been having issues with the removal of GC after a build.  
> 
> Dennis  
> 
> On Thu, May 2, 2019 at 10:20 AM John Ralls  wrote:
> Boost has the annoying misfeature of versioning their library names so that 
> they can't be upgraded without rebuilding everything dependent on them.  
> Ubuntu 18.10 and 19.04 provide boost-1.67.0 and you built GnuCash with 
> boost-1.65.0.
> 
> ICU has the same misfeature but GnuCash doesn't directly link it so that 
> won't generally affect folks building on Linux.
> 
> Regards,
> John Ralls
> 
> 
> > On May 2, 2019, at 1:11 AM, Dennis Powless  wrote:
> > 
> > I ran:  sudo apt-get install libboost-all-dev
> > 
> > Same output as before.
> > 
> > D
> > 
> > On Thu, May 2, 2019 at 3:51 AM Dennis Powless  wrote:
> > 
> >> Do I need to add this as a dependency?  Libboost_reqex.so.1.65.1 ??  I see
> >> boost as a dependency.
> >> 
> >> dennis@dennisLaptop1:~$ gnucash
> >> gnucash: error while loading shared libraries: libboost_regex.so.1.65.1:
> >> cannot open shared object file: No such file or directory
> >> 
> >> 
> >> d
> >> 
> >> On Thu, May 2, 2019 at 2:59 AM Dennis Powless 
> >> wrote:
> >> 
> >>> I recently upgraded to Ubuntu 19.04 and when I click on icon on the dock
> >>> on the left, it attempts to open, then abruptly stops.   No GC splash
> >>> screen.
> >>> 
> >>> I'm using GC 3.1
> >>> 
> >>> 
> >>> Dennis
> >>> 
> >> 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 

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


Re: [GNC] Uninstall GC

2019-05-02 Thread John Ralls



> On May 2, 2019, at 2:09 PM, Stephen M. Butler  wrote:
> 
> On 5/2/19 1:48 PM, Dennis Powless wrote:
>> I've got GC 3.1 installed on my laptop running Ubuntu 19.04.  Built from
>> source.
>> 
>> 
>> 
>> This was the command I ran to install GC back then.
>> 
>> cmake -DWITH_AQBANKING=OFF -D CMAKE_INSTALL_PREFIX=/home/dennis/.local
>> /home/dennis/Applications/gnucash-3.1
>> 
>> So, my build directory is  Applications/gnucash-3.1   ???  right.
> 
> 
> Probably not.  Since you gave a full path (not relative) to the source,
> your build location could be nearly anywhere.  Specifically, it would be
> where you were at when the cmake was issued. 
> 
> Usually it is in a "build-xxx" folder just under Applications (next door
> to gnucash-3.1).  However, some use a '.build' folder inside the source
> code (dpkg_buildpackage does that).
> 
> You will need to find all the 'make' files and see which one contains
> the build for 3.1.
> 
>> 
>> I then did this
>> 
>> dennis@dennisLaptop1:~/Applications/gnucash-3.1$ make uninstall
>> make: *** No rule to make target 'uninstall'.  Stop.
>> 
>> This was the output.

Or just
  rm -rf ~/Applications/gnucash-3.1

You could even leave it there and just remove ~/Applications/gnucash-3.1/bin 
from $PATH and/or delete the desktop file if that's how you launch GnuCash. 
Installing GnuCash from apt will put everything in /usr like all of the other 
programs on the machine and install a new desktop file pointing there.

Regards,
John Ralls

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


Re: [GNC] Account Types

2019-05-03 Thread John Ralls
Unless the business is exceptionally simple it would be a real chore to account 
for even a reselling operation, never mind a manufacturing one, in GnuCash. 
Cost of goods sold is almost never just the cost of the ingredients; even a 
reselling operation will have some labor chargeable to the product ( "direct 
labor"). That's what ERP systems are for. Get one, it will save money in the 
long run.

Regards,
John Ralls

> On May 2, 2019, at 9:47 PM, Adrien Monteleone 
>  wrote:
> 
> What you are looking for is something more along the lines of operational 
> and/or cost-center accounting.
> 
> You *can* achieve that with an unconventional account tree, but you’ll 
> encounter some oddities, like this one.
> 
> You can export your P to a spreadsheet to manipulate it like you want with 
> COGS broken out separately and even add a Operating Revenue or similar line 
> after.
> 
> Otherwise, investigate using the SQlite backend with Piecash to generate a 
> custom P (you could use Scheme within GnuCash to do this, but that is a 
> steeper learning curve)
> 
> Regards,
> Adrien
> 
>> On May 2, 2019, at 8:33 PM, Jimmy R via gnucash-user 
>>  wrote:
>> 
>> I've created a top level accounts called COGS which is fine, but when I run a
>> report it is shown within the Expenses. Is it possible to have it shown like
>> below displaying ( two expenses )
>> 
>> Expense COGS
>> - Food
>> - Beverages
>> 
>> Expense Operating
>> - Advertising
>> - Auto
>> ---Fees
>> ---Gas
>> ---Parking
>> ---Repair and Maintenance
>> ---Bank Service Charge
>> etc etc
>> 
>> Thank You,
>> 
>> Jimmy
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Uninstall GC

2019-05-03 Thread John Ralls
Adrien,

Yeah, that got me too because the line wrapped between .local and the second 
/home/dennis. There's a space there so the install prefix is 
/home/dennis/.local and the source directory is 
/home/dennis/Applications/gnucash-3.1.

Regards,
John Ralls

> On May 2, 2019, at 9:38 PM, Adrien Monteleone 
>  wrote:
> 
> Curious about that cmake line...
> 
> Was that: /home/dennis/.local/home/dennis/Applications/gnucash-3.1?
> 
> Looks like an extra nested /home/dennis in there or am I reading that wrong? 
> (If I am, apologies for the noise)
> 
> Regards,
> Adrien
> 
>> On May 2, 2019, at 6:48 PM, John Ralls  wrote:
>> 
>> 
>> 
>>> On May 2, 2019, at 2:09 PM, Stephen M. Butler  wrote:
>>> 
>>> On 5/2/19 1:48 PM, Dennis Powless wrote:
>>>> I've got GC 3.1 installed on my laptop running Ubuntu 19.04.  Built from
>>>> source.
>>>> 
>>>> 
>>>> 
>>>> This was the command I ran to install GC back then.
>>>> 
>>>> cmake -DWITH_AQBANKING=OFF -D CMAKE_INSTALL_PREFIX=/home/dennis/.local
>>>> /home/dennis/Applications/gnucash-3.1
>>>> 
>>>> So, my build directory is  Applications/gnucash-3.1   ???  right.
>>> 
>>> 
>>> Probably not.  Since you gave a full path (not relative) to the source,
>>> your build location could be nearly anywhere.  Specifically, it would be
>>> where you were at when the cmake was issued. 
>>> 
>>> Usually it is in a "build-xxx" folder just under Applications (next door
>>> to gnucash-3.1).  However, some use a '.build' folder inside the source
>>> code (dpkg_buildpackage does that).
>>> 
>>> You will need to find all the 'make' files and see which one contains
>>> the build for 3.1.
>>> 
>>>> 
>>>> I then did this
>>>> 
>>>> dennis@dennisLaptop1:~/Applications/gnucash-3.1$ make uninstall
>>>> make: *** No rule to make target 'uninstall'.  Stop.
>>>> 
>>>> This was the output.
>> 
>> Or just
>> rm -rf ~/Applications/gnucash-3.1
>> 
>> You could even leave it there and just remove ~/Applications/gnucash-3.1/bin 
>> from $PATH and/or delete the desktop file if that's how you launch GnuCash. 
>> Installing GnuCash from apt will put everything in /usr like all of the 
>> other programs on the machine and install a new desktop file pointing there.
>> 
>> Regards,
>> John Ralls
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Uninstall GC

2019-05-03 Thread John Ralls
David,

You're right, I misread his cmake command line. I should have said `rm -rf 
~/.local`. 

Of course that might also have collateral damage if he's installed other things 
into .local.

  find ~/.local -name *gnucash* -o -name *gnc* -exec rm -rf {} \;
  
will safely remove everything GnuCash installs with the possible exception of 
libgwengui-gtk3.so if the system doesn't provide it.

Regards,
John Ralls

> On May 2, 2019, at 6:39 PM, David Cousens  wrote:
> 
> John,
> 
> Won't that simply remove the source directories. With that prefix Dennis has
> installed under /home/dennis/.local. If the build directory is under
> ~/Applications/gnucash-3.1 then he will lose the manifest by using rm  -rf
> on the source directory. 
> 
> If he can locate the original build directory then issuing make uninstall
> from a terminal open in that directory. I have adopted the practice of
> putting the build directory inside the source directory and retaining both
> (I once found that the make uninstall procedure seems to reference the
> source directories not simply the manifest file or the build directories but
> I have never checked this out fully) until after I have removed a build. It
> doesn't cause any problems and keeps everything you need for an uninstall
> together.
> 
> Dennis 
> Your build directory is unlikely to be gnucash-3.1, that is most likely the
> source directory. Where it is located is the directory from which you
> originally executed the cmake command since you used absolute addressing to
> the source. It may be  inside gnucash-3.1 if you used the mkdir   and
> cd  commands from the terminal open atgnucash-3.1 before issuing the
> make command. Here  is a generic notation for a filename for a build
> file. It will have whatever name you gave it at the time. The attached
> screenshot gives you the directory structure and files in the build
> directory note the dist_manifest.txt and install_manifest.txt. These will be
> present in your build directory.
> Selection_009.png
> <http://gnucash.1415818.n4.nabble.com/file/t375329/Selection_009.png>  
> 
> David Cousens
> 
> 
> 
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Please respond to this request for help!

2019-05-01 Thread John Ralls
Adrien,

AQBanking *will* drop DTAUS support in Version 6 when that's released. As of 
today it still hasn't been, and the Windows and MacOS bundles still provide 
AQBanking 5.7.8, the latest stable release that still supports DTAUS and 
includes dtaus.xml.

Regards,
John Ralls


> On May 1, 2019, at 11:37 AM, Adrien Monteleone 
>  wrote:
> 
> As noted by Maf., 2.1.16 is ancient. It will not read the 3.x file. (if you 
> got that far) I don’t think 2.1 will even install on Win10. (if you can even 
> find it)
> 
> dtaus.xml has to do with Aqbanking. (allows you to make a transaction in your 
> bank account *from* GnuCash) They dropped DTAUS support in their new version 
> 6 and GnuCash 3.5 is supposed to work with Aqbanking-v6, so not sure why you 
> are getting that error. (the file, I should think, shouldn’t even be part of 
> the package, unless it was retained for backwards compatibility with older 
> systems.)
> 
> First, I’d do a system-wide search for the file and completely trash it. (the 
> file might already be on the system and corrupted, causing a problem)
> 
> Then, download 2.6.21 and try that.
> 
> If that installs and you can successfully open your file, look over your data 
> and make sure there are no problems.
> 
> When you are satisfied everything is okay, download 3.5-1 (an updated Windows 
> installer) and install it.
> 
> Barring that, since you mention you’ve successfully installed 3.5 on a 
> different Win10 machine, maybe a ‘refresh’ of Win10 is in order? (be sure to 
> make a backup of everything first)
> 
> Regards,
> Adrien
> 
> 
> 
>> On May 1, 2019, at 11:32 AM, David Jaggar  wrote:
>> 
>> Hello Sachin,
>> I'm in Britain, so with the time difference, it has meant a delay in
>> following up.
>> Good thinking to install on another computer. I did that on a friend's
>> computer (also Windows 10) and it installed with no problem. However, I
>> downloaded the 3.5 version again, and still have the problem. I also find
>> that I can no longer reinstall my earlier version (2.1.16 ver) because I
>> have the same problem: the dtaus.xml file stops in the installation and
>> task manager indicates that the setup is suspended.
>> 
>> I am completely unfamiliar with Linux.
>> 
>> Thanks for suggestions,
>> David.
>> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Unique entry date and transaction date availability?

2019-05-01 Thread John Ralls
Unfortunately it was part of the Register rewrite called Register2. That had 
some serious stability problems that the contributor wasn't able to resolve so 
it remains hidden away behind the "--extra" command-line flag.

Regards,
John Ralls

> On May 1, 2019, at 2:55 PM, Jeff Albrecht  wrote:
> 
> Doh! Forgot to include platform and version. Windows 10 Version: 3.5 Build 
> ID: 3.5+(2019-03-30)
> 
> Working on it since 2013 and it's still experimental? :-) I'd sure like it to 
> go into the Main branch. I feel it's a very important feature to have 
> although not often used.
> 
> I looked around for a while "windows gnucash startup command line options" I 
> guess there aren't any?
> 
>  - Jeff
> 
> 
> On 5/1/2019 2:12 PM, Christian Kluge wrote:
>> Am 01.05.2019 um 22:55 schrieb Jeff Albrecht:
>> 
>>> Is there a transaction creation date available and if so how may I
>>> display it.
>>> 
>>> I did find an email thread from September 2013...
>>> 
>>> "Starting with releases in the 2.5 series (which is still in alpha or
>>> beta, depending on your opinion), the date entered will be visible if
>>> you have your preferences set to show it."
>>> https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050587.html
>>> 
>>> Searched through preferences a couple times. I'm not seeing it.
>>> 
>> I don’t know which OS you’re using but on Linux with the experimental
>> features compile option I can start gnucash with the --extra option and
>> can enable this view in the Extensions/Register 2 General Journal
>> 
>> Kind regards
>> 
>> Christian Kluge
>> 
>> 
>> ___
>> 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: [GNC] * Unsaved book - Gnucash

2019-05-01 Thread John Ralls
I sure hope so.

Regards,
John Ralls


> On May 1, 2019, at 8:32 AM, Michael Hendry  wrote:
> 
>> On 1 May 2019, at 16:02, John Ralls  wrote:
>> 
>> 
>> 
>>> On May 1, 2019, at 6:46 AM, Michael Hendry  wrote:
>>> 
>>> I’m using version 3.4 on Mac OS X High Sierra.
>>> 
>>> This comes up briefly in the Gnucash title bar when I’ve finished working 
>>> on one file and File->Open another one, although the file that is being 
>>> closed has definitely been saved already.
>>> 
>>> It doesn’t seem to have any adverse effect (apart from operator anxiety).
>> 
>> Michael,
>> 
>> GnuCash is currently written to always have a book to the point that when 
>> switching from one to another it creates one for the brief interval while 
>> the old one is closed and the new one is loading. That's the indication 
>> you're seeing. 
>> 
>> Regards,
>> John Ralls
>> 
> 
> Thanks, John.
> 
> I had suffered from premature Gnucash shutdown during file saving when I 
> first started using 3.4, so I was alarmed that something similar might be 
> happening.
> 
> IIRC that particular bug is fixed in 3.5.
> 
> Regards,
> 
> Michael Hendry

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


Re: [GNC] Segmentation Fault GC 3.5

2019-04-28 Thread John Ralls



> On Apr 28, 2019, at 7:43 AM, Mike stagl  wrote:
> 
> I just finished building gnucash 3.5 per the instructions on the wiki
> Building on Linux.
> 
> I'm running a Debian 9 (x64) system.
> 
> I can get GnuCash to install and open successfully.  When I create a
> simple checkbook, as soon as I enter any information in the register,
> GnuCash crashes.  I have a gnucash.trace file that shows the following:

Run it in the debugger and get a proper stack trace. If you didn't do a debug 
build, do one first by uninstalling, cleaning, and rebuilding, passing 
-DCMAKE_BUILD_TYPE=Debug to cmake.

Regards,
John Ralls

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


Re: [GNC] Error Retrieving Quotes

2019-04-28 Thread John Ralls



> On Apr 28, 2019, at 6:18 AM, Sachin Danave  wrote:
> 
> Hi All,
> 
> Sorry to raise an old topic, but I do hope I can get some help.
> 
> I am from India and I have setup stock accounts for various stocks that I
> hold and which are traded on National Stock Exchange in India. I have
> installed the relevant pre-requisites including Perl on my Windows 10
> machine.
> 
> In the Security Editor, I have set up a stock (e.g. HDFC Bank Limited -
> HDFCBANK.NS) with the correct ticker symbol on Yahoo Finance. I used the
> various Online Quotes options :
> a) Single - Yahoo as JSON or Yahoo as YQL
> b) Unidentified - yahoo, yahoo asia etc
> 
> When I try to Get Quotes, I get a message that there was an unidentified
> error while retrieving quotes.
> 
> Does this even work for any of the stocks traded on Indian stock exchanges
> ? Just dont want to waste my time in something that is not available ...

All of the Yahoo! price sources except yahoo_json were discontinued some time 
ago when Verizon bought Yahoo!. Using one of them will cause the dreaded 
"unknown error", so go through all of the securities for which you have quote 
retrieval enabled and make sure that none of them are using any yahoo source 
other than yahoo_json.

I just tried 
  gnc-fq-dump yahoo_json HDFCBANK.NS
and got
  Finance::Quote fields Gnucash uses:
symbol: HDFCBANK.NS  <=== required
  date: 04/26/2019   <=== recommended
  currency: INR  <=== required
  last: 2280.95  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional
so that should work.

Regards,
John Ralls


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


Re: [GNC] sqlite error from gnucash 2.6.19

2019-04-28 Thread John Ralls



> On Apr 28, 2019, at 10:20 AM, Jeff Abrahamson  wrote:
> 
> On 27/04/2019 23:44, John Ralls wrote:
>>> On Apr 27, 2019, at 10:00 AM, Jeff Abrahamson  wrote:
>>> 
>>> I opened a gnucash file (sqlite, gnucash v2.6.19, built from version
>>> c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace
>>> 
>>>   * 18:36:09  CRIT  xaccAccountGetName: assertion
>>>   'GNC_IS_ACCOUNT(acc)' failed
>>> 
>>> I presume this means some bit of corruption in the sqlite file, but
>>> googling isn't helping me know what to do about it.  Something gnucash
>>> specific?  Use sqlite tools directly?  Other?
>> Don't leap to conclusions. First run GnuCash with the --debug option. That 
>> will provide a great deal more information that should help resolve where 
>> the error is coming from.
>> 
>> If it does prove to be a database problem next run gnucash with --log 
>> gnc.backend.dbi=debug which will print out all of the SQL queries. If it's 
>> really corrupt data then the errors will be interleaved with the queries. 
>> That should provide you enough information to query the database with the 
>> sqlite3 command-line tool and figure out exactly what's wrong.
> 
> Thanks, and fair enough.  I was overly distracted by the CRIT.
> 
> Anyway, even with backend logging, I'm not seeing anything clear in the
> stream of messages that suggests a pattern, certainly not against
> specific SQL statements.  I'll watch it more closely and on a couple
> different gnucash files and report back.  Perhaps this always happens
> and I've just never noticed.

It's entirely possible that it's normal. What passes for a type system in 
GObject is managed entirely at run time and all of the type checks raise a 
critical error like that when they fail. When the engine was rewritten to use 
GObject 15 years ago the implementors didn't really understand the intricacies 
and did some things that work but aren't the best way to do it. Fixing that is 
one of the motivations for converting engine to C++: The type system is 
compile-time so it's much faster and the compiler enforces type safety so the 
programmer doesn't have to.

Regards,
John Ralls

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


Re: [GNC] Uninstall GC

2019-05-03 Thread John Ralls
No, cmake/cmake_uninstall.cmake.in is a source file so that's your source 
directory.

try
  locate install_manifest.txt

to find your build directory.

Regards,
John Ralls

> On May 3, 2019, at 1:07 PM, Dennis Powless  wrote:
> 
> dennis@dennisLaptop1:~$ locate cmake_uninstall.cmake
> /home/dennis/.local/share/Trash/files/gnucash-maint/cmake/
> cmake_uninstall.cmake.in
> /home/dennis/Applications/cmake_uninstall.cmake
> /home/dennis/Applications/gnucash-3.1/cmake/cmake_uninstall.cmake.in
> 
> Can I then run the cmake uninstall from this location?
> 
> d
> 
> On Thu, May 2, 2019 at 9:40 PM David Cousens 
> wrote:
> 
>> John,
>> 
>> Won't that simply remove the source directories. With that prefix Dennis
>> has
>> installed under /home/dennis/.local. If the build directory is under
>> ~/Applications/gnucash-3.1 then he will lose the manifest by using rm  -rf
>> on the source directory.
>> 
>> If he can locate the original build directory then issuing make uninstall
>> from a terminal open in that directory. I have adopted the practice of
>> putting the build directory inside the source directory and retaining both
>> (I once found that the make uninstall procedure seems to reference the
>> source directories not simply the manifest file or the build directories
>> but
>> I have never checked this out fully) until after I have removed a build. It
>> doesn't cause any problems and keeps everything you need for an uninstall
>> together.
>> 
>> Dennis
>> Your build directory is unlikely to be gnucash-3.1, that is most likely the
>> source directory. Where it is located is the directory from which you
>> originally executed the cmake command since you used absolute addressing to
>> the source. It may be  inside gnucash-3.1 if you used the mkdir 
>> and
>> cd  commands from the terminal open atgnucash-3.1 before issuing the
>> make command. Here  is a generic notation for a filename for a build
>> file. It will have whatever name you gave it at the time. The attached
>> screenshot gives you the directory structure and files in the build
>> directory note the dist_manifest.txt and install_manifest.txt. These will
>> be
>> present in your build directory.
>> Selection_009.png
>> <http://gnucash.1415818.n4.nabble.com/file/t375329/Selection_009.png>
>> 
>> David Cousens
>> 
>> 
>> 
>> -
>> David Cousens
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Uninstall GC

2019-05-03 Thread John Ralls
So you built in the parent directory of the sources. Not exactly recommended 
but at least it's  not the source directory itself.

What files are left?

Regards,
John Ralls

> On May 3, 2019, at 1:16 PM, Dennis Powless  wrote:
> 
> I was able to run make uninstall on the Applications directory.
> 
> The terminal completed the task.
> 
> However, there seems to be still files hanging around.
> 
> d
> 
> On Fri, May 3, 2019 at 4:07 PM Dennis Powless  wrote:
> 
>> dennis@dennisLaptop1:~$ locate cmake_uninstall.cmake
>> /home/dennis/.local/share/Trash/files/gnucash-maint/cmake/
>> cmake_uninstall.cmake.in
>> /home/dennis/Applications/cmake_uninstall.cmake
>> /home/dennis/Applications/gnucash-3.1/cmake/cmake_uninstall.cmake.in
>> 
>> Can I then run the cmake uninstall from this location?
>> 
>> d
>> 
>> On Thu, May 2, 2019 at 9:40 PM David Cousens 
>> wrote:
>> 
>>> John,
>>> 
>>> Won't that simply remove the source directories. With that prefix Dennis
>>> has
>>> installed under /home/dennis/.local. If the build directory is under
>>> ~/Applications/gnucash-3.1 then he will lose the manifest by using rm  -rf
>>> on the source directory.
>>> 
>>> If he can locate the original build directory then issuing make uninstall
>>> from a terminal open in that directory. I have adopted the practice of
>>> putting the build directory inside the source directory and retaining both
>>> (I once found that the make uninstall procedure seems to reference the
>>> source directories not simply the manifest file or the build directories
>>> but
>>> I have never checked this out fully) until after I have removed a build.
>>> It
>>> doesn't cause any problems and keeps everything you need for an uninstall
>>> together.
>>> 
>>> Dennis
>>> Your build directory is unlikely to be gnucash-3.1, that is most likely
>>> the
>>> source directory. Where it is located is the directory from which you
>>> originally executed the cmake command since you used absolute addressing
>>> to
>>> the source. It may be  inside gnucash-3.1 if you used the mkdir 
>>> and
>>> cd  commands from the terminal open atgnucash-3.1 before issuing
>>> the
>>> make command. Here  is a generic notation for a filename for a
>>> build
>>> file. It will have whatever name you gave it at the time. The attached
>>> screenshot gives you the directory structure and files in the build
>>> directory note the dist_manifest.txt and install_manifest.txt. These will
>>> be
>>> present in your build directory.
>>> Selection_009.png
>>> <http://gnucash.1415818.n4.nabble.com/file/t375329/Selection_009.png>
>>> 
>>> David Cousens
>>> 
>>> 
>>> 
>>> -
>>> David Cousens
>>> --
>>> Sent from:
>>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Need loan to upgrade my truck

2019-05-08 Thread John Ralls


> On May 8, 2019, at 5:43 AM, GeorgeMunday  wrote:
> 
> My wife and I are finally deciding to upgrade our truck and buy something
> bigger newer and more powerful. But I don't have that much cash to drop on a
> truck. I have never had a truck loan before. I have talked to my bank and
> got the reply "we have not had good experiences financing trucks" and so
> they turned me down. I have also talked to a few people who said that is
> common. 
> My friend then told me to try  the truck financing company
> <http://www.truckloancenter.com/service-areas/truck-loans-lease-atlanta/>  
> as they provide loans for trucks. I don't know whether they will be able to
> finance me. I am not sure if we are going brand new or slightly used. How
> much down payment should I need to pay?
> If you guys could give me any information I’d appreciate it.  Any
> information or suggestions would be great! Thanks!
> 

Dear Mr. Munday,

Sorry, you've stumbled into the wrong list. We discuss a Free accounting 
program called GnuCash here. We emphatically do not offer financial advice.

Regards,
John Ralls

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


Re: [GNC] Search, amounts not correct

2019-07-04 Thread John Ralls



> On Jul 4, 2019, at 3:47 AM, elvo  wrote:
> 
> Hi.
> I have an issue that is bugging me..
> When I search an account for i.e a description, the result always shows the
> entries with ALOT of zero's.
> Almost impossible to see the amount. And When I mark the row/amount, that
> selection just empties/clears, and if I mark another entry, the value of the
> previous selected entry reappears.
> 
> Don't know what is wrong. The PC is set to System Language "English", and
> the Locale/international settings is Sweden "Swedish". The accounts have
> Currency SEK (Swedish krona), and the settings for reports is also set to
> SEK.
> What is wrong?

The OS is Microsoft Windows, right? What version of GnuCash?

Regards,
John Ralls

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


Re: [GNC] Scheduled transactions: Why create in advance?

2019-07-10 Thread John Ralls



> On Jul 10, 2019, at 2:52 PM, Adrien Monteleone 
>  wrote:
> 
> The website has all the info needed to get started with the code.

No, the *wiki* has some information needed to get started with the code... but 
it's up to the prospective contributor to have learned the necessary 
programming skills elsewhere.

Regards,
John Ralls

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


Re: [GNC] Miscalculation in cashflow reports

2019-07-13 Thread John Ralls


> On Jul 2, 2019, at 11:01 PM, mongolie2006-gnu--- via gnucash-user 
>  wrote:
> 
> Erdenet (Mongolia).
> 
> Hello.
> This discussion concerns the following bug:
> 797093 – Miscalculation in cashflow reports
> 
> | 
> | 
> |  | 
> 797093 – Miscalculation in cashflow reports
> 
> 
> |
> 
> |
> 
> |
> 
> When there is a split, GnuCash doesn't correctly calculate the cash flow. The 
> attached file, which is essentially the same as the one posted by Fiable.biz 
> (me) in bug #622778, shows a salary of 1 000 € paid for half by bank transfer 
> (in cash), for half from a loan granted to the employee. Now see the cash 
> flow report for the sole bank account, from 2010-01-01 to 2010-12-31, in 
> euros. You'll see that the "money out" is 1 000 €, compensated by 500 € of 
> Money in, while the Money out should be 500 €, and Money in should be 0. The 
> money from A/Receivable doesn't goes to the bank account. It's not a cash 
> flow. It will never appear in my bank transactions statement. My bank cannot 
> know it. It goes directly to the expenses (payroll) account.
> 
>   When there are multiple credit accounts and multiple debit accounts in a 
> split, my idea is that the amount of money in a credit account should be, for 
> the cash flow report calculation, regarded as distributed between the debit 
> accounts proportionally to the total amounts affected to these debit accounts 
> (and reciprocally, the amount of money in a debit account should be regarded 
> as distributed between credit accounts proportionally to the amounts affected 
> to these credit accounts).
> 
>   But when there is only one debit account and multiple credit accounts, or 
> the opposite, the calculation is indisputable, and the above example shows a 
> clear bug.From IFRS for SMEs (version 2015, in force), no.7.1:
> "The statement of cash flows provides information about the changes in cash 
> and cash equivalents of an entity for a reporting period" (End of quotation)
> So things don't producing any change in cash or cash equivalents are not 
> "cash flow".
> Therefore I would like that old bug to be corrected...
> Thank you for your attention.


There hasn't been much of a response, perhaps because the presentation here 
isn't clear.

The bug, https://bugs.gnucash.org/show_bug.cgi?id=797093, complains that the 
Cash Flow report on a single bank account reports the following transaction:

Assets:Bank Cr 500
Assets:Other   Cr 500
Expenses:Payroll  Dr 1000

as 
Money in:
   Assets: Other 500
Money Out:
   Expenses: Payroll1000
Difference: -500

Which isn't right: Although the net at the bottom is correct, the report 
implies that 500 flowed through the Bank and it didn't.

Where it gets more interesting is when there are multiple in and out splits in 
a single transaction, e.g.

Assets:Bank   Cr 500
Assets:Other  Cr 200
Expenses:PayrollDr 600 
Expenses:ElseDr 200 

In that case, the Cash Flow report on Assets:Bank should show an outflow of 
500, but how should it be apportioned between Expenses:Payroll and 
Expenses:Else? 500 to Payroll, 300 to Payroll and 200 to Else, 375 to Payroll 
and 125 to Else, or something else?

Or does it even matter?

Regards,
John Ralls


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


Re: [GNC] importing invoices

2019-07-13 Thread John Ralls



> On Jul 13, 2019, at 9:07 AM, Jonathan Francoeur  wrote:
> 
> Hi.  I am trying to import invoices after reading this
> <https://www.gnucash.org/docs/v3/C/gnucash-guide/busnss-imp-bills-invoices.html>
> .
> I copied the examples into a .csv file because I assumed they would work
> however I keep getting "customer does not exist" error.  I'm confused
> because the error dialogue refers to the data in the first column which
> according to the above link is the invoice ID and not to do with the
> customer.
> Here are some images":
> This one shows the import window.  I changed the id's from what the example
> in the above link gave to match what I have already created.  I also
> changed the dates to be in the future so that I could easily find them and
> delete them.  I also changed the account names to correspond with existing
> accounts.

You're misinterpreting the message, which is admittedly a little ambiguous. 
Since it's an invoice, the Owner type is Customer, and you have a column filled 
with "1" designated as "Owner Id". The importer thinks that there is no 
customer 1. Is it correct?

Regards,
John Ralls


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


[GNC] GnuCash 3.6 for MacOS 10.15 Catalina

2019-07-07 Thread John Ralls
Apple introduced a new security feature last fall, Notarization [1]. As anyone 
trying the new Catalina public beta may have discovered, it declines to open 
signed but not notarized programs downloaded from the web, including GnuCash 
3.6-1.

I've worked out how to sign GnuCash while still allowing it to work on older 
MacOS versions (it took a bit of experimentation, Apple's documentation isn't 
quite right) and I've uploaded a new dmg to SourceForge:

https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/3.6/Gnucash-Intel-3.6-2.dmg/download

SHA-256: 184ae9693582fb11c4ee2c3cb5a329faf470f601d842ff6f2db5a16aedd239a5

I encourage testing by the adventurous, especially anyone who's installed the 
Catalina public beta, to try it out. If there aren't any problems I'll notarize 
all (well, until the next Apple security change) future releases the same way.

Regards,
John Ralls

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


Re: [GNC] Gnucash bug

2019-07-08 Thread John Ralls


> On 8 juil. 2019, at 08:55, R. Victor Klassen  wrote:
> 
> Perhaps this has been fixed. I’m using 2.6.21 for production. 
> 
> Using SQLite I am expecting every transaction to hit disk immediately. 
> 
> Saturday we had a power failure and lost about five days’ worth of 
> transactions including at least 10 invoices and three new customers.   
> 
> I think I can reconstruct. But I wouldn’t expect this to have happened. 

Were those 5 days worth of transactions all entered together or over the 5 
days? Do the transaction logs reflect the "lost" transactions? If so you can at 
least recover them by playing the transactions back
https://www.sqlite.org/howtocorrupt.html might shed some insight on what 
happened. 

Regards,
John Ralls

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


Re: [GNC] [GNC-dev] Gnucash not showing the correct locale

2019-07-03 Thread John Ralls
Only slightly. The tarball release is e.g. 3.6. The first Windows bundle is 
3.6, but if there's a dependency problem or I screw up the bundle  subsequent 
bundles of that same release will be 3.6-1, 3.6-2, etc. The MacOS bundles work 
the same way except that the first one is 3.6-1... 1-based counting instead of 
0-based, if you like.

Regards,
John Ralls

> On Jul 3, 2019, at 9:55 AM, David Carlson  wrote:
> 
> Is it normal for MAc releases to have a different number than Windows, Linus, 
> BSD, and tarballs?
> 
> On Wed, Jul 3, 2019 at 9:16 AM John Ralls  wrote:
> 
> 
> > On Jul 3, 2019, at 6:46 AM, Marco Rossi  wrote:
> > 
> > Hi everybody,
> > I’m experiencing an issue with Gnucash 3.6.1 installed on macOS Mojave 
> > 10.14.5. My default language is “italian” but Gnucash always run in english.
> > When trying to start the application from the Terminal I’ve got this 
> > warning:
> > 
> > (process:6569): gnc.gui-WARNING **: 15:31:44.760: [mac_set_languages()] 
> > Language list: it:it_IT
> > The locale defined in the environment isn't supported. Falling back to the 
> > 'C' (US English) locale
> > 
> > Anybody else has got the same issue? I’ve searched for some infos about 
> > this but with no success.
> 
> You're in the wrong list, user support questions should go to 
> gnucash-u...@lists.gnucash.org.
> 
> To directly answer your question, see 
> https://bugs.gnucash.org/show_bug.cgi?id=797297.
> 
> Regards,
> John Ralls
> 
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
> 
> 
> -- 
> David Carlson

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


Re: [GNC] GnuCash and OSX.15

2019-06-26 Thread John Ralls



> On Jun 26, 2019, at 10:42 AM, Alan Magnus  wrote:
> 
> When I open Gnucash in 10.15 this is what I see
> 
> 
> 
> 

Open System Preferences and select Security and Privacy, then select the 
Privacy pane. In the list at the left scroll down to Files and Folders. Make 
sure that GnuCash is in the right pane and that Documents Folder is selected.

Regards,
John Ralls

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


Re: [GNC] Webserver Down?

2019-04-23 Thread John Ralls


> On Apr 23, 2019, at 10:41 AM, Adrien Monteleone 
>  wrote:
> 
> Just tried to hit the server. I get a "can’t connect error" from Safari and 
> Firefox. (not helpful)
> 
> I can ping the server just fine.
> 
> An attempt via wget and elinks for both port 443 and 80 returns a ‘connection 
> refused’ error.

Looks like it. I get "connection refused" with Chrome.

Regards,
John Ralls

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


Re: [GNC] [GNC-dev] Webserver Down?

2019-04-23 Thread John Ralls


> On Apr 23, 2019, at 10:50 AM, John Ralls  wrote:
> 
> 
> 
>> On Apr 23, 2019, at 10:41 AM, Adrien Monteleone 
>>  wrote:
>> 
>> Just tried to hit the server. I get a "can’t connect error" from Safari and 
>> Firefox. (not helpful)
>> 
>> I can ping the server just fine.
>> 
>> An attempt via wget and elinks for both port 443 and 80 returns a 
>> ‘connection refused’ error.
> 
> Looks like it. I get "connection refused" with Chrome.
> 

I emailed Linas separately and he fixed whatever was the problem.

Regards,
John Ralls


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


Re: [GNC] help lost data file

2019-04-09 Thread John Ralls
The number of files is if anything too big. The most usual case would be only 
one because most people have only one book.

1. test.gnucash.gcm 
Mar 22, 2012 at 10:00 AM
2. MACS.gnucash.gcm Mar 18, 
2013 at 1:43 PM
3. MACS.gnucash_2.gcm   Mar 22, 
2012 at 9:01 AM
4. ewrofficedata.gnucash.rev.gnucash.gcmAug 7, 2013 at 
11:43 PM
5. ewrofficedata.gnucash.gcmApr 5, 
2019 at 11:21 PM
6. ewrofficedata.gnucash.2013160900.gnucash.gcm Mar 31, 2019 at 5:03 PM
7. ewrofficedata.gnucash.20130806193744.gnucash.gcm Aug 16, 2013 at 9:13 PM
8. ewrofficedata.gnucash.20130806193744.gnucash.20130807120014.log.gnucash.gcm 
Today
9. ewrofficedata.gnucash_2.gcm  Aug 6 2013 at 
8:34 PM
10 ewrofficedata copy.gnucash.gcm   Mar 31, 
2019 at 5:10 PM

You wrote your first post at 5:20 PM on March 31, so the file that you had open 
immediately before that was #10, and the one before *that* was #6. Notice that 
that's a backup file from 2013, so you apparently have been working in that one 
for the last 5+ years. 

You obviously don't want to open the .gcm file, it's 
ewrofficedata.gnucash.2013160900.gnucash that you want to open. It's 
probably in the same folder as the others. Once you've confirmed that I suggest 
that you make a new directory and use Save As to save it to the new directory 
as ewrofficedata.gnucash, then delete the old directory. GnuCash will notice 
that it can't find the other files in your history list and ask if you want to 
remove them. Tell it yes. Adjust your backups as necessary to include the new 
directory and exclude the old one and you're set.

Regards,
John Ralls



> On Apr 8, 2019, at 10:55 PM, Eric Rathhaus office  wrote:
> 
> So I used the go to command and got the first screen shot.  opening the book 
> folder and I get the second screen shot.  It’s odd that there are so few 
> files as I’ve used this program since 2012.  And when I tried to open any of 
> the recent gcm files, I get nothing or it says a suitable back up can’t be 
> found.  I getting concerned that something terriblest wrong happened and that 
> I need to restore from archived cloud version, much data.  
> 
> Kind regards,
> 
> Eric W. Rathhaus
> Law Office of Eric W. Rathhaus
> 484 Lake Park Avenue, Suite 50
> Oakland, CA 94610
> 415.577.0920 tel
> 415.737.0603 fax
> 
> www.ewrlaw.com
> 
> Confidentiality : 
> 
> The information contained in this message is legally privileged and 
> confidential information intended only for the use of the addressee(s) named 
> above.  If the reader of this message is not the intended recipient, please 
> be advised that any dissemination, distribution, or copy of the information 
> in this message, and/or the name(s) of the person(s) it is addressed to, is 
> prohibited.  If you have received this message in error, please notify us by 
> returning this email to us.  If that is not possible, we will reimburse you 
> for any costs in returning this message to us through other means.
> 
> 
> 
>> On Apr 8, 2019, at 4:09 PM, John Ralls  wrote:
>> 
>> Interesting. A little experimentation finds that it's not sufficient to just 
>> select the home directory, you must have the home directory as the primary 
>> view in Finder. If you're using Icon or List view you can double-click on 
>> your home directory to make it primary. If you're in column view you can 
>> either switch temporarily to one of the others or you can drag your home 
>> directory to the sidebar and then click on it there.
>> 
>> There's another way, though: Select Go>Go to Folder... from the menu and 
>> then type into the dialog box ~/Library/Application Support/Gnucash and 
>> click Go.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Apr 8, 2019, at 2:44 PM, Eric Rathhaus office  wrote:
>>> 
>>> Hi John - sorry to be so dense.  So those applications are old versions, I 
>>> believe.  But I navigated to me as user and still no option of show library 
>>> files appears.  I think I used to store the data in the fold err office 
>>> data, but all the files in that directory or old.  No matter where I’ve 
>>> looked, the only files I find that are recent are .log files.  I can’t find 
>>> any newer files with the .gnucash or the .gcm extensions.  I’m lost here 
>>> and the tax man is breathing down my neck. 
>>> 
>>> Kind regards,
>>> 
>>> Eric W. Rathhaus
>>> Law Office of Eric W. Rathhaus
>>> 484 Lake Park A

Re: [GNC] Downgrading to 2.6.21

2019-04-11 Thread John Ralls
Fixed, try tomorrow's nightly build from 
https://code.gnucash.org/builds/win32/maint.

Turned out to be a std::string scoping issue, gory details in 
https://github.com/Gnucash/gnucash/commit/c091197f572a701cb2ecc81c40fe47bbd41f59aa.

Regards,
John Ralls


> On Apr 11, 2019, at 1:49 PM, Greg Feneis  wrote:
> 
> Yay! 
> 
> 
> 
> 
> Kind regards,
> 
> Greg Feneis
> 
> 
> 
> On Thu, Apr 11, 2019 at 1:08 PM John Ralls  wrote:
> I managed to replicate the error on Win7 and I've debugged into it a bit. The 
> gibberish in the pathname is because a wide-character string returned from 
> Windows is getting interpreted as a normal-character string. But that's not 
> the only problem, the path to the user-config-dir is getting overwritten with 
> the candidate storage path, and that's what's causing the error.
> 
> For some reason this doesn't happen on Win10, so a parallel debugging session 
> there is next.
> 
> Regards,
> John Ralls
> 
> 
> > On Apr 11, 2019, at 10:22 AM, Adrien Monteleone 
> >  wrote:
> > 
> > Nevermind. I got lost in the thicket.
> > 
> > I see a message now that you already eliminated DropBox as the problem 
> > because there are local paths that won’t save either.
> > 
> > Sorry for the noise.
> > 
> > Regards,
> > Adrien
> > 
> >> On Apr 11, 2019, at 12:14 PM, Adrien Monteleone 
> >>  wrote:
> >> 
> >> Colin,
> >> 
> >> This is what I understood as the point to test some messages ago.
> >> 
> >> Greg,
> >> 
> >> Several messages back someone mentioned needing to install the DropBox 
> >> client to get real paths as opposed to some mapped paths. The reason for 
> >> this is the mapped paths (which are displayed as real paths instead) are 
> >> insanely longer than the real ones. (ostensibly using some sort of UUID in 
> >> place of each path node) If you use the client, you’ll be using the real 
> >> displayed paths that you see. The premise is that while DropBox is showing 
> >> you what you think is the path, it is reporting something else to GnuCash. 
> >> The path is being garbled by the error message because of non-standard 
> >> characters in the mapped path from DropBox.
> >> 
> >> So the problem *might* be resolved, (or at least pinpointed) by showing 
> >> FULL paths, because that would show you the path you think you are 
> >> accessing isn’t really that short, it is MUCH longer.
> >> 
> >> Of course, this might not resolve the problem, but eliminating 
> >> possibilities is part of chasing bugs. If you do have the desktop client 
> >> installed, then you still have another problem, or you indeed found a bug.
> >> 
> >> Regards,
> >> Adrien
> >> 
> >> 
> >>> On Apr 11, 2019, at 10:58 AM, Colin Law  wrote:
> >>> 
> >>> And, to continue, I hit reply too soon. It is the actual path that
> >>> gnucash sees not the mirage, so potentially something in the actual
> >>> path is confusing GC.
> >>> 
> >>> Colin
> >>> 
> >>> On Thu, 11 Apr 2019 at 16:55, Colin Law  wrote:
> >>>> 
> >>>> In that case I misunderstood.  I thought the point was that Dropbox
> >>>> does some clever path mapping that makes it look as if the file is at
> >>>> the location you see in the browser, but actually that is a mirage.
> >>>> It is actually somewhere else entirely.
> >>>> 
> >>>> Colin
> >>>> 
> >> 
> > 
> > 
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see 
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 

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


Re: [GNC] Register Reconcile Issue

2019-06-28 Thread John Ralls



> On Jun 28, 2019, at 1:24 PM, Dale Alspach  wrote:
> 
> 
> Today I was reconciling an account and noticed a peculiar behavior.
> 
> Typically I check heavily used credit and bank accounts online a few
> times a month. At that time I mark transactions cleared "c" which have
> appeared online. When a statement comes I usually clear any additional
> transactions appearing on the statement and then click Reconcile.
> 
> Today I marked a transaction but apparently did not hit "enter" or move
> off the transaction before hitting Reconcile.
> 
> In the Reconcile window this transaction was not marked cleared so I
> marked it and finished the reconciliation. To my surprise this
> transaction was not marked "y". This seems to me to be a bug. It could
> easily confuse a user and foul subsequent reconciliations.
> 
> A possible resolution would be to have "Reconcile" pop up the "save or
> discard changes" message, when there have been modifications, before
> opening the reconcile window. Second, if a transaction is marked in the
> reconcile window and the reconcile is finished, all reconciled
> transactions should be marked "y" in the register regardless of previous
> state.

It might not be intuitive but it's not a bug: You've started an edit on the 
transaction but the changes you've made aren't visible to the rest of the 
program until you commit them by moving to another transaction, nor can any 
other part of the program edit it.

The suggestion that reconciling an account should be permitted only if the 
account has no transactions being edited is reasonable and should prevent both 
problems.

Regards,
John Ralls

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


Re: [GNC] Checksum

2019-07-02 Thread John Ralls
The checksums are in the release notes for each version, 
http://www.gnucash.org/news.phtml and 
https://github.com/Gnucash/gnucash/releases/tag/3.6 (file downloads at the 
bottom), on the SourceForge download page, 
https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/3.6/,
and were in the release announcement email.

Regards,
John Ralls


> On Jul 1, 2019, at 8:35 PM, Dale Alspach  wrote:
> 
> Thanks,
> 
> Still checksums should be linked from the same location as the files or
> be on the gnucash.org site.
> 
> Dale
> 
> On 7/1/19 5:06 PM, David Carlson wrote:
>> Quote from the release announcement:
>> 
>> "
>> 
>> The SHA256 Hashes for the downloadable files are:
>> 
>>  * |f1cb86de60bb0eb2cf5c2c3868e7dab7d889017e233230f944f158f84eb85f25|  
>> gnucash-3.6.tar.bz2
>>  * |a9275a8d2aef576016b7f58b08bcc71739902e2e81787171af83c2576e21d085|  
>> gnucash-3.6.tar.gz
>>  * |cb8ba5aa13dce6c9caedfb774abef47b8e352c2cda7d762d3f74840f1b12766a|  
>> gnucash-3.6.setup.exe
>>  * |a9275a8d2aef576016b7f58b08bcc71739902e2e81787171af83c2576e21d085|  
>> Gnucash-Intel-3.6-1.dmg
>>  * |32d373a4faa96cde2bba564bc8d7143d6317f121c488492f2dc5ebe99b4b6163|  
>> gnucash-docs-3.6-1.tar.gz
>> 
>>  * SourceForge:
>>  o Win32
>>
>> <http://downloads.sourceforge.net/gnucash/stable/gnucash-3.6.setup.exe>
>>  o Mac-Intel
>>
>> <http://downloads.sourceforge.net/gnucash/stable/Gnucash-Intel-3.6-1.dmg>
>>  * Github
>>  o Win32
>>
>> <https://github.com/Gnucash/gnucash/releases/download/3.6/gnucash-3.6.setup.exe>
>>  o Mac-Intel
>>
>> <https://github.com/Gnucash/gnucash/releases/download/3.6/Gnucash-Intel-3.6-1.dmg>
>> 
>> "
>> 
>> Is that close enough?
>> 
>> On Mon, Jul 1, 2019 at 3:23 PM Dale Alspach > <mailto:alspac...@gmail.com>> wrote:
>> 
>>I have been building the 3.x series on linux 18.3 from source. Why is it
>>that the checksum for the source bzipped tarball is not readily
>>available. I have yet to find it for the 3.6 release.
>>The download link from gnucash.org <http://gnucash.org> fetches
>>gnucash-3.6.tar.bz2 from
>>sourceforge.net <http://sourceforge.net> but provides nothing else.
>> 
>>Dale
>>___
>>gnucash-user mailing list
>>gnucash-user@gnucash.org <mailto: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.
>> 
>> 
>> 
>> -- 
>> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Version 3.6 crashes on MacOS 10.14.5

2019-07-02 Thread John Ralls
If there's no crash log it's likely that Gatekeeper just failed to start it 
after verification. If that's the case it will start up normally the next time 
you launch it.

Regards,
John Ralls


> On Jul 2, 2019, at 8:23 AM, Adrien Monteleone via gnucash-user 
>  wrote:
> 
> There is a tracefile, but make sure to create a copy of it somewhere else 
> because it gets overwritten with the next launch.
> 
> Instructions here: http://wiki.gnucash.org/wiki/Tracefile
> 
> Also, was a crash report not generated when it blew up? Usually MacOS creates 
> and displays a crash report on screen. You can copy and paste the contents to 
> a file and attach them to a bug report. (do not copy and paste the crash or 
> the tracefile into a bug report comment, though, make sure to attach them as 
> text files)
> 
> If you happened to close that crash report, you should be able to find it 
> using Console.app.
> 
> Regards,
> Adrien
> 
>> On Jul 2, 2019, at 9:45 AM, Roderick Averill  
>> wrote:
>> 
>> I’m currently using version 3.4 with no issues.
>> 
>> I downloaded version 3.6-1 for the MacOS and when I open it, it immediately 
>> crashes.
>> 
>> Is there a log file that I can review?
>> 
>> Rod
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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


Re: [GNC] Price in Register Account report not decimal

2019-08-12 Thread John Ralls
I don't see any open bugs about this so please file one.

Regards,
John Ralls


> On Aug 12, 2019, at 1:00 AM, Joe Normandeau  
> wrote:
> 
> Interestingly I opened the html report in Libreoffice Calc directly and it 
> had the decimal not the fraction.  Didn't even need to put the "=" in front 
> of it.  So thanks John for your suggestion. I'll use it as a work around. Bit 
> of formatting to do but minor issue.
> 
> Should this be reported as a bug or just leave it as is.?
> 
> JoeCanuck
> 
> On 12/08/2019 1:56 am, John Ralls wrote:
>> That preference is for the GUI. I don't think that it has any affect on 
>> reports.
>> 
>> I can reproduce this, where a price for 5712 shares has a value of 85,505.78 
>> and is represented as 14.9695 in the register but as 14 + 276889/285600 on 
>> the Account Report. I don't think that there's an immediate solution for 
>> that other than to paste the report into a spreadsheet and stick an '=' in 
>> front of the price to make it a formula.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Aug 11, 2019, at 3:24 AM, Joe Normandeau 
>>>  wrote:
>>> 
>>> Colin
>>> 
>>> Yep
>>> 
>>> Build ID: 3.6 + (2019-06-29)
>>> 
>>> JoeCanuck
>>> 
>>> On 11/08/2019 5:36 pm, Colin Law wrote:
>>>> On Sun, 11 Aug 2019 at 07:00, Joe Normandeau  
>>>> wrote:
>>>>> Apologies Adrien
>>>>> 
>>>>> I should have stated that flag is already turned on and I've cycled it
>>>>> number of times and it makes no difference to the Register Account Report.
>>>> Have you tried that again since you upgraded to 3.6?
>>>> Also are you sure it is definitely running 3.6?  Check in Help > About.
>>>> 
>>>> Colin
>>>> 
>>>>> JoeCanuck
>>>>> 
>>>>> 
>>>>> On 10/08/2019 11:58 pm, Adrien Monteleone wrote:
>>>>>> Preferences > General > Numbers > Force prices to display as numbers
>>>>>> 
>>>>>> Regards,
>>>>>> Adrien
>>>>>> 
>>>>>>> On Aug 10, 2019, at 4:09 AM, Joe Normandeau  
>>>>>>> wrote:
>>>>>>> 
>>>>>>> 
>>>>>>> On 10/08/2019 5:37 pm, Colin Law wrote:
>>>>>>>> On Sat, 10 Aug 2019 at 06:19, Joe Normandeau  
>>>>>>>> wrote:
>>>>>>>>> I'm just new to this mail list so if I get something wrong be gentle.
>>>>>>>>> 
>>>>>>>>> I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the 
>>>>>>>>> price
>>>>>>>>> in the register account report to be decimal. It always comes out as 2
>>>>>>>>> +  a fraction ie. 2 + 6227/6779. I must be missing a configuration
>>>>>>>>> setting but I can't seem to get the right one. Can someone assist 
>>>>>>>>> please?
>>>>>>>> I think that may have been a bug in 3.3.  Why are you not using the
>>>>>>>> latest available for Windows, which is 3.6 I think?
>>>>>>>> https://gnucash.org/download.phtml
>>>>>>>> 
>>>>>>>> Colin
>>>>>>> Thanks for your comments Collin.
>>>>>>> 
>>>>>>> I've loaded 3.6 and the same thing happens.  Don't know where to go 
>>>>>>> from here as I need these reports for my auditor.
>>>>>>> 
>>>>>>> JoeCanuck
>>>>>> ___
>>>>>> 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.
>>>>>> 
>>>>> ---
>>>>> This email has been checked for viruses by AVG.
>>>>> https://www.avg.com
>>>>> 
>>>>> _

<    5   6   7   8   9   10   11   12   13   14   >