trouble with date when importing a just exported csv file.

[Larry Evans]

On 01/27/2015 11:45 AM, David Carlson wrote:
> 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

Thanks David,

Although I'm new to export/import to csv, I've been using gnucash
for several years.  Howver, you are right that I am testing
gnucash, but only the import/export part.  I tried on my real
data; however, I got the same error.  Thus I decided to simplify.


I've attached several .png files detailing in sufficient detail,
hopefully, what's happening.  The leading number in the filename
indicates the order in which the depicted actions were taken.

TIA for any insight you could provide.

-regards,
Larry


-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1.AccountTree.png
Type: image/png
Size: 75141 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0009.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2.SHA1_transactions.png
Type: image/png
Size: 52357 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0010.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3.ExportSettings.png
Type: image/png
Size: 347949 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0011.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 4.AccountSelection.png
Type: image/png
Size: 367390 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0012.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 5.ExportFilename.png
Type: image/png
Size: 342560 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0013.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 6.export_SHA1_transactions.png
Type: image/png
Size: 84744 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0014.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 7.ImportFile.png
Type: image/png
Size: 351406 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0015.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 8.PreviewSettings.png
Type: image/png
Size: 249359 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0016.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 9.ImportSettingsProblem.png
Type: image/png
Size: 194990 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20150127/c5ba9a96/attachment-0017.png>