topic Re: .CSV file upload problem in Application Development and Automation Discussions

.CSV file upload problem

Former Member — Fri, 11 Jan 2008 07:49:12 GMT

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.

Former Member — Fri, 11 Jan 2008 08:02:31 GMT

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 — Fri, 11 Jan 2008 08:05:58 GMT

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.