Re: [GNC] GC 2.6.19 & GC 3.8

2020-03-01 Thread David Cousens
It will depend upon where your 2.6.19 version is installed to and where in
the file heirarchy the flatpak installs to. Main problem will be if the
libraries for both versions get installed to the same locations. I think
flatpaks install under~/.local/share/flatpak/exports/share/applications for
per usr  and 
under /var/lib/flatpak/exports/share/applications for sytemwide
installations. 

If 2.6.19 was installed with apt from the system repository it will likely
be under /usr/local/{bin/share/lib/etc} where the components are installed
in the appropriate directory from the set in {}.

https://wiki.gnucash.org/wiki/Flatpak may contain more info.

David



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


Re: [GNC] Transaction Import

2020-03-01 Thread Stephen M. Butler
On 3/1/20 7:32 PM, Stu Perlman wrote:
> Thank You, David.
>
> I'll have to look into what Citi allows (or not).  I don't recall seeing
> categories in their OFX feed but then again, I was not looking for them!
>
> - Stu


You have to scroll down in the download screen to see the OFX/QFX option.

>
>
> On Sun, Mar 1, 2020 at 6:21 PM David Cousens 
> wrote:
>
>> Stu,
>>
>> You can disable the Bayesian matching  with Edit->Preferences->Online
>> Banking and uncheck the use bayesian matching chceckbox. I doubt if this
>> removes existing Bayesian data from your data file but it shouldn't then
>> be
>> used in processing further imports.  You can manually delete it with th
>> Tools->Import Match Editor if you wish. I don't know whether the token
>> data
>> from imports is still accumulated with that option unchecked. I suspect
>> not,
>> but haven't actually checked the code out
>>
>> The Import Match window does allow you to review each transaction before
>> importing. While it is displayed, the transactions marked for importing are
>> also provisionally displayed in the appropriate account register which can
>> be accessed normally to examine the data in the format usually encountered
>> (wouldn't edit them in the register though as any changes will be
>> overwritten when you complete the import the data). It would be nicer if
>> these were flagged in some way as provisional to distinguish them clearly
>> from transactions already fully imported to GnuCash but it usually obvious
>> from the dates.
>>
>> In the Import Matcher editor if you look at the non-Bayesian data that
>> should give you account name mappings used in from source transaction data
>> and the GnuCash internal account they are mapped on to. There is no edit
>> capability there though. I think these are set initially when a new
>> external account is encountered in import data with no existing mapping
>> onto
>> the GnuCash internal accounts and a dialog to assign an account is brought
>> up.
>>
>> The only way AFAIK to force a particular account to be assigned as the
>> transfer account is to specify the Account name in the import data
>> explicitly and then the above mentioned mapping will take place. My bank
>> attaches expense categories to my downloaded OFX files which I can setup in
>> their web interface and they assign particular transactions to them on the
>> basis of  my initial assignments. GnuCash's Bayesian matcher recognizes
>> those categories and match them onto specific intenal accounts fairly well.
>> unfortunately not all banks either do this or do it well.
>>
>> David Cousens
>>
>> David Cousens
>>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Transaction Import

2020-03-01 Thread Stu Perlman
Thank You, David.

I'll have to look into what Citi allows (or not).  I don't recall seeing
categories in their OFX feed but then again, I was not looking for them!

- Stu


On Sun, Mar 1, 2020 at 6:21 PM David Cousens 
wrote:

