SAP EP – Netweaver Portal

MDM Result Set iView – How to export records to Excel

July 1, 2009 at 5:23 pm

[ex] [Excel] [iview] [iview mediapro] [iview mediapro mac] [iview mediapro3]

1. Group-Layout can not be disabled – MDM Search Text iViewSymptom While using MDM 7.1 SP02 Portal iViews in the portal design-time property editor, you are configuring the Search Text iView “Group-Based Layout” property to “No”, however in run-time, the iView ignores...
2. iView eforcement of MDM Role Table and Field PrivilegesSymptom When working in MDM iViews, MDM table and field privileges enforced policy is stricter then the one in Data Manager Other terms Roles, Permissions, Privileges, iViews Reason and Prerequisites In MDM...
3. iView eforcement of MDM Role Table and Field PrivilegesSymptom When working in MDM iViews, MDM table and field privileges enforced policy is stricter then the one in Data Manager Other terms Roles, Permissions, Privileges, iViews Reason and Prerequisites In MDM...
4. MDM Item Details iView – “Record is protected” messageSymptom When trying to edit a record via MDM Portal Item Details iView you see a message that “Record is protected, record is checked out” and you can not edit it. Trying...
5. Numbers after decimal point displayed differently- MDM iViewSymptom Formatting of MDM Real, Measurement or Currency field types with 1 or more digits after the decimal point appear to be different when comparing these fields in Item Details Edit mode...
6. iView error when accessing new iViews from UWLSymptom This problem occurs in two cases: After approving contract the manager is not able to view the earmarked fund document. There is an iview problem. Steps: 1. Login as purchaser Create...
7. ‘WELCOME_CLAUSE’ is displayed in the portal header iViewSymptom Instead of welcome text and the name of the user at the header iView of the portal, a string ‘WELCOME_CLAUSE’ is displayed. This incorrect behavior can be reproduced on version: -...
8. iView Name correction ‘ Process Bid as Substitute ‘Symptom iView name incorrect in SRM 50 Business package for the iView ‘Process bid as substitute’. Solution Please check the manual steps and in addition check the attachment for manual correction of...

Symptom
You are trying to export records from MDM Result Set iViews to an Excel file.
Other terms
Excel, export, iViews, MDM, Result Set
Solution
Export to Excel functionally can be achieved by configuring an MDM Result Set iView custom table EPCF or URL event.
This custom event, passes the string that represents the MDM Search which is to be caught by your custom application (*).
Your custom developed client application will then perform the export to Excel activity, with the benefit of the Excel file been tailored according to your business needs and repository specific semantics.
For this configuration, select [MDM Search] from the Result Set event builder ‘Mapped field’ dropdown list (For further details on Result Set table events, refer to the Portal Content User Guide to the section on Portal Eventing).
(*)
The string that is generated is what is produced by the MDM Java API function Search.serialize(). The search can be reconstructed in any client application by passing this string to the Search.deserialize( String ) function.
See attached Export2Excel.ppt showing a sample portal page screen capture with the above implementation.
Note – the above is not relevant for MDM4J, only for MDM Java API.

Permalink