System Administration
Configure Excel Integration Overview
- Page-level Import — A user can manually import the Excel file via the Page Gear menu > Excel Integration (if the feature is enabled on the page).
- Public WebApp Event — The Public WebApp event, added to the page as a business rule, can import the Excel file without user involvement. This is useful if an Excel file should be imported every day at a certain time from a service page.
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.
To perform Excel Integration on a Construct page or a page for a custom WebApp, the Page Designer must enable the feature on the page. Refer to Enable Excel Integration for more information.
Refer to DSP Pages Delivered with Excel Integration Enabled for information about pages in delivered WebApps that allow the use of Excel Integration.
The Excel template uses the current user’s language, set on the My Profile page, to translate the translated column name and the help text in the template. Translated phrases must exist for the column headers and help text for them to display in the spreadsheet. Refer to Set the Language for the Translated Column Name Header in the Excel Template for more information.
Excel Integration cannot be performed on a page if it is read only.
NOTE: The security definitions associated with a user’s role may prevent that user from viewing records added via Excel Integration. If a user’s role prevents that user from viewing records on a page through a security definition, and the UPDATE USER DEFINITION ON SAVE check box on the Security Definitions Pages page is unchecked, the user can add records to the page using Excel Integration. However, the user cannot view these records.
Refer to Use Excel Integration, the Knowledge Base article Use Excel Integration to Create or Update Multiple User Accounts and the Data Insiders article Excel Integration for more information.
Configure Excel Integration includes the following topics:
- DSP® Pages Delivered with Excel Integration Enabled
- Enable Excel Integration
- Add Reserved Columns to Tables to Track Excel Integration
- Include Data Type and Help Text in the Excel Template
- Configure Column Header and Text Color in the Excel Template
- Exclude Columns from Excel Integration
- Set the Language for the Translated Column Header in the Excel Template
- Enable/Disable Sheet with Instructions