> Stu,
>
> You can disable the Bayesian matching  with Edit->Preferences->Online
> Banking and uncheck the use bayesian matching chceckbox. I doubt if this
> removes existing Bayesian data from your data file but it shouldn't then
> be
> used in processing further imports.  You can manually delete it with th
> Tools->Import Match Editor if you wish. I don't know whether the token
> data
> from imports is still accumulated with that option unchecked. I suspect
> not,
> but haven't actually checked the code out
>
> The Import Match window does allow you to review each transaction before
> importing. While it is displayed, the transactions marked for importing are
> also provisionally displayed in the appropriate account register which can
> be accessed normally to examine the data in the format usually encountered
> (wouldn't edit them in the register though as any changes will be
> overwritten when you complete the import the data). It would be nicer if
> these were flagged in some way as provisional to distinguish them clearly
> from transactions already fully imported to GnuCash but it usually obvious
> from the dates.
>
> In the Import Matcher editor if you look at the non-Bayesian data that
> should give you account name mappings used in from source transaction data
> and the GnuCash internal account they are mapped on to. There is no edit
> capability there though. I think these are set initially when a new
> external account is encountered in import data with no existing mapping
> onto
> the GnuCash internal accounts and a dialog to assign an account is brought
> up.
>
> The only way AFAIK to force a particular account to be assigned as the
> transfer account is to specify the Account name in the import data
> explicitly and then the above mentioned mapping will take place. My bank
> attaches expense categories to my downloaded OFX files which I can setup in
> their web interface and they assign particular transactions to them on the
> basis of  my initial assignments. GnuCash's Bayesian matcher recognizes
> those categories and match them onto specific intenal accounts fairly well.
> unfortunately not all banks either do this or do it well.
>
> David Cousens
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-03-01 Thread David Cousens
Ken,

If you are up to it you can always build the latest version from sources.
There are fairly detailed instructions on the GnuCash Wiki page
(https://wiki.gnucash.org/wiki/Building_On_Linux). They are not Debian
specific (mainly from builds on Linux Mint 17/18/19) but should be adapted
fairly easily (usually just a replacement with the Debian command name if
and where it is different.)

David Cousens



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


Re: [GNC] What type of Data should i use to import from GnuCash Android to Desktop ?

2020-03-01 Thread David Cousens
CSV is comma separated variables. The data is arranged in a series of
columns/fields with or without an initial header line specifying the column
name/content. A newline character terminates a line of columns. Blank fields
are indicated by successive commas. Other characters than a comma can be
used as the field separator.  It is a general non- specifiic format commonly
used in data fields. names in the  initial header line generally have to be
mapped to specific transaction data fields during import.

QIF is a proprietary format used by Intuit in some of its products for
financial/accounting data. As it is generated usually by an accounting
product it generally specifies bth accounts a transaction addresses. Not
familiar enough  with it to know  whether it handles true multisplit data
for more than 2 splits.

There are more complete descriptions of the file formats on Wikipedia and in
QIF usually to a specification.

David Cousens




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


Re: [GNC] Transaction Import

2020-03-01 Thread David Cousens
Stu,

You can disable the Bayesian matching  with Edit->Preferences->Online
Banking and uncheck the use bayesian matching chceckbox. I doubt if this
removes existing Bayesian data from your data file but it shouldn't then  be
used in processing further imports.  You can manually delete it with th
Tools->Import Match Editor if you wish. I don't know whether the token  data
from imports is still accumulated with that option unchecked. I suspect not,
but haven't actually checked the code out

The Import Match window does allow you to review each transaction before
importing. While it is displayed, the transactions marked for importing are
also provisionally displayed in the appropriate account register which can
be accessed normally to examine the data in the format usually encountered
(wouldn't edit them in the register though as any changes will be
overwritten when you complete the import the data). It would be nicer if
these were flagged in some way as provisional to distinguish them clearly
from transactions already fully imported to GnuCash but it usually obvious
from the dates.

In the Import Matcher editor if you look at the non-Bayesian data that
should give you account name mappings used in from source transaction data
and the GnuCash internal account they are mapped on to. There is no edit
capability there though. I think these are set initially when a new 
external account is encountered in import data with no existing mapping onto
the GnuCash internal accounts and a dialog to assign an account is brought
up.

The only way AFAIK to force a particular account to be assigned as the
transfer account is to specify the Account name in the import data
explicitly and then the above mentioned mapping will take place. My bank
attaches expense categories to my downloaded OFX files which I can setup in
their web interface and they assign particular transactions to them on the
basis of  my initial assignments. GnuCash's Bayesian matcher recognizes
those categories and match them onto specific intenal accounts fairly well.
unfortunately not all banks either do this or do it well.

David Cousens

David Cousens



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


Re: [GNC] Investment Portfolio Reporting

2020-03-01 Thread David Carlson
You won't get much out of GnuCash unless you had it collecting security
prices at the appropriate times to use in your desired reports.  If you
did, try the assets over time reports.  There may be some better reports in
the 3.x family of releases.

Otherwise, third party software or spreadsheets or a combination will work
better.

David Carlson


On Sun, Mar 1, 2020, 10:53 AM rsbrux via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I need some reports which show the performance of various investment
> accounts over the past year.  I don't find anything suitable in GC
> 2.6.19 and don't have the chops (neither in accounting nor in guile) to
> write my own.  Surely I am not the first GC user with this need.  The
> only thing I found which looks useful is gnucash-portfolio:
>
> http://portfolio.alensiljak.tk/
>
> https://github.com/MisterY/gnucash-portfolio
>
> However, as ignorant as I am about Python, I am not even sure how to
> install it.  Furthermore, it appears to require the GC DB stored in
> SQLite, whereas mine is still in (compressed) XML.
>
> Does anyone have experience with gnucash-portfolio?
>
> What other approach could I use?
>
> ___
> 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] GC 2.6.19 & GC 3.8

2020-03-01 Thread Les
I have just installed GC 3.8 via Flatpak and used my 2.6 version to 
start it but saved the file to a different location.


Is it possible to run both versions at the same time?

Using Linux Mint 19.1

Thank,

Les

___
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] Transactions association to accounts (automatically)

2020-03-01 Thread David Cousens
Stelvio,

Allowing transactions to be imported assigned to the Imbalnce account results 
in the import matcher not being trained to
match the correct account. It is better to assign the account and correct any 
account assignments GnuCash has made in
the Import Match window before importing , not in GnuCash after importing for 
this reason.. The A, U and R checkboxes
control and indicate whether a transaction is to be added, or cant be assigned 
with certainty or has been matched with
an existing transaction. The green backgound colours generally indicate  that a 
transaction is OK (either matches an
existing transaction or is to be imported and a transfer account has been 
assigned, the yellow gold normally indicates
that it is to be imported but an transfer account hasn't or can't be assigned 
and you should assign an account before
importing. The red backgound generally indicates a problem with matching two or 
more transactions already in GnuCash.
Red or Yellowgold mean you definitely have to intervene. Green are  generally 
OK. If the R is checked it means they
won't be important - the matcher can get it wrong so these need to be checked 
carefully. If A is checked with a green
background it will be imported to the account specified.  Evrytime you import 
to an incorrect account or to the
Imbalance account the matcher is being mistrained and incorrect data (as far as 
your desired assignment) is being stored
and will bias future decisions by GnuCash.

David  Cousens


On Sun, 2020-03-01 at 15:34 -0600, Stelvio Rosset wrote:
> David, thanks.
> 
> I imported already 26 months transactions, so I think there should be
> already some learning by gnu-cash, on the other hand I never enjoyed this
> add-in.
> 
> The way I am doing is to import all the transactions (import transactions
> from CSV), with well identified: date, description, transfer account,
> withdrawal, and note;
> 
> Gnu-cash needs I specify the account, then I specify from the drop-down list
> as  Imbalance-EUR; in that way I will find all my transactions in the
> account Imbalance-EUR, and start then the association manually.
> 
> Following this procedure I have not enjoy the auto-association of the
> account.
> 
> Note: based on how I am acting, I was then asking the possibility of the
> auto-allocation after I have imported them into the Imbalance-EUR.
> 
> Should I maybe follow a different path than the one described above?
> 
> Thanks for help
> Stelvio
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
-- 
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed

___
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] Transaction Import

2020-03-01 Thread Stu Perlman
I would like to have GnuCash import all of my transactions using a default
transfer account without having to look for mismatches in the Import
Matcher.  It's easier for me to just bring everything in with the transfer
account going to a single holding account that I use as a queue to show me
transactions that need review. This allows me to come back to them after
completing the import without losing track of them.

I appreciate the capabilities of the Bayesian matching but for me, I'd
rather personally review each new transaction.  I can get what I want by
manually changing the destination account for each import, but I was
wondering if there was a way to have imports always go to account X on the
transfer side?

Thanks in advance for your help.
___
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] Transactions association to accounts (automatically)

2020-03-01 Thread Barufa
Hi Stelvio,

If you are importing single splits, you can generate one CSV by account, for
instance, Credit Card.
You'd match the CSV importer to Date, Withdrawal, Memo and Account
Description. On the drop-down, select your Credit Card account (all postings
are going to be made on this account and the corresponding one is taken from
the CSV).

