Hi Roland
Just to let you know in the latest beta 3 the custom field is not working as expected.
If you use several custom fields with default values only the first default value of the first custom field is printed.
The headers seem to work fine.
Regards
Hello,
I am not a 100% sure I understand what you mean. Could you give me a more detailed explanation? What are you importing, what do you expect, what do you see? The debug log if possible.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland
I made a simple template for showing you the result and happened to get this error:
Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `u8713_virtuemart_orders` LEFT JOIN `u8713_virtuemart_order_items` ON `u871' at line 2 SQL=SELECT FROM `u8713_virtuemart_orders` LEFT JOIN `u8713_virtuemart_order_items` ON `u8713_virtuemart_orders`.`virtuemart_order_id` = `u8713_virtuemart_order_items`.`virtuemart_order_id` LEFT JOIN `u8713_virtuemart_order_userinfos` AS `user_info1` ON `u8713_virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id` LEFT JOIN `u8713_virtuemart_orderstates` ON `u8713_virtuemart_orders`.`order_status` = `u8713_virtuemart_orderstates`.`order_status_code` LEFT JOIN `u8713_virtuemart_product_manufacturers` ON `u8713_virtuemart_order_items`.`virtuemart_product_id` = `u8713_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `u8713_virtuemart_manufacturers` ON `u8713_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `u8713_virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `u8713_users` ON `u8713_users`.`id` = `user_info1`.`virtuemart_user_id` LEFT JOIN `u8713_virtuemart_countries` ON `u8713_virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id` LEFT JOIN `u8713_virtuemart_invoices` ON `u8713_virtuemart_orders`.`virtuemart_order_id` = `u8713_virtuemart_invoices`.`virtuemart_order_id` LEFT JOIN `u8713_virtuemart_paymentmethods_es_es` ON `u8713_virtuemart_orders`.`virtuemart_paymentmethod_id` = `u8713_virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id` LEFT JOIN `u8713_virtuemart_shipmentmethods` ON `u8713_virtuemart_orders`.`virtuemart_shipmentmethod_id` = `u8713_virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` WHERE `u8713_virtuemart_orders`.`order_status` IN ('C') AND `user_info1`.`address_type` = 'ST'
The issue I was talking about is described in the image:
Column headers all exported.
Default values only first appears in exported CSV file.
Hello,
Do I see it correct that you are doing an export of fields of the type custom only? Then the error you get is expected because the custom field has no relation to any order field. So no fields are selected for export. You would need to select at least 1 field that is part of an order, for example the virtuemart_order_id.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry I noticed when I added the order number it worked again.
Still the issue mentioned, I attach you an image of the result file where you can check it.
This has been fixed in the new version I have sent you and will be fixed in the upcoming beta 4.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.