Export full org-mode to CSV (not tables)

Export full org-mode to CSV (not tables)

[Simon Mullis]

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

Re: OrgmodeExport full org-mode to CSV (not tables)

[Wes Hardaker]

>>>>> On Mon, 24 Aug 2009 14:29:33 +0200, Simon Mullis <simon@mullis.co.uk> said:

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

org-export-generic can *almost* do this for you by carefully setting the
header open/close to simply be ", " for opening and a "\n" for closing
on header 2 (I think; haven't tested it).

But, it won't remove the text: prefix at the beginning of the fields.
It' be simple to pass the results through sed 's/, [^:]*:/,/g' though.
-- 
\ Wes Hardaker                           http://pontifications.hardakers.net /
 \_____ "In the bathtub of history the truth is harder to hold than ________/
       \_______ the soap, and much more difficult to find." _______/
               \_________ -- Terry Pratchett ______________/
                         \__________________/

Re: OrgmodeExport full org-mode to CSV (not tables)

[Simon Mullis]

Thanks Wes.  I'll try this...

Cheers

SM

2009/8/24 Wes Hardaker <wjhns209@hardakers.net>:
>>>>>> On Mon, 24 Aug 2009 14:29:33 +0200, Simon Mullis <simon@mullis.co.uk> said:
>
> SM> I'd like an easy way to export this data to an Excel table, or
> SM> better yet, CSV.
>
> org-export-generic can *almost* do this for you by carefully setting the
> header open/close to simply be ", " for opening and a "\n" for closing
> on header 2 (I think; haven't tested it).
>
> But, it won't remove the text: prefix at the beginning of the fields.
> It' be simple to pass the results through sed 's/, [^:]*:/,/g' though.
> --
> \ Wes Hardaker                           http://pontifications.hardakers.net /
>  \_____ "In the bathtub of history the truth is harder to hold than ________/
>       \_______ the soap, and much more difficult to find." _______/
>               \_________ -- Terry Pratchett ______________/
>                         \__________________/
>



-- 
Simon Mullis
_________________
simon@mullis.co.uk