Re: New Report ideas

[Cindy Doughty]

I like it!

On Jun 29, 2017 8:15 PM, "Christopher Lam" 
wrote:

> Hi Doug
>
> I'd be keen to hack scheme to modify the source "Accounts" tree which is
> common to several report types.
>
> Right now you select your originating accounts, and when you 'save' the
> report options, the account guid are hardcoded into the options. This
> causes issues if we modify the chart of accounts. Wouldn't it be nice to
> choose any of the following account ie name/description/notes:
> 1. "Income:Chris:"
> 2. "Expenses:Business:"
> 3. ":Travel" which captures splits from both Expenses:Business:Travel and
> Expenses:Holiday:Travel
> 4. "^1" my favorite, will capture splits from accounts such as
> Expenses:Business^1:etc and Expenses:Household:Electric^1, perfect for the
> accountant. The wife gets to use ^2 :)
>
> Next step could be to search account types (eg INCOME only)
>
> Mockup attached
>
> [image: Inline images 1]
>
>
___
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: Any interest any new report

[Steve Isenberg via gnucash-user]

I would be interested in a report such as this:
Expenses? ? ? ? ? ? trip#1? ? ? trip#2? ? ? ? trip#3
lodging
transportation
food
entertainment
Thanks



On Thursday, June 29, 2017, 8:17:57 PM EDT,  
wrote:

Send gnucash-user mailing list submissions to
    gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
    gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
    gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of gnucash-user digest..."


Today's Topics:

  1. Re: Any interest any new report (Dorel Ciornei)
  2. Re: Any interest any new report (Adrien Monteleone)
  3. Re: Any interest any new report (Cindy Doughty)
  4. Re: Any interest any new report (Cindy Doughty)
  5. Where to save saved data (John and Diane)
  6. New Report ideas (Christopher Lam)


--

Message: 1
Date: Thu, 29 Jun 2017 16:27:08 + (UTC)
From: Dorel Ciornei 
To: Cindy Doughty ,  gnucash-user
    
Subject: Re: Any interest any new report
Message-ID: <772622715.1467252.1498753628...@mail.yahoo.com>
Content-Type: text/plain; charset=UTF-8

Hi Doug,I could really use such a report as long as it is flexible enough to 
select any accounts on the left side (for rows).Where would the columns labels 
come from? Will they be also any accounts or will they be names used in the 
Description field?Thank youDorel

On Thursday, June 29, 2017, 8:04:58 AM CDT, Cindy Doughty  
wrote:

I am thinking of creating a new report based on the comparison-transaction
report I created.? The new report would allow you to control what is shown
in each column for example:

Expenses? ? ? ? ? ? Me? mate? ? ? Kid#1? ? ? ? Kid#2
Food
clothing
Hobbies


or you could report

Expenses? ? ? ? ? ? trip#1? ? ? trip#2? ? ? ? trip#3
lodging
transportation
food
entertainment

or you could have

Expenses? ? ? Apt#1? ? ? ? Apt#2? ? ? ? ? Apt#3

The report would work by allowing you to find specific entries for each
column such as an account name? or an entry in the notes or memo fields
such as #mate or ##holiday ##london
Are there 5 or 6 people that could make use of such a report and would 5
columns be enough columns?

If there is not a strong interest I'll just make a rough version for myself.


Doug Doughty*
___
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.

New Report ideas

[Christopher Lam]

Hi Doug

I'd be keen to hack scheme to modify the source "Accounts" tree which is
common to several report types.

Right now you select your originating accounts, and when you 'save' the
report options, the account guid are hardcoded into the options. This
causes issues if we modify the chart of accounts. Wouldn't it be nice to
choose any of the following account ie name/description/notes:
1. "Income:Chris:"
2. "Expenses:Business:"
3. ":Travel" which captures splits from both Expenses:Business:Travel and
Expenses:Holiday:Travel
4. "^1" my favorite, will capture splits from accounts such as
Expenses:Business^1:etc and Expenses:Household:Electric^1, perfect for the
accountant. The wife gets to use ^2 :)

Next step could be to search account types (eg INCOME only)

Mockup attached

[image: Inline images 1]
___
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.

Where to save saved data

[John and Diane]

Hi
New to gnucash.
Notice there are many saved data files on desktop after each use of 
Gnucash. If I put them in a folder named 'Bookkeeping", the next time I 
try to use gnucash, I get a message the program can't find the data on 
the desktop. How do I know what files to leave on the desktop and which 
ones I can put in a folder and which folder? My desktop is covered in 
the backups at this moment.
What is the correct way to save all these many, many files so the 
program can find the data?
I only use this for keeping the checkbook and credit card ledgers and 
reconciling them. Not a business.

