on 12-27-2013 7:07 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure about this but try using the Record.enclosureSign feature.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.