Importing Example CSV into Watershed Essentials

Watershed Essentials delivers basic insights and is designed for L&D practitioners who want to start tracking and exploring learning outside an LMS. The platform not only allows multiple options for getting data in and showing progress, but also serves as a foundation for organizations to build toward more robust learning analytics in the future. Additional product features include dashboard reporting and preconfigured reports that answer common questions about learners and their activities. 

Watershed offers extremely powerful capability to convert almost any data CSV into xAPI data that can be used with Watershed's reporting. This guide walks you through importing a CSV of data exported from an LMS to Watershed Essentials (or any Watershed account):

Importing Example CSV

Watershed offers extremely powerful capability to convert almost any data CSV into xAPI data that can be reported on using Watershed's reporting. 

  1. Go to xapigo.com/csv/ to download the example CSV (essentials.csv):
  2. In your Watershed account, go to the Edit Templates menu in the CSV Data Sources section of the Data page:
  3. Click to Add Import Template. Import templates are the code that convert the data in your CSV to xAPI. 
  4. Name the import template "Example CSV Import Template" (or whatever you'd like) and click Next
  5. Upload the Example CSV file you downloaded before (essentials.csv) and click Next
  6. Skip the optional Step 3: Specify template variables by clicking Next
  7. Paste the Template from xapigo.com/csv/ into the Create Statement Template box. It should look like this screenshot:
  8. Click to Save the template.
  9. Your template should now be on the list of templates:
  10. Go to the Import Templates menu in the CSV Data Sources section of the Data page. Select the new template you just created from the dropdown. 
  11. Upload the Example CSV file you downloaded before (essentials.csv): 
  12. The screen will update to preview a few statements. Click the Import statements button to begin the import. It could take up to a minute for the upload to complete.

Viewing Data from the Imported Example CSV on the Watershed Essentials Dashboard

After you've imported your CSV into Watershed, you'll be able to see data on your Watershed Essentials dashboard.

  • The Activities Report shows what activities are being sent to Watershed and the number of interactions your learners have had with each. For your imported CSV, the Activities show courses and assessments that would be exported from an LMS. 
  • The People Report shows all of the people that are being sent to your Watershed account and the number of interactions they've had with your learning content. If you've imported the example CSV, you should see a list of people from the CSV and the number of interactions each person has made. 
  • The Actions Report shows what actions (combination of verb and activity) are being interacted with the most in your account. The most common actions from your imported CSV will be listed along with the number of times the combination appears in your CSV.
  • The Interactions by Data Source Report shows the number of interactions sent to Watershed by each data source. If you have only imported the example CSV, you'll only see data from the imported CSV on the report. 
  • The Data Sources Report shows similar information, but represented as a pie chart.
  • The Interactions Report is a raw stream of interactions from all of your data sources. If the most recent thing you've done is import the example CSV, then you'll see the all of them at the top.

Viewing Raw xAPI Data from the Imported Example CSV in Watershed Essentials

After you've imported your CSV into Watershed, you'll be able to see the raw xAPI data in Watershed Essentials.

On the Data page, go to the Debug menu. This is a stream of xAPI statements displayed in the order that Watershed received them (the most recent statements are first). If you just imported the CSV, you should see your statements at the top of this section. Click the arrow next to the statement name to view the full xAPI statement.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

If you can't find what you need or you want to ask a real person a question, please contact customer support.