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:27]
m.chlupac
en:mervis-db:excel-exporter [2020/02/03 15:35] (current)
Line 18: Line 18:
  
  
-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. You can also define the name of output file and whether the file should be just updated or overwritten.
Line 45: 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 |}}
Line 63: Line 61:
 ==== Output ==== ==== Output ====
  
-The output file is defined in configuration XML file and the example output should like this:+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 |}} {{ :en:mervis-db:excel_exporter_output.png?direct&800 |}}
  • © Energocentrum Plus, s.r.o. 2017 - 2024