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