How Export to ASCII Works
The Sentinel can create Comma Separated Value (CSV), fixed length or Structured Text exports from Notes.
Points to Remember
1. Sentinel creates a CSV format the Notes does not support.
2. Structured text exports are useful for handling large text fields or rich text fields of over 255 bytes. This Export looks similar to a report, and is limited to 80 characters wide before it word wraps.
3. You must list fields for export. Other choices select all fields if none are listed (see Notes to Notes). However, as ASCII file formats are very structured, the Sentinel needs to know what data will be exported.
Sample Uses
1. Use the Structured Export to create a file that a non-ODBC compliant system can read. This format lists every field and its content:
INFOMANNUMBER:00034894
STATUS:OPEN
CLOSEDATE:07/29/94
TIMECLOSED:09:00
CHANGECONTROLNO:1234ABC
END
2. Create a CSV file for an external user or customer, with whom you do not have a direct ODBC connection.
Tips and Techniques
1. Subselect the Notes file for only certain Notes by using a View. This will reduce the Export to only certain records.