Re: [GNC] GNUCash Documentation

2019-03-13 Thread 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 >

[GNC] GNUCash Documentation

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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 >

Re: [GNC] retained earnings in balance sheet: where does it come from?

2019-03-13 Thread 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*

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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:

[GNC] GNUcash Product description in report

2019-03-13 Thread 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

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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,

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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,

Re: [GNC] How to customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?

2019-03-13 Thread 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

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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, >

Re: [GNC] How to customize the columns shown in the "generic import transaction matcher" (when downloading transactions from my bank) ?

2019-03-13 Thread 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 > >

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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, >

Re: [GNC] HELP! No lock!?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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.

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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

Re: [GNC] Using a mysql database?

2019-03-13 Thread 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