Re: importing

2017-10-11 Thread David Carlson 
What O S are you installing into and what version are you installing?
The help files come along automatically in Windows and most Linux packages.

David C


On Oct 11, 2017 11:18 PM, "frank raney"  wrote:

> I can't find the documentation to tell me where to put the help files.  I
> put them in the same dir as the program but when I click on help, I am told
> it can not be found.
>
> *Frankie Raney*
> *12454 Auberry Rd.
> *
> *Clovis, Ca
> .*
> *559.297.8577 <(559)%20297-8577> H*
> *559.304.1751 <(559)%20304-1751> C*
>
> On 10/11/2017 2:14:08 PM, David Carlson 
> wrote:
> I forgot to mention that there is a setting somewhere called "Use Trading
> Accounts" that turns that feature on or off.  I think it is mentioned
> somewhere in the documentation.
>
> David C
>
> On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> Frank,
>>
>> There is still a problem with Gnucash on your computer because it should
>> not be crashing.
>>
>> It may be somehow related to the account named Trading that GnuCash
>> created.  Normally, GnuCash will only create that account for users that
>> know that they want to use a special feature that is there for investors to
>> use to help with capital gains calculations, and it normally isn't used by
>> most people.
>>
>> Actually, I am not sure how to safely delete that account (and prevent it
>> from coming back) if you do not want it, because it contains transfers to
>> and from your security accounts.  Perhaps a developer or another user can
>> advise us about that.   That is still not the cause of the crash, the
>> developers may need more details about that.
>>
>> Good luck.
>>
>> David C
>>
>>
>> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:
>>
>>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
>>> wrote:
>>>
>>> > I just answered my own question..The lck file is a temporary
>>> file
>>> > when the main file is opened.  I opened my file read only, resaved it.
>>> > closed it and the lck file went away.  I opened the file in a smaller
>>> > window so I coiuld see my directory and the lck file appeared
>>> again..it
>>> > went away when I closed the file..so.what was happening
>>> was,
>>> > when the program crashed, it did not close the lck file, and when I
>>> tried
>>> > to reopen it, it thought it was in usewala..Im back in
>>> > business...
>>> >
>>> >
>>> > Frankie Raney
>>> > 12454 Auberry Rd.
>>> 
>>> > Clovis, Ca
>>> 
>>> .
>>> > 559.297.8577 H
>>> > 559.304.1751 C
>>>
>>>
>>> That lck file is the mechanism by which gnucash ensures that each file is
>>> only opened once at a time. If that file is there, that means gnucash is
>>> using the corresponding ".gnucash" file. Of course, if gnucash crashes
>>> and
>>> is unable to delete that .lck file, it will superexist the gnucash
>>> process.
>>> In this case, the correct choice is "open anyway", and copying everything
>>> first is an excellent idea, too.
>>> ___
>>> 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.
>>>
>>
>>
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_-361508229154219599_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
___
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: importing

2017-10-11 Thread frank raney 
I can't find the documentation to tell me where to put the help files.  I put 
them in the same dir as the program but when I click on help, I am told it can 
not be found.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/11/2017 2:14:08 PM, David Carlson  wrote:
I forgot to mention that there is a setting somewhere called "Use Trading 
Accounts" that turns that feature on or off.  I think it is mentioned somewhere 
in the documentation.


David C


On Wed, Oct 11, 2017 at 4:07 PM, David Carlson mailto:david.carlson@gmail.com]> wrote:

Frank,


There is still a problem with Gnucash on your computer because it should not be 
crashing.


It may be somehow related to the account named Trading that GnuCash created.  
Normally, GnuCash will only create that account for users that know that they 
want to use a special feature that is there for investors to use to help with 
capital gains calculations, and it normally isn't used by most people.


Actually, I am not sure how to safely delete that account (and prevent it from 
coming back) if you do not want it, because it contains transfers to and from 
your security accounts.  Perhaps a developer or another user can advise us 
about that.   That is still not the cause of the crash, the developers may need 
more details about that.


Good luck.


David C



On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws mailto:dartm...@gmail.com]> wrote:

On Wed, Oct 11, 2017 at 3:31 PM, frank raney mailto:frankraney...@gmail.com]>
wrote:

> I just answered my own question..The lck file is a temporary file
> when the main file is opened.  I opened my file read only, resaved it.
> closed it and the lck file went away.  I opened the file in a smaller
> window so I coiuld see my directory and the lck file appeared again..it
> went away when I closed the file..so.what was happening was,
> when the program crashed, it did not close the lck file, and when I tried
> to reopen it, it thought it was in usewala..Im back in
> business...
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 [tel:559.297.8577] H
> 559.304.1751 [tel:559.304.1751] C


That lck file is the mechanism by which gnucash ensures that each file is
only opened once at a time. If that file is there, that means gnucash is
using the corresponding ".gnucash" file. Of course, if gnucash crashes and
is unable to delete that .lck file, it will superexist the gnucash process.
In this case, the correct choice is "open anyway", and copying everything
first is an excellent idea, too.

___
gnucash-user mailing list
gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
https://lists.gnucash.org/mailman/listinfo/gnucash-user 
[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.




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: importing

2017-10-11 Thread David Carlson 
I forgot to mention that there is a setting somewhere called "Use Trading
Accounts" that turns that feature on or off.  I think it is mentioned
somewhere in the documentation.

David C

On Wed, Oct 11, 2017 at 4:07 PM, David Carlson 
wrote:

> Frank,
>
> There is still a problem with Gnucash on your computer because it should
> not be crashing.
>
> It may be somehow related to the account named Trading that GnuCash
> created.  Normally, GnuCash will only create that account for users that
> know that they want to use a special feature that is there for investors to
> use to help with capital gains calculations, and it normally isn't used by
> most people.
>
> Actually, I am not sure how to safely delete that account (and prevent it
> from coming back) if you do not want it, because it contains transfers to
> and from your security accounts.  Perhaps a developer or another user can
> advise us about that.   That is still not the cause of the crash, the
> developers may need more details about that.
>
> Good luck.
>
> David C
>
>
> On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:
>
>> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
>> wrote:
>>
>> > I just answered my own question..The lck file is a temporary
>> file
>> > when the main file is opened.  I opened my file read only, resaved it.
>> > closed it and the lck file went away.  I opened the file in a smaller
>> > window so I coiuld see my directory and the lck file appeared
>> again..it
>> > went away when I closed the file..so.what was happening was,
>> > when the program crashed, it did not close the lck file, and when I
>> tried
>> > to reopen it, it thought it was in usewala..Im back in
>> > business...
>> >
>> >
>> > Frankie Raney
>> > 12454 Auberry Rd.
>> > Clovis, Ca.
>> > 559.297.8577 H
>> > 559.304.1751 C
>>
>>
>> That lck file is the mechanism by which gnucash ensures that each file is
>> only opened once at a time. If that file is there, that means gnucash is
>> using the corresponding ".gnucash" file. Of course, if gnucash crashes and
>> is unable to delete that .lck file, it will superexist the gnucash
>> process.
>> In this case, the correct choice is "open anyway", and copying everything
>> first is an excellent idea, too.
>> ___
>> 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: importing

2017-10-11 Thread David Carlson 
Frank,

There is still a problem with Gnucash on your computer because it should
not be crashing.

It may be somehow related to the account named Trading that GnuCash
created.  Normally, GnuCash will only create that account for users that
know that they want to use a special feature that is there for investors to
use to help with capital gains calculations, and it normally isn't used by
most people.

Actually, I am not sure how to safely delete that account (and prevent it
from coming back) if you do not want it, because it contains transfers to
and from your security accounts.  Perhaps a developer or another user can
advise us about that.   That is still not the cause of the crash, the
developers may need more details about that.

Good luck.

David C


On Wed, Oct 11, 2017 at 3:06 PM, Aaron Laws  wrote:

> On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
> wrote:
>
> > I just answered my own question..The lck file is a temporary file
> > when the main file is opened.  I opened my file read only, resaved it.
> > closed it and the lck file went away.  I opened the file in a smaller
> > window so I coiuld see my directory and the lck file appeared
> again..it
> > went away when I closed the file..so.what was happening was,
> > when the program crashed, it did not close the lck file, and when I tried
> > to reopen it, it thought it was in usewala..Im back in
> > business...
> >
> >
> > Frankie Raney
> > 12454 Auberry Rd.
> > Clovis, Ca.
> > 559.297.8577 H
> > 559.304.1751 C
>
>
> That lck file is the mechanism by which gnucash ensures that each file is
> only opened once at a time. If that file is there, that means gnucash is
> using the corresponding ".gnucash" file. Of course, if gnucash crashes and
> is unable to delete that .lck file, it will superexist the gnucash process.
> In this case, the correct choice is "open anyway", and copying everything
> first is an excellent idea, too.
> ___
> 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.

How to rename a budget?

2017-10-11 Thread gbguy 
Is there any way to rename a budget so that when you "Actions->Budget->Open
Budget" you see a new name for the budget?

I've tried "Actions->Rename Page" but that does not change the name of the
budget.  Google nor my searching of this forum yielded any help.

TIA



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

2017-10-11 Thread Aaron Laws 
On Wed, Oct 11, 2017 at 3:31 PM, frank raney 
wrote:

> I just answered my own question..The lck file is a temporary file
> when the main file is opened.  I opened my file read only, resaved it.
> closed it and the lck file went away.  I opened the file in a smaller
> window so I coiuld see my directory and the lck file appeared again..it
> went away when I closed the file..so.what was happening was,
> when the program crashed, it did not close the lck file, and when I tried
> to reopen it, it thought it was in usewala..Im back in
> business...
>
>
> Frankie Raney
> 12454 Auberry Rd.
> Clovis, Ca.
> 559.297.8577 H
> 559.304.1751 C


That lck file is the mechanism by which gnucash ensures that each file is
only opened once at a time. If that file is there, that means gnucash is
using the corresponding ".gnucash" file. Of course, if gnucash crashes and
is unable to delete that .lck file, it will superexist the gnucash process.
In this case, the correct choice is "open anyway", and copying everything
first is an excellent idea, too.
___
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: importing

2017-10-11 Thread frank raney 
I just answered my own question..The lck file is a temporary file when 
the main file is opened.  I opened my file read only, resaved it. closed it and 
the lck file went away.  I opened the file in a smaller window so I coiuld see 
my directory and the lck file appeared again..it went away when I closed 
the file..so.what was happening was, when the program crashed, it 
did not close the lck file, and when I tried to reopen it, it thought it was in 
usewala..Im back in business...


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/11/2017 12:21:33 PM, frank raney  wrote:
OK
So I redid the import and saved my self periodicallyeverything was going 
well.Untill I deleted an accoiut that was called TradingI did not have 
that accoiunt in quicken by that name.  It is my IRA...when I deleted that 
file, the program crashed again.  I had just saved before I tried to delete.  
(it also saved its own with date..

When I tried to open my file I got a message that the lock file could not be 
found...  I opened the backup created by GC but the main checking account is 
not the same.  The message was " GnuCash could not obtain the lock for 
file://C:\Users\Frankie\Documents\gnucash\mydata 2017.gnucash. That database 
may be in use by another user, in which case you should not open the database. 
What would you like to do?"

There are options to open read only, create a new file, open anyway, quit.

this is exactly what happened tbefore, but I opened anyway.

the lock file exists (lck file) but is 0 bites and is an hour old...

What is this lock file?  

I am going to copy the whole dir and then try to open read only, then resave.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/10/2017 10:22:24 AM, Frankie Raney  wrote:
Only backups was the ones within the first 20-15 min, nothing else during the 
4-5 hrs of work.  I have started over and as before, only one acct is off, my 
main checkingalmost $6000 off. What I will do is compare balances every 2-3 
months, untill I find a spot they do not agree, then delete the duplicate. This 
is the fastest way with a 1.2 Meg file. This time I will manually save every 10 
min...

Someone mentioned XML and SQLthese should already be installed since I use 
other databases?  Or will I have to install them for use with GC.


On Oct 10, 2017 7:01 AM, "Colin Law" mailto:clan...@gmail.com]> wrote:

Are there any of the backups there somename.gnucash.nnn?  The
number string is the date/time that it was taken. These will be mixed
up with the log files so you may not have noticed them.

Colin

On 10 October 2017 at 14:30, Frankie Raney mailto:frankraney...@gmail.com]> wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
>
> On Oct 10, 2017 2:50 AM, "Liz" mailto:ed...@billiau.net]> 
> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney mailto:frankraney...@gmail.com]> 
>> wrote:
>>
>> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
>> > awayI saved it after importing, and looked at it with file
>> > browserit was therethen I went back, run GC and started
>> > editing..when GC crashed, the file went to lala land. Only the
>> > log file was left.
>>
>> basic idea, but in case lala land is still on your hard drive, a search
>> for *.gnucash is worthwhile
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> [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 [mailto:gnucash-user@gnucash.org]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> [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.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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: importing

2017-10-11 Thread frank raney 
OK
So I redid the import and saved my self periodicallyeverything was going 
well.Untill I deleted an accoiut that was called TradingI did not have 
that accoiunt in quicken by that name.  It is my IRA...when I deleted that 
file, the program crashed again.  I had just saved before I tried to delete.  
(it also saved its own with date..

When I tried to open my file I got a message that the lock file could not be 
found...  I opened the backup created by GC but the main checking account is 
not the same.  The message was " GnuCash could not obtain the lock for 
file://C:\Users\Frankie\Documents\gnucash\mydata 2017.gnucash. That database 
may be in use by another user, in which case you should not open the database. 
What would you like to do?"

There are options to open read only, create a new file, open anyway, quit.

this is exactly what happened tbefore, but I opened anyway.

the lock file exists (lck file) but is 0 bites and is an hour old...

What is this lock file?  

I am going to copy the whole dir and then try to open read only, then resave.


Frankie Raney
12454 Auberry Rd.
Clovis, Ca.
559.297.8577 H
559.304.1751 C
On 10/10/2017 10:22:24 AM, Frankie Raney  wrote:
Only backups was the ones within the first 20-15 min, nothing else during the 
4-5 hrs of work.  I have started over and as before, only one acct is off, my 
main checkingalmost $6000 off. What I will do is compare balances every 2-3 
months, untill I find a spot they do not agree, then delete the duplicate. This 
is the fastest way with a 1.2 Meg file. This time I will manually save every 10 
min...

Someone mentioned XML and SQLthese should already be installed since I use 
other databases?  Or will I have to install them for use with GC.


On Oct 10, 2017 7:01 AM, "Colin Law" mailto:clan...@gmail.com]> wrote:

Are there any of the backups there somename.gnucash.nnn?  The
number string is the date/time that it was taken. These will be mixed
up with the log files so you may not have noticed them.

Colin

On 10 October 2017 at 14:30, Frankie Raney mailto:frankraney...@gmail.com]> wrote:
> Did a search, that's how I know it went to lala land.  Can't remember ever
> having this happen before.
>
> On Oct 10, 2017 2:50 AM, "Liz" mailto:ed...@billiau.net]> 
> wrote:
>
>> On Mon, 9 Oct 2017 20:39:34 -0700
>> Frankie Raney mailto:frankraney...@gmail.com]> 
>> wrote:
>>
>> > Yes, yes, and yes. It was, is the only filewhen it crashed it went
>> > awayI saved it after importing, and looked at it with file
>> > browserit was therethen I went back, run GC and started
>> > editing..when GC crashed, the file went to lala land. Only the
>> > log file was left.
>>
>> basic idea, but in case lala land is still on your hard drive, a search
>> for *.gnucash is worthwhile
>>
>> Liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org [mailto:gnucash-user@gnucash.org]
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>> [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 [mailto:gnucash-user@gnucash.org]
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
> [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.


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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.

Github projects related to gnucash

2017-10-11 Thread Sébastien de Menten 
Hello,

Just to let you know, I have updated the list of github projects with
gnucash in their description:
http://piecash.readthedocs.io/en/latest/doc/github_links.html

Python is the front runner language in terms of # projects followed at some
distance by perl and Java.

Kind regards,

Sébastien
___
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: Report - Items sold, quantity and value

2017-10-11 Thread Eduardo Estefano Neto 
Thank you Christopher.  What I'm looking for is the aggregrated items
report. Hope this is in the roadmap.

Eduardo

On Wed, Oct 11, 2017 at 3:21 AM Christopher Lam 
wrote:

> You can print a report of itemized sales in one invoice by running the
> Reports/Business/Tax Invoice report.
>
> I don't think there's a report which will aggregate items sold across
> several invoices.
>
> C
> On 10 Oct 2017 22:04, "Eduardo Estefano Neto" <
> eduardo.estefano.n...@gmail.com> wrote:
>
>> Hi there everyone. Does anyone know how to extract a list of items sold? I
>> would like to have a listing of items inside the invoices. Something like:
>>
>> Client | Invoice Nr | Item | Quantity | Value
>>
>> Thanks in advance
>>
>> Eduardo
>> --
>> Eduardo Estefano Neto
>> eduardo.estefano.n...@gmail.com
>> (11) 9.9481-3450
>> Linkedin: https://br.linkedin.com/pub/eduardo-estefano-neto/b/877/793
>>
> ___
>> 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.
>>
> --
Eduardo Estefano Neto
eduardo.estefano.n...@gmail.com
(11) 9.9481-3450
Linkedin: https://br.linkedin.com/pub/eduardo-estefano-neto/b/877/793
___
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.

Scheduled Transactions, Variables and Formulas

2017-10-11 Thread Cheryl Wheeler 
I am playing with variables and formulas in scheduled transactions. I 
created a test SX using the example shown here 
(https://wiki.gnucash.org/wiki/Scheduled_Transactions#Bank_Account_Interest). 
When I tried to save the SX, GnuCash gave me an error message saying 
that it couldn't parse the formula. After some experimentation, I found 
that the problem seems to be the use of the variable "i" when passed as 
a parameter to the function "computeInterestIncrement". If I change i to 
a numeral, then the formula parses; if I use i alone (no function call), 
it parses.


The example in the wiki is from 2005. Assuming that it once worked, have 
there been intentional changes such that it is no longer expected to 
work, or would this be a bug? I am using GnuCash 2.6.15 on Windows 7.


___
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: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-11 Thread Maf. King 
On Wednesday, 11 October 2017 14:35:51 BST Frankie Raney wrote:
> The cloud could be your own (hard drive or home cloud). I think you can
> install to a shareable drive(cloud) then create a short cut on each machine
> to it.  I think I have seen a way to share one of your desktops. I don't
> know for sure how to do it, but I do remember seeing an article on doing it.


Heh. I do keep my accounts files on a NFS share (indeed, lots of my ~ lives on 
my fileserver).  Never really thought of it as "the cloud".  That term has to 
me at least, always been the "cloud" shape in network diagrams at the other 
end of my connection to the internet - meaning the bit I know is there but 
isn't under my control.

However, discussing where the file(s) live doesn't really help with the OP's 
problem of needing to create several identical reports on several data files, 
which because the reports work on accountID not name, and the reports are not 
per-file but global is just plain cumbersome...

Amish - the only thing I think I can suggest at this point is that each 
company has it's own user login - at least that way the list of accounts is 
not cumbersome..  Or thinking about it, if on linux (may work on Win, probably 
not on Mac), you could create some shortcuts for each accounts file that sets 
up a custom environment  (i think you need to set GNC_DOT_DIR bit have a good 
google first) before launching GC so that each company has its own prefs file.  
probably more cumbersome than a really busy menu, and error-prone, though,,, 

Maf.

___
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: Question on mysql "account" table

2017-10-11 Thread John Ralls 


> On Oct 11, 2017, at 6:31 AM, Joseph Hesse  wrote:
> 
> Here is an example of what I am trying to do.  My expenses in gnucash have 
> items that look like:
> 
> Expenses
>   Auto
> Gas
> Service
> 
> When I look in the mysql accounts table I can find the record containing 
> Service but no easy way to find Expenses:Auto:Service. The record containing 
> Service in the accounts table has the item parent_guid so I could use that to 
> locate the parent classification of Service, which is Auto. I can repeat the 
> process until I get a complete description of the account.
> 
> My questions is: Is there sophisticated query where I can add a column to the 
> accounts table containing the full name instead of just the name?
> 
> I know I can do what I want in a programming language like PHP or C++ but I 
> want to know if there is something easier.
> 
> The reason for my questions is I am creating a custom expense report by 
> joining the accounts, splits and transactions table and I want the expense 
> name to have a full path description.
> 

Changing the database schema is not supported. You should also be aware that 
GnuCash sometimes needs to rewrite the database from scratch and when it does 
any schema changes you’ve made will be lost.

That said you could create an auxiliary table mapping the fully-qualified 
account names to their GUIDs (which is what you want for querying the splits 
table) and GnuCash will ignore it. You’d need to write a recursive tree walking 
query to do that. It might be possible in a single query but that’s way beyond 
my SQL-fu; I’d wrap the SQL in a scripting language—perl or python depending on 
my mood at the moment—to start off with a clean table, compute the tree, and 
populate it.

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: Question on mysql "account" table

2017-10-11 Thread Colin Law 
If you use joins on the guid values to the parents then you should be
able to get them directly using the appropriate queries.

Colin

On 11 October 2017 at 14:31, Joseph Hesse  wrote:
> Here is an example of what I am trying to do.  My expenses in gnucash have
> items that look like:
>
> Expenses
>   Auto
> Gas
> Service
>
> When I look in the mysql accounts table I can find the record containing
> Service but no easy way to find Expenses:Auto:Service. The record containing
> Service in the accounts table has the item parent_guid so I could use that
> to locate the parent classification of Service, which is Auto. I can repeat
> the process until I get a complete description of the account.
>
> My questions is: Is there sophisticated query where I can add a column to
> the accounts table containing the full name instead of just the name?
>
> I know I can do what I want in a programming language like PHP or C++ but I
> want to know if there is something easier.
>
> The reason for my questions is I am creating a custom expense report by
> joining the accounts, splits and transactions table and I want the expense
> name to have a full path description.
>
> Thank you,
> Joe
>
> ___
> 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.

Question on mysql "account" table

2017-10-11 Thread Joseph Hesse 
Here is an example of what I am trying to do.  My expenses in gnucash 
have items that look like:


Expenses
  Auto
    Gas
    Service

When I look in the mysql accounts table I can find the record containing 
Service but no easy way to find Expenses:Auto:Service. The record 
containing Service in the accounts table has the item parent_guid so I 
could use that to locate the parent classification of Service, which is 
Auto. I can repeat the process until I get a complete description of the 
account.


My questions is: Is there sophisticated query where I can add a column 
to the accounts table containing the full name instead of just the name?


I know I can do what I want in a programming language like PHP or C++ 
but I want to know if there is something easier.


The reason for my questions is I am creating a custom expense report by 
joining the accounts, splits and transactions table and I want the 
expense name to have a full path description.


Thank you,
Joe

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