cancel
Showing results for 
Search instead for 
Did you mean: 

CONTENT CONVERSION FILE SENDER

brian_briones
Participant
0 Kudos

hi gurus,

I have the next problem:

the file on the directory has the following structure:

:20:COUNTNUMBER

:21:COUNTVALUES

:86:DESCRIPTION DESCRIPTION DESCRIPTION

DESCRIPTION DESCRIPTION DESC

RIPTION ETC

:35:OTHERVALUES

I create the Data Type with the following structure:

<record>

    <DATA20>

              <KEY>

             <VALUE>

     </DATA20>

     <DATA21>

              <KEY>

             <VALUE>

     </DATA21>

     <DATA86>

              <KEY>

             <VALUE>

     </DATA86>

      <DATA35>

              <KEY>

             <VALUE>

     </DATA35>

<record>

And on my comun channel rhe configuration on FCC is the following:

Recordset Name = record

Recordset Structure = DATA20,*,DATA21,*,DATA86,*,DATA35,*

key field name = KEY

NAME                                                       VALUE

DATA20.fieldFixedLengths                      4,30

DATA20.endSeparator                             'nl'

DATA20.fieldNames                                 KEY,VALUE

DATA20.keyFieldValue                             :20:

DATA21.fieldFixedLengths                      4,30

DATA21.endSeparator                             'nl'

DATA21.fieldNames                                 KEY,VALUE

DATA21.keyFieldValue                             :21:

DATA86.fieldFixedLengths                      4,500

DATA86.endSeparator                             'nl'

DATA86.fieldNames                                 KEY,VALUE

DATA86.keyFieldValue                             :86:

DATA35.fieldFixedLengths                      4,30

DATA35.endSeparator                             'nl'

DATA35.fieldNames                                 KEY,VALUE

DATA35.keyFieldValue                             :35:

MY DATA GET ON XML IS:

<record>

<DATA20>

          <KEY>:20:</KEY>

          <VALUE>COUNTNUMBER</VALUE>

</DATA20>

<DATA21>

          <KEY>:21:</KEY>

          <VALUE>COUNTVALUES</VALUE>

</DATA21>

<DATA86>

          <KEY>:86:</KEY>

          <VALUE>DESCRIPTION DESCRIPTION DESCRIPT</VALUE>

</DATA86>

<DATA35>

          <KEY>:35:</KEY>

          <VALUE>OTHERVALUES</VALUE>

</DATA35>

</record>

THE VALUES ON KEY :86: NOT PASS AT THE XML BECAUSE IS SEPARATES FOR ENTER ON THE FILE AND GET THE FIRST RECORD...

do you have an idea how do this one?

the other case is perfect (:20: ,:35:, etc) because come on the lines... but the :86: key not.

I need the all description on key :86: value.

regards friends.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Brian

The easiest solution will be read the data as it is in PI and then create an java map which will parse input text and generate the desired structure.

Please let me know if you need any help on Java Mapping.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Brian,

As your end Separator is "nl" (new line), it looks for new key field in next line. So, I think its not possible by standard operators.

I suggest you to read all the lines normally and do FCC in mapping or use an adapter module to achieve this functionality.

Regards,

Pranav

Former Member
0 Kudos

Not sure about this but try using the Record.enclosureSign feature.