Re: [GNC] Question about OFX imports

[Jean Laroche]

Also, you definitely would not want to double-import the same 
transaction, so there isn't a good reason to want to mock with the 
FITID. What *could* be useful (but in extremely rare cases) would be to 
force a re-import of the same transaction despite the fact that it's 
been imported previous, while avoiding a duplication (i.e. the second 
import would update the existing transaction instead of being skipped 
altogether). But I don't see a good reason to implement that at this 
point... Deleting the existing one achieves the same result for these 
rare cases.


Jean

On 5/13/24 3:12 PM, David Reiser via gnucash-user wrote:

On May 13, 2024, at 17:50, David Carlson  wrote:

Now it is my turn to ask a question.

My bank recently had an issue with the description text for a few
transactions that resulted in the transactions being reposted with
corrected descriptions.  Now I am trying to import the corrected
transactions but they do not appear in the OFX importer even though they
are in the file generated by the bank.

My question is: If I delete the previously imported transactions, can I
import the corrected transactions?

yes.


A corollary; is there any way to check, edit or remove the FITID value of a
transaction that prevents the duplicate import without doing tricks in the
OFX file before importing?

only if you are willing to risk damaging your datafile editing it outside of 
gnucash. The FITID values are stored as a key/value pair like:

 
   online_id
   20180906246910059666
 

and finding specific transactions in the raw XML is harder than you might 
imagine. The online_id is not available to the user anywhere in the gnucash 
interface.

I have never tried editing a gnucash SQL file outside of gnucash.


--
David Carlson
___


--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Question about OFX imports

[Jean Laroche]

Yes, I believe that if you delete the previously imported transaction, 
the new one will be imported.


For your 2nd question, there isn't a way to remove or edit that FITID 
value without hacking either the OFX or your database... I don't think 
GC ever shows you the FITID of transactions (even though they're saved 
in the database).


Jean

On 5/13/24 2:50 PM, David Carlson wrote:

Now it is my turn to ask a question.

My bank recently had an issue with the description text for a few
transactions that resulted in the transactions being reposted with
corrected descriptions.  Now I am trying to import the corrected
transactions but they do not appear in the OFX importer even though they
are in the file generated by the bank.

My question is: If I delete the previously imported transactions, can I
import the corrected transactions?
A corollary; is there any way to check, edit or remove the FITID value of a
transaction that prevents the duplicate import without doing tricks in the
OFX file before importing?


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

Re: [GNC] Import of CSV

[Jean Laroche]

I can't help you with the CSV import as I typically use ofx and am not 
familiar with the CSV workflow.
The option to reconcile is there with the OFX import because it was 
added by the people who maintain and update gnucash (I worked on the ofx 
import myself). I'm guessing it's not on the CSV import because nobody 
added the reconcile to it?
If you have an option to use OFX rather than CSV, you live will be a bit 
simpler, but I'm imagining you already know that.


Jean

On 4/11/24 4:36 PM, Gyle McCollam wrote:

Back on 3/11 I sent 2 emails about issues with imports.  Neither received any 
responses.  This month when I imported the CSV file I had the following issues:


   1.
There were many receipts from the same vendor.  It matched the 1st to an entry 
that was already reconciled, which to me doesn't make sense, am I wrong?  Every 
entry after that was then matched to an earlier transaction. I was able to 
change these to the correct transaction.  BTW they all had the same value or $ 
amount that is why they matched.  If the 1st had not been matched to a 
reconciled transaction they would have all been OK this month.
   2.
When importing an OFX/QFX file you have the option to reconcile after matching, 
but in the case of a CSV import, it does not give you that option.  Is there a 
logical reason why not?


Thank You,

Gyle McCollam

Gyle McCollam

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

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

Re: [GNC] Trouble setting up online banking

[Jean Laroche]

ofxdirectconnect is dead or dying indeed. The only available solution at 
the moment is to go download your transactions in ofx format, then 
importing that into gnucash. That's what I've resorted to doing, much as 
I dislike it.


Jean

On 3/25/24 3:21 PM, Bryan B. wrote:

I have been using Wells Fargo Bank and MtMcKinley Bank for a long time.

I'm trying to connect GnuCash to these banks. The AqBanking app suggests I
go to ofxhome.com for server info.

When I search for Wells Fargo Bank, the information there isn't up to date.
 From the error messages listed, I did find some relevant information
regarding the Client UID etc. However, after inputting this info into
AqBanking App, I'm asked for User Id and Client ID, neither of which I can
find online, despite searching.

Mt McKinley bank is not listed.

Results from a Google search that led to reddit.com/r/GnuCash suggest that
OFX is dead. If this is the case, what has replaced it? How can I set up
automated downloads for GnuCash, if at all possible?

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

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

Re: [GNC] Defining Keyboard shortcuts for Menu Functions

[Jean Laroche]

As shown in 
https://wiki.gnucash.org/wiki/Keyboard_Shortcuts#Modifying_Keyboard_Shortcuts


You need to find and edit the file accelerator-map
Then uncomment the line

(gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction" "")

And modify to this (for example, for Ctrl-shift-o to import ofx).

(gtk_accel_path "/gnc-plugin-ofx-actions/OfxImportAction" 
"o")


Jean

On 3/6/24 9:14 AM, Lincoln A Baxter wrote:

Hi

I've just spent 45 minutes searching the web, and GC docs for how to a
new keyboard shortcut.

The shortcut I want define would be to File->Import->Import OFX/QFX

Can someone provide me with enough information so that I can do this?

I have no problem editing text configuration files.

I would need to know the function-name for this action, and how to bind
a key to that function in a configuration file GC will read.

TIA,

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

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

Re: [GNC] Looking how to automatically download transactions from Capital One

[Jean Laroche]

I don't think Capital One can be automatically downloaded. It used to 
support it a long while back, but not anymore. I have to go and download 
by hand.


Jean
P.S. Your signature is somewhat obnoxious/in your face.

On 2/16/24 8:56 AM, Matatia Chetrit wrote:

bs"d

Hello. I looked for ways to automatically download transactions from
Capital One.
I tried the Online Banking Setup interface of Aq Banking  -
OFX Didn't work with the credentials:

CapitalOne (Banking)https://ofx.capitalone.com/ofx/103/process.ofx
**OFX Version=103;APPID=MDNC;APPVER=2012. Must have CLIENTUID set.
1001Capital One Whatever your routing number is


   "id" = "md:1052"
   "access_type" = "OFX"
   "ofx_version" = "103"
   "fi_name" = "Capital One Bank (Not Credit Cards)"
   "bootstrap_url" =
"https://onlinebanking.capitalone.com/ofx/process.ofx;
   "fi_id" = "1001"
   "uses_fi_tag" = "y"
   "app_id" = "MDNC"
   "fi_org" = "Hibernia"
   "app_ver" = "2012"
}
{
   "id" = "md:2019"
   "uses_fi_tag" = "y"
   "access_type" = "OFX"
   "fi_name" = "Capital One Bank (Not Credit Cards)"
   "bootstrap_url" ="https://ofx.capitalone.com/ofx/103/process.ofx;
   "fi_id" = "1001"
   "ofx_version" = "103"
   "app_id" = "MDNC"
   "fi_org" = "Capital One"
   "app_ver" = "2012"

tried OFX Direct Connect, EBICS, Offline Backend & HBCI. Nothing
worked. Any Suggestions?

I also have another paypal account - tried to log in paypal
transactions - with paypal interface that didn't work either.

If you have info on that as well that would also be helpful.


Thanks in advance.
Matatia Chetrit
==



7 Noahide Torah Laws for All People
1 Being Faithful to G∙d - Don't Worship Idols - Object,Animal,Man
2 Respect of Integrity of Family - Prohibition of Immoral Relations-
Adultery,Bestiality,Homosexuality& Incest
3 Respect of Human Life - Don't Murder
4 Respect of G∙d- Don't Blaspheme
5 Respect of Property-Don't Steal
6 Law & Order-Establish Courts of Law
7 Respect of Creatures-Don't Eat Limb taken from live animal
http://www.jerusalemlife.com/?p=1473  



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

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

Re: [GNC] Using GC for Property Management

[Jean Laroche]

"to those who don't know better"
Bit eye roll there.

On 9/25/23 12:40 PM, Adrien Monteleone wrote:

ChatGPT cannot give you an answer.

It is designed to spit out sentences that plausibly sound like a human 
answered your question.


There is a universe of difference between the two.

One implies accuracy, the other is B.S. that appears accurate to those 
who don't know better.



Regards,
Adrien

On 9/22/23 2:56 PM, Mark at Lorimark wrote:

well...

I don't know how to answer your question, but considering what I 
would do if I were asking the same questions...


I went to ChatGPT and asked the big AI.  Here is what it said;


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

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

Re: [GNC] No longer able to import OFX

[Jean Laroche]

I think many people have run into that problem, and some wrote some 
python scripts that modify the bank FITID for example by adding part of 
the date, so it becomes unique. It's a kludge of course, but it works.


You could look for such scripts on github for example, or write your own 
from the available python based ofx libraries


Jean

On 9/24/23 9:18 AM, john wrote:



On Sep 24, 2023, at 07:15, Mike St. Germaine  wrote:

Hello,
At some point earlier in the year I started receiving the attached
message when attempting to import an OFX from Citizens bank (the
message is "found 1 previously imported transactions, no new
transactions" -- the number always matches the number of transactions
i'm trying to import). These are transactions that have definitely not
been imported before. I've been manually entering all transactions for
a while now and that's getting pretty old.
This change seemed to coincide with a major change the bank made to
their website though that could very well be a coincidence.
If I create a new Gnucash file and import the OFX, it works just fine.
It just won't allow me to import to the file I've been using for the
past year or so. Also worth mentioning I'm still able to import OFX
files from other banks with no issue.
I deleted the account assignment through the import map editor but
that didn't work either. It did ask for a new account assignment when
importing but then I just received the same message described above.

This problem is usually because your bank is reusing FITID values. Those are 
supposed to be unique to enable software reading the OFX to identify duplicate 
transactions.

Regards,
John Ralls


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

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

Re: [GNC] Using Plaid

[Jean Laroche]

To me it's very different.  You're not giving a user name and a password 
to AQBanking. I started using Plaid, then got really spooked by the fact 
that they do have access to your account as if they were you. Removed my 
account and canceled my keys.
There are no current alternatives at the moment, unlike in Europe where 
there seem to be, I believe mandated by the EU.
I wrote automated scripts to scrape my banks for the OFX files, but 
that's a royal pain in the butt, and it's not robust at all.


Jean

On 2/28/23 3:44 PM, Ben Pracht wrote:

  I read that disclaimer. It says to keep the token secure and yes, the
bearer of that token gets access. As they said:
"The access token generated by using this tool is sensitive material as it
grants access to your accounts. It should be handled with care and
protected from unauthorized access. You must be sure to store it in such a
way that makes it impossible for others to gain access. The creators and
maintainers of Plaid2QIF are in no way responsible if you mishandle your
access token."

GIving Plaid2QIF this token is no different than me giving a username and
password to AQBanking, except that Plaid has a chance of working. I don't
like having an intermediary, in this case Plaid and Plaid2QIF, but OFX is
unusable, and at the moment, AQBanking isn't even showing the list of banks
anymore. Does anyone know of a US bank or credit union that uses a modern
REST based API that they actually share with developers?

Regards,
Ben

On 2/22/23 23:08, john wrote:

On Feb 22, 2023, at 2:01 PM, Ben Pracht
  wrote:

I'd like to use Plaid with GnuCash. There is a plaid2qif project that
claims to have been extensively tested with GnuCash and Plaid. However,
when I created the Plaid account, it asks for either a limited developer
account or a production account with a compliance audit. What account type
should I use? Anything else helpful to know?


Neither. See
https://github.com/ebridges/plaid2qif/blob/master/gen-access-token/README.md
,

Pay particular attention to the disclaimer at the bottom of that page.

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

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

Re: [GNC] Chase OFXdirect connect - another one bites the dust

[Jean Laroche]

Any of you know whether something else is in the works to replace direct 
connect? Manual downloading can be a pain when you have many accounts in 
different institutions...


J.

On 10/6/22 9:46 AM, David Reiser via gnucash-user wrote:

As of today, aqbanking reports that “ofx.chase.com” is 
an unknown host. Banktivity reports that today is the start of Chase enforcing data 
access only through Open Banking APIs.

OFX data format transaction downloads are still available from the Chase online web 
accounts — manual download followed by File>Import>Import OFX/QFX… in Gnucash.
--
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Lost 4 hours of data input

[Jean Laroche]

Wonder if the OP changed it to something longer? Or if we have a bug 
somewhere...


J.

On 7/22/22 4:41 PM, David Carlson wrote:

The auto save interval might default to 5 minutes but for me it is one of
the first  mandatory changes to make when setting up a new file to set it
to a half hour or longer because I won't turn it off altogether.

On Fri, Jul 22, 2022, 2:36 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Is the default not 5 minutes? One shouldn't lose more than 5 minutes of
work in such a case.

Regards,
Adrien

On 7/22/22 2:04 PM, Jean Laroche wrote:

I fully agree. Does this mean that the default autosave should be
changed to something more reasonable?

On 7/22/22 11:46 AM, David T. via gnucash-user wrote:

It's too bad that the responses to "Gnucash has crashed and I lost X
hours of work" are:

1. Save more often.
2. Don't use a cloud service except as an offline backup.
3. Use the db backend (which is basically a technological alternative
to #1).


___
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 
seehttps://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] Lost 4 hours of data input

[Jean Laroche]

I fully agree. Does this mean that the default autosave should be 
changed to something more reasonable?


On 7/22/22 11:46 AM, David T. via gnucash-user wrote:

It's too bad that the responses to "Gnucash has crashed and I lost X hours of 
work" are:

1. Save more often.
2. Don't use a cloud service except as an offline backup.
3. Use the db backend (which is basically a technological alternative to #1).




On July 22, 2022 8:51:01 PM GMT+03:00, Phyllis Bruce  
wrote:

Thank you Adrien, and Glenn

I'd much prefer to keep the file local. I just discovered I can choose to
NOT sync a folder to dropbox so I carefully navigated to the GnuCash folder
on my PC and made that change.  I will re-import by month henceforth.  I've
already done the hard work of figuring where stuff goes so it should be
easier this time.  I'll also decrease the autosave interval.

Once I have a good file, do I need to keep the log files?  They pile up in
a double quick hurry.

On Fri, Jul 22, 2022 at 12:16 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Someone else can help with the logfile, and it *should* replay your
steps, but I'd offer two suggestions for a different workflow:

1. copy the file locally first, then open it. (other users of DropBox
may have additional/alternative practices to help with sync issues)

2. Import, match & reconcile one month at a time then save. Doing this
in smaller batches has two advantages: the matcher is trained as you go,
this means less editing work on your part, and more accurate match
guesses on GnuCash's part; the incremental saves mean should a crash
happen, you lose less work.

Another option is to switch to the SQLite backend rather than the
default XML. Of course, XML should work, but SQLite does instant saves,
so if there is a crash, your at most likely to lose the last
edit/import, etc. (and so doing things in smaller batches also means
less lost work, without even having to remember to save.)

Regards,
Adrien

On 7/22/22 11:29 AM, Phyllis Bruce wrote:

Imported and matched all the years transactions for a credit card.  Then
hit the reconcile button.  Crash!
On trying to get back in I received a message that talked about
bounceback?  I'm sorry, I didn't write it down, but when I tried to

reopen

it said that someone else might be using the file and the path to DROPBOX
was shown.  I possibly made a mistake in choosing to open anyway -

because

4 hours of work have apparently disappeared.

Dropbox has a log file timestamp is 10:51 (the log also exists on my

local

drive).  That is about the time of the crash.  Could it possibly be of

help

in restoring all my work or do I need to do it over again?


___
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 
seehttps://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 
seehttps://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] QFX file for Bank of American business account not

[Jean Laroche]

Don't know if my last messages went through. Here they are again:

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements 
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements, 
but that's the way it is.

Perhaps file a bug with libofx?

In the meantime, if you're on a linux box or a mac and you're familiar 
with linux commands, you can use the command line to strip the ofx file 
from the offending lines using sed, for example on the mac:


cat stmt.qfx | sed -E "/ stmt_fixed.qfx

I'm not a sed guru, so maybe there's a better/more robust way to do it. 
But this should give you a temporary solution?


Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
element "CARDNUM" undefined


(Above message occurred on Line 39, Column 14)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00

(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
element "CARDNAME" undefined


(Above message occurred on Line 40, Column 15)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: 9767

(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
element "MCC" undefined





On 5/4/22 2:24 PM, Kalpesh Patel wrote:

I did experimented with the file he has attached and I can concur that OFX
matcher is bailing out, or more likely silently exiting as if it was NOP.
This is most likely an OFX import bug.

  


If you start a fresh new file with just the 'Common Accounts' and then
import the ofx file that was originally attached to the e-mail, GNC 4.10 on
Windows 10 prompts to create a new account which it does with 'Unknown OFX
credit card account "Credit card 4003901016729673"' account name and then
there is no subsequent dialogue box to import the single transaction that is
in that file. It exit with the effect that you cancelled the import after
creating the account. If I reimport the file again then there is nothing
displayed, -- nothing;  nada --,  such as error messages or the notification
windows that one transaction was found and that it was a duplicate. It once
again simply silently exits and goes back if like no "import" was performed
at all or cancelled. I don't see the transaction getting added to the
register either.

  

  

  


--

  


Message: 12

Date: Wed, 4 May 2022 03:25:25 +

From: Peter Wu mailto:peter_cd...@hotmail.com> >

To: "gnucash-user@gnucash.org  "
mailto:gnucash-user@gnucash.org> >

Subject: [GNC] QFX file for Bank of American business account not

 invoking Import Matcher

Message-ID:

  

OM
 >

 


Content-Type: text/plain; charset="windows-1252"

  


Hello,

Gnucash community.  Hope everyone is doing well and having a good time.  Two
questions:

  

  


   1.  Beside the mailing-list.  Does anyone know a forum where we can ask
and discuss issues?  I feel it may be easier to search/discuss/answer
questions than a mailing list.

   2.  As the email subject says.  Attached qfx file does not work.  I have
personal Bank of American checking and credit card.  They all work.  I
downloaded the file by using the ?Web Connect for Quicken 2018 and above?.

  


I have a suspicion why it is not working.  Maybe it is because a combined
qfx file.  BofA organized their business account in a group fashion.  They
made a parent account and each credit card holder as a child account.  Their
personal account doesn?t follow this parent-child account structure.

  


Does anyone has a solution for this kind of qfx file?

  


Best,

Peter

  

  

  


___
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 

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Jean Laroche]

In the meantime, if you're on a linux box or a mac and you're familiar 
with linux commands, you can use the command line to strip the ofx file 
from the offending lines using sed, for example on the mac:


cat stmt.qfx | sed -E "/ stmt_fixed.qfx

I'm not a sed guru, so maybe there's a better/more robust way to do it. 
But this should give you a temporary solution?


Jean

On 5/4/22 9:51 AM, Jean Laroche wrote:

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements 
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized 
elements, but that's the way it is.

Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
element "CARDNUM" undefined


(Above message occurred on Line 39, Column 14)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00

(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
element "CARDNAME" undefined


(Above message occurred on Line 40, Column 15)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: 9767

(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
element "MCC" undefined




On 5/4/22 8:38 AM, Peter Wu wrote:

Hi David C,

It is all new transactions.  If it is previously imported 
transaction, it would give a error dialog saying no new transaction.


But for the given QFX, it just does nothing after you click okay to 
import the file.


By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash 
Users 
Subject: Re: [GNC] QFX file for Bank of American business account not 
invoking Import Matcher
If your file already contains a transaction that was previously 
imported with the same reference number,  Gnucash does not import it 
again.


On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when 
you click on "Import OFX/QFX"?  Are you able to see the filename and 
select it?  Is there an error message?


On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:

Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data 
for gnucash


For personal account checking or credit card. It is the same user 
flow, use the web connect for quicken 2018 or above download a qfx 
file and everything works fine.


I would expect this biz credit to work too. They are from the same 
institution and UI flow is the same.


Somehow the downloaded qfx won’t work. I attached the file in the 
first email.


I used a diff checker to check personal qfx and biz credit card qfx. 
Inside the file, keys are different.


Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone

On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:


What is your reasoning to expect THAT (data intended for some sort 
of bookkeeping that is NOT double entry bookkeeping) to be correct 
data for gnucash

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

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] QFX file for Bank of American business account not invoking Import Matcher

[Jean Laroche]

Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements 
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements, 
but that's the way it is.

Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
element "CARDNUM" undefined


(Above message occurred on Line 39, Column 14)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00

(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
element "CARDNAME" undefined


(Above message occurred on Line 40, Column 15)
 X ERROR: startElement: incoming_data should be empty! You are 
probably using OpenSP <= 1.3.4.  The following data was lost: 9767

(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
element "MCC" undefined




On 5/4/22 8:38 AM, Peter Wu wrote:

Hi David C,

It is all new transactions.  If it is previously imported transaction, it would 
give a error dialog saying no new transaction.

But for the given QFX, it just does nothing after you click okay to import the 
file.

By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash Users 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
If your file already contains a transaction that was previously imported with 
the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when you click on 
"Import OFX/QFX"?  Are you able to see the filename and select it?  Is there an 
error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:
Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine.

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same.

Somehow the downloaded qfx won’t work. I attached the file in the first email.

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different.

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone


On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:

What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

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

___
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] QFX file for Bank of American business account not invoking Import Matcher

[Jean Laroche]

I tried your OFX file, and the same happens for me, no matching dialog 
opens.

I'll take a look and see if I can find out what's going on.

Jean

On 5/4/22 8:38 AM, Peter Wu wrote:

Hi David C,

It is all new transactions.  If it is previously imported transaction, it would 
give a error dialog saying no new transaction.

But for the given QFX, it just does nothing after you click okay to import the 
file.

By the way, I am using the latest Mac OS on latest Gnucash version.

Should I reply all with email or just reply to the mailing list?

Best,
Peter

From: David Carlson 
Date: Wednesday, May 4, 2022 at 08:30
To: Peter Wu 
Cc: stepbystepf...@comcast.net , Gnucash Users 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
If your file already contains a transaction that was previously imported with 
the same reference number,  Gnucash does not import it again.

On Wed, May 4, 2022, 9:11 AM David Carlson 
mailto:david.carlson@gmail.com>> wrote:
Probably, but you do not explain what happens or doesn't happen when you click on 
"Import OFX/QFX"?  Are you able to see the filename and select it?  Is there an 
error message?

On Wed, May 4, 2022 at 9:03 AM Peter Wu 
mailto:peter_cd...@hotmail.com>> wrote:
Quote:
What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

For personal account checking or credit card. It is the same user flow, use the 
web connect for quicken 2018 or above download a qfx file and everything works 
fine.

I would expect this biz credit to work too. They are from the same institution 
and UI flow is the same.

Somehow the downloaded qfx won’t work. I attached the file in the first email.

I used a diff checker to check personal qfx and biz credit card qfx. Inside the 
file, keys are different.

Is it because how gnucash is parsing the file?

Thanks,
Peter

Sent from my iPhone


On May 4, 2022, at 6:47 AM, Michael or Penny Novack 
mailto:stepbystepf...@comcast.net>> wrote:

What is your reasoning to expect THAT (data intended for some sort of 
bookkeeping that is NOT double entry bookkeeping) to be correct data for gnucash

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

___
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] Unusual book need

[Jean Laroche]

As far as I know, there's no easy way to delete a group of transactions, 
I think that's one of the shortcomings of GC?
You can do a search to find all of them using the right criterion but 
I'm pretty sure after that you can't really do much with that (except 
create a report which isn't useful for you).


But maybe the experts know of a way.

One useful feature would be the ability to delete/move transactions in a 
search result, since GC does not allow selecting multiple transactions 
and acting on them (to move them to a new account / delete them etc) 
doing it on the result of a search could be a useful workaround.


J


On 4/15/22 11:00 AM, Jeff wrote:

I need to move transactions from from one set of books to another one.

I didn't realize while entering transactions in my dads books that 
they should have gone into mine.  My dad opened a bank account that I 
did not know about until I started entering charges that my son made 
with feed stores (debit card).  I had not been informed about the bank 
account that grandpa opened in my sons name, and I am responsible for 
all of his income/debits until he is 21.  And many of these 
transactions affect my income/loss.


Is there an easy way to move those entries from one journal to the 
other or will I have to find all of them and manually delete them from 
one journal and reenter them in mine?  These are separate journal files.



___
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] Reconciliation discrepancies

[Jean Laroche]

One potential source of problem is banks that mess up the unique 
identifier of downloaded transactions.
In my case Citibank is inconsistent in assigning a unique and constant 
FITID for each transaction. So if I re-download transactions, there's a 
chance that the FITID of a previously downloaded transaction will not be 
the same as the first time I downloaded it. This means GC will think 
it's a new transaction and I'll end up with a duplicated transactions 
and failure to reconcile.


This was so annoying I had to write a small python script to correct the 
issue myself in the ofx file before importing it in GC.


Jean

On 4/12/22 4:16 PM, John Layman wrote:

I've been using GnuCash for 12 years and have rarely had a reconcile
discrepancy that could be blamed on the software (that was a date bug that
reared its head a while back - quickly corrected).  And the incidence of
error on the bank's part has been extremely rare.  Most occasions when I've
encountered a sizable imbalance have been due to transactions I bungled by
inadvertently entering them with a munged date.  The faulty entry has
eventually been found lurking back in time among previously balanced data.
The GnuCash reconciliation process displays the beginning balance, and I've
learned to first double check that number and the reconciliation date for
correspondence with the bank statement when there is an imbalance.
Searching the account for unreconciled transactions is a good way to reveal
any junk entries that were inadvertently plunked down back in time.

In my experience, whenever you encounter something puzzling in GnuCash, the
most likely cause is user error or a failure to RTFM.

-Original Message-
From: gnucash-user 
On Behalf Of Rich Shepard
Sent: Tuesday, April 12, 2022 8:49 AM
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Reconciliation discrepancies

On Tue, 12 Apr 2022, Liz wrote:


By looking at such a small number of transactions it is possible to
find whatever the errors are. I too have been on Gnucash for a couple
of decades, but still found 4 errors in one file this March, payments
not entered as received, and digit transposition.

Liz,

The reason I started this thread is all transactions for the month match. No
switched digits, no missing GnuCash transactions. And, now and then during
the month I check the accounts on the bank's web site and marked GnuCash
transactions as cleared as they appear on the bank's web page.


I hope you find what is happening and let us know.

Based on everyone's response my assumption that it's something unknowable at
the bank's side seems to be confirmed.

Thanks,

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

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

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

Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

[Jean Laroche]

I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to have 
0200 as their time; subtracting 5 hours from that would return -3 o'clock (and presumably 
shift the date back one).


You could do a test where you modify your OFX file to remove [-5:EST] 
from all transactions (you can do that easily in an editor), then try to 
import it and see whether this fixes the dates.


After that the question is whether that [-5:EST] is valid or not.
Jean


On 1/11/22 11:59 AM, D. via gnucash-user wrote:

But EFT transactions (which are the bulk of my txns these days) shouldn't get 
shifted around much at all. I'd be miffed if every EFT entry were a day off.


 Original Message 
From: Gyle McCollam 
Sent: Tue Jan 11 13:33:51 EST 2022
To: "D." 
Cc: "gnucash-user@gnucash.org" 
Subject: Re: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I find my dates usualy do not agree with the bank dates.  I record credit card 
bills when I pay them (electronically) and they are recorded by the payee on 
the same date.  However, they usually hit my bank the next banking day.  This 
isn't and shouldn't be a problem or concern.  Actual physical checks take even 
longer to show up at the bank.  This is all normal.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on behalf of 
D. via gnucash-user 
Sent: Tuesday, January 11, 2022 1:20 PM
To: David Carlson 
Cc: GnuCash 
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I'd be annoyed at the shift.

I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to have 
0200 as their time; subtracting 5 hours from that would return -3 o'clock (and presumably 
shift the date back one).


 Original Message 
From: David Carlson 
Sent: Tue Jan 11 12:53:59 EST 2022
To: "xraive ." 
Cc: Gnucash Users 
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Your bank creates the Ofx file.   Gnucash just accepts what they give you.
Sometimes it may appear to be incorrect when it is a misunderstanding about
whether transactions are posted on the same day they occur.

Does it really make a difference?




On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:


I downloaded transactions from my bank (TD) in Canada and when I tried
importing the file into GNUCASH all the dates were set to one day earlier
then the actual transactions.  I'm including sample transactions below.

OFX file imported to GNUCASH


DEBIT
2021072202[-5:EST]
-14.64
21203175847980020
Best Buy


CREDIT
2021072602[-5:EST]
21.83
2120719980010
Home Depot


Any help would be greatly appreciated.  If you need additional information
please let me know.

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


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

___
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 

Re: [GNC] Gnucash import QIF issue

[Jean Laroche]

How did you create these traces?

They don't seem to indicate a crash. Did you get them right after the 
crash happened?


Jean

On 1/10/22 2:22 PM, subscr...@nock.org.uk wrote:

Thanks very much for your quick response and assistance.

Tracefiles attached and hopefully these will help.

Bearing in mind what it says about the difficulty in getting the Stack_Trace
files I hope this will do but if you do need more then I will get them to
you once you let me know.

Using latest version of Gnucash downloaded this morning i.e. 4.9  on Windows
10 Home with all updates 19043.1415

RAM 32GB
Processor Intel(R) Core(TM) i7-4770K CPU @ 3.50GHz   3.50 GHz

Robert Nock
01600 580807

-Original Message-
From: gnucash-user
[mailto:gnucash-user-bounces+subscribe=nock.org...@gnucash.org] On Behalf Of
Jean L
Sent: 10 January 2022 16:52
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Gnucash import QIF issue

Can you do a bit of debugging?
https://wiki.gnucash.org/wiki/Stack_Trace
https://wiki.gnucash.org/wiki/Tracefile
That way we can get a chance to see where the crash happens. Another
option is to send your qif file to one of us for us to repro the issue,
but that's probably not something you want to do for privacy reasons.

Jean


On 1/10/2022 4:21 AM, subscr...@nock.org.uk wrote:

I am trying to import a QIF file from Quicken XG 2004 for the UK.

   


Loading the file etc seems to be fine and I can get through all the option
windows.   It.

   


The import starts OK and gets about half way (having taken many minutes as
the QIF file is 11MB with transactions back decades) and then just closes
leaving no Gnucash window.

   


Restarting Gnucash just takes me back to the beginning option to import a
file etc.

   


Have tried twice and both times with same result though I have not

actually

seen the moment the window closes.

   


Any ideas?  What can I do to work out what the problem is?

   


Thanks a lot,

   


Bob

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see

https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

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

Re: [GNC] Incorrect QFX Import

[Jean Laroche]

GC will not import an ofx transaction it thinks it already has imported. 
To determine whether a transaction has been imported GC looks at the 
FITID. So if two transactions in your OFX file have the same FITID, the 
second one won't be imported.


Can you check that the transactions that are missing don't have the same 
FITID as some of the transactions that were imported?
Some banks are not good at assigning unique FITID to transactions, and 
that can cause a problem for GC.

Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:

Additionally, I tried exiting GnuCash and trying the import again.  This
made no difference.

On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:


I downloaded all of 2021's transactions from my bank in QFX format and
tried to import the file.

As I was doing so, I noticed an anomaly.  I receive monthly direct
deposits from a pension, all arrive on or shortly after the first of each
month, the same amount every month. But on the QFX import screen, only 5 of
the months showed the deposit,
for January, May, August, September and December.  The other seven months
were not on the import screen. I tried sorting by date, by amount, by
description - they aren't there.

In an attempt to learn what was going on, I first checked my bank
statements.  Was the pension not being deposited?  No, that wasn't it, the
deposits came in every month as they were supposed to. I then opened the
QFX file in a text editor to see if the deposits were listed in the QFX.
They all were.  So I am trying to understand if there's a bug in the import
function that would throw these transactions away.

Here are the QFX entries from December and November. Perhaps someone
looking at them can tell me why the first one was accepted and the second
not? I see no important difference.


CREDIT
2021120112[0:GMT]
1772.79
202112010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



CREDIT
2021110112[0:GMT]
1772.79
202111010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



___
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] QFX import: transaction matching NOT learning to match

[Jean Laroche]

Make sure you do the assignment during the matching, in the matching 
window. Not after matching is all done in the registry (in which case GC 
does not learn anything).


Jean

On 11/4/21 5:13 PM, David Mintz wrote:

Hello,

I am running Version: 3.8 Build ID: 3.8b+(2019-12-29) and when I import a QFX, nearly all the transactions are 
assigned to "Imbalanced" even though I have gone through multiple iterations of trying to teach GC to 
recognize transactions by assigning the accounts manually. I have seen earlier postings about this, but the most 
detailed discussions were serveral years ago, and the most recent says, in substance, "just keep 
trying". I hesitate to do that because I fear it's a fool's errand. How many times do I need to tell it 
"Stop & Shop" belongs to Expenses:groceries?

One strange detail:  I tend to neglect my financial record-keeping for months 
at a time, but as I recall, I was not having this problem a few months ago. It 
seems to be a case of *it used to work but now it doesn't.*

I've read that it may be that it thinks "Imbalanced" is the answer, and cannot 
unlearn. Is there a any way to wipe the slate clean, so to speak, and force GC to start 
over so?

I've also seen that people have written Perl scripts to run against their data 
files and yeah, I could try that -- but I'd much prefer to get GnuCash to work 
properly without having to intervene this way.

Any suggestions?

Gratefully,

David


---
David Mintz
https://davidmintz.org
Capitalism has failed. https://wsws.org
___
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] QFX Import in 4.8

[Jean Laroche]

No, there isn't such an option at this time. I agree that that's an 
annoying side effect of a change that was added for this version to fix 
an import bug.

I think I'll have to fix this.

Jean

On 10/7/21 10:11 AM, Dale Alspach wrote:

This is for the flatpak install of version 4.8 on linux mint.
I just downloaded transactions from TIAA and when I imported, I was
presented with a sequence of 16 screens (some containing only 1 line) that
I had to OK. Each screen had transactions for a single security. I much
prefer getting a single screen with multiple lines as in earlier versions.
Is there an option somewhere to revert to the earlier behavior?
Dale
___
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] Mortgage & Loan Repayment Assistant woes

[Jean Laroche]

Well it looks like you found a bug! :)
Your payments should *not* be the same if going monthly rather than 
by-weekly.


Can you open a bug? Possibly here?
https://bugs.gnucash.org/buglist.cgi?component=Scheduled%20Transactions_id=13393=GnuCash=---
With all the info you put here?

Thanks,

Jean

On 9/16/21 1:22 PM, Chris Mitchell wrote:

On Thu, 16 Sep 2021 10:39:10 -0700
Jean Laroche  wrote:


The fact that the interest amount is twice as much seems to indicate
to me that GC does not do the proper calculation given your
every-two-week frequency.
That would happen I think if GC thought you're paying your mortgage
every month instead of every two-weeks.

Could you try doing the same with a monthly schedule, instead of
two-week schedule and see if what you get seems right?
That would help debug the issue.
Jean


My Gnucash version is 4.4 (more specifically 4.4+(2020-12-28) running
on Debian); thanks for reminding me to mention that, Stan!

Jean, I tried setting the payment frequency to monthly, leaving
everything else exactly as it was. All of the payment amounts remained
exactly the same; only the dates changed.

The formula showing for "Amount" is exactly the same as before.

Assuming that my hypothetical monthly total payment, interest portion,
and principal portion should all be 26/12 × my actual biweekly amounts:

* The total payment amount is roughly 1.75× what I would expect;
* The interest portion is about what I would expect;
* The principal amount is thus way too high;

Let me know if there's any more info I can provide.

Cheers!
  -Chris

___
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] Mortgage & Loan Repayment Assistant woes

[Jean Laroche]

The fact that the interest amount is twice as much seems to indicate to 
me that GC does not do the proper calculation given your every-two-week 
frequency.
That would happen I think if GC thought you're paying your mortgage 
every month instead of every two-weeks.


Could you try doing the same with a monthly schedule, instead of 
two-week schedule and see if what you get seems right?

That would help debug the issue.
Jean

On 9/16/21 10:31 AM, Chris Mitchell wrote:

Hi all,

I can't seem to get my mortgage repayment scheduled transactions set up
correctly, even though I *think* my mortgage is pretty close to the
simplest possible case.

* It's a fixed interest rate;
* The payments are only principal & interest, no tax/escrow/etc;
* Every two weeks I make a blended payment with a known, fixed total
   amount;
* I have from my bank a schedule of payments so far this year,
   projected payments, balance after every payment, etc

On the Loan Details page, I select the mortgage account, enter the
current balance remaining in the "Amount" field, and enter the interest
rate (selecting "Interest rate" and type "Fixed" on the accompanying
dropdowns). For the start date I put in today's date, for both "Length"
and "Months remaining" I provide what Libreoffice Calc's "Months"
function tells me is the number of months between today and the "Ending
Date" listed on the mortgage paperwork from my bank.

On Loan Repayment Options, no boxes are checked off.

On Loan Repayment, I give the transaction a name and select the
appropriate accounts for where the payment comes from and where the
interest goes, then specify the frequency (every 2 weeks, on Thursday,
starting today). The "Amount" field is a non-editable display showing a
formula that I don't understand, namely:
pmt( [MyInterestRate/100] / 12.00 : [MyMonthsRemaining].00 :
[MyPresentBalance] : 0 : 0 )

(Actual loan details redacted)

I recognize the values it asked me for, so that's good I guess. At no
point thus far do I see anything that I recognize as a place to enter
my *actual payment* amount, which strikes me as surprising.

Then I click "Next" and look at the list of generated payments. The
overall payment amount showing here is a little over three times my
actual payment amount, with the interest portion close to (but not
exactly) twice what it should be.

I assume Gnucash is doing the underlying math right, so the result
being so thoroughly wrong would seem to imply that I'm doing something
terribly wrong in the entry process. I've done it three times, double-
and triple-checked my values against the bank paperwork, and I'm
stumped.

Any help to get my scheduled transaction set up correctly without
having to go learn the whole "fundamental financial equation" business
(https://code.gnucash.org/docs/C/gnucash-guide/loans_calcs1.html) would
be gratefully welcomed.

Cheers!
  -Chris
___
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] Scheduled transaction frequency?

[Jean Laroche]

I'm not sure it's possible.

Jean

On 3/16/21 10:04 AM, gnu Gord wrote:

I'm trying to add a scheduled transaction that occurs 21 days after the
10th of each month.
With this timing, the transaction does not occur on a specific date in the
month. Some months it's on the 31st and some months it's on the first of
the next month, ETC

I can't figure out how to enter that in GnuCash.
___
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] Fwd: Gnucash xml file ope error

[Jean Laroche]

Your xml file must be corrupted one way or another?
Which version of GC are you using and which platform?
I wonder if there's some debugging info that can be enabled that would 
pinpoint which part of the file does not get parsed.


If I were you, I would check the xml file using a validation tool for 
xml. Most of these tools are online, so that's probably not great for 
you, but perhaps you can find one that you can download.

You'd have to save your data uncompressed (see the preferences)

Jean

On 3/1/21 2:10 PM, pellico wrote:

Please help.  How do I get tech support for this problem.  Thank you.
Richard Cinanni

 Forwarded Message 
Subject: Gnucash xml file ope error
   Date: Wed, 10 Feb 2021 10:06:16 -0500
   From: pellico [1]
 To: [2]gnucash-user@gnucash.org
Please help:
I've been using Gnucash for years.  This problem started late last
year.  I open my file and add a transaction, then the next time I try
to open it I get the attached error.
Seems that when I can open it, if I save it as a new file, it will open
and I can update.  Then the next open, fails.
Also, if it helps, there is no problem if I save it as SQL format file,
so must be an issue in the XML.
Thank you.
Richard Cinanni

References

1. mailto:pelli...@gmx.com
2. mailto:gnucash-user@gnucash.org

___
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] Scheduled Transaction Mystery?

[Jean Laroche]

For what it's worth, I tried to repro the problem, but failed to. So 
it's probably a bit of a tricky bug :(


J.

On 2/5/21 6:45 PM, David Carlson wrote:

Adrien, thanks for your comments.  I am a prolific user of SX's, I average
several per day.  The transaction count would not appear in the SLR dialog
unless it only counted the ones that had already happened when the dialog
appeared.  Since most transactions appear only after being approved for
creation in that dialog, I would expect the number to appear in the
'created transactions' window, but I do not recall seeing it there, so I
see that as part of the mystery.

I do get surprised from time to time, tho.  I just recently noticed that if
one pauses the mouse pointer over a 'y' letter in the reconciled box the
reconciliation date flies up.  Nothing happens over other letters in that
box.  Surprise!

You  are right that I use the XML data format.  Since I count that 'dirty
file' symbol as important, I would miss it if there were no other way to
tell if or how many changes had occurred since I last created a backup or
at least made a discrete file save..

On Fri, Feb 5, 2021 at 8:06 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


On 2/5/21 7:39 PM, David Carlson wrote>

I want to start with "... will tell me on start up
that it has created x number of scheduled txns. I can see the change in
value in the register but not the actual txn."

Where does GnuCash display that number?  I have never seen such a summary
transaction count or noticed an updated running total for any account in
any of the places that I might think to look for these changes.
Admittedly, I am currently still using release 3.8 in Ubuntu 20.04  Do I
simply not know where to look?

The Since Last Run Dialog perhaps? I'm not certain, I don't have any to
fire for a spell.

The main thing that I do see consistently is the appearance of the

asterisk

in front of the filename in the top banner which is supposed to mean that
GnuCash has done something that can be 'Saved".  When that asterisk

appears

after opening a file but before I have manually made any entries I assume
that the Since Last Run wizard did something.

An artifact of the XML backend. Anyone using a db backend won't see that
because changes are committed right away, there is no separate save
procedure.

I have never intentionally

configured any scheduled transaction to be created without a

notification,

but now and then the asterisk will appear without any Since Last Run

dialog

window appearing or any created transaction appearing in a results

window.

I believe that in trying to track that down I have even tried closing the
program without saving and seeing the warning that some change will be
lost, and if I proceed, the next time I start the program, the asterisk
will again spontaneously appear without any of the other artifacts.

I'm pretty sure Since Last Run only fires on start up. I found that out
after some time once I moved to MacOS and never shut GnuCash down. I
don't get the SXs to fire unless I manually run the dialog, or do a
restart of GnuCash.

Regards,
Adrien

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




___
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] Scheduled Transaction Mystery?

[Jean Laroche]

Can you describe how your scheduled trans is setup? x days in advance? 
enter automatically? On the nth of the month or specific date?

Any info to help repro the problem.

Jean

On 2/5/21 2:08 PM, Jack Slater wrote:
I doubt I can reproduce since I'm sure the dates and settings 
contribute to the error.  I'm guessing that if I start GnuC now it 
will be there.  I think the  bug isi in the timing with the date and 
lead time. My specific actions/results are in my first email.




On Fri, Feb 5, 2021 at 4:02 PM Jean Laroche <mailto:rip...@gmail.com>> wrote:


This is very strange, if you could do a simple repro, step by step, I
could take a look at it.
It definitely looks like a bug.

Jean


On 2/5/21 1:54 PM, Jack Slater wrote:
> Interesting. Sure seems like a bug to me.
>
> On Fri, Feb 5, 2021 at 3:38 PM Christina Martin
mailto:christ...@airgeadstudio.net>>
> wrote:
>
>> FWIW for about the last 18 months to 2 years, mine will tell me
on start
>> up
>> that it has created x number of scheduled txns. I can see the
change in
>> value in the register but not the actual txn. They didn't seem
to actually
>> display until something else happened and I could never figure
out what
>> the
>> something else was. My work around is to start it, allow the
scheduled
>> txns
>> to run, save it and close gnucash. When I reopen, everything is
happy. Yes
>> it's tiresome but it's working for me. I can't recall if this
started
>> occurring before the upgrade to 4.xx or not.
>>
>> Regards,
>> Christina
>>> Message: 1
>>> Date: Thu, 4 Feb 2021 16:00:59 -0500
>>> From: "Derek Atkins" mailto:de...@ihtfp.com>>
>>> To: "Jack Slater" mailto:theillini...@gmail.com>>
>>> Cc: "John Ralls" mailto:jra...@ceridwen.us>>, gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>
>>> Subject: Re: [GNC] Scheduled Transaction Mystery?
>>> Message-ID:
>>> <19e311e6378fc91d60db8677af984288.squir...@mail2.ihtfp.org
<mailto:19e311e6378fc91d60db8677af984288.squir...@mail2.ihtfp.org>>
>>> Content-Type: text/plain;charset=utf-8
>>>
>>> Do you have the SX set up to notify you on creation?  If not,
it could
>>> create without telling you.
>>>
>>> -derek
>>>
>>>
>>> On Thu, February 4, 2021 3:36 pm, Jack Slater wrote:
>>>> Started it.
>>>>
>>>> Last Run Window did pop up and showed nothing. Closed it.
>>>>
>>>> No variables included.
>>>>
>>>> On Thu, Feb 4, 2021 at 2:11 PM John Ralls mailto:jra...@ceridwen.us>> wrote:
>>>>
>>>>> When you say you opened GnuCash, does that mean that you
started it? Or
>>>>> has it been running since before 2 February and you switched
to its
>>>>> window?
>>>>>
>>>>> If the former, when you started it for the first time did
the Since
>> Last
>>>>> Run window come up, what did it say about that transaction,
and what
>> did
>>>>> you do? Does the scheduled transaction have a variable that
requires
>>>>> user
>>>>> input?
>>>>>
>>>>> Regards,
>>>>> John Ralls
>>>>>
>>>>>> On Feb 4, 2021, at 10:48 AM, Jack Slater
mailto:theillini...@gmail.com>>
>>>>> wrote:
>>>>>> It should be listed in the register for sure regardless and
I have not
>>>>>> deleted it.  I simply opened GnuC and looked and its not there.
>>>>>>
>>>>>> On Thu, Feb 4, 2021 at 12:42 PM Jean Laroche
mailto:rip...@gmail.com>>
>> wrote:
>>>>>>> I think if you set it up to create x days in advance, when the
>>>>>>> transaction is created, the "last occurrence" is set to
the day of
>>>>> the
>>>>>>> transaction (no to the day it was created). So that would
explain why
>>>>>>> you see "Last occurrence 2/5/21".
>>>>>>>
>>>>>>> Is it possible that you somehow deleted the occurrence
that was
>>>>> created?
>>>>>>> J.
   

Re: [GNC] Scheduled Transaction Mystery?

[Jean Laroche]

But it's a bug that you have to go through these steps, right? (i.e., 
that they don't show in the register unless you close GC then open it 
again).


On 2/5/21 2:04 PM, Adrien Monteleone wrote:
Be sure for each transaction you want to see, you have the 'Notify me 
when created' check box marked.


Then when the Since Last Run dialog pops up on starting GnuCash (or 
manually run) there is a checkbox at the bottom of that window to 
"Review created transactions". Check it, then click the OK button.


You will get a register view with each transaction that was listed as 
'created' in the Since Last Run dialog.


Works for me every time.

Regards,
Adrien

On 2/5/21 3:38 PM, Christina Martin wrote:
FWIW for about the last 18 months to 2 years, mine will tell me on 
start up that it has created x number of scheduled txns. I can see 
the change in value in the register but not the actual txn. They 
didn't seem to actually display until something else happened and I 
could never figure out what the something else was. My work around is 
to start it, allow the scheduled txns to run, save it and close 
gnucash. When I reopen, everything is happy. Yes it's tiresome but 
it's working for me. I can't recall if this started occurring before 
the upgrade to 4.xx or not.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Scheduled Transaction Mystery?

[Jean Laroche]

This is very strange, if you could do a simple repro, step by step, I 
could take a look at it.

It definitely looks like a bug.

Jean


On 2/5/21 1:54 PM, Jack Slater wrote:

Interesting. Sure seems like a bug to me.

On Fri, Feb 5, 2021 at 3:38 PM Christina Martin 
wrote:


FWIW for about the last 18 months to 2 years, mine will tell me on start
up
that it has created x number of scheduled txns. I can see the change in
value in the register but not the actual txn. They didn't seem to actually
display until something else happened and I could never figure out what
the
something else was. My work around is to start it, allow the scheduled
txns
to run, save it and close gnucash. When I reopen, everything is happy. Yes
it's tiresome but it's working for me. I can't recall if this started
occurring before the upgrade to 4.xx or not.

Regards,
Christina

Message: 1
Date: Thu, 4 Feb 2021 16:00:59 -0500
From: "Derek Atkins" 
To: "Jack Slater" 
Cc: "John Ralls" , gnucash-user@gnucash.org
Subject: Re: [GNC] Scheduled Transaction Mystery?
Message-ID:
<19e311e6378fc91d60db8677af984288.squir...@mail2.ihtfp.org>
Content-Type: text/plain;charset=utf-8

Do you have the SX set up to notify you on creation?  If not, it could
create without telling you.

-derek


On Thu, February 4, 2021 3:36 pm, Jack Slater wrote:

Started it.

Last Run Window did pop up and showed nothing. Closed it.

No variables included.

On Thu, Feb 4, 2021 at 2:11 PM John Ralls  wrote:


When you say you opened GnuCash, does that mean that you started it? Or
has it been running since before 2 February and you switched to its
window?

If the former, when you started it for the first time did the Since

Last

Run window come up, what did it say about that transaction, and what

did

you do? Does the scheduled transaction have a variable that requires
user
input?

Regards,
John Ralls


On Feb 4, 2021, at 10:48 AM, Jack Slater 

wrote:

It should be listed in the register for sure regardless and I have not
deleted it.  I simply opened GnuC and looked and its not there.

On Thu, Feb 4, 2021 at 12:42 PM Jean Laroche 

wrote:

I think if you set it up to create x days in advance, when the
transaction is created, the "last occurrence" is set to the day of

the

transaction (no to the day it was created). So that would explain why
you see "Last occurrence 2/5/21".

Is it possible that you somehow deleted the occurrence that was

created?

J.

On 2/4/21 10:19 AM, Jack Slater wrote:

Today is 2/4/21.
Transaction scheduled for the 5th of every month.
Looking at Scheduled Transactions, it reads Last Occurance 2/5/21.
Transaction options are set to Create Automatically and Create 3

days
in

advance.
No transaction listed in register.

Seems pretty illogical to me. What am I missing?
___

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


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

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

Re: [GNC] Scheduled Transaction Mystery?

[Jean Laroche]

I think if you set it up to create x days in advance, when the 
transaction is created, the "last occurrence" is set to the day of the 
transaction (no to the day it was created). So that would explain why 
you see "Last occurrence 2/5/21".


Is it possible that you somehow deleted the occurrence that was created?

J.

On 2/4/21 10:19 AM, Jack Slater wrote:

Today is 2/4/21.
Transaction scheduled for the 5th of every month.
Looking at Scheduled Transactions, it reads Last Occurance 2/5/21.
Transaction options are set to Create Automatically and Create 3 days in
advance.
No transaction listed in register.

Seems pretty illogical to me. What am I missing?
___
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] Missing Account(s) in Type-Ahead Search

[Jean Laroche]

Hi Adrien,

I wrote the new version of the type-ahead. One thing is that it only 
shows a small number of matches (to make it more responsive). Off the 
top of my head, I don't remember the exact number, but you could easily 
find out by just typing a "a" or a very common character and you'll see 
that the list does not include all accounts that have this character.


So I'm wondering if what you're seeing is a result of that?

For example when you say:
> When I type "gift" I get all of the savings accounts, all of the gift 
card accounts, and *some* of the gift expense accounts, and do not get 
the "Gifts Received" account at all.


I wonder if the number of accounts that you get in the match is equal to 
the max (and therefore "Gifts Received" is not displayed)


Jean

On 1/5/21 11:40 AM, Adrien Monteleone wrote:
Not sure if anyone else is seeing this, but I have several accounts 
that don't show up as expected in the type-ahead search when selecting 
an account for a split. (this is an awesome time saver by the way, and 
thanks again to whomever coded it!)


I can't seem to find anything special about these accounts to give a 
hint as to the problem. (none are marked as 'placeholder' or 'hidden' 
for example)


Some background:

I have several asset accounts to track various savings for gifts I 
need to purchase. (organized as "Assets::Savings:Gifts:etc.")


I have an additional set of several asset accounts to track balances 
on various gift cards I have received. (organized as "Assets::Prepaid 
Expenses:Gift Cards & Pre-Paid Cards:etc.")


I also have several expense accounts under an Expenses:Gifts node of 
my account tree. (for when I give gifts to others, organized as 
"Expenses:Gifts:etc.")


Finally, I have a single income account labeled as "Gifts Received" 
for when people give to me. ("Revenue:Gifts Received")



When I type "gift" I get all of the savings accounts, all of the gift 
card accounts, and *some* of the gift expense accounts, and do not get 
the "Gifts Received" account at all.


Once I get to "gifts" then every expected account *except* the "Gifts 
Received" account shows up.


If I proceed to "gifts " (with a trailing space) then, and only then 
does the search show the "Gifts Received" account, which is the only 
one shown as it is the only one with a space after 'gifts'.


A bug? Something wrong with my book?

___
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] American Express now forces you to use Quicken to download QFX

[Jean Laroche]

I'm also getting increasingly annoyed with all the financial 
institutions that are dropping OFX support in favor of exclusive quicken 
support.
At the moment, I have to download manually or semi-manually (using 
browser automation, which isn't a walk in the park) to get my data.


This is very frustrating.

Jean


On 1/4/21 12:16 PM, Steve Cohen wrote:
I've gone back recently to using my GnuCash and I need to download 
transactions from American Express.  Their website now wants to force 
me to go through Quicken to deactivate my account and reactivate it in 
order to get QFX data.


It's my data, not Quicken's.  That was the whole reason I started 
using GNUCash to avoid quicken.  How can I get my data now from 
American Express?

___
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] Missing payment items in OFX import from Bank

[jean laroche]

It could indeed be an FTID problem: if a transaction in the OFX file has 
an FTID (they are supposed to!) GC checks whether it has seen this 
transaction before (by looking at all previous transactions in the 
corresponding account). If it finds a transaction with the same FTID, it 
assumes you're re-importing the same transaction and it's just ignoring it.


So the issue *could* be that the transactions that GC ignores have FTIDs 
that already exist in the ledger transactions.
You could verify this hypothesis by opening the .gnucash file (go to the 
options, select saving uncompressed, which then allows you to see the GC 
file as plain text) and searching for the FTID of one of the 
transactions that are not being imported. (or by exporting all 
transactions to a csv file and checking there).
OR, you could hack the OFX file, change the FTID to a large string, and 
trying re-importing it. If it works this time, you'll know what the 
issue is.


Some banks have been known to re-use FTIDs which they're not supposed to 
do. That causes a problem for GC.


J


On 10/9/2020 9:47 PM, David Cousens wrote:

Has anyone else come across a problem importing payment information fro OFX
files for a credit cardGNuCash 4.2? I used to have no problem with this but
in bringing my accounts up to date I have noticed the importer is not
recognising a transaction which occurs in the OFX file. The transactions
other than payments I have made into the acount seem to be imported normally
but the following and similar record are not appearing in the Import matcher
window. In my case these normally match to transfers from a bank account
into my credit card which already exist as I generally import the bank
account records first but they usually come up in the import matcher as a do
not import however now they do not appear at all in the import matcher
window.

CREDIT
20200420
20200420
1400.00
N042009047838
PAYMENT RECEIVED, THANK YOU


Another similar payment record into the account on another date also failed
to be recorded and similarly in a previous import for the month before. Any
payment records do not appear to be recognized in the OFX file.  The records
matching these payments into the account are not marked as cleared "c" when
the records are imported. It may have something to do with FITID recognition
as all the records which are not being imported have  values whereas
all the records fo my purchases have a blank . Just want to check
that this is a general problem and not just my bank changing things before
reporting it as a bug.

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.


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

Re: [GNC] OFX import, wrong base account

[Jean Laroche]

Have you tried using Tools/Import Map Editor (in the tools menu)?
Select "Online" on the far right to change or remove OFX import account 
associations. Find the wrong one and remove it.

Jean

On 8/18/20 10:36 AM, brad wrote:
I'm still looking for ideas on this.   I'm comfortable unzipping the gc 
file and tweaking with a text editor if that's what needs to be done.



On 8/10/20 1:52 PM, brad wrote:
I tried to import an OFX from a different institution, a credit card 
this time, it was a bank last time.   It used the same account as the 
Source Account.
I tried a trick I found on the list from a decade ago, delete the 
account, and move all transaction to a new account.  No go.   Now it 
seemed to randomly pick another account as the Source Account.


On 8/10/20 12:57 PM, brad wrote:
I'm running my 1st OFX import since updating to 3.8 and the ofx 
import is going to the wrong base (source) account.    How do I 
change that??

I see this in the help
*|"GnuCash|* then opens an Account Selection dialog to select an 
account in your CoA to match to an account name in the import file. 
Select the appropriate account from the account tree and press the 
*OK* button. On subsequent import of files from the same source 
account, the mapped *|GnuCash|* account is remembered and the account 
selection dialog is not displayed."

But that doesn't help me reset it.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] OFX Import matcher user input memo / description enhancement

[Jean Laroche]

One drawback of your workflow is that GC does not learn how to better 
match incoming OFX transactions to your accounts, because you're doing 
that outside of the import matcher...
I guess you move them to UnAccountedFor2020 so you can go back to them 
at a later time, and take your time importing them to the right account...


I too would love to be able to add a note to the imported info *in* the 
matching dialog, rather than having to go to the register after the 
import to add notes...

J.

On 8/5/20 10:28 AM, Jeff Albrecht wrote:

Devs and users,

I want to add a short text entry somewhere on many of my transactions 
that are being imported and matched. Specifically if I bought some 
goodie, dodad or whatnot from ePay or Amizoned I'd like to add what the 
item was in my GNUCash check register.


_My Current Workflow_
Ignore monthly reminders to import .OFX
Do six to twelve months at a time
Download the .OFX from my bank
Import the .OFX
Match obvious like Netflix, utilities, grocers etc... that don't need a 
memo.
Move the remaining unmatched transactions into a temporary register, for 
instance 'UnAcountedFor2020' where I can add some arbitrary text to a 
memo or description field.
Then lookup transactions on the vendor websites and try to jog my memory 
what a a transaction was actually for. This may be handy for reordering, 
or explaining to my Accountant. For instance in the following image 
replacement nozzles for my pressure washer, this text string was copied 
from the vendor, Amazon, orders list item description. Copy and Paste.




Next I highlight the UnAccountedFor2020 and utilize the 4.x partial 
pattern matcher which again, is so COOL, such a time saver. (Maybe have 
a short list at the top of the picker of the last ten accounts selected? 
This would leave my hand on the mouse for many of the transactions)

I continue this until the UnAccountedFor2020 register is empty.
I've noticed that the yellow line which has the 'UnAccountedFor2020' is 
always blank in the memo/description. I put my desired text there.


_Enhancement_

If during the .OFX import matching some input box that I could enter my 
memo/description text would appear as I pick the proper matching 
account. Again that yellow line that has the desired target account is 
always blank in the memo/description and may be the likely candidate for 
the text target. If I could ad that user inputted text during the import 
transaction matching I wouldn't need to move desired transactions for 
memo/description into a temporary register as I do in my current work flow.


c ya...  - Jeff


___
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] Bravo! 4.x type-ahead search enhancement

[Jean Laroche]

I'm really tempted to make available everywhere... (it is not, currently)
J.

On 8/4/20 2:29 PM, Chris Graves wrote:

Hey Jean,

Another +1 for your type ahead improvements!

Chris

On Tue, Aug 4, 2020 at 1:44 PM jean laroche <mailto:rip...@gmail.com>> wrote:


Thanks for the feedback! It's always fun to read when users appreciate
the changes! :)

Jean


On 8/4/2020 1:17 PM, Samantha Payn wrote:
 > Wow! Sounds brilliant!
 >
 > Samantha Payn
 >
 >> On 4 Aug 2020, at 21:03, Jeff Albrecht mailto:je...@rodaw.com>> wrote:
 >>
 >> Thank you GNU developers!
 >>
 >> This feature is saving me so much time in my workflow.
 >>
 >> "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."
 >>
 >> Thanks again! - Jeff
 >>
 >> --
 >> Jeff Albrecht
 >> KF7CRU @jhalbrecht
 >>
 >> ___
 >> gnucash-user mailing list
 >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
 >> To update your subscription preferences or to unsubscribe:
 >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
 >> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 >> -
 >> Please remember to CC this list on all your replies.
 >> You can do this by using Reply-To-List or Reply-All.
 > ___
 > gnucash-user mailing list
 > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
 > To update your subscription preferences or to unsubscribe:
 > https://lists.gnucash.org/mailman/listinfo/gnucash-user
 > If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.

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


___
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] Bravo! 4.x type-ahead search enhancement

[jean laroche]

Thanks for the feedback! It's always fun to read when users appreciate 
the changes! :)


Jean


On 8/4/2020 1:17 PM, Samantha Payn wrote:

Wow! Sounds brilliant!

Samantha Payn


On 4 Aug 2020, at 21:03, Jeff Albrecht  wrote:

Thank you GNU developers!

This feature is saving me so much time in my workflow.

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

Thanks again! - Jeff

--
Jeff Albrecht
KF7CRU @jhalbrecht

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

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


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

Re: [GNC] OFX import settings

[jean laroche]

Did you try the import map editor in the Tools menu?

J.


On 7/28/2020 6:38 PM, Vinayak Vatsal wrote:

Hello,

GnuCash seems to have decided that OFX files downloaded from my bank for my 
Visa card are to be assigned to the top level Bank Account account by default. 
It used to work and go to the correct account, but the card was replaced, and 
now it doesn’t work any more.  I cannot find a setting that tells the program 
to associate these OFX files with the credit card account instead.

Can somebody please tell me how to fix this so that the OFX files are 
permanently associated to the correct account?

Thanks in advance,

Nike




___
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] Import Transaction Matcher issue in v4

[Jean Laroche]

Ah, OK I get it now!
Yes, you should check that from one day to the next, the FTID returned 
by citibank remains the same (for the same transaction). If not, then 
that's going to be a problem.
What has changed recently with GC is that it not will not match a new 
imported transaction with one from the register that has an online id. 
Previous versions allowed that, so in your case, it's quite possible 
that from one day to the next, the same transaction would be given a 
different ID, but GC matched it to the same register transaction that 
was previously matched.
So, on day 1, you'd match OFX1->Reg1, and on day two, you'd still match 
OFX2 -> reg1, even though reg1 had already been matched to OFX1 the 
previous day. So you'd see OFX2 appear as "match" and not "Add".


The correct behavior is that OFX2 actually has the same ID as OFX1, and 
it's entirely skipped by GC. But it seems that your bank is messing 
their online ID, and this is what's causing the issue for you, along 
with the new GC behavior.


I'm not sure how to fix your problem. It's clearly a bank issue but 
that's not terribly helpful as far as your problem goes. We should 
probably add an option to defeat the new GC import behavior, 
specifically for users like you whose bank send unreliable FTIDs/


FYI, the new GC behavior was added because the old behavior was causing 
issues with people who had recurring daily transactions: imagine buying 
a cup of coffee every day: in that case GC will match all daily cups of 
coffee to the same register transaction (within a date range, of course) 
instead of adding the new one every day (which really is the correct way 
to do it).




Jean


On 7/27/20 2:45 PM, Fross, Michael wrote:

Hi Jean.  Let me try to better explain my issue.

On most days, I download QFX files from my Checking and Credit Card 
accounts and import them.  In this way I clear transactions and I can 
see what's going on.  The next day I'll do so again, and the importer 
skips those that have already been matched per your comment.s  I've been 
doing this for years and it's worked well.


Since I updated to V4 the transactions that would have matched 
previously now come up with "Match Missing!" in the importer.  I don't 
want to add them as they would create duplicates.  Transactions that are 
not cleared seem to be able to be matched.  But those that are 
previously cleared get the "Match Missing!" issue.


Now, based on what you told me, the QFX file for a problem transaction 
has a FITID that is one higher than the ONLINE_ID in the gnucash file 
for the same transaction.  So the Match Missing items seems to be correct.


If I duplicate the transaction, delete the original, it matches which I 
assume is because there is not an ONLINE_ID associated with the new one.


What I don't understand is if there is an issue with GNUCash, which is 
why I asked if others are having the same issue, or if it is/was an 
issue with CITIBANK QFX files.  If they changed the FITID for some 
reason that would cause this.  Since no one else has said they are 
having the issue, I'm assuming this is not a GNUCash issue.


Does that better explain the issue?

I really appreciate the time to respond and help me through this.

Michael






On Mon, Jul 27, 2020 at 3:50 PM Jean Laroche <mailto:rip...@gmail.com>> wrote:


There's a misunderstanding here.
This is what GC does:
- It looks at the OFX transaction, which always has an FITID.
- IF GC sees this FITID in one of the register transactions, it skips
the OFX transaction, because it's already been imported (when a
transaction gets imported from the ofx, the online_id is copied into
the
register transaction, that's how GC remembers it's already imported the
transaction).
- If the FITID is not found in the register, GC assumes that this is a
new transaction and attempts to match it with existing transactions in
your register. BUT:
     . It only looks at register transactions that have NO FITID (i.e.,
register transactions that you entered manually, typically)
     . Among those, it looks for transactions that match pretty closely
for the date and the amount.
     . It picks the one with the highest matching score, if that
score is
above a user-adjustable threshold.

So in the case you outline below, if the register transaction has the
same FITID as your ofx transaction, the ofx transaction will NOT be
imported (it will be just skipped).

I think I don't quite understand the problem you're having. Is it that
you're importing OFX transaction and they're not matching register
transactions that you entered manually?
Or is it that they're being imported despite the fact they were
imported
previously?

J.

On 7/27/20 1:31 PM, Fross, Michael wrote:
 > Thanks Jean / John for your thoughts.  There is a register entry
that
 

Re: [GNC] Import Transaction Matcher issue in v4

[Jean Laroche]

There's a misunderstanding here.
This is what GC does:
- It looks at the OFX transaction, which always has an FITID.
- IF GC sees this FITID in one of the register transactions, it skips 
the OFX transaction, because it's already been imported (when a 
transaction gets imported from the ofx, the online_id is copied into the 
register transaction, that's how GC remembers it's already imported the 
transaction).
- If the FITID is not found in the register, GC assumes that this is a 
new transaction and attempts to match it with existing transactions in 
your register. BUT:
   . It only looks at register transactions that have NO FITID (i.e., 
register transactions that you entered manually, typically)
   . Among those, it looks for transactions that match pretty closely 
for the date and the amount.
   . It picks the one with the highest matching score, if that score is 
above a user-adjustable threshold.


So in the case you outline below, if the register transaction has the 
same FITID as your ofx transaction, the ofx transaction will NOT be 
imported (it will be just skipped).


I think I don't quite understand the problem you're having. Is it that 
you're importing OFX transaction and they're not matching register 
transactions that you entered manually?
Or is it that they're being imported despite the fact they were imported 
previously?


J.

On 7/27/20 1:31 PM, Fross, Michael wrote:
Thanks Jean / John for your thoughts.  There is a register entry that 
matches, IMHO, very closely.   I increased the Match Display Threshold 
from 1 to 3, and then to 6 (which appears to be the highest value 
allowed.)  Every transaction from the import says "Match Missing."


Digging around a bit, for the transaction in question, the QFX file 
contains the FITID of 202007210003:



CREDIT
2020072112
54.00
202007210003
ACH Electronic Credit
Expenses


My GNUCash file contains, for the same transaction has the online id 
being 202007210002

         
           
             online_id
             202007210002
           

The online_ID is ...002 instead of ...003.  Changing the QFX file to 
match the online_id value seemed to work.  Now my question is why would 
this be different for *lots* of transactions.  Everything worked 
normally in v3, but this would not have changed as part of the release.  
I'll check a few more problem transactions and see if I can detect a 
pattern.  Perhaps Citibank is paying games


Michael

On Sun, Jul 26, 2020 at 4:57 PM jean laroche <mailto:rip...@gmail.com>> wrote:


To get a match you have to have a transaction in the register that's
sufficiently similar to the one you're importing, and that has not been
imported/matched before.
In your case, it could be one of these reasons (I can't see the image):
- There's no matching transaction in your register (no existing
transaction has amount close, and a date close to the imported one)
- There's a matching transaction but it's already been matched to an
imported transaction at some point so it's not available to be matched
to the new imported one.
- There's a matching transaction that's available, but the match score
is below the threshold that allows the transaction to be shown as a
potential match. Too large a date mismatch can cause that.

Can you check whether you're in one of these 3 cases? If you're in case
3, you can lower the minimum matching threshold in the preferences and
see if that helps.
J.


On 7/26/2020 2:44 PM, John Ralls wrote:
 > If there's no matching transaction already in the account then
there's nothing to clear. In that case only adding or not makes sense.
 >
 > Regards,
 > John Ralls
 >
 >
 >> On Jul 26, 2020, at 1:56 PM, Fross, Michael mailto:mich...@fross.org>> wrote:
 >>
 >> Hello all,
 >>
 >> I sent this earlier this month and didn't see any reply so I
thought I
 >> would try again.   Has anyone else seen these issues?  I use
Citibank and
 >> perhaps it's a Citibank issue, but I did not have this problem
on v2 or v3.
 >>
 >> Thanks all.  I appreciate the help.
 >>
 >> Michael
 >>
 >>
 >> On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael mailto:mich...@fross.org>> wrote:
 >>
 >>> Hello all,
 >>>
 >>> I typically download QFX files from my banks every day or two,
import them
 >>> to clear them in Gnucash.  Worked great.  However, ever since
upgrading to
 >>> v4, the importer seems to have trouble matching.  Most of the
imported
 >>> transactions are listed in the importer as (A)dd, but when I select
 >>> (C)lear for them it says match missing.
 >>>
 >>> This has occurred for seve

Re: [GNC] Import Transaction Matcher issue in v4

[Jean Laroche]

No,
>> - There's a matching transaction but it's already been matched to an
>> imported transaction at some point so it's not available to be matched
>> to the new imported one.

This means, if you re-import the same file, the register transactions 
that were previously imported are marked as having been matched/imported 
(they have an online-id), and they're not available to be matched.
But more importantly, the ofx transaction is recognized as having been 
imported before because its online id is already in the register so the 
ofx transaction is skipped entirely.

Jean


On 7/27/20 9:52 AM, Adrien Monteleone wrote:
This appears to mean that if a subsequent import file contained a 
duplicate transaction for some reason, (or the user accidentally 
selected an already imported file) then duplicates would be imported. Or 
am I reading that wrong?


Regards,
Adrien

On 7/26/20 4:56 PM, jean laroche wrote:

- There's a matching transaction but it's already been matched to an 
imported transaction at some point so it's not available to be matched 
to the new imported one.


___
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] Import Transaction Matcher issue in v4

[jean laroche]

To get a match you have to have a transaction in the register that's 
sufficiently similar to the one you're importing, and that has not been 
imported/matched before.

In your case, it could be one of these reasons (I can't see the image):
- There's no matching transaction in your register (no existing 
transaction has amount close, and a date close to the imported one)
- There's a matching transaction but it's already been matched to an 
imported transaction at some point so it's not available to be matched 
to the new imported one.
- There's a matching transaction that's available, but the match score 
is below the threshold that allows the transaction to be shown as a 
potential match. Too large a date mismatch can cause that.


Can you check whether you're in one of these 3 cases? If you're in case 
3, you can lower the minimum matching threshold in the preferences and 
see if that helps.

J.


On 7/26/2020 2:44 PM, John Ralls wrote:

If there's no matching transaction already in the account then there's nothing 
to clear. In that case only adding or not makes sense.

Regards,
John Ralls



On Jul 26, 2020, at 1:56 PM, Fross, Michael  wrote:

Hello all,

I sent this earlier this month and didn't see any reply so I thought I
would try again.   Has anyone else seen these issues?  I use Citibank and
perhaps it's a Citibank issue, but I did not have this problem on v2 or v3.

Thanks all.  I appreciate the help.

Michael


On Sat, Jul 4, 2020 at 9:48 AM Fross, Michael  wrote:


Hello all,

I typically download QFX files from my banks every day or two, import them
to clear them in Gnucash.  Worked great.  However, ever since upgrading to
v4, the importer seems to have trouble matching.  Most of the imported
transactions are listed in the importer as (A)dd, but when I select
(C)lear for them it says match missing.

This has occurred for several accounts.  Here is a simple credit card
example, although for my checking account, there are dozens like this.  The
top portion shows the register with the Sprint bill cleared.  The date,
amount, and name (mostly) match.

[image: image.png]

Not sure if there is just something wrong with my setup or not.  Perhaps a
bug?  Are others experiencing this?  Any ideas to get the matcher matching
again?  Something need to get cleared out?

For those of us in the US, happy Independence Day.  Thank you all for your
assistance.

