Spooled files in the designer
You can process spooled files in InterFormNG2, if you have installed InterFormNG2 on the IBM i platform.
The spooled file actions related to the designer are:
- How to load a spooled file in the designer.
- How to map spooled file data in the designer.
- How to use attributes of the input spooled files
- How to map spooled file data from a specific page.
- How to map spooled file data from current page.
- How to reproduce input spooled file as output.
- How to iterate across spooled file detail lines.
- How to setup a template to use the page range of an input spooled file.
- Transform a spooled file into XML.
- Convert a spooled file into Excel.
Input
spooled file attributes
As the first thing InterFormNG2 retrieves a lot of spooled file attributes, when a spooled file is processed in the workflow.
Each of the attributes can be referred to in the workflow and in the designer as variables i.e. if you want to verify if the name of the input spooled file is 'QPRINT', then you can compare the variable $interform.input.spooled.splf with 'QPRINT'.
The video shows how the attributes can be used in the designer, but it is actually easier, if you simply select the spooled file attributes from the Attributes tab:
This list can only used to retrieve information from the spooled file - not to assign a new value for a spooled file attribute.
The attributes, that are retrieved are:
interform.input.spooled.system | The system on which the spooled file was created. |
interform.input.spooled.created | The time stamp of when the spooled file was created. |
interform.input.spooled.jobName | The name of the job, that created the spooled file. |
interform.input.spooled.user | The user, that created the spooled file. |
interform.input.spooled.jobNbr | The job number of the job (refer to job name above), that created the spooled file. |
interform.input.spooled.splf | The spooled file name. |
interform.input.spooled.splfNbr | The spooled file number |
interform.input.spooled.outq | The output queue on which the spooled file is placed. |
interform.input.spooled.outqLib | The library of the output queue in which the spooled file is placed. |
interform.input.spooled.formtype | The form type of the input spooled file. |
interform.input.spooled.pgm | The program, that created the spooled file. |
interform.input.spooled.pgmLib | The library of the program, that created the spooled file. |
interform.input.spooled.devFile | The device file (or printer file), that was used, when the spooled file was created. |
interform.input.spooled.devLib | The library of the device file (or printer file), that was used, when the spooled file was created. |
interform.input.spooled.userData | The user data field of the input spooled file. |
interform.input.spooled.usrDefData | This contains the user defined data attribute of the input spooled file. |
interform.input.spooled.copies | The copies attribute of the input spooled file. |
interform.input.spooled.toOutq | If the spooled file arrived via Spool2XML, then this is the output queue, where the merged print is to be printed. |
interform.input.spooled.toOutqlib | The library used for interform.input.spooled.toOutq above. |
interform.input.spooled.sourceDrawer | The drawer selection in the input spooled file. |
interform.input.spooled.startPage | The first page to be printed. This is normally 1 and was set in the pagerange attribute. |
interform.input.spooled.endPage | The last page to be printed. This is normally *END and was set in the pagerange attribute. |
interform.input.spooled.saveAfterWritten | The save attribute of the input spooled file. |
Load aspooled file in the designer
If you want to load a spooled file in the designer, then you first need to load the spooled file in the library.
Now you can load the spooled file in the designer as described here.
You can identify loaded spooled files as the files with the extension .splf.
Related Articles
Map spooled files in the designer
You can map spooled file data in the designer, after you have loaded a spooled file. Mapping is done with the either ng:spoolMap or the ng:spoolMapRel built-in functions. This section covers this: How to view the spooled file contents Spooled file ...Designer Overview
This section covers the use of the InterFormNG2 designer. For installation you should refer to Installation and upgrade. These sections cover the use of the designer: Starting the designer. Create a new template. Open an existing template in the ...Use spooled file attributes in the designer
You can use a lot of spooled file attributes, when you create a template in the designer. You can e.g. use spooled file attributes in the designer in multiple way: Inside conditions or e.g. simply include them in a text element. You can refer to ...Excel designer
Excel Support It is possible to generate Excel output in InterFormNG2, and it is also possible to convert Excel files into XML. You need however to have a license for InterFormNG2, that includes the Excel functionality, which can be support for ...Transformation designer
The designer can be used not only for designing a template for merges into various outputs like PDF, print or HTML, but the designer can also help you to transform an input XML file (or input spooled file in the version 2 format) into a new, ...