Re: [GNC] Transaction imports
On Tue, Jul 5, 2022 at 07:53 Christian Lynbech wrote: > Where is the information related to transaction imports saved? I am on a > Mac. > > I have my books stored under revision control FWIW, I also keep mine under version control with git. I make sure the data file is in **unzipped xml format** to help the diffing be at least somewhat easier for a human eye to interpret if need be. -Tom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction imports
Christian, The import data matching information is stored in the individual data file. Not sure about import configuraion information. See the following for more info. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-migrate-settings.html David Cousens On Tue, 2022-07-05 at 14:52 +0200, Christian Lynbech wrote: > Where is the information related to transaction imports saved? I am on a Mac. > > I have my books stored under revision control but when I wanted to do an > CSV import on a another machine, I did not see the import I have defined > when running Gnucash on my main computer. I am guessing/fearing that > this also applies to the learned matching of transactions to accounts. > > How would I replicate such information between computers? > >/Christian > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction imports
Thanks. /Christian --- On Tue, Jul 05 2022, john wrote: On Jul 5, 2022, at 5:52 AM, Christian Lynbech wrote: Where is the information related to transaction imports saved? I am on a Mac. I have my books stored under revision control but when I wanted to do an CSV import on a another machine, I did not see the import I have defined when running Gnucash on my main computer. I am guessing/fearing that this also applies to the learned matching of transactions to accounts. How would I replicate such information between computers? The transaction matching tokens are kept in "slots" records belonging to the account into which you were importing the transactions. This is part of the book (i.e. .gnucash) file so you need only copy or share it between machines. Saved report and CSV configurations are kept in the DOT-GNUCASH folder, which on macOS is ~ /Library/Application Support/gnucash. See https://wiki.gnucash.org/wiki/Backup for more about where GnuCash keeps data and how to make thorough backups or share books between machines. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction imports
> On Jul 5, 2022, at 5:52 AM, Christian Lynbech wrote: > > Where is the information related to transaction imports saved? I am on a Mac. > > I have my books stored under revision control but when I wanted to do an > CSV import on a another machine, I did not see the import I have defined > when running Gnucash on my main computer. I am guessing/fearing that > this also applies to the learned matching of transactions to accounts. > > How would I replicate such information between computers? The transaction matching tokens are kept in "slots" records belonging to the account into which you were importing the transactions. This is part of the book (i.e. .gnucash) file so you need only copy or share it between machines. Saved report and CSV configurations are kept in the DOT-GNUCASH folder, which on macOS is ~/Library/Application Support/gnucash. See https://wiki.gnucash.org/wiki/Backup for more about where GnuCash keeps data and how to make thorough backups or share books between machines. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Transaction imports
Where is the information related to transaction imports saved? I am on a Mac. I have my books stored under revision control but when I wanted to do an CSV import on a another machine, I did not see the import I have defined when running Gnucash on my main computer. I am guessing/fearing that this also applies to the learned matching of transactions to accounts. How would I replicate such information between computers? /Christian ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction Imports
Anyone have a how-to or tutorial on how to import stock transactions
from a CSV file? I'm not finding anything in the documentation on how
to handle the different commodities.
On Sun, 2022-06-19 at 15:10 -0500, Jon Schewe wrote:
> I'm trying to do a similar import and I'm finding that I can't
> convince
> GnuCash to enter the other account. I'm using import transactions
> from
> CSV.I have matched columns to Date, Description, Account, Price,
> Deposit, Transfer Account.The "Account" column is the mutual fund
> account.The "Transfer Account" column is the currency account.
> When I start the import process all of my transactions need an
> account
> to transfer from, despite specifying the Transfer Account. When I try
> and select my currency account I'm told that it has the wrong
> commodity.
> I have another column for the currency amount, but I don't know what
> to
> map that to in the importer.
> I tried checkout out
> https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
>
> but it doesn't seem to address this.Suggestions on where I'm going
> wrong.
> On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote:
> > Further to this: you care about how much money something cost (the
> > amount you have spent), and how much you got for it (the amount of
> > shares you purchased). The first affects how much money you have in
> > your bank account, the second affects how many shares show in your
> > mutual fund.
> > On April 11, 2022 8:16:06 PM EDT, Stu Perlman <
> > sgperl...@gmail.com
> > >
> > wrote:
> > > Thank for the heads up.
> > > On Mon, Apr 11, 2022 at 3:03 PM D <
> > > sunfis...@yahoo.com
> > > > wrote:
> > > > Not going to go into great detail here, but you definitely
> > > > DON'T
> > > > want tohave gnucash calculate shares. Have it calculate
> > > > price.On
> > > > Apr 11, 2022, at 11:21, Stu Perlman <
> > > > sgperl...@gmail.com
> > > > > wrote:
> > > > > Hello Everyone,
> > > > > I am looking for some guidance on how to import a few hundred
> > > > > transactionsfrom my 401(k) account.Unfortunately, the plan
> > > > > administrator does not offer a good option forexporting the
> > > > > transaction data but I am able to get what I need with
> > > > > somebasic web scraping.
> > > > > I have been experimenting with creating a multi-split CSV
> > > > > import from thedata that I have captured.What I wanted to do
> > > > > was a file layout such as:
> > > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/20
> > > > > 21
> > > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index
> > > > > Institutional
> > > > > Fund,299.26,0.916289038,326.601/19/2021,Contribution,Cash,-
> > > > > 299.26,,Vanguard Institutional Index Institutional
> > > > > Fund,299.26,0.892008703,335.49
> > > > >
> > > > > My wishful thinking was that I could put the number of shares
> > > > > into the memocolumn for reference (but that the system would
> > > > > auto-calculate that numberusing the provided Price and
> > > > > transaction amount ("Deposit")).I hit a blocker on the second
> > > > > to last step of the import wizard with themessage: "*The
> > > > > account 'Vanguard Institutional Index Fund' has a
> > > > > differentcommodity to the one required, 'US Dollar'. Please
> > > > > choose a differentaccount.*"
> > > > > So I'm wondering if there are other ways I can go about what
> > > > > I'm trying toaccomplish? I started with the CSV importer
> > > > > because I figured it would bethe easiest record layout to
> > > > > create but I'm not against using a differentformat if what I
> > > > > want to accomplish can be done.
> > > > > I have a backup plan which is that I will NOT do the multi-
> > > > > split import andwill just select the Cash account for all
> > > > > rows
> > > > > in the Import Previewscreen. I could pack the memo field with
> > > > > the ticker symbol, price,quantity, and total debit and let it
> > > > > all dump into the Imbalance-USDaccount. I would then have to
> > > > > either manually fix them one by one orpossibly script it
> > > > > out. I have done this with success in the past butwould
> > > > > rather
> > > > > just get it right at the data import step if that's in anyway
> > > > > possible.
> > > > > My thanks in advance for any advice offered.
> > > > > - Stu--
> > > > > gnucash-user mailing
> > > > > listgnucash-u...@gnucash.org
> > > > >
> > > > > To update your subscription preferences or to unsubscribe:
> > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > > >
> > > > > If you are using Nabble or Gmane, please see
> > > > > https://wiki.gnucash.org/wiki/Mailing_Lists
> > > > > for more
> > > > > information.-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
> > listgnucash-u...@gnucash.org
> >
> > To update
Re: [GNC] Transaction Imports
I'm trying to do a similar import and I'm finding that I can't convince
GnuCash to enter the other account. I'm using import transactions from
CSV.I have matched columns to Date, Description, Account, Price,
Deposit, Transfer Account.The "Account" column is the mutual fund
account.The "Transfer Account" column is the currency account.
When I start the import process all of my transactions need an account
to transfer from, despite specifying the Transfer Account. When I try
and select my currency account I'm told that it has the wrong
commodity.
I have another column for the currency amount, but I don't know what to
map that to in the importer.
I tried checkout out
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
but it doesn't seem to address this.Suggestions on where I'm going
wrong.
On Mon, 2022-04-11 at 22:36 -0400, David T. via gnucash-user wrote:
> Further to this: you care about how much money something cost (the
> amount you have spent), and how much you got for it (the amount of
> shares you purchased). The first affects how much money you have in
> your bank account, the second affects how many shares show in your
> mutual fund.
> On April 11, 2022 8:16:06 PM EDT, Stu Perlman
> wrote:
> > Thank for the heads up.
> > On Mon, Apr 11, 2022 at 3:03 PM D wrote:
> > > Not going to go into great detail here, but you definitely DON'T
> > > want tohave gnucash calculate shares. Have it calculate price.On
> > > Apr 11, 2022, at 11:21, Stu Perlman wrote:
> > > > Hello Everyone,
> > > > I am looking for some guidance on how to import a few hundred
> > > > transactionsfrom my 401(k) account.Unfortunately, the plan
> > > > administrator does not offer a good option forexporting the
> > > > transaction data but I am able to get what I need with
> > > > somebasic web scraping.
> > > > I have been experimenting with creating a multi-split CSV
> > > > import from thedata that I have captured.What I wanted to do
> > > > was a file layout such as:
> > > > *Date,Description,Account,Deposit,SharesAsMemo,Price*01/04/2021
> > > > ,Contribution,Cash,-299.26,,Vanguard Institutional Index
> > > > Institutional
> > > > Fund,299.26,0.916289038,326.601/19/2021,Contribution,Cash,-
> > > > 299.26,,Vanguard Institutional Index Institutional
> > > > Fund,299.26,0.892008703,335.49
> > > >
> > > > My wishful thinking was that I could put the number of shares
> > > > into the memocolumn for reference (but that the system would
> > > > auto-calculate that numberusing the provided Price and
> > > > transaction amount ("Deposit")).I hit a blocker on the second
> > > > to last step of the import wizard with themessage: "*The
> > > > account 'Vanguard Institutional Index Fund' has a
> > > > differentcommodity to the one required, 'US Dollar'. Please
> > > > choose a differentaccount.*"
> > > > So I'm wondering if there are other ways I can go about what
> > > > I'm trying toaccomplish? I started with the CSV importer
> > > > because I figured it would bethe easiest record layout to
> > > > create but I'm not against using a differentformat if what I
> > > > want to accomplish can be done.
> > > > I have a backup plan which is that I will NOT do the multi-
> > > > split import andwill just select the Cash account for all rows
> > > > in the Import Previewscreen. I could pack the memo field with
> > > > the ticker symbol, price,quantity, and total debit and let it
> > > > all dump into the Imbalance-USDaccount. I would then have to
> > > > either manually fix them one by one orpossibly script it
> > > > out. I have done this with success in the past butwould rather
> > > > just get it right at the data import step if that's in anyway
> > > > possible.
> > > > My thanks in advance for any advice offered.
> > > > - Stu--
> > > > gnucash-user mailing listgnucash-u...@gnucash.org
> > > > To update your subscription preferences or to unsubscribe:
> > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > > If you are using Nabble or Gmane, please see
> > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more
> > > > information.-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
> listgnucash-u...@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.--
> ---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
If you are using Nabble or Gmane, please see
Re: [GNC] Transaction Imports
Further to this: you care about how much money something cost (the amount you
have spent), and how much you got for it (the amount of shares you purchased).
The first affects how much money you have in your bank account, the second
affects how many shares show in your mutual fund.
On April 11, 2022 8:16:06 PM EDT, Stu Perlman wrote:
>Thank for the heads up.
>
>On Mon, Apr 11, 2022 at 3:03 PM D wrote:
>
>> Not going to go into great detail here, but you definitely DON'T want to
>> have gnucash calculate shares. Have it calculate price.
>> On Apr 11, 2022, at 11:21, Stu Perlman wrote:
>>>
>>> Hello Everyone,
>>>
>>> I am looking for some guidance on how to import a few hundred transactions
>>> from my 401(k) account.
>>> Unfortunately, the plan administrator does not offer a good option for
>>> exporting the transaction data but I am able to get what I need with some
>>> basic web scraping.
>>>
>>> I have been experimenting with creating a multi-split CSV import from the
>>> data that I have captured.
>>> What I wanted to do was a file layout such as:
>>>
>>> *Date,Description,Account,Deposit,SharesAsMemo,Price*
>>> 01/04/2021,Contribution,Cash,-299.26
>>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
>>> 01/19/2021,Contribution,Cash,-299.26
>>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
>>>
>>>
>>> My wishful thinking was that I could put the number of shares into the memo
>>> column for reference (but that the system would auto-calculate that number
>>> using the provided Price and transaction amount ("Deposit")).
>>> I hit a blocker on the second to last step of the import wizard with the
>>> message: "*The account 'Vanguard Institutional Index Fund' has a different
>>> commodity to the one required, 'US Dollar'. Please choose a different
>>> account.*"
>>>
>>> So I'm wondering if there are other ways I can go about what I'm trying to
>>> accomplish? I started with the CSV importer because I figured it would be
>>> the easiest record layout to create but I'm not against using a different
>>> format if what I want to accomplish can be done.
>>>
>>> I have a backup plan which is that I will NOT do the multi-split import and
>>> will just select the Cash account for all rows in the Import Preview
>>> screen. I could pack the memo field with the ticker symbol, price,
>>> quantity, and total debit and let it all dump into the Imbalance-USD
>>> account. I would then have to either manually fix them one by one or
>>> possibly script it out. I have done this with success in the past but
>>> would rather just get it right at the data import step if that's in any
>>> way possible.
>>>
>>> My thanks in advance for any advice offered.
>>>
>>> - Stu
>>> --
>>>
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction Imports
Thank for the heads up.
On Mon, Apr 11, 2022 at 3:03 PM D wrote:
> Not going to go into great detail here, but you definitely DON'T want to
> have gnucash calculate shares. Have it calculate price.
> On Apr 11, 2022, at 11:21, Stu Perlman wrote:
>>
>> Hello Everyone,
>>
>> I am looking for some guidance on how to import a few hundred transactions
>> from my 401(k) account.
>> Unfortunately, the plan administrator does not offer a good option for
>> exporting the transaction data but I am able to get what I need with some
>> basic web scraping.
>>
>> I have been experimenting with creating a multi-split CSV import from the
>> data that I have captured.
>> What I wanted to do was a file layout such as:
>>
>> *Date,Description,Account,Deposit,SharesAsMemo,Price*
>> 01/04/2021,Contribution,Cash,-299.26
>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
>> 01/19/2021,Contribution,Cash,-299.26
>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
>>
>>
>> My wishful thinking was that I could put the number of shares into the memo
>> column for reference (but that the system would auto-calculate that number
>> using the provided Price and transaction amount ("Deposit")).
>> I hit a blocker on the second to last step of the import wizard with the
>> message: "*The account 'Vanguard Institutional Index Fund' has a different
>> commodity to the one required, 'US Dollar'. Please choose a different
>> account.*"
>>
>> So I'm wondering if there are other ways I can go about what I'm trying to
>> accomplish? I started with the CSV importer because I figured it would be
>> the easiest record layout to create but I'm not against using a different
>> format if what I want to accomplish can be done.
>>
>> I have a backup plan which is that I will NOT do the multi-split import and
>> will just select the Cash account for all rows in the Import Preview
>> screen. I could pack the memo field with the ticker symbol, price,
>> quantity, and total debit and let it all dump into the Imbalance-USD
>> account. I would then have to either manually fix them one by one or
>> possibly script it out. I have done this with success in the past but
>> would rather just get it right at the data import step if that's in any
>> way possible.
>>
>> My thanks in advance for any advice offered.
>>
>> - Stu
>> --
>>
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction Imports
Not going to go into great detail here, but you definitely DON'T want to have
gnucash calculate shares. Have it calculate price.
On Apr 11, 2022, 11:21, at 11:21, Stu Perlman wrote:
>Hello Everyone,
>
>I am looking for some guidance on how to import a few hundred
>transactions
>from my 401(k) account.
>Unfortunately, the plan administrator does not offer a good option for
>exporting the transaction data but I am able to get what I need with
>some
>basic web scraping.
>
>I have been experimenting with creating a multi-split CSV import from
>the
>data that I have captured.
>What I wanted to do was a file layout such as:
>
>*Date,Description,Account,Deposit,SharesAsMemo,Price*
>01/04/2021,Contribution,Cash,-299.26
>,,Vanguard Institutional Index Institutional
>Fund,299.26,0.916289038,326.6
>01/19/2021,Contribution,Cash,-299.26
>,,Vanguard Institutional Index Institutional
>Fund,299.26,0.892008703,335.49
>
>
>My wishful thinking was that I could put the number of shares into the
>memo
>column for reference (but that the system would auto-calculate that
>number
>using the provided Price and transaction amount ("Deposit")).
>I hit a blocker on the second to last step of the import wizard with
>the
>message: "*The account 'Vanguard Institutional Index Fund' has a
>different
>commodity to the one required, 'US Dollar'. Please choose a different
>account.*"
>
>So I'm wondering if there are other ways I can go about what I'm trying
>to
>accomplish? I started with the CSV importer because I figured it would
>be
>the easiest record layout to create but I'm not against using a
>different
>format if what I want to accomplish can be done.
>
>I have a backup plan which is that I will NOT do the multi-split import
>and
>will just select the Cash account for all rows in the Import Preview
>screen. I could pack the memo field with the ticker symbol, price,
>quantity, and total debit and let it all dump into the Imbalance-USD
>account. I would then have to either manually fix them one by one or
>possibly script it out. I have done this with success in the past but
>would rather just get it right at the data import step if that's in any
>way possible.
>
>My thanks in advance for any advice offered.
>
>- Stu
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
[GNC] Transaction Imports
Hello Everyone,
I am looking for some guidance on how to import a few hundred transactions
from my 401(k) account.
Unfortunately, the plan administrator does not offer a good option for
exporting the transaction data but I am able to get what I need with some
basic web scraping.
I have been experimenting with creating a multi-split CSV import from the
data that I have captured.
What I wanted to do was a file layout such as:
*Date,Description,Account,Deposit,SharesAsMemo,Price*
01/04/2021,Contribution,Cash,-299.26
,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
01/19/2021,Contribution,Cash,-299.26
,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
My wishful thinking was that I could put the number of shares into the memo
column for reference (but that the system would auto-calculate that number
using the provided Price and transaction amount ("Deposit")).
I hit a blocker on the second to last step of the import wizard with the
message: "*The account 'Vanguard Institutional Index Fund' has a different
commodity to the one required, 'US Dollar'. Please choose a different
account.*"
So I'm wondering if there are other ways I can go about what I'm trying to
accomplish? I started with the CSV importer because I figured it would be
the easiest record layout to create but I'm not against using a different
format if what I want to accomplish can be done.
I have a backup plan which is that I will NOT do the multi-split import and
will just select the Cash account for all rows in the Import Preview
screen. I could pack the memo field with the ticker symbol, price,
quantity, and total debit and let it all dump into the Imbalance-USD
account. I would then have to either manually fix them one by one or
possibly script it out. I have done this with success in the past but
would rather just get it right at the data import step if that's in any
way possible.
My thanks in advance for any advice offered.
- Stu
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
