Resolved Custom fields is not working as expected

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.

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.

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.