Re: [GNC] .log files with sqlite backend

[Alen Siljak]

> Sent: Thursday, April 19, 2018 at 3:47 PM
> From: "Derek Atkins" 
> To: "David T. via gnucash-user" 
> Cc: "alen.sil...@gmx.com" , "sunfis...@yahoo.com" 
> 
> Subject: Re: [GNC] .log files with sqlite backend
> 
> So I don't see why you would want or need to replay logs with SQL.
> Is there a specific use-case here that I missed?

Not really, except that the .log files are still created which is redundant, as 
you just confirmed.
The sql backend indeed does save all the changes immediately and the Save 
button also becomes redundant.

So, from what I understand, the whole point of .log files is to help prevent 
losing changes if there's a crash before the user clicks Save with an xml book?

Cheers
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Alen Siljak]

Jeffrey, perhaps a stupid question - why don't you install a native linux 
version of GnuCash instead of running a Windows version under Wine?
I use the same xml/sql book with linux and windows versions interchangably and 
there are no issues (that I can see, at least!). 
Also, just for comparison, Windows version loads my book in ~30 seconds while 
linux version loads the same book in 5. You may even benefit from an increased 
performance.

Versions 3.0 and 2.6.19 are not compatible. Version 2.6.21 should be, though. 
However, can't confirm that 100% as I've moved to 3.0 and it worked ok for me 
so far.


> Sent: Wednesday, April 18, 2018 at 9:40 AM
> From: "jeffrey black" 
> To: "Gnucash userlist" , gnucash-devel 
> 
> Subject: [GNC-dev] GnuCash 3.0 wine versus Windoze 10
>
> 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).
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [NO MORE TAGS] Version 3 configuration files

[Alen Siljak]

Yes, absolutely, same here. Thank you. 
I thought of the missing link 2 seconds after pressing the send button, as 
usual.

The page is here: https://wiki.gnucash.org/wiki/Configuration_Locations

and, as Geert noted, currently it is (more or less) just a copy/paste of his 
message with some formatting. Further effort is still needed to disect and 
arrange it into suggested sections. I'd also suggest extracting various 
explanations from other pages and moving them here. But that requires dedicated 
time for understanding the original meaning of the section and rephrasing it 
correctly (which I can probably afford only on a weekend).

Cheers!

> Sent: Tuesday, April 17, 2018 at 2:24 PM
> From: "Stan Brown" 
> To: gnucash-user@gnucash.org
> Cc: alen.sil...@gmx.com
> Subject: Re: [NO MORE TAGS] Version 3 configuration files
>
> This is a great idea, IMHO. I've been confused by this for a while, and the 
> info I found seemed incomplete.  But you forgot to tell us the URL of the new 
> page!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] XDG_CONFIG_HOME

