Skip to Content
avatar image
Former Member

1 more question---Shabharish weblog-FCC(Pattern/Random content)

Hi All,

<b>In Shabharish Vijayakumar's weblog----->Content Conversion (Pattern/Random content in input file)</b>

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

<b>I.</b>

<b>In</b>

The Data type is shown as below:

hbatch contains

key2

hvalue1

hvalue2

<b>In</b>

The output XML thrown to XI for further processing is as shown below:

<hbatch> contains

<key2> </key2>

<bvalue1> </bvalue1>

<bvalue2> </bvalue2>

</hbatch>

<b>My question is </b>

hbatch which is suppose to contain hvalue1 and hvalue2 right ? but here

it contains bvalue1 and bvalue2 how?

<b>II</b>

<b>what is meant by</b>

<b>1.</b> The output XML thrown to XI for further processing ? (where exactly is the file now?)

<b>2.</b>The output XML after content conversion would be then as follows for the same input file (where exactly is the file now?)

<b>III</b>

1. is DT_INPUT the source file (file goes into XI)?

2. which is the target file (file comes out of XI)?

Pls help me to complete this scenario

Thanks,

srinivas.

Message was edited by:

srinivas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    May 29, 2007 at 10:29 AM

    use the input file as

    0112345010101

    021111112222

    03100001111112222

    03100011111212223

    041000011111

    021231116722

    03100781119012332

    041005611001

    059453287699

    <i>1. The output XML thrown to XI for further processing ? (where exactly is the file now?)</i>

    >>>

    here what i meant is the XML generated by Content conversion from the Sender File adapter. The file has now been converted to XML and is in XI as an XML.

    <i>2.The output XML after content conversion would be then as follows for the same input file (where exactly is the file now?)</i>

    >>>

    in this case what i have tried to convey is the result if "Suppose the trailer occurrence is mentioned as 1 (as in the data type created ) then the output XML would not have the complete data as in the input file, rather only the final hbatch, body and tbatch occurring before the trailer would be included in the message." - <i>from the blog </i>

    <i>1. is DT_INPUT the source file (file goes into XI)?</i>

    >>>

    your input file sud be the one i mentioned above

    <i>2. which is the target file (file comes out of XI)?</i>

    >>>

    target file has not been mentioned in this blog. The blog just shows how to convert the flat file to an XML as specified in the blog.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2007 at 02:58 PM

    Hi,

    check the node name and field names in sender communication channel.

    you should put

    hbatch.fieldNames key2,hvalue1,hvalue2

    I guess you have put something like

    hbatch.fieldNames key2,bvalue1,bvalue2

    I guess it solves your problem..:)

    regards

    pushkar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 29, 2007 at 09:02 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 29, 2007 at 01:27 PM

    Hi Shabarish

    Thanks for you reply. For my 1st question

    1. The output XML thrown to XI for further processing ? (where exactly is the file now?)

    you said,

    here what i meant is the XML generated by Content conversion from the Sender File adapter. The file has now been converted to XML and is in XI as an XML.

    The Data type is shown as below:

    hbatch contains

    key2

    hvalue1

    hvalue2

    In

    The output XML thrown to XI for further processing is as shown below:

    <hbatch> contains

    <key2> </key2>

    <bvalue1> </bvalue1>

    <bvalue2> </bvalue2>

    </hbatch>

    My question is

    hbatch which is suppose to contain hvalue1 and hvalue2 right ? but here

    it contains bvalue1 and bvalue2 how?

    Thanks,

    ss

    Message was edited by:

    s s

    Add comment
    10|10000 characters needed characters exceeded

    • <i>hbatch which is suppose to contain hvalue1 and hvalue2 right ? but here

      it contains bvalue1 and bvalue2 how?</i>

      >>>>

      well i guess that must be because i must have given hbatch.fieldnames as bvalue1 and bvalue2 instead of hvalue1 and hvalue2. Do try the same and confirm 😊