{
  "name": "Batch Convert CAD/BIM Files to XLSX/DAE with Validation and Reporting",
  "nodes": [
    {
      "id": "be5c0de2-0df1-4c35-8b0e-26f8d1911bda",
      "name": "Sticky Note23",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        224
      ],
      "parameters": {
        "width": 376,
        "height": 368,
        "content": "## 📋 Quick Start Guide\n\n**1️⃣ Configure Settings**\nEdit \"Set Configuration Parameters\":\n- `converter_path`: Path to RvtExporter.exe\n- `source_folder`: Your CAD files location\n- `output_folder`: Where "
      }
    },
    {
      "id": "d8a6fce0-af86-4769-8911-afb6c665f38d",
      "name": "Sticky Note25",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        608
      ],
      "parameters": {
        "width": 380,
        "height": 224,
        "content": "## 🎓 Video Tutorials\n\n**📹 [CAD-BIM Pipeline Tutorial](https://www.youtube.com/watch?v=PMTZNRFjD6c)**\nComplete walkthrough of CAD-BIM automation\n\n**⚡ [Automated Validation](https://www.youtube.com/watc"
      }
    },
    {
      "id": "1182ee14-cf89-45ee-96dc-d96a6864dcfa",
      "name": "Sticky Note28",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        1168
      ],
      "parameters": {
        "width": 372,
        "height": 244,
        "content": "## 🆘 Support\n\n**Resources:**\n🌐 [DataDrivenConstruction.io](https://datadrivenconstruction.io)\n📧 support@datadrivenconstruction.io\n💬 [Community Forum](https://t.me/datadrivenconstruction)\n\n**Documentat"
      }
    },
    {
      "id": "8bd00e43-cb87-489a-87b6-a6258262a5bf",
      "name": "Sticky Note29",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        848
      ],
      "parameters": {
        "width": 380,
        "height": 304,
        "content": "## 🎯 Use Cases\n\n**Weekly Reports**\nAutomate Monday conversions\n\n**Quality Control**\nValidate before client delivery\n\n**Archive Projects**\nConvert old files to lightweight formats\n\n**BI Integration**\nF"
      }
    },
    {
      "id": "3ccefd7c-ade0-4125-952c-928115a49ebf",
      "name": "Sticky Note31",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        112
      ],
      "parameters": {
        "width": 372,
        "height": 100,
        "content": "⭐ **If you find our tools helpful**, please consider starring our repository on [GitHub](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto). "
      }
    },
    {
      "id": "c5388249-6dc3-4070-9057-2b5668251832",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -688,
        112
      ],
      "parameters": {
        "width": 520,
        "height": 1940,
        "content": "## 📋 Options Parameter Configuration Guide\n\n## 🎯 Overview\nThe Options parameter allows you to customize the export process with various flags and settings. Multiple options can be combined using space"
      }
    },
    {
      "id": "2fe7360d-df50-4eb7-8799-441e7aed7a1a",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -80,
        704
      ]
    },
    {
      "id": "614d8fe1-6c80-4cb0-b941-5aa3998a2321",
      "name": "Capture Pipeline Start Time1",
      "type": "n8n-nodes-base.code",
      "position": [
        144,
        656
      ]
    },
    {
      "id": "e64288d1-9d53-4036-afde-437c9892a927",
      "name": "Merge Pipeline Start with Config1",
      "type": "n8n-nodes-base.merge",
      "position": [
        688,
        672
      ]
    },
    {
      "id": "7b214d29-a619-4a41-8cfa-67f074470b89",
      "name": "Set Configuration Parameters1",
      "type": "n8n-nodes-base.set",
      "position": [
        416,
        512
      ]
    },
    {
      "id": "53648934-0bb7-49d3-83f9-ab4280bb3ec9",
      "name": "Find CAD Files1",
      "type": "n8n-nodes-base.executeCommand",
      "position": [
        848,
        688
      ]
    },
    {
      "id": "894a4fae-cd2f-4418-b35b-fc6a06cda820",
      "name": "Merge Config with Search Results1",
      "type": "n8n-nodes-base.merge",
      "position": [
        1008,
        576
      ]
    },
    {
      "id": "cc6f17d1-4393-4c77-947a-53c42c01543c",
      "name": "Process File List1",
      "type": "n8n-nodes-base.code",
      "position": [
        1168,
        576
      ]
    },
    {
      "id": "357d21f1-ff0b-4308-99a7-8ab3140b6dde",
      "name": "Check if Files Exist1",
      "type": "n8n-nodes-base.if",
      "position": [
        1328,
        576
      ]
    },
    {
      "id": "84eff3b1-f5a8-4c84-82cb-2fa1d1bc23ea",
      "name": "Split Files for Processing1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1520,
        560
      ]
    },
    {
      "id": "0330e04c-9572-439d-b09f-aa932b5e81ad",
      "name": "Create Output Directory1",
      "type": "n8n-nodes-base.executeCommand",
      "position": [
        1696,
        656
      ]
    },
    {
      "id": "1cbf1ee9-0710-4145-a54e-0c4c73e177a6",
      "name": "Merge File Data1",
      "type": "n8n-nodes-base.merge",
      "position": [
        1856,
        576
      ]
    },
    {
      "id": "627097e5-5d07-4386-a9d7-22dffe7ba4ab",
      "name": "Capture Start Time1",
      "type": "n8n-nodes-base.code",
      "position": [
        2032,
        576
      ]
    },
    {
      "id": "edf42bdd-67ed-46d1-a522-cbc93538d894",
      "name": "Small Delay",
      "type": "n8n-nodes-base.wait",
      "position": [
        2192,
        576
      ]
    },
    {
      "id": "1c4e14d2-f9cc-4b4f-85f0-7c0245c32b18",
      "name": "Execute Conversion1",
      "type": "n8n-nodes-base.executeCommand",
      "position": [
        2352,
        688
      ]
    },
    {
      "id": "f02f9f74-9b20-4857-92c3-4b0f4103f1b1",
      "name": "Calculate Conversion Time1",
      "type": "n8n-nodes-base.code",
      "position": [
        2512,
        688
      ]
    },
    {
      "id": "9255e34b-be94-4630-8887-fc7a0aafd739",
      "name": "Merge Data Before Verification1",
      "type": "n8n-nodes-base.merge",
      "position": [
        2672,
        576
      ]
    },
    {
      "id": "0e3dc51e-4891-4094-ad20-341424dd04df",
      "name": "Verify Output Files and Get Sizes1",
      "type": "n8n-nodes-base.executeCommand",
      "position": [
        2832,
        576
      ]
    },
    {
      "id": "8d038788-44e7-49be-a999-b97ac4f96fac",
      "name": "Complete File Verification1",
      "type": "n8n-nodes-base.code",
      "position": [
        2992,
        576
      ]
    },
    {
      "id": "44336609-1655-4f5b-92b4-9b6165620036",
      "name": "Generate HTML Report1",
      "type": "n8n-nodes-base.code",
      "position": [
        3152,
        576
      ]
    },
    {
      "id": "21c9bd6d-e1a0-4697-b99d-c51e666af986",
      "name": "Prepare Binary Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        3312,
        576
      ]
    },
    {
      "id": "3ba8b465-5da4-4b79-83e2-2bdb63222b6b",
      "name": "Save HTML File1",
      "type": "n8n-nodes-base.writeBinaryFile",
      "position": [
        3472,
        576
      ]
    },
    {
      "id": "94de0bbb-402b-4dea-bcaf-f98fdc678048",
      "name": "Verify and Prepare Path1",
      "type": "n8n-nodes-base.code",
      "position": [
        3632,
        576
      ]
    },
    {
      "id": "6558ac19-23c1-44c9-8b7b-3615052cd4a5",
      "name": "Open HTML Report1",
      "type": "n8n-nodes-base.executeCommand",
      "position": [
        3792,
        576
      ]
    },
    {
      "id": "cdf12580-ade1-4ae0-a699-980aca156c98",
      "name": "Final Completion Notice1",
      "type": "n8n-nodes-base.executeCommand",
      "position": [
        3952,
        576
      ]
    },
    {
      "id": "dc253ac4-c296-4a8c-897c-380e5e14b683",
      "name": "No Files Found Response1",
      "type": "n8n-nodes-base.set",
      "position": [
        1520,
        784
      ]
    },
    {
      "id": "ee8bb887-c553-412b-9be5-c865f08fbd82",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        112
      ],
      "parameters": {
        "width": 756,
        "height": 844,
        "content": "## 🏁 GROUP 1: INITIALIZATION\n\n**Nodes in this group:**\n• Manual Trigger\n• Capture Pipeline Start Time\n• Set Configuration Parameters\n• Merge Pipeline Start with Config\n\n**What happens here:**\n1️⃣ Pipe"
      }
    },
    {
      "id": "0ca6f619-b073-41b1-a248-0f2b62333773",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        624,
        112
      ],
      "parameters": {
        "width": 1024,
        "height": 840,
        "content": "## 🔍 GROUP 2: FILE DISCOVERY\n\n**Nodes in this group:**\n• Find CAD Files\n• Merge Config with Search Results\n• Process File List\n• Check if Files Exist\n\n**What happens here:**\n1️⃣ PowerShell scans the s"
      }
    },
    {
      "id": "8dcff587-4f09-4e86-a065-bdd056be456d",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1664,
        112
      ],
      "parameters": {
        "width": 316,
        "height": 844,
        "content": "## 🔄 GROUP 3: BATCH PREPARATION\n\n**Nodes in this group:**\n• Split Files for Processing\n• Create Output Directory\n• Merge File Data\n\n**What happens here:**\n1️⃣ File list is split into individual items\n"
      }
    },
    {
      "id": "ae685ee4-bbee-4b56-85e0-26f3da9053fd",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        112
      ],
      "parameters": {
        "width": 800,
        "height": 840,
        "content": "## ⚡ GROUP 4: CONVERSION EXECUTION\n\n**Nodes in this group:**\n• Capture Start Time\n• Small Delay\n• Execute Conversion\n• Calculate Conversion Time\n\n**What happens here:**\n1️⃣ Timestamp captured for each"
      }
    },
    {
      "id": "5fe7b6d6-7a36-41ae-a431-a93803227a50",
      "name": "Sticky Note15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2816,
        112
      ],
      "parameters": {
        "width": 284,
        "height": 836,
        "content": "## ✅ GROUP 5: VALIDATION\n\n**Nodes in this group:**\n• Merge Data Before Verification\n• Verify Output Files and Get Sizes\n• Complete File Verification\n\n**What happens here:**\n1️⃣ All conversion data is "
      }
    },
    {
      "id": "2a199a8f-7206-4b18-9e87-f9dc4db56d8d",
      "name": "Sticky Note16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3120,
        112
      ],
      "parameters": {
        "width": 456,
        "height": 832,
        "content": "## 📊 GROUP 6: REPORTING\n\n**Nodes in this group:**\n• Generate HTML Report\n• Prepare Binary Data\n• Save HTML File\n\n**What happens here:**\n1️⃣ All results compiled into statistics\n2️⃣ Professional HTML r"
      }
    },
    {
      "id": "565d9855-8447-4c4e-ab57-b652a8733040",
      "name": "Sticky Note17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3600,
        112
      ],
      "parameters": {
        "width": 484,
        "height": 828,
        "content": "## 🎯 GROUP 7: FINALIZATION\n\n**Nodes in this group:**\n• Verify and Prepare Path\n• Open HTML Report\n• Final Completion Notice\n\n**What happens here:**\n1️⃣ Report path normalized for Windows\n2️⃣ HTML repo"
      }
    },
    {
      "id": "32324229-f786-4023-bfc1-bc01ad05575d",
      "name": "Sticky Note30",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        976
      ],
      "parameters": {
        "width": 488,
        "height": 308,
        "content": "## 📝 Configuration Example\n\n```\nconverter_path: \nC:\\DDC_Converter\\RvtExporter.exe\nsource_folder: \nC:\\Projects\\Building_A\noutput_folder: \nC:\\Projects\\Converted\nfile_extension: .rvt\ninclude_subfolders: "
      }
    },
    {
      "id": "62e0570c-238d-40e2-8b1f-f1f71ca8f034",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -80,
        560
      ]
    },
    {
      "id": "637d319f-4c7d-4f14-8676-16e6a839812d",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        304
      ],
      "parameters": {
        "width": 192,
        "height": 384,
        "content": "## ⬇️ Only modify the variables here  \n— everything else works automatically"
      }
    }
  ],
  "connections": {
    "Small Delay": {
      "main": [
        [
          {
            "node": "Execute Conversion1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Capture Pipeline Start Time1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find CAD Files1": {
      "main": [
        [
          {
            "node": "Merge Config with Search Results1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Save HTML File1": {
      "main": [
        [
          {
            "node": "Verify and Prepare Path1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge File Data1": {
      "main": [
        [
          {
            "node": "Capture Start Time1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Open HTML Report1": {
      "main": [
        [
          {
            "node": "Final Completion Notice1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process File List1": {
      "main": [
        [
          {
            "node": "Check if Files Exist1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Capture Start Time1": {
      "main": [
        [
          {
            "node": "Small Delay",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Data Before Verification1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Execute Conversion1": {
      "main": [
        [
          {
            "node": "Calculate Conversion Time1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Binary Data1": {
      "main": [
        [
          {
            "node": "Save HTML File1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if Files Exist1": {
      "main": [
        [
          {
            "node": "Split Files for Processing1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Files Found Response1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate HTML Report1": {
      "main": [
        [
          {
            "node": "Prepare Binary Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Output Directory1": {
      "main": [
        [
          {
            "node": "Merge File Data1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Verify and Prepare Path1": {
      "main": [
        [
          {
            "node": "Open HTML Report1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Conversion Time1": {
      "main": [
        [
          {
            "node": "Merge Data Before Verification1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Complete File Verification1": {
      "main": [
        [
          {
            "node": "Generate HTML Report1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Files for Processing1": {
      "main": [
        [
          {
            "node": "Create Output Directory1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge File Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Capture Pipeline Start Time1": {
      "main": [
        [
          {
            "node": "Set Configuration Parameters1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Pipeline Start with Config1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Configuration Parameters1": {
      "main": [
        [
          {
            "node": "Merge Pipeline Start with Config1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Merge Data Before Verification1": {
      "main": [
        [
          {
            "node": "Verify Output Files and Get Sizes1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Config with Search Results1": {
      "main": [
        [
          {
            "node": "Process File List1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Pipeline Start with Config1": {
      "main": [
        [
          {
            "node": "Find CAD Files1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Config with Search Results1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Verify Output Files and Get Sizes1": {
      "main": [
        [
          {
            "node": "Complete File Verification1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}