FCC in Sender Adapter

[Former Member]

Hi Experts,

My Input file contains following structure:

101

102

103

104

Now I want to generate following source XML file using FCC in sender file adapter

<?xml version="1.0" encoding="utf-8" ?>

<ns:MT_Employee xmlns:ns="http://Test_Employee">

<Employee>

<EmpID>101</EmpID>

<EmpID>102</EmpID>

<EmpID>103</EmpID>

<EmpID>104</EmpID>

</Employee>

</ns:MT_Employee>

Pls let me know what will be values for following parameters:

Document Name: <This would be MT_Employee probably>

Document NS: <This would be http://Test_Employee probably>

Document Offset : <Blank because we need values from first row onwards>

RecordSet Name:

RecordSet NS:

RecordSet Structure:

RecordSet Sequence:

Recordsets per Msg:

Key Field Name:

KetField Type:

Parameters:

Pls let me know all the parameters required to attain above XML

Thanks,

Rakesh

[baskar_gopalakrishnan2]

Document Name: MT_Employee
Document Namespace:http://Test_Employee
Document Offset:  leave blank
Recordset Name: leave blank
Recordset Namespace: leave blank
Recordset Structure: Employee,*
Recordset sequence Ascending
Recordsets per message  *
key Field Name    leave blank
key Field Type   String (case sensitive)

Note: Since you have just one field value , you dont need any field name here. Just leave blank. Fill only mandatory characters.

Plus you need to specify name value fields below.... that's it.

Employee.endSeparator            'nl'
Employee.fieldNames                EmpID

Hope that helps

Edited by: Baskar Gopal on Apr 21, 2011 9:41 AM

[Former Member]

Hi Gopal,

I have provided the parameters said by u, but it did'nt work. We have to either provide 'Employee.fieldFixedLengths' or 'Employee.fieldSeparator' . Because one of these is mandatory for FCC. After providing ur parameters, I got below error:

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'Employee.fieldFixedLengths' or 'Employee.fieldSeparator' is missing Consistency check: no. of arguments in 'Employee.fieldFixedLength' does not match 'Employee.fieldNames' (0 <> 1)

Pls let me know the parameters to attain below XML:

<?xml version="1.0" encoding="utf-8" ?>

<ns:MT_Employee xmlns:ns="http://Test_Employee">

<Employee>

<EmpID>101</EmpID>

<EmpID>102</EmpID>

<EmpID>103</EmpID>

<EmpID>104</EmpID>

</Employee>

</ns:MT_Employee>

from below input file structure:

101

102

103

104

Regards,

Adi

[Former Member]

Basically, 'Employee.fieldSeparator' is not relevant in your case as you have only one field.

Do you know if the EmpID will always be 3 characters ?

If yes then 'Employee.fieldFixedLengths' = 3

else try this

'Employee.fieldSeparator' 'nl' or ' '

[Former Member]

Hi,

No, empID is not always 3 characters, some EmpIDs can even be 4 or 5 characters long. I applied Employee.fieldSeparator='nl', but I am not getting the desired result.

Regards,

Adi

[baskar_gopalakrishnan2]

either fieldSeparator or fieldFixedLength is mandatory and in your case fieldFixedLength is not possible. Try to give and see how that helps

Employee.fieldSepartor , (just comma, no quotes)