User Tools

Site Tools


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
Last revisionBoth sides next revision
pub:formatxtemplates [2018/07/25 17:24] kkramerpub:formatxtemplates [2018/08/16 11:50] kkramer
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 83: Line 86:
 ---- ----
  
-<html>&#091;</html>[[configuredatamap#mapped_field_maintenance | Up To Mapped Field Maintenance ]]<html>&#093;</html> 
  
pub/formatxtemplates.txt · Last modified: 2022/06/25 17:02 by 127.0.0.1