Localization Export and Import (in Grid) accompanies our core feature - Dependencies. It allows you to export translation files with the current statuses of strings. When you re-import using Localization Import statuses can be updated automatically.
Note
To use the Localization Export and Import feature, you’ll first need to set up localization columns and add Dependencies to all the desired language pairs in your Grid.
Export files using Localization export
- Open a Grid, you’ll see the Localization button in the header (if dependencies are set).
- Select Localization Export.
Gridly will export the translation file in XLSX (Excel format). You can select what to feature in the exported files.
- Source language: Select the source language you want to export.
- Select target language to export: Select the target language columns to export, or click the check box to Export all target languages.
-
Other settings (optional):
- Highlight source changed: Highlight changes in the source language columns since the last translation update.
- Include up-to-date record: Files exported using the Localization export function will by default solely include records that need updating (Dependency status: Out-of-date, Unset). Select this option if you also want to include up-to-date records
- Include do-not-translate: Select this option if you want to include records with the source status: Do not translate
- Include not-ready-for-translation record: Select this option if you want to include records with the source status: Not ready for translation
- Export to the same sheet: For Grids containing more than 1 target language, each language will be exported to a separate sheet. Select this option if you want the languages to be exported to the same sheet
- Select other columns (optional): Select other columns you want to export.
- Click Export.
Re-import files using Localization Import
After sending out to translators to update translations, you can re-import the files to update the records in the Grid.
- Open the Grid, then click on the toolbar.
- Select Localization import from the dropdown list.
- Drag and drop, or click to browse for your files.
- If you want to import multiple localization files at once, click Add more files.
- Click Manage to start checking the updates.
Note
Gridly can only import XLSX files to this location which have been initially exported using the Gridly Localization Export feature.
Manage import
Let’s review the changes before we finish importing.
In the Manage import window, you can see a preview of the imported records and changes made (or not made). All the changes will be highlighted by type: Error, Warning, Info. Gridly won’t import the values or update the translation statuses for some changes. Please check the table below for detailed information.
Filter issues and actions
Click next to the target language to filter issues by issue type and action:
Click to show unresolved issues.
View records details
You can compare the changes in the Grid and imported file by clicking on the cells in the target language columns. For specific updates, you are required to select whether to overwrite or skip the updates, and set the statuses for the targets.
You can choose to apply an option to all similar issues:
Tips
For longer text, you can click at the bottom right of each cell to expand and view the whole text.
Confirm import
After reviewing the import preview, click Import, then click Apply.
If you don’t manually resolve issues, Gridly will apply the default option for those.
Export the list of issues
If you don’t know how to resolve the issues, or simply want to save them for further investigation, you can choose Export copy of issue list to export a list of current import issues. The exported file will be in XLSX format.
Issue overview
Don't know what the issue is about? Here is the list of issues with detailed explanations. You can always open a record to view the issue details:
- Issue: the issue name.
- Issue type: Issues are highlighted by types: Error (Red), Warning (Yellow), Info (Blue).
- Description: Explain what the issue is about and why it occurs.
- Action: What can be done with the issue.
- Default Dependency status: the Dependency status of a string will be updated following this Default Dependency status if you don't take any separate actions.
Issue | Issue type | Description | Action | Default Dependency status |
Record not found | Error | This record was deleted from the Grid | Skip import of these records | Keep as current |
Source not ready | Error | Translation cannot be imported if the source status of the strings is set as Not ready for translation, or Do not translate | Skip import of these records | Keep as current |
No target | Error | There is no translation in the target language column in the file | Skip import of these records | Keep as current |
Source changed - Target changed | Warning | The source text has been changed since the last export. | Select whether to Overwrite with updated text or Skip | Keep as current |
Source changed - Target unchanged | Warning | The source text has been changed since the last export, but the translation is not updated | Skip import of these records | Keep as current |
TM conflict | Warning | Strings that used TM (Translation Memory) have been updated with new TM data since the last export | Select whether to Overwrite with updated text or Skip | Mark as Up-to-date, and update the imported translation to TM |
Length exceeded | Warning | Imported strings are longer than the maximum length set in the Grid | Select whether to Overwrite with updated text or Skip | Mark as Up-to-date |
Source changed | Warning | The source text has been changed since the last export | Skip import of these records | Keep as current |
Target changed | Info | The text in the target language has been changed | Select whether to Overwrite with updated text or Skip | Mark as Up-to-date |
No change | Info | There is no change in the translation before and after exporting | Skip import of these records | Keep as current |
Manage import issue warnings
You can choose whether to show warning messages for specific issue types and also select a default action if that issue is found. This is all configured in the Import warning tab.
On the project page, click next to the company name and select Localization settings, then open the Import warning tab.
Default import warning settings are applied to all projects. You can toggle on or off and select the default action under each issue type. If you want to create a custom import warning for a specific project, click Create New Setting.
For example, the message below won't be displayed when the option Display warning is set to off. The default action will be applied automatically.
You can check and change the default actions for your issues in the Import warning setting.
- Skip: Skip importing the records to the Grid
- Overwrite - set up-to-date: Overwrite with updated text from the imported file, mark the dependency status of the strings as up-to-date.
- Overwrite - set out-of-date: Overwrite with updated text from the imported file, mark the dependency status of the strings as out-of-date
Note
You cannot change the default action for Issues such as Record not found, Source not ready, they will be skipped when importing.