Thank you,
Diane
___
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: Any interest any new report

[Cindy Doughty]

Sorry,
I misread your question. Each of the column headings will be user input, on
the same tab as the find entries.  Also, planning on having a check box so
you can select if the column should be included this time or not.

On Thu, Jun 29, 2017 at 12:27 PM, Dorel Ciornei 
wrote:

> Hi Doug,
> I could really use such a report as long as it is flexible enough to
> select any accounts on the left side (for rows).
> Where would the columns labels come from? Will they be also any accounts
> or will they be names used in the Description field?
> Thank you
> Dorel
>
> --
> On Thursday, June 29, 2017, 8:04:58 AM CDT, Cindy Doughty <
> dbdoug...@gmail.com> wrote:
>
>
> I am thinking of creating a new report based on the comparison-transaction
> report I created.  The new report would allow you to control what is shown
> in each column for example:
>
> ExpensesMe  mate  Kid#1Kid#2
> Food
> clothing
> Hobbies
>
>
> or you could report
>
> Expensestrip#1  trip#2trip#3
> lodging
> transportation
> food
> entertainment
>
> or you could have
>
> Expenses  Apt#1Apt#2  Apt#3
>
> The report would work by allowing you to find specific entries for each
> column such as an account name  or an entry in the notes or memo fields
> such as #mate or ##holiday ##london
> Are there 5 or 6 people that could make use of such a report and would 5
> columns be enough columns?
>
> If there is not a strong interest I'll just make a rough version for
> myself.
>
>
> Doug Doughty
> ___
> 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: Any interest any new report

[Cindy Doughty]

 You will be able to select which accounts will be shown on the left side.
I am planning on using a set of find command for each of the columns.
 You will be able to find an account name or find a string of characters in
a description, memo or note, which ever you choose,  along the lines of

*Column 2:*
*Heading:  **London trip*
[image: Inline image 2]







Doug Doughty

On Thu, Jun 29, 2017 at 12:27 PM, Dorel Ciornei 
wrote:

> Hi Doug,
> I could really use such a report as long as it is flexible enough to
> select any accounts on the left side (for rows).
> Where would the columns labels come from? Will they be also any accounts
> or will they be names used in the Description field?
> Thank you
> Dorel
>
> --
> On Thursday, June 29, 2017, 8:04:58 AM CDT, Cindy Doughty <
> dbdoug...@gmail.com> wrote:
>
>
> I am thinking of creating a new report based on the comparison-transaction
> report I created.  The new report would allow you to control what is shown
> in each column for example:
>
> ExpensesMe  mate  Kid#1Kid#2
> Food
> clothing
> Hobbies
>
>
> or you could report
>
> Expensestrip#1  trip#2trip#3
> lodging
> transportation
> food
> entertainment
>
> or you could have
>
> Expenses  Apt#1Apt#2  Apt#3
>
> The report would work by allowing you to find specific entries for each
> column such as an account name  or an entry in the notes or memo fields
> such as #mate or ##holiday ##london
> Are there 5 or 6 people that could make use of such a report and would 5
> columns be enough columns?
>
> If there is not a strong interest I'll just make a rough version for
> myself.
>
>
> Doug Doughty
> ___
> 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: Any interest any new report

[Adrien Monteleone]

I’ve seen several threads and bugs requesting class functionality to enable 
reports for example 2 & 3. I’m sure there will be other examples. Certainly I 
would appreciate this ability. Since the jobs feature only applies to a 
customer OR a vendor and can’t involve regular transactions, a report like what 
you propose would be very, very useful.

I’ll be happy to test it.


Regards,
Adrien

> On Jun 29, 2017, at 8:03 AM, Cindy Doughty  wrote:
> 
> I am thinking of creating a new report based on the comparison-transaction
> report I created.  The new report would allow you to control what is shown
> in each column for example:
> 
> ExpensesMe   mate   Kid#1Kid#2
> Food
> clothing
> Hobbies
> 
> 
> or you could report
> 
> Expensestrip#1  trip#2trip#3
> lodging
> transportation
> food
> entertainment
> 
> or you could have
> 
> Expenses  Apt#1 Apt#2  Apt#3
> 
> The report would work by allowing you to find specific entries for each
> column such as an account name  or an entry in the notes or memo fields
> such as #mate or ##holiday ##london
> Are there 5 or 6 people that could make use of such a report and would 5
> columns be enough columns?
> 
> If there is not a strong interest I'll just make a rough version for myself.
> 
> 
> Doug Doughty
> ___
> 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: Any interest any new report

