Reusing an XTM Connect – Google Sheets configuration in a new Sheet
As described in Saving and reusing translation configuration settings, you can optionally make Sheet-specific configuration settings that control different aspects of the translation process in that Sheet. If you save these settings, you can reuse them in a new Google Sheet. For details of how to save these settings, see Exporting an XTM Connect – Google Sheets configuration to a.json file. Below, you will find a description of how to apply those settings in a new Sheet, when required.
Create a new Google Sheet. To do so, from the File menu, select New and then select Spreadsheet. The new Google Sheet opens.
In your original Sheet, in row 1., select and copy the following headers for the following columns (but not the column contents):
The source column to be translated.
The comment column, if you have set it.
The target length column, if you have set it.
The target language column header(s).
(You can also request translation into multiple languages in the new Sheet, but these languages, and the other details, must match the details in the original Sheet.)
Paste the content you copied earlier into the new Google Sheet, in row 1.
In the new Sheet, from the Extensions menu, select XTM Connect – Google Sheets and then select Open XTM Connect.
In the new Sheet, XTM Connect – Google Sheets is not connected. You must log in to it. If required, see Logging in to XTM Connect – Google Sheets from Google Sheets for details). When you have logged into XTM Connect – Google Sheets, a screen message notifies you that there are no default settings for the new Sheet (which is expected).
To apply your saved XTM Connect – Google Sheets configuration, select the Import button in the Configuration template section, in the XTM Connect – Google Sheets panel.
In the File Manager on your computer, select the
.jsonconfiguration file that you exported and saved locally earlier.Select the Open button. A screen message notifies you that there are no default settings for the new Sheet (which is expected).
In the message popup, select OK. The popup closes.
In the XTM Panel, you see all the settings that you made for your original Sheet. They will be applied in the new Sheet when you have entered source texts and other data in it and sent it for translation.
In the Sheet, you see the same columns as in your original Sheet. These columns are empty and you can fill them with data, as required.
Optionally, you can save all the settings defined for XTM Connect – Google Sheets, such as language mappings and project templates, as default settings. These will be loaded automatically whenever you log in to XTM Connect – Google Sheets again.
When you have filled your new Sheet with source texts and other data, and are ready to send them for translation, select the Request translation button at the bottom of the XTM Panel. A project creation popup is displayed.
Select the OK button. The popup closes. When the translation has been requested, the cells in the columns into which the requested translations are to be returned are filled with the following data:
The DO NOT EDIT! Waiting for translation from XTM Cloud. placeholder text.
Date and time.
A cell ID.
Warning
Do not make any changes in these cells. The cell contents must stay intact to enable the translations to return.
Once translation is finished in XTM Cloud, XTM Connect – Google Sheets is notified. The cells in the Google Sheet columns intended to receive particular target language translations are then filled with the translations.
Note
In the case of translations into multiple target languages, when the source content has been translated into particular target languages, those translations can be returned to your Google Sheet, via XTM Connect – Google Sheets, without waiting for the other target language translations to finish. Consequently, you do not have to wait until the whole project is finished, to start checking or using some of the translations, when they are ready. For more information, see Retrieving finished translations manually.