Michael


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

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


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

Re: [GNC] BotanyBayGardens nonprofit example, and why GnuCash does not suffice

[jean laroche]

Thanks for the very detailed analysis of Gnucash's shortcomings for 
nonprofits (and other businesses).

I'm not an accountant either, barely a computer scientist.
If I were to summarize the areas where GC falls short, it seems to me GC 
is missing:

- Support for Job Costing
- Cash Flow reporting isn't what it should be.

Could the original poster (Don) confirm that these two features, if 
fixed/implemented would go a long way toward making GC more suited for 
nonprofits?


Perhaps the developers (including me, in a  modest manner) could then 
discuss whether these would be easy to add/fix. Perhaps these features 
have been discussed in the past? Job costing, in particular, may not be 
that hard to implement? The Cash Flow reporting might also not be too 
hard to fix, once the OP specifies exactly how it should be done, ideally.


Jean


On 7/24/2020 10:03 PM, w...@theprescotts.com wrote:

I have a few comments on this long post. I will preface it by admitting that I 
am neither a tax attorney nor an accountant. I have kept my personal accounts 
in GnuCash for many years. I am the treasurer for two non-profits, or more 
accurately, two subsidiaries of one non-profit. But neither of them are legal 
entities nor in the US. Legally, they are probably more akin to informal 
associations.

The suggestions for falsifying the dates of transactions for convenience in 
accounting strike me as very bad advice. Is it even legal for an organization 
that has to abide by US tax laws.

Similarly, I don't understand the advice to just treat Paypal transactions as 
if they were directly on checking. This would make accounting for Paypal fees 
strange. For organizations outside the US, Paypal no longer holds funds; they 
transfer them immediately, so the Paypal balance is always zero except for 
immediately after a deposit to Paypal. Even so, it is much easier to track 
activity treating Paypal as a bank account.

Finally, I don't understand the suggestions about not having a cash account and 
immediately depositing all cash to checking. Perhaps it is partly because I 
live in a country where many transactions are still done with cash, where no 
one uses checks, just bank transfers. But I often accept donations in cash, and 
often pay bills in cash. Not accounting for those transactions directly would 
be neither accurate nor convenient.

Will

On 2020 Jul 24, at 07-24 22:13:26, doncram  wrote:

Here is an example set of accounts set up as best possible for a real
nonprofit, "Botany Bay Gardens".  This might be enough guidance for a few
nonprofits.  But I explain why/how GnuCash usually fails for nonprofits,
how it usually cannot serve them well enough, so a Treasurer coming here
should probably decide to use Quickbooks (in its Pro version, or in a
version packaged for Nonprofits) instead.  Unfortunately the visiting
Treasurer's time is usually wasted, even more so if they proceed with
trying to implement GnuCash, because they can't tell in advance how it will
not work. I wish GnuCash would make a few changes, so nonprofits could be
served.

Recently Fiona and Joshua (and last year BigAl) asked questions about
how/whether GnuCash accounts could be set up to handle a nonprofit.  Here's
how: see the attached Chart of Accounts, Balance Sheet, and Income
Statement, for a real nonprofit, "Botany Bay Gardens" (not its real name),
and the following notes:

1. Setting this up in GnuCash just now did not take me terribly long, but I
already knew well what are the accounts that are needed and how I want them
organized.  This is in the United States. I previously reviewed some
similar but bigger nonprofits reporting in their publicly available U.S.
Internal Revenue Service Form 990 financial statements filings.  And I
worked with the board and determined how their previous reporting system
did not work for them, as well as how it would not work well for their IRS
990 reporting which they are soon required to start, because the nonprofit
is growing over the reporting requirement threshold.  Take some time and
design out your own chart of accounts in a spreadsheet, and revise as
necessary with others' input.

2. You have to use account numbers (which are optional in GnuCash and in
Quickbooks, but if you use them, they set the order) to make your reports
presentable, with ordering that makes sense for your organization.
Otherwise the default alphabetical order is maddening.

3. I prefer to set up one "Placeholder"-type account titled "Cash", which
in this case contains two items:  the organization's checking account and
its investment account with a local foundation (which charges fees but
handles investment of spare funds and assists in fundraising in various
ways).  These are both convertible easily to real cash.  I don't use a
"Petty Cash" account, because any cash collected in this nonprofit, say at
a fundraising event, should be promptly deposited into the checking
account.  You don't want to record each tiny separate addition to 

Re: [GNC] Importing Transactions from Bank

[Jean Laroche]

GC does not re-import transactions that have previously been imported.

On 7/20/20 2:43 PM, Jon Griffith wrote:

Is Gnucash smart enough to recognize transactions that have already been
imported, or do we have to keep tight tabs on the import date range?


___
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] Reconcile also opens Interest Payment box?

[Jean Laroche]

I'd like a preference somewhere to activate/inactivate the Interest Payment
pop-up appearing automatically on an account by account basis. I'd like the
"Enter Interest Payment ..." button to remain as I have used it a couple of
times, but that when it has been used it won't then mean it appears
automatically the next time, which would remove the need for the "No
Automatic Interest Payment" button.

Just my two penny worth.


Alan A Holmes

BTW, that's exactly what the current Pull Request implements: per 
account option, and the option isn't set silently if you decide to click 
"enter interest payment".

https://github.com/Gnucash/gnucash/pull/753
I think it's a reasonable compromise that keeps the feature around, but 
much better behaved.

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

Re: [GNC] AqBanking OFX DirectConnect issues

[jean laroche]

Thanks for mentioning that. I have completely given up on aqbanking 
within GC, I struggled mightily to make it work and failed, and decided 
to go the ofx way.

I personally use ofxclient, there's also ofxget.
But sadly recently my bank (Patelco) stopped their ofx server, there was 
a long discussion on this mail group about that.
I started using plaid, which is an api/service that collects 
transactions/balances etc from all your banks and makes them available 
to you. Not everybody is comfortable with that though.
Then I resorted to writing my own screen scraping python code to log 
into my bank, and download the ofx files automatically. I used python 
and selenium and selenium ide (an extension for Chrome and Firefox).

Definitely not ideal, but it works...
Jean.


On 7/15/2020 4:38 AM, fleur wrote:

Thanks for the info.  FYI If you know python, and are so inclined, there are 
OFX libraries you can use to generate those requests.  ofxtools is one.


fleur
--
Fleur Dragan / fl...@obscure.org





On Jul 12, 2020, at 11:11 AM, Dan Howell  wrote:

On Fri, Jul 10, 2020 at 09:21 AM EDT fleur  wrote:


I can't help unfortunately, but I'm having my own OFX setup issues and I'm
curious: What platform do you run GnuCash on?  Also, were you successful in
re-setting up your Chase account(s)?


As I said in my original message, I'm using GnuCash on Windows 10. Yes, I
was successful re-setting up the Chase account, by reusing the same Client
UID I generated when I first successfully set up the Chase connection
before the AqBanking upgrade.

So far, Schwab and Chase are the only banks I've had success in connecting
to. I may try again soon with some other banks, hoping the upgrade might
fix some issues I've had before, but given most U.S. banks reluctance to
work with any financial software not owned by Intuit, I'm not expecting
much. But now that I know how to generate OFX requests with cURL, I may
experiment more.

Thanks to Martin for fixing the  issue.

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


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


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

Re: [GNC] Reconcile also opens Interest Payment box?

[jean laroche]

Note that with the PR:
- There no longer a global pref for popping the interest transfer dialog 
prior to reconcile.

- There's a new per-account pref for this ^^ . Set to False by default
- In the reconcile window, there's still the button to open the interest 
transfer dialog
- In the interest transfer dialog, a button was removed (that was 
changing the preference).


So with the PR the interest transfer dialog should not pop up for you if 
it didn't before. If it does, the user has to go turn the preference off 
in the account edit dialog.


Jean


On 7/12/2020 3:35 PM, nvsoar wrote:

FWIW - For me the pop ups are confusing.  I delete and hope it works out.
A million thanks for a great application.
All the best from the Carson Valley,
nvsoar

On 07/12/20 15:15, jean laroche wrote:
The thing is, there's a good chance we won't know if somebody uses 
the feature and happens to not be on this forum, which is very likely.
So out of caution, I would err on the side of keeping it. The code 
bloat isn't enormous. In my PR I removed a bit of it, and simplified 
things a bit.
I know that as a user, I really dislike when features disappear... 
(if I happen to use them).
I think the onus is on us to justify why it's really bad to keep the 
feature.


Jean
P.S. Nobody's suggesting to remove reconciling! I think it was a 
misunderstanding from the start!



On 7/12/2020 3:02 PM, John Ralls wrote:

Larry,

Thanks for the offer, but I wouldn't want to turn our users into 
more product for survey monkey. Besides, I'm not looking for votes, 
I'm looking for reasons why removing the dialogs might be a bad 
thing. A single person with a persuasive reason would outweigh all 
of the "don't cares".


To your points: A Scheduled Transaction is an even better reminder 
and quick fill (aka autocomplete) in the register will fill in the 
last payment account too. What quickfill won't do is pre-populate 
the credit field with the reconciled balance.


Regards,
John Ralls


On Jul 12, 2020, at 2:11 PM, Larry Long  wrote:

John, I almost always pay off entire credit card balances, so I 
rarely ever use the "interest charge" pop-up.However, I do use the 
"interest earned" pop-up associated with bank accounts.
I find it a convenient reminder for me to enter that figure before 
I begin checking-off transactions in the reconcile 
window.Similarly, I use (and appreciate) the "payment transaction" 
pop-up window associated with credit card accounts.  The fact that 
it remembers and prepopulates my usual source account for the 
payment is also a handy convenience for me.

Could I do without these two features?  Certainly.
Do I find them helpful and time-saving for me? Yes.Compelling 
reasons?  While I find them helpful, I can't say that I have any.
If you want a survey of your users, I don't believe that this list 
is the best method.
I would suggest that you set up a free account on Survey Monkey, 
create your questions there and post a link on this list.  It will 
accumulate the results for you and is much less effort than trying 
to track responses here.
I'd be happy to create one for you based on what you asked below.  
However, if you wanted to write your own questions, it might be 
better for you to do it.
Meanwhile, a huge "Thank You" to you and the entire team for all 
the effort that you folks put into the software--and in answering 
questions on this list!

Regards,Larry Long


On Sunday, July 12, 2020, John Ralls wrote: > > Frank and I have 
both opined on https://bugs.gnucash.org/show_bug.cgi?id=797854 
that the whole
interest payment as part of reconciling is stupid. I want to add 
to that opinion that so is the payment
transfer that optionally pops up when one finishes reconciling a 
credit card account. It's a lot of
program complexity that relieves the user of very little work 
indeed: Those interest and payment
transactions can just as easily--maybe more easily--be created in 
the register before and after
reconciling, and in the case of interest they're an obvious 
candidate for a scheduled transaction.
But that's a UI change and UI changes tend to generate heated 
disagreement. I want to get that out
of the way up front: Who here objects to removing the interest and 
payment transfer automatic popups
and the interest payment button on the reconcile info dialog, and 
what compelling reason do you have

for objecting?

Regards,
John Ralls



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-

Re: [GNC] Reconcile also opens Interest Payment box?

[jean laroche]

The thing is, there's a good chance we won't know if somebody uses the 
feature and happens to not be on this forum, which is very likely.
So out of caution, I would err on the side of keeping it. The code bloat 
isn't enormous. In my PR I removed a bit of it, and simplified things a bit.
I know that as a user, I really dislike when features disappear... (if I 
happen to use them).
I think the onus is on us to justify why it's really bad to keep the 
feature.


Jean
P.S. Nobody's suggesting to remove reconciling! I think it was a 
misunderstanding from the start!



On 7/12/2020 3:02 PM, John Ralls wrote:

Larry,

Thanks for the offer, but I wouldn't want to turn our users into more product for survey 
monkey. Besides, I'm not looking for votes, I'm looking for reasons why removing the 
dialogs might be a bad thing. A single person with a persuasive reason would outweigh all 
of the "don't cares".

To your points: A Scheduled Transaction is an even better reminder and quick 
fill (aka autocomplete) in the register will fill in the last payment account 
too. What quickfill won't do is pre-populate the credit field with the 
reconciled balance.

Regards,
John Ralls


On Jul 12, 2020, at 2:11 PM, Larry Long  wrote:

John, I almost always pay off entire credit card balances, so I rarely ever use the "interest 
charge" pop-up.However, I do use the "interest earned" pop-up associated with bank 
accounts.
I find it a convenient reminder for me to enter that figure before I begin checking-off 
transactions in the reconcile window.Similarly, I use (and appreciate) the "payment 
transaction" pop-up window associated with credit card accounts.  The fact that it 
remembers and prepopulates my usual source account for the payment is also a handy 
convenience for me.
Could I do without these two features?  Certainly.
Do I find them helpful and time-saving for me?  Yes.Compelling reasons?  While 
I find them helpful, I can't say that I have any.
If you want a survey of your users, I don't believe that this list is the best 
method.
I would suggest that you set up a free account on Survey Monkey, create your 
questions there and post a link on this list.  It will accumulate the results 
for you and is much less effort than trying to track responses here.
I'd be happy to create one for you based on what you asked below.  However, if 
you wanted to write your own questions, it might be better for you to do it.
Meanwhile, a huge "Thank You" to you and the entire team for all the effort 
that you folks put into the software--and in answering questions on this list!
Regards,Larry Long



On Sunday, July 12, 2020, John Ralls wrote: > > Frank and I have both opined on 
https://bugs.gnucash.org/show_bug.cgi?id=797854 that the whole
interest payment as part of reconciling is stupid. I want to add to that 
opinion that so is the payment
transfer that optionally pops up when one finishes reconciling a credit card 
account. It's a lot of
program complexity that relieves the user of very little work indeed: Those 
interest and payment
transactions can just as easily--maybe more easily--be created in the register 
before and after
reconciling, and in the case of interest they're an obvious candidate for a 
scheduled transaction.
But that's a UI change and UI changes tend to generate heated disagreement. I 
want to get that out
of the way up front: Who here objects to removing the interest and payment 
transfer automatic popups
and the interest payment button on the reconcile info dialog, and what 
compelling reason do you have
for objecting?

Regards,
John Ralls



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

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


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

Re: [GNC] Reconcile also opens Interest Payment box?

[jean laroche]

Personally, I don't find this feature useful and indeed, it would 
simplify the code to just remove it...

Jean


On 7/12/2020 11:07 AM, Michael Hendry wrote:

On 12 Jul 2020, at 17:38, John Ralls  wrote:

Frank and I have both opined on https://bugs.gnucash.org/show_bug.cgi?id=797854 
that the whole interest payment as part of reconciling is stupid. I want to add 
to that opinion that so is the payment transfer that optionally pops up when 
one finishes reconciling a credit card account. It's a lot of program 
complexity that relieves the user of very little work indeed: Those interest 
and payment transactions can just as easily--maybe more easily--be created in 
the register before and after reconciling, and in the case of interest they're 
an obvious candidate for a scheduled transaction.

But that's a UI change and UI changes tend to generate heated disagreement. I 
want to get that out of the way up front: Who here objects to removing the 
interest and payment transfer automatic popups and the interest payment button 
on the reconcile info dialog, and what compelling reason do you have for 
objecting?

Regards,
John Ralls

I don’t use the interest feature, as I have the credit card paid off every 
month by direct debit, and have never paid interest.

I do use the automatic payment feature (from bank to credit card), and find it 
helpful, but not essential. If it were withdrawn I expect it would take a while 
to get out of old habits (ten years since I first started using GC!), but I’d 
cope.

Regards,

Michael

___
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] Reconcile also opens Interest Payment box?

[Jean Laroche]

If you open a bug about it, I can try to fix that (move things to the 
right place etc). At the very least, the global option should be either 
fixed, or removed.

Jean

On 7/10/20 3:35 PM, Adrien Monteleone wrote:
For consistency, that very wide button should probably either be changed 
to a checkbox, then moved or copied to the Account Edit page as a 
per-account preference. (it could remain in the dialog for 
discoverability I suppose, which is what I mean by 'copied') One could 
change it in either place, but ideally, it should be in one place.


I'm not sure a global preference (especially one that is ignored) is 
necessary if each account can be set separately.


Regards,
Adrien

On 7/10/20 5:16 PM, lj wrote:

I figured it out. Duh.

There is a button on the Reconcile dialog that says "Enter Interest 
Payment". In addition to letting you enter an interest payment, 
clicking that button sets a per-account flag to always prompt for an 
interest payment when you reconcile.


On the Interest Payment dialog, there is a button "No Auto Interest 
Payments for this Account". (It's very wide, and I didn't realize it 
was a button.) That cancels the dialog, and also clears the 
per-account flag so GnuCash will no longer prompt for interest payment 
when you reconcile.


And the global preference Register, Reconciling, Automatic interest 
transfer? It does NOTHING at all. It sets a preference flag which is 
never used. It's supposed to be the default for accounts without the 
auto-interest-payment flag, but it doesn't work. Note that in 
libgnucash/engine/Account.cpp, the function 
xaccAccountGetAutoInterestXfer() ignores its default_value argument.


___
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] Reconcile also opens Interest Payment box?

[jean laroche]

There's a Preference for that under Register, Reconciling
Jean

On 7/8/2020 2:54 PM, lj wrote:

Using GnuCash-3.10 on Linux, self-compiled (soon to upgrade to 3.11)

For just one of my accounts, the following odd thing started happening 
this month. I open the register and click Reconcile.  The expected 
Reconcile Information dialog box opens, but on top of that I get an 
Interest Payment box. Why would this pop up over Reconcile? Why only for 
one account? It started this month. What did I do to cause this?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
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] Best match probability calc is too pessimistic

[jean laroche]

Write a bug report, I'll take a look at it.
Jean


On 7/5/2020 12:11 PM, Jim DeLaHunt wrote:

On 2020-07-05 11:49, David Reiser via gnucash-user wrote:
…From my perspective, transactions posting within 3 days of the 
transaction date should still get a match score of 6. One day after 
transaction ought to be 8. One of the grocery stores I go to 
frequently has never posted the charge to the credit card company the 
next day. Sometimes there’s only a 2-day gap, but it is frequently 3 
days. I suspect the difference between 2 and 3 days is related to how 
late in the evening I go shopping.


And on the extreme end, for a checking account transaction, if the 
imported check number (complicated by bank-prepended zeroes) and 
amount match exactly, and the date in gnucash is within 180 days of 
the bank’s date, then the transaction should still have some usable 
match score. In the U.S., the bank will still pay that check. I have 
had friends sit on checks for excessive lengths of time.


David, I completely agree with you. I have been doing a lot of 
transaction importing from OFX recently, and it's a continuing problem 
that I can't trust the matcher to handle dates the way you describe.


Would you care to add a bug report for this into the bug tracker, 
 ? If so, I'll second it.


Best regards,
    —Jim DeLaHunt, software engineer, Vancouver, Canada


___
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] Import QFX Crashes GnuCash v4.0

[jean laroche]

It's a known bug which has already a fix but the fix needs to be 
incorporated into the next version.

Jean


On 7/4/2020 5:05 PM, Ted Phakias wrote:

I recently upgraded to version 4.0. When I attempt to import a QFX file
from my brokerage firm, the application crashes. How can I go about
troubleshooting this issue?


Importing a QIF file for a different brokerage firm works just fine.

Thank you


Sent from [1]Mail for Windows 10


Virus-free. [2]www.avg.com

References

Visible links:
1. https://go.microsoft.com/fwlink/?LinkId=550986
2. 
http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient

Hidden links:
4. 
http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=emailclient
5. file://localhost/tmp/tmp_WHfmE.html#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2
___
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] Bulk moving transactions

[Jean Laroche]

I started looking at that a little while before 4.0 and stopped because 
no new features could be added. I'm going to re-start, as this strikes 
me as a must-have feature.
The other elephant in the room is the undo/redo support, but that's for 
another thread

J.

On 7/1/20 1:32 PM, Derek Atkins wrote:


On Wed, July 1, 2020 4:27 pm, Jean Laroche wrote:

Does it not trike you as insane that we have to go through these hoops
just to bulk move transactions? Something that should be as simple as
shift-select, right-click, move?
I'm not sure how support for multi-select operations was never seriously
looked at.


Patches always welcome!

Seriously, it's not that easy due to the design and implementation of the
register.  The register-2 rewrite was supposed to make it easier, but that
effort (started about a decade ago) stalled and never finished, so we're
still using the same Canvas-based register code.


J.



Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


-derek


___
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] Bulk moving transactions

[Jean Laroche]

Does it not trike you as insane that we have to go through these hoops 
just to bulk move transactions? Something that should be as simple as 
shift-select, right-click, move?
I'm not sure how support for multi-select operations was never seriously 
looked at.

J.


On 7/1/20 1:09 PM, Adrien Monteleone wrote:

Sorry Michael, it was an oversight. I was not reading carefully. Geert pointed 
that out to me as well.

Apologies for the noise.

Regards,
Adrien


On Jul 1, 2020 w27d183, at 2:56 PM, Michael or Penny Novack 
 wrote:

On 7/1/2020 12:07 PM, Adrien Monteleone wrote:

I’ve twice now seen the advice to delete the account as a bulk move operation.

Yes, that does work.

However, this appears to be a parent account.

Can a parent account be safely deleted without affecting the sub accounts?

I guess I could try, just for kicks, (since I’m not the one needing to move 
transactions) but my initial suspicion is —that way lies a mess.


Did you read what I wrote? The process?

YES, you would want to first make this account NOT be the parent of its 
children. Once you have given them a different parent, they will no longer be 
the children of the account you want to delete.

Create a new placeholder account. Edit each child account so that this account 
is now its parent. THEN delete the account that had been the parent.

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.


___
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] Auto reconcile on OFX Import

[jean laroche]

ah ah ah! No worries man!


On 7/1/2020 5:31 AM, Matthew Forbis wrote:

I found it right where you said.  It turns out when I thought I had already 
upgraded to 4.0, I had downloaded the installer, but not gone through the 
installation.  I was still running one of the testing releases that didn't have 
the option.  As soon as I upgraded, it showed up.

Shame on me for not doing a better troubleshooting job first.


Thanks,
Matt






On Monday, June 29, 2020, 7:58:08 PM CDT, jean laroche  wrote:





I just checked. For me, if the check box isn't checked, I don't get the
reconciliation dialog.
The check box is at the bottom right of the transaction matching dialog
(the one that opens after you select the OFX file).

J.


On 6/29/2020 5:50 PM, Matthew Forbis via gnucash-user wrote:

Hi All,

I'm sure it's somewhere that I'm overlooking, but I can't find where to turn 
off the reconcile window that opens automatically when importing an OFX file. I 
know there was some discussion on the development list about the reconcile 
window automatically popping up when importing an OFX file early on.  I thought 
it was decided that this was select-able somewhere, but I can't seem to find 
where to turn it off.  I import my accounts at random times and not necessarily 
on the closing date of the statement, so I do not need it to reconcile 
automatically as I have cancelled every single time so far.

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

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



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

Re: [GNC] Bulk moving transactions

[Jean Laroche]

not that I know of. That's one limitation of GC that I would really love 
to fix (or see fixed). It's usually impossible to select multiple 
transactions and do something on them (except in a few situations).
If you have very many of them, you could export them to cvs, then 
reimport them in the right account? But that's really a kludge.

J.


On 6/30/20 1:46 PM, V. Vatsal via gnucash-user wrote:

Hello,

I am running GnuCash on Mac.

Somehow a month’s worth of credit card transactions ended up in the top level 
Bank Accounts account. Is there some quick way to move or edit them to the 
appropriate credit card account? It’s not possible even to move them manually, 
as far as I can tell, without jumping to the corresponding Expense account for 
each, and then changing the source account there.

Thanks,

Nike


___
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] Auto reconcile on OFX Import

[jean laroche]

I just checked. For me, if the check box isn't checked, I don't get the 
reconciliation dialog.
The check box is at the bottom right of the transaction matching dialog 
(the one that opens after you select the OFX file).


J.


On 6/29/2020 5:50 PM, Matthew Forbis via gnucash-user wrote:

Hi All,

I'm sure it's somewhere that I'm overlooking, but I can't find where to turn 
off the reconcile window that opens automatically when importing an OFX file. I 
know there was some discussion on the development list about the reconcile 
window automatically popping up when importing an OFX file early on.  I thought 
it was decided that this was select-able somewhere, but I can't seem to find 
where to turn it off.  I import my accounts at random times and not necessarily 
on the closing date of the statement, so I do not need it to reconcile 
automatically as I have cancelled every single time so far.

Thanks,
Matt
___
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] Auto reconcile on OFX Import

[jean laroche]

 There's a check box on the matching dialog (bottom right) that's 
normally cleared, where you can select whether to run the reconciliation 
or not.


If the checkbox is cleared and it's still running the reconciliation 
then that's a bug.

J


On 6/29/2020 5:50 PM, Matthew Forbis via gnucash-user wrote:

Hi All,

I'm sure it's somewhere that I'm overlooking, but I can't find where to turn 
off the reconcile window that opens automatically when importing an OFX file. I 
know there was some discussion on the development list about the reconcile 
window automatically popping up when importing an OFX file early on.  I thought 
it was decided that this was select-able somewhere, but I can't seem to find 
where to turn it off.  I import my accounts at random times and not necessarily 
on the closing date of the statement, so I do not need it to reconcile 
automatically as I have cancelled every single time so far.

Thanks,
Matt
___
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 4.0 doesn't launch on MacOS X 10.15.4

[Jean Laroche]

I'm on 10.13.4 (High Sierra) and it launches without any problem.
J

On 6/29/20 7:58 AM, peterb wrote:

...or at least, not on my instance of it.  No particular user-visible error
message, no splash screen visible, lots of stuff in the console.  Happy to
file a bug or share whatever data might help.

Is anyone else seeing this, or am I unique?

-P
___
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] Version 4.0 on Mac High Sierra

[jean laroche]

Are you in the main account window? The new type-ahead search is only 
available when you're looking at a transaction and you're changing the 
target account of the transaction.


I'm on windows but for me, in the main account view (where all accounts 
are visible) if I type the name of an account then enter, the account is 
opened immediately.


J


On 6/28/2020 12:27 PM, Ira Fuchs wrote:

I may be misreading the Changes but I am unable to see the new type-ahead 
search when selecting an account. If I type a few letters of the account name, 
I see the letters typed in the bottom right corner and the first account with 
those letters is selected. If I use the down arrow I will get the next, and so 
on. I don’t see any drop-list. Moreover, a few versions ago, it was possible to 
simply hit Enter when the account of interest was highlighted and it would be 
opened. Now it takes one or 2 double-clicks on the account to open the register.
___
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 

Re: [GNC] Running both Stable and Development Releases

[jean laroche]

When you run the installer, you point it to a different location than 
the previous one. It might tell you it will remove the existing version 
but in my experience that does not happen. I don't quite remember, but 
perhaps I renamed the previous version's directory before running the 
installer with the other version...


Jean


On 5/26/2020 6:06 PM, Greg Feneis wrote:

How?

Kind regards, Greg Feneis
(Pixel 3)


On Tue, May 26, 2020, 17:34 jean laroche  wrote:


I've been able to install both is two separate directories, and things
work just fine... But that's just 1 data point...

Jean


On 5/26/2020 5:04 PM, flywire wrote:

GnuCash setup is quick enough but it asks for the existing version to be
uninstalled. Can both Development and Stable releases be installed at the
same time under Win10? Installing the Stable release and running a
PortableApp version of the Development release would be good.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see

https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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


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


___
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] Running both Stable and Development Releases

[jean laroche]

I've been able to install both is two separate directories, and things 
work just fine... But that's just 1 data point...


Jean


On 5/26/2020 5:04 PM, flywire wrote:

GnuCash setup is quick enough but it asks for the existing version to be
uninstalled. Can both Development and Stable releases be installed at the
same time under Win10? Installing the Stable release and running a
PortableApp version of the Development release would be good.
___
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] Since last run... errors

[jean laroche]

These are scheduled transactions. You should probably cancel the "since 
last run" dialog, then go and edit/delete the scheduled transactions 
(under the "action" menu) that don't seem to be valid (wrong account etc).

Jean


On 5/20/2020 6:07 PM, Ronald Wiplinger wrote:

I am using GNUcash for a few weeks and when I start the program a popup
window shows me some errors. I have no idea how to solve this.

I shows:
v  Alexander's contribution
 06/06/20  To-Create
v  house rent
 09/04/20  To-Create
 (null) -> TWD   (Need Value)


The list goes on, always telling me:
 (null) -> TWD   (Need Value)

I cannot find the transaction in any account.
I tried to add a value where it says Need Value. To find it easy later I
choose 9 as value.

After I click OK I get another pop up, telling me:

Invalid Transactions
Unknown account for guide
[ab745cddc36 ... ], canceling SX
[Alexander's contribution] creation.
Unknown account for guide
[ab745cddc36... ] caneling SX [house rent] creation.


Needless to say, but next start of GNUcash gives me the same problem.

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


___
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 does OFX Direct Connect do?

[jean laroche]

On 5/18/2020 9:38 PM, GWB wrote:

When GnuCash imports OFX transactions, it can tell (almost always?
most of the time?) if that particular transaction has already been
recorded in the ledger.  I find that helpful.  The most time consuming
part of the process for me is assigning categories, transfer accounts,
and determining if it is a split transaction (that I usually do in
another step after importing).


You'd be better off assigning accounts ("categories") from the import 
matching dialog, not after the fact, because that's the only time the 
bayesian matching learns.
If you do it after the fact, GC will never learn to assign accounts 
based on your history. In my experience, it becomes very good at it, so 
now I almost never have to correct an assigned transfer account (category).

Jean
___
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 matcher shortcomings, OFX realm (at least)

[Jean Laroche]

QIF is a lot worse the OFX. OFX transactions have a unique ID, which QIF 
ones don't have...


On 5/6/20 11:48 AM, David Reiser wrote:

Thanks, Jean.
I think the QIF importer has some code that detects multiple possible matches 
and pops up a “select the right match” dialog/window. Perhaps that can be 
reworked/incorporated. I don’t use QIF too much, but I think that particular 
behavior gets triggered in a step a little closer to the final import sequence 
than the General Matcher window gets to when it has decided it has already 
identified matches.
--
Dave Reiser
dbrei...@icloud.com






On May 6, 2020, at 2:16 PM, Jean Laroche  wrote:

I have run into this issue as well! Thanks for looking into it.
I'll try to fix it. What should really be done here, I'm guessing is that the 
matcher should not match several transactions to the same one. This may not be 
super easy to fix, but I'll take a look.
Jean

On 5/6/20 11:00 AM, David Reiser via gnucash-user wrote:

Michael Fross said:

I have to keep importing the same QFX file over and over until I get
“nothing to import” message. If I don’t, it seems to miss transactions in
the file. Not sure about QIF, but Maybe it’s similar.

Michael

Ok, I’ll split this out into another discussion.
The need for multiple attempts at importing the same ofx file to get all the 
transactions imported is probably a result of a shortcoming in the matcher code 
when multiple same-dollar-value transactions (or nearly the same if Commercial 
ATM fee threshold is set to anything greater than 0.00) appear in the ofx file. 
One very common cause of such cases is vending machine transactions.
If you never enter any of the same-value transactions manually, and only import 
them, then you’ll probably be OK, because the matcher will suggest that all the 
transactions should be Added rather than matched.
If, however, you have even one of the same-value transactions entered manually, 
and a set of 5 same-value transactions incoming in the import file, the 
matcher’s default behavior is to display all 5 incoming transactions as having 
a good candidate match. The problem is that all five of those incoming 
transactions are pointed at a single transaction in the gnucash file. If you 
blithely click OK in the Matcher window, the import process matches the first 
incoming transaction to the existing transaction. Then when the second 
same-value transaction gets examined, the matcher says “Oh, I already matched 
that existing transaction, I’ll ignore this one”. And all subsequent same-value 
transaction that had reported they had a match in the file are ignored because 
the candidate match is already taken.
Matching can be even messier if you have, say, 4 transactions of $2.00 entered 
in your data file, but 7 $2.00 transactions coming in with the import.
The reason sequential imports work is that once a candidate is matched and the 
import process ends, the next time the import process is launched, that first 
transaction is no longer a candidate match because it now has an imported 
transaction ID associated with it (and the transaction ID prevents the incoming 
transaction from appearing at all anymore), and the matcher moves on (sometimes 
only one candidate transaction at a time).
I did file a bug on this several years ago, but the matcher’s default match 
identification has not changed. What was added is the ability to double click a 
transaction in the matcher dialog window to see alternative transactions to 
match against. If you see multiple transactions in your matcher window with the 
same dollar value, you must inspect the potential matches for each one and 
select a different one from the top candidate picked by default for all the 
same-value transactions.
I hope this explanation helps reduce the number of repeat imports you have to 
use.
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.



___
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 matcher shortcomings, OFX realm (at least)

[Jean Laroche]

I have run into this issue as well! Thanks for looking into it.
I'll try to fix it. What should really be done here, I'm guessing is 
that the matcher should not match several transactions to the same one. 
This may not be super easy to fix, but I'll take a look.

Jean

On 5/6/20 11:00 AM, David Reiser via gnucash-user wrote:

Michael Fross said:

I have to keep importing the same QFX file over and over until I get
“nothing to import” message. If I don’t, it seems to miss transactions in
the file. Not sure about QIF, but Maybe it’s similar.

Michael


Ok, I’ll split this out into another discussion.

The need for multiple attempts at importing the same ofx file to get all the 
transactions imported is probably a result of a shortcoming in the matcher code 
when multiple same-dollar-value transactions (or nearly the same if Commercial 
ATM fee threshold is set to anything greater than 0.00) appear in the ofx file. 
One very common cause of such cases is vending machine transactions.

If you never enter any of the same-value transactions manually, and only import 
them, then you’ll probably be OK, because the matcher will suggest that all the 
transactions should be Added rather than matched.

If, however, you have even one of the same-value transactions entered manually, 
and a set of 5 same-value transactions incoming in the import file, the 
matcher’s default behavior is to display all 5 incoming transactions as having 
a good candidate match. The problem is that all five of those incoming 
transactions are pointed at a single transaction in the gnucash file. If you 
blithely click OK in the Matcher window, the import process matches the first 
incoming transaction to the existing transaction. Then when the second 
same-value transaction gets examined, the matcher says “Oh, I already matched 
that existing transaction, I’ll ignore this one”. And all subsequent same-value 
transaction that had reported they had a match in the file are ignored because 
the candidate match is already taken.

Matching can be even messier if you have, say, 4 transactions of $2.00 entered 
in your data file, but 7 $2.00 transactions coming in with the import.

The reason sequential imports work is that once a candidate is matched and the 
import process ends, the next time the import process is launched, that first 
transaction is no longer a candidate match because it now has an imported 
transaction ID associated with it (and the transaction ID prevents the incoming 
transaction from appearing at all anymore), and the matcher moves on (sometimes 
only one candidate transaction at a time).

I did file a bug on this several years ago, but the matcher’s default match 
identification has not changed. What was added is the ability to double click a 
transaction in the matcher dialog window to see alternative transactions to 
match against. If you see multiple transactions in your matcher window with the 
same dollar value, you must inspect the potential matches for each one and 
select a different one from the top candidate picked by default for all the 
same-value transactions.

I hope this explanation helps reduce the number of repeat imports you have to 
use.

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.


___
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] Scheduled transactions

[jean laroche]

Here

https://bugs.gnucash.org/buglist.cgi?component=Scheduled%20Transactions_id=8236=GnuCash=---



On 5/3/2020 11:11 AM, augras wrote:

Hi,
Unfortunately Actions > Check and Repair> All Transactions doesn't work.
This arrived around last october when i update from 2.6.x (i don't remenber
exactly) to the last gnucash on flathub. And now i have made some new
updates to the last gnucash version on flathub at this day.
I will try to find an xml editor to test.
Where open a bug ?
Philippe



--
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] Reconcile on Import Quick Question

[Jean Laroche]

I would think you're right, you're not the only one. I think aqbanking 
lets you decide whether you want to reconcile upon import or not...


On 4/28/20 9:20 AM, Fross, Michael wrote:
Thanks Jean.  I'm sure I'm not the only one that imports without 
reconciling.  I appreciate you looking into it.


Have a great day.

Michael

On Tue, Apr 28, 2020 at 10:42 AM Jean Laroche <mailto:rip...@gmail.com>> wrote:


It cannot be turned off at the moment, but I think given your
experience, there should be an option to disable it.
I'll look into adding that if other devs agree.
Jean

On 4/28/20 8:35 AM, Fross, Michael wrote:
 > Hello everyone.  I installed 3.902 this morning (after
uninstalling the
 > previous version) and had a quick question.  I tend to download
