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

[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 message from your deity 
to start keeping regular ones.

I think the simplest fix is to re-save to a new file using File>Save As... I 
suggest doing it twice, one XML and the other SQLite3. You pick which one with 
the list box on the top of the Save As dialog box. 

Regards,
John Ralls


> On Mar 15, 2020, at 4:53 PM, Eric H. Bowen via gnucash-user 
>  wrote:
> 
> 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 
> transaction records were not affected I put up with it for several months as 
> just a nuisance. However, recently I've been trying to reconcile a loan 
> account for a vehicle which was totaled and paid off by insurance, and when I 
> try to balance the liability of the loan off against the asset for the value 
> of the vehicle it seems to post properly for that session...but when I 
> restart Gnucash for the next session, the amount has moved back to 
> "Imbalance". A couple of other transactions are doing this as well, but the 
> auto payoff is the big'un. I want to get the known error taken care of first, 
> and then when the imports are back to working properly I want to see if I'm 
> still having problems balancing out these transactions and, if I do, I'll 
> post a separate request to the listEric.
> 
> On 3/15/20 6:30 PM, David H wrote:
>> 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. 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
>>>>>> 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 transaction dates can be in the future, this looks like 6th
>>>Feb 2020 to me in ccyy-m-d format ?
>>> 
>>>Cheers David.
>>> 
>> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 transaction records were not affected I put up with it for 
several months as just a nuisance. However, recently I've been trying to 
reconcile a loan account for a vehicle which was totaled and paid off by 
insurance, and when I try to balance the liability of the loan off 
against the asset for the value of the vehicle it seems to post properly 
for that session...but when I restart Gnucash for the next session, the 
amount has moved back to "Imbalance". A couple of other transactions are 
doing this as well, but the auto payoff is the big'un. I want to get the 
known error taken care of first, and then when the imports are back to 
working properly I want to see if I'm still having problems balancing 
out these transactions and, if I do, I'll post a separate request to the 
listEric.


On 3/15/20 6:30 PM, David H wrote:

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. 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 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 transaction dates can be in the future, this looks like 6th
Feb 2020 to me in ccyy-m-d format ?

Cheers David.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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. 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 <
> 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 transaction dates can be in the future, this looks like 6th Feb 2020
> to me in ccyy-m-d format ?
>
> Cheers David.
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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, and shouldn't appear in 
regular load/save to/from SQL or XML.


Correct. That particular error occurs only when I am importing 
downloaded transactions from my bank, which does not use ISO date 
format, and is merely a minor inconvenience. The error which I am 
concerned about also involves imported transactions, and appears to be 
related to the database which attempts to automatically match 
transactions to their proper accounts. Here is my most recent 
gnucash.trace file, following such an import:


   * 17:57:27 ERROR  [error_handler()] DBI error: 11:
   database disk image is malformed
   * 17:57:27 ERROR 
   [GncDbiSqlConnection::execute_select_statement()] Error executing
   SQL SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM
   accounts)
   * 17:57:27 ERROR 
   [GncDbiSqlResult::~GncDbiSqlResult()] Error 11 in dbi_result_free()
   result.
   * 17:57:28 ERROR  [error_handler()] DBI error: 11:
   database disk image is malformed
   * 17:57:28 ERROR 
   [GncDbiSqlConnection::execute_select_statement()] Error executing
   SQL SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM
   splits WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
   * 17:57:28 ERROR 
   [GncDbiSqlResult::~GncDbiSqlResult()] Error 11 in dbi_result_free()
   result.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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  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 transaction dates can be in the future, this looks like 6th Feb 
2020 to me in ccyy-m-d format ?


Cheers David.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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 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, 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 XML-based OFX V2. AFAIK that's not supported
> by any US bank.
> >> [...]
> >>
> >> OFX2 is the only version I could get access to a test server for, so
> >> thats what I implemented so far.
> >>
> >> However, since the OFX spec state that banks should also accept XML like
> >> OFX requests (i.e. OFX files with closing XML elements) the code might
> >> be adjustable for this...
> >>
> >> I will try to add a mode in which the plugin sends the headers
> >> previously used for OFX1 and still send requests with closing XML
> >> elements, at least according to the specs I read that should work...
> >>
> >> Anyway, as I wrote before I can't test it myself. There is only person -
> >> so far - I heard of from the US who tested the latest code with a real
> >> server and I really appreciate his help, but he seems to be using the
> >> prebuilt Windows version which makes the debug process... well...
> difficult.
> >>
> >> It would be extremely helpfull to have someone who could compile and
> >> test a version from GIT, but given the different timezones the possible
> >> OFX users and I live in that might be time consuming for both sides...
> >
> > Martin,
> >
> > As I said here and in my bug report, AQB 5's OFX backend works well and
> has done for many years. If you just update it for the new AQB6 and Gwen5
> API it has a good chance of working.
> >
> > I can build from git and test. So far there's no need for debugging,
> simply comparing the OFX from 5.8 and 6.1 showed me the problem: OFX
> DirectConnect servers using V1 can't parse the XML you send in the request
> and 400, see the transcripts in the bug report.
> >
> > The current OFX spec doesn't matter if the bank is using software
> written for OFX V1 as nearly all in the US do.
> >
> > Regards,
> > John Ralls
> >
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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, 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 XML-based OFX V2. AFAIK that's not supported 
>>> by any US bank.
>> [...]
>> 
>> OFX2 is the only version I could get access to a test server for, so
>> thats what I implemented so far.
>> 
>> However, since the OFX spec state that banks should also accept XML like
>> OFX requests (i.e. OFX files with closing XML elements) the code might
>> be adjustable for this...
>> 
>> I will try to add a mode in which the plugin sends the headers
>> previously used for OFX1 and still send requests with closing XML
>> elements, at least according to the specs I read that should work...
>> 
>> Anyway, as I wrote before I can't test it myself. There is only person -
>> so far - I heard of from the US who tested the latest code with a real
>> server and I really appreciate his help, but he seems to be using the
>> prebuilt Windows version which makes the debug process... well... difficult.
>> 
>> It would be extremely helpfull to have someone who could compile and
>> test a version from GIT, but given the different timezones the possible
>> OFX users and I live in that might be time consuming for both sides...
> 
> Martin,
> 
> As I said here and in my bug report, AQB 5's OFX backend works well and has 
> done for many years. If you just update it for the new AQB6 and Gwen5 API it 
> has a good chance of working.
> 
> I can build from git and test. So far there's no need for debugging, simply 
> comparing the OFX from 5.8 and 6.1 showed me the problem: OFX DirectConnect 
> servers using V1 can't parse the XML you send in the request and 400, see the 
> transcripts in the bug report.
> 
> The current OFX spec doesn't matter if the bank is using software written for 
> OFX V1 as nearly all in the US do.
> 
> Regards,
> John Ralls
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 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 ".gnucash" suffix on the file name
>> ???  Seems that it doesn't like your date of 2020/2/6  - 6th Feb 2020 ?
>> 
>> If your file is definitely xml it's probably compressed so can't be
>> searched.  You can go to Preferences >>General >> Files and uncheck
>> "Compress Files" and save it as an uncompressed file which will allow you
>> to open it with a text editor and search for the 2020/2/6 and compare it
>> with other dates and see if they look the same.  If you do this copy your
>> data file and work on a copy until you find the problem.
>> 
>> Regards David.
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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 ".gnucash" suffix on the file name
> ???  Seems that it doesn't like your date of 2020/2/6  - 6th Feb 2020 ?
> 
> If your file is definitely xml it's probably compressed so can't be
> searched.  You can go to Preferences >>General >> Files and uncheck
> "Compress Files" and save it as an uncompressed file which will allow you
> to open it with a text editor and search for the 2020/2/6 and compare it
> with other dates and see if they look the same.  If you do this copy your
> data file and work on a copy until you find the problem.
> 
> Regards David.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 transaction dates can be in the future, this looks like 6th Feb 2020 to
me in ccyy-m-d format ?

Cheers David.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 ".gnucash" suffix on the file name
???  Seems that it doesn't like your date of 2020/2/6  - 6th Feb 2020 ?

If your file is definitely xml it's probably compressed so can't be
searched.  You can go to Preferences >>General >> Files and uncheck
"Compress Files" and save it as an uncompressed file which will allow you
to open it with a text editor and search for the 2020/2/6 and compare it
with other dates and see if they look the same.  If you do this copy your
data file and work on a copy until you find the problem.

Regards David.



On Mon, 16 Mar 2020 at 06:31, Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> 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:
>
> * 14:57:56  WARN  qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR 
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
> * 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR 
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM splits
> WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
> * 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:01:20  WARN  qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 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:
> 
> * 14:57:56  WARN  qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed

I fear, you have to consult the manual for the backend you are using
(SQLite, MySQL, PostgreSQL, ...) or ask the corresponding community.

> * 15:00:34 ERROR 
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
> * 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR 
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM splits
> WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
> * 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 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).

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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:

* 14:57:56  WARN  qif-parse:parse-date/format: format is y-d-m 
but date is [2020/2/6].
* 15:00:34 ERROR  [error_handler()] DBI error: 11: 
database disk image is malformed
* 15:00:34 ERROR  
[GncDbiSqlConnection::execute_select_statement()] Error executing SQL 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
* 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()] 
Error 11 in dbi_result_free() result.
* 15:00:34 ERROR  [error_handler()] DBI error: 11: 
database disk image is malformed
* 15:00:34 ERROR  
[GncDbiSqlConnection::execute_select_statement()] Error executing SQL 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM splits 
WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
* 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()] 
Error 11 in dbi_result_free() result.
* 15:01:20  WARN  qif-parse:parse-date/format: format is y-d-m 
but date is [2020/2/6].


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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 XML-based OFX V2. AFAIK that's not supported 
>> by any US bank.
> [...]
> 
> OFX2 is the only version I could get access to a test server for, so
> thats what I implemented so far.
> 
> However, since the OFX spec state that banks should also accept XML like
> OFX requests (i.e. OFX files with closing XML elements) the code might
> be adjustable for this...
> 
> I will try to add a mode in which the plugin sends the headers
> previously used for OFX1 and still send requests with closing XML
> elements, at least according to the specs I read that should work...
> 
> Anyway, as I wrote before I can't test it myself. There is only person -
> so far - I heard of from the US who tested the latest code with a real
> server and I really appreciate his help, but he seems to be using the
> prebuilt Windows version which makes the debug process... well... difficult.
> 
> It would be extremely helpfull to have someone who could compile and
> test a version from GIT, but given the different timezones the possible
> OFX users and I live in that might be time consuming for both sides...

Martin,

As I said here and in my bug report, AQB 5's OFX backend works well and has 
done for many years. If you just update it for the new AQB6 and Gwen5 API it 
has a good chance of working.

I can build from git and test. So far there's no need for debugging, simply 
comparing the OFX from 5.8 and 6.1 showed me the problem: OFX DirectConnect 
servers using V1 can't parse the XML you send in the request and 400, see the 
transcripts in the bug report.

The current OFX spec doesn't matter if the bank is using software written for 
OFX V1 as nearly all in the US do.

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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 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 provide info on where 
>> to download the GIT repository, I would be happy to test.
> 
> https://www.aquamaniac.de/rdm/projects/aqbanking/repository
> similar for gwenhyfar.
> 
>> Thx,
>> Chris
> 
> ~Frank
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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 what I 
> sent you the debug info from.  Anyways, if you could provide info on where to 
> download the GIT repository, I would be happy to test.

https://www.aquamaniac.de/rdm/projects/aqbanking/repository
similar for gwenhyfar.

> Thx,
> Chris

~Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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 provide info on where to 
download the GIT repository, I would be happy to test.

Thx,
Chris

> 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 XML-based OFX V2. AFAIK that's not supported 
>> by any US bank.
> [...]
> 
> OFX2 is the only version I could get access to a test server for, so
> thats what I implemented so far.
> 
> However, since the OFX spec state that banks should also accept XML like
> OFX requests (i.e. OFX files with closing XML elements) the code might
> be adjustable for this...
> 
> I will try to add a mode in which the plugin sends the headers
> previously used for OFX1 and still send requests with closing XML
> elements, at least according to the specs I read that should work...
> 
> Anyway, as I wrote before I can't test it myself. There is only person -
> so far - I heard of from the US who tested the latest code with a real
> server and I really appreciate his help, but he seems to be using the
> prebuilt Windows version which makes the debug process... well... difficult.
> 
> It would be extremely helpfull to have someone who could compile and
> test a version from GIT, but given the different timezones the possible
> OFX users and I live in that might be time consuming for both sides...
> 
> 
> Regards
> Martin
> 
> 
> -- 
> "Things are only impossible until they're not"
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] AQBanking OFX DirectConnect

[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.
[...]

OFX2 is the only version I could get access to a test server for, so
thats what I implemented so far.

However, since the OFX spec state that banks should also accept XML like
OFX requests (i.e. OFX files with closing XML elements) the code might
be adjustable for this...

I will try to add a mode in which the plugin sends the headers
previously used for OFX1 and still send requests with closing XML
elements, at least according to the specs I read that should work...

Anyway, as I wrote before I can't test it myself. There is only person -
so far - I heard of from the US who tested the latest code with a real
server and I really appreciate his help, but he seems to be using the
prebuilt Windows version which makes the debug process... well... difficult.

It would be extremely helpfull to have someone who could compile and
test a version from GIT, but given the different timezones the possible
OFX users and I live in that might be time consuming for both sides...


Regards
Martin


-- 
"Things are only impossible until they're not"
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] AQBanking OFX DirectConnect

[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 suspect that Intuit doesn't support OFX V2 anywhere with OFX DirectConnect, 
so has anyone outside of the US who can use if tried with GnuCash 3.8 and 
AQBanking 5.99 or 6.x and been successful?

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] font size how to increase

[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  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] General Journal Report - Error

[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 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 General Journal report however I am getting
>> a fatal error message followed by a crash in GnuCash. The error
>> message is "too many heap sections".
>> 
>> I am on Windows 10 (v1909) and using GnuCash 3.8.
>> 
>> Does anyone know if there is a way to circumvent this error and get
>> the General Journal report?
>> 
>> Thanks in advance.
>> Gilberto
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] font size how to increase

[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
Sent: Sunday, March 08, 2020 12:20 AM
To: Gnucash Users
Subject: Re: [GNC] font size how to increase

For more detailed info if needed, see the wiki and search for “GTK”

Regards,
Adrien

> On Mar 7, 2020 w10d67, at 9:21 PM, Rare Bear  wrote:
> 
> Look in the "Users/AppData/Roaming/GnuCash" folder for a file named
> "gtk-3.0.css".  Edit the file and change the font to something you like.  I
> changed mine to "font: 15px consolas, sans-serif;" and save the new version
> in the same folder.  Reopen GnuCash and you should be good to go.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash 3.8 font size too small

[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 too small to read
> comfortably. But I cannot find any place in Preferences or elsewhere to
> increase the font size. Help appreciated.
>
> Chris Sackett
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] General Journal Report - Error

[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 General Journal report however I am getting
> a fatal error message followed by a crash in GnuCash. The error
> message is "too many heap sections".
>
> I am on Windows 10 (v1909) and using GnuCash 3.8.
>
> Does anyone know if there is a way to circumvent this error and get
> the General Journal report?
>
> Thanks in advance.
> Gilberto
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to track Family expenses ?

[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
   Person1
   Person2
   Joint
Expenses
   Person1
   Person2
   Joint

with appropriate subaccounts under each of those headings. The reports all
have the ability to select in the Report Options which accounts are
presented in a particular report. SO it is possible to prepare Balance
sheets P and Loss, Cash flow for person 1, person 1 and  the joint accounts
if you need to. The main advantage is you can prepare a report which
contains all of them and includes as subtotals the person1, person2 and
joint sub-accountsacoounts of the top level Asset, Liability, Equity, Income
and Expense accounts.  If you have separate books, you cannot do this, you
would have to exporteach individuals reports and then combine them in a
spreadsheet. 

There is no way to automatically sync the account heirarchy in the Gnucash
main program and a copy in the Android app. It may be that the Android app
can read the main program datafile and write to it but there is an enormous
risk in this as there ino guarantee that the Android app and the main
GnuCash app are data file compatible and if they are they will remain so
into the future as they are produced by the GnuCash development team for the
program and a separate developer. That developer will no doubt be trying to
maintain file compatability going forward the Android app v2.4.0 AFAIK is
only compatible with the versions up to 2.7 as it was released in June 2018.
There were some data file changes going to GnuCash v3.x. They may have been
incorporated in v2.7 as v2.7 ultimately became v3.0 and may have made it.
 into the Android app. I don.t know whether they did or not. You would need
to check the release notes for GnuCash 2.6.19 forward together with the
release notes for v2.4.0 of the Android app. My choice is to avoid any
possibility of corrupting my GnuCash data file by using the CSV export form
the Android app and import to GnuCash if I need to transfer data.

The optimal solution obviously depends on your individual requirements and
personal workflow. I make almost no use of the Android app now as I have
very few transactions, almost none other than a few cash transactions that
don't go through my credit or debit card accounts and I can download those
from the bank as fequently as I wish. e can really only illustrate how we
use GnuCash. You will have to adapt how you use i to your own situation.
Good luck

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.