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

Kalpesh Patel kalpesh.patel at usa.net
Wed Jan 4 08:00:42 EST 2023


I stand corrected as well. The Action column is never updated with the action denoted in the qif file. Nonetheless the right side buy and sell columns do reflect correct transaction (which Derek confirmed by walking the code), which is what I was looking at it before, albeit it is not easy on the eyes to decipher what transaction is what. Since Action column never had any information in it (since at least going back 3.4 version), I have gotten used to looking at the right side columns.

As a follow on, it does not populate for OFX imports either so might be absent for all import methods.

That should be a bug IMHO; not a RFE.
  

-----Original Message-----
From: Derek Atkins <derek at ihtfp.com> 
Sent: Wednesday, January 04, 2023 7:32 AM
To: ml at tgr66.me
Cc: Kalpesh Patel <kalpesh.patel at usa.net>; gnucash-user at gnucash.org
Subject: Re: [GNC] Missing "Buy" action after import of QIF file

Looking at the code, you are correct; the importer never calls xaccSplitSetAction.

It USES the action to figure out how to process the transaction, but it never actually saves it.

Feel free to file an RFE in Bugzilla.

-derek

On Tue, January 3, 2023 8:14 pm, ml at tgr66.me wrote:
> 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
>>
>
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot 2023-01-04 075256.jpg
Type: image/jpeg
Size: 51632 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230104/6bbf4768/attachment-0001.jpg>


More information about the gnucash-user mailing list