Translate field values using a table

  1. Using Manager, select File > New.
  2. Select Table and click OK.
  3. Type a name for the new table. Note that table names are case-sensitive.
  4. Click OK. The Table dialog is displayed.
  5. In the first Update line box, type values that can occur in the field. Type one key value on each line. The Key field can contain up to 63 characters (More detailed instructions).
  6. On the same line, under Translation, type the value that you want to change each key value to. The Translation field can contain up to 99 characters.

    If you want the value to be replaced by spaces, type one space as the translation value. (If the field on the invoice definition is numeric, you must also change the transaction field type from numeric (N) to alphanumeric (X) to accommodate the space.

    Also, you may want to change the pad character, as the default pad character for alphanumeric fields is a space. Do all of this in the Transaction description dialog.)

    There is no need to fill in the Connection 1 and Connection 2 columns, though you can fill these in if you intend to use the table for validation via a connection table, as well.

  7. Click Close. This saves the table.
  8. Create or edit the field profile in your invoice profile.
  9. In the Table validation settings, select the name of the translation table in the Translation table group box.
  10. Optional: Select Translate value when transferred to translate the value after validation and verification (that is, just before transfer).

    If you do not select Translate value when transferred, translation occurs in Interpret. To avoid validation errors in this case, make sure the format specification of the field being translated matches both the field values and the translation values.

Note Kofax ReadSoft Invoices does not support direct translation of different field formats via table translation. For example, you cannot translate a field with a numeric format specification to an alphabetic value. However, you can do this using a connection table connected to an empty field.