[GNC] unable to import simple investment transaction from qif

[David Carlson]

Ar,
Please reply to all so others can see and perhaps provide additional
information. I have done that for you this time.

I do not have an example but you can create one by exporting an existing
transaction.

On Mon, Dec 12, 2022, 7:34 AM ar <ar123456 at gmail.com> wrote:

> Hi David,
>
> I am using 4.12 unfortunately I was not able to find any example of using
> the greatly improved csv for the import of investment data.
>
> I would appreciate a pointer.
>
> Thank you,
>
> Aleksey
>
>
> On Sun, Dec 11, 2022 at 9:19 PM David Carlson <david.carlson.417 at gmail.com>
> wrote:
>
>> If you are using a recent release of GnuCash, ie 4.something, the csv
>> transaction import feature has been greatly improved and includes the
>> ability to save and re-use settings .
>>
>> It definitely works to import investment transactions previously exported
>> from GnuCash,  so it should work with generic files as well, possibly with
>> some massage.
>>
>> I don't know if the qif import process can handle investments even though
>> Quicken can export them in that format it requires split transactions which
>> qif importer seems to choke on.
>>
>>
>>
>> On Sun, Dec 11, 2022, 7:25 PM ar <ar123456 at gmail.com> wrote:
>>
>>> Hi,
>>>
>>> I am trying to import avery simple transaction from qif: just 2 buy
>>> transaction for the same account, containing  mutual fund MMMM
>>>
>>> The 'Assets:Investments:XXXXX' is gnu cash account tracking shares of
>>> MMMM,
>>> 'Asserts:Investments:YYYY' is a gnucash cash account.
>>>
>>> If I do not provide security symbol as below, the import fails when it
>>> requires to enter the security.
>>>
>>> !Account
>>> NAssets:Investments:XXXXX
>>> TInvst
>>> ^
>>> !Type:Invst
>>> D07/16'2022
>>> NBuy
>>> LAssets:Investments:YYYYY
>>> Q34.107
>>> T-77.58
>>> ^
>>> D07/15'2022
>>> NBuy
>>> LAssets:Investments:YYYYY
>>> Q7.638
>>> T-37.7
>>> ^
>>>
>>> I provide security as YMMMM, the import creates account
>>> Assets:Investments:XXXXX:MMMM that conflicts with
>>> 'Assets:Investments:XXXXX'
>>>
>>> 1. Does this feature works? If Yes are there usage examples.
>>> 2. I do not insist on using qif format, is it possible to use .csv for
>>> import, are there examples?
>>> 3. It seems that csv import requires a lot of manual selections to be
>>> made
>>> for every imported file, am I getting it right?
>>>
>>> Thank you,
>>>
>>> Aleksey
>>> _______________________________________________
>>> 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.
>>>
>>