
When running an integration how can it prompt the user to pick a file?
There is a "Before Integration" script in the script library (even though I haven't tried it myself) that goes like:
'Create a File System Object – this will be used to check that the path specified by the user exists
Dim pFSO
Set pFSO = CreateObject("Scripting.FileSystemObject")
'Prompt the user to enter a value
sPath=InputBox("Enter the full path to the source file(s).", "Enter Path")
'Test to make sure that the value supplied is a valid path
If Not pFSO.FolderExists(sPath) then
CancelIntegration sPath & "' is not a valid path. Please run the integration again."
Else
SetVariable "sPath", sPath
End If
In case you weren't aware, there is quite a bit of script samples in Integration Manager if you go to Script -> Script Library in Script Editor window.