Re: [GNC] Scary moment

2022-12-31 Thread R Losey
As a software engineer with ~40 years, I've learned to remember details... glad it was helpful. On Sat, Dec 31, 2022 at 11:51 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Not boring. Well detailed, thanks! > > It looks like that rules out file-access issues. > > Okay, last

Re: [GNC] Scary moment

2022-12-31 Thread R Losey
Your post came though for me, and I answered it. I only have Perl installed on Linux, so I can only do price updates there. On Sat, Dec 31, 2022 at 6:57 PM Robert Kesterson wrote: > I don’t know what that content is, but I didn’t knowingly post a binary > here (which is what that looks like).

Re: [GNC] Scary moment

2022-12-31 Thread R Losey
Well, before, if I ran the GnuCash GUI with it open on another machine, it tells me that the file is locked. I don't override the lock unless I know that the machine or GnuCash crashed. I have caught myself a handful of times over the last seven years, so it is possible, especially if the

Re: [GNC] Bank account reconciled, will this change screw things up?

2022-12-31 Thread Liz
On Fri, 30 Dec 2022 23:54:05 + "Dr. David Kirkby" wrote: > I think that I am in a minority here using them. They seem to make > things more complicated. I just hope that the benefits outweigh the > complications. > > Dave. I use them to create invoices and check that I have been paid but

Re: [GNC] One File, Two Users

2022-12-31 Thread Adrien Monteleone
On 12/31/22 2:43 PM, Paul Kroitor wrote: 1. Put the data file in an existing MySQL server in the cloud and allow the MySQL lockout mechanisms to deal with access conflicts; No go. At least if you're considering the MySQL backend. GnuCash doesn't use it except as a store. It reads the

Re: [GNC] Scary moment

2022-12-31 Thread Adrien Monteleone
Not sure where you saw that odd string. It didn't appear in your last post. Binaries would be stripped off anyway. It must be something with your mail client. Regards, Adrien On 12/31/22 6:56 PM, Robert Kesterson wrote: I don’t know what that content is, but I didn’t knowingly post a binary

Re: [GNC] Scary moment

2022-12-31 Thread Robert Kesterson
I don’t know what that content is, but I didn’t knowingly post a binary here (which is what that looks like). Speaking of scary moments… Anyway what I intended to post was something along the lines of this: Since the OP mentions using Gnucash both as an application and as a CLI utility on

Re: [GNC] One File, Two Users

2022-12-31 Thread Andreas Hentze
Hi Paul, I do #2 (using the sqlite file type) successfully. But I use my own cloud on a synology NAS disk station (as I want to be sure, that my data is mine :-)). Therefor I use the sync-client to the local disk and never had a Problem with the lockfile. Best regards

Re: [GNC] OFX import date questions

2022-12-31 Thread Phyllis Bruce
Hi Simon, the import had the proper transactions but was not matching a couple I had manually entered that were outside the default parameters. I thing I’ve got that sorted now. I’m running ver 4.13 of GC in Windows 11. I upgrade as soon as I know one has been distributed.

Re: [GNC] Autofill on import OFX?

2022-12-31 Thread Jean L
No you don't need to do anything for it to learn, except select the account the transaction should be associated with when you import the transaction so the matcher can remember that. Of course, that's only if you haven't already entered the transaction manually (in which case you already

Re: [GNC] One File, Two Users

2022-12-31 Thread Glenn Serre
Good afternoon Paul, Inline below... On Sat, Dec 31, 2022 at 12:44 PM Paul Kroitor wrote: [...] > So I need to find a way to allow two users, in two different cities, to > access a single set of books, but without an office infrastructure. Access > will be alternating, thus no simultaneous

Re: [GNC] Scary moment

2022-12-31 Thread Robert Kesterson
Maybe it has been asked already, but with the file being accessed from three separate machines, by a gui and by a CLI utility, are you sure it wasn’t open on two machine at once? That would explain everything if one machine made the changes, but another machine (which didn’t have the changes)

Re: [GNC] Autofill on import OFX?

2022-12-31 Thread Simon Roberts
Thanks for this Jean, Murugan, that's very helpful (and rather impressive!) Do I infer that I need to use the " right click on a transaction in the transaction matching window, you can edit various fields prior to the transaction being imported" feature so it knows I'm trying to teach it, rather

Re: [GNC] Matching error in OFX import

2022-12-31 Thread Simon Roberts
Good to know, but for 20.04,it gave me 3.8. On Sat, Dec 31, 2022 at 1:27 PM john wrote: > > > On Dec 31, 2022, at 8:14 AM, Simon Roberts > wrote: > > But, I will get back when I'm not using 3.8. It's sad (but clearly nobody > here is in control of this!) that Ubuntu is packaging such an old

