| Author |
Message
|
| Jithesh shetty |
 Posted: Mon Nov 12, 2007 1:27 am Post subject: ESQL coding..WMB |
 |
|
Acolyte
Joined: 30 Oct 2007
Posts: 51
|
Hi,
I am using File Extender to picks up the flat file from the folder.......then this is passed to compute node their i have to do following task....
1) To store the flat file in an array.
2) To Create the XML message from that node itself.
Can any one help in this.....
regards
jithesh Shetty |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Mon Nov 12, 2007 1:34 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Jithesh shetty,
Use a message set, create the structure that your are expecting from the file...read the entire file and get it parsed against the message set.
Then do the conversion to XMLNS/XMLNSC domain in ESQL.
Regards. |
|
| Back to top |
|
|
| Jithesh shetty |
| Posted: Mon Nov 12, 2007 1:42 am Post subject: ESQL coding..WMB |
|
|
Acolyte
Joined: 30 Oct 2007
Posts: 51
|
hi,
i am beginner for this tool i don't know dept in this tool.....
i' will create the message set for structure of the o/p XML message....
can u tell me how to store the entire input message(Flat file) into array...and conversion from flat file to XML using ESQl
Regards
Jithesh Shettty[/i] |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Nov 12, 2007 1:49 am Post subject: Re: ESQL coding..WMB |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Jithesh shetty wrote: |
| i am beginner for this tool i don't know dept in this tool..... |
May I,with all respect, suggest you seek training sooner rather than later? WMB is not a straightforward tool with many levels of functionality and you will find benefit from a formal informational process.
This forum is not the best medium for such training.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Jithesh shetty |
| Posted: Mon Nov 12, 2007 8:07 pm Post subject: ESQL coding..WMB |
|
|
Acolyte
Joined: 30 Oct 2007
Posts: 51
|
hi,
Now i have created XML structure using ESQl coding.....i have to pass the values for that.....
i am sending a input flat file message.....
VMI;INVRPT;VMI_INVRPTD97A_1553;VMI;040611121212;062011121212;032;5038495000019;0027855;GBP;0563754455;1232-2141-5212;VMI;WOKHOhosub/4077;100
VMI;INVRPT;VMI_INVRPTD97A_1553;VMI;040611121212;062011121212;032;5038495000019;0027855;GBP;0812344365;1232-2141-6961;VMI;WOKHOhosub/4066;100
the output should be look like this......
<?xml version="1.0"?>
<VMIINVRPTD97A>
<VMI>
<HEADER>VMI</HEADER>
<MSGTYPE>INVRPT</MSGTYPE>
<DOCUMENTID>VMI_INVRPTD97A_1553</DOCUMENTID>
<FREETEXTID1>VMI</FREETEXTID1>
<DOCISSUEDT>040611121212</DOCISSUEDT>
<INVRPTDT>062011121212</INVRPTDT>
<INVRPTPARTY>032</INVRPTPARTY>
<SUPPLIER>5038495000019</SUPPLIER>
<BUYER>0027855</BUYER>
<CURRENCY>GBP</CURRENCY>
<ITEMREFNO>0563754455</ITEMREFNO>
<ADDITEMREFNO>1232-2141-5212</ADDITEMREFNO>
<FREETEXTID2>VMI</FREETEXTID2>
<LINEITEMREFNO>WOKHOhosub/4077</LINEITEMREFNO>
<QTY>100</QTY>
</VMI>
<VMI>
<HEADER>VMI</HEADER>
<MSGTYPE>INVRPT</MSGTYPE>
<DOCUMENTID>VMI_INVRPTD97A_5003</DOCUMENTID>
<FREETEXTID1>VMI</FREETEXTID1>
<DOCISSUEDT>040611121212</DOCISSUEDT>
<INVRPTDT>062011121212</INVRPTDT>
<INVRPTPARTY>032</INVRPTPARTY>
<SUPPLIER>5038495000019</SUPPLIER>
<BUYER>0027855</BUYER>
<CURRENCY>GBP</CURRENCY>
<ITEMREFNO>0812344365</ITEMREFNO>
<ADDITEMREFNO>1232-2141-6961</ADDITEMREFNO>
<FREETEXTID2>VMI</FREETEXTID2>
<LINEITEMREFNO>WOKHOhosub/4066</LINEITEMREFNO>
<QTY>100</QTY>
</VMI>
</VMIINVRPTD97A>
please help me in this.......
Regards
Jithesh....[/b] |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Nov 13, 2007 1:45 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Follow the advice of elvis_gn, who has given the best method of achieving your aims.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
