Thanks so much for sharing this, Jean!
I look forward to trying it out.
On Wed, Apr 15, 2020 at 10:47 PM jean laroche wrote:
> 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
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
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
Sorry, I wasn,t clear that I was intentionally comparing apples with
oranges because they both grow on trees
On Wed, Apr 15, 2020 at 5:49 PM Jean Laroche wrote:
> 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
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
On Wed, Apr 15, 2020 at 5:22 PM Jean Laroche 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
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
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
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
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.
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
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 wrote:
> BTW, that's a feature I was
Citi does do it, the problem is that I can't get the import to load
properly (or without error, I don't recall now). I'll try to pull a
consolidated file from Citi and then examine it to see if the tags that you
mentioned in your earlier email are included or if they are missing.
- Stu
On Tue,
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
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
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
My bank knows how to export multiple accounts in OFX format. I think some
banks just won't do it for one reason or another.
On Tue, Apr 14, 2020 at 1:51 PM Jean Laroche wrote:
> I tried importing OFX files with multiple accounts a while back (6
> months ago?), and it didn't work (only 1
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,
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
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
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
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
23 matches
Mail list logo
