How to Use DataImport Masks on the iSeries Apache

 

Configuring the PC web service

1.  Install .NET 1.1 and 2.0.
2. Download and install the Apache 2.0.x Web Server on your Windows PC.  The version on the RJS web site is 2.0.59 .
3. Install the Apache mod_aspdotnet .Net plugin on your Windows PC.
4. Install the Visual Basic 5.0 Runtime Files.
5. Download the DataImport components and unzip them to C:\WINDOWS\system32.
6. Download DataImport.
7. Register the ActiveX components by running the following BAT file from a Windows command line: 

   C:\WINDOWS\system32\regdiw.bat
    

8. Create the directories C:\RJSTEMP and C:\DI6 if they do not already exist.
9. Unzip the DataImport Web Service to C:\Program Files\Apache Group\Apache2\htdocs.

   Note: web.config should require no modifications. The site will need to be registered as an ASP.NET 2.0 application.
    

10. Add the following entries to the end of the C:\Program Files\Apache Group\Apache2\conf\httpd.conf file:
    #---------------------------------------------------------------------------
    # ASP.Net Functionality Enablement
    #
    #---------------------------------------------------------------------------
    LoadModule aspdotnet_module "modules/mod_aspdotnet.so" 
     
    AddHandler asp.net asax ascx ashx asmx aspx axd config cs csproj licx rem resources resx soap vb vbproj vsdisco webinfo 
     
     
     
    #---------------------------------------------------------------------------
    # Mount the ASP.NET /asp application 
    #---------------------------------------------------------------------------
    AspNetMount /RJSDIWServer "C:\inetpub\wwwroot\RJSDIWServer" 
    #---------------------------------------------------------------------------
    #/SampleASP is the alias name for asp.net to execute 
    #"c:/SampleASP" is the actual execution of files/folders  in that location 
    #---------------------------------------------------------------------------
     
    #---------------------------------------------------------------------------
    # Map all requests for /asp to the application files 
    #---------------------------------------------------------------------------
    Alias /RJSDIWServer "C:\inetpub\wwwroot\RJSDIWServer"
    #---------------------------------------------------------------------------
    #maps /RJSDIWServer request to "C:\inetpub\wwwroot\RJSDIWServer" 
    #now to get to the /RJSDIWServer type http://localhost/RJSDIWServer
    #It'll redirect http://localhost/SampleASP to "C:\inetpub\wwwroot\RJSDIWServer"
    #---------------------------------------------------------------------------
     
    #---------------------------------------------------------------------------
    # Allow asp.net scripts to be executed in the /RJSDIWServer
    #---------------------------------------------------------------------------
    <Directory "C:\inetpub\wwwroot\RJSDIWServer">  
     Options FollowSymlinks ExecCGI 
     Order allow,deny 
     Allow from all 
     DirectoryIndex index.htm index.aspx 
    #default the index page to .htm and .aspx 
     
     
    #---------------------------------------------------------------------------
    # For all virtual ASP.NET webs, we need the aspnet_client files 
    # to serve the client-side helper scripts. 
    # Set up an alias match to the .Net Runtimes
    #---------------------------------------------------------------------------
    AliasMatch /aspnet_client/system_web/(\d+)_(\d+)_(\d+)_(\d+)/(.*) "C:/Windows/Microsoft.NET/Framework/v$1.$2.$3/ASP.NETClientFiles/$4" 
    <Directory "C:/Windows/Microsoft.NET/Framework/v*/ASP.NETClientFiles"> 
     Options FollowSymlinks 
     Order allow,deny 
     Allow from all 
     
     
     
     
    #---------------------------------------------------------------------------
    #
    #---------------------------------------------------------------------------
     
11. Test web service with following URL: http://localhost/RJSDIWServer/DIWMergeForm.aspx. It will prompt for missing parameters.

Configuring the iSeries

1. Configure RJSCONVERT to point to the web service by updating the DIWRMTSVR data area. The following is sn example command, assuming that the web service is at the IP address 1.1.1.1 and is using port 1080:

   CHGDTAARA DTAARA(RJSCONVERT/DIWRMTSVR) VALUE(http://1.1.1.1:1080)
    

2. License the Native DataImport Converter (requires the licenses for both the Native Text to PRN/TXT and the Native DataImport Report Converters).
3. Create a directory on the IFS to store DataImport mask files. The DataImport masks must be stored on the IFS. This article will  use the IFS path '/rjsdiw' as the mask directory for the remaining examples.

   If you want to share the /rjsdiw folder so that it's more readily accessed from PCs, use the following command:

   ADDIFSSHR SHARENAME(RJSDIW) ACTION(*ADD) PATHNAME('/rjsdiw') PERMISSION(*READWRITE) MAXUSERS(*NOMAX)
    

4. Test the CPYSPLDIW command.

   Sample syntax: CPYSPLDIW FILE(SPOOL) JOB(000000/USER/JOB) SPLNBR(1) FILNAM('/RJSTEMP/REPORT.XLS') MASKNAME('/rjsdiw/invoices.msk') TRANTYPE(XLS8) MASKLOC(*IFS) RMTSVRURL(*DEFAULT)

Other Notes

• Email Report Server/400

  As of version 2.66, the Email Recipient list now contains options for mask name and output type. Use main output type of DIW to trigger the web service. It will use the DIWRMTSVR data area in the RJSCONVERT library to find the web service. The MAILSPLF command also has DataImport parameters now.
   

• Batch Report Server/400

  As of version 1.58, the Output Queue list now contains options for mask name and output type. Use main output type of DIW to trigger the web service. It will use the DIWRMTSVR data area in the RJSCONVERT library to find the web service. Mask information is on the second detail screen. Currently only BCHMON supports DIW conversion. DataImport capabilities will be added to the BCHSPLF, IMGSPLF and FTPSPLF commands at a later date.