Thank you both. I’ll work on a report. > On Jan 4, 2023, at 07:00, Kalpesh Patel <kalpesh.pa...@usa.net> wrote: > > 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 > <Screenshot 2023-01-04 075256.jpg>
_______________________________________________ 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.
