topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Tue, 19 Sep 2006 01:22:50 GMT

Hi,

I have to upload an excel sheet from the desktop to the internal table & I am using the FM - TEXT_CONVERT_XLS_TO_SAP ... all is going well but the enduser wants that I should check for the situation where a wrong excel file is selected for the upload, then I need to throw an error that "wrong file selected".

Any reponses on how to handle it.

Thank You,

SB.

Re: Query

Former Member — Tue, 19 Sep 2006 01:31:45 GMT

you could use a file path parameter to request user to input the file path.

then u need to define what is defined as error/wrong.

There after just a pop up window to say 'wrong file selected'?

If all is fine then u proceed to upload. ?

Re: Query

Former Member — Tue, 19 Sep 2006 01:33:40 GMT

Hi ,

How do u want to validate that? Do you want to validate based on the file name? or File extension? Or incorrrect data?

If you want to validate the file name or file extension then you need to write ur own code.

If you want to validate based on the contents then you have to first upload and then loop through the data and validate.

Cheers

Re: Query

Former Member — Tue, 19 Sep 2006 01:41:48 GMT

Well I need to validate based on the filename... & I hope that since this is a regular monthly upload ... the excel sheet will be saved with date ...

Re: Query

Former Member — Tue, 19 Sep 2006 01:48:28 GMT

Hi,

Use the FM "SO_SPLIT_FILE_AND_PATH" and split the filename and validate as per your requirement.

Cheers

Re: Query

Former Member — Tue, 19 Sep 2006 01:55:26 GMT

Hi Vijay ... but this may restrict the user to enter the filename always the same ... instead of that if the first line/column of the excel sheet will always be = "Rate Type"... then they will have the flexibility to use any name with an .xls extention ...

With the FM that I am using TEXT_CONVERT_XLS_TO_SAP ... can I select the header's 1st column = 'Rate Type' & if sy-subrc <> 0. then throw an error...

Re: Query

Former Member — Tue, 19 Sep 2006 02:27:35 GMT

Any reponses for this query ??

Re: Query

Former Member — Tue, 19 Sep 2006 02:46:23 GMT

hi,

did u try using FM GUI_UPLOAD??

Re: Query

Former Member — Tue, 19 Sep 2006 03:08:01 GMT

Yes ... I did .. but in that the excel file values were shown as ## while debugging the internal table

Re: Query

Former Member — Tue, 19 Sep 2006 03:27:02 GMT

Hi SB,

You can select first row from the itab populated from excel and validate if the value = Rate Type as per you requirement.

REPORT zupload_excel_to_itab.

TYPE-POOLS: truxs.

PARAMETERS: p_file TYPE rlgrap-filename.

TYPES: BEGIN OF t_datatab,

col1(30) TYPE c,

col2(30) TYPE c,

col3(30) TYPE c,

END OF t_datatab.

DATA: it_datatab type standard table of t_datatab,

wa_datatab type t_datatab.

DATA: it_raw TYPE truxs_t_text_data.

CONSTANTS: c_filename(20) type c value 'Rate Pattern'.

At selection screen

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

field_name = 'P_FILE'

IMPORTING

file_name = p_file.

START-OF-SELECTION.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw " WORK TABLE

i_filename = p_file

TABLES

i_tab_converted_data = it_datatab[] "ACTUAL DATA

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

read table it_datatab index 0.

if it_datatab-col1 <> c_filename.

message e001 with 'Incorrect File'.

endif.

END-OF-SELECTION.

Hope this would give you some idea.

Cheers,

Vikram

Pls reward for helpful replies!!

Re: Query

Former Member — Tue, 19 Sep 2006 04:15:50 GMT

Thanx Vikram