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

Tue Jan 3 19:35:27 EST 2023

Yes. Trying again to paste a screen cap.

I also tried on my Linux box and got the same result. No action showing.

> On Jan 3, 2023, at 18:27, Derek Atkins <derek at ihtfp.com> wrote:
> 
> Are you in double-line mode?  If not, try turning that on..
> 
> -derek
> 
> On Tue, January 3, 2023 7:16 pm, ml at tgr66.me wrote:
>> 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
>>> 
>>> 
>>> 
>>> ------------------------------
>>> 
>> 
>> 
> 
> 
> -- 
>       Derek Atkins                 617-623-3745
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
> 