|
Home > Archive > BizTalk Server General > July 2004 > Flat file question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Flat file question
|
|
| Guy Barrette 2004-07-27, 7:55 am |
| Hi
I have a flat file with different type of records. All in the same file and
those records can be positioned at any row in the file. Can BizTalk deal
with this kind of file? If so, how?
John,Doe,Microsoft,Redmond
Paul,Doe,Microsoft,Redmond
Ringo,Doe,Microsoft,Redmond
Starbucks,999 Main,Seattle,12345,USA
Etoile,7 Champs Elysee,Chicago,12345,USA
Jane,Doe,Microsoft,Redmond
Coffee Shop,123 Main st,New York,12345,USA
Thanks
Guy Barrette
| |
| Guy Barrette 2004-07-27, 7:55 am |
| I forgot to mention that each record has an identifier like this:
ABC,John,Doe,Microsoft,Redmond
ABC,Paul,Doe,Microsoft,Redmond
ABC,Ringo,Doe,Microsoft,Redmond
XYZ,Starbucks,999 Main,Seattle,12345,USA
XYZ,Etoile,7 Champs Elysee,Paris,12345,France
ABC,Jane,Doe,Microsoft,Redmond
XYZ,Coffee Shop,123 Main st,New York,12345,USA
"Guy Barrette" <someone@nurun.com> wrote in message
news:eeK5T19cEHA.1384@TK2MSFTNGP10.phx.gbl...
> Hi
>
> I have a flat file with different type of records. All in the same file
and
> those records can be positioned at any row in the file. Can BizTalk deal
> with this kind of file? If so, how?
>
> John,Doe,Microsoft,Redmond
> Paul,Doe,Microsoft,Redmond
> Ringo,Doe,Microsoft,Redmond
> Starbucks,999 Main,Seattle,12345,USA
> Etoile,7 Champs Elysee,Chicago,12345,USA
> Jane,Doe,Microsoft,Redmond
> Coffee Shop,123 Main st,New York,12345,USA
>
>
> Thanks
> Guy Barrette
>
>
| |
| Yossi Dahan 2004-07-27, 7:55 am |
| Yes it can.
The Tag identifier & tag offset can be used to give BizTalk a clue as to how
to decide which type of record this is.
If your schema is more complicated I suggest you look at Itemfield's
ContentMaster (www.itemfield.com)
Yossi
"Guy Barrette" <someone@nurun.com> wrote in message
news:eeK5T19cEHA.1384@TK2MSFTNGP10.phx.gbl...
> Hi
>
> I have a flat file with different type of records. All in the same file
and
> those records can be positioned at any row in the file. Can BizTalk deal
> with this kind of file? If so, how?
>
> John,Doe,Microsoft,Redmond
> Paul,Doe,Microsoft,Redmond
> Ringo,Doe,Microsoft,Redmond
> Starbucks,999 Main,Seattle,12345,USA
> Etoile,7 Champs Elysee,Chicago,12345,USA
> Jane,Doe,Microsoft,Redmond
> Coffee Shop,123 Main st,New York,12345,USA
>
>
> Thanks
> Guy Barrette
>
>
| |
| Rohith 2004-07-27, 4:56 pm |
| tag offset very much helpful in this case!!!
Flat File Like:
ABC456789
ABCJKLKM0
CBA123458
1st and 2nd redords starts with ABC...in that case you have to use Both tag
identifier & tag offset!!
ABC456789 <<tag identifier=9 tag offset=9>>
ABCJKLKM0<<tag identifier=0 tag offset=9>>
CBA123458<<tag identifier=CBA>>
you can do it...u rs stuff tooo!!cool!!
CR-
quote:
Originally posted by Yossi Dahan
Yes it can.
The Tag identifier & tag offset can be used to give BizTalk a clue as to how
to decide which type of record this is.
If your schema is more complicated I suggest you look at Itemfield's
ContentMaster (www.itemfield.com)
Yossi
"Guy Barrette" <someone@nurun.com> wrote in message
news:eeK5T19cEHA.1384@TK2MSFTNGP10.phx.gbl...
> Hi
>
> I have a flat file with different type of records. All in the same file
and
> those records can be positioned at any row in the file. Can BizTalk deal
> with this kind of file? If so, how?
>
> John,Doe,Microsoft,Redmond
> Paul,Doe,Microsoft,Redmond
> Ringo,Doe,Microsoft,Redmond
> Starbucks,999 Main,Seattle,12345,USA
> Etoile,7 Champs Elysee,Chicago,12345,USA
> Jane,Doe,Microsoft,Redmond
> Coffee Shop,123 Main st,New York,12345,USA
>
>
> Thanks
> Guy Barrette
>
>
| |
| Guy Barrette 2004-07-27, 5:53 pm |
| Thanks for the info. I'm almost there !
The problem I have when I validate the instance is that is get the 1st and
the 2nd sequence of records in the XML file but anything after is ignored.
ABC,John,Doe,Microsoft,Redmond
ABC,Paul,Doe,Microsoft,Redmond
ABC,Ringo,Doe,Microsoft,Redmond
XYZ,Starbucks,999 Main,Seattle,12345,USA
XYZ,Etoile,7 Champs Elysee,Paris,12345,France
ABC,Jane,Doe,Microsoft,Redmond
XYZ,Coffee Shop,123 Main st,New York,12345,USA
OK---ABC,John,Doe,Microsoft,Redmond
OK---ABC,Paul,Doe,Microsoft,Redmond
OK---ABC,Ringo,Doe,Microsoft,Redmond
OK---XYZ,Starbucks,999 Main,Seattle,12345,USA
OK---XYZ,Etoile,7 Champs Elysee,Paris,12345,France
Ignored---ABC,Jane,Doe,Microsoft,Redmond
Ignored---XYZ,Coffee Shop,123 Main st,New York,12345,USA
Looks like BizTalk ignore everything after the it processed the 1st and 2nd
set of records.
There must be a property or setting to ajust but I can't figure what is is.
Thanks for your help.
Guy Barrette
"Yossi Dahan" <yossidahan@hotmail.com> wrote in message
news:uBmH4E%23cEHA.1672@TK2MSFTNGP12.phx.gbl...
> Yes it can.
> The Tag identifier & tag offset can be used to give BizTalk a clue as to
how
> to decide which type of record this is.
> If your schema is more complicated I suggest you look at Itemfield's
> ContentMaster (www.itemfield.com)
>
> Yossi
>
>
> "Guy Barrette" <someone@nurun.com> wrote in message
> news:eeK5T19cEHA.1384@TK2MSFTNGP10.phx.gbl...
> and
deal[vbcol=seagreen]
>
>
| |
| Yossi Dahan 2004-07-27, 5:53 pm |
| If you want attach your schema and a sample file and I'll try to have a look
"Guy Barrette" <someone@nurun.com> wrote in message
news:%234xqss%23cEHA.2520@TK2MSFTNGP12.phx.gbl...
> Thanks for the info. I'm almost there !
>
> The problem I have when I validate the instance is that is get the 1st and
> the 2nd sequence of records in the XML file but anything after is ignored.
>
> ABC,John,Doe,Microsoft,Redmond
> ABC,Paul,Doe,Microsoft,Redmond
> ABC,Ringo,Doe,Microsoft,Redmond
> XYZ,Starbucks,999 Main,Seattle,12345,USA
> XYZ,Etoile,7 Champs Elysee,Paris,12345,France
> ABC,Jane,Doe,Microsoft,Redmond
> XYZ,Coffee Shop,123 Main st,New York,12345,USA
>
> OK---ABC,John,Doe,Microsoft,Redmond
> OK---ABC,Paul,Doe,Microsoft,Redmond
> OK---ABC,Ringo,Doe,Microsoft,Redmond
> OK---XYZ,Starbucks,999 Main,Seattle,12345,USA
> OK---XYZ,Etoile,7 Champs Elysee,Paris,12345,France
> Ignored---ABC,Jane,Doe,Microsoft,Redmond
> Ignored---XYZ,Coffee Shop,123 Main st,New York,12345,USA
>
> Looks like BizTalk ignore everything after the it processed the 1st and
2nd
> set of records.
> There must be a property or setting to ajust but I can't figure what is
is.
>
>
> Thanks for your help.
> Guy Barrette
>
>
>
> "Yossi Dahan" <yossidahan@hotmail.com> wrote in message
> news:uBmH4E%23cEHA.1672@TK2MSFTNGP12.phx.gbl...
> how
file[vbcol=seagreen]
> deal
>
>
| |
| Guy Barrette 2004-07-27, 5:53 pm |
| Thank you so much for your time. Here's the file:
ABC,John,Doe,Microsoft,Redmond
ABC,Paul,Doe,Microsoft,Redmond
ABC,Ringo,Doe,Microsoft,Redmond
XYZ,Starbucks,999 Main,Seattle,12345,USA
XYZ,Etoile,7 Champs Elysee,Paris,12345,France
ABC,Jane,Doe,Microsoft,Redmond
XYZ,Coffee Shop,123 Main st,New York,12345,USA
And the schema:
<?xml version="1.0" encoding="utf-16" ?>
- <xs:schema xmlns="http://AgenciesSchemas.MultipleRecords"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://AgenciesSchemas.MultipleRecords"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
- <xs:annotation>
- <xs:appinfo>
<b:schemaInfo count_positions_by_byte="false" standard="Flat File"
root_reference="MultipleRecordsCSV" />
<schemaEditorExtension:schemaInfo namespaceAlias="b"
extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
standardName="Flat File"
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
aEditorExtensions" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="MultipleRecordsCSV">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" sequence_number="1"
child_delimiter_type="hex" child_delimiter="0x0D 0x0A" child_order="postfix"
/>
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element maxOccurs="unbounded" name="Nom">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" sequence_number="1"
child_delimiter_type="char" child_delimiter="," tag_name="ABC" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Prenom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Nom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Compagnie" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Ville" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
- <xs:element maxOccurs="unbounded" name="Compagnie">
- <xs:annotation>
- <xs:appinfo>
<b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" sequence_number="2"
child_delimiter_type="char" child_delimiter="," tag_name="XYZ" />
</xs:appinfo>
</xs:annotation>
- <xs:complexType>
- <xs:sequence>
- <xs:annotation>
- <xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
- <xs:element name="Nom" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Adresse" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Ville" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Zip" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
- <xs:element name="Pays" type="xs:string">
- <xs:annotation>
- <xs:appinfo>
<b:fieldInfo justification="left" sequence_number="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
"Yossi Dahan" <yossidahan@hotmail.com> wrote in message
news:%23mwOh$%23cEHA.1424@tk2msftngp13.phx.gbl...
> If you want attach your schema and a sample file and I'll try to have a
look
>
>
> "Guy Barrette" <someone@nurun.com> wrote in message
> news:%234xqss%23cEHA.2520@TK2MSFTNGP12.phx.gbl...
and[vbcol=seagreen]
ignored.[vbcol=seagreen]
> 2nd
> is.
to[vbcol=seagreen]
> file
>
>
| |
| Yossi Dahan 2004-07-28, 7:54 am |
| Guy hi
I'm still looking at your sample (whenever I can get some time...)
What I can see at the moment is that the disassembler splits the file into
two results, so the missing records are actually in a second message.
if you create a simple messaging scenario using file adapters and the sample
you've provided you will see two messages written at the end, together
having all the records.
I'll keep looking into it, but it might give you, or anyone else a clue as
to what's going on (if so, please post here)
Yossi
"Guy Barrette" <someone@nurun.com> wrote in message
news:OMf$42$cEHA.3300@TK2MSFTNGP09.phx.gbl...
> Thank you so much for your time. Here's the file:
>
> ABC,John,Doe,Microsoft,Redmond
> ABC,Paul,Doe,Microsoft,Redmond
> ABC,Ringo,Doe,Microsoft,Redmond
> XYZ,Starbucks,999 Main,Seattle,12345,USA
> XYZ,Etoile,7 Champs Elysee,Paris,12345,France
> ABC,Jane,Doe,Microsoft,Redmond
> XYZ,Coffee Shop,123 Main st,New York,12345,USA
>
>
> And the schema:
>
>
> <?xml version="1.0" encoding="utf-16" ?>
> - <xs:schema xmlns="http://AgenciesSchemas.MultipleRecords"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://AgenciesSchemas.MultipleRecords"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> - <xs:annotation>
> - <xs:appinfo>
> <b:schemaInfo count_positions_by_byte="false" standard="Flat File"
> root_reference="MultipleRecordsCSV" />
> <schemaEditorExtension:schemaInfo namespaceAlias="b"
> extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
> standardName="Flat File"
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
> aEditorExtensions" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="MultipleRecordsCSV">
> - <xs:annotation>
> - <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="1"
> child_delimiter_type="hex" child_delimiter="0x0D 0x0A"
child_order="postfix"
> />
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> - <xs:annotation>
> - <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element maxOccurs="unbounded" name="Nom">
> - <xs:annotation>
> - <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="1"
> child_delimiter_type="char" child_delimiter="," tag_name="ABC" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> - <xs:annotation>
> - <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="Prenom" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="1" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Nom" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="2" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Compagnie" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="3" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Ville" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="4" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> - <xs:element maxOccurs="unbounded" name="Compagnie">
> - <xs:annotation>
> - <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="2"
> child_delimiter_type="char" child_delimiter="," tag_name="XYZ" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> - <xs:annotation>
> - <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="Nom" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="1" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Adresse" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="2" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Ville" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="3" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Zip" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="4" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Pays" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="5" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
>
>
>
> "Yossi Dahan" <yossidahan@hotmail.com> wrote in message
> news:%23mwOh$%23cEHA.1424@tk2msftngp13.phx.gbl...
> look
> and
> ignored.
and[vbcol=seagreen]
is[vbcol=seagreen]
as[vbcol=seagreen]
> to
BizTalk[vbcol=seagreen]
>
>
| |
| Yossi Dahan 2004-07-28, 7:54 am |
| Guy hi
This is a schema that works for me. give it a try (and thanks for Tim Riley
for the help with this one...)
Yossi
<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns="http://AgenciesSchemas.MultipleRecords"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://AgenciesSchemas.MultipleRecords"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<b:schemaInfo count_positions_by_byte="false" standard="Flat File"
root_reference="MultipleRecordsCSV" />
<schemaEditorExtension:schemaInfo namespaceAlias="b"
extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
standardName="Flat File"
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
aEditorExtensions" />
</xs:appinfo>
</xs:annotation>
<xs:element name="MultipleRecordsCSV">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" sequence_number="1"
child_delimiter_type="hex" child_delimiter="0x0D 0x0A" child_order="postfix"
/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence minOccurs="0" maxOccurs="unbounded">
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
<xs:sequence minOccurs="0">
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Nom">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" child_delimiter_type="char"
child_delimiter="," tag_name="ABC" 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="Prenom" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Nom" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Compagnie" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Ville" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:sequence minOccurs="0">
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="2" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Compagnie">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" child_delimiter_type="char"
child_delimiter="," tag_name="XYZ" 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="Nom" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Adresse" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Ville" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Zip" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Pays" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
"Guy Barrette" <someone@nurun.com> wrote in message
news:OMf$42$cEHA.3300@TK2MSFTNGP09.phx.gbl...
> Thank you so much for your time. Here's the file:
>
> ABC,John,Doe,Microsoft,Redmond
> ABC,Paul,Doe,Microsoft,Redmond
> ABC,Ringo,Doe,Microsoft,Redmond
> XYZ,Starbucks,999 Main,Seattle,12345,USA
> XYZ,Etoile,7 Champs Elysee,Paris,12345,France
> ABC,Jane,Doe,Microsoft,Redmond
> XYZ,Coffee Shop,123 Main st,New York,12345,USA
>
>
> And the schema:
>
>
> <?xml version="1.0" encoding="utf-16" ?>
> - <xs:schema xmlns="http://AgenciesSchemas.MultipleRecords"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://AgenciesSchemas.MultipleRecords"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> - <xs:annotation>
> - <xs:appinfo>
> <b:schemaInfo count_positions_by_byte="false" standard="Flat File"
> root_reference="MultipleRecordsCSV" />
> <schemaEditorExtension:schemaInfo namespaceAlias="b"
> extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
> standardName="Flat File"
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
> aEditorExtensions" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="MultipleRecordsCSV">
> - <xs:annotation>
> - <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="1"
> child_delimiter_type="hex" child_delimiter="0x0D 0x0A"
child_order="postfix"
> />
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> - <xs:annotation>
> - <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element maxOccurs="unbounded" name="Nom">
> - <xs:annotation>
> - <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="1"
> child_delimiter_type="char" child_delimiter="," tag_name="ABC" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> - <xs:annotation>
> - <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="Prenom" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="1" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Nom" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="2" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Compagnie" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="3" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Ville" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="4" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> - <xs:element maxOccurs="unbounded" name="Compagnie">
> - <xs:annotation>
> - <xs:appinfo>
> <b:recordInfo structure="delimited"
> preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="2"
> child_delimiter_type="char" child_delimiter="," tag_name="XYZ" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:complexType>
> - <xs:sequence>
> - <xs:annotation>
> - <xs:appinfo>
> <b:groupInfo sequence_number="0" />
> </xs:appinfo>
> </xs:annotation>
> - <xs:element name="Nom" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="1" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Adresse" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="2" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Ville" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="3" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Zip" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="4" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> - <xs:element name="Pays" type="xs:string">
> - <xs:annotation>
> - <xs:appinfo>
> <b:fieldInfo justification="left" sequence_number="5" />
> </xs:appinfo>
> </xs:annotation>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
>
>
>
> "Yossi Dahan" <yossidahan@hotmail.com> wrote in message
> news:%23mwOh$%23cEHA.1424@tk2msftngp13.phx.gbl...
> look
> and
> ignored.
and[vbcol=seagreen]
is[vbcol=seagreen]
as[vbcol=seagreen]
> to
BizTalk[vbcol=seagreen]
>
>
| |
| Guy Barrette 2004-07-29, 7:50 am |
| Hi Yossi
Are you sure you posted the right file? I compared my schema and yours and
they are identical !
Thanks
Guy Barrette
"Yossi Dahan" <yossidahan@hotmail.com> wrote in message
news:ekkQ1pKdEHA.1604@TK2MSFTNGP11.phx.gbl...
> Guy hi
>
> This is a schema that works for me. give it a try (and thanks for Tim
Riley
> for the help with this one...)
>
> Yossi
> <?xml version="1.0" encoding="utf-16"?>
>
> <xs:schema xmlns="http://AgenciesSchemas.MultipleRecords"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> targetNamespace="http://AgenciesSchemas.MultipleRecords"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:schemaInfo count_positions_by_byte="false" standard="Flat File"
> root_reference="MultipleRecordsCSV" />
>
> <schemaEditorExtension:schemaInfo namespaceAlias="b"
> extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
> standardName="Flat File"
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
>
aEditorExtensions" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> <xs:element name="MultipleRecordsCSV">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" sequence_number="1"
> child_delimiter_type="hex" child_delimiter="0x0D 0x0A"
child_order="postfix"
> />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> <xs:complexType>
>
> <xs:sequence minOccurs="0" maxOccurs="unbounded">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:groupInfo sequence_number="0" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> <xs:sequence minOccurs="0">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:groupInfo sequence_number="1" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> <xs:element maxOccurs="unbounded" name="Nom">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" child_delimiter_type="char"
> child_delimiter="," tag_name="ABC" 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="Prenom" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="1" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Nom" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="2" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Compagnie" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="3" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Ville" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="4" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> </xs:sequence>
>
> </xs:complexType>
>
> </xs:element>
>
> </xs:sequence>
>
> <xs:sequence minOccurs="0">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:groupInfo sequence_number="2" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> <xs:element maxOccurs="unbounded" name="Compagnie">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:recordInfo structure="delimited"
preserve_delimiter_for_empty_data="true"
> suppress_trailing_delimiters="false" child_delimiter_type="char"
> child_delimiter="," tag_name="XYZ" 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="Nom" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="1" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Adresse" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="2" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Ville" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="3" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Zip" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="4" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> <xs:element name="Pays" type="xs:string">
>
> <xs:annotation>
>
> <xs:appinfo>
>
> <b:fieldInfo justification="left" sequence_number="5" />
>
> </xs:appinfo>
>
> </xs:annotation>
>
> </xs:element>
>
> </xs:sequence>
>
> </xs:complexType>
>
> </xs:element>
>
> </xs:sequence>
>
> </xs:sequence>
>
> </xs:complexType>
>
> </xs:element>
>
> </xs:schema>
>
>
>
>
> "Guy Barrette" <someone@nurun.com> wrote in message
> news:OMf$42$cEHA.3300@TK2MSFTNGP09.phx.gbl...
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
> child_order="postfix"
a[vbcol=seagreen]
1st[vbcol=seagreen]
> and
> is
> as
Itemfield's[vbcol=seagreen]
same[vbcol=seagreen]
> BizTalk
>
>
| |
| Yossi Dahan 2004-07-29, 5:51 pm |
| Guy hi,
I'm pretty sure I have, but just in case here is the one I've got:
<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns="http://AgenciesSchemas.MultipleRecords"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
targetNamespace="http://AgenciesSchemas.MultipleRecords"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:annotation>
<xs:appinfo>
<b:schemaInfo count_positions_by_byte="false" standard="Flat File"
root_reference="MultipleRecordsCSV" />
<schemaEditorExtension:schemaInfo namespaceAlias="b"
extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension"
standardName="Flat File"
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
aEditorExtensions" />
</xs:appinfo>
</xs:annotation>
<xs:element name="MultipleRecordsCSV">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" sequence_number="1"
child_delimiter_type="hex" child_delimiter="0x0D 0x0A" child_order="postfix"
/>
</xs:appinfo>
</xs:annotation>
<xs:complexType>
<xs:sequence minOccurs="0" maxOccurs="unbounded">
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="0" />
</xs:appinfo>
</xs:annotation>
<xs:sequence minOccurs="0">
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="1" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Nom">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" child_delimiter_type="char"
child_delimiter="," tag_name="ABC" 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="Prenom" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Nom" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Compagnie" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Ville" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:sequence minOccurs="0">
<xs:annotation>
<xs:appinfo>
<b:groupInfo sequence_number="2" />
</xs:appinfo>
</xs:annotation>
<xs:element maxOccurs="unbounded" name="Compagnie">
<xs:annotation>
<xs:appinfo>
<b:recordInfo structure="delimited" preserve_delimiter_for_empty_data="true"
suppress_trailing_delimiters="false" child_delimiter_type="char"
child_delimiter="," tag_name="XYZ" 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="Nom" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="1" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Adresse" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="2" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Ville" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="3" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Zip" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="4" />
</xs:appinfo>
</xs:annotation>
</xs:element>
<xs:element name="Pays" type="xs:string">
<xs:annotation>
<xs:appinfo>
<b:fieldInfo justification="left" sequence_number="5" />
</xs:appinfo>
</xs:annotation>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
sorry if I mislead you
Yossi Dahan
"Guy Barrette" <someone@nurun.com> wrote in message
news:OrcKK8WdEHA.712@TK2MSFTNGP09.phx.gbl...
> Hi Yossi
>
> Are you sure you posted the right file? I compared my schema and yours
and
> they are identical !
>
>
> Thanks
> Guy Barrette
>
>
> "Yossi Dahan" <yossidahan@hotmail.com> wrote in message
> news:ekkQ1pKdEHA.1604@TK2MSFTNGP11.phx.gbl...
> Riley
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
> preserve_delimiter_for_empty_data="true"
> child_order="postfix"
> preserve_delimiter_for_empty_data="true"
> preserve_delimiter_for_empty_data="true"
>
xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/Schem
have[vbcol=seagreen]
> a
> 1st
1st[vbcol=seagreen]
what[vbcol=seagreen]
clue[vbcol=seagreen]
> Itemfield's
> same
>
>
|
|
|
|
|