Overview
Users can use our standard template to format their historical data prior to uploading it to the Content Library.
The standard template is available for download in Excel format.
Using the Standard Template to Import Content
- Navigate to the Content Library and click + Add Content. Select Import File from the menu.
- Click the Menu icon, and then select Add New File.
- Select Standard Templates, then click the link to download the template.
- Complete the spreadsheet as required (see the Formatting Requirements and Notes section below), then import it into Responsive.
Formatting Requirements and Notes
There are two required fields that must be populated during the Standard Template import process:
- Question
- Answers
The standard template provides the flexibility to set many attributes for your Q&A pairs including owners, review cycles, tags, star ratings, and more. Some values require a specific format.
| Values | Formatting Requirement and Notes |
| Adding Multiple Owners | Use the email address associated with the user's account. All owner emails must be separated by a semicolon (;) with no spaces in between. |
| Alternative Questions | Must be open text fields. |
| Tags | All tags must be separated by a semicolon (;) as the delimiter. Tags do not need to be created in the system prior to importing via this upload. |
| Last Updated Date | Date format options: 2022-12-31 or 12/31/2022. |
| Next Review Date | Date can be in a variety of formats but must include the day, month and year (see above for examples). |
| Owners | Enter the email address associated with the user's account. The user status can be pending verification. Do not reference the owner by their name; you must use their email address. |
| Collection | All collections must be separated by a semicolon (;) with no spaces in between. |
| Moderators | Use the email address associated with the user's account. Multiple moderators can be specified, separated by a space as the delimiter. There must not be a new line separating the values. |
| View/Edit Privacy |
The value is Everyone by default. To customize privacy settings, enter the user role(s) in the appropriate cell. Use a semi-colon (;) as the delimiter if you want to enter multiple values. This option allows you to set different attributes for your Q&As (such as different privacy settings based on the Q&A pair). Privacy can be set in bulk (applied to all Q&As) from the Configuration screen prior to import. |
| Enable Answer Library Review | To enable the review, select True from the drop-down. To disable the review, choose False or leave blank. |
| Next Review Date | Date format options: 2022-12-31 or 12/31/2022. |
| Review Cycle | To have review cycle set to the default settings, use Default. To customize the review cycle, enter the number of days in the cell (100, for example). |
| Last Used Date | Date format options: 2022-12-31 or 12/31/2022. |
| Comment | Must be open text field. |
| Star Rating | Rating must be a numerical value between 1 and 5. |
| Alert Text | Must be open text field. |
| Last Updated By | Use the email address associated with the user's account. |
| Flag | To enable the flag, click a cell in the Flag column and choose True from the drop-down. The default setting in the system is False. |