I'm using Drupal 5.3, Calendar module 5.x-1.5, and Views Bonus Pack 5.x-1.1. I have a calendar view that shows the grid of 7 columns for the weekdays plus 4 or 5 rows for each month. It's a typical calendar layout. http://school.saintjohns.net/calendar/school

When I use the export to Doc function, it dumps all of the calendar event node titles into a 3 column table, all in the first column, in the order they were entered into the system. No dates are included, so we can't tell which event goes on what date, and the layout is completely lost. I'd really like for it to preserve the layout so we can open it up as a calendar in Word. Any suggestions on how to do this? I'm not a great PHP coder, but I'm willing to try to hack the module to preserve the table layout, if someone can give me some guidance on how to do it.

Comments

cindyr’s picture

cindyr commented

Don't know if this is related or not to the inability of it exporting the calendar table layout, but I tried changing my argument from "Display All Values" to "Summary, Sorted Ascending" and this (along with all the other Summary views) gives me a nasty mysql error. The view of the calendar on the page no longer shows any events listed on the calendar, but the export to Doc continues to give me the same listing (not sorted by date). The Display All Values lets the calendar on the page display all the events without the mysql error.

MySQL Error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: SELECT count( DISTINCT(node.nid)) AS num_nodes, node.type FROM node node LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid LEFT JOIN node og_node_data ON og_ancestry.group_nid = og_node_data.nid LEFT JOIN og_uid og_uid_node ON og_node_data.nid = og_uid_node.nid AND og_uid_node.is_active = '1' LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN content_type_birthday node_data_field_birthdate ON node.vid = node_data_field_birthdate.vid WHERE (node.status = '1') AND (node.type IN ('birthday','event')) AND (og_uid_node.uid = '1') AND (( REPLACE(node_data_field_date.field_date_value,'T',' ')>='2007-10-01 00:00:00' AND REPLACE(node_data_field_date.field_date_value,'T',' ')<='2007-10-31 23:59:59') OR ( REPLACE(node_data_field_birthdate.field_birthdate_value,'T',' ')>='2007-10-01 00:00:00' AND REPLACE(node_data_field_birthdate.field_birthdate_value,'T',' ')<='2007-10-31 23:59:59')) GROUP BY in /includes/database.mysql.inc on line 172.

pomliane’s picture

pomliane commented
Status: Active » Closed (won't fix)

This version of Views Bonus Pack is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.