[Dorel Ciornei via gnucash-user]

Hi Doug,I could really use such a report as long as it is flexible enough to 
select any accounts on the left side (for rows).Where would the columns labels 
come from? Will they be also any accounts or will they be names used in the 
Description field?Thank youDorel

On Thursday, June 29, 2017, 8:04:58 AM CDT, Cindy Doughty  
wrote:

I am thinking of creating a new report based on the comparison-transaction
report I created.  The new report would allow you to control what is shown
in each column for example:

Expenses            Me  mate      Kid#1        Kid#2
Food
clothing
Hobbies


or you could report

Expenses            trip#1      trip#2        trip#3
lodging
transportation
food
entertainment

or you could have

Expenses      Apt#1        Apt#2          Apt#3

The report would work by allowing you to find specific entries for each
column such as an account name  or an entry in the notes or memo fields
such as #mate or ##holiday ##london
Are there 5 or 6 people that could make use of such a report and would 5
columns be enough columns?

If there is not a strong interest I'll just make a rough version for myself.


Doug Doughty
___
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: File signatures??

[Mike or Penny Novack]

On 6/28/2017 9:40 AM, m...@considine.net wrote:

Hi,

I think this is the right venue to ask this question.  If not, I can 
hopefully get a pointer to where else to turn.


I need to figure out what - if any - file signatures could be used to 
identify gnucash data files.  The need arises from a harddisk crash 
and recovery effort,


Horses and barn doors. And I am sure you will be better prepared next 
time. But others on the list should take note. And proper backup 
procedures are not just for gnucash:


a) Do not keep backups on the same device. Some day a disk may crash.
b) Ideally do not keep backups (not all of them) in the same location. 
You might make two copies, one to keep handy (for a data restore of a 
messed up file) and one stored off site for a more serious disaster. I 
learned THAT lesson in 2006 when a house fire (just one room actually 
burned) destroyed most of the backups kept in another room nearby (heat, 
smoke, and water)


What I personally do is have a couple of large external drives. These 
days a terabyte drive is only about $100. Sure slow going copying all 
the user data but you don't have to sit there while the computer chugs 
away making a copy of the data directory << you only need to do 
"systems" when you install software --- if instead of immediately 
updating every time you are notified of a new version but instead wait 
till you have several and do them at one time as a "build" you can space 
out THOSE backups >>


Michael D Novack
___
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: File signatures??

[Maf. King]

Hi Matt.

What do you mean by category structure?  If you're talking about the Chart of 
Accounts (ie the "tree"), that is stored in the data file.  Recover it (or one 
of the auto-backup copied in the same directory) and I'd expect all to be 
well.

Custom reports are in ~/.gnucash/saved-reports-2.4 - this head extract from 
mine suggests that a sequence of semicolons might be a good search string?  or 
"gnc:report" etc.


