topic Re: gui_upload in Application Development and Automation Discussions

gui_upload

Former Member — Mon, 28 Dec 2009 14:22:02 GMT

Hi Experts,

i facing problem while i am uploading text data its special charecters are changing automaticaly as #

but my requirment is as what ever data is maintaned in text file even it is special charectors but it should upload as it is.

so friends how can i stop the these changes.

i am using FM GUI_UPLOAD.

EXMPL

uoploding_text : hi - hello

oputput_text : hi#hello

Thanks & Regards,

Tarun

Re: gui_upload

Former Member — Mon, 28 Dec 2009 14:35:02 GMT

Please use a meaningful subject line

Re: gui_upload

Former Member — Mon, 28 Dec 2009 14:38:44 GMT

Hi reddy,

My problenm in FM only

that whatever data is in presentation server it not fetching in internal table for special charectors,

its replacing special charecters with #.

so i think subject line is ok.

Regards,

Tarun

Re: gui_upload

Former Member — Mon, 28 Dec 2009 14:45:30 GMT

Hello

Try

HAS_FIELD_SEPARATOR = 'X'.

Re: gui_upload

Former Member — Mon, 28 Dec 2009 14:46:59 GMT

You will come to know soon friend when the moderator either locks this thread or gives you a warning for your very descriptive subject line

Re: gui_upload

Former Member — Mon, 28 Dec 2009 15:14:08 GMT

Which subject title do you think is more meaningfull to those who might know the answer:

> 1) gui_upload

> 2) FM gui_upload changes special characters to #

> 3) Hii experts

> 4) None of the above, because it can be searched first.

Just curious...

Cheers,

Julius

Re: gui_upload

kesavadas_thekkillath — Mon, 28 Dec 2009 16:41:51 GMT

Wow that was really good !!!

Re: gui_upload

Former Member — Mon, 28 Dec 2009 17:03:14 GMT

I dont Thnik so problem in FM , rather in Yourself....

Just use a good subject line.....

one better approach... use offset concept of splting the line of the text file and move that to indivdual fields and append into another internal table..

Regards,

Kumar

Re: gui_upload

Clemenss — Mon, 28 Dec 2009 20:25:35 GMT

Hi Devalla,

OK, better subject next time.

Special characters are not replaced by but displayed as #. Just because you can not display them.

Regards,

Clemens

Re: gui_upload

Former Member — Tue, 29 Dec 2009 08:30:57 GMT

Solved my self

Re: gui_upload

Former Member — Tue, 29 Dec 2009 09:45:56 GMT

HI,

Please share the answer .

regards,

ShaiKSHadulla.

Re: gui_upload

Former Member — Tue, 29 Dec 2009 09:52:05 GMT

I think "Solved my self" means that the fields of Tarun's internal table were of type "banana peel"...

Re: gui_upload

kesavadas_thekkillath — Tue, 29 Dec 2009 18:38:23 GMT

))))))))))))))

Re: gui_upload

Former Member — Tue, 29 Dec 2009 19:10:11 GMT

Considering GUI_UPLOAD's innocence here, perhaps GUI_SLIP would have been an OK subject title

Re: gui_upload

Former Member — Mon, 18 Jan 2010 06:45:35 GMT

Hello Friends,

I had a problem with GUI_UPLOAD, that i am getting junk values or # sign after every field. I was going through these thread and did not find answer in it. But i solved this my self. Then thought of sharing to everybody.

1) First convert Excel to Tab delimeted (*txt)

2) Then

CALL METHOD cl_gui_frontend_services=>gui_upload

EXPORTING

filename = iv_file_name

filetype = 'ASC'

has_field_separator = 'X'

IMPORTING

filelength = lv_length

CHANGING

data_tab = lt_customers

Please copy paste the same. otherwise if you keep commented fields like REPLACEMENT = '#' you will get error in this .

So keep only

filename = iv_file_name

filetype = 'ASC'

has_field_separator = 'X'

Rest everything just delete.

Hope it will help for others who facing problem in uploading excel.