Article Links Introduction | Export Tasklist | Edit the Tasklist Spreadsheet | Import a Tasklist |
The Express LMS is a basic feature LMS and does not include all the features of a full-service LMS. The Express LMS does not include the ability to export tasklists.
INTRODUCTION
The LMS provides a method for you to export existing tasklists to perform bulk editing in a spreadsheet and then import the spreadsheet updating the existing tasklist with your desired changes. You can add new tasks and edit and delete existing tasks in the spreadsheet.
A tasklist does not need to be published to export.
EXPORT A TASKLIST
Follow these steps to export a tasklist:
- Click the Administration tab at the top of the screen
- Click the Training Import and Creation link, then the Tasklist link on the left menu bar
- Search and locate the desired tasklist to be exported
- Click the Edit icon to the left of the desired tasklist
- Click the Export button located on the second button bar
Note: You must have your browser's pop-up blocker disabled to view the spreadsheet
- The Excel file will appear as a button in the lower-left corner of the Google Chrome browser
- Click the button to open the spreadsheet
- Refer to the Edit Tasklist Spreadsheet article below to make the desired changes to the tasklist
- Save the spreadsheet to your local hard drive or network location being careful not to change the name
- Refer to the Import the Tasklist article below to import the updated tasklist
EDIT THE TASKLIST SPREADSHEET
Follow the steps below to add a new task, edit an existing task, or delete an existing task:
Add a New Task
- Insert a row above the last row with the ###### signs
Note: Do not add any content in the spreadsheet following the pound signs. This will ensure your import will work properly - Column A - ID: Leave blank
- Column B - Item Type Enter either of the following - case sensitive - no spaces
- Tasklist:Informational
Used to indicate an informational field - Tasklist: Task
Used to indicate a task
- Tasklist:Informational
- Column C - Title: Enter a title if applicable, otherwise leave blank. Not case sensitive and may use spaces. 132 character limit.
- Column D - Task: Enter the task. Not case sensitive and may use spaces. Unlimited text field.
- Column E - Link URL: Enter a URL if applicable, otherwise leave blank.
- Column F - Required: Enter either of the following - case sensitive
- True
Indicates the task is required - False
Indicates the task is NOT required
- True
- Save the spreadsheet to your local hard drive or network location being careful not to change the name
- Refer to the Import the Tasklist article below to import the updated tasklist
Edit an Existing Task
- Make the changes to any existing column
- Column A - ID: Do not edit this column
- Column B - Item Type Enter either of the following - case sensitive - no spaces
- Tasklist:Informational
Used to indicate an informational field - Tasklist: Task
Used to indicate a task
- Tasklist:Informational
- Column C - Title: Enter a title if applicable, otherwise leave blank. Not case sensitive and may use spaces. 132 character limit.
- Colum D - Task: Enter the task. Not case sensitive and may use spaces. Unlimited text field.
- Column E - Link URL: Enter a URL if applicable, otherwise leave blank.
- Column F - Required: Enter either of the following - case sensitive
- True
Indicates the task is required - False
Indicates the task is NOT required
- True
- Save the spreadsheet to your local hard drive or network location being careful not to change the name
- Refer to the Import the Tasklist article below to import the updated tasklist
Delete an Existing Task
- Delete the desired row using your Excel spreadsheet commands
- Save the spreadsheet to your local hard drive or network location being careful not to change the name
- Refer to the Import the Tasklist article below to import the updated tasklist
IMPORT THE TASKLIST
Follow these steps to import the tasklist after you have made all your desired changes and saved the spreadsheet:
- Click the Administration tab at the top of the screen
- Click the Training Import and Creation link and then the Tasklists link on the left menu bar
- Search and locate the tasklist following the directions provided in Using Search article
- Click the Edit icon to the left of the desired tasklist
- Click the Import button located on the second button bar
- Click the Browse button
- Navigate to the desired spreadsheet on your local hard drive or network location
- Click on the spreadsheet file
- Click the Open button in the lower right corner
- You will be returned to the Edit Tasklist screen in the LMS
- Click the Upload button to the right of the Browse button
- The new tasklist will be uploaded
- Click the Save button to save the changes
- Click the Publish button when you are ready to publish the new tasklist and assign it