Re: [GNC] GNUCash Documentation

[John Ralls]

> On Mar 13, 2019, at 7:03 PM, Justin Haynes  
> wrote:
> 
> I can probably start spending a little time each month contributing to 
> documentation.  I read about how to start contributing and noticed that one 
> of the steps is to open a bug in Bugzilla.  I noticed when searching Bugzilla 
> (https://bugs.gnucash.org/buglist.cgi?bug_status=__open___redirect=1=Importance=Documentation_format=specific
>  
> ),
>  that there are 50 bugs.  I skimmed them, to see what bugs looked like and 
> how people are working on them as evidenced in the comments. 
> 
> So I assume the following approach should work just fine, as I will not be 
> having or wanting commit access:
> 
> 1. If I see a bug I’d like to jump in and fix, and it doesn’t seem to be 
> getting attention - just confirm by posting a comment to the bug proposing to 
> work on it and see if I get a response within say 24 hours.  If I don’t see 
> anything back, start working on it and submit my patches, or whatever we're 
> calling them.
> 
> 2. If I notice something that needs fixing, submit a bug and start working on 
> it.  
> 
> Am I on the right track?

Pretty much.

If you can get your head around git and Github we generally prefer Github pull 
requests [1] and failing that that patches be created with git format-patch 
[2]. We do recognize that that may be too much to expect from non-programmers, 
so if you need help getting a patch into submittable shape by all means ask 
here or on IRC.


Regards,
John Ralls



[1] https://help.github.com/en/articles/about-pull-requests
[2] https://git-scm.com/docs/git-format-patch
___
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] GNUCash Documentation

[Justin Haynes]

I can probably start spending a little time each month contributing to 
documentation.  I read about how to start contributing and noticed that one of 
the steps is to open a bug in Bugzilla.  I noticed when searching Bugzilla 
(https://bugs.gnucash.org/buglist.cgi?bug_status=__open___redirect=1=Importance=Documentation_format=specific
 
),
 that there are 50 bugs.  I skimmed them, to see what bugs looked like and how 
people are working on them as evidenced in the comments. 

So I assume the following approach should work just fine, as I will not be 
having or wanting commit access:

1. If I see a bug I’d like to jump in and fix, and it doesn’t seem to be 
getting attention - just confirm by posting a comment to the bug proposing to 
work on it and see if I get a response within say 24 hours.  If I don’t see 
anything back, start working on it and submit my patches, or whatever we're 
calling them.

2. If I notice something that needs fixing, submit a bug and start working on 
it.  

Am I on the right track?


Justin
___
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] Using a mysql database?

[Klaus Dahlke]

On Wed, 13 Mar 2019 08:27:13 +
Colin Law  wrote:

> On Tue, 12 Mar 2019 at 22:42, Jacob Larsen  wrote:
> >
> > Hi
> >
> > How reliable is my data if I move from an XML file to a mysql database?
> 
> Do you have a specific reason for wanting to do that?
> 
> Colin
> ___

I run gnucash on postgresql since many years without an issue. One advantage 
for using a databsae is for that I can do reporting via ruby on rails from the 
database tables (read only access).

Cheers,
Klaus
___
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] retained earnings in balance sheet: where does it come from?

[Andrea Borgia]

Il 10/03/19 10:16, Adrien Monteleone ha scritto:



The fact that this is also the same amount as this particular
transaction you entered for 13/01/17 is purely coincidental. (and
should be, since it is entered in 2017 and you are running a balance
sheet as of 31/12/16, unless you *aren’t* setting that report date
properly) Transactions after 31/12/16 (or whatever date you run your
balance sheet for) are not part of the report calculation, so they
can’t affect it.


I'm not a big fan of coincidences where lots of transactions are
involved and the difference matches just one of them.

I had made an error in the P calculation for 2016, meaning I had
included that amount as a loss instead of leaving it out. Now that am 
splitting the file, I have fixed the mistake for 2016 already and 2017 
is next in line.




