Exporting data allows you to extract information to a variety of formats. There are currently four export formats. Although the exported information is the same for each type, the structure changes for each export format type. The formats include the following:
The process for exporting data is essentially the same irrespective of the output format. All information from each selected document will be exported to a specified file on the local workstation and formatted based on the selected export type.
When exporting data, you can only access data visible to your user ID. This means that the data export is tied to the Access Control List (ACL) and roles assigned to you. If you select to export all documents in the view, only those documents that match your authority level will be exported, even if there are more documents in the view than you can see or access.
Follow these steps to export information from a Lotus Notes database to a file or spreadsheet. The steps are basically the same regardless of the output file format.
Select one or more documents by placing a checkmark next to each one in the view or open a specific document.
Select the File > Export menu options to display the Export dialog window. Specify the destination folder in the Save in field, enter the output file name, and pick the export format type (see Figure 18.5).
Figure 18.5. Export data dialog
Be sure to specify a file extension in the file name. Lotus Notes does not automatically append the extension to the file name. Consider using .TXT for text files and .WK4 for Microsoft Excel spreadsheets.
Click the Export button to continue with the export configuration process. At this point, an additional export dialog window will be displayed that will enable you to further refine the format and content to be exported.
From the secondary export configuration dialog, select either All documents to export all documents from the view or Selected documents to only export those checked in the view. To include the column titles from the view, select the Include View titles option. This option will add the view column titles when exporting in Lotus 1-2-3, Comma-Separated Text, or Tabular Text.
Figure 18.6. Settings used to determine which values to export
After all export parameters have been specified, select the OK button to export the selected data to the specified file.
An Introduction to the Lotus Domino Tool Suite
Getting Started with Designer
Navigating the Domino Designer Workspace
Domino Design Elements
An Introduction to Formula Language
An Introduction to LotusScript
Fundamentals of a Notes Application
Reference Library Applications
Design Enhancements Using LotusScript
Design Enhancements Using Formula Language
Miscellaneous Enhancements and Tips for Domino Databases
Application Deployment and Maintenance
Appendix A. Online Project Files and Sample Applications
Appendix B. IBM® Lotus® Notes® and Domino®Whats Next?
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Authors: Mark Elliott
Similar book on Amazon
XPages Portable Command Guide: A Compact Resource to XPages Application Development and the XSP Language
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases