[GNC] Register issues within 3.2

[Alun Champion]

OS: MacOS
Version: Gnucash 3.2

After pasting (Cmd-V) data into a register the register will no longer
receive normal keyboard input, just the annoying keyboard beep.

Enter still works, as does tab but no data entry from the keyboard in any
field in the register for that account. Other registers for other accounts
continue to receive input (unless you paste something into that register).

This is very annoying because I often paste data from online account data.
   -Alun.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Fedora 28

[Ronal B Morse]

Gnucash 3.2-1 just became available in the Fedora 28 repositories.  I 
installed using DNF and experienced no unusual issues.


Thanks to whoever did the work.

RBM

___
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] Finance::Quote still not working with alphavantage

[David Carlson]

Greg,

Just so you don't feel like you are alone, I have GnuCash running on for
different machines one Windows and three are assorted versions of Uubuntu
and Debian.  Only one of them (one of the Ubuntu machines) will retrieve
quotes successfully through AlphaVantage, and that is about 1/3 to 1/2 of
the U.S. stocks and mutual funds in my list on a given try.  In two or
three tries I think that I get most of them. All of my machines are running
some GnuCash release between 2.6.12 and 2.6.17 and I think that I have gone
through all the steps that have been mentioned in this thread on most of
the machines but GnuCash still does not even tell me that it did not get
any of those stocks or mutual funds.

I suspect that GnuCash may not even be able to find the environment setting
or something.


David C

On Thu, Jul 5, 2018 at 1:05 PM, Greg Etling  wrote:

> Reviving this thread - I decided to follow others' recommendation of
> installing perlbrew, and F::Q is working from the CLI. However, I'm not
> seeing any change in the Gnucash behavior (v2.6.21, key in the preferences
> pane, retrieval failing), so I think I'm missing a step on having Gnucash
> actually use the perlbrew version of perl. Can anyone let me know what I'm
> likely forgetting?
>
> Thanks
>
> Greg
> 917-664-0083
> http://gregetling.com
> --
> "The credit belongs to the man who is actually in the arena, whose face is
> marred by dust and sweat and blood; who strives valiantly; who errs, who
> comes short again and again, because there is no effort without error and
> shortcoming" -Theodore Roosevelt
>
> On Sun, Nov 19, 2017 at 4:59 PM, Frank Saporito <
> frank.saporito...@gmail.com
> > wrote:
>
> > Hi Greg
> >
> > Is this what you are looking for?
> >
> > $ ONLINE_TEST=1 prove -lvof t/alphavantage.t
> > Cannot determine source for t/alphavantage.t at
> > /usr/share/perl5/App/Prove.pm line 496
> >
> > thanks
> >
> >
> >
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-
> f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] how to share style sheets between computers in GnuCash 3.1?

[Geert Janssens]

Op donderdag 5 juli 2018 19:31:29 CEST schreef Mark Hedges:
> Thanks Geert!
> 
You're welcome.

> BTW I get a lot of DKIM rejection reports from recipient servers when I
> send mail to the list.  Is that because the list server strips the
> anti-spam headers from my message before it forwards it out?  Maybe there
> is a patch for that.
> 
I don't know. This is something our mailing list adminstrator may know more 
about... Forwarding back to the list...

> Mark
> 
Geert


___
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] Finance::Quote still not working with alphavantage

[Greg Etling]

Reviving this thread - I decided to follow others' recommendation of
installing perlbrew, and F::Q is working from the CLI. However, I'm not
seeing any change in the Gnucash behavior (v2.6.21, key in the preferences
pane, retrieval failing), so I think I'm missing a step on having Gnucash
actually use the perlbrew version of perl. Can anyone let me know what I'm
likely forgetting?

Thanks

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 19, 2017 at 4:59 PM, Frank Saporito  wrote:

> Hi Greg
>
> Is this what you are looking for?
>
> $ ONLINE_TEST=1 prove -lvof t/alphavantage.t
> Cannot determine source for t/alphavantage.t at
> /usr/share/perl5/App/Prove.pm line 496
>
> thanks
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
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] autocomplete not working in 3.2

[Irving Duran]

+1

Thank You,

Irving Duran


On Thu, Jul 5, 2018 at 10:09 AM Alun Champion  wrote:

> I can confirm 3.2 has issues with completion on MacOS.
> When typing in the register description the first letter completes but the
> next letter inserts vs replaces the proposed completion, so if you intended
> `commute`, `c` would complete to `car` and the next key would end up with
> `coar`, which isn't the intended behaviour.
>
> Also I've had an issue occur multiple times where it would start not
> accepting any normal keyboard input in any field of the register, and need
> to restart the application. (Note: cut and paste still works).
>
> Regards
>-Alun.
>
>
> On 4 July 2018 at 18:45, John Ralls  wrote:
>
> > This problem has been reported in the bug tracker as
> > https://bugs.gnucash.org/show_bug.cgi?id=796734.
> >
> > For a workaround one can rename or remove Gnucash.app/Contents/
> > Resources/lib/gtk-3.0/3.0.0/immodules.cache. Note that that will break
> > the use of input modules so one will no longer be able to work in Asian
> > languages that require input modules.
> >
> > Regards,
> > John Ralls
> >
> >
> > > On Jul 3, 2018, at 8:30 PM, V. Vatsal via gnucash-user <
> > gnucash-user@gnucash.org> wrote:
> > >
> > > I am new to GnuCash, but I can confirm that autocomplete doesn’t work
> > well on Mac OS. I would expect that typing “foo” would match
> > “Expenses:Food” but it doesn’t match anything unless you type the whole
> > string “expenses:foo” which rather defeats the purpose.
> > >
> > > Nike
> > >
> > >> On Jul 3, 2018, at 7:45 PM, Deane Yamane 
> > wrote:
> > >>
> > >> I have the same problems. IMHO V3.x has been buggy from the start.
> Some
> > nice features but not worth it. I think I’ll revert to 2.26(?) and wait
> > till the ‘dust clears’ :(
> > >>> On Jul 1, 2018, 2:34 AM -1000, Michael Matz  >,
> > wrote:
> > >>> I just upgraded from 3.0 to 3.2. macOs 10.13.5
> > >>>
> > >>> (I skipped 3.1 because 3.0 has worked well for me, with the limited
> > set of
> > >>> features I use.)
> > >>>
> > >>> When I enter a new transaction, I type the first letter in the
> > description
> > >>> column and GnuCash makes a suggestion but if I continue typing the
> > >>> suggestion is not updated or replaced.
> > >>>
> > >>> For example, if I type "F" the description becomes "Food". If I then
> > type
> > >>> "a" then the description becomes "Faood". Or typing "Fo" becomes
> > "Foood"
> > >>> This worked as expected in 3.0 and previous versions, i.e. typing
> "Fa"
> > >>> results in "Fa" (no suggestion) and typing "Fo" result in "Food".
> > >>>
> > >>> The same thing happens in the Transfer column
> > >>>
> > >>> Anybody else having this problem?
> > >>>
> > >>> I've switched back to 3.0 for now.
> > >>>
> > >>> Thanks,
> > >>> Michael
> > >>> ___
> > >>> gnucash-user mailing list
> > >>> gnucash-user@gnucash.org
> > >>> To update your subscription preferences or to unsubscribe:
> > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >>> If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > >>> -
> > >>> Please remember to CC this list on all your replies.
> > >>> You can do this by using Reply-To-List or Reply-All.
> > >> ___
> > >> gnucash-user mailing list
> > >> gnucash-user@gnucash.org
> > >> To update your subscription preferences or to unsubscribe:
> > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >> If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > >> -
> > >> Please remember to CC this list on all your replies.
> > >> You can do this by using Reply-To-List or Reply-All.
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-u

Re: [GNC] autocomplete not working in 3.2

[Alun Champion]

I can confirm 3.2 has issues with completion on MacOS.
When typing in the register description the first letter completes but the
next letter inserts vs replaces the proposed completion, so if you intended
`commute`, `c` would complete to `car` and the next key would end up with
`coar`, which isn't the intended behaviour.

Also I've had an issue occur multiple times where it would start not
accepting any normal keyboard input in any field of the register, and need
to restart the application. (Note: cut and paste still works).

Regards
   -Alun.


On 4 July 2018 at 18:45, John Ralls  wrote:

> This problem has been reported in the bug tracker as
> https://bugs.gnucash.org/show_bug.cgi?id=796734.
>
> For a workaround one can rename or remove Gnucash.app/Contents/
> Resources/lib/gtk-3.0/3.0.0/immodules.cache. Note that that will break
> the use of input modules so one will no longer be able to work in Asian
> languages that require input modules.
>
> Regards,
> John Ralls
>
>
> > On Jul 3, 2018, at 8:30 PM, V. Vatsal via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > I am new to GnuCash, but I can confirm that autocomplete doesn’t work
> well on Mac OS. I would expect that typing “foo” would match
> “Expenses:Food” but it doesn’t match anything unless you type the whole
> string “expenses:foo” which rather defeats the purpose.
> >
> > Nike
> >
> >> On Jul 3, 2018, at 7:45 PM, Deane Yamane 
> wrote:
> >>
> >> I have the same problems. IMHO V3.x has been buggy from the start. Some
> nice features but not worth it. I think I’ll revert to 2.26(?) and wait
> till the ‘dust clears’ :(
> >>> On Jul 1, 2018, 2:34 AM -1000, Michael Matz ,
> wrote:
> >>> I just upgraded from 3.0 to 3.2. macOs 10.13.5
> >>>
> >>> (I skipped 3.1 because 3.0 has worked well for me, with the limited
> set of
> >>> features I use.)
> >>>
> >>> When I enter a new transaction, I type the first letter in the
> description
> >>> column and GnuCash makes a suggestion but if I continue typing the
> >>> suggestion is not updated or replaced.
> >>>
> >>> For example, if I type "F" the description becomes "Food". If I then
> type
> >>> "a" then the description becomes "Faood". Or typing "Fo" becomes
> "Foood"
> >>> This worked as expected in 3.0 and previous versions, i.e. typing "Fa"
> >>> results in "Fa" (no suggestion) and typing "Fo" result in "Food".
> >>>
> >>> The same thing happens in the Transfer column
> >>>
> >>> Anybody else having this problem?
> >>>
> >>> I've switched back to 3.0 for now.
> >>>
> >>> Thanks,
> >>> Michael
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> To update your subscription preferences or to unsubscribe:
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >>> -
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
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] Where is the theme selection in 3.x?

[cicko]

pj42uk wrote
> Your posting promped me to try this,  and starting with the sample
> GTK-3.0.css, having read the wiki 3 times, I've got it working and changed
> some colours. It is actually quite easy, even for a 76-year-old.
> Thank you.

Thank you for the feedback! That's really heart-warming.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] GnuCash 3.2 Released

[John Ralls]

> On Jul 5, 2018, at 12:56 AM, Geert Janssens  
> wrote:
> 
> Op donderdag 5 juli 2018 07:04:21 CEST schreef David Cousens:
>> On Wed, 2018-07-04 at 14:54 +0200, Geert Janssens wrote:
>>> Are you referring to the fact that uninstall doesn't remove empty
>>> directories
>>> 
>> 
>> No. The uninstall target in build.ninja as written by cmake was just an
>> empty stub. 
> 
> 
>> 
>> cmake_uninstall.cmake existed and had been created by cmake when it
>> configured the build, but it could not be executed from build.ninja.
>> Somewhere in the CMakeLists.txt files in the source something is
>> missing which writes the code into build.ninja to run
>> cmake_uninstall.cmake. 
> 
> This is odd in itself. I have been using ninja-build for months and the 
> uninstall target works just fine without your additions (it does leave the 
> directories of course).
> 
> So I don't understand why you would need to modify the generated build.ninja 
> file.
>> 
>> I think it would be nice to tidy up the uninstall of the directories as
>> well. John has pointed out elsewhere that it isn't absolutely necessary
>> to prevent any interference between installs and that this was
>> primarily for developers but with cmake now the primary build
>> configuration, those of us who like to keep ahead of the distro version
>> are likely to be building from source using cmak and ninja. 
>> 
>> With a /usr/local prefix, GnuCash does a nice install where the files
>> are all copied into directories named as gnucash:
>> /usr/local/lib/gnucash/...
>> /usr/local/share/gnucash/...
>> /usr/local/etc/gnucash/...
>> /usr/local/include/gnucash/...
>> 
>> and the directories I referred to were subdirectories of the respective
>> gnucash directories listed above. At present install_manifest.txt has
>> no explicit record of the existence of them as they are created on the
>> fly when files are installed in them by cmake_install.cmake (top level
>> of build directory) rather than being created explicitly with a mkdir.
>> 
>> Removing the above directories with "rm -r /lib/gnucash " and
>> similar commands for the others should do it with the appropriate
>> checking as you mentioned above.
> 
> Indeed. You could add something to that effect in cmake_uninstall.cmake.in
> 
>> 
>> There is a separate target in build.ninja for install/local (but not an
>> uninstall/local) for installing under a user home directory.
>> 
> build.ninja is generated based on the contents of the various CMakeLists.txt 
> and *.cmake files. I only look in build.ninja if a ninja build behaves 
> differently from a make build. Is that the case here ?
> 
> Note I always install in a custom prefix under my home directory. Perhaps 
> that's why my uninstall works where uninstall under /usr/local doesn't ?
> 
> Something to try when I find the time.
> 
>> Do you know if Rob Gowin is continuing to work on the cmake scripts or
>> not? I don't mind going in and trying to patch it, but if it is still a
>> work in progress then I don't want to get in his way, and I'm happy to
>> leave it to Rob if he is still developing them.
> 
> I don't know. I'll let Rob answer this.

Remember that CMake does things differently when told to install anywhere under 
/usr and /opt.

See https://cmake.org/cmake/help/latest/module/GNUInstallDirs.html 


Regards,
John Ralls

___
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] V3 cannot save on top of existing mysql database

[Colin Law]

On 5 July 2018 at 12:42, Geert Janssens  wrote:

> Op donderdag 5 juli 2018 10:12:56 CEST schreef Colin Law:
> > Are the powers-that-be aware of an apparent bug that prevents File > Save
> > As > Mysql over an existing database?
> >
> Yep: https://bugs.gnucash.org/show_bug.cgi?id=796724
> which is likely a duplicate of https://bugs.gnucash.org/show_
> bug.cgi?id=789594


Thanks Geert. I have added a note adding the information that this works ok
on 2.6.19 (with mysql at least).

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: [GNC] V3 cannot save on top of existing mysql database

[Geert Janssens]

Op donderdag 5 juli 2018 10:12:56 CEST schreef Colin Law:
> Are the powers-that-be aware of an apparent bug that prevents File > Save
> As > Mysql over an existing database?
> 
Yep: https://bugs.gnucash.org/show_bug.cgi?id=796724
which is likely a duplicate of https://bugs.gnucash.org/show_bug.cgi?id=789594

Geert

> The trace file shows
> 
> * 09:04:54  WARN  [GncDbiBackend::session_begin()]
> Databse already exists, Might clobber it.
> * 09:05:00  CRIT  [error_handler()] DBI error: 1050: Table
> 'versions' already exists
> * 09:05:00  CRIT  [GncDbiSqlConnection::create_table()]
> Error in dbi_result_free() result
> * 09:05:00  CRIT  [error_handler()] DBI error: 1062:
> Duplicate entry 'Gnucash' for key 'PRIMARY'
> * 09:05:00  CRIT 
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> INSERT INTO versions VALUES('Gnucash',302)
> * 09:05:00  CRIT 
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> versions VALUES('Gnucash',302)
> * 09:05:00  CRIT  [GncSqlBackend::set_table_version()] SQL
> error: INSERT INTO versions VALUES('Gnucash',302)
> * 09:05:00  CRIT  [error_handler()] DBI error: 1062:
> Duplicate entry 'Gnucash-Resave' for key 'PRIMARY'
> * 09:05:00  CRIT 
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
> INSERT INTO versions VALUES('Gnucash-Resave',19920)
> * 09:05:00  CRIT 
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> versions VALUES('Gnucash-Resave',19920)
> * 09:05:00  CRIT  [GncSqlBackend::set_table_version()] SQL
> error: INSERT INTO versions VALUES('Gnucash-Resave',19920)
> * 09:05:00  CRIT  [error_handler()] DBI error: 1050: Table
> 'books' already exists
> * 09:05:00  CRIT  [GncDbiSqlConnection::create_table()]
> Error in dbi_result_free() result
> ...
> 
> To replicate open an XML file, do File > Save As a new mysql db, revert to
> the XML one again, and Save As Mysql again with the same db name.
> 
> This is v3.2 build from tarball on Ubuntu 18.04.  Mysql 5.7.22.
> 
> 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.




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

[GNC] V3 cannot save on top of existing mysql database

[Colin Law]

Are the powers-that-be aware of an apparent bug that prevents File > Save
As > Mysql over an existing database?

The trace file shows

* 09:04:54  WARN  [GncDbiBackend::session_begin()]
Databse already exists, Might clobber it.
* 09:05:00  CRIT  [error_handler()] DBI error: 1050: Table
'versions' already exists
* 09:05:00  CRIT  [GncDbiSqlConnection::create_table()]
Error in dbi_result_free() result
* 09:05:00  CRIT  [error_handler()] DBI error: 1062:
Duplicate entry 'Gnucash' for key 'PRIMARY'
* 09:05:00  CRIT 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO versions VALUES('Gnucash',302)
* 09:05:00  CRIT 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
versions VALUES('Gnucash',302)
* 09:05:00  CRIT  [GncSqlBackend::set_table_version()] SQL
error: INSERT INTO versions VALUES('Gnucash',302)
* 09:05:00  CRIT  [error_handler()] DBI error: 1062:
Duplicate entry 'Gnucash-Resave' for key 'PRIMARY'
* 09:05:00  CRIT 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing SQL
INSERT INTO versions VALUES('Gnucash-Resave',19920)
* 09:05:00  CRIT 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
versions VALUES('Gnucash-Resave',19920)
* 09:05:00  CRIT  [GncSqlBackend::set_table_version()] SQL
error: INSERT INTO versions VALUES('Gnucash-Resave',19920)
* 09:05:00  CRIT  [error_handler()] DBI error: 1050: Table
'books' already exists
* 09:05:00  CRIT  [GncDbiSqlConnection::create_table()]
Error in dbi_result_free() result
...

To replicate open an XML file, do File > Save As a new mysql db, revert to
the XML one again, and Save As Mysql again with the same db name.

This is v3.2 build from tarball on Ubuntu 18.04.  Mysql 5.7.22.

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: [GNC] Windows 10 installation very slow opening or saving file

[Geert Janssens]

Some people have reported saving took considerably less time when they made 
the gnucash window as small as possible. This suggests gnucash is repeatedly 
updating its window contents while saving.

Can you check if this makes a difference for you ?

Geert

Op donderdag 5 juli 2018 08:19:01 CEST schreef Derick Jordaan:
> I downgraded to 2.6 - could not resolve it on Windows 10 - deleting some
> recovery files helped a little, but still a major problem - not usable in
> my view.
> 
> On Thu, 5 Jul 2018 at 08:11, Jamestk  wrote:
> > djza wrote
> > 
> > > Thank you for the feedback, I did check the threads in the May archive,
> > > also cleaned out the backup files (of which there were a lot), but the
> > > improvement (if any) is only marginal.  I see there were some bug
> > > reports
> > > relating to this, so I suspect I am also going to drop back to 2.6 and
> > 
> > see
> > 
> > > how that is, this is not workable as it stands.
> > > 
> > > 
> > > 
> > > On Wed, 30 May 2018 at 10:24, Geert Janssens <
> > > 
> > > geert.gnucash@
> > > 
> > > >
> > > 
> > > wrote:
> > >> Op woensdag 30 mei 2018 10:12:37 CEST schreef Maf. King:
> > >> > Hi Derick,
> > >> > 
> > >> > someone else reported crazy long save times on Win10 platforms
> > >> > earlier
> > >> 
> > >> this
> > >> 
> > >> > month - don't recall if there was a solution found, but have a hunt
> > >> 
> > >> through
> > >> 
> > >> > the archives for May and see if that thread offers any help.
> > >> > 
> > >> > HTH,
> > >> > Maf.
> > >> 
> > >> I believe there was mention of the load times slowing down when there
> > 
> > are
> > 
> > >> lots
> > >> of backup files in the same directory. Try moving older backups to a
> > >> subdirectory and let us know if that reduces the load times.
> > >> 
> > >> Regards,
> > >> 
> > >> Geert
> > >> 
> > >> 
> > >> ___
> > >> gnucash-user mailing list
> > > 
> > > gnucash-user@
> > > 
> > >> To update your subscription preferences or to unsubscribe:
> > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > >> If you are using Nabble or Gmane, please see
> > >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > >> -
> > >> Please remember to CC this list on all your replies.
> > >> You can do this by using Reply-To-List or Reply-All.
> > > 
> > > ___
> > > gnucash-user mailing list
> > > 
> > > gnucash-user@
> > > 
> > > 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.
> > 
> > Did you have any luck with this?
> > 
> > Recently upgraded to latest version but auto saving really problematic
> > while
> > working, generally speaking it takes as long to load as saving relatively
> > small file.
> > 
> > Using Win 10 Pro with Samsung SSD
> > 
> > Going to switch off auto save for the moment to get things done.
> > 
> > 
> > 
> > --
> > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




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

