Importing options

When you import a file into a view you have some choices for how to display the imported data.

Formatting options

You have three choices for generating the column titles and widths during an import.

  • Choose "View Defined" if the column names and column widths in the source worksheet are identical to the names and widths of the columns in the view.
  • Choose "WKS Title Defined" if you've set up the worksheet so that the cells in the first row of the worksheet match the column headers and fields in the view. The cells in the first row must be labels.
  • Choose "Format File Defined" if you are using a column descriptor file (COL) that contains column style instructions.

Including additional fields for imported documents

You can use the import option "Calculate fields on form during document import" if you want the newly created document to contain all of the fields of the form you're using for the import. Notes® imports information more quickly when you do not select this option. If you first import without selecting this option and the results are not what you expect -- for example, fields that rely on other fields are empty or incorrect -- import the worksheet again and choose this option.

Character translation file

Notes® uses a character translation file (CLS) to translate foreign symbols and characters. The CLS file must be in the Notes® program directory.