CSV / XLSX File Configuration

Depois de os arquivos CSV ou XLSX para o projeto, eles exigem configuração adicional antes que o sistema possa importar o conteúdo destes arquivos.

Para configurar arquivos CSV ou XLSX, siga estas etapas:

  1. Open your project and go to Sources > Files.
  2. Clique em Configurar próximo ao arquivo para abrir a janela de configuração.

Configurar Arquivo

The same configurations mentioned in this article are also applicable to the TSV file format. The main difference between CSV and TSV files is that they use different delimiters between columns (i.e., comma in CSV and Tab in TSV).

Opções de Configuração para Arquivos XLSX

Ao configurar arquivos XLSX, você terá as seguintes opções:

  • Importar todas as células - importe cada célula como um texto original separado. Além disso, você pode usar Segmentação de Conteúdo para dividir o conteúdo do arquivo original em pedaços de texto mais curtos, principalmente frases e parágrafos curtos. Isso é útil ao traduzir unidades de conteúdo que consistem em várias frases porque será mais fácil traduzir pedaços menores de texto. Segmentation Rules eXchange (SRX) são usados ​​para segmentação automática de conteúdo.

  • Configurar colunas para importação - especifique a ordem de coluna preferida.

Opções de Configuração XLSX

Configuração de Colunas para Importação de arquivos XLSX e CSV

When configuring CSV or XLSX file with Configure columns for import option, you can specify the following column types:

  • Key – Column contains string identifiers. Typically an alphanumeric value.
  • Source string – Column contains source strings that should be translated.
  • Source string/Translation – Column contains source strings, but the same column will be filled with translations when the file is exported. Ao enviar traduções existentes, os valores desta coluna serão usados como traduções.
  • Translation – Column for resulting translations added on export. On import and when uploading existing translations, the system will check this column for existing translations and upload them to the project.
  • Context – Column contains comments or context information for the source strings.
  • Labels – Column contains labels for the source strings. You can add multiple labels to each string, separating them with commas.
  • Max. Length – Column contains max.length limit values for the translations of the strings.
  • Not chosen – Column that will be skipped on import.

CSV Configuration

Configuration Templates

If multiple files have the same configuration scheme, save your current configuration as a template by clicking Templates > Save as template, then specify the template name and click Save. You’ll be able to apply the template to the newly imported files.

Column Headers

Not to translate the column headers, select Do not import the first row (header).

Column Headers

Redefinir configuração de compartilhamento

If you’d like to start the spreadsheet configuration over, click Edit and select Reset Configuration.

Planilhas Multilingues

If your file contains several columns with translations into different languages, select Multilingual Spreadsheet and map the languages to the appropriate columns.

By default, when you configure the multilingual spreadsheets, the Import translations option is selected. If you’d like not to import the existing translations from the file, you can clear this option.

If your multilingual source file doesn’t contain enough columns for all project target languages, click Edit and select Add column. To remove one of the added columns, click Edit and select Delete Selected Column.

Multilingual CSV

Configurar vários arquivos ao mesmo tempo

To configure several selected CSV or XLSX files, right-click and select Configure files.

CSV Configuration

To configure all CSV or all XLSX files at once, click Configure All.

CSV Configuration

In the configuration window, you’ll be able to switch between the selected files to preview and verify if the applied configuration is correct for all files.

Changing Scheme for CSV and XLSX Files

You might want to update CSV or XLSX files and change the initially configured scheme. The scheme update might be needed when you add a new target language to your Crowdin project.

To change the scheme for your source file, follow these steps:

  1. Right-click on the needed files and select Change scheme.
  2. Select the new file on your machine.
  3. Set the new configuration/template for the file correspondingly.
Note: You can't edit the existing configuration template. Instead, you can remove it or create a new one.

Veja também

Este artigo foi útil?