pwittchen / android-resource-converter

Scripts converting Android *.xml resources with translations to *.csv file and backwards
9 stars 9 forks source link
android converter csv python resource xml

Android Resource Converter

Simple Python scripts converting Android xml resources with translations to csv file and backwards

Motivation

In international projects sometimes there's a need to send resource files to the client in order to have translated strings. Client doesn't have to understand XML notation and editing two or more files at the same time is inconvenient. It's easier to send file which can be edited in MS Excel or Libre Office Calc.

Scripts in this repository are able to convert Android xml resources to a single .csv file ready to open in software for common users. In addition, there's another script, which can generate xml resource files from .csv file. Scripts were tested on Linux (Ubuntu 14.04 LTS)

Requirements

To satisfy requirements, run the following command:

$ pip install -r requirements.txt

Usage

Generating *.csv file

$ ./xml2csv.py <directory_with_xml_files>

Example

$ ./xml2csv.py resources

Sample output

translations.csv

key strings_english.xml strings_polish.xml
hello_world Hello World!    Witaj Świecie!
app_name    My application  Moja aplikacja

Note: These "space" delimiters are fine and can be modified in the script. Nevertheless, Libre Office Calc reads it properly.

Generating *.xml files

$ ./csv2xml.py <file_with_translations>.csv

Example

$ ./csv2xml.py translations.csv

Sample output

strings_english.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<resources>
  <string name="hello_world">Hello World!</string>
  <string name="app_name">My application</string>
</resources>

strings_polish.xml

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<resources>
  <string name="hello_world">Witaj Świecie!</string>
  <string name="app_name">Moja aplikacja</string>
</resources>

Caveats