Categories
View Replies (8)

Resolved VirtueMart Orders Advanced export - empty csv

  1. webstar
    webstar
  2. RO CSVI
  3. Tuesday, 11 August 2020
  4.  Subscribe via email
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
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (8)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
webstar
webstar
Accepted Answer Pending Moderation
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'
  1. more than a month ago
  2. RO CSVI
  3. # 2
webstar
webstar
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
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'

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
  1. more than a month ago
  2. RO CSVI
  3. # 4
webstar
webstar
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 5
webstar
webstar
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
webstar
webstar
Accepted Answer Pending Moderation
Perfect - Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!