@@37 Exporting data to external programs

If data from a report in M3 SWB has to be handled by an external program, you can export from the report directly to the program concerned. This applies to the following reports in M3 SWB:
  • Work center schedule
  • Load profile
  • Load report
  • Order analysis

To be able to export data to external programs, you must specify a function for each relevant panel in the panel files.

For example, to export data from the Order Analysis report (PMDSCH__.SKM) to an Excel spreadsheet in a panel file, you must specify the @@37 function for the panel that contains data definition information applicable to the relevant list box. To clarify this process, the example below shows the procedure in detail (using panel #82).

Syntax

@@37;%PMSIMDIR%\CONTROL\PMEXPO.FID;DSCH;%DATA\PMDSCH.TXT;START_K:\MSOffice\EXCEL.EXE

Function

Defines path and file name for the data file

Example

#80;1;-1;-2;-3;01;00;79;

@@28;SWT;5;28;100;4;180;Order_Export;

@@33;COHEAD00;CRPORT00;

@@24;\OK;1;7;?0;-2;;PNPF3;T;F3;

@@24;\Help;1;7;?0;-2;;PH;

_

____$\OK______$\Help__&

#81;1;-1;-2;-3;01;00;79;

_

#82;1;-1;-2;-3;01;00;79;

@@37;%MOVEXDIR%\CONTROL\PMEXPO.FID;DSCH;%DATA%\PMDSCH.TXT;START_K:\MSOffice\EXCEL.EXE_/R_C:\MVXAPP11\CONTROL\PMMADSCH.XLS
Note: A macro configuration, which is user-defined, automatically starts Excel but the actual transfer of data occurs manually. If you want help in configuring special functions and macros, contact your implementation consultant at Infor.