Configure Data Mapping

Mapping is normally done with iMap, the GUI mapping tool. This section discussed mapping using the green screen.

There are many ways to launch mapping; the most basic is to go to menu IDOCS, take option 1, and the select option 2 on the form application or check for which you wish to map. The Data Mapping with Spool File screen is display.

                    Data Mapping with Spool File (DATAMAPSP)                    
                                                                                
 Type choices, press Enter.                                                     
                                                                                
 iDocs Form Application . . . . . > '   AAAMCOR'  Character value               
 User ID  . . . . . . . . . . . .   *CURRENT      Name, generic*, *CURRENT...   
 Form Type  . . . . . . . . . . .   *ALL          Name, *ALL                    
 User Data  . . . . . . . . . . .   *ALL          Name, generic*, *ALL          
 Output Queue . . . . . . . . . .   *ALL          Name, *ALL                    
   Library  . . . . . . . . . . .                 Name, *LIBL                   
 Job Name . . . . . . . . . . . .   *ALL          Name, *, *ALL                 
   User Name  . . . . . . . . . .                 Name                          
   Job Number . . . . . . . . . .                 000000-999999                 
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                         Bottom 
 F3=Exit   F4=Prompt   F5=Refresh   F12=Cancel   F13=How to use this display    
 F24=More keys                                                                  
                                                                                

You can now specify the selection criteria of press enter for *CURRENT user. The Work with Spool Files screen is now displayed.

 11/23/20                     iDocs Form Suite                        DATMAPC1  
 10:58:55                    Work with Spooled Files                  KKRAMER   
                                                                                
  1=Select   2=Change   3=Duplicate   4=Delete   5=Display                      
                                                                                
                                                                Total Form      
 Opt File       Job        User       Out Queue  User Data  Sts Pages Type      
     FIVEPAGE   QPADEV002B KKRAMER    FORM001    ALASKARR   RDY     5 *STD      
     L88X132W   QPADEV002B KKRAMER    FORM001    CMST408    RDY    28 T4        
     L99X132W   QPADEV002B KKRAMER    FORM001    CMST4A08   RDY    15 T4A       
     L22X132W   QPADEV002B KKRAMER    FORM001    CMS1099D08 RDY     3 1099D     
     L88X085W   QPADEV002B KKRAMER    FORM001    CMSW208    RDY    85 W2        
     L33X132W   QPADEV002B KKRAMER    FORM001    CMS1099M08 RDY     4 1099M     
     L22X132W   QPADEV0002 KKRAMER    FORM001    CMS1099I08 RDY     3 1099I     
     CMSPO      QPADEV000J KKRAMER    FORM001    REEVESPO   RDY     2 P.O.      
     REEVESCC   QPADEV000J KKRAMER    FORM001    CMSPRSP7   RDY    17 PRCHECK   
     W66X132L   QPADEV000J KKRAMER    FORM001    Swift Stub RDY    37 SWIFTSTUBS
     L42X85W    QPADEV000J KKRAMER    FORM001    SWIFTAPCK  RDY   375 SWIFTCHECK
     L66X132W   QPADEV000J KKRAMER    FORM001    Swift stub RDY     2 SWIFTSTUBS
     L42X85W    QPADEV000J KKRAMER    FORM001    LEONPLASTC RDY   106 *STD    + 
                                                                                
  Record:        13 /       276                                                 
  F3=Exit  F5=Reload  F11=Old view   F12=Previous  F17=Top  F18=Bottom          
                                                                                

After selecting the spool file the spool file is displayed on the screen.

  11/23/20                     iDocs Form Suite                        FM2500C4  
 16:39:48            Data Mapping Definition Maintenance              QSECOFR   
                                                                                
 Position Cursor on map page, Press Enter.                                      
                                                                                
                                                                                
 * * * * * * * * * * * * * * * Spooled File Data * * * * * * * * * * * * * * * *
 ....+... 1 ...+... 2 ...+... 3 ... Page 001 +... 5 ...+... 6 ...+... 7 ...+... 
                                                                 177925  12/31/9
                                  ST LOUIS, MO                                  
              5409                                        5408                  
        ACME COMPANY                                ACME COMPANY                
        5555 CHARLESTOWN IND. DR.                   5555 CHARLESTOWN IND. DR.   
        ST CHARLES      MO  92618                   ST CHARLES      MO  92618   
                            CUSTOMER PICK UP                      X           14
         00-626-4675        CUSTOMER PICK UP                                    
   7002                          130        2     46#       130   2.40000      3
 LARGE LIGHT BEZEL         98479                                                
   7023                            0        2     30#       160   1.26000      2
 SMALL LIGHT BEZEL         98526                                                
          4              76#                      .00           .00             
                                                                                
 F3=Exit   F12=Previous                                                         
                                                                                

Next appears the selected spool file page ready for you to specify mapped fields.

 11/23/20                     iDocs Form Suite                        FM2500C6  
16:41:59            Data Mapping Definition Maintenance              QSECOFR   
                                                                               
Form: DEMOINV    DEMO. INVOICE FORM                  Begin window Colunm:   1  
                                                                               
Line ....+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 .  
  1                                                                            
  2                                                                            
  3                                                                            
  4                                                                            
  5                                                                            
  6                                                                  177925    
  7                                   ST LOUIS, MO                             
  8               5409                                        5408             
  9         ACME COMPANY                                ACME COMPANY           
 10         5555 CHARLESTOWN IND. DR.                   5555 CHARLESTOWN IND.  
 11         ST CHARLES      MO  92618                   ST CHARLES      MO  9  
 12                             CUSTOMER PICK UP                      X        
 13          00-626-4675        CUSTOMER PICK UP                               
 14    7002                          130        2     46#       130   2.40000  
 15  LARGE LIGHT BEZEL         98479                                           
                                                                       More... 
F3=Exit   F8=Mark Datafield Start   F12=Previous   F19=Left   F20=Right        
                                                                               

To create a mapped field, position the cursor over the start and press F8. Next, move the cursor to the end of the field and press F8 again. The mapped field window (below) appears for you to finish the mapped field definition. When that is complete the program returns to this screen for you to map additional fields. When finished you may press F3 to exit.

Some considerations:

• When marking the end of the mapped field remember to allow for the maximum extent of the field. If the field is potentially 30 characters in length remember to map all 30 characters.
• When mapping number remember to map first the full extent of the number to the left, because numbers usually have leading blanks, and the full extent to the right because numbers may have a trailing negative sign.

 11/24/20                     iDocs Form Suite                        FM2540C1  
 10:22:50              Spooled Datamap Field Maintenance              KKRAMER   
                       Form: OFBURST    Bursting and Separation                 
                                                                                
  1=Select   3=Copy   4=Delete   5=Display                                      
                                                                                
                                      From     To     Map                       
 Sel Fld Name   Description          Row Col Row Col  Type   Fld   Xloc    Yloc 
     *FILENAME  PDF File Name          1   9   1  12   2           9998    9998 
     BLOCK001   Spool Page Number      1  29   1  32   2           1056    1124 
     BLOCK002   CUSTOMER               1  51   1  52   2           9998    9998 
     BLOCK003   INVOICE NUMBER         1   9   1  12   2           1056     808 
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                         Bottom 
                                                                                
 F3=Exit   F6=Add   F7=Font/No Font   F12=Cancel                                

 11/24/20                     iDocs Form Suite                        FM2540S2  
 10:24:22                    Map Field Maintenance                    KKRAMER   
                                                                                
  Form Name. . . . . . OFBURST       Field Name . *FILENAME      F4=List        
                                     Description. PDF File Name                 
                                                                                
  From Row . . . . . .   1           To Row . . . . . . .    1                  
  From Column  . . . .   9           To Column  . . . . .   12                  
                                                                                
Overlay Target                                                                  
  Horizontal Position. 9998  300dpi  Vertical Position. .  9998   300dpi        
  Map Field  . . . . .               Map Type . . . . . .  2 F4=List  XY Mapping
  Font . . . . . . . .       F4=List Courier -NP 10cpi Regular           Align N
  Line Spacing . . . .       300dpi  Font Rotation. . . .       90° 180° 270°   
  Form Side. . . . . .       F4=List Non duplex field                           
  Color . .                  F4=List                                            
  Sort Sequence . . .                Scaling Barcode:                           
  Bursting. . . . . .   N            Height (Inch):      Module Wid(.01"):      
                                     Human Readable Text: Y Y/N                 
                                                                                
                                                                                
 F2=Conditionally Map   F3=Exit   F4=Prompt     F7=Map Field Settings           
 F9=Box Settings       F10=Save  F12=Cancel    F13=Configure Path               
                                                                                

• Field Name: Enter the name for this field, and then enter a description. Alternatively, press F4 and select from the list of keywords for the field name. If you specify a key word you are stipulating to iDocs that the content of this mapped field is used for a particular purpose. See Field Name Key Words for a complete list.
• Horizontal Position: X coordinate position of the top, left of the mapped field. 0 is the left margin. 300 pixels per inch.
• Vertical Position: Y coordinate position of the top, left of the mapped field. 0 Is the top of the page.300 pixels per inch.
• Map Field: Used to reference a mapped field number for mapping created with the Forms Designer in conjuction with Map Type 3. This technique is currently obsolete having been replaced by iMap but is still supported. Normally blank.
• Map Type: Determines the technique that will be used to define and position the field being mapped. The options are:
  2 = Absolute Placement; 3 = Map Field Positioning; 5 = Dynamic Macros ; 6 = Database field retrieval; 7 = CHECK# retrieved from Bank master. 8 = *XLS Header Field; 9 = *XLS Detail Field; 1 = *XLS Total (Footer) Field
• Font: Select a font from the list of LaserJet 4 printer resident fonts by pressing F4.
• Align: Enter an alignment preference or leave blank. Accepted values are blank or 'N' = Neutral; 'C' = Center; 'L' = Left; 'R' = Right; 'G' = General format (6.92). When this field is ‘G’ then if the value is numeric, iDocs will format the numeric value as -134.456 and utilize right alignment.
• Line Spacing: Number of pixels to increase the Y value of the pcl cursor when advancing lines in a multiline mapped field. The usual value is 50 pixels.
• Font Rotation: Enter 90, 180, or 270 to rotate the mapped field. The direction of rotation is counter clockwise.
• Form Side: Enter *NONE for a mapped field on a non-duplex document, *FRONT or *BACK for a duplex document.
• Color: Select a color for data.
• Sort Sequence: Sort sequence used to sort the pages in the input spool file on the value of this mapped field. Odd values specify ascending sequence, even values specify descending sequence. Lower numbers are a higher sort priority. The F4 = Select Sort prompt will display a list of supported sort values. Note that while the sorting field may be of any length, only the first 25 characters of the mapped field are used to sort the spool file. View a video for Bursting and Separation ideas for document automation.
• Bursting: Close the spool file and open a new one if the value in this field has changed from the prior page. Enter a Y for bursting or N (default).
• Scaling Barcode: iBar option for scale-able bar coding available in Version 6.80. (The Human Readable option was added in version 6.85.) The F4 = Scaling Barcode Fonts prompt will display a list of supported Barcode Types. Note: Each bar code must be licensed by entering the appropriate registration code on the Module Registration Screen. Contact your Sales Person for additional information. If Scaling barcodes are being mapped, leave the Font field (above) blank.
• Height (in inches): Specify the height of the scaling bar code in inches. i.e. 1.0 for 1 inch.
• Module Width(.01“): For standard linear bar codes, specify the scaling bar code width of the individual 'bar' width. The actual width is determined by the number of characters represented. The default is 0.01. (One inch is 1.000). Caution, it is not the width of the printed bar code rather the width of each individual bar. For two-dimensional (or matrix square Quick Response barcodes), leave the Height field blank and specify the desired width in inches. Normally the width can be left blank and the default will be used.
• Human Readable Text: Y/N: For Scaling bar codes, Y will display the human readable text below the printed bar code for symbologies that support human readable text. i,e, it will be ignored for QR codes. N will not display the human readable text below the bar code.

• F2=Conditionally Map: Conditionally map data fields.
• F9=Box Settings: Configure boxes around the mapped field text.
• F13=Configure Path : Configure location of dynamic macro files.

[ Up To Main Menu ]