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.
About this task
When importing tabular text into a view, you must select
an HCL Notes® form to accept the data.
There is a limit of 1536 total characters per record (row) when importing
tabular text into a view.
Perform the following steps:
Procedure
-
In a view, click .
-
Click Tabular Text in the Files
by type list.
-
Select the file's drive and directory and then select the
file.
-
Click Import.
-
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.).
-
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 Options for Imported Documents 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:
Lines Per Page - (Header Line Count + Footer Line Count)
-
Click Main Document or Response
Document in the Import as list
according to how you want the text to appear in the view.
-
If you are using a form where your fields need to be calculated,
click Calculate fields on form during document import.
This option appears if you have formulas in your text.
-
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. Click Use
format file and then 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.
-
Click OK.