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

File Content Conversion in Sender File Adapter

Hi,

I am implementing a scenario, where I need to do Content conversion in My file Adapter.My input file is as follows

BGN00S-A200711281003ET4

REF38381012

DTP007D820071128

N1P5P5MicrosoftFI58-0612397

INSY18030XNAN

REFZZZZ666666666

DTP336D819970331

NM1ILIL1AdamsMarkE34666666666

PERIPIPHP770555-5555

N31470 Georgia Club Drive

N4StathamGA30666

DMGD819571022MM7

HD030HLTAE1D

My data type is as below.

<header>

<BGN>

<A></A>

<B></B>

<C></C>

<D></D>

</BGN>

<REF>

<A1></A1>

<B1></B1>

<C1></C1>

<D1></D1>

</REF>

<DTP>

<A2></A2>

<B2></B2>

<C2></C2>

<D2></D2>

</DTP>

</header>

<Content>

<N1>

<A></A>

<B></B>

<C></C>

<D></D>

</N1>

<REFAR>

<A1></A1>

<B1></B1>

<C1></C1>

<D1></D1>

</REFAR>

<DMP>

<A2></A2>

<B2></B2>

<C2></C2>

<D2></D2>

</DMP>

</Content>

My issue is, How do I set my parameter in Sender Comm channel for content conversion especially at record structure.

I have provided the value as Header,1,Content,*

But its not working.

If I do provide like

BGN_REC,,REF_REC,,DTP_REC,,N1_REC,,INS_REC,,NM1_REC,,PER_REC,,N3_REC,,N4_REC,,DMG_REC,,HD_REC,* then ,I am not getting above XML format. Please suggest or How can I modify my Data type which competes to configure in Channel

Thanks

Manmadha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Nov 30, 2007 at 06:31 PM

    Hi manmadha,

    Check this blog...

    How to send a flat file with various field lengths and variable substructures to XI 3.0

    /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    Sachin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 05:15 AM

    HI Manmadha,

    If i am not wrong your input file is

    BGN00S-A200711281003ET4 REF38381012 DTP007D820071128 N1P5P5MicrosoftFI58-0612397 INSY18030XNAN REFZZZZ666666666 DTP336D819970331 NM1ILIL1AdamsMarkE34666666666 PERIPIPHP770555-5555 N31470 Georgia Club Drive N4StathamGA30666 DMGD819571022MM7 HD030HLTAE1D .

    1. Kindly let me know the scenario type ? Is it a file to file scenario..?

    2. File you are getting is fixed length or CSV ?

    3. file adapter has capabilities to work on both sirttuations, justyou need to play around adapter..no need of Module Pool Prog..?

    Kindly come up with the answers of my questions

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 01, 2007 at 06:36 AM

    hi manmadha,

    in the FCC, give the structure name (root element)

    in FCC parameters

    add

    <b> <str_name>.fieldNames : at Values(add the fields/tags that you want

    exactly in order)</b>

    <b> <str_name>.fieldSeparator : leave a whitespace

    <str_name>.endSeparator : 'nl' <i> </b>// end Line</i>

    <i> it will be easier if the fields are seperated by commas, anyway you try

    this and get me status</i>

    <b> Check your File Adapter error: RWB->>ComponenetMoni->>Adapters

    read the Adapter Configuration

    http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1

    /content.htm

    regards,

    nikhilbos.

    <i>**reward if helpful

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI,

      refer the below weblog:

      File Content Conversion for Multi Hierarchical Structure

      /people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

      Thnx

      Chirag Gohil

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.