Spooled file support

Spooled file support

InterFormNG2 is able to process spooled files, if you install InterFormNG2 on the IBM i platform.

 

Please notice, that spooled file support, as well as Spool2XML, are modules for InterFormNG2, that are purchased separately.

 

You can also use the spool2XML functionality, but it is very important, that you ensure, that InterFormNG2 and Spool2XML are not monitoring the same output queues.

 

You need to use the built-in function, ng:spoolMap in order to refer to spooled file information.


Note:

*USERASCII spooled files are not supported by InterFormNG2. If you try to process a *USERASCII spooled file in InterFormNG2, then you will see the error message: "*USERASCII spooled files are not supported, so the spooled file is ignored."

 

The spooled file support is divided into these sections:

 

Spooled file formats

The spooled files can be stored in two different formats. The new format, version 2.0 is recommended.

 

Spooled files in the designer

•How to load a spooled file in the designer.

•Transformation designer - convert a spooled file into XML in the designer.

•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.

•Use spooled file attributes in the designer.

•Change page breaks of a spooled file.

•Use the page range of an input spooled file.

•Output the spooled file pages in reverse order.

•Copy management for spooled files.

•Handling multi-line conditioned sections

•How to switch between different page formats within a spooled file.

•Convert a spooled file into Excel.

 

 

Spooled files in the workflow

•How to monitor an output queue.

•Load a sample spooled file in the workflow editor

•How to condition the workflow on spooled file attributes

•Condition workflow on spooled file contents

•How to merge a spooled file with a template.

•How to change spooled file attributes

•Spooled file actions

•Split spooled files

•Add data to spooled files via SQL

•Transform a spooled file into XML

•Transform a spooled file into Excel.

•Transform a spooled file into a new spooled file. This can e.g. be used if you want to change the contents or add data from an SQL via the function, ng:databaseLookup. Multiple examples are found here.

•Use database information to move a spooled file or set output queue.

•Use translation file to link users with an output queue.

•Handling large spooled files in parallel. Consider this to avoid that larger spooled files are preventing processing of smaller spooled files, which might require a smaller response time.

 

General

•How to use input spooled file attributes

•The buit-in function, ng:spoolMap

•AFPDS spooled file adjustment

•Restore a spooled file

•Save a spooled file

    • Related Articles

    • Spooled file formats

      Whenever you load or process spooled files in InterFormNG2, then you can choose between two internal formats: Version 1.0 and version 2.0. It is recommended to use Version 2.0 if at all possible. These are the reasons why you should use the version ...

    • Spooled file into Excel

      This section shows how a spooled file can be converted into Excel. The example relates to a spooled file, that has a format like below: The spooled file is a multi-page spooled file with a header, some details lines (in the middle blue frame), which ...

    • Support for old NG templates

      Customers, that has a lot of existing NG templates (with extension .itpl, that have been made in InterFormNG), can use these templates in InterFormNG2, if the following limitations are taken into account: 1.The templates can be loaded in the library ...

    • Change attributes of spooled file

      As a part of spooled file processing in InterFormNG2 on the IBM i platform, you might want to change one or more spooled file attributes of the input spooled file to let the end user know, that the specific spooled file has been successfully ...

    • Introduction to the Spooled file extractor

      IMPORTANT: The spooled file extractor is no longer supported. Any spooled file extractor definitions, that has previously been designed can still be used in the workflow, but they cannot be edited. The better alternative is to use the designer for ...