[GNC] Missing "Buy" action after import of QIF file
Derek Atkins
derek at ihtfp.com
Tue Jan 3 19:50:27 EST 2023
Screen cap came through (at least to me) -- but you cut out too much info
so I can't tell what I'm supposed to be seeing or not.
-derek
On Tue, January 3, 2023 7:35 pm, ml at tgr66.me wrote:
> 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
>>
>
>
--
Derek Atkins 617-623-3745
derek at ihtfp.com www.ihtfp.com
Computer and Internet Security Consultant
More information about the gnucash-user
mailing list