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