Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article provides information about the Settings/Configuration/Comments Library page. Upload your standard comments and checklists into the Library to provide a resource for your plan review staff. There is no limit to the number of records that can be uploaded to the Library.

Prerequisites:

  1. Configure Groups for Permitting and Design Review Lists.

  2. Configure Review Types for Permitting and Design Review Lists (as needed).

  3. Configure Comment Sources for Permitting and Design Review Lists.

  4. Configure Categories and Sub-categories for Permitting and Design Review Lists.

  5. Gather plan reviewer checklists and standard comments.

    1. Verify that the comments to be uploaded are correct and accurate.

In this article:

The Standard Comments Library tools allow the Agency to populate one or more lists of standard comments for use by staff during plan review. Since reviewers are able to edit the standard comment text on-the-fly as needed, setting up a standard comment library can help improve plan review times by saving users the need to type the same comments over and over again. Instead, reviewers can insert standardized comments from the library and then just change the text to fit the current review needs.

Note

Before adding standard comments to the Comments Library, the Agency Admin will first need to:

  1. Gather agency standard comments from staff (such as plan reviewer checklists) and any other sources used.

    1. These will need to be compiled into a spreadsheet for upload into EPR.

  2. Verify that any comments to be uploaded are accurate and up-to-date.

    1. We also recommend checking for duplicates and/or very similar comments that may be addressed by a single comment.

  3. Confirm that any Groups referenced by comments already exist in EPR.

  4. Confirm that any Review Types referenced by comments already exist in EPR.

  5. Confirm that any Sources referenced by comments already exist in EPR.

  6. Confirm that any Categories and Subcategories referenced by comments already exist in EPR.

Table of Contents
minLevel1
maxLevel6
include
outlinefalse
indent
exclude.*Related articles.*
typelist
class
printablefalse

...

The Standard Comments Library

  • Standard comments uploaded to the Library can be inserted into plan review projects.

    • When records from the Library are inserted into a project, the record's Group, Source, Review Type and category/sub-category values are inserted as well.

  • Comment records can be batch uploaded into the Library via the Sample Spreadsheet template  CSV or XLS format.

  • Comment records can be manually added/edited to the Library.

  • Comments flagged ‘in-active’ are not visible to users for plan review.

  • Where applicable, comment records should be associated to a Group and Review type, Comment source and Checklist name.

  • Comment records are associated to either For Permitting or For Design Review purpose.

...

Batch update features allow selected records to be:

  • Marked as active or in-active.

  • Copied as ‘New’ comment records.

  • Deleted.

About Category and Sub-category lists

Client's who want to generate project correction report/deficiency reports that are  grouped by headings and/or sub-headings should enter those values as Category and Sub-category list types.

For example:

Standard Comments can be associated to a 'General Requirements' category and a 'Building Envelope' sub-category. 

The Sort Order value of those list records is then used to control the sorting on the correction reports.

Preparing Comments for Batch Upload

Follow these best practices to prepare standard comments for batch upload:

...

Start by downloading this SampleStandardComment.csv

...

Using Microsoft Excel add your standard comments to the sample SampleStandardComment.csv

...

During upload, data mapping is based on the Row 1 labels. Do not rename the column headers.

...

Export your standard comments as DOS comma separated values (csv)

  1. On Windows Excel "Save As" "CSV (MS-DOS)(*.csv)
    Image Removed

  2. On Mac go to File > Save As... MS-DOS Comma Separted (.csv)
    Image Removed

...

  1. For each comment being uploaded, provide either the entire item label or the entire item abbreviation to populate these columns in the spreadsheet.

Click here to download the CSV template for comments

...

Uploading to the Comments Library

...

From the Comment Library page, download the CSV template using the Download button ( (blue star) ). 

...

Enter the standard comment into the CONTENT column.

...

Complete the other columns as described below, validating that the Purpose, Review Type, Sources, Categories, Groups have matching Label or Abbreviation values.

...

Set 'Active' to False only if the comment should be unavailable to users.

...

To configure standard comments, navigate to Settings > Configuration > Comments Library. Standard comment can be added either one-at-a-time or in batches to the Comments Library.

Info

To import standard comments in batches, see Batch Importing Standard Comments.

...

Create a New Standard Comment

Most often, the Agency will upload standard comments in batches, but you can also create a single comment directly on the Comments Library page.

