IBM BJ0NJML - Service And Asset Management - Flat File Formatting; Flat File Properties; HTTP Handler

Handlers
148
Integration Guide
Flat File Formatting
If the data in the flat file contains the flat file delimiter character, the data adds the
text qualifier, which is " (quotation marks). If the data contains quotation marks,
the handler escapes the quotation marks. You cannot use quotation marks as the
delimiter character.
The following example data uses a comma (,) as a delimiter. The INVOICEDESC
value, (
Rotating Custom Item, No 71), contains a comma. When the flat file is
written, the INVOICEDESC value is enclosed in quotation marks.
EXTSYS1,MXINVOICEInterface,Add
INVOICENUM,INVOICEDESC,PONUM,VENDOR,CONTACT,PAYMENTTERMS
1071,"Rotating Custom Item, No 71",1000,A0001,,
The following example data uses a comma (,) as a delimiter. The INVOICEDESC
value (
Rotating "Custom" Item No 71) contains double quotation marks.
When the flat file is written, double quotation marks in INVOICEDESC data ends
with quotation marks, and the entire string is wrapped in quotation marks.
EXTSYS1,MXINVOICEInterface,Add
INVOICENUM,INVOICEDESC,PONUM,VENDOR,CONTACT,PAYMENTTERMS
1071,"Rotating ""Custom"" Item No 71",1000,A0001,,
The following example data uses a comma (,) as a delimiter. The INVOICEDESC
data (
Rotating "Custom" Item, No. 71) contains the delimiter character and
double quotation marks. When the flat file is written, the INVOICEDESC value
appears in the code.
EXTSYS1,MXINVOICEInterface,Add
INVOICENUM,INVOICEDESC,PONUM,VENDOR,CONTACT,PAYMENTTERMS
1071,"Rotating ""Custom"" Item, No. 71",1000,A0001,,
Flat File Properties
This handler has the following properties:
FILEDIR Property This required property specifies the location of the flat file. The location must
exist on the local server where the application server runs, or on a shared network
drive.
This property value defaults to the Integration global directory/flatfiles folder when
no value is specified. The mxe.int.globaldir value controls the integration global
directory value.
FLATFILESEP Property This required property specifies the character that separates the columns in each
row.
HTTP Handler
The HTTP handler is a Java component that consists of properties. The handler
delivers data as an XML document to a URL by using HTTP or HTTPS protocols.
The HTTP handler also evaluates the response code received from the external
system.