Reading Flat file data

[Former Member]

Dear Experts,

please guide me for below requirement.

1. Screen has input field 'File Name', Browse and Upload buttons.

2. When user clicks on Browse button, popup should raise with a facility to select file(xls, txt generally) from local machine and the selected file should be placed into Input field 'File Name'.

3. When user clicks on Upload button, all the fields and records should be assigned to Node.

The main achievement of this application to upload sales orders from local machine to SAP.

Thanks a lot.

Regards,

Siva Mandapudi.

[saravanan_narayanan · Accepted solution]

Hello Siva,

> 1. Screen has input field 'File Name', Browse and Upload buttons.
> 2. When user clicks on Browse button, popup should raise with a facility to select file(xls, txt generally) from local machine and the selected file should be placed into Input field 'File Name'.

for this you can use the FileUpload UI Element

> 3. When user clicks on Upload button, all the fields and records should be assigned to Node

for this you can use the function module 'TEXT_CONVERT_XLS_TO_SAP'

BR, Saravanan

[Former Member · Accepted solution]

Hi,

By using FileUpload UI Element I'm able to get only just file name and its type, But i'm expecting full file path. How can i achieve it.

Thanks a lot.

Siva Mandapudi.

[saravanan_narayanan · Accepted solution]

Hello Siva,

the FileUpload UI Element has a property by name 'DATA'. Once you browse the file and trigger the roundtrip to the server, the file content will be automativally populated the context attribute that is bound to the DATA property of the Fileupload UI element.

BR, Saravanan

[Former Member · Accepted solution]

Hi,

I'm already working on DATA property, My intention is to get the full file path not XSTRING data.

Please suggest.

Thanks a lot.

Siva Mandapudi.

[former_member205613 · Accepted solution]

Hi Siva Mandapudi,

the UI Element File Upload has the attribute FILE_NAMe where you can find the name!

regards

Heike