p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

Go Back   p2p.wrox.com Forums > .NET > Other .NET > Biztalk
Reload this Page Biztalk 2002 flatfile to flatfile Schema help
I forgot my password Register Now
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Biztalk General discussion about Biztalk server.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.

Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 24th, 2005, 09:15 AM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Gahanna, Ohio, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Biztalk 2002 flatfile to flatfile Schema help
Hi,

I am having trouble outputting multiple detail records in sequence with their corresponding header record. The schema is simple, root>header>detail. The map creates the correct records in this format header>header>header>detail>detail>detail, but what I want is Header>detatil>Header>detail>Header>detail. How can i adjust the schema to produce desired results? Here is the schema, which is delimited, postfix, [header = 1 min, unbounded max], [detail = 1 min, unbounded max]. Thank you.

<?xml version="1.0"?>


<Schema name="Order" b:BizTalkServerEditorTool_Version="1.5" b:root_reference="Order_TXT" b:def_record_delim="0xd" b:standard="FlatFile" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:b="urn:schemas-microsoft-com:BizTalkServer" xmlns:d="urn:schemas-microsoft-com:datatypes">
<b:SelectionFields/>

<ElementType name="Order_TXT" content="eltOnly" model="closed">
<b:RecordInfo structure="delimited" delimiter_type="hex" delimiter_value="0xd" field_order="postfix" append_newline="yes" skip_CR="no" skip_LF="yes"/>
<element type="Header" maxOccurs="*" minOccurs="1"/>
<element type="Detail" maxOccurs="*" minOccurs="1"/>
</ElementType><ElementType name="Header" content="empty" model="closed">
<b:RecordInfo tag_name="|HED|," structure="delimited" delimiter_type="hex" delimiter_value="0x2c" field_order="infix" escape_type="hex" escape_value="0x7e" append_newline="no" skip_CR="no" skip_LF="yes"/>
<AttributeType name="TransmissionID">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalwTax">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTaxRate3">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTaxRate2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTaxRate1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTax3">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTax2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTax1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalShippingCharge">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalQty">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalItems">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalAmount">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ThirdPartyAccount">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TermsOfPayment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TermsOfDelivery">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TelephoneDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TelephoneBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="StoreID">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="StateProvinceDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="StateProvinceBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ShipmentLabelFormat">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ShipComplete">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ReleseDate">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ReferenceB">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="RecordType">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="RecordCommand">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="PostalZipDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="PostalZipBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="PODRequired">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="InternalOrderNumber">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="FaxDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="FaxBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ExpectedReceiptDate">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="EmailDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="EmailBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CustomerOrder">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CustomerClientID">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CurrencyCode">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CountryDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CountryBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ContactDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ContactBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ConsigneeDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ConsigneeBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment3">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientPOType">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientPO">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientDepartment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CityDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CityBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ChangeReason">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CarrierCode">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CODValue">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="AppointmentRequired">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address3Del">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address3Bill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address2Del">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address2Bill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address1Del">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address1Bill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<attribute type="RecordType" required="no"/>
<attribute type="RecordCommand" required="no"/>
<attribute type="ChangeReason" required="no"/>
<attribute type="InternalOrderNumber" required="no"/>
<attribute type="ReleseDate" required="no"/>
<attribute type="CustomerOrder" required="no"/>
<attribute type="ClientPO" required="no"/>
<attribute type="ReferenceB" required="no"/>
<attribute type="TermsOfDelivery" required="no"/>
<attribute type="CarrierCode" required="no"/>
<attribute type="TermsOfPayment" required="no"/>
<attribute type="ConsigneeDel" required="no"/>
<attribute type="ContactDel" required="no"/>
<attribute type="Address1Del" required="no"/>
<attribute type="Address2Del" required="no"/>
<attribute type="Address3Del" required="no"/>
<attribute type="CityDel" required="no"/>
<attribute type="StateProvinceDel" required="no"/>
<attribute type="PostalZipDel" required="no"/>
<attribute type="CountryDel" required="no"/>
<attribute type="TelephoneDel" required="no"/>
<attribute type="FaxDel" required="no"/>
<attribute type="EmailDel" required="no"/>
<attribute type="ConsigneeBill" required="no"/>
<attribute type="ContactBill" required="no"/>
<attribute type="Address1Bill" required="no"/>
<attribute type="Address2Bill" required="no"/>
<attribute type="Address3Bill" required="no"/>
<attribute type="CityBill" required="no"/>
<attribute type="StateProvinceBill" required="no"/>
<attribute type="PostalZipBill" required="no"/>
<attribute type="CountryBill" required="no"/>
<attribute type="TelephoneBill" required="no"/>
<attribute type="FaxBill" required="no"/>
<attribute type="EmailBill" required="no"/>
<attribute type="Comment" required="no"/>
<attribute type="Comment2" required="no"/>
<attribute type="TotalAmount" required="no"/>
<attribute type="TotalShippingCharge" required="no"/>
<attribute type="TotalTax1" required="no"/>
<attribute type="TotalTaxRate1" required="no"/>
<attribute type="TotalTax2" required="no"/>
<attribute type="TotalTaxRate2" required="no"/>
<attribute type="TotalTax3" required="no"/>
<attribute type="TotalTaxRate3" required="no"/>
<attribute type="TotalwTax" required="no"/>
<attribute type="CurrencyCode" required="no"/>
<attribute type="ShipComplete" required="no"/>
<attribute type="CustomerClientID" required="no"/>
<attribute type="StoreID" required="no"/>
<attribute type="ThirdPartyAccount" required="no"/>
<attribute type="ClientPOType" required="no"/>
<attribute type="ClientDepartment" required="no"/>
<attribute type="ShipmentLabelFormat" required="no"/>
<attribute type="PODRequired" required="no"/>
<attribute type="AppointmentRequired" required="no"/>
<attribute type="ExpectedReceiptDate" required="no"/>
<attribute type="CODValue" required="no"/>
<attribute type="TotalItems" required="no"/>
<attribute type="TotalQty" required="no"/>
<attribute type="TransmissionID" required="no"/>
<attribute type="Comment3" required="no"/>
</ElementType><ElementType name="Detail" content="empty" model="closed">
<b:RecordInfo tag_name="|DET|," structure="delimited" delimiter_type="hex" delimiter_value="0x2c" field_order="infix" escape_type="hex" escape_value="0x7e" append_newline="no" skip_CR="no" skip_LF="yes"/>
<AttributeType name="UnitPriceCustom">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="UnitPriceCommercial">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="UnisShippingCharge">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ShipComplete">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="SerialRequired">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="SerialNumber">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ReleaseDate">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="RecordType">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="RecordCommand">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="OrderQuantity">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="LineNumber">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="LineID2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="LineID1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ItemGroup">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Item">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="HSCode">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CustomerOrder">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientSkuDescription">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientSKU">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ChangeReason">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CartonConfiguration">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<attribute type="RecordType" required="no"/>
<attribute type="RecordCommand" required="no"/>
<attribute type="ChangeReason" required="no"/>
<attribute type="CustomerOrder" required="no"/>
<attribute type="LineNumber" required="no"/>
<attribute type="Item" required="no"/>
<attribute type="ItemGroup" required="no"/>
<attribute type="OrderQuantity" required="no"/>
<attribute type="ReleaseDate" required="no"/>
<attribute type="UnitPriceCommercial" required="no"/>
<attribute type="UnitPriceCustom" required="no"/>
<attribute type="UnisShippingCharge" required="no"/>
<attribute type="ShipComplete" required="no"/>
<attribute type="SerialNumber" required="no"/>
<attribute type="SerialRequired" required="no"/>
<attribute type="Comment" required="no"/>
<attribute type="Comment1" required="no"/>
<attribute type="LineID1" required="no"/>
<attribute type="LineID2" required="no"/>
<attribute type="HSCode" required="no"/>
<attribute type="ClientSKU" required="no"/>
<attribute type="ClientSkuDescription" required="no"/>
<attribute type="CartonConfiguration" required="no"/>
</ElementType></Schema>
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #2 (permalink)  
Old January 24th, 2005, 05:25 PM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Gahanna, Ohio, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default
For those with experience in flatfile schema building, here is my latest work on the schema to produce one Header with one or more Details, each Header on a line, and each Detail must also be on their own line. Thank you in advance for your suggestions. This schema is giving me one Header and one Detail per line.

<?xml version="1.0"?>


<Schema name="Order" b:BizTalkServerEditorTool_Version="1.5" b:root_reference="Order_TXT" b:def_record_delim="0xd" b:def_field_delim="0x2c" b:standard="CUSTOM" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:b="urn:schemas-microsoft-com:BizTalkServer" xmlns:d="urn:schemas-microsoft-com:datatypes">
<b:SelectionFields/>

<ElementType name="Order_TXT" content="eltOnly" model="open">
<b:RecordInfo structure="delimited" delimiter_type="inherit_record" field_order="postfix" skip_CR="no"/>
<element type="Header_Loop" maxOccurs="*" minOccurs="1"/>
</ElementType><ElementType name="Header_Loop" content="eltOnly" model="open">
<b:RecordInfo structure="delimited" delimiter_type="inherit_record" field_order="infix" append_newline="yes" skip_CR="no"/>
<element type="Header" maxOccurs="*" minOccurs="1"/>
<element type="Detail_Loop" maxOccurs="*" minOccurs="0"/>
</ElementType><ElementType name="Header" content="eltOnly" model="open">
<b:RecordInfo tag_name="|1|," structure="delimited" delimiter_type="inherit_field" field_order="infix" skip_CR="no" skip_LF="yes"/>
<AttributeType name="TransmissionID">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalwTax">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTaxRate3">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTaxRate2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTaxRate1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTax3">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTax2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalTax1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalShippingCharge">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalQty">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalItems">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TotalAmount">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ThirdPartyAccount">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TermsOfPayment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TermsOfDelivery">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TelephoneDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="TelephoneBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="StoreID">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="StateProvinceDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="StateProvinceBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ShipmentLabelFormat">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ShipComplete">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ReleseDate">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ReferenceB">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="RecordCommand">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="PostalZipDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="PostalZipBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="PODRequired">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="InternalOrderNumber">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="FaxDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="FaxBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ExpectedReceiptDate">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="EmailDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="EmailBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CustomerOrder">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CustomerClientID">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CurrencyCode">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CountryDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CountryBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ContactDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ContactBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ConsigneeDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ConsigneeBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment3">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientPOType">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientPO">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientDepartment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CityDel">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CityBill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ChangeReason">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CarrierCode">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CODValue">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="AppointmentRequired">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address3Del">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address3Bill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address2Del">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address2Bill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address1Del">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Address1Bill">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<attribute type="RecordCommand" required="no"/>
<attribute type="ChangeReason" required="no"/>
<attribute type="InternalOrderNumber" required="no"/>
<attribute type="ReleseDate" required="no"/>
<attribute type="CustomerOrder" required="no"/>
<attribute type="ClientPO" required="no"/>
<attribute type="ReferenceB" required="no"/>
<attribute type="TermsOfDelivery" required="no"/>
<attribute type="CarrierCode" required="no"/>
<attribute type="TermsOfPayment" required="no"/>
<attribute type="ConsigneeDel" required="no"/>
<attribute type="ContactDel" required="no"/>
<attribute type="Address1Del" required="no"/>
<attribute type="Address2Del" required="no"/>
<attribute type="Address3Del" required="no"/>
<attribute type="CityDel" required="no"/>
<attribute type="StateProvinceDel" required="no"/>
<attribute type="PostalZipDel" required="no"/>
<attribute type="CountryDel" required="no"/>
<attribute type="TelephoneDel" required="no"/>
<attribute type="FaxDel" required="no"/>
<attribute type="EmailDel" required="no"/>
<attribute type="ConsigneeBill" required="no"/>
<attribute type="ContactBill" required="no"/>
<attribute type="Address1Bill" required="no"/>
<attribute type="Address2Bill" required="no"/>
<attribute type="Address3Bill" required="no"/>
<attribute type="CityBill" required="no"/>
<attribute type="StateProvinceBill" required="no"/>
<attribute type="PostalZipBill" required="no"/>
<attribute type="CountryBill" required="no"/>
<attribute type="TelephoneBill" required="no"/>
<attribute type="FaxBill" required="no"/>
<attribute type="EmailBill" required="no"/>
<attribute type="Comment" required="no"/>
<attribute type="Comment2" required="no"/>
<attribute type="TotalAmount" required="no"/>
<attribute type="TotalShippingCharge" required="no"/>
<attribute type="TotalTax1" required="no"/>
<attribute type="TotalTaxRate1" required="no"/>
<attribute type="TotalTax2" required="no"/>
<attribute type="TotalTaxRate2" required="no"/>
<attribute type="TotalTax3" required="no"/>
<attribute type="TotalTaxRate3" required="no"/>
<attribute type="TotalwTax" required="no"/>
<attribute type="CurrencyCode" required="no"/>
<attribute type="ShipComplete" required="no"/>
<attribute type="CustomerClientID" required="no"/>
<attribute type="StoreID" required="no"/>
<attribute type="ThirdPartyAccount" required="no"/>
<attribute type="ClientPOType" required="no"/>
<attribute type="ClientDepartment" required="no"/>
<attribute type="ShipmentLabelFormat" required="no"/>
<attribute type="PODRequired" required="no"/>
<attribute type="AppointmentRequired" required="no"/>
<attribute type="ExpectedReceiptDate" required="no"/>
<attribute type="CODValue" required="no"/>
<attribute type="TotalItems" required="no"/>
<attribute type="TotalQty" required="no"/>
<attribute type="TransmissionID" required="no"/>
<attribute type="Comment3" required="no"/>
</ElementType><ElementType name="Detail_Loop" content="eltOnly" model="open">
<b:RecordInfo structure="delimited" delimiter_type="inherit_record" field_order="infix" append_newline="yes" skip_CR="no"/>
<element type="Detail" maxOccurs="*" minOccurs="1"/>
</ElementType><ElementType name="Detail" content="eltOnly" model="open">
<b:RecordInfo tag_name="|2|," structure="delimited" delimiter_type="inherit_field" field_order="infix" skip_CR="no" skip_LF="yes"/>
<AttributeType name="UnitPriceCustom">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="UnitPriceCommercial">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="UnisShippingCharge">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ShipComplete">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="SerialRequired">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="SerialNumber">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ReleaseDate">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="RecordCommand">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="OrderQuantity">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="LineNumber">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="LineID2">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="LineID1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ItemGroup">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Item">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="HSCode">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CustomerOrder">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment1">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="Comment">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientSkuDescription">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ClientSKU">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="ChangeReason">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<AttributeType name="CartonConfiguration">
<b:FieldInfo pad_char="0x7c" wrap_char="0x7c"/></AttributeType>
<attribute type="RecordCommand" required="no"/>
<attribute type="ChangeReason" required="no"/>
<attribute type="CustomerOrder" required="no"/>
<attribute type="LineNumber" required="no"/>
<attribute type="Item" required="no"/>
<attribute type="ItemGroup" required="no"/>
<attribute type="OrderQuantity" required="no"/>
<attribute type="ReleaseDate" required="no"/>
<attribute type="UnitPriceCommercial" required="no"/>
<attribute type="UnitPriceCustom" required="no"/>
<attribute type="UnisShippingCharge" required="no"/>
<attribute type="ShipComplete" required="no"/>
<attribute type="SerialNumber" required="no"/>
<attribute type="SerialRequired" required="no"/>
<attribute type="Comment" required="no"/>
<attribute type="Comment1" required="no"/>
<attribute type="LineID1" required="no"/>
<attribute type="LineID2" required="no"/>
<attribute type="HSCode" required="no"/>
<attribute type="ClientSKU" required="no"/>
<attribute type="ClientSkuDescription" required="no"/>
<attribute type="CartonConfiguration" required="no"/>
</ElementType></Schema>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #3 (permalink)  
Old January 25th, 2005, 04:26 PM
Registered User
Points: 9, Level: 1
Points: 9, Level: 1 Points: 9, Level: 1 Points: 9, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2005
Location: Gahanna, Ohio, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Thank you. I have solved this issue with the help from a previous p2p poster, and by the cooperatio of the friendly 'Looping Functiod'.

:)
Tom


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #4 (permalink)  
Old April 18th, 2005, 12:58 PM
Registered User
  
Join Date: Apr 2005
Location: Chennai, Tamilnadu, India.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Tom,

Greetings to you.

Really your solution is nice.

lawrence
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SSIS Package:RawFile Source,FlatFile Destination Mit_2807 BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 September 19th, 2008 05:01 AM
BIZTALK gayathri Irugulapati Biztalk 0 June 21st, 2006 05:17 AM
Schema to Schema conversion onlyda XSLT 5 March 23rd, 2006 12:25 PM
Y BizTalk dja24030 Biztalk 0 April 6th, 2004 06:41 AM
Biztalk mandla Biztalk 3 September 24th, 2003 01:35 AM



All times are GMT -4. The time now is 04:33 AM.

Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© 2008 Wiley Publishing, Inc