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 a
spooled 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.
Other spooled file actions related to the designer is covered here.
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 ...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 ...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: 1.Starting the designer. 2.Create a new template. 3.Open an existing template in ...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, ...