Re: [GNC] GnuCash 3.2 Released

[Geert Janssens]

Op donderdag 5 juli 2018 07:04:21 CEST schreef David Cousens:
> On Wed, 2018-07-04 at 14:54 +0200, Geert Janssens wrote:
> > Are you referring to the fact that uninstall doesn't remove empty
> > directories
> >
> 
> No. The uninstall target in build.ninja as written by cmake was just an
> empty stub. 


> 
> cmake_uninstall.cmake existed and had been created by cmake when it
> configured the build, but it could not be executed from build.ninja.
> Somewhere in the CMakeLists.txt files in the source something is
> missing which writes the code into build.ninja to run
> cmake_uninstall.cmake. 

This is odd in itself. I have been using ninja-build for months and the 
uninstall target works just fine without your additions (it does leave the 
directories of course).

So I don't understand why you would need to modify the generated build.ninja 
file.
> 
> I think it would be nice to tidy up the uninstall of the directories as
> well. John has pointed out elsewhere that it isn't absolutely necessary
> to prevent any interference between installs and that this was
> primarily for developers but with cmake now the primary build
> configuration, those of us who like to keep ahead of the distro version
> are likely to be building from source using cmak and ninja. 
> 
> With a /usr/local prefix, GnuCash does a nice install where the files
> are all copied into directories named as gnucash:
> /usr/local/lib/gnucash/...
> /usr/local/share/gnucash/...
> /usr/local/etc/gnucash/...
> /usr/local/include/gnucash/...
> 
> and the directories I referred to were subdirectories of the respective
> gnucash directories listed above. At present install_manifest.txt has
> no explicit record of the existence of them as they are created on the
> fly when files are installed in them by cmake_install.cmake (top level
> of build directory) rather than being created explicitly with a mkdir.
> 
> Removing the above directories with "rm -r /lib/gnucash " and
> similar commands for the others should do it with the appropriate
> checking as you mentioned above.

Indeed. You could add something to that effect in cmake_uninstall.cmake.in

> 
> There is a separate target in build.ninja for install/local (but not an
> uninstall/local) for installing under a user home directory.
> 
build.ninja is generated based on the contents of the various CMakeLists.txt 
and *.cmake files. I only look in build.ninja if a ninja build behaves 
differently from a make build. Is that the case here ?

Note I always install in a custom prefix under my home directory. Perhaps 
that's why my uninstall works where uninstall under /usr/local doesn't ?

Something to try when I find the time.

> Do you know if Rob Gowin is continuing to work on the cmake scripts or
> not? I don't mind going in and trying to patch it, but if it is still a
> work in progress then I don't want to get in his way, and I'm happy to
> leave it to Rob if he is still developing them.

I don't know. I'll let Rob answer this.

Geert



___
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] Where is the theme selection in 3.x?

[Peter Jackson]

Your posting promped me to try this,  and starting with the sample
GTK-3.0.css, having read the wiki 3 times, I've got it working and changed
some colours. It is actually quite easy, even for a 76-year-old.
Thank you.


Nurton Court
Middleton-on-the-Hill
Ludlow SY8 4BD
Tel: 01568 750 248 Mob: 07955 586 476

On 4 July 2018 at 21:07, cicko  wrote:

