JR52258: MDMCS EXPORTING SEARCH RESULTS TO MICROSOFT EXCEL KNOWLEDGE CENTER INFORMATION

APAR status

• Closed as documentation error.

Error description

• There are wrong information with MDMCS 11.3 and 11.4
  regarding Exporting search results to Microsoft Excel  and it
  needs to be fixed.
  
  Here is the information found on Knowledge Center:
  
  About this task
  The IBM InfoSphere Master Data Management Collaboration Server
  Excel Parser is supported through a third party .jar file named
  POI-3.2-FINAL.jar file. This .jar file does not support the
  Microsoft Excel 2007 file format (*.xlsx).
  
  
  This information should be replaced for the following:
  
  About this task
  The IBM InfoSphere Master Data Management Collaboration Server
  Excel Parser is supported through a third party .jar file named
  poi-3.7-20101029.jar. This library supports Microsoft Excel
  2007 format, which allows more than 255 columns per data sheet.
  You need to run the new Rich Search Result Report script using
  the Default Rich Search Results Report Script (Excel 2007 -
  xlsx format) option to export items with more than 255
  attributes.
  
  Note: You still can export Rich Search Results to files in the
  Excel 2003 format by using the Default Rich Search Results
  Report Script option, but with this format the report will fail
  if items have more than 255 attributes.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All MDM CE users are affected by this.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * There are wrong information with MDMCS 11.3 and 11.4         *
  * regarding Exporting search results to Microsoft Excel  and   *
  * it                                                           *
  * needs to be fixed.                                           *
  *                                                              *
  * Here is the information found on Knowledge Center:           *
  *                                                              *
  * About this task                                              *
  * The IBM InfoSphere Master Data Management Collaboration      *
  * Server                                                       *
  * Excel Parser is supported through a third party .jar file    *
  * named                                                        *
  * POI-3.2-FINAL.jar file. This .jar file does not support the  *
  * Microsoft Excel 2007 file format (*.xlsx).                   *
  *                                                              *
  *                                                              *
  * This information should be replaced for the following:       *
  *                                                              *
  * About this task                                              *
  * The IBM InfoSphere Master Data Management Collaboration      *
  * Server                                                       *
  * Excel Parser is supported through a third party .jar file    *
  * named                                                        *
  * poi-3.7-20101029.jar. This library supports Microsoft Excel  *
  * 2007 format, which allows more than 255 columns per data     *
  * sheet.                                                       *
  * You need to run the new Rich Search Result Report script     *
  * using                                                        *
  * the Default Rich Search Results Report Script (Excel 2007 -  *
  * xlsx format) option to export items with more than 255       *
  * attributes.                                                  *
  *                                                              *
  * Note: You still can export Rich Search Results to files in   *
  * the                                                          *
  * Excel 2003 format by using the Default Rich Search Results   *
  * Report Script option, but with this format the report will   *
  * fail                                                         *
  * if items have more than 255 attributes.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please refer the latest version of documentation.            *
  ****************************************************************
  

Problem conclusion

• http://www.ibm.com/support/knowledgecenter/SSWSR9_11.4.0/com.ibm
  .pim.dev.doc/searches/pim_tsk_dev_exportingsearchresultstoexcel.
  html
  http://www.ibm.com/support/knowledgecenter/SSWSR9_11.3.0/com.ibm
  .pim.dev.doc/searches/pim_tsk_dev_exportingsearchresultstoexcel.
  html
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels