Export the org spreadsheet into a tab seperated text file

Export the org spreadsheet into a tab seperated text file

[Csányi Pál]

Hello!

Is there available from Org-mode to export a table to a Tab separated 
text file? 

-- 
Regards, Paul Csanyi
http://www.freewebs.com/csanyi-pal/index.htm

Re: Export the org spreadsheet into a tab seperated text file

[Bernt Hansen]

csanyipal@gmail.com (Csányi Pál) writes:

> Hello!
>
> Is there available from Org-mode to export a table to a Tab separated 
> text file? 

Hi!

Yes it's easy.  Put the pointer on the table and M-x org-table-export
Export table to: /tmp/some-table.txt
Format: orgtbl-to-tsv

HTH,
Bernt

RE: Re: Export the org spreadsheet into a tab seperated textfile

[Parker, Matthew]

Sorry, 

But, can you describe exactly what you mean by "Put the pointer on the table"

I tried putting point in various places (indicated w/ "[p]" below) and ran M-x org-table-export. But got messages: "No Table at point" or "before first heading"

Thanks!

[p]
| *one* | *two*| *three*|
| asdf | asdf | asdf |
|    1 |    1 |    1 |


[p] | *one* | *two*| *three*|
| asdf | asdf | asdf |
|    1 |    1 |    1 |

|[p] *one* | *two*| *three*|
| asdf | asdf | asdf |
|    1 |    1 |    1 |



| asdf | asdf | asdf |
|    1 |    1 |    1 |
[p]

-----Original Message-----
From: emacs-orgmode-bounces+mparker=seic.com@gnu.org [mailto:emacs-orgmode-bounces+mparker=seic.com@gnu.org] On Behalf Of Bernt Hansen
Sent: Friday, July 11, 2008 3:39 PM
To: Csányi Pál
Cc: emacs-orgmode@gnu.org
Subject: [Orgmode] Re: Export the org spreadsheet into a tab seperated textfile

csanyipal@gmail.com (Csányi Pál) writes:

> Hello!
>
> Is there available from Org-mode to export a table to a Tab separated 
> text file? 

Hi!

Yes it's easy.  Put the pointer on the table and M-x org-table-export
Export table to: /tmp/some-table.txt
Format: orgtbl-to-tsv

HTH,
Bernt


_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: Re: Export the org spreadsheet into a tab seperated textfile

[Bernt Hansen]

"Parker, Matthew" <MParker@seic.com> writes:

> But, can you describe exactly what you mean by "Put the pointer on the table"
>
> I tried putting point in various places (indicated w/ "[p]" below) and ran M-x org-table-export. But got messages: "No Table at point" or "before first heading"
>
> Thanks!
>
> [p]
> | *one* | *two*| *three*|
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
>
>
> [p] | *one* | *two*| *three*|
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
>
> |[p] *one* | *two*| *three*|
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
>
>
>
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
> [p]

The middle two above should work fine as long as you have a heading
before it.  Just insert a line

* Test

in front of the table.

Put the point on the table is just put the cursor anywhere inside the
table.

-Bernt

RE: Re: Export the org spreadsheet into a tab seperated textfile

[Parker, Matthew]

Worked. Thanks.

-----Original Message-----
From: Bernt Hansen [mailto:bernt@norang.ca] 
Sent: Friday, July 11, 2008 5:12 PM
To: Parker, Matthew
Cc: Csányi Pál; emacs-orgmode@gnu.org
Subject: Re: [Orgmode] Re: Export the org spreadsheet into a tab seperated textfile

"Parker, Matthew" <MParker@seic.com> writes:

> But, can you describe exactly what you mean by "Put the pointer on the table"
>
> I tried putting point in various places (indicated w/ "[p]" below) and ran M-x org-table-export. But got messages: "No Table at point" or "before first heading"
>
> Thanks!
>
> [p]
> | *one* | *two*| *three*|
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
>
>
> [p] | *one* | *two*| *three*|
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
>
> |[p] *one* | *two*| *three*|
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
>
>
>
> | asdf | asdf | asdf |
> |    1 |    1 |    1 |
> [p]

The middle two above should work fine as long as you have a heading
before it.  Just insert a line

* Test

in front of the table.

Put the point on the table is just put the cursor anywhere inside the
table.

-Bernt

Re: Export the org spreadsheet into a tab seperated text file

[Csányi Pál]

Bernt Hansen <bernt@norang.ca> writes:

> csanyipal@gmail.com (Csányi Pál) writes:

>> Is there available from Org-mode to export a table to a Tab separated 
>> text file? 

> Yes it's easy.  Put the pointer on the table and M-x org-table-export
> Export table to: /tmp/some-table.txt
> Format: orgtbl-to-tsv

OK it works but only for one org table at a time.

But what to do if I have an org file with more than one table with
different columns x rows and between these tables moreover I have some
text, like the follows:

[options]

Here is an org tabe.

[pins]

Here is an org tabe.

etc.

Can I export in org mode the whole file with these tables end texts
mixed this way in to one Tab separated text file? (Tab separated only
where was an org table so in this example abowe in tab separated text
file there should to get two places with tab separated rows that
contain datas taken from the tables.)?

-- 
Regards, Paul Csanyi
http://www.freewebs.com/csanyi-pal/index.htm

Re: Re: Export the org spreadsheet into a tab seperated text file

[Carsten Dominik]

On Jul 12, 2008, at 1:41 AM, Csányi Pál wrote:

> Bernt Hansen <bernt@norang.ca> writes:
>
>> csanyipal@gmail.com (Csányi Pál) writes:
>
>>> Is there available from Org-mode to export a table to a Tab  
>>> separated
>>> text file?
>
>> Yes it's easy.  Put the pointer on the table and M-x org-table-export
>> Export table to: /tmp/some-table.txt
>> Format: orgtbl-to-tsv
>
> OK it works but only for one org table at a time.
>
> But what to do if I have an org file with more than one table with
> different columns x rows and between these tables moreover I have some
> text, like the follows:
>
> [options]
>
> Here is an org tabe.
>
> [pins]
>
> Here is an org tabe.
>
> etc.
>
> Can I export in org mode the whole file with these tables end texts
> mixed this way in to one Tab separated text file? (Tab separated only
> where was an org table so in this example abowe in tab separated text
> file there should to get two places with tab separated rows that
> contain datas taken from the tables.)?


No, you cannot.  What would be the application for this?

- Carsten

Re: Re: Export the org spreadsheet into a tab seperated textfile

[Carsten Dominik]

On Jul 11, 2008, at 2:12 PM, Bernt Hansen wrote:

> "Parker, Matthew" <MParker@seic.com> writes:
>
>> But, can you describe exactly what you mean by "Put the pointer on  
>> the table"
>>
>> I tried putting point in various places (indicated w/ "[p]" below)  
>> and ran M-x org-table-export. But got messages: "No Table at point"  
>> or "before first heading"
>>
>> Thanks!
>>
>> [p]
>> | *one* | *two*| *three*|
>> | asdf | asdf | asdf |
>> |    1 |    1 |    1 |
>>
>>
>> [p] | *one* | *two*| *three*|
>> | asdf | asdf | asdf |
>> |    1 |    1 |    1 |
>>
>> |[p] *one* | *two*| *three*|
>> | asdf | asdf | asdf |
>> |    1 |    1 |    1 |
>>
>>
>>
>> | asdf | asdf | asdf |
>> |    1 |    1 |    1 |
>> [p]
>
> The middle two above should work fine as long as you have a heading
> before it.  Just insert a line
>
> * Test
>
> in front of the table.

Oops, this should not be required.  Fixed now.  Also, your post
reminded me that there should be completion for the translator
functions, this works now as well.

Thanks.

- Carsten

Re: Export the org spreadsheet into a tab seperated text file

[Csányi Pál]