The first time GNC will ask your help to link the Account Description to
your Chart of Accounts. From the second time onward, it'll match them
automatically and you won't have to deal with a bunch of postings to
Imbalance-EUR.

EXAMPLE OF CSV

Date,Withdrawal,Description,Account Description
01/02/2020,12.47,PAYPAL*UBER,Expenses:Uber
02/02/2020,89.69,Walmart,Expenses:Groceries
03/02/2020,109.97,OliveGarden,Expenses:Eating Outside
05/02/2020,24.9,NETFLIX.COM,Expenses:Streaming Netflix
07/02/2020,60,Amazon.com,Expenses:Amazon



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


Re: [GNC] import map editor takes a VERY long time to open

2020-03-01 Thread david whiting
Thanks. I do have a lot of transactions that have a unique reference.

I have one core (of eight) that is running at 100% processing this. It has
now been running for 3 and half hours and the trace file is 557 Mb and
growing...

David

On Sun, 1 Mar 2020 at 21:33, David Cousens  wrote:

> David,
>
> I have a 16.8 Mbyte uncompresseddata file which takes 3-4 sec at most to
> load at startup in V3.8 on Linux Mint 19.3 (Ubuntu 18.04). The Import Map
> Editor comes up almost immediately on selecting it from the menu. I
> possibly
> have fewer accounts than you have and have roughly half the transactions
> and
> splits.
>
> If you have a transaction source (or several of them) which uses a unique
> number each time in the transaction description you can get a lot of import
> matching data being stored with very low frequency of occurrence that
> effectively does little to help with matching. I have 6-8 transactions a
> month which regularly can't be matched because of this. Government
> departments/ pensionfunds  are becoming specialists at tagging UUIDs onto
> things. This of course has to be imported and sorted through during import
> and matching which is probably why you want to use the Import match Editor.
> Unfortunately as the match data is stored in the data file there is no
> simple way to remove it and start again with retraining. I have't yet taken
> the time out to prune the matching data but the ability to do this is
> obviously there for when there is a problem.
>
> If you upload the whole tracefile Geert or John may be able to spot
> something in it but if the excerpt is typical it would appear to be
> buidling
> up the tables of information that the import match editor uses. There may
> be
> nothing for it but to allow it to run to completion. You may ned to turn
> off
> any power saving measures in Ubuntu which automatically hibernate or
> suspend
> the system to allow this to occur.
>
> Linux has a sometimes annoying indexing process which seems to grab a lot
> of
> CPU time and runs with a high priority and can stop other programs from
> operating by denial of service until it is complete (has been several hours
> on a few occasions). This is usually accompanied by a lot of disk access.
> There are fixes on the various  Linux forums if this is the problem.
>
> I seem to remember there may be a bug or feature request around possibly
> parsing such numbers where there is a fixed component which would identify
> a
> specific account and a random component but this is not going to be easy
> unless there is a separator of some sort. I don't know if anyone has looked
> at this yet.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Whiting
___
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] Transactions association to accounts (automatically)

2020-03-01 Thread Stelvio Rosset
David, thanks.

I imported already 26 months transactions, so I think there should be
already some learning by gnu-cash, on the other hand I never enjoyed this
add-in.

The way I am doing is to import all the transactions (import transactions
from CSV), with well identified: date, description, transfer account,
withdrawal, and note;

Gnu-cash needs I specify the account, then I specify from the drop-down list
as  Imbalance-EUR; in that way I will find all my transactions in the
account Imbalance-EUR, and start then the association manually.

Following this procedure I have not enjoy the auto-association of the
account.

Note: based on how I am acting, I was then asking the possibility of the
auto-allocation after I have imported them into the Imbalance-EUR.

Should I maybe follow a different path than the one described above?

Thanks for help
Stelvio



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


Re: [GNC] import map editor takes a VERY long time to open

2020-03-01 Thread David Cousens
David,

I have a 16.8 Mbyte uncompresseddata file which takes 3-4 sec at most to
load at startup in V3.8 on Linux Mint 19.3 (Ubuntu 18.04). The Import Map
Editor comes up almost immediately on selecting it from the menu. I possibly
have fewer accounts than you have and have roughly half the transactions and
splits. 

