Re: Mac OS accelerator keys

2017-09-12 Thread Deva -
Thank you for the response John.

It was nice to know some historical context on this one.

I changed the ~/Library/Application Support/Gnucash/accelerator-map file as you 
suggested (see sample extract below). First, I had it as "b”, “l”, 
etc. Started up gnucash, but nothing was happening when I pressed the Alt+l or 
Alt+j key on an open account register while I was on a transaction line.

So I closed gnucash, went back and edited the file again to replace  with 
 as shown in the extract here. Started up gnucash again, and used the 
“Command” key with these letter combinations, but still no effect.

; (gtk_accel_path "/GncPluginPageRegisterActions/ViewStyleBasicAction" 
"b”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/ViewStyleAutoSplitAction" "l”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/JumpTransactionAction" "j”)
; (gtk_accel_path 
"/GncPluginPageRegisterActions/DuplicateTransactionAction" 
"d”)

I perform these actions fairly frequently on any given transaction register, so 
I am keen on getting this to work.

Am I missing something?

Cheers,
Deva

On 12-Sep-2017, at 8:09 PM, John Ralls 
> wrote:



On Sep 12, 2017, at 5:30 AM, Deva - 
> wrote:

Hello,

I am running Gnucash v2.6.6 on Mac OS Sierra.

This is in response to an earlier post clarifying how to setup keyboard access 
to frequently performed functions by Christopher Lam (see below). I couldn’t 
find a way to respond to that specific thread from my daily digest mail, hence 
this.

I presume that post was about a windows fix. On my Mac, I found a similar file 
called osx_accel_map under 
/Applications/Gnucash/Contents/Resources/share/gnucash/ui.

I edited the file (after making a backup of the original file) for the 2 lines 
mentioned in the earlier post, but instead of "j" and "l”, I 
changed it to “j” and “l” based on other such entries in the file.

I restarted gnucash after these edits, but these accelerator keys don’t seem to 
work on an open register. I tried pressing both  as well as  for 
the  key, but with no effect - nothing happens.

Can you please let me know how I can set this up for a Mac?

Deva,

The file you want to edit is ~/Library/Application 
Support/Gnucash/accelerator-map. The one in the bundle is obsolete and not used.

 means “Command” on Mac and “Control” everywhere else.  means 
“Alt”; on a Mac that’s the Alt/Option key. (The history about that is that I 
had a spirited discussion with Mitch Natterer of The GIMP about how to map 
control to command.  isn’t a modifier key in Gtk. I wanted to map 
command to meta, but Mitch insisted that  should be Alt/Option to be 
consistent with Linux and Win32. He solved the problem rather elegantly by 
inventing . Shortly after that Mike Alexander improved my accelerator 
map code in GnuCash to not use osx_accel_map but didn’t remove it in case it 
might prove useful.)

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: using custom text to effect class reports

2017-09-12 Thread Cindy Doughty
The transaction report I posted today (Sept 12 2017) should be able to
search just note fields, just change the entry on the "sort" tab.

Doug Doughty

On Fri, Sep 1, 2017 at 12:16 PM, George Riner 
wrote:

> I'm using the trick of inserting a custom piece of text into transactions
> so that I can then select/sort for that text in report generation. This is
> to get a quicken-style 'class report'. I then put that custom bit of text
> into the "Description contains:" field of the 'Sorting' tab on the report
> options.
>
> It works fine, and I've been using it to mostly satisfaction.
>
> Except that the only option to search in is the 'Description' field. I do
> make purchases with 1 charge to my credit card where the items I bought
> apply to different 'classes' and I insert my custom-text into each 'note'
> field of the split transaction. but I can't set the report options to
> filter by Memo or Note field; only the Description field.
>
> Is my only recourse at present to 'un-split' the transaction into the 2 or
> 3 different transactions for each 'class'? Or am I missing some other
> report filtering options that work on the Memo &/or Note fields?
>
> :George
> Gnucash 2.6.17
> Windows 10
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: saved report

2017-09-12 Thread John Ralls


> On Sep 12, 2017, at 6:33 PM, Dennis Powless  wrote:
> 
> Both are Linux.
> 
> I'm not sure how to adjust that, will have to look into that.
> 

One way to do it is to set
  GNC_DOT_DIR=/path/to/dropbox/gnucash
in /etc/gnucash/environment.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Transaction Report - Subtotaling on Description? (Based on Previous Threads)

2017-09-12 Thread John Ralls


> On Sep 12, 2017, at 6:03 PM, Cindy Doughty  wrote:
> 
> I have attached a copy of my modified version of the transaction report.
> This version has the following features
> 
> 1. On the display tab you can select to consolidate transactions and the
> report will combine all similar transactions into one total entry.  By
> checking and unchecking entries on the display tab you can change how the
> numbers are combined - by description, memo, notes, account.  The date
> ranged which is combined is controlled based on the date range selected on
> the sorting tab.  You can combine for an entire year, by month, by week, or
> by quarter.
> 
> 
> 
> 2. You can use the find option on the sorting tab to limit the report to
> only descriptions containing specific text and you can limit the amount to
> a given range such as only amounts greater than 500.
> 
> 
> 
> 3. You can specify on the general tab you want all of the entries to be
> scaled.  By which I mean you can take the results for a full year and
> divide it by 365 to see what the amounts are on a daily basis.  You can
> also take the numbers for a quarter and multiply by 4 to see what they
> would look like on an annual basis.
> 
> 
> 
> 4. You can easily select a time period on the general tab.  Such as last
> quarter, 2nd half of the year, or the month of January.  I have also
> modified the Income statement in the "other" menu to provide this same
> capability.
> 
> 
> 
> To install, download the attached files and put them into your .gnucash
> folder.  In windows for me this is c:/users/UserName/.gnucash.  Warning if
> you already have a config.user file then first put into a different folder
> and then copy the entries in config.user into your existing config.user
> file.  The transaction  report will show up under reports, the income
> statement  in "Other".

Doug,

Can we interest you in getting your reports added to the repository so that 
people don’t have to search the email archives for them?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: saved report

2017-09-12 Thread Dennis Powless
Both are Linux.

I'm not sure how to adjust that, will have to look into that.

D

Sent from my iPhone

> On Sep 12, 2017, at 4:42 PM, John Ralls  wrote:
> 
> 
>> On Sep 12, 2017, at 9:04 AM, Dennis Powless  wrote:
>> 
>> Can I have a saved report 'saved' to my dropbox folder?  I'm sure I can
>> move it there, but will gnucash look for it where it was last saved, or
>> will it only look in the normal location?  I use multiple devices and need
>> it across those.
>> 
> 
> You can set $GNC_DOT_DIR to point at your dropbox folder. Do note that 
> GnuCash stores window positions in that folder too so  if your various 
> devices have different display sizes there might be a disappearing window 
> problem on the ones with smaller displays.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: GnuCash security symbol incompatible with financeQuote

2017-09-12 Thread John Ralls

> On Sep 12, 2017, at 12:57 PM, gnucash_noob_22237  
> wrote:
> 
> I agree, FinanceQuote reacts perfectly well when presented with the correct
> symbol.
> 
> The problem I still can't overcome is how to get GnuCash to present
> FinanceQuote with the correct symbol for this security. I tried to create a
> new security with symbol "BTEM.L" but GnuCash will not let me continue until
> I give a "Type". Say I choose "LSE", for example. I am not allowed to leave
> it empty.
> 
> Now, when I go to the price editor and click "Get Quotes", I see:
> "Unable to retrieve quotes for these items: LSE:L.BTEM".
> 
> This is what I was referring to. How can I remove the "LSE:" part? Or how
> can I override this default behaviour by which GnuCash enforces the FQ
> request to be formatted like "X:Y" ?

GnuCash doesn't send the LSE: part to Finance::Quote, it just uses it for the 
error dialog.

Why did you set the symbol to L.BTEM instead of BTEM.L?

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: GnuCash security symbol incompatible with financeQuote

2017-09-12 Thread gnucash_noob_22237
I agree, FinanceQuote reacts perfectly well when presented with the correct
symbol.

The problem I still can't overcome is how to get GnuCash to present
FinanceQuote with the correct symbol for this security. I tried to create a
new security with symbol "BTEM.L" but GnuCash will not let me continue until
I give a "Type". Say I choose "LSE", for example. I am not allowed to leave
it empty.

Now, when I go to the price editor and click "Get Quotes", I see:
"Unable to retrieve quotes for these items: LSE:L.BTEM".

This is what I was referring to. How can I remove the "LSE:" part? Or how
can I override this default behaviour by which GnuCash enforces the FQ
request to be formatted like "X:Y" ?




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Unit Trusts assistance development

2017-09-12 Thread Hylton Conacher (ZR1HPC)

Dear John,

On 10/09/2017 16:10, John Ralls wrote:




On Sep 10, 2017, at 1:26 AM, Hylton Conacher (ZR1HPC)  
wrote:

Hi,

I am a new user of Gnucash 2.6.17 on a Mac and after many years using the 
earlier versions (95/98) of Quicken on Windows Have started a fresh set of 
accounts on Gnucash, for personal use, since the 1st Sept.

I have managed to operate my way through how different the app works, and am 
actually enjoying the learning experience.

In the years previous to this I have invested funds in several unit trusts, or 
what I believe some call, Mutual Funds.

I would like to add the current balances of the unit trusts as opening balances 
in Gnucash however despite reading the on-line manual and doing some Google 
searching as well as Bugzilla searching, have been unable to successfully 
create the following unit trust type of account hierarchy, as the account type 
is not specified.

Further delving into the app trying to use either 'Stock' or 'Mutual fund' did 
not assist as then I needed to select the 'Security/Currency'. When I clicked 
on Select it only showed non-currency related items, and none of them in south 
Africa. As my country currency is not listed, despite being listed if I choose 
to add an 'Asset' account.

The composition of the units purchased is decided by the parent company from 
which you are buying the unit trusts. The money given to the company for the 
purchase of your units is invested in a variety of assets that should provide a 
return i.e. gold bullion, stocks purchased in a particular range of companies, 
bonds etc.
As the value of those investments increases i.e. those companies invested in 
are now worth more, so the value of a unit trust unit increases.
The parent company has absolute discretion on where and when it wants to invest 
your money and so manages the risk and ensures a positive return on investment, 
allowing them to take a fee of the profit earned.

A unit trust will normally be traded in the home country currency but may be 
traded in a completely different currency i.e. whilst the home currency is ZAR, 
I may have a unit trust that is traded in GBP. A unit trust consists of units 
purchased, usually to 2 or 3 decimal points i.e. 0.01 or 0.001 but some might 
be more, a price per full unit and then the currency value of the total units 
held in that particular named unit trust.

I believe this unit trust account type needs further development work and 
wonder if there is a work around?

I have raised a feature request

to request this further enhancements to Gnucash.


You believe wrong.

One accounts for units in a unit trust as units. Please STUDY the Tutorial and 
Concepts Guide, paying particular attention to the chapters on Investments and 
Capital Gains, where you’ll learn how to use GnuCash to account for 
non-currency assets.

Regards,
John Ralls


You are incorrect.
You account for your investment in units, expressed as having a currency 
value. Each transaction is actually measured in currency as there is a 
price per unit which must be paid or received. I tried to enter the 
investment as a mutual fund but the price calculation would not allow me 
to enter in values to 4 decimal places. After changing decimal places in 
the settings, I saw no change. Despite your advice and your inability to 
understand my mention that I had read and STUDIED the documentation and 
tried Google searches, I tried many methods to get the unit trust 
accounts to display properly, Gnucash is just not currently suitable for 
unit trust accounts, in my opinion, even if the account is marked as a 
Mutual fund or Stock, of which it is neither. If there is anyone else 
who actually uses Gnucash for South African unit trusts, I would be most 
pleased to hear from you.


Again John, thank you for taking it upon yourself to close my bugzilla 
post before doing any investigation into the matter or even waiting for 
a reply from the original poster. So much for you using the community 
user platform to improve the product.


I have reopened the request and will close it once I am able to 
accomplish what I require, whether it be by step by step instructions or 
further application development.


Let's make Gnucash great again.

Hylton




___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

saved report

2017-09-12 Thread Dennis Powless
Can I have a saved report 'saved' to my dropbox folder?  I'm sure I can
move it there, but will gnucash look for it where it was last saved, or
will it only look in the normal location?  I use multiple devices and need
it across those.

D
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Mac OS accelerator keys

2017-09-12 Thread John Ralls


> On Sep 12, 2017, at 5:30 AM, Deva -  wrote:
> 
> Hello,
> 
> I am running Gnucash v2.6.6 on Mac OS Sierra.
> 
> This is in response to an earlier post clarifying how to setup keyboard 
> access to frequently performed functions by Christopher Lam (see below). I 
> couldn’t find a way to respond to that specific thread from my daily digest 
> mail, hence this.
> 
> I presume that post was about a windows fix. On my Mac, I found a similar 
> file called osx_accel_map under 
> /Applications/Gnucash/Contents/Resources/share/gnucash/ui.
> 
> I edited the file (after making a backup of the original file) for the 2 
> lines mentioned in the earlier post, but instead of "j" and 
> "l”, I changed it to “j” and “l” based on other such 
> entries in the file.
> 
> I restarted gnucash after these edits, but these accelerator keys don’t seem 
> to work on an open register. I tried pressing both  as well as 
>  for the  key, but with no effect - nothing happens.
> 
> Can you please let me know how I can set this up for a Mac?

Deva,

The file you want to edit is ~/Library/Application 
Support/Gnucash/accelerator-map. The one in the bundle is obsolete and not used.

 means “Command” on Mac and “Control” everywhere else.  means 
“Alt”; on a Mac that’s the Alt/Option key. (The history about that is that I 
had a spirited discussion with Mitch Natterer of The GIMP about how to map 
control to command.  isn’t a modifier key in Gtk. I wanted to map 
command to meta, but Mitch insisted that  should be Alt/Option to be 
consistent with Linux and Win32. He solved the problem rather elegantly by 
inventing . Shortly after that Mike Alexander improved my accelerator 
map code in GnuCash to not use osx_accel_map but didn’t remove it in case it 
might prove useful.)

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Mac OS accelerator keys

2017-09-12 Thread Deva -
Hello,

I am running Gnucash v2.6.6 on Mac OS Sierra.

This is in response to an earlier post clarifying how to setup keyboard access 
to frequently performed functions by Christopher Lam (see below). I couldn’t 
find a way to respond to that specific thread from my daily digest mail, hence 
this.

I presume that post was about a windows fix. On my Mac, I found a similar file 
called osx_accel_map under 
/Applications/Gnucash/Contents/Resources/share/gnucash/ui.

I edited the file (after making a backup of the original file) for the 2 lines 
mentioned in the earlier post, but instead of "j" and "l”, I 
changed it to “j” and “l” based on other such entries in the file.

I restarted gnucash after these edits, but these accelerator keys don’t seem to 
work on an open register. I tried pressing both  as well as  for 
the  key, but with no effect - nothing happens.

Can you please let me know how I can set this up for a Mac?

Cheers,
Deva

>>> start post
From: Christopher Lam [mailto:christopher@gmail.com]
Sent: Saturday, September 9, 2017 3:49 AM
To: Drew H. >
Cc: gnucash-user@gnucash.org
Subject: Re: Add icon for "Get Transactions..."

Ah but there exists mechanism to add keyboard shortcuts.Edit your 
.gnucash/accelerator-map and maybe you'll find appropriate entry.
I've added Ctrl-J for Jump as Ctrl-L for Split as follows:

(gtk_accel_path "/GncPluginPageRegisterActions/JumpTransactionAction" 
"j")
(gtk_accel_path "/GncPluginPageRegisterActions/SplitTransactionAction" 
"l”)

<<< end post


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.