inFORM Decisions Information Portal

User Tools

Site Tools

Trace:
pub:smartrouting
no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


Next revision
—pub:smartrouting [2018/05/24 16:06] – external edit 127.0.0.1
Line 1: Line 1:
 +
 +<html>&#091;</html>[[start | Return to Table of Contents]]<html>&#093;</html>
 +
 +====== Smart Routing ======
 +
 +=====  Overview =====
 +
 +Smart Routing is a set of features in iDocs that permits the automatic routing of merged documents to Email, Fax or Print. It is implemented in two basic ways:
 +
 +  - The routing information can be retrieved from a database using spool file information as the database key, or
 +  - The routing information can be scraped directly from the spool file.
 +
 +===== Smart  Routing Using a Database =====
 +
 +The first step is to [[configuredatamap | create a mapped field ]] that contains the database key value. This for example might be a customer number if you are using a customer database file.  From the main InFORM Decisions menu, take option one, Define a form or Check Application.  Locate the form application and  place a two next to the application. Next locate a sample spool file and select this spool file with an option one and press enter twice.
 +
 +
 +
 +At this point, the left column of the screen should display the corresponding lines numbers of the spool file. Additionally the key value, such as the customer number, should be in full view. If the value is not in full view, the display screen may be shifted right by using the shift F8 key.
 +
 +
 +
 +With the key value in full view, position the cursor in the leftmost position of the value and press the F8 key. Next, place the cursor in the rightmost position of the key value and press the F8 key again. This will display the Map Field Maintenance screen.
 +
 +<html><pre>
 +  5/11/07                     iDocs Form Suite                        FM2540S2  
 + 10:26:08                    Map Field Maintenance                    QSECOFR   
 +                                                                                
 +  Form Name. . . . . . DEMOINV       Field Name . . . MYSMARTKEY F4=List        
 +                                     Description. . . Smart Routing Key         
 +Spooled File Source                                                             
 +  From Row . . . . . . 1             To Row . . . . . . .  1                   
 +  From Column  . . . . 1             To Column  . . . . .  10                   
 +                                                                                
 +Overlay Target                                                                  
 +  Horizontal Position. 9998  300dpi  Vertical Position. .  9998   300dpi        
 +  Map Field  . . . . .       F4=List Map Type . . . . . .  2 F4=List  XY Mapping
 +  Font . . . . . . . .       F4=List Courier 11cpi Regular                      
 +  Line Spacing . . . .       300dpi  Font Rotation. . . .       90° 180° 270°   
 +  Form Side. . . . . .       F4=List Non duplex field                           
 +                                                                                
 +</pre></html>
 +
 +Complete the field prompt by entering a field name and description. Choose any meaningful name for the mapped field – do not use a 
 +keyword from the F4 prompt. Enter 9998 for both horizontal and vertical positions so the data does not print on the output page – those coordinates are off the pcl page.
 +
 +<html><pre>
 +Conditionally map                                                              
 +  If the value in column       to column                                       
 +  Map next field end                 Bursting. . . . . .   Y  (Y/N)            
 +  of this field . . .   N  (Y/N)                                               
 +  Sort Sequence . . . .  1 F4=List                                             
 +</pre></html>
 +
 +
 +Secondly, specify a sort sequence.  You should specify a sort sequence if you wish to group pages to one target into one transmission. For example, if you are emailing based on customer number you probably want to group all pages to a particular customer into one attachment and send the customer one email. Odd sort sequences sort in ascending order, even sequences sort in descending order.
 +
 +Bursting should be set to Y.  This will create a new document and thus a separate transmission, email fax or print, to the target.  If you do not burst then each input spool file will generate one output transmission to the target found **on the first page only** of the document.
 +
 +The normal procedure is to sort and burst on this field.
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +===== Database Definition for Email =====
 +
 +Smart Routing considers output targets in this order: Email, Fax, Print. Any output method not defined will be skipped. The first method defined that successfully resolves a target destination such as an email address or fax number will be selected. If you need to handle customer preference as to delivery method use logical files to present to the Smart Routing application only one deliver method.
 +
 +From the Form definition maintenance screen navigate back to the form application and place an option 14 next to the entry. Option 14 will be labeled External Database on versions older than 3.69d and Smart Routing on younger versions.
 +
 +<html><pre>
 + 5/11/07                     iDocs Form Suite                        FM1200S1  
 +10:32:03                    iMail Document Routing                   QSECOFR   
 +                                                                               
 +Type information, press Enter.                                                 
 +                                                                               
 +  Application: DEMOINV    DEMO. INVOICE FORM                                   
 +                                                                               
 +  File Name . . . : ROUTINGDB                                                  
 +    Library . . . :   CUSTOMER                                                 
 +  Member Name . . : *FIRST                                                     
 +                                                                               
 +                                                                               
 +  Prefix to key (if necessary) . . . . . :                                     
 +  Map field data to use as key . . . . . : MYSMARTKEY                          
 +                                                                               
 +  String to return as *TOADDRESS . . . . : From Col: 10    To Col: 137         
 +                                                                               
 +  Outq to receive file if *TOADDRESS not valid . . :  BADOUTQ               
 +                                                                               
 +</pre></html>
 +
 + At this screen specify the file name and library of the database file containing the Smart Routing address information, such as email addresses and fax number.  In the field specifying the Map field data to use as key, enter the name of the mapped field defined to contain the database key earlier in this document. In this example, MYSMARTKEY contains a value from the spool file to look up into CUSTOMER/ROUTINGDB. 
 +
 +The next prompt identifies the location of the email address within the customer record. In the example above, the email address within the customer record begins in position 10 and ends in position 137 for a size of 128 characters. Please note that this is in bytes and is considered from the beginning of the record. It does not refer to fields in the database.
 +
 +The last field specifies the location where the output spool files should be placed if the email address can not be retrieved, i.e. the lookup on the database using the specified key fails. If the lookup succeeds but the address is not deliverable, the email is sent to the email server which handles it separately - examine the inbox of the sender's email address on the email server. Email undeliverable at the server is not returned to iMail/iDocs. If the address lookup succeeds but the email server rejects the send, examine the iMail log.
 +
 +Please note that in iDocs 5.0 and subsequent versions the address failure outqueue must be specified separately using option 18 from the [[defineform | main form list]] (subfile).
 +
 +
 +===== Email Defaults =====
 +
 +From the iMAIL external routing screen the delivery parameters were specified for the recipient, but not the sender, subject and message body. These values can be specified by pressing the F6 key to specify the email default values.
 +
 +<html><pre>
 +  03/11/11                     iDocs Form Suite                        FM1200S3  
 + 10:34:51                    iMail Document Routing                   QSECOFR   
 +                                                                                
 + Type information, press Enter.                                                 
 +                                                                                
 +   Application: DEMOINV    DEMO. INVOICE FORM                                   
 +                                                                                
 +  From:     defaultfrom@informdecisons.com                                      
 +  To:       info@informdecisions.com                                           
 +  Subject:  Default Subject                                                     
 +                                                                                
 +  Message Default Line 1                                                        
 +  Message Default Line 2                                                        
 +  Message Default Line 3                                                        
 +  Message Default Line 4                                                        
 +  Message Default Line 5                                                        
 +  Message Default Line 6                                                        
 +  Message Default Line 7                                                        
 +                                                          
 +                                                                                
 +                                                                                
 +                                                                                
 + F3=Exit   F10=Update   F12=Cancel                                              
 +</pre></html>
 +
 +From this screen, enter the default from address, subject and associated text. Press the F10 key to save the values and return back to the form definition maintenance.
 +
 +Note that one does not have to specify a default to address – that is determined as part of the Smart Routing processing. If you do not specify a default from address then the default contained in the iMail configuration will be used.
 +
 +
 +
 +===== Database Definition for Fax =====
 +
 +Navigate back to the form application and reselect it with an option 14. Press the F7 key to define the FAX directives. The screen below should be displayed.
 +
 +<html><pre>
 +  5/11/07                     iDocs Form Suite                        FM1200S2  
 + 10:41:27                    iFAX Document Routing                    QSECOFR   
 +                                                                                
 + Type information, press Enter.                                                 
 +                                                                                
 +   Application: DEMOINV    DEMO. INVOICE FORM                                   
 +                                                                                
 +   File Name . . . : ROUTINGDB                                                  
 +     Library . . . :   CUSTOMER                                                 
 +   Member Name . . : *FIRST                                                     
 +                                                                                
 +                                                                                
 +   Prefix to key (if necessary) . . . . . :                                     
 +   Map field data to use as key . . . . . : MYSMARTKEY                          
 +                                                                                
 +   String to return as Company Name . . . : From Col: 129   To Col: 158         
 +   String to return as Contact  . . . . . : From Col: 212   To Col: 231            
 +   String to return as Fax# . . . . . . . : From Col: 159   To Col: 168         
 +                                                                                
 +   Outq to receive file if Fax# not valid . . . . . :  BADFAX                  
 +                                                                                
 +                                                                                
 + F3=Exit   F6=Fax Default Values   F7=Email   F10=Update   F11=Print  F12=Cancel
 +</pre></html>
 +
 +The first five prompts for faxing should contain the same values for emailing. However if the fax number and email  addresses are contained in different databases, these databases can be defined separately.
 +
 +As specified previously for email, define the beginning and ending columns for the fax recipient’s company name, contact and fax number.
 +
 +Finally in the last prompt on the screen specify the name of the out queue that will be used to collect spool files intended to be faxed, but resulted in not being faxed due to an invalid fax number. 
 +
 +If doing only Fax Smart Routing and not also email, use ***FAX** for the distribution outqueue in the form definition and *FORMDEF in the engine or manual merge.
 +
 +===== Fax  Defaults =====
 +
 +Once all the values have been identified, press the F6 key to define the fax default values.
 +
 +<html><pre>
 + 5/11/07                     iDocs Form Suite                        FM1200S4  
 +10:39:19                    iFAX Document Routing                    QSECOFR   
 +                                                                               
 +Type information, press Enter.                                                 
 +                                                                               
 +  Application: DEMOINV    DEMO. INVOICE FORM                                   
 +                                                                               
 +       Cover Page  : *DEFAULT                                                  
 +       Fax Line  . : *DEFAULT                                                  
 +                                                                               
 +  From Company . . : inFORM Decisions                                          
 +       Contact . . : Davis Yokana                                              
 +       Phone#  . . : 949.709.5838                                              
 +       Fax#  . . . : 949.709.5839                                              
 +       Subject . . : Company Newsletter                                        
 +       Message . . : Thank you for subscribing to our company newslette        
 +                     r.                                                        
 +                                                                               
 +    To Company . . :                                                           
 +       Contact . . :                                                           
 +       Fax#  . . . :                                                           
 +                                                                               
 +F3=Exit   F10=Update   F12=Cancel                                              
 +</pre></html>
 +
 +From this screen specify the default cover page from within iFAX fax or override the default value. 
 +
 +
 +
 +The prompt for the Fax line specifies the default  fax telephone line with that will be used to send the fax transmissions.
 +
 +The remaining entries for the from and to prompts will be used to populate the cover page with the correct inFORM Decisions of the sender and the recipient.
 +
 +Press the F10 key to save this inFORM Decisions, and return to the Form Definition Maintenance Screen.
 +
 +
 +===== Specifying the Out Queue =====
 +
 +
 +
 +From the Work With Form Applications subfile (list), scroll to the form application and place a 1 next to the entry.
 +
 +<html><pre>
 +  5/11/07                     iDocs Form Suite                        FM0465C3  
 + 10:43:18                Define a Form Application                    QSECOFR   
 +                                                                                
 + Form  Application. . . . . .  DEMOINV    DEMO. INVOICE FORM                    
 + Form  Size . . . . . . . . .      2  Letter(8 1/2 x 11 in.)             F4=List
 + Collate(Y/N). . . . . . . . . . . N     Use Mapped Fields Only (Y/N). . . Y    
 + Orient (P)ortrait or (L)andscape. P     Pages per Overlay (1-9) . . . . . 1    
 + Front Map File. :               F4=List Back Map File . . :             F4=List
 + X adjustment value. . . . . . . .   0   Y adjustment value. . . . . . . .   0  
 +                                                                                
 +                                                                                
 +                                                                                
 +                                                                                
 + Front Side                     Back Side               Form       Destination  
 + Overlay   Seq  Drawer  Merge   Overlay           Merge Prompt     Out Queue    
 + F4=List    #   F4=List Data    F4=List   Tumble  Data  F4=List    F4=List      
 + DEMOINV     1      1     Y                             *STD       *EMAILPDF    
 +                                                                                
 +                                                                                
 +                                                                              + 
 +                                                                                
 + F1=Help  F2=Data Map   F3=Exit  F7=Footer      F8=Work with Mapped  Fields     
 + F9=Advanced Functions  F12=Cancel   F15=Global Offset   F17=Import Map         
 +</pre></html>
 +
 +In the prompt for the Distribution Out Queue enter the key word value of either ***EMAILPDF** to process the distribution of the spool files in a PDF format, ***EMAILPCL** to process the distribution of the spool files in a PCL format.
 +
 +Note that despite the keyword value being misleading and contrary to the alternative delivery methods, that if emailing is not an available option for the spool file, the alternate methods will be used.
 +
 +===== Engine Definition =====
 +
 +From the InFORM Decisions main menu, select option 4, Work with Engines. Select an existing engine, or create a new one dedicated to Smart Routing.
 +
 +<html><pre>
 + 5/11/07                      iDocs Form Suite                       FM0450C3  
 +10:45:35                Engine Definition Maintenance                QSECOFR   
 +                                                                               
 +Engine Name. . . . . . : DQENGINE   Description. . : A Dataqueue Engine        
 +Archive Out Queue. . . : ARCHIVE    Archive Library: QUSRSYS       F4=List     
 +Data Queue . . . . . . : DQENGINE   Dataque Library: QGPL                      
 +Engine Status. . . . . :                                                       
 +                                                                               
 +       Originating        Spool     Spool      Form       Resulting  Resulting 
 +Prc Out Queue  Library    Attribute Attribute  App        SpoolFile  Out Queue 
 +Grp      F4=List          F4=List   Value      F4=List    Name        F4=List  
 +    QPRINT     *LIBL      *FORM    INVOICE    JCAINVOICE            *FORMDEF   
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                               
 +                                                                       More... 
 +F3=Exit   F4=Prompt  F7=Server View                  F12=Previous  F21=Command 
 +Press Enter to confirm                                                         
 +</pre></html>
 +
 +Changing the Destination Out Queue value to *FORMDEF specifies that the resulting spool file will be directed as it is defined in the form application. 
 +
 +In this example the form application named, JCAINV, has defined within it *EMAILPDF in the distribution override out queue.
 +
 +After changing this value within the engine definition, the engine is ready to be submitted to batch and to process smart routing accordingly.
 +
 +====== Smart Routing Using Spool File Information ======
 +
 +The other way to use Smart Routing is to scrape the destination information directly from the spool file. Of course the information has to be in the spool file to scraped. Email addresses and fax numbers usually are not included in end user documents, but if they are this might be the simplest way to setup Smart Routing.
 +
 +
 +
 +The procedure is to create a form application as one normally would, and then in addition to the mapping for the output create additional mapped fields as discussed below.  Please note that using this method one should not define databases uses option 14. One merely creates specific mapped fields to contain the necessary information from the spool file. 
 +
 +
 +
 +
 +
 +
 + ===== iMail =====
 +
 +
 +
 +For email routing, create mapped fields named using the following keywords containing the specified information.
 +
 +
 +
 +<html><table><tr><td></html>
 +
 +***FRADDRESS** – iMail from address.
 +
 +<html></td></tr><tr><td></html>
 +
 +***TOADDRESS** – iMail recipient address
 +
 +<html></td></tr><tr><td></html>
 +
 +***CCADDRESS** – iMail recipient address to copy
 +
 +<html></td></tr><tr><td></html>
 +
 +***BCADDRESS** – iMail recipient address to blind copy
 +
 +<html></td></tr><tr><td></html>
 +
 +***SUBJECT** -    iMail Subject
 +
 +<html></td></tr><tr><td></html>           
 +
 +***SUB0120 ** - iMail Subject 1 through 20
 +
 +<html></td></tr><tr><td></html>
 +
 +***SUB2140** - iMail Subject 21 through 40
 +
 +<html></td></tr><tr><td></html>
 +
 +***MESSAGE** - iMail Message     
 +
 +<html></td></tr><tr><td></html>
 +
 +***MSG01** -  **09** - iMail Message lines 1 through 9
 +
 +<html></td></tr></table></html>
 +
 +
 +
 +You can prompt the field name in the greenscreen mapped field screen, scroll through the possible keyword values, and select one of the above.
 +
 +
 +
 +To successfully define a Smart Routing email application from the above keywords as mapped fields you must define at a minimum *TOADDRESS.
 +
 +In the form application definition the destination outqueue is *EMAILPDF. The destination outqueue in the engine is *FORMDEF.
 +
 +**Note on Subject Line:**
 +
 +You can create a “dynamic” subject line in your EMAIL that will contain information mapped from your spoolfile.  The extracted data can be the entire subject line or appended to a literal value that was typed into the default Subject Line.  Use keywords *SUB0120 and *SUB2140 as the field names for the mapped fields that reference the data to be extracted.  Both keywords allow for a maximum 20 Alpha mapped value.  The value in *SUB0120 will be trimmed and appended to the subject literal value with a blank space prefix.  If *SUB2140 is used, the trimmed value will be appended to the trimmed value of *SUB0120 with a blank space prefix.
 +
 +  * The *SUBJECT keyword replaces the default subject line defined in Smart Routing. 
 +  * The *SUB0120 and *SUB2140 keywords append to the default Smart Routing subject.
 +  * Each allows up to 20 characters and can be used together, but *SUB0120 must be defined before using *SUB2140.
 +
 +Example:
 +<html> <pre>
 +                                        From     To       Map                       
 +Fld Name      Description            Row Col Row Col  Type  Fld    Xloc    Yloc 
 +*SUB0120   Subject cols 1 - 20         3  30   3  49   2           9999    9998 
 +*SUB2140   Subject cols 21 - 40        4  30   4  49   2           9998    9998 
 +</pre> </html> 
 +Subject: Default Message +First mapped field+ +Second field+
 +                  Email subject default = 'Default Message'  
 +                  First mapped field (*SUB0120) = '+First mapped field+' (20 character max)
 +                  Second mapped field (*SUB2140) = '+Second field+' (20 character max) 
 +
 +
 +===== iFax =====
 +
 +
 +
 +The iFax interface to mapped field Smart Routing is identical to that of iMail. The keywords used to name the mapped fields are different. They are:
 +
 +
 +
 +<html><table><tr><td></html>
 +
 +***FAXNBR** -      iFAX FAX Number  
 +
 +<html></td></tr><tr><td></html>    
 +
 +***FAXDESC** -    iFAX FAX Description
 +
 +<html></td></tr><tr><td></html>
 +
 +***FAXNBRUSR** -  iFAX FAX Number User Data   
 +
 +<html></td></tr><tr><td></html>
 +
 +***FAXTO** -      iFAX FAX Recipient          
 +
 +<html></td></tr></table></html>
 +
 +
 +
 +To define an iFax Smart Routing application using this method one must define at a minimum *FAXNBR.
 +
 +
 +
 +In the form application the destination outqueue is *FAX; in the engine it is *FORMDEF.
 +
 +
 +
 +===== Print =====
 +
 +
 +
 +To define print as the Smart Routing destination define a mapped field with field name:
 +
 +
 +
 +***OUTQ** -      iDocs Out Queue   
 +
 +
 +
 +The contents of the mapped field will be evaluated and its contents used to specify the destination outqueue of the resulting merged document.  The captured value used as an outqueue will override the destination outqueue specified in the form and/or engine.
 +
 +The output outqueue in the form definition is specified as *PRINT.
 +
 +
 +You can also define mapped fields to capture:
 +
 +
 +
 +<html><table><tr><td></html>
 +
 +***TRAY** - iDocs Input Tray 
 +
 +<html></td></tr><tr><td></html>
 +
 +***BIN** -        iDocs Output Bin
 +
 +<html></td></tr></table></html>
 +
 +
 +----
 +<html>&#091;</html>[[start | Return to Table of Contents]]<html>&#093;</html>
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
  
pub/smartrouting.txt · Last modified: 2022/06/25 17:02 by 127.0.0.1