Introduction
XTM Cloud includes an extensive reporting utility that previews the source and target translation in off-line mode, along with, among others, segment IDs, XTM Cloud statuses, comments, date created, date modified, segment revisions and the personal details of the users who took part in the workflow process and modified entries.
Enabling/downloading the report
The Preview Extended report is available for internal project managers, linguists and LSPs provided that the administrator has enabled the option to download the report in one of the three available formats, in the main XTM Cloud instance: XLSX, HTML, PDF in Configuration → Settings → Translation → Workflow and access → Linguist general options → Allow linguist to download.
Once this option has been selected, reports can be generated and then downloaded in the Project/Task file manager:
for project managers: Project Editor → Files → Preview → (generate Extended table…);
for linguists: Project context menu → Open File Manager → Files → Preview → (generate Extended table…);
IMPORTANT!
It is not possible for subcontractors (LSPs) to generate an Excel Extended table, so the lack of this option on their side, even though the Contractor has allowed them to do so, is to be expected!
Preview Extended table window panel
When you try to generate the Preview Extended table, the system will display a popup window in which you can select the specific columns that you would like to include in your report.
Defaults → In this section, you can select one of five predefined report templates.
Report columns → This section describes all the columns that you can freely include in/exclude from reports.
Report options → This section displays any additional settings that modify the report in any way:
All languages → In a multilingual Extended table report, each column included in the report breaks up into as many sub-columns as there are target languages, each of them presenting data for its specific language.
Only include segments with QA warnings → If the QA warnings column is activated, this setting restricts inclusion to segments that have QA warnings, in XTM Workbench.
Only show last revisions per step → This setting adds the Last revision column, which only contains the last revision for a particular segment (instead of the Revisions column).
Populate target with source → If no translation has been inserted in the target segment in XTM Workbench, it will be populated with the source text in the report.
Show usernames → It displays usernames in the appropriate columns such as Comments, Corrector changes, etc.
Description of columns
COLUMN NAME | DESCRIPTION |
|---|---|
Basic columns | |
Segment number | Shows each segment's number in XTM Workbench.
|
Source text | It shows the segment’s source text. |
XTM status | Shows the XTM status of a particular segment at the time the report was generated. The status can have one of the following values:
|
Segment ID | This ID relates to ID-based matching. If this feature is enabled, the ID for this segment is displayed.
|
Target text | Contains the segment’s target text. |
XTM status/match type | Shows both the XTM status of a particular segment and its match type at the time the report was generated (if the match type exists). Match types can have one of the following values:
|
Character limit | If a character length restriction is set for the target, that restriction will be displayed in this column. Keep in mind that the character restriction can only be applied to entire paragraphs, not individual segments. |
Corrector changes | It shows all the changes made to the text by linguists assigned to the Correct step(s), following the first/Translate step. The changes are either marked in blue (addition) or If the Show usernames setting is selected, the column also displays the date and time at which a correction was made, and the username of the user who made it. |
Date modified | It shows the date and time of last modification to a particular segment. The date and time format displayed in that column is based on individual User details settings. |
Last modified by | It shows the username of the user who last modified a particular segment. |
QA warnings | This contains the QA warnings for a particular segment (if they exist), as listed in the XTM Workbench QA panel. Keep in mind that, contrary to XTM Workbench, this column does not display spelling errors. Also, its exclusion from the report switches off the Only include segments with QA warnings setting. |
Comments | It shows linguist comments (if they exist) from XTM Workbench for a particular segment. If the Show usernames setting is selected, the column also displays the date and time at which a comment was made, and the username of the user who made it. |
Date created | It shows the date and time when the first translation version was created for a particular segment. Therefore, if a pre-populated match is inserted in the segment, the date will point to an actual project creation date. The date and time format displayed in that column is based on individual User details settings. |
Filename | It shows the name of the file that a particular segment comes from (one report can be generated for multiple files). |
Matches | It shows all the matches that a particular segment received. They do not have to be pre-populated. The column displays the match type (in bold) and its text. The status can have one of the following values:
|
Advanced columns | |
Revisions | It shows all the translation versions for a particular segment except for the last one, starting from whatever was entered first. As mentioned, the final manual translation of a segment does not count as a revision; therefore, it will not be displayed in the column.
As a result, we end up with two revisions:
Along with the revision number, the column also shows the workflow step name in which a particular revision was made. If the Show usernames setting is selected, the column also displays the date and time at which a correction was made, and the username of the user who made it. |
Pre-translated text | It shows a pure text, unedited by a linguist, coming directly from a pre-populated MT/TM match, if the project settings permitted this. The bold label at the top of the text indicates that an actual match has been applied. |
Post-edited text | The column shows the linguist’s very first manual revision of a text that has been machine-translated or pre-populated from a TM.
As a result, the "Post-edited text" column will only display the translation that was inserted in the Translate step, that is:
|
Final text | It shows the text which is the final translation version of a particular segment in XTM Workbench and so will be displayed in a target document. Note that the workflow step name in bold indicates the step in which this final version was inserted/the segment containing this version status was confirmed, so it does not necessarily have to be the last step in the workflow. A linguist might as well have begun work on the project in one of the previous steps and made the change there. |
Edit distance score | It shows the score. This will help you track the number of changes made by a post-editor in a machine-translated target segment. See the following article to learn about accessing MT performance data: Accessing machine translation (MT) performance data. |
Good to know!
The Preview Extended table can also be downloaded directly from XTM Workbench:
In XTM Workbench, go to Preview and click Excel extended table.
2. At the bottom right of the page, a green message is displayed that informs you that the report is ready.
Also keep in mind that the "XTM Workbench" version of the Extended table restricts the segment selection to segments which have been filtered in XTM Workbench. In other words, you can first filter specific segments using in-built XTM Workbench filters and then download the segment data in the report.