[GNC] OFX Import with Multiple Banks/Accounts in a single file
David Carlson
david.carlson.417 at gmail.com
Tue Apr 14 15:03:18 EDT 2020
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 <ripngo at gmail.com> wrote:
> 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
> >
> > <BANKID> <ACCTID> and <ACCTTYPE>.
> >
> >
> >
> >
> > On Tue, Apr 14, 2020 at 12:12 PM Ove Grunnér <write2ove at 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< maxAcc; acc++) {
> >>
> >> int transactionTableMaxRows =
> accountTable.getTransactionTableMaxRows(acc);
> >> DateFormat dateFormat = new SimpleDateFormat("yyyy-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 <
> david.carlson.417 at gmail.com>
> >> 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 <sgperlman at gmail.com>
> 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 at 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 at 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 at 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
More information about the gnucash-user
mailing list