[GNC] Missing "Buy" action after import of QIF file
Kalpesh Patel
kalpesh.patel at usa.net
Tue Jan 3 17:09:17 EST 2023
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
------------------------------
More information about the gnucash-user
mailing list