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

Tue Jan 3 19:27:59 EST 2023

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