[GNC] Missing "Buy" action after import of QIF file
ml at tgr66.me
ml at tgr66.me
Tue Jan 3 20:14:56 EST 2023
This is what I would expect to see. Note the “Buy” in the Action field.
However, I had to add that as the QIF import process doesn’t appear to be doing it.
Thank you.
> On Jan 3, 2023, at 18:50, Derek Atkins <derek at ihtfp.com> wrote:
>
> 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