Release Assembly - Output Builder Output Fixes

Project Overview

The CPQ application has been developed to provide sales users at a outdoor advertising media company the ability to create advertising campaigns plans and generate dynamic proposals for their customers. The solution has been built on the Salesforce platform leveraging multiple integrations to obtain availability data, OOH ratings and inventory maps as well as leverages Heroku to create the proposal outputs - which is referred to as the "Output Builder".

Competition Task Overview

This is a 48 hours contest! Review phase is 24 hours!

Note: Client could only grant salesforce access to limited number of users. Please don't register the contest if you didn't get salesforce login in previous contests.

Please use contact manager if you want to be added to the waiting list.

The Output Builder will receive a JSON request, fetch data from SalesForce and generate PDF/Excel file.

1. PDF Fix
   • When generating a PDF output, the Package and Flight Comments and Disclaimers do not render.These values are only rendering when "Include Package Summary" Option is selected.The desired scenario is that Comments and Disclaimers should always be rendered at the end of every Package, irrespective of the Package summary being requested.
2. Excel Fix

   • Disclaimers on Excel Output:
     The disclaimers are implemented in excel reporter and the template contains hard coded call in the proposal template object in Salesforce, which is wrong. Disclaimers would be dynamic based on several rules which are already implemented and working properly for our PDF output.

   • Requirement:

     We need the ability to set these disclaimers with dynamic values in the same manner that we create the disclaimers for our PDF output.

     Snippet from template:
     Important notes
     <jx:forEach items="${exporter.getDisclaimers('Chicago - Flight 1', 'Chicago', 'Bulletin')}" var="disclaimer">
     ${disclaimer}
     </jx:forEach>

Environment Set Up

1. Request SalesForce Test Environment Login in Contest Forum
2. Login to SalesForce Test Site and find the session id in cookie.
3. Download the Modified Code for developers from this page.
4. Update the Hard Code session id, JSON Request and salesforceURL for testing.
5. Run the project and verify the generated XLS file.

Final Submission Guidelines

• Source Code
• Deployment Guide