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
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: 

.CSV file upload problem

Former Member

‎2008 Jan 11 7:49 AM

0 Kudos
114

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

‎2008 Jan 11 8:02 AM

0 Kudos
45

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

‎2008 Jan 11 8:05 AM

0 Kudos
45

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.