# Compare

**Panel:** Export | **Button:** Compare

<img src="Extensions/duHast-2025.extension/duHast.tab/Export.panel/Compare.pushbutton/Icon.png" width="40" alt="button icon">

Compares the sheets listed in a Revit schedule against the PDF files in a folder, and
reports which sheets have no matching file and which have more than one.

## What it does

1. Asks you to select a **schedule** from the model by name.
2. Asks you to select a **folder** containing the PDF files to check against.
3. Exports all sheet schedules and reads the selected schedule's content back.
4. Builds a sheet number for each row by concatenating the **first two columns** of that row
   (see *Schedule setup* below). Rows with fewer than two columns are skipped.
5. Finds every `.pdf` in the folder and all its subfolders.
6. Matches each sheet number against the file names using a **starts with** test.
7. Reports, sorted by sheet number:
   - sheet numbers with **no matching file**;
   - sheet numbers with **more than one matching file**.

Matched sheets are printed as they are found. If every sheet matches exactly one file the
tool reports that all files matched successfully.

## When to use this

Use this after an issue to confirm that every sheet on the drawing register has been
exported, and that no sheet has produced duplicate files.

## Schedule setup

The sheet number is built as `row[0] + row[1]` — the first two columns of the schedule,
concatenated with no separator. This suits a schedule whose first two fields together form
the full sheet number (for example a discipline prefix column followed by a number column).

If your schedule holds the whole sheet number in a single first column, the second column's
value will be appended to it and nothing will match. Adjust the schedule fields, or the
`get_full_sheet_number_from_data` function in
`Extensions/duHast-2025.extension/duHast.tab/lib/export/CompareRevitToFolder/compare_revit_schedule_to_folder.py`,
accordingly.

## Requirements

- A schedule in the model listing the sheets to check.
- A folder of exported PDFs, named so that each file name **begins with** the sheet number.

## Notes

- Only `.pdf` files are considered. DWG exports are not checked by this tool.
- The comparison is on file names only. File contents, dates and sizes are not examined, so
  this will not tell you whether a PDF is out of date — only whether one exists.
- The search walks subfolders, so a sheet found in two different subfolders is reported as
  a multiple match.
- A schedule that filters out sheets will cause those sheets to be absent from the check;
  the tool reports on what the schedule contains, not on every sheet in the model.