2015 might not show that line, but that would mean your expenses
match your income exactly for that year, an unlikely but not
impossible scenario.


No, no, it's downright impossible: I am saving quite a bit each year but
I was closing the books (even before splitting) at the end of the year
so the balance sheet on dec.31st would show all zeroes... unless someone
with fat fingers had made an error and included an entry from the
following year :P

With one file per year, I saw that closing the books on jan.1st of the 
following year would enable me to have a meaningful balance sheet and 
that's what I'll be doing. That has the added bonus of being much easier 
to carry over to the next year.



Last but not least, sorry if I mix up some terms: I am not an accountant 
so, each time I want to ask a question, I have to re-run gnucash in 
English to check whether the report I used in Italian is what I expect 
it to be with an English label.



Regards,
Andrea.
___
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] Using a mysql database?

[Jacob Larsen]

Ahh. It felt like it loaded faster from the database, but I just timed 
it and it is the same. In any case, the stalls on autosave are enough to 
switch to a database for me.


I have to add though that even if day-to-day writes to the database are 
instant then the initial import does take forever. Just one time though.


/Jacob

On 13/03/2019 19.52, D wrote:

If you're hoping that the db version is going to load faster, you should 
probably abandon that. As I have been told, the startup for the db isn't faster 
because Gnucash still loads the entire file into memory at startup. Saves are 
instant, though.

On March 14, 2019, at 12:11 AM, Jacob Larsen  wrote:

Hi

It is mainly to get around the long load times and stalls on autosaves
for v3.x. But having it (sequentially) accessible from multiple PCs is
an interesting bonus.

I will have it accessible on WAN through an SSH tunnel too, but I
suspect that the performance might not be very good here, so definitely
not a primary use case.

/Jacob

On 13/03/2019 09.27, Colin Law wrote:

On Tue, 12 Mar 2019 at 22:42, Jacob Larsen  wrote:

Hi

How reliable is my data if I move from an XML file to a mysql database?

Do you have a specific reason for wanting to do that?

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.

Re: [GNC] HELP! No lock!?

[Jack Slater]

I’ll do that from now on now that I know it’s safe 

> On Mar 13, 2019, at 1:48 PM, D  wrote:
> 
> Well, I find it much simpler to click "Open anyway" since I know no one else 
> has my Gnucash file open.
> 
> On March 14, 2019, at 12:01 AM, Jack Slater  wrote:
> 
> Hi Derek - I used Tom's answer:
> Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data
> folder. Near the bottom you'll see a file with type LCK. Delete it. Open
> GC and enjoy.
> 
>> On Wed, Mar 13, 2019 at 1:22 PM Derek Atkins  wrote:
>> 
>> Hi Jack,
>> 
>> 
>>> On Wed, March 13, 2019 2:09 pm, Jack Slater wrote:
>>> Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
>>> window:
>>> 
>>> "GnuCash could not obtain the lock for C:\" ( etc. file location)
>>> 
>>> option to open read only (wont work for me!),create new file, open
>> anyway,
>>> quit
>> 
>> First thing to try:  Do you have another copy of GnuCash open?
>> If NOT...  What happens of you try "Open Anyway"?
>> 
>> Here's what's going on.  When GnuCash is open, it creates the lock file to
>> ensure a second copy doesn't grab the file and possibly cause you to lose
>> data.  If you shut down the computer while GnuCash was still running then
>> GnuCash didn't exit cleanly and, as a result, didn't delete the lock file.
>> 
>> The "Open Anyway" option is basically your way to tell GnuCash that this
>> is what happened.
>> 
>> So, does that work?
>> 
>>> I need to get that file open it has all my data!
>>> 
>>> I do have a back up.
>> 
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> -derek
>> 
>> --
>>   Derek Atkins 617-623-3745
>>   de...@ihtfp.com www.ihtfp.com
>>   Computer and Internet Security Consultant
>> 
>> 
> ___
> 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] GNUcash Product description in report

[Martijn Heuts]

Hello,
Before I did an update many months ago I was able to create a particular report 
and for some reason I can't figure out how I did itas I lost all my reports 
after the update.
The report had products I sold in there. This report was generated from when I 
created an invoice and gave a description of the productI sold. I had a report 
created which showed me all the 'descriptions' (my products) and it included 
the date/month, price and product description.
All I can do right now is generate a similar report but it has the customer 
name instead of the product description.
Any help I would really appreciate it.
Thanks,

Martijn

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

Re: [GNC] HELP! No lock!?

[Michael or Penny Novack]

On 3/13/2019 2:57 PM, Derek Atkins wrote:

I would think just clicking "Open Anyway" would be easier.
But glad you got it working :)

-derek

 The important thing is that BEFORE you jump to either using "open 
anyway" or deleting the lock file you take a few seconds to think about 
WHY this happened?


IF you are positive there was no crash or force shutdown with gnucash 
running CHECK that there isn't an instance of gnucash running. In other 
words, close the one you are in and then check the list of running jobs.


Michael D Novack

PS: Do NOT simply delete every file ending with extension .lck Just the 
one associated to the gnucash file you are trying to open (look at the 
part before the .lck)   It isn't only gnucash that uses lock files.

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

Re: [GNC] HELP! No lock!?

[Derek Atkins]

I would think just clicking "Open Anyway" would be easier.
But glad you got it working :)

-derek

On Wed, March 13, 2019 2:28 pm, Jack Slater wrote:
> Hi Derek - I used Tom's answer:
> Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data
> folder. Near the bottom you'll see a file with type LCK. Delete it. Open
> GC and enjoy.
>
> On Wed, Mar 13, 2019 at 1:22 PM Derek Atkins  wrote:
>
>> Hi Jack,
>>
>>
>> On Wed, March 13, 2019 2:09 pm, Jack Slater wrote:
>> > Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
>> > window:
>> >
>> > "GnuCash could not obtain the lock for C:\" ( etc. file location)
>> >
>> > option to open read only (wont work for me!),create new file, open
>> anyway,
>> > quit
>>
>> First thing to try:  Do you have another copy of GnuCash open?
>> If NOT...  What happens of you try "Open Anyway"?
>>
>> Here's what's going on.  When GnuCash is open, it creates the lock file
>> to
>> ensure a second copy doesn't grab the file and possibly cause you to
>> lose
>> data.  If you shut down the computer while GnuCash was still running
>> then
>> GnuCash didn't exit cleanly and, as a result, didn't delete the lock
>> file.
>>
>> The "Open Anyway" option is basically your way to tell GnuCash that this
>> is what happened.
>>
>> So, does that work?
>>
>> > I need to get that file open it has all my data!
>> >
>> > I do have a back up.
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>Derek Atkins 617-623-3745
>>de...@ihtfp.com www.ihtfp.com
>>Computer and Internet Security Consultant
>>
>>
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

Re: [GNC] HELP! No lock!?

[D via gnucash-user]

Well, I find it much simpler to click "Open anyway" since I know no one else 
has my Gnucash file open.

On March 14, 2019, at 12:01 AM, Jack Slater  wrote:

Hi Derek - I used Tom's answer:
Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data
folder. Near the bottom you'll see a file with type LCK. Delete it. Open
GC and enjoy.

On Wed, Mar 13, 2019 at 1:22 PM Derek Atkins  wrote:

> Hi Jack,
>
>
> On Wed, March 13, 2019 2:09 pm, Jack Slater wrote:
> > Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
> > window:
> >
> > "GnuCash could not obtain the lock for C:\" ( etc. file location)
> >
> > option to open read only (wont work for me!),create new file, open
> anyway,
> > quit
>
> First thing to try:  Do you have another copy of GnuCash open?
> If NOT...  What happens of you try "Open Anyway"?
>
> Here's what's going on.  When GnuCash is open, it creates the lock file to
> ensure a second copy doesn't grab the file and possibly cause you to lose
> data.  If you shut down the computer while GnuCash was still running then
> GnuCash didn't exit cleanly and, as a result, didn't delete the lock file.
>
> The "Open Anyway" option is basically your way to tell GnuCash that this
> is what happened.
>
> So, does that work?
>
> > I need to get that file open it has all my data!
> >
> > I do have a back up.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
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] Using a mysql database?

