Purpose

The creates an XML file for an extract file created by a Callista job

SubSystem

System

This job allows the user to select an extract that has been created and create an XML file of that extract. It does not create any new data it just changes the format of an extract derived by another job. The file extension will be XML. If the Use Extract from Current Request check box is selected then the job automatically looks for an extract generated by a job in the same job request.
The XML file created, contains all the records included in the selected extract. It has XML tags that are named after the columns that appear in the S_EXTRACT and S_EXTRACT_RECORD tables, unless an XSLT stylesheet is defined for the S_EXTRACT_TYPE of the extract (this is defined on the S_EXTRACT_TYPE table).

The user can have the XML delivered as an email attachment using standard Callista Job Scheduler functionality.
The system output type in the job details form (JBSF4110) is defined as XML.

If the 'Use Extract from Current Request' checkbox is selected but no extract file is created for a COMPLETED job run in this request, then a message is logged to the RUN_LOG table indicating that no extract was found.
If more than one extract exists from the current request, then each record is processed individually (generating a separate file).

The output file is opened in the default job output directory, and is named <s_extract_type>-<creation_dt>.xml. If the output directory can not be found, then an error is raised and the job fails. Likewise if the output file cannot be opened for writing, or writing fails during a write attempt.

The Generate Extract XML File block contains:

Parameters Tab

• Use Extract from Current Request check box
• System Extract Type
• Previous Extract

Rules/Notes:

If an extract is created by another job which is included in the same request as this job (in JBSF5210) then the Use Extract from Current Request checkbox can be used to create an XML file for this extract.

When the Use Extract from Current Request check box is selected then the other fields on the parameter form are disabled and cleared. When it is not selected, the rest of the fields are enabled.

The Extract Type field acts as a filter to reduce the number of records displayed by the Previous Extract LOV.

The Previous Extract LOV displays in order of creation date (Most recent first).

Using Stylesheets from the S_EXTRACT_TYPE table.

If a stylesheet (XSLT) is specified in the stylesheet column of the S_EXTRACT_TYPE table, then the XML tags will be given meaningful names reflective of the data stored within them, otherwise the XML tags will be named after the column names of the extract tables.

Rules/Notes:

There is no provision to alter the stylesheet through Callista SMS product, so changes to the stylesheets need to be made by administrators directly on the back-end database table (S_EXTRACT_TYPE).
If the stylesheet or the data source are in any way corrupted or improperly formatted, a warning is logged to inform the user and the processing should continue (returning the un-transformed data source).