Received: from mail-vx0-f189.google.com ([209.85.220.189]:39452) by stodi.digitalkingdom.org with esmtps (TLSv1:RC4-SHA:128) (Exim 4.76) (envelope-from ) id 1S5K5M-0006Va-02; Wed, 07 Mar 2012 08:51:38 -0800 Received: by vcbfo11 with SMTP id fo11sf1420307vcb.16 for ; Wed, 07 Mar 2012 08:51:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=beta; h=x-beenthere:date:from:to:message-id:in-reply-to:references:subject :mime-version: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=++9ki+8knUkdO41C9IAP/swqddUmzbzwKFULKRECb0w=; b=Yhm6vLr0NdmS3LXQMJmJnA1xBZmdTR5Mzv6MJQqUJ1nVrzVE8SnzOMBSIwKk237fYB gCNyUq9yQdc4Xe+zhbLpTS7JO6RcP4v0N2QFover0vVc+3VlLfZlD2XFBCXMQkCAoDji 3SMy3GzVocFY3zDn2rrYiI74I2s9ualbXAbKc= Received: by 10.52.94.100 with SMTP id db4mr524971vdb.10.1331139081819; Wed, 07 Mar 2012 08:51:21 -0800 (PST) X-BeenThere: lojban@googlegroups.com Received: by 10.52.88.105 with SMTP id bf9ls2391068vdb.8.gmail; Wed, 07 Mar 2012 08:51:21 -0800 (PST) Received: by 10.236.153.3 with SMTP id e3mr41460yhk.9.1331139081116; Wed, 07 Mar 2012 08:51:21 -0800 (PST) Date: Wed, 7 Mar 2012 08:51:20 -0800 (PST) From: gleki To: lojban@googlegroups.com Message-ID: <30777748.137.1331139080734.JavaMail.geo-discussion-forums@vbck9> In-Reply-To: <28202283.2472.1331138872964.JavaMail.geo-discussion-forums@vbw15> References: <29741151.5374.1331043579316.JavaMail.geo-discussion-forums@vbkc1> <8f2d80fb-7cda-4645-854d-4f119e0d5726@l14g2000vbe.googlegroups.com> <20567224.17.1331117056640.JavaMail.geo-discussion-forums@ynic10> <85d85f4f-d5f5-4fe2-a278-c278b63bffe1@m2g2000vbc.googlegroups.com> <28202283.2472.1331138872964.JavaMail.geo-discussion-forums@vbw15> Subject: [lojban] Re: How to export tatoeba in simple format MIME-Version: 1.0 X-Original-Sender: gleki.is.my.name@gmail.com X-Original-Authentication-Results: ls.google.com; spf=pass (google.com: domain of gleki.is.my.name@gmail.com designates internal as permitted sender) smtp.mail=gleki.is.my.name@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: X-Google-Group-Id: 1004133512417 List-Post: , List-Help: , List-Archive: Sender: lojban@googlegroups.com List-Subscribe: , List-Unsubscribe: , Content-Type: multipart/alternative; boundary="----=_Part_136_23218615.1331139080731" X-Spam-Score: -0.7 (/) X-Spam_score: -0.7 X-Spam_score_int: -6 X-Spam_bar: / ------=_Part_136_23218615.1331139080731 Content-Type: text/plain; charset=ISO-8859-1 And if the script is not yet ready for publishing please compile a jbo-rus.csv file. Our Russian lojbanists will highly estimate it. Your name will be next to the spreadsheet for sure. mu'o On Wednesday, March 7, 2012 8:47:52 PM UTC+4, gleki wrote: > > > On Wednesday, March 7, 2012 6:51:44 PM UTC+4, ianek wrote: >> >> What platform? Is Linux ok? >> > > For me ? Well, yes. As for other interested in lojban we > can periodically do snapshots of the database ourselves. > >> >> On 7 Mar, 11:44, gleki wrote: >> > I'm interested. And actually in periodically doing it myself. Not 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 lojban >> > 2 column english >> > then i need >> > japanese >> > chinese >> > russian >> > arabic >> > spanish >> > polish >> > french >> > german >> > >> > I'll repeat once again. An automated script for doing so would be >> awesome. >> > >> > >> > >> > >> > >> > >> > >> > 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 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 >> 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 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 ? > > > On Wednesday, March 7, 2012 6:51:44 PM UTC+4, ianek wrote: >> >> What platform? Is Linux ok? >> >> On 7 Mar, 11:44, gleki wrote: >> > I'm interested. And actually in periodically doing it myself. Not 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 lojban >> > 2 column english >> > then i need >> > japanese >> > chinese >> > russian >> > arabic >> > spanish >> > polish >> > french >> > german >> > >> > I'll repeat once again. An automated script for doing so would be >> awesome. >> > >> > >> > >> > >> > >> > >> > >> > 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 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 >> 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 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 view this discussion on the web visit https://groups.google.com/d/msg/lojban/-/yxJbbW3xbjQJ. 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. ------=_Part_136_23218615.1331139080731 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable And if the script is not yet ready for publishing
please compile a jbo-= rus.csv file.
Our Russian lojbanists will highly estimate it.
Your name will be next to the spreadsheet for sure.

mu'o

On Wednesday, March 7, 2012 8:47:52 PM UTC+4, gleki wr= ote:

On Wednesday, March 7,= 2012 6:51:44 PM UTC+4, ianek wrote:
What platform? Is Linux ok?

For me ? Well, yes. As for other inter= ested in lojban we can periodically do snapshots of the database = ourselves.

On 7 Mar, 11:44, gleki <gleki.is.my.n...@gmail.com> wrote:
> I'm interested. And actually in periodically doing it myself. &nbs= p;Not 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    lojban
> 2 column   english
> then i need
> japanese
> chinese
> russian
> arabic
> spanish
> polish
> french
> german
>
> I'll repeat once again. An automated script for doing so  wou= ld be awesome.
>
>
>
>
>
>
>
> 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 bas= h. 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 co= urse. 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 oth= er
> > language available in tatoeba instantly, if anyone's interest= ed.
>
> > 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 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 spread= sheet with two
> > columns.
> > > > One for English and another one for Lojban
>
> > > > Does anyone know how to do that ?

O= n Wednesday, March 7, 2012 6:51:44 PM UTC+4, ianek wrote:
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. &nbs= p;Not 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    lojban
> 2 column   english
> then i need
> japanese
> chinese
> russian
> arabic
> spanish
> polish
> french
> german
>
> I'll repeat once again. An automated script for doing so  wou= ld be awesome.
>
>
>
>
>
>
>
> 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 bas= h. 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 co= urse. 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 oth= er
> > language available in tatoeba instantly, if anyone's interest= ed.
>
> > 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 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 spread= sheet 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 view this discussion on the web visit https://groups.google.com/d/msg/lojban/-/yx= JbbW3xbjQJ.
=20 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.
------=_Part_136_23218615.1331139080731--