SHARING INFORMATION WITH OTHER APPLICATIONS

Importing tabular text files
Tabular text is ASCII text arranged in rows and columns, separated by tabs. When you import a tabular text file into a view, each text row becomes an individual document, and each text column becomes a field. The original table cell contents become field contents. There is a limit of 1536 total characters per record (row) when importing tabular text into a view.

When importing tabular text into a view, you must select a Notes form to accept the data.

To import tabular text files

1. In a view, choose File - Import.

2. In the Import dialog box, select "Tabular Text" in the "Files by type" list.

3. Select the file's drive and directory and then select the file.

4. Click Import.

5. Select the form you want to use to import the tabular text in the "Use Form" section of the "Tabular Text Import" dialog box. The field names in the form file must correspond to the field names used in the Notes view (for example, name, address, phone number, and so on.).

6. If you want to import the text only, specify the number of header or footer lines that you want Notes to ignore in the file in the "Page Layout" section of the "Tabular Text Import" dialog box. The "Lines per Page" setting establishes how many lines of text each Notes document receives. The total number of lines in the imported documents are calculated as:


7. Select "Main Document" or "Response Document" in the "Import as" list according to how you want the text to appear in the view.

8. If you are using a form where your fields need to be calculated, select "Calculate fields on form during document import." This option appears if you have formulas in your text.

9. If the ASCII file and view have different formats, you need to use a format file so individual components correspond to the columns in the view or the fields in the document. Select "Use format file" and the click "Choose format file" to select the format file to use. A format file has the extension .COL and is sometimes called a column descriptor file.

10. Click OK.