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

[Michael Anstis (JIRA)]

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)
            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