Hi
After updating to 6.5.2 the combine rules failed, this works in previous 6.5.1 and 6.5 but after updating I had to go back to an old version I luckily still had in my hard drive.
A part from the bug I'll recommend uploading intermediate versions too in the download section since with so many features and changes is not strange that some features get broken and we are starting to fear updates.
Regards
Hello,
What is broken for you? There were a number of fixes done on the CSVI rules as they were broken in 6.5.1 as far as I could tell.
I have made version 6.5.1 available for download again.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
The combine rules,
I have for example name and second name combined and second name is unpublished but doesnt display in name.
Same for products and custom fields.
Regards
Hello,
We have figured out the issue and fixed it. Please update your CSVI to 6.5.2 version and load the patch file attached. This will solve the issue with combine rule on export.
Also, this fix will be included in our next CSVI 6.5.3 version.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Sorry but this does not solve it, now the combined rules return empty values.
Regards
Hello,
Did you update your CSVI to 6.5.2 version first and then applied the patch?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Yes I did that and the result is that columns that use the combined rule return empty values.
Regards
Hello,
Can you send us the debug log of the export?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
`
Detalles
Fecha 2016-02-16 13:25:31 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Fecha Tiempo Línea Acción Comentario
Procesadas 85 líneas
2016-02-16 13:25:31 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-02-16 13:25:31 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-02-16 13:25:32 0 [DEBUG] Limpiar registros antiguos. 25 registros encontrados y umbral de 25 registros
2016-02-16 13:25:32 0 [QUERY] SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id
2016-02-16 13:25:32 0 [DEBUG] CSVI Pro Versión:@version@
2016-02-16 13:25:32 0 [DEBUG] COM_CSVI_JOOMLA_VERSION
2016-02-16 13:25:32 0 [DEBUG] Versión PHP: 5.5.30
2016-02-16 13:25:32 0 [DEBUG] =========================
2016-02-16 13:25:32 0 [DEBUG] action: export
2016-02-16 13:25:32 0 [DEBUG] component: com_virtuemart
2016-02-16 13:25:32 0 [DEBUG] operation: order
2016-02-16 13:25:32 0 [DEBUG] localpath: /home/comenara/public_html
2016-02-16 13:25:32 0 [DEBUG] ftphost:
2016-02-16 13:25:32 0 [DEBUG] ftpport:
2016-02-16 13:25:32 0 [DEBUG] ftproot:
2016-02-16 13:25:32 0 [DEBUG] ftpfile:
2016-02-16 13:25:32 0 [DEBUG] export_email_subject:
2016-02-16 13:25:32 0 [DEBUG] export_email_body:
2016-02-16 13:25:32 0 [DEBUG] export_filename: Pedidos almacén [d]-[m]-[Y].csv
2016-02-16 13:25:32 0 [DEBUG] export_file: csv
2016-02-16 13:25:32 0 [DEBUG] field_delimiter: ,
2016-02-16 13:25:32 0 [DEBUG] text_enclosure: "
2016-02-16 13:25:32 0 [DEBUG] include_column_headers: Sí
2016-02-16 13:25:32 0 [DEBUG] signature: No
2016-02-16 13:25:32 0 [DEBUG] publish_state:
2016-02-16 13:25:32 0 [DEBUG] recordstart:
2016-02-16 13:25:32 0 [DEBUG] recordend:
2016-02-16 13:25:32 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-02-16 13:25:32 0 [DEBUG] export_price_format_decimal: 2
2016-02-16 13:25:32 0 [DEBUG] export_price_format_decsep: .
2016-02-16 13:25:32 0 [DEBUG] export_price_format_thousep:
2016-02-16 13:25:32 0 [DEBUG] header:
2016-02-16 13:25:32 0 [DEBUG] body:
2016-02-16 13:25:32 0 [DEBUG] footer:
2016-02-16 13:25:32 0 [DEBUG] language: es-ES
2016-02-16 13:25:32 0 [DEBUG] splitorderline: Sí
2016-02-16 13:25:32 0 [DEBUG] ordernostart:
2016-02-16 13:25:32 0 [DEBUG] ordernoend:
2016-02-16 13:25:32 0 [DEBUG] orderlist:
2016-02-16 13:25:32 0 [DEBUG] orderdaterange:
2016-02-16 13:25:32 0 [DEBUG] orderdatestart:
2016-02-16 13:25:32 0 [DEBUG] orderdateend:
2016-02-16 13:25:32 0 [DEBUG] ordermdatestart:
2016-02-16 13:25:32 0 [DEBUG] ordermdateend:
2016-02-16 13:25:32 0 [DEBUG] order_address: BTST
2016-02-16 13:25:32 0 [DEBUG] orderpricestart:
2016-02-16 13:25:32 0 [DEBUG] orderpriceend:
2016-02-16 13:25:32 0 [DEBUG] groupbyfields:
2016-02-16 13:25:32 0 [DEBUG] sortfields:
2016-02-16 13:25:32 0 [DEBUG] use_system_limits: No
2016-02-16 13:25:32 0 [DEBUG] max_execution_time:
2016-02-16 13:25:32 0 [DEBUG] memory_limit:
2016-02-16 13:25:32 0 [DEBUG] =========================
2016-02-16 13:25:32 0 [DEBUG] Export field: País
2016-02-16 13:25:32 0 [DEBUG] Export field: Bultos
2016-02-16 13:25:32 0 [DEBUG] Export field: Nº Pedido
2016-02-16 13:25:32 0 [DEBUG] Export field: Nombre
2016-02-16 13:25:32 0 [DEBUG] Export field: Referencia
2016-02-16 13:25:32 0 [DEBUG] Export field: Cantidad
2016-02-16 13:25:32 0 [DEBUG] Export field: Nota del comprador
2016-02-16 13:25:32 0 [DEBUG] Export query
SELECT COALESCE(`user_info2`.`virtuemart_country_id`, `user_info1`.`virtuemart_country_id`) AS `virtuemart_country_id`,
`#__virtuemart_shipmentmethods`.`shipment_element`,
`#__virtuemart_orders`.`virtuemart_order_id`,
`order_number`,
COALESCE(`user_info2`.`first_name`, `user_info1`.`first_name`) AS `first_name`,
COALESCE(`user_info2`.`last_name`, `user_info1`.`last_name`) AS `last_name`,
`order_item_sku`,
`product_attribute`,
`order_item_name`,
`product_quantity`,
`user_info1`.`customer_note`
FROM `#__virtuemart_orders`
LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info2` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info2`.`virtuemart_order_id` AND `user_info2`.`address_type` = 'ST'
LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`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 `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`
LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`
LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`
LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`
WHERE `#__virtuemart_orders`.`order_status` IN ('Z') AND `user_info1`.`address_type` = 'BT'
Hello,
I have for example name and second name combined and second name is unpublished but doesnt display in name.
I have taken a look at my own export template, where I do a bunch of combining and replacing. The combining works there with the patch.
To be sure I created a new template to combine 2 fields on export where 1 field is unpublished. This works as well for me. I have the idea that something may not be right in your installation. Can you check if the patch is applied correctly?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I checked twice, updated to 6.5.2 then I applied patch and the export file with replace rules return empty values in the column.
Installed 6.4.3 again and everything works fine.
An example of my combine rules:
source fields: first_name,last_name
target field: first_name
Combine character: emtpy
In template last_name is unpublished
First name returns no values.
Regards
Hello,
Can you give the latest version 6.5.3 a try?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello, same issue in 6.5.3, something not working with the combine rules.
Some images so you can see what happens.
Hi Roland, I seem to have a similar problem. Today I updated from CSVI pro 6.5.1 to 6.5.3 and then the combine fields plugin returned an empty value when exporting Virtuemart data. I reverted back to 6.5.1 and the plugin worked normally again.
Here's my config:
Joomla 3.4.8
VM 3.0.12
CSVI Pro 6.5.3
Source fields: custom,category_id,product_name
Target field: product_name
Combine character: space
This should return my brand name, category and product title (e.g. Saint Basics boxershort St. Luke Blue) but in version 6.5.3, the field stays empty.
Hello,
We have identified the issue and fixed it. Can you apply the attached patch file and check if the export works?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you guys, uptated to latest version and applied patch, that solved the issue.
Regards
Log in to reply to this topic.