[GNC] Should i create Equity for each currency i had ?

[Long]

Hello,

I saw GnuCash guided you in chapter 12 that you should create Equity for
each currency. 
But i don't think so, Because when you do that, you will never know
"Gain/Loss" when you look into Report. Because when the exchange rate
changed, both assets and equity will be the same.
I think i should only use my currency (default) in equity accounts (opening
balances), then using "currency transfer" to transfer money to each assets,
in this way, i will know "gain/loss" in my book time period. Right ?

Regards.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] Gnucash 3.9

[Jürgen Jatzkowski via gnucash-user]

Christopher,

happy easter holidays and sorry for my late answer.

I changed as you recommended and the report is working like a charm again.

Thanks a lot!

Jürgen

Am So., 5. Apr. 2020 um 13:47 Uhr schrieb Christopher Lam <
christopher@gmail.com>:

> Apologies for this bug. If you are able please modify eguile-utilities.scm
> within the GnuCash.app and modify the following line:
>
> From: ((_ x . _) x)
> To:   ((_ x . y) x)
>
> On Sat, 4 Apr 2020 at 14:39, Christopher Lam 
> wrote:
>
>> Please file a bug on bugs.gnucash.org
>> Meanwhile the (Experimental) Multicolumn Balance Sheet is likely to be
>> very capable of generating a useful report.
>>
>> On Sat, 4 Apr 2020 at 13:28, jjatzkowski  wrote:
>>
>>> I just upgraded to GnuCash 3.9 on (MacOS; Catalina 10.15.3).
>>>
>>> Version: 3.9
>>> Build ID: 3.9+(2020-03-28)
>>>
>>> Unfortunately the eguile report (in menu "Berichte/Aktiva&Passiva/Bilanz
>>> mit
>>> eguile)  doesn't work any longer and throws an error which you can see
>>> below.
>>>
>>> Question: is this something which is known - I couldn't find any hints on
>>> this?
>>>
>>> Help is really highly appreciated :)
>>>
>>> 
>>>
>>> Bilanz (mit »eguile«) 31.12.2020
>>>
>>> Fehler aufgetreten beim Verarbeiten der Vorlage:
>>>
>>> In c-interface.scm:
>>> 64:23 19 (gnc:backtrace-if-exception _ . _)
>>>  22:4 18 (gnc:call-with-error-handling _ _)
>>> In ice-9/boot-9.scm:
>>> 829:9 17 (catch _ _ # …)
>>> In c-interface.scm:
>>> 26:40 16 (_)
>>> In report.scm:
>>>780:24 15 (_)
>>>756:25 14 (gnc:report-render-html #< type: 2e3751edeb754…> …)
>>> In balsheet-eg.scm:
>>>611:15 13 (balsheet-renderer _)
>>> In ice-9/ports.scm:
>>> 550:4 12 (call-with-output-string _)
>>> 474:4 11 (with-output-to-port _ _)
>>> 470:4 10 (with-input-from-port _ _)
>>> In ice-9/boot-9.scm:
>>> 829:9  9 (catch _ _ # …)
>>> In eguile-gnc.scm:
>>> 189:8  8 (eval-input)
>>> In ice-9/eval.scm:
>>> 619:8  7 (_ #(#(#(#(#) …) …) …))
>>> 619:8  6 (_ #(#(#(#(#(#(#(#(#(#(#(…) …) …) …) …) …) …) …) …) …) …))
>>> In ice-9/boot-9.scm:
>>>260:13  5 (for-each # …)
>>> In ice-9/eval.scm:
>>> 619:8  4 (_ #(#(#(# …) …) …))
>>> 619:8  3 (_ #(#(#(#) …) …))
>>> In eguile-html-utilities.scm:
>>> 56:11  2 (empty-cells _)
>>> 41:15  1 (string-repeat _ _)
>>> In unknown file:
>>>0 (make-list -1 "")
>>>
>>> Value out of range 0 to 4294967295: -1
>>>
>>>
>>>
>>>
>>> --
>>> Sent from:
>>> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>>> ___
>>> 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.
>>>
>>

-- 
-- 
juergen jatzkowski
jjatzkow...@googlemail.com
___
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.

[GNC] Online price updating

[Mohamed Omar]

Dear All,
I am testing GnuCash personal finance program ability to update our UAE 
Finantial Stock Market (Abu Dhabi – ADX & Dubai DFM) .
I followed the steps of using Finance::Qoute by downloading the file and 
ActivePerl software. I become upset due to unfortunately my lack of understand 
some process.
Can you advise me if I could obtain of market stock prices after complete the 
installing the the patch file on my PC.
Best regards,

Mohamed Omar

Sent from Mail for Windows 10

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

Re: [GNC] Saving Data

[Andrew Ralph via gnucash-user]

Thanks for your reply 
I am on macOS Mojave version 10.14.6 

The error Message is “The file/URI/Uesers/macuser/desktop/Lake 19-20.gnucash 
could not be found. The file is in the history list do you want to remove it.” 

The process I am going through
Making an new set of accounts
File- new-file-go through new account set up
File-Save as-

Data format-xml
Name lake 19 20.gnucash
Desktop-macuser-desktop create file lake19 20

Making another new set of accounts
File- new-file-go through new account set up
Then
Save as
Data format-xml
Name Oxley 19 20.gnucash
Desktop-macuser-desktop create file Oxley 19 20

Now have 2 files on the desktop the first file, Lake 19 20 and the Oxley 19 20 
both have the Oxley accounts in them.

Following the file open in Gnucash is retrieving the correct accounts from the 
saved files on the desktop, even though opening from the desktop they are 
different??

 I will work with opening from Gnucash and see how I go, wondering about the 
implications for back up?

Thanks a lot for your advice, really helpful

Regards
Andrew



> On 13/04/2020, at 11:30 PM, Adrien Monteleone 
>  wrote:
> 
> If on a Mac, indeed you cannot double-click the file to open. You have to use 
> File > Open (or the recents list) from within GnuCash.
> 
> As for exporting and importing the account tree, that should be as simple as 
> File > Export > Export Account Tree to CSV, and then in the new file: File > 
> Import > Import Accounts from CSV.
> 
> As for the error message and saving, we’d need the text of the message to 
> advise further.
> 
> Regards,
> Adrien
> 
> 
> 
>> On Apr 13, 2020 w16d104, at 1:55 AM, David Carlson 
>>  wrote:
>> 
>> I think you tried to include an attachment that failed to come through.  It
>> would suffice to give the text of the message.
>> 
>> Also, it would be helpful to know what OS you are on.  From your email
>> address I suspect that it might be an Apple something.  I know nothing
>> about those, except that you need to use a certain procedure to find and
>> open multiple files.
>> 
>> On Sun, Apr 12, 2020 at 11:02 PM Andrew Ralph via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>> 
>>> Hi Team really struggling to save and or find any of my files, have been
>>> following instructions over and over in the user guide and have lost a lot
>>> of data and time, really frustrating.
>>> 
>>> I am trying to set up multiple Files/accounts Linking 5 different banking
>>> accounts (importing data) to seperate files book of accounts. Personal
>>> account and 4 Rental properties want a seperate set of books for each
>>> property for each financial year. The account hierarchy will be the same
>>> for each property x 4, I have a seperate bank account for each property.
>>> 
>>> Have not been able to export the hierarchy to the seperate accounts
>>> 
>>> Can open initially in the 4 recents in the file drop down menu but when
>>> following instructions to save file File -Save as-name - documents and
>>> create a file  when I try and retrieve data by opening the file get this
>>> message see below.  Also when saving files to different folders they are
>>> named as the previous file not the newly created one. Seems like it should
>>> be a simple process what am I doing wrong?
>>> 
>>> Cheers
>>> Andrew
> 
> ___
> 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.

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

[GNC] New User

[Le Grande Danois]

 Any Danes or Swedes using GNU Cash who would consider helping me getting 
started? I’m thinking via remote control with TeamViewer. I will of course pay 
for this. 

I’m running the economy for three sports clubs that I need to set up. At the 
moment I’m using a commercial program that I want to leave. I do have 
accounting knowledge but in order to get a good start I think I need help 
getting started. 
Thanks 
___
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.

Re: [GNC] Should i create Equity for each currency i had ?

[Adrien Monteleone]

Long,

GnuCash can show you the value of foreign denominated accounts in your own 
currency.

You don’t have to go through the trouble of doing manual transfers to 
accomplish this.

Regards,
Adrien

> On Apr 14, 2020 w16d105, at 3:06 AM, Long  wrote:
> 
> Hello,
> 
> I saw GnuCash guided you in chapter 12 that you should create Equity for
> each currency. 
> But i don't think so, Because when you do that, you will never know
> "Gain/Loss" when you look into Report. Because when the exchange rate
> changed, both assets and equity will be the same.
> I think i should only use my currency (default) in equity accounts (opening
> balances), then using "currency transfer" to transfer money to each assets,
> in this way, i will know "gain/loss" in my book time period. Right ?
> 
> Regards.

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

Re: [GNC] Online price updating

[John Ralls]

> On Apr 13, 2020, at 11:37 AM, Mohamed Omar  wrote:
> 
> Dear All,
> I am testing GnuCash personal finance program ability to update our UAE 
> Finantial Stock Market (Abu Dhabi – ADX & Dubai DFM) .
> I followed the steps of using Finance::Qoute by downloading the file and 
> ActivePerl software. I become upset due to unfortunately my lack of 
> understand some process.
> Can you advise me if I could obtain of market stock prices after complete the 
> installing the the patch file on my PC.

AFAICT there is no module in Finance::Quote for retrieving data from either of 
those exchanges, but the stock quotes might be available through Yahoo. You can 
test that by trying to get quotes from the Yahoo finance web site. If you can 
figure out the right symbols to look up then you can set up your securities in 
GnuCash with those symbols and set the price quote source to yahoo-json.

Regards,
John Ralls.

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

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Ove Grunnér]

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("-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 
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  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.
>
___
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.

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[David Carlson]

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 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("-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 
> 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  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 ma

Re: [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

  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 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("-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 
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  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.






___
gnucash-user mailing list
gnucash-user@gnucash.o

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[David Carlson]

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 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
> >
> >   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 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("-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 
> 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 preferenc

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Stu Perlman]

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 system. I
have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well with
each other.  I am able to get my data from Citi by using an older AqB
release that I have running under Cygwin to pull the data from the Citi's
web server.  I have found that in order to import the files that are
download into GNC that I need to make one file for each account at Citi (by
running aqbanking-cli for one account at a time). I then strip out the 1st
dozen or so lines in the response received.  I have managed to script most
of this so it's not nearly as cumbersome as it may appear, but needing to
enter the password once for each account at Citi is annoying as is needing
to import multiple files into GNC instead of one consolidated file. I tried
to eliminate the repeating password step with the Expect tool, but I could
not get it to work in the Cygwin environment.

Unfortunately, the other financial institutions where I have multiple
accounts don't even support OFX (or at least if they do, the info is not
available on OFXhome.net)  so I don't know if the issues I have run into
are caused by Citi, GNC, or AqB. These issues are not so annoying that I
would go back to Quicken! LOLI may mess around with trying to automate
my calls to aqbanking-cli using PowerShell so that I can take Cygwin out of
the mix and/or just try moving over to my Ubuntu system for GNC.

- Stu






On Tue, Apr 14, 2020 at 2:40 PM David Carlson 
wrote:

> 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 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("-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 
>> 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  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 O

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Ove Grunnér]

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 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 system. I
> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well with
> each other.  I am able to get my data from Citi by using an older AqB
> release that I have running under Cygwin to pull the data from the Citi's
> web server.  I have found that in order to import the files that are
> download into GNC that I need to make one file for each account at Citi (by
> running aqbanking-cli for one account at a time). I then strip out the 1st
> dozen or so lines in the response received.  I have managed to script most
> of this so it's not nearly as cumbersome as it may appear, but needing to
> enter the password once for each account at Citi is annoying as is needing
> to import multiple files into GNC instead of one consolidated file. I tried
> to eliminate the repeating password step with the Expect tool, but I could
> not get it to work in the Cygwin environment.
>
> Unfortunately, the other financial institutions where I have multiple
> accounts don't even support OFX (or at least if they do, the info is not
> available on OFXhome.net)  so I don't know if the issues I have run into
> are caused by Citi, GNC, or AqB. These issues are not so annoying that I
> would go back to Quicken! LOLI may mess around with trying to automate
> my calls to aqbanking-cli using PowerShell so that I can take Cygwin out of
> the mix and/or just try moving over to my Ubuntu system for GNC.
>
> - Stu
>
>
>
>
>
>
> On Tue, Apr 14, 2020 at 2:40 PM David Carlson 
> wrote:
>
>> 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 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("-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 
>>> 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

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

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 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 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 system. I
have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well with
each other.  I am able to get my data from Citi by using an older AqB
release that I have running under Cygwin to pull the data from the Citi's
web server.  I have found that in order to import the files that are
download into GNC that I need to make one file for each account at Citi (by
running aqbanking-cli for one account at a time). I then strip out the 1st
dozen or so lines in the response received.  I have managed to script most
of this so it's not nearly as cumbersome as it may appear, but needing to
enter the password once for each account at Citi is annoying as is needing
to import multiple files into GNC instead of one consolidated file. I tried
to eliminate the repeating password step with the Expect tool, but I could
not get it to work in the Cygwin environment.

Unfortunately, the other financial institutions where I have multiple
accounts don't even support OFX (or at least if they do, the info is not
available on OFXhome.net)  so I don't know if the issues I have run into
are caused by Citi, GNC, or AqB. These issues are not so annoying that I
would go back to Quicken! LOLI may mess around with trying to automate
my calls to aqbanking-cli using PowerShell so that I can take Cygwin out of
the mix and/or just try moving over to my Ubuntu system for GNC.

- Stu






On Tue, Apr 14, 2020 at 2:40 PM David Carlson 
wrote:


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 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("-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 
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 
wrote:


Hello,

I am using GNC on Windows 10.  I have a fairly recent build, dated

March 9

from the maintenance branch.

I 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

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 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 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 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 system. I
have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well with
each other.  I am able to get my data from Citi by using an older AqB
release that I have running under Cygwin to pull the data from the Citi's
web server.  I have found that in order to import the files that are
download into GNC that I need to make one file for each account at Citi (by
running aqbanking-cli for one account at a time). I then strip out the 1st
dozen or so lines in the response received.  I have managed to script most
of this so it's not nearly as cumbersome as it may appear, but needing to
enter the password once for each account at Citi is annoying as is needing
to import multiple files into GNC instead of one consolidated file. I tried
to eliminate the repeating password step with the Expect tool, but I could
not get it to work in the Cygwin environment.

Unfortunately, the other financial institutions where I have multiple
accounts don't even support OFX (or at least if they do, the info is not
available on OFXhome.net)  so I don't know if the issues I have run into
are caused by Citi, GNC, or AqB. These issues are not so annoying that I
would go back to Quicken! LOLI may mess around with trying to automate
my calls to aqbanking-cli using PowerShell so that I can take Cygwin out of
the mix and/or just try moving over to my Ubuntu system for GNC.

- Stu






On Tue, Apr 14, 2020 at 2:40 PM David Carlson 
wrote:


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 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("-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 
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 A

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Stu Perlman]

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, Apr 14, 2020 at 3:07 PM David Carlson 
wrote:

> 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 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
> > >
> > >   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 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("-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 
> > 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
>

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Stu Perlman]

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 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 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 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 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 system. I
> >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well
> with
> >> each other.  I am able to get my data from Citi by using an older AqB
> >> release that I have running under Cygwin to pull the data from the
> Citi's
> >> web server.  I have found that in order to import the files that are
> >> download into GNC that I need to make one file for each account at Citi
> (by
> >> running aqbanking-cli for one account at a time). I then strip out the
> 1st
> >> dozen or so lines in the response received.  I have managed to script
> most
> >> of this so it's not nearly as cumbersome as it may appear, but needing
> to
> >> enter the password once for each account at Citi is annoying as is
> needing
> >> to import multiple files into GNC instead of one consolidated file. I
> tried
> >> to eliminate the repeating password step with the Expect tool, but I
> could
> >> not get it to work in the Cygwin environment.
> >>
> >> Unfortunately, the other financial institutions where I have multiple
> >> accounts don't even support OFX (or at least if they do, the info is not
> >> available on OFXhome.net)  so I don't know if the issues I have run into
> >> are caused by Citi, GNC, or AqB. These issues are not so annoying that I
> >> would go back to Quicken! LOLI may mess around with trying to
> automate
> >> my calls to aqbanking-cli using PowerShell so that I can take Cygwin
> out of
> >> the mix and/or just try moving over to my Ubuntu system for GNC.
> >>
> >> - Stu
> >>
> >>
> >>
> >>
> >>
> >>
> >> On Tue, Apr 14, 2020 at 2:40 PM David Carlson <
> david.carlson@gmail.com>
> >> wrote:
> >>
> >>> 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 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("-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 = transactionDescrip

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[Jean Laroche]

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 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 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 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 Perlman mailto:sgperl...@gmail.com>> 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 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
system. I
 >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all
play well with
 >> each other.  I am able to get my data from Citi by using an
older AqB
 >> release that I have running under Cygwin to pull the data from
the Citi's
 >> web server.  I have found that in order to import the files that are
 >> download into GNC that I need to make one file for each account
at Citi (by
 >> running aqbanking-cli for one account at a time). I then strip
out the 1st
 >> dozen or so lines in the response received.  I have managed to
script most
 >> of this so it's not nearly as cumbersome as it may appear, but
needing to
 >> enter the password once for each account at Citi is annoying as
is needing
 >> to import multiple files into GNC instead of one consolidated
file. I tried
 >> to eliminate the repeating password step with the Expect tool,
but I could
 >> not get it to work in the Cygwin environment.
 >>
 >> Unfortunately, the other financial institutions where I have
multiple
 >> accounts don't even support OFX (or at least if they do, the
info is not
 >> available on OFXhome.net)  so I don't know if the issues I have
run into
 >> are caused by Citi, GNC, or AqB. These issues are not so
annoying that I
 >> would go back to Quicken! LOL    I may mess around with trying
to automate
 >> my calls to aqbanking-cli using PowerShell so that I can take
Cygwin out of
 >> the mix and/or just try moving over to my Ubuntu system for GNC.
 >>
 >> - Stu
 >>
 >>
 >>
 >>
 >>
 >>
 >> On Tue, Apr 14, 2020 at 2:40 PM David Carlson
mailto:david.carlson@gmail.com>>
 >> wrote:
 >>
 >>> 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
mailto: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("-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[] transactio

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[David Carlson]

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.

When I mentioned three tags that appear in OFX files that I receive I only
gave selected examples   not a complete definition. One would need to get a
copy of the OFX standard for completeness.




On Tue, Apr 14, 2020, 3:14 PM Stu Perlman  wrote:

> 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 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 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 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 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
> system. I
> > >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all play well
> > with
> > >> each other.  I am able to get my data from Citi by using an older AqB
> > >> release that I have running under Cygwin to pull the data from the
> > Citi's
> > >> web server.  I have found that in order to import the files that are
> > >> download into GNC that I need to make one file for each account at
> Citi
> > (by
> > >> running aqbanking-cli for one account at a time). I then strip out the
> > 1st
> > >> dozen or so lines in the response received.  I have managed to script
> > most
> > >> of this so it's not nearly as cumbersome as it may appear, but needing
> > to
> > >> enter the password once for each account at Citi is annoying as is
> > needing
> > >> to import multiple files into GNC instead of one consolidated file. I
> > tried
> > >> to eliminate the repeating password step with the Expect tool, but I
> > could
> > >> not get it to work in the Cygwin environment.
> > >>
> > >> Unfortunately, the other financial institutions where I have multiple
> > >> accounts don't even support OFX (or at least if they do, the info is
> not
> > >> available on OFXhome.net)  so I don't know if the issues I have run
> into
> > >> are caused by Citi, GNC, or AqB. These issues are not so annoying
> that I
> > >> would go back to Quicken! LOLI may mess around with trying to
> > automate
> > >> my calls to aqbanking-cli using PowerShell so that I can take Cygwin
> > out of
> > >> the mix and/or just try moving over to my Ubuntu system for GNC.
> > >>
> > >> - Stu
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> On Tue, Apr 14, 2020 at 2:40 PM David Carlson <
> > david.carlson@gmail.com>
> > >> wrote:
> > >>
> > >>> 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 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("-MM-dd");
> > 
> >   // get data for this account
> >   String targetFileAccountName =
> > accountTable.getTransactionTableAccountName(acc);
> >   String[] transactionDescription =
> > accountTable.getTransactionDescription(acc);
> >   float[] transactionAmount =
> > 

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

[jean laroche]

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 that was between   and 
  (including these) from one file, and copied it right 
after the
  from the other file, saved and imported. I get the 
transactions from both accounts in one shot.

That's pretty cool.
So if that's not working for you, you should look at your OFX file and 
try to identify where the problem originates...

Jean


On 4/14/2020 1:29 PM, David Carlson wrote:

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.


When I mentioned three tags that appear in OFX files that I receive I 
only gave selected examples   not a complete definition. One would 
need to get a copy of the OFX standard for completeness.





On Tue, Apr 14, 2020, 3:14 PM Stu Perlman > wrote:


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 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 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 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 Perlman mailto:sgperl...@gmail.com>> 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 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 system. I
> >> have yet to get GNC, AqBanking 6.x and Citi's OFX API to all
play well
> with
> >> each other.  I am able to get my data from Citi by using an
older AqB
> >> release that I have running under Cygwin to pull the data
from the
> Citi's
> >> web server.  I have found that in order to import the files
that are
> >> download into GNC that I need to make one file for each
account at Citi
> (by
> >> running aqbanking-cli for one account at a time). I then
strip out the
> 1st
> >> dozen or so lines in the response received.  I have managed
to script
> most
> >> of this so it's not nearly as cumbersome as it may appear,
but needing
> to
> >> enter the password once for each account at Citi is annoying
as is
> needing
> >> to import multiple files into GNC instead of one consolidated
file. I
> tried
> >> to eliminate the repeating password step with the Expect
tool, but I
> could
> >> not get it to work in the Cygwin environment.
> >>
> >> Unfortunately, the other financial institutions where I have
multiple
> >> accounts don't even support OFX (or at least if they do, the
info is not
> >> available on OFXhome.net)  so I don't know if the issues I
have run into
> >> are caused by Citi, GNC, or AqB. These issues are not so
annoying that I
> >> would go back to Quicken! LOL    I may mess around with trying to
> automate
> >> my calls to aqbanking-cli using PowerShell so that I can take
Cygwin
> out of
> >> the mix and/or just try moving over to my Ubuntu system for GNC.
> >>
> >> - Stu
> >>
> >>
> >>
> >>
> >>
> >>
> >> On Tue, Apr 14, 2020 at 2:40 PM David Carlson <
> david.carlson@gmail.com >
> >> wrote:
> >>
> >>> 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
mailto: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

Re: [GNC] Broken QFX import in 3.8

[Jon Schewe]

On Sun, 2020-01-19 at 09:06 -0800, John Ralls wrote:
> 
> On Jan 19, 2020, at 5:01 AM, Tom Teixeira  wrote:
> 
> On 1/5/20 8:53 AM, Jon Schewe wrote:
> I just got version 3.8 using flatpak and it seems that the QFX import
> is broken. I download my QFX files as usual. Then use the import menu
> item to load the file. However GnuCash maps to one of my stock
> accounts rather than the correct bank account. Version 3.7 worked just
> fine.
> 
> Has anyone else seen this? Is there a way around it?
> 
> Jon
> 
> I also ran into this problem and rolled bacl to Version 3.7
> 
> 
> It's due to a change in the import matcher to accommodate AQBanking 6 which 
> had an unintended affect on both file imports and on accounts with sub 
> accounts. https://github.com/Gnucash/gnucash/pull/631 will fix it, we're 
> waiting on testing with FinTS to make sure that it doesn't break that.
> 

I've upgraded to 3.9 via flatpak and it's working now.
___
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.