pwittchen / android-resource-converter

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

translations.csv file not delimted #2

Open spark85 opened 8 years ago

spark85 commented 8 years ago

I tried running the xml2csv command and the translation file it creates does not look like a proper csv file in LibreOffice. The columns are not being generated properly.

pwittchen commented 8 years ago

What version of Libre Office Calc are you using? After last PR, delimiter was changed to tab. Most of csv files uses comma or semicolon as delimiter, but tab should also work. As far as I see, in case of Libre Office, you can use any kind of delimiter. I'm not sure how it behaves in MS Office, but in Libre Office it should be fine.

Sample xml file from this repository converted to csv file looks like that:

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

When I open it in Libre Office Calc, I see the following window (I'm using Polish version):

zrzut ekranu z 2016-02-26 18 32 40

Then, I press ok (I leave default configuration and don't change antyhing) and I can see spreadsheet as follows:

zrzut ekranu z 2016-02-26 18 40 45

I'm using Ubuntu 14.04 LTS and Libre Office version: 4.2.8.2, Build ID: 420m0 (Build:2).

Does it behave differently in your case?

pwittchen commented 8 years ago

Due to no response I'm closing this issue as invalid. In my case, everything works fine as I described above. In case of any problems, we can re-open this issue. Feel free to create a new one if necessary.

spark85 commented 8 years ago

Sorry; I didn't see the notification on the requests. I ended up giving up on the tool and moving on. I will give it another try this weekend and check it out. My guess is there is probably a character encoding issue in the content.

pwittchen commented 8 years ago

Ok, you can let me know how will it go :). You can also attach a sample file to convert, so I can be sure that I can reproduce this problem.

pwittchen commented 6 months ago

I removed the last comment because it looked like some sort of scam.