[-- Attachment #1: Type: text/plain, Size: 2412 bytes --]

Carsten Dominik <dominik@uva.nl> writes:

> On Jul 12, 2008, at 1:41 AM, Csányi Pál wrote:
>
>> Bernt Hansen <bernt@norang.ca> writes:
>>
>>> csanyipal@gmail.com (Csányi Pál) writes:
>>
>>>> Is there available from Org-mode to export a table to a Tab
>>>> separated
>>>> text file?
>>
>>> Yes it's easy.  Put the pointer on the table and M-x org-table-export
>>> Export table to: /tmp/some-table.txt
>>> Format: orgtbl-to-tsv
>>
>> OK it works but only for one org table at a time.
>>
>> But what to do if I have an org file with more than one table with
>> different columns x rows and between these tables moreover I have some
>> text, like the follows:
>>
>> [options]
>>
>> Here is an org tabe.
>>
>> [pins]
>>
>> Here is an org tabe.
>>
>> etc.
>>
>> Can I export in org mode the whole file with these tables end texts
>> mixed this way in to one Tab separated text file? (Tab separated only
>> where was an org table so in this example abowe in tab separated text
>> file there should to get two places with tab separated rows that
>> contain datas taken from the tables.)?
>
>
> No, you cannot.  What would be the application for this?

If I would get the tab separated text file from org tables, then I
would be to run on it the tragesym python script. Tragesym can to make
from this tab separated text file an electric symbol for gEDA suite.

http://geda.seul.org/wiki/geda:tragesym_readme

However, I can now to send an org table within org file to tab
separated lines. I run orgtbl-send-table on every org-table in the org
file. 

After that I can to run on this org file tragesym, but get an error
message in some circumstances. If I edit one table in this org file so
that I put '#' character at start of every line then I get the
electric symbol file when run tragesym on the org file. If I leave the
file unedited then I get error message: 

Traceback (most recent call last):
  File "/usr/local/geda-0.0.2/bin/.scripts/tragesym.py", line 586, in <module>
    opts,attr,pins=readsrc(file_in)
  File "/usr/local/geda-0.0.2/bin/.scripts/tragesym.py", line 143, in readsrc
    geda_attr[(string.strip(element[0]),nr)]=string.strip(element[1])
IndexError: list index out of range

But this is maybe the issue for the geda news group: 

gmane.comp.cad.geda.user

The file with edited lines that don't cause this error because of '#'
characters at beginning of the lines is attached here..


[-- Attachment #2: The edited org file with '#' characters at one torg table --]
[-- Type: application/octet-stream, Size: 3852 bytes --]

# This is the template file for creating symbols with tragesym
# every line starting with '#' is a comment line.

[options]
# wordswap swaps labels if the pin is on the right side an looks like
# this: 
#   "PB1 (CLK)". That's useful for micro controller port labels

# rotate_labels rotates the pintext of top and bottom pins
#   this is useful for large symbols like FPGAs with more than 100 pins

# sort_labels will sort the pins by it's labels
#   useful for address ports, busses, ...

#+ORGTBL: SEND options orgtbl-to-generic :tstart "" :tend "" :lstart "" :lend "" :sep "\t"
| wordswap           | yes  |
| rotate_labels      | no   |
| sort_labels        | yes  |
| generate_pinseq    | yes  |
| sym_width          | 1400 |
| pinwidthvertical   | 400  |
| pinwidthhorizontal | 400  |

# BEGIN RECEIVE ORGTBL options #

wordswap	yes
rotate_labels	no
sort_labels	yes
generate_pinseq	yes
sym_width	1400
pinwidthvertical	400
pinwidthhorizontal	400

# END RECEIVE ORGTBL options #

[geda_attr]
# name will be printed in the top of the symbol

# if you have a device with slots, you'll have to use slot= and
# slotdef= 

# use comment= if there are special information you want to add

#+ORGTBL: SEND geda_attr orgtbl-to-generic :tstart "" :tend "" :lstart "" :lend "" :sep "\t"
#| version       | 20080127 1                                  |
#| name          | MCT6                                        |
#| device        | DUAL_PHTR_OPTCPLR                           |
#| refdes        | U?                                          |
#| footprint     | none                                        |
#| description   | dual phototransistor optocoupler            |
#| documentation | http://www.fairchildsemi.com/ds/MC/MCT6.pdf |
#| author        | Paul Csanyi                                 |
#| numslots      | 0                                           |
#| dist-license  | GPL                                         |
#| use-license   | unlimited                                   |

# BEGIN RECEIVE ORGTBL geda_attr #

version	20080127 1
name	MCT6
device	DUAL_PHTR_OPTCPLR
refdes	U?
footprint	none
description	dual phototransistor optocoupler
documentation	http://www.fairchildsemi.com/ds/MC/MCT6.pdf
author	Paul Csanyi
numslots	0
dist-license	GPL
use-license	unlimited

# END RECEIVE ORGTBL geda_attr #

[pins]
# tabseparated list of pin descriptions
# ----------------------------------------

# pinnr is the physical number of the pin

# seq is the pinseq= attribute, leave it blank if it doesn't matter 

# type can be (in, out, io, oc, oe, pas, tp, tri, clk, pwr) 

# style can be (line,dot,clk,dotclk,none). none if only want to add a 
# net 

# posit. can be (l,r,t,b) or empty for nets

# net specifies the name of the net. Vcc or GND for example.

# label represents the pinlabel.
#	negation lines can be added with "\_" example: \_enable\_  
#	if you want to write a "\" use "\\" as escape sequence 

#-----------------------------------------------------

#+ORGTBL: SEND pins orgtbl-to-generic :skip 1 :tstart "" :tend "" :lstart "" :lend "" :sep "\t"
| pinnr | seq | type | style | posit. | net | label     |
|     1 |   1 | pas  | line  | l      |     | ANODE     |
|     2 |   2 | pas  | line  | l      |     | CATHODE   |
|     3 |   3 | pas  | line  | l      |     | CATHODE   |
|     4 |   4 | pas  | line  | l      |     | ANODE     |
|     5 |   5 | pas  | line  | r      |     | EMITTER   |
|     6 |   6 | pas  | line  | r      |     | COLLECTOR |
|     7 |   7 | pas  | line  | r      |     | COLLECTOR |
|     8 |   8 | pas  | line  | r      |     | EMITTER   |

# BEGIN RECEIVE ORGTBL pins #

1	1	pas	line	l		ANODE
2	2	pas	line	l		CATHODE
3	3	pas	line	l		CATHODE
4	4	pas	line	l		ANODE
5	5	pas	line	r		EMITTER
6	6	pas	line	r		COLLECTOR
7	7	pas	line	r		COLLECTOR
8	8	pas	line	r		EMITTER

# END RECEIVE ORGTBL pins #

[-- Attachment #3: Type: text/plain, Size: 259 bytes --]


Without these '#' characters at the '[geda_attr]' org table I get the
error message: IndexError: list index out of range

This is maybe a tragesym bug..

Any advices will be appreciated!

-- 
Regards, Paul Csanyi
http://www.freewebs.com/csanyi-pal/index.htm

[-- Attachment #4: Type: text/plain, Size: 204 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode