Re: [GNC] Missing "Buy" action after import of QIF file
Thank you both. I’ll work on a report. > On Jan 4, 2023, at 07:00, Kalpesh Patel 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 > Sent: Wednesday, January 04, 2023 7:32 AM > To: m...@tgr66.me > Cc: Kalpesh Patel ; 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 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 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 >>>>>>> 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 >>>>>>> ex
Re: [GNC] Missing "Buy" action after import of QIF file
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 Sent: Wednesday, January 04, 2023 7:32 AM To: m...@tgr66.me Cc: Kalpesh Patel ; 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 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 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 >>>>>> 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 ^ >>>>>> >
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 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 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 >>>>>> 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 >
Re: [GNC] Missing "Buy" action after import of QIF file
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 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 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 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: >>>>>> >>>>&
Re: [GNC] Missing "Buy" action after import of QIF file
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 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 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? >>&
Re: [GNC] Missing "Buy" action after import of QIF file
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 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 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" >>> To: m...@tgr66.me >>> Cc: gnucash-user@gnucash.org >>> Subject: Re: [GNC] Missing "Buy&qu
Re: [GNC] Missing "Buy" action after import of QIF file
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 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" >> 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 >>
Re: [GNC] Missing "Buy" action after import of QIF file
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 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" > 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 unsubsc
Re: [GNC] Missing "Buy" action after import of QIF file
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" 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 -- ___ 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.
Re: [GNC] Missing "Buy" action after import of QIF file
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 ___ 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.
Re: [GNC] Missing "Buy" action after import of QIF file
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. ___ 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.
[GNC] Missing "Buy" action after import of QIF file
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.