on 09-21-2016 5:30 AM
Hi All,
I have a requirement in which i have to upload a XL file from Odata service in ABAP Server.
Then after i have to read the XL file and update my DB table .
I have developed a FM to read the XL data and updating my DB table if i am executing the FM it is working fine but when i am including the FM
to service it failing and showing exception.
Kindly suggest me the solution.
Thanks and regard,
Rewati Raman
What was the Exception? I think you need to include a Gateway service. Its not mentioned in your query like as mentioned in the below,
File Attachments Approach in Gateway | SCN
Also in addition needed to check-out the below, in this relevant,
Load data from EXCEL file into Table UI on the ... | SCN
Thanks,
Kaushik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Kaushik Debnath for your reply.
I am using ALSM_EXCEL_TO_INTERNAL_TABLE Fm to read data from XL file inside this FM a standerd class is there
CALL METHOD cl_gui_frontend_services=>clipboard_import
IMPORTING
data = excel_tab
EXCEPTIONS
cntl_error = 1
* ERROR_NO_GUI = 2
* NOT_SUPPORTED_BY_GUI = 3
OTHERS = 4
.
IF sy-subrc <> 0.
MESSAGE a037(alsmex).
ENDIF.
while executing this line i am getting cntl_error = 1 exception .
So in service following error is coming Message A ALSMEX 037 cannot be processed in plugin mode HTTPS.
I didnt upload the XL file to service directly i was trying to read data from XL using FM .
Is it mandatory to upload first the read or directly i can read XL in service ?
Regard,
Rewati Raman
please do Upload 1st & check, you will easily observer the difference. If you Debug, its is possible that in your way, it would through a dump in ST22 & can also check the responsible-program lines from there.
Somehow, your similar issue was faced by our friends provided in the below link also,
Error while using File Upload through Frontend | SCN
Thanks,
Kaushik
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.