Release Assembly - Output Builder Output Fixes 2

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
   • For Excel Output requests, we run into an "infinite loop error" when Include Summary is checked.
     See attached json request to validate and reproduce this issue.
2. Excel Fix
   • Value Formatting on Excel Outputs need to match the same as we have on our PDF Outputs.
     • All formatting for currency values follows the same formatting as on the PDF page
     • Text values should always be leftaligned
     • All Number values should always be rightaligned

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