[jboss-jira] [JBoss JIRA] Commented: (JBRULES-3154) Date handling in XLS tables

[Michael Anstis (JIRA)]

    [ https://issues.jboss.org/browse/JBRULES-3154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12616308#comment-12616308 ] 

Michael Anstis commented on JBRULES-3154:
-----------------------------------------

Workaround: Don't use excel cell's formatting to date, use text format ... and use either the default format "dd-MMM-yyyy" or the one you set in "drools.dateformat" system property.

> Date handling in XLS tables
> ---------------------------
>
>                 Key: JBRULES-3154
>                 URL: https://issues.jboss.org/browse/JBRULES-3154
>             Project: Drools
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: drools-decisiontables
>    Affects Versions: 5.2.0.Final
>            Reporter: Michael Anstis
>            Assignee: Michael Anstis
>
> Dates set in a XLS sheet are not read correctly under Guvnor. It seems that XLS reading transforms the date into a format that can't be properly handled by compiler.
> Example (in the repository_export.xml attached file) :
>     * My XLS has a column that tests a java.util.Date against a value : "myDate >= $param"
>     * My XLS cell contains a date, formatted by Excel (may be that's the reason) using a English format like the Guvnor default one, ie : dd-MMM-yyyy. The example date value is "01-Jan-2009" (the display, the internal value in XLS is a number...)
> Problems (at compilation and DRl generation) :
>     * Unable to create a Field value of type 'ValueType = 'Date'' and value '"1-janv.-2009"' : notice that the date value has been transformed !
>     * This value ("janv." instead of "jan") is certainly due to the fact that I am french ("janvier" is the french for "january")
>     * If I reset the french default format, ie dd/MM/yyyy, the value 01/01/2009 is tranformed to 01/01/09, and the compilation complains about unknown format (same error).
>     * If I turn the excel cell in text format, and enter "01-jan-2009", there no value transformation anymore, and the rule compiles OK.
> So I guess that reading dates in the XLS is the source of the problem.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira