on 05-15-2007 10:10 AM
Hi,
I have a JDBC to File interface. However, there is a requirement to remove some of the XML tags from XML produced by the File Adapter.
For example,
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_XML xmlns:ns0="namespace">
<XMLIntegration>
<Prices COLUMNS="Index, Date, Price">
<Index>Fuel</Index>
<Date>2007-05-01 00:00:00.0</Date>
<Price>0</Price>
</Prices>
<Prices COLUMNS="Index, Date, Price"/>
</XMLIntegration>
</ns0:MT_XML>
needs to be changed to
<XMLIntegration>
<Prices COLUMNS="Index, Date, Price">
Fuel, 2007-05-01 00:00:00.0, 120.65
</Prices>
</XMLIntegration>
Does anyone know how to do this? I'm using the File Content Conversion Message Protocol but I'm not having much success
hi,
you just need to have this:
<XMLIntegration>
<Prices COLUMNS="Index, Date, Price">
Fuel, 2007-05-01 00:00:00.0, 120.65
</Prices>
</XMLIntegration>
as your target message in your mapping
and map all values to Prices tag
you don't need no content conversion - just the mapping
Regards,
michal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Michal's reply is the one I'm going to go for
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I guess you need to be using adapter module
REgards
krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This structure is neither XML nor Flat file content. So using FCC will not serve your purpose. If your requirement is to strictly get this structure, then use a JAVA/ABAP/XSLT mapping and create the structure you need. In the File adapter use the Message protocol <b>File</b>.
Regards,
Jai Shankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<XMLIntegration>
<Prices COLUMNS="Index, Date, Price">
Fuel, 2007-05-01 00:00:00.0, 120.65
</Prices>
</XMLIntegration>
Since this does not contain a XML declaration at the beging, this is not a XML file.
It is a flat file content but does not have any field separator or fixed lengths. that is what I tried to mention.
Regards,
Jai Shankar
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.