http://projects.binnyva.com/forum/topic/csv_export Support for my OSS Projects en-US Tue, 07 Feb 2012 16:28:59 +0000 http://bbpress.org/?v=1.0.2 q http://projects.binnyva.com/forum/search.php http://projects.binnyva.com/forum/topic/csv_export#post-204 Tue, 07 Apr 2009 17:38:27 +0000 Binny V A 204@http://projects.binnyva.com/forum/ Hi Binny,<br /> <br /> i took a look at your export.php and changed two things:<br /> <br /> *) print '&quot;' . stripslashes(implode('&quot;;&quot;', $attendee)) . &quot;\&quot;\n&quot;; »»» i changed the &quot;,&quot; to &quot;;&quot; - this forces (excel &amp; openoffice) to put every value in a separate cell. maybe you could change this in the next version.<br /> <br /> *) header(&quot;Content-Disposition:attachment;filename=$event_name&quot; . date(&quot;_Y-m-d_H-i&quot;,time()) . &quot;.csv&quot;); »»» i brought date and time to differ better between multiple downloads of the same file. some people (including myself) may need this. maybe you could change this in the next version too, or (if you want to make it super-sophisticated) bring an admin-panel option if you want to add date&amp;time or not.<br /> <br /> **********************<br /> <br /> i then tried to replace &quot;A.name,A.url,A.email,A.phone&quot; at &quot;$all_attendee = &quot; with an asteriks &quot;*&quot;. i tried to do this to make the code flexible enough to handle different form-fields, because i still hope you will add custom-forms in the next version. <br /> <br /> my problem simply is, that i don´t know how to exclude &quot;guests, added_on, attendee_ID&quot; from &quot;{$wpdb-&gt;prefix}eventr_event_attendee&quot;-table and &quot;ID, picture&quot; from &quot;{$wpdb-&gt;prefix}eventr_attendee&quot;-table. <br /> <br /> another problem is that i don´t know how to exclude empty table-cells... maybe with something like &quot;EXCLUDE blablabla WHEN/IS NULL&quot;?