Re: weird CSV download result

[[support], _]

Tom,  

I analyzed the code from your log and found the following:

1.  It appears you have one of the fields set to a DateField in the FD when in fact its a numeric.  

WOW is trying to create an excel date field and the date data is not a date datatype, it's coming in as a BeigDecimal.  

Corrective action:

Check the FDs for any that are set to a DateField in the field class of the FD.  If they are not valid dates, remove the DateField from the FD.

Thanks, WOW SUPPORT

On Wed, Apr 23, 2014 at 10:50 AM, Elliott, Tom [External] <tom.e...@externals.adidas-group.com> wrote:

The info should be at the end of the log. 

 

Tom Elliott

SLD IT Contract Developer

 

From: ph...@planetjavainc.com [mailto:ph...@planetjavainc.com] On Behalf Of [support], _
Sent: Wednesday, April 23, 2014 1:07 PM
To: Elliott, Tom [External]
Subject: Re: weird CSV download result

 

Hi Tom,

 

We need to see the tomcat logs.  Could you find the most recent and zip and send and we'll take a look.

 

Thanks, WOW SUPPORT

 

On Wed, Apr 23, 2014 at 6:37 AM, Elliott, Tom [External] <tom.e...@externals.adidas-group.com> wrote:

Hi guys,

 

Getting a strange xl download result.   Not sure why.

 

 

 

Properties:

 

DisplayColumns{ results:; details:; }

 

DetailDisplay{

  addButtonsURI:;            button locations:;            buttonJustify:;

  cancel:;                               colCnt:;                 colonAfterLabel:;

  copyURI:;                          delete:;                                deleteText:;

  editButtonsURI:;            editURI:;                              grid:;

 insert:;                                insertAndCopy:;               insertAndNew:;

  insertText:;                       insertURI:;                          label justify:;

  maxInputWidth:;           maxInputWidthSum:;    nextAndPrevious:;

  nextText:;                         previousText:;                   printURI:;

  tableWidth:;                     updateAndNextPrevious:;           updateText:;

  viewButtonsURI:;          viewURI:;                           

}

TableDisplay{

  selectionType:none;    refresh:true;      chart:true;

  excel:true;                        msWord:false;  xml:false;

  editFD:true;                     print:true;           sorting:true;

  drawGrid:true;                rowCopy:false; updateable:false;

  deleteAll:false;               nextPrevious:true;

}

 

CSV { columnHeadings: internal; }

 

 

/***  Sample Report Break (Commented Out) *******

**  breakColumns:STATE;  **/

 

ReportBreak{

  columns:giqtpk;

   columnFunctions:SUM,COUNT;}

 

 

 

 

Tom Elliott

SLD IT Contract Developer