<?xml version="1.0"?>
<csvi>
  <template>
    <settings>
      <action><![CDATA[export]]></action>
      <component><![CDATA[com_csvi]]></component>
      <operation><![CDATA[sql]]></operation>
      <override><![CDATA[]]></override>
      <exportto>
        <option><![CDATA[togooglesheet]]></option>
      </exportto>
      <output_empty_file><![CDATA[no]]></output_empty_file>
      <localpath><![CDATA[/var/www/vhosts/mydomain/httpdocs]]></localpath>
      <ftphost><![CDATA[]]></ftphost>
      <ftpport><![CDATA[21]]></ftpport>
      <sftp><![CDATA[no]]></sftp>
      <ftpusername><![CDATA[]]></ftpusername>
      <ftppass><![CDATA[]]></ftppass>
      <ftproot><![CDATA[]]></ftproot>
      <ftpfile><![CDATA[]]></ftpfile>
      <export_email_addresses><![CDATA[]]></export_email_addresses>
      <export_email_addresses_cc><![CDATA[]]></export_email_addresses_cc>
      <export_email_addresses_bcc><![CDATA[]]></export_email_addresses_bcc>
      <export_email_subject><![CDATA[]]></export_email_subject>
      <export_email_body><![CDATA[]]></export_email_body>
      <databasetype><![CDATA[]]></databasetype>
      <localtablelist><![CDATA[]]></localtablelist>
      <primary_key_source><![CDATA[Μήνας]]></primary_key_source>
      <primary_key_target><![CDATA[id]]></primary_key_target>
      <create_new_columns><![CDATA[yes]]></create_new_columns>
      <empty_table><![CDATA[no]]></empty_table>
      <database_host><![CDATA[]]></database_host>
      <database_portno><![CDATA[]]></database_portno>
      <database_username><![CDATA[]]></database_username>
      <database_password><![CDATA[]]></database_password>
      <database_name><![CDATA[]]></database_name>
      <database_table><![CDATA[]]></database_table>
      <spreadsheetid><![CDATA[1PrM6irVfx7mI4qkHGsKHd6LQX9kVbxDsKfFxBgJC3PI]]></spreadsheetid>
      <sheetname><![CDATA[sheet1]]></sheetname>
      <range_from><![CDATA[A]]></range_from>
      <range_to><![CDATA[L]]></range_to>
      <valueInputOption><![CDATA[RAW]]></valueInputOption>
      <export_filename><![CDATA[parkdatatest.xlsx]]></export_filename>
      <export_file><![CDATA[xlsx]]></export_file>
      <sheet_name><![CDATA[Sheet 1]]></sheet_name>
      <sheet_font><![CDATA[Arial]]></sheet_font>
      <field_delimiter><![CDATA[,]]></field_delimiter>
      <text_enclosure><![CDATA[]]></text_enclosure>
      <include_column_headers><![CDATA[yes]]></include_column_headers>
      <include_empty_nodes><![CDATA[yes]]></include_empty_nodes>
      <signature><![CDATA[no]]></signature>
      <use_excel_date><![CDATA[no]]></use_excel_date>
      <recordstart><![CDATA[]]></recordstart>
      <recordend><![CDATA[]]></recordend>
      <export_price_format_decimal><![CDATA[2]]></export_price_format_decimal>
      <export_price_format_decsep><![CDATA[,]]></export_price_format_decsep>
      <export_price_format_thousep><![CDATA[.]]></export_price_format_thousep>
      <offset><![CDATA[Europe/Athens]]></offset>
      <querySet><![CDATA[{"querySet0":{"query":"SELECT\r\n    CONCAT(\r\n        YEAR(pd.PeriodStartDate),\r\n        ' ',\r\n        CASE MONTH(pd.PeriodStartDate)\r\n            WHEN 1 THEN '\u0399\u03b1\u03bd\u03bf\u03c5\u03ac\u03c1\u03b9\u03bf\u03c2'\r\n            WHEN 2 THEN '\u03a6\u03b5\u03b2\u03c1\u03bf\u03c5\u03ac\u03c1\u03b9\u03bf\u03c2'\r\n            WHEN 3 THEN '\u039c\u03ac\u03c1\u03c4\u03b9\u03bf\u03c2'\r\n            WHEN 4 THEN '\u0391\u03c0\u03c1\u03af\u03bb\u03b9\u03bf\u03c2'\r\n            WHEN 5 THEN '\u039c\u03ac\u03b9\u03bf\u03c2'\r\n            WHEN 6 THEN '\u0399\u03bf\u03cd\u03bd\u03b9\u03bf\u03c2'\r\n            WHEN 7 THEN '\u0399\u03bf\u03cd\u03bb\u03b9\u03bf\u03c2'\r\n            WHEN 8 THEN '\u0391\u03cd\u03b3\u03bf\u03c5\u03c3\u03c4\u03bf\u03c2'\r\n            WHEN 9 THEN '\u03a3\u03b5\u03c0\u03c4\u03ad\u03bc\u03b2\u03c1\u03b9\u03bf\u03c2'\r\n            WHEN 10 THEN '\u039f\u03ba\u03c4\u03ce\u03b2\u03c1\u03b9\u03bf\u03c2'\r\n            WHEN 11 THEN '\u039d\u03bf\u03ad\u03bc\u03b2\u03c1\u03b9\u03bf\u03c2'\r\n            WHEN 12 THEN '\u0394\u03b5\u03ba\u03ad\u03bc\u03b2\u03c1\u03b9\u03bf\u03c2'\r\n        END\r\n    ) AS `\u039c\u03ae\u03bd\u03b1\u03c2`,\r\n    pd.EnergyInjectedKwh AS `\u03a3\u03c5\u03bd\u03bf\u03bb\u03b9\u03ba\u03ae \u0395\u03b3\u03c7\u03c5\u03b8\u03b5\u03af\u03c3\u03b1 \u039c\u03a4 - \u0394\u0395\u0394\u0394\u0397\u0395`,\r\n    pd.EnergyConsumedKwh AS `\u039a\u03b1\u03c4\u03b1\u03bd\u03ac\u03bb\u03c9\u03c3\u03b7 \u03a0\u03ac\u03c1\u03ba\u03bf\u03c5 \u039c\u03a4 - \u0394\u0395\u0394\u0394\u0397\u0395`,\r\n    pd.EnergyAllocatedKwh AS `\u039c\u03b5\u03c4\u03b1\u03ba\u03c5\u03bb\u03b9\u03cc\u03bc\u03b5\u03bd\u03b7 \u039c\u03a4 - \u0394\u0395\u0397`,\r\n    pd.EnergyRecycledKwh AS `\u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03b5\u03c6\u03cc\u03bc\u03b5\u03bd\u03b7 \u039c\u03a4 - \u0394\u0395\u0397`,\r\n    pd.TransformationFactor AS `\u03a3\u03c5\u03bd\u03c4\u03b5\u03bb\u03b5\u03c3\u03c4\u03ae\u03c2 \u0391\u03c0\u03c9\u03bb\u03b5\u03b9\u03ce\u03bd \u03a7\u03a4`,\r\n    CASE\r\n        WHEN pd.CertifiedFlag = 1 THEN '\u039d\u03b1\u03b9'\r\n        ELSE '\u038c\u03c7\u03b9'\r\n    END AS `\u03a0\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u0394\u0395\u0394\u0394\u0397\u0395`,\r\n    pd.EnergyProducedKwhSedge AS `\u03a0\u03b1\u03c1\u03b1\u03c7\u03b8\u03b5\u03af\u03c3\u03b1 - SolarEdge`,\r\n    pd.EnergySelfConsumedKwhSedge AS `\u0391\u03c5\u03c4\u03bf\u03ba\u03b1\u03c4\u03b1\u03bd\u03ac\u03bb\u03c9\u03c3\u03b7 \u03a0\u03ac\u03c1\u03ba\u03bf\u03c5 - SolarEdge`,\r\n    pd.EnergyPurchasedKwhSedge AS `\u039a\u03b1\u03c4\u03b1\u03bd\u03ac\u03bb\u03c9\u03c3\u03b7 \u03b1\u03c0\u03cc \u03b4\u03af\u03ba\u03c4\u03c5\u03bf - SolarEdge`,\r\n    pd.EnergyConsumedKwhSedge AS `\u03a3\u03c5\u03bd\u03bf\u03bb\u03b9\u03ba\u03ae \u039a\u03b1\u03c4\u03b1\u03bd\u03ac\u03bb\u03c9\u03c3\u03b7 \u03a0\u03ac\u03c1\u03ba\u03bf\u03c5 - SolarEdge`,\r\n    pd.EnergyInjectedKwhSedge AS `\u0395\u03b3\u03c7\u03c5\u03b8\u03b5\u03af\u03c3\u03b1 - SolarEdge`\r\nFROM VNM_PARK_DATA pd\r\nWHERE pd.PeriodStartDate >= '2024-12-01'\r\n  AND pd.PeriodStartDate <= '2026-01-01'","sheetName":"sheet1","sheet_font":"Verdana","header_column_font":"Verdana","header_font_size":"14","header_font_style":"bold","header_align_horizontal":"center","header_align_vertical":"center","header_column_color":"","header_column_background":""}}]]></querySet>
      <header><![CDATA[]]></header>
      <body><![CDATA[]]></body>
      <footer><![CDATA[]]></footer>
      <html_header><![CDATA[]]></html_header>
      <html_body><![CDATA[]]></html_body>
      <html_footer><![CDATA[]]></html_footer>
      <placeholders><![CDATA[{"placeholders0":{"placeholder":"","value":""}}]]><![CDATA[]]></placeholders>
      <use_system_limits><![CDATA[no]]></use_system_limits>
      <max_execution_time><![CDATA[]]></max_execution_time>
      <memory_limit><![CDATA[]]></memory_limit>
      <csvi_template_id><![CDATA[40]]></csvi_template_id>
      <tags/>
    </settings>
    <template_name><![CDATA[01 - parkdatatest]]></template_name>
    <template_alias><![CDATA[01-sygkentrotika-dedomena-parkou]]></template_alias>
    <advanced><![CDATA[1]]></advanced>
    <action><![CDATA[export]]></action>
    <frontend><![CDATA[0]]></frontend>
    <secret><![CDATA[]]></secret>
    <log><![CDATA[1]]></log>
    <lastrun><![CDATA[2026-10-19 15:07:18]]></lastrun>
    <enabled><![CDATA[1]]></enabled>
    <ordering><![CDATA[1]]></ordering>
    <notes><![CDATA[]]></notes>
    <tag><![CDATA[]]></tag>
    <featured><![CDATA[0]]></featured>
    <fields>
      <field>
        <field_name><![CDATA[Μήνας]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[1]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Συνολική Εγχυθείσα ΜΤ - ΔΕΔΔΗΕ]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[2]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Κατανάλωση Πάρκου ΜΤ - ΔΕΔΔΗΕ]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[3]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Μετακυλιόμενη ΜΤ - ΔΕΗ]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[4]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Επιστρεφόμενη ΜΤ - ΔΕΗ]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[5]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Συντελεστής Απωλειών ΧΤ]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[6]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Πιστοποιημένα από ΔΕΔΔΗΕ]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[7]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Παραχθείσα - SolarEdge]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[8]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Αυτοκατανάλωση Πάρκου - SolarEdge]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[9]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Κατανάλωση από δίκτυο - SolarEdge]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[10]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Συνολική Κατανάλωση Πάρκου - SolarEdge]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[11]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
      <field>
        <field_name><![CDATA[Εγχυθείσα - SolarEdge]]></field_name>
        <column_header><![CDATA[]]></column_header>
        <default_value><![CDATA[]]></default_value>
        <cdata><![CDATA[yes]]></cdata>
        <ordering><![CDATA[12]]></ordering>
        <field_date_format><![CDATA[]]></field_date_format>
        <offset><![CDATA[]]></offset>
        <number_field><![CDATA[no]]></number_field>
        <enabled><![CDATA[yes]]></enabled>
        <sort><![CDATA[0]]></sort>
        <sheet_name><![CDATA[sheet1]]></sheet_name>
        <font_size><![CDATA[0]]></font_size>
        <fieldrules/>
      </field>
    </fields>
  </template>
</csvi>
