KnowledgeBase - How do I create lookup tables and upload translation files using the Translation File Import (TFI) service?

How do I create lookup tables and upload translation files using the Translation File Import (TFI) service?

« Go Back
Webtrends On Demand
Webtrends On Demand customers who have purchased the Translation File Import (TFI) service can create lookup tables and upload the corresponding translation files by performing the steps below.
Next Steps
If the default "Campaigns" or "Products" lookup tables are to be used, proceed to step 3. For a new, custom lookup table, start with step 1. below.

1. In the Webtrends user interface, navigate to "Administration > Web Analysis > Report Configuration > Custom Reports > Lookup Tables" and select "New."

2. Enter a name in the "Name:" field and select the type of delimiter to be used (the default is comma). Select "Save" to save the new lookup table. On returning to the Lookup Tables list, the new entry displays as a link (indicating it is user-created and editable) but no entry displays under the "Source" column as it has not yet been linked to a translation file.

3. Upload the translation file to the LookupTables folder on the SFTP server. For more information about this process, see More Information below.

4. If the default "campaigns.csv" or "products.csv" were uploaded and no issues with validation occurred, no further action is required. If a new translation file was uploaded, contact Webtrends Technical Support at (503) 223-3023 for further assistance. Technical Support will open a case and submit a request with our Hosted Operations team to create a link between the newly created lookup table and the recently uploaded translation file. Once the link is established, the system automatically checks for new versions of the file in the LookupTables folder, tests the validity of the file structure, and assuming the file passes validation, overwrites the previous version with the new one. The system recognizes a translation file by name so each iteration must use the same name as before.

Troubleshooting issues with validation
When issues with validation occur, an e-mail will be sent to the e-mail address on file for the user account used to access the SFTP server. The e-mail will state where the issues occurred and, where possible, steps for correction. When validation fails, the most recent version to have passed validation will continue to be used until the newer version passes validation.

The SFTP translation file validation process will detect these common errors:
  • Empty or corrupt files
  • An incorrect/inconsistent number of fields per line
  • Unclosed quotes
  • Invalid headers
  • Incorrect encoding
  • No newline before EOF
To minimize the chance a translation file fails validation, ensure the following conditions are met:
  • The translation file must have a header and each line in the file must have the same number of fields as the header.
  • If quotation marks are used they must be used in pairs to open and close the content in each field.
  • Translation files must be encoded in UTF-8 format.
  • Translation files must end with a newline character (CR/LF). This can be achieved by hitting Enter after the last line of the translation file. Translation files exported from Excel will automatically end in a newline character.
Note: Excel will not automatically expand the number of comma-delimited fields on any line to the correct number of fields if those fields are blank. To ensure Excel keeps the correct number of fields when saving a file in .csv format, add a final column called "END" (or something similar), then populate the column with any character (such as an asterisk) for each row on the file. Regardless of how many other columns in a given row are blank, Excel will insert blank fields to ensure that the final field is aligned properly with the header.
More Information
Was this article helpful?

Please tell us how we can make this article more useful.

Characters Remaining: 255