[Jean-David Beyer via gnucash-user]

On 3/13/19 1:15 PM, Stephen M. Butler wrote:
> Also remember that data is only as reliable as that which is entered. 
> The third law of thermodynamics states it only gets worse over time.

A database rule I encountered and seems to be true is a corrolary to GI-GO:

A databbase's data are only good if the people entering the data are
those that are going to use it. If you have rooms full of bored clerks
typing it in on terminals, who have no idea what it means, and could not
care less, the data will be bad to begin with. And, as you said, its
entropy will only increase.

I remember a database of telephone directory entries that someone had
run a program on to improve it.

One entry was TOYS R US that got corrected to TOYS R UNITED STATES


-- 
  .~.  Jean-David Beyer
  /V\  PGP-Key:166D840A 0C610C8B
 /( )\ Shrewsbury, New Jersey
 ^^-^^ 14:35:01 up 10 days, 22:38, 2 users, load average: 4.29, 4.59, 4.64
___
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] Using a mysql database?

[Jacob Larsen]

Hi

It is mainly to get around the long load times and stalls on autosaves 
for v3.x. But having it (sequentially) accessible from multiple PCs is 
an interesting bonus.


I will have it accessible on WAN through an SSH tunnel too, but I 
suspect that the performance might not be very good here, so definitely 
not a primary use case.


/Jacob

On 13/03/2019 09.27, Colin Law wrote:

On Tue, 12 Mar 2019 at 22:42, Jacob Larsen  wrote:

Hi

How reliable is my data if I move from an XML file to a mysql database?

Do you have a specific reason for wanting to do that?

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] HELP! No lock!?

[Jack Slater]

Hi Derek - I used Tom's answer:
Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data
folder. Near the bottom you'll see a file with type LCK. Delete it. Open
GC and enjoy.

On Wed, Mar 13, 2019 at 1:22 PM Derek Atkins  wrote:

> Hi Jack,
>
>
> On Wed, March 13, 2019 2:09 pm, Jack Slater wrote:
> > Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
> > window:
> >
> > "GnuCash could not obtain the lock for C:\" ( etc. file location)
> >
> > option to open read only (wont work for me!),create new file, open
> anyway,
> > quit
>
> First thing to try:  Do you have another copy of GnuCash open?
> If NOT...  What happens of you try "Open Anyway"?
>
> Here's what's going on.  When GnuCash is open, it creates the lock file to
> ensure a second copy doesn't grab the file and possibly cause you to lose
> data.  If you shut down the computer while GnuCash was still running then
> GnuCash didn't exit cleanly and, as a result, didn't delete the lock file.
>
> The "Open Anyway" option is basically your way to tell GnuCash that this
> is what happened.
>
> So, does that work?
>
> > I need to get that file open it has all my data!
> >
> > I do have a back up.
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>Derek Atkins 617-623-3745
>de...@ihtfp.com www.ihtfp.com
>Computer and Internet Security Consultant
>
>
___
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 customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?

[Derek Atkins]

