Skip to Content
author's profile photo Former Member
Former Member

Receiver File content conversion

Dear All,

I have configured my RX file content conversion with both the ways CSV as well as Fixed length.

For all the values of XML strucutre the file is generated correctly, but for certain situation the File is not generated correctly.

For example:-

For missing XML tags in RX payload the File is not generated correctly-

I have three values in Input two are filled one is blank and for blank value XML tag is not generated and because of which File is not generated correclty.

This is happening for both the cases CSV as well as Fixed length.

Is there any way to avoid this.

I know we can write exist and if with else in mapping but i need to do it for all my interfafces which is not feasible.

Chirag

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2009 at 12:36 PM

    Chirag,

    You can try to use mapwithdefault (with spaces equal to the lenght of the field for file content conversion) so that just incase if you dont have the value it comes as spaces in its corresponding position. Use this just before the target field after all your mapping is done for the field.

    Regards,

    ---Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2009 at 12:41 PM

    Here's a similar thread with a response:

    Receiver File Adapter Content Conversion Problem.

    It seems like there's no FCC config to solve that issue, as mentioned above using MapWithDefault should solve the issue (if you use a FixedLength maybe you can only specify the value default as a " ", that should map a constant value if the field doesn't exist, or you can try to use an UDF but i guess using an standard function would be better

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 02, 2010 at 11:52 AM

    used mapwith default for all the receiver comm channel solved the problem.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.