Commands  ›  Architecture / Comments  ›  Architecture Load Client Comments From Excel Workbook

Architecture Load Client Comments From Excel Workbook

Architecture / Comments writes to model Public API · not yet exposed

Coming soon

Before you run this

Excel comment workbook on disk in the company comment-register format (drawing ref, location, comment, author, date, status). Project comment register configured.

After it runs

One comment row in the project register per workbook row; sheet / drawing reference resolved against the project sheets where possible; new rows tagged with the workbook source path.

When to use this

Don't use this when

BCF imports (use the BCF command), PDF markups (use the PDF markup command), or workbooks not in the company format (the column mapping has to match).

Decision flow

1. Open the Excel workbook and read every row of the comments sheet.
2. Map columns to the project register (drawing ref, location, comment, author, date, status).
3. Resolve drawing refs against the project sheets to set a back-link.
4. Insert comment rows in one Transaction; tag with the workbook source path.
5. Report rows imported and any rows skipped (bad format, duplicate id).

What you'll see in the chat

on start
I'll load the comments from that workbook into the register now.
thinking
Reading each row and resolving drawing refs against the project sheets.
on success
Done — {n_imported} comments loaded from the workbook. {n_resolved} matched to sheets.
on failure
Couldn't load the comment workbook: {error}.

REST API

Not yet exposed

This command does not carry a [RestApi] attribute today. Once tagged, this section will auto-populate with:

  • POST /api/v1/commands/architecture_load_client_comments_from_excel_workbook
  • Request body schema (from [RestApiParam])
  • Response schema (from [RestApiResponse])
  • curl / JS / Python code examples

Keywords & intent patterns

Excel comments · comment register import · client feedback · comment pro-forma · workbook comments

PillarArchitecture / Comments