maf@janus:~/.gnucash> head saved-reports-2.4
;;;
;; Options for saved report "VAT Box 1 - Last Qtr", based on template 
"2fe3b9833af044abb929a88d5a59620f"
(let ()
 (define (options-gen)
  (let ((options (gnc:report-template-new-options/report-guid 
"2fe3b9833af044abb929a88d5a59620f" "Transaction Report")))

; Section: General

(let ((option (gnc:lookup-option options



Maf.


On Thursday, 29 June 2017 11:38:28 BST MattC wrote:
> Thank you.  That is exactly what I'm looking for.  Fwiw, it appears that
> searching for "trans_guild" identifies log files/fragments.  So I'm hoping
> that piecing those together migjt be a successful "plan b".   I think that
> leaves the category structure to try to figure out, as well as - though
> less importantly - customized reports.
> 
> I'll report back how it goes, but if anyone has suggestions for other files
> to search for, I'd appreciate the input.
> 
> Matt
> 
> 
> Sent from my Verizon Wireless 4G LTE smartphone
> 
>  Original message From: "Maf. King"
>  Date:06/29/2017  4:31 AM  (GMT-05:00)
> To: gnucash-user@gnucash.org Cc: m...@considine.net
> Subject: Re: File signatures?? 
> On Wednesday, 28 June 2017 14:40:09 BST m...@considine.net wrote:
> > Hi,
> > 
> > I think this is the right venue to ask this question.  If not, I can
> > hopefully get a pointer to where else to turn.
> > 
> > I need to figure out what - if any - file signatures could be used to
> > identify gnucash data files.  The need arises from a harddisk crash and
> > recovery effort, the result of which was a *lot* of files and file
> > fragments recovered, but at the expense of the harddisk's directory
> > structure and filenames (for the most part).  The harddisk in question
> > has terabytes of data on it, so going through the disk manually is not
> > practical.
> > 
> > On this disk were the data files for a non-profit which had a somewhat
> > customized account tree structure.  What I am trying to figure out is if
> > there are any unique headers to a minimum number of files that could be
> > used to recreate the transactions and other data in gnucash?  If there
> > are keywords or byte strings I can use, then I can use disk search tools
> > for look for the files and fragments that are relevant and try to stitch
> > things back together.
> > 
> > FWIW, I believe the account data was stored as XML rather than in a
> > database.  And the version of gnucash I was using was whatever version
> > was stable at the beginning of this calendar year.
> > 
> > Thanks in advance for any help or pointers.
> > 
> > Matt
> > 
> > PS I already understand the wisdom of having some backup elsewhere, so I
> > can forgo that pointer.  The problem in this case was that this unit was
> > also the backup.
> 
> Hi Matt
> 
> from my system:
> 
> ~> head myfile.gnucash
> 
>   xmlns:gnc="http://www.gnucash.org/XML/gnc;
>  xmlns:act="http://www.gnucash.org/XML/act;
>  xmlns:book="http://www.gnucash.org/XML/book;
>  xmlns:cd="http://www.gnucash.org/XML/cd;
>  xmlns:cmdty="http://www.gnucash.org/XML/cmdty;
>  xmlns:price="http://www.gnucash.org/XML/price;
>  xmlns:slot="http://www.gnucash.org/XML/slot;
>  xmlns:split="http://www.gnucash.org/XML/split;
> 
> Now, this is an uncompressed gc file from v 2.6.16, but dating back years; a
> file created this year has exactly the same first few lines though.
> 
> If your file was saved with compression turned on, then your task is
> probably harder - look for gz compressed files.
> 
> HTH,
> Maf.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542



___
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: File signatures??

[Maf. King]

On Wednesday, 28 June 2017 14:40:09 BST m...@considine.net wrote:
> Hi,
> 
> I think this is the right venue to ask this question.  If not, I can
> hopefully get a pointer to where else to turn.
> 
> I need to figure out what - if any - file signatures could be used to
> identify gnucash data files.  The need arises from a harddisk crash and
> recovery effort, the result of which was a *lot* of files and file
> fragments recovered, but at the expense of the harddisk's directory
> structure and filenames (for the most part).  The harddisk in question
> has terabytes of data on it, so going through the disk manually is not
> practical.
> 
> On this disk were the data files for a non-profit which had a somewhat
> customized account tree structure.  What I am trying to figure out is if
> there are any unique headers to a minimum number of files that could be
> used to recreate the transactions and other data in gnucash?  If there
> are keywords or byte strings I can use, then I can use disk search tools
> for look for the files and fragments that are relevant and try to stitch
> things back together.
> 
> FWIW, I believe the account data was stored as XML rather than in a
> database.  And the version of gnucash I was using was whatever version
> was stable at the beginning of this calendar year.
> 
> Thanks in advance for any help or pointers.
> 
> Matt
> 
> PS I already understand the wisdom of having some backup elsewhere, so I
> can forgo that pointer.  The problem in this case was that this unit was
> also the backup.
> 

Hi Matt

from my system:

~> head myfile.gnucash

http://www.gnucash.org/XML/gnc;
 xmlns:act="http://www.gnucash.org/XML/act;
 xmlns:book="http://www.gnucash.org/XML/book;
 xmlns:cd="http://www.gnucash.org/XML/cd;
 xmlns:cmdty="http://www.gnucash.org/XML/cmdty;
 xmlns:price="http://www.gnucash.org/XML/price;
 xmlns:slot="http://www.gnucash.org/XML/slot;
 xmlns:split="http://www.gnucash.org/XML/split;

Now, this is an uncompressed gc file from v 2.6.16, but dating back years; a 
file created this year has exactly the same first few lines though.

If your file was saved with compression turned on, then your task is probably 
harder - look for gz compressed files.

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