Re: [GNC-dev] Single User Installation location on Linux

[Colin Law]

On Fri, 6 Mar 2020 at 09:50, Geert Janssens  wrote:
> ...
> So we have identified at least one installation method that indeed does 
> follow the systemd spec. I wonder whether npm (for nodeJS), guix (for guile), 
> cpan (for perl) and so on have similar user local installation options that 
> use $HOME/.local.

Not npm, assuming you mean when you use it to install modules.  It
installs into a folder node_modules in the folder from which it is
run.  So an npm local install is local to the current folder, not the
user.

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

Re: [GNC-dev] Single User Installation location on Linux

[Colin Law]

On Fri, 6 Mar 2020 at 09:29, Geert Janssens  wrote:
> ...
> What I am still curious about though is how applications get installed in 
> $HOME/.local/bin.

Looking at my notes on platformio I believe it got there via
pip install --user platformio
In my notes it also says to add .local/bin to the path but I don't
know whether in fact it was there already.

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

Re: [GNC-dev] Single User Installation location on Linux

[Colin Law]

Inspecting my Ubuntu 19.10 system I see that a number of applications
have installed themselves to ~/.local/bin.  Platformio for example.
Also that folder is in the PATH, but whether it is there on a clean
install I don't know.

Colin

On Thu, 5 Mar 2020 at 22:20, David Cousens  wrote:
>
> Geert
>
> I had a short discussion about where to install for local use with John when
> I started updating the wiki a couple of years ago. At that time the user
> gnucash data files weren't in $HOME/.local/share/gnucash so there was no
> possible conflict at that time.
>
> The $HOME/.local/bin was added to PATH in my default user .profile supplied
> in Linux Mint which is executed by the command interpreter in login shells.
> It also adds $HOME/bin to the PATH and includes .bashrc if it exists., so it
> is a distro dependent addition and we can't assume it will have been added
> in all distributions.
> .profile 
>
>
> If $HOME/.local/bin or $HOME/bin is in the PATH and has a soft link in
> either location to the executable  then just typing gnucash at the prompt in
> a terminal will start it (AFAIK as long as there isn't another link earlier
> in the PATH variable which gets activated first). My own  practice is to
> create aliases  which address the specific executable and locations when I
> have multiple versions installed or if the use is likely to be longer term
> create launchers for the specific version in the LM menu.
>
> > That will depend a bit on the history behind the choice for $HOME/.local
> > in
> > the first place.
>
> That was the main reason why I raised it here after Frank pointed it out in
> a comment on my reply to a user in the user forum. It may be the user data
> files can coexist happily in $HOME/.local/share along with the program data
> files as it is a single user installation.
>
> I built and installed 3.8 to $HOME/.local yesterday to check it out. make
> uninstall seems to have removed the files placed in
> $HOME/.local/share/gnucash in the install without affecting the user data
> files in the same location, but just leaves the trail of empty directories
> the files were in.The risk is in a user doing a manual uninstall of the
> program and accidentally deleting the user data files with custom reports,
> checks books etc.
>
>
> David Cousens
>
>
> David
>
>
>
> -
> David Cousens
> --
> 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
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Failure to clone repo on Windows

[Colin Law]

Possibly this
https://github.com/git-for-windows/git/issues/2435

Colin

On Mon, 6 Jan 2020 at 10:15, Gnu Cash  wrote:
>
> Anybody seen this?  (can't see any reference to it in the recent archives)
>
> Using git version 2.24.1.windows.2
>
> [image: image.png]
> ___
> 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: [GNC-dev] What about outdated open bugs in Gnucash Bugzilla?

[Colin Law]

On Thu, 7 Nov 2019 at 22:24, Christian Gruber
 wrote:
>
> Ok, I'll start doing that on all bugs older than 10 years. If there is
> no reaction after at least one month, I'll close them as RESOLVED.

Does the system have a setting so that automatically closes bugs that
have been marked as needing input if nothing happens for a defined
period?  Launchpad uses that method for Ubuntu bugs and it is a good
way of getting rid of obsolete bug reports with minimum intervention.

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

Re: [GNC-dev] What about outdated open bugs in Gnucash Bugzilla?

[Colin Law]

Possibly an alternative, used in Ubuntu for example, is when a version
goes out of support that any bugs against that version have a comment
added saying the version is out of support, saying that if the bug is
relevant to a later version then please to post a comment, and marking
the bug as needing info, so it will expire after a time if there is no
input,

Colin

On Sun, 27 Oct 2019 at 21:46, David Cousens  wrote:
>
> John,
>
> Is there perhaps a need to place maintenance limits on GnuCash release
> versions,  i.e. at a specified time after release they become unsupported,
> as is bugs and all. This is more than likely what actually happens in
> practice given limited skilled developer time. As bug reports are often tied
> to a specific version, bugs could then be removed from bugzilla when the
> version they apply to becomes unsupported.  Most bugs are not show stoppers
> and those that are or are particularly inconvenient are usually fixed fairly
> quickly after release.
>
> Enhancement requests could possibly have a longer lifetime but perhaps there
> is a need for expiry on those as well. E.g. if they didn't make it into the
> next major release and you really need that feature you raise the issue
> again (or work on it yourself).
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> 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
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Ubuntu Eoan has GnuCash 3.7

[Colin Law]

On Fri, 27 Sep 2019 at 19:15, Tommy Trussell  wrote:
>
> I see (some? all?) of them (plus a few OTHER things we've discussed here
> even in the past few days) in the git log for GnuCash after the 3.7 tag.
> :-/  Such is the nature of moving targets!

Do you mean that the version which calls it is 3.7 in ubuntu 19.10 is
actually 3.7 + some fixes or enhancements that are not in 3.7 buiilt
from source?
Could that be confusing when someone reports an issue in '3.7'?

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

Re: [GNC-dev] Dependencies on Launchpad

[Colin Law]

I would not bother trying to build for Trusty. It went out of support
in April, nobody should be using it now.
https://wiki.ubuntu.com/Releases

Colin

On Mon, 27 May 2019 at 02:11, John Ralls  wrote:
>
> You don't need libgwen-gtk3, GnuCash's CMakeLists will figure out if it's not 
> present and build the sources included in borrowed/libgwen-gtk3.
>
> Ubuntu 14.04 includes libwebkit2gtk-3.0-dev and that's sufficient for GnuCash.
>
> GnuCash just needs the googletest sources, so util/ci/ubuntu-14.04-docker 
> clones https://github.com/google/googletest. You don't need to build anything,
>
> Regards,
> John Ralls
>
>
> > On May 26, 2019, at 3:49 PM, Stephen M. Butler  wrote:
> >
> > On 5/26/19 3:24 PM, Dale Phurrough wrote:
> >> Gnucash 3.5 builds clean on Ubuntu 14.04 aka Trusty with the list of
> >> packages in the Dockerfile at
> >> https://github.com/diablodale/gnucash-dev-docker/blob/master/debian.dockerfile
> >>
> >> You can see in it there are some logic tests to see what
> >> platform/packages are available in the repos.
> >> Currently I use the suggestion from the core devs to pull all the
> >> build dependencies for gnucash 2.x (build-dep -qq gnucash). I'll
> >> change that later to be more specific as I have done already with the
> >> CentOS and upcoming openSUSE Dockerfile.
> >> You can use the Dockerfile along with your own research to get the
> >> needed packages.
> >> Gtest and gmock are not available for Trusty. You will need to build
> >> that yourself. The core devs write about this and you can see in the
> >> Dockerfile that 1.8.0 is downloaded and later compiled by c/make.
> >>
> >> If you have a specific list of packages, I would be interested to help
> >> resolve them because I'll need to do that myself when I replace the
> >> build-dep approach.
> >>
> >> --Dale
> >>
> >
> > My problem is figuring out what to tell Launchpad so it will build from
> > source for Trusty.
> >
> > The debian/control file wants debhelper >= 11.  It looks like 9.2 is
> > available for Trusty do I'll try to downgrade that to >= 9.
> >
> > googletest isn't available for Trusty.  Somehow I'll need to get that
> > into my PPA first and have it built for Trusty there.
> >
> > Ditto for locales-all.  Haven't found that one yet.
> >
> > Also need ibgwengui-gtk3-dev and libwebkit2tk-4.0-dev
> >
> > So, if I can figure out those five packages for Trusty, then we'll take
> > another crack at building for the PPA.
> >
> > I can build on my own box just fine.  Teaching the PPA up on Launchpad
> > is another story!
> >
> >
> > --Steve
> >
> >> On Sun, May 26, 2019 at 11:51 PM Stephen M. Butler  >> > wrote:
> >>
> >>I received this response from the folks on Launchpad:
> >>
> >>You tried building the packages for Ubuntu trusty, but several
> >>dependencies (at least debhelper (>= 11~), googletest, locales-all) do
> >>not exist in the standard repositories or trusty.
> >>
> >>If you really want to build these packages for trusty, then you first
> >>have to find a solution for these dependent packages in trusty (either
> >>in an existing PPA, or by backporting theses packages to trusty in
> >>your
> >>own PPA). Otherwise it is not possible to build that gnucash
> >>package for
> >>trusty.
> >>
> >>-
> >>
> >>What suggestions do the devs have?  What is the earliest Ubuntu
> >>that has these in the standard repository or should I investigate
> >>adding them to my PPA (and then I'll have to figure out how to do
> >>that)?
> >>
> >>--Steve
> >>
> >>
> >>On 5/23/19 2:41 PM, Stephen M. Butler wrote:
> >>> I've made it to the point of uploading source to Launchpad to
> >>build a
> >>> ppa.  However, Launchpad reported these dependency issues:
> >>>
> >>>
> >>
> >> +--+
> >>> | Install gnucash build dependencies (apt-based resolver)
> >>  |
> >>>
> >>
> >> +--+
> >>>
> >>> Installing build dependencies
> >>> Reading package lists...
> >>> Building dependency tree...
> >>> Reading state information...
> >>> Some packages could not be installed. This may mean that you have
> >>> requested an impossible situation or if you are using the unstable
> >>> distribution that some required packages have not yet been created
> >>> or been moved out of Incoming.
> >>> The following information may help to resolve the situation:
> >>>
> >>> The following packages have unmet dependencies:
> >>>   sbuild-build-depends-gnucash-dummy : Depends: debhelper (>=
> >>11~) but 9.20131227ubuntu1 is to be installed
> >>>Depends: googletest but it
> >>is not installable
> >>>Depends:
> >>libgwengui-gtk3-dev but it is not installable
> >>>

Re: [GNC-dev] About the "$HOME/.local" installation prefix

[Colin Law]

On Fri, 3 May 2019 at 07:26, David Cousens  wrote:
> ...
> I.e. we recommend using cmake commands as follows for inexperienced or users
> who don't have admin privileges rather than simply installing directly under
> $HOME/.local  which already has a gnucash directory for GnuCash user
> preferences.
>
> cmake -DCMAKE_INSTALL_PREFIX=$HOME/.local/programs/gnucash  absolute path to sources>
>
> If you think this is a better idea (or there is another more general
> alternative  I can update the Wiki build instructions to reflect this. The
> user could then create an alias in the bashrc file to access the executable
> and/or add it to their launcher etc.

I really don't like the idea of installing under a hidden directory (~/.local).

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

Re: [GNC-dev] About the "$HOME/.local" installation prefix

[Colin Law]

On many varieties of Linux /usr/local is the conventional location to
add locally built packages.  In this case probably /usr/local/gnucash.
I think the build instructions used to suggest that but I may be
mistaken.

Colin

On Thu, 2 May 2019 at 17:27, Geert Janssens  wrote:
>
> Op donderdag 2 mei 2019 18:03:22 CEST schreef Tommy Trussell:
> > On Thu, May 2, 2019 at 6:02 AM Geert Janssens 
> >
> > wrote:
> > > Our current wiki on building gnucash for Ubuntu 16.04 (https://
> > > wiki.gnucash.org/wiki/BuildUbuntu16.04) suggests $HOME/.local as a valid
> > > installation prefix.
> >
> > ...
> >
> > > So personally I would recommend against using $HOME/.local as installation
> > > prefix. I am however curious where this suggestion originally came from.
> >
> > This is entirely speculation... I'm looking at this system where I've been
> > testing the GnuCash versions available as Snap and Flatpak... and I see
> > that the Flatpak installation apparently added
> > ~/.local/share/flatpak/exports/share to the $XDG_DATA_DIRS environment
> > variable.
> >
> > Maybe whoever wrote the wiki entry was also working with Flatpak and
> > thought .local would be a good place to stash things to make them more
> > accessible to Flatpak.
> >
> Possibly.
>
> > I would think ~/bin would be a more ideal suggestion because I see it is
> > already defined in my bash $PATH on this Ubuntu machine. (And I'm pretty
> > sure I didn't add it, though I may have.)
>
> That would be another alternative location. To have gnucash benefit from ~/bin
> being on the path though the gnucash binary itself should be ~/bin/gnucash.
>
> Translating this back to the required installation prefix would mean the
> installation prefix should be $HOME.
>
> This is certainly possible but has the drawback the installation would add
> extra directories in your home directory, like
> ~/share
> ~/etc
> ~/lib(64)
> ...
>
> That may be cluttering the home directory more than the average user may like.
> And in addition if someone is adding other binaries to ~/bin it again becomes
> more difficult to keep the gnucash build separate from everything else.
>
> To me something like Adrien suggested makes most sense.
> One could add two extra steps to simplify launching gnucash afterwards:
> - make a softlink from /bin/gnucash to /home/bin/gnucash.
> This would allow console users to simply type "gnucash" to run their own
> gnucash build.
> - copy /share/applications/gnucash.desktop to
> ~/.local/share/applications
> That should make you graphical environment aware of your self-built gnucash
> and have it pop up in the usual places to launch applications (the Kicker menu
> on KDE, or the gnome-shell application launcher).
>
> Regards,
>
> Geert
>
>
> ___
> 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: [GNC-dev] Building 3.5 package for Disco

[Colin Law]

Keep up the good work, it is very much appreciated.

Colin

On Fri, 26 Apr 2019 at 17:30, Stephen M. Butler  wrote:
>
> Just upgraded to 19.04 from 18.04 (had to apply 18.10 in the process).
> I figured the upgrade would handle all items, but I found this note
> today (https://launchpad.net/ubuntu/disco/+source/gtest) that says gtest
> source isn't available for 19.10.
>
> Listing the packages on this box shows:
> dpkg -l | grep gtest
> ii  autopkgtest
> 5.10ubuntu1  all  automatic as-installed
> testing for Debian packages
> ii  libgtest-dev:amd64
> 1.8.1-3  amd64Google's framework for
> writing C++ tests
>
> dpkg -l | grep mock
> ii  google-mock:amd64
> 1.8.1-3  amd64Google's framework for
> writing and using C++ mock classes
> ii  libnunit-mocks2.6.3-cil
> 2.6.4+dfsg-1 all  Unit test framework
> for CLI - Assemblies
>
> Then I found this note
> (https://askubuntu.com/questions/219516/howto-install-google-mock-on-ubuntu-12-10)
> about needing to compile google test with the same flags as the subject
> (in this case GnC) else get strange results.
>
> I'm headed back to the wiki for building GnC on Linux to verify the
> dependencies (and cross check to what 19.04 loaded).  I think there was
> a note there about building google test and mock.
>
> I will report back once I've done that.
>
> --Steve
>
> [but it did work on 18.04!!]
>
>
>
> On 4/26/19 12:26 AM, Geert Janssens wrote:
> > The error seems to have something to do with GTtest. Do you have 
> > google_test/
> > google_mock properly installed ?
> >
> > Regards,
> >
> > Geert
> >
> > Op vrijdag 26 april 2019 04:37:04 CEST schreef Stephen M. Butler:
> >> Anybody here can help with dpkg-buildpackage -rfakeroot -b -uc?
> >>
> >> I received this error message (snippet copied):
> >>
> >> Scanning dependencies of target test-tx_import
> >> make[5]: Leaving directory '/home/steve/Projects/GnuCash/gnucash/.build'
> >> /usr/bin/make -f
> >> gnucash/import-export/csv-imp/test/CMakeFiles/test-tx_import.dir/build.make
> >> gnucash/import-export/csv-imp/test/CMakeFiles/test-tx_import.dir/build
> >> make[5]: Entering directory '/home/steve/Projects/GnuCash/gnucash/.build'
> >> [ 87%] Building CXX object
> >> gnucash/import-export/csv-imp/test/CMakeFiles/test-tx_import.dir/test-tx-imp
> >> ort.cpp.o cd
> >> /home/steve/Projects/GnuCash/gnucash/.build/gnucash/import-export/csv-imp/te
> >> st && /usr/bin/c++  -DHAVE_CONFIG_H -DHAVE_GUILE20 -D_GNU_SOURCE
> >> -I/home/steve/Projects/GnuCash/gnucash/gnucash/import-export/csv-imp
> >> -I/home/steve/Projects/GnuCash/gnucash/.build/common
> >> -I/home/steve/Projects/GnuCash/gnucash/common
> >> -I/home/steve/Projects/GnuCash/gnucash/libgnucash/engine
> >> -I/home/steve/Projects/GnuCash/gnucash/common/test-core
> >> -I/home/steve/Projects/GnuCash/gnucash/lib -I/usr/include/glib-2.0
> >> -I/usr/lib/x86_64-linux-gnu/glib-2.0/include
> >> -I/home/steve/Projects/GnuCash/gnucash/.build/__gtest/googletest/include
> >> -I/home/steve/Projects/GnuCash/gnucash/gnucash/import-export
> >> -I/usr/include/gtk-3.0 -I/usr/include/at-spi2-atk/2.0
> >> -I/usr/include/at-spi-2.0 -I/usr/include/dbus-1.0
> >> -I/usr/lib/x86_64-linux-gnu/dbus-1.0/include -I/usr/include/gio-unix-2.0
> >> -I/usr/include/cairo -I/usr/include/libdrm -I/usr/include/pango-1.0
> >> -I/usr/include/harfbuzz -I/usr/include/fribidi -I/usr/include/atk-1.0
> >> -I/usr/include/pixman-1 -I/usr/include/freetype2 -I/usr/include/libpng16
> >> -I/usr/include/gdk-pixbuf-2.0 -I/usr/include/libmount
> >> -I/usr/include/blkid -I/usr/include/uuid
> >> -I/home/steve/Projects/GnuCash/gnucash/gnucash/gnome-utils
> >> -I/home/steve/Projects/GnuCash/gnucash/libgnucash/app-utils
> >> -I/home/steve/Projects/GnuCash/gnucash/borrowed/libc
> >> -I/home/steve/Projects/GnuCash/gnucash/.build/libgnucash/core-utils
> >> -I/home/steve/Projects/GnuCash/gnucash/libgnucash/core-utils
> >> -I/usr/include/guile/2.0
> >> -I/home/steve/Projects/GnuCash/gnucash/libgnucash/gnc-module
> >> -I/usr/include/libxml2
> >> -I/home/steve/Projects/GnuCash/gnucash/libgnucash/backend/xml
> >> -Wno-error=deprecated-declarations  -Werror -Wall -Wmissing-declarations
> >> -Wno-unused -Wno-error=parentheses -std=gnu++11 -g -O2
> >> -fdebug-prefix-map=/home/steve/Projects/GnuCash/gnucash=.
> >> -fstack-protector-strong -Wformat -Werror=format-security -Wdate-time
> >> -D_FORTIFY_SOURCE=2 -O3 -DNDEBUG   -o
> >> CMakeFiles/test-tx_import.dir/test-tx-import.cpp.o -c
> >> /home/steve/Projects/GnuCash/gnucash/gnucash/import-export/csv-imp/test/test
> >> -tx-import.cpp [ 87%] Linking CXX executable ../../../../bin/test-tx_import
> >> cd
> >> /home/steve/Projects/GnuCash/gnucash/.build/gnucash/import-export/csv-imp/te
> >> st && /usr/bin/cmake -E cmake_link_script
> >> CMakeFiles/test-tx_import.dir/link.txt --verbose=1
> >> /usr/bin/c++  -Wno-error=deprecated-declarations  -Werror -Wall
> >> 

Re: [GNC-dev] GnuCash 3 on Linux

[Colin Law]

On Tue, 12 Mar 2019 at 09:14, Colin Law  wrote:
>
> On Tue, 12 Mar 2019 at 04:19, Wm via gnucash-devel
>  wrote:
> >
> > On 24/02/2019 15:40, Colin Law wrote:
> > > On Sun, 24 Feb 2019 at 15:21, Wm via gnucash-devel
> > >  wrote:
> > >>
> > >> That is the point, dear, you may not have said a swearword but what you
> > >> are supporting is shameful.
> > >
> > > Please don't call me dear.  That is almost as bad as labelling me a
> > > Trump supporter.
> > > I don't understand what it is you think I am supporting, all I am
> > > supporting here is gnucash and civility.
> >
> > If arguments were heard I'd agree.
> >
> > No-one likes repeating themself.
>
> Just please quote the bit of whichever of my posts upset you so much,
> if you have already done that then apologies for asking you to repeat
> yourself.  You said "what you are supporting is shameful" but I don't
> know where in my posts I am supporting something that is shameful.

I am taking from your lack of response as an indication of the fact
that, having looked back at my posts, you have determined that I did
not say anything that backs up your assertion.  I now consider this
matter closed.

Colin
>
>
> Colin
>
> >
> > --
> > Wm
> >
> >
> >
> >
> > ___
> > 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: [GNC-dev] GnuCash 3 on Linux

[Colin Law]

On Sun, 24 Feb 2019 at 15:21, Wm via gnucash-devel
 wrote:
>
> That is the point, dear, you may not have said a swearword but what you
> are supporting is shameful.

Please don't call me dear.  That is almost as bad as labelling me a
Trump supporter.
I don't understand what it is you think I am supporting, all I am
supporting here is gnucash and civility.

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

Re: [GNC-dev] GnuCash 3 on Linux

[Colin Law]

On Sat, 23 Feb 2019 at 23:28, Wm via gnucash-devel
 wrote:
> ...
> You, Colin Law, seem to be the sort of person that votes for Trump
> because you aren't bothered if a black women gets shot.

I fail to see what I have done to be so vilely abused as to be accused
of being a Trump supporter or being a racist.

Also I fail to see what I said that so angered you.  I merely
expressed surprise that you use Gnucash when you have such a low
opinion of the developers.  How you can trust their work to look after
your financial data when you consider them so incompetent I don't
know.

As for my desire not to post words that may offend others then that is
why I do it, so as not to offend.  I have grandchildren and if they
should happen to google my name and come up with my posts I would not
want to be ashamed of what I have written.  Some obviously are not
worried about offending others.

>
> There aren't that many people like you out there, Colin Law, and you
> should let this community know which side you are on.

Which side of what?

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

Re: [GNC-dev] GnuCash 3 on Linux

[Colin Law]

I cannot understand why you keep using this software since it is so
obviously horribly flawed and you have such a low opinion of the
developers.

I am sure you would be a much happier person if you used one of the
many alternatives that are conveniently available.

Surely anyone who keeps using it is just encouraging these ne'r do
well developers to carry on in their recalcitrant ways and you really
owe it to yourself to stop using it in order to show how disgusted you
are.  That'll show the F***Ts won't it.

Colin

On Sat, 23 Feb 2019 at 21:37, Wm via gnucash-devel
 wrote:
>
> On 05/06/2018 13:53, Chris Good wrote:
> > Hi,
>
> Hello, Chris
>
> > I'm working on my BackupGnuCash stand-alone app.
> > I have 2 questions today:
>
> read
> https://wiki.gnucash.org/wiki/Configuration_Locations
> and weep at how bad things have become
>
> The last time i addressed this our idiots in charge were so recalcitrant
> about even considering they'd done a stupid thing I stopped reading the
> gnc lists.
>
> I am glad you, someone I respect, have raised it again.
>
> > 1.
> >
> > I'm a little uncertain about where the saved reports and metadata files are
> > in GnuCash 3.0 for Linux.
>
> unfortunately the people that think they know better decided to put them
> where Micrsosoft, etc thought best.  That means it changes at a whim, I
> am angry about this and they don't care.
>
> I cannot make a backup policy for my charitable organizations because
> our cleverer-than-thou FUCKWIT seniors just put stuff where they think
> MS or Linux policy suggests they should go and never actually think for
> themselves.
>
> The files should belong to the book and be closely associated with them.
>
> Our FUCKWITS IN CHARGE decided that the metadata belonged with the user
> not the book, that makes no fucking sense for an accounting file, they
> changed it anyway, gr
>
> > I suspect they are by default:
> >
> > ~/.local/share/gnucash/saved-reports-2.4
> >
> > ~/.local/share/gnucash/books/[BOOK].gnucash.gcm
> >
> > unless overridden by XDG_DATA_HOME.
>
> except you can't rely on those those locations.
>
> See the problem now?
>
> > Can some-one please confirm?
>
> Only thing I can confirm is I don't know where anything is.
>
> > 2.
> >
> > I tried to get version 3 on Linux (Ubuntu 16.04) running to test myself.
>
> that's the easy bit :)
>
> > Thanks in advance,
>
> Waves back.
>
> ___
> 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: [GNC-dev] Normalizing live data, a suggestion for discussion

[Colin Law]

Can all users save files as sqlite?  Does that need anything extra
installed on the OS side that may not be there?  Also what about
different builds of GC, do they all have sqlite?Colin

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

Re: [GNC-dev] Debian files

[Colin Law]

That is working well for me (on a virgin 18.10 system).

Excellent work.

Colin

On Wed, 23 Jan 2019 at 23:15, Stephen M. Butler  wrote:
>
> On 1/23/19 12:55 PM, Colin Law wrote:
> > Steve, are you sure it is worth all this effort? If the flatpak
> > nightly and stable builds become available then they will be perfectly
> > acceptable for Ubuntu.
> >
> > Colin
>
>
> Excellent question!  Probably not.  But then, I have some success this
> afternoon (US West Coast).
>
> I did the following and it worked for me.  I've uploaded the three deb
> files (along with the ddeb and changes, etc) to:
>
> https://drive.google.com/open?id=1fV_fURy6c77e7gf6S41lTacM7dFyy7VD
>
> I still need to figure out how to package this for Launchpad -- but I
> think I just crossed over the biggest hurdle.
>
> Besides, how else am I supposed to learn this stuff?  <>
>
> Items I see still need to be done:
>
> 1.  Script the steps I made so I can automate it and avoid typing mistakes.
>
> 2.  Push to launchpad so they can rebuild it.
>
> Probably not worth it -- but it feels good to have accomplished this so far!
>
> steve@SteveLaptop:~/Projects/GnuCash$ /*ls -Fal *.deb*/
> -rw-r--r-- 1 steve steve 3901212 Jan 23 14:29 gnucash_3.4_amd64.deb
> -rw-r--r-- 1 steve steve 5027024 Jan 23 14:29 gnucash-common_3.4_all.deb
> -rw-r--r-- 1 steve steve  268880 Jan 23 14:29 python3-gnucash_3.4_amd64.deb
>
>
> steve@SteveLaptop:~/Projects/GnuCash$ */sudo apt install ./*.deb/*
> [sudo] password for steve:
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Note, selecting 'gnucash' instead of './gnucash_3.4_amd64.deb'
> Note, selecting 'gnucash-common' instead of './gnucash-common_3.4_all.deb'
> Note, selecting 'python3-gnucash' instead of
> './python3-gnucash_3.4_amd64.deb'
> The following additional packages will be installed:
>   gnucash-docs libclass-inspector-perl libclass-singleton-perl
> libcommon-sense-perl libdate-manip-perl libdatetime-locale-perl
> libdatetime-perl libdatetime-timezone-perl libfile-sharedir-perl
>   libfinance-quote-perl libhtml-tableextract-perl libjs-jquery
> libjson-perl libjson-xs-perl libtypes-serialiser-perl
> Suggested packages:ls -Fal *.deb
>   libdbd-mysql libhtml-element-extended-perl
> Recommended packages:
>   pythone3-gnucash
> The following NEW packages will be installed:
>   gnucash gnucash-common gnucash-docs libclass-inspector-perl
> libclass-singleton-perl libcommon-sense-perl libdate-manip-perl
> libdatetime-locale-perl libdatetime-perl libdatetime-timezone-perl
>   libfile-sharedir-perl libfinance-quote-perl libhtml-tableextract-perl
> libjs-jquery libjson-perl libjson-xs-perl libtypes-serialiser-perl
> python3-gnucash
> 0 upgraded, 18 newly installed, 0 to remove and 3 not upgraded.
> Need to get 0 B/98.5 MB of archives.
> After this operation, 227 MB of additional disk space will be used.
> Do you want to continue? [Y/n] Y
> Get:1 /home/steve/Projects/GnuCash/gnucash-common_3.4_all.deb
> gnucash-common all 1:3.4 [5,027 kB]
> Get:2 /home/steve/Projects/GnuCash/gnucash_3.4_amd64.deb gnucash amd64
> 1:3.4 [3,901 kB]
> Get:3 /home/steve/Projects/GnuCash/python3-gnucash_3.4_amd64.deb
> python3-gnucash amd64 1:3.4 [269 kB]
> Selecting previously unselected package libjs-jquery.
> (Reading database ... 232220 files and directories currently installed.)
> Preparing to unpack .../00-libjs-jquery_3.2.1-1_all.deb ...ls -Fal *.deb
> Unpacking libjs-jquery (3.2.1-1) ...
> Selecting previously unselected package gnucash-common.
> Preparing to unpack .../01-gnucash-common_3.4_all.deb ...
> Unpacking gnucash-common (1:3.4) ...
> Selecting previously unselected package libhtml-tableextract-perl.
> Preparing to unpack .../02-libhtml-tableextract-perl_2.15-1_all.deb ...
> Unpacking libhtml-tableextract-perl (2.15-1) ...
> Selecting previously unselected package libclass-inspector-perl.
> Preparing to unpack .../03-libclass-inspector-perl_1.32-1_all.deb ...
> Unpacking libclass-inspector-perl (1.32-1) ...
> Selecting previously unselected package libfile-sharedir-perl.
> Preparing to unpack .../04-libfile-sharedir-perl_1.104-1_all.deb ...
> Unpacking libfile-sharedir-perl (1.104-1) ...
> Selecting previously unselected package libdatetime-locale-perl.
> Preparing to unpack .../05-libdatetime-locale-perl_1%3a1.17-1_all.deb
> /sudo apt install ./*.deb/...
> Unpacking libdatetime-locale-perl (1:1.17-1) ...
> Selecting previously unselected package libclass-singleton-perl.
> Preparing to unpack .../06-libclass-singleton-perl_1.5-1_all.deb ...
> Unpacking libclass-singleton-perl (1.5-1) ...
> Selecting previously unselected package libdatetime-timezone-perl.
> 

Re: [GNC-dev] Debian files

[Colin Law]

Steve, are you sure it is worth all this effort? If the flatpak
nightly and stable builds become available then they will be perfectly
acceptable for Ubuntu.

Colin

On Wed, 23 Jan 2019 at 17:27, Stephen M. Butler  wrote:
>
> On 1/22/19 8:08 PM, John Ralls wrote:
> >
> >> On Jan 22, 2019, at 7:01 PM, Stephen M. Butler  wrote:
> >>
> >> Looking for someone more knowledgeable than I.  Where did I go wrong?
> >>
> >> I uninstalled my locally built gnucash (sudo make uninstall) and cleaned
> >> the system (sudo apt autoremove) then started with these debian files:
> >>
> > [snip]
> >
> >> --> whereis gnucash
> >> gnucash: /etc/gnucash /usr/local/etc/gnucash /usr/local/lib/gnucash
> >>
> >> --> gnucash
> >>
> >> Command 'gnucash' not found, but can be installed with:
> >>
> >> sudo apt install gnucash
> >>
> >> --> sudo apt install gnucash
> >> Reading package lists... Done
> >> Building dependency tree
> >> Reading state information... Done
> >> gnucash is already the newest version (1:3.4).
> >> 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
> >>
> >>
> >> SMB: At this point I decided to remove the packages and see if my local
> >> build would install and run
> > [snip]
> >
> >>
> >> SMB: And gnucash works.  So why didn't installing the debian package work?
> > It appears from the dump that it didn’t complete installing because the 
> > Finance::Quote dependencies (which should be optional) and the jqplot 
> > dependency (needed for making chart reports, not optional) weren’t 
> > installed, but apt marked it as installed anyway. If you really care you 
> > could uninstall and reinstall the “official” gnucash.deb and see if it 
> > works. If it doesn’t then it would seem that something’s messed up and you 
> > should confer with Dimitry to figure out what it is.
> >
> > Regards,
> > John Ralls
> >
> >
> Removed my local build and installed the repository version (2.6.19 is
> what it found).  That worked.
>
> Dimitry isn't interested in helping.
>
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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: [GNC-dev] Debian package

[Colin Law]

On Tue, 22 Jan 2019 at 15:34, Stephen M. Butler  wrote:
>
> Looks like the dependency list from the mainline is missing a few
> entries.  I'll check that out.
>
> Also, here are the files for the debian folder used in the build.  Any
> suggestions or corrections would be appreciated.  Wondering if there is
> a way to package this all together instead of having three .deb files?

Sorry, I don't really know much about deb files.

Colin


Colin

>
> --Steve
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Debian package

[Colin Law]

Sorry for delay, been otherwise engaged.
On a live Ubuntu 18.10 session running off the install image I started
by attempting to install gnucash_3.4_amd64.deb

ubuntu@ubuntu:~$ sudo dpkg -i Downloads/gnucash_3.4_amd64.deb
Selecting previously unselected package gnucash.
(Reading database ... 149974 files and directories currently installed.)
Preparing to unpack .../gnucash_3.4_amd64.deb ...
Unpacking gnucash (1:3.4) ...
dpkg: dependency problems prevent configuration of gnucash:
 gnucash depends on gnucash-common (= 1:3.4); however:
  Package gnucash-common is not installed.
 gnucash depends on libaqbanking35-plugins; however:
  Package libaqbanking35-plugins is not installed.
 gnucash depends on guile-2.2 | guile-2.0; however:
  Package guile-2.2 is not installed.
  Package guile-2.0 is not installed.
 gnucash depends on libfinance-quote-perl; however:
  Package libfinance-quote-perl is not installed.
 gnucash depends on libhtml-tableextract-perl; however:
  Package libhtml-tableextract-perl is not installed.
 gnucash depends on libcrypt-ssleay-perl; however:
  Package libcrypt-ssleay-perl is not installed.
 gnucash depends on libdate-manip-perl; however:
  Package libdate-manip-perl is not installed.

dpkg: error processing package gnucash (--install):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 gnucash

I then tried gnucash_3.4_amd64.deb

ubuntu@ubuntu:~$ sudo dpkg -i Downloads/gnucash-common_3.4_all.deb
Selecting previously unselected package gnucash-common.
(Reading database ... 149977 files and directories currently installed.)
Preparing to unpack .../gnucash-common_3.4_all.deb ...
Unpacking gnucash-common (1:3.4) ...
dpkg: dependency problems prevent configuration of gnucash-common:
 gnucash-common depends on libjs-jquery; however:
  Package libjs-jquery is not installed.

dpkg: error processing package gnucash-common (--install):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 gnucash-common

On Mon, 21 Jan 2019 at 07:10, Stephen M. Butler  wrote:
>
> Please try these before I take the next step of figuring out how to
> populate a ppa up on Launchpad.
>
> GnuCash-3.4
> https://drive.google.com/open?id=1fV_fURy6c77e7gf6S41lTacM7dFyy7VD
>
>
> GnuCash-3.4-39 (current maint)
> https://drive.google.com/open?id=1SO2xkPICKEpSQCvJLW6CnBVrzgvTEyHQ
>
>
> Thanks to all who stepped forward with suggestions.
>
> And to preempt others -- Yes, I do have a kite.  And I use a dry suite
> when jumping into lakes!  <>
>
> --Steve
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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: [GNC-dev] [GNC] dpkg-builder

[Colin Law]

On Sun, 20 Jan 2019 at 19:03, Mechtilde  wrote:
>
> Hello
>
> unter debian Buster you can use GnuCash version 3.4 from the Debian repo.

Yes, but not in Ubuntu 18.10.

Colin

>
> Kind regards
>
>
> --
> Mechtilde Stehmann
> ## Apache OpenOffice
> ## Freie Office Suite für Linux, MacOSX, Windows
> ## Debian Developer
> ## PGP encryption welcome
> ## F0E3 7F3D C87A 4998 2899  39E7 F287 7BBA 141A AD7F
>
> ___
> 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: [GNC-dev] Launchpad

[Colin Law]

Managed to give
http://mirrors.kernel.org/ubuntu/pool/universe/g/gnucash/gnucash_3.4-1_amd64.deb
a quick try on 18.10 and it fails to install with lots of missing
packages, and apt install -f just says it is going to remove the
partially install gnucash again, which I think means the packages are
not available on 18.10.  I assume it will be the same or worse on
18.04.

Colin

On Thu, 3 Jan 2019 at 21:46, Stephen M. Butler  wrote:
>
> Thanks.  I checked the trusty and others and they had older versions.
> So, maybe not so good news.
>
> But, if I can get his debian folder
>
> On 1/3/19 1:34 PM, Colin Law wrote:
> > On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
> >> mirrors.kernel.org/ubuntu
> >> <http://mirrors.kernel.org/ubuntu/pool/universe/g/gnucash/gnucash_3.4-1_amd64.deb>
> >>
> >> Colin, do you have a machine on which this can be tested?
> > Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
> > (19.04) so whether there will be problems with 18.10 or 18.04 remains
> > to be seen.  I can't try it till tomorrow though (it is late evening
> > here in UK).
> >
> > Colin
> >
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Launchpad

[Colin Law]

On Thu, 3 Jan 2019 at 21:28, Stephen M. Butler  wrote:
>
> mirrors.kernel.org/ubuntu
> 
>
> Colin, do you have a machine on which this can be tested?

Yes, on Ubuntu 18.10.  Note that I think this is intended for disco
(19.04) so whether there will be problems with 18.10 or 18.04 remains
to be seen.  I can't try it till tomorrow though (it is late evening
here in UK).

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

Re: [GNC-dev] Launchpad

[Colin Law]

I don't think the guys/gals that maintain the official Debian and
Ubuntu packages are on this list, though I may be wrong.

Colin

On Mon, 31 Dec 2018 at 17:44, Stephen M. Butler  wrote:
>
> Dev Team,
>
> So far, three folks have either used or inquired about using the debian
> package for 3.4.  Marketing theory (no, I'm a software engineer by
> avocation) says that there are several more that would take advantage if
> it were more "supported".
>
> Here are my thoughts:
>
>  1. Both Ubuntu (Launchpad) and Debian request certain files in a
> ~/debian folder.  Most of these appear to be copies of files the
> application already has.  Perhaps a softlink could be put in the
> debian folder that points to the original so that changes in the
> original automatically show up in the folder.  Does this work via git?
>  2. I'm willing to coordinate the effort to build that folder (I presume
> on the Master branch) but will need volunteers from more technical
> folks from time-to-time to handle some of the techy stuff.  I know
> the devs are busy squashing bugs so this would have to take a back
> seat to that.
>  3. Building this folder might even be beneficial to the official
> packagers for the various distros.
>  4. One team for whom I did light testing, published a daily build (no
> longer daily as the software matured) for the adventurous.
>
>
> https://launchpad.net/~subsurface/+archive/ubuntu/subsurface-daily
>
> I would be willing to push the files up to Launchpad if the team sees
> value in perusing this.  However, I don't want to step on anybodies toes
> if this would get in the way of the official release process for the
> various distros.  And, if this got to the point of highly automated,
> perhaps the dev team would prefer to do the push themselves.
>
> --Steve
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
> ___
> 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: [GNC-dev] *.deb package for GnuCash 3.4 Released

[Colin Law]

On Mon, 31 Dec 2018 at 10:06, Colin Law  wrote:
>
> On Sun, 30 Dec 2018 at 20:33, Stephen M. Butler  wrote:
> >
> > For those interested in a deb file but not willing to compile yourself:
> > https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY -->
> > gnucash_3.4-0-1_amd64.deb
>
> I am trying this on Ubuntu 18.10 and when running it I get
> error while loading shared libraries: libboost_regex.so.1.65.1: cannot
> open shared object file: No such file or directory

OK, found solution
sudo apt install libboost-regex1.65.1

It seems to be working ok on Ubuntu 18.10 now. Subject to further
testing of course. Will let you know.

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

Re: [GNC-dev] *.deb package for GnuCash 3.4 Released

[Colin Law]

On Sun, 30 Dec 2018 at 20:33, Stephen M. Butler  wrote:
>
> For those interested in a deb file but not willing to compile yourself:
> https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY -->
> gnucash_3.4-0-1_amd64.deb

I am trying this on Ubuntu 18.10 and when running it I get
error while loading shared libraries: libboost_regex.so.1.65.1: cannot
open shared object file: No such file or directory
Do you know whether there is a reasonably simple fix for this?

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

Re: [GNC-dev] Wiki Building Instructions Reorganization

[Colin Law]

I am away from home at the moment so haven't been able to follow exactly
what is proposed here, is the intention do remove the existing instructions
for building from source on Ubuntu [1] that are very clear and easy to
follow?

[1] https://wiki.gnucash.org/wiki/BuildUbuntu16.04

Colin

On Thu, 20 Sep 2018 at 06:28, David Cousens 
wrote:

> To all interested parties,
>
> As a first step to doing a restructure I decided to map (fairly roughly)
> the
> area of the wiki associated with Building GnuCash from Sources that was
> accessible from the main wiki Building GnuCash page in an attached
> Freeplane
> Mindmap  BuildingGnucashMap20180920.mm
> <
> http://gnucash.1415818.n4.nabble.com/file/t375329/BuildingGnucashMap20180920.mm>
>
> .  It is fairly instructive in illustrating the problem. (Freeplane and
> Freemind maps are not totally compatible as they diverged from a common
> source some time ago )
>
> I will construct a second mindmap to illustrate how I propose to
> restructure
> this section of the wiki and then post it in this thread for comment
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> 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
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Documentation Version Display

[Colin Law]

On Sat, 25 Aug 2018 at 15:11, Frank H. Ellenberger
 wrote:
>
> Am 25.08.2018 um 09:39 schrieb Colin Law:
> > On Sat, 25 Aug 2018 at 02:25, David T. via gnucash-devel
> >  wrote:
> >> ...
> >> I imagine most people would search for “gnucash help” or “gnucash 
> >> tutorial.”
> >
> > Actually I think the search is very likely to be something like
> > gnucash how to reconcile account
> > which will take one straight into the middle of the tutorial, hence
> > the need for the version on each page.
>
> No, the recent stable (3.2) is the only version indexed by google. We
> disallow indexing older versions because before the version with most
> links (i.e. 1.x) was listed first.

That does not conflict with what I said, the search will take the user
to the page.  He may not be using the latest version and does not know
that only the latest is indexed, so the page should indicate which
version it is for.

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

Re: [GNC-dev] Documentation Version Display

[Colin Law]

On Sat, 25 Aug 2018 at 02:25, David T. via gnucash-devel
 wrote:
> ...
> I imagine most people would search for “gnucash help” or “gnucash tutorial.”

Actually I think the search is very likely to be something like
gnucash how to reconcile account
which will take one straight into the middle of the tutorial, hence
the need for the version on each page.  I think new users may well
search for tutorial or help but once one gets going it is much more
likely to be a specific search, which may well be quicker than finding
the tutorial and looking for the right section.

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

Re: [GNC-dev] Documentation Version Display

[Colin Law]

Some applications handle this problem by inserting a prominent warning
at the top of each page of out of date documentation, see [1] for
example.  I assume they have some automatic way of doing this rather
than editing all the pages, so whether something like this could be
done without major effort I don't know.

Colin

[1]https://docs.influxdata.com/influxdb/v1.0/introduction/installation/
On Sat, 25 Aug 2018 at 02:25, David T. via gnucash-devel
 wrote:
>
> Adrien,
>
> That seems reasonable, too, although there was recently a long discussion 
> about which online document a user was viewing, suggesting that it’s not 
> always clear.
>
> As for “search juice,” I can’t possibly imagine how there would be a major 
> negative impact by adding “Gnucash v. 3.2” immediately prior the two document 
> titles—and I can’t imagine a search where this would negatively affect 
> results. Honestly, I imagine most people would search for “gnucash help” or 
> “gnucash tutorial.” Such a search presumably would be helped by this change, 
> rather than hurt by it. Not being privy to Google’s search algorithms, I 
> can’t say with authority, or course.
>
> I am opposed to removing these links altogether. As I noted elsewhere, 
> “current stable release” is not IMHO a universally-understood term. And, 
> while I haven’t mentioned it before, I personally find the grid of cryptic 
> icons lined up next to the document titles to be difficult to understand or 
> use. On my screen, they are far too small for me to process visually; of the 
> four in use, I only immediately recognize the PDF icon. The use of a tiny 
> earth icon for HTML help is neither intuitive to me, nor clear to discern. 
> Additionally, I am admittedly unfamiliar with either the Epub or Mobi formats 
> or icons; however, if the goal is to universally communicate the availability 
> of these formats, I don’t think this is the way. But I digress!
>
> The point is, these links clearly put the user into the online documents, 
> which I think is valuable.
>
> David
>
> > On Aug 24, 2018, at 6:30 PM, Adrien Monteleone 
> >  wrote:
> >
> > David,
> >
> > I agree the pages should have both the document title (per another thread) 
> > and the version either in the header or footer.
> >
> > But I can’t fathom clicking the ‘main’ documentation link and thinking that 
> > I’m getting anything other than the most current version. If I knew I was 
> > running an older version of the software and slightly down the page I see a 
> > link for documentation for that version, I’m going to grab that one 
> > instead, making a fairly safe assumption that the main link isn’t for me.
> >
> > The only solution I can think of for this situation is to remove those two 
> > links at the top of the page and users will then click the links for their 
> > chosen version. (with each already well labeled) Adding the version to 
> > those links is, to me, unnecessary clutter. (links should be as concise and 
> > accurately descriptive as possible, and changing that link text each 
> > release will reduce search juice for those links.)
> >
> > Regards,
> > Adrien
> >
> >> On Aug 24, 2018, at 12:03 PM, David T. via gnucash-devel 
> >>  wrote:
> >>
> >> John,
> >>
> >>
> >>> On Aug 24, 2018, at 10:57 AM, John Ralls  wrote:
> >>>
> >>>
> >>>
>  On Aug 24, 2018, at 5:51 AM, David T. via gnucash-devel 
>   wrote:
> 
>  Hello,
> 
>  Today, I had the opportunity to examine the online Help text, where I 
>  saw detailed information about the Transaction Report, which has 
>  recently changed radically. The information provided on the online Help 
>  clearly references the new version of this report, which I surmise 
>  because I am still running 2.6.21, and I do not have this version of the 
>  report.
> 
>  Here is the problem: there is no indication in the online resources 
>  (either in the document itself, or on Gnucash.org ) 
>  the version of GnuCash to which the documentation refers. This could 
>  lead to user confusion, as they see help that refers to functionality 
>  that they do not have.
> 
>  I am sure that the stock answer here will be: “GnuCash is currently on 
>  release 3.2, and therefore the documentation available at Gnucash.org 
>   reflects the current release.” I respect that.
> 
>  However, at any given time, there will be people who choose for one 
>  reason or another not to upgrade to the latest and greatest version—or 
>  more problematically, are unaware that they are not running the latest 
>  version. These users would benefit from being informed *somewhere* that 
>  the documentation that they are consulting is for a particular version. 
>  Is there some way to add the version number to the header of the 
>  documentation pages? (The footer is also an option, but is less 
>  preferable online since the footer 

Re: [GNC-dev] GnuCash Portable is no longer portable as of 3.x

[Colin Law]

On 5 July 2018 at 06:05, Wm via gnucash-devel  wrote:
> GnuCash Portable
> https://portableapps.com/apps/office/gnucash_portable
> is no longer portable as of 3.x

I think it would be useful if you detailed the problem a little so
others would not fall into the trap, or pointed us to a bug
description or something.

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

Re: [GNC-dev] Minor coding style discussion: C++ and comments

[Colin Law]

On 23 June 2018 at 23:49, John Ralls  wrote:
> ...
> For the record, I don’t care as long as all comments in a file use the same 
> style and a single commit is used to convert the comments in a particular 
> file and that commit has no other changes.

I cannot see the point in wasting time changing the format in existing
code. When it comes to understanding existing code, the comment format
will make no difference to any developer sufficiently experienced to
understand code as complex as gnucash.  In addition there is always
the slight possibility of accidentally changing code so possibly
introducing bugs.  Surely there are more important things to do.

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

Re: [GNC-dev] Proposed updates to Wiki Build / Change of subject

[Colin Law]

On 3 May 2018 at 08:23, jeffrey black  wrote:

> Seems Ubuntu has an inferiority complex about doing
> a NEW or REINSTALL (not update) over any version of it's previous self.
>

During the install when it asks where to install it select Something Else,
select the partition that you want to install it into (so the one
containing the old ubuntu), select Format and for the path use '/'.  That
will format that partition and put the new Ubuntu there.

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

Re: [GNC-dev] Proposed updates to Wiki Build#Ubuntu pages

[Colin Law]

On 27 April 2018 at 05:02, jeffrey black <beastmaster...@hotmail.com> wrote:

> On 04/26/2018 04:11 PM, Colin Law wrote:
>
> On 26 April 2018 at 22:04, jeffrey black <beastmaster...@hotmail.com>
> wrote:
>
>>
>> Somewhere along the way I corrupted a system image file installing all
>> of the dependencies.  As soon as I get caught up I am going to try to
>> un-install all of them and start from scratch. This time paying more
>> attention to any error messages.  Whatever I did affects most but; not
>> all of the the packages I have tried to install since.
>>
>
> What symptom are you seeing?  There is probably a simple fix.
>
> If apt is complaining then often
> sudo apt-get install -f
> will fix it.
>
> Colin
>
> It seems to be that the problem starts with 
> linux-image-extra-1.13.0-37-generic
> does not exist even though the system insists it is installed.  versions
> -36, -38, and -39 are intact.
>
> At this time I have to figure out how to actually put -37 back before I
> can proceed.  Or get Ubuntu to over look it and use -38 or -39.  dpkg seems
> to require it, so somewhere there is a configuration file I need to change.
>
Tell us what symptom you are seeing. Copy/paste the command that is giving
problems.

Colin



> --JEffrey Black M.B.A.
>
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Proposed updates to Wiki Build#Ubuntu pages

[Colin Law]

On 26 April 2018 at 22:04, jeffrey black  wrote:

>
> Somewhere along the way I corrupted a system image file installing all
> of the dependencies.  As soon as I get caught up I am going to try to
> un-install all of them and start from scratch. This time paying more
> attention to any error messages.  Whatever I did affects most but; not
> all of the the packages I have tried to install since.
>

What symptom are you seeing?  There is probably a simple fix.

If apt is complaining then often
sudo apt-get install -f
will fix it.

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

Re: [GNC-dev] GnuCash 3.0 wine versus Windoze 10

[Colin Law]

Gnucash runs better on a Linux system than it does on Windows.  My
understanding is that it is Linux s/w adapted to run on Windows.  So if you
want to run Ubuntu ( which is an excellent idea) then run GC natively on
that, not under wine.  You will be able to install gnucash from the
software manager, it will install a 2.x version not 3.x as that has not yet
worked its way into the repositories.

For recovering your data boot of a live Ubuntu DVD/USB stick and then you
will be able to copy the files off the disc onto another stick or network
drive.

Colin

On 18 April 2018 at 08:40, jeffrey black  wrote:

> Before I do something incredibly stupid, like I did in hard crashing my
> Windoze server because of a virus (IRS search miss-key, go figure), and
> the boot partitions seem to be non-repairable even though all data and
> programs are still on disk.  (And yes, I know stupid of me to not have a
> current backup).  I still have legacy apps with data stored internally
> that are not extractable without Windoze and without a reliable backup
> per partition, per drive, I am not going to touch those drives until I
> can find a way to recover everything.
>
> Can GnuCash 3.0 be run under Wine on Ubuntu Xenial?  3.0 has features
> that I need.  It wants to install on only my Windoze dives which I will
> not do until I have all of the data extracted. I have been unable to
> build 3.0 from source code.  (yes I know Mint is a better choice but;
> until I recover all of the data from Windoze I am not changing, Ubuntu
> is up and running, Hallelujah, on it's own dedicated drive).
>
> Second Question:  My laptop still has Windoze 10 home, so can I install
> GnuCash 3.0 on it and use it with Windoze GnuCash Version 2.6.19 data
> files on the server files which are still accessible via Ubuntu file
> share with Windoze 10?  Are the data files compatible?  I have 20+ years
> of data that I definitely can not afford to loose (think divorce).
>
> --JEffrey Black M.B.A.
>
>
>
> ___
> 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: DBI issue: Incorrect datetime value: '19700101000000'

[Colin Law]

On 19 January 2018 at 14:40, John Ralls  wrote:
>
> See https://bugzilla.gnome.org/show_bug.cgi?id=784623 
> .

In particular see the workaround in comment #20

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

Re: Call for testing: snap package

[Colin Law]

Which version of gnucash is it?

Colin

On 2 August 2017 at 10:40, Jacob Zimmermann via gnucash-devel
 wrote:
> Hi all,
>
> I have built a snap package of GNUCash and am seeking some feedback and
> testing. On Linux distros that support snap, the package can be
> installed using the following command:
>
> sudo snap install --beta gnucash-jz
>
> Builds for AMD64 and ARM are available.
>
> Regards,
> Jacob
>
> ___
> 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: [MAINT] Network Maintenance Wednesday, March 8 0830-1430 US/EST

[Colin Law]

On 8 March 2017 at 15:23, Derek Atkins  wrote:
> Alas, this maintenance is being postponed.  AT buried the wrong cable,
> so I have to wait for the correct cable to be re-buried.

I suppose it is some consolation for us in the UK to know that other
suppliers are as incompetent as OpenReach are over here :)

Colin

>
> I'll send another note when we attempt this another time.
>
> -derek
>
> Derek Atkins  writes:
>
>> Hi,
>>
>> My ISP is replacing a network cable tomorrow which will cause a network
>> disruption.  During the outage there will be no access to code, which
>> means gnucash's email, the email archive, wiki, or git master repo.
>>
>> The ISP tech is scheduled to arrive sometime between 8:30am and 12:30pm
>> US EST (1330-1730 UTC), and the process should take about 2 hours.
>>
>> Please let me know if you have any questions.
>>
>> Thanks,
>>
>> -derek
>>
>> PS: it's a fiber cable, which is why it takes so long.  They can put one
>> end on immediately, but they have to remove the old cable and then route
>> the new cable before they can install the second end.
>
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> 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: XML Parse error on Local Build

[Colin Law]

On 10 December 2016 at 13:33, Geert Janssens  wrote:
> ...
> I agree the complete details of autogen/configure/make are fairly complex. I
> don't even understand all of it myself. The complexity stems from the design
> idea to create a build system that's generic enough to build all kinds of
> objects (applications, libraries, documentation, websites, whatever) on as
> many different platforms as possible. Luckily we don't need all of this
> complexity for our purposes.
>
> Let me try to explain this top to bottom. The command we're ultimately
> interested in is 'make'. This command follows recipes to convert some source
> files into some end object(s). For gnucash this is a bunch of c and guile
> sources which are transformed into the gnucash application (which itself is
> composed of an executable and lots of libraries). There are lots of details
> I'm glossing over here, focusing mostly on the principles.
>
> For our docs plain make (without explicit target that is) does nothing,
> because the xml files are both the source and the target which yelp needs to
> display the docs.
>
> However aside from the main target one can also define alternative targets. A
> few spring to mind for the docs: html, pdf, mobi, epub, install. So one could
> run
> make pdf
> and make will search a recipe to build one or more pdf files, depending on
> which directory you execute the command in.
>
> 'install' is a special recipe that is intended to put whatever make built as
> primary target (the xml files in case of the docs, which are the same as the
> source xml files) in a special location where a typical unix system expects
> these files. For example, executables typically should be installed in
> /usr/bin on linux. This location can be overridden. I'll get back to this
> later.
>
> Where does make find all these recipes ?
> make looks for a file called Makefile in the current directory. Makefile holds
> the recipes and other configuration items. Unfortunately this file is very
> complex in itself because - as I said earlier - the build system is designed
> to work in very different environments.
> For example the location of all the tools needed to create targets from the
> source files (like xsltproc) may be installed in different locations on
> different platforms, or even have a different name (like xsltproc.exe in a
> Windows environment). Or some commandline options for certain tools may not
> be available on all platforms or versions of the tool. Manually coping with
> all these variations will quickly result in a mess.
>
> So to cope with this a configuration step was added to the build process. This
> step runs a very complicated script called "configure" that will analyze your
> system and actually creates the Makefile files I described above. configure
> will lookup installation location for all tools used and can enable or disable
> certain recipes in the Makefiles based on its findings. "configure" can also
> take extra commandline options that can alter what it will include in the
> Makefiles. You can see these options by running configure --help. Most of them
> are not relevant for us, except for the few we invented ourselves like
> --with-mobi.
>
> "configure" doesn't take Makefile's as input. Instead it will read files
> called Makefile.in, which is a pseudo Makefile with lots or variables that
> still need final setting.
>
> Still, writing a configure script and Makefile.in files remains very
> cumbersome and lots of information in both files comes back all the time in
> different projects. So yet another step was added before in the build system.
> This step is meant to generate the configure script and the Makefile.in files
> based on another set of files: configure.ac and Makefile.am files.
> These files encode the essence of configure and the final Makefiles, but with
> everything removed that can be detected by a smart configuration script. Only
> the details that matter and are unique for each project are retained in these
> files.
> Generating configure and the various Makefile.in files involve a few steps,
> but they are always the same, regardless of the platform you run them on. For
> this reason they are combined together in a small script called autogen.sh.
> This script itself is the platform independent and is used to initiate the
> whole build system for a given project.
>
> And that's the general idea behind the autotools based build system. Again I
> glossed over a lot of details.
>
> As a rule of thumb, autogen.sh should be called the first time you want to
> initialize the build system and sometimes when changes are made in
> configure.ac or the Makefile.am files. Frequently those changes are
> autodetected though. Calling autogen.sh when it's not necessary doesn't doe
> harm either way. The only side effect is that the first next build may take
> longer.
>
> The same goes for "configure". It should generally be called right after
> autogen.sh for the same 

Re: ROOT Type accounts

[Colin Law]

On 31 October 2016 at 06:39, David T. via gnucash-devel <
gnucash-devel@gnucash.org> wrote:

> OK, so I deleted these entries in the file. Now, when I open the file in
> GnuCash, the progress bar does a little "zippy back and forth” thing while
> loading the user data that I haven’t seen before. Also, there is new empty
> top level account with a guid as its name. This guid doesn’t appear in
> accounts, splits, or transactions, however. Not sure what to do differently.
>

If the extraneous root accounts were not doing any harm then I would just
leave them and not worry about it.

Colin


>
> Maybe it’s not important?
>
> David
>
> > On Oct 29, 2016, at 5:54 PM, Geert Janssens 
> wrote:
> >
> > On Saturday 29 October 2016 17:33:40 David T. wrote:
> >> OK, so I opened the SQLite file in GnuCash, went to the COA and
> >> selected Check and Repair All. No change, unfortunately.
> >>
> > Yes, that's what I meant - check & repair should be the place to handle
> > this, but it currently doesn't.
> >
> > I see the way I replied to you could be interpreted differently. Sorry
> > about that.
> >
> >> I will try removing the rows manually and see what happens! This, of
> >> course is on a copy of my real data file. ;)
> >>
> > Wise, very wise :)
> >
> > Geert
>
>
> ___
> 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: GnuCash backup

[Colin Law]

On 28 May 2016 at 09:19, Chris Good <chris.g...@ozemail.com.au> wrote:
>> -Original Message-----
>> From: Colin Law [mailto:clan...@gmail.com]
>> Sent: Saturday, 28 May 2016 5:24 PM
>> To: Chris Good <chris.g...@ozemail.com.au>
>> Cc: gnucash-devel <gnucash-devel@gnucash.org>
>> Subject: Re: GnuCash backup
>>
>> On 28 May 2016 at 01:44, Chris Good <chris.g...@ozemail.com.au> wrote:
>> > Hi,
>> >
>> > I've created a gui (JavaFX/OpenJFX) Java app for backing up GnuCash
>> > data to an encrypted 7-zip file in a 3rd party cloud storage directory
>> > (Dropbox/Google Drive/OneDrive).
>>
>> Does it do any more than zipping the file and saving it in the specified
>> directory?
>>
>> Colin
>
> Hi Colin,
>
> That's about it. What else would you like?

Nothing, it is just that to use a java app for that seemed rather
overkill so I wondered whether I was missing something, but I can see
that it could be useful for those who do not know how to write a
script to do that.

Cheers

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

Re: GnuCash backup

[Colin Law]

On 28 May 2016 at 01:44, Chris Good  wrote:
> Hi,
>
>
>
> I've created a gui (JavaFX/OpenJFX) Java app for backing up GnuCash data to
> an encrypted 7-zip file in a 3rd party cloud storage directory
> (Dropbox/Google Drive/OneDrive).

Does it do any more than zipping the file and saving it in the
specified directory?

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

Problems with make check and guile, apparently

[Colin Law]

I am having getting make check to pass for reasons unknown to me.  In
src/engine/test/test-suite.log I see


   GnuCash 2.6.12: src/engine/test/test-suite.log


# TOTAL: 27
# PASS:  24
# SKIP:  0
# XFAIL: 0
# FAIL:  3
# XPASS: 0
# ERROR: 0

.. contents:: :depth: 2

FAIL: test-test-extras
==

;;; note: auto-compilation is enabled, set GUILE_AUTO_COMPILE=0
;;;   or pass the --no-auto-compile argument to disable.
;;; compiling 
/home/colinl/apps/gnucash_git/src/engine/test/./test-test-extras.scm
;;; WARNING: compilation of
/home/colinl/apps/gnucash_git/src/engine/test/./test-test-extras.scm
failed:
;;; ERROR: no code for module (gnucash engine test test-extras)
Backtrace:
In ice-9/boot-9.scm:
 157: 17 [catch #t # ...]
In unknown file:
   ?: 16 [apply-smob/1 #]
In ice-9/boot-9.scm:
  63: 15 [call-with-prompt prompt0 ...]
In ice-9/eval.scm:
 432: 14 [eval # #]
In ice-9/boot-9.scm:
2401: 13 [save-module-excursion #]
4052: 12 [#]
1724: 11 [%start-stack load-stack ...]
1729: 10 [#]
In unknown file:
   ?: 9 [primitive-load
"/home/colinl/apps/gnucash_git/src/engine/test/./test-test-extras.scm"]
In ice-9/eval.scm:
 505: 8 [# (use-modules #)]
In ice-9/psyntax.scm:
1106: 7 [expand-top-sequence ((use-modules (gnucash engine test ...))) () ...]
 989: 6 [scan ((use-modules (gnucash engine test ...))) () ...]
 279: 5 [scan ((# #) #(syntax-object *unspecified* # #)) () (()) ...]
In ice-9/boot-9.scm:
3597: 4 [process-use-modules (((gnucash engine test test-extras)))]
 702: 3 [map # ((#))]
3598: 2 [# (#)]
2867: 1 [resolve-interface (gnucash engine test ...) #:select ...]
In unknown file:
   ?: 0 [scm-error misc-error #f ...]

ERROR: In procedure scm-error:
ERROR: no code for module (gnucash engine test test-extras)
FAIL test-test-extras (exit status: 1)

Followed by several other similar reports.  Having searched the list I
found suggestions to delete ~/.cache/guile/ccache but that did not
help, in fact I tried deleting ~/.cache/guile but again I still get
the error.  A few days ago make check was ok but I don't know what I
may have done to mess it up.  The only file modified (from the maint
branch) is gnc-backend-dbi.c which does not appear to be related to
the problem.

This is running on Ubuntu 16.04.

Any help will be much appreciated.

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

Re: Help with libdbi code

[Colin Law]

Given the question over the advisability of changing the db schema on
a minor release, with the associated issues of migrating the database
and so on I have reverted to plan A and written code to modify the
session sql_options each time we connect to the server.  A pull
request will be generated shortly.  As this is the first non-trivial
code I have contributed no doubt I will have contravened a number of
conventions, which I will happily sort out as they are raised.

On the issue of testing, is it necessary to extend the tests to cover
this?  The only area I can see that could be easily tested is the code
that removes the NO_ZERO_DATE option from the options string.  I have
tested that thoroughly with a simple test harness, testing strings
with the option missing, with it at the start, end and middle of the
string and with an that option as a substring of another option (not
likely to happen I know).  One should probably bear in mind that this
code will likely not be required on the next major release, assuming
that the database schema is updated instead.

Off topic;
I have not used C for several years and had forgotten what hard work
it is working with strings. When I first met C at the end of the 70's
it was a revelation and I used it and later C++ for many years, but
now it does seem tedious.  I still have my orginal Kernighan and
Ritchie which I remember reading from cover to cover whilst waiting
with great anticipation for my C compiler to arrive.  Recently I have
been using Ruby and the method in the pull request to remove the
option from the option string could be written in Ruby as something
like

new_options = (options.split(',') - ["NO_ZERO_DATE"]).join(',')

It would no doubt take very much longer to execute, but nowadays that
is often of little consequence.  Of course C/C++ does have numerous
advantages over languages such as Ruby, particularly when it comes to
large systems such as GnuCash.

Regards

Colin

On 7 May 2016 at 22:14, Colin Law <clan...@gmail.com> wrote:
> On 7 May 2016 at 21:44, Colin Law <clan...@gmail.com> wrote:
>> ...
>> I am running with
>> type_name = "TIMESTAMP NULL";
>> and have not found any problems so far.
>>
>
> On further investigation I am getting errors.  When I attempt to save
> as mysql I get
> CRIT  [mysql_error_fn()] DBI error: 1067: Invalid
> default value for 'date_closed'
> This is related to gnc-order-sql.c line 64.  I suspect the orders
> table does not use BCT_DATETIME for its column definitions.
>
> Will investigate further tomorrow.
>
> Colin
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Strange issue with ChangeLog in git

[Colin Law]

On 9 May 2016 at 15:07, John Ralls  wrote:
> ...
> Running make updates the changelog. It's a good reason to build out-of-source.

Ah, that explains it.  Many thanks.

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

Strange issue with ChangeLog in git

[Colin Law]

I have a very strange issue with the file ChangeLog in git.  Around a
week ago I forked the git repo and started a branch off maint for some
development.  Now when I look at the changes between my working copy
and the repository I find that somehow a chunk has been added to the
start of ChangeLog in my working copy.

My copy of ChangeLog starts
2016-04-10 Per Johansson
* Added new sv_AX and sv_FI account plans. (HEAD -> maint, origin/maint)

Then there are number of entries and then
2016-03-24 Geert Janssens
* Bug 693342 - Print (bottom) prints to middle for 3-check pages

Whereas the version in the git repository has not got the first
entries at all, and starts with
 2016-03-24 Geert Janssens
* Bug 693342 - Print (bottom) prints to middle for 3-check pages
(HEAD, origin/maint, maint)

There is no way that I added the extra lines so I am completely at a
loss to understand what is going on.

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

Re: Help with libdbi code

[Colin Law]

On 7 May 2016 at 21:44, Colin Law <clan...@gmail.com> wrote:
> ...
> I am running with
> type_name = "TIMESTAMP NULL";
> and have not found any problems so far.
>

On further investigation I am getting errors.  When I attempt to save
as mysql I get
CRIT  [mysql_error_fn()] DBI error: 1067: Invalid
default value for 'date_closed'
This is related to gnc-order-sql.c line 64.  I suspect the orders
table does not use BCT_DATETIME for its column definitions.

Will investigate further tomorrow.

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

Re: Help with libdbi code

[Colin Law]

On 7 May 2016 at 16:47, Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:
> On Saturday 07 May 2016 16:23:56 Colin Law wrote:
>> ...
>> Can we be sure, though, that nowhere does the code
>> explicitly write 0 (as opposed to not asking for anything to be
>> written, so the default is written)?
>
> Good question. I haven't searched thoroughly through the code yet. However
> one spot that may cause this is gnc_dbi_safe_sync_all in gnc-backend-dbi.c
> line 1642. If there is a 0 timestamp somewhere in the DB, I assume it will
> plainly copy it. Of course this depends on whether some other code actually
> does write 0 timestamps. I haven't had time yet to search where timestamps
> are written or whether it's special cased somewhere in the backend code or
> anything.
>
> From the trace file however there's good hope that gnucash prefers to write
> NULL for an invalid timestamp, at least that's what it does for the slot
> table there.

Under what circumstances is that code called?

>
>> I could not find anything in the libdbi docs that explicitly says what
>> happens when a field containing NULL is fetched. I presume it is
>> going to return 0 however, so that should be OK.
>
> No, a NULL value in the database is explicitly tested for in
> gnc-backend-dbi.c line 2108. In that case gnucash will internally continue
> with NULL. So this situation appears to be taken into account.

Where the final NULL is a c NULL, so zero, of course.  So yes that should be ok.

>> The other area I can think of where this could cause problems is if
>> anywhere in the code issues a query specifying date <> 0 or > 0 or = 0
>> or other similar operation. These would have to be changed to IS NOT
>> NULL etc.
>
> True. I doubt gnucash does that already though. Gnucash reads the whole db
> in memory at load time and does all querying in-memory. It just writes back
> any change as well. Those write-backs typically use the guid to find the
> proper row in any table, not a timestamp.

I had forgotten that gnucash just reads the complete db in at startup.
I can see that means that probably there is no complex querying.

I am running with
type_name = "TIMESTAMP NULL";
and have not found any problems so far.

Should make check work?  I find that even before I make the change I am getting
 /qof/gnc-date/qof print date dmy buff:   FAIL
GTester: last random seed: R02Sed570872cf591664699ffdaa1320d1f4
/bin/bash: line 1: 17264 Terminated  MALLOC_CHECK_=2
MALLOC_PERTURB_=$((${RANDOM:-256} % 256)) gtester --verbose test-qof

Do I have to do anything special to get the database tests to run?  I
see a configure option  --with-test-mysql-url=URL.  Do I have to set
that up?  If so what is the format please?

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

Re: Help with libdbi code

[Colin Law]

On 7 May 2016 at 15:56, John Ralls  wrote:
> ..
> Try changing gnc-backend-dbi.c line 2702 from
> type_name = "TIMESTAMP NULL DEFAULT 0";
> to
> type_name = "TIMESTAMP NULL DEFAULT NULL";
>

I don't think it is necessary to specify DEFAULT NULL as that is the default.

Well That does prevent the error and nothing else undesirable seems to
be happening.  Can we be sure, though, that nowhere does the code
explicitly write 0 (as opposed to not asking for anything to be
written,  so the default is written)?

I could not find anything in the libdbi docs that explicitly says what
happens when a field containing NULL is fetched.  I presume it is
going to return 0 however, so that should be OK.

The other area I can think of where this could cause problems is if
anywhere in the code issues a query specifying date <> 0 or > 0 or = 0
or other similar operation.  These would have to be changed to IS NOT
NULL etc.

Regards

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

Re: Help with libdbi code

[Colin Law]

On 7 May 2016 at 12:01, John Ralls <jra...@ceridwen.us> wrote:
>
>> On May 7, 2016, at 6:22 AM, Colin Law <clan...@gmail.com> wrote:
>>
>> On 7 May 2016 at 10:09, Geert Janssens <geert.gnuc...@kobaltwit.be> wrote:
>>> ...
>>> I'm not sure you need to do this when connecting to the mysql database (not
>>> table) and before creating the new database. At that point there is no data
>>> in the new database so there can't be any NULL in a date field either.
>>>
>>> On the other hand it may be that you do have to do this if MySQL already
>>> complains when writing the DB schema which I consider unlikely (yet not
>>> impossible).
>>
>> I believe that it is necessary as the initial problem is encountered
>> when creating the database as one of the date fields has a default
>> value of zero.  In fact I have not found a case where the no_zero_date
>> option causes a problem other than when creating a new database, but I
>> have not tried very hard.  I had wondered whether an alternative
>> strategy of not providing a default value, but allowing the date to be
>> null in the database instead was possible, but I gather that would
>> involve significant work.  In addition it would cause problems when
>> upgrading gnucash as old databases would no longer be compatible.
>
> Hmm, the trace files from the bug report seemed to show that the error was 
> from saving a slot row with a 0-valued date rather than from creating a table 
> with a default value of 0.

No doubt you are right (again), it is probably not the actual creation
but the writing that is the issue.  Me jumping to conclusions again.
I will investigate whether it is necessary to change the options for
creating the db.

>
> The only issue with schema changes is that they make the database 
> incompatible between GnuCash versions. I agree that it's dumb to declare a 
> date field NOT_NULL and then store 0 in it. It was also my (apparently 
> mis-)understanding that NO_ZERO_DATE also meant no NULL dates. If that's not 
> the case and we can work around the schema change issue (easy if it really is 
> just during DB creation) then that's a better way to address the problem.

I suggest I go ahead with changing the options as it will be a very
localised change with little chance of side effects so would be ok in
the next minor release.  Changing the schema to use null rather than
zero could have unexpected side effects and it would be difficult (I
imagine) to be certain that there was not a bit of code somewhere that
had been missed, that needed to be changed.

Regards

Colin

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

Re: Help with libdbi code

[Colin Law]

On 7 May 2016 at 10:09, Geert Janssens  wrote:
> ...
> I'm not sure you need to do this when connecting to the mysql database (not
> table) and before creating the new database. At that point there is no data
> in the new database so there can't be any NULL in a date field either.
>
> On the other hand it may be that you do have to do this if MySQL already
> complains when writing the DB schema which I consider unlikely (yet not
> impossible).

I believe that it is necessary as the initial problem is encountered
when creating the database as one of the date fields has a default
value of zero.  In fact I have not found a case where the no_zero_date
option causes a problem other than when creating a new database, but I
have not tried very hard.  I had wondered whether an alternative
strategy of not providing a default value, but allowing the date to be
null in the database instead was possible, but I gather that would
involve significant work.  In addition it would cause problems when
upgrading gnucash as old databases would no longer be compatible.

Regards

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

Re: Help with libdbi code

[Colin Law]

On 6 May 2016 at 22:38, John Ralls <jra...@ceridwen.us> wrote:
>
>> On May 6, 2016, at 5:29 PM, Colin Law <clan...@gmail.com> wrote:
>>
>> I don't fully follow what you are saying
>> about SUPER privileges, but will go away and think about it some more.
>
> See the bit in 
> http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-setting about 
> GLOBAL vs. SESSION mode.

I don't need to set the global values, just the session, in fact I
must not set the global settings as that would affect other users and
applications.  I mis-spake when I said I needed to adjust the settings
before connecting to the database, that assertion was made on the
assumption that the code connected to the server and then to the
database.  Now that I understand that is not the case I understand why
it connects to the mysql table before creating the gnucash database,
connecting to the mysql table is a means of getting round the problem
that one cannot simply connect to the server and create a db.  In fact
what I need to do is, in the case where the database exists, adjust
the session settings after connecting to the db but before using it,
and in the case where the db does not exist adjust the settings after
connecting to the mysql table but before creating the new database.  I
guess I will then have to do it again when connecting to the new
database as this will be a new session.

Thanks again for the help.

Colin

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

Re: Help with libdbi code

[Colin Law]

On 6 May 2016 at 22:13, John Ralls <jra...@ceridwen.us> wrote:
>
>> On May 6, 2016, at 11:17 AM, Colin Law <clan...@gmail.com> wrote:
>>
>> I want to add some code to adjust the mysql sql_options if necessary,
>> in order to avoid bug #765872 [1].  I believe that this needs to be
>> called from gnc-backend-dbi.c in gnc_dbi_mysql_session_begin.  I need
>> to adjust the options after the mysql connection is made but before
>> the database is opened (since I need to do it before creating the
>> database in the case that the database does not already exist).  I
>> thought that I should do it before the call to dbi_conn_error_handler
>> at line 867 (maint branch) but cannot get it to work there.  If,
>> however, I put it after the line
>> result = dbi_conn_connect( be->conn );
>> then (provided the database already exists) it does work.
>>
>> The failing code is
>>
>>result = dbi_conn_query( connection, "SELECT @@sql_mode");
>>
>> If the database has not been opened then this returns NULL, but when I
>> then call dbi_conn_error this returns 0, which seems odd. The error
>> message is also empty.
>> If I run the SELECT query from the mysql command line before opening a
>> database then it works correctly.
>> Can anyone point out where I am going wrong?
>>
>
> Colin,
>
> If you've got dbi_conn_error_handler() at line 867 you're looking at the 
> master branch (it will be gnc-backend-dbi.cpp unless you have an old commit). 
> It's at line 841 in maint.

Yes, you are right, I looked at the wrong file to get the line number,
I am actually working with the right file.  I couldn't get the line
number from my working copy as I have inserted the function to do the
changes above that point.  Sorry for the confusion.

>
> Yes, of course it needs to go after dbi_conn_connect: That's what connects to 
> the server. Up to that point you're just talking to the dbi driver.

Ah, I misunderstood, I assumed that dbi_conn_new_r connected to the
server.  I will have to go and look at the docs more carefully.

>  Look at the DB creation code a little further down to see how to connect to 
> the server without connecting to a database, but notice that you'll have to 
> disconnect and reconnect with the database when you're finished. That means 
> that either you set the sql_mode with the database connected--and it sounds 
> from above like that works--or you permit the gnucash user to have SUPER 
> privilege, which I think would be a tough sell if the server is also being 
> used for other things.

Thanks, I will look at that.  I don't fully follow what you are saying
about SUPER privileges, but will go away and think about it some more.

Thanks

Colin

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

Help with libdbi code

[Colin Law]

I want to add some code to adjust the mysql sql_options if necessary,
in order to avoid bug #765872 [1].  I believe that this needs to be
called from gnc-backend-dbi.c in gnc_dbi_mysql_session_begin.  I need
to adjust the options after the mysql connection is made but before
the database is opened (since I need to do it before creating the
database in the case that the database does not already exist).  I
thought that I should do it before the call to dbi_conn_error_handler
at line 867 (maint branch) but cannot get it to work there.  If,
however, I put it after the line
result = dbi_conn_connect( be->conn );
then (provided the database already exists) it does work.

The failing code is

result = dbi_conn_query( connection, "SELECT @@sql_mode");

If the database has not been opened then this returns NULL, but when I
then call dbi_conn_error this returns 0, which seems odd. The error
message is also empty.
If I run the SELECT query from the mysql command line before opening a
database then it works correctly.
Can anyone point out where I am going wrong?

Thanks

Colin

[1] https://bugzilla.gnome.org/show_bug.cgi?id=765872
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Recommendations on Coding programs

[Colin Law]

On 18 October 2015 at 00:06, Matt Graham  wrote:
> G’day all,
>
> Now that I finally have myself set up to be able to view, edit and test the 
> gnucash sources, I have come across the limitation of using text editors 
> (using nano at the moment...) to code. Can anyone recommend a good program 
> for doing coding for Gnucash? I’m mainly looking at the C side of things 
> rather than guile, but a program that can do multiple types of code would be 
> useful. Preferably ones that are supported on both windows and linux.

I like jEdit which is available on Win and Linux.

Colin

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

Re: Help finding files to move to new PC

[Colin Law]

On 20 September 2015 at 20:49, Joe Chando  wrote:
> I had a hardware failure (motherboard) so all data should be OK,  I had used
> checking.gnucash as the file name (or so I thought) that was stored in a
> checking account folder.
> When I moved the files to the new PC all the data appears to be there except
> that everything is listed by it's sub account, there is no longer a top
> level account.

This sort of question should really be asked on the gnucash-user list
rather than the development list (which is for discussion of the s/w
development).  I suggest you ask it there.  However I am not sure
exactly what you mean but perhaps if you do View > New Accounts Page
it will help.  If not then ask there and give a bit more detail on
exactly what you see.

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

Re: web link busted?

[Colin Law]

On 24 February 2015 at 03:46, Stone Creek Ranch
stonecreekra...@gmail.com wrote:
 Seems like your link to download 2.6.5 maintenance release for Windows
 platform is broken.  You may want to review it.  Maybe it's just security?

 http://www.gnucash.org/download.phtml

 http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.5-setup.exe

It's ok here, what exactly to you mean by broken?  Perhaps it was just
a temporary issue with sourceforge access.

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

Re: Fun with Git

[Colin Law]

On 10 February 2015 at 05:36, David T. sunfis...@yahoo.com wrote:
 Thanks for the leads. I have been reading, but the descriptions of how it’s 
 supposed to work aren’t matching my experience. Specifically, the manuals all 
 talk about pushing changes onto the repository—but I don’t have push 
 capabilities with the gnucash-docs repository. Thus, when I get errors about 
 needing to push my changes, I don’t know how to get out of the situation. My 
 realm is “3 ahead”, and I cannot figure out how to proceed. I followed the 
 prompts that said to stash my changes, but now I can’t locate the changes I 
 want to submit for bug 693156. I see the changes in the files on my hard 
 drive, so I know they are there, but for the life of me, I can’t figure out 
 how to get git to get them.

To pick up your stashed changes again use
git stash apply
See http://git-scm.com/book/en/v1/Git-Tools-Stashing for a users
friendly discussion of stashing.

I don't know about your other question.  Are you supposed to push them
at all or are you just supposed to do your work on a local branch on
your PC and send off the patches for those with permissions to push?

Colin


 David

 On Feb 9, 2015, at 12:44 AM, Colin Law clan...@gmail.com wrote:

 On 8 February 2015 at 22:35, John Ralls jra...@ceridwen.us wrote:

 On Feb 7, 2015, at 3:41 PM, David T. sunfis...@yahoo.com wrote:

 OK, so, I am now duly anointed with Just Enough Knowledge in the GnuCash 
 documentation procedures to be dangerous. Woe is unto the Devel mailing 
 list, as I have run into a couple of Problems.

 Simply put, I have edited a number of sections in the Guide in response to 
 a number of bugs. I turned in a patch for one of those bugs (634181), but 
 I have other changes that I would like to send in. The patches affect 
 ch_oview.xml and ch_basics.xml. Following the commands in the wiki (git 
 commit -a) suggested that I was going to get a patch with all the changes 
 to both files, but I just wanted one file at a time. I tried “git commit 
 ch_oview.xml”, which seemed to set me up to create the one file patch, but 
 when I issue the next command prescribed in the wiki (“git pull —rebase”), 
 I get the following:

 dht-retina:C david$ git pull --rebase
 Cannot pull with rebase: You have unstaged changes.
 Please commit or stash them.

 I do not know how to proceed from this.

 Now it’s time for you to get dangerous with git. Github has a nice 
 collection of resources at 
 https://help.github.com/articles/good-resources-for-learning-git-and-github/;
  there’s also Scott Chacon’s excellent book at 
 http://git-scm.com/documentation.

 I also highly recommend Atlassian’s free (as in beer) Git GUI SourceTree 
 http://www.sourcetreeapp.com/ which makes tailoring commits really easy.

 The immediate answer to your question is `git add`: Use that to put 
 individual files into the index and `git commit` *without* the -a to commit 
 just the files in the index. You can use `git status` to show which files 
 are changed and which files are already in the index.

 Also I recommend git gui which shows a graphical interface showing the
 changes you have made allows you to mark the ones you want to commit
 and commit them.  Also gitk is nice for seeing the history.

 Colin


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

Re: Fun with Git

[Colin Law]

On 8 February 2015 at 22:35, John Ralls jra...@ceridwen.us wrote:

 On Feb 7, 2015, at 3:41 PM, David T. sunfis...@yahoo.com wrote:

 OK, so, I am now duly anointed with Just Enough Knowledge in the GnuCash 
 documentation procedures to be dangerous. Woe is unto the Devel mailing 
 list, as I have run into a couple of Problems.

 Simply put, I have edited a number of sections in the Guide in response to a 
 number of bugs. I turned in a patch for one of those bugs (634181), but I 
 have other changes that I would like to send in. The patches affect 
 ch_oview.xml and ch_basics.xml. Following the commands in the wiki (git 
 commit -a) suggested that I was going to get a patch with all the changes to 
 both files, but I just wanted one file at a time. I tried “git commit 
 ch_oview.xml”, which seemed to set me up to create the one file patch, but 
 when I issue the next command prescribed in the wiki (“git pull —rebase”), I 
 get the following:

 dht-retina:C david$ git pull --rebase
 Cannot pull with rebase: You have unstaged changes.
 Please commit or stash them.

 I do not know how to proceed from this.

 Now it’s time for you to get dangerous with git. Github has a nice collection 
 of resources at 
 https://help.github.com/articles/good-resources-for-learning-git-and-github/; 
 there’s also Scott Chacon’s excellent book at 
 http://git-scm.com/documentation.

 I also highly recommend Atlassian’s free (as in beer) Git GUI SourceTree 
 http://www.sourcetreeapp.com/ which makes tailoring commits really easy.

 The immediate answer to your question is `git add`: Use that to put 
 individual files into the index and `git commit` *without* the -a to commit 
 just the files in the index. You can use `git status` to show which files are 
 changed and which files are already in the index.

Also I recommend git gui which shows a graphical interface showing the
changes you have made allows you to mark the ones you want to commit
and commit them.  Also gitk is nice for seeing the history.

Colin

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

Re: Lost data

[Colin Law]

On 8 February 2015 at 13:44, Gill Pyrah gillpy...@gmail.com wrote:

Please use Reply All or Reply List when replying to list messages
otherwise the message goes (as this one did) only to the poster you
are replying to.  I am forwarding it to the list.

 Hi Colin thanks for your response, which, strangely (perhaps because of
 monitoring?) only arrived with me today.

Your original post only arrived with me today, I have absolutely no idea why.


 The bin was within Gnucash.

I did not know that GC had a bin.  How do you access it?

 I found that by copying and pasting every
 individual coded item into the main accounts file I could recover it in
 usable form. But there were hundreds of items and it took a couple of days.
 It wasn't possible (as far as I could see) to copy, reinstate or move them
 all at once.

Were you not aware that GC automatically keeps backups of the accounts
file each time you save it?  All you had to do was to pick up the
latest backup and you would have been back at the point when you last
saved it.

 Now my problem is, when the time comes to send a copy of my year's accounts
 file to my accountant's portal, in a form he can use (to open splits, etc),
 how do I do it? I simply dare not risk exporting the data and loosing the
 whole lot once I've been using Gnucash for a year.

It is very simple, all you have to do is to save a copy of your
accounts file before doing the operation.  Then you can copy that file
back if it all goes wrong.  In fact since, as I said earlier,
automatic backups are taken then even this is not really necessary.
But do you not keep backups of you file anyway?  Particularly since
the problem you encountered.  Remember that a hard disk or computer
can go up in smoke at any time (literally or metaphorically).  If that
happened and you have not got a backup (at least on another machine or
CD, and preferably off site) then you could loose all your data with
little hope of recovery.  The same is true of all the other documents,
photos and so on that are on the machine.

 I asked a friendly computer geek (who hadn't seen Gnucash before) whether he
 could work it out but he couldn't - and also didn't want to risk exporting
 everything to the bin.

Not much of a geek if he did not suggest taking a backup of the
accounts file first.

 My system is Windows 8.

Sorry to hear that, you have my sympathies.

 Any advice very welcome.

Switch to Ubuntu?

Colin

 Thanks, Gill

 On 8 February 2015 at 13:35, Colin Law clan...@gmail.com wrote:

 On 14 October 2014 at 14:01,  gillpy...@gmail.com wrote:
 
 
 
 
  Trying to export data to accountants accidentally lost it all to “bin”
  and though I can see every item as a few KB each, can’t copy or highlight
  all to retrieve. Somehow I’ve got two entries back but thousands are still
  in the bin. Please help! I have tried going to “import” and got back to the
  bin, just can’t pick the info up.

 I, for one, have little idea what you mean.  Exactly what have you
 lost?  Do you mean you have lost your main accounts file?  What
 exactly do you see in the bin and which bin are you talking about?

 Also which operating system are you using (Win 7 or whatever) which
 version of gnucash?

 Colin



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

Re: Future direction: reports founded on SQL repository.

[Colin Law]

On 5 February 2015 at 22:29, Allen S. Rout a...@ufl.edu wrote:


 I've seen several references here to the policy direction that SQL
 (-lite or my-, or otherwise) will be the future preferred datastore.

 Associated with these, there are discussions that the future of
 reporting interfaces will likely be through some flavor of reporting
 tool founded on the SQL interfaces.

 There are FAQ entries which discourage SQL backend uses for most users.

In case it is of interest I use the xml format day to day then at the
end of each month I Save As to mysql to generate an up to date sql db
and then return to the xml file.  Then I run my SQL reports against
the db.  That would not work if you need to do reports on a day to day
basis of course.

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

Re: An eclectic approach for collaborative GnuCash

[Colin Law]

On 21 June 2014 19:32, Emmanuel Florent emmanuel.flor...@gmail.com wrote:
 Once would like a multi-user Gnucash without the SGDB/VPN setup nightmare.
 Dream...
 The goal is to work on books on multiple computers and with multiple users.
 I've a proposal for a Python script that take a Gnucash xml file,
 convert it to post request on a REST service.
 Then using the same process it can pull down data to merge an xml file
 from the nosql db.
 To get an idea of the whole thing from a programmer view,
 here are the  unit test:
 http://bazaar.launchpad.net/~emmanuel-florent/flowzr/trunk/view/head:/gcs-client/gnucash_test.py

 What do you think of this off-topic proposal ?
 Would you have achieved the same goal differently ? How ? Why ?

Will this problem not be solved by the planned (eventually) completion
of the sql interface which will mean that the s/w will interact
directly with the database rather than reading it all into memory?
Then multiple users can connect to the db at once.  This is a major
piece of work however.

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

Re: An eclectic approach for collaborative GnuCash

[Colin Law]

Please use Reply To or Reply All when replying to posts on the list,
otherwise your reply only goes to the original sender.  Copying your
message here.

On 23 June 2014 11:05, Emmanuel Florent emmanuel.flor...@gmail.com wrote:
 Well when that'll be done, a problem will remain:
 - setting a SGDB on a LAN,

Yes, you would need to setup a  mysql or postgres server, which is not
a major exercise.

 - setting a up a VPN,

Not necessary, just use an ssh tunnel to securely access the server.

 It can be solved. xTuple for example does that with an installer +
 postgresql on the cloud.
 But it remain impossible to work if you are on a train, on a flight
 for example...

That would work with an ssh tunnel, I believe.

However, once the database work is complete then a further extension
could be to add a REST interface to gnucash so that a web application
could be provided.  That would allow easy web-based access.

Colin


 Bgrds

 EF

 2014-06-23 8:00 GMT+01:00 Colin Law clan...@gmail.com:
 On 21 June 2014 19:32, Emmanuel Florent emmanuel.flor...@gmail.com wrote:
 Once would like a multi-user Gnucash without the SGDB/VPN setup nightmare.
 Dream...
 The goal is to work on books on multiple computers and with multiple users.
 I've a proposal for a Python script that take a Gnucash xml file,
 convert it to post request on a REST service.
 Then using the same process it can pull down data to merge an xml file
 from the nosql db.
 To get an idea of the whole thing from a programmer view,
 here are the  unit test:
 http://bazaar.launchpad.net/~emmanuel-florent/flowzr/trunk/view/head:/gcs-client/gnucash_test.py

 What do you think of this off-topic proposal ?
 Would you have achieved the same goal differently ? How ? Why ?

 Will this problem not be solved by the planned (eventually) completion
 of the sql interface which will mean that the s/w will interact
 directly with the database rather than reading it all into memory?
 Then multiple users can connect to the db at once.  This is a major
 piece of work however.

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

Re: private-kvp merge reverted other changes since November.

[Colin Law]

On 13 May 2014 18:39, Mike Alexander m...@umich.edu wrote:
 ...
 In the other direction, I think that once a topic branch is merged to master 
 it should be abandoned (unless it is used to fix bugs in the stuff that was 
 just merged).  A new topic branch should be created for subsequent changes, 
 even if they are related to the changes that were just merged (such as the 
 same changes to a different part of the code).  I'm not sure if this is what 
 you're suggesting or not, but it would seem to avoid a ladder appearance (if 
 I know what you mean by that).

Working with git in the past I have considered that topic branches
should be as short lived as possible.  A piece of work should be
broken into a number of self contained chunks and each one done on a
branch, merged back to trunk, and left.  The next chunk being started
on a new branch.  Of course this is not always possible as sometimes
major changes are required which must all be done before the s/w
reaches a new consistent state.  In that case merging will always be
tricky.

Colin

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

Re: private-kvp merge reverted other changes since November.

[Colin Law]

On 13 May 2014 21:09, John Ralls jra...@ceridwen.us wrote:

 On May 13, 2014, at 10:39 AM, Mike Alexander m...@umich.edu wrote:

 On May 13, 2014, at 11:47 AM, John Ralls jra...@ceridwen.us wrote:

 Yeah, it would be silly to merge after every commit. One strategy might be 
 to frequently merge from master and then revert the merge if there are no 
 conflicts. ISTM that relying on rerere in the face of ongoing development 
 on both branches risks replaying what was the right answer with last week's 
 code but isn't with this week's, so if there are conflicts resolved in the 
 merge it stays so that new code builds on the resolved result rather than 
 continuing to diverge.

 I think merges into master should happen for every module (e.g. gncguid, 
 gncdate) so that conflicts coming into master are limited to a single 
 subject. That should make it a bit easier for the person doing the merge to 
 keep track of which way to resolve the conflicts.

 That will still produce a ladder appearance in gitk and friends. I don't 
 find that objectionable, but apparently some people do.

 I agree that merging master into topic branches frequently is a good idea.  
 I have a long running branch where I do all my real work and merge master 
 into it often.  This seems to work well.  I've also created more short lived 
 topic branches and used them like this.

 In the other direction, I think that once a topic branch is merged to master 
 it should be abandoned (unless it is used to fix bugs in the stuff that was 
 just merged).  A new topic branch should be created for subsequent changes, 
 even if they are related to the changes that were just merged (such as the 
 same changes to a different part of the code).  I'm not sure if this is what 
 you're suggesting or not, but it would seem to avoid a ladder appearance (if 
 I know what you mean by that).

 It’s not. I see no reason to abandon a branch just because it’s merged into 
 master, and if you really have a long-running branch where you do all of your 
 work, neither do you. It won’t avoid the ladder look, either. There will just 
 be a bunch of shortish branches instead of one long one.

If you want to work in that way I suggest having a look at git rebase.
 Rather than merging the branch into master this effectively moves the
base of the branch along to the current master and makes the tree look
much simpler.

Colin

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

Re: Fix for dbi_initialize crash if libdbi = 0.9.0 (notably on Ubuntu 14.04)

[Colin Law]

On 5 May 2014 23:18, John Ralls jra...@ceridwen.us wrote:

 On May 5, 2014, at 5:33 PM, Colin Law clan...@gmail.com wrote:

 On 5 May 2014 21:45, John Ralls jra...@ceridwen.us wrote:
 ...
 It's because dbi_initialize_r() is the only function that needs to write to 
 the dbi_instance; everything else just reads it. That makes managing the 
 memory the application's job and allows other approaches than allocating it 
 on the heap, including the static allocation that Moritz chose to use in 
 his implementation. The _r suffix to the function name is analogous to 
 gmtime_r, localtime_r, etc. which take a struct tm* from the caller instead 
 of using a static in the library code. Making the rest of the functions use 
 pass-by-copy saves a multi-threaded program from having to synchronize 
 their calls, though using const dbi_inst* instead would have allowed for 
 cleaner semantics when they choose to put it on the heap.

 That makes sense, though the fact that two users separately got the
 interface wrong does make one wonder whether it is ideal.  It also
 does not help that it is actually defined as void* or something
 similar so the compiler was not able to identify that the original
 call to initialize was wrong (I think, I have not looked at it in
 detail).

 Of course it's not ideal, but it's the best one can do without proper 
 constructors that are part of the language. In C++ one can simply have

   static DbiInstance dbi_inst = DbiInstance();

 The compiler does more or less the same thing that dbi_initialize_r() does, 
 but hides the gory details so that the programmer has to go out of his way to 
 screw it up. As a consequence the compiler can be very strict about void*: 
 The programmer has to explicitly declare or cast a parameter to void* in the 
 function call or get a warning.

The problem with the original code (which caused the runtime crash)
was that, because dbi_inst is defined as a void* the compiler was
unable to flag an error when a dbi_inst itself was passed as a
parameter instead of dbi_inst.  It is a long time since I wrote any C
(as opposed to C++) and you are right that one forgets how much easier
it was to make such errors.  I wonder why dbi_inst is a void* rather
than a struct* as presumably it does point to a struct of some sort.

Colin

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

Re: Fix for dbi_initialize crash if libdbi = 0.9.0 (notably on Ubuntu 14.04)

[Colin Law]

On 6 May 2014 13:09, John Ralls jra...@ceridwen.us wrote:

 On May 6, 2014, at 3:41 AM, Colin Law clan...@gmail.com wrote:

 On 5 May 2014 23:18, John Ralls jra...@ceridwen.us wrote:

 On May 5, 2014, at 5:33 PM, Colin Law clan...@gmail.com wrote:

 On 5 May 2014 21:45, John Ralls jra...@ceridwen.us wrote:
 ...
 It's because dbi_initialize_r() is the only function that needs to write 
 to the dbi_instance; everything else just reads it. That makes managing 
 the memory the application's job and allows other approaches than 
 allocating it on the heap, including the static allocation that Moritz 
 chose to use in his implementation. The _r suffix to the function name 
 is analogous to gmtime_r, localtime_r, etc. which take a struct tm* from 
 the caller instead of using a static in the library code. Making the rest 
 of the functions use pass-by-copy saves a multi-threaded program from 
 having to synchronize their calls, though using const dbi_inst* instead 
 would have allowed for cleaner semantics when they choose to put it on 
 the heap.

 That makes sense, though the fact that two users separately got the
 interface wrong does make one wonder whether it is ideal.  It also
 does not help that it is actually defined as void* or something
 similar so the compiler was not able to identify that the original
 call to initialize was wrong (I think, I have not looked at it in
 detail).

 Of course it's not ideal, but it's the best one can do without proper 
 constructors that are part of the language. In C++ one can simply have

  static DbiInstance dbi_inst = DbiInstance();

 The compiler does more or less the same thing that dbi_initialize_r() does, 
 but hides the gory details so that the programmer has to go out of his way 
 to screw it up. As a consequence the compiler can be very strict about 
 void*: The programmer has to explicitly declare or cast a parameter to 
 void* in the function call or get a warning.

 The problem with the original code (which caused the runtime crash)
 was that, because dbi_inst is defined as a void* the compiler was
 unable to flag an error when a dbi_inst itself was passed as a
 parameter instead of dbi_inst.  It is a long time since I wrote any C
 (as opposed to C++) and you are right that one forgets how much easier
 it was to make such errors.  I wonder why dbi_inst is a void* rather
 than a struct* as presumably it does point to a struct of some sort.

 I guess you're referring to
   typedef void * dbi_inst
 in dbi.h. That's a clumsy way of making the pointer opaque. Unfortunately it 
 completely subverts type safety, even in C++.
 Hmm. That also means that they've screwed up dbi_initialize_r(), because they 
 still own the memory for the struct. They've
 accomplished absolutely nothing except breaking their API. What idiots.

The thing they *have* accomplished is the ability to have multiple
instances open at the same time, which I suspect was the prime motive.
 I agree, though, not the best way to achieve it.

Cheers

Colin

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

Fix for dbi_initialize crash if libdbi = 0.9.0 (notably on Ubuntu 14.04)

[Colin Law]

Attached is patch to fix the startup crash on the maint branch after
tag 2.6.3 when using libdbi = 0.9.9, as is the case on Ubuntu 14.04.
It is a single line correction (well single character in fact).

Do I need to file a bug and attach the patch there or can someone
apply it from here?

Cheers

Colin
From 8ea4329d6a40f480bd65498f4ea1676505cb096f Mon Sep 17 00:00:00 2001
From: Colin co...@clanlaw.org.uk
Date: Mon, 5 May 2014 13:34:32 +0100
Subject: [PATCH] Fix crash initialising dbi if libdbi version = 0.9.0

---
 src/backend/dbi/gnc-backend-dbi.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/backend/dbi/gnc-backend-dbi.c b/src/backend/dbi/gnc-backend-dbi.c
index 694cbba..fcfce0c 100644
--- a/src/backend/dbi/gnc-backend-dbi.c
+++ b/src/backend/dbi/gnc-backend-dbi.c
@@ -1869,7 +1869,7 @@ gnc_module_init_backend_dbi(void)
 
 /* dbi_initialize returns -1 in case of errors */
 #if HAVE_LIBDBI_R
-num_drivers = dbi_initialize_r( driver_dir, dbi_instance );
+num_drivers = dbi_initialize_r( driver_dir, dbi_instance );
 #else
 num_drivers = dbi_initialize( driver_dir );
 #endif
-- 
1.9.1

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

Re: Fix for dbi_initialize crash if libdbi = 0.9.0 (notably on Ubuntu 14.04)

[Colin Law]

On 5 May 2014 17:05, Geert Janssens janssens-ge...@telenet.be wrote:
 On Monday 05 May 2014 13:43:08 Colin Law wrote:

 Attached is patch to fix the startup crash on the maint branch after

 tag 2.6.3 when using libdbi = 0.9.9, as is the case on Ubuntu 14.04.

 It is a single line correction (well single character in fact).



 Do I need to file a bug and attach the patch there or can someone

 apply it from here?



 Cheers



 Colin

 Hi Colin,



 Thank you for the patch. Looking at the libdbi api documentation I believe
 your fix is a step in the right direction. It only fixes the initialization
 for sqlite files though and not the initialization for the other sql
 backends.



 So I have applied an updated patch for this.



 In addition I have modified all dbi_function_r function calls to use
 dbi_instance instead of dbi_instance. That's how I understand it should be
 from the api documentation. I have not tested this though because I don't
 have libdbi 0.9.x on my system. Can you recheck with the most recent maint
 revision and verify if everything works fine with your sqlite data file ?

Hi Geert

Could I ask you to have another look at the docs?  I think all the
functions other than initialize actually take a dbi_inst rather than
dbi_inst*.  Which is not the way I would have designed it certainly.
I think the one call of dbi_initialize_r is for all db types.

Cheers

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

Re: Fix for dbi_initialize crash if libdbi = 0.9.0 (notably on Ubuntu 14.04)

[Colin Law]

On 5 May 2014 21:00, Geert Janssens janssens-ge...@telenet.be wrote:
 ...
 Uhm... after rereading I see you are completely right. I have no idea how I
 could have misread this the first time...

 I have reverted my commit and applied your patch. Sorry for goofing up !

No problem, thanks.

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

Re: Fix for dbi_initialize crash if libdbi = 0.9.0 (notably on Ubuntu 14.04)

[Colin Law]

On 5 May 2014 21:45, John Ralls jra...@ceridwen.us wrote:
 ...
 It's because dbi_initialize_r() is the only function that needs to write to 
 the dbi_instance; everything else just reads it. That makes managing the 
 memory the application's job and allows other approaches than allocating it 
 on the heap, including the static allocation that Moritz chose to use in his 
 implementation. The _r suffix to the function name is analogous to 
 gmtime_r, localtime_r, etc. which take a struct tm* from the caller instead 
 of using a static in the library code. Making the rest of the functions use 
 pass-by-copy saves a multi-threaded program from having to synchronize their 
 calls, though using const dbi_inst* instead would have allowed for cleaner 
 semantics when they choose to put it on the heap.

That makes sense, though the fact that two users separately got the
interface wrong does make one wonder whether it is ideal.  It also
does not help that it is actually defined as void* or something
similar so the compiler was not able to identify that the original
call to initialize was wrong (I think, I have not looked at it in
detail).

Cheers

Colin

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

libdbi crash on startup, maint branch on Ubuntu 14.04

[Colin Law]

The crash on running GC built on Ubuntu 14.04 is triggered by the
commit Make compatible to libdbi = 0.9.0 on 2014-04-15.

Backtrace attached, it starts

Program received signal SIGSEGV, Segmentation fault.
0x7fffcc5b4dac in dbi_initialize_r ()
   from /usr/lib/x86_64-linux-gnu/libdbi.so.1
(gdb) bt full
#0  0x7fffcc5b4dac in dbi_initialize_r ()
   from /usr/lib/x86_64-linux-gnu/libdbi.so.1
No symbol table info available.
#1  0x7fffcca02528 in gnc_module_init_backend_dbi ()
at ../../../../src/backend/dbi/gnc-backend-dbi.c:1872
prov = 0x9316c0
driver_dir = 0x0
num_drivers = 0
have_sqlite3_driver = 0
have_mysql_driver = 0
have_pgsql_driver = 0
__FUNCTION__ = gnc_module_init_backend_dbi
#2  0x7fffcca02926 in qof_backend_module_init ()

libdbi-dev is version 0.9.0

Colin
Program received signal SIGSEGV, Segmentation fault.
0x7fffcc5b4dac in dbi_initialize_r ()
   from /usr/lib/x86_64-linux-gnu/libdbi.so.1
(gdb) bt full
#0  0x7fffcc5b4dac in dbi_initialize_r ()
   from /usr/lib/x86_64-linux-gnu/libdbi.so.1
No symbol table info available.
#1  0x7fffcca02528 in gnc_module_init_backend_dbi ()
at ../../../../src/backend/dbi/gnc-backend-dbi.c:1872
prov = 0x9316c0
driver_dir = 0x0
num_drivers = 0
have_sqlite3_driver = 0
have_mysql_driver = 0
have_pgsql_driver = 0
__FUNCTION__ = gnc_module_init_backend_dbi
#2  0x7fffcca02926 in qof_backend_module_init ()
---Type return to continue, or q return to quit---
at ../../../../src/backend/dbi/gnc-backend-dbi.c:1977
No locals.
#3  0x76c13fd7 in qof_load_backend_library (
directory=0x931650 /opt/gnucash/lib/gnucash, 
module_name=0x7734c91a gncmod-backend-dbi)
at ../../../../src/libqof/qof/qofbackend.c:246
fullpath = 0x929720 p)\223
backend = 0x9328f0
module_init_func = 0x7fffcca0291d qof_backend_module_init
__FUNCTION__ = qof_load_backend_library
#4  0x772cc048 in gnc_engine_init_part2 ()
at ../../../src/engine/gnc-engine.c:105
libdir = 0x931650 /opt/gnucash/lib/gnucash
---Type return to continue, or q return to quit---
pkglibdir = 0x931650 /opt/gnucash/lib/gnucash
builddir = 0x0
uninstalled = 0
libs = {{subdir = 0x7734c916 dbi, 
lib = 0x7734c91a gncmod-backend-dbi, required = 1}, {
subdir = 0x7734c92d xml, 
lib = 0x7734c931 gncmod-backend-xml, required = 1}, {
subdir = 0x0, lib = 0x0, required = 0}}
lib = 0x77587f40 libs
#5  0x772cc181 in gnc_engine_init (argc=0, argv=0x0)
at ../../../src/engine/gnc-engine.c:142
No locals.
#6  0x772d7151 in libgncmod_engine_gnc_module_init (refcount=0)
---Type return to continue, or q return to quit---
at ../../../src/engine/gncmod-engine.c:46
No locals.
#7  0x770574dc in gnc_module_load_common (
module_name=0x775cbed4 gnucash/engine, iface=0, optional=0)
at ../../../src/gnc-module/gnc-module.c:519
initfunc = 0x772d7131 libgncmod_engine_gnc_module_init
info = 0x7a7e00
gmodule = 0x6ca990
modinfo = 0x6ccd60
__FUNCTION__ = gnc_module_load_common
#8  0x7705771c in gnc_module_load (
module_name=0x775cbed4 gnucash/engine, iface=0)
at ../../../src/gnc-module/gnc-module.c:554
---Type return to continue, or q return to quit---
No locals.
#9  0x775bc099 in libgncmod_app_utils_gnc_module_init (refcount=0)
at ../../../src/app-utils/gncmod-app-utils.c:64
No locals.
#10 0x770574dc in gnc_module_load_common (
module_name=0x4062d8 gnucash/app-utils, iface=0, optional=0)
at ../../../src/gnc-module/gnc-module.c:519
initfunc = 0x775bc07d libgncmod_app_utils_gnc_module_init
info = 0x805f80
gmodule = 0x6ac970
modinfo = 0x6cb2c0
__FUNCTION__ = gnc_module_load_common
#11 0x7705771c in gnc_module_load (
---Type return to continue, or q return to quit---
module_name=0x4062d8 gnucash/app-utils, iface=0)
at ../../../src/gnc-module/gnc-module.c:554
No locals.
#12 0x00405180 in load_gnucash_modules ()
at ../../../src/bin/gnucash-bin.c:479
i = 0
len = 22
modules = {{name = 0x4062d8 gnucash/app-utils, version = 0, 
optional = 0}, {name = 0x4062ea gnucash/engine, version = 0, 
optional = 0}, {name = 0x4062f9 gnucash/register/ledger-core, 
version = 0, optional = 0}, {
name = 0x406318 gnucash/register/register-core, version = 0, 
optional = 0}, {name = 0x406338 gnucash/register/register-gnome, 
---Type return to continue, or q return to quit---
version = 0, optional = 0}, {
name = 0x406358 gnucash/import-export/qif-import, version = 0, 
optional = 0}, {name = 0x406379 gnucash/import-export/ofx, 
version = 0, 

Re: libdbi crash on startup, maint branch on Ubuntu 14.04

[Colin Law]

On 3 May 2014 12:20, Colin Law clan...@gmail.com wrote:
 The crash on running GC built on Ubuntu 14.04 is triggered by the
 commit Make compatible to libdbi = 0.9.0 on 2014-04-15.

 Backtrace attached, it starts

 Program received signal SIGSEGV, Segmentation fault.
 0x7fffcc5b4dac in dbi_initialize_r ()
from /usr/lib/x86_64-linux-gnu/libdbi.so.1
 (gdb) bt full
 #0  0x7fffcc5b4dac in dbi_initialize_r ()
from /usr/lib/x86_64-linux-gnu/libdbi.so.1
 No symbol table info available.
 #1  0x7fffcca02528 in gnc_module_init_backend_dbi ()
 at ../../../../src/backend/dbi/gnc-backend-dbi.c:1872
 prov = 0x9316c0
 driver_dir = 0x0
 num_drivers = 0
 have_sqlite3_driver = 0
 have_mysql_driver = 0
 have_pgsql_driver = 0
 __FUNCTION__ = gnc_module_init_backend_dbi
 #2  0x7fffcca02926 in qof_backend_module_init ()

 libdbi-dev is version 0.9.0

I think the problem may be that a db_inst object is being passed to
dbi_initialize_r rather than a pointer, but I don't know enough about
how the code works to know what the fix should be.

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

Re: libdbi-0.9.0 vs. libdbi-0.8.4 on Ubuntu 14.04 Issue

[Colin Law]

On 2 May 2014 07:49, Herbert Mühlburger m...@muehlburger.at wrote:
 Hi,

 Am 2014-05-01 22:46, schrieb Colin Law:

 [...]

 apt-cache policy libdbd-mysql

 [...]

 That looks ok, though I meant libdbd-sqlite3 since I see that is
 what you are using, I presume that shows the same thing.  I am
 using 32 bit. Have you checked with the 2.6.3 tag that it also
 fails?  I have a 64 bit machine but I am not sure I have not tried
 it with sqlite.  I will give it a go.

It appears to be an issue with HEAD.  I built that (on 64 bit, but
don't know whether that is significant) and got segmentation error on
startup.  Reverted to tag 2.6.3 and it is ok.  I had some problems
getting it to build after the checkout of 2.6.3, though.  I assumed
that

sudo make uninstall
make clean

git checkout 2.6.3

./configure...
make
sudo make install
would do it, but it failed on the make.  Rather than messing about
trying to analyse it  I removed the src directory, repeated the
checkout and started again with ./autogen.sh

Also oddly I found I needed --disable-error-on-warning to get it to
compile on 2.6.3 which is a bit odd
So if anyone can tell me the proper technique to checkout a different
version and rebuild I would be grateful

Colin

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

Re: libdbi-0.9.0 vs. libdbi-0.8.4 on Ubuntu 14.04 Issue

[Colin Law]

On 2 May 2014 09:21, Geert Janssens janssens-ge...@telenet.be wrote:
 ...
 It would be interesting to test with brancht 'maint' as well. The changes
 for libdbi 0.9.0 have been committed after 2.6.3 has been released.

 Also I'm confused here: are both versions (HEAD and 2.6.3) linking against
 libdbi 0.9 ? If so does the 2.6.3 build generate deprecation warnings for
 some libdbi functions ?

Compiling 2.6.3 the warnings were libdbi deprecations as you
suggested.  The warnings are gone in the maint branch., so that makes
sense.  The maint branch does not run, however, giving a SIGEGV in
dbi_initialize_r().

I am confused by the fact that if I compile the 2.6.3 tarball (on the
same system) then I do not get the deprecation warnings.

 
 John's recent c++ related commits have caused sufficient difference between
 the stable branch (maint and by extension also tag 2.6.3) and HEAD that you
 need to start from a completely clean build directory AND have to rerun
 autogen.sh in between. So the steps would become:



 sudo make uninstall (to remove your installed version of gnucash)

 make maintainer-clean (wipes everything that was generated)



 git checkout 2.6.3 (or git checkout maint)



 ./autogen.sh

 ./configure ...

 make

 sudo make install



 Because I switch a lot between maint and master, I have chosen to clone the
 gnucash repository twice. One close is permanently checked out to maint the
 other to master.



 And in addition I'm building in separate build directories instead of in the
 source directories. That makes it easier to start from scratch (just delete
 the build directory). This is pretty easy to do:

 create your build directory (wherever you like)

 cd build-directory

 path-to-gnucash-configure/configure ...

 make

Thanks for all that, it all makes sense.

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

Re: Compile Error SchedXAction.h

[Colin Law]

On 2 May 2014 13:14, Herbert Mühlburger m...@muehlburger.at wrote:
 Hi folks,

 The latest commits to HEAD produce a new issue while compiling it.
 This issue I have not encountered before the latest commits were
 pushed to github.

 Does anybody have the same problem?
 ..
 Datei oder Verzeichnis nicht gefunden
  #include ../SchedXAction.h

Yes, I see that too.  I think possibly it should be SchedXaction.h

Colin

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

Re: Official Ubuntu GnuCash package segfaults on Ubuntu 14.04

[Colin Law]

On 1 May 2014 16:45, Derek Atkins warl...@mit.edu wrote:
 Herbert Mühlburger m...@muehlburger.at writes:

 After installing libdbi-0.8.3 I could run GnuCash without problems. As
 you mentioned there seems to be a problem with the latest version of
 libdbi. Where is the GNC_DBD_DIR env variable being set?

 I thought it got set during configure?

In case it is of relevance it is not set on my system.

Colin

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

Re: libdbi-0.9.0 vs. libdbi-0.8.4 on Ubuntu 14.04 Issue

[Colin Law]

On 1 May 2014 20:23, Herbert Mühlburger m...@muehlburger.at wrote:
 Am 2014-05-01 17:55, schrieb John Ralls:

 On May 1, 2014, at 8:45 AM, Derek Atkins warl...@mit.edu wrote:

 Herbert Mühlburger m...@muehlburger.at writes:

 After installing libdbi-0.8.3 I could run GnuCash without
 problems. As you mentioned there seems to be a problem with the
 latest version of libdbi. Where is the GNC_DBD_DIR env variable
 being set?

 I thought it got set during configure?

 It’s actually there to allow post-build override, which is
 necessary in the MacOSX bundle. Try setting it explicitly to the
 correct path.

 There is an interesting behaviour:

 1) Installing libdbi-0.8.4, compiling gnucash and running it using a
 sqlite3 GnuCash-file works as expected.

 I downloaded the official tar.gz from
 http://sourceforge.net/projects/libdbi/files/libdbi/libdbi-0.8.4/libdbi-0.8.4.tar.gz/download
 compiled and installed it on my system.

 2) Installing libdbi-0.9.0 from source and compiling GnuCash results
 in the following output:

 checking dbi/dbi.h usability... yes
 checking dbi/dbi.h presence... yes
 checking for dbi/dbi.h... yes
 checking Looking for at least one supported DBD module... configure:
 error:
 Unable to find any of the supported dbd modules
 (libdbdsqlite3, libdbdmysql, or libdbdpgsql) needed to actually use
 the SQL
 backend.

 If you do have them installed the problem is either that dlopen cannot
 find them or that dlopen itself is not getting linked. Check config.log
 to find out which.  You can add the option --with-dbi-dbd-dir pointing to
 the directory in which they are located.

 If you do not actually want to build with libdi add --disable-dbi
 to the configure argument list and run it again.

 ./configure --prefix=/opt/gnucash --enable-compile-warnings
 --enable-dbi  5,35s user 2,96s system 103% cpu 8,009 total

 Everything I change is the version of libdbi from 0.8.4 to 0.9.0. Are
 the dbd-modules for libdbi-0.9.0 located somewhere else and GnuCash
 does not search there?

What does
apt-cache policy libdbd-mysql
show?

Colin

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

Re: libdbi-0.9.0 vs. libdbi-0.8.4 on Ubuntu 14.04 Issue

[Colin Law]

On 1 May 2014 21:33, Herbert Mühlburger m...@muehlburger.at wrote:
 Am 2014-05-01 21:40, schrieb Colin Law:
 apt-cache policy libdbd-mysql

 libdbd-mysql:
   Installiert:   0.9.0-2ubuntu2
   Installationskandidat: 0.9.0-2ubuntu2
   Versionstabelle:
  *** 0.9.0-2ubuntu2 0
 500 http://at.archive.ubuntu.com/ubuntu/ trusty/main amd64
 Packages
 100 /var/lib/dpkg/status


That looks ok, though I meant libdbd-sqlite3 since I see that is what
you are using, I presume that shows the same thing.  I am using 32
bit. Have you checked with the 2.6.3 tag that it also fails?  I have a
64 bit machine but I am not sure I have not tried it with sqlite.  I
will give it a go.

Colin

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

./configure flags

[Colin Law]

HI

I am building from source on Ubuntu 14.04 with a view to updating the
wiki.  The instructions for 12.04 specify
./configure --prefix=/path/to/install/to/gnucash
--enable-compile-warnings --with-html-engine=webkit
--disable-error-on-warning

Is that still appropriate?

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

Re: Official Ubuntu GnuCash package segfaults on Ubuntu 14.04

[Colin Law]

On 28 April 2014 17:25, Herbert Mühlburger m...@muehlburger.at wrote:
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA256

 Some additional information on what might create this issue:

  - the version of libdbi-dev on Ubuntu 13.10 was 0.8.4-6
  - the version of libdbi-dev on Ubuntu 14.04 is 0.9.0-1

 There are some deprecated functions which also prevent GnuCash from
 successfuly running the test suite on the current master branch.

 As a result it is not possible for me to run either the current master
 branch or the latest stable version of GnuCash on Ubuntu 14.04.

Note that the version of GC in the Ubuntu repo is 2.6.1, which has
some bugs, though I don't know whether they can cause a crash.

I have had no problems compiling and running 2.6.3 on Ubuntu 14.04
(from the source tarball).  What is it that is causing you difficulty?

Colin

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

Re: Official Ubuntu GnuCash package segfaults on Ubuntu 14.04

[Colin Law]

On 29 April 2014 21:14, Herbert Mühlburger m...@muehlburger.at wrote:
 Am 29.04.14 16:57, schrieb Derek Atkins:

 Install Fedora?

 That's not an option ... I would appreciate somehow more constructive help.

See http://wiki.gnucash.org/wiki/Building#Ubuntu_14.04_LTS_.28Trusty_Tahr.29
for how to build on 14.04, or am I misunderstanding your problem?

Colin

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

Firefox hogging processor sometimes on startup

[Colin Law]

I have mentioned this before, sometimes when FF starts up it functions
ok but consumes masses of CPU, eventually hogging the whole machine.
I can close FF but the process does not die, I have to kill it.  I
have started running the console on startup and this time the last
thing I see in the log is shown below.  Is it possible that the
problem is related to google calendar syncing?

Colin

Reminderfox  ** Alert **2014-04-25 21:50
rmFx_CalDAV_SyncActiveAccounts  trace: addReminderDialog: ' start sync
in background for Remote Calendars'
chrome://reminderfox/content/caldav/calDAVcalls.js # 284
1: [chrome://reminderfox/content/addReminderDialog.js # 770]
rmFx_mainDialogLoad/

PROPFIND 
https://clanlaw%40googlemail%2e...@www.googleapis.com/caldav/v2/clanlaw%40googlemail.com/events/
[HTTP/1.1 207 Multi-Status 393ms]
Reminderfox  ** Alert **2014-04-25 21:50
.core.clearRemindersAndTodos
chrome://reminderfox/content/reminderFoxCore.js # 2670
1: [chrome://reminderfox/content/reminderFoxCore.js # 5439]
reminderfox.core.importRemindersUpdateAll

POST https://mail.google.com/mail/u/0/ [HTTP/1.1 200 OK 335ms]
Reminderfox  ** Alert **2014-04-25 21:50
rmFx_CalDAV_SyncActiveAccounts  trace: addReminderDialog: ' start sync
in background for Remote Calendars'
chrome://reminderfox/content/caldav/calDAVcalls.js # 284
1: [chrome://reminderfox/content/addReminderDialog.js # 770]
rmFx_mainDialogLoad/

PROPFIND 
https://clanlaw%40googlemail%2e...@www.googleapis.com/caldav/v2/clanlaw%40googlemail.com/events/
[HTTP/1.1 207 Multi-Status 77ms]
Reminderfox  ** Alert **2014-04-25 21:50
.core.clearRemindersAndTodos
chrome://reminderfox/content/reminderFoxCore.js # 2670
1: [chrome://reminderfox/content/reminderFoxCore.js # 5439]
reminderfox.core.importRemindersUpdateAll
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: Git branch cleanup

[Colin Law]

On 11 April 2014 23:10, John Ralls jra...@ceridwen.us wrote:
 I’d like to delete most of the old feature branches from the repository

Why bother?

Colin

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

Re: Git branch cleanup

[Colin Law]

On 12 April 2014 15:38, John Ralls jra...@ceridwen.us wrote:

 On Apr 12, 2014, at 12:29 AM, Colin Law clan...@gmail.com wrote:

 On 11 April 2014 23:10, John Ralls jra...@ceridwen.us wrote:
 I’d like to delete most of the old feature branches from the repository

 Why bother?

 So that the branch pick list isn't a mile long with the two most important 
 near the bottom.

Which tool are you using to see the pick list?

Colin

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

Re: Github reports fixing Heartbleed vulnerability

[Colin Law]

On 10 April 2014 18:21, John Ralls jra...@ceridwen.us wrote:
 https://github.com/blog/1818-security-heartbleed-vulnerability

 They recommend not only changing your password and enabling two-factor 
 authentication but also replacing your ssh keys.

 I’ll add that if you’ve used a github ssh key anywhere else you should 
 replace it there as well — and use a different key this time.

I just thought that I should point out that on the blog they say
users who want to be extra cautious should change passwords etc.

Colin

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

Re: Building on Windows from scratch

[Colin Law]

On 20 December 2013 12:59, Gary Bilkus m...@gary.bilkus.com wrote:
 Thanks for the info.

 I will set up a windows 32 bit virtual machine and try to follow the 
 instructions one by one. Should I report each problem to this list or 
 privately to somewhere else. I'm happy to put in the work to ensure that the 
 instructions are clear.

 BTW, the reason I want to be able to build gnucash from source is that I'm 
 considering some enhancements which may be of interest to others and may not, 
 but I am restricted to running on windows boxes at the moment.

Have you considered running ubuntu (for example) in a virtual machine
such as vmware or virtualbox?   I suspect the hassle of doing that
would be much less than that of developing on Windows.

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

Re: Fwd: Error parsing compressed file but reads uncompressed ok

[Colin Law]

On 17 November 2013 04:38, Mike Alexander m...@umich.edu wrote:
 [snip]
 The patch to libxml2 to fix this is easy.  I'll submit it to the MacPorts
 maintainer for libxml2 who will presumably submit it upstream.

Is there a link for the bug?  If so I will also report a bug on Ubuntu libxml2.

 However, it
 will take a while for this to propagate to all the platforms that matter for
 GnuCash.  GnuCash is also quite capable of decompressing the file itself.  I
 suggest that we change it so that it never passes a compressed file to
 libxml2 and instead decompresses it itself.  This isn't a difficult change
 and unless you think it is a bad idea, I'll do it.

Would that be just on 2.5 or would it be backported to 2.4?

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

Error parsing compressed file but reads uncompressed ok

[Colin Law]

I find today that I cannot open my compressed xml accounts file, I get
a parse error opening the file.  I am using version 2.4.13 (on Ubuntu
13.10).  If I uncompress the file with gunzip it will open ok, but if
I I save it compressed again then again it will not reopen.
I can read the same compressed file ok with version 2.4.10 (on Ubuntu
12.04), and if I save it with version 2.4.10 then I can re-open it
with version 2.4.13.

The trace file shows
* 12:38:50  WARN GLib-GObject Attempt to add property
GnomeProgram::sm-connect after class was initialised
* 12:38:50  WARN GLib-GObject Attempt to add property
GnomeProgram::show-crash-dialog after class was initialised
* 12:38:50  WARN GLib-GObject Attempt to add property
GnomeProgram::display after class was initialised
* 12:38:50  WARN GLib-GObject Attempt to add property
GnomeProgram::default-icon after class was initialised
* 12:38:59  CRIT gnc.backend.file.sixtp parse failed at:
* 12:38:59  WARN gnc.backend [gnc_xml_be_load_from_file()] Syntax
error in Xml File
/home/colinl/Documents/OwlDocs/finance/accounts/accounts.gnucash
* 12:38:59  CRIT GLib g_hash_table_foreach: assertion 'version ==
hash_table-version' failed
* 12:38:59  CRIT GLib g_hash_table_foreach: assertion 'version ==
hash_table-version' failed


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

Re: Error parsing compressed file but reads uncompressed ok

[Colin Law]

On 5 November 2013 12:39, Colin Law clan...@googlemail.com wrote:
 I find today that I cannot open my compressed xml accounts file, I get
 a parse error opening the file.  I am using version 2.4.13 (on Ubuntu
 13.10).  If I uncompress the file with gunzip it will open ok, but if
 I I save it compressed again then again it will not reopen.
 I can read the same compressed file ok with version 2.4.10 (on Ubuntu
 12.04), and if I save it with version 2.4.10 then I can re-open it
 with version 2.4.13.

In fact I see that even if I make a new trivial file and save it
compressed then I cannot re-open it.  Either something has got messed
up in my system or an update has introduced a bug.

Colin


 The trace file shows
 * 12:38:50  WARN GLib-GObject Attempt to add property
 GnomeProgram::sm-connect after class was initialised
 * 12:38:50  WARN GLib-GObject Attempt to add property
 GnomeProgram::show-crash-dialog after class was initialised
 * 12:38:50  WARN GLib-GObject Attempt to add property
 GnomeProgram::display after class was initialised
 * 12:38:50  WARN GLib-GObject Attempt to add property
 GnomeProgram::default-icon after class was initialised
 * 12:38:59  CRIT gnc.backend.file.sixtp parse failed at:
 * 12:38:59  WARN gnc.backend [gnc_xml_be_load_from_file()] Syntax
 error in Xml File
 /home/colinl/Documents/OwlDocs/finance/accounts/accounts.gnucash
 * 12:38:59  CRIT GLib g_hash_table_foreach: assertion 'version ==
 hash_table-version' failed
 * 12:38:59  CRIT GLib g_hash_table_foreach: assertion 'version ==
 hash_table-version' failed


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

Re: Error parsing compressed file but reads uncompressed ok

[Colin Law]

On 5 November 2013 16:49, John Ralls jra...@ceridwen.us wrote:

 On Nov 5, 2013, at 7:36 AM, Colin Law clan...@googlemail.com wrote:

 On 5 November 2013 14:57, John Ralls jra...@ceridwen.us wrote:

 On Nov 5, 2013, at 6:46 AM, Colin Law clan...@googlemail.com wrote:
 ...
 I guess you must be right, for some reason gnucash is unable to
 correctly unzip this particular file.  Any suggestions on how to
 progress this further?  I could send the file privately to someone if
 they wanted to have a look at it.


 There was a similar complaint from someone using OSX on the users list on 21 
 October, but the user didn't follow up on troubleshooting.

 Try making a debug build of GC and libz using the source .deb and debugging. 
 Set your first breakpoint at try_gz_open and see what's going on.

Having added another transaction it is now ok so it may be something
pattern specific in the data in the file.  Very odd.  I have kept a
copy of failing file.

Sadly I am not sure when I will have time to investigate it further, I
am not in development mode with GC at the moment.

Cheers

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

Re: Base And Gnucash

[Colin Law]

On 3 May 2013 17:21,  b...@comcast.net wrote:
 The most important need would be the ability to run custom SQL queries on the 
 underlying data.


 I have taken another look at Gnucash as I have not tried to use this program 
 in some time. I cannot tell whether
 this is possible or not.

Since one of the options with Gnucash is to use a MySQL database to
store the data then it is obvious that it is possible to run custom
queries.

Exactly what the query must be to give particular results is not quite
so obvious, but it is possible.

Colin



 Last time I tried to use this program importing using CSV was not possible I 
 believe so that is a step in the right
 direction.
 - Original Message -
 From: Buddha Buck blaisepas...@gmail.com
 To: b...@comcast.net
 Cc: Derek Atkins warl...@mit.edu, gnucash-devel@gnucash.org devel 
 gnucash-devel@gnucash.org
 Sent: Thursday, May 2, 2013 10:47:48 PM
 Subject: Re: Base And Gnucash






 On Thu, May 2, 2013 at 11:10 PM,  b...@comcast.net  wrote:


 Huh? What??


 It is inappropriate for GNUcash to interact with OpenOffice?





 That is not what Derek said.


 He said it is inappropriate to discuss replicating GnuCash's functionality 
 here. I'd tend to agree.
 blockquote


 The debate between canned accounting systems and open systems is well known.

 /blockquote



 Not to me it isn't. This is the first I've heard of a debate between canned 
 accounting systems and open systems where OpenOffice is considered an 
 accounting system (open, canned, or otherwise).


 For that matter, I'm not sure what *your* definitions of the terms canned, 
 open, and accounting system are.

 blockquote

 Is GNUcash designed to be a canned system? What would be the purpose for open 
 source software to
 be a black box?

 /blockquote



 There are plenty, plenty of pieces of open source software which are 
 effectively black boxes to folks not versed in the field. It is possible 
 that, with time, effort, and study, I could come to understand how gcc works, 
 but effectively, it's a black box to me. Same with OpenOffice. It's inner 
 workings are a black box to me. What makes them open source is that I am 
 allowed to open that black box, peer in, figure out how it works (or hire 
 someone to do that for me), and twiddle with it, if I so choose.


 But there is no way that it is a requirement that different open source 
 software need talk with each other. How does OpenOffice interact with 
 Firefox? Or gcc? Or SuperTuxCart? I bet poorly in all cases.


 But let me ask you a direct question: What is it that you want to do, using 
 OpenOffice Base, that you can't do using GnuCash? What concrete need is not 
 being fulfilled? Pretty much worthless to me, and easily modify the code 
 for their needs is very vague.

 blockquote


 - Original Message -
 From: Derek Atkins  warl...@mit.edu 

 To: John Ralls  jra...@ceridwen.us 
 Cc: b...@comcast.net ,  gnucash-devel@gnucash.org devel  
 gnucash-devel@gnucash.org 
 Sent: Thursday, May 2, 2013 10:20:17 AM
 Subject: Re: Base And Gnucash



 John Ralls  jra...@ceridwen.us  writes:

 On May 1, 2013, at 8:32 PM, b...@comcast.net wrote:

 The problem with Gnucash is that it is hard or perhaps practically
 impossible to modify unless perhaps one is
 very familiar with the program. THis is at least how it used to be.

 That hasn't changed. It's also usually true of all complex programs, and
 Gnucash is complex, perhaps overly so.

 I think it depends on what exactly you want/need to change.. Some
 things are easier than others. However I would point out that creating
 something in ANY language as complex as GnuCash would be just as hard to
 make changes if you're not familiar with it! The language you use
 doesn't change that fact.

 This makes it practically impossible to switch from our system to GNUcash.
 IT was some time ago that I tried to work with this
 program, but just importing my data was not possible or too difficult.

 Not at all. GnuCash has lots of decent importers for various data
 formats, including QIF, OFX/QFX, HBCI, MT940, and CSV. Granted, if you
 cannot create data in those formats then sure, you'll have trouble
 importing into GnuCash.

 The advantages of building a financial program based on Base are obvious.

 No, they are not.

 The import issue for example is already solved.

 No, it is not. You would still need to write parsers for QIF, OFX,
 HBCI, MT940, etc. Sure, CSV is probably going to be easy for you, but
 none of the others are.

 Also, keep in mind that initial import is a one-time operation. It's
 everything else that happens over and over and over. You're prematurely
 optimizing for the wrong thing here.

 Also, it would not be all that difficult to write it. Users could much
 more easily modify the program and on and on and on. I am not
 understanding
 why there is not such a project. Or is there?

 Whether or not such a project exists or whether or not it would be easy to
 write has 

Re: Approval for Introducing Your Software in Japanese PC magazine

[Colin Law]

On 28 April 2013 14:48, John Ralls jra...@ceridwen.us wrote:

 On Apr 28, 2013, at 1:14 AM, Graham Leggett minf...@sharp.fm wrote:

 On 28 Apr 2013, at 04:45, John Ralls jra...@ceridwen.us wrote:

 The rules say that you have to distribute all of the source code, but I 
 think that it's become
 pretty common to rely on the fact that the sources are all readily 
 available via the net. You'll
 probably want to get an OK from your lawyers.

 The rules say that if you make changes to the code, you must make those 
 changes to the source available under the same license.

 If you don't make changes to the code, for example you just publish the 
 binaries as provided, then just link back to the source here.

 The source doesn't need to be on the same physical medium, but does need to 
 be available. An example might be binaries on an operating system CD, with 
 source available via the operating system website.

 Wrong.
 http://www.gnu.org/licenses/old-licenses/gpl-2.0-faq.html#TOCUnchangedJustBinary

Just to clarify that, I don't think it means that you have to supply
the sources on the same medium at the same time, just that you have to
be able to supply the sources if someone requires it.  If I get a
Ubuntu CD from Canonical (a CD not a download), which includes
gnucash, they do not have to supply the source at the same time.  It
has to be available if I ask for it however.  Also if I insist on
getting the source on CD then they can make a reasonable charge for it
I believe.

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

Re: Fw: Re: Proposed change to development Process was Fw: [Bug 650598] Cannot Enter Nth Day of Month Scheduled Transactions

[Colin Law]

On 7 February 2013 15:41, David Carlson carlson...@sbcglobal.net wrote:
 Then is there some other way to show the bug unresolved (because it has not 
 been released) but the code is in the queue?

Could one use a Status of Resolved to mean that the fix has been
committed but not yet released, and then close the bug when it is
released?

Colin


 David C

 --- On Thu, 2/7/13, John Ralls jra...@ceridwen.us wrote:

 From: John Ralls jra...@ceridwen.us
 Subject: Re: Proposed change to development Process was Fw: [Bug 650598] 
 Cannot Enter Nth Day of Month Scheduled Transactions
 To: David Carlson carlson...@sbcglobal.net
 Cc: gnucash-devel gnucash-devel@gnucash.org, david.carlson@gmail.com
 Date: Thursday, February 7, 2013, 9:35 AM


 On Feb 7, 2013, at 7:21 AM, David Carlson carlson...@sbcglobal.net wrote:

 As I requested in this closed bug, which is not in the current program 
 release and may not be in the current release for many more months, how 
 about adding a status Awaiting next Program Release so the bug can be 
 found in a search for unresolved bugs?

 This should reduce duplicate bug reports.


 It might, but we don't control bugzilla, gnome.org's Bug Squad [1] does. We 
 don't have the privs to modify the workflow.

 Regards,
 John Ralls

 [1] https://live.gnome.org/Bugsquad/
 ___
 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: [gnucash-htdocs] Change GnuCash website `Mailing Lists' link name

[Colin Law]

On 15 January 2013 21:17, Christian Stimming christ...@cstimming.de wrote:
 Am Sonntag, 13. Januar 2013, 20:36:22 schrieb Derek Atkins:
 John Ralls jra...@ceridwen.us writes:
  On Jan 12, 2013, at 2:55 PM, Yawar Amin yawar.a...@gmail.com wrote:
  Hi folks,
 
  I think most of the devs here know that I and other documentation team
  members get emails from time to time for people looking for GnuCash
  support. A lot of the time they say they gave up in frustration after
  trying to find someone to email on the GnuCash website.
 
  I'm hoping this will change that by simplifying the `mailing lists'
  term
  to `public discussion forums'.
 
  Thoughts?
 
  That's not really a simplification. Worse, I think that if you call it
  that then people will think that they're web forums, and we have
  enough trouble with nabble users who don't understand that they're
  using a web interface to a mailing list.

 I agree.  Please do not call it a forum.

 No, I think Yawar has a valid point here. The term mailing list to a non-
 tech user does not sound like some place where discussions are being held. I'd
 welcome any better wording that is more accessible for non-tech users as well.

It could be called something like a 'support and discussion mailing
list'.  I think that it would be incorrect to use the word forum.  It
would certainly be unconventional and confusing.

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

Re: [gnucash-htdocs] Change GnuCash website `Mailing Lists' link name

[Colin Law]

On 15 January 2013 21:29, Derek Atkins de...@ihtfp.com wrote:

 On Tue, January 15, 2013 4:23 pm, Colin Law wrote:
 I agree.  Please do not call it a forum.

 No, I think Yawar has a valid point here. The term mailing list to a
 non-
 tech user does not sound like some place where discussions are being
 held. I'd
 welcome any better wording that is more accessible for non-tech users as
 well.

 It could be called something like a 'support and discussion mailing
 list'.  I think that it would be incorrect to use the word forum.  It
 would certainly be unconventional and confusing.

 How about email support and discussion list(s)?

There are only 120 ways of reordering the words, one of them should do :)

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

Re: [gnucash-htdocs] Change GnuCash website `Mailing Lists' link name

[Colin Law]

On 15 January 2013 22:07, Derek Atkins de...@ihtfp.com wrote:

 On Tue, January 15, 2013 4:35 pm, Colin Law wrote:
 On 15 January 2013 21:29, Derek Atkins de...@ihtfp.com wrote:

 On Tue, January 15, 2013 4:23 pm, Colin Law wrote:
 I agree.  Please do not call it a forum.

 No, I think Yawar has a valid point here. The term mailing list to a
 non-
 tech user does not sound like some place where discussions are being
 held. I'd
 welcome any better wording that is more accessible for non-tech users
 as
 well.

 It could be called something like a 'support and discussion mailing
 list'.  I think that it would be incorrect to use the word forum.  It
 would certainly be unconventional and confusing.

 How about email support and discussion list(s)?

 There are only 120 ways of reordering the words, one of them should do :)

 True.  My specific suggestion was to include the word email, and not use
 the phrase mailing list.

 This whole thread is about wordsmithing..  :-/

Yes, I was just being flippant, sorry.  I think your suggestion is the
best so far.

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

Cannot change alert window width

[Colin Law]

I find that I can no longer change the width of the alert window (the
window showing a tab for each active alert along with Snooze button).
The change may have coincided with an upgrade to FireFox 17, but I
cannot be certain of that.  I am running on Ubuntu 12.10.  Is anyone
else seeing this?

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

Re: GnuCash XML spec (for non-C languages?)

[Colin Law]

On 4 November 2012 22:05, Christian Stimming christ...@cstimming.de wrote:
 Am Donnerstag, 1. November 2012, 09:43:30 schrieb John Ralls:
 On Nov 1, 2012, at 9:32 AM, Geert Janssens janssens-ge...@telenet.be
 wrote:
  On 01-11-12 17:13, Derek Atkins wrote:
  Also, what is the policy of GnuCash towards manipulating the XML.
 
  Is modifying the XML also actively discouraged?
 
  Yes.  All data 'writes' should only happen through the GnuCash API.
 
  Which means there are currently 3 supported ways to modify the data:
  - using the GnuCash application's gui
  - you can write a guile/scheme script that uses the GnuCash API
  - if python bindings are enabled on your platform you can also write a
  python script that uses the GnuCash API.
 There's a fourth: You can write a program in any language which can load a C
 library.

 We used to be somewhat proud of this statement - being able to offer a C
 library that can handle the data store correctly. However, I think the times
 have changed. By they way, the gnucash API isn't only a C library, but
 instead, it's a C library requiring glib - any new platform would first have a
 glib being ported to it.

 Today, we have all those new mobile devices. They might even allow C
 libraries, but if they do, it would be a C library for specific architectures
 with significantly smaller target audience than the whole mobile platform in
 mind. Or in other words, one would have to cross-compile a whole set of
 different C libraries to cover all the mobile devices using a particular
 platform. And for the gnucash API this all wouldn't even work as long as there
 isn't a glib on that platform!

 Because of this new situation today, I think it would be quite useful to be
 able to modify our original point of view concerning access to the datastore.
 I think it would be quite useful to find some sort of datastore access layer
 that is *not* forced to be a C library. In fact, it shouldn't be tied to any
 specific programming language. If it were possible to postulate the structure
 of the datastore in such a language-independent way, it would enable other
 languages and platforms without C libraries to offer gnucash data display and
 manipulation. Such as Ngewi's Android app, directly accessing a SQL database
 with gnucash data. Or any app on any of those other well-known mobile
 platforms. They all have in common that it is impossible to use the gnucash C
 library. They all have in common that it's a huge improvement for users to be
 able to do their bookkeeping also from those devices.

 So IMHO the logical next step is to find some new formulation of the gnucash
 datastore where the data manipulation is no longer solely tied to a C library.
 I know this step isn't particularly easy, but I think the time has come to no
 longer outright refuse such a step.

A web service interface would be good.  Then one could enter one's
transactions directly into the database in the cloud or ones home
server from the mobile device.  No messing about with export/import.

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