Differences

This shows you the differences between two versions of the page.

--- en:mervis-db:excel-exporter [2017/08/16 18:16]
m.chlupac
+++ en:mervis-db:excel-exporter [2017/08/16 18:41]
m.chlupac
@@ Line 15: / Line 15: @@
 {{ :en:mervis-db:excel_exporter_viewer.png?direct&800 |}}
-==== Mapping File ====
+==== Configuration File ====
-First you have to create a simple XML file where you define mapping between a set of keys describing individual Mervis DB variable and some Variable Name that will be used later in Excel template.
+First you have to create a configuration XML file where you define mapping between a set of keys describing individual Mervis DB variable and some Variable Name that will be used later in Excel template.
+You can also define the name of output file and whether the file should be just updated or overwritten.
 <code xml ExcelDemo.xml><?xml version="1.0" encoding="utf-8"?>
@@ Line 43: / Line 45: @@
 ==== Excel Template ====
-You can use a simple templating language to define which values from Mervis DB should go where in th Excel file.
+You can use a simple templating language to define which values from Mervis DB should go where in the output Excel file.
 <code>[YEAR:2016|MONTH:1|DAY:15|HOUR:12|MINUTE:0|VARIABLE:OutsideTemperature]</code>
 Any of the time-defining values can be omitted and will be replace by current date, time or values passed via command line parameters.
-Simple Excel template: {{ :en:mervis-db:exceldemo.xlsx |}}
 {{ :en:mervis-db:excel_exporter_template.png?direct&800 |}}
+==== Run the Exporter  ====
+<code bat runExcelDemo.bat>.\ESG.RcWareDb.DataExporter\ESG.RcWareDb.DataExporter.exe tmpPath:"ExcelDemo.xml" srvUrl:"http://db.mervis.info/db/energocentrum/RcWareDbAccess" srvUser:"exceldemo" srvPsw:"pfi4cj4qrj" timeTolerance:300 toleranceType:before</code>
+For more info options see <code>.\ESG.RcWareDb.DataExporter\ESG.RcWareDb.DataExporter.exe --help</code>
+==== Output ====
+The output file is defined in configuration XML file and the example output should like this:
+{{ :en:mervis-db:excel_exporter_output.png?direct&800 |}}
+==== Download Full Example ====
+Download: {{ :en:mervis-db:excelexporterdemo.zip |}}