From: Dirk-Jan C. Binnema <djcb.bulk@gmail.com>
To: David Ellis <ddellis914@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: using org-mode with MS Outlook
Date: Fri, 04 Mar 2011 08:10:55 +0200 [thread overview]
Message-ID: <20110304061055.E7AE939C612@djcbsoftware.nl> (raw)
In-Reply-To: <AANLkTikSDQTxrQP8kxteQFMO09eTiLw01teO=DN25u1-@mail.gmail.com>
[-- Attachment #1: Type: text/plain, Size: 851 bytes --]
Hi David,
>>>>> On Thu, 3 Mar 2011 14:31:48 -0600, David Ellis ("DE") wrote:
DE> I would like to move my calendar and task data from MS Outlook into
DE> org files. I would like to know if anyone has done this and what is
DE> the best way to do this. I know that MS Outlook can export to an
DE> icalendar file. So, if there is an easy way to import that into and
DE> org file, that will solve the calendar issue.
I took a slightly different approach; when I get meeting-invitations etc.,
Exchange usually sends a message; so what I did was to write some code to
parse these message and add the item to my org-calendar.
The approach is a bit fragile, and there are quite a few cases which are not
handled very well; still it may be useful; so find attached
org-exchange-capture.el; ideas for improvements are welcome.
Best wishes,
Dirk.
[-- Attachment #2: org-exchange-capture.el --]
[-- Type: text/plain, Size: 3562 bytes --]
;; org-exchange-capture.el, v0.0.1
;; written by: Dirk-Jan C. Binnema <djcb@djcbsoftware.nl>
;; License: GPLv3+
(require 'org-capture)
;; turn the e-mails sent MS-Exchange about invitation/appointments into org-TODOs
;; using 'org-capture'.
;; The idea is that you select (mark) the parts of the email you want to add to
;; your org-todo item, and then invoke M-x org-exchange-capture-invitation
;; Some caveats:
;; - obviously, this is just a one-way copy, it won't make you 'accept' an
;; invitation, nor does it get any updates
;; - it seems to work with the emails I get from Exchange (I've encountered two
;; different kinds). But there may be more; at least the ones I get that are
;; in English, there are other versions as well. I'd be interested in
;; extending the regexps with more cases.
;;
;; - it does not take time-zones into account (yet)
;;
;; NOTE:
;; It does NOT handle yet:
;; When: 12.08.2010 12:00-14:00 (GMT+02:00) Helsinki, ...
;; When: \\([0-9]\\{2\\}\.[0-9]\\{2\\}\.[0-9]\\{4\\}\\)
;; When: 20. syyskuuta 2010 12:00-12:45 (GMT+02:00) Helsinki, ....
;; When: Occurs every Thursday effective 19.08.2010 from 14:00 to 15:30
;; (GMT+02:00) Helsinki, ...
;; - it requires org-capture, which is fairly new; it should be easy to support
;; org-remember as well though. Also, I only tested with Wanderlust as e-mail
;; client; it *should* work with others as well though...
;; Note that that the message buffer must be the active buffer;
;; ie. it won't work in the 'Summary' (Wanderlust)
(defun djcb-exchange-invite-time-to-org-date()
"try to to find the Time/Date from an Exchange-invitation
e-mail in the current buffer, and convert it into an org-mode
date, or `nil' if it's not found."
"get the time/date of an Outlook invite in org-mode notation"
(let ((date) (time-begin) (time-end))
(save-excursion
(save-match-data
(beginning-of-buffer)
(if (re-search-forward
(concat "^When: \\([0-9]+ [a-z]+,? [0-9]\\{4\\}\\) "
"\\([0-9]+:[0-9]+\\)-\\([0-9]+:[0-9]+\\)") nil t 1)
(progn
(setq
date (parse-time-string (match-string-no-properties 1))
time-begin (match-string-no-properties 2)
time-end (match-string-no-properties 3))
(format "<%d-%02d-%02d %s--%s>"
(elt date 5) (elt date 4) (elt date 3)
time-begin time-end))
(message "No match")
nil)))))
(defun djcb-exchange-invite-subject()
"get the subject of an MS-Exchange invite e-mail in the current
buffer"
(save-excursion
(save-match-data
(beginning-of-buffer)
(when (re-search-forward "^Subject: \\(.*\\)" nil t 1)
(match-string-no-properties 1)))))
(defun org-exchange-capture-invitation ()
"capture the MS-Exchange invite e-mail in buffer into an
org-mode agenda item using the org-capture system. For this to
work, you'll need to add to your `org-capture-templates' an item
with a shortcut key of 'E', e.g.
(\"E\" \"ExchangeInvite\" entry
(file+headline \"todo.org\" \"Meetings\")
\"* TODO %c\\n\")
any text you select (mark) in the buffer will be added to to
captured TODO; thus you can add the relevant details to the org TODO item.
"
(interactive)
(let( (time (djcb-exchange-invite-time-to-org-date))
(title (djcb-exchange-invite-subject))
(txt
(if (use-region-p) (buffer-substring-no-properties (region-beginning)
(region-end)) "")))
(when time
(kill-new (concat title " " time "\n\t" txt)) ;; hack: prepend to kill ring
(org-capture nil "E"))))
(provide 'org-exchange-capture)
[-- Attachment #3: Type: text/plain, Size: 172 bytes --]
--
Dirk-Jan C. Binnema Helsinki, Finland
e:djcb@djcbsoftware.nl w:www.djcbsoftware.nl
pgp: D09C E664 897D 7D39 5047 A178 E96A C7A1 017D DA3C
next prev parent reply other threads:[~2011-03-04 6:11 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-03-03 20:31 using org-mode with MS Outlook David Ellis
2011-03-03 21:42 ` Rehan Iftikhar
2011-03-03 22:02 ` Nick Dokos
2011-03-03 22:25 ` David Ellis
2011-03-03 23:04 ` Nick Dokos
2011-03-06 20:12 ` Eric S Fraga
2011-03-04 6:10 ` Dirk-Jan C. Binnema [this message]
2011-03-04 19:23 ` Bastien
-- strict thread matches above, loose matches on Subject: below --
2011-03-03 23:23 Michael Markert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20110304061055.E7AE939C612@djcbsoftware.nl \
--to=djcb.bulk@gmail.com \
--cc=ddellis914@gmail.com \
--cc=djcb@djcbsoftware.nl \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).