First of all, this module rocks - thanks Steven!

I am using it with the Calendar module to export a list of shows from the daily/weekly/monthly displays of the Calendar view. Each show is a node and each node has a date-time field (node_data_field_show_time.field_show_time_value) that specifies the time and date of the show. The Calendar view shows the titles of all shows for the given date range in rows that correspond to the show time. The export picks up the show titles for the given date range but not the date-time information for each show.

Unfortunately, without the date-time information for each show, the export is not very helpful to me - is there any way to pick that up?

Below is the view query for my DAY display of my Calendar view for DATE="2010-12-10."

SELECT node.nid AS nid,
node.title AS node_title,
node_data_field_show_time.field_show_time_value AS node_data_field_show_time_field_show_time_value,
node.type AS node_type,
node.vid AS node_vid,
node.changed AS node_changed
FROM node node
LEFT JOIN content_type_show node_data_field_show_time ON node.vid = node_data_field_show_time.vid
WHERE (node.status <> 0)
AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_show_time.field_show_time_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(-28800)), '%Y-%m-%%d') <= '2010-12-10' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_show_time.field_show_time_value, '%Y-%m-%%dT%T'), SEC_TO_TIME(-28800)), '%Y-%m-%%d') >= '2010-12-10'))
ORDER BY node_changed ASC

Comments

steven jones’s picture

Status: Active » Postponed (maintainer needs more info)

We use the fields that date module provides, does it not work?

The fields we export should just run through the normal views rendering layer, so I'm not sure why your dates aren't working.

greggadsdon’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)

As Drupal 6 nears the end of its life and support period, the 6.x version of Views Data Export will not be supported either. To that end, this issue has been closed, and will not be resolved in the 6.x branch of Views Data Export.

If this issue is still relevant to 7.x branch of Views Data Export, then please re-open and move to a relevant 7.x version.