08-12-2024 09:24 AM
Hello,
I'm looking for a function to put in a extensibility rule that will be handled via a data management sequence to execute an automatic import in a workflow that uses a connector datasource:
This function : Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, fixedScenario, systemTime, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) executes the harvest file, in my case i want it to execute the connector businessrule
Does anyone know how to do this? your help is much appreciated.
thank you
Solved! Go to Solution.
08-12-2024 05:33 PM
Here is a BRApi call that will trigger an Import from an import step that uses a connector rule. Note the SourceDataOriginTypes.FromDirectConnection argument which specifies that it is a direct connect.
Dim impProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, si.WorkflowClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, True)
08-12-2024 05:33 PM
Here is a BRApi call that will trigger an Import from an import step that uses a connector rule. Note the SourceDataOriginTypes.FromDirectConnection argument which specifies that it is a direct connect.
Dim impProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, si.WorkflowClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, True)
08-13-2024 09:47 AM
Thank you, this is working!
08-13-2024 10:55 AM
So, I see you have had one reply above, which works, but just to expand on this a little.
You can use that function you are referring to, all you would need to do is to first make sure you create an empty file in the Batch Harvest folder, lets call it a "trigger" file, with the correct naming convention to identify the WF name, Scenario, Time and load method (just the same as it would have been a file containing data). Then when you execute the BRApi.Utilities.ExecuteFileHarvestBatch the system will know its a connector based import workflow and will trigger the import to take place.
Secondly, there is a solution available on Solution Exchange, in OpenPlace, called "Data Import Schedule Manager" which is a tool to help you schedule connector based workflows in a very easy way.
Hope that helps.
08-14-2024 04:06 AM
Hello @JoakimK?,
I downloaded the "Data Import Schedule Manager" solution and set up an automatic import with it but the import failed because of this:
Do you know how this can be solved ?
Thank you for you help.
08-14-2024 06:05 AM
The version of the solution downloaded is DSM_PV8.2.0_SV100_PackageContents.
Framework 4.8
08-14-2024 07:41 AM
I changed this part of the BusinessRule Extender DSM_EmailHelper :
Dim fileExists As Boolean = False
If My.Computer.FileSystem.FileExists(filepathNoSpace) Then
If Not fileAttachmentPaths.Contains(filepathNoSpace) Then
fileAttachmentPaths.Add(filepathNoSpace)
End If
fileExists = True
End If
by putting this one instead:
Dim fileExists As Boolean = False
If File.Exists(filepathNoSpace) Then
If Not fileAttachmentPaths.Contains(filepathNoSpace) Then
fileAttachmentPaths.Add(filepathNoSpace)
End If
fileExists = True
End If
and it worked fine for me. @JoakimK do you see any inconveniant for this change ?
Thanks for your help
08-14-2024 07:43 AM
That is exactly right! And this is how it should be fixed. I will notify the owner of the solution to make sure its updated in OpenPlace as well. Thank you.
08-13-2024 11:00 AM
Thank you so much Joakim, i will look at the solution available on OnePlace 👌👍