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

Structured file output

I need to create a file from the file receiver adapter that corresponds to an inbound message that uses mode FILE2XMBWITHSTRUCTURECONVERSION. This option is not available with the inbound adapter, only the FILE2XMBWITHROWCONVERSION mode. What is the process to output a file with a complex structure?

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 Dec 17, 2004 at 12:13 PM

    Hi,

    If I understand your problem correctly then you need to have an output file Adapter?

    You need to define a header node and item node as seen below in the Adapter config:

    This is how you do it:

    ##File Adapter specific parameters (example, see docu)

    file.sourceDir= /tmp

    file.sourceFilename=complex2.txt

    #file.processingMode=setAttribute

    #ile.processingMode=delete

    #file.processingMode=archive

    file.processingMode=test

    #file.archiveDir=c:/temp_archive

    file.pollInterval=900

    ##xml conversion properties if mode FILE2XMBWITHROWCONVERSION specified (example, see docu)

    xml.recordsetStructure=Header,1,Item,*

    xml.recordsetName=row

    xml.recordsetsPerMessage=1

    xml.documentName=Resultset

    #xml.fieldFixedLengths=

    xml.Header.processFieldNames=fromConfiguration

    xml.Item.processFieldNames=fromConfiguration

    xml.Header.fieldNames=ID,EMPID,NAME

    xml.Item.fieldNames=ID,SKILLS

    xml.keyFieldName=ID

    xml.keyFieldType=CaseSensitiveString

    xml.Header.keyFieldValue=H

    xml.Item.keyFieldValue=I

    xml.Header.fieldSeparator= ;

    xml.Item.fieldSeparator= ;

    Cheers

    Ashish

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your reply.

      What I want to do is exactly the opposite. I want to be able to send a custom XML message from XI to my inbound file adapter that in turn will send it to a FTP destination.

      The flat file I FTP, has a three character identifier as the first field on each row. This identifier identifies the row as being a header row, Item row, Item detail row, ....., and Trailer row.

      It is according to this identifier that the adapter must map the row differently from the XML message as each row will have a different layout.

      The opposite happens with an inbound message from the FTP site and I can get this to work as you described in your reply.

      There is no SAP documentation I can find to help me with this. Any Idea on how I can get the first scenario to work?

  • Posted on Dec 20, 2004 at 01:25 PM

    It is not possible to have a structured file output.

    It works only with XI 3.0 J2EE file adapter, but not with J2SE file adapter at all.

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I will appreciate it if you can tell me how to do this using the J2EE file adapter, or where I can get information on this. If anyone have done something like this before, can you please give me an example?

      Thanks

      Johan

  • Posted on Dec 21, 2004 at 04:56 PM

    Hi Johan

    If I have understood your problem correctly you wish to output multiple record types to a file using an outbound file adapter within XI 2.0, if so I have posted a reply to this question, the message can be found using URL :-

    https://www.sdn.sap.com/sdn/collaboration.sdn?node=linkFnode6-1&contenttype=url&content=https://outbounding-complex-text-files

    Please let me know how you get on as I remember how frustrating I found this.

    All the best

    Ian Passfield

    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.