[Alen Siljak]

   Michael,

   if you look at the v3.0 release notes, it states that
   "Data file directories are now located appropriately to the operating
   system's conventions by default:
 * Windows: CSIDL_APPDATA/Gnucash
 * MacOS: $HOME/Application Support/Gnucash
 * Linux: $XDG_CONFIG_HOME/gnucash (or the default
   $HOME/.config/gnucash)

   It's still possible to overried with the environment variable
   GNC_DOC_PATH, which replaces GNC_DOT_DIR in earlier versions of
   GnuCash."

   So, the config directory has changed. On Windows, it used to default to
   ~/.gnucash but not any more. I don't have a Windows system at hand so
   can't give you the exact default location.

   Geert,

   I still find it strange that, even though there is no XDG variable that
   points to ~/.local/share, gnucash directory is still located there. I
   mean, there is no XDG_CONFIG_HOME nor XDG_DATA_HOME set on my system.
   There must be other standards (you know what's good about standards?
   There's so many of them).

   Cheers

   Sent: Monday, April 16, 2018 at 8:10 PM
   From: "Fross, Michael" 
   To: "Geert Janssens" 
   Cc: Gnucash-User , cicko
   
   Subject: Re: [GNC] XDG_CONFIG_HOME
   Just so I'm clear:

   XDG_DATA_HOME will point to the GNC config directory on linux.
   GNC_DATA_HOME will do likewise on Windows?  And the config directory is
   essentially the .gnucash from the v2.6 release?

   I think this is right, just making sure I understand.

   Thank you,

   Michael

   On Mon, Apr 16, 2018 at 11:57 AM, Geert Janssens
   <[1]geert.gnuc...@kobaltwit.be> wrote:

 Op zondag 15 april 2018 14:32:12 CEST schreef cicko:
 > Continuing from another thread, this is a separate issue.
 > On my OpenSuse system, I see no XDG_CONFIG_HOME variable when I do
 > `printenv`. Echoing the variable itself also displays nothing.
 >
 > This would not be a problem on its own but I see no
 ~/.config/gnucash folder
 > in order to do some GTK styling customizations. Could any linux
 gurus share
 > some wisdom here? Thanks!
 XDG_DATA_HOME will default to ~/.config if it is not explicitly set.
 That's
 what the free desktop specification requires.
 And ~/.config/gnucash is not created automatically indeed. You can
 create it
 yourself if you need it.
 Geert

References

   1. mailto:geert.gnuc...@kobaltwit.be
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounts columns currency

[Alen Siljak]

   > Sent: Sunday, April 15, 2018 at 12:10 AM
   > From: "John Ralls" <jra...@ceridwen.us>
   > To: "Alen Siljak" <alen.sil...@gmx.com>
   > Cc: gnucash-user@gnucash.org
   > Subject: Re: [GNC] Accounts columns currency
   >
   > > - I wanted to convert my XML book to SQLite and modify the
   root-account currency. However, I see no other book format options
   besides xml. GnuCash was installed from the default OpenSuse repo.
   > > - Checked one of the SQLite backup files and the root account is
   already in EUR commodity.
   > > - The summary line at the bottom of the Accounts window is showing
   all the amounts in Euros, respecting the default currency setting, it
   seems.
   > >
   > > But the list of columns that can be added to the Accounts window
   still only contains the locale currency (GBP).
   > > Changing the system default language also had no effect on the
   currency displayed here.
   > > I was going to check the config directory but I see no
   ~/.config/gnucash.
   >
   > Having only the XML backend indicates that you haven't installed
   either libdbi or the dbd driver packages.
   >
   > Language and locale are separate. Currency, numeric separators, time
   formats, etc. are locale settings. If you launch GnuCash from the
   command line you can set the locale for it with e.g. LANG=de_DE
   gnucash. If you use a desktop icon it's easier to set it in
   /usr/share/etc/gnucash/environment. It's about halfway down and says #
   LANG = nl_BE. Remove the # and set it to your locale of choice. If you
   want the same language just uncomment the following line. If you want a
   different language, uncomment the following line and replace {LANG}
   with a comma-separated list of two-letter language codes in order of
   preference, e.g. fr,de,en.
   >
   > Is this 2.6.something or 3.0? For 2.6.something the config directory
   is ~/.gnucash.
   >
   > Are you sure you selected the Choose radio button in
   Preferences>Accounts>Default Currency?

   Many thanks for all the tips. Got everything working now!

   Sqlite driver was missing.
   I switched my system locale to en_IE as it seems to be the only one
   matching my settings, without the need to mix different locales for
   language, currency, date format, etc. In Yast, "Language" is the name
   for all the related settings even though it shows way less detail than
   running "locale".

   So it seems that the additional columns in the Accounts window are
   always using the locale currency. At least on linux.
   I was expecting this would be the default currency from the settings.
   Do you have any opinion on this? Should I file it as a bug? I mean, my
   original problem is solved and it is likely not affecting too many
   people out there so it might as well pass.

   My gnucash package is v3.0.-1.1.
   And, no, the .config/gnucash is definitely not there but obviously the
   config files are located somewhere.
   The .register-cursor row is almost unusable with a dark theme as the
   text remains black (and gets a dark background from the theme) so I'll
   look around for the settings folder in order to modify the text color
   to something lighter.

   Cheers
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Accounts columns currency

[Alen Siljak]

   > I think that the currency offered on the accounts page is the
   currency of the root account. That’s set when you create a new book
   with File>New and its default is the default currency in Preferences.
   Once it’s set for a book it can’t be changed in the GUI.

   Thanks for the info, John. I was hoping it was that easy. But... Here
   are a few interesting details:

   - I wanted to convert my XML book to SQLite and modify the root-account
   currency. However, I see no other book format options besides xml.
   GnuCash was installed from the default OpenSuse repo.
   - Checked one of the SQLite backup files and the root account is
   already in EUR commodity.
   - The summary line at the bottom of the Accounts window is showing all
   the amounts in Euros, respecting the default currency setting, it
   seems.

   But the list of columns that can be added to the Accounts window still
   only contains the locale currency (GBP).
   Changing the system default language also had no effect on the currency
   displayed here.
   I was going to check the config directory but I see no
   ~/.config/gnucash.

   The story continues.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Importing Quicken

[Alen Siljak]

Hi, David,

You are right. I've removed the benefits section but kept the fact about open 
data standards. Apart from being a benefit (to me), it is also a consequence of 
migration that may or may not be important for users.

> You mention multi-currency problems with QIF, saying that GnuCash only 
> handles one currency per file. However, I am under the impression that the 
> problem of multiple currencies had to do with the *QIF* specification, and 
> not GnuCash. In other words, the problem isn't that GnuCash doesn’t handle 
> multiple currencies, it’s that QIF doesn’t. Can anyone confirm that for me?

Yes, that's probably true. However, if an application interprets a transfer in 
such a manner that it takes 100 Euros from one and then deposits 100 AUD into 
another account without warning the user, that's a big no-no for me.

Thanks for the feedback!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash 3.0 Released

[Alen Siljak]

Congratulations on that big milestone!
And thank you for all the time and effort that went into this application.

> Sent: Monday, April 02, 2018 at 10:17 PM
> From: "John Ralls" 
> To: Gnucash-User 
> Cc: gnucash-devel , gnucash-annou...@gnucash.org
> Subject: GnuCash 3.0 Released
>
> GnuCash 3.0 released
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Re: Latest version for Windows?

[Alen Siljak]

   Thanks a lot, John, for the prompt action!
   I installed the latest weekly build assuming that would be the latest
   maintenance version. Basically, this means I could safely rely on
   GitHub Releases page for the stable updates.
   Cheers
   --
   Sent from my Android phone with GMX Mail.

   On 9/2/18, 20:32 John Ralls  wrote:

 > On Feb 9, 2018, at 7:41 AM, John Ralls  wrote:
 >
 >
 >
 >> On Feb 9, 2018, at 5:57 AM, cicko  wrote:
 >>
 >> I find a bit confusing as to where to find the latest version for
 Windows.
 >> The maintainance releases are apparently going out but somehow I
 canʼt
 >> figure out what the flow is.
 >>
 >> The main [1]www.gnucash.org page points to
 >>
 [2]http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.
 19-1.setup.exe
 >> which does not exist.
 >>
 >> The Installation page simply points to the Windows directory on
 SourceForge.
 >> The Stable version there is
 >>
 [3]https://sourceforge.net/projects/gnucash/files/gnucash%20%28stabl
 e%29/2.6.19/gnucash-2.6.19-setup.exe/download
 >> which looks like the first 2.6.19 version?
 >> However, on the same page there is a hash
 >> 1fa83d9578e8c62bd7dcef3b953e0e7610bf03bed9c1a037a72a6eee1ac79e37
 >> gnucash-2.6.19-3.setup.exe
 >> which refers to 2.6.19-3 version for Windows(!).
 >>
 >> And, finally, Windows wiki page
 ([4]https://wiki.gnucash.org/wiki/Windows)
 >> points to
 >> [5]https://code.gnucash.org/builds/win32/maint/
 >> which shows what I believe are the weekly maintenance builds,
 based on the
 >> info in their names and the description on the wiki page.
 >>
 >> So, if I want to get the *latest stable version* for Windows,
 which one
 >> should I use?
 >
 > You should use
 [6]https://sourceforge.net/projects/gnucash/files/gnucash%20%28stabl
 e%29/2.6.19/gnucash-2.6.19-setup.exe/download<[7]https://sourceforge
 .net/projects/gnucash/files/gnucash%20(stable)/2.6.19/gnucash-2.6.19
 -setup.exe/download> or
 [8]https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnuca
 sh-2.6.19-setup.exe<[9]https://github.com/Gnucash/gnucash/releases/d
 ownload/2.6.19/gnucash-2.6.19-setup.exe>
 >
 > (They’re the same file; Github lacks SourceForge’s annoying
 advertising).
 >
 > And I’ll get the mess of wrong pointers and names cleaned up.
 >
 The pointer on [10]www.gnucash.org and the README.txt on SourceForge
 are fixed now. Sorry for the confusion.
 Regards,
 John Ralls

References

   1. http://www.gnucash.org/
   2. 
http://downloads.sourceforge.net/sourceforge/gnucash/gnucash-2.6.19-1.setup.exe
   3. https://sourceforge.net/projects/gnucash/files/gnucash 
(stable)/2.6.19/gnucash-2.6.19-setup.exe/download
   4. https://wiki.gnucash.org/wiki/Windows
   5. https://code.gnucash.org/builds/win32/maint/
   6. https://sourceforge.net/projects/gnucash/files/gnucash 
(stable)/2.6.19/gnucash-2.6.19-setup.exe/download
   7. https://sourceforge.net/projects/gnucash/files/gnucash 
(stable)/2.6.19/gnucash-2.6.19-setup.exe/download
   8. 
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-2.6.19-setup.exe
   9. 
https://github.com/Gnucash/gnucash/releases/download/2.6.19/gnucash-2.6.19-setup.exe
  10. http://www.gnucash.org/
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Scheduled Transactions

[Alen Siljak]

   Yep,

   It would be fantastic if I could pick which transaction to enter and
   ignore all others from the Since Last Run window. With
   not-so-strictly-dated transactions I have to set the due date to the
   latest when they usually occur, and then add a reminder ahead so that I
   can enter them if they happen earlier.
   This could happen either by setting all the (i.e. "To-Create")
   transactions to "Reminder" and then manually choosing one to actually
   enter.
   Also, I like to always double-check on created transactions so ability
   to set the "Check the created transactions" default would be great.
   Reviewing created transactions is also mandatory when the actual
   transaction happens earlier than scheduled because then I need to
   modify the date after entering into register.

   Whether this happens on Since Last Run window or the scheduled
   transactions editor (i.e. having an Enter and/or Skip buttons), does
   not matter much.

   I've already submitted something along those lines at BugZilla:

   https://bugzilla.gnome.org/show_bug.cgi?id=791857
   https://bugzilla.gnome.org/show_bug.cgi?id=792121
   https://bugzilla.gnome.org/show_bug.cgi?id=792241

   It's just that I'm not sure how much time the devs would dedicate to
   this, having more important priorities. However, some of these are
   really not that difficult so perhaps someone picks them up.

   Cheers!

   Sent: Wednesday, February 07, 2018 at 1:39 PM
   From: "Colin Law" 
   To: cicko 
   Cc: gnucash-user 
   Subject: Re: Scheduled Transactions


 Hence I will really appreciate any progress on the Scheduled
 Transactions
 window. :)


   Are there features lacking that you want?

   Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Thank You!

[Alen Siljak]

   I'll join in on the thanks list by saying that I'm getting happier by
   the day after recently switching to GnuCash. It's a wonderful piece of
   software. Double-entry accounting often saves the day and makes me
   wonder how could I live without it for so long.
   And the sugar on top of all that is the fact that I can tap directly
   into the database and create a report/view for any piece of information
   I want to see. I'm still getting used to this but finally I feel my
   hands are untied and I can create a set of tools I've kinda been
   waiting for years to be implemented by someone else.
   So, thanks guys for being there for so long and keeping this software
   humming along.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Feedback for 2.7.2 on Windows

[Alen Siljak]

   Hi!

   This is my first post to the list and I'm still figuring out where all
   the different pieces of information should be addressed. I'm not sure
   if there is a specific channel for the unstable version feedback, apart
   from BugZilla.
   I had a brief run of the 2.7.2 version of GnuCash on Windows 10. It
   took a while to start the first time but everything went well there.
   The application seems quicker and more responsive than 2.6.18 in
   general.
   One thing I noticed, though, is that no custom reports were available
   in the Reports menu even though the settings were correctly copied to
   the new location in the roaming profile folder.

   Other than that, I'd like to thank you very much for this software
   package. I've followed it for years but have only made the switch
   recently. I'm still in the process of migrating the data. I really like
   being able to run my own reports on the data and, in that regard, I
   hope for more extensibility in the future. Python bindings are a great
   idea but they are currrently not available on Windows.
   Fortunately, Sebastien provided some wonderful functionality for Python
   in the form of piecash and gnucash-utilities project. I'm writing some
   portfolio tools and reports that I find missing in GnuCash, on top of
   those two projects, in https://github.com/MisterY/gnucash-portfolio.
   We'll see what this grows into and/if these get merged.

   Cheers,

   Alen
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.