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 <de...@ihtfp.com> Sent: Wednesday, January 04, 2023 7:32 AM To: m...@tgr66.me Cc: Kalpesh Patel <kalpesh.pa...@usa.net>; gnucash-user@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, m...@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 <de...@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, m...@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 <de...@ihtfp.com> wrote: >>>> >>>> Are you in double-line mode? If not, try turning that on.. >>>> >>>> -derek >>>> >>>> On Tue, January 3, 2023 7:16 pm, m...@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.pa...@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: m...@tgr66.me >>>>>> To: gnucash-user@gnucash.org >>>>>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file >>>>>> Message-ID: <84e2bf01-d789-4f0d-a16e-065358bbf...@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, m...@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@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" <de...@ihtfp.com> >>>>>> To: m...@tgr66.me >>>>>> Cc: gnucash-user@gnucash.org >>>>>> Subject: Re: [GNC] Missing "Buy" action after import of QIF file >>>>>> Message-ID: >>>>>> <9a802229f90f37a850599830d27ce46a.squir...@mail.ihtfp.org> >>>>>> Content-Type: text/plain;charset=utf-8 >>>>>> >>>>>> Hi, >>>>>> >>>>>> On Tue, January 3, 2023 10:37 am, m...@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, m...@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@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@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 >>>>>> de...@ihtfp.com www.ihtfp.com >>>>>> Computer and Internet Security Consultant >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------ >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Derek Atkins 617-623-3745 >>>> de...@ihtfp.com www.ihtfp.com >>>> Computer and Internet Security Consultant >>>> >>> >>> >> >> >> -- >> Derek Atkins 617-623-3745 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> > > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant
_______________________________________________ gnucash-user mailing list gnucash-user@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.
