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 <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< 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....@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 <sgperl...@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@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.
>>
>
--
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.