If you have a transaction source (or several of them) which uses a unique
number each time in the transaction description you can get a lot of import
matching data being stored with very low frequency of occurrence that
effectively does little to help with matching. I have 6-8 transactions a
month which regularly can't be matched because of this. Government
departments/ pensionfunds  are becoming specialists at tagging UUIDs onto
things. This of course has to be imported and sorted through during import
and matching which is probably why you want to use the Import match Editor.
Unfortunately as the match data is stored in the data file there is no
simple way to remove it and start again with retraining. I have't yet taken
the time out to prune the matching data but the ability to do this is
obviously there for when there is a problem.

If you upload the whole tracefile Geert or John may be able to spot
something in it but if the excerpt is typical it would appear to be buidling
up the tables of information that the import match editor uses. There may be
nothing for it but to allow it to run to completion. You may ned to turn off
any power saving measures in Ubuntu which automatically hibernate or suspend
the system to allow this to occur. 

Linux has a sometimes annoying indexing process which seems to grab a lot of
CPU time and runs with a high priority and can stop other programs from
operating by denial of service until it is complete (has been several hours
on a few occasions). This is usually accompanied by a lot of disk access.
There are fixes on the various  Linux forums if this is the problem.

I seem to remember there may be a bug or feature request around possibly
parsing such numbers where there is a fixed component which would identify a
specific account and a random component but this is not going to be easy
unless there is a separator of some sort. I don't know if anyone has looked
at this yet.

David Cousens



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


[GNC] What type of Data should i use to import from GnuCash Android to Desktop ?

2020-03-01 Thread Long
Hello,

I'm new to GnuCash, i really have a lot of questions to ask, and most of
them are maybe basic for you. Sorry if i post too much.

What difference between "CSV" and "QIF" files ?
is "QIF" files easier to import more than "CSV" ? Because, when i importing
with CSV files, i need to choose Account hierarchy again before i can press
"Next" Button, it's annoying.

Thank you so much for spent your time to help me.
Regards.



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


Re: [GNC] Transactions association to accounts (automatically)

2020-03-01 Thread David Cousens
Stelvio,

The import matching process is used by most of the import methods including
CSV. 

The problem when you start out is that it can't initially know which
specific accounts you wish to allocate transactions to, but it accumulates
information as you import data that allows GnuCash to automatically suggest
the correct account based on past import choices. It uses either an older
mapping approach or a Bayesian probability methodology to assign the
accounts based primarily on information in the Description anda few other
fields in the import record. 

Edit-> Preferences->Online Banking will display the preference settings for
the matcher which is also used on data downloaded live from banks using
aqbanking.  AFAIK the "Use bayesian matching" is selected by default but if
it isn't make sure it is checkeded. It is probably not advisable to change
any of the other default  selections until you are more familiar with
importing data.

It also searches through existing transactions within a time window about
the import date (~6 weeks) and identifies transactions for which the
imported data might be duplicates and then tries to match a transfer account
if this is not specified explicitly specified in the import record (it can
be). 

You can manually override any of the automatic duplicate matches and account
assignments in the Import Matcher window. When GnuCash first starts out it
also constructs a mapping of external Account Names in imported data to the
internal GnuCash names which correspond to them. If an account name is
specified for the first time in import data you will get a dialog asking you
to match it to an Account in the account heirarchy you have setup in
GnuCash. Once you have done that GnuCash will remember the association.

The import training only takes place from data as it is imported and does
not use any transaction information already in Gnucash. This is important
because the import matching data is stored in the last stage of the import
process and if you don't complete an import GnuCash won't accumulate data
from that import on which these automatic processes are based. It is also
necessary to make sure any duplicates identified are actually duplicates -
the matcher will sometimes get it wrong and to make sure the correct
transfer accounts have been assigned manually before importing otherwise the
matching process does not get trained.

See https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html for
more info.  There is updated documentation on the way on this as well but my
progress on this lately has been limited by health and other issues.

if you are using one of the v3.x GnuCash version, the CSV import is vastly
improved particularly in the setup of options for the import of data with
the ability to store and recall setups for specific data sources. If you
experiment with this you should be able to minimize or eliminate any
preprocessing in Excel before importing  data. Another possibility is to
setup and use macros in Excel or LibreOffice to preprocess your data
automatically and prepare it for import.

David Cousens



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


