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 u
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
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 ea
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 fr
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.
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
On 3/13/19 1:27 AM, 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
> _
Also remember that data is only as reliable as that whi
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.
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 l
Life is s easy when you know the answers! Thanks for the speedy reply!
On Wed, Mar 13, 2019 at 1:15 PM Tom Balaban wrote:
> 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.
>
>
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,
> qui
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
> > s
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,
> qui
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 w
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, Jac
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, s
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
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
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 w
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 f
It's trivial to reset a mysql password, if you are relying on that to
provide ANY kind of security you might want to rethink.
Lawrence
On 13/3/19 10:53 pm, 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
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 happen
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 descri
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:
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
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
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 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__&no_redirect=1
> 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
> (h
To get invoice line items on a report do the following:
1. Do not ‘Accumulate Splits’ when you post the invoice(s). This can be done by
unchecking that box when posting, or fixing the preference globally. (this will
put each line item as its own split)
2. Open the the relevant Income/Revenue acc
30 matches
Mail list logo