on 03-17-2010 1:41 PM
Hi Guys,
I am using Multimapping to generate 2 target messages and finally creating these 2 messges as csv files. But i need to use variable substitution (because dynamic configuration doesnt work in multimapping) to create the target files and i need to omit this node from content. i know if it is fixed length file we can use variable substitution and finally we can cut the variable in content conversion by using below method
fixedLengthToodShortHandling cut
Note:- I am using PI7.1
thanks,
madhu
Hi, Madhu
To omit only one node, use :
node.fieldFixedLengths --> 0,0,...0
node.fixedLengthTooShortHandling --> Cut
node.endSeparator --> '0'
Regards,
Carme
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi alentorn
assume below is my target payload
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_MadhuMulti xmlns:ns0="http://rr.unilever.com/bconepi13">
<Strutcture>
<Name>Syam</Name>
<Sex>FEMALE</Sex>
<ID>123</ID>
<Filename>EmpDetails</EmpDetails>
</Strutcture>
<Strutcture>
<Name>Syam1</Name>
<Sex>Male</Sex>
<ID>789</ID>
<Filename>EmpDetails</EmpDetails>
</Strutcture>
</ns0:MT_MadhuMulti>
i want file name as EmpDetails.txt
and file content as below
Syam,Female,123
Syam1,Male,789
Can you tell me my content conversion parametersv in receiver channel???
thanks,
Madhu
You must separate variable filename from the other fields in several nodes.
.
Please, analyze if you can change your scenario, with next stucture:
<ns0:MT_MadhuMulti xmlns:ns0="http://rr.unilever.com/bconepi13">
<Strutcture>
<Name>Syam</Name>
<Sex>FEMALE</Sex>
<ID>123</ID>
</Strutcture>
</Strutcture>
<Strutcture>
<Name>Syam1</Name>
<Sex>Male</Sex>
<ID>789</ID>
</Strutcture>
<nothing>
...
<Filename>EmpDetails</EmpDetails>
</nothing>
</ns0:MT_MadhuMulti>
And then in your CC:
Recordset strucutre --> Structure,nothing
Structure.fieldSeparator --> ;
nothing.fieldFixedLengths --> 0
nothing.fixedLengthTooShortHandling --> Cut
nothing.endSeparator --> '0'
Regards,
Carme.
Hi Madhu,
Can you change the structure as mentioned in this blog. She mentioned exactly the same issue you have:
/people/sravya.talanki2/blog/2005/08/11/solution-to-the-problem-encountered-using-variable-substitution-with-xi-sp12
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If we are on the same page, this might help you - /people/shabarish.vijayakumar/blog/2010/01/14/file-conversion-using-nodeception
VJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.