There are basically 2 tables where the translations are stored. Translated Text [sys_translated_text] & Translated Name/Fields [sys_translated]
sharing few links for help
For example purpose I have used French language and shared for catalog item name, short description, variable label.
You can similarly give for the question choices as well for Select box variable
I hope this will help you get started on your requirement.
Steps:
1) Visit to "System Localization" -> "Translated Name / Fields". Create new record.
2) For translating catalog item name and short description use this table Translated Name / Fields:
a) Translation of the catalog item "Name"
- Label - the catalog item name
- Element - the field name which holds this value i.e. name
- Table - The catalog item table i.e. sc_cat_item
- Value - french value of that catalog item name
b) Translation of the catalog item "Short Description"
- Label - the catalog item short description
- Element - the field name which holds this value short_description
- Table - The catalog item table i.e. sc_cat_item
- Value - french value of that catalog item short description
c) Translating questions/variables use this:
- Give the label same as "Question" on the variable
- Select the element as "question_text" which holds the value
- Table - Variable which holds the variable information in instance
- Value - french value for the label you want
Regarding Testing: For example purpose I have used French language; so you need to impersonate as User whose language is French in user profile and check whether all these are coming in french or not from portal etc.
a) catalog item name
b) catalog item short description
c) catalog variable names
d) catalog variable drop down choices etc
Screenshot:
Note: Remember to clear instance cache using cache.do and then test so that you can validate. Or you can also logout and login again to perform the testing
Regards
Ankur