To create a single standard comment:

  1. Navigate to the EPR Standard Comment Library page at Settings > Configurations > Comments Library.

  2. Click on (blue star) in the lower right corner. The “Add Standard Comment” form pops up.

  3. Fill out the form with your standard comment information:

    1. Select a Purpose.

    2. Select a Group.

    3. Fill out the comment text in the text box.

    4. To make the comment more searchable within the library, and ensure it is better organized within future comment report letters, adding as much other information (Category, Subcategory, Source, Review Type and/or List Name) as possible is recommended. Refer to the table below for more details about each field.

      image-20240606-170503.pngImage Added
Info

When a library comment is inserted by plan reviewers, the comment’s Group - along with any Category, Subcategory, Source, and/or Review Type information - is also included in the new comment. Depending on the Agency’s Comment Report Letter configurations, some of these values may also be used when sorting comments within the letter.

Batch Import Standard Comments

The most common method of adding standard comments to the Standard Comment Library is to import them in batches via a spreadsheet template provided by EPR by an Admin. Periodic review and updating of library comments (such as when revised codes become available) is recommended.

To batch upload standard comments:

  1. Navigate to the EPR Standard Comment Library page at Settings > Configurations > Comments Library.

  2. Click on (blue star) to download the standard comment XLS template.

  3. Fill out the spreadsheet with your standard comment information:

    1. Filling out the CONTENT, PURPOSE, and ACTIVE fields is required.

    2. To make the comment more searchable within the library, and ensure it is better organized within future comment report letters, filling out as much other information (Category/categories, Subcategory/subcategories, Source/sources, Review Type and/or List Name) as possible is recommended. Refer to the table below for what each field represents.

  4. Save the file in CSV or XLS format.

  5. Select the Once ready to upload, click on (blue star) (Batch Upload button ( (blue star) ) on the Comments Library page. 

Sample CSV templateImage Removed

Required Column Values

These column values must be provided in order to uploaded standard comments into EPR successfully:

  • Purpose - Either "For Permitting" or "For Design Review".

    • EPR will only make standard comments available when they match the purpose of the Project the user is working on.

...

  1. ). This will open a window for you to select the file.

  2. Select the file and click on OPEN to import comments to the library.

Note

A message will indicate whether import was successful or if any comments failed to import. Comments will only import successfully if:

  1. The spreadsheet headers and format remain unchanged. Do not edit the column headers, add/remove columns, or otherwise change the template!

  2. The values filled out for Purpose, Review Type, Source/sources, Category/categories, Subcategory/subcategories, and Groups MUST match what is already configured in EPR. (“Checklist name” values do not have to already exist in EPR.)

Standard Comment Template Fields

The following table contains descriptions and examples of each field included in the “SampleStandardComment” upload template provided by EPR.

Comment Field

Required for Upload?

Must Match Existing EPR List Value or Abbreviation?

Description

Examples

Content

YES

NO

The comment text (which can be up to 8,000 characters in length).

Note

Remove any HTML formatting prior to uploading

...

Optional Column Values

These column values are optional, but provide two helpful functions:

  1. They can be used as filters when plan reviewers search the Standard Comment library.

  2. Some fields, such as Category and Subcategory, can be used to sort comments in the Corrections Report letter prepared for the applicant.

Review Type - If used, this field must match an existing Review Type value configured in EPR.

...

into EPR as CSV and XLS files may trigger unexpected comment reformatting if HTML remains. Comments can be reformatted after upload.

  • “Clearance around a water closet shall be…”

  • “Surfaces required to comply with Section 11B-902 of the 2022 CBC shall…”

Purpose

YES

YES

When users search for comments in the library during plan review, EPR will only show comments that match the current project’s Purpose.

Note

Unlike other list items, purpose is not freely configurable by the Agency and must be one of the listed values.

Must be either:

  • "For Permitting"

  • "For Design Review"

Review Type

NO

YES

Typically used only if specialized subgrouping is required beyond what Group, Categories, and Subcategories can provide. If a Group such as “FIRE” has a large number of comments, specialized subgroupings can improve searchability and/or sorting, such as for comments under a “Fire Life Safety” or other specialized review type.

Info

If an Agency does not expect to have multiple assignments/review tasks under a single Group, then Review Type is not generally

...

used.

...

As an example, Review Type would be configured if an agency has a "FIRE" group and requires individual review tasks done for "Fire Life Safety" and "Fire Sprinklers". In this scenario, "Fire Life Safety" and "Fire Sprinklers" would need to be configured as Review Types.

  • Sources - If used, this field must match an existing Source value configured in EPR.

    • Typically refers to a Code base or Code source.

    • Example: "2016 CBC" or "2019 IBC".

