Re: [GNC] Price Editor

2018-09-20 Thread David Carlson
Les, that seems very strange as the price editor should be displaying all
the prices that are currently in the data file.  Are you using the regular
XML data file format or a database format?

David C

On Thu, Sep 20, 2018 at 4:20 PM Les  wrote:

> I have noticed that beginning this week (09/1702018) the price database
> of my securities has been truncated and only the current week's prices
> are being displayed.
>
> Is this a bug?
>
> My system is unchanged (Linux Mint 18.2 and GC 2.6.17).
>
> Thanks,
>
> Les
> ___
> 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.


[GNC] Price Editor

2018-09-20 Thread Les
I have noticed that beginning this week (09/1702018) the price database 
of my securities has been truncated and only the current week's prices 
are being displayed.


Is this a bug?

My system is unchanged (Linux Mint 18.2 and GC 2.6.17).

Thanks,

Les
___
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] Another sort field like 'Class' in Quicken?

2018-09-20 Thread Alex Aycinena
>
>
> -- Forwarded message --
> From: Paul Kinzelman 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Mon, 17 Sep 2018 16:41:21 -0600
> Subject: Re: [GNC] Another sort field like 'Class' in Quicken?
> On 9/17/2018 8:16 AM, David T. wrote:
> > Paul,
> >
> > This is a recent addition to the program. Since the documentation is
> also developed by volunteers (who are not necessarily the same as the
> people who write the program itself) documentation often lags behind the
> features. We rely on users like you to provide descriptions of features and
> how they get used. If you have a suggestion for this description, we’d
> welcome it.
> I understand the issues with volunteer efforts. I did provide my
> understanding
> of what you told me, perhaps that could be put into the docs. Is it a wiki?
> Can I just go in there and do it?
> But more importantly, is my summary correct? :-)
> >
> > As an aside, I will note that it is my understanding that this setting
> is supposedly a one-time option—i.e., that once you select it, you
> shouldn’t change it back. But your comment sounds as if you have tried it
> both ways in your file without negative consequence. If the setting can be
> changed at a later time without problem, that would be important to know.
> Can you give further information on this?
> No - I just saw the box and was trying to understand what it was for.
> I haven't tried turning it on, I'm still just trying to understand what
> it does.
> And that happened in my search for a Class/Tag field so I don't think I
> even need to try to turn it on. It does look like the
> Action field can be used for what I want.
>
> So if my summary of what it does is correct, I'd update the wiki if it
> will allow
> me to do that.
> >
> > What exact version are you using, and on which operating system?
> The latest download 3.2 on Windoz 10.
> >
> > What is your file storage, SQL or XML? If XML, when you tried the
> different settings, did you save your file after each setting change?
> default everything - XML. Didn't try it so I can't answer that question.
> >
> > If you did save the file after changing the setting, did you in fact
> save the file with data in the affected fields?
> >
> > David T.
> >
> >
> >> On Sep 17, 2018, at 10:00 AM, Paul Kinzelman 
> wrote:
> >>
> >> Wow, I did not get that out of what I read at all.
> >> It'd be very useful for people I think if you updated the documentation
> >> to say that.
> >>
> >> So would a good summary be that if the box is unchecked, if you fill in
> >> the number field in a transaction, it automagically propagates
> >> to the other corresponding account register to keep them in sync.
> >>
> >> If the box is checked, you have to fill in the numbers in both places
> >> manually (if you don't, the other one will be blank),
> >> which allows them to be different.
> >>
> >> On 9/16/2018 10:59 PM, Adrien Monteleone wrote:
> >>> Think of the option as more like either you have numbers for
> transactions, or you have numbers for splits.
> >>>
> >>> With the option unset, a payment transaction for example will have the
> same number both in the asset/liability register used to make/accept the
> payment and in the AP/AR register.
> >>>
> >>> With the option set, you could have different numbers depending on
> which register you are viewing.
> >>>
> >>> This might be useful in some cases to keep paperwork in sync. Your
> internal paperwork might use one number for a transaction but the external
> entity might use a different one. The option allows you to record both AND
> see each number in its proper perspective and context in your books.
> >>>
> >>> Regards,
> >>> Adrien
> >>>
>  On Sep 16, 2018, at 10:07 PM, Paul Kinzelman 
> wrote:
> 
>  I read the docs and don't really understand the "Use split Action
> field for Number" purpose.
>  It sounds like the Action field is moved to the Num field, and the
> Num is hidden
>  someplace else? And it's inaccessible?
> 
>  Too bad the empty space can't be used for tag, that sounds like a
> great solution.
>  I'm surprised that it can't be.
> 
>  However, it sounds like I can use the "Action" field for the Tag, and
> I
>  understand that I have to be careful to make sure the spelling is
> correct.
>  As long as I don't collide with one of the already populated items,
> seems
>  like I should be OK.
> 
>  Thanks!
> 
>  On 9/16/2018 10:24 AM, John Ralls wrote:
> > But don’t confuse an empty space on the grid for a field. There’s no
> “tag” field, and adding one is complicated.
> >
> > There are already five free text fields in GnuCash, all searchable:
> Number, Description and Notes are part of transactions, Action and Memo are
> part of splits.  Action is a little weird in that it’s a combo
> pre-populated with some values associated with certain GnuCash features so
> using it as a class/tag/subcategory might require extra effort and might
> 

Re: [GNC] date range on budget report

2018-09-20 Thread Adrien Monteleone
Nice find!

I don’t think you can ditch the last ‘Actual’ from within GnuCash, that will 
have to be in a spreadsheet.

But the column may be useful if you enter future transactions. I know this 
sounds odd, but it can be helpful, especially with such a report, to show 
‘planned’ transactions that will chew up some or all of that future budgeted 
amount. It would then show (if you include the Diff column) how much is really 
remaining/discretionary.

I haven’t started using future transactions yet, but this version of the report 
has me thinking of doing so.

Regards,
Adrien

> On Sep 19, 2018, at 5:33 PM, Robert Kushler  wrote:
> 
> Updating did the trick.  I played with the date options and tried something 
> counter-intuitive that worked nicely and may be of interest to others:  I set 
> "start" to "Next" and "end" to "Current" (and also unchecked "Show Totals" on 
> the Display tab).  This produces a report with "budget vs actual to date" in 
> the first two columns, "rest of year budget" in the third, and "rest of year 
> actual" (all zeros, of course) in the fourth.  Now I guess I will try 
> customizing to remove the fourth column and tweak the column labels.
> 
> Thanks again for setting me on the path to success.
> 
> On Wed, Sep 19, 2018 at 5:33 PM Adrien Monteleone 
>  wrote:
> Rob,
> 
> The options for the budget report do allow you to choose which periods you 
> want to report for. (at least as of v3.2)
> 
> Look at the General tab starting with the Range checkbox.
> 
> You could say, run the report for July, August, September (Q3) add the Total 
> and Difference columns (from the Display tab) and get a QTD report.
> 
> If you included previous periods as a consolidated column, the first column 
> would be Q1 & Q2 combined, and your Totals would be YTD.
> 
> Note, if you include periods AFTER the range, such as Q4 in this example, 
> then the Totals for Budget & Difference are for the full budget period, but 
> Actual is necessarily YTD. (perhaps if you have future transactions already 
> entered, this might not be the case, I haven’t tested)
> 
> I don’t think you can get just the three totals columns by themselves YTD. 
> The best you could do is select the range as only the current period, select 
> to include prior periods consolidated, DO NOT include later periods, and 
> you’ll get a report with (as of today) Jan-Aug as a single column, followed 
> by September (current) followed by the three Total columns, which in this 
> case would be YTD.
> 
> If you needed to modify from there, simply export or copy/paste to a 
> spreadsheet.
> 
> Regards,
> Adrien
> 
> 
> > On Sep 19, 2018, at 3:30 PM, Robert Kushler  wrote:
> > 
> > I've created a budget by month, and want to produce a budget vs actual
> > report for "year to date" (accumulated).  The default report has each month
> > in a separate column and shows the whole year. The Options pop-up does not
> > include a way to modify the dates for the report.  I've looked at the file
> > "budget.scm", which seems to have code for date setting which is commented
> > out (but the useless "Price source" option, which *does* appear in the
> > pop-up, is not commented out).
> > 
> > What's the deal?  Thanks for any help/enlightenment you can provide.
> > 
> > Regards,   Rob Kushler
> > ___
> > 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] Auto Save Ledger

2018-09-20 Thread Michael or Penny Novack

On 9/20/2018 4:51 AM, Maf. King wrote:

Hi Lesley,

Save your account data file into a folder - don't work directly from the
desktop. (File menu -> Save As while GC is running is probably the best way to
do this)

GC creates its own backup files each time you save (if using the default &
recommended XML file format) and puts it in the same folder as the main data
file - hence if the data lives on the desktop, that is where GC will put the
backups.

HTH,

 Maybe making this a bit clearer (as to what is going on)

The "desktop" IS a folder. But it is a special folder whose contents are 
always being displayed on the main window as icons (you can ask OTHER 
folders to be displayed to you as icons within their windows).


What Maf. King is telling you is to use some OTHER folder for your 
gnucash file to reside in. The program will use that same folder as the 
place to put the log file and backup.


Michael.
___
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] Auto Save Ledger

2018-09-20 Thread Graham

On 19/09/2018 16:58, Lesley Douglass wrote:

Every time GnuCash auto saves, it automatically saves two new icons on my 
desktop. A GnuCash icon and a text document. Is there anyway to change the 
settings so this stops?
You can edit the number of saves that are stored to less than 1 day, but 
wouldn't it be better to save to a folder on your desktop instead? That 
way your workspace is uncluttered but you still have plenty of backup in 
case of stuff-ups.


Graham

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
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] Auto Save Ledger

2018-09-20 Thread Maf. King
Hi Lesley,

Save your account data file into a folder - don't work directly from the 
desktop. (File menu -> Save As while GC is running is probably the best way to 
do this)

GC creates its own backup files each time you save (if using the default & 
recommended XML file format) and puts it in the same folder as the main data 
file - hence if the data lives on the desktop, that is where GC will put the 
backups.

HTH,
Maf.



On Wednesday, 19 September 2018 16:58:07 BST Lesley Douglass wrote:
> Every time GnuCash auto saves, it automatically saves two new icons on my
> desktop. A GnuCash icon and a text document. Is there anyway to change the
> settings so this stops?
> 
> Disclaimer
> 
> The information contained in this communication from the sender is
> confidential. It is intended solely for use by the recipient and others
> authorized to receive it. If you are not the recipient, you are hereby
> notified that any disclosure, copying, distribution or taking action in
> relation of the contents of this information is strictly prohibited and may
> be unlawful.
> 
> This email has been scanned for viruses and malware, and may have been
> automatically archived by Mimecast Ltd, an innovator in Software as a
> Service (SaaS) for business. Providing a safer and more useful place for
> your human generated data. Specializing in; Security, archiving and
> compliance. To find out more visit the Mimecast website.
> ___
> 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.


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





___
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 required for debugging gnucash to find Segmentation fault error when saving from mysql to xml

2018-09-20 Thread Jeff Abrahamson
The first thing to try is surely just to run the program under gdb and
to let it crash.  When it crashes, ask for a backtrace (bt) to see where
you are.  You can move from stack frame to stack frame (f -- for
example, "f 3" to view frame 3).  You can request to see the values of
variables with the print command (p).  For example "p the_date" will
show you the value of variable "the_date".

I find it helpful to run gdb in emacs (M-x gdb).  The reason is that it
allows me to see source code automatically rather than having to request
gdb to list bits of source code at the commandline.

Note that I don't have experience debugging gnucash but I have plenty
with gdb.

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.com/


On 19/09/18 23:19, Uli Hansen wrote:
> Dear All,
>
> please be aware that I run gdb the first time in my life to find this
> problem.
>
> When saving from mysql to xml I get a segmentation fault error:
>
> Thread 1 "gnucash" received signal SIGSEGV, Segmentation fault.
> g_date_time_add (datetime=0x0, timespan=0) at
> /build/glib2.0-7ZsPUq/glib2.0-2.48.2/./glib/gdatetime.c:1074
> 1074    /build/glib2.0-7ZsPUq/glib2.0-2.48.2/./glib/gdatetime.c: No
> such file or directory
>
> I already comiled the sources from 2.6.12 to dive into this problem.
>
>
> I assume that the cause of my error is an empty date field somewhere
> in my database.
>
> In order to find the proper table and the id, I want to debug with gdb.
>
> But honestly it's quiet complicated and I'm not familiar with gdb.
>
> Can somebody give me a hint where to set a breakpoint. Which function
> is called to convert from mysql to xml?
>
> Which file/function could be a good startpoint for me?
>
> Many thanks in advance.
>
> Uli
>
>
> ___
> 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.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/
http://transport-nantes.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.

[GNC] Help required for debugging gnucash to find Segmentation fault error when saving from mysql to xml

2018-09-20 Thread Uli Hansen

Dear All,

please be aware that I run gdb the first time in my life to find this 
problem.


When saving from mysql to xml I get a segmentation fault error:

Thread 1 "gnucash" received signal SIGSEGV, Segmentation fault.
g_date_time_add (datetime=0x0, timespan=0) at 
/build/glib2.0-7ZsPUq/glib2.0-2.48.2/./glib/gdatetime.c:1074
1074    /build/glib2.0-7ZsPUq/glib2.0-2.48.2/./glib/gdatetime.c: No such 
file or directory


I already comiled the sources from 2.6.12 to dive into this problem.


I assume that the cause of my error is an empty date field somewhere in 
my database.


In order to find the proper table and the id, I want to debug with gdb.

But honestly it's quiet complicated and I'm not familiar with gdb.

Can somebody give me a hint where to set a breakpoint. Which function is 
called to convert from mysql to xml?


Which file/function could be a good startpoint for me?

Many thanks in advance.

Uli


___
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] Auto Save Ledger

2018-09-20 Thread Lesley Douglass
Every time GnuCash auto saves, it automatically saves two new icons on my 
desktop. A GnuCash icon and a text document. Is there anyway to change the 
settings so this stops?

Disclaimer

The information contained in this communication from the sender is 
confidential. It is intended solely for use by the recipient and others 
authorized to receive it. If you are not the recipient, you are hereby notified 
that any disclosure, copying, distribution or taking action in relation of the 
contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been 
automatically archived by Mimecast Ltd, an innovator in Software as a Service 
(SaaS) for business. Providing a safer and more useful place for your human 
generated data. Specializing in; Security, archiving and compliance. To find 
out more visit the Mimecast website.
___
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.