trouble with date when importing a just exported csv file.

David Carlson david.carlson.417 at gmail.com
Tue Jan 27 12:45:46 EST 2015


On 1/27/2015 10:30 AM, Larry Evans wrote:
> Using an account tree containing just a checking account and one stock
> account for stock SHA1, I bought 1 share on 2015-01-01, then exported
> the account transactions to a csv file.  I changed the date of the
> buy in the .csv file toe 2015-02-01 and tried to import it.
> I specifyied the date field and y-m-d, but when the import ran,
> I got some error message about possibly the date field being wrong.
> On import, I specified no quotes and @ and the separated.
> The exported file is at bottom delimited by --{--- and --}---.
>
> My OS is ubuntu 14.04 and my gnucash is 2.6.1.
>
> How can I import these transactions?
>
> TIA.
>
> -regards,
> Larry
>
> --{-------import_export.csv---
> Date at Account
> Name at Number@Description at Notes@Memo at Category@Type at Action@Reconcile at To
> With Sym at From With Sym at To Num. at From Num. at To Rate/Price at From Rate/Price
> 2015-02-01 at Checking Account@@buy 1@@@SHA1 at T@@N at -$100.00@@-100.00@@@
> @@@@@@SHA1 at S@Buy at N@@1 SHA1@@1@@100
> @@@@@@Checking Account at S@@N at -$100.00@@-100.00@@1.00@
> 2015-02-01 at SHA1@@buy 1@@@Checking Account at T@Buy at N@1 SHA1@@1@@@
> @@@@@@SHA1 at S@Buy at N@1 SHA1@@1@@100@
> @@@@@@Checking Account at S@@N@@-$100.00@@-100.00@@1.00
> --}-------import_export.csv---
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>

Slow down.  I suggest going one step at a time.

It looks like you are a new user trying to test GnuCash.  Either you
skipped several steps or you just didn't mention them in your message.

Investment transactions issues are not easy to troubleshoot if mixed up
with import export issues. 

I suggest first reading the Tutorial and Concepts Guide and setting up
your chart of accounts similar to the samples  After you have the basics
down, go to the import section of the help manual if you plan to import
data from some outside source. 

After all of that, go to the investments chapter of the Tutorial and
Concepts Guide and set up your test accounts correctly with security
accounts under a asset:brokerage account.  Feel free to ask simple
questions that you think will get short answers.

David C


More information about the gnucash-user mailing list