On Wed, March 13, 2019 2:23 pm, a b wrote:
> What a shame! :((

Patches always welcome!

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

Re: [GNC] HELP! No lock!?

[Maf. King]

On Wednesday, 13 March 2019 18:09:12 GMT Jack Slater wrote:
> Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
> window:
> 
> "GnuCash could not obtain the lock for C:\" ( etc. file location)
> 
> option to open read only (wont work for me!),create new file, open anyway,
> quit
> 
> I need to get that file open it has all my data!
> 
> I do have a back up.

Hi,

this happens if GC has crashed or otherwise not shut down properly.   If you 
are sure that GC is not still running, and another user hasn't got the file 
open, then the "open anyway" option is the one to go for.  Does exactly the 
same thing as going and deleting the lock manually in a file manger...

Maf.



___
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 customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?

[a b]

What a shame! :((

On Wed, 13 Mar 2019, 00:33 John Ralls  wrote:

>
>
> > On Mar 12, 2019, at 1:42 PM, a b  wrote:
> >
> > HI there,
> >
> > *Just joined the list (as I found nothing helpful on this on Google and
> > this list seems to be the most up-to-date place for asking
> gnucash-related
> > stuff)*.
> >
> > For a while now, I'm using the
> >
> > [Actions --> Online Actions --> Get Transactions...]
> >
> > feature to get my banking transactions into gnucash. So far so good.
> >
> > However, the "generic import transaction matcher"-windows which pops up
> as
> > part of this process is not much to my liking: It shows a number of (to
> me)
> > irrelevant columns; I'd like it to just always show a) the columns I'm
> > interested in and b) remember the ideal width per column (as set by me
> > *once*). How to achieve this? Possible (and if so, how easily
> > accomplishable)?
> >
>
> That dialog isn't customizable, sorry.
>
> 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] HELP! No lock!?

[Derek Atkins]

Hi Jack,


On Wed, March 13, 2019 2:09 pm, Jack Slater wrote:
> Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
> window:
>
> "GnuCash could not obtain the lock for C:\" ( etc. file location)
>
> option to open read only (wont work for me!),create new file, open anyway,
> quit

First thing to try:  Do you have another copy of GnuCash open?
If NOT...  What happens of you try "Open Anyway"?

Here's what's going on.  When GnuCash is open, it creates the lock file to
ensure a second copy doesn't grab the file and possibly cause you to lose
data.  If you shut down the computer while GnuCash was still running then
GnuCash didn't exit cleanly and, as a result, didn't delete the lock file.

The "Open Anyway" option is basically your way to tell GnuCash that this
is what happened.

So, does that work?

> I need to get that file open it has all my data!
>
> I do have a back up.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

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

Re: [GNC] HELP! No lock!?

[Tom Balaban]

Simple fix. Close GNUCash. Use File Explorer to navigate to your GC data 
folder. Near the bottom you'll see a file with type LCK. Delete it. Open 
GC and enjoy.




-- Original Message --
From: "Jack Slater" 
To: gnucash-user@gnucash.org
Sent: 3/13/2019 2:09:12 PM
Subject: [GNC] HELP! No lock!?


Just tried to start up GC. Fresh boot of Win 10 PC and I get a message
window:

"GnuCash could not obtain the lock for C:\" ( etc. file location)

option to open read only (wont work for me!),create new file, open anyway,
quit

I need to get that file open it has all my data!

I do have a back up.
___
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] Using a mysql database?

[Craig Van Tassle]

I have been using GnuCash with a MySQL database. I used it for the 
ability to replicate to an offsite backup/slave.

That feature has saved me a number of times.

Local LAN is very fast. Even over a slow WAN connection it's pretty fast 
as long as I keep the Database limited to about a year.
If I kept more then 3 years of moderate personal use, then it would 
start to slow down but not badly.



On 2019-03-12 20:14, Joseph Vernice wrote:

Been using MySQL DB for gnu cash for many years, mainly because of
security. Never had a problem. Very reliable and fast on my lan server.
Not sure how fast over internet.


On Tue, Mar 12, 2019 at 7:37 PM John Ralls  wrote:




> On Mar 12, 2019, at 3:39 PM, Jacob Larsen  wrote:
>
> Hi
>
> How reliable is my data if I move from an XML file to a mysql database?
I just tried saving my books in a mysql (MariaDB) database, reload 
from the
database, and then saving back to an XML file. The files are of the 
same
size, and they have a large chunk that is identical on both sides in 
my
difftool. But there is also a large chunk that differs, so most likely 
the
order is shuffled. I started xmldiff on it just to see what it finds, 
but

that tool has not yet returned.
>
> Does anyone here know if there are any issues with data reliability when
saving data in a mysql database?
>
> Also, do you happen to know a difftool for xml files that runs faster
than xmldiff? I started xmldiff on the 2x50MB (uncompressed) files I 
have

lying around, and it is still running for the last hour or so.
>

Jacob,

The list of open SQL backend bugs is
https://bugs.gnucash.org/buglist.cgi?bug_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=Backend%20-%20SQL_id=3199_format=advanced.
AFAICT none affect data integrity.

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.


___
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] Using a mysql database?

[Maf. King]

On Wednesday, 13 March 2019 12:53:13 GMT Joseph Vernice wrote:
> There are no logon credentials for an XML database, making it easy for
> someone to access your data.  I use a mysql database that requires
> credentials to log on.  Also, I change the port from the default 3306 to
> something else.  The port is blocked by my firewall.  I can do this only
> because the DB server is on my LAN.
> 

Hi Joseph,

Does MySQL default to encrypt the data it stores on disk?

I know the XML isn't encrypted by default, but it isn't especially hard to do 
with the correct tools at one's disposal, (along with other sensitive files 
that might be lurking under ~/ ) 

I'm not sure that there's much *real* security gain (vs perceived gain) from 
the requirement of an extra password to open the database in MySQL?

Maf.
 




___
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] Using a mysql database?

[Bucky Carr]

Thank you. Didn't know you could make a MySQL db, logon-only.

On 3/13/2019 6:53 AM, Joseph Vernice wrote:
There are no logon credentials for an XML database, making it easy 
for someone to access your data.  I use a mysql database that 
requires credentials to log on.  Also, I change the port from the 
default 3306 to something else.  The port is blocked by my 
firewall.  I can do this only because the DB server is on my LAN.


___
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] Using a mysql database?

[Derek Atkins]

Joseph,

On Wed, March 13, 2019 8:53 am, Joseph Vernice wrote:
> There are no logon credentials for an XML database,

Sure there are -- your user account login credentials!

Unless, of course, you don't HAVE user login credentials, at which point I
would say "there's your problem"!

>  making it easy for someone to access your data. 

They would need to break into your computer, first, to access your data! 
MySQL has a network flair to it, which means that there are probably MORE
people who can access that than your laptop/desktop with correct user
account settings.

>I use a mysql database that requires
> credentials to log on.  Also, I change the port from the default 3306 to
> something else.  The port is blocked by my firewall.  I can do this only
> because the DB server is on my LAN.

Note that AFAIK, mysql connections are not encrypted, so someone listening
on your network could see your data.  Your password is probably secure
because I do believe that it uses a hashed value over the wire. But if
you're doing it for security only, you're kind of missing the point.  :(

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Using a mysql database?

[Joseph Vernice]

There are no logon credentials for an XML database, making it easy for 
someone to access your data.  I use a mysql database that requires 
credentials to log on.  Also, I change the port from the default 3306 to 
something else.  The port is blocked by my firewall.  I can do this only 
because the DB server is on my LAN.


On 3/12/2019 8:38 PM, Bucky Carr wrote:



On 3/12/2019 6:14 PM, Joseph Vernice wrote:

Been using MySQL DB for gnu cash for many years, mainly because of
security. Never had a problem. Very reliable and fast on my lan server.
Not sure how fast over internet.


Hi. Can you explain a bit how the MySQL db is more secure than the 
standard xml, for example?


___
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] Using a mysql database?

[Colin Law]

On Tue, 12 Mar 2019 at 22:42, Jacob Larsen  wrote:
>
> Hi
>
> How reliable is my data if I move from an XML file to a mysql database?

Do you have a specific reason for wanting to do that?

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.