|
Home > Archive > BizTalk Server General > May 2004 > Using the Flat File Disassembler
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 |
Using the Flat File Disassembler
|
|
| chabber 2004-05-13, 5:52 pm |
| I am new to BTS2004, and just looking at the help files it is not apparent how to disassemble a flat file into an xml document? I gathered after long hours of searching on the web, that this can only be done through the use of a Schema (xsd)? Aren't XSD
files used for xml validation? Does anyone know of any good tutorials or instructions for converting a flat file into an XML Document using BTS2004?
Thank you.
| |
| Scott Colestock 2004-05-13, 5:52 pm |
| Schemas are used to describe flat files in BizTalk 2004 - standard XSD
schemas with additional annotations the describe the structure of the
document.
You will want to create a schema, and in the "Schema Editor Extensions"
property of the schema, specify "Flat File Extensions". This will allow you
to specify delimited or positional, etc. and begin describing the schema of
the flat file.
Also, you will need a pipeline that contains the flat file assembler or
disassembler - see program files\microsoft biztalk
2004\sdk\samples\pipelines\assemblerdisa
ssembler directory.
- Scott Colestock
"chabber" <chris.habbershaw@trancentrix.com> wrote in message
news:4BDC9AD1-E59A-41E6-86CB-7208F8A1C060@microsoft.com...
> I am new to BTS2004, and just looking at the help files it is not apparent
how to disassemble a flat file into an xml document? I gathered after long
hours of searching on the web, that this can only be done through the use of
a Schema (xsd)? Aren't XSD files used for xml validation? Does anyone know
of any good tutorials or instructions for converting a flat file into an XML
Document using BTS2004?
>
> Thank you.
| |
| chabber 2004-05-13, 5:52 pm |
| I have a receive pipeline with a flat file disassembler. I just don't know how to create
the Flat File Schema. I tried creating a schema with Flat File Extensions, but nowhere did
I see an option delineating between positional and delimited. I also tried creating child field elements
and tried to specify the starting point and width for my first field, but nowhere did I see
any positional start or length properties on these field elements. I also need to skip record headers,
but again the documentation provides no clue on how to do this either.
This is a great product. It just lacks a lot of documentation and tutorials. The two modules they give
as tutorials are great, but do not encompass a lot of the functionality.
-chabber
----- Scott Colestock wrote: -----
Schemas are used to describe flat files in BizTalk 2004 - standard XSD
schemas with additional annotations the describe the structure of the
document.
You will want to create a schema, and in the "Schema Editor Extensions"
property of the schema, specify "Flat File Extensions". This will allow you
to specify delimited or positional, etc. and begin describing the schema of
the flat file.
Also, you will need a pipeline that contains the flat file assembler or
disassembler - see program files\microsoft biztalk
2004\sdk\samples\pipelines\assemblerdisa
ssembler directory.
- Scott Colestock
"chabber" <chris.habbershaw@trancentrix.com> wrote in message
news:4BDC9AD1-E59A-41E6-86CB-7208F8A1C060@microsoft.com...
> I am new to BTS2004, and just looking at the help files it is not apparent
how to disassemble a flat file into an xml document? I gathered after long
hours of searching on the web, that this can only be done through the use of
a Schema (xsd)? Aren't XSD files used for xml validation? Does anyone know
of any good tutorials or instructions for converting a flat file into an XML
Document using BTS2004?[vbcol=seagreen]
| |
| chabber 2004-05-14, 4:36 pm |
| This works for one line only (e.g. Item1, Item2, Item3, Item4), however when
I add a second line to the csv file the xml returned does not include an
elements past 4 items. Do you know what I am overlooking? I noticed that the
attached xsd did have a child delimiter of cr/lf in hexidecimal, but I don't
know why this would not be working.
-chabber
"David Downing [MSFT]" <ddowning@online.microsoft.com> wrote in message
news:ubrtYoUOEHA.2716@tk2msftngp13.phx.gbl...
> I've attached a very simple flat file schema add it to your project and it
> should allow you to get started. The structure is as follows:
>
> Root delimited, postfix, <cr><lf>
> Record1 delimited, infix, ,
> Field1
> Field2
> Field3
> Field4
> Field5
>
>
> --
> Dave
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "chabber" <anonymous@discussions.microsoft.com> wrote in message
> news:9D037B1E-4D39-4CE2-AA86-35E0AC819DD4@microsoft.com...
> know how to create
> Extensions, but nowhere did
> tried creating child field elements
but[vbcol=seagreen]
> nowhere did I see
also[vbcol=seagreen]
> need to skip record headers,
> tutorials. The two modules they give
> XSD
the[vbcol=seagreen]
> Extensions"
> allow you
> schema of
assembler[vbcol=seagreen]
> or
> apparent
> after long
the[vbcol=seagreen]
> use of
> anyone know
into[vbcol=seagreen]
> an XML
>
>
>
| |
| David Downing [MSFT] 2004-05-14, 5:37 pm |
| Try setting the maxOccurs for Record1 to unbounded.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"chabber" <chabber@cox.net> wrote in message
news:eGkVDMfOEHA.808@tk2msftngp13.phx.gbl...
> This works for one line only (e.g. Item1, Item2, Item3, Item4), however
when
> I add a second line to the csv file the xml returned does not include an
> elements past 4 items. Do you know what I am overlooking? I noticed that
the
> attached xsd did have a child delimiter of cr/lf in hexidecimal, but I
don't
> know why this would not be working.
>
> -chabber
>
> "David Downing [MSFT]" <ddowning@online.microsoft.com> wrote in message
> news:ubrtYoUOEHA.2716@tk2msftngp13.phx.gbl...
it[vbcol=seagreen]
> rights.
> but
> also
functionality.[vbcol=seagreen]
standard[vbcol=seagreen]
> the
will[vbcol=seagreen]
> assembler
not[vbcol=seagreen]
> the
> into
>
>
| |
| David Downing [MSFT] 2004-05-24, 4:37 pm |
| This issue should be resolved.
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|