| 2017-05-18 |
09:25:48 |
0 |
[DEBUG] |
Clean up old logs. Found 23 logs and threshold is 25 logs
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Clean up old logs. Found 23 logs and threshold is 25 logs
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
CSVI Pro Version: 7.1.0
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Joomla! version: 3.7.0
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
PHP version: 5.5.38
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
=========================
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
action: export
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
component: com_virtuemart
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
operation: product
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
override:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
output_empty_file: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
localpath: /web/htdocs/www.profumeriaverde.it/home
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
ftphost:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
ftpport:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
ftproot:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
ftpfile:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_email_subject:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_email_body:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
database_username:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
database_host:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
database_portno:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
database_name:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
database_table:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
primary_key_source: product_sku
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
primary_key_target: id
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
create_new_columns: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_filename: export18
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_file: csv
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
field_delimiter: ;
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
text_enclosure: "
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
include_column_headers: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
signature: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
publish_state:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
recordstart:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
recordend:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_date_format: d/m/Y H:i:s
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_price_format_decimal: 2
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_price_format_decsep: .
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
export_price_format_thousep:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
header:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
body:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
footer:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
language: it-IT
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
exportsef: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
cachesefurls: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
emptysefcache: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
producturl_suffix:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
vm_itemid:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
picture_limit: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
featured: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
category_separator: /
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
publish_state_categories:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
incl_subcategory: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
parent_only: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
child_only: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
incl_productskufilter: Sì
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
productskufilter:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
stocklevelstart:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
stocklevelend:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
shopper_group_price: none
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
priceoperator: gt
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
pricefrom:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
priceto:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
price_quantity_start:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
price_quantity_end:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
targetcurrency:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
force_shopper_group_price: none
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
groupbyfields: {"name":["product_sku","product_name","manufacturer_name","product_in_stock","product_ordered"]}
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
sortfields:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
use_system_limits: No
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
max_execution_time:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
memory_limit:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
csvi_template_id: 4
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
tags:
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
=========================
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Export field: product_sku
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Export field: product_name
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Export field: manufacturer_name
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Export field: product_ordered
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Export field: product_in_stock
|
| 2017-05-18 |
09:25:50 |
0 |
[DEBUG] |
Export query
|
| SELECT `#__virtuemart_products`.`virtuemart_product_id`,
|
| `#__virtuemart_products`.`product_parent_id`,
|
| `product_sku`,
|
| `product_ordered`,
|
| `product_in_stock`
|
| FROM `#__virtuemart_products`
|
| LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id`
|
| LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
|
| LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
|
| LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id`
|
| LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency`
|
| LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id`
|
| GROUP BY `product_sku`,`product_ordered`,`product_in_stock`
|