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

File - File Multimapping(1 File to be Split into N no of Files)

Hi

I have FILE 2 FILE Scenario.

Requirement is to convert source xml file to n no of files.

eg If we have 3 records in a source file , the target must have 3 files added with timestamp.

Ques.png (32.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jun 03, 2014 at 06:16 PM

    Hi Ziaur,

    Yes , we can do this in 2 ways,

    1. Using File content conversion (FCC) in sender communication channel .

    2. In message Mapping , change Target side occurrence to 0 to unbounded.

    Thanks

    Hari.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ziaur,

      This will be done through multi-mapping , just change the occurrence of the message mapping target structure and Operation mapping structure as shown below ,

      Message Mapping :

      then your message will look like as below ,

      Map Messages and Messages1 with constant and make sure MT_* (your message type structure will repeat as per your requirement ). And Test with sample XML and you should get multiple MT_* segment in target .

      Operation Mapping :

      Note : While doing end to end testing , no need to mention messages and message1 segment in Source XML file.

      Thanks

      Hari.

      mm.png (17.7 kB)
      om.png (9.4 kB)
      mm.png (17.1 kB)
  • Posted on Jun 03, 2014 at 06:30 PM

    Hi Ziaur,

    The best way is set recordset per message to 1 in FCC. refer the below blog

    Night Mare-Processing huge files in SAP XI

    regards,

    Harish

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 03, 2014 at 07:05 PM

    Since it is xml in the source i think you have to use multimapping. for having filename in the target based on the number of records like 1,2,3, you need to use UDF/std function to generate the number and map it to target.at the end use variable substitution.

    but this is going to have extra field on the target side.

    else you have to use below approach to make use of DC.

    A new approach: Multi-mapping Dynamic Configuration using a generic custom module

    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.