Re: [GNC] file storage location

[Michael or Penny Novack]

On 6/15/2020 11:07 AM, Jamie Tolbert wrote:
new user here, seems like all the files are in my document storage 
folder, I'd like to move them to their own separate folder, is that 
possible? 



In a way, that you say you have this problem, implies that you are not 
yet comfortable with using your OS. In other words, ignore for a moment 
that you are asking about your gnucash data. How about all your 
documents? Do you just have them all in a "heap" in your documents 
folder? How do you find them? Assuming you have documents of six basic 
types (plus miscellaneous ones) have you not created seven sub folders 
within the documents folder for them to be in?. Then when looking for a 
document of type X you look for it in the Xdocuments folder.  I just 
took a look, and in our case, 47 at the top level, with many of these 
having sub folders under them.


The point I am making is the fact that upon becoming a gnucash user you 
did not immediately create a sub folder for gnucash data is a SYMPTOM of 
the more general problem.


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] GnuCash 3.905 Released

[w...@theprescotts.com]

I am currently running 3.10-1 on MacOS. I am unclear how this relates to 3.905. 
Can someone clarify this for me.

Thanks,
Will 

On 2020 Jun 14, at 06-14 18:19:31, John Ralls  wrote:

The GnuCash development team announces GnuCash 3.905, the fourth testing 
release for what will soon be GnuCash 4.0.

Changes

Baseline requirements

Operating Systems:

• Linux: Ubuntu 18.04LTS
• MacOS: 10.13
• Windows: 8.1
Software Dependencies:

• C++ standard is now C++17, requires gcc 8.0 or clang 6.0.
• Cmake 3.10
• boost 1.67.0
• gettext 0.19.6 for general use, 0.20 to generate gnucash.pot.
• glib-2.0 2.56.1, gtk 3.22.30
• googletest 1.8.0
• ICU, any version.
• libdbi 0.8.3
• libxml2 2.9.4
• swig 3.0.12 Now required for building from tarballs as well as from 
git.
• Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD
New Features

The intent is to have command categories with subcommands to better enable a 
richer command line capability as illustrated with the new report commands list 
and show.

• A new separate executable, gnucash-cli (gnucash-cli.exe on Microsoft 
Windows) for doing command-line things like updating the prices in your book. 
gnucash-cli gains the ability to run reports from the command line. Specify 
reports to run by name or guid. It also provides an export format and an output 
file name without which it will output the report to stdout.
• gnucash-cli --report run --name=[reportname/guid] 
datafile.gnucash
• gnucash-cli --report run --name=[reportname/guid] 
--output-file=x.html datafile.gnucash
• gnucash-cli --report run --name=[reportname/guid] 
--output-file=x.html --export-type=TYPE datafile.gnucash
The GUI command, gnucash responds to the same command line arguments. In order 
to provide more options its syntax (and gnucash-cli's) for quote retrieval is 
changed from --add-quotes to --quotes get.

• When deleting accounts the destination accounts of moved splits will 
be checked to ensure that they have the same commodity as the source account. 
If they don't you'll get a warning and the opportunity to pick another account 
or to carry on regardless.
• New type-ahead search added to sequential search when selecting an 
account in the register: Instead of typing the first few characters of a top 
level account, the separator, the first few characters of the next level 
account and so on you may instead type a few characters of any part of a full 
account name and the drop-list will be filtered to contain only matching 
accounts. Once you have a small enough list you can use the arrow keys to 
select the account that you want.
• Python bindings are now localized and their strings available for 
translation.
• The new reports introduced in the Experimental Reports menu are moved 
to the main menu and the old reports hidden; the old reports can be unhidden by 
running GnuCash from the commandline with the --extra argument. That will cause 
the old reports to appear in their regular locations on the menu labeled 
(legacy). Note that new reports use different options and layouts and you may 
need to adjust your saved report configurations.
• A new Transaction Association dialog, available from the new Update 
Transaction Association item in the register context menu, provides the ability 
to have multiple associations for a single transaction. Associations may now be 
easily removed.
• Allow Associations to be added to invoices. The actual association 
when present is added as a link button which is shown below the notes.
• A symbol is now displayed on transactions in the register when they 
have an attachment and the selected font supports the symbol.
• The OFX file importer can now import more than one file at a time.
• A new report menu supbmenu Multicolumn contains the old 
custom-multicolumn report and a new Dashboard report containing Account reports 
for expenses and income, an income-expense chart, and an account summary.
• When importing, the matcher will no longer offer to match a 
transaction to one that has already matched in a previous import, nor will it 
offer to match more than one imported transaction to a single existing 
transaction.
• Support for UK VAT and Australian GST added to the Income-GST report. 
The reports options are changed from source accounts to source sales and 
purchase accounts to permit proper reporting of capital purchases. N.B. This is 
incompatible with previous versions of the report and will require regenerating 
saved configurations.
• Add option to save Layout for Business items
Add two menu items under windows, one to save an existing layout for Invoices, 
Bills and Vouchers to their respective default layouts so the user set column 
widths will be used. The second menu item will reset the column wid

Re: [GNC] GnuCash 3.905 Released

[David Carlson]

Will, stay with 3.10-1.  3.905 is an experimental beta release.  The
numbering sounds odd, but release 4.0 will follow after the beta has had
enough experience.

On Mon, Jun 15, 2020 at 11:05 AM w...@theprescotts.com <
w...@theprescotts.com> wrote:

> I am currently running 3.10-1 on MacOS. I am unclear how this relates to
> 3.905. Can someone clarify this for me.
>
> Thanks,
> Will
>
> On 2020 Jun 14, at 06-14 18:19:31, John Ralls  wrote:
>
> The GnuCash development team announces GnuCash 3.905, the fourth testing
> release for what will soon be GnuCash 4.0.
>
> Changes
>
> Baseline requirements
>
> Operating Systems:
>
> • Linux: Ubuntu 18.04LTS
> • MacOS: 10.13
> • Windows: 8.1
> Software Dependencies:
>
> • C++ standard is now C++17, requires gcc 8.0 or clang 6.0.
> • Cmake 3.10
> • boost 1.67.0
> • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot.
> • glib-2.0 2.56.1, gtk 3.22.30
> • googletest 1.8.0
> • ICU, any version.
> • libdbi 0.8.3
> • libxml2 2.9.4
> • swig 3.0.12 Now required for building from tarballs as well as
> from git.
> • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD
> New Features
>
> The intent is to have command categories with subcommands to better enable
> a richer command line capability as illustrated with the new report
> commands list and show.
>
> • A new separate executable, gnucash-cli (gnucash-cli.exe on
> Microsoft Windows) for doing command-line things like updating the prices
> in your book. gnucash-cli gains the ability to run reports from the command
> line. Specify reports to run by name or guid. It also provides an export
> format and an output file name without which it will output the report to
> stdout.
> • gnucash-cli --report run --name=[reportname/guid]
> datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html --export-type=TYPE datafile.gnucash
> The GUI command, gnucash responds to the same command line arguments. In
> order to provide more options its syntax (and gnucash-cli's) for quote
> retrieval is changed from --add-quotes to --quotes get.
>
> • When deleting accounts the destination accounts of moved splits
> will be checked to ensure that they have the same commodity as the source
> account. If they don't you'll get a warning and the opportunity to pick
> another account or to carry on regardless.
> • New type-ahead search added to sequential search when selecting
> an account in the register: Instead of typing the first few characters of a
> top level account, the separator, the first few characters of the next
> level account and so on you may instead type a few characters of any part
> of a full account name and the drop-list will be filtered to contain only
> matching accounts. Once you have a small enough list you can use the arrow
> keys to select the account that you want.
> • Python bindings are now localized and their strings available
> for translation.
> • The new reports introduced in the Experimental Reports menu are
> moved to the main menu and the old reports hidden; the old reports can be
> unhidden by running GnuCash from the commandline with the --extra argument.
> That will cause the old reports to appear in their regular locations on the
> menu labeled (legacy). Note that new reports use different options and
> layouts and you may need to adjust your saved report configurations.
> • A new Transaction Association dialog, available from the new
> Update Transaction Association item in the register context menu, provides
> the ability to have multiple associations for a single transaction.
> Associations may now be easily removed.
> • Allow Associations to be added to invoices. The actual
> association when present is added as a link button which is shown below the
> notes.
> • A symbol is now displayed on transactions in the register when
> they have an attachment and the selected font supports the symbol.
> • The OFX file importer can now import more than one file at a
> time.
> • A new report menu supbmenu Multicolumn contains the old
> custom-multicolumn report and a new Dashboard report containing Account
> reports for expenses and income, an income-expense chart, and an account
> summary.
> • When importing, the matcher will no longer offer to match a
> transaction to one that has already matched in a previous import, nor will
> it offer to match more than one imported transaction to a single existing
> transaction.
> • Support for UK VAT and Australian GST added to the Income-GST
> report. The reports options are changed from source accounts to source
> sales and purchase accounts to permit proper reporting of capital
> purchases. N.B. 

[GNC] Trouble opening ancient files

[Thomas Klausner]

Hi!

I have been using gnucash for a very long time, and recently I tried
opening some of my first files -- but couldn't. Many old files worked,
but not these two and their related .xac files.

I see two different symptoms.

One file has an timestamp from 2002. I don't recognize the file
format, it's a binary format, but gzip cannot unpack it
The error I get from gnucash (3.10) is:

"No suitable backend was found for /path/to/file."

A hexdump of the file starts with:

  00 00 00 0a 00 00 00 04  00 00 00 ab 00 08 00 00  ||
0010  00 09 41 75 73 67 61 62  65 6e 00 00 00 00 04 31  |..Ausgaben.1|
0020  30 30 00 00 00 00 01 00  00 00 00 01 00 00 00 00  |00..|
0030  04 46 52 46 00 00 00 00  01 00 00 00 00 00 00 00  |.FRF|
0040  00 01 00 00 00 05 00 00  00 d6 00 08 00 00 00 06  ||
0050  45 73 73 65 6e 00 00 00  00 04 31 31 30 00 00 00  |Essen.110...|

where I'm quite sure that "Ausgaben" is an account name and FRF is a
unit of currency, so probably Account number 100 in the Unit of FRF.


The second file has a timestamp from 2005. It is plaintext XML. The
error from gnucash is:

"This file/URL appears to be from a newer version of GnuCash. You must
upgrade your version of GnuCash to work with this data."

The file starts with:

--- begin quote ---


1

61535f2d2589fccc34164e57b1255f25
1
38
1023

  NASDAQ
  Fond
  Fond
  10

--- end quote ---

Then follows a gnc:pricedb and some accounts like

--- begin quote ---

  Ausgaben
  be0508dcdbc39e35f677dd6f334d36e5
  EXPENSE
  
ISO4217
ATS
  
  100
  100
  Ausgaben

--- end quote ---

Any suggestions on how to get versions of these files that could be
opened by gnucash 3.10?

Thank you,
 Thomas
___
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] Training the classifier of imported transactions in GnuCash

[Cliff Kushler]

Hi Gio, 

Thanks for your quick response!  

Yes, I have been importing transactions for many years.  However, it seems that 
Gnucash is not getting any better - I have to correct transactions from the 
same source over and over again, month after month.  There is a window that 
appears during the import process (before the transactions are posted in the 
actual account registers) that shows all of the transactions to be imported, 
with check boxes labelled “A” (accept? not sure…), “U+R” (update & reconcile?) 
and “R” (reconcile).  However, I do not know of any way to correct the 
classification of a transaction while it is still in this window (which seems 
like the opportunity to train the classifier).  I end up correcting the 
transactions after they have posted in the account registers, and GnuCash does 
not seem to be learning from this.  

If you (or anyone) knows what I should be doing, please let me know - thanks! 

Cliff

On Jun 15, 2020, at 3:25 AM, Gio Bacareza  wrote:

Hi Cliff,

I also want to first say thanks to all the developers. I am a user and a fan. 
2nd, awesome to meet you Cliff. I love your products too.

I was also looking into an automated way of classifying transactions. I did a 
quick automl using google and have achieved 90%+ accuracy.

However, I wasn't able to use it because I think gnucash does its own and 
requires you to classify them upon import. After a few imports it also 
"learns." So subsequent imports will have these transfer accounts autopopulated.

I hope it helps.

gio



On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler mailto:ckush...@gmail.com>> wrote:
Hello - 

I am a long-time user and fan of GnuCash, and start by offering my gratitude to 
everyone who has contributed to it.  For what it’s worth, I am also a 
co-inventor of T9 and Swype, so perhaps I have contributed something to make 
your life easier too.  

My question is whether there is a tool, technique or strategy to improve the 
accuracy with which GnuCash assigns imported transactions to destination 
accounts.  I import large quantities of credit card transactions, and while 
many of them are assigned to the correct accounts, a very large number of 
repeat transactions (i.e. from the same vendor) are either repeatedly assigned 
to the same wrong category or simply left as “Imbalance-USD”.  I have not been 
able to identify a way to correct them while they are still displayed in the 
initial import window, although I suspect that would be the time to correct 
them.  I go through and manually correct them in the register after importing 
them, but this does not seem to help future classification accuracy.  

Any help would be much appreciated!  I probably should have asked this years 
ago…

Joy & Blessings,

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


-- 
cheers,

Gio

___
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] Trouble opening ancient files

