Forum Discussion

ST1's avatar
ST1
New Contributor III
4 months ago

Transformation Event Handler using Batch Load

When loading data through batch file, does transformation event handler invoked the same way as running through manual workflow steps? Also, how can I execute Workflow (import->validate->load) thro...
  • JoakimK's avatar
    3 months ago

    If you are using the standard "BRApi.Utilities.ExecuteFileHarvestBatch" function then the answer is yes, it will invoke all the same steps.

    Secondly, you can decide which steps of the import process to be executed by setting the relevant boolean flags that are used in the same BRApi call above, the easiest way to do that is to create parameters for each flag, and then have the parameter in the function.

    Example:

    Dim valTransform As Boolean = True
    Dim valIntersect As Boolean = True
    Dim loadCube As Boolean = True
    Dim processCube As Boolean = False
    Dim confirm As Boolean = False
    Dim autoCertify As Boolean = False

    Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, Scenario, Time, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False)

     

    Joakim