topic Re: Error when transferring table data to a CSV format file. in Application Development and Automation Discussions

Error when transferring table data to a CSV format file.

Former Member — Wed, 18 Oct 2006 14:34:42 GMT

I am getting an error when I am passing the parameter value for the file name from the selection screen. If i hard code the path and name it works fine. can any one help me please. here is my code:

PARAMETERS: OUTFILE LIKE dxfile-filename

DEFAULT 'C:\Apositivepay.txt',

RUNDATE LIKE PAYR-LAUFD,

Bank LIKE T012K-HBKID. "List of Possible Banks

...

type-pools:TRUXS.

DATA: BEGIN OF OUTPUT_REC OCCURS 0, "Output file for USBANK

ACCT(12), "bank account no

...

Payee2(40) type c, "payee 2

END OF OUTPUT_REC.

data: itab1 type TRUXS_T_TEXT_DATA.

...

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'

EXPORTING

I_FIELD_SEPERATOR = ','

TABLES

I_TAB_SAP_DATA = OUTPUT_REC

CHANGING

I_TAB_CONVERTED_DATA = itab1

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.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = OUTFILE "This doesn't work

filename = 'C:\Apositivepay.txt' "This works

TABLES

DATA_TAB = itab1

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_WRITE_ERROR = 2

INVALID_FILESIZE = 3

INVALID_TABLE_WIDTH = 4

INVALID_TYPE = 5

NO_BATCH = 6

UNKNOWN_ERROR = 7

OTHERS = 8.

Message was edited by: Anwarul Kabir

Re: Error when transferring table data to a CSV format file.

Former Member — Wed, 18 Oct 2006 14:37:18 GMT

data: v_outputfile type string.

v_outputfile = OUTFILE.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = v_OUTputFILE

TABLES

DATA_TAB = itab1

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_WRITE_ERROR = 2

INVALID_FILESIZE = 3

INVALID_TABLE_WIDTH = 4

INVALID_TYPE = 5

NO_BATCH = 6

UNKNOWN_ERROR = 7

OTHERS = 8.

Make the highlighted changes

Message was edited by: Ravi Kanth Talagana

Re: Error when transferring table data to a CSV format file.

Former Member — Wed, 18 Oct 2006 14:38:05 GMT

try this:

DATA: FILENAME TYPE STRING.

MOVE OUTFILE TO FILENAME.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = FILENAME

TABLES

DATA_TAB = itab1

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_WRITE_ERROR = 2

INVALID_FILESIZE = 3

INVALID_TABLE_WIDTH = 4

INVALID_TYPE = 5

NO_BATCH = 6

UNKNOWN_ERROR = 7

OTHERS = 8.

Max

Re: Error when transferring table data to a CSV format file.

Former Member — Wed, 18 Oct 2006 14:40:14 GMT

hi,

use this code and save that file in CSV format it will work

OPEN DATASET P_IFILE FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF SY-SUBRC NE 0.

MESSAGE E000 WITH 'Problem in opening Application Server file'.

ELSE.

DO.

READ DATASET P_IFILE INTO IT_UPLOAD.

IF SY-SUBRC NE 0.

EXIT.

ELSE.

APPEND IT_UPLOAD.

CLEAR IT_UPLOAD.

ENDIF.

ENDDO.

CLOSE DATASET P_IFILE.

ENDIF.

IF IT_UPLOAD[] IS INITIAL.

MESSAGE E000 WITH 'NO data in the file/upload problem'.

ENDIF.

LOOP AT IT_UPLOAD.

SPLIT IT_UPLOAD AT ','

INTO

IT_FDATA-MATNR

IT_FDATA-WERKS.

IT_FDATA-SLGORT.

APPEND IT_FDATA.

CLEAR IT_FDATA.

ENDLOOP.

IT_TOTAL1[] = IT_FDATA[].

Re: Error when transferring table data to a CSV format file.

Former Member — Wed, 18 Oct 2006 14:51:49 GMT

Thanks its working now.

But another problem I am noticing now. Which is my I_TAB is holding an extra blank row. so the output is putting an extra smi-colon at the end. Any solutions for that? and also its putting smi-colon though I used coma to separate them? Is there anything else I need to do in order to have the coma as a separator instead of smi-colon?

Thanks