Data Population in a Translation

How Can I Populate Translation Data?

There are several options for populating data in a Translation in the Fabric Studio:

  • Manual population via the Translation window.
  • Importing the Translation’s data from a file. The data is loaded from the file only once.
  • Importing the Translation’s data from a database to create a Dynamic Translation. The data is loaded from the database each time the Translation is invoked.

Import options are enabled via the Import screen.

How Can I Import Translation Data from a File?

After defining the Translation Schema do the following:

  1. Go to Translation Data tab > Import Data.
  2. Click the Import from File tab.
  3. Do the following in the Main section:
    • Enter the location of the file or click Browse and search for it.
    • Optional: Check First line as a header if the file includes a header, the first line will be skipped during the import.
    • Select the Delimiter Type (for example a Comma delimiter).
    • Optional: If the file is an Excel file, select the Worksheet Page from the dropdown list.
    • Click Fetch Data to preview the imported file.
  4. Do the following in the Mapping section:
    • Click Fill Mapping Grid to create the association between the fetched data and the Translation fields.
    • Check all columns and verify the association is correct. Manually update if needed.
  5. Click Apply to confirm the association between the Data and Translation fields. A Confirmation notification opens indicating the number of rows imported.
  6. Click Save.

Example

To create a new Translation named trnCountry:

image

Import the data from the CSV file as follows:

image

Notes

  • Supported file formats are text, CSV or Excel. When the file format is Excel, specify which worksheet.
  • Close the Import file before importing data.
  • Manual corrections may be required in the Grid columns mapping.

How Can I Import Translation Data from a Database Table?

After defining the Translation Schema, do the following:

  1. Go to Translation Data tab > Import Data.
  2. Go to the Import from DB Table tab.
  3. Do the following in the Database section:
    • Choose the DB Connection from the dropdown list.
    • Go to the Source DB Tables Tree and click the table holding the data to be imported.
  4. Do the following in the Mapping section:
    • Click Fill Mapping Grid to create the association between the fetched data and the Translation fields.
    • Check all columns and verify the association is correct. Manually update if needed.
  5. Click Apply to confirm the association between the data and Translation fields.
  6. Click Save.

How Can I Import Translation Data Using DB SQL?

After defining the Translation Schema do the following:

  1. Go to Translation Data tab > Import Data > Import from DB SQL tab.
  2. Do the following in the Database section:
    • Choose the DB Connection from the dropdown list.
    • Enter the SQL Query to fetch the data.
  3. In the Mapping section, click Fill Mapping Grid to create the association between the data and Translation fields.
  4. Click Apply and then click Save.

Previous

Data Population in a Translation

How Can I Populate Translation Data?

There are several options for populating data in a Translation in the Fabric Studio:

  • Manual population via the Translation window.
  • Importing the Translation’s data from a file. The data is loaded from the file only once.
  • Importing the Translation’s data from a database to create a Dynamic Translation. The data is loaded from the database each time the Translation is invoked.

Import options are enabled via the Import screen.

How Can I Import Translation Data from a File?

After defining the Translation Schema do the following:

  1. Go to Translation Data tab > Import Data.
  2. Click the Import from File tab.
  3. Do the following in the Main section:
    • Enter the location of the file or click Browse and search for it.
    • Optional: Check First line as a header if the file includes a header, the first line will be skipped during the import.
    • Select the Delimiter Type (for example a Comma delimiter).
    • Optional: If the file is an Excel file, select the Worksheet Page from the dropdown list.
    • Click Fetch Data to preview the imported file.
  4. Do the following in the Mapping section:
    • Click Fill Mapping Grid to create the association between the fetched data and the Translation fields.
    • Check all columns and verify the association is correct. Manually update if needed.
  5. Click Apply to confirm the association between the Data and Translation fields. A Confirmation notification opens indicating the number of rows imported.
  6. Click Save.

Example

To create a new Translation named trnCountry:

image

Import the data from the CSV file as follows:

image

Notes

  • Supported file formats are text, CSV or Excel. When the file format is Excel, specify which worksheet.
  • Close the Import file before importing data.
  • Manual corrections may be required in the Grid columns mapping.

How Can I Import Translation Data from a Database Table?

After defining the Translation Schema, do the following:

  1. Go to Translation Data tab > Import Data.
  2. Go to the Import from DB Table tab.
  3. Do the following in the Database section:
    • Choose the DB Connection from the dropdown list.
    • Go to the Source DB Tables Tree and click the table holding the data to be imported.
  4. Do the following in the Mapping section:
    • Click Fill Mapping Grid to create the association between the fetched data and the Translation fields.
    • Check all columns and verify the association is correct. Manually update if needed.
  5. Click Apply to confirm the association between the data and Translation fields.
  6. Click Save.

How Can I Import Translation Data Using DB SQL?

After defining the Translation Schema do the following:

  1. Go to Translation Data tab > Import Data > Import from DB SQL tab.
  2. Do the following in the Database section:
    • Choose the DB Connection from the dropdown list.
    • Enter the SQL Query to fetch the data.
  3. In the Mapping section, click Fill Mapping Grid to create the association between the data and Translation fields.
  4. Click Apply and then click Save.

Previous