NLS XML Import Specification

The NLS XML Import specification can be used through any import mechanism in NLS.

When this file is run, the sequence of events is as follows:

1. An error file and report file are created with the same base name as the input file.
2. Records are processed from top of file to bottom with exceptions being written to the error file and successful imports written to the report file.

General rules to keep in mind when creating an XML import file:

• The XML file must be started with the section <NLS>
• To assign NULL to an attribute with an existing value, use "##NULL##"
  Some attributes, where indicated, accepts a blank “” value for NULL.
• Date format is MM/dd/yyyy or as configured by the DATEFMT user defined parameter.
• Time format is HH:mm:ss or as configured by the TIMEFMT user defined parameter.

<?xml version="1.0" encoding="UTF-8"?>
<NLS>
    <CIF CIFPortfolioName="&lt;default&gt;" CIFNumber="FHE123" ShortName="JOHN DOE">
        <CIFDETAIL CIFDetail1="UDF1" CIFDetail20="13.45"/>
        <CIFDEMOGRAPHICS CIFDemographic1="SOME TEXT"/>
    </CIF>
</NLS>