[GNC] CSV Import Crash in GNC 5.0+

2023-04-20 Thread Joseph Vernice
I am using the nightly build 5.0.77 on Windows 11. Ever since upgrading to 5.0 (and above nightly builds) I am unable to import transactions from CSV. The system crashes when I select the CSV import profile or when I try to create a new one. The crash occurs immediately after selecting the

[GNC] CSV import crash in 5.0+

2023-04-20 Thread Joseph Vernice
I am using the nightly build 5.0.77 on Windows 11. Ever since upgrading to 5.0 (and above nightly builds) I am unable to import transactions from CSV. The system crashes when I select the CSV import profile or when I try to create a new one. The crash accors immediately after selecting the

Re: [GNC] GnuCash 4.900 Released

2023-01-12 Thread Joseph Vernice
Thank you for the clarification. On Wed, Jan 11, 2023 at 4:14 PM Steve Butler wrote: > This is an experimental pre-5.0 release. 4.13 is for everyday use until > 5.0 comes out. > > On Wed, Jan 11, 2023, 13:11 wrote: > >> I see many references to GnuCash 4.900, but the website only has version

Re: [GNC] Log file preferences (using sqlite)

2021-02-02 Thread Joseph Vernice
You can try creating a link pointing to where you want to save the logs. Unfortunately, if you use this method, everything in the folder will be saved to the linked folder, including mom GC files. On Tue, Feb 2, 2021 at 9:57 AM Chris Green wrote: > I run gnucash on Linux with a sqlite3

Re: [GNC] mysql gnucash

2020-08-18 Thread Joseph Vernice
alls > > > > > On Aug 18, 2020, at 5:29 PM, w...@theprescotts.com wrote: > > > > > > Probably should not be a space in "localhost". > > > > > > Will > > > > > > On 2020 Aug 18, at 08-18 17:42:09, Joseph Vernice > wrote

Re: [GNC] mysql gnucash

2020-08-18 Thread Joseph Vernice
You can set up the MySQL to point to 127.0.0.1 and the alias “local host” On Tue, Aug 18, 2020 at 4:31 PM andy ngo wrote: > Thank you for your help. > > I don't remember using Flatpak back then (too long ago, couldn't remember > > exactly). > > However, the problem is solved with Geert's

Re: [GNC] mysql gnucash

2020-08-18 Thread Joseph Vernice
Can you open any MySQL database?  Need to find out if it's mysql installation or a connection issue. On 8/17/2020 1:11 PM, andy ngo wrote: Hi there: Up to now, I've been used Gnucash 3.2 in Ubuntu 18.04 with mysql 5.7.31 My old laptop is now too old and needs to retire. So I bought a new one

Re: [GNC] Importing transactions problem

2020-03-17 Thread Joseph Vernice
No, one side is to the credit card (correct source acct) and the other account to my checking account (incorrect) On 3/17/2020 1:48 PM, John Ralls wrote: On Mar 17, 2020, at 10:18 AM, Joseph Vernice wrote: Hello John, The problem is the auto assigned account on the import. For some

Re: [GNC] Importing transactions problem

2020-03-17 Thread Joseph Vernice
Hello John, The problem is the auto assigned account on the import.  For some reason, everything is being autoassigned to my checking account instead of an expense or imbalance. Regards, Joe Vernice On 3/17/2020 12:40 PM, John Ralls wrote: On Mar 17, 2020, at 8:44 AM, Joseph Vernice

[GNC] Importing transactions problem

2020-03-17 Thread Joseph Vernice
There seems to be a problem with importing transactions.  I am importing a QFX file from my credit card company and all seems fine.  When I close and re-open the gnucash file, the transactions offsetting account all change to my checking account.  Is this s bug?  How can I fix it?  How can it

Re: [GNC] Investment account import

2019-03-27 Thread Joseph Vernice
, Each stock will have its own account. That's just how it works. Setup can be tedious, but it's not difficult once it's set up. I have many more commodity accounts than you (many of them closed out), and I do not find it troublesome. David On Wed, Mar 27, 2019 at 20:10, Joseph Vernice

[GNC] Investment account import

2019-03-27 Thread Joseph Vernice
I have a Schwab account that contains a number of stock investments.  I can't figure out how to import the investment transactions into the account that I setup. There doesn't seem to be any means of setting the Symbol column in GC.  Do I need to setup a sub-account for each stock symbol? If

Re: [GNC] Using a mysql database?

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

Re: [GNC] Using a mysql database?

2019-03-12 Thread Joseph Vernice
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 > >

Re: [GNC] Accounting for gold coins

2019-02-24 Thread Joseph Vernice
Treat the gold coins as investments just like stocks.  Instead of shares just use your unit of purchase (ounces, grams, etc.). On 2/24/2019 9:30 AM, Gary Holtum wrote: I purchased 3 lots of gold bullion coins at different times at different prices. I physically have the coins. I want to keep

