CSV2XMLTransformation
Description
CSV2XMLTransformation element defines a CSV to XML transformation.
GreenVulcano® ESB Configuration
CSV2XMLTransformation is used by element Transformations.
The following table shows its attributes:
Attribute | Type | Description |
---|---|---|
type | fixed | This attribute must assume the value transformation. |
class | fixed | This attribute must assume the value it.greenvulcano.gvesb.gvdte.transformers.bin.bin2xml.CSVToXMLTransformer |
name | required | Transformation name.
The attribute's value cannot be null. |
FieldDelimiter | required | CSV field delimiter. Default ','.
The attribute's value cannot be null. |
UseCDATA | required | Defines if the fields values must be enclosed in a CDATA section.
The attribute's admitted values are:
|
CSV2XMLTransformation might contain the following sub-elements:
How To
To add a new CSV2XMLTransformation go to the VulCon® Core view. Expand the GVDataTransformation element and right clicking Transformation -> Insert after or Insert before -> CSV2XMLTransformation.
The following example shows the use of CSV2XMLTransformation to transform CDR data, passed in input as CSV files, into an XML.
There have been defined two Transformations and a SequenceTransformation which performs both:
<CSV2XMLTransformation FieldDelimiter="," UseCDATA="False"
class="it.greenvulcano.gvesb.gvdte.transformers.bin.bin2xml.CSVToXMLTransformer"
name="ERICSSON_cdrToXml" type="transformation"/>
<XSLTransformation DataSourceSet="Default"
XSLMapName="DataHandler/Ericsson/CaMa/InsertCDRDataBis.xsl"
class="it.greenvulcano.gvesb.gvdte.transformers.xslt.XSLTransformer"
name="InsertCDRData" type="transformation"/>
<SequenceTransformation DumpInOut="true" Output="OUT2"
class="it.greenvulcano.gvesb.gvdte.controller.SequenceTransformer"
name="UpdateCDRData" type="transformation">
<SequenceElement Input="IN" Output="OUT1" Transformer="ERICSSON_cdrToXml"/>
<SequenceElement Input="OUT1" Output="OUT2" Transformer="InsertCDRData"/>
</SequenceTransformation>
The following dh-call operation has been defined in order to convert the input as CSV data into a XML that will be successively transformed for inserting or updating the read data into the database.
<dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
name="ChangeCDRToXML" type="call">
<DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
jdbc-connection-name="ds.gv_cama" make-dump="text"
name="ChangeCDRToXML" output-data="InsertOrUpdate"
type="dbobuilder">
<DHVariables>
<DHVariable name="decimal-separator" value="."/>
<DHVariable name="grouping-separator" value=","/>
<DHVariable name="format" value="#0.00"/>
</DHVariables>
<DBOInsertOrUpdate class="it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate"
input-data="csv_param"
name="InsertAndUpdate"
output-data="xml_param"
transformation="UpdateCDRData"
type="dbo">
<statement id="0" type="insert">insert into CAMA.CDR_EVENT
(MSG_ID, MSISDN, EVENT, EVENT_TIME, NOTE, INS_DATE)
values((select ID from MESSAGES where MMS_ID = ?),?,?,?,'',sysdate)
</statement>
<statement id="1" type="update">UPDATE cama.cdr_event
SET EVENT = ?, EVENT_TIME = ?
WHERE MSG_ID = (select ID from CAMA.MESSAGES where MSG_ID = ?) and MSISDN = ?
</statement>
</DBOInsertOrUpdate>
</DBOBuilder>
</dh-call>