System Administration

Configure the Excel Template Overview

DSP® System Fields Related to Excel Integration

The information included in this topic is used by the page Designer.

The fields listed in this section are manually added to an underlying table to track the user and date/time of data entry during the Excel import process. The values will be updated upon completion of the import process.

System Field	Description
AddedOn	Contains the date/time that the record was inserted into the table.
AddedBy	Contains the username of the user that imported the record.
AddedVia	Contains the method used to add the record into the table. This field defaults to ‘ExcelImport’ for records inserted via Excel Integration.

 

In the Excel template, the cell’s comment as well as column highlighting will indicate if the column is required.

Configuring the Excel template includes the following topics:

• Configure Header Rows

• Configure Column Header Color in the Excel Template

• Configure Columns for Exporting

• Set the Translated Column Header in the Excel Template

• Enable/Disable Sheet with Instructions

 

NOTE: Refer to the Knowledge Base article on the BackOffice Associates Support site "DSP® Microsoft® Excel® Integration Developer Guide" for information about running Excel Integration via a Public WebApp event.