Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MULTIENG.fMultiImportExcel problem

907664Feb 9 2012 — edited Feb 15 2012

Hello. I am new in FDM.
I want to use multiload methods in webscript. This is my code:

--------------------------------------
Sub webwebSAP2FDM()

Dim MULTIENG
Set MULTIENG = CreateObject("upsMPLDMw.clsMPLoader") 'upsWMPLoaderDM
MULTIENG.mInitialize API, SCRIPTENG

Call MULTIENG.mStructGetExcelToProperty ("D:\FDM\MTS_TEST\Inbox\TEST_SIT.xls") '- set result to the property PcolLoadSet.

If Not MULTIENG.fMultiImportExcel(MULTIENG.PcolLoadSet) Then
MsgBox "Import Failed "& MULTIENG.GstrError
End If
.....
----------------------------------------

TEST_SIT.xls file exists and is correct - in FDM web client I upload this file using multi-load without any problem. But when I try to upload it with the script I got "false" result - "Import failed"
MULTIENG.GstrError is empty.

Did someone use multiload methods in scripts?

Edited by: 904661 on 09.02.2012 5:59

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 14 2012

Added on Feb 9 2012

#business-intelligence-applications, #financial-data-management, #performance-management-applications

2 comments

277 views