topic Re: upload a file from presentation server in Application Development and Automation Discussions

upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:12:39 GMT

hello..

Please help me in the below problem !

When I am uploading a space delimited (.prn) file from presentation server, into an internal table the different fields are not recognized. the data is uploaded according to the length of the field defined in the internal table and hence correct data is not going into the fields in the internal table

for example: if in the file i have the two fields with values

HELLO HOW

and if my internal table has two fields with lengths 8 and 10

i am getting HELLOHOW into first field and blank in next field. How to differentiate the fields?

i am using file type ASC and field separator = 'X'.

I tried with tab delimited file, i am having the same problem.

Thank you,

Rushi

Re: upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:15:51 GMT

Try a comma seperated file and use the split at , into respective fields.

Thanks

Kiran

Edited by: kiran dasari on Oct 22, 2008 7:46 PM

Re: upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:16:02 GMT

Hi,

Try using the SPLIT AT statement for the purpose.

Regards

Lekha

Re: upload a file from presentation server

BH2408 — Wed, 22 Oct 2008 14:17:11 GMT

Hi ,

Try to create the correct flat file ..while creating use the seperator TAB or pipe .

regards,

Bharani

Re: upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:35:44 GMT

Hello Bharani,

How to create the correct flat file? I am having data in a excel sheet, and i saved as a tab delimited file while saving it. I am still having the same problem. fiels values ar enot recognised. Please suggest!.

Thank you,

Rushi

Re: upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:39:52 GMT

Hi Rushi,

I have search in SDN for half an hour for your query please do search SDN before posting. As i seen before some good material while we upload the EXCEL with tab delimiter (.prn file)

Check this link your issue will be solved this this complete steps are shown for BDC adjust the code according to your requirement.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/309cb157-738d-2910-7691-b74c4ddba3c7

Cheers!!

Balu

Re: upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:48:50 GMT

Balu,

Thank you very much for ur help ! Next time I will search for an hour before posting ! Sorry about that !.

Thanks again!,

Rushi

Re: upload a file from presentation server

Former Member — Wed, 22 Oct 2008 14:54:00 GMT

Hi never mind dude, actually many people will be spending there precious time to solve other issues, if i see same repeating post of same quiz questions or any normal issues then i always suggest the poster's to search before they post because definitely there will be some or the post related to the post they send.

Anyways happy to see your query is been solved.

Happy Posting

Cheers!!

Balu