| Author |
Flat File Mapping Help
|
|
| Edison 2004-04-24, 7:34 am |
| 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, 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 th
e root say starting node of XML file is also coming. How will I get rid of the same.
Thanks in advance
| |
| Matt Milner 2004-04-24, 10:35 pm |
| 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
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, 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
| |
| Edison 2004-04-25, 12:35 am |
| Matt
Can you please explain elabratey how would you do that
Thanks in advance
| |
| Edison 2004-04-25, 2:34 am |
| Also , Matt what about my second question?
| |
| Matt Milner 2004-04-25, 9:36 pm |
| 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
>
| |
| David Downing [MSFT] 2004-04-26, 4:36 pm |
| 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
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, 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
| |
| Edison 2004-04-27, 12:35 am |
| Dave
Thanks. Can you please share the project work. Let me know your eamil id please.
| |
| Edison 2004-04-27, 10:36 am |
| 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
| |
| David Downing [MSFT] 2004-04-27, 11:37 am |
| 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.
>
| |
| David Downing [MSFT] 2004-04-27, 12:36 pm |
| 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
| |
| David Downing [MSFT] 2004-04-27, 2:36 pm |
| There is a setting in Outlook Express under tools | options | security tab.
Uncheck the "Do not allow attachments to be saved or opened that could
potentially be a virus". This should allow you to access my attachment.
--
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.
>
| |
| Edison 2004-04-28, 10:35 am |
| Dave
I have sent an email to you. I am sorry I am not able to download the attachment
THanks in advance
| |
| Edison 2004-04-29, 8:36 am |
| Dave
When I run your project I am getting "error: SQL Server could not be found" compilation error.
But I do have SQL Server on my machine and it is running fine
Thanks
| |
| David Downing [MSFT] 2004-04-29, 5:36 pm |
| Right Click on the BizTalk Project from the Solution Explorer and select
properties.
Click on Configuration Properties / Deployment
In the Server row type in the name of the server you're deploying to.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:2FC7D21E-778E-4E34-9059-B7CF9987D23D@microsoft.com...
> Dave
>
> When I run your project I am getting "error: SQL Server could not be
found" compilation error.
>
> But I do have SQL Server on my machine and it is running fine
>
> Thanks
>
| |
| Edison 2004-05-12, 9:01 am |
| Hi Dave
I have a requirement like this
My flat file contents would come through a .Net assembly in other words, I am filling up the contents in my schema using a scripting functoid.
My schema looks like below:
<DestinationType><Content><value retrieved from scripting functoid><Content></Destinationtype>
What is happening is, in my flat file I am getting the root nodes that is Destinationtype and content tags are also coming.
I tried setting postfix, child delimiter for content/destinationtype nodes. But of no use.
Please help.
Thanks in advance
| |
| David Downing [MSFT] 2004-05-12, 1:18 pm |
| Edison,
Can you post your schema and the XML instance data that's being submitted to
the flat file assembler?
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:AF9310C2-3E78-4EB0-AB46-6C7154C93C7E@microsoft.com...
> Hi Dave
>
> I have a requirement like this
>
> My flat file contents would come through a .Net assembly in other words, I
am filling up the contents in my schema using a scripting functoid.
>
> My schema looks like below:
>
> <DestinationType><Content><value retrieved from scripting
functoid><Content></Destinationtype>
>
> What is happening is, in my flat file I am getting the root nodes that is
Destinationtype and content tags are also coming.
> I tried setting postfix, child delimiter for content/destinationtype
nodes. But of no use.
>
> Please help.
>
> Thanks in advance
| |
| Edison 2004-05-13, 12:00 pm |
| Dave
I have sent my sample output file by email to you. Please help me in fixing this issue. In my sample file I do not want the root node to appear in my flat file.
Thanks in advance.
| |
| Edison 2004-05-17, 10:35 am |
| Dave
After incorporating that, when I try to load or send my flat file to my destination host using FTP Adapter, I am getting FileNotFoundException.
But I am able to access it.
Anything else I need to set?
Thanks
| |
| David Downing [MSFT] 2004-05-17, 11:41 am |
| Make sure the file you drop into your receive location is not read only.
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edison" <anonymous@discussions.microsoft.com> wrote in message
news:397703C0-5B13-48D9-8674-70D0D8B079F5@microsoft.com...
> Dave
>
> After incorporating that, when I try to load or send my flat file to my
destination host using FTP Adapter, I am getting FileNotFoundException.
>
> But I am able to access it.
>
> Anything else I need to set?
>
> Thanks
| |
| Edison 2004-05-24, 4:37 pm |
| Dave
I have ensured that it is not read only. The folder has full permissions
What should I do?
Thanks
| |
| David Downing [MSFT] 2004-05-25, 4:37 pm |
| Can you post your zipped up project. Also include the exact directory
where you have the project located on your computer.
Thank you,
Dave
| |
| David Downing [MSFT] 2004-05-30, 10:46 am |
| Looks like the thread was broken. Can you post your zipped up project and
a description of how you're setting this up, and any other pertinent
information?
Thank you,
Dave
--
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|