Re: [GNC] How does GnuCash autoassign transactions?

2018-11-28 Thread Joseph Vernice
e matcher learns from your > decision. > > Take a look at: > https://www.gnucash.org/docs/v3/C/gnucash-help/import-qif.html > > David > > > > On Nov 28, 2018, at 8:06 PM, Joseph Vernice wrote: > > > > I would like to know how GnuCash auto-assigns transactions

[GNC] How does GnuCash autoassign transactions?

2018-11-28 Thread Joseph Vernice
.  Most of the time only a handful of these are correct. How are the transactions PREDICTED?  How can this be tweaked? Thank you, Joseph Vernice ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences

Re: [GNC] MySQL version update: GnuCash API recognize new MySQL database & tables?

2018-11-17 Thread Joseph Vernice
Check credentials in MySQL. Specifically permissions for Root@Localhost On Sat, Nov 17, 2018 at 5:38 PM Colin Law wrote: > On Sat, 17 Nov 2018 at 22:31, Peter Holck wrote: > > > > Thanks for your suggestion. No, with only my new instance of MySQL > running (8.13 running, 5.6 stopped) when I

Re: [GNC] Online trx download

2018-10-28 Thread Joseph Vernice
ollowed them? What did you find? Regards, John Ralls On Oct 28, 2018, at 9:08 AM, Joseph Vernice wrote: Yes, I did. I even deleted it and created a new one. On Sun, Oct 28, 2018 at 11:51 AM John Ralls wrote: Have you completed the Online Banking Setup assistant at this point? Regards, John R

Re: [GNC] Online trx download

2018-10-28 Thread Joseph Vernice
o account > selection at that point. > > Anyway, there's a bunch of debugging instructions in my email yesterday. > Have you followed them? What did you find? > > Regards, > John Ralls > > > > On Oct 28, 2018, at 9:08 AM, Joseph Vernice wrote: > > > > Ye

Re: [GNC] Online trx download

2018-10-28 Thread Joseph Vernice
Yes, I did. I even deleted it and created a new one. On Sun, Oct 28, 2018 at 11:51 AM John Ralls wrote: > Have you completed the Online Banking Setup assistant at this point? > > Regards, > John Ralls > > > On Oct 28, 2018, at 7:18 AM, Joseph Vernice wrote: > > H

Re: [GNC] Online trx download

2018-10-28 Thread Joseph Vernice
ays states that there are no transactions to download for the period, even though there are dozens of them. What settings could be in question here? Thank you On 10/27/2018 12:14 PM, John Ralls wrote: On Oct 27, 2018, at 6:49 AM, Joseph Vernice <mailto:jvern...@gmail.com>> wrote: Wit

[GNC] Online trx download

2018-10-27 Thread Joseph Vernice
With the latest update to GnuCash for Windows 10 (Version: 3.3,Build ID: 3.3+ (2018-09-29), Finance::Quote: 1.47) it appears that the Actions>Online Actions>Get Transactions is not working.  Even though there are several transaction that should be downloaded, I am receiving a dialog box

Re: [GNC] GC 3.2 SaveAs issue

2018-07-31 Thread Joseph Vernice
to the right or left far enough so that it is not blocked. Regards JV On 7/31/2018 9:38 AM, GT-I9070 H wrote: Use the ALT + TAB key sequence. Regards GTI Em seg, 30 de jul de 2018 às 15:24, Joseph Vernice <mailto:jvern...@gmail.com>> escreveu: I am having an issue with SaveAs un

[GNC] GC 3.2 SaveAs issue

2018-07-30 Thread Joseph Vernice
I am having an issue with SaveAs under Win10 and GC 3.2.  When saving to an existing file, the "Overwrite" dialog box is not in the foreground.  Any way of making the Overwrite on top? ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] pros/cons of storage formats

2018-05-17 Thread Joseph Vernice
MySQL and postgre are the only formats that can be password protected. I have been using MySQL for many years. It takes more disc space, but it's more secure, backups are small, and is an excellent backed for reporting. On Thu, May 17, 2018, 3:58 PM GWB wrote: > I have used

Re: GNUCash 3.0 crashes on load

2018-04-03 Thread Joseph Vernice
experiencing with the same issue. I appreciate all of the work that the developers have put into gnucash. Apr 3, 2018, at 7:05 AM, Joseph Vernice <jvern...@gmail.com> wrote: Gnucash crashes on opening an XML file (backup of my normally used mysql file). Mysql file eventually loads after 10-15 m

GNUCash 3.0 crashes on load

2018-04-03 Thread Joseph Vernice
Gnucash crashes on opening an XML file (backup of my normally used mysql file). Mysql file eventually loads after 10-15 minutes. It takes only 50 seconds with version 2.6.19 I have the following error in my gnucash log after 10+ minute loading of mysql data file... : WARN Could not spawn