LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-24-2005, 03:31 PM   #1
mcle
LQ Newbie
 
Registered: Dec 2004
Location: Leipzig, Saxony, Germany, Europe, Earth
Distribution: SUSE
Posts: 22

Rep: Reputation: 15
Export data from Evolution to Openoffice


Hi there,

I've testet several "Outlook replacement" software - Mozilla with Calendar, KOrganizer and Evolution.
Evolution seems to be the best for my needs, but I can't find any way to export tasks and calendar information and such from Evolution. I want to create a summary in Openoffice calc about a day of the calendar. I can't simply copy&paste, there's no export from Evolution at all and Openoffice seems to only import Evolution Adress books :-(
Is there something I can do about this or is this just bad luck for me?
On the other hand, if you can point me to a "PIM software" running on linux as "Outlook replacement" that can at be configured to display the time scale of a day 5-minutes-way like Evolution (and not 15 minutes as in KOrganizer) or can display this as in Mozilla Calendar in a free scale, but with a possibility to chose how "large" one hour has to be like in KOrganizer, and allows an easy export to a format that can be read with OpenOffice Calc?

Many thanks in advance,
//mc_le
 
Old 03-21-2007, 12:27 PM   #2
VincentB
Member
 
Registered: Jun 2003
Location: Brussels, Belgium
Distribution: Ubuntu 6.10
Posts: 139

Rep: Reputation: 15
Hi,

I know ... it has been a long time since you posted this question in this forum.
have you received an answer so far to your question?
I am interested in exporting mails (in an automated way) from Evolution to Open Office?

Thanks in advance for your answer,
Kind regards,

Vincent

Quote:
Originally Posted by mcle
Hi there,

I've testet several "Outlook replacement" software - Mozilla with Calendar, KOrganizer and Evolution.
Evolution seems to be the best for my needs, but I can't find any way to export tasks and calendar information and such from Evolution. I want to create a summary in Openoffice calc about a day of the calendar. I can't simply copy&paste, there's no export from Evolution at all and Openoffice seems to only import Evolution Adress books :-(
Is there something I can do about this or is this just bad luck for me?
On the other hand, if you can point me to a "PIM software" running on linux as "Outlook replacement" that can at be configured to display the time scale of a day 5-minutes-way like Evolution (and not 15 minutes as in KOrganizer) or can display this as in Mozilla Calendar in a free scale, but with a possibility to chose how "large" one hour has to be like in KOrganizer, and allows an easy export to a format that can be read with OpenOffice Calc?

Many thanks in advance,
//mc_le
 
Old 08-21-2011, 07:26 PM   #3
Justin Perreault
LQ Newbie
 
Registered: Aug 2011
Posts: 1

Rep: Reputation: 0
Cool Solution linux Evolution Calendar to OpenOffice Calc

This is just the start as I am sure someone can figure out the command line way when you do please post it.

I was searching for a solution so I am guessing it is still relevant as this discussion was one of the top hits. So basically get Evolution to produce a view of calendar information in a table format so the information can be manipulated in a spreadsheet such as Calc. I did this with Evolution 2.32.2, do not know if older versions can do it or if newer versions need it.

Step 1 create a custom view in Evolution. When in Calendar Select:

View -> Current View -> Define Views -> New

Give it a name and select table -> OK -> OK -> Close

This will produce a table view of your calendar.

Step 2 Select the data you want. While in the month you want Select:

View -> Current View -> name of table view used in Step 1

From here you modify the column headings by right clicking on them and selecting either:

Remove this Column or Add a Column

I suggest Start Date, End Date, Summary, Description.

Step 3 Print to PDF

At this stage print the data to pdf. The more tidy the pdf prints the easier the data will copy, try adjusting the column widths in Step 2 and consider using landscape view or larger "paper size" for the print setting

Step 4 Copy the data from the pdf

Open the pdf highlight all the data and CTRL-C to copy it.

Step 5 Paste into Calc

Open Calc and select a cell the do CTRL-V to paste the data.

At this point a dialogue will pop up asking how you want the data interpreted. I used fixed width and put markers to divide the data in to date/time/date/time/summary columns

Now I that the data is in Calc I can manipulate however I want and most importantly control the print out for easy reading of all those micro appointments.

Let me know how you get on using this.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
OpenOffice SWF export font issues julioody Linux - Software 1 03-18-2005 01:32 PM
OpenOffice Calc export chart to image file? cast55 Linux - Software 2 03-15-2005 11:51 AM
Looking For Export Program, Outlook to Evolution MatthewASmith79 Linux - Newbie 3 02-21-2004 09:32 PM
ximian evolution - export contacts andrewlkho Linux - Software 1 08-18-2003 01:15 AM
Evolution export? hotrodowner Linux - Software 5 01-01-2003 08:57 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:32 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration