The issue I would guess is this:
<b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" child_order="infix"
child_delimiter_type="char" child_delimiter="," sequence_number="1" />
The child record is set to infix comma delimited record, but there is a
comma preceeding the <CR><LF>, I would change it to postfix and see if
that
fixes it.
Eric
http://blog.biztalk-info.com
"shadowplayer" <shadowplayer@[EMAIL PROTECTED]
> wrote in message
news:uvxhSEKtHHA.2004@[EMAIL PROTECTED]
> Thanks for your help - not sure if you can see the schema I attached but
> my 0x0D 0x0A delimiter is already set for post fix
>
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> xmlns="http://SchedulesRecord"
attributeFormDefault="unqualified"
> elementFormDefault="unqualified"
targetNamespace="http://SchedulesRecord"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:annotation>
> <xs:appinfo>
> <b:schemaInfo count_positions_by_byte="false"
> parser_optimization="complexity" lookahead_depth="0"
> suppress_empty_nodes="true" generate_empty_nodes="false"
> allow_early_termination="true" standard="Flat File" root_reference="CSV"
> default_pad_char=" " pad_char_type="char"
> early_terminate_optional_fields="true"
> allow_message_breakup_of_infix_root="true" compile_parse_tables="false"
/>
> <schemaEditorExtension:schemaInfo namespaceAlias="b"
> extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
> standardName="Flat File"
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions"
> />
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="CSV">
> <xs:annotation>
> <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" child_order="postfix"
> child_delimiter_type="hex" child_delimiter="0x0D 0x0A"
sequence_number="1"
> />
> </xs:appinfo>
> </xs:annotation>
> <xs:complexType>
> <xs:sequence minOccurs="0">
> <xs:annotation>
> <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> <xs:element maxOccurs="1" name="SchedulesRecord">
> <xs:annotation>
> <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" child_order="infix"
> child_delimiter_type="char" child_delimiter="," sequence_number="1" />
> </xs:appinfo>
> </xs:annotation>
> <xs:complexType>
> <xs:sequence>
> <xs:annotation>
> <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="ISIN" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="1"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="ScheduleName" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="2"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="ScheduleType" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="3"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="ScheduleDate" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="4"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="Price" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="5"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="NXT_CALL_DT" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="6"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="NXT_PUT_DT" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="7"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="NXT_SINK_DT" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="8"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="PUT_DAYS_NOTICE" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="9"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="CALL_DAYS_NOTICE" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left"
sequence_number="10"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="PCT_SINKER" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left"
sequence_number="11"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="NXT_SINK_AMT" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left"
sequence_number="12"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="SINK_TYP" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left"
sequence_number="13"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="AMT_ISSUED" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left"
sequence_number="14"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> <xs:element name="NextSinkAmount" type="xs:string">
> <xs:annotation>
> <xs:appinfo>
> <b:fieldInfo justification="left"
sequence_number="15"
> />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
> "Eric Stott" <ericstott@[EMAIL PROTECTED]
> wrote in message
> news:e1mnt$BtHHA.1184@[EMAIL PROTECTED]
>> You need to define the delimiter of 0x0D 0x0A as either post fix or
infix
>> delimited which ever it is...
>> Infix:
>> XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
>> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>> XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
>> 00:00:00.000,,,,,,,,350000000.00,
>> Post fix:
>> XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
>> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>> XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
>> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>>
>> Eric
>> http://blog.biztalk-info.com
>>
>> "shadowplayer" <shadowplayer@[EMAIL PROTECTED]
> wrote in message
>> news:%23gjqDMAtHHA.484@[EMAIL PROTECTED]
>>> Hi,
>>>
>>> I have a simple csv flat file debatching schema which does not work
when
>>> the incoming csv ends with a CRLF
>>>
>>> i.e.
>>>
>>> XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
>>> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>>> XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
>>> 00:00:00.000,,,,,,,,350000000.00,
>>>
>>> works but
>>>
>>> XS0000,CALL_SCHEDULE,C,2049-03-21 00:00:00.000,100.0000,2017-06-21
>>> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>>> XS0001,CALL_SCHEDULE,C,2049-06-21 00:00:00.000,100.0000,2017-06-21
>>> 00:00:00.000,,,,,,,,350000000.00,<CRLF>
>>>
>>> does not.
>>>
>>> The error re****ted is:
>>>
>>> "Unable to match the data in the input stream."
>>>
>>> Strangely though this does work when I set
>>> RecoverableInterchangeProcessing to true...
>>>
>>> I'm sure there must be a simple answer to this but it has eluded me
for
>>> two days now :-)
>>>
>>> My schema is attached.
>>>
>>> Many thanks
>>>
>>>
>>
>>
>
>
|
