Managing the comments of a review

The review page has two tabs that list the comments and the findings of the review in a table:

Use these tabs to follow the discussions, to close them in bulk, and to export them to Excel. To comment on the designs, see Contributing to a review.

The Comments tab

The Comments tab of a review

Each row is a comment, a reply or a finding. You see the public comments and the comments of your groups. Review moderators see all the comments.

Column Content
Design, ResourceThe commented design and resource. These columns are always visible.
TypeComment or Finding.
Unique keyThe label of the comment or the finding, for example UVF_SR-12. Click it to open the comment. This column is always visible.
Finding TitleThe title of a finding.
StatusOpen, In progress (findings only) or Closed.
ContentThe text. This column is always visible.
Likes, Liked byThe number of likes and the users who liked the comment. To see the comments that you liked, select your name in the filter of Liked by.
ObjectiveThe objectives of the commented resource.
GroupThe group that can read the comment, or Public. This column is hidden by default.
Resource's diagramThe diagram of a comment on a diagram. This column is hidden by default.
AnnotationThe quoted text of a comment on a Word or PDF document.
ColumnThe Excel column of a comment on a spreadsheet cell. This column is hidden by default.
OrderThe position of the resource in the design. This column is hidden by default.
Creator, Replied, Created, ModifiedThe author, whether the comment has replies, and the dates. Modified is hidden by default.

The table can also show the custom attributes of comments and findings. A user with the Create, modify or close a review permission selects them:

  1. Click Configure.
  2. Move the attributes to Selected properties.
  3. Put the attributes in order.
  4. Click OK.

This choice applies to this review, for all the contributors.

Filtering, sorting and choosing the columns

SECollab saves the visible columns and the number of rows for each page in your browser, for each review.

Changing many comments at once

Select rows with their check boxes. The buttons above the table act on the selected rows:

The buttons that act on the selected rows

A dialog gives a summary of the changes. In the dialog:

  1. For Close and Reopen, optionally select Close the entire discussion or Reopen the entire discussion. The change then applies to the whole thread of each selected comment.
  2. Select the confirmation check box.
  3. Click OK.

These actions are for review moderators, while the review is in progress and before the end of its due date. Close and Reopen also need the Comments and findings mass status modification permission. Delete needs the Mass delete comments and findings permission. Create findings needs the Add or modify a finding and Moderate and delete review comments permissions. The History tab records mass deletions with the Mass deletion tag.

The Findings to Resolve tab

You can plan a finding for one or more reviews that must resolve it. For example, you can plan the findings of a design review for the next review of the same design. The Findings to Resolve tab lists the findings planned for this review. A finding of this review appears in the tab only when someone links it.

The Findings to Resolve tab

To link findings to the review:

  1. On the Findings to Resolve tab, click Link Findings.
  2. Click Select Findings.
  3. Select a review in progress of the project, in My Reviews or All Reviews.
  4. Optionally, filter the findings by objective, design, state or text.
  5. Select the findings.
  6. Select the confirmation check box.
  7. Click OK.
    The Link Findings to Review dialog

To remove findings from the tab, select them. Then click Unlink Findings. SECollab does not delete the findings.

You can also close or reopen the selected findings with Close and Reopen. SECollab changes each finding in its own review. It skips the findings of the reviews that you cannot access or cannot moderate. The tab has its own Configure button (finding attributes only) and its own export.

Only the review moderators who have the Moderate review findings permission can link and unlink findings. The review must be in progress, before the end of its due date.

Exporting comments to Excel

The export uses the table as you see it: its filters, its sort and its visible columns. For example, to export only the findings, filter the Type column. To export the comments of one group, filter the Group column.

  1. Set the filters, the sort and the columns of the table.
  2. Click Export Review to Excel (or Export findings to resolve on the Findings to Resolve tab).
  3. In the dialog, optionally move columns between Hidden columns and Displayed columns. This change applies to this export only.
  4. To add a summary sheet, select Export of objectives summary.
    The Export Review to Excel dialog
  5. Click OK. The export runs as an activity.
  6. When the activity is complete, download the file from the Activities page. See Following the activities of a project.

The dialog warns you when an important column is missing. For example:

The Excel file has these sheets:

You need the Export review comments permission. The export is available after the start of the review. A user who is not a review moderator exports only the public comments and the comments of their groups. If no comment matches the filters, SECollab creates no file, and the activity ends with a warning.

Importing the replies of third parties from Excel

You can send the exported file to people who do not use SECollab. They type replies in the Reply n content and Reply n user columns, up to five replies for each comment. You then import the file to add these replies to the discussions.

  1. On the review page, click the arrow button at the top right, then click Import Review from Excel.
  2. Select the .xlsx file.
  3. Click Analyze. SECollab shows the number of replies to import and the anomalies. Examples of anomalies are empty or duplicated replies, replies without author and replies to closed comments.
  4. Optionally, click Download the detail to get the analysis as an Excel file.
  5. If there are anomalies, select I confirm I want to import with anomalies. SECollab then ignores the rows with anomalies.
  6. Click Import. The import runs as an activity.

SECollab creates each reply with you as its author. The text of the reply starts with "Original author:" and the name in the file. The import only adds replies. It does not create discussions, delete comments or change the status of comments.

Rules for a valid file:

You need the Import review comments permission. The import is available while the review is in progress and before the end of its due date.