[GNC] One File, Two Users

2022-12-31 Thread Paul Kroitor
Hi, long time user of GnuCash with various sets of books. Some are currently run in a quasi-office environment such that users in other cities can VPN into our LAN and thus open GnuCash books as though they are on a local server. But this infrastructure is now going away. So I need to find a

Re: [GNC] Matching error in OFX import

2022-12-31 Thread john
> On Dec 31, 2022, at 8:14 AM, Simon Roberts > wrote: > > But, I will get back when I'm not using 3.8. It's sad (but clearly nobody > here is in control of this!) that Ubuntu is packaging such an old version. They're not. You're using Ubuntu 20.04. The current Ubuntu release, 22.10, has

Re: [GNC] OFX import date questions

2022-12-31 Thread Phyllis Bruce
Yes, David C- to me, date issued is the date I wrote the check. By date cleared, I meant the date on the statement which I assume is the date the bank cleared the transaction. I'm also going to take a leap and assume the OFX and QFX operate the same since the two are on the same line as OFX/QFX

Re: [GNC] Autofill on import OFX?

2022-12-31 Thread Murugan Muruganandam
Simon GNUCash learns the transactions matching when you start input, and stores it for future reference. Same is the case with imported files, you can view the import map editor for details. please note you cannot directly enter the assocation here, but you can delete any wrong association

Re: [GNC] Autofill on import OFX?

2022-12-31 Thread Jean L
The transfer will be automatically assigned once you import a few transactions. GC is smart in the way it learns from previous imported transactions which account a given imported transaction should be assigned to. So give it a little time and it'll do the right thing. Another thing you may

[GNC] Autofill on import OFX?

2022-12-31 Thread Simon Roberts
Now that I have GC 4.13 and my imported transactions are correctly recognized and not dumped, I have another question. If I have a transaction with, for example, a description field of XYZ, and I start to enter a new transaction with the same description, and then hit tab, GC auto-fills all the

Re: [GNC] OFX import date questions

2022-12-31 Thread Simon Roberts
A side thought Phylls, I think your first observation was about some transactions that you had imported not showing up? If that's the case, what version of GnuCash are you running? I was running 3.8, which was the default from the Ubuntu Linux repositories. It was indeed failing to import some

Re: [GNC] Scary moment

2022-12-31 Thread Adrien Monteleone
Not boring. Well detailed, thanks! It looks like that rules out file-access issues. Okay, last gasp here: For safety, I'd make 2 copies for testing. 1. Update prices via GUI rather than CLI. Check if transactions disappear. Exit, reopen, check again. Since you were running the CLI update on

Re: [GNC] Scary moment

2022-12-31 Thread R Losey
Yes, I have an iMac (pretty new), a Win10 machine, and an older Linux machine (Ubuntu 22.04 LTS). The file - the only one I use - is stored on a NAS disk that all of the machines can access. Nothing has gone wrong with the disk that I can tell, since I use the NAS for a lot of stuff and there have

Re: [GNC] Scary moment

2022-12-31 Thread R Losey
My data file is stored on a NAS device (with redundant disks). I've been using GnuCash for seven years now, and have always kept it on the NAS and have had no issues like this before. My machines are three separate physical machines (I have an recent iMac, a Windows 10 machine, and an older

Re: [GNC] OFX import date questions

2022-12-31 Thread David Carlson
Phyllis, Reconciliation does* not* always change the date to date cleared. In fact, the only date messed with during reconciliation is the reconciliation date. That date is always automatically set to the date used by the reconciliation process. In fact, that date has been the topic of other

Re: [GNC] Matching error in OFX import

2022-12-31 Thread Simon Roberts
I've built 4.13 and the problem seems to have been fixed :) On Sat, Dec 31, 2022 at 9:14 AM Simon Roberts < si...@dancingcloudservices.com> wrote: > Gach, yes, sorry meant to reply all, will pay attention in future, > hopefully not do that again :( > > But FWIW, these transactions have

Re: [GNC] Matching error in OFX import

2022-12-31 Thread Simon Roberts
Gach, yes, sorry meant to reply all, will pay attention in future, hopefully not do that again :( But FWIW, these transactions have different FITIDs and are in a single import from a single file (and do not duplicate anything pre-existing). But, I will get back when I'm not using 3.8. It's sad

Re: [GNC] OFX import date questions

2022-12-31 Thread Phyllis Bruce
Thanks Jean and David, My thresholds are prolly set to the defaults. Another thing I will do is filter for "Unreconciled" before I start my reconciliation. I often have some withdrawals that don't occur within two months. If I know they're there, I can change the threshold to look for them.