APPLICATION DESIGN


Exporting views
You can export a view to an ASCII file, a worksheet, a tabular text file, or a structured text file.

Exporting to an ASCII file with comma separated values

A comma separated value file (CSV) formats data as ASCII text with one record per line and with fields separated by commas. When you export to a CSV file, you can choose between exporting all or selected documents in a view. You can choose an export character set -- either Unicode, the International (UTF-8) choice, or the default. You can also choose to include view titles in the exported file.

Notes on exporting as a CSV file


Exporting to a worksheet

When you export a view to a worksheet, each document becomes a row in the worksheet. Each field becomes a column in the worksheet. The original field contents become cell contents. Column titles become labels in the worksheet.

When you export a view to a new worksheet file, IBMR® Lotus® Notes® exports the file in 1-2-3 WK1 format. Although you can specify any extension with the file name, it's best to keep the extension .wk1. When you open the exported file in a newer release of 1-2-3, 1-2-3 automatically converts the file to its new format and adds the appropriate extension.

If you change the exported file to WK2, WK3, or WK4 before opening it in a release of 1-2-3 that uses that extension, and then open the file in 1-2-3 and attempt to add and save attributes, the new copy of the file will be in conflict with the original, and you won't be able to save your changes.

To export to a Microsoft Excel file, export the view as a 1-2-3 worksheet, and then save the file in 1-2-3 as a Microsoft Excel file.

Exporting to a tabular text file

Tabular text is ASCII text arranged in rows and columns, separated by space characters. When you export a view to a tabular text file, each document becomes a text row (line). Each field becomes a text "column," separated by space characters. The original field contents become the "cell" contents. To see the separation between columns in the exported view, use a monospaced font for the columns in the original view.

The result of a tabular export may not look exactly like the view. Views use a proportionally spaced font, but exports use a monospaced font. Export a few documents as a test. Then, if necessary, adjust the column width settings in the view before you perform the whole export.

To display or edit the contents of a view in a Notes document, export the view to a tabular text file. Then import the tabular text file into a Notes document.

Exporting to a structured text file

Structured text is ASCII text that retains its structure in fields and values. Exporting a view to structured text creates a file containing the text of all the documents in the view, minus any rich text attributes.

To export a view

1. Select the database and open the view you want to export.

2. (Optional) Select specific documents to export only a subset of the view.

3. Choose File - Export.

4. Select the file format you're exporting to.

5. Do one of the following:

6. Click Export.

7. If you selected an existing file, do one of the following:

8. Click "All documents" unless you selected specific documents in Step 2.

9. (Optional, for comma separated value format) Select an export character set.

10. (Optional, for 1-2-3 worksheet or tabular text formats) Select "Include View titles" to export the view's column headings to a worksheet or tabular text file.

11. (Optional, for structured text format) Change the inter-document delimiter and word-wrap settings if you are exporting to a structured text file.

12. Click OK.

Delimiter and word wrap settings


See Also