that convert the po files to a lot of different formats, e.g. csv format that you can load into calc.
Definitely I will check. This will simplify a great lot of my effort. With Warm Regards V.Kadal Amutham 919444360480 914422396480 On 15 June 2013 17:24, Kadal Amutham <[email protected]> wrote: > > With Warm Regards > > V.Kadal Amutham > 919444360480 > 914422396480 > > > On 15 June 2013 17:19, janI <[email protected]> wrote: > >> On 15 June 2013 13:44, Kadal Amutham <[email protected]> wrote: >> >> > I understand Mr Jan I. I got stuck in getting Pootle installed in my >> Ubuntu >> > 11.10 desktop. I will resolve it soon and try to manipulate the data >> > available with me. >> > >> >> If your purpose is to check/print etc. the text, have a look at the >> gettext >> utility instead (see pootle homepage), there a set of utilities available >> on ubuntu (and other os), that convert the po files to a lot of different >> formats, e.g. csv format that you can load into calc. >> >> jsc and I do a lot of the maintenance using these utilities. >> >> rgds >> jan I. >> >> >> > >> > With Warm Regards >> > >> > V.Kadal Amutham >> > 919444360480 >> > 914422396480 >> > >> > >> > On 15 June 2013 17:06, janI <[email protected]> wrote: >> > >> > > On 15 June 2013 10:35, Kadal Amutham <[email protected]> wrote: >> > > >> > > > Jani, Could you able to access the database and the tables in >> pootle, >> > as >> > > > one could do it in MySQL? >> > > > >> > > >> > > I have access to the mysql db, but I cannot provide that for you (at >> > least >> > > at the moment), this is a shared server between all asf projects and >> in >> > > order to have mysql access you would need access to the server and be >> > able >> > > to do sudo. >> > > >> > > The database is controlled by pootle, and we are very carefull when >> using >> > > mysql directly, actually we only do backup, and I do db optimization. >> > > >> > > >> > > > I checked the size of Tamil pootle files it is 5.7 MB. Assume 10 MB. >> > > There >> > > > are not more than 40 languages currently in pootle. So the DB size >> > should >> > > > not be more than 400MB? How it shows 15GB? Actually it should be >> much >> > > less >> > > > than 400MB. The original English text data will not be repeated 40 >> > times, >> > > > to get 400MB. So where is the catch? >> > > > >> > > >> > > I am not sure why you expect the mysql tables to have anywhere the >> same >> > > size as the simple po files. the mysql tables contains all kind of key >> > > references, historical data, information about who did what. >> > > >> > > I dont think there is a catch, try to load the po files in simple >> tables >> > > and you will normally find that the tables are much larger than the >> > > original text files. >> > > >> > > I you want to learn more about how pootle structures data, then >> download >> > it >> > > and install it, having done that you can upload your files on your >> local >> > > version, and play with that. >> > > >> > > >> > > > There is one law. The name I forgot >> > > > >> > > > The work extends till the time available >> > > > The data expands to fill the hard disk space >> > > > >> > > >> > > Yeah, you are right, but dont forget the other law: >> > > The more you compress data, the slower a system you get. >> > > >> > > rgds >> > > jan I. >> > > >> > > > >> > > > With Warm Regards >> > > > >> > > > V.Kadal Amutham >> > > > 919444360480 >> > > > 914422396480 >> > > > >> > > > >> > > > On 15 June 2013 13:37, Kadal Amutham <[email protected]> wrote: >> > > > >> > > > > It is a good suggestion. I checked that pootle is open source, >> and I >> > > will >> > > > > install, I can download Tamil translation from AOO server and >> upload >> > it >> > > > to >> > > > > my pootle. Let us see whether I can do anything worthwhile >> > > > > >> > > > > With Warm Regards >> > > > > >> > > > > V.Kadal Amutham >> > > > > 919444360480 >> > > > > 914422396480 >> > > > > >> > > > > >> > > > > On 15 June 2013 12:47, janI <[email protected]> wrote: >> > > > > >> > > > >> On Jun 15, 2013 6:55 AM, "Kadal Amutham" <[email protected]> >> wrote: >> > > > >> > >> > > > >> > It is a great news that it is in MySQL. Can I have the copy of >> the >> > > > >> database >> > > > >> > / table to study further? >> > > > >> >> > > > >> may I suggest you start by installing pootle somewhere and get to >> > know >> > > > the >> > > > >> db structure first. Just dumping about 15gb data will not be vey >> > > > helpfull >> > > > >> to you. >> > > > >> >> > > > >> if you install pootle you can experiment on a small db, create >> the >> > > > script >> > > > >> you ant which we then can run on the server. >> > > > >> >> > > > >> rgds >> > > > >> jan i >> > > > >> >> > > > >> > >> > > > >> > With Warm Regards >> > > > >> > >> > > > >> > V.Kadal Amutham >> > > > >> > 919444360480 >> > > > >> > 914422396480 >> > > > >> > >> > > > >> > >> > > > >> > On 15 June 2013 03:59, janI <[email protected]> wrote: >> > > > >> > >> > > > >> > > On Jun 14, 2013 8:48 PM, "Kadal Amutham" <[email protected]> >> > > wrote: >> > > > >> > > > >> > > > >> > > > Pootle server may be sitting on a Database server like >> MySQL. >> > > > >> Probably >> > > > >> > > > there shall be single database, and each language shall >> have a >> > > > >> table. >> > > > >> If >> > > > >> > > I >> > > > >> > > > could get a copy of that table, then I can upload to any >> MySQL >> > > > >> server >> > > > >> and >> > > > >> > > > analyse further. I can take any print out as I like. >> > > > >> > > >> > > > >> > > pootle uses mysql, but each is not so that each language has >> a >> > > > simple >> > > > >> > > table. sentences/words/terms are split across several tables, >> > > which >> > > > >> also >> > > > >> > > contain deleted entries and to some extent revisions. >> > > > >> > > >> > > > >> > > rgds >> > > > >> > > jan i >> > > > >> > > >> > > > >> > > > >> > > > >> > > > Kindly let me know whether my assumption is correct. >> > > > >> > > > >> > > > >> > > > >> > > > >> > > > On 14 June 2013 16:56, Andrea Pescetti < >> [email protected]> >> > > > wrote: >> > > > >> > > > >> > > > >> > > > > Andre Fischer wrote: >> > > > >> > > > > >> > > > >> > > > >> >> > http://wiki.openoffice.org/**wiki/Mnemonics_Localisation#** >> > > > >> > > > >>>> How_the_mnemonics_are_assigned< >> > > > >> > > >> > > > >> > > >> > > > >> >> > > > >> >> > > > >> > > >> > >> http://wiki.openoffice.org/wiki/Mnemonics_Localisation#How_the_mnemonics_are_assigned >> > > > >> > > > >> > > > >> > > > >>>> >> > > > >> > > > >>> Is this "no accelerators" rule still active? Even in >> > > languages >> > > > >> where >> > > > >> > > > >> automatic selection of accelerators work, can that not >> > break >> > > > >> > > > >> documentation? I mean, can adding a new string lead to >> all >> > > > >> > > accelerators >> > > > >> > > > >> being redefined? >> > > > >> > > > >> >> > > > >> > > > > >> > > > >> > > > > As far as I know, documentation is not mentioning >> > accelerators >> > > > in >> > > > >> > > general, >> > > > >> > > > > but only shortcuts (CTRL-S and similar). >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > And there is point 3 in section 1.1 in the >> > > > Mnemonics_Localisation >> > > > >> page >> > > > >> > > > >> mentioned above: >> > > > >> > > > >> "The bugs are fixed manually in Web-LingTool by placing >> the >> > > '~' >> > > > >> > > > >> character to a different position" >> > > > >> > > > >> Removing all explicitly defined accelerators would >> remove >> > > such >> > > > >> bug >> > > > >> > > fixes. >> > > > >> > > > >> >> > > > >> > > > > >> > > > >> > > > > The guidelines in >> > > http://openoffice.apache.org/**translate.html >> > > > < >> > > > >> > > http://openoffice.apache.org/translate.html>item 3 only >> mention >> > > > >> "newly >> > > > >> > > translating strings": existing accelerators can >> > > > >> > > > > be left as they ae, they won't break anything (except, >> > > possibly, >> > > > >> making >> > > > >> > > > > more difficult some automated matches in translation >> > > > management). >> > > > >> > > > > >> > > > >> > > > > Regards, >> > > > >> > > > > Andrea. >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > >> > > > >> >> > > > >> > >> ------------------------------**------------------------------**--------- >> > > > >> > > > > To unsubscribe, e-mail: l10n-unsubscribe@openoffice.** >> > > > apache.org< >> > > > >> > > [email protected]> >> > > > >> > > > > For additional commands, e-mail: >> > [email protected]. >> > > > >> **org< >> > > > >> > > [email protected]> >> > > > >> > > > > >> > > > >> > > > > >> > > > >> > > >> > > > >> >> > > > > >> > > > > >> > > > >> > > >> > >> > >
