summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorBrad Payne (Vir Linden) <vir@lindenlab.com>2020-09-10 19:53:13 +0100
committerBrad Payne (Vir Linden) <vir@lindenlab.com>2020-09-10 19:53:13 +0100
commit3788fdbb03f85492f4bd26cb4637434ac3e8515e (patch)
tree37e996bba5f7de759081cd2b7071a4d547709aad /scripts
parent932f66929db5e7a5afae1f547408388cdc680709 (diff)
SL-13705 - fixes and spreadsheet format changes
Diffstat (limited to 'scripts')
-rw-r--r--scripts/code_tools/modified_strings.py15
1 files changed, 10 insertions, 5 deletions
diff --git a/scripts/code_tools/modified_strings.py b/scripts/code_tools/modified_strings.py
index eee20cf83b..3ea13a2bf5 100644
--- a/scripts/code_tools/modified_strings.py
+++ b/scripts/code_tools/modified_strings.py
@@ -169,7 +169,8 @@ def make_translation_spreadsheet(mod_tree, base_tree, lang, args):
new_val = "(DUPLICATE)"
else:
new_val = ""
- data.append([filename, name, "text", val, transl_val, new_val])
+ field = "text"
+ data.append([val, transl_val, new_val, filename, name, field])
all_en_strings.add(val)
rows += 1
for attr in translate_attribs:
@@ -178,9 +179,12 @@ def make_translation_spreadsheet(mod_tree, base_tree, lang, args):
or attr not in base_dict[name].attrib \
or mod_dict[name].attrib[attr] != base_dict[name].attrib[attr] \
or (args.missing and (not name in transl_dict or not attr in transl_dict[name].attrib)):
- val = mod_dict[name].attrib[attr]
+ elt = mod_dict[name]
+ val = elt.attrib[attr]
+ #if attr == "value" and elt.tag not in ["string","text"]:
+ # print("skipping value attribute", val, "tag", elt.tag, "in", filename)
+ # continue
if should_translate(filename, val):
- show_val = val
transl_val = "--"
if name in transl_dict and attr in transl_dict[name].attrib:
transl_val = transl_dict[name].attrib[attr]
@@ -188,14 +192,15 @@ def make_translation_spreadsheet(mod_tree, base_tree, lang, args):
new_val = "(DUPLICATE)"
else:
new_val = ""
- data.append([filename, name, attr, show_val, transl_val, new_val])
+ field = attr
+ data.append([val, transl_val, new_val, filename, name, field])
all_en_strings.add(val)
rows += 1
if args.verbose and rows>0:
print(" ",rows,"rows added")
outfile = "SL_Translations_{}.xlsx".format(lang.upper())
- cols = ["File", "Element", "Field", "EN", "Previous Translation ({})".format(lang.upper()), "ENTER NEW TRANSLATION ({})".format(lang.upper())]
+ cols = ["EN", "Previous Translation ({})".format(lang.upper()), "ENTER NEW TRANSLATION ({})".format(lang.upper()), "File", "Element", "Field"]
num_translations = len(data)
df = pd.DataFrame(data, columns=cols)
df.to_excel(outfile, index=False)