[GNC] import map editor takes a VERY long time to open

2020-03-01 Thread david whiting
Hi,

[Resending as I sent it from the wrong email address the first time]

OS: Ubuntu 19.10
Machine: 8 cores (but only one used by gnucash, I think). 32 Gb memory.
Gnucash: 3.7 and 3.8 maint (built this afternoon)
Backend: XML, uncompressed. 24 Mb

I would like to use the import map editor but it seems to take a very long
time to open, in fact so long that I haven't managed to open it yet. I have
given it an hour and then killed gnucash. I'm now running it with --debug
--trace and after an hour the trace file is 149 Mb and growing.

For a long while now the trace file has been filling up with entries as
shown below [1].

My gnucash data file is 24 Mb uncompressed. I have over 1,000 accounts, not
sure how many transactions or splits, but perhaps this gives a reasonable
idea:

$ grep "gnc:transaction version" BYFC3.gnucash | wc -l
15427
$ grep "" BYFC3.gnucash | wc -l
32704

Is it normal that it takes this long?

Thanks.

David



[1] /tmp/gnucash.trace
* 18:49:19  INFO  [qof_event_generate_internal] id=1
hi=0x55c552cc3a30 han=0x7f24b5c96510 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=19
hi=0x55c55a2ef4c0 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=18
hi=0x55c55a19d090 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=17
hi=0x55c5585b1050 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=16
hi=0x55c55987fe90 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=15
hi=0x55c558f13c70 han=0x7f24b5bf1810 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=14
hi=0x55c558f13c20 han=0x7f24b5c52c40 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=13
hi=0x55c558dad490 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=12
hi=0x55c558bf9a60 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=11
hi=0x55c5560d78c0 han=0x7f24b5bf8460 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=10
hi=0x55c558aacbb0 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=9
hi=0x55c55867c960 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=8
hi=0x55c55850ffe0 han=0x7f24b69961a0 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=7
hi=0x55c556552e70 han=0x7f24b5c52c40 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=6
hi=0x55c554b91610 han=0x7f24b5caf760 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=5
hi=0x55c555f85da0 han=0x7f24b5ae7830 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=4
hi=0x55caa670 han=0x7f24b5ad5790 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=3
hi=0x55c5544042a0 han=0x7f24b696d030 data=(nil)
* 18:49:19  INFO  [qof_event_generate_internal] id=2
hi=0x55c552b56d30 han=0x7f24b5bf1340 data=(nil)
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c566329080 count=50
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c566c0ad60 count=650
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c565b24e60 count=19
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c565b5cca0 count=54
* 18:49:19  INFO  [qof_object_foreach] type=gncEntry
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
gncEntry before is 1027
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
gncEntry after is 1027
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c566cc2b40 count=2
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching
objects=0x55c5665d8a40 count=47
* 18:49:19  INFO  [qof_object_foreach] type=Split
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split before is 32713
* 18:49:19  INFO  [qof_collection_foreach] Hash Table size of
Split after is 32713
* 18:49:19  INFO  [qof_query_run_internal] matching

Re: [GNC] Transactions association to accounts (automatically)

2020-03-01 Thread Stelvio Rosset
Hi, thanks. I am using CSV to import/export, and that case I am not able to
use that functionality.

With many banks in EU the direct connections in not available/possible, I
guess  a number of us then are just importing in the same "old style" I am
using.

Any other suggestion in case? Example, excel 2 OFX, then importing in
gnu-cash enjoying the AI functionality?

Stelvio




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


Re: [GNC] Transactions association to accounts (automatically)

2020-03-01 Thread Barufa
Hi,

This "AI style" import process is already available via OFX/QFX method.

At first, you'll have to manually select the corresponding account for every
entry.
However, as you feed more data on the system, it'll start to learn the
patterns. Probably further down the road all you'll have to do is basically
validate what it populates and a few corrections.

Note to backup your data before trying new import methods. This way, if
anything goes wrong, you can just revert back.



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


Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-03-01 Thread Andrea Borgia

Il 01/03/20 16:39, km22 ha scritto:


I recently moved from Windows 7 (due to end of life) to Debian 10.  I
have gnucash 3.4 installed from the standard repo.  However I think this
version contains a bug as I cannot see any of the historical FX prices I
stored in the Price Database. I think I need to move to a more recent
version.  I saw this wiki article: https://wiki.gnucash.org/wiki/Debian
but no clues there on how to install the latest version 3.8.  Can anyone
here advise?


Hi, Ken.

If you're comfortable with using the "testing" distribution, then GC 3.8 
is already included, I am using it now.


If you prefer to continue using the "stable" distribution of Debian, 
then you could try the "flatpak" version of GC, available here:

https://flathub.org/apps/details/org.gnucash.GnuCash

How to use Flatpak on Debian:
https://flatpak.org/setup/Debian/


Regards,
Andrea.
___
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] AppleCard OFX file

2020-03-01 Thread David Reiser via gnucash-user
On Mar 1, 2020, at 12:46 PM, Keith Bellairs  wrote:
> 
> Apple has added ability to export Apple credit card transactions in ofx
> format. When I tried to import their ofx file, ended up with an empty
> transaction matching window in gnucash. I think Apple's sgml ofx data is
> buggy. There is no closing tag   in the header info. I edited
> the ofx and added the tag. After that the gnucash import worked correctly
> in GNC 3.7 on my Mac.
> 
> The corrected set of tags looks like this:
> 
> Apple Card
> 
> 
> So that worked this month.
> 
> Keith


That’s good to know. But notice that the ACCTID isn’t particularly unique. 
Since Apple/GS don’t allow joint accounts, my wife and I both have accounts. 
But both sets of ofx groups have the same ACCTID, meaning I’d have to 
edit/script modify one or both accounts each month before importing the data.

Ofx’s biggest advantage — FITID tags to easily identify duplicates — is 
rendered unimportant by another of Apple’s inflexibilities. Since you can only 
export a whole month at a time and always get the same transactions for a whole 
month, there’s never a chance of getting anything other than 0% or 100% 
duplicates.

Under the current system, I’ve found it easier to import the csv transaction 
data. I have one settings file for my data, and one for my wife’s. And I easily 
end up in the same transaction matcher in nearly the same time as for a 
well-formed ofx file.

Dave
--
Dave Reiser
dbrei...@icloud.com



___
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] AppleCard OFX file

2020-03-01 Thread Keith Bellairs
Apple has added ability to export Apple credit card transactions in ofx
format. When I tried to import their ofx file, ended up with an empty
transaction matching window in gnucash. I think Apple's sgml ofx data is
buggy. There is no closing tag   in the header info. I edited
the ofx and added the tag. After that the gnucash import worked correctly
in GNC 3.7 on my Mac.

The corrected set of tags looks like this:
 
 Apple Card
 

So that worked this month.

Keith
___
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 Income & Expense (Graph)

2020-03-01 Thread Stelvio Rosset
Hi, question on the Income & Expense Graph Report.

Along the period selected, the report is able to show punctual value of the
expenses level, income, and eventually the punctual net value.

There is any setting allowing to show also the cumulative net value created
in the period?

Punctual net (example monthly) could be up or down along a period of time,
but it would be nice to see at a glance if the cumulative result is going to
the positive or negative side.

Thanks for help
Stelvio




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


[GNC] Transactions association to accounts (automatically)

2020-03-01 Thread Stelvio Rosset
Hi all, (first post for me)

currently I am using GnuCash with the following practice:

1) download the transaction files from the bank / credit card providers;
2) re-formatting each of those via excel;
3) consolidate in excel all the transactions with a simple table form
compatible with gnucash CSV import;
4) link each transaction to the source / destination account with names and
syntax compatible with gnucash structure;
5) finally imports the transactions (monthly) into gnucash via CSV;

It works, but... the process is taking time.

It would be great if would be possible to think to a development where for
each transaction (during the import or even after the import) I could "push
a button" and gnucash would suggest the best fit of the destination account
(or a list of those) where the transaction should be associated with (most
of the case the need is on Expenses).

The suggestion could be created based on the descriptions / key-works / or
other AI, eventually supported also by external files where users can
specify the key-works to be used.

I have seen this discussion in some treads, but actually I have not see the
request (and eventually acceptance) to develop such functionality. 

If this intelligence is already provided by gnu-cash, apologize for the
post, and please help me to find the way, otherwise how sounds the idea to
propose this development path?

Thanks
Stelvio




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


