Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
en:mervis-db:excel-exporter [2017/08/16 18:16]
m.chlupac 		en:mervis-db:excel-exporter [2020/02/03 15:35] (current)
Line 15: Line 15:
 {{ :en:mervis-db:excel_exporter_viewer.png?direct&800 |}} {{ :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"?> <code xml ExcelDemo.xml><?xml version="1.0" encoding="utf-8"?>
Line 43: Line 45:
 ==== Excel Template ==== ==== 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> <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. 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 |}} {{ :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 look like this:
 +
 +{{ :en:mervis-db:excel_exporter_output.png?direct&800 |}}
 +
 +==== Download Full Example ====
 +
 +Download: {{ :en:mervis-db:excelexporterdemo.zip |}}
 +
 +
 +
 +
  
  
  • © Energocentrum Plus, s.r.o. 2017 - 2024