> Well, Tom, it's certainly an interesting discussion in general. :)
>
> I'd like to make two points:
>
> - You keep referring to Windows and I'm not sure why. At the moment I'm
> using GnuCash on both Windows and Linux and can't say that there is much
> difference if we talk about changing visual appearance. Both are using dark
> themes. On Linux it is set at the OS level (window manager, actually) and
> in
> Windows I simply followed a tip from Geert, now listed at
> https://wiki.gnucash.org/wiki/GTK3, section 1.2.1 Dark Themes. All it
> takes
> is to create a settings.ini plain text file at %LOCALAPPDATA%\gtk-3.0 (you
> can paste that in Windows Explorer's address bar) and add the two lines
> listed there on the page.
> If you are looking for other types of customizations, do read that whole
> page. It *will* get simpler if you read it a few times over a few days.
> Things somehow sink in. Especially if you also try it in practice once,
> fail, try it again on another day. It works miracles.
>
> - Another point is about users not being developers. I get this a lot in
> all
> the Open Source projects I contributed to. And perhaps it is easy for me to
> say because I *am* a professional developer, but I could say that I know *a
> lot* of people who used to fix their own cars. None of them were car
> mechanics. A few people I know can fix almost anything they have at home
> (as
> long as it does not have software in it! :)) but they are not professional
> craftsmen or anything like that. Do note that it is year 2018. There is now
> almost nothing out there that works without software. It is up to you if
> you
> want to be semi-literate (sorry if it is sounds harsh, but yes, it is the
> 21st century, the age of Hal 9000 and all that), and yes, even HTML and CSS
> count in "programming" nowadays. What I would really, *really*, like you
> too
> look at is this - https://www.youtube.com/watch?v=TK1mBqKvIyU. He has a
> much
> better way of explaining this. Just look at the first five minutes if you
> don't have more time. You'll see what I mean. If you can make a figure out
> of wood and you're not a carpenter then why also not make your own
> accounting program or a tool to change visual appearance of it?
>
> This is addressed to all the users who shy away from doing any
> "development", nothing personal.
>
> Cheers
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Credit Notes

[Geert Janssens]

Op woensdag 4 juli 2018 23:01:31 CEST schreef Eric Rathhaus (general) via 
gnucash-user:
> I need to refund fees to a client that were paid on multiple invoices. I do
> not want to apply the refund to other outstanding invoices but rather need
> to cut  check and send to client. My idea is to create an invoice/credit
> note using the job created for general matters, which then would go into
> the AR account, and list the individual refunds and associated invoices in
> the notes sectiont. How do I reflect the next step in the transaction when
> I write a check from my checking account?
> 

You process a payment on the customer invoice, using the checking account as 
payment account.
GnuCash will create the payment transaction for you and mark the credit note 
as paid. If you want to print a check, at the same time you can enable this in 
the payment window.

Regards,

Geert


___
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] how to share style sheets between computers in GnuCash 3.1?

[Geert Janssens]

Op woensdag 4 juli 2018 22:11:17 CEST schreef Mark Hedges:
> Hi.
> 
> I store my v3.1 books in Google Drive.  I use the Backup & Sync plugin to
> share them between different computers.  The plugin syncs a desktop folder
> to Google Drive.  I use it like a normal file in Windows File Explorer.
> When the file changes, it uploads or downloads the new version
> automatically.
> 
> I created a style sheet on one computer using Edit > Style Sheets.
> However, the style sheet does not appear when I open the book on another
> computer.
> 
> I see some files in $HOME/.gnucash, like a file stylesheets-2.0.  That file
> appears to only have default style sheets.
> 
> I see a .gcm file in .gnucash/books named for my book that was saved
> recently, but not near the time I made the style sheet.  (On that note,
> this also seems to have book-specific settings in it, including account
> hierarchy ordering... why wouldn't this information be saved in the book's
> XML file to remain portable?)
> 
> I can't find any files in .gnucash that were saved after the time I created
> the style sheet, so I guess it is not stored there anymore after v.3.0.
> 
> Where are the stylesheets?  How do I make them portable between computers?
> 
> Here's my vote to make style sheets part of a book XML file so they go with
> the book.
> 
> It would also be nice if book-specific style sheets could be exportable to
> their own file to import them under a different book.
> 
They still are although under gnucash 3.x the file you're looking for is now 
stored in a new location.
You will find all the info you need on this wiki page:
https://wiki.gnucash.org/wiki/Configuration_Locations
Or more precisely:
https://wiki.gnucash.org/wiki/Configuration_Locations#In_GNC_DATA_HOME

Regards,

Geert


___
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] Changing default font size in Gnucash 3.2

[Geert Janssens]

Op woensdag 4 juli 2018 22:07:21 CEST schreef Daniel Dickinson:
> Thanks all for your replies.  Creating a gtk.css file in
> ~/Library/Application Support/Gnucash/config/gtk-3.0/ did the trick! 
> Perhaps the wiki should be updated to indicate that only the .css option is
> available on Mac?
> 
> Dan

Good idea. Please do!

Geert


___
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.