Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.

Support Ticket System is replacing forum

This forum was converted into a searchable archive. You cannot add posts here any more. For support please use our new Ticket System.

Create your first ticket
Exporting date fields to SD or csv
To watch this topic for replies  Register (enables digests) or give email address:
This topic is locked: you cannot edit posts or make replies.
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
Gregory

Joined: 17 Sep 2007
Posts: 21

View user's profile

Back to top
Link to postPosted: Mon Jan 14, 2008 8:15 pmPost subject: Exporting date fields to SD or csv 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

View user's profile

Back to top
Link to postPosted: Mon Jan 14, 2008 10:27 pmPost subject: NN MMM DD HH:MM:SS "EDT" YYYY 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
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Mon Jan 14, 2008 11:05 pmPost subject: 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
Gregory

Joined: 17 Sep 2007
Posts: 21

View user's profile

Back to top
Link to postPosted: Tue Jan 15, 2008 6:08 amPost subject: Reply with quote

Tim,
A simple dd/mm/yyyy or mm/dd/yyyy would be great.
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Fri Jan 18, 2008 11:07 amPost subject: Reply with quote

We will look at sorting something out for this.
Tim
ChemAxon personnel
Joined: 05 Oct 2004
Posts: 1703

View user's profile

Back to top
Link to postPosted: Thu Feb 14, 2008 7:50 pmPost subject: 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.
This topic is locked: you cannot edit posts or make replies.
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