New to Crowdmark? Check out our Getting Started Guide for instructors.
Sign In

Importing and exporting the comment library

From an assessment’s Dashboard you may export the assessment’s entire comment library or comments from a specific question to a CSV file. This file can be used for analysis or imported to other assessments in Crowdmark.

Exporting comments

  1. From your assessment’s Dashboard, click Manage comment library in the Administration panel. The Manage comment library modal window will appear.

  2. Select which question you would like to export the comments from.

  3. Click the Export question button to download a CSV file.

The comment library export file will contain the following headings:

  • Label: The question label that the comment is associated with.
  • Comment: The comment text.
  • Points: Points associated with the comment or blank if no points are associated.
  • Shared:true” if the comment has been shared with the team or “false” if not.
  • Times used: The number of times the comment has been used by all graders in the assessment.

An example of an exported comment library CSV file

Importing a library of comments

Note: All comments with the Shared column set to “true” will be shared with your grading team. The Times used column of the CSV file is not required and will be ignored when importing the file.

  1. Open your CSV file of comments and change the question labels in the Label column to match the question labels in your assessment, if needed. Crowdmark needs the correct labels to know which question each comment is associated with.

  2. From your assessment’s Dashboard, click Manage comment library in the Administration panel. The Manage comment library modal window will appear.

  3. Ensure that All questions (entire library) is selected.

  4. Click the Import library from CSV file button.

  5. Select your CSV file. You will see a message with the number of comments that were detected in the file.

  6. If the filename and number of comments looks correct, click the Yes, import comments to library button

  7. You will see a message confirming the number of comments uploaded to each question.

Importing comments to a specific question

Note: All comments with the Shared column set to “true” will be shared with your grading team. The Label and Times used columns of the CSV file are not required and will be ignored when importing the file.

  1. From your assessment’s Dashboard, click Manage comment library in the Administration panel. The Manage comment library modal window will appear.

  2. Select which question you would like to import the comments to.

  3. Click the Import question from CSV file button.

  4. Select your CSV file. You will see a message with the number of comments that were detected in the file.

  5. If the filename and number of comments looks correct, click the Yes, import comments to question button.

  6. You will see a message confirming the number of comments uploaded.

Deleting unused comments

If you make a mistake or upload the wrong file, you can click the Delete all unused comments button. This will remove comments that have not been placed on student work, including any comments that you or your graders have created through the comment library but have not used.

Troubleshooting import issues

Your CSV file must include the Label (if importing an entire library) and Comments columns. If any data is missing or if there is an issue with the file the import will not work until the issues are resolved.

You may encounter the following errors:

  • The file must be in .csv format: If you are uploading an Excel or similar file, please save it as a CSV.
  • Row 1 is missing data for Comment: This error appears if a row is missing some required information (Comment text, Label, etc.)
  • The file is missing a Comment column: The specified column is either missing or incorrectly named. If the column name looks correct, ensure that there are no extra spaces in or around the text.
  • Unknown error: This error appears if one of your question labels is incorrect or if there is a connection issue.