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

Sender and receiver File Adapter

Hi ,

Sender File

12345566767

fjwehifh

09782345sdfgsjghjghhh

83475 dsf888234 dsfsdf wefrwr

Question1 : I need to Treat the Complete Message as a Field

Eg : MY Source Structure

Recordset

record

Field1 0..1

I need to read complete file as one field, How can i achive it

Thanks in advace

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Dec 16, 2010 at 08:34 AM

    Hello,

    You first need to convert the incoming file into XML using FCC. After you have a defined structure in message mapping,

    1. right-click the root node of your source structure

    2. click return as XML

    3. and then map it to field

    Hope this helps,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2010 at 08:47 AM

    Hi,

    What is the version of your PI ? I mean 7.0 or 7.1.

    "Return as XML " is only available for PI 7.1 and above versions.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Once you have read the file using FCC and converted it into XML format.

      You can write a UDF, in which you can provide all the source fields as input.

      In UDF, concatenate all the input fields and assign it to target field.

      -Rahul

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2010 at 09:48 AM

    So, you would not have the option "Return as XML".

    Check the below blog: This helps you to resolve your Issue:

    http://wiki.sdn.sap.com/wiki/display/XI/JavaMapping-ConverttheInputxmlto+String

    Thanks,

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I did not understand your query properly.

      As per my understanding, you do not have the sender input fields. You would like to get the content of the sender file and that need to be populated as single field in the receiver. Isn't?

      I think you are configuring anything in the IR part?

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2010 at 10:58 AM

    Hi all,

    As my understanding, requirement is that the source file is haphazard and the data type of source has only one field, we should read all the content from the file and convert to the DT which has only one field. and we should map the flat not xml content to target.

    correct if i am wrong,

    anyone has a suggestion for this?

    Regards,

    Kevin Song

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I guess only this paramter is enough to convert into XML NameA.fieldName: <Field name>.

      In Message Mapping, Use Trim function to remove the leading and subsequent blank spaces.

      Thanks,

      Edited by: Hareenkumar on Dec 16, 2010 12:09 PM

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.