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

Problem converting flat file to XML using JMS Adapter

I need to take an MQSeries message in a flat file format and convert it to XML before processing. I have configured the modules as described by the screenshot located here:

http://www.radesix.com/JMSConfig.jpg

The message is received however it isn't converting to XML. When I view the payload I get the message indicated by the screenshot located here:

http://www.radesix.com/JMSError.jpg

I am new to XI. Any ideas?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 03:36 PM

    Did you develop this module yourself or is it a standard module that is present in XI ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 04:29 PM

    I'm looking at the link you gave... I don't see PLAIN2XML anywhere.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2004 at 04:42 PM

    This documentation seems to indicate that PLAIN2XML is an arbitrary name. What seems to count is the conversiontype parameter. We are using Struct2XMLService since the flat file is of fixed length, not delimited.

    Does anyone have a working example of this scenario?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 16, 2004 at 12:11 PM

    Your conversion Type is set to StructPlain2XML but your configuration works only with SimplePlain2XML.

    For a good documentation go to Plain J2SE adapter -> Configuring the Sender File/FTP adapter

    Scroll to point 8: FILE2XMBWITHSTRUCTURECONVERSION

    All the here described and explained parameters you have to use for StructPlain2XML.

    (For SimplePlain2XML you use the parameters described under 7 FILE2XMBWITHROWCONVERSION)

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • For simple plain conversion here is a config, which works in our system:

      (left parameter key, right parameter value, module key always the same)

      Transform.Class com.sap.aii.messaging.adapter.Conversion

      TransformContentType text/xml;charset=utf-8

      xml.conversionType SimplePlain2XML

      xml.addHeaderLine 0

      xml.processFieldNames fromConfiguration

      xml.documentName SA02_Identnummer

      xml.documentNamespace urn:mycompany-com:logistics:DFT:HWL

      xml.structureTitle SA02_Identnummer_Satz

      xml.fieldNames Satzart,Identnummer,Status

      xml.fieldFixedLengths 2,10,3

      Be aware, that you must delete all spaces in the config, especially when you copy and paste values.

      For struct. conversion the entries are a little bit more complex.

      Regards

      Stefan

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.