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,
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
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
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 a
ngle 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 th
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 i
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
y
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 intere
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
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.
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
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
d 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
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
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
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,
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
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
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
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
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
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
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?
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
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 feedb
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
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
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,
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
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
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
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
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
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
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
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
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
:
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
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
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
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
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
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
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
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
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
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
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@gnu
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, an
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
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
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
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
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
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.
hat
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.
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 strang
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
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
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
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
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
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
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
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
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
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
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
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
"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
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
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
/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 sur
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
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
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
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
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
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
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).
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
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
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
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,
84 matches
Mail list logo