Importing Custom Data

Professional Development Administrators can upload custom data imports for mass credit management. Once you create templates in the importer, you can reuse the same template with matched column headers for future uploads. 

Using the Import Custom Data feature does not create a new course in course management. Instead, it mass imports credits, which display as an outside credit request. To locate the imported credits, view the staff portfolio.

Access Import Custom Data Feature

Step 1: Select the Professional Learning Workshop Settings gear in Strive.

Step 2: Select Staff Management.

Step 3: Select Import Custom Data.

Create a Template

Step 1: Select the Create Template button.

Step 2: Follow the Template Editor prompts to create your template.

Step 3: Enter the name for your template.

Step 4: Select Choose File to upload your CSV file with data.

Step 5: Locate the file on your computer.

Step 6: Select the Upload button.

Step 7: Once the name of the file appears next to Choose File, select the Next button.

Step 8: After selecting next, a list of the potential schema (data matches) appears on this page. Click Next again to address matching column headers with data.

Step 9: Use the drop-down menus to match required data fields to columns in your uploaded file. The Next button will not be active until all columns are matched.

Step 10: Click Next when columns are matched.

Step 11: Select the column of data to match Credit Type that represents the credit type to be awarded.

Step 12: Select the checkboxes next to the specific credit type(s) to be awarded in the upload. You can award multiple credit types at the same time.

Step 13: Click Next when this step is complete.

Step 14: The system validates imported data files. Select Yes to validate and click Finish.

The completed template is stored in your list of Existing Templates. It can be re-applied to another importer with similar fields. Use the Template Editor to create as many templates as needed.

Tips for creating your data import template

The comma delimited file (CSV) must have the following columns to be successfully imported:

• Course Title
• Start Date
• End Date* (If the end date is left unmatched, it will be set the same as the start date.)
• User Email
• ‘Credit Type’ Column with value of hours

Tips:

• If your CSV file has more columns than the above listed minimum, the process will still run. 
• The Credit Type column must have the value of the credit.
• If a course has more than one credit and the credit value is the same, you can connect the column to more than one credit type.
• If a course has multiple credit types with different credit values, each column must be listed separately with the credit value included. 

Below is an example spreadsheet of how the CSV file provides credits to multiple users participating in multiple courses with different types of credits awarded.

Column A is the title of the course.

Column B is the Start and End date of the course.

Column C is the User Email and identifies who will receive credit.

Columns D-G are the Credit Types in Strive.

• The header of the columns is the actual credit type.
• The cells in columns D-G reflect the number of credit hours awarded for each credit type.

Note: If a user has not gained credit, the appropriate column must have a 0 in the field. Empty credit fields cause an error when importing. 

Upload a New Import With a Created Template

Step 1: Select the template name from Existing Templates.

Step 2: Select the Import New File button.

Step 3: Select the file to upload.

Step 4: Select Upload.

Step 5: Select Next. You do not have to verify column data again using an existing template.

Remove a File and Data

Step 1: Select the template name from Existing Templates.

Step 2: Select the file you want to delete from Data Files list. 

Step 3: Select the Delete File & Data button to remove the file.