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

    Problems in CSV export from RESTful Web services

    Igor Kortchnoï
    Igor Kortchnoï Oct 5, 2011 2:28 PM
      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
      • 236 Views
      • Tags:
        • 1. Re: Problems in CSV export from RESTful Web services
          Colm Divilly-Oracle
          Colm Divilly-Oracle Oct 7, 2011 4:01 AM (in response to Igor Kortchnoï)
          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ï
            Igor Kortchnoï Oct 7, 2011 10:43 AM (in response to Colm Divilly-Oracle)
            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