Re: [GNC] unable to import simple investment transaction from qif
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 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 > 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 wrote: >> >>> Hi, >>> >>> I am trying to import avery simple transaction from qif: just 2 buy >>> transaction for the same account, containing mutual fund >>> >>> The 'Assets:Investments:X' is gnu cash account tracking shares of >>> , >>> 'Asserts:Investments:' 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:X >>> TInvst >>> ^ >>> !Type:Invst >>> D07/16'2022 >>> NBuy >>> LAssets:Investments:Y >>> Q34.107 >>> T-77.58 >>> ^ >>> D07/15'2022 >>> NBuy >>> LAssets:Investments:Y >>> Q7.638 >>> T-37.7 >>> ^ >>> >>> I provide security as Y, the import creates account >>> Assets:Investments:X: that conflicts with >>> 'Assets:Investments:X' >>> >>> 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@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.
Re: [GNC] unable to import simple investment transaction from qif
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 wrote: > Hi, > > I am trying to import avery simple transaction from qif: just 2 buy > transaction for the same account, containing mutual fund > > The 'Assets:Investments:X' is gnu cash account tracking shares of , > 'Asserts:Investments:' 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:X > TInvst > ^ > !Type:Invst > D07/16'2022 > NBuy > LAssets:Investments:Y > Q34.107 > T-77.58 > ^ > D07/15'2022 > NBuy > LAssets:Investments:Y > Q7.638 > T-37.7 > ^ > > I provide security as Y, the import creates account > Assets:Investments:X: that conflicts with > 'Assets:Investments:X' > > 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@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] unable to import simple investment transaction from qif
Hi, I am trying to import avery simple transaction from qif: just 2 buy transaction for the same account, containing mutual fund The 'Assets:Investments:X' is gnu cash account tracking shares of , 'Asserts:Investments:' 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:X TInvst ^ !Type:Invst D07/16'2022 NBuy LAssets:Investments:Y Q34.107 T-77.58 ^ D07/15'2022 NBuy LAssets:Investments:Y Q7.638 T-37.7 ^ I provide security as Y, the import creates account Assets:Investments:X: that conflicts with 'Assets:Investments:X' 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@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.