Release Assembly - Output Builder Excel 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.

Following are the open Bugs in the Excel Outputs, that are required to be fixed. Most of these are
layout formatting issues for the Excel Outputs:

1. CC Logo is not at the scale it is supposed to be by spec, and should be protected (i.e. User cannot delete). The current logo is out of proportions b/c the aspect ratio is set to H: 82% and W: 56% (the aspect ratio is locked which is good, b/c it prevents the logo from moving with the column size). They should both be the same ratio: H: 82% and W: 82%.
2. All Disclaimers (i.e. Important Notes) should be on separate rows contiguous and not on separate rows. ( All Disclaimer text should be fully visible. Again NoWrap on these, so they should just look like 1 row).
3. On Network Output table, the Table formatting is off for the values in details. Every Network rendered out there should have a Field header row. This does not seem to repeat for the second, and third and other networks after the first.
4. All flight summaries are 2 rows, with flight name on 1 row and the summary on the next, they should all be on the same row.
5. On every Flight, we are rendering the buy Type value (e.g. Location, Network/Custom, Audience) as a table header. This is a Field attribute value for “BuyType” and if selected, should be along with other fields in the order it was selected.

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

N/A