NAMEEXP ​
Export a set of names from the Names table to an external file in specified format.
Reporting Area(s) ​
Names
Required Parameters ​
None
Optional Parameters ​
- Drive\Directory\Filename for export file (i.e.: "c:\acehold\exprec") default is c:\nameexp.dbf
- Logical .t. include multiple instances of a name, .f. include name only once (default)
- Logical .t. include all records in report, .f. don't include canceled or waitlisted records (default)
- Character expression: field to add to export (i.e.: "rgcrse as courseno")
Example(s) ​
JUSTAFTER('=NAMEEXP()') exports name and address to a dBASE III file in c:\nameexp.dbf
JUSTAFTER('=NAMEEXP("c:\acehold\myfile.dbf")') exports name and address to a dBASE III file in c:\acehold, called myfile.dbf
JUSTAFTER('NAMEEXP("c:\acehold\myfile.xls",.t.,.t.,"rgcrse as courseno")') exports name and address to a Microsoft Excel file called myfile.xls with multiple records for each name including any canceled records, and the number of the course taken.
Notes ​
Fields included are: Salut, Name1, MI, Name3, Title, Firm, Address, Address2, City, State, Zip, Country, Dayphone, Homephone, Faxphone, Email.
You must run this function from a report which has the Name ID field in the cursor (i.e. nmid, rgid, pyid)
If you pass the file name within parameter # 1 with the .xls extension, the function will generate a Microsoft Excel file or pass the file name within parameter # 2 with the .TXT or .CSV extension, the function will generate an ASCII output file.