ok, It is simple script task, but time and performance should be an issue. I have wrote php script that can do these:
1. Extract string keys and values from csv source file.
2. Checking target xml file and see there are any matching string keys.
3. If there are matching then check its string value.
4. And save all the data in csv form.
So here are samples:
//source csv
## Airbrush=
@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun=Airbrush Gun
@@Foo_HOB_Curio_Shoppe_wordclueName_Airbrush=Airbrush
## Alarm=
@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock=Alarm Clock
@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock=Alarm Clock
@@Foo_HOB_Russian_Front_wordclueName_Alarm=Alarm
@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm=Fire Alarm
//target xml
<?xml version="1.0" encoding="UTF-8"?>
<strings locale="ko_KR">
<pkg name="Achievements">
<string key="@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun">
<original>성취</original>
</string>
<string key="@@Foo_HOB_Russian_Front_wordclueName_Alarm">
<original>축하합니다</original>
</string>
<string key="@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock">
<original>획득했습니다!</original>
<variation index="0">획득했습니다!</variation>
</string>
<string key="@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock">
<original>획득했습니다!</original>
<variation index="0">획득했습니다!</variation>
</string>
<string key="@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock">
<original>획득했습니다!</original>
<variation index="0">획득했습니다!</variation>
</string>
<string key="@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm">
<original>획득했습니다!</original>
<variation index="0">획득했습니다!</variation>
</string>
<string key="@@Foo_HOB_Art_Studio_wordclueName_Airbrush">
<original>성취</original>
</string>
</pkg>
</strings>
//result csv
Airbrush
@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun=Airbrush Gun
@@Foo_HOB_Art_Studio_wordclueName_AirbrushGun=성취
@@Foo_HOB_Curio_Shoppe_wordclueName_Airbrush=Airbrush
@@Foo_HOB_Curio_Shoppe_wordclueName_Airbrush=성취
Alarm
@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock=Alarm Clock
@@Foo_CAD_Bank_Vault_wordclueName_AlarmClock=획득했습니다!
@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock=Alarm Clock
@@Foo_HOB_Garage_Sale_wordclueName_AlarmClock=획득했습니다!
@@Foo_HOB_Russian_Front_wordclueName_Alarm=Alarm
@@Foo_HOB_Russian_Front_wordclueName_Alarm=축하합니다
@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm=Fire Alarm
@@Foo_HOB_Window_Shopping_wordclueName_FireAlarm=획득했습니다!
That is all. As I said, I have wrote php script that is working only small size of files. Source file is like 350k but the target xml file is like 4MB, and my script takes too long to do this.
I attach real source and target file. Check it. ;-)