[Adrien Monteleone]

That first 2002 file is indeed ancient. (the 2005 file is no spring chicken 
either)

For both cases, you’d have to find the ’newest’ version of GnuCash that will 
open each file, then upgrade GnuCash in steps (possibly some leaps skipping 
bug-fix releases) and open each file with each version. At some point, file 
conversions will be done so they are readable by newer versions, and not 
backwards compatible.

Eventually you’ll arrive at the 3.x series and then you can jump to 3.10.

You’ll have to start this further back for the 2002 file and then eventually 
you’ll be able to open up each with the same version.

You might get lucky and only have to make 2 or three steps.

Sorry I can’t help pinpoint a version to target to get started, or help with 
which versions you can skip.

The wiki may provide some help if you dig, (as in reading old change logs) 
otherwise maybe someone familiar with those older files can help with specifics.

Regards,
Adrien

> On Jun 15, 2020 w25d167, at 3:49 PM, Thomas Klausner  wrote:
> 
> Hi!
> 
> I have been using gnucash for a very long time, and recently I tried
> opening some of my first files -- but couldn't. Many old files worked,
> but not these two and their related .xac files.
> 
> I see two different symptoms.
> 
> One file has an timestamp from 2002. I don't recognize the file
> format, it's a binary format, but gzip cannot unpack it
> The error I get from gnucash (3.10) is:
> 
> "No suitable backend was found for /path/to/file."
> 
> A hexdump of the file starts with:
> 
>   00 00 00 0a 00 00 00 04  00 00 00 ab 00 08 00 00  ||
> 0010  00 09 41 75 73 67 61 62  65 6e 00 00 00 00 04 31  |..Ausgaben.1|
> 0020  30 30 00 00 00 00 01 00  00 00 00 01 00 00 00 00  |00..|
> 0030  04 46 52 46 00 00 00 00  01 00 00 00 00 00 00 00  |.FRF|
> 0040  00 01 00 00 00 05 00 00  00 d6 00 08 00 00 00 06  ||
> 0050  45 73 73 65 6e 00 00 00  00 04 31 31 30 00 00 00  |Essen.110...|
> 
> where I'm quite sure that "Ausgaben" is an account name and FRF is a
> unit of currency, so probably Account number 100 in the Unit of FRF.
> 
> 
> The second file has a timestamp from 2005. It is plaintext XML. The
> error from gnucash is:
> 
> "This file/URL appears to be from a newer version of GnuCash. You must
> upgrade your version of GnuCash to work with this data."
> 
> The file starts with:
> 
> --- begin quote ---
> 
> 
> 1
> 
> 61535f2d2589fccc34164e57b1255f25
> 1
> 38
> 1023
> 
>  NASDAQ
>  Fond
>  Fond
>  10
> 
> --- end quote ---
> 
> Then follows a gnc:pricedb and some accounts like
> 
> --- begin quote ---
> 
>  Ausgaben
>  be0508dcdbc39e35f677dd6f334d36e5
>  EXPENSE
>  
>ISO4217
>ATS
>  
>  100
>  100
>  Ausgaben
> 
> --- end quote ---
> 
> Any suggestions on how to get versions of these files that could be
> opened by gnucash 3.10?
> 
> Thank you,
> Thomas

