Append and Overwrite functionality is also supported for the export process for search results.
If your user code profile includes the export authorization code, this option allows you to examine FACTS search results in an Excel spreadsheet, or you can export search results to a flat file so they can be used in other programs, such as word processors, contact managers, etc.
Note: You must open the Excel program before exporting a search to Excel.
To export search results to Excel:
1. Open a search.
2. Use the Go To and Filter fields to locate the information you want.
3. Once you have the desired information in the browser, select Export-->To Excel. FACTS automatically formats the results and sets up column headers.
To export search results to a flat file (ASCII):
1. Open a search.
2. Use the Go To and Filter fields to locate the information you want.
3. Once you have the desired information in the browser, select Export-->To Flat File.
4. Name the flat file. You do not have to enter the .txt extension to the file name; it will be added automatically.
FACTS saves the flat files to ssi7\fileprt by default. To save the file to another drive and directory, specify the path in front of the file name.
Example: C:\My Documents\myflatfile.
Append and Overwrite functionality is also supported for the export process for search results.