Google Sheets: How to troubleshoot the issue that translated content is not imported back to Excel automatically
Introduction
One of the problems that you might identify is that translations are not returning to the dedicated place in your Excel spreadsheet upon completion in XTM Cloud. You might still see a message like DO NOT EDIT! Waiting for translation from XTM. 28-08-2023 11:26 AM in target cells, even the jobs concerned have been finished in XTM Cloud (which should, by default, trigger automatic import of those jobs into Excel).
Before submitting an issue request to the XTM International Support team, there are a couple of troubleshooting measures that you can perform first, to try and resolve the problem.
Instructions
First of all, using the Retrieve translations option in the XTM Connect plugin, try importing translations back to the CMS manually. It might sometimes happen that, due to, for example, connection issues, you need to import content manually. A single click on the said button returns a single translation job from XTM Cloud, meaning that if you happen to be waiting for a single file in 5 languages to come back, you will see only 1 of those languages populate. To retrieve everything, you need to click on the button 5 times.
The next step is to perform basic web troubleshooting actions. These involve:
Clearing your browser’s cache (see Clear your web browser's cache, cookies, and history for help),
Trying another browser to see if the issue also persists there,
Trying to access the XTM Connect plugin in private (Incognito) mode (see How to Turn on Incognito Mode for help).
If performing the actions above does not resolve the issue, try clearing the spreadsheet’s memory. In the XTM Connect plugin, if you click on Show advanced settings, you will see the red button with the label Clear sheet's memory. It basically does what it says – the connection between any existing projects that are currently in translation in XTM Cloud and the spreadsheet will be broken. Even though there might be some content from previous projects in the current sheet, the connector will treat it as a brand new file.
IMPORTANT!
Be careful when you use this option when working with a spreadsheet. Treat it as a solution only when absolutely necessary. It would also be best to first consult with XTM International Support about it.
If performing the actions above does not resolve the issue, go to your XTM Cloud instance (if you are able to) and check if a successfully generated target file has been placed there. If there is no target file (or it has been generated incorrectly), remember to tell the XTM International Support team so when submitting an issue request.
As a last resort, try creating a new spreadsheet (or copying an existing one) and working on it. It is possible that the connector could not retrieve translations in the existing spreadsheet for various reasons and submitting the same content for translation again from a newly created sheet (or from a copy of the existing one) and finishing it in XTM Cloud might help straightaway.
If this option does not resolve the problem, submit an issue request to XTM International Support. To do this, use the following form, in Customer Portal: Report an issue relating to XTM Connect – Google Sheets. In it, fill out the fields accordingly.
IMPORTANT!
In some rare cases, if
you cannot see anything in the XTM Connect plugin,
the XTM Connect plugin is in a prolonged “loading” state or
there is any other unexpected error,
there might have been an outage affecting the overall connector. In such a case, submit an issue request to XTM International Support immediately!