Re: Future allocated money, aka Envelope Budgeting

2018-02-06 Thread Wm

On 06/02/2018 12:10, cicko wrote:

GnuCash - Dev mailing list wrote

for e.g. I am, at the moment, in the process of doing my multiple view
portfolio analysis starting from

https://www.ledger-cli.org/3.0/doc/ledger3.html#Asset-Allocation

which is more or less what envelope budgeting is plus a bit.

see

https://www.ledger-cli.org/3.0/doc/ledger3.html#Working-with-multiple-funds-and-accounts


Thanks a lot for these links! I was not aware that ledger had asset
allocation.
This might save some effort in writing gnucash portfolio extensions
(https://github.com/MisterY/gnucash-portfolio). Perhaps I could even
interface to ledger-cli or another ledger client from Python.

A quick question, though - what do you guys use to have an up-to-date
records in ledger? How do you use (or export) GnuCash book into text files
appropriate for ledger?


if you are already using python piecash is a good place to start

===
https://piecash.readthedocs.io/en/latest/news.html
===

I know he used to have a ledger-cli export but I can't find it right 
now, probably my fault for looking too quickly.


I don't actually export all of my gnc to ledger for asset allocation, I 
just create tx like this


===
2018-02-03  Buy Fund1   
  Assets:Broker  100 "Fund1" @ 100.00 
  Assets:Cash

2018-02-03  Buy Bond2   
  Assets:Broker  999 "Bond2" @ 50.00
  Assets:Cash
===
using the investment portfolio report as my source.

If I was doing asset allocation monthly or weekly I'd automate it a bit 
more using piecash or some handwritten sql



Now I'm thinking how good it would be to have a translation layer that
provides the data from a GnuCash sqlite database to ledger.


piecash should save you a step

P.S. I've just noticed MisterY already knows about piecash, silly me :)

--
Wm

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: GnuCash 2.7.4 Released

2018-02-06 Thread John Ralls


> On Feb 6, 2018, at 2:37 PM, Klaus Dahlke  wrote:
> 
> Hi John,
> I tied to complie gnucash 2.7.4 on Arch Linux with cmake without success. For 
> comparison I cloned the git repository, installed and could compile 
> successfully via autogen.sh, configure and make
> 
> The error when using cmake is:
> [mb40 gnucash_build]# cmake ../gnucash
> -- The C compiler identification is GNU 7.3.0
> -- The CXX compiler identification is GNU 7.3.0
> -- Check for working C compiler: /usr/bin/cc
> -- Check for working C compiler: /usr/bin/cc -- works
> -- Detecting C compiler ABI info
> -- Detecting C compiler ABI info - done
> -- Detecting C compile features
> -- Detecting C compile features - done
> -- Check for working CXX compiler: /usr/bin/c++
> -- Check for working CXX compiler: /usr/bin/c++ -- works
> -- Detecting CXX compiler ABI info
> -- Detecting CXX compiler ABI info - done
> -- Detecting CXX compile features
> -- Detecting CXX compile features - done
> -- Performing Test have_mod_mask
> -- Performing Test have_mod_mask - Failed
> CMake Error at gnome/gschemas/CMakeLists.txt:16 (add_gschema_targets):
>  Unknown CMake command "add_gschema_targets".
> 
> 
> CMake Warning (dev) in CMakeLists.txt:
>  No cmake_minimum_required command is present.  A line of code such as
> 
>cmake_minimum_required(VERSION 3.10)
> 
>  should be added at the top of the file.  The version specified may be lower
>  if you wish to support older CMake versions for this project.  For more
>  information run "cmake --help-policy CMP".
> This warning is for project developers.  Use -Wno-dev to suppress it.
> 
> -- Configuring incomplete, errors occurred!
> See also "/mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeOutput.log".
> See also "/mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeError.log".
> 
> 
> 
> CMakeError.log:
> Performing C SOURCE FILE Test have_mod_mask failed with the following output:
> Change Dir: /mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeTmp
> 
> Run Build Command:"/usr/bin/make" "cmTC_29946/fast"
> /usr/bin/make -f CMakeFiles/cmTC_29946.dir/build.make 
> CMakeFiles/cmTC_29946.dir/build
> make[1]: Entering directory 
> '/mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeTmp'
> Building C object CMakeFiles/cmTC_29946.dir/src.c.o
> /usr/bin/cc   -Dhave_mod_mask   -o CMakeFiles/cmTC_29946.dir/src.c.o   -c 
> /mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeTmp/src.c
> /mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeTmp/src.c:2:10: fatal 
> error: gdk/gdk.h: No such file or directory
> #include 
>  ^~~
> compilation terminated.
> make[1]: *** [CMakeFiles/cmTC_29946.dir/build.make:66: 
> CMakeFiles/cmTC_29946.dir/src.c.o] Error 1
> make[1]: Leaving directory 
> '/mnt/rd/gnucash-2.7.4/gnucash_build/CMakeFiles/CMakeTmp'
> make: *** [Makefile:126: cmTC_29946/fast] Error 2
> 
> Source file was:
> 
> #include 
> 
> int main (int argc, char** argv) {
>  GdkModifierIntent foo = GDK_MODIFIER_INTENT_DEFAULT_MOD_MASK;
>  return 0;
> }
> 
> 
> Also setting defininf CMAKE_PREFIX_PATH doesn't help:
> echo $CMAKE_PREFIX_PATH
> /usr/include/gtk-3.0
> 
> 
> Any ideas?


Please remember to copy the list on all replies. "Reply All" works well.

You're not starting at the top level CMakeFile. Tell it "cmake .." instead of 
"cmake ../gnucash".

Regards,
John Ralls

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Bug in "Liabilities Barchart" report (since 2.6.19)

2018-02-06 Thread Di Mang
Hello Christopher,

I found the bug out. It was caused by commit "766e74096+"

Titel: "bugfix incorrect min-date handling".
Description: "This bugfix affects net-linechart and net-barchart - assumes
the min-date for dates must be 0. Net worth charts straddling the date
01-01-1970 were incorrect. I'll fix in time64-ftw as well."
"
 src/report/report-system/report-collectors.scm

index ad3ae5369..b4415e5d8 100644
@@ -155,7 +155,7 @@
 (list min-date max-date datepairs)))

 (define (category-report-dates-accumulate dates)
-  (let* ((min-date (gnc:secs->timepair 0))
+  (let* ((min-date (decdate (car (list-min-max dates gnc:timepair-lt))
DayDelta))
"

As a simple solution, we can undo this change. But I do not know, if this
affects other parts of the code.
Could you please check, how it can be repair? Thanks a lot!

Do I still need to add this bug to Bugzilla?

DiMang




2018-02-06 16:41 GMT+01:00 Di Mang :

> Hello Christopher,
>
> Thank you for checking! I will add this bug to Bugzilla.
>
> DiMang
>
> 2018-02-05 23:29 GMT+01:00 Christopher Lam :
>
>> Hi Di Mang I agree bug exists - would you be able to file bug report?
>>
>> We'd need to investigate category-barchart.scm
>>
>>
>>
>> On 06/02/18 05:24, Di Mang wrote:
>>
>>> Hello all,
>>>
>>> I have investigated this problem further in the last few days.
>>> I think, it doesn't depend on some special version of GnuCash.
>>>
>>> For example, all works fine, if I use pre-build versions of GnuCash.
>>> I tested it with:
>>> * GnuCash (2.6.17, 2.6.19) on Windows 7 (from GnuCash-website)
>>> * and GnuCash 2.6.17 on Ubuntu 17.10 (from Ubuntu Software Center).
>>>
>>> But, it does not work right (see screenshots in my first mail),
>>> if I build GnuCash from souce files myself (2.6.19 or unstable, on Ubuntu
>>> 17.10, with cmake).
>>>
>>> I attached the output files for "cmake" and "make" commands.
>>> Can it be, that I am using a wrong version of some library?
>>>
>>> 2018-01-28 16:50 GMT+01:00 Frank H. Ellenberger <
>>> frank.h.ellenber...@gmail.com>:
>>>
>>> Hi,

 Am 28.01.2018 um 15:48 schrieb Di Mang:

> Hello,
>
> I have a problem with the "Liabilities Chart", "Asset Chart" and "Net
>
 Worth

> Barchart" reports since I switched to GnuCash 2.6.19 (on Ubuntu
> 17.10). I
> have this problem with unstable 2.7.3 too (built from source). With
>
 GnuCash

> 2.6.17 the reports worked as expected.
>
> These reports display the accumulated amounts, but only based on the
> transactions from the selected period. The transactions before the
> start
> time are ignored. See example in the appendix (as image and GnuCash
>
 file).

> ​I tried to find the error. Unfortunately, I do not know where to
> start.​
> Can someone please look at it. With the example from the attachment it
> should be easy. Thanks in advance!
>
> ​DM​
>
 Did you accitently change Preferences->Accounts->Reverse Balance
 Accounts?

 Frank





 ___
 gnucash-devel mailing list
 gnucash-devel@gnucash.org
 https://lists.gnucash.org/mailman/listinfo/gnucash-devel

>>>
>> ___
>> gnucash-devel mailing list
>> gnucash-devel@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
>
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Bug in "Liabilities Barchart" report (since 2.6.19)

2018-02-06 Thread Di Mang
Hello Christopher,

Thank you for checking! I will add this bug to Bugzilla.

DiMang

2018-02-05 23:29 GMT+01:00 Christopher Lam :

> Hi Di Mang I agree bug exists - would you be able to file bug report?
>
> We'd need to investigate category-barchart.scm
>
>
>
> On 06/02/18 05:24, Di Mang wrote:
>
>> Hello all,
>>
>> I have investigated this problem further in the last few days.
>> I think, it doesn't depend on some special version of GnuCash.
>>
>> For example, all works fine, if I use pre-build versions of GnuCash.
>> I tested it with:
>> * GnuCash (2.6.17, 2.6.19) on Windows 7 (from GnuCash-website)
>> * and GnuCash 2.6.17 on Ubuntu 17.10 (from Ubuntu Software Center).
>>
>> But, it does not work right (see screenshots in my first mail),
>> if I build GnuCash from souce files myself (2.6.19 or unstable, on Ubuntu
>> 17.10, with cmake).
>>
>> I attached the output files for "cmake" and "make" commands.
>> Can it be, that I am using a wrong version of some library?
>>
>> 2018-01-28 16:50 GMT+01:00 Frank H. Ellenberger <
>> frank.h.ellenber...@gmail.com>:
>>
>> Hi,
>>>
>>> Am 28.01.2018 um 15:48 schrieb Di Mang:
>>>
 Hello,

 I have a problem with the "Liabilities Chart", "Asset Chart" and "Net

>>> Worth
>>>
 Barchart" reports since I switched to GnuCash 2.6.19 (on Ubuntu 17.10).
 I
 have this problem with unstable 2.7.3 too (built from source). With

>>> GnuCash
>>>
 2.6.17 the reports worked as expected.

 These reports display the accumulated amounts, but only based on the
 transactions from the selected period. The transactions before the start
 time are ignored. See example in the appendix (as image and GnuCash

>>> file).
>>>
 ​I tried to find the error. Unfortunately, I do not know where to
 start.​
 Can someone please look at it. With the example from the attachment it
 should be easy. Thanks in advance!

 ​DM​

>>> Did you accitently change Preferences->Accounts->Reverse Balance
>>> Accounts?
>>>
>>> Frank
>>>
>>>
>>>
>>>
>>>
>>> ___
>>> gnucash-devel mailing list
>>> gnucash-devel@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>>
>>
> ___
> gnucash-devel mailing list
> gnucash-devel@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Future allocated money, aka Envelope Budgeting

2018-02-06 Thread cicko
cicko wrote
> A quick question, though - what do you guys use to have an up-to-date
> records in ledger? How do you use (or export) GnuCash book into text files
> appropriate for ledger?

Looks good so far. At
https://www.ledger-cli.org/3.0/doc/ledger3.html#Major-Changes-from-version-2_002e6,
a feature "GnuCash file import" is listed. I guess this implies the XML
file?
Hopefully, with a bit more searching, it turns out that there is also an
sqlite adapter. :)

It is also great that there is the Python interface
(https://www.ledger-cli.org/3.0/doc/ledger3.html#Extending-with-Python).
Hopefully my work on portfolio project will turn to be more of a process of
discovery of what ledger does. :) And then adapting it and presenting in a
way I'd like to have.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel


Re: Future allocated money, aka Envelope Budgeting

2018-02-06 Thread cicko
GnuCash - Dev mailing list wrote
> for e.g. I am, at the moment, in the process of doing my multiple view 
> portfolio analysis starting from
> 
> https://www.ledger-cli.org/3.0/doc/ledger3.html#Asset-Allocation
> 
> which is more or less what envelope budgeting is plus a bit.
> 
> see
> 
> https://www.ledger-cli.org/3.0/doc/ledger3.html#Working-with-multiple-funds-and-accounts

Thanks a lot for these links! I was not aware that ledger had asset
allocation.
This might save some effort in writing gnucash portfolio extensions
(https://github.com/MisterY/gnucash-portfolio). Perhaps I could even
interface to ledger-cli or another ledger client from Python.

A quick question, though - what do you guys use to have an up-to-date
records in ledger? How do you use (or export) GnuCash book into text files
appropriate for ledger?

Now I'm thinking how good it would be to have a translation layer that
provides the data from a GnuCash sqlite database to ledger.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel