Create SSP batch to upload SSP data
Learn how to create an SSP batch to upload SSP data.
After the SSP data is filled in the downloaded SSP template file, you can create an SSP batch to upload the data to Zuora Revenue.
- Navigate to SSP > Upload.
- In the SSP Upload left pane, select the template based on which you want to upload data and click the Create Batch icon.
- In the New SSP Batch window, specify the following required fields and click the save icon.
- Batch Name: A unique name of this batch.
- Start Date: The start effective date of the SSP data.
- End Date: The end effective date of the SSP data.
- Term: If you select AMOUNT for the Value Type field in the SSP template, specify the term for the SSP amount. For example, enter 1 for one month, and enter 12 for one year.
- Close the New SSP Batch window. The SSP batch is created and listed on the right.
- To upload your SSP data file, click the Upload icon.
- In the New SSP Upload window, click Choose File to select the file and then click Upload.Note:
Starting from version 37.004.02.00, to remediate CSV injection software attack, ensure that no cells in the uploaded filebegin with any of the following characters:
- Equal sign (=)
- Plus (+)
- At (@)
During file upload, use theENABLE_CSV_DATA_SANITIZATIONprofile to specify how to handle the file that hasthese special characters as a starting character in any cell. Valid values for this profile include the following:
- BLOCK: The file will be blocked if any cell begins with the above special characters.
- SANITIZE:The above specialcharacters will be removedif any cell begins with them. Then, the file can be processed by the system.
- RAW: The file can flow into the system as it is even if there is a potential security risk.
- Close the New SSP Upload window.
- Click the Refresh icon until the Batch Status column value changes from NEW to SSP UPLOADED.
- (Superuser only) To make the SSP data valid, click the Approve icon and provide your comment to approve the SSP data.