Re: simple find transactions report

[Elmar]

Perfect!  Thanks, although I had to translate this to the menu entry 
"edit/find" (not "search")


- elmar

On 10/09/2017 04:16 PM, David Carlson wrote:

Geert,

Gmail used those ing triple dots to hide your reply in my mail 
folder.  Lucky for me I suspected as much when there appeared to be no 
reply .


David C


On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens 
<geert.gnuc...@kobaltwit.be <mailto:geert.gnuc...@kobaltwit.be>> wrote:


Start with a search from the account hierarchy page and then open
an account report on the search results tab.

    Regards,
Geert

Elmar <etsc...@gmail.com <mailto:etsc...@gmail.com>> schreef op 9
oktober 2017 20:35:06 GMT+01:00:
>Good afternoon to the list
>
>I seem to be having a brain fart.  I am trying to retrieve all the
>transactions (all dates) with a certain payee in the description
field,
>
>and only those transactions.  Somehow I cannot make the transaction
>report do this - what am I missing?  It should be easy, which
tells me
>I'm at fault.
>
>- Elmar
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.

Sent from my smartphone. Please excuse my brevity.
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: gnucash-user Digest, Vol 176, Issue 27

[Elmar]

On 11/12/2017 01:37 PM, gnucash-user-requ...@gnucash.org wrote:
On Nov 12, 2017, at 4:38 AM, Chris Szilagyi <ch...@apex-internet.com> 
wrote:

Hello:

Recently our Discover credit card online banking stopped working.

I have tried setting the dates to as far back as 6 months, and up to the
past 30 days' worth... and still receive the same message. Thank you for
clarifying the account name.

If there is anything else I can try please let me know, thank you!

This seems to be variable.  LGFCU (local government federal credit 
union) has a visa card that aqbanking seems to handle OK, but RBFCU 
(Randolph-Brooks Federal Credit Union) consistently fails the same way 
(no transactions).  Part of the difference seems to be the way the banks 
handle the credit card accounts vs. their checking/savings accounts - 
LGFCU lets you get there directly via the website, while RBFCU generates 
a new page from the account list on the website to a site called 
ezcardinfo.  BTW, IRA accounts - both Roth and regular - also seem to 
fail, but money market accounts held in the same bank succeed.  There 
may be no solution, although while I was running Quicken, they all 
worked OK in that program. - Elmar


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[Elmar]

Thanks - I missed the transaction report option.  Oops.

On 11/2/2017 11:28 AM, Christopher Lam wrote:

Hi Elmar

 From the default Transaction Report, choose:

Accounts/Accounts: select the Expenses:Discretionary:Travel, click 
'Select children' which will select 
Expenses:Discretionary:Travel:Lodging etc


Sorting/Primary Key: Date
Sorting/Primary Subtotal: none
Sorting/Secondary Key: Description

or

Sorting/Primary Key: Description
Sorting/Secondary Key: Date
Sorting/Secondary Subtotal: none

Good luck!

Next release 2.7 onwards will have arbitrary string searching.

On 2 November 2017 at 22:59, Elmar <etsc...@gmail.com 
<mailto:etsc...@gmail.com>> wrote:


Getting a report by payee/description for a set of dates across a
set of accounts, is still opaque to me, though.  I have a "travel"
account under expenses-discretionary, that is itself split into
lodging, travel, fees, etc.  I am trying to retrieve all
transactions from all these subaccounts sorted by payee and date to
dump into a spreadsheet.  Doing a "find" on the placeholder account
"travel" gives me nothing at all. Do I have to go and learn SQL to
get what I need?

- Elmar

On 10/10/2017 11:17 AM, Geert Janssens wrote:

Heh, sorry. I'm not near a computer to verify my directions and
won't be until next week...

Glad you managed to decode my terse answer.

Geert

Elmar <etsc...@gmail.com <mailto:etsc...@gmail.com>> schreef op
9 oktober 2017 21:37:57 GMT+01:00:
  >Perfect!  Thanks, although I had to translate this to the
menu entry
  >"edit/find" (not "search")


___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-
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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[Elmar]

Getting a report by payee/description for a set of dates across a set of 
accounts, is still opaque to me, though.  I have a "travel" account 
under expenses-discretionary, that is itself split into lodging, travel, 
fees, etc.  I am trying to retrieve all transactions from all these 
subaccounts sorted by payee and date to dump into a spreadsheet.  Doing 
a "find" on the placeholder account "travel" gives me nothing at all. 
Do I have to go and learn SQL to get what I need?


- Elmar

On 10/10/2017 11:17 AM, Geert Janssens wrote:
Heh, sorry. I'm not near a computer to verify my directions and won't be 
until next week...


Glad you managed to decode my terse answer.

Geert

Elmar <etsc...@gmail.com> schreef op 9 oktober 2017 21:37:57 GMT+01:00:
 >Perfect!  Thanks, although I had to translate this to the menu entry
 >"edit/find" (not "search")


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnctimeperiod-utilities.scm. etc.

[Elmar]

I've added the 3 files gnctimeperiod-utilities.scm, transaction.scm and 
config.user to /home//.gnucash (Linux Mint, GC 2.6.12).  Under the 
reports tab, I see 2 entries labveled "transaction report" - both seem 
to be identical.  Running one of them gives me the result I needed 
(summary totals by description field for a period of time).  The other 
does the exact same.  And I noted a bug - I cannot set it to the 
previous year's start and end dates in the options dialog.  It always 
reports only the current year.  Did I install things wrongly? - Elmar


___
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-user Digest, Vol 183, Issue 11

[Elmar]

Found it - thanks.


On 06/04/2018 11:47 PM, Cindy Doughty wrote:
Look at my Sept 12 2017 post - One way to find it is to google nabble 
gnucash  and then search for  Doughty or



Subtotaling on Description


On Mon, Jun 4, 2018 at 1:11 PM, Elmar <mailto:etsc...@gmail.com>> wrote:


I am still running  2.6.12 - where on the web (URL) is this
report, please?  It sounds incredibly useful.

    - Elmar

On 06/04/2018 09:17 AM, gnucash-user-requ...@gnucash.org
<mailto:gnucash-user-requ...@gnucash.org> wrote:

-- Forwarded message --
From: Cindy Doughty mailto:dbdoug...@gmail.com>>
Date: Sun, Jun 3, 2018 at 6:46 PM
Subject: consolidate transactions report
To: gnucash-user mailto:gnucash-user@gnucash.org>>
Cc: gnucash-de...@gnucash.org <mailto:gnucash-de...@gnucash.org>


Attached is an updated version of the transaction report I
published last
year

...
for linux and os see the following from the wiki - note you
want the right
hand column:

Operating SystemUser Config Directory (2.6 and older)User
Config Directory
(3 and newer)
*Linux/Unix* /home/YourName/.gnucash
/home/YourName/.config/gnucash...
-- next part --
A non-text attachment was scrubbed...
Name: config-user.scm
Type: application/octet-stream
Size: 296 bytes
Desc: not available
URL:

<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment.obj

<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment.obj>>
-- next part --
A non-text attachment was scrubbed...
Name: consolidate-transactions.scm
Type: application/octet-stream
Size: 187996 bytes
Desc: not available
URL:

<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment-0001.obj

<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment-0001.obj>>
-- next part --
A non-text attachment was scrubbed...
Name: gnctimeperiod-utilities.scm
Type: application/octet-stream
Size: 65612 bytes
Desc: not available
URL:

<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment-0002.obj

<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment-0002.obj>>


___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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-user Digest, Vol 183, Issue 11

[Elmar]

I am still running  2.6.12 - where on the web (URL) is this report, 
please?  It sounds incredibly useful.


- Elmar

On 06/04/2018 09:17 AM, gnucash-user-requ...@gnucash.org wrote:

-- Forwarded message --
From: Cindy Doughty 
Date: Sun, Jun 3, 2018 at 6:46 PM
Subject: consolidate transactions report
To: gnucash-user 
Cc: gnucash-de...@gnucash.org


Attached is an updated version of the transaction report I published last
year

...
for linux and os see the following from the wiki - note you want the right
hand column:

Operating SystemUser Config Directory (2.6 and older)User Config Directory
(3 and newer)
*Linux/Unix* /home/YourName/.gnucash /home/YourName/.config/gnucash...
-- next part --
A non-text attachment was scrubbed...
Name: config-user.scm
Type: application/octet-stream
Size: 296 bytes
Desc: not available
URL: 
<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment.obj>
-- next part --
A non-text attachment was scrubbed...
Name: consolidate-transactions.scm
Type: application/octet-stream
Size: 187996 bytes
Desc: not available
URL: 
<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment-0001.obj>
-- next part --
A non-text attachment was scrubbed...
Name: gnctimeperiod-utilities.scm
Type: application/octet-stream
Size: 65612 bytes
Desc: not available
URL: 
<http://lists.gnucash.org/pipermail/gnucash-user/attachments/20180604/6ad75909/attachment-0002.obj>



___
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.

filter by transfer account?

[Elmar]

Looking at a particular account, I would like to filter by the transfer 
account within it, or perhaps just sort by the transfer account, which 
would accomplish the same thing.  How can this be done? - Elmar


___
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: filter by transfer account?

[Elmar]

That worked.  Thanks. - Elmar


On 02/02/2018 12:57 PM, David Carlson wrote:
I think that the only choice would be to start in the account that you 
want to be your base for the filter then do ctrl-F and select the 
criteria All Accounts = .  
So, for example, to find transfers from Bank1 to Cash you would start 
in Bank1 and select Ctrl-F , select All Accounts from under 
Description, then select Cash from the account list.


Crude but I just tried it and it works.

David C



On Fri, Feb 2, 2018 at 11:34 AM, Elmar <etsc...@gmail.com 
<mailto:etsc...@gmail.com>> wrote:


Looking at a particular account, I would like to filter by the
transfer account within it, or perhaps just sort by the transfer
account, which would accomplish the same thing.  How can this be
done? - Elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
<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.

trial balance - how to find mismatch question

[Elmar]

The recent threads on trial balances has me wondering why mine seems to 
be ~$1600 out of balance, despite having everything else in the account 
balance and reconcile correctly, i.e. nothing in the imbalance account, 
and setting the dates to the earliest date in the file and today.  
Either I am not using it correctly or I do not understand how to 1) use 
it and 2) find out what to do when it doesn't balance.  Is there a 
tutorial?  The webpage documents (section 10.3.4.11. Trial Balance) 
doesn't give much help. - Elmar


___
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: gnucash-user Digest, Vol 179, Issue 59

[Elmar]

On 02/15/2018 02:28 PM, gnucash-user-requ...@gnucash.org wrote:

--

Message: 1
Date: Thu, 15 Feb 2018 13:27:17 -0600
From: Adrien Monteleone <adrien.montele...@gmail.com>
To: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org>
Subject: Re: trial balance - how to find mismatch question
Message-ID: <823da1a8-b449-470f-ab10-e66505686...@gmail.com>
Content-Type: text/plain;   charset=utf-8
...

Elmar,

Reduce your ending date so the range is half of what it was. Re-run the report. 
Is it s[t]ill out of balance? Keep doing this till you get a balance, then set 
that ending date to a new start date, and start working forwards till you get 
out of balance again. This will help you narrow down where on the calendar the 
error occurred.

Regards,
Adrien
OK - did that and ran into something VERY strange.  Everything stayed in 
balance up to 07/12/2016.  Setting that as the start date and 12/31/2016 
as the end date, as soon as I hit "apply", QC overwrites the end date 
with - get this - 02/27/1899 !!!  This of course produces nonsense.  One 
day later (01/01/2017) works fine and shows the imbalance.  So, have I 
1) found a bug, and 2) given I have narrowed the date range to a few 
weeks, what report should I run to find the weirdness? - Elmar

___
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-user Digest, Vol 181, Issue 62

[Elmar]

If this does go to a web forum, it would be good to have an RSS feed for 
the individual emails.  The digest keeps the inbox level down, but 
shifting to an RSS feeder is often much more convenient for things like 
this, imho.


- Elmar

On 04/12/2018 12:00 PM, gnucash-user-requ...@gnucash.org wrote:

I still haven't seen list of mailing clients which are *not* capable to
perform filtering by List-Id and if it is really such a problem, maybe
the solution is to turn mailing lists into web forum?


___
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] multiple item select, cut, copy and paste?

[Elmar]

I know it has been raised before, but is this functionality (multiple 
item select, cut, copy and paste) on the queue for inclusion into GC any 
time soon?

___
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] formulas in scheduled transaction templates?

[Elmar]

I have been watching the back and forth on automatically calculating 
taxes, etc. on invoices, and wondered about the following situation: 
when I download transactions form my bank, it gives me the net deposit 
of (e.g.) a salary.  Is there a way to create a template that 
back-calculates the various taxes and the gross amount that the net is 
derived from?  This may be US specific, but Social Security, Medicare, 
State and Federal taxes are all definable by percentage of the gross.  
But template entries (for scheduled  transactions) do allow formulas, do 
they? - Elmar

___
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] mismatched Baysian matching , was Re: gnucash-user Digest, Vol 189, Issue 50

[Elmar]

The one on fixing mismatched Baysian matching.

On 12/19/18 10:09 AM, David Carlson wrote:

Elmer,

What thread are you responding to?

David C

On Wed, Dec 19, 2018, 8:58 AM Elmar <mailto:etsc...@gmail.com> wrote:


I gather this is only in version 3.x?  Any hope for us still on
version
2.6.12 ?

- Elmar

On 12/18/18 10:58 PM, gnucash-user-requ...@gnucash.org
<mailto:gnucash-user-requ...@gnucash.org> wrote:
> In GnC, click on the Tools menu and then on the Import Map
Editor.?  > Once on the new screen you can see all the mappings
that have been >
generated.

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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-user Digest, Vol 189, Issue 50

[Elmar]

I gather this is only in version 3.x?  Any hope for us still on version 
2.6.12 ?


- Elmar

On 12/18/18 10:58 PM, gnucash-user-requ...@gnucash.org wrote:
In GnC, click on the Tools menu and then on the Import Map Editor.?  > Once on the new screen you can see all the mappings that have been > 

generated.

___
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] Bayesian matching, was Re: gnucash-user Digest, Vol 189, Issue 50

[Elmar]

Not yet in the Linux Mint repository. Do you know when it will appear 
there?  I am hesitant to install things not in the official repository. 
Can I install 3.3 alongside 2.6.12 (paranoia speaking here)? - Elmar


On 12/19/18 10:27 AM, Geert Janssens wrote:

Op woensdag 19 december 2018 15:55:59 CET schreef Elmar:

I gather this is only in version 3.x?  Any hope for us still on version
2.6.12 ?

Hope ? Sure, migrate to 3.x ;)

More seriously, in the 2.6 series there  was no gui interface to changing
this. Only by direct manipulation of the data file.

Regards,

Geert



___
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] undo needed, was Re: Reconciliation is not adding up correctly

[Elmar]

I bet the ability to  have a few levels of "undo" is on the desired 
enhancements list, no?  I certainly have cursed a few times when I hit 
delete by mistake.


- Elmar

On 1/30/19 12:00 PM, gnucash-user-requ...@gnucash.org wrote:
Message: 9 Date: Wed, 30 Jan 2019 12:17:20 + From: Colin Law  >  ... Once you have deleted a transaction then it 

> is gone, so you won't be able to find it in by filtering.
___
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] undo needed, was Re: Reconciliation is not adding up correctly

[Elmar]

Found it - thanks :)

On 1/31/19 1:10 PM, David Carlson wrote:


On Thu, Jan 31, 2019 at 11:28 AM Elmar <mailto:etsc...@gmail.com>> wrote:


I'm running 2.6.12; that setting does not exist in the
preferences.  The
https://wiki.gnucash.org/wiki/Backup says that this folder HOME

<https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/.gconf/apps/gnucash/

should exist, but it does not, nor is there any gsettings file in
HOME
<https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/.gnucash
(Linux Mint 18.3 btw).  - Elmar

On 1/31/19 4:14 AM, Colin Law wrote:
> On Thu, 31 Jan 2019 at 09:08, Elmar mailto:etsc...@gmail.com>> wrote:
>> Open simultaneously - that sounds dangerous to my galloping
senility :)
>> Normally I run into this when I have been working on the file
for an
>> hour or so, having done some 20 or 30 operations e.g. end of month
>> multiple bank statement reconciles, then I screw up something. 
A quick
>> ctrl-z would save a whole lot of grief.
> Configure Auto Save to save the file every 5 minutes. Then you
should
> not need to go back and redo more than that.  Unless you are unlucky
> enough to make an erroneous change and by coincidence it immediately
> saves before you have time to close without saving.
>
> Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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.


I believe the AutoSave feature has been present for many years under 
Edit > Preferences > General > Files and should be in 2.6.12.  The 
problem with that is that it freezes the UI during the save, which can 
take more than a minute for some combinations of data file size and 
locations of program, user and data.  Twenty percent or more 
unavailability is not acceptable.  Worse, Auto means that it happens 
exactly when the quarterback has the ball, the defensive line is 
breaking through, the receivers are all covered with flypaper and the 
TV replay cameras are not properly aimed.


That is why I choose manually when I want my backups.

David Carlson

___
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] undo needed, was Re: Reconciliation is not adding up correctly

[Elmar]

Open simultaneously - that sounds dangerous to my galloping senility :) 
Normally I run into this when I have been working on the file for an 
hour or so, having done some 20 or 30 operations e.g. end of month 
multiple bank statement reconciles, then I screw up something.  A quick 
ctrl-z would save a whole lot of grief.


- Elmar

On 1/30/19 6:09 PM, David Carlson wrote:

Elmar,

True, but if you have been keeping backups you can open a backup file 
simultaneously with your data file, find the eroneously deleted 
transaction, copy it [Transaction > Copy], return to the main file and 
paste it back in [Transaction > Paste Transaction].


I do this a few times each year when I screw up.

Warning!  when you do this, close the backup file before closing the 
main file, to avoid corrupting certain settings or accidentally 
switching to the backup the next time you open GnuCash.


On Wed, Jan 30, 2019 at 12:32 PM Elmar <mailto:etsc...@gmail.com>> wrote:


I bet the ability to  have a few levels of "undo" is on the desired
enhancements list, no?  I certainly have cursed a few times when I
hit
delete by mistake.

- Elmar

On 1/30/19 12:00 PM, gnucash-user-requ...@gnucash.org
<mailto:gnucash-user-requ...@gnucash.org> wrote:
> Message: 9 Date: Wed, 30 Jan 2019 12:17:20 + From: Colin
Law  > mailto:clan...@gmail.com>> ... Once you
have deleted a transaction then it
 > is gone, so you won't be able to find it in by filtering.
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] undo needed, was Re: Reconciliation is not adding up correctly

[Elmar]

I'm running 2.6.12; that setting does not exist in the preferences.  The 
https://wiki.gnucash.org/wiki/Backup says that this folder HOME 
<https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/.gconf/apps/gnucash/ 
should exist, but it does not, nor is there any gsettings file in HOME 
<https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/.gnucash  
(Linux Mint 18.3 btw).  - Elmar


On 1/31/19 4:14 AM, Colin Law wrote:

On Thu, 31 Jan 2019 at 09:08, Elmar  wrote:

Open simultaneously - that sounds dangerous to my galloping senility :)
Normally I run into this when I have been working on the file for an
hour or so, having done some 20 or 30 operations e.g. end of month
multiple bank statement reconciles, then I screw up something.  A quick
ctrl-z would save a whole lot of grief.

Configure Auto Save to save the file every 5 minutes.  Then you should
not need to go back and redo more than that.  Unless you are unlucky
enough to make an erroneous change and by coincidence it immediately
saves before you have time to close without saving.

Colin

___
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] upgrade from 2.6.12 to 3.5-1 via deb

[Elmar]

I just saw the reply that it was built for Mint 19.x, not 18.x.. *sigh* 
I guess I have to upgrade my Mint.


On 4/15/19 8:45 AM, Colin Law wrote:

On Mon, 15 Apr 2019 at 13:42, Elmar  wrote:

Downloaded gnucash_3.5_amd64.deb, and tried to install via the gdebi
installer and got an red error bar saying "Error:Dependency is not
satisfiable: gnucash-common (=1:3.5)" I'm running Mint 18.3 with the
Mate desktop, btw.

Where did you download that from?  If it is Stephen's deb then you
need to download and install all three files

Colin

___
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] upgrade from 2.6.12 to 3.5-1 via deb

[Elmar]

Downloaded gnucash_3.5_amd64.deb, and tried to install via the gdebi 
installer and got an red error bar saying "Error:Dependency is not 
satisfiable: gnucash-common (=1:3.5)" I'm running Mint 18.3 with the 
Mate desktop, btw.


How to proceed? - Elmar


___
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] upgrade from 2.6.12 to 3.5-1 via deb

[Elmar]

Got them, thanks.  But "all at once"?  In which order?  - Elmar

On 4/15/19 12:18 PM, Stephen M. Butler wrote:

On 4/15/19 5:39 AM, Elmar wrote:

Downloaded gnucash_3.5_amd64.deb, and tried to install via the gdebi
installer and got an red error bar saying "Error:Dependency is not
satisfiable: gnucash-common (=1:3.5)" I'm running Mint 18.3 with the
Mate desktop, btw.

How to proceed? - Elmar


.


You need all three packages and install them all together at once.


___
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] upgrade from 2.6.12 to 3.5-1 via deb

[Elmar]

Thanks.  Now to check to see if I can retain all my reports and my 
online signing data for account downloads ... or how to find and restore 
it as opposed to recreating everything.


On 4/15/19 12:45 PM, Colin Law wrote:

All in one command, if you put them in a folder by themselves then use
sudo dpkg -i *.deb

On Mon, 15 Apr 2019, 17:38 Elmar, <mailto:etsc...@gmail.com>> wrote:


Got them, thanks.  But "all at once"?  In which order?  - Elmar

On 4/15/19 12:18 PM, Stephen M. Butler wrote:
> On 4/15/19 5:39 AM, Elmar wrote:
>> Downloaded gnucash_3.5_amd64.deb, and tried to install via the
gdebi
>> installer and got an red error bar saying "Error:Dependency is not
>> satisfiable: gnucash-common (=1:3.5)" I'm running Mint 18.3
with the
>> Mate desktop, btw.
>>
>> How to proceed? - Elmar
>>
>>
>> .
>>
> You need all three packages and install them all together at once.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] GC CTD lost saved reports

[Elmar]

That did it, thanks.  Went to the .local and it had 2.4 and an empty 
2.8, so renamed the 2.4 to 2.8 and thus they reappeared.  I don't think 
the jar routine looks here though. - Elmar


On 6/2/19 4:34 PM, Geert Janssens wrote:

Op zondag 2 juni 2019 20:37:44 CEST schreef Elmar:

OK, this is a weird.  I was editing some of the options in a report,
specifically unhighlighting one account and highlighting another to
include, and tried to save the report.  GC crashed to desktop.
Reopening it (open anyway), now GC tells me that I have no saved reports
at all!  Looking in .gnucash folder, I see saved-reports-2.4 (and its
backup file) dated in 2018, so they are there, and they are in the
backup 7zip archive dated 15APR2019 (created by BackupGnuCash.jar along
with the .gnucash.gcm and the .gnucash files itself).  OTOH aqbanking
works fine.  This is GC 3.5 running under Linux Mint 19.1 Mate desktop.
How do I get my reports back? - Elmar

For gnucash 3.x and up gnucash looks for this file in
$HOME/.local/share/gnucash
Are files in that directory also backed up by BackupGnuCash.jar ? You should
restore to that directory as well if you want gnucash to find your saved
reports again.

Regards,

Geert



___
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] GC CTD lost saved reports

[Elmar]

OK, this is a weird.  I was editing some of the options in a report, 
specifically unhighlighting one account and highlighting another to 
include, and tried to save the report.  GC crashed to desktop.  
Reopening it (open anyway), now GC tells me that I have no saved reports 
at all!  Looking in .gnucash folder, I see saved-reports-2.4 (and its 
backup file) dated in 2018, so they are there, and they are in the 
backup 7zip archive dated 15APR2019 (created by BackupGnuCash.jar along 
with the .gnucash.gcm and the .gnucash files itself).  OTOH aqbanking 
works fine.  This is GC 3.5 running under Linux Mint 19.1 Mate desktop.  
How do I get my reports back? - Elmar



___
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] column widths - balance

[Elmar]

For some reason I can't seem to expand the column width for the account 
balance (e.g. a bank cash money market account, last column in the 
register) - it will only display 5 places in front of the decimal 
point.  Is this a bug?


GC Version: 3.5 Build ID: git 3.5+(2019-03-30) on Linux Mint 19.1 Mate 
desktop.


- Elmar



___
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] Upgrade 2.6.18 to 3.5

[Elmar]

On 4/10/19 11:15 AM, gnucash-user-requ...@gnucash.org wrote:

Date: Tue, 9 Apr 2019 14:21:15 -0500
From: Adrien Monteleone 
To: GnuCash 
Subject: Re: [GNC] Upgrade 2.6.18 to 3.5
Message-ID: <1fee796e-cc28-49a2-b975-8faf5425f...@lusfiber.net>
Content-Type: text/plain;??? charset=us-ascii

I think it was originally recommended to update to 2.6.19 or 2.6.21 first. 
(2.6.20 and .21 were snap fix releases for some critical problems with 2.6.19 
which was originally intended to be the *last* of the 2.6 series)

Regards,
Adrien


Heck, I am still running off the Mint repository version 2.6.12-1 built 
from rev ed11f6d+ on 2016-04-18.  Nothing is "broken" that I use, and I 
am being cautious, awaiting the repository to update. Anyone got any 
ideas on when that might happen? - Elmar



___
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] upgrade to 3.7?

[Elmar]

I downloaded and unpacked gnucash-3.7.tar.gz, but now I don't know what 
to do with the resulting folder - there is no install shell thingie.  
How do I proceed?  I have 3.6 running now. (Linux Mint 19.3).  thanks - 
Elmar


___
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-user Digest, Vol 198, Issue 17

[Elmar]

Thanks - I did exactly that (downloaded all 3 packages) but I got no joy:

