DEADDUMP
Used in a JUSTDOIT to replace the report cursor with a specific data set (see Notes section for fields) and allow exporting to a file. This basically returns an abbreviated set of fields from the default "Deadbeat" report.
Reporting Area(s)
Deadbeat
Required Parameters
None
Optional Parameters
- Sort Order for output. Enter Field name(s) separated by commas (e.g. "cobegdate,cocrse"). Defaults to nmname3,nmname1.
- Additional Fields list. May list field individually (e.g. “NMINC” ) or add field with an alternate name (e.g. "loccounty as County"). Can also use Functions for special formatting. (you may add multiple fields by separating them with commas)
- Target Drive/Path/Filename where file is to be written. If none is specified, a “Save As” dialog box allows you to specify the location and file name.
- Character string to set type of export file. Options are: 'CSV', 'FOXPLUS', 'SDF', 'DELI', 'XLSX', and 'XML'. (Defaults to 'XLS'.)
Example(s)
JUSTDOIT("deaddump()") Replaces Cursor with new data set and allows exporting to Excel.
JUSTDOIT("deaddump('COCRSE')") Replaces Cursor with new data set in Course Code order and allows export to Excel.
JUSTDOIT("deaddump(,'cdow(cobegdate) as BeginDay'))") Replaces Cursor with new data and adds the character value of the day the course starts as BeginDay column and allows Export to Excel.
JUSTDOIT(" =deaddump(,,'c:\Rosters\Myroster') " ) ))") Replaces Cursor with new and allows Export to Excel with default destination folder as C:\Rosters\ and target file name as ‘Myroster’. NOTE: you may just list target drive/folder.. ie: ‘C:\Rosters\’
JUSTDOIT("deaddump(,,,'CSV’)") Allows export to CSV.
Notes
These are the fields exported:
Cocrse
Cocrsnm
Cobegdate
Coenddate
Loclocat
NMID
Nmsalut
Nmname1
Nmname2
Nmname3
Nmsuff
Nmbadge
Nmtitle
Nmfirm
Nmaddr1
Nmaddr2
Nmcity
Nmstate
Nmzip
Nmcounty
Nmcntry
Nmdphone
Nmhphone
Nmcellph
Nmfphone
Nmemail
Nmcode1
Nmcode2
Nmmembnum
Nmchar1
Nmedlevel
Nmbirth
Nmsex
Nmethnic
Nmorg
Nmocc
Nmspec
Rgaddate
Rgregnote
Rgfeedesc
Rgcrsefee
RgCEUS
Rghours
Rgcredit
Rggrade
Rgptcert
Rgcomplete
Rgcancel
Rgwaitlist
Rgstatus
Rgcode
Rgmisc
Due
Paid
All NameUDFs fields
All RegUDFs fields