|
Home > Archive > BizTalk Server Orchestration > July 2005 > Envelope Processing
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 |
Envelope Processing
|
|
| SAJJAS 2005-06-29, 5:51 pm |
| I have an requirement to convert an enveloped (Header, Content >> Multiple
Records, Footer) text file, which needs to be converted to XML. So its
practically a transformation of just the Content to XML and i can leave the
header and footer behind. Please let me know what it takes to accomplish this.
--
SAJJAS
| |
| Tom Lysholt Hansen 2005-06-29, 5:51 pm |
| Hi,
I think you'll find this very usefull:
http://geekswithblogs.net/sthomas/a...2/12/17373.aspx
--
Regards
Tom Lysholt Hansen
GlobeTeam A/S
"SAJJAS" wrote:
> I have an requirement to convert an enveloped (Header, Content >> Multiple
> Records, Footer) text file, which needs to be converted to XML. So its
> practically a transformation of just the Content to XML and i can leave the
> header and footer behind. Please let me know what it takes to accomplish this.
> --
> SAJJAS
| |
| SAJJAS 2005-06-29, 5:51 pm |
| Example Text File
1MAZDACORPORATION,
2MAZDA629,
2MAZDAPROTEGE,
2MAZDAH,
3SENTYBSAJJAS,
The first and last line indicates the header and footer
The converted file should be
CAR=MAZDA629, UPDATE=YES,
CAR=MAZDAPROTEGE, UPDATE=YES,
CAR=MAZDAH, UPDATE=YES,
I was thinking if i could converte source file to destinatation file by
converting it to intermediately into XML data.
Please advise and thanks for all your help.
--
SAJJAS
"SAJJAS" wrote:
> I have an requirement to convert an enveloped (Header, Content >> Multiple
> Records, Footer) text file, which needs to be converted to XML. So its
> practically a transformation of just the Content to XML and i can leave the
> header and footer behind. Please let me know what it takes to accomplish this.
> --
> SAJJAS
| |
| Tom Lysholt Hansen 2005-06-29, 5:51 pm |
| First you must be shure that you are able to determine the exact format of
the files.
Will the format of the incomming file always be:
1st line = header ended by a CRLF
last line = footer (will it be ended by a trailing CRLF og not?)
All lines inbetween = the number 2 followed by a string that represent the
value followed by a comma and a CRLF
And the destination file:
Each line is "CAR=" followed by the string from the "2-lines" above followed
again by ", update=yes" + CRLF?
Will there have to be a trailing CRLF after the last line?
Should there be a leading CRLF before the first line?
If you want to use BizTalk to assist you in this conversion you'll have to
use XML as intermediate format.
If you answer the questions I'll see if I can find a minutte to help you get
started. Perhaps you could give me a few more example files as well?
--
Regards
Tom Lysholt Hansen
"SAJJAS" wrote:
[vbcol=seagreen]
> Example Text File
> 1MAZDACORPORATION,
> 2MAZDA629,
> 2MAZDAPROTEGE,
> 2MAZDAH,
> 3SENTYBSAJJAS,
>
> The first and last line indicates the header and footer
>
> The converted file should be
> CAR=MAZDA629, UPDATE=YES,
> CAR=MAZDAPROTEGE, UPDATE=YES,
> CAR=MAZDAH, UPDATE=YES,
>
>
> I was thinking if i could converte source file to destinatation file by
> converting it to intermediately into XML data.
>
> Please advise and thanks for all your help.
> --
> SAJJAS
>
>
> "SAJJAS" wrote:
>
| |
| SAJJAS 2005-06-29, 5:51 pm |
| Tom,
The input file is a positional flat file with header, body and footer.
Answers to your questions are as follows,
Will the format of the incomming file always be:
1st line = header ended by a CRLF
[SAJJAS] ends with ","
last line = footer (will it be ended by a trailing CRLF og not?)
[SAJJAS] trailing ","
All lines inbetween = the number 2 followed by a string that represent the
value followed by a comma and a CRLF
[SAJJAS] positional and ends with ","
And the destination file:
Each line is "CAR=" followed by the string from the "2-lines" above followed
again by ", update=yes" + CRLF?
[SAJJAS] true ends with CRLF and each field is seperated from the other by ","
Will there have to be a trailing CRLF after the last line?
[SAJJAS] No
Should there be a leading CRLF before the first line?
[SAJJAS] No
If you want to use BizTalk to assist you in this conversion you'll have to
use XML as intermediate format.
[SAJJAS] True
Please let me know
--
SAJJAS
"Tom Lysholt Hansen" wrote:
[vbcol=seagreen]
> First you must be shure that you are able to determine the exact format of
> the files.
>
> Will the format of the incomming file always be:
>
> 1st line = header ended by a CRLF
> last line = footer (will it be ended by a trailing CRLF og not?)
>
> All lines inbetween = the number 2 followed by a string that represent the
> value followed by a comma and a CRLF
>
> And the destination file:
>
> Each line is "CAR=" followed by the string from the "2-lines" above followed
> again by ", update=yes" + CRLF?
>
> Will there have to be a trailing CRLF after the last line?
> Should there be a leading CRLF before the first line?
>
> If you want to use BizTalk to assist you in this conversion you'll have to
> use XML as intermediate format.
>
> If you answer the questions I'll see if I can find a minutte to help you get
> started. Perhaps you could give me a few more example files as well?
> --
> Regards
> Tom Lysholt Hansen
>
>
> "SAJJAS" wrote:
>
| |
| Tom Lysholt Hansen 2005-06-29, 5:51 pm |
| I've constructed a small example containing input schema, output schema and a
mapping that should help you out. If you can give me an email address without
exposing yourself to more spam, I'll send you a zipped VS .NET 2003 project.
I'll have to tell you, that I'm positioned in Denmark and that make time
zones an issue (i don't know your time zon). We have CET (GMT +1), so it's
11pm right now, som I might not get back to you untill tomorrow morning CET.
--
Regards
Tom Lysholt Hansen
"Tom Lysholt Hansen" wrote:
[vbcol=seagreen]
> First you must be shure that you are able to determine the exact format of
> the files.
>
> Will the format of the incomming file always be:
>
> 1st line = header ended by a CRLF
> last line = footer (will it be ended by a trailing CRLF og not?)
>
> All lines inbetween = the number 2 followed by a string that represent the
> value followed by a comma and a CRLF
>
> And the destination file:
>
> Each line is "CAR=" followed by the string from the "2-lines" above followed
> again by ", update=yes" + CRLF?
>
> Will there have to be a trailing CRLF after the last line?
> Should there be a leading CRLF before the first line?
>
> If you want to use BizTalk to assist you in this conversion you'll have to
> use XML as intermediate format.
>
> If you answer the questions I'll see if I can find a minutte to help you get
> started. Perhaps you could give me a few more example files as well?
> --
> Regards
> Tom Lysholt Hansen
>
>
> "SAJJAS" wrote:
>
| |
| SAJJAS 2005-06-29, 5:51 pm |
| my email address is sudheer_sajja@yahoo.com
--
SAJJAS
"Tom Lysholt Hansen" wrote:
[vbcol=seagreen]
> I've constructed a small example containing input schema, output schema and a
> mapping that should help you out. If you can give me an email address without
> exposing yourself to more spam, I'll send you a zipped VS .NET 2003 project.
>
> I'll have to tell you, that I'm positioned in Denmark and that make time
> zones an issue (i don't know your time zon). We have CET (GMT +1), so it's
> 11pm right now, som I might not get back to you untill tomorrow morning CET.
> --
> Regards
> Tom Lysholt Hansen
>
>
> "Tom Lysholt Hansen" wrote:
>
| |
| SAJJAS 2005-06-30, 6:00 pm |
| Tom,
I wasnt able to run the application , could you give me an insight as to
whether i need to create an orchestration and configure ports for input and
output.
Thanks for you help
--
SAJJAS
"Tom Lysholt Hansen" wrote:
[vbcol=seagreen]
> I've constructed a small example containing input schema, output schema and a
> mapping that should help you out. If you can give me an email address without
> exposing yourself to more spam, I'll send you a zipped VS .NET 2003 project.
>
> I'll have to tell you, that I'm positioned in Denmark and that make time
> zones an issue (i don't know your time zon). We have CET (GMT +1), so it's
> 11pm right now, som I might not get back to you untill tomorrow morning CET.
> --
> Regards
> Tom Lysholt Hansen
>
>
> "Tom Lysholt Hansen" wrote:
>
| |
| Tom Lysholt Hansen 2005-06-30, 6:00 pm |
| You can do 2 things to test the sample.
The simplest is to use the Test Map funciton of the BizTalk Mapper. Set the
input.txt as input instance and set the output format to native. That will
only give you an idea of the quality of the map and the schemas.
The one that looks most like a production solution is:
1) Ad a receive pipeline and a send pipeline to the project.
2) insert the Flat file disassembler into the receive pipeline and configure
it to use the input schema
3) insert the Flat file assembler into the send pipeline and configure it to
use the outpu schema
4) Deploy the solution (you need to provide a key-file/strong name first)
5) Create a receive port and a file receive location using the receive
pipeline you created - configure the receive port to use the map
6) Create a file send port using the send pipeline you created.
7) Set the filter of the sendport to: bts.ReceivePortName == (the name of
your receive port)
8) Enable the receive location and start the send port.
This link looks like a good help:
http://geekswithblogs.net/synboogal...5/31/41073.aspx
This should do the trick. You should now be able to drop files and have them
converted.
--
Regards
Tom Lysholt Hansen
"SAJJAS" wrote:
[vbcol=seagreen]
> Tom,
>
> I wasnt able to run the application , could you give me an insight as to
> whether i need to create an orchestration and configure ports for input and
> output.
>
> Thanks for you help
>
> --
> SAJJAS
>
>
> "Tom Lysholt Hansen" wrote:
>
| |
| SAJJAS 2005-06-30, 6:00 pm |
| Tom,
In the mapper i see that you have a string functoid used, wondering how do i
code more changes to it, also please recommend an article for more
information on that.
--
SAJJAS
"Tom Lysholt Hansen" wrote:
[vbcol=seagreen]
> You can do 2 things to test the sample.
>
> The simplest is to use the Test Map funciton of the BizTalk Mapper. Set the
> input.txt as input instance and set the output format to native. That will
> only give you an idea of the quality of the map and the schemas.
>
> The one that looks most like a production solution is:
>
> 1) Ad a receive pipeline and a send pipeline to the project.
> 2) insert the Flat file disassembler into the receive pipeline and configure
> it to use the input schema
> 3) insert the Flat file assembler into the send pipeline and configure it to
> use the outpu schema
> 4) Deploy the solution (you need to provide a key-file/strong name first)
> 5) Create a receive port and a file receive location using the receive
> pipeline you created - configure the receive port to use the map
> 6) Create a file send port using the send pipeline you created.
> 7) Set the filter of the sendport to: bts.ReceivePortName == (the name of
> your receive port)
> 8) Enable the receive location and start the send port.
>
> This link looks like a good help:
> http://geekswithblogs.net/synboogal...5/31/41073.aspx
>
>
> This should do the trick. You should now be able to drop files and have them
> converted.
> --
> Regards
> Tom Lysholt Hansen
>
>
> "SAJJAS" wrote:
>
| |
| Tom Lysholt Hansen 2005-07-01, 5:54 pm |
| Hi,
I've used a concatenate functiod to build the output string. It concatenates
all the input strings - and I've passed the data from the input schema and a
constant ", UPDATE=YES".
You can configure the functiod by selecting the functiod in the map and then
click the "..." symbol in the "Configure Functoid Inputs"-entry in the
property window.
A good link to start out by could be:
http://msdn.microsoft.com/library/d...og_map_sqws.asp
I'll also Recommend tho book "BizTalk 2004 Unleashed" by Scott Woodgate and
a couple of other guys.
--
Regards
Tom Lysholt Hansen
"SAJJAS" wrote:
[vbcol=seagreen]
> Tom,
>
> In the mapper i see that you have a string functoid used, wondering how do i
> code more changes to it, also please recommend an article for more
> information on that.
>
> --
> SAJJAS
>
>
> "Tom Lysholt Hansen" wrote:
>
|
|
|
|
|