Resolved Virtuemart export

Hello Jeff,

Your question is not clear but I am going to guess you want to know how to export your custom field with your orders? If so, it all depends on the custom field and if and how it is stored with the order. All custom fields are stored in 1 field and that is called product_attribute field. We may need to see first how your custom field is stored if it doesn't come out as expected.

Exporting orders is no different than exporting products, You just need to add the fields to your template.

Let me know if you have any specific issues with the custom field export.

Thanks, I am a couple of steps further, however, when I export a file, I get the following content (in the export file)


<br />
<b>Strict Standards</b>: Declaration of CsviModelOrderAdvancedExport::getFilterBy() should be compatible with CsviModelExportfile::getFilterBy($filter, $ignore = Array, $special = Array) in <b>/home/mfvr/public_html/administrator/components/com_csvi/models/com_virtuemart/export/orderadvancedexport.php</b> on line <b>677</b><br />
<br />
<b>Strict Standards</b>: Non-static method CsviHelper::replaceValue() should not be called statically, assuming $this from incompatible context in <b>/home/mfvr/public_html/administrator/components/com_csvi/models/com_virtuemart/export/orderadvancedexport.php</b> on line <b>420</b><br />
<br />
<b>Strict Standards</b>: Non-static method CsviHelper::replaceValue() should not be called statically, assuming $this from incompatible context in <b>/home/mfvr/public_html/administrator/components/com_csvi/models/com_virtuemart/export/orderadvancedexport.php</b> on line <b>420</b><br />

Any ideas?

Hello Jeff,

Your error reporting is set to a very high level, that is causing these information messages. I would suggest you go to Joomla Global Configuration -> Server -> Error reporting and set it to System default or if it already is, set it to None. These messages will be gone.

This will be cleaned up in CSVI 6

Thanks that worked, however, now I get a file with no content and without file extension, size is 1kb. When I open it in Wordpad, there is nothing in it

What am I doing wrong?

The content was already empty when you had the notices because the data should be shown around it.

without file extension

That means you have set a filename in your template without an extension.

As for the content being empty, post the debug log and let me see what is in there. Also check your template if you have not set any filters that may limit the results to nothing.

Thanks, the file extension problem is solved.

I have attached the debuglog.

Thanks!

Hello Jeff,

The debug log is not attached, please make sure it is zipped before attaching it. Thanks.

Something else that came to mind, you could check in the database if there is any information in the product_attribute field of the virtuemart_orders table. If this is empty, then your custom field won't be exported.

Sorry, I didn't zip it, should be attached now.

Hello Jeff,

In the debug log I see you are exporting the field Namenpersonenbijmeerderetickets, so that looks fine to me assuming that field is in your order table. If you leave this field out, do you get anything in your export file then?

The date filter looks fine too where you select orders between February 4th and March 3rd. Are there any orders placed within that date span? If you don't use any date filter, do you get anything in your export file?

If you have access to PhpMyAdmin via your provider you can execute this query via the SQL tab and see if you get any results

SELECT `ol768_virtuemart_orders`.`virtuemart_order_id`, `customer_number`, `first_name`, `last_name`, `order_item_name`, `Namenpersonenbijmeerderetickets`, `customer_note` FROM ol768_virtuemart_orders LEFT JOIN ol768_virtuemart_order_items ON ol768_virtuemart_orders.virtuemart_order_id = ol768_virtuemart_order_items.virtuemart_order_id LEFT JOIN ol768_virtuemart_order_userinfos AS user_info1 ON ol768_virtuemart_orders.virtuemart_order_id = user_info1.virtuemart_order_id LEFT JOIN ol768_virtuemart_orderstates ON ol768_virtuemart_orders.order_status = ol768_virtuemart_orderstates.order_status_code LEFT JOIN ol768_virtuemart_product_manufacturers ON ol768_virtuemart_order_items.virtuemart_product_id = ol768_virtuemart_product_manufacturers.virtuemart_product_id LEFT JOIN ol768_virtuemart_manufacturers ON ol768_virtuemart_product_manufacturers.virtuemart_manufacturer_id = ol768_virtuemart_manufacturers.virtuemart_manufacturer_id LEFT JOIN ol768_users ON ol768_users.id = user_info1.virtuemart_user_id LEFT JOIN ol768_virtuemart_countries ON ol768_virtuemart_countries.virtuemart_country_id = user_info1.virtuemart_country_id LEFT JOIN ol768_virtuemart_invoices ON ol768_virtuemart_orders.virtuemart_order_id = ol768_virtuemart_invoices.virtuemart_order_id LEFT JOIN ol768_virtuemart_paymentmethods_nl_nl ON ol768_virtuemart_orders.virtuemart_paymentmethod_id = ol768_virtuemart_paymentmethods_nl_nl.virtuemart_paymentmethod_id LEFT JOIN ol768_virtuemart_shipmentmethods_nl_nl ON ol768_virtuemart_orders.virtuemart_shipmentmethod_id = ol768_virtuemart_shipmentmethods_nl_nl.virtuemart_shipmentmethod_id WHERE DATE(ol768_virtuemart_orders.created_on) >= DATE_SUB(CURDATE(), INTERVAL 40 DAY) AND DATE(ol768_virtuemart_orders.created_on) <= DATE_SUB(CURDATE(), INTERVAL 13 DAY) GROUP BY `customer_number`,`first_name`,`last_name`,`order_item_name`,`Namenpersonenbijmeerderetickets`,`customer_note`

I don't see any obvious reasons why your export file would be empty, as in there are no errors.