Differences

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

--- pub:formatxtemplates [2018/07/25 17:04] – created kkramer
+++ pub: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 ======
@@ Line 28: / Line 31: @@
 Here is a sample view of a formatted Excel sheet:
+{{:pub:exceltemplate1.jpg?600|}}
+The syntax for assigning of the Field Name I ${xxxx} in which xxxx equals the name of the Mapped Field Name.  For example if the Mapped Field Name is SIDE01001 then you will want to use ${side01001} in your Excel sheet.
-{{:pub:dynamicmacro_imap.jpg?600|}}
-Note: Check box Dynamic macro should be checked if we want to create a dynamic macro (file pcl should be formatted: m + macro name + .pcl
+Once you are done with configuring your excel sheet, you will want to save it as .XLS (not .XLSX).  Keep the name to an 8 Alpha/Numeric name.
-iMap will create pcl file for whole page so we need to locate signature to corresponding position on form.
+Then you can either use Navigator, Filezilla,  FTP, or whatever method you want to use to move the newly created .XLS file to the FORMFMG folder under QDLS on the IBMi.
+Setup the Form Application with Mapped Fields:
+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.\\
+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.\\
+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
+  * XLS File Name: Fill in the name you want to call the XLS file.
+  * Spool Pages in separate sheets: Y/N Y=Yes, for separating into separate sheets within the workbook; N=No, too keep in one sheet.
+  * 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.
-The dynamic macro mapped field requires these settings.
+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.
-  * The mapped field must be a type 5.
-  * The F13 key needs to be pressed to insure that the IFS directory path is correct. This path must then contain the macro file. The default path is  /idocs/macros/signatures. The macro file must be in this directory.
-  * The macro file must be correctly named:  the macro file name must begin with an m. So if the data from the spooled file contains the value FOO, then the macro file must be named mFOO.pcl. This is not case sensitive. Note that greenbar text is frequently uppercase.
 <html><p></html>
@@ Line 48: / Line 86: @@
 ----
-<html>&#091;</html>[[configuredatamap#mapped_field_maintenance | Up To Mapped Field Maintenance ]]<html>&#093;</html>