All
I expect following flat file from my XML file. How will I achieve it by BTS 
2004? say using Mapper? I am new to BTS 2004

[Document]  -- This is the root tag that should come
[NAME CAR] -- Name of mine
[COMMENT Comment Test ] --- Comment
[ID 00002] - Unique ID
[COU CUS ] - Country I belong to
[DOC Sample.doc] - DOcument name
[End Of File]

My questions are:

1) Using "[" or "]" in schmea is invalid. But in some posts I saw that I
 can make square brackets as a part of data itself, which means that I need 
to have a scripting functoid that would give me abobe result.

2) In the above flat file the COU, DOC tags occur multiple times, when they 
occur multiples times in my source schema my flat should look like this, XXX
uming you have 2 COU and DOC tags in my source schema, then my flat file sho
uld look like

[COU CUS,AUS]
[DOC sample.doc, sample1.txt]

I know that if I ahve a XML, I can convert it to a Flat file using a pipelin
e. But I want my pipeline to look in above format. How to do I achieve the s
ame?

Is it advisable to use a scripting functoid and generate a XML file containi
ng a sting of above format, and then give that XML file to pipeline and conv
ert it as a flat file using flat file assembler. If I do this way, then in m
y flat file I am getting th
e root say starting node of XML file is also coming. How will I get rid of t
he same.

Thanks in advance

[ Post a follow-up to this message ]

I'd put the special characters in your flat file schema using them as
delimeters.

Matt


"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:4093C09A-6CC6-4478-90EF-C0A0531C151E@microsoft.com...
> All
> I expect following flat file from my XML file. How will I achieve it by
BTS 2004? say using Mapper? I am new to BTS 2004
>
> [Document]  -- This is the root tag that should come
> [NAME CAR] -- Name of mine
> [COMMENT Comment Test ] --- Comment
> [ID 00002] - Unique ID
> [COU CUS ] - Country I belong to
> [DOC Sample.doc] - DOcument name
> [End Of File]
>
> My questions are:
>
> 1) Using "[" or "]" in schmea is invalid. But in some posts I saw that I[/vbco
l]
can make square brackets as a part of data itself, which means that I need
to have a scripting functoid that would give me abobe result.[vbcol=seagreen]
>
> 2) In the above flat file the COU, DOC tags occur multiple times, when
they occur multiples times in my source schema my flat should look like
this, assuming you have 2 COU and DOC tags in my source schema, then my flat
file should look like
>
> [COU CUS,AUS]
> [DOC sample.doc, sample1.txt]
>
> I know that if I ahve a XML, I can convert it to a Flat file using a
pipeline. But I want my pipeline to look in above format. How to do I
achieve the same?
>
> Is it advisable to use a scripting functoid and generate a XML file
containing a sting of above format, and then give that XML file to pipeline
and convert it as a flat file using flat file assembler. If I do this way,
then in my flat file I am getting the root say starting node of XML file is
also coming. How will I get rid of the same.
>
> Thanks in advance

[ Post a follow-up to this message ]

Matt

Can you please explain elabratey how would you do that
Thanks in advance

[ Post a follow-up to this message ]

Also , Matt what about my second question?

[ Post a follow-up to this message ]

Sorry, I'm not that well versed in flat file schemas.  However, you should
be able to set delimeters on your flat file schema so that you get the
brackets you want.  As for combining the elements into one element, you
should be able to use the cumulative concatenate functoid to do that.


Matt


"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:68D43299-A33A-4388-8833-0420556B3F1D@microsoft.com...
> Matt
>
> Can you please explain elabratey how would you do that
> Thanks in advance
>

[ Post a follow-up to this message ]

Edison,

Can you attach an instance of your document in the exact format you expect?

--
Dave

This posting is provided "AS IS" with no warranties, and confers no rights.

"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:4093C09A-6CC6-4478-90EF-C0A0531C151E@microsoft.com...
> All
> I expect following flat file from my XML file. How will I achieve it by
BTS 2004? say using Mapper? I am new to BTS 2004
>
> [Document]  -- This is the root tag that should come
> [NAME CAR] -- Name of mine
> [COMMENT Comment Test ] --- Comment
> [ID 00002] - Unique ID
> [COU CUS ] - Country I belong to
> [DOC Sample.doc] - DOcument name
> [End Of File]
>
> My questions are:
>
> 1) Using "[" or "]" in schmea is invalid. But in some posts I saw that I[/vbco
l]
can make square brackets as a part of data itself, which means that I need
to have a scripting functoid that would give me abobe result.[vbcol=seagreen]
>
> 2) In the above flat file the COU, DOC tags occur multiple times, when
they occur multiples times in my source schema my flat should look like
this, assuming you have 2 COU and DOC tags in my source schema, then my flat
file should look like
>
> [COU CUS,AUS]
> [DOC sample.doc, sample1.txt]
>
> I know that if I ahve a XML, I can convert it to a Flat file using a
pipeline. But I want my pipeline to look in above format. How to do I
achieve the same?
>
> Is it advisable to use a scripting functoid and generate a XML file
containing a sting of above format, and then give that XML file to pipeline
and convert it as a flat file using flat file assembler. If I do this way,
then in my flat file I am getting the root say starting node of XML file is
also coming. How will I get rid of the same.
>
> Thanks in advance

[ Post a follow-up to this message ]

Dave

Thanks. Can you please share the project work. Let me know your eamil id ple
ase.

[ Post a follow-up to this message ]

Dave

I did not understand the reason behind putting xmlns for each element. Can y
ou pls explain.
Also please let me know how to access your project.

Thanks in advance

Thanks christof and Matt

[ Post a follow-up to this message ]

Edison,

Apparently the project I attached to the last response is inaccessable.
Send me an email to the following addresss and I'll attach it to the
response.

ddowning@microsoft.com

--
Dave

This posting is provided "AS IS" with no warranties, and confers no rights.

"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:8A5C8169-616D-42CA-B6BE-4DFE341E6C08@microsoft.com...
> Dave
>
> Thanks. Can you please share the project work. Let me know your eamil id
please.
>

[ Post a follow-up to this message ]

The xmlns="" is simply indicating that the names are unqualified.  If you
visit http://www.w3.org/ you can find a world of information regarding both
XML and XSD.

--
Dave

This posting is provided "AS IS" with no warranties, and confers no rights.

"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:B575F212-342D-4207-9EA0-8D76690E09AB@microsoft.com...
> Dave
>
> I did not understand the reason behind putting xmlns for each element. Can
you pls explain.
> Also please let me know how to access your project.
>
> Thanks in advance
>
> Thanks christof and Matt

[ Post a follow-up to this message ]