Posted: Mon Jan 14, 2008 8:15 pmPost subject: Exporting date fields to SD or csv
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).
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.
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.
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