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.
-
-