Excel to Title Blocks for AutoCAD (MCP)
=======================================

Lets your AI assistant write the title blocks of every drawing in a folder into one Excel table, and write your edits back into all the drawings in one go.
(日本語の説明は README-ja.txt をご覧ください。)


1. Install (about 2 minutes)
----------------------------
Claude Desktop (no settings file to edit)
(1) Download the extension file (.mcpb) from the page where you got this app. You do not need to unzip anything.
(2) Open Claude Desktop and go to Settings -> Extensions.
(3) Drag the .mcpb file onto that page, then press Install.
    (If dragging does not work: Advanced settings -> Install Extension... on the same page, and choose the file.)
(4) Start a new chat and ask "Which Excel to Title Blocks tools can you use?" The AI lists them and you are ready.

Other AI clients (MCP settings)
(1) Unzip this file anywhere, for example: C:\Tools\excel-to-title-blocks
(2) Add the server to the MCP settings of your AI client (change the path to where you unzipped it; write each \ in the path twice).

    {
      "mcpServers": {
        "excel-to-title-blocks": {
          "command": "C:\\Tools\\excel-to-title-blocks\\py\\python.exe",
          "args": ["-m", "zumen_check.server_tb"]
        }
      }
    }

(3) Quit the AI client and start it again.

You do not need to install Python. It is included in this folder.


2. Use
------
(1) Ask the AI to write the title blocks into a table:
      "Write the title blocks of the drawings in C:\Drawings\ProjectA into C:\Drawings\titles.xlsx"
    The table has one row per title block (file, layout, block, no) and one column per attribute
    (drawing number, title, revision, date and so on, under the tag names of your title block).
    The title block is found automatically. If another block was picked, the AI lists the other blocks it found;
    tell it the name ("use the block named TB-A1") and it writes the table again.
(2) Open the table in Excel and change what you need: a new revision and date for every sheet, a new project name, a corrected title.
    Leave the first four columns (file, layout, block, no) as they are. They tell which title block each row belongs to.
    Clear a cell to empty that attribute in the drawing. You can also save the table as .csv.
(3) Ask the AI to show what would change, then write it back:
      "Show me what would change if I apply C:\Drawings\titles.xlsx to the drawings in C:\Drawings\ProjectA"
      "Apply it and save the drawings in a folder named Updated"
    Only the cells that differ from the drawing are changed.
    The updated drawings are saved in a separate folder under the same file names. The original files are not changed.
    (Drawings with nothing to change are not saved. A file that already exists in that folder is not overwritten.)

Good to know
    Values are kept as text, so 001 stays 001. If Excel turned a cell into a date or a true/false value, that cell is reported
    and nothing is written from it; format the cell as Text and type the value again.
    Attributes that hold an auto-updating field (for example a plot date) are left alone. To replace them with your value, ask
    "apply it and overwrite the fields too".
    When a new value is longer than the old one, add "narrow the values that got longer" and they are narrowed to fit the box.
    Rows or cells that could not be applied (a drawing that is not in the folder, a tag the block does not have, a locked layer)
    are listed with the reason, and the rest is still applied.
    Each saved copy is read back and checked. A copy is saved only when every planned value went in, so you never get a half-updated drawing.
    If a drawing in the folder is open in AutoCAD right now, that one is skipped and you are told which.
    For DWG files, keep AutoCAD running (each drawing is opened and closed in turn; the drawing you are working on stays as it is).
    DXF files can be handled without AutoCAD running.


3. Free and subscription
------------------------
Free: writing the title blocks into a table, and previewing what would change.
Subscription: writing the table back into the drawings.

Subscribe: https://ai-pick.tech/autocad/title-block/
After subscribing, give the AI the license key shown on the purchase-complete page (once):
      "My license key is ...... Please register it."
To cancel, change the card or get receipts, ask the AI "I want to manage my subscription" and it gives you the link.
The subscription check sends only the license key to the server. No drawing data is sent.


4. Help
-------
If something does not work, you lost your key, or you would like another feature added, write to contact@gramshift.com.
The most requested items go into the next version first.
