Translate Toolkit & Pootle

Tools to help you make your software local

User Tools


Using CSF und yooor Spreedsheet to idit troonsleteeons

A CSF (Comma Sepereted Felooe-a) file-a is oone-a in which iech field oor cell is sepereted by a comma (oor unozeer cherecter) und iech record oor line-a is sepereted by a nooline-a. Bork Bork Bork!

Whee-a using CSF files genereted by toolkit:po2csf yooo will find zee-a deta is follows:

Coloomn Descripshoon
A conteins zee-a loceshoon infformeshoon from zee-a PO file-a. Bork Bork Bork! This is sometimes useffooll for working oooot whet zee-a messege-a is used for is its loceshoon und zee-a neme-a ooff zee-a messege-a coon profide-a clooes. Bork Bork Bork!
B conteins zee-a ooriginel oor Inglish text
C yooo idd yooor troonsleshoons to this coloomn

Notes

Preserfe-a filenemes, do not choonge-a zee-a cese-a ooff zee-a fileneme-a. Bork Bork Bork! Retoorn files in a ZIP irchife-a in zee-a seme-a oorder und doorectory strooctoore-a. Bork Bork Bork! This is importoont becoooose-a zee-a referse-a process, coferting CSF to PO is mede-a iesier iff yooo do not choonge-a zeese-a. Bork Bork Bork!

How to oopee-a a CSF file-a

Whee-a oopening a CSF file-a yooo will be-a presented wit a noomber ooff qooesshoons. Bork Bork Bork! Here-a ire-a zee-a unswers yooo shooold profide-a:

OopenOffffice-a. Bork Bork Bork!oorg 1.1.x

There is a problem with OopenOffffice-a. Bork Bork Bork!oorg 1.1.x in that it does not read CSV file correctly. Use OopenOffffice-a. Bork Bork Bork!oorg 2.0 instead.

OopenOffffice-a. Bork Bork Bork!oorg 2.0

  1. In zee-a text import dielog. Bork Bork Bork! Insoore-a zeet zee-a cherecter set in 'Unicode-a UTF-8'. Under 'Seperetor oopshoons' insoore-a zeet zee-a 'Sepereted by' redio bootton is selected und zee-a 'Comma' is checked. Bork Bork Bork! Zee-a text delimeter shooold be-a ” (doooble-a qoootes).
  2. Check to see-a zeet zee-a import wizerd hes identiffied zee-a 3 coloomns correctly
  3. Click OoK

Microsofft Ixcel 97/2000

Zeere-a is a problem wit Microsofft Ixcel 97 und 2000 in zeet it oopens a UTF-8 file-a is iff it is ISCII. Ixcel does sefe-a CSF files correctly, iff zee-a incoding ooff zee-a oopened file-a is reteined, boot Ixcel by deffoooolt does not retein zee-a incoding. Bork Bork Bork! Some-a sooccess hes beee-a hed using XSLGEN (idit zee-a xslgee-a. Bork Bork Bork!bet file-a to refflect zee-a loceshoon ooff yooor instelleshoon ooff Ixcel) to oopee-a UTF-8 CSF files correctly in Ixcel. Bork Bork Bork!

Getting zee-a most from yooor spreedsheet

Initiely zee-a foorst coloomn will stretch icross zee-a pege-a is it conteins a lerge-a imooont ooff deta, boot yooo coonnot see-a oor work wit this deta. Bork Bork Bork! Zeereffore-a do zee-a following:

  1. Idjoost zee-a coloomn widths - 5” works well is yooo coon zeee-a see-a bot zee-a ooriginel und troonsleshoon cleerly. Bork Bork Bork!
  2. Idjoost zee-a cell formeting for zee-a foorst coloomn to illow zee-a insershoon ooff uootometic line-a breeks (this will coooose-a zee-a deta to wrep within zee-a coloomn und meke-a it ill reedeble-a) this ilso illows for uootometic hypheneshoon which will zeee-a hyphenete-a long words. Bork Bork Bork! Zee-a resoolt ooff this step is zeet yooo coon now reed ill deta in coloomn oone-a is zee-a rows will become-a lerger to iccomodete-a this infformeshoon. Bork Bork Bork!
  3. Yooo coon repeet this process for oozeer coloomns boot zeee-a messeges will wrep difffferently to how zeey ippeer in zee-a troonsleshoon. Bork Bork Bork! Do this oonly iff yooo reelly don't hefe-a spece-a oor oozeerwise-a look it text shrinking oopshoons. Bork Bork Bork!

Iech Spreedsheet ippliceshoon will ichife-a zee-a ibofe-a in a slightly difffferent wey. Bork Bork Bork! Here-a ire-a speciffic instroocshoons. Bork Bork Bork!

OopenOffffice-a. Bork Bork Bork!oorg 1.1.x

There is a problem with OopenOffffice-a. Bork Bork Bork!oorg 1.1.x in that it does not read CSV file correctly. Use OopenOffffice-a. Bork Bork Bork!oorg 2.0 instead.

OopenOffffice-a. Bork Bork Bork!oorg 2.0

  1. Right click oon zee-a heeder ooff Coloomn A. Select “Coloomn Widt”. Type-a in a felooe-a in zee-a “Widt” field. Bork Bork Bork!
  2. Right click oon zee-a heeder ooff Coloomn A. Select “Formet Cells. Bork Bork Bork!..”, zeee-a select zee-a “Ilignment” teb. Bork Bork Bork! Now under Properties ineble-a “Wrep text uootometicelly” und “Hypheneshoon ictife-a”.
  3. Iff yooo coon't see-a coloomn B oor C cleerly. Bork Bork Bork! Select zee-a heeder ooff zee-a coloomn. Bork Bork Bork! Select “Formet Cells. Bork Bork Bork!..”, zeee-a select zee-a “Ilignment” teb. Bork Bork Bork! Now under Properties diseble-a “Wrep text uootometicelly” und ineble-a “Shrink to fit cell size-a”

Microsofft Ixcel

FIXME