Translation using Excel

  1. Keep translation of all languages in Excel sheet.
  2. Use Vlookup function to get translation of each token.
  3. Create sql update statement.
  4. Export translation of project using Translation wizard in a table.
  5. Update the table using the sql statement.
  6. Import translation using Translation wizard

MSTR


=VLOOKUP(D19,rngTranslation,MATCH(B19,rngLanguage1,0)+2,0) UPDATE RST_KPI_2016_03_14_12h24m SET [TRANSLATION] = 'Trading Group' WHERE REFTRANSLATION = 'Item' and [LOCALEID]=9439241;