Received: from mail-gy0-f189.google.com ([209.85.160.189]:41118)
	by stodi.digitalkingdom.org with esmtps (TLSv1:RC4-SHA:128)
	(Exim 4.76)
	(envelope-from <lojban+bncCMLaiI6rCBCJ7N36BBoEyT8L2w@googlegroups.com>)
	id 1S5IDl-0005TK-Bw; Wed, 07 Mar 2012 06:52:18 -0800
Received: by ghbf14 with SMTP id f14sf6810908ghb.16
        for <multiple recipients>; Wed, 07 Mar 2012 06:51:57 -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
         :content-transfer-encoding;
        bh=3wlT4cfN0YMUjmIuxs3e+srP/BfHNHQEgqlAhT/ao10=;
        b=giqA1QeL/w+xo3QldKeXj87VWhsspLVffbt9XKbAdNGh0jyjKOrVkb03ZWAiwUC5TF
         JCOpyWt8EK4C3nhx7hpdo2XO6c31DxXZqxtDfQWVkfC7qAAa4VJa1doGw0r+At/evJL0
         nzLcG+GWqUva94Sf3m5X65l6EWJQ6SeatB2eE=
Received: by 10.224.219.140 with SMTP id hu12mr425300qab.16.1331131913727;
        Wed, 07 Mar 2012 06:51:53 -0800 (PST)
X-BeenThere: lojban@googlegroups.com
Received: by 10.229.241.210 with SMTP id lf18ls2262677qcb.6.gmail; Wed, 07 Mar
 2012 06:51:45 -0800 (PST)
MIME-Version: 1.0
Received: by 10.52.23.80 with SMTP id k16mr366677vdf.7.1331131905299; Wed, 07
 Mar 2012 06:51:45 -0800 (PST)
Received: by m2g2000vbc.googlegroups.com with HTTP; Wed, 7 Mar 2012 06:51:44
 -0800 (PST)
Date: Wed, 7 Mar 2012 06:51:44 -0800 (PST)
In-Reply-To: <20567224.17.1331117056640.JavaMail.geo-discussion-forums@ynic10>
References: <29741151.5374.1331043579316.JavaMail.geo-discussion-forums@vbkc1>
 <d9078ebe-3488-4fe0-adbd-d9f60abea5a7@q11g2000vbu.googlegroups.com>
 <8f2d80fb-7cda-4645-854d-4f119e0d5726@l14g2000vbe.googlegroups.com> <20567224.17.1331117056640.JavaMail.geo-discussion-forums@ynic10>
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: <85d85f4f-d5f5-4fe2-a278-c278b63bffe1@m2g2000vbc.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
Content-Transfer-Encoding: quoted-printable
X-Spam-Score: 0.0 (/)
X-Spam_score: 0.0
X-Spam_score_int: 0
X-Spam_bar: /

What platform? Is Linux ok?

On 7 Mar, 11:44, gleki <gleki.is.my.n...@gmail.com> wrote:
> I'm interested. And actually in periodically doing it myself. =A0Not by
> request.
> Because the database is live and is being updated by us.
>
> Of course I know about those three files.
>
> For now, I'd prefer such export for several directions at one (a
> multilingual spreadsheet).
> I want all sentences for which we have lojban translations.
> i.e.
> first column =A0 =A0lojban
> 2 column =A0 english
> then i need
> japanese
> chinese
> russian
> arabic
> spanish
> polish
> french
> german
>
> I'll repeat once again. An automated script for doing so =A0would be awes=
ome.
>
>
>
>
>
>
>
> On Wednesday, March 7, 2012 2:47:17 AM UTC+4, ianek wrote:
>
> > 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://tatoe...
>
> > > There are actually three columns: id, language, sentence, but with
> > > some database-fu or script-fu or maybe even spreadsheet-fu you can ge=
t
> > > 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 ?

--=20
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@googlegrou=
ps.com.
For more options, visit this group at http://groups.google.com/group/lojban=
?hl=3Den.