Differences

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

--- en:mervis-db:excel-exporter [2017/08/16 18:27]
m.chlupac
+++ en:mervis-db:excel-exporter [2020/02/03 15:35]
@@ Line 1: / Line 1: @@
-====== Excel Exporter ======
-There is a command line tool called Excel Exporter available that can help you create fully customizable Microsoft Excel reports from your Mervis DB data.
-It's based on custom template XLSX files where you can place data from Mervis DB using special syntax.
-For more info contact  [[en:help:energocentrum-plus|sales department]].
-===== Example =====
-In this example we demonstrate how to export single variable into Excel file.
-You can see the raw data from database in: [[https://db.mervis.info/viewer2/#/graphView?shortId=f864dc|Mervis DB Viewer]].
-{{ :en:mervis-db:excel_exporter_viewer.png?direct&800 |}}
-==== 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.
-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"?>
-<RcWareDbExporterVariableTemplateFile>
-     <exportTemplate>exceldemo.xlsx</exportTemplate>
-     <exportOutput>exceldemo_[yyyy-MM-dd_HH-mm].xlsx</exportOutput>
-	 <fillIncrementaly>false</fillIncrementaly>
-     <variables>
-          <variable name="OutsideTemperature">
-               <keyValuePairs>
-                    <keyValuePair key="DPGuid" value="338E2882-D72B-4D17-A241-73E8BC30F458" isId="true" />
-                    <keyValuePair key="StationName" value="ENERGO" isId="true" />
-               </keyValuePairs>
-          </variable>
-          <variable name="HereCouldBeSomeOtherVariable">
-               <keyValuePairs>
-                    <keyValuePair key="DPGuid" value="338E2882-D72B-4D17-A241-73E8BC30F458" isId="true" />
-                    <keyValuePair key="StationName" value="ENERGO" isId="true" />
-               </keyValuePairs>
-          </variable>
-     </variables>
-</RcWareDbExporterVariableTemplateFile></code>
-==== Excel Template ====
-You can use a simple templating language to define which values from Mervis DB should go where in th 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 |}}