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

  • Follow
  • 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