Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem with ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member

‎2007 Feb 09 4:59 AM

0 Likes
2,847

Hi,

I'm trying to upload an excel file to internal table. While uploading it's ignoring the columns with blank values and I don't have control on the file to update blank fields with 0 or somethng. The file wud be created by BDC and tht file has to be loaded thruh the program itself and it's a scheduled job. Pls help...

Thanks in advance

Hi,

I'm trying to upload an excel file to internal table. While uploading it's ignoring the columns with blank values and I don't have control on the file to update blank fields with 0 or somethng. The file wud be created by BDC and tht file has to be loaded thruh the program itself and it's a scheduled job. Pls help...

Thanks in advance

Reply
7 REPLIES 7
Read only

Former Member

‎2007 Feb 09 5:01 AM

0 Likes
1,235

That is the normal behaviour of ALSM_EXCEL_TO_INTERNAL_TABLE. Use GUI_UPLOAD instead.

Read only

Former Member

‎2007 Feb 09 5:08 AM

0 Likes
1,235

Hi Chesat ,

You would anyway be converting the table which you get as output from the FM into an internal table , you can handle the ignored columns in this because if you look at the structure of the output file it has row and column no , so it a column no is not there it means that the column in that specific row was blank and you can populate the internal table accordingly.

Regards

Arun

Read only

Former Member
In response to Former Member

‎2007 Feb 09 8:36 AM

0 Likes
1,235

Hi,

I'm doing it in a diferent method i.e instead of excel I'm using a text file which downloads into exact report format. Now my problem is value field in FM ALSM_EXCEL_TO_INTERNAL_TABLE holds only upto 50 chars and my requirement is more than 300 chars. How to handle this pls answer.......

Thanks in advance

Read only

Former Member

‎2007 Feb 09 8:39 AM

0 Likes
1,235

why arenot you going for GUI_UPLOAD / GUI_DOWNLOAD it will be easier to handle

regards

shiba dutta

Read only

Former Member
In response to Former Member

‎2007 Feb 09 8:52 AM

0 Likes
1,235

GUI_UPLOAD gives me an error Access Denied

Read only

Former Member
In response to Former Member

‎2007 Feb 09 8:57 AM

0 Likes
1,235

The reason for access denied can be you have opened the file , so close the file and try again.

Read only

Former Member

‎2007 Feb 09 9:04 AM

0 Likes
1,235

Hi,

I see 2 issues here. 1st one is i dont think you can GUI_UPLOAD to Upload Excel files. You can use either TEXT_CONVERT_XLS_TO_SAP or ALSM_EXCEL_TO_INTERNAL_TABLE with the former much easier to use.

Second and the Important thing is, you cannot schedule a job to upload a file from presentation server because the background jobs run in application server and will have no clue about your system. So you will have to either run the program in dialog mode or store the data in Application Server.

regards,

Mahesh