Enrich EMMS Online Help

Download reports  

This process is used when the Download report option has been set to Yes on a report creation screen.

1. Once the report is completed, you must retrieve the file and member names.
   1. At the EMMS main menu, select Administration | Reports | Report Downloads.
      • The Report Downloads screen appears.
   2. Find the particular report you generated in the list and note the File Name and Member Name associated with it.
2. From the computer's START menu, select All Programs | IBM iSeries Access for Windows | Data Transfer From IBM i.
   • The Data Transfer from IBM i screen appears.
3. Fill in the fieldsfields as required.

   System Name is your system name or IP address.

   File Name is the Enrich library name followed by the file name, with the member name in brackets: emmstrain1/ffdacpp(morrison0222).

   Output Device should be set to File.

   File Name is any valid path and filename.xls on your PC. This will only be input-capable after you select File for the Output Device.

4. Click on the Details button.
   • The File Details screen appears.
5. Select Create new file.
6. Fill in the fieldsfields as required.

   File Type should be set to BIFF3 or BIFF4 or BIFF7 or BIFF8 (MS Excel 3-8).

   File Name is any valid path and file name.fdf on your PC.

7. Click OK.
   • You return to the Data Transfer from IBM i screen.
8. Click Transfer data from IBM i.
   • You will be prompted for your user ID and password.
9. Type in your User ID and Password and click OK.
   • This will create the spreadsheet on your PC.

Notes:

• This process creates a flat file with no headers. To determine header descriptions, run a query or SQL statement over the file.
• There is a Screen Preferences business parameter Retain Multi-Mbr (Days) that controls the number of days to save the member. Once a member reaches the maximum number of days, the next time any member is created the system will delete all members greater than the maximum value.

Back to How To