___
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] Training the classifier of imported transactions in GnuCash

[Adrien Monteleone]

Cliff, did you not see my reply or the one from Liz?

Making the corrections *after* the import is never going to teach GnuCash how 
to match those transactions correctly. The corrections are to be done as part 
of the import matching process.

The documentation covers this. See the Help Guide "§6.15.6. Generic Transaction 
Import Matcher", and the Tutorial & Concepts Guide "§3.1. Importing 
Transactions from Files”.

Liz asked for additional info on your system and version so more specific 
advice can be offered.

Regards,
Adrien

p.s.—I’m copying you this time in case you aren’t subscribed to the list, but 
I’d advise it if you are not. If you send a reply, be sure to send it to the 
list. (or use reply-all)

> On Jun 15, 2020 w25d167, at 2:30 PM, Cliff Kushler  wrote:
> 
> Hi Gio, 
> 
> Thanks for your quick response!  
> 
> Yes, I have been importing transactions for many years.  However, it seems 
> that Gnucash is not getting any better - I have to correct transactions from 
> the same source over and over again, month after month.  There is a window 
> that appears during the import process (before the transactions are posted in 
> the actual account registers) that shows all of the transactions to be 
> imported, with check boxes labelled “A” (accept? not sure…), “U+R” (update & 
> reconcile?) and “R” (reconcile).  However, I do not know of any way to 
> correct the classification of a transaction while it is still in this window 
> (which seems like the opportunity to train the classifier).  I end up 
> correcting the transactions after they have posted in the account registers, 
> and GnuCash does not seem to be learning from this. 
> 
> If you (or anyone) knows what I should be doing, please let me know - thanks! 
> 
> Cliff
> 
> On Jun 15, 2020, at 3:25 AM, Gio Bacareza  wrote:
> 
> Hi Cliff,
> 
> I also want to first say thanks to all the developers. I am a user and a fan. 
> 2nd, awesome to meet you Cliff. I love your products too.
> 
> I was also looking into an automated way of classifying transactions. I did a 
> quick automl using google and have achieved 90%+ accuracy.
> 
> However, I wasn't able to use it because I think gnucash does its own and 
> requires you to classify them upon import. After a few imports it also 
> "learns." So subsequent imports will have these transfer accounts 
> autopopulated.
> 
> I hope it helps.
> 
> gio
> 
> 
> 
> On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler 
> mailto:ckush...@gmail.com>> wrote:
> Hello - 
> 
> I am a long-time user and fan of GnuCash, and start by offering my gratitude 
> to everyone who has contributed to it.  For what it’s worth, I am also a 
> co-inventor of T9 and Swype, so perhaps I have contributed something to make 
> your life easier too.  
> 
> My question is whether there is a tool, technique or strategy to improve the 
> accuracy with which GnuCash assigns imported transactions to destination 
> accounts.  I import large quantities of credit card transactions, and while 
> many of them are assigned to the correct accounts, a very large number of 
> repeat transactions (i.e. from the same vendor) are either repeatedly 
> assigned to the same wrong category or simply left as “Imbalance-USD”. I have 
> not been able to identify a way to correct them while they are still 
> displayed in the initial import window, although I suspect that would be the 
> time to correct them.  I go through and manually correct them in the register 
> after importing them, but this does not seem to help future classification 
> accuracy.  
> 
> Any help would be much appreciated!  I probably should have asked this years 
> ago…
> 
> Joy & Blessings,
> 
> Cliff Kushler


