inFORM Decisions Information Portal

User Tools

Site Tools

Trace:
pub:formatxtemplates

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
pub:formatxtemplates [2018/07/25 17:18] – kkramerpub:formatxtemplates [2022/06/25 17:02] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +<html>&#091;</html>[[start#imail | Up To iMail ]]<html>&#093;</html>
 +
 +
 ====== Create and format Excel Templates ====== ====== Create and format Excel Templates ======
  
Line 41: Line 44:
  
 Setup the Form Application with Mapped Fields: Setup the Form Application with Mapped Fields:
-If you have not create a Form Application already, then at this time you will want to create a Form Application. +If you have not create a Form Application already, then at this time you will want to **[[defineformopt1 |  create a Form Application]]**. 
 Helpful tip: You may want to use iMap to Map the spool file data, and then change the Map Type after you upload to iDocs on the IBMi.\\ Helpful tip: You may want to use iMap to Map the spool file data, and then change the Map Type after you upload to iDocs on the IBMi.\\
-Create the Form Application with the Mapped Fields using one of the three Map Types for *XLS.\\+Create the Form Application with the **[[configuredatamap#mapped_field_maintenance |  Mapped Fields ]]**using one of the three Map Types for *XLS.\\
 Enter the newly created XLS name under the Front Side Overlay field.\\ Enter the newly created XLS name under the Front Side Overlay field.\\
-Within the Form Application select option F6 = XLS Fnc to configure the following:+Within the Form Application select **[[ifsxls |  option F6 = XLS Fnc ]]** to configure the following:
   * IFS Output Folder: If you want to save the output to a directory fill this is with the directory path, otherwise leave blank   * IFS Output Folder: If you want to save the output to a directory fill this is with the directory path, otherwise leave blank
   * XLS File Name: Fill in the name you want to call the XLS file.   * XLS File Name: Fill in the name you want to call the XLS file.
Line 51: Line 54:
   * Overwrite = Y=Yes, for overwriting already exciting files with same name (mainly when saving to directory); N=No, for saving with an appending number.   * Overwrite = Y=Yes, for overwriting already exciting files with same name (mainly when saving to directory); N=No, for saving with an appending number.
  
 +F6 XLS Settings screen: 
 +<html><pre>                                                                         
 +                      iDocs XLS Settings                                   
 +                                                                           
 +  IFS Output Folder:  /idocs/xls                                           
 +                                                                           
 +  XLS File Name. . :  ABC                                                  
 +                                                                           
 +  Spool pages in separate sheets:  Y Y/N                                   
 +  Overwrite  . . . :  Y Y/N                                                
 +                                                                           
 +  F3=Exit   F4=Prompt   F10=Save                                           
 +                                                                           
 +                                                                           
 +
 +
 +
 +
 +</pre></html>
 +Lastly, for the Destination Out Queue  use *EMAILXLS to output as XLS when emailing out.
 + 
 +
 +Testing with iMail when doing a manual merge…
 +When testing, select the Form Application with 15 to merge with a spool file
 +Then select the spool file with option 11 to merge and email
 +When sending the email, change the TYPE field to *XLS to send out as an XLS format.
  
  
Line 57: Line 86:
 ---- ----
  
-<html>&#091;</html>[[configuredatamap#mapped_field_maintenance | Up To Mapped Field Maintenance ]]<html>&#093;</html> 
  
pub/formatxtemplates.1532564287.txt.gz · Last modified: 2022/06/25 17:02 (external edit)