Received: from mail-yw0-f61.google.com ([209.85.213.61]:41456)
	by stodi.digitalkingdom.org with esmtps (TLSv1:RC4-SHA:128)
	(Exim 4.76)
	(envelope-from <lojban+bncCMLaiI6rCBD2p9r6BBoE0iim-g@googlegroups.com>)
	id 1S53AG-0004bL-TD; Tue, 06 Mar 2012 14:47:38 -0800
Received: by yhkk25 with SMTP id k25sf6044380yhk.16
        for <multiple recipients>; Tue, 06 Mar 2012 14:47:22 -0800 (PST)
Received-SPF: pass (google.com: domain of lojban+bncCMLaiI6rCBD2p9r6BBoE0iim-g@googlegroups.com designates 10.52.71.232 as permitted sender) client-ip=10.52.71.232;
Authentication-Results: mr.google.com; spf=pass (google.com: domain of lojban+bncCMLaiI6rCBD2p9r6BBoE0iim-g@googlegroups.com designates 10.52.71.232 as permitted sender) smtp.mail=lojban+bncCMLaiI6rCBD2p9r6BBoE0iim-g@googlegroups.com; dkim=pass header.i=lojban+bncCMLaiI6rCBD2p9r6BBoE0iim-g@googlegroups.com
Received: from mr.google.com ([10.52.71.232])
        by 10.52.71.232 with SMTP id y8mr1770933vdu.18.1331074042297 (num_hops = 1);
        Tue, 06 Mar 2012 14:47:22 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=googlegroups.com; s=beta;
        h=x-beenthere:mime-version:date:in-reply-to:references:user-agent
         :x-http-useragent:message-id:subject:from:to:x-original-sender
         :x-original-authentication-results:reply-to:precedence:mailing-list
         :list-id:x-google-group-id:list-post:list-help:list-archive:sender
         :list-subscribe:list-unsubscribe:content-type;
        bh=X7xSvyKjFPZqA9x0OfByfn6ofsMX4M6iP9n63BKzbnY=;
        b=nPM3zpSoUBclloAqNigyAMOSsBJZzK1UMMsJsEy+mA0WfKzw2lHGaJOQbZbHRUrZeB
         8QDCSr0Eauw/PxNaeJE7sKxlsodV9L+5cSMLacfioFQ6hZ4CHzhX1BURwGZRt8tqoBnh
         MiotvcC0LNUrK1urJI9qHbSDwd5KtKpTyWBo0=
Received: by 10.52.71.232 with SMTP id y8mr549770vdu.18.1331074038521;
        Tue, 06 Mar 2012 14:47:18 -0800 (PST)
X-BeenThere: lojban@googlegroups.com
Received: by 10.220.209.196 with SMTP id gh4ls1443275vcb.1.gmail; Tue, 06 Mar
 2012 14:47:17 -0800 (PST)
MIME-Version: 1.0
Received: by 10.52.24.244 with SMTP id x20mr4648472vdf.11.1331074037048; Tue,
 06 Mar 2012 14:47:17 -0800 (PST)
Received: by l14g2000vbe.googlegroups.com with HTTP; Tue, 6 Mar 2012 14:47:17
 -0800 (PST)
Date: Tue, 6 Mar 2012 14:47:17 -0800 (PST)
In-Reply-To: <d9078ebe-3488-4fe0-adbd-d9f60abea5a7@q11g2000vbu.googlegroups.com>
References: <29741151.5374.1331043579316.JavaMail.geo-discussion-forums@vbkc1> <d9078ebe-3488-4fe0-adbd-d9f60abea5a7@q11g2000vbu.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.11 (KHTML,
 like Gecko) Chrome/17.0.963.65 Safari/535.11,gzip(gfe)
Message-ID: <8f2d80fb-7cda-4645-854d-4f119e0d5726@l14g2000vbe.googlegroups.com>
Subject: [lojban] Re: How to export tatoeba in simple format
From: ianek <janek37@gmail.com>
To: lojban <lojban@googlegroups.com>
X-Original-Sender: janek37@gmail.com
X-Original-Authentication-Results: ls.google.com; spf=pass (google.com: domain
 of janek37@gmail.com designates internal as permitted sender)
 smtp.mail=janek37@gmail.com; dkim=pass header.i=@gmail.com
Reply-To: lojban@googlegroups.com
Precedence: list
Mailing-list: list lojban@googlegroups.com; contact lojban+owners@googlegroups.com
List-ID: <lojban.googlegroups.com>
X-Google-Group-Id: 1004133512417
List-Post: <http://groups.google.com/group/lojban/post?hl=en_US>, <mailto:lojban@googlegroups.com>
List-Help: <http://groups.google.com/support/?hl=en_US>, <mailto:lojban+help@googlegroups.com>
List-Archive: <http://groups.google.com/group/lojban?hl=en_US>
Sender: lojban@googlegroups.com
List-Subscribe: <http://groups.google.com/group/lojban/subscribe?hl=en_US>, <mailto:lojban+subscribe@googlegroups.com>
List-Unsubscribe: <http://groups.google.com/group/lojban/subscribe?hl=en_US>, <mailto:googlegroups-manage+1004133512417+unsubscribe@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
X-Spam-Score: 0.0 (/)
X-Spam_score: 0.0
X-Spam_score_int: 0
X-Spam_bar: /

I've created the list for you, but it was an ugly hack in bash. A
better way would be to create a database and import sentences.csv and
links.csv to it, and then write a very simple program instead of
hacking around with grep etc. But it would be more work of course. And
maybe not faster, considering that import would take time.

Here you go: http://dl.dropbox.com/u/17805197/jbo-eng.csv
It's tab-seperated list, any spreadsheet program should read it.

As a by-product, I am able to produce such a list for any other
language available in tatoeba instantly, if anyone's interested.

mu'o mi'e ianek

On 6 Mar, 22:17, ianek <jane...@gmail.com> wrote:
> http://tatoeba.org/pol/download_tatoeba_example_sentenceshttp://tatoeba.org/files/downloads/sentences.csv
>
> There are actually three columns: id, language, sentence, but with
> some database-fu or script-fu or maybe even spreadsheet-fu you can get
> what you want. Or maybe I'll hack it together in a while.
>
> mu'o mi'e ianek
>
> On 6 Mar, 15:19, gleki <gleki.is.my.n...@gmail.com> wrote:
>
>
>
>
>
>
>
> > I wanna export tatoeba databse into a simple spreadsheet with two columns.
> > One for English and another one for Lojban
>
> > Does anyone know how to do that ?

-- 
You received this message because you are subscribed to the Google Groups "lojban" group.
To post to this group, send email to lojban@googlegroups.com.
To unsubscribe from this group, send email to lojban+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/lojban?hl=en.