and import
 > from my bank accounts every day.  When I was doing so today,
after the
 > import, the reconcile dialog appeared.  I only reconcile monthly
when I get
 > my statements, so I looked to turn this off but could not find
the option.
 > This did not occur in previous versions or I had figured out how
to disable.
 >
 > I'm guessing I'm missing something, but I couldn't determine how
to do
 > that.  Any pointers in the right direction?
 >
 > Thank you.
 >
 > Michael
 > ___
 > gnucash-user mailing list
 > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
 > To update your subscription preferences or to unsubscribe:
 > https://lists.gnucash.org/mailman/listinfo/gnucash-user
 > If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 > -
 > Please remember to CC this list on all your replies.
 > You can do this by using Reply-To-List or Reply-All.
 >
___
gnucash-user mailing list
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] Reconcile on Import Quick Question

[Jean Laroche]

It cannot be turned off at the moment, but I think given your 
experience, there should be an option to disable it.

I'll look into adding that if other devs agree.
Jean

On 4/28/20 8:35 AM, Fross, Michael wrote:

Hello everyone.  I installed 3.902 this morning (after uninstalling the
previous version) and had a quick question.  I tend to download and import
from my bank accounts every day.  When I was doing so today, after the
import, the reconcile dialog appeared.  I only reconcile monthly when I get
my statements, so I looked to turn this off but could not find the option.
This did not occur in previous versions or I had figured out how to disable.

I'm guessing I'm missing something, but I couldn't determine how to do
that.  Any pointers in the right direction?

Thank you.

Michael
___
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] Trying to set up online banking

[jean laroche]

John, are you saying there's a way to setup the aqbanking without using 
the wizard? I completely missed that :(



On 4/26/2020 10:44 AM, John Ralls wrote:

Probably because nobody had the same experience. If the automagic account 
download didn't work then you have to set up the accounts manually in the 
AQBanking setup window using the Accounts tab.

Regards,
John Ralls



On Apr 26, 2020, at 10:38 AM, jean laroche  wrote:

Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
ofxclient.py since I can't get aqbanking to work and I customized it for my 
needs).
It's definitely not an issue with the setup, it's a programming issue!
Everything starts well with the GC online banking setup wizard, I retrieve the 
account list, successfully (according to the UI) then when I want to continue 
with the
wizard, the "next" button is grayed out, and I'm stuck there.
This is with windows 8, and the latest GC (actually all recent versions of GC).

Where do I open a bug on this? I started a thread on the Dev list, asking if 
anybody else on windows had the same experience and got nowhere with it.
Jean


On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:

Hi Jean

Am 26.04.20 um 03:19 schrieb jean laroche:

Are you on windows?

Gnucash & Aqbanking version?


I have to say, I have not been able to setup the
online banking thing in GC in windows.

Which Bank?
Did you follow John's instructions?

Frank

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


___
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] Trying to set up online banking

[jean laroche]

Oh absolutely! I'm very familiar with how to setup the OFX stuff (I use 
ofxclient.py since I can't get aqbanking to work and I customized it for 
my needs).

It's definitely not an issue with the setup, it's a programming issue!
Everything starts well with the GC online banking setup wizard, I 
retrieve the account list, successfully (according to the UI) then when 
I want to continue with the

wizard, the "next" button is grayed out, and I'm stuck there.
This is with windows 8, and the latest GC (actually all recent versions 
of GC).


Where do I open a bug on this? I started a thread on the Dev list, 
asking if anybody else on windows had the same experience and got 
nowhere with it.

Jean


On 4/26/2020 2:12 AM, Frank H. Ellenberger wrote:

Hi Jean

Am 26.04.20 um 03:19 schrieb jean laroche:

Are you on windows?

Gnucash & Aqbanking version?


I have to say, I have not been able to setup the
online banking thing in GC in windows.

Which Bank?
Did you follow John's instructions?

Frank


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

Re: [GNC] Trying to set up online banking

[jean laroche]

Are you on windows? I have to say, I have not been able to setup the 
online banking thing in GC in windows.

Could you describe the issue you're running into?
However, people have reported that ofxget works great to get your data 
from your banks in OFX file format. It's a simple thing to import them 
into GC after that.


Jean


On 4/25/2020 6:11 PM, Janet Shelby wrote:

Hello, I am a new user migrating from many years of Quicken. I would like
to use Gnucash if it will download banking transactions,  especially credit
card transactions.  The tool provided does not get successful results with
no instruction on what to do upon failure. I am an accountant but not an IT
specialist!  Can I get assistance here? Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[jean laroche]

You can put this in a combine.py file. Install python3 (preferably), 
change the names of the files

at the bottom and give it a shot (python combine.py)
Python is a blast as far as languages are concerned, so give it a shot, 
you probably won't regret it!


Good luck,
Jean


# This combines a list of strings (ofx_list) that are read from ofx files
# into a single ofx file suitable to be imported in GnuCash.
def combine_ofx(ofx_list,out_name):
    if len(ofx_list) < 2: return
    # This function finds the occurrences of  and  tags,
    # and outputs the lines numbers in two arrays, along with the lines.
    def findOFXTag(ofx_str):
    ofxIdx = []
    sofxIdx = []
    # Some ofx files have all the tags combined in a single line!
    # Split at < character.
    all_lines = ofx_str.split('<')
    out_lines = []
    for ii,line in enumerate(all_lines):
    # split() removes the '<' character, but we need it. Put it 
back at the start

    # of each line.
    line='<'+line
    if '' in line: ofxIdx.append(ii)
    if '' in line: sofxIdx.append(ii)
    out_lines.append(line)
    # ofxIdx has the indices of lines that have 
    # sofxIdx has the indices of lines that have 
    # out_lines is an array of strings, one per line.
    return ofxIdx,sofxIdx,out_lines
    # Output the first ofx string to the last  (excluded) then 
the next ones from  ->  (excluded)

    print("Outputting first file")
    o,s,lines = findOFXTag(ofx_list[0])
    A = ''.join(lines[0:s[-1]])
    for ofx in ofx_list[1:]:
    print("Outputting next file")
    o, s, lines = findOFXTag(ofx)
    A += ''.join(lines[o[0]+1:s[-1]])
    # Finally add the last  tag
    A += '\n'
    # And write the file.
    print("Writing out file",out_name)
    with open(out_name,'w') as f:
    f.write(A)

def read_ofx_file(file_name):
    # This reads an ofx file and return a long string.
    print("Reading",file_name)
    with open(file_name) as f:
    ofx_as_string = f.read()
    return ofx_as_string

if __name__ == '__main__':
    # You could use this this way:
    file1 = r"E:\temp\Dropbox\OurAccount\OFX\80_Patelco_Checking.ofx"
    file2 = r"E:\temp\Dropbox\OurAccount\OFX\79_Patelco_Checking.ofx"
    file3 = r"E:\temp\Dropbox\OurAccount\OFX\77_Patelco_Visa.ofx"
    all_strings = 
[read_ofx_file(file1),read_ofx_file(file2),read_ofx_file(file3)]

    combine_ofx(all_strings,'combined.ofx')




On 4/15/2020 6:49 PM, Stu Perlman wrote:

Jean,

I would love to see how you did it with Python. That's actually on the 
shortlist of languages I want to learn.


I realized that at least in so far as the Citi produced OFX file is 
concerned, I will always need to delete a fixed number of lines.  If I 
download only one account at a time, I must delete the first 30 
lines.  I have been using sed to do this:


sed -i '1,30d' /tmp/ofx.log


I realized just now (after grabbing some sample downloads of various 
sizes) that if there is more than one account I need to find that 
first  tag and then delete that line and the 31 that follow.  I 
tried using sed with regex but can't get it quite right as it only 
deletes the  line; the next 31 lines are left alone:


sed -i '/<[^>]*\/OFX>/,32d' /tmp/ofx.log


Much appreciation for your help!

Stu


On Wed, Apr 15, 2020 at 6:22 PM Jean Laroche <mailto:rip...@gmail.com>> wrote:


I hacked some python code to do that if you're interested. I'm taking
ofx files, reading them and combining them just the way you
describe it.
It's not beautiful code but it works.
What would be awesome would be if you could select multiple files
in GC,
and then do the import!

On 4/15/20 2:58 PM, Stu Perlman wrote:
> I did some experimenting today and I think I am seeing something
similar.
>
> If I take the  tag that ends the first account’s
transaction data
> and then select all text up to and including the  tag that
starts
>   the next account’s transaction it will work perfectly.
>
> There is a bunch of stuff in between those two tags, including
another
> pair of   tags that wrap some header info that
appears before
> the second account’s transactions.
>
> I’d rather not have to manipulate the file each time so if I can
figure
> out a script that can do what I am doing by hand I should be
set.   If
>   it’s not the same number of lines or characters each time my
script
> will need to be able to detect the correct tags as start and
stop points
> before removing the text.   I plan on working on this a little
more now
> that I know it is possible to import multiple accounts using a
single file.
>
> On Tue, Apr 14, 2020 at 10:11 PM 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

I think we're talking about OFX here, which is a lot more robust that 
QIF as far as importing. In any event, when you combine the OFX files, 
the OFX import is done sequentially (apparently) in GC as if you opened 
them one after the other, but I may be wrong. The transactions do all 
appear combined in a single match dialog, which is super nice.

Jean

On 4/15/20 3:42 PM, David Carlson wrote:



On Wed, Apr 15, 2020 at 5:22 PM Jean Laroche <mailto:rip...@gmail.com>> wrote:


I hacked some python code to do that if you're interested. I'm taking
ofx files, reading them and combining them just the way you describe
it.
It's not beautiful code but it works.
What would be awesome would be if you could select multiple files in
GC,
and then do the import!

Jean,
I don't know if it is still true with the current QIF importer, but IIRC 
back in the release 2.4.x era the QIF importer could handle multiple 
files in one pass. The downside was that it couldn't match both sides of 
a transfer in the same file. Multiple files would be a nice Request for 
Improvement if it did match transfers.


On 4/15/20 2:58 PM, Stu Perlman wrote:
 > I did some experimenting today and I think I am seeing something
similar.
 >
 > If I take the  tag that ends the first account’s
transaction data
 > and then select all text up to and including the  tag that
starts
 >   the next account’s transaction it will work perfectly.
 >
 > There is a bunch of stuff in between those two tags, including
another
 > pair of   tags that wrap some header info that appears
before
 > the second account’s transactions.
 >
 > I’d rather not have to manipulate the file each time so if I can
figure
 > out a script that can do what I am doing by hand I should be set.
   If
 >   it’s not the same number of lines or characters each time my
script
 > will need to be able to detect the correct tags as start and stop
points
 > before removing the text.   I plan on working on this a little
more now
 > that I know it is possible to import multiple accounts using a
single file.
     >
 > On Tue, Apr 14, 2020 at 10:11 PM jean laroche mailto:rip...@gmail.com>
 > <mailto:rip...@gmail.com <mailto:rip...@gmail.com>>> wrote:
 >
 >     Well, combined OFX files *are* supported, at least when the
 >     originate from the same bank.
 >     I just created a combined OFX file by joining two separate OFX
 >     files, and putting the two data in between the BANKMSGSRSV1
tags in
 >     a row.
 >
 >          
 >     
 >          
 >          
 >     
 >          
 >
 >     In other words, I took everything that was between

 >     and   (including these) from one file, and
copied it
 >     right after the
 >       from the other file, saved and imported. I
get the
 >     transactions from both accounts in one shot.
 >     That's pretty cool.
 >     So if that's not working for you, you should look at your OFX
file
 >     and try to identify where the problem originates...
 >     Jean
 >
 >
 >     On 4/14/2020 1:29 PM, David Carlson wrote:
 >>     Stu,
 >>
 >>     Are you doing online banking through GnuCash or importing OFX
 >>     files that you downloaded earlier?
 >>
 >>     I am importing OFX files that I imported directly from my bank's
 >>     website.
 >>
 >>     I think that the same OFX format  is used either way but a
 >>     different procedure is used to get the data into GnuCash.
 >>
 >>     When I mentioned three tags that appear in OFX files that I
 >>     receive I only gave selected examples   not a complete
definition.
 >>     One would need to get a copy of the OFX standard for
completeness.
 >>
 >>
 >>
 >>
 >>     On Tue, Apr 14, 2020, 3:14 PM Stu Perlman
mailto:sgperl...@gmail.com>
 >>     <mailto:sgperl...@gmail.com <mailto:sgperl...@gmail.com>>>
wrote:
 >>
 >>         Jean, I always assumed it was supported because if you
use GNC
 >>         to configure
 >>         AqB, you only need to set up one User per financial
 >>         institution even though
 >>         you can set up multiple accounts for that single user.
 >>
 >>         - Stu
 >>
 >>         On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche
mailto:rip...@gmail.com>
 >>         <mailto:rip...@gmail.com <mail

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

I hacked some python code to do that if you're interested. I'm taking 
ofx files, reading them and combining them just the way you describe it. 
It's not beautiful code but it works.
What would be awesome would be if you could select multiple files in GC, 
and then do the import!


On 4/15/20 2:58 PM, Stu Perlman wrote:

I did some experimenting today and I think I am seeing something similar.

If I take the  tag that ends the first account’s transaction data 
and then select all text up to and including the  tag that starts 
  the next account’s transaction it will work perfectly.


There is a bunch of stuff in between those two tags, including another 
pair of   tags that wrap some header info that appears before 
the second account’s transactions.


I’d rather not have to manipulate the file each time so if I can figure 
out a script that can do what I am doing by hand I should be set.   If 
  it’s not the same number of lines or characters each time my script 
will need to be able to detect the correct tags as start and stop points 
before removing the text.   I plan on working on this a little more now 
that I know it is possible to import multiple accounts using a single file.


On Tue, Apr 14, 2020 at 10:11 PM jean laroche <mailto:rip...@gmail.com>> wrote:


Well, combined OFX files *are* supported, at least when the
originate from the same bank.
I just created a combined OFX file by joining two separate OFX
files, and putting the two data in between the BANKMSGSRSV1 tags in
a row.

     

     
     

     

In other words, I took everything that was between  
and   (including these) from one file, and copied it

right after the
  from the other file, saved and imported. I get the
transactions from both accounts in one shot.
That's pretty cool.
So if that's not working for you, you should look at your OFX file
and try to identify where the problem originates...
Jean


On 4/14/2020 1:29 PM, David Carlson wrote:

Stu,

Are you doing online banking through GnuCash or importing OFX
files that you downloaded earlier?

I am importing OFX files that I imported directly from my bank's
website.

I think that the same OFX format  is used either way but a
different procedure is used to get the data into GnuCash.

When I mentioned three tags that appear in OFX files that I
receive I only gave selected examples   not a complete definition.
One would need to get a copy of the OFX standard for completeness.




On Tue, Apr 14, 2020, 3:14 PM Stu Perlman mailto:sgperl...@gmail.com>> wrote:

Jean, I always assumed it was supported because if you use GNC
to configure
AqB, you only need to set up one User per financial
institution even though
you can set up multiple accounts for that single user.

- Stu

On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche mailto:rip...@gmail.com>> wrote:

> BTW, that's a feature I was interested in (importing
combined OFX
> files). If there are others interested, I'll look at a way
to support
> that. Another thing that I miss is the ability to automatically
> reconcile after an OFX import (not to highjack this thread).
> J.
>
> On 4/14/20 12:53 PM, Ove Grunnér wrote:
> > Ah, I was talking of QIF, not QFX, sorry about that.
> > yes the java code writes QIF.
> > Ove.
> >
> > On Tue, 14 Apr 2020 at 20:45, Stu Perlman
mailto:sgperl...@gmail.com>> wrote:
> >
> >> Ove,
> >>
> >> Thanks for the info that you shared.  Is your Java
program writing to
> the
> >> QIF format or the OFX format?
> >>
> >> David - my apologies, I never noticed your reply to my
original email
> last
> >> month!  I'm happy to read that it should work.
> >>
> >> I'm still running GNC 3.8 from a mid-march build on my
WIndows system. I
> >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to
all play well
> with
> >> each other.  I am able to get my data from Citi by using
an older AqB
> >> release that I have running under Cygwin to pull the data
from the
> Citi's
> >> web server.  I have found that in order to import the
files that are
> >> download into GNC that I need to make one file for each
account at Citi
> (by
> >> running aqbanking-cli for one account at a time). I then
strip out the
> 1st
> >> dozen or so l

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[jean laroche]

Well, combined OFX files *are* supported, at least when the originate 
from the same bank.
I just created a combined OFX file by joining two separate OFX files, 
and putting the two data in between the BANKMSGSRSV1 tags in a row.


    

    
    

    

In other words, I took everything that was between   and 
  (including these) from one file, and copied it right 
after the
  from the other file, saved and imported. I get the 
transactions from both accounts in one shot.

That's pretty cool.
So if that's not working for you, you should look at your OFX file and 
try to identify where the problem originates...

Jean


On 4/14/2020 1:29 PM, David Carlson wrote:

Stu,

Are you doing online banking through GnuCash or importing OFX files 
that you downloaded earlier?


I am importing OFX files that I imported directly from my bank's website.

I think that the same OFX format  is used either way but a different 
procedure is used to get the data into GnuCash.


When I mentioned three tags that appear in OFX files that I receive I 
only gave selected examples   not a complete definition. One would 
need to get a copy of the OFX standard for completeness.





On Tue, Apr 14, 2020, 3:14 PM Stu Perlman <mailto:sgperl...@gmail.com>> wrote:


Jean, I always assumed it was supported because if you use GNC to
configure
AqB, you only need to set up one User per financial institution
even though
you can set up multiple accounts for that single user.

- Stu

On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche mailto:rip...@gmail.com>> wrote:

> BTW, that's a feature I was interested in (importing combined OFX
> files). If there are others interested, I'll look at a way to
support
> that. Another thing that I miss is the ability to automatically
> reconcile after an OFX import (not to highjack this thread).
> J.
>
> On 4/14/20 12:53 PM, Ove Grunnér wrote:
> > Ah, I was talking of QIF, not QFX, sorry about that.
> > yes the java code writes QIF.
> > Ove.
> >
> > On Tue, 14 Apr 2020 at 20:45, Stu Perlman mailto:sgperl...@gmail.com>> wrote:
> >
> >> Ove,
> >>
> >> Thanks for the info that you shared.  Is your Java program
writing to
> the
> >> QIF format or the OFX format?
> >>
> >> David - my apologies, I never noticed your reply to my
original email
> last
> >> month!  I'm happy to read that it should work.
> >>
> >> I'm still running GNC 3.8 from a mid-march build on my
WIndows system. I
> >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all
play well
> with
> >> each other.  I am able to get my data from Citi by using an
older AqB
> >> release that I have running under Cygwin to pull the data
from the
> Citi's
> >> web server.  I have found that in order to import the files
that are
> >> download into GNC that I need to make one file for each
account at Citi
> (by
> >> running aqbanking-cli for one account at a time). I then
strip out the
> 1st
> >> dozen or so lines in the response received.  I have managed
to script
> most
> >> of this so it's not nearly as cumbersome as it may appear,
but needing
> to
> >> enter the password once for each account at Citi is annoying
as is
> needing
> >> to import multiple files into GNC instead of one consolidated
file. I
> tried
> >> to eliminate the repeating password step with the Expect
tool, but I
> could
> >> not get it to work in the Cygwin environment.
> >>
> >> Unfortunately, the other financial institutions where I have
multiple
> >> accounts don't even support OFX (or at least if they do, the
info is not
> >> available on OFXhome.net)  so I don't know if the issues I
have run into
> >> are caused by Citi, GNC, or AqB. These issues are not so
annoying that I
> >> would go back to Quicken! LOL    I may mess around with trying to
> automate
> >> my calls to aqbanking-cli using PowerShell so that I can take
Cygwin
> out of
> >> the mix and/or just try moving over to my Ubuntu system for GNC.
> >>
> >> - Stu
> >>
> >>
> >>
> >>
> >>
> >>
> >> On Tue, Apr 14, 2020 at 2:40 PM David Carlson <
> david.carlson@gmail.com <mailto:david.carlson@gmail.com>>
> >> wrote:
> >>
> >>> Ove,
> &g

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

The AqB code and the OFX import code are not the same though. So it's 
quite possible one supports it, and the other not.

I'll take a look tonight!
Jean

On 4/14/20 1:06 PM, Stu Perlman wrote:
Jean, I always assumed it was supported because if you use GNC to 
configure AqB, you only need to set up one User per financial 
institution even though you can set up multiple accounts for that single 
user.


- Stu

On Tue, Apr 14, 2020 at 4:01 PM Jean Laroche <mailto:rip...@gmail.com>> wrote:


BTW, that's a feature I was interested in (importing combined OFX
files). If there are others interested, I'll look at a way to support
that. Another thing that I miss is the ability to automatically
reconcile after an OFX import (not to highjack this thread).
J.

On 4/14/20 12:53 PM, Ove Grunnér wrote:
 > Ah, I was talking of QIF, not QFX, sorry about that.
 > yes the java code writes QIF.
 > Ove.
 >
 > On Tue, 14 Apr 2020 at 20:45, Stu Perlman mailto:sgperl...@gmail.com>> wrote:
 >
 >> Ove,
 >>
 >> Thanks for the info that you shared.  Is your Java program
writing to the
 >> QIF format or the OFX format?
 >>
 >> David - my apologies, I never noticed your reply to my original
email last
 >> month!  I'm happy to read that it should work.
 >>
 >> I'm still running GNC 3.8 from a mid-march build on my WIndows
system. I
 >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all
play well with
 >> each other.  I am able to get my data from Citi by using an
older AqB
 >> release that I have running under Cygwin to pull the data from
the Citi's
 >> web server.  I have found that in order to import the files that are
 >> download into GNC that I need to make one file for each account
at Citi (by
 >> running aqbanking-cli for one account at a time). I then strip
out the 1st
 >> dozen or so lines in the response received.  I have managed to
script most
 >> of this so it's not nearly as cumbersome as it may appear, but
needing to
 >> enter the password once for each account at Citi is annoying as
is needing
 >> to import multiple files into GNC instead of one consolidated
file. I tried
 >> to eliminate the repeating password step with the Expect tool,
but I could
 >> not get it to work in the Cygwin environment.
 >>
 >> Unfortunately, the other financial institutions where I have
multiple
 >> accounts don't even support OFX (or at least if they do, the
info is not
 >> available on OFXhome.net)  so I don't know if the issues I have
run into
 >> are caused by Citi, GNC, or AqB. These issues are not so
annoying that I
 >> would go back to Quicken! LOL    I may mess around with trying
to automate
 >> my calls to aqbanking-cli using PowerShell so that I can take
Cygwin out of
 >> the mix and/or just try moving over to my Ubuntu system for GNC.
 >>
 >> - Stu
 >>
 >>
 >>
 >>
 >>
 >>
 >> On Tue, Apr 14, 2020 at 2:40 PM David Carlson
mailto:david.carlson@gmail.com>>
 >> wrote:
 >>
 >>> Ove,
 >>>
 >>> I believe !Clear:AutoSwitch is only used in QIF imports.  My
OFX imports
 >>> have tags similar to
 >>>
 >>>   and .
 >>>
 >>>
 >>>
 >>>
 >>> On Tue, Apr 14, 2020 at 12:12 PM Ove Grunnér
mailto:write2...@gmail.com>> wrote:
 >>>
 >>>> it works for me as well, but I know I need to put a specific
line in the
 >>>> beginning of the file to let gnuCash know it is multi account
 >>>>
 >>>> open up your file and check if the firs line is:
 >>>> !Clear:AutoSwitch
 >>>>
 >>>> Try to add the line if it is missing.
 >>>>
 >>>> I use the below java code to write my import files.
 >>>>
 >>>> br
 >>>>
 >>>>
 >>>> try {
 >>>>      FileWriter fstream = new
FileWriter(targetDirectoryPointer + targetQifFileName);
 >>>>      BufferedWriter info = new BufferedWriter(fstream);
 >>>>
 >>>>      // WRITE TO FILE
 >>>>      // indicator for multi account import
 >>>>      info.write("!Clear:AutoSwitch"+"\n");
 >>>>
 >>>>      for (int acc=0; acc< 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

BTW, that's a feature I was interested in (importing combined OFX 
files). If there are others interested, I'll look at a way to support 
that. Another thing that I miss is the ability to automatically 
reconcile after an OFX import (not to highjack this thread).

J.

On 4/14/20 12:53 PM, Ove Grunnér wrote:

Ah, I was talking of QIF, not QFX, sorry about that.
yes the java code writes QIF.
Ove.

On Tue, 14 Apr 2020 at 20:45, Stu Perlman  wrote:


Ove,

Thanks for the info that you shared.  Is your Java program writing to the
QIF format or the OFX format?

David - my apologies, I never noticed your reply to my original email last
month!  I'm happy to read that it should work.

I'm still running GNC 3.8 from a mid-march build on my WIndows system. I
have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well with
each other.  I am able to get my data from Citi by using an older AqB
release that I have running under Cygwin to pull the data from the Citi's
web server.  I have found that in order to import the files that are
download into GNC that I need to make one file for each account at Citi (by
running aqbanking-cli for one account at a time). I then strip out the 1st
dozen or so lines in the response received.  I have managed to script most
of this so it's not nearly as cumbersome as it may appear, but needing to
enter the password once for each account at Citi is annoying as is needing
to import multiple files into GNC instead of one consolidated file. I tried
to eliminate the repeating password step with the Expect tool, but I could
not get it to work in the Cygwin environment.

Unfortunately, the other financial institutions where I have multiple
accounts don't even support OFX (or at least if they do, the info is not
available on OFXhome.net)  so I don't know if the issues I have run into
are caused by Citi, GNC, or AqB. These issues are not so annoying that I
would go back to Quicken! LOLI may mess around with trying to automate
my calls to aqbanking-cli using PowerShell so that I can take Cygwin out of
the mix and/or just try moving over to my Ubuntu system for GNC.

- Stu






On Tue, Apr 14, 2020 at 2:40 PM David Carlson 
wrote:


Ove,

I believe !Clear:AutoSwitch is only used in QIF imports.  My OFX imports
have tags similar to

  and .




On Tue, Apr 14, 2020 at 12:12 PM Ove Grunnér  wrote:


it works for me as well, but I know I need to put a specific line in the
beginning of the file to let gnuCash know it is multi account

open up your file and check if the firs line is:
!Clear:AutoSwitch

Try to add the line if it is missing.

I use the below java code to write my import files.

br


try {
 FileWriter fstream = new FileWriter(targetDirectoryPointer + 
targetQifFileName);
 BufferedWriter info = new BufferedWriter(fstream);

 // WRITE TO FILE
 // indicator for multi account import
 info.write("!Clear:AutoSwitch"+"\n");

 for (int acc=0; acc< maxAcc; acc++) {

 int transactionTableMaxRows = 
accountTable.getTransactionTableMaxRows(acc);
 DateFormat dateFormat = new SimpleDateFormat("-MM-dd");

 // get data for this account
 String targetFileAccountName = 
accountTable.getTransactionTableAccountName(acc);
 String[] transactionDescription = 
accountTable.getTransactionDescription(acc);
 float[] transactionAmount = accountTable.getTransactionAmount(acc);
 float[] transactionBalance = accountTable.getTransactionBalance(acc);
 Date[] transactionDate = accountTable.getTransactionDate(acc);

 // WRITE TO FILE
 // New Account
 String account = accountDetailsGnuCashName[acc] ;
 info.write("!Account" + "\n" + "N" + account + "\n" + "^" + "\n");


 for (int l = 0; l < transactionTableMaxRows; l++) {

 // Transaction
 String type = "Bank";
 String date = dateFormat.format(transactionDate[l]);
 String amount = String.valueOf(transactionAmount[l]);
 String description = transactionDescription[l];
 String category = transactionDescription[l];

 info.write("!Type:" + type + "\n");
 info.write("D" + date + "\n");
 info.write("T" + amount + "\n");
 info.write("P" + description +"\n");
 info.write("L" + category + "\n");
 info.write("^" + "\n");
 }
 }

 // Close File
 info.close();

}
catch (IOException e) {
 System.out.println("A write error has occurred");
 e.printStackTrace();
}


On Fri, 13 Mar 2020 at 15:21, David Carlson 
wrote:


Stu,

I have been importing OFX files from my bank for years with three or
four
checking or savings accounts in one file, so I know GnuCash release
2.6.19
can import OFX files with multiple accounts.  It is possible but
unlikely
that GnuCash has lost that ability in recent releases.  You may have
something else happening in your case.

On Fri, Mar 13, 2020 at 9:58 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

Oh, so does this mean that GC cannot import combined OFX files, as far 
as we know (that's what I thought was the case)?

Jean

On 4/14/20 12:53 PM, Ove Grunnér wrote:

Ah, I was talking of QIF, not QFX, sorry about that.
yes the java code writes QIF.
Ove.

On Tue, 14 Apr 2020 at 20:45, Stu Perlman  wrote:


Ove,

Thanks for the info that you shared.  Is your Java program writing to the
QIF format or the OFX format?

David - my apologies, I never noticed your reply to my original email last
month!  I'm happy to read that it should work.

I'm still running GNC 3.8 from a mid-march build on my WIndows system. I
have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well with
each other.  I am able to get my data from Citi by using an older AqB
release that I have running under Cygwin to pull the data from the Citi's
web server.  I have found that in order to import the files that are
download into GNC that I need to make one file for each account at Citi (by
running aqbanking-cli for one account at a time). I then strip out the 1st
dozen or so lines in the response received.  I have managed to script most
of this so it's not nearly as cumbersome as it may appear, but needing to
enter the password once for each account at Citi is annoying as is needing
to import multiple files into GNC instead of one consolidated file. I tried
to eliminate the repeating password step with the Expect tool, but I could
not get it to work in the Cygwin environment.

Unfortunately, the other financial institutions where I have multiple
accounts don't even support OFX (or at least if they do, the info is not
available on OFXhome.net)  so I don't know if the issues I have run into
are caused by Citi, GNC, or AqB. These issues are not so annoying that I
would go back to Quicken! LOLI may mess around with trying to automate
my calls to aqbanking-cli using PowerShell so that I can take Cygwin out of
the mix and/or just try moving over to my Ubuntu system for GNC.

- Stu






On Tue, Apr 14, 2020 at 2:40 PM David Carlson 
wrote:


Ove,

I believe !Clear:AutoSwitch is only used in QIF imports.  My OFX imports
have tags similar to

  and .




On Tue, Apr 14, 2020 at 12:12 PM Ove Grunnér  wrote:


it works for me as well, but I know I need to put a specific line in the
beginning of the file to let gnuCash know it is multi account

open up your file and check if the firs line is:
!Clear:AutoSwitch

Try to add the line if it is missing.

I use the below java code to write my import files.

br


try {
 FileWriter fstream = new FileWriter(targetDirectoryPointer + 
targetQifFileName);
 BufferedWriter info = new BufferedWriter(fstream);

 // WRITE TO FILE
 // indicator for multi account import
 info.write("!Clear:AutoSwitch"+"\n");

 for (int acc=0; acc< maxAcc; acc++) {

 int transactionTableMaxRows = 
accountTable.getTransactionTableMaxRows(acc);
 DateFormat dateFormat = new SimpleDateFormat("-MM-dd");

 // get data for this account
 String targetFileAccountName = 
accountTable.getTransactionTableAccountName(acc);
 String[] transactionDescription = 
accountTable.getTransactionDescription(acc);
 float[] transactionAmount = accountTable.getTransactionAmount(acc);
 float[] transactionBalance = accountTable.getTransactionBalance(acc);
 Date[] transactionDate = accountTable.getTransactionDate(acc);

 // WRITE TO FILE
 // New Account
 String account = accountDetailsGnuCashName[acc] ;
 info.write("!Account" + "\n" + "N" + account + "\n" + "^" + "\n");


 for (int l = 0; l < transactionTableMaxRows; l++) {

 // Transaction
 String type = "Bank";
 String date = dateFormat.format(transactionDate[l]);
 String amount = String.valueOf(transactionAmount[l]);
 String description = transactionDescription[l];
 String category = transactionDescription[l];

 info.write("!Type:" + type + "\n");
 info.write("D" + date + "\n");
 info.write("T" + amount + "\n");
 info.write("P" + description +"\n");
 info.write("L" + category + "\n");
 info.write("^" + "\n");
 }
 }

 // Close File
 info.close();

}
catch (IOException e) {
 System.out.println("A write error has occurred");
 e.printStackTrace();
}


On Fri, 13 Mar 2020 at 15:21, David Carlson 
wrote:


Stu,

I have been importing OFX files from my bank for years with three or
four
checking or savings accounts in one file, so I know GnuCash release
2.6.19
can import OFX files with multiple accounts.  It is possible but
unlikely
that GnuCash has lost that ability in recent releases.  You may have
something else happening in your case.

On Fri, Mar 13, 2020 at 9:58 AM Stu Perlman 
wrote:


Hello,

I am using GNC on Windows 10.  I have a fairly recent build, dated

March 9

from the maintenance branch.

I 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

I tried importing OFX files with multiple accounts a while back (6 
months ago?), and it didn't work (only 1 account got processed), so I 
assumed GC did not support it! I'm surprised to hear that it does.

I'll try again and keep you posted.
Jean

On 4/14/20 11:40 AM, David Carlson wrote:

Ove,

I believe !Clear:AutoSwitch is only used in QIF imports.  My OFX imports
have tags similar to

  and .




On Tue, Apr 14, 2020 at 12:12 PM Ove Grunnér  wrote:


it works for me as well, but I know I need to put a specific line in the
beginning of the file to let gnuCash know it is multi account

open up your file and check if the firs line is:
!Clear:AutoSwitch

Try to add the line if it is missing.

I use the below java code to write my import files.

br


try {
 FileWriter fstream = new FileWriter(targetDirectoryPointer + 
targetQifFileName);
 BufferedWriter info = new BufferedWriter(fstream);

 // WRITE TO FILE
 // indicator for multi account import
 info.write("!Clear:AutoSwitch"+"\n");

 for (int acc=0; acc< maxAcc; acc++) {

 int transactionTableMaxRows = 
accountTable.getTransactionTableMaxRows(acc);
 DateFormat dateFormat = new SimpleDateFormat("-MM-dd");

 // get data for this account
 String targetFileAccountName = 
accountTable.getTransactionTableAccountName(acc);
 String[] transactionDescription = 
accountTable.getTransactionDescription(acc);
 float[] transactionAmount = accountTable.getTransactionAmount(acc);
 float[] transactionBalance = accountTable.getTransactionBalance(acc);
 Date[] transactionDate = accountTable.getTransactionDate(acc);

 // WRITE TO FILE
 // New Account
 String account = accountDetailsGnuCashName[acc] ;
 info.write("!Account" + "\n" + "N" + account + "\n" + "^" + "\n");


 for (int l = 0; l < transactionTableMaxRows; l++) {

 // Transaction
 String type = "Bank";
 String date = dateFormat.format(transactionDate[l]);
 String amount = String.valueOf(transactionAmount[l]);
 String description = transactionDescription[l];
 String category = transactionDescription[l];

 info.write("!Type:" + type + "\n");
 info.write("D" + date + "\n");
 info.write("T" + amount + "\n");
 info.write("P" + description +"\n");
 info.write("L" + category + "\n");
 info.write("^" + "\n");
 }
 }

 // Close File
 info.close();

}
catch (IOException e) {
 System.out.println("A write error has occurred");
 e.printStackTrace();
}


On Fri, 13 Mar 2020 at 15:21, David Carlson 
wrote:


Stu,

I have been importing OFX files from my bank for years with three or four
checking or savings accounts in one file, so I know GnuCash release 2.6.19
can import OFX files with multiple accounts.  It is possible but unlikely
that GnuCash has lost that ability in recent releases.  You may have
something else happening in your case.

On Fri, Mar 13, 2020 at 9:58 AM Stu Perlman  wrote:


Hello,

I am using GNC on Windows 10.  I have a fairly recent build, dated

March 9

from the maintenance branch.

I noticed that I'm still unable to use AqBanking to get OFX data from

Citi

into GNC.  I Did a little exploring and discovered that if I manipulate

the

file in C:\tmp\ofx.log and break it into separate parts for each account
that was downloaded that GNC will import the data just fine if it's

limited

to one account per file.  I also believe, but I need to confirm that I

can

leave all of the data in a single file but that I need to eliminate a

lot

lines starting with the closing tags for the first account's response

body

and up to and including the opening tags for the subsequent accounts'
response bodies.

Has anyone else encountered this issue and if so, do you have any ideas

how

to fix this?  Is it a defect?

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.




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






___
gnucash-user mailing list