From mboxrd@z Thu Jan  1 00:00:00 1970
From: Simon Mullis <simon@mullis.co.uk>
Subject: Export full org-mode to CSV (not tables)
Date: Mon, 24 Aug 2009 14:29:33 +0200
Message-ID: <23d7e1bb0908240529s61574804i18cea3dd4630b500@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MfYgA-0002vN-50
	for emacs-orgmode@gnu.org; Mon, 24 Aug 2009 08:29:42 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MfYg5-0002qj-83
	for emacs-orgmode@gnu.org; Mon, 24 Aug 2009 08:29:41 -0400
Received: from [199.232.76.173] (port=48331 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MfYg5-0002qa-3X
	for emacs-orgmode@gnu.org; Mon, 24 Aug 2009 08:29:37 -0400
Received: from mail-fx0-f226.google.com ([209.85.220.226]:48435)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <simon.mullis@gmail.com>) id 1MfYg4-0005BB-9t
	for emacs-orgmode@gnu.org; Mon, 24 Aug 2009 08:29:36 -0400
Received: by fxm26 with SMTP id 26so1918268fxm.42
	for <emacs-orgmode@gnu.org>; Mon, 24 Aug 2009 05:29:33 -0700 (PDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hi All,

I now use org-mode for everthing I can.  Unfortunately, the rest of
the world is still stuck in Excel-land.

I have a long and detailed org file for each project arranged as follows:

* Priority 1:
**  Project: <name>
*** Number: <number>
*** Key1: <value1>
*** Key2: <value2>
*** Key3: <long multi-line text comment - value3>
* Priority 2:
**  Project: <name>
*** Number: <number>
*** Key1: <value1>
*** Key2: <value2>
*** Key3: <long multi-line text comment - value3>

and so on. There are multiple "Projects" per "Priority". There may be
multiple "Numbers" per "Project".

I'd like an easy way to export this data to an Excel table, or better yet, CSV.

So,

Priority,Project, Number, Key1, Key2, Key3
<priority>,<name>, <number>, <value1>, <value2>, <value3>,
<priority>,<name>, <number>, <value1>, <value2>, <value3>,

and so on....

Ideally I'd like to do this from within org-mode. (Alternatively I can
just write some quick python (or whatever) to do this for me.)

Any ideas?

Thanks

SM