___
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] Training the classifier of imported transactions in GnuCash

[Cliff Kushler]

Hello - 

I am a long-time user and fan of GnuCash, and start by offering my gratitude to 
everyone who has contributed to it.  For what it’s worth, I am also a 
co-inventor of T9 and Swype, so perhaps I have contributed something to make 
your life easier too.  

My question is whether there is a tool, technique or strategy to improve the 
accuracy with which GnuCash assigns imported transactions to destination 
accounts.  I import large quantities of credit card transactions, and while 
many of them are assigned to the correct accounts, a very large number of 
repeat transactions (i.e. from the same vendor) are either repeatedly assigned 
to the same wrong category or simply left as “Imbalance-USD”.  I have not been 
able to identify a way to correct them while they are still displayed in the 
initial import window, although I suspect that would be the time to correct 
them.  I go through and manually correct them in the register after importing 
them, but this does not seem to help future classification accuracy.  

Any help would be much appreciated!  I probably should have asked this years 
ago…

Joy & Blessings,

Cliff Kushler
___
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] Training the classifier of imported transactions in GnuCash

[Adrien Monteleone]

Correcting *after* the import doesn’t teach the matcher anything.

You have to re-assign the incorrect matches as part of the import process.

Regards,
Adrien

> On Jun 14, 2020 w25d166, at 2:02 PM, Cliff Kushler  wrote:
> 
> Hello - 
> 
> I am a long-time user and fan of GnuCash, and start by offering my gratitude 
> to everyone who has contributed to it.  For what it’s worth, I am also a 
> co-inventor of T9 and Swype, so perhaps I have contributed something to make 
> your life easier too.  
> 
> My question is whether there is a tool, technique or strategy to improve the 
> accuracy with which GnuCash assigns imported transactions to destination 
> accounts.  I import large quantities of credit card transactions, and while 
> many of them are assigned to the correct accounts, a very large number of 
> repeat transactions (i.e. from the same vendor) are either repeatedly 
> assigned to the same wrong category or simply left as “Imbalance-USD”.  I 
> have not been able to identify a way to correct them while they are still 
> displayed in the initial import window, although I suspect that would be the 
> time to correct them.  I go through and manually correct them in the register 
> after importing them, but this does not seem to help future classification 
> accuracy.  
> 
> Any help would be much appreciated!  I probably should have asked this years 
> ago…
> 
> Joy & Blessings,
> 
> Cliff Kushler

___
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] Training the classifier of imported transactions in GnuCash

[Liz]

On Mon, 15 Jun 2020 04:19:00 -0500
Adrien Monteleone  wrote:

> orrecting *after* the import doesn’t teach the matcher anything.
> 
> You have to re-assign the incorrect matches as part of the import
> process.
> 
> Regards,
> Adrien
> 
> > On Jun 14, 2020 w25d166, at 2:02 PM, Cliff Kushler
> >  wrote:
> > 
> > Hello - 
> > 
> > I am a long-time user and fan of GnuCash, and start by offering my
> > gratitude to everyone who has contributed to it.  For what it’s
> > worth, I am also a co-inventor of T9 and Swype, so perhaps I have
> > contributed something to make your life easier too.  
> > 
> > My question is whether there is a tool, technique or strategy to
> > improve the accuracy with which GnuCash assigns imported
> > transactions to destination accounts.  I import large quantities of
> > credit card transactions, and while many of them are assigned to
> > the correct accounts, a very large number of repeat transactions
> > (i.e. from the same vendor) are either repeatedly assigned to the
> > same wrong category or simply left as “Imbalance-USD”.  I have not
> > been able to identify a way to correct them while they are still
> > displayed in the initial import window, although I suspect that
> > would be the time to correct them.  I go through and manually
> > correct them in the register after importing them, but this does
> > not seem to help future classification accuracy.  
> > 
> > Any help would be much appreciated!  I probably should have asked
> > this years ago…
> > 
> > Joy & Blessings,
> > 
> > Cliff Kushler  

To add to this, in later versions of Gnucash there are some ways of
editing the /learned/ items.
Could you please advise your OS, Gnucash version, and /which/ importer
you use.
This will allow more tailored advice.

Liz 
___
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] Training the classifier of imported transactions in GnuCash

[Gio Bacareza]

Hi Cliff,

I also want to first say thanks to all the developers. I am a user and a
fan. 2nd, awesome to meet you Cliff. I love your products too.

I was also looking into an automated way of classifying transactions. I did
a quick automl using google and have achieved 90%+ accuracy.

However, I wasn't able to use it because I think gnucash does its own and
requires you to classify them upon import. After a few imports it also
"learns." So subsequent imports will have these transfer accounts
autopopulated.

I hope it helps.

gio



On Mon, Jun 15, 2020 at 5:11 PM Cliff Kushler  wrote:

> Hello -
>
> I am a long-time user and fan of GnuCash, and start by offering my
> gratitude to everyone who has contributed to it.  For what it’s worth, I am
> also a co-inventor of T9 and Swype, so perhaps I have contributed something
> to make your life easier too.
>
> My question is whether there is a tool, technique or strategy to improve
> the accuracy with which GnuCash assigns imported transactions to
> destination accounts.  I import large quantities of credit card
> transactions, and while many of them are assigned to the correct accounts,
> a very large number of repeat transactions (i.e. from the same vendor) are
> either repeatedly assigned to the same wrong category or simply left as
> “Imbalance-USD”.  I have not been able to identify a way to correct them
> while they are still displayed in the initial import window, although I
> suspect that would be the time to correct them.  I go through and manually
> correct them in the register after importing them, but this does not seem
> to help future classification accuracy.
>
> Any help would be much appreciated!  I probably should have asked this
> years ago…
>
> Joy & Blessings,
>
> Cliff Kushler
> ___
> 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.
>


-- 
cheers,

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

Re: [GNC] GnuCash 3.905 Released

[Christopher Lam]

A couple of notes:
- Balance-sheet is reverted back to the legacy report: multicolumn
balance-sheet had a few more bugs identified related to currency
conversions, so, isn't ready yet. The latter is downgraded back to
experimental submenu.
- gnucash-cli --report run --name "VAT Report" --export-type CSV
--output-file VAT.CSV, when "Income and GST Statement" is properly set up
and saved as "VAT Report", would be a convenient way to generate the VAT
figures and save as CSV. Also applicable for Australian BAS reports.

On Sun, 14 Jun 2020 at 23:21, John Ralls  wrote:

> The GnuCash development team announces GnuCash 3.905, the fourth testing
> release for what will soon be GnuCash 4.0.
>
> Changes
>
> Baseline requirements
>
> Operating Systems:
>
> • Linux: Ubuntu 18.04LTS
> • MacOS: 10.13
> • Windows: 8.1
> Software Dependencies:
>
> • C++ standard is now C++17, requires gcc 8.0 or clang 6.0.
> • Cmake 3.10
> • boost 1.67.0
> • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot.
> • glib-2.0 2.56.1, gtk 3.22.30
> • googletest 1.8.0
> • ICU, any version.
> • libdbi 0.8.3
> • libxml2 2.9.4
> • swig 3.0.12 Now required for building from tarballs as well as
> from git.
> • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD
> New Features
>
> The intent is to have command categories with subcommands to better enable
> a richer command line capability as illustrated with the new report
> commands list and show.
>
> • A new separate executable, gnucash-cli (gnucash-cli.exe on
> Microsoft Windows) for doing command-line things like updating the prices
> in your book. gnucash-cli gains the ability to run reports from the command
> line. Specify reports to run by name or guid. It also provides an export
> format and an output file name without which it will output the report to
> stdout.
> • gnucash-cli --report run --name=[reportname/guid]
> datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html datafile.gnucash
> • gnucash-cli --report run --name=[reportname/guid]
> --output-file=x.html --export-type=TYPE datafile.gnucash
> The GUI command, gnucash responds to the same command line arguments. In
> order to provide more options its syntax (and gnucash-cli's) for quote
> retrieval is changed from --add-quotes to --quotes get.
>
> • When deleting accounts the destination accounts of moved splits
> will be checked to ensure that they have the same commodity as the source
> account. If they don't you'll get a warning and the opportunity to pick
> another account or to carry on regardless.
> • New type-ahead search added to sequential search when selecting
> an account in the register: Instead of typing the first few characters of a
> top level account, the separator, the first few characters of the next
> level account and so on you may instead type a few characters of any part
> of a full account name and the drop-list will be filtered to contain only
> matching accounts. Once you have a small enough list you can use the arrow
> keys to select the account that you want.
> • Python bindings are now localized and their strings available
> for translation.
> • The new reports introduced in the Experimental Reports menu are
> moved to the main menu and the old reports hidden; the old reports can be
> unhidden by running GnuCash from the commandline with the --extra argument.
> That will cause the old reports to appear in their regular locations on the
> menu labeled (legacy). Note that new reports use different options and
> layouts and you may need to adjust your saved report configurations.
> • A new Transaction Association dialog, available from the new
> Update Transaction Association item in the register context menu, provides
> the ability to have multiple associations for a single transaction.
> Associations may now be easily removed.
> • Allow Associations to be added to invoices. The actual
> association when present is added as a link button which is shown below the
> notes.
> • A symbol is now displayed on transactions in the register when
> they have an attachment and the selected font supports the symbol.
> • The OFX file importer can now import more than one file at a
> time.
> • A new report menu supbmenu Multicolumn contains the old
> custom-multicolumn report and a new Dashboard report containing Account
> reports for expenses and income, an income-expense chart, and an account
> summary.
> • When importing, the matcher will no longer offer to match a
> transaction to one that has already matched in a previous import, nor will
> it offer to match more than one imported transaction to a single existing
> transaction.
> • Support for UK VAT and Australian GST added to the Income-GST
> report. The reports options are

[GNC] file storage location

[Jamie Tolbert]

new user here, seems like all the files are in my document storage 
folder, I'd like to move them to their own separate folder, is that 
possible?

___
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] file storage location

[D. via gnucash-user]

1. File->Save As --- save into your new location. Exit Gnucash. 
2. From your favorite file manager, move all remaining gnucash files into the 
new location. Note that the base data file will already be there, since you 
saved it there in step 1, so you don't need that. 

You could of course do it all from your file manager, but gnucash would bark 
about the missing data file the next startup. This is remedied simply by 
ignoring the error and then opening the file from its new location, but thre 
first method avoids the error altogether. 


 Original Message 
From: Jamie Tolbert 
Sent: Mon Jun 15 11:07:52 EDT 2020
To: gnucash-user@gnucash.org
Subject: [GNC] file storage location

new user here, seems like all the files are in my document storage 
folder, I'd like to move them to their own separate folder, is that 
possible?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] GnuCash 3.905 Released

[jean laroche]

The Win32 download link from sourceforge appears to be broken
The GitHub one seems to work.

Also the doc states:

When importing, the matcher will no longer offer to match a 
transaction to one that has already matched in a previous import, nor 
will it offer to match more than one imported transaction to a single 
existing transaction.
The second item, I thinks this is pull request 
https://github.com/Gnucash/gnucash/pull/718 and it hasn't been merged in yet


Jean


On 6/15/2020 5:31 AM, Christopher Lam wrote:

A couple of notes:
- Balance-sheet is reverted back to the legacy report: multicolumn
balance-sheet had a few more bugs identified related to currency
conversions, so, isn't ready yet. The latter is downgraded back to
experimental submenu.
- gnucash-cli --report run --name "VAT Report" --export-type CSV
--output-file VAT.CSV, when "Income and GST Statement" is properly set up
and saved as "VAT Report", would be a convenient way to generate the VAT
figures and save as CSV. Also applicable for Australian BAS reports.

On Sun, 14 Jun 2020 at 23:21, John Ralls  wrote:


The GnuCash development team announces GnuCash 3.905, the fourth testing
release for what will soon be GnuCash 4.0.

Changes

Baseline requirements

Operating Systems:

 • Linux: Ubuntu 18.04LTS
 • MacOS: 10.13
 • Windows: 8.1
Software Dependencies:

 • C++ standard is now C++17, requires gcc 8.0 or clang 6.0.
 • Cmake 3.10
 • boost 1.67.0
 • gettext 0.19.6 for general use, 0.20 to generate gnucash.pot.
 • glib-2.0 2.56.1, gtk 3.22.30
 • googletest 1.8.0
 • ICU, any version.
 • libdbi 0.8.3
 • libxml2 2.9.4
 • swig 3.0.12 Now required for building from tarballs as well as
from git.
 • Webkit 2.4.11 Mac & Win32, 2.14.1 Linux/BSD
New Features

The intent is to have command categories with subcommands to better enable
a richer command line capability as illustrated with the new report
commands list and show.

 • A new separate executable, gnucash-cli (gnucash-cli.exe on
Microsoft Windows) for doing command-line things like updating the prices
in your book. gnucash-cli gains the ability to run reports from the command
line. Specify reports to run by name or guid. It also provides an export
format and an output file name without which it will output the report to
stdout.
 • gnucash-cli --report run --name=[reportname/guid]
datafile.gnucash
 • gnucash-cli --report run --name=[reportname/guid]
--output-file=x.html datafile.gnucash
 • gnucash-cli --report run --name=[reportname/guid]
--output-file=x.html --export-type=TYPE datafile.gnucash
The GUI command, gnucash responds to the same command line arguments. In
order to provide more options its syntax (and gnucash-cli's) for quote
retrieval is changed from --add-quotes to --quotes get.

 • When deleting accounts the destination accounts of moved splits
will be checked to ensure that they have the same commodity as the source
account. If they don't you'll get a warning and the opportunity to pick
another account or to carry on regardless.
 • New type-ahead search added to sequential search when selecting
an account in the register: Instead of typing the first few characters of a
top level account, the separator, the first few characters of the next
level account and so on you may instead type a few characters of any part
of a full account name and the drop-list will be filtered to contain only
matching accounts. Once you have a small enough list you can use the arrow
keys to select the account that you want.
 • Python bindings are now localized and their strings available
for translation.
 • The new reports introduced in the Experimental Reports menu are
moved to the main menu and the old reports hidden; the old reports can be
unhidden by running GnuCash from the commandline with the --extra argument.
That will cause the old reports to appear in their regular locations on the
menu labeled (legacy). Note that new reports use different options and
layouts and you may need to adjust your saved report configurations.
 • A new Transaction Association dialog, available from the new
Update Transaction Association item in the register context menu, provides
the ability to have multiple associations for a single transaction.
Associations may now be easily removed.
 • Allow Associations to be added to invoices. The actual
association when present is added as a link button which is shown below the
notes.
 • A symbol is now displayed on transactions in the register when
they have an attachment and the selected font supports the symbol.
 • The OFX file importer can now import more than one file at a
time.
 • A new report menu supbmenu Multicolumn contains the old
custom-multicolumn report and a new Dashboard report containing Account
reports for expenses and income, an