topic Re: Background function to convert CSV in Application Development and Automation Discussions

Background function to convert CSV

Former Member — Fri, 10 Jul 2009 10:47:50 GMT

Dear expert,

do you know if a function to convert CSV into SAP with the opportunity to use background execution exists?

Thank you in advance for you collaboration.

Warm regards,

Fuffo

Re: Background function to convert CSV

venkat_o — Fri, 10 Jul 2009 10:52:00 GMT

Hi,

<li>It is not possible to download data to presentation server in background. So no such function modules.

<li>To convert CSV to SAP . There is one function module TEXT_CONVERT_CSV_TO_SAP.

Thanks

Venkat.O

Re: Background function to convert CSV

Former Member — Fri, 10 Jul 2009 10:53:31 GMT

If you want to upload a CSV file from front end and load into SAP in Back ground mode, Then 'GUI_*' functions will not work as it won't support B/G execution.

Alternatively, You can always upload a file( Using CG3Z) in AL11 and your program can make use of the file in B/G mode.

This can be done using OPEN DATA SET, TRANSFER, CLOSE DATASET.

Thank,

Raj

Re: Background function to convert CSV

RahulKeshav — Mon, 13 Jul 2009 06:40:36 GMT

Try to use this one...

Here itab is ur internal table of same format as the .csv file is having

background processing

OPEN DATASET l_file FOR INPUT IN TEXT MODE ENCODING DEFAULT MESSAGE l_message.

IF sy-subrc = 0.

DO.

READ DATASET l_file INTO gs_tab.

IF sy-subrc <> 0.

CLOSE DATASET l_file.

EXIT.

ENDIF.

APPEND gs_file TO gt_file.

APPEND gs_tab TO gt_tab.

ENDDO.

ELSE.

IF sy-subrc <> 0.

MESSAGE e000 WITH text-012.

g_exit = '1'.

EXIT.

ENDIF.

Re: Background function to convert CSV

RahulKeshav — Wed, 15 Jul 2009 06:09:00 GMT

any update....

if problem is solved please close this thread...