topic Re: Encoded .csv data in Application Development and Automation Discussions

Encoded .csv data

Former Member — Fri, 03 Apr 2009 15:57:37 GMT

Hi guys,

I've uploaded a .csv file from my pc to an internal table using the FM GUI_UPLOAD. But now instead of getting the data I entered in the file:

MANDT Business partner Creation date Description

100 1234 3042009 testtest

300 4321 1012001 TEST

200 2222 14061987 Test3

It outputs to the following data:

ÐÏ# ########## ##.##.#### #õÿ ##ø########À #######ÿ#######ÿ#######

0.0.1. 00.00.0000

0.0.2. ######## Í 00.00.0000

0.0.3. 00.00.0000

0.0.4. 00.00.0000

0.0.5. 00.00.0000

0.0.6. 00.00.0000

0.0.7. 00.00.0000

0.0.8. 00.00.0000

0.0.9. 00.00.0000

0.0.10. ######## Í 00.00.0000

0.0.11. ######## Í ##.##.####

0.0.12. #######P## . .###

0.0.13. 00.00.0000

0.0.14. 00.00.0000

Is this encoded or somthing? Please explain the problem and help me solve it.

Your help will be greatly appriciated.

Former Member — Fri, 03 Apr 2009 16:06:19 GMT

Hi,

You need to pass the FILETYPE as DAT and HAS_FIELD_SEPARATOR = 'X' in GUI_UPLOAD FM.

Check proper file name is passed or not.

Former Member — Mon, 06 Apr 2009 06:47:21 GMT

That doesn't work, the program doesn't work anymore after selecting a file if I do that. This is my current FM;

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = gv_filename

has_field_separator = 'X'

FILETYPE = 'DAT'

TABLES

data_tab = it_klant

EXCEPTIONS

file_open_error = 1

file_read_error = 2

OTHERS = 17.

Again, the uploaded file has to be a .csv but the data just is getting through all weird now.