Skip to content

Export > Custom tabular exporter: date formatting doesn't work #3368

Open

Description

@allanaaa

Using the custom tabular exporter to export dates into locale formats (short, medium, long, full) doesn't seem to have any effect in any of the available output formats.

custom

To Reproduce

Export some columns of identical dates into the five available locale formats.

Current Results

HTML tables, XLS, XLSX, CSV, and TSV all output the original data into each cell, no matter which locale format you've chosen. Omitting time does nothing. The "use local time zone" checkbox does nothing.

Short,Medium,Long,Full,ISO
2020-09-16T13:15:31Z,2020-09-16T13:15:31Z,2020-09-16T13:15:31Z,2020-09-16T13:15:31Z,2020-09-16T13:15:31Z
2020-09-15T13:15:00Z,2020-09-15T13:15:00Z,2020-09-15T13:15:00Z,2020-09-15T13:15:00Z,2020-09-15T13:15:00Z

Expected Behavior

Presumably (like some of the other settings for the custom tabular exporter) this is intended to work in at least one of the available output formats, but maybe not all of them. Can anyone tell me which formats?

There seem to be other discussions (#3322 for example) around this right now so I just want to register this as something to test when those are worked on.

Activity

  1. added
    Type: BugIssues related to software defects or unexpected behavior, which require resolution.
    Status: Pending ReviewIndicates that the issue or pull request is awaiting review by project maintainers or collaborators
    on Nov 27, 2020
  2. rachittiwari8562 commented on Dec 1, 2020

    @rachittiwari8562
    Contributor

    I have looked into this issue,and there seems to have some problem in backened.
    As far as i have researched the parameters are correcty passed in the backened upto the file main/src/com/google/refine/exporters/CustomizableTabularExporterUtilities.java
    But in the function "void setup()" the "date" variable (which ideally should have user selected values for different options) has default values and hence it gives identical results.

  3. rachittiwari8562 commented on Dec 1, 2020

    @rachittiwari8562
    Contributor

    Also i am having a hunch that something is wrong in the else case in the line from 117 to 136 .Specifically in the line 129.

  4. added
    exportExporting a project to some format. Use the format-specific sub-label if available
    and removed
    Status: Pending ReviewIndicates that the issue or pull request is awaiting review by project maintainers or collaborators
    on Dec 3, 2020
  5. allanaaa commented on Dec 3, 2020

    @allanaaa
    ContributorAuthor

    This issue is being noted in the 3.4.1 documentation here: https://deploy-preview-3336--openrefine-docs.netlify.app/manual/exporting/#custom-tabular-exporter
    (soon to be at https://docs.openrefine.org/manual/exporting#custom-tabular-exporter )

    In the future, when a PR to fix this has been completed, the documentation should be updated to reflect the functions.

  6. wetneb commented on Dec 3, 2020

    @wetneb
    Member

    We also noted that at the moment the option to ignore the time is not honoured.

  7. tfmorris commented on Dec 3, 2020

    @tfmorris
    Member

    Can anyone tell me which formats?

    XLS, XLSX, & ODS probably won't support localized dates. The rest of the listed formats probably should, although we might want to make ISO 8601 the default for CSV/TSV to encourage people to not make life more difficult for themselves.

  8. xbdeng commented on Apr 20, 2022

    @xbdeng

    I want to try to solve this issue, and I have done something. Could you assign this issue to me?

  9. assigned and unassigned on Apr 20, 2022
  10. added theissue type on Oct 13, 2026
  11. removed
    Type: BugIssues related to software defects or unexpected behavior, which require resolution.
    on Oct 13, 2026
  12. self-assigned this
    on Oct 22, 2026
  13. added this to the 3.10.2 milestone on Oct 23, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

exportExporting a project to some format. Use the format-specific sub-label if available

Type

Projects

No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions