This is an old revision of the document!
Table of Contents
[ Up To Main Menu ]
Configure Data Mapping
Mapping is normally done with iMap, the GUI mapping tool. This section discussed mapping using the green screen.
Selecting the Spool File
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
Selecting the Spool File Page
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=PreviousThe purpose of this display is to select the spool file page with which to map. One should page down until the spool file page with the most representative data appears. Then, position the cursor over the page and press <enter> to select.
Creating Mapped Fields
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.
Mapped Field Maintenance
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 PathThe Mapped Field Maintenance screen appears after the second pressing of F8 to mark the end of the mapped field. Use it to fully specify or change the properties of a mapped field defined through green screen mapping or iMap GUI mapper.
- 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.
- 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 ]