CSV2XMLTransformation - Revision history

Anonymous at 10:37, 3 April 2012

2012-04-03T10:37:58Z

Anonymous: /* How To */

2012-04-02T16:05:20Z

‎How To

Anonymous: /* How To */

2012-04-02T16:04:00Z

‎How To

Anonymous: /* How To */

2012-04-02T16:03:14Z

‎How To

Anonymous: /* How To */

2012-04-02T16:01:46Z

‎How To

Anonymous: /* How To */

2012-04-02T14:41:15Z

‎How To

Anonymous: /* {{GVESB}} Configuration */

2012-04-02T13:44:40Z

‎{{GVESB}} Configuration

Anonymous: Created page with "==Description== CSV2XMLTransformation element defines a CSV to XML transformation. =={{GVESB}} Configuration== [[File:CVS2XMLTransformation.jpg|thumb|CSV2XMLTransformation wit..."

2012-04-02T13:24:31Z

Created page with "==Description== CSV2XMLTransformation element defines a CSV to XML transformation. =={{GVESB}} Configuration== [[File:CVS2XMLTransformation.jpg|thumb|CSV2XMLTransformation wit..."

New page

==Description==

CSV2XMLTransformation element defines a CSV to XML transformation.

=={{GVESB}} Configuration==

[[File:CVS2XMLTransformation.jpg|thumb|CSV2XMLTransformation with VulCon]]CSV2XMLTransformation is used by element [[GVDataTransformation#Transformations|Transformations]].

The following table shows its attributes:
{|class="gvtable"
! 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 can't be null.
|-
| UseCDATA || required || Defines if the fields values must be enclosed in a CDATA section.
The attribute's admitted values are:
* True
* False
|}

CSV2XMLTransformation might contain the following sub-elements:
* [[Description]]
* [[AddTagTransformation#TransformationAlias|TransformationAlias]]

@@ Line 38: / Line 38: @@
 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 [[GVDataTransformation#Transformations|Transformations]] and a [[SequenceTransformation]] which performs both:
+There have been defined two [[GVDataTransformation#Transformations|Transformations]] and a [[SequenceTransformation]] which performs both [[CSV2XMLTransformation]] and [[XSLTransformation]] in this order:
 <syntaxhighlight lang="XML">

@@ Line 38: / Line 38: @@
 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 [[GVDataTransformations#Transformations|Transformations]] and a [[SequenceTransformation]] which performs both:
+There have been defined two [[GVDataTransformation#Transformations|Transformations]] and a [[SequenceTransformation]] which performs both:
 <syntaxhighlight lang="XML">

@@ Line 38: / Line 38: @@
 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:
+There have been defined two [[GVDataTransformations#Transformations|Transformations]] and a [[SequenceTransformation]] which performs both:
 <syntaxhighlight lang="XML">
@@ Line 56: / Line 56: @@
 </syntaxhighlight>
-The following [[dh-call]] operation has been defined in order to convert the input as CSV data into a XML that will be sucesively transformed for inserting data into the database.
+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.
 <syntaxhighlight lang="XML">
 <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"

@@ Line 37: / Line 37: @@
 The following example shows the use of CSV2XMLTransformation to transform CDR data, passed in input as CSV files, into an XML.
 <syntaxhighlight lang="XML">
-    <CSV2XMLTransformation FieldDelimiter="," UseCDATA="False"
+<CSV2XMLTransformation FieldDelimiter="," UseCDATA="False"
-                           class="it.greenvulcano.gvesb.gvdte.transformers.bin.bin2xml.CSVToXMLTransformer"
+          class="it.greenvulcano.gvesb.gvdte.transformers.bin.bin2xml.CSVToXMLTransformer"
-                           name="ERICSSON_cdrToXml" type="transformation"/>
+          name="ERICSSON_cdrToXml" type="transformation"/>
 </syntaxhighlight>
 <syntaxhighlight lang="XML">
-    <dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
+<dh-call class="it.greenvulcano.gvesb.virtual.datahandler.DataHandlerCallOperation"
-                             name="ChangeCDRToXML" type="call">
+         name="ChangeCDRToXML" type="call">
-                        <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
+     <DBOBuilder class="it.greenvulcano.gvesb.datahandling.dbobuilder.DBOBuilder"
-                                    jdbc-connection-name="ds.gv_cama" make-dump="text"
+                 jdbc-connection-name="ds.gv_cama" make-dump="text"
-                                    name="ChangeCDRToXML" output-data="InsertOrUpdate"
+                 name="ChangeCDRToXML" output-data="InsertOrUpdate"
-                                    type="dbobuilder">
+                 type="dbobuilder">
-                            <DHVariables>
+          <DHVariables>
-                                <DHVariable name="decimal-separator" value="."/>
+                 <DHVariable name="decimal-separator" value="."/>
-                                <DHVariable name="grouping-separator" value=","/>
+                 <DHVariable name="grouping-separator" value=","/>
-                                <DHVariable name="format" value="#0.00"/>
+                 <DHVariable name="format" value="#0.00"/>
-                            </DHVariables>
+          </DHVariables>
-                            <DBOInsertOrUpdate class="it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate"
+          <DBOInsertOrUpdate class="it.greenvulcano.gvesb.datahandling.dbo.DBOInsertOrUpdate"
-                                               input-data="csv_param"
+                  input-data="csv_param"
-                                               name="InsertAndUpdate"
+                  name="InsertAndUpdate"
-                                               output-data="xml_param"
+                  output-data="xml_param"
-                                               transformation="ERICSSON_cdrToXml"
+                  transformation="UpdateCDRData"
-                                               type="dbo">
+                  type="dbo">
-                                <statement id="0" type="insert">insert into CAMA.CDR_EVENT
+                 <statement id="0" type="insert">insert into CAMA.CDR_EVENT
-(MSG_ID, MSISDN, EVENT, EVENT_TIME, NOTE, INS_DATE)
+                      (MSG_ID, MSISDN, EVENT, EVENT_TIME, NOTE, INS_DATE)
-values((select ID from MESSAGES where MMS_ID = ?),?,?,?,&apos;&apos;,sysdate)</statement>
+                      values((select ID from MESSAGES where MMS_ID = ?),?,?,?,'',sysdate)
-                                <statement id="1" type="update">UPDATE cama.cdr_event
+                 </statement>
-SET EVENT = ?, EVENT_TIME = ?
+                 <statement id="1" type="update">UPDATE cama.cdr_event
-WHERE MSG_ID = (select ID from CAMA.MESSAGES where MSG_ID = ?) and MSISDN = ?</statement>
+                      SET EVENT = ?, EVENT_TIME = ?
-                            </DBOInsertOrUpdate>
+                      WHERE MSG_ID = (select ID from CAMA.MESSAGES where MSG_ID = ?) and MSISDN = ?
-                        </DBOBuilder>
+                 </statement>
-                    </dh-call>
+          </DBOInsertOrUpdate>
 </syntaxhighlight>

@@ Line 42: / Line 42: @@
                             class="it.greenvulcano.gvesb.gvdte.transformers.bin.bin2xml.CSVToXMLTransformer"
                             name="ERICSSON_cdrToXml" type="transformation"/>
 </syntaxhighlight>

@@ Line 21: / Line 21: @@
 The attribute's value cannot be null.
 |-
-| UseCDATA || required || Defines if the fields values must be enclosed in a CDATA section.
+| UseCDATA || required || Defines if the fields value must be enclosed in a CDATA section.
 The attribute's admitted values are:
 * True

@@ Line 19: / Line 19: @@
 |-
 | FieldDelimiter || required || CSV field delimiter. Default ','.
-The attribute's value can't be null.
+The attribute's value cannot be null.
 |-
 | UseCDATA || required || Defines if the fields values must be enclosed in a CDATA section.
@@ Line 30: / Line 30: @@
 * [[Description]]
 * [[AddTagTransformation#TransformationAlias|TransformationAlias]]