Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For confidential or other support please email.		 The time now is Tue Oct 07, 2008 3:22 pm
 <b>Register</b> (required to post and download)Register (required to post and download)
 Username:    Password:   Remember login       
 FAQFAQ   SearchSearch   DigestsDigests 
Exporting date fields to SD or csv
To watch this topic for replies  Register (enables digests) or give email address:
Reply to topic    Home -> Forums -> Support -> Instant JChem -> Exporting date fields to SD or csv

Display posts from previous:        View previous topic :: View next topic    
Author Message
reichag
Joined: 17 Sep 2007
Posts: 21


View user's profile
Back to top
Post subject: Exporting date fields to SD or csv
Link to postPosted: Mon Jan 14, 2008 8:15 pm  Reply with quote
When I export file which include date fileds to an SD or csv file, the format includes a time stamp (Fri Jul 07 00:00:00 EDT 2006 ) eventhough the date appears normally (7.7.2006) in IJC. The export format is not recognized as a date format in other programs (excel, spotfire). Is there a way to control the format of date fields when exporting so that they are recognizable as date fields in excel? (Using IJC 2.2, office 2007, Windows XP, Java 6).
mlukasak
Joined: 21 Dec 2007
Posts: 1
IJC personnel

View user's profile
Back to top
Post subject: NN MMM DD HH:MM:SS "EDT" YYYY
Link to postPosted: Mon Jan 14, 2008 10:27 pm  Reply with quote
Please use following format mask in cells containing date values.

NN MMM DD HH:MM:SS "EDT" YYYY

It is working fine for me in OpenOffice. It should be same in excel.

Milan
tdudgeon
Joined: 05 Oct 2004
Posts: 573
IJC personnel

View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Mon Jan 14, 2008 11:05 pm  Reply with quote
Export works on the "raw" data, not the formatted data you see in a view. This is generally a good thing as it would be bad if data was lost because of formatting, and it can usually be reformatted in the new destination.
But in the case of dates this is not ideal, and some formatting capability would probably be a good idea. The question is what formatting? With all the multitude of date formats and locales any particular format would not be right for all people.
Maybe we can provide a simple fix for this specific problem by providing allowing a default date format to be defined and used.
Longer term we want to allow all data to be formatted according to users specific needs.

Please let us know If you have any specific suggestions.

Thanks

Tim
reichag
Joined: 17 Sep 2007
Posts: 21


View user's profile
Back to top
Post subject:
Link to postPosted: Tue Jan 15, 2008 6:08 am  Reply with quote
Tim,
A simple dd/mm/yyyy or mm/dd/yyyy would be great.
tdudgeon
Joined: 05 Oct 2004
Posts: 573
IJC personnel

View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Fri Jan 18, 2008 11:07 am  Reply with quote
We will look at sorting something out for this.
tdudgeon
Joined: 05 Oct 2004
Posts: 573
IJC personnel

View user's profile

Visit poster's website
Back to top
Post subject:
Link to postPosted: Thu Feb 14, 2008 7:50 pm  Reply with quote
Date formats now have been standardized in IJC 2.2.1. They are displayed and exported in 1-Jan-2008 format, which is recognised by most external programs.
We hope to make the formatting more customisable in future.
Display posts from previous:   
Reply to topic    Home -> Forums -> Instant JChem -> Exporting date fields to SD or csv All times are GMT + 1 Hour
Page 1 of 1
To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum