Export Functions
The following report functions allow you to export selected data from various tables.
CAT2XML - used in a JUSTAFTER to export Catalog data into an XML file.
COPY2XLS - used in a JUSTAFTER to copy fields from a report into an Excel file.
DBXTRACT - export records associated with courses in cursor to an external location.
FIRMEXP - export a set of firms from FIRM table in a specified format.
MEMOEXP - exports all fields in a report cursor, including memo field contents, into a text file. Note: will not preserve line breaks in memo fields.
NAMEEXP - Exports name information for all individuals in report. The data is exported after the report runs.
PREFEXP - Exports name information with preferred address information for all individuals in report. The data is exported after the report runs.
COPY TO Command
You can use the COPY TO command in a JUSTAFTER to set specific fields to export. E.g.
JUSTAFTER("Copy fields cocrse,cocrsenm,cobegdate,coenrolled to c:\acehold\courses.xls XLS") - exports the course code, title, begin date, and enrollment count to an EXCEL file called courses.xls and saves it in c:\acehold.
JUSTAFTER("Copy fields cocrse,cocrsenm,cobegdate,coenrolled to c:\acehold\courses.csv CSV") - exports the course code, title, begin date, and enrollment count to an CSV file called courses.csv and saves it in c:\acehold.
JUSTAFTER("Copy to putfile('Enter File Name','','XLS') XLS") - exports all fields in the cursor to an EXCEL file, letting the user specify the file name and location.
Notes
- Fields must be native to the report cursor (can't be memory variables or data displayed in report using a report function).