Application Development 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
Showing results for 
Search instead for 
Did you mean: 

.CSV file upload problem

Former Member
0 Kudos
121

Hi Experts,

I have a situation where I m uploading a .CSV file from prsentation server.

my internal table is having one column string type.

then i am breaking it into 5 columns by splitting.

1. now the situation is if the file contains some header in first row its throwing dump.

i want it should show error message to remove header from file. or simply exclude that particular row.

2. second situation is in the file i have more then file fields.

my requirment is to upload selected columns from file.

it will be 5 columns.

so at prsent if file has more then 5 columns its throwing dump.

Please reply soon..its realy urgent requirment.

Regards,

Azad.

2 REPLIES 2

Former Member
0 Kudos
52

Hi Azad,

Make sure that your CSV file fields length and Internal Table fields length are same and in the same order before uploading to internal table.

Regards,

Satish

Former Member
0 Kudos
52

Hi,

Handling your requirement using GUI_UPLOAD is not possible.

Use FM : ALSM_EXCEL_TO_INTERNAL_TABLE. With this you can get required columns (5 columns) data.