ets@Shinobi-L ~/Downloads $ sudo apt install ./*3.7*.deb
[sudo] password for ets:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'gnucash' instead of './gnucash_3.7-0_amd64.deb'
Note, selecting 'gnucash-common' instead of './gnucash-common_3.7-0_all.deb'
Note, selecting 'python3-gnucash' instead of 
'./python3-gnucash_3.7-0_amd64.deb'

Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 gnucash : Depends: libboost-date-time1.67.0 but it is not installable
   Depends: libboost-filesystem1.67.0 but it is not installable
   Depends: libboost-locale1.67.0 but it is not installable
   Depends: libboost-regex1.67.0 (>= 1.67.0-10) but it is not 
installable

   Depends: libboost-system1.67.0 but it is not installable
   Depends: libicu63 (>= 63.1-1~) but it is not installable
   Depends: libofx7 (>= 1:0.9.14) but 1:0.9.12-1 is to be installed
 python3-gnucash : Depends: python3 (>= 3.7~) but 3.6.7-1~18.04 is to 
be installed

E: Unable to correct problems, you have held broken packages.
ets@Shinobi-L ~/Downloads $

- Elmar

On 9/9/19 9:06 PM, gnucash-user-requ...@gnucash.org wrote:

Message: 4
Date: Mon, 9 Sep 2019 15:32:06 -0500
From: Adrien Monteleone
To: Gnucash Users
Subject: Re: [GNC] upgrade to 3.7?
Message-ID:
Content-Type: text/plain;   charset=us-ascii

Elmar,

That package was for building from source.

If you want .deb files to install, one user is graciously packing them and 
making them publicly available via Dropbox found in this thread:

https://lists.gnucash.org/pipermail/gnucash-user/2019-September/086840.html

Follow the instructions in the thread.

Regards,
Adrien

___
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] Report - transactions vs day of month instead of day of week

[Elmar]

Is there any way to change the options of this included report (income 
vs. day of the week) into income vs day of the month?  I ask because I 
would like to get a report that gives me the expected income as I 
progress through a month for budgeting purposes.  The report vs. day of 
the week seems to be a bit odd to me.

___
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] Report - transactions vs day of month instead of day of week

[Elmar]

Well, never mind - I used a spreadsheet after exporting the account to 
csv, A lot of sorting then deleting rows, extracting the day of the 
month from the date and then function sumif with a criterion range of 
1-31.  But having that in a report instead of day of the week would 
still be nice.


On 1/26/20 7:35 PM, Elmar wrote:
Is there any way to change the options of this included report (income 
vs. day of the week) into income vs day of the month?  I ask because I 
would like to get a report that gives me the expected income as I 
progress through a month for budgeting purposes.  The report vs. day 
of the week seems to be a bit odd to me.

___
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] android app question

[Elmar]

Is there a site that supports the small android app?  I have a bunch of 
transactions that I would like to export into csv (or qif), but the app 
says that there are no transactions available to export.


- Elmar
___
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] GC CTD lost saved reports

[Elmar]

My actual data file is on a separate drive, btw : 
/mnt/363D179A5F47C759/finances/GnuCash


On 1/2/20 7:59 AM, Elmar wrote:
This is what's confusing: GC seems to have several folders on the 
linux side


/home//.config/gnucash

/home//.gnucash

/home//.local/share/gnucash

Should all of them have the same contents?  And if so, why the 
duplication?  Or is one or more of these left over from when I 
upgraded from version 2.6 to 3.7?


- Elmar

On 1/1/20 6:57 PM, John Ralls wrote:
That makes sense, the aqbanking stuff lives in its own folder, 
~/.aqbanking.


See if you have both ~/.gnucash and ~/.config/gnucash with only one 
of them having saved-reports-2.8.

If neither, then that's the file you want from your Windows config.

BTW, what does CTD expand to?

Regards,
John Ralls



On Jan 1, 2020, at 3:27 PM, Elmar  wrote:

Update - aqbanking data is NOT lost, just all the reports. The 
program says I have none saved, and need to create some.


On 1/1/20 4:46 PM, Elmar wrote:
Just had a CTD when trying to modify a save report while running in 
linux (my default OS), and now all my reports and all my aqbanking 
info is gone (Linux Mint 19.1, Version: 3.5 Build ID: git 
3.5+(2019-03-30) Finance::Quote: 1.47GC ).  However, since I dual 
boot, on the windows side, all the reports and aqbanking info is 
still there!  The data file is fine, happily. What do I need to 
copy over from where in win7 to where  in the linux file system to 
get my linux side working again? - Elmar




___
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] GC CTD lost saved reports

[Elmar]

This is what's confusing: GC seems to have several folders on the linux side

/home//.config/gnucash

/home//.gnucash

/home//.local/share/gnucash

Should all of them have the same contents?  And if so, why the 
duplication?  Or is one or more of these left over from when I upgraded 
from version 2.6 to 3.7?


- Elmar

On 1/1/20 6:57 PM, John Ralls wrote:

That makes sense, the aqbanking stuff lives in its own folder, ~/.aqbanking.

See if you have both ~/.gnucash and ~/.config/gnucash with only one of them 
having saved-reports-2.8.
If neither, then that's the file you want from your Windows config.

BTW, what does CTD expand to?

Regards,
John Ralls



On Jan 1, 2020, at 3:27 PM, Elmar  wrote:

Update - aqbanking data is NOT lost, just all the reports.  The program says I 
have none saved, and need to create some.

On 1/1/20 4:46 PM, Elmar wrote:

Just had a CTD when trying to modify a save report while running in linux (my 
default OS), and now all my reports and all my aqbanking info is gone (Linux 
Mint 19.1, Version: 3.5 Build ID: git 3.5+(2019-03-30) Finance::Quote: 1.47GC 
).  However, since I dual boot, on the windows side, all the reports and 
aqbanking info is still there!  The data file is fine, happily. What do I need 
to copy over from where in win7 to where  in the linux file system to get my 
linux side working again? - Elmar



___
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] GC CTD lost saved reports

[Elmar]

Since I am running only version 3.7 in both linux and win7, I can safely 
delete .gnucash entirely, right?


And in other news - I got my reports back :)  Thank the computer gods 
for backups and redundancies.


On 1/2/20 2:36 PM, John Ralls wrote:

~/.gnucash is left over from GC 2.6. The other two are for different purposes 
(and I forgot that when I wrote the earlier message), see 
https://wiki.gnucash.org/wiki/Configuration_Locations.

  ~/.gnucash should have saved-reports-2.4 only, ~/.local/share/gnucash should 
have both saved-reports-2.4 and saved-reports-2.8.

Regards,
John Ralls


On Jan 2, 2020, at 4:59 AM, Elmar  wrote:

This is what's confusing: GC seems to have several folders on the linux side

/home//.config/gnucash

/home//.gnucash

/home//.local/share/gnucash

Should all of them have the same contents?  And if so, why the duplication?  Or 
is one or more of these left over from when I upgraded from version 2.6 to 3.7?

- Elmar

On 1/1/20 6:57 PM, John Ralls wrote:

That makes sense, the aqbanking stuff lives in its own folder, ~/.aqbanking.

See if you have both ~/.gnucash and ~/.config/gnucash with only one of them 
having saved-reports-2.8.
If neither, then that's the file you want from your Windows config.

BTW, what does CTD expand to?

Regards,
John Ralls



On Jan 1, 2020, at 3:27 PM, Elmar  wrote:

Update - aqbanking data is NOT lost, just all the reports.  The program says I 
have none saved, and need to create some.

On 1/1/20 4:46 PM, Elmar wrote:

Just had a CTD when trying to modify a save report while running in linux (my 
default OS), and now all my reports and all my aqbanking info is gone (Linux 
Mint 19.1, Version: 3.5 Build ID: git 3.5+(2019-03-30) Finance::Quote: 1.47GC 
).  However, since I dual boot, on the windows side, all the reports and 
aqbanking info is still there!  The data file is fine, happily. What do I need 
to copy over from where in win7 to where  in the linux file system to get my 
linux side working again? - Elmar



___
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] GC CTD lost saved reports

[Elmar]

Just had a CTD when trying to modify a save report while running in 
linux (my default OS), and now all my reports and all my aqbanking info 
is gone (Linux Mint 19.1, Version: 3.5 Build ID: git 3.5+(2019-03-30) 
Finance::Quote: 1.47GC ).  However, since I dual boot, on the windows 
side, all the reports and aqbanking info is still there!  The data file 
is fine, happily. What do I need to copy over from where in win7 to 
where  in the linux file system to get my linux side working again? - Elmar



___
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] GC CTD lost saved reports

[Elmar]

Update - aqbanking data is NOT lost, just all the reports.  The program 
says I have none saved, and need to create some.


On 1/1/20 4:46 PM, Elmar wrote:
Just had a CTD when trying to modify a save report while running in 
linux (my default OS), and now all my reports and all my aqbanking 
info is gone (Linux Mint 19.1, Version: 3.5 Build ID: git 
3.5+(2019-03-30) Finance::Quote: 1.47GC ).  However, since I dual 
boot, on the windows side, all the reports and aqbanking info is still 
there!  The data file is fine, happily. What do I need to copy over 
from where in win7 to where  in the linux file system to get my linux 
side working again? - Elmar




___
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] Status: enqueued (1) ???

[Elmar]

Good morning - running Version: 3.8 Build ID: 3.8b+(2019-12-29) 
Finance::Quote: 1.49 under linux mint.  Attempting to get online 
transactions. I got a CTD.  Reopening gave the usual dialog, opened 
anyway, and saw that a couple of entries I'd just made weren't there. So 
I recreated them,l saved, and then tried to get online transactions a I 
have always done.  But - I get an error as soon as I try: "Status: 
enqueued (1)" - and no recourse other than "close". check/repair all did 
nothing.  How do I clear this error?


-elmar

p.s. I went into the online banking setup, discovered that all the 
associations had been lost when I upgraded from Linux Mint 19.3 to 20 
and thus QC also apparently auto-upgraded from 3.5 to 3.8, but fixing 
these did not change the behavior.

___
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] Online Banking Status: enqueued (1) ???

[Elmar]

On 7/14/2020 11:18 AM, Frank H. Ellenberger wrote:

...Perhaps you should
go through the Online Banking Setup for each account. Verify each tab there..


I did that, and realigned each account.  I didn't change the behavior. 
On my dual boot system (Windows 10/Linux mint 20), on the windows side I 
am running Version: 3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: - and 
it still works perfectly.  So it's the Linux side AQbanking module that 
seems out of sync with the upgraded GC 3.8.

___
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] Status: enqueued (1) ???

[Elmar]

Good morning - running Version: 3.8 Build ID: 3.8b+(2019-12-29) 
Finance::Quote: 1.49 under linux mint.  Attempting to get online 
transactions. I got a CTD.  Reopening gave the usual dialog, opened 
anyway, and saw that a couple of entries I'd just made weren't there. So 
I recreated them,l saved, and then tried to get online transactions a I 
have always done.  But - I get an error as soon as I try: "Status: 
enqueued (1)" - and no recourse other than "close". check/repair all did 
nothing.  How do I clear this error?


- Elmar

___
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] Status: enqueued (1) ???

[Elmar]

On 7/14/2020 11:27 AM, John Ralls wrote:
...

If it's a US bank then you need to upgrade AQBanking to 6.1.4 or later.


That sounds like what happened.  The windows 10 version - dual boot - 
(Version: 3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: -) still works 
fine. I had thought simply to copy the AQbanking folder across in case 
that was messed up, but if what you say needs doing, that won't work. 
Now how to find the updated AQbanking for Linux (Ubuntu base)?

___
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] Status: enqueued (1) ???

[Elmar]

I looked in https://packages.debian.org/search?keywords=aqbanking and 
found a whole bunch of stuff.  And am lost ... sorry.


On 7/14/20 3:56 PM, John Ralls wrote:

Debian unstable has 6.2.1, as does the future Ubuntu 20.10.

Regards,
John Ralls


On Jul 14, 2020, at 9:05 AM, Elmar  wrote:

On 7/14/2020 11:27 AM, John Ralls wrote:
...

If it's a US bank then you need to upgrade AQBanking to 6.1.4 or later.

That sounds like what happened.  The windows 10 version - dual boot - (Version: 
3.5 Build ID: 3.5+(2019-03-30) Finance::Quote: -) still works fine. I had 
thought simply to copy the AQbanking folder across in case that was messed up, 
but if what you say needs doing, that won't work. Now how to find the updated 
AQbanking for Linux (Ubuntu base)?


___
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] migrating reports from 2.6.19 to 4.4

[Elmar]

Good evening - I have installed 4.4 on both my partitions (win 10 via 
the exe, and linux mint via the flatpak).  I was running much earlier 
versions (3.8 on win10, and 2.6.18 on Linux).  My reports show up if I 
put the contents of the old gnucash (or .gnucash) folders into the 
appropriate folders on each partition, and they run.  BUT, they 
disappear as soon as I close the program.  And on the windows side, it 
CTD as soon as I try to delete an old report - why I don't know.  Is 
there a log file I can upload to diagnose this?

___
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] migrating reports from 2.6.19 to 4.4

[Elmar]

Good evening - I have installed 4.4 on both my partitions (win 10 via 
the exe, and linux mint via the flatpak).  I was running much earlier 
versions (3.8 on win10, and 2.6.18 on Linux).  My reports show up if I 
put the contents of the old gnucash (or .gnucash) folders into the 
appropriate folders on each partition, and they run.  BUT, they 
disappear as soon as I close the program.  And on the windows side, it 
CTD as soon as I try to delete an old report - why I don't know.  Is 
there a log file I can upload to diagnose this?

___
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] flatpak 4.4 reports anomaly

[Elmar]

Since they do run and do extract the correct data OK, can I simply 
resave them, or if not, trivially alter some aspect to save under a new 
name to avoid having to remember what I all tweaked in each of them?


On 2/9/21 4:02 PM, Derek Atkins wrote:

Hi,

It is certainly true that 2.6 reports are not compatible with 4.4.  So
yes, I would expect saved reports to not have made the transition.

-derek

On Tue, February 9, 2021 3:58 pm, Elmar wrote:

Running the flatpak 4.4 on Linux Mint 19.3 - I've copied my version
2.6.19 reports into the gnucash folder in
/home/ets/.var/app/org.gnucash.GnuCash/data/gnucash (saved reports
2.4).  They al show up and run fine, BUT as soon as I try to delete one
of them, I get a CTD, a locked data file, and when I start the programk
(open anyway) and reopen the reports menu, only 2 of the many reports I
have saved show up.  Is ther a fundamental incompatability with the
report?  I can get my reports back if I delete the file
/home/ets/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8
and they do run, but I cannot delete any of them, and trying to export
their output results in the same crash.  Do I have to recreate ALL my
reports in the new version of GC?
___
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.

[GNC] flatpak 4.4 reports anomaly

[Elmar]

Running the flatpak 4.4 on Linux Mint 19.3 - I've copied my version 
2.6.19 reports into the gnucash folder in 
/home/ets/.var/app/org.gnucash.GnuCash/data/gnucash (saved reports 
2.4).  They al show up and run fine, BUT as soon as I try to delete one 
of them, I get a CTD, a locked data file, and when I start the programk 
(open anyway) and reopen the reports menu, only 2 of the many reports I 
have saved show up.  Is ther a fundamental incompatability with the 
report?  I can get my reports back if I delete the file 
/home/ets/.var/app/org.gnucash.GnuCash/data/gnucash/saved-reports-2.8 
and they do run, but I cannot delete any of them, and trying to export 
their output results in the same crash.  Do I have to recreate ALL my 
reports in the new version of GC?

___
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] flatpak 4.4 reports anomaly

[Elmar]

I just took the 2.4 file, copied it (CTRL-C/CTRL-V) and renamed it to 
2.8.  Opened GC, tried to delete one report, and got a crash to 
desktop.  So no joy there, unless I have misunderstood what you suggested.


On 2/9/21 4:38 PM, David H wrote:

Elmar,

Since you say they seem to run, why don't you try closing gnucash and 
then copying your saved-reports-2.4 to saved-reports-2.8, re-opening 
Gnucash and opening each saved report in turn and then if everything 
looks ok saving the config of each of your reports ?  I've upgraded 
over the years and am also using the flatpak version 4.4 on Ubuntu and 
have both a saved-reports-2.4 and a saved-reports-2.8 in 
the .var/app/org.gnucash.GnuCash/data/gnucash/ folder and the 2.4 
version is just ignored.


Just backup your files first of course.

Cheers David H.


___
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] flatpak 4.4 reports anomaly

[Elmar]

Thank all for the replies, but what are "scheme backtraces" and where do 
I find them?  and how do I "convert" my 2.4 reports to 4.4 compatible 
ones? - Elmar


On 2/9/21 11:46 PM, John Ralls wrote:

Elmar,

A fair amount of Scheme API was deprecated in 3.x and removed in 4.x. Look 
through the NEWS file for which ones. There should be Scheme backtraces in the 
trace file that will help identify the source of the crash.

Regards,
John Ralls



On Feb 9, 2021, at 3:01 PM, Elmar  wrote:

I just took the 2.4 file, copied it (CTRL-C/CTRL-V) and renamed it to 2.8.  
Opened GC, tried to delete one report, and got a crash to desktop.  So no joy 
there, unless I have misunderstood what you suggested.

On 2/9/21 4:38 PM, David H wrote:

Elmar,

Since you say they seem to run, why don't you try closing gnucash and then 
copying your saved-reports-2.4 to saved-reports-2.8, re-opening Gnucash and 
opening each saved report in turn and then if everything looks ok saving the 
config of each of your reports ?  I've upgraded over the years and am also 
using the flatpak version 4.4 on Ubuntu and have both a saved-reports-2.4 and a 
saved-reports-2.8 in the .var/app/org.gnucash.GnuCash/data/gnucash/ folder and 
the 2.4 version is just ignored.

Just backup your files first of course.

Cheers David H.

___
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] flatpak 4.4 reports anomaly

[Elmar]

The sequence of events was that I had been running 3.8, but somehow it 
started to fail badly, with CTD.  So I uninstalled that one and 
reinstalled the one from the Mint repository, which was 2.6.19.  All 
seemed well. I tried to reinstall 3.6 and then 3.8, then 3.11, but the 
installs failed in weird ways, which I didn't bother to document - my 
goal was to get to 4.4 anyway.  So I gave up and grabbed the flatpak of 
4.4.  In all these versions, going up and down, the data file remained 
perfect, and once I moved the "guts" of my aqbanking folder (archived 
from version 3.8) into the correct folder for 4.4, my online banking 
(downloads of transactions) also worked perfectly, and continue to 
work.  The "guts" of the gnucash folder (the one holding the reports 
templates) when copied from the 3.8 archive into the correct 4.4 folder 
(under .var) seemed to go smoothly, and all my reports showed up fine, 
and they run fine.  I just cannot edit or delete any one of them without 
a CTD, and have to delete the settings6 folder to get them to show up 
again.  All check and repair seems to do is look for imbalances across 
the selected accounts, and it finds no problems.  It doesn't touch 
report or online templates as far as I can see. So, as I said, my only 
problem are editing my reports (running them works), and I see no way to 
edit/resave them, since I CTD as soon as I try.


On 2/10/21 5:13 PM, David H wrote:

Elmar,

Can I ask how you went from 2.6.19 to 4.4 flatpak?  ... For the 
reports you may have to open each and re-save the config after the 2.8 
update, I don't know.


Cheers David H.



___
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] flatpak 4.4 reports anomaly

[Elmar]

Trying "flatpak run org.GnuCash.gnucash --logto=$HOME/gnucash.trace"

does not invoke the program and instead gives me

"error: app/org.GnuCash.gnucash/x86_64/master not installed"

Which is very odd, since it runs from the menu system fine.

- Elmar

On 2/11/21 3:59 AM, Geert Janssens wrote:
The default trace file location on flatpak doesn't work indeed. By  > default the trace file will be written in /tmp and that folder is > 
treated special by flatpak. The details aren't clear to me yet, but > 
it's indeed safer to add the --logto option. You are free to use a > 
file name there (for example "$HOME/ gnucash.trace") or stdout. > > Note 
for completeness to start the flatpak edition of gnucash you'll > 
probably have to invoke something more like this: flatpak run > 
org.GnuCash.gnucash --logto="path-to-log-to-or-stdout" > > Regards, > > 
Geert >


___
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] flatpak 4.4 reports anomaly

[Elmar]

Running "/usr/bin/flatpak run --branch=stable --arch=x86_64 
--command=gnucash --file-forwarding org.gnucash.GnuCash 
--logto=$HOME/gnucash.trace" in a terminal window invoked GC fine. 
Opening the saved reports item, then trying to delete a report results 
in this output in the terminal window:


ets@Shinobi-L ~ $ /usr/bin/flatpak run --branch=stable --arch=x86_64 
--command=gnucash --file-forwarding org.gnucash.GnuCash 
--logto=$HOME/gnucash.trace

Found Finance::Quote version 1.49.
Backtrace:
   7 (apply-smob/1 #)
In report-core.scm:
    735:9  6 (gnc:save-all-reports)
In srfi/srfi-1.scm:
   592:29  5 (map1 (("56c1338531aa5948f29ffac9c8299627" . #<) …))
   592:29  4 (map1 (("48954786309f091b627a6d3bac31df38" . #<) …))
   592:17  3 (map1 (("f4327d79575b0d1039dc544e59030b77" . #<) …))
In report-core.scm:
   725:20  2 (gnc:report-template-save-to-savefile _)
   659:21  1 (gnc:report-template-serialize #< vers…>)
    165:0  0 (%report-template-name-procedure _)

report-core.scm:165:0: In procedure %report-template-name-procedure:
In procedure struct_vtable: Wrong type argument in position 1 (expecting 
struct): #f

ets@Shinobi-L ~ $

OTOH the gnucash.trace file is completely blank.

- Elmar

On 2/11/21 11:23 AM, Geert Janssens wrote:

Ok, the branch specification is probably important.

You can try as follows:
/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash --file-
forwarding org.gnucash.GnuCash --logto="path-to-log-to-or-stdout"

My mail client splits this line up, but the command should be all on one line.

Regards,

Geert


___
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] flatpak 4.4 reports anomaly

[Elmar]

The menu item cals GC via "/usr/bin/flatpak run --branch=stable 
--arch=x86_64 --command=gnucash --file-forwarding org.gnucash.GnuCash @@ 
%f @@"


And this is the first (and only) flatpak I have ever installed.  I 
installed Flatseal so GC could find my data files as well, of course.


On 2/11/21 9:16 AM, Geert Janssens wrote:

In that case the first thing to do is to figure out how exactly your system
calls the flatpak version of gnucash. There are quite a few subtle details
that may affect this.

You can examine the menu entry to figure out what command is being run
exactly.

Out of curiosity have you been removing installed flatpaks manually by
deleting associated directories ? The error suggests flatpak believes a
version of gnucash (master) is installed on your system while it appears not
to.

Regards,

Geert

Op donderdag 11 februari 2021 13:58:29 CET schreef Elmar:

Trying "flatpak run org.GnuCash.gnucash --logto=$HOME/gnucash.trace"

does not invoke the program and instead gives me

"error: app/org.GnuCash.gnucash/x86_64/master not installed"

Which is very odd, since it runs from the menu system fine.

- Elmar


___
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] CSV matching for credit cards?

[Elmar]

Good evening - I have managed to figure out how to do the csv matches 
for normal asset accounts, since the labels actually line up with what I 
expect them to mean.  But I am having problems with credit cards.  My 
csv looks like this:


Tran Date    Post Date    Description    Ref Number    Amount
3/20/2021    3/21/2021    [redacted]     19918    74.99
[lots more lines like the above]
3/3/2021    3/3/2021    PAYMENT - THANK YOU        -792.66

How does this line up with deposit?  Withdrawal? And in the gnucash file 
the columns for liability accounts are increase and decrease, which does 
match either the csv, or the importer.


Further, I can't get some matches that are obviously matches to match - 
date, amount all both identical, but it says "no match". Why?


- Elmar

___
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] CSV matching for credit cards?

[Elmar]

Sorry - the csv is comma separated.  To post this I dumped it into 
libreoffice, the copy/pasted into a text file, which of course removes 
the commas. The original is like so:


Tran Date,Post Date,Description,Ref Number,Amount
3/20/2021,3/21/2021,[redacted],019918,74.99
...
3/3/2021,3/3/2021,PAYMENT - THANK YOU,,-792.66

Sorry for the confusion.  This is then in theimporter specification 
(obviously skip first line) date, none, description, number,  and here I 
stumble.  The liability account has headers that say Increase, and 
Decrease.  Now is that a deposit in the importer or a withdrawal? It's 
the switches in terminology that confuse me: "amount" in the csv vs. 
deposit/withdrawal in the importer vs. increase/decrease in the 
liability account.  What is which?  Is my "amount" a "deposit" that will 
translate into an "increase" if a positive value?


And finally, the matching question is also unresolved.  Thanks for the 
reply, and apologies for my denseness. - Elmar


On 4/1/21 6:07 PM, David Cousens wrote:
Elmar,  > > The example you listed is not comma separated... > >  One will 
assign Debit to +ve amounts and Credit to negative > amounts and the 
other will reverse these. Idon't know which way round > it is though. It 
will likely be opposite to the assignment you used > to import asset 
account data > >


___
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] OFX connect/AQbanking problem

[Elmar]

  Now you are speaking in tongues - the only scent I get from my 
computer in the years that I have had them is when the magic blue smoke 
comes out. Not a pleasant smell ...


On 3/13/21 11:22 AM, D. wrote:

... downloaded a recent copy of Quicken and sniffed the packets that come and 
go during a session with their bank under Quicken


___
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] OFX connect/AQbanking problem.

[Elmar]

Alas, it seems as if the assembled knowledge base cannot solve this.  It 
bothers me that this used to work fine in the older version, but now 
fails, despite having the bank in the database.  No help at all?  The 
bank will not "expose" its OFX files for download - only CSV, and that's 
a royal pain. - Elmar


On 3/5/21 4:59 PM, David H wrote:
Sorry Elmar, can't help you there as I'm in Oz and we don't use AQ 
Banking oe the like here, just simple OFX/CSV downloads is all they'll 
give us.  Such is life.  I'm sure someone will come along when your 
time zone wakes up and be able to give you some pointers to get it 
working.  Thanks for the heads up on flatseal - didn't realise it even 
existed and it looks quite nice.


Cheers David H.

On Sat, 6 Mar 2021 at 07:48, Elmar <mailto:etsc...@gmail.com>> wrote:


thank you for your kind reply.  I have flatseal, and it shows the
network permission set on for gnucash.  What diagnostic can I
send? - Elmar

On 3/5/21 4:42 PM, David H wrote:
> See https://docs.flatpak.org/en/latest/sandbox-permissions.html -
> flatpak works in it's own little world separated from the host os -
> think of it as a VM I guess so you have to setup everything again.
> You probably need to enable network permissions going by the
network
> error you received.
>
> Cheers David H.
    >
> On Sat, 6 Mar 2021 at 07:28, Elmar mailto:etsc...@gmail.com>
> <mailto:etsc...@gmail.com <mailto:etsc...@gmail.com>>> wrote:
>
    >     No ideas?  No responses?
>
>     On 3/3/21 12:03 PM, Elmar wrote:
>     > I upgraded from 2.6 to 4.4 via flatpak, and discovered
that all my
>     > online banking credentials/profiles have vanished. So I
have to
>     > recreate - but using the set-up online banking setup tool, I
>     created
>     > the user OK, but when it comes time to retrieve the
account list
>     from
>     > the bank (which DOES show up in the bank list, btw) I get the
>     > following dialog:
>     >
>     > 14:01:12 Sending request...
>     > 14:01:12 Using GnuTLS default ciphers.
>     > 14:01:12 TLS: SSL-Ciphers negotiated:
>     TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
>     > 14:01:12 Waiting for response...
>     > 14:01:12 No message received
>     > 14:01:12 Network error while waiting for response
>     > 14:01:12 Operation finished, you can now close this window.
>     >
>     > GC retrieved fine in earlier versions; what is going wrong
here?
>     The
>     > bank involved is the Local Government Federal Credit
Union, if that
>     > matters.  Since it showed up in the drop down list, I had
hoped
>     that
>     > it would be all setup automagically.  Apparently not.
Running under
>     > Linux Mint 19.3 Mate desktop in case that has any effect.
- Elmar
>     >
>
>     ___
>     gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto:gnucash-user@gnucash.org <mailto: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] OFX connect/AQbanking problem

[Elmar]

Thank you for the explanation, David.  My "pique" if you will, was the 
lack of response following the last reply.  What I was hoping for was a 
pointer to what changed between version 2 and version 4 of GC in 
aqbanking, since the older version did downloads fine, but the new 
version doesn't, or failing that, some way to diagnose the problem based 
on the error message, or lastly a person I could contact that knows the 
internals of the module, especially since Quicken is supported by the 
bank (I don't have Quicken, btw).  In any case, I don't "blame" anyone, 
especially not for a volunteer maintained and developed program. Such an 
attitude is imho simply wrong.  I apologize if I came off too strong. - 
Elmar


On 3/13/21 10:51 AM, gnucash-user-requ...@gnucash.org wrote:

Message: 12
Date: Sat, 13 Mar 2021 10:51:39 -0500
From: "D." 
To: Elmar 
Cc: David H , Rainer Dorsch via gnucash-user

Subject: Re: [GNC] OFX connect/AQbanking problem.
Message-ID: 
Content-Type: text/plain; charset=UTF-8

Elmar,

The AQbanking connection is a commercially-maintained black box protocol that 
was previously reverse engineered by the diligent volunteer maintainer of the 
AQbanking package. The fact that it failed when the commercial vendor altered 
the innards inside the box is not surprising. The ongoing challenges of 
figuring out the workarounds demonstrates the skill with which that commercial 
vendor has created their new system. There have been numerous discussions on 
these lists regarding different attempts. That they haven't worked for you is 
lamentable, to be sure, but not a reason to blame the group for not providing 
you a solution.

David T.


 Original Message 
From: Elmar 
Sent: Sat Mar 13 09:33:50 EST 2021
To: David H 
Cc: GNU Cash User 
Subject: Re: [GNC] OFX connect/AQbanking problem.

Alas, it seems as if the assembled knowledge base cannot solve this.? It
bothers me that this used to work fine in the older version, but now
fails, despite having the bank in the database.? No help at all?? The
bank will not "expose" its OFX files for download - only CSV, and that's
a royal pain. - Elmar


___
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] CSV matching produces duplicates?

[Elmar]

No - just taken from the bank as CSV directly.  I have another post 
where the OFX problem is described.


On 3/3/21 5:40 PM, Christopher Lam wrote:
You mean transactions imported via ofx then reimported with CSV? This 
may be https://bugs.gnucash.org/show_bug.cgi?id=798128


For now, it'll be best to narrow down your CSV import to exclude the 
already imported date range.


On Thu, 4 Mar 2021, 5:59 am Elmar, <mailto:etsc...@gmail.com>> wrote:


Version 4.4 from flatpak on linux mint 19.3  ( I think my sig
needs to
be fixed, but I misremember how to do that)

Since my OFX import to my bank seems now broken, I have been
reduced to
CSV imports.  And I find that the matcher does not match worth beans,
producing duplicates of tranasctions that in fact DO match within the
one month window.  Is this a know problem?  Is there a way to tune
the
matcher better? - Elmar



___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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.

[GNC] CSV matching produces duplicates?

[Elmar]

Version 4.4 from flatpak on linux mint 19.3  ( I think my sig needs to 
be fixed, but I misremember how to do that)


Since my OFX import to my bank seems now broken, I have been reduced to 
CSV imports.  And I find that the matcher does not match worth beans, 
producing duplicates of tranasctions that in fact DO match within the 
one month window.  Is this a know problem?  Is there a way to tune the 
matcher better? - Elmar




___
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] CSV matching produces duplicates?

[Elmar]

Even if I know that the match exists, and I tell it that it does, it 
replies that the match does not exist.  So I have to either leave it red 
so it doesn't import, or accept the duplicate.  Which means keeping both 
windows open (the match window and the account window), and manually 
checking the matches myself.  Which defeats the entire purpose of 
computer matching.


On 3/3/21 6:13 PM, David Carlson wrote:
Isn't it still possible to manually override the automatic behavior on 
a transaction by transaction basis during the various types of imports?


I know that is not wanted, but that is what we have to do to train the 
Bayesian matching.  I am frustrated that the new matcher released in 
the 3.x series is not learning to make matches that it did very well 
in the old matcher.  If anyone has suggestions in this regard I am all 
ears.


On Wed, Mar 3, 2021 at 4:46 PM Elmar <mailto:etsc...@gmail.com>> wrote:


No - just taken from the bank as CSV directly.  I have another post
where the OFX problem is described.

On 3/3/21 5:40 PM, Christopher Lam wrote:
> You mean transactions imported via ofx then reimported with CSV?
This
> may be https://bugs.gnucash.org/show_bug.cgi?id=798128
>
> For now, it'll be best to narrow down your CSV import to exclude
the
> already imported date range.
>
> On Thu, 4 Mar 2021, 5:59 am Elmar, mailto:etsc...@gmail.com>
> <mailto:etsc...@gmail.com <mailto:etsc...@gmail.com>>> wrote:
>
>     Version 4.4 from flatpak on linux mint 19.3  ( I think my sig
>     needs to
>     be fixed, but I misremember how to do that)
>
>     Since my OFX import to my bank seems now broken, I have been
>     reduced to
>     CSV imports.  And I find that the matcher does not match
worth beans,
>     producing duplicates of tranasctions that in fact DO match
within the
>     one month window.  Is this a know problem?  Is there a way
to tune
>     the
>     matcher better? - Elmar
>
>
>
>     ___
>     gnucash-user mailing list
> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
<mailto:gnucash-user@gnucash.org <mailto: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 <mailto: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.



--
David Carlson


___
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] CSV matching produces duplicates?

[Elmar]

Response at bottom -

On 3/3/21 11:49 PM, gnucash-user-requ...@gnucash.org wrote:
 > -- > > As Elmar pointed out, clicking the 
'A' box for an incoming > transaction forces the import even if there is 
an existing match. > That is worse than just accepting every transaction 
as new and going > back and deleting duplicates later (this has 
essentially been my > procedure for the past few months of supposed 
training of the new > Bayesian matcher). I mostly use manual OFX imports 
except for a few > accounts where that is not offered. > > He also 
points out that sometimes there is an existing match but the > importer 
does not find it or allow it to be manually matched during > the import. 
I do see that too, although it is infrequent for me. > > In any case, 
there is very little of the potential labor saving from > the automation 
actually happening > > > > On Wed, Mar 3, 2021 at 6:38 PM David Cousens 
>  wrote: > >> Elmar, >> >> If a transaction 
has been matched and is marked to be either >> updated (U column 
checkbox selected) or cleared (C column checkbox >> selected), you have 
to deselect the selected checkboxes in the U >> (up[date) and C (Clear) 
column( previously labelled the R column in >> earlier GC versions) and 
then select the checkbox in the A column >> for the transaction row to 
force it to import. It is then likely >> you will have to assign a 
transfer account before importing. The >> importer does learn 
particularly in the account matching part of >> the procedure and it is 
important for the learning process that >> this is done before the final 
import of the batch of transactions
Sadly, while the bank offers integration with Quicken explicitly, they 
do not expose the OFX file for me to download, so until they do, I am 
stuck with CSV.  So I need to know how best to do this CSV.  My old 
procedure was to download via the OFX with the date range always 
extending back to one day before the last reconcile, just in case I 
missed any transactions.  This of course results in the CSV having tons 
of duplicates showing before I complete the import.  With the OFX, the 
duplicate checking works pretty well perfectly, but with the CSV, it 
doesn't appear to, unless I am using it wrong, i.e. clicking cleared 
(old reconcile) on what I know is already in the file.  When I do click 
C, the importer tells me No Match, which is wrong.  Bottom line seems to 
be that I have to keep the acount window open beside the import window, 
and use the mark 1 eyeball to find the duplicates, and (check me on 
this) force them to display red to avoid duplicates in the file.  Is 
this correct? - Elmar

___
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] OFX connect/AQbanking problem.

[Elmar]

I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my 
online banking credentials/profiles have vanished.  So I have to 
recreate - but using the set-up online banking setup tool, I created the 
user OK, but when it comes time to retrieve the account list from the 
bank (which DOES show up in the bank list, btw)  I get the following dialog:


14:01:12 Sending request...
14:01:12 Using GnuTLS default ciphers.
14:01:12 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
14:01:12 Waiting for response...
14:01:12 No message received
14:01:12 Network error while waiting for response
14:01:12 Operation finished, you can now close this window.

GC retrieved fine in earlier versions; what is going wrong here? The 
bank involved is the Local Government Federal Credit Union, if that 
matters.  Since it showed up in the drop down list, I had hoped that it 
would be all setup automagically.  Apparently not.  Running under Linux 
Mint 19.3 Mate desktop in case that has any effect. - Elmar


___
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] OFX connect/AQbanking problem.

[Elmar]

No ideas?  No responses?

On 3/3/21 12:03 PM, Elmar wrote:
I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my 
online banking credentials/profiles have vanished.  So I have to 
recreate - but using the set-up online banking setup tool, I created 
the user OK, but when it comes time to retrieve the account list from 
the bank (which DOES show up in the bank list, btw)  I get the 
following dialog:


14:01:12 Sending request...
14:01:12 Using GnuTLS default ciphers.
14:01:12 TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
14:01:12 Waiting for response...
14:01:12 No message received
14:01:12 Network error while waiting for response
14:01:12 Operation finished, you can now close this window.

GC retrieved fine in earlier versions; what is going wrong here? The 
bank involved is the Local Government Federal Credit Union, if that 
matters.  Since it showed up in the drop down list, I had hoped that 
it would be all setup automagically.  Apparently not. Running under 
Linux Mint 19.3 Mate desktop in case that has any effect. - Elmar




___
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] OFX connect/AQbanking problem.

[Elmar]

thank you for your kind reply.  I have flatseal, and it shows the 
network permission set on for gnucash.  What diagnostic can I send? - Elmar


On 3/5/21 4:42 PM, David H wrote:
See https://docs.flatpak.org/en/latest/sandbox-permissions.html - 
flatpak works in it's own little world separated from the host os - 
think of it as a VM I guess so you have to setup everything again.  
You probably need to enable network permissions going by the network 
error you received.


Cheers David H.

On Sat, 6 Mar 2021 at 07:28, Elmar <mailto:etsc...@gmail.com>> wrote:


No ideas?  No responses?

On 3/3/21 12:03 PM, Elmar wrote:
> I upgraded from 2.6 to 4.4 via flatpak, and discovered that all my
> online banking credentials/profiles have vanished. So I have to
> recreate - but using the set-up online banking setup tool, I
created
> the user OK, but when it comes time to retrieve the account list
from
> the bank (which DOES show up in the bank list, btw) I get the
> following dialog:
>
> 14:01:12 Sending request...
> 14:01:12 Using GnuTLS default ciphers.
> 14:01:12 TLS: SSL-Ciphers negotiated:
TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
> 14:01:12 Waiting for response...
> 14:01:12 No message received
> 14:01:12 Network error while waiting for response
> 14:01:12 Operation finished, you can now close this window.
>
> GC retrieved fine in earlier versions; what is going wrong here?
The
> bank involved is the Local Government Federal Credit Union, if that
> matters.  Since it showed up in the drop down list, I had hoped
that
> it would be all setup automagically.  Apparently not. Running under
> Linux Mint 19.3 Mate desktop in case that has any effect. - Elmar
>

___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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] flatpak 4.4 reports anomaly

[Elmar]

I'm trying to edit and/or delete existing reports, not (yet) create new 
ones.  Or do you mean the trace file? In the command string I used 
--logto=$HOME/gnucash.trace, and that file was created.  It just had no 
contents.


On 2/12/21 1:40 AM, Christopher Lam wrote:

You normally specify the name when Saving a report. What name did you use?

On Fri, 12 Feb 2021, 12:36 am Elmar, <mailto:etsc...@gmail.com>> wrote:


Running "/usr/bin/flatpak run --branch=stable --arch=x86_64
--command=gnucash --file-forwarding org.gnucash.GnuCash
--logto=$HOME/gnucash.trace"


...
___
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] version 3.11, flatpak 4.4 and Status: enqueued (1) ???

[Elmar]

Good morning.  I've installed 3.11 from 
https://launchpad.net/~sicklylife/+archive/ubuntu/gnucash by adding the 
PPA, and then the software manager popped up and offered to upgrade from 
the MINT provided version 2.6.19 (Linux Mint 19.3). Works fine except it 
crashes to disk as soon as I invoke the aqbanking module to retrieve 
transactions from the bank.  Restarting the program although it 
complains about a lock being in place and reattempting the download 
results in the enqueued error.  Deleting the setting6 folder from 
.aqbanking lets the program try again, but I get the same error.  In 
desperation, I loaded the flatpak version of 4.4, which runs fine (after 
I used flatseal to let it see my data file on a different disk), but 
none of my reports nor any of the aqbanking data settings are there.  So 
2 questions - how do I fix 3.11 to not crash with aqbanking and/or where 
do I put the "guts" of the .aqbanking and .gnucash folders (currently in 
my home directory) into the flatpak version?  Thanks. - Elmar

___
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] flatpak 4.4 reports anomaly

[Elmar]

In the absence of any follow-up, I am guessing that I'm hosed?  Just 
have to delete the saved-reports-2.4 and try to rebuild my reports from 
scratch?


On 2/11/21 11:36 AM, Elmar wrote:
Running "/usr/bin/flatpak run --branch=stable --arch=x86_64 
--command=gnucash --file-forwarding org.gnucash.GnuCash 
--logto=$HOME/gnucash.trace" in a terminal window invoked GC fine. 
Opening the saved reports item, then trying to delete a report results 
in this output in the terminal window:


ets@Shinobi-L ~ $ /usr/bin/flatpak run --branch=stable --arch=x86_64 
--command=gnucash --file-forwarding org.gnucash.GnuCash 
--logto=$HOME/gnucash.trace

Found Finance::Quote version 1.49.
Backtrace:
   7 (apply-smob/1 #)
In report-core.scm:
    735:9  6 (gnc:save-all-reports)
In srfi/srfi-1.scm:
   592:29  5 (map1 (("56c1338531aa5948f29ffac9c8299627" . #<) …))
   592:29  4 (map1 (("48954786309f091b627a6d3bac31df38" . #<) …))
   592:17  3 (map1 (("f4327d79575b0d1039dc544e59030b77" . #<) …))
In report-core.scm:
   725:20  2 (gnc:report-template-save-to-savefile _)
   659:21  1 (gnc:report-template-serialize #< vers…>)
    165:0  0 (%report-template-name-procedure _)

report-core.scm:165:0: In procedure %report-template-name-procedure:
In procedure struct_vtable: Wrong type argument in position 1 
(expecting struct): #f

ets@Shinobi-L ~ $

OTOH the gnucash.trace file is completely blank.

- Elmar



___
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] nabble gnucash gone?

[Elmar]

Good afternoon.  The wiki link to gnucash on nabble no longer works.  
Has gnucash vanished from nabble?  I scrolled through almost 200 pages 
searching for "gnucash" and got no hits.


- Elmar
___
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] Flatpak/Flatseal Gnucash fails to launch

[Elmar]

I'm not sure how I "hijacked" the thread.  I thought I started a new one 
- apparently not.  Sorry.


I'm pretty sure that flatpak itself is the problem.  I just don't know 
how to diagnose it, or provide the right data so that it can be 
diagnosed by someone better than I.  I was hoping that since the 
inability to launch  gnucash is how I ran into this, that somone else 
would have had this problem and solved it.  I'll go the google route - 
searching the Mint forums didn't help.  And I guess the gnucash list is 
also not the place :)  I'll quit this thread here.


- Elmar

On 11/27/21 1:58 PM, Frank H. Ellenberger wrote:

Hi Elmar,

At first, yiu should not hijack other threads. For a new thread, do
*not* respond to another mail, but create a new mail to the list.

Am 25.11.21 um 18:42 schrieb Elmar:

Flatseal also reacts the same way, i.e. does not open, although if
flatpak is really isntalled it should at least show its window.

If other apps behave similar, is is usually a problem with your flatpak
installation. Try to google terms like "flatpak linux mint 20"

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] Flatpak/Flatseal Gnucash fails to launch

[Elmar]

Good afternoon, all

I just went through a clean install, replacing my Linux Mint 19.3 with 
Mint 20.2.  Gnucash 3.8 is provided and it opens my data file seemingly 
OK, but I had the flatpak running version 4.x, and would like to get 
that back.  I have installed and reinstalled flatpak, but when I click 
on the icon for gnucash 4.x, I get the wait timer, and then nothing.  
Flatseal also reacts the same way, i.e. does not open, although if 
flatpak is really isntalled it should at least show its window.  Ideas 
on how to get the flatpak version running again?  Thanks


- Elmar

Release Linux Mint 20.2 Uma 64-bit
Kernel Linux 5.4.0-90-generic x86_64
MATE 1.24.0

 (ignore the autosig - and how do I change it btw?)
___
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] SOLVED Re: Flatpak/Flatseal Gnucash fails to launch

[Elmar]

On 12/1/21 1:19 AM, Chris Good wrote:

...

https://github.com/flatpak/flatpak/issues/3585#issuecomment-621545087 
 :


Looks like your repo config was somehow deleted. If you don't care 
about saving the apps


in your user installation you can just do |rm -rf ~/.local/share/flatpak|




That worked  Gnucash came up instantly.  Many many thanks!

___
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] Flatpak/Flatseal Gnucash fails to launch

[Elmar]

On 11/30/21 3:13 AM, Geert Janssens wrote:


... flaptak run org.gnucash.GnuCash
Thank you for your kind reply, Geert.  I have been banging this around 
the Linuxmint forum as well with no resolution (See 
https://forums.linuxmint.com/viewtopic.php?f=90=362033=2101949#p2101949), 
and for some reason the software manager is not installing the flatpak 
programs so that they can be run.  Doing the above gives me the following:


ets@Shinobi ~ $ flatpak org.gnucash.GnuCash error:  > 'org.gnucash.GnuCash' is not a flatpak command. Did you mean > 

'create-usb'? > > See 'flatpak --help'

So no joy here so far. - Elmar




___
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] Flatpak/Flatseal Gnucash fails to launch

[Elmar]

On 11/30/21 7:51 AM, Fross, Michael wrote:
Don’t forget the “run” command. In your paste it was missing.  See 
Geert’s command.


Oops - here's better.  I got messed up first with flaptak, instead of 
flatpak :)



ets@Shinobi ~ $ flatpak run org.gnucash.GnuCash
error: While opening repository /home/ets/.local/share/flatpak/repo: 
opening repo: opendir(objects): No such file or directory


___
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] reports does not work

[Elmar]

I tried this, and I get -

Command 'gnucash' not found, but can be installed with:
sudo apt install gnucash

My gnucash is flatpak (Build ID: Flathub 5.4.1), so that is why I'd 
guess.  How should I modify the command line? thanks


- Elmar

On 10/31/23 06:29, gnucash-user-requ...@gnucash.org wrote:

Message: 11
Date: Tue, 31 Oct 2023 11:29:42 +0100
From: Sylvain M 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Gnucash 5.4 - reports does not work
Message-ID: <76bf3109-1f86-4bd9-8b6e-68ee531b1...@free.fr>
Content-Type: text/plain; charset=UTF-8; format=flowed

Hello, I have found a workaround : launching gnucash from the terminal
with this command :

export WEBKIT_DISABLE_DMABUF_RENDERER=1; gnucash


It's ok,

Thank you for your help,

Sylvain





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reports exist but display blank?

[Elmar]

Ah, I had not seen this, thank you.  Where do I put this webkit line?  
The command in the launcher properties I use is


/usr/bin/flatpak run --branch=stable --arch=x86_64 --command=gnucash 
--file-forwarding org.gnucash.GnuCash @@ %f @@


- Elmar

On 10/6/23 21:29, David H wrote:

Elmar,

Read the other thread in the mailing list re "Reports not displaying" 
for a work around - 
https://lists.gnucash.org/pipermail/gnucash-user/2023-October/109024.html


Cheers David H.


On Sat, 7 Oct 2023 at 09:28, Elmar  wrote:

I'm running Version: 5.4 Build ID: Flathub 5.4.1 Finance::Quote:
1.58 of
GC under Linux Mint 21.2

All reports, not only my saved ones, but all of them under the
reports
tab, now display a blank window.  All the options are still set as
I had
them when I look at the report's options (accounts reported,
etc.), but
nothing is displayed.   Is this a white on white font problem, and if
so, where do I correct it?

    - Elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Reports exist but display blank?

[Elmar]

I'm running Version: 5.4 Build ID: Flathub 5.4.1 Finance::Quote: 1.58 of 
GC under Linux Mint 21.2


All reports, not only my saved ones, but all of them under the reports 
tab, now display a blank window.  All the options are still set as I had 
them when I look at the report's options (accounts reported, etc.), but 
nothing is displayed.   Is this a white on white font problem, and if 
so, where do I correct it?


- Elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Summary report - cannot use CTRL to select accounts one by one.

[Elmar]

Update - it works on my windows 10 installation though (dual boot 
system), just not the linux one.  Ideas?


On 4/27/2022 12:07 PM, Elmar wrote:
Using GC Version: 4.10 Build ID: 4.10+(2022-03-26) (flatpak on Linux 
Mint 20.3) - I am trying to select/de-select individual accounts in 
the options of the included account summary report.  I can select 
sequential accounts with shift-click, but ctrl-click no longer adds or 
removes the highlight from the selected set.  What happened? This used 
to work. - elmar

___
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] Account Summary report - cannot use CTRL to select accounts one by one.

[Elmar]

Sadly no joy here - no matter how often I click, or with what extra key 
(ctrl, shift, alt), I cannot add one account, or else everything 
deselects and that one account gets highlighted.  It's a complex 
selection, and I just recently added another account and want to update 
the report, but I can't. - Elmar


On 4/27/22 20:09, David H wrote:

Elmar,

Works on ubuntu 21.10 although it seems you have to click once and 
then click again to remove accounts from selection.  Does this help?


Cheers David H.

On Thu, 28 Apr 2022 at 09:26, Elmar  wrote:

Update - it works on my windows 10 installation though (dual boot
system), just not the linux one.  Ideas?

On 4/27/2022 12:07 PM, Elmar wrote:
> Using GC Version: 4.10 Build ID: 4.10+(2022-03-26) (flatpak on
Linux
> Mint 20.3) - I am trying to select/de-select individual accounts in
> the options of the included account summary report.  I can select
> sequential accounts with shift-click, but ctrl-click no longer
adds or
> removes the highlight from the selected set.  What happened?
This used
    > to work. - elmar
___
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.

[GNC] Account Summary report - cannot use CTRL to select accounts one by one.

[Elmar]

Using GC Version: 4.10 Build ID: 4.10+(2022-03-26) (flatpak on Linux 
Mint 20.3) - I am trying to select/de-select individual accounts in the 
options of the included account summary report.  I can select sequential 
accounts with shift-click, but ctrl-click no longer adds or removes the 
highlight from the selected set.  What happened? This used to work. - elmar

___
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] Solved - Re: Price database

[Elmar]

Thank you!  It worked!  I got DB Browser for SQLite running on Linux 
Mint, exported the GC file to sqlite3, opened in the program, and ran 
the code. I  couldn't figure out how to export the resulting table into 
csv, but simply highlighted the thing, and copy/pasted it into 
LibreOffice Calc.  Just need to copy over the column headings and it's 
what I needed done.  Again, thank you for the expertise and the help!


- Elmar

On 10/16/22 03:57, Geoff wrote:

David - good idea!

Elmar - please see updated SQL here:
https://wiki.gnucash.org/wiki/PostgreSQL-Requests_For_Direct_Database_Access#Extract_prices_and_associated_descriptions 



Thanks

Geoff
=



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] graphing the price database vs. time

[Elmar]

I am looking through the various reports and cannot see how to graph the 
price database for the various investment entries as a function of 
time.  So either I need to know how to export the price database to csv 
for import to a spreadsheet program, or I need to know how to do a line 
chart in GC for the database.  Any ideas on how to accomplish this?  
Thanks. - Elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] graphing the price database vs. time

[Elmar]

Looked at that, but it lumps them all together, i.e. I have a half dozen 
stocks under retirement accounts.  I select children and all I get is 
one line.  It won't do a multi-line plot by investment.  The stacked bar 
plot is close but not what I want. where and how is the price database 
encoded/stored in GC?


- Elmar

On 10/7/22 16:16, David Carlson wrote:
If you want prices instead of security value over time, that is easier 
to get directly from Yahoo or Google finance.


For your securities use use the assets over time reports.



On Fri, Oct 7, 2022, 12:02 PM Elmar  wrote:

I am looking through the various reports and cannot see how to
graph the
price database for the various investment entries as a function of
time.  So either I need to know how to export the price database
to csv
for import to a spreadsheet program, or I need to know how to do a
line
chart in GC for the database.  Any ideas on how to accomplish this?
Thanks. - Elmar
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Price database

[Elmar]

Asking again - is there any way to get the accumulated data copied from 
the price database into a spreadsheet?


- Elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price database

[Elmar]

Thank you, but how I have my investments labeled make sense to me, and 
not to any online databases.  I personally enter the quarterly (or 
monthly) prices that the statements give me (some of which are not 
tracked by, say, finance:quote), so conventional tools are really 
useless for me.  It's my personal GC price database I want to export as 
a whole thing (all the "investments", with all their date stamped data, 
appropriately labeled for later massaging in a spreadsheet).



- Elmar


On 10/15/22 14:19, Murugan Muruganandam wrote:
if you are looking for historical price data for analysis, you can use 
google finance function in goolge sheets to get the same, for example 
=GOOGLEFINANCE("AAPL","price",DATE(2016,1,1),today(),"DAILY") will 
give you daily rates from 2016 january




Saludos Cordiales


Murugan



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price database

[Elmar]

Thank you.  This will be a new experience for me - I have never even 
looked at SQL, much less have any facility with it.  All the included 
reports don't touch the price database itself, and I don't know how to 
create an appropriate one from the menu in GC. Off to look at the wiki 
:)  Probably tomorrow - too late today, and I have other more homely 
tasks still to do.


- Elmar

On 10/15/22 13:40, john wrote:
The easiest would be to save your book to SQLite3: File>Save As..., 
pick Sqlite3 from the drop-down at the top of the dialog, pick a file 
name and location.
Then run a query on the prices table (see 
https://wiki.gnucash.org/wiki/SQL#Prices for the schema; you may want 
to join on commodities to get the security's symbol and namespace and 
the currency's ISO-4217 code). Note that the actual price is saved in 
two fields, value_num and value_denom, that represents a fraction. 
Sqlite3 has a -csv option to output csv and a -o option to write a file.


Regards,
John Ralls



On Oct 15, 2022, at 9:39 AM, Elmar  wrote:

Asking again - is there any way to get the accumulated data copied 
from the price database into a spreadsheet?


- Elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Size of description column not shrinkable?

[Elmar]

I think this has been addressed somewhere before, but for some reason, I 
cannot shrink the size of the description column.  May I have a clue 
given?  thanks. - elmar

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Size of description column not shrinkable?

[Elmar]

Tried that - and godlings, the tab bar is huge and not shrinkable at 
all.  I'll try the font thing, because at the moment, it tries to crunch 
the last column often cutting off the "cents" of the totals, and there 
is no obvious way to specify the default widths of any column 
numerically or by double clicking on the column header to make it 
auto-magically adjust to fit all its entries.  I gather that the 
description column has a "spring" width, then, i.e. it takes whatever it 
can get?


- Elmar

On 12/17/23 16:22, David Carlson wrote:
I suppose you could also change the GnuCash layout to put the tab bar 
on the side instead of on top.




On Sun, Dec 17, 2023, 3:13 PM David Carlson 
 wrote:


The description column has a minimum width of whatever it takes to
fill the entire width of the GnuCash window after all the other
fields are in place.  If you want to reduce it to less than that,
you need to reduce the width of the entire GnuCash window or
increase the default font size on your display.



On Sun, Dec 17, 2023, 11:15 AM Elmar  wrote:

I think this has been addressed somewhere before, but for some
reason, I
cannot shrink the size of the description column.  May I have
a clue
    given?  thanks. - elmar
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] closing accounts

[Elmar]

How do you actually CLOSE but not delete an account, so that no new 
transactions can ever be posted to it, i.e. mark it as read only? GC 
keeps stuffing things automatched some way to the closed accounts.  How 
can I flag that account as unavailable?


- elmar
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] reports blank query

[Elmar]

This command works great for my flatpak GC from the terminal window 
(spews a bunch of stuff into the window first, but then launches GC fine 
with visible reports). But -  if I paste that command line into a 
launcher, it fails.  Is this a limitation of the launcher?


- Elmar

On 5/18/24 12:00, gnucash-user-requ...@gnucash.org wrote:

On 12/14/23 10:58, john wrote:
It won't be fixed in the next release because it's not something that
GnuCash can fix. As you say, the work around is to stop WebKit using the
GPU with WEBKIT_DISABLE_COMPOSITING_MODE=1 in the environment.

There's a typo in your flatpak command line that might trip up somebody
not paying close enough attention. The correct command is
  ? ? WEBKIT_DISABLE_COMPOSITING_MODE=1 flatpak run org.gnucash.GnuCash
with a space between flatpak and run.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Backups

[Elmar Schmeisser]

The hard part is backing up all the specialized reports and the online
settings, etc.  The datafile is easy; the rest is not.

On Fri, Dec 23, 2022, 12:00 PM  wrote:

>
> At Fri, 23 Dec 2022 10:34:44 +1000 Daryl Hillgrove <
> daryl.hillgr...@gmail.com> wrote:
>
> >
> > Can a simple backup function be added to gnucash?
> >
> > I am very concerned that if my computer fails I will lose all my data. I
> > want to store the backup data to external storage such as a memory stick.
> >
>
> This can be achieved by just copying the *.gnucash file to your external
> storage device.  GnuCash *already* makes backup copies of its datafile, in
> the
> directory (folder) where the datafile lives.
>
> > Thanks
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] closing accounts

[Elmar Schmeisser]

Thank you!  Perfect!

On Tue, Nov 28, 2023, 5:25 PM Murugan Muruganandam <
m.muruganan...@hotmail.com> wrote:

> mark the account as place holder, which will stop transactions to be
> entered
>
>
>
> Saludos Cordiales
>
>
> Murugan
> --
> *From:* gnucash-user  hotmail@gnucash.org> on behalf of Elmar 
> *Sent:* Tuesday, November 28, 2023 6:51 PM
> *To:* gnucash-user@gnucash.org 
> *Subject:* [GNC] closing accounts
>
> How do you actually CLOSE but not delete an account, so that no new
> transactions can ever be posted to it, i.e. mark it as read only? GC
> keeps stuffing things automatched some way to the closed accounts.  How
> can I flag that account as unavailable?
>
> - elmar
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.