Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread John Ralls
You're using a SQLite3 database, not and XML file, and SQLIte3 thinks that its file has gotten corrupted. If you have backups you should make sure that the one or two from just ´before the first time you encountered the error are safe and available. If you don't have backups then this is a

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Eric H. Bowen via gnucash-user
I'm seeing the error on all three operating systems, although it first appeared on the Windows 10 computer. The pop-up error message does appear only when importing transactions, and only from one specific account (my personal checking account) at that, and since it seemed as though the

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread David H
Hi Eric, Yep saw that. What OS are you seeing the error on, or is it on all of them ? Just saw your other post, so you are getting this when trying to import transactions NOT when saving your Gnucash data file. Cheers David. On Mon, 16 Mar 2020 at 09:19, Eric H. Bowen wrote: > Hello, David.

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Eric H. Bowen via gnucash-user
On 3/15/20 4:36 PM, Christopher Lam wrote: On Sun, 15 Mar 2020 at 20:31, Eric H. Bowen via gnucash-user mailto:gnucash-user@gnucash.org>> wrote: * 14:57:56  WARN qif-parse:parse-date/format: format is y-d-m but date is [2020/2/6]. This warning only appears during QIF imports,

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Eric H. Bowen via gnucash-user
Hello, David. More info in the message I just posted. I do use ISO date format (-mm-dd) for all of my computer-related workEric On 3/15/20 4:22 PM, David H wrote: On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger mailto:frank.h.ellenber...@gmail.com>> wrote: > * 15:01:20 

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread David Carlson
OFX direct connect is not the same as plain OFX, which is easier to use. I didn't have a good experience when I tried OFX D C with my banks long ago. On Sun, Mar 15, 2020, 5:18 PM chris graves wrote: > Not that it matters, but I concur with John. I also have been using AQB > OFX successfully

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread chris graves
Not that it matters, but I concur with John. I also have been using AQB OFX successfully for ~8 years, thanks to you devs! I continue successfully to use the AQB provided with GnuCash 3.7. Thanks for your support! Chris > On Mar 15, 2020, at 1:21 PM, John Ralls wrote: > > >> On Mar 15,

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Christopher Lam
On Sun, 15 Mar 2020 at 20:31, Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > * 14:57:56 WARN qif-parse:parse-date/format: format is y-d-m > but date is [2020/2/6]. > This warning only appears during QIF imports, and shouldn't appear in regular load/save to/from SQL or XML.

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Adrien Monteleone
Open the file with a text editor, if sqlite, you’ll see: "SQLite format 3" at the beginning of the file, otherwise, you’re looking at a compressed (or uncompressed) XML. Regards, Adrien > On Mar 15, 2020 w12d75, at 4:33 PM, Adrien Monteleone > wrote: > > sqlite files also have a .gnucash

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Adrien Monteleone
sqlite files also have a .gnucash extension. Regards, Adrien > On Mar 15, 2020 w12d75, at 4:19 PM, David H wrote: > > Hi Eric, > > You may need to provide further info on this, i.e what version of gnucash > are you using and on what OS ? > > You say your file is saved as xml so I'm a bit

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread David H
On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > > * 15:01:20 WARN qif-parse:parse-date/format: format is y-d-m > > but date is [2020/2/6]. > > That date is in the future. It seems, somebody changed the date format > (order of day and month). > Hmm

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread David H
Hi Eric, You may need to provide further info on this, i.e what version of gnucash are you using and on what OS ? You say your file is saved as xml so I'm a bit surprised to see sql dbi related error messages in your trace file. So just to remove all doubt - your file is definitely xml and has a

Re: [GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Frank H. Ellenberger
Hello Eric, with the trace file your request looks slightly better. How about your Gnucash version, selected backend, region ...? From Am 15.03.20 um 21:29 schrieb Eric H. Bowen via gnucash-user: > I still have not been able to repair my "Unable to Save to Database" > error in GnuCash. I've

[GNC] How to fix "Unable to Save to Database" error - Second Request

2020-03-15 Thread Eric H. Bowen via gnucash-user
I still have not been able to repair my "Unable to Save to Database" error in GnuCash. I've found the gnucash.trace file, which has the error messages, but so far I haven't been able to find any clue for repairing a database saved in .xml format. Assistance requested. Trace file follows: *

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread John Ralls
> On Mar 15, 2020, at 12:47 PM, Martin Preuss wrote: > > Hi, > > Am 15.03.20 um 20:17 schrieb John Ralls: >> I just made a MacOS build with the latest AQBanking so I could test it with >> my bank (USAA). No go, and a bit of troubleshooting reveals that it's >> because AQBanking now uses the

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread Frank H. Ellenberger
Better use the "git clone" instructions from https://www.aquamaniac.de/rdm/projects/aqbanking/wiki#Programmieren Am 15.03.20 um 21:13 schrieb Frank H. Ellenberger: > Hi Chris, > > Am 15.03.20 um 21:07 schrieb chris graves: >> Hi Martin, >> >> I'm not sure if you are speaking of me, I did test

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread Frank H. Ellenberger
Hi Chris, Am 15.03.20 um 21:07 schrieb chris graves: > Hi Martin, > > I'm not sure if you are speaking of me, I did test from a recent flatpak > build, not windows. And subsequently built the latest AqB/Qwen available > from https://www.aquamaniac.de/ . That is

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread chris graves
Hi Martin, I'm not sure if you are speaking of me, I did test from a recent flatpak build, not windows. And subsequently built the latest AqB/Qwen available from https://www.aquamaniac.de/ . That is what I sent you the debug info from. Anyways, if you could

Re: [GNC] AQBanking OFX DirectConnect

2020-03-15 Thread Martin Preuss
Hi, Am 15.03.20 um 20:17 schrieb John Ralls: > I just made a MacOS build with the latest AQBanking so I could test it with > my bank (USAA). No go, and a bit of troubleshooting reveals that it's because > AQBanking now uses the XML-based OFX V2. AFAIK that's not supported by any US > bank.

[GNC] AQBanking OFX DirectConnect

2020-03-15 Thread John Ralls
I just made a MacOS build with the latest AQBanking so I could test it with my bank (USAA). No go, and a bit of troubleshooting reveals that it's because AQBanking now uses the XML-based OFX V2. AFAIK that's not supported by any US bank. I've filed https://www.aquamaniac.de/rdm/issues/202. I

Re: [GNC] font size how to increase

2020-03-15 Thread Frank H. Ellenberger
Hi Gary, I have just updated https://wiki.gnucash.org/wiki/GTK3#Typefaces HTH Frank Am 15.03.20 um 15:06 schrieb Gary Holtum: > Using win7, gnucash 3.8 > > I would like to increase the font size but the file gtk-3.0.css does not > exist on my computer. Please advise. > > Gary

Re: [GNC] General Journal Report - Error

2020-03-15 Thread John Ralls
It's coming from Guile's garbage collector, bdwgc, and might be related to building GnuCash for 32 bits on Windows. Regards, John Ralls > On Mar 15, 2020, at 4:42 AM, Christopher Lam > wrote: > > A heap error is not common. Please file a bug in bugzilla, and ideally > attach

Re: [GNC] font size how to increase

2020-03-15 Thread Gary Holtum
Using win7, gnucash 3.8 I would like to increase the font size but the file gtk-3.0.css does not exist on my computer. Please advise. Gary -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+diamondhranchqh=earthlink@gnucash.org] On Behalf Of Adrien Monteleone

Re: [GNC] GnuCash 3.8 font size too small

2020-03-15 Thread Rare Bear
Chris, Look back a week or two - This question gets asked a lot and rather than repeat the answer you can easily find an answer to the same question. It's an easy process. Dennis On Sat, Mar 14, 2020 at 11:38 PM Chris Sackett wrote: > Have upgraded to 3.8. The font on the Accounts pages is

Re: [GNC] General Journal Report - Error

2020-03-15 Thread Christopher Lam
A heap error is not common. Please file a bug in bugzilla, and ideally attach https://wiki.gnucash.org/wiki/Tracefile Also try "gnucash.exe --debug" too On Fri, 13 Mar 2020 at 18:49, Gilberto Reis Filho < gilberto.reis.fi...@gmail.com> wrote: > Good afternoon. > > I am trying to generate a

Re: [GNC] How to track Family expenses ?

2020-03-15 Thread David Cousens
Long, Adrien has addressed point 2 For point 3. I dont' create top level account for each person. The structure I use is much like you had in your original post Assets Person1 Person2 Joint Liabilities Person1 Person2 Joint Equity Person1 Person2 Joint Income