Hi, I wonder if you can help - Im trying to export an "VirtueMart Orders Advanced export" but the file is coming out blank/empty
can you help
Hello,
Yes, we can definitely help but we would like to see what is causing empty export file. To check that, please post the export debug log. To get the debug log check How to collect debug information? document.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Is this any good?
Details
Date 2020-08-11 09:50:47 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 103 lines
2020-08-11 09:50:47 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2020-08-11 09:50:47 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2020-08-11 09:50:47 0 [DEBUG] RO CSVI Version: 7.17.0
2020-08-11 09:50:47 0 [DEBUG] Joomla! version: 3.9.20
2020-08-11 09:50:47 0 [DEBUG] PHP version: 7.3.20
2020-08-11 09:50:47 0 [DEBUG] =========================
2020-08-11 09:50:47 0 [DEBUG] action: export
2020-08-11 09:50:47 0 [DEBUG] component: com_virtuemart
2020-08-11 09:50:47 0 [DEBUG] operation: orderadvanced
2020-08-11 09:50:47 0 [DEBUG] override:
2020-08-11 09:50:47 0 [DEBUG] 0: todownload
2020-08-11 09:50:47 0 [DEBUG] output_empty_file: Yes
2020-08-11 09:50:47 0 [DEBUG] localpath:
2020-08-11 09:50:47 0 [DEBUG] ftphost:
2020-08-11 09:50:47 0 [DEBUG] ftpport:
2020-08-11 09:50:47 0 [DEBUG] sftp: No
2020-08-11 09:50:47 0 [DEBUG] ftproot:
2020-08-11 09:50:47 0 [DEBUG] ftpfile:
2020-08-11 09:50:47 0 [DEBUG] export_email_subject:
2020-08-11 09:50:47 0 [DEBUG] export_email_body:
2020-08-11 09:50:47 0 [DEBUG] database_username:
2020-08-11 09:50:47 0 [DEBUG] database_host:
2020-08-11 09:50:47 0 [DEBUG] database_portno:
2020-08-11 09:50:47 0 [DEBUG] database_name:
2020-08-11 09:50:47 0 [DEBUG] database_table:
2020-08-11 09:50:47 0 [DEBUG] primary_key_source: virtuemart_order_id
2020-08-11 09:50:47 0 [DEBUG] primary_key_target: id
2020-08-11 09:50:47 0 [DEBUG] create_new_columns: Yes
2020-08-11 09:50:47 0 [DEBUG] clientid:
2020-08-11 09:50:47 0 [DEBUG] clientsecret:
2020-08-11 09:50:47 0 [DEBUG] accesstoken:
2020-08-11 09:50:47 0 [DEBUG] fulltoken:
2020-08-11 09:50:47 0 [DEBUG] spreadsheetid:
2020-08-11 09:50:47 0 [DEBUG] sheetname:
2020-08-11 09:50:47 0 [DEBUG] range_from:
2020-08-11 09:50:47 0 [DEBUG] range_to:
2020-08-11 09:50:47 0 [DEBUG] export_filename: shippingexport.csv
2020-08-11 09:50:47 0 [DEBUG] export_file: xml
2020-08-11 09:50:47 0 [DEBUG] export_site: orderadvanced
2020-08-11 09:50:47 0 [DEBUG] publish_state:
2020-08-11 09:50:47 0 [DEBUG] recordstart:
2020-08-11 09:50:47 0 [DEBUG] recordend:
2020-08-11 09:50:47 0 [DEBUG] export_date_format: d/m/Y H:i:s
2020-08-11 09:50:47 0 [DEBUG] export_price_format_decimal: 2
2020-08-11 09:50:47 0 [DEBUG] export_price_format_decsep: .
2020-08-11 09:50:47 0 [DEBUG] export_price_format_thousep:
2020-08-11 09:50:47 0 [DEBUG] add_currency_to_price: No
2020-08-11 09:50:47 0 [DEBUG] language: en-GB
2020-08-11 09:50:47 0 [DEBUG] ordernostart: 00389887
2020-08-11 09:50:47 0 [DEBUG] ordernoend: 00389926
2020-08-11 09:50:47 0 [DEBUG] orderlist:
2020-08-11 09:50:47 0 [DEBUG] usedatefield: created_on
2020-08-11 09:50:47 0 [DEBUG] orderdaterange:
2020-08-11 09:50:47 0 [DEBUG] lastorderid:
2020-08-11 09:50:47 0 [DEBUG] orderdatestart:
2020-08-11 09:50:47 0 [DEBUG] orderdateend:
2020-08-11 09:50:47 0 [DEBUG] ordermdatestart:
2020-08-11 09:50:47 0 [DEBUG] ordermdateend:
2020-08-11 09:50:47 0 [DEBUG] 0: S
2020-08-11 09:50:47 0 [DEBUG] 0:
2020-08-11 09:50:47 0 [DEBUG] 0:
2020-08-11 09:50:47 0 [DEBUG] order_address: BTST
2020-08-11 09:50:47 0 [DEBUG] 0: none
2020-08-11 09:50:47 0 [DEBUG] 0:
2020-08-11 09:50:47 0 [DEBUG] orderpricestart:
2020-08-11 09:50:47 0 [DEBUG] orderpriceend:
2020-08-11 09:50:47 0 [DEBUG] 0:
2020-08-11 09:50:47 0 [DEBUG] 0:
2020-08-11 09:50:47 0 [DEBUG] include_empty_nodes: No
2020-08-11 09:50:47 0 [DEBUG] header: test
2020-08-11 09:50:47 0 [DEBUG] order:
2020-08-11 09:50:47 0 [DEBUG] orderline:
2020-08-11 09:50:47 0 [DEBUG] footer:
2020-08-11 09:50:47 0 [DEBUG] groupbyfields:
2020-08-11 09:50:47 0 [DEBUG] sortfields:
2020-08-11 09:50:47 0 [DEBUG] use_system_limits: No
2020-08-11 09:50:47 0 [DEBUG] max_execution_time:
2020-08-11 09:50:47 0 [DEBUG] memory_limit:
2020-08-11 09:50:47 0 [DEBUG] =========================
2020-08-11 09:50:47 0 [DEBUG] Export field: virtuemart_order_id
2020-08-11 09:50:47 0 [DEBUG] Export field: full_name
2020-08-11 09:50:47 0 [DEBUG] Export field: company
2020-08-11 09:50:47 0 [DEBUG] Export query
SELECT #__virtuemart_orders.virtuemart_order_id,
#__virtuemart_order_items.virtuemart_product_id,
#__virtuemart_order_items.product_attribute,
COALESCE(user_info2.first_name, user_info1.first_name) AS first_name,
COALESCE(user_info2.middle_name, user_info1.middle_name) AS middle_name,
COALESCE(user_info2.last_name, user_info1.last_name) AS last_name,
COALESCE(user_info2.company, user_info1.company) AS company
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_en_gb ON #__virtuemart_orders.virtuemart_paymentmethod_id = #__virtuemart_paymentmethods_en_gb.virtuemart_paymentmethod_id
LEFT JOIN #__virtuemart_shipmentmethods_en_gb ON #__virtuemart_orders.virtuemart_shipmentmethod_id = #__virtuemart_shipmentmethods_en_gb.virtuemart_shipmentmethod_id
WHERE #__virtuemart_orders.virtuemart_order_id >= 389887 AND #__virtuemart_orders.virtuemart_order_id <= 389926 AND #__virtuemart_orders.order_status IN ('S') AND user_info1.address_type = 'BT'
I'm actually unsure what I should be exporting as
Order OR advanced order?
I need one line of order user information per virtuemart order
eg Order IE, Name, shipping address, country code, email, phone
Hello,
WHERE
#__virtuemart_orders.virtuemart_order_id>= 389887 AND#__virtuemart_orders.virtuemart_order_id<= 389926 AND#__virtuemart_orders.order_statusIN ('S') ANDuser_info1.address_type= 'BT'
You have set filters in your export template and it is possible that the virtuemart_order_id which are between 389887 and 389926 does not have order_status as S. Remove these filters and try the export and see if you get records in export file.
Order OR advanced order?
I need one line of order user information per virtuemart order
eg Order IE, Name, shipping address, country code, email, phone
With Order advanced export you can export order and order item details in XML format. It is an advanced version of order export. But if you are looking at exporting user information for an order then you can use VirtueMart Order export.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
OK, That makes sense - OK I got it workign with VM Order export - but its exporting multiple lines - I only need 1 line PER order. with only the order user info eg NO item lines
Any ideas?
Hello,
Please take a look at Group by and Sort by document to avoid duplicates in order. Try setting virtuemart_order_item_id as group by field in your template and check.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Oh Actually, It doesnt seem to be item lines it sems to be order histories its repeating
eg Ive been testing different statuses on that order - by changiugn from Paid to shipping multiple times. And the exporter seems to be outputin ga new line for each of these changes
Perfect - Thank you
Log in to reply to this topic.