topic Re: GUI_DOWNLOAD export cyrillic characters wrong. in Application Development and Automation Discussions

topic Re: GUI_DOWNLOAD export cyrillic characters wrong. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954044#M1694379 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for your answer but my problem is not that the file is not exported in CSV. The problem appears only with the cyrillic characters. If I export in german or english, there are no problems.</P><P>However I tried your code I am getting the same results.</P><P></P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 11:28:51 GMT Former Member 2012-08-23T11:28:51Z GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954034#M1694369 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using GUI_DOWNLOAD to export a table with two lines. One contains the column descriptions and the other contains values. The problem is with the header(the column descriptions). It contains cyrillic characters(in bulgarian language), and they are exported with other strange characters. I am using this code:</P><P></P><P>call function 'GUI_DOWNLOAD'</P><P>exporting</P><P>filename = a</P><P>filetype = 'ASC'</P><P>tables </P><P>data_tab =b</P><P>.</P><P></P><P>Can you help me?</P><P></P><P>Thanks,</P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 09:47:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954034#M1694369 Former Member 2012-08-23T09:47:19Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954035#M1694370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>     change the file type as 'BIN' if you are downloading the contents to a text file other wise you have to use 'ASC'. check with the file type properly.....</P><P></P><P>Regards,</P><P>SUDHEER KUMAR CH S M.</P></BODY></HTML> Thu, 23 Aug 2012 10:37:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954035#M1694370 Former Member 2012-08-23T10:37:05Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954036#M1694371 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>     change the file type as 'BIN' if you are downloading the contents to a text file other wise you have to use 'ASC'. check with the file type properly.....</P><P></P><P>Regards,</P><P>SUDHEER KUMAR CH S M.</P></BODY></HTML> Thu, 23 Aug 2012 10:37:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954036#M1694371 Former Member 2012-08-23T10:37:06Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954037#M1694372 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>     change the file type as 'BIN' if you are downloading the contents to a text file other wise you have to use 'ASC'. check with the file type properly.....</P><P></P><P>Regards,</P><P>SUDHEER KUMAR CH S M.</P></BODY></HTML> Thu, 23 Aug 2012 10:37:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954037#M1694372 Former Member 2012-08-23T10:37:06Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954038#M1694373 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>     change the file type as 'BIN' if you are downloading the contents to a text file other wise you have to use 'ASC'. check with the file type properly.....</P><P></P><P>Regards,</P><P>SUDHEER KUMAR CH S M.</P></BODY></HTML> Thu, 23 Aug 2012 10:37:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954038#M1694373 Former Member 2012-08-23T10:37:06Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954039#M1694374 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>     change the file type as 'BIN' if you are downloading the contents to a text file other wise you have to use 'ASC'. check with the file type properly.....</P><P></P><P>Regards,</P><P>SUDHEER KUMAR CH S M.</P></BODY></HTML> Thu, 23 Aug 2012 10:37:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954039#M1694374 Former Member 2012-08-23T10:37:06Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954040#M1694375 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try passing the valid code page value in the FM.</P></BODY></HTML> Thu, 23 Aug 2012 10:45:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954040#M1694375 Former Member 2012-08-23T10:45:22Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954041#M1694376 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am exporting to CSV.</P><P></P><P>Thanks,</P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 10:48:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954041#M1694376 Former Member 2012-08-23T10:48:29Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954042#M1694377 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to determine the valid code page?</P><P></P><P>Thanks,</P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 10:55:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954042#M1694377 Former Member 2012-08-23T10:55:13Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954043#M1694378 <HTML><HEAD></HEAD><BODY><P style="text-align: justify;">If you want to download the internal table in CSV file with the headings, first use SAP_CONVERT_TO_TEX_FORMAT to convert the itab to CSV formatted then use GUI_DOWNLOAD, mentioning the columns headings in a separate internal table and assign it to FIELDNAMES parameter in GUI_DOWNLOAD</P><P></P><P>TYPE-POOLS: truxs.</P><P> DATA: i_data TYPE truxs_t_text_data.  </P><P></P><P>CALL FUNCTION 'SAP_CONVERT_TO_TEX_FORMAT'   </P><P>EXPORTING</P><P>     i_field_seperator          = ',' </P><P>*   I_LINE_HEADER              = </P><P>*   I_FILENAME                 = </P><P>*   I_APPL_KEEP                = ' '</P><P>   TABLES</P><P>     i_tab_sap_data             = itab </P><P>CHANGING</P><P>    i_tab_converted_data       = i_data</P><P> EXCEPTIONS</P><P>    conversion_failed          = 1</P><P>    OTHERS                     = 2. </P><P>IF sy-subrc  0.</P><P>   MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno </P><P>   WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. </P><P>ENDIF.  </P><P></P><P>CALL FUNCTION 'GUI_DOWNLOAD' </P><P> EXPORTING </P><P>* BIN_FILESIZE = FILENAME = 'c:\test.csv' </P><P>FILETYPE = 'ASC'</P><P>  IMPORTING</P><P> *FILELENGTH =</P><P>  TABLES </P><P>DATA_TAB = i_data      " internal table containing data</P><P>FIELDNAMES = i_column   " internal table containing headers</P><P>EXCEPTIONS </P><P>FILE_WRITE_ERROR = 1</P><P> NO_BATCH = 2</P><P> GUI_REFUSE_FILETRANSFER = 3</P><P> INVALID_TYPE = 4</P><P> NO_AUTHORITY = 5</P><P> UNKNOWN_ERROR = 6 </P></BODY></HTML> Thu, 23 Aug 2012 11:03:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954043#M1694378 Former Member 2012-08-23T11:03:42Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954044#M1694379 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for your answer but my problem is not that the file is not exported in CSV. The problem appears only with the cyrillic characters. If I export in german or english, there are no problems.</P><P>However I tried your code I am getting the same results.</P><P></P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 11:28:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954044#M1694379 Former Member 2012-08-23T11:28:51Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954045#M1694380 <HTML><HEAD></HEAD><BODY><P>May be you have to install that language in your systemfor your Operating system...</P></BODY></HTML> Thu, 23 Aug 2012 11:46:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954045#M1694380 Former Member 2012-08-23T11:46:27Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954046#M1694381 <HTML><HEAD></HEAD><BODY><P>If your MS office is not having the patch update for language related to bulgarian, then the language characters will not be displayed in correct manner. check with that...</P></BODY></HTML> Thu, 23 Aug 2012 11:48:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954046#M1694381 Former Member 2012-08-23T11:48:42Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954047#M1694382 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using OFFICE 2007. I can see the language(bulgarian) in the available languages.</P><P></P><P>Thanks,</P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 12:00:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954047#M1694382 Former Member 2012-08-23T12:00:35Z Re: GUI_DOWNLOAD export cyrillic characters wrong. https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954048#M1694383 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Does anyone has other suggestions?</P><P></P><P>Thanks,</P><P>Efren</P></BODY></HTML> Thu, 23 Aug 2012 15:18:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/gui-download-export-cyrillic-characters-wrong/m-p/8954048#M1694383 Former Member 2012-08-23T15:18:28Z