...

(For a sample FIRE Group):

  • “Fire Life Safety” or “FLS”

  • “Fire Sprinklers” or “FS”

  • Any active Review Type value or abbreviation

Sources (Source)

NO

YES

Typically refers to the code base or code source from which the comment originated.

  • “2019 IBC” or “19IB”

  • “2019 CBC” or “19CB”

  • “2022 CBC” or “22CB”

  • Any active Source value or abbreviation

Categories (Category)

NO

YES

Most often, checklists have standard comments

...

organized into sections and then subsections.

...

A "Category" is roughly equivalent to a main comment section heading.

...

  • A Structural checklist may have sections (categories) specifically for comments about "Concrete" or "Steel" comments.

  • Alternatively, a large checklist may have sections in

...

  • parts (Part I, Part II, III, IV…)

  • Any active Category value or abbreviation

Subcategories (Subcategory)

NO

YES

Most often, checklists have standard comments

...

organized into sections and then subsections.

...

A "Subcategory" is roughly is equivalent to a comment section

...

sub-heading.

...

  • A Structural checklist may have a Steel section with subsections (subcategories) for "General"

...

  • or "Cantilevered Column" comments.

  • Groups - This field must match an existing Group value configured in EPR.

    • Examples: "Building" or "BLDG" or "Fire" or "FIRE" (abbreviation must match EPR configuration).

...

  • Any active Subcategory value or abbreviation

Groups (Group)

NO

YES

Typically refers to the main group of users who will most frequently use the standard comment.

  • “Building” or “BLDG”

  • “Planning” or “PLAN”

  • Any active Group value or abbreviation

Checklist Name

NO

NO

This field provides an extra filter or grouping option that can be whatever text string the user wants

...

to type in.

Info

Checklist name does not need to match

...

  • Examples: "John's Checklist" or "Plumbing Checklist 2019".

ACTIVE - Refers to comment status.

...

any pre-existing EPR list values.

  • “General Administrative Comments”

  • “John H. Comment Checklist”

  • “Plumbing Checklist 2023”

Active

YES

NO

The comment’s default availability. “ACTIVE” means the comment will be available to reviewers/plan checkers during their reviews and “INACTIVE” means it will exist in the library but is not available for use during plan review.

Note

ACTIVE is an internal standard comment status rather than a list item, so it must be set to either ACTIVE or INACTIVE.

...

Typically, any new standard comment uploaded to EPR will have ACTIVE = TRUE.

Formatting Comment content after uploading

Comment content may have lost some formatting after loading. Click on the pencil icon to open the Edit Standard Comment form.

...

At the end of each paragraph, hit the ENTER key to create a new line, then apply the desired formatting to the selected text, as desired.

Correction reports will honor this formatting.

...

Must be either:

  • “ACTIVE” - if it will be used right away

  • “INACTIVE” - if the comment should not be available for use until a later date

Vendor_ID

NO

NO

If an Agency wants to track how frequently a specific library comment is used, provide a unique Vendor_ID number for that comment or comments.

Info

If tracking is not needed, this field can be left blank.

  • 0001

  • 12345

Info

Required fields must be filled into uploaded standard comments into EPR successfully. Providing optional fields is recommended as these values are used to sort and filter for standard comments with the library and, potentially, in comment report letters.

...

Formatting Comments After Upload

Comment formatting HTML must often be removed prior to uploading comments into the EPR comment library to prevent the transition from the comment source, to the CSV or XLS file, to the EPR library from resulting in unexpected reformatting. However, once inside EPR comments can be reformatted using the available editing tools.

To format a standard comment in the library:

  1. Navigate to the EPR Standard Comment Library page at Settings > Configurations > Comments Library.

  2. Apply any filters (if necessary).

  3. Hover over the comment.

  4. Click on (blue star) (View/Edit Comment) to open the “Edit Standard Comment” form.

Apply formatting as desired (see Comment Formatting Tools for options).

Before Editing

After Editing

image-20240606-201332.pngImage Addedimage-20240606-185740.pngImage Added


Comment Formatting Tools

Apply formatting to a comment using any of the following tools.

Feature

Icon

Description

Heading 1

image-20240606-192441.pngImage Added

Click to resize any selected text to use the largest font size (intended for a main heading).

Heading 2

image-20240606-192413.pngImage Added

Click to resize any selected text to use the large font size (intended for a sub-heading).

Heading 3

image-20240606-192342.pngImage Added

Click to resize any selected text to use the medium font size, which is slightly larger and bolder than standard text (intended for a third-level sub-heading).

Bold

image-20240606-192316.pngImage Added

Click to make any selected text bold.

Italic

image-20240606-192244.pngImage Added

Click to make any selected text italic.

Underline

image-20240606-192204.pngImage Added

Click to underline any selected text.

Unordered List

image-20240606-192138.pngImage Added

Click to sort selected text into a list using bullets.

Ordered List

image-20240606-191820.pngImage Added

Click to sort selected text into a list using numbers.

Undo

image-20240606-191744.pngImage Added

Click to undo the last edit.

Redo

image-20240606-191725.pngImage Added

Click to redo the last edit.

Increase Indent

image-20240606-191702.pngImage Added

Click to increase the indent for the selected line.

Decrease Indent

image-20240606-191631.pngImage Added

Click to decrease the indent for the selected line.

Insert / Edit link

image-20240606-191444.pngImage Added

Click to insert or edit an existing hyperlink.

...

Other Standard Comment Library Batch Features

In addition to batch importing comments, the Standard Comment Library also allows users to batch export, batch update, and even batch delete standard comments.

Batch Update Comments to Inactive or Back to Active

To prevent a standard comment from being used by staff - in case the text needs to be reviewed and possibly updated, for example - Admins can simply mark the comment as “Inactive.” Inactive comments remain visible to Admins in the library page, but will not show up in reviewers' search results.

To set one or more standard comment as INACTIVE:

  1. Navigate to the Settings > Configuration > Comments Library page.

  2. Click on the checkbox next to each desired comment in the library list.

  3. At the top right of the table, click on (blue star) SET INACTIVE.

...

Warning

Once inactive, the selected comments become unavailable for use by staff during plan review.

To set one or more standard comment back to ACTIVE:

  1. Navigate to the Settings > Configuration > Comments Library page.

  2. Click on the checkbox next to each desired comment in the library list.

  3. At the top right of the table, click on (blue star) SET ACTIVE.

Info

Once active, the selected comments are again available for use by staff during plan review.

Batch Copy As New

To duplicate an existing library comment:

  1. Navigate to the Settings > Configuration > Comments Library page.

  2. Click on the checkbox next to each desired comment in the library list.

  3. At the top right of the table, click on (blue star) COPY AS NEW.

Info

The selected comments are duplicated in the library. This saves time whenever existing comments have to be copied over to other user groups and/or departments.

Batch Export Comments From the Library

The Standard Comment Library allows users to download comments from the library by exporting to a CSV file. Staff can then review these standard comments and even update them if necessary.

To batch export comments:

  1. Navigate to the EPR Standard Comment Library page at Settings > Configurations > Comments Library.

  2. Apply any filters (if necessary).

  3. Select one or more comments to export.

  4. Click on (blue star) DOWNLOAD to export the selected comments as a CSV file.

...

Info

Unlike the sample XLS file for uploading new comments, the Standard Comment download CSV file includes an additional column named “Comment ID” that is used to track the standard comment in EPR’s library.

Batch Update Comment Text

In addition to updating comments individually if desired, users also have the option to batch update their library comment text.

To batch update several comments at once:

  1. Navigate to the EPR Standard Comment Library page at Settings > Configurations > Comments Library.

  2. Apply any filters (if necessary).

  3. Select one or more comments to export.

  4. Click on (blue star) DOWNLOAD to export the selected comments as a CSV file.

  5. Review comment text within the CSV file and edit as desired.

  6. Once done, click on (blue star) (UPLOAD) to reupload the updated CSV file back into the Standard Comment Library.

...

Info

Because the CSV file includes the library’s comment id values, it will then update the existing library comments to reflect any changes made by the users.

Batch Delete Comments

Like with any delete function, users are advised to only perform a batch delete of library comments if certain that the selected comments are no longer necessary.

To batch delete several comments at once:

  1. Navigate to the EPR Standard Comment Library page at Settings > Configurations > Comments Library.

  2. Apply any filters (if necessary).

  3. Select one or more comments to delete.

  4. In the batch options menu that appears, click on (blue star) (MORE OPTIONS) to see the DELETE option.

  5. Click on DELETE.

  6. A pop-up will appear showing how many standard comments will be deleted and ask for confirmation.

    1. Click DELETE again to confirm or CANCEL to stop.

...

...

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@10c5c
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "comment" , "standard" , "upload" , "checklist" ) and type = "page" and space = "EKB"
labelsstandard comment upload checklist

...