[GNC] Investment Portfolio Reporting

2020-03-01 Thread rsbrux via gnucash-user
I need some reports which show the performance of various investment 
accounts over the past year.  I don't find anything suitable in GC 
2.6.19 and don't have the chops (neither in accounting nor in guile) to 
write my own.  Surely I am not the first GC user with this need.  The 
only thing I found which looks useful is gnucash-portfolio:


http://portfolio.alensiljak.tk/

https://github.com/MisterY/gnucash-portfolio

However, as ignorant as I am about Python, I am not even sure how to 
install it.  Furthermore, it appears to require the GC DB stored in 
SQLite, whereas mine is still in (compressed) XML.


Does anyone have experience with gnucash-portfolio?

What other approach could I use?

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


[GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-03-01 Thread km22

Hi,

I recently moved from Windows 7 (due to end of life) to Debian 10.  I
have gnucash 3.4 installed from the standard repo.  However I think this
version contains a bug as I cannot see any of the historical FX prices I
stored in the Price Database. I think I need to move to a more recent
version.  I saw this wiki article: https://wiki.gnucash.org/wiki/Debian
but no clues there on how to install the latest version 3.8.  Can anyone
here advise?

Thanks,
Ken


___
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] Bug while trying to select date (01/01/2019) - immediately changes to 12/31/1969

2020-03-01 Thread Michael or Penny Novack

On 3/1/2020 1:50 AM, Barufa wrote:

I would appreciate your help with a date selecting bug. Don't know if I
changed something in the Preferences menu or somewhere else, but I'm not
able to select date 01/01/2019.
When I type that date or select it in the calendar, as soon as I move the
cursor somewhere else it reverts to 12/31/1969.


For those who don't know this, "12/31/1969" if a special date, time zero 
for computers. So whenever it shows up where some other date is 
expected, the bug/problem is "no date".


Michael D Novack

___
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] Bug while trying to select date (01/01/2019) - immediately changes to 12/31/1969

2020-03-01 Thread Colin Law
On Sun, 1 Mar 2020 at 12:25, Barufa  wrote:
>
> I'm using 3.8b+ (2019-12-29) running on Windows 10.

Not the old bug then, unless it has crept back in.

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] Bug while trying to select date (01/01/2019) - immediately changes to 12/31/1969

2020-03-01 Thread Barufa
Hi Colin,

I'm using 3.8b+ (2019-12-29) running on Windows 10.



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


Re: [GNC] Fastest ways to enter my transactions into GnuCash ?

2020-03-01 Thread Maf. King
Adrian meant that sometimes he gets ; by mistake  - then the quick selection 
goes all wrong.

there is a preference to set the separator.

HTH,
Maf.



On Sunday, 1 March 2020 09:29:35 GMT Long wrote:
> Using " ; " instead " : " to enter transfer account is not working on
> GnuCash 3.8, Maybe you are using the older version of GnuCash.
> 
> That Tips Can Not used anymore.
> Regards.
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
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 doesn't show negative number as red ! Possible to Edit Report CSS ?

2020-03-01 Thread Long
Hello,

- Income Statement (Multicolumn) Doesn't Show Negative Number as Red (Total
Net Income). Is it a bug ?
Picture :  Income_Statement_(Multicolumn).png

  

- Possible to Edit CSS for Report ?
In that Picture, i have AUTO and it sub-accounts, can i border (CSS) all the
Accounts that have Sub-accounts ? To easier to check the report !
For Default of GnuCash report, its Report look very hard to check. Its
design very bad.
I'm not a Coder, But i watched HTML code after export that Report, And saw
that, Code very bad too. Because For All Accounts, it's used the same
"Class" code.
Example : 
1 -  1.png   
2 -  2.png   

So that is a problem, i can't specific the Parent Accounts to have a color
... etc

Generally, I want to have a better look of GnuCash report. And Is it a bug
when Total Doesn't show the value as red when it's negative value ?

Sorry for my bad english and Thank for helping me.
Regards.



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


Re: [GNC] Fastest ways to enter my transactions into GnuCash ?

2020-03-01 Thread Long
Using " ; " instead " : " to enter transfer account is not working on GnuCash
3.8, Maybe you are using the older version of GnuCash.

That Tips Can Not used anymore.
Regards.



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