2 Replies Latest reply on Oct 7, 2011 10:43 AM by Igor Kortchnoï

    Problems in CSV export from RESTful Web services

    Igor Kortchnoï
      When I try to export web service's results, I have the following problems:

      - No column headings exported
      - CSV fields are not enclosed in quotation marks
      - I have comma as separator instead of semicolon that my swiss setting needs to properly import fields
      - Accentuated characters are in two-byte presentation

      I can palliate to first three problems by constructing result string manually in Resource Template select, though if there is a way to set them by putting correct parameters in ApexListener, it would be handy.

      However, I cannot cope with the last one (setting encoding).

      Could someone help me?

      I run Apex Listener 1.1.2.131.15.23 (not 1.1.3, as stated before) on Glassfish 3.1

      Thank you.

      Igor

      Edited by: kortchnoi on Oct 5, 2011 4:27 PM
        • 1. Re: Problems in CSV export from RESTful Web services
          Colm Divilly-Oracle
          Column headings are not included, columns are only quoted if the value in the column requires escaping, there is no way to change the column delimiter it is always a comma.

          Your last issue sounds like a character set encoding problem, can you detail your operating system and database character settings?
          • 2. Re: Problems in CSV export from RESTful Web services
            Igor Kortchnoï
            Windows 7 64 Ultimate
            Format: French (Switzerland)

            Glassfish 3.1
            Alex Listener 1.1.3.243.11.40

            I have just added -Dfile.encoding=UTF8 to JVM options in default-config and server-config sections of Glassfish, but the encoding problem is still the same.

            NLS:
            NLS_CALENDAR     GREGORIAN
            NLS_CHARACTERSET     WE8MSWIN1252
            NLS_COMP     BINARY
            NLS_CURRENCY     SFr.
            NLS_DATE_FORMAT     RRRR-MM-DD HH24:MI:SS
            NLS_DATE_LANGUAGE     ENGLISH
            NLS_DUAL_CURRENCY     SF
            NLS_ISO_CURRENCY     SWITZERLAND
            NLS_LANGUAGE     ENGLISH
            NLS_LENGTH_SEMANTICS     BYTE
            NLS_NCHAR_CHARACTERSET     AL16UTF16
            NLS_NCHAR_CONV_EXCP     FALSE
            NLS_NUMERIC_CHARACTERS     .'
            NLS_SORT     BINARY
            NLS_TERRITORY     SWITZERLAND
            NLS_TIMESTAMP_FORMAT     DD.MM.RR HH24:MI:SSXFF
            NLS_TIMESTAMP_TZ_FORMAT     DD.MM.RR HH24:MI:SSXFF TZR
            NLS_TIME_FORMAT     HH24:MI:SSXFF
            NLS_TIME_TZ_FORMAT     HH24:MI:SSXFF TZR