topic Re: problem in GUI_UPLOAD function module in Application Development and Automation Discussions

problem in GUI_UPLOAD function module

Former Member — Sun, 01 Feb 2009 21:26:53 GMT

Hi Folks,

I am in the BI system where I have limited scope of upload function module, So I used GUI_UPLOAD as a upload function module.

I am uploading CSV file and which have amount field (with comma ',' ) as one of the column , So it is truncating the other columns while retrieving data into internal table and giving wrong data in columns.

Any other Function module, or tricks to upload file which have ',' in one of the column.

Thanks

Re: problem in GUI_UPLOAD function module

Former Member — Mon, 02 Feb 2009 04:26:37 GMT

Hi,

Well in this case you will have to change the file format i.e. Instead of CSV make it tab delimited etc.

Else change the amount value by replacing comma(which woud be a tedious task).

There is no other alternative.

Best regards,

Prashant

Re: problem in GUI_UPLOAD function module

Former Member — Mon, 02 Feb 2009 04:45:42 GMT

Hi,

Before converting the file into CSV format, in excel chnage the cell format ( right click on the column & select Format Cell ) from Currency to Numbers then save the file as CSV format for uploading. This will remove the "," from the amount fields.

Hope this solves ur problem.

Re: problem in GUI_UPLOAD function module

awin_prabhu — Mon, 02 Feb 2009 04:58:07 GMT

Hi,

After getting data into internal table validate it and remove ','.

Using data type as string.

Use TRANSLATE for removing ','.

Ex:

TRANSLATE g_r_wa2-matnr USING '; ' .

Re: problem in GUI_UPLOAD function module

Former Member — Mon, 02 Feb 2009 05:03:21 GMT

Hi,

Declare two structures one structure field take char and upload data. Once uplaoded data you use Write .....Curency statemtnet and change char amount field into correct format and append to the sencond structure.

Regards

Md.MahaboobKhan

Re: problem in GUI_UPLOAD function module

Former Member — Mon, 02 Feb 2009 18:13:52 GMT

Hi,

I used Text(tab delimited) file as a input and this problem is resolved.

Thanks a lot for your inputs.