Workflow - Support for XLSGen

Workflow - Support for XLSGen

• A PowerSchool/IFAS workflow model named TESTDOC (version 1), marked Active.

• Vendor: PowerSchool. Author: Unknown. Created: 2025-08-07.

• Workflow definition version: “Version 7.04 XML Variant.”

How it is triggered and when it can run

• Trigger type: Table-triggered, not a manual or timed job.

• Trigger object: BT20.OHHBatchMaster.

• Trigger event: UPDATE (fires when that table is updated).

• Effective window: from 2025-06-23 to 2050-12-31.

• “JobEnabled” is 0 (the scheduler job is disabled), but the model/state itself is enabled (StateEnabled = true). Since it’s table-triggered, it can still run on update events.

What the workflow does (Main Flow)

• Steps: Start → A1 (C# Test Activity) → End.

• No conditions on the transitions; it flows straight through.

Details of the C# activity (A1)

• Purpose: Test creating and reading an Excel file via the Xlsgen COM engine.

• Action type: BT50WF Managed Activity “ExecuteCSharp.”

• Behavior:

  • Sets ModelId to “TestExcel” and creates a separate trace log.

  • CreateExcel():

    • Creates a new Excel workbook at C:\Temp\MyExcelFile2.xlsx.

    • Adds a worksheet named “sheet1.”

    • Writes “hello world!” to cell A1.

    • Closes and disposes of COM objects, logging cleanup.