[GNC] Missing "Buy" action after import of QIF file

Tue Jan 3 19:16:58 EST 2023

I only included the snippet relevant to the question; my real file has the header lines and carets. The back ticks were included because I’m used to using those to show a code block :-) They’re not in the real file. I’ll include the entire test file at the end of this message.

So I just double checked, and the Buy action is not selected in either the `XYZ` account or in “Joint Brokerage” account. I don’t know where else I should be looking.

I’m on Mac with GnuCash v4.13. 

I can also try on a Linux box.

!Account
NAssets:Investments:Brokerage Account:Joint Brokerage
TInvst
^
!Type:Bank
D01/11/2020
NPayment/Deposit
PTrf My Bank
CX
T1,000.00
MDeposit
LAssets:Current Assets:My Bank
^
!Type:Invst
D12/2/2022
NBuy
PXYZ, INC
YXYZ
I150
T450
Q3
CR
M3 shares @ 150; Nothing to see here
^
!Type:Invst
D1/1/2023
NDiv
PXYZ, INC
YXYZ
T16.23
CR
MInvestments:Dividend Income; Still nothing
^

> On Jan 3, 2023, at 16:09, Kalpesh Patel <kalpesh.patel at usa.net> wrote:
> 
> Your QIF may not be complete. I believe it is not documented but need first
> four lines and the last line as shown in the below example; carets are
> important in qif format as well! This would be the minimal example:
> 
> !Account
> NTest
> TInvst
> ^
> !Type:Invst
> D12/2/2022
> NBuy
> PXYZ, INC
> YXYZ
> I150
> T450
> Q3
> CR
> M3 shares @ 150; Nothing to see here
> ^
> 
> 
> With that qif file contents, a top level 'Test' account created, child
> account called 'XYZ' created under 'Test' account, a buy entry for 3 shares
> created and a new security called XYZ under NONCURRENCY namespace created. I
> also think back ticks at beginning and end of the one you provided in the
> message are extraneous when included.
> 
> I am on Windows 11 running GNC v4.11.
> 
> ------------------------------
> 
> Message: 2
> Date: Tue, 3 Jan 2023 09:37:05 -0600
> From: ml at tgr66.me
> To: gnucash-user at gnucash.org
> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
> Message-ID: <84E2BF01-D789-4F0D-A16E-065358BBF4B1 at tgr66.me>
> Content-Type: text/plain;	charset=utf-8
> 
> Oops, I guess the mailing list doesn?t show attached images.
> 
>> On Jan 2, 2023, at 19:51, ml at tgr66.me wrote:
>> 
>> In my import file:
>> 
>> ```
>> !Type:Invst
>> D12/2/2022
>> NBuy
>> PXYZ, INC
>> YXYZ
>> I150
>> T450
>> Q3
>> CR
>> M3 shares @ 150; Nothing to see here
>> ```
>> 
>> Import and GnuCash creates the correct account, but notice the lack of a
> ?Buy? action:
>> 
>> 
>> 
>> Is this a known issue or am I misunderstanding the need for the action to
> be shown there?
>> _______________________________________________
>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Tue, 3 Jan 2023 10:46:56 -0500
> From: "Derek Atkins" <derek at ihtfp.com>
> To: ml at tgr66.me
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] Missing "Buy" action after import of QIF file
> Message-ID: <9a802229f90f37a850599830d27ce46a.squirrel at mail.ihtfp.org>
> Content-Type: text/plain;charset=utf-8
> 
> Hi,
> 
> On Tue, January 3, 2023 10:37 am, ml at tgr66.me wrote:
>> Oops, I guess the mailing list doesn?t show attached images.
> 
> You need to attach it as a file, not embed it in HTML.
> 
>> 
>>> On Jan 2, 2023, at 19:51, ml at tgr66.me wrote:
>>> 
>>> In my import file:
>>> 
>>> ```
>>> !Type:Invst
>>> D12/2/2022
>>> NBuy
>>> PXYZ, INC
>>> YXYZ
>>> I150
>>> T450
>>> Q3
>>> CR
>>> M3 shares @ 150; Nothing to see here
>>> ```
>>> 
>>> Import and GnuCash creates the correct account, but notice the lack 
>>> of a ?Buy? action:
> 
> The QIF Importer should set the Action field, but it's possible it only sets
> it on "one side" (which may not be the side you're looking at).
> 
> -derek
> 
>>> 
>>> 
>>> 
>>> Is this a known issue or am I misunderstanding the need for the 
>>> action to be shown there?
>>> _______________________________________________
>>> 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
>>> -----
>>> 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
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
> 
> 
> 
> ------------------------------
> 