Importing or Exporting a Translation Spreadsheet

about importing or exporting a translation spreadsheet docid\ irbwugpskqicnyiwxlq9jexporting language records to microsoft excel from the translation tool docid\ irbwugpskqicnyiwxlq9jexporting language records to microsoft excel from the languages workspace docid\ irbwugpskqicnyiwxlq9jimporting language records from microsoft excel docid\ irbwugpskqicnyiwxlq9j about importing or exporting a translation spreadsheet use the import from excel and export to excel features to manage strings in a microsoft excel spreadsheet importing all of the strings to a microsoft excel spreadsheet makes it easy to see which strings have not been translated also, use this feature if you have customized translation strings and need to back them up or restore them you have strings translated by an outside source also see setting up languages docid\ lvpbgqv5z08mcuzy43ky3 when editing an exported translation string spreadsheet in microsoft excel, edit the strings in the right most column only and do not add rows to the spreadsheet making changes in other columns or adding rows could result in database inconsistencies when you import the spreadsheet exporting language records to microsoft excel from the translation tool from the configuration console, open the translation tool as described in accessing the ivanti translation tool docid\ c92 3jttrgimjuaqt9atp if you make any changes, be sure to save before continuing to export select the properties to export by checking the property click export to microsoft excel the application creates a microsoft excel spreadsheet with the properties that you selected depending on your browser configuration, the application saves the spreadsheet into the default download folder or into a folder that you specify after you export the spreadsheet, you can open it and modify the translations strings in the right most column as necessary exporting language records to microsoft excel from the languages workspace when using the firefox browser, the exported file may have the wrong file extension change or add the file extension xlsx to the file before attempting to open it from the configuration console, click configure > organizational profile > languages the application displays the languages workspace select the culture name (target language) to export decide on an export option export all exports all properties, with or without translations choose this option when you want to export existing translations that you have edited export since exports properties without translations, based on the filters applied export all strings with missing translations exports all the properties without translations if you decided on the export all option, in the export all column of the languages workspace, click export next to the target language to export the application creates a microsoft excel spreadsheet depending on your browser configuration, the application saves the spreadsheet into the default download folder or into a folder that you specify if you decided on the export since option, do the following a in the export since column of the languages workspace, click export next to the target language to export the application displays the export strings with missing translations dialog box export strings with missing translations dialog box b from the drop down menus, do the following in the first field, select either modified by or created by in the second field, select the login id of the person who made the modification or created the translation in the third field, select either modified date or created date in the fourth field, enter the range of dates in which the modification or creation took place c click export the application creates a microsoft excel spreadsheet depending on your browser configuration, the application saves the spreadsheet into the default download folder or into a folder that you specify if you decided on the export strings missing translations option, do the following a in the export since column of the languages workspace, click export next to the target language to export the application displays the export strings with missing translations dialog box b check export all strings with missing translations c click export the application creates a microsoft excel spreadsheet depending on your browser configuration, the application saves the spreadsheet into the default download folder or into a folder that you specify importing language records from microsoft excel if you are adding an all new culture (language), see adding a language and culture without translations docid\ lvpbgqv5z08mcuzy43ky3 do one of the following from the configuration console, open the translation tool as described in using the ivanti translation tool docid\ c92 3jttrgimjuaqt9atp click import from microsoft excel the application displays the file upload dialog box from the configuration console, click configure > organizational profile > languages to open the languages workspace next to a language, click import navigate to the spreadsheet, select it, and click open importing takes several minutes and depends on file size when completed, the application displays an import was successful message click ok to view the imported language records, run a new search to view the updated records