The Challenge The major challenge was to communicate to CRM via webservice. Moreover generating the Power Point Slides dynamically using Third Party vendor API was in itself a big challenge. The application is built on Major Customer Relationship Management System. Communication with CRM was done through webservice and then generating the XML file of data. This data had to be used to populate the PowerPoint slides. PPT slides were dynamically generated and the end user could download the whole power point generated dynamically.
The Solution
We developed XML format which was used to populate the data slides dynamically. All data which was extracted from CRM was first put in xml object. This xml object was then used to populate the data slides. Data slides were generated dynamically using Third Party vendor API with the respective user's data extracted from CRM and putting in xml format and then populating the slides.
The Technology java/JSP, STRUTS, kXML, Third Party vendor API for PowerPoint generation, Webservice
The Benefits
Dynamic generation of Power Point, without having end user to populate the slides manually. Generation of Organization chart, matrix and lot of data slides with lot of data populated dynamically. This saves lot of time of the end user which otherwise would have been very tedious work for user to generate the slide manually.