Skip to Content

File Content Conversion with data in double quotes

Hi Experts,

I am trying a File content Conversion in module tab.

My Incoming file consists of values in double quotes.

EX:

"Header","1","2","3"

"Text","1","2","3"

"TextData","1","2","3"

"TextData","1","2","3"

"Text","1",3","5"


My Structure is as follows


Record

     Header     1

     Text          *

     Textdata     *



When i am using Recordsetstructure = Header,1,Text,1,TextData,2,Text,1 the data is being convrted to xml successfully.


But when i am using RecrdsetStructure=Header,1,Text,*,TextData,*   it is throwing an error.


Could you please help regarding this.


Thank you in advance



Diwakar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Sep 11, 2015 at 06:58 PM

    HI Diwakar,

    please remove the "" using replace string in graphical mapping and try.

    br,

    rashmi

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2015 at 05:52 AM

    Hello Rashmi,

    thanks for your reply.

    I am using Content conversion in sender file channel and csv is not getting converted to xml if i use * in record setStructure as mentioned in the earlier post.

    Thanks,

    Diwakar Sharma.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2015 at 06:04 AM

    Hello Diwakar,

    Quote should be not a problem.

    "Header","1","2","3"

    "Text","1","2","3"

    "TextData","1","2","3"

    "TextData","1","2","3"

    "Text","1",3","5"


    It is because of the order of the fields.


    In your case if you configure Header,1,Text,*,TextData,* .It's logically wrong because Text records are coming again after TextData records


    Try this.


    Header,1,Text,1,TextData,*,Text,1.It will work.


    To use this FCC-Header,1,Text,*,TextData,* .File data should be like


    "Header","1","2","3"

    "Text","1","2","3"

    "Text","1",3","5"

    "TextData","1","2","3"

    "TextData","1","2","3"


    Add comment
    10|10000 characters needed characters exceeded

  • Sep 15, 2015 at 09:50 AM

    Hi Raghuraman,

    Thanks for your reply.

    In have already configured those parameters.

    please find the list of parameters i have configured

    Module Key          Parameter                               Value

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

    P2X                    Transform.ContentType          text/xml;charset=utf-8

    P2X                    xml.Header.fieldNames          a,b,c

    P2X                    xml.Header.fieldSeparator       ","

    P2X                    xml.Header.keyFieldValue        Header 

    P2X                    xml.Text.fieldNames               a,b,c

    P2X                    xml.Text.fieldSeparator               ","

    P2X                    xml.Text.keyFieldValue              Text

    P2X                    xml.TextData.fieldNames          a,b,c

    P2X                    xml.TextData.fieldSeparator          ","

    P2X                    xml.TextData.keyFieldValue          TextData

    P2X                    xml.conversionType                    StructPlain2XML

    P2X                    xml.documentName                    myMessageType

    P2X                    xml.documentNamespace              my Name space

    P2X                    xml.keyFieldName                         a

    P2X                    xml.processFieldNames               fromConfiguration

    P2X                    xml.recordsetName                    record

    P2X                    xml.recordsetStructure               header,1,Text,*,TextData,*

    P2X                    xml.recordsetStructureOrder          var

    Please suggest.

    Thanks

    Diwakar Sharma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2015 at 12:31 PM

    Hi Diwakar,

    In Recordset Sequence please enable the Variable option then try this,may be it will help you.


    Regards,

    Rajendra

    Add comment
    10|10000 characters needed characters exceeded