Skip to Content
0
Jul 10, 2020 at 09:33 AM

Automate file uploading process in BPC

288 Views

Hello,

Is it possible to automate the file uploading process which we do from data manager in BPC ? Can we automate this via a macro ? We have a requirement that a csv file named prov_2020_07 stored in a folder called /Provisions gets automatically uploaded via the macro.

I have written below line of code which triggers the upload file prompt automatically but the user still has to click browse and fetch the file and upload on server folder. Can we automate that part too ?

Sub upload()
Dim cofCom As Object
Dim epm As Object
Dim api As Object
Set cofCom = Application.COMAddIns("SapExcelAddIn").Object
cofCom.ActivatePlugin ("com.sap.epm.FPMXLClient")
Set epm = cofCom.GetPlugin("com.sap.epm.FPMXLClient")

epm.DataManagerOpenFileUploadDialog
epm.DataManagerRunPackage "IMPORT", "Data Management", ""
epm.DataManagerOpenViewStatusDialog

End Sub

Regards,

Neha