topic read .csv from server directory in Application Development and Automation Discussions

read .csv from server directory

Former Member — Mon, 11 Nov 2019 08:52:30 GMT

read .csv contents char, dats, unit etc from server directory.

i have using:

OPEN DATASET file FOR INPUT IN TEXT MODE ENCODING DEFAULT.

...

READ DATASET file INTO my_structure.

dump to "read dataset":

exception = CX_SY_CONVERSION_CODEPAGE

During conversion of a text from code page '4110' to code page '4103', one of the following occurred: - Characters were discovered that cannot be displayed in one of the code pages - The conversion could not be performed for some other reason (see below for more details). Excerpt from the source buffer from the first character that could not be converted, displayed in hexadecimal form (with the ASCII characters in brackets): "82 CF 6E 01 00 00 04 05 00 00 13 00 08 02 5B 43 (..n...........[C)" The system was forced to terminate the current ABAP program 'ZTESTPROVA' since the conversion would have produced incorrect data. There are 50 of these non-convertible characters. If this number is 0, the second of the two scenarios described above applies.

thanks

Re: read .csv from server directory

FredericGirod — Mon, 11 Nov 2019 09:08:17 GMT

Luca, I think you really need to start learning about using search functionality over internet. You will find the solution of most of your issus

1 answer of Google with the key work "OPEN DATASET CX_SY_CONVERSION_CODEPAGE"

https://answers.sap.com/questions/2547874/open-dataset-and-transfer-ittable-to-file-error-cx.html

Re: read .csv from server directory

Tomas_Buryanek — Mon, 11 Nov 2019 11:53:53 GMT

I prefer to read files in BINARY MODE. And later convert if needed to text in specific code page.

In your case you would read dataset to xstring and after that convert it to string in code page of CSV file. We cannot tell which one, but probably UTF-8 (that depends on the provider who provides/creates that file).

Handy methods to conversion are in cl_bcs_convert (method xstring to string in this case).

Re: read .csv from server directory

Sandra_Rossi — Mon, 11 Nov 2019 15:36:56 GMT

Maybe this character-set recognition tool can help.