<?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[todownload]]></option>
      </exportto>
      <output_empty_file><![CDATA[yes]]></output_empty_file>
      <localpath><![CDATA[/var/www/html/csvi.test]]></localpath>
      <ftphost><![CDATA[]]></ftphost>
      <ftpport><![CDATA[]]></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>
      <database_username><![CDATA[]]></database_username>
      <database_password><![CDATA[]]></database_password>
      <database_host><![CDATA[]]></database_host>
      <database_portno><![CDATA[]]></database_portno>
      <database_name><![CDATA[]]></database_name>
      <database_table><![CDATA[]]></database_table>
      <primary_key_source><![CDATA[product_id]]></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>
      <clientid><![CDATA[]]></clientid>
      <clientsecret><![CDATA[]]></clientsecret>
      <spreadsheetid><![CDATA[]]></spreadsheetid>
      <sheetname><![CDATA[]]></sheetname>
      <range_from><![CDATA[]]></range_from>
      <range_to><![CDATA[]]></range_to>
      <valueInputOption><![CDATA[RAW]]></valueInputOption>
      <export_filename><![CDATA[icecat-test.csv]]></export_filename>
      <export_file><![CDATA[csv]]></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[]]></offset>
      <querySet><![CDATA[{"querySet0":{"query":"SELECT product_id FROM `#__csvi_icecat_index` AS `i` \r\nLEFT JOIN `#__csvi_icecat_suppliers` AS `s` ON `s`.`supplier_id` = `i`.`supplier_id` \r\nWHERE `i`.`prod_id` = 'ITGCADCDSB' AND `s`.`supplier_name` = 'ITEK'","sheetName":"icecat","sheet_font":"Arial","header_column_font":"","header_font_size":"12","header_font_style":"regular","header_align_horizontal":"center","header_align_vertical":"top","header_column_color":"","header_column_background":""}}]]></querySet>
      <header><![CDATA[]]></header>
      <body><![CDATA[]]></body>
      <footer><![CDATA[]]></footer>
      <placeholders><![CDATA[{"placeholders0":{"placeholder":"","value":""}}]]></placeholders>
      <globalrules><![CDATA[]]></globalrules>
      <use_system_limits><![CDATA[no]]></use_system_limits>
      <max_execution_time><![CDATA[]]></max_execution_time>
      <memory_limit><![CDATA[]]></memory_limit>
    </settings>
    <template_name><![CDATA[ICEcat test export]]></template_name>
    <template_alias><![CDATA[icecat-test-export]]></template_alias>
    <advanced><![CDATA[0]]></advanced>
    <action><![CDATA[export]]></action>
    <frontend><![CDATA[0]]></frontend>
    <secret><![CDATA[]]></secret>
    <log><![CDATA[1]]></log>
    <lastrun><![CDATA[2024-09-04 20:02:09]]></lastrun>
    <enabled><![CDATA[1]]></enabled>
    <ordering><![CDATA[0]]></ordering>
    <notes><![CDATA[]]></notes>
    <tag><![CDATA[]]></tag>
    <featured><![CDATA[0]]></featured>
    <fields>
      <field>
        <field_name><![CDATA[product_id]]></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[icecat]]></sheet_name>
      </field>
    </fields>
  </template>
</csvi>
