pub:formatxtemplates
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
pub:formatxtemplates [2018/07/25 17:04] – created kkramer | pub:formatxtemplates [2018/07/25 17:39] – kkramer | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | < | ||
+ | |||
+ | |||
====== Create and format Excel Templates ====== | ====== Create and format Excel Templates ====== | ||
Line 28: | Line 32: | ||
Here is a sample view of a formatted Excel sheet: | Here is a sample view of a formatted Excel sheet: | ||
+ | {{: | ||
+ | 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. | ||
- | {{: | + | |
- | 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). |
- | iMap will create pcl file for whole page so we need to locate signature | + | Then you can either use Navigator, Filezilla, |
+ | |||
+ | 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 **[[cnfigdatamap# | ||
+ | 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: | ||
+ | * 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: | ||
+ | < | ||
+ | iDocs XLS Settings | ||
+ | |||
+ | IFS Output Folder: | ||
+ | |||
+ | XLS File Name. . : ABC | ||
+ | |||
+ | Spool pages in separate sheets: | ||
+ | Overwrite | ||
+ | |||
+ | F3=Exit | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | </ | ||
+ | Lastly, for the Destination Out Queue use *EMAILXLS to output as XLS when emailing out. | ||
+ | |||
- | The dynamic macro mapped | + | 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 / | ||
- | * The macro file must be correctly named: | ||
< | < |
pub/formatxtemplates.txt · Last modified: 2022/06/25 17:02 by 127.0.0.1