GNOME Bugzilla – Bug 127557
Support export of tasks or other items to Excel (CSV)
Last modified: 2009-08-15 18:40:50 UTC
Currently, Evolution does not have any data export features, because it uses standard file formats which other applications can import. However, task list data is not easy to import into spreadsheets or project management tools, and it should be. This bug is part of the Integrated Collaborative Desktop Bounty Hunt. For more information on prizes, contest rules, and other bounty tasks, visit: http://www.gnome.org/bounties/ If you would like to start working on this bounty, please create a bugzilla account and append your intention to work on this bounty to this bug. If multiple people declare their intentions to work on a task, we encourage you to join forces and work together. Please do not close this bug. The contest organizers will mark this bug as FIXED when the prize is claimed.
Please see http://www.gnome.org/bounties/Tasks.php3#127557 for more information.
I am going to work on this.
Created attachment 33919 [details] [review] Patch that does this This patch adds a menu-option to save a task or calendar as a CSV (comma separated file). I've added this to the current save-calendar plugin.
Created attachment 33920 [details] [review] Little fix This one fixes a tiny mistake in the previous one
Oh, and ... gnome_vfs_write (handle, buffer, strlen (buffer), bytes_written); + g_free (buffer); csv_lines = g_list_next (csv_lines); And also ... g_print ("Write failed\n"); } + g_list_free (csv_lines); }
And the FALSE gbooleans of the g_string_free-functions should be TRUE :-)
Created attachment 33924 [details] [review] This is actually even more better There is no need to keep an offline copy in memory .. this one will write to the file while gathering the data (and freeing it). Bleh, I was probably not very awake last two patches...
Note that I have a CVS account on GNOME and that afaik I can commit this myselve. But I'd rather wait for permission from the original author of the altered file.
Comment on attachment 33919 [details] [review] Patch that does this http://bugzilla.gnome.org/attachment.cgi?id=33924&action=view
Comment on attachment 33920 [details] [review] Little fix http://bugzilla.gnome.org/attachment.cgi?id=33924&action=view
Created attachment 33929 [details] [review] Patch generator Philip hase created yet another take This one splits up the menu in two submenus. Also a few cleanups and some code-comments added
Created attachment 34083 [details] [review] Changed some UI requirements (Evolution Hackfest UI of 24 nov) Changed some UI requirements (Evolution Hackfest UI of 24 nov)
Created attachment 34154 [details] [review] With a type-selector like OpenOffice.org has
Created attachment 34308 [details] [review] A lot better Hmm, this one is A LOT better ...
Created attachment 34318 [details] [review] Extra patch to apply after 34308 Fixes some small memory issues
Created attachment 34319 [details] [review] Some bugfixes, replaces both 34308 and 34318 Some bugfixes
Created attachment 34391 [details] [review] First patch after revision by Moya Rodrigo
The work for comma separated value format is done and available in the MAIN of evolution in cvs.gnome.org. Closing this bug
I've received the cheque. Thanks a lot