Problem: Using views data export for csv downloads from entityforms, the submitted and changed dates format is set to “medium”, which looks like “Wed, 10/21/2015 – 2:50pm”. Excel takes it to be a text string, so you can’t sort on the submitted date.

Solution we'd like to use: Clone the default view and change the date formats for those two fields to short” (“2015-10-21 14:50”), which sorts properly in Excel. Then change the view associated with the submissions reports for the entityform type to the new view.

What we found: The new view was used properly for the table and page displays in the entityform submissions, but the default view continued to be used for the csv and xml downloads.

Steps to demonstrate the error:

  1. I cloned the default view, which is just called “entityform”. I'll call the new view "sortable".
  2. In "sortable", I changed the date format for submitted and changed dates to “short” (“2015-10-21 14:50”) for the xml, csv, and table displays.
  3. For one entityform type, under the Edit tab, I clicked on "Submissions views", and set the "View for submissions reports" to the new sortable view.
  4. Under entityform submissions, I ascertained that the new format appeared in the "table" display.
  5. I downloaded as csv and xml, and saw that the date formats were still "medium".
  6. I changed the format for the submitted date in the default view, "entityform", to "short".
  7. Downloaded the submissions as csv again, and saw that "submitted date" was in the short format, and "changed date" was in medium format. i.e. it matched the default view even though the "sortable" view was still specified for the entityform type. Ditto for the xml download.

Comments

caroline.hecht created an issue. See original summary.

tommycox’s picture

Title: csv and xml downloads with views data export use default view instead of selected view » Views Data Export uses default view instead of selected view
Project: Entityform » Views data export
Version: 7.x-2.x-dev » 7.x-3.x-dev
tommycox’s picture

Status: Active » Closed (works as designed)

This seems to be more of an architectural decision with how adding new view displays works, which follows the settings of the master view as is the case with adding any new child view. Closing.