Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Biz Talk NonXML > Outbound Positi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 950 of 978
Post > Topic >>

Outbound Positional FlatFile Schema

by Karsten Fuchs <Karsten@[EMAIL PROTECTED] > Jul 26, 2007 at 07:16 AM

Hello everybody,

I'm trying to create an outbound positional flatfile schema with
padding characters. If the one XML Node is empty the padding
charackter starts with an unmeant CRLF. What am I doing wrong? I'm to
blind to find it out myself at the moment.

Example:

Flatfile result:

711031103500  16218125 0004500044070726



                                                                   712

In the first line there is an CRLF after 726. In the second line the
wanted 9 spaces. Then again CRLF. Third line again spaces with CRLF.

What I need:

711031103500  16218125
0004500044070726
712

No CRLFs.



My Inbound XML File:

- <VDA xmlns="http://VDA4913_Schema">
- <Identifier xmlns="">
  <Record_Type>711</Record_Type>
  <Version>03</Version>
  <Data_Recipient_Number>1103500</Data_Recipient_Number>
  <Data_Sender_Number>16218125</Data_Sender_Number>
  <Transfer_Number_Old>45</Transfer_Number_Old>
  <Transfer_Number_New>44</Transfer_Number_New>
  <Transfer_Date>070726</Transfer_Date>
  <Subcontractor_Number />
  <Carrier_Number />
  <Warehouse_Key />
  <****pment_Key />
  <Empty_Field_711 />
  </Identifier>
- <Message xmlns="">
- <Record_712>
  <Record_Type>712</Record_Type>

My XSD Schema:

  <?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
xmlns="http://VDA4913_Schema"
targetNamespace="http://VDA4913_Schema"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:annotation>
- <xs:appinfo>
  <b:schemaInfo default_pad_char="" pad_char_type="char"
count_positions_by_byte="false" parser_optimization="speed"
lookahead_depth="3" suppress_empty_nodes="true"
generate_empty_nodes="false" allow_early_termination="false"
early_terminate_optional_fields="false"
allow_message_breakup_of_infix_root="false"
compile_parse_tables="false" standard="Flat File" root_reference="VDA"
is_envelope="no" />
  <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="VDA">
- <xs:annotation>
- <xs:appinfo>
  <recordInfo sequence_number="1" structure="delimited"
preserve_delimiter_for_empty_data="false"
suppress_trailing_delimiters="false" xmlns="http://
schemas.microsoft.com/BizTalk/2003" child_order="postfix"
child_delimiter_type="char" />
  </xs:appinfo>
  </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
  <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/
BizTalk/2003" />
  </xs:appinfo>
  </xs:annotation>
- <xs:element minOccurs="1" maxOccurs="1" name="Identifier"
nillable="true">
- <xs:annotation>
- <xs:appinfo>
  <recordInfo sequence_number="1" structure="positional"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" tag_name="711" tag_offset="0"
xmlns="http://schemas.microsoft.com/BizTalk/2003"
/>
  </xs:appinfo>
  </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
  <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/
BizTalk/2003" />
  </xs:appinfo>
  </xs:annotation>
- <xs:element name="Record_Type" type="xs:integer">
- <xs:annotation>
- <xs:appinfo>
  <fieldInfo sequence_number="1" justification="right" pos_length="3"
pos_offset="0" pad_char_type="hex" pad_char="0x30" xmlns="http://
schemas.microsoft.com/BizTalk/2003" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element name="Version" type="xs:integer">
- <xs:annotation>
- <xs:appinfo>
  <fieldInfo sequence_number="2" justification="right" pos_length="2"
pos_offset="0" pad_char_type="hex" pad_char="0x30" xmlns="http://
schemas.microsoft.com/BizTalk/2003" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Data_Recipient_Number"
type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo sequence_number="3" justification="left" pos_length="9"
pos_offset="0" pad_char_type="hex" pad_char="0x20" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Data_Sender_Number"
type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <fieldInfo justification="left" pos_length="9" pos_offset="0"
pad_char_type="hex" pad_char="0x20" xmlns="http://
schemas.microsoft.com/BizTalk/2003" sequence_number="4" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Transfer_Number_Old"
type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <fieldInfo justification="right" pos_length="5" pos_offset="0"
pad_char_type="hex" pad_char="0x30" xmlns="http://
schemas.microsoft.com/BizTalk/2003" sequence_number="5" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Transfer_Number_New"
type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo justification="right" pos_length="5" pos_offset="0"
pad_char_type="hex" pad_char="0x30" sequence_number="6" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Transfer_Date" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo sequence_number="7" justification="right"
pos_length="6" pos_offset="0" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Subcontractor_Number"
type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo sequence_number="8" justification="left" pos_length="9"
pos_offset="0" pad_char_type="char" pad_char="" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Carrier_Number" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo justification="left" pos_length="9" pos_offset="0"
pad_char_type="hex" pad_char="0x20" sequence_number="9" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Warehouse_Key" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo justification="left" pos_length="1" pos_offset="0"
pad_char_type="none" sequence_number="10" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="****pment_Key" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo justification="left" pos_length="1" pos_offset="0"
pad_char_type="none" sequence_number="11" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
- <xs:element minOccurs="0" name="Empty_Field_711" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
  <b:fieldInfo sequence_number="12" justification="left"
pad_char_type="hex" pad_char="0x20" pos_length="69" pos_offset="0" />
  </xs:appinfo>
  </xs:annotation>
  </xs:element>
  </xs:sequence>
  </xs:complexType>
  </xs:element>
- <xs:element minOccurs="1" maxOccurs="unbounded" name="Message">
- <xs:annotation>
- <xs:appinfo>
  <b:recordInfo sequence_number="2" structure="delimited"
preserve_delimiter_for_empty_data="false"
suppress_trailing_delimiters="false" child_delimiter_type="char"
child_order="infix" />
  </xs:appinfo>
  </xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
  <b:groupInfo sequence_number="0" />
  </xs:appinfo>
  </xs:annotation>
- <xs:element minOccurs="1" name="Record_712">
- <xs:annotation>
- <xs:appinfo>
  <b:recordInfo structure="positional"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" tag_name="712" tag_offset="0"
sequence_number="1" />
  </xs:appinfo>
  </xs:annotation>


Regards Karsten
 




 2 Posts in Topic:
Outbound Positional FlatFile Schema
Karsten Fuchs <Karsten  2007-07-26 07:16:02 
Re: Outbound Positional FlatFile Schema
Jan Eliasen <eliasen@[  2007-08-03 22:29:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 6:31:03 CST 2008.