HI,
When I export an Excel file including the field "order_item_name" only 1 product shows in that field, also when 2 products are ordered. What to do to show 2 products in that field?
Hello,
Two products will be shown as two different rows in excel file and not in one single row. Can you post me the debug log and also the file you exported to check?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
It says : No debug log available
Is it possible to switch it on?
These fields are exported :
Aanhef,Voornaam,Achternaam,Adres,Postcode,Plaats,Telefoonnummer,E-mail,Geboortejaar,Cursus,Order status,Order status naam,Totaal
The field Cursus only shows 1 product, also when two products are ordered.
Hello,
It says : No debug log available
Is it possible to switch it on?
Have a look at top of this page under section "Where to get the debug information?" which explains how to enable and get the debug log.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
herewith I send you the debug log.
thanks
Hello,
Your log is missing in the post, if file is big try to compress and post it.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
ok sorry. again as 7zip file
Its not there again, send it as email to tharuna@csvimproved.com.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello,
Your debug log shows you have set few Group by fields based on user info fields. Can you remove them and try the export?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I removed those groupfields and did another export. But it didn't sort out the issue.
Still the export file shows only one product when there are more products ordered.
hereunder the logfile
Details
Date 2016-05-19 12:01:03 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 92 lines
2016-05-19 12:01:03 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:01:03 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:01:04 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:01:04 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:01:04 0 [DEBUG] CSVI Pro Version: 6.5.7
2016-05-19 12:01:04 0 [DEBUG] Joomla! version: 3.5.1
2016-05-19 12:01:04 0 [DEBUG] PHP version: 5.5.35
2016-05-19 12:01:04 0 [DEBUG] =========================
2016-05-19 12:01:04 0 [DEBUG] action: export
2016-05-19 12:01:04 0 [DEBUG] component: com_virtuemart
2016-05-19 12:01:04 0 [DEBUG] operation: order
2016-05-19 12:01:04 0 [DEBUG] localpath: /home/nederla1/public_html
2016-05-19 12:01:04 0 [DEBUG] ftphost:
2016-05-19 12:01:04 0 [DEBUG] ftpport:
2016-05-19 12:01:04 0 [DEBUG] ftproot:
2016-05-19 12:01:04 0 [DEBUG] ftpfile:
2016-05-19 12:01:04 0 [DEBUG] export_email_subject:
2016-05-19 12:01:04 0 [DEBUG] export_email_body:
2016-05-19 12:01:04 0 [DEBUG] export_filename:
2016-05-19 12:01:04 0 [DEBUG] export_file: csv
2016-05-19 12:01:04 0 [DEBUG] field_delimiter: ,
2016-05-19 12:01:04 0 [DEBUG] text_enclosure:
2016-05-19 12:01:04 0 [DEBUG] include_column_headers: Yes
2016-05-19 12:01:04 0 [DEBUG] signature: Yes
2016-05-19 12:01:04 0 [DEBUG] publish_state:
2016-05-19 12:01:04 0 [DEBUG] recordstart:
2016-05-19 12:01:04 0 [DEBUG] recordend:
2016-05-19 12:01:04 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-05-19 12:01:04 0 [DEBUG] export_price_format_decimal: 2
2016-05-19 12:01:04 0 [DEBUG] export_price_format_decsep: .
2016-05-19 12:01:04 0 [DEBUG] export_price_format_thousep:
2016-05-19 12:01:04 0 [DEBUG] header:
2016-05-19 12:01:04 0 [DEBUG] body:
2016-05-19 12:01:04 0 [DEBUG] footer:
2016-05-19 12:01:04 0 [DEBUG] language: nl-NL
2016-05-19 12:01:04 0 [DEBUG] splitorderline: No
2016-05-19 12:01:04 0 [DEBUG] ordernostart:
2016-05-19 12:01:04 0 [DEBUG] ordernoend:
2016-05-19 12:01:04 0 [DEBUG] orderlist:
2016-05-19 12:01:04 0 [DEBUG] orderdaterange:
2016-05-19 12:01:04 0 [DEBUG] orderdatestart:
2016-05-19 12:01:04 0 [DEBUG] orderdateend:
2016-05-19 12:01:04 0 [DEBUG] ordermdatestart:
2016-05-19 12:01:04 0 [DEBUG] ordermdateend:
2016-05-19 12:01:04 0 [DEBUG] order_address:
2016-05-19 12:01:04 0 [DEBUG] orderpricestart:
2016-05-19 12:01:04 0 [DEBUG] orderpriceend:
2016-05-19 12:01:04 0 [DEBUG] groupbyfields: {"name":[]}
2016-05-19 12:01:04 0 [DEBUG] sortfields:
2016-05-19 12:01:04 0 [DEBUG] use_system_limits: No
2016-05-19 12:01:04 0 [DEBUG] max_execution_time:
2016-05-19 12:01:04 0 [DEBUG] memory_limit:
2016-05-19 12:01:04 0 [DEBUG] =========================
2016-05-19 12:01:04 0 [DEBUG] Export field: Aanhef
2016-05-19 12:01:04 0 [DEBUG] Export field: Achternaam
2016-05-19 12:01:04 0 [DEBUG] Export field: First name
2016-05-19 12:01:04 0 [DEBUG] Export field: Adres
2016-05-19 12:01:04 0 [DEBUG] Export field: Postcode
2016-05-19 12:01:04 0 [DEBUG] Export field: Plaats
2016-05-19 12:01:04 0 [DEBUG] Export field: Telefoonnummer
2016-05-19 12:01:04 0 [DEBUG] Export field: E-mail
2016-05-19 12:01:04 0 [DEBUG] Export field: Geboortejaar
2016-05-19 12:01:04 0 [DEBUG] Export field: Cursus
2016-05-19 12:01:04 0 [DEBUG] Export field: Order status
2016-05-19 12:01:04 0 [DEBUG] Export field: Order status naam
2016-05-19 12:01:04 0 [DEBUG] Export field: Totaal
2016-05-19 12:01:04 0 [DEBUG] Export query
SELECT title,
user_info1.last_name,
user_info1.first_name,
address_1,
zip,
city,
phone_1,
user_info1.email,
Geboortejaar,
order_item_name,
#__virtuemart_orders.order_status,
order_status_name,
order_total
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_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_nl_nl ON #__virtuemart_orders.virtuemart_paymentmethod_id = #__virtuemart_paymentmethods_nl_nl.virtuemart_paymentmethod_id
LEFT JOIN #__virtuemart_shipmentmethods ON #__virtuemart_orders.virtuemart_shipmentmethod_id = #__virtuemart_shipmentmethods.virtuemart_shipmentmethod_id
LEFT JOIN #__virtuemart_products ON #__virtuemart_products.product_sku = #__virtuemart_order_items.order_item_sku
i removed the field and added it again. also i added the field product sku.
unfortunately both still only show 1 ordered item/sku.
hereunder the logfile
Details
Date 2016-05-19 12:05:07 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 94 lines
2016-05-19 12:05:07 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:05:07 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:05:08 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-05-19 12:05:08 0 [QUERY] SELECT csvi_log_id FROM 2eb_csvi_logs ORDER BY csvi_log_id
2016-05-19 12:05:08 0 [DEBUG] CSVI Pro Version: 6.5.7
2016-05-19 12:05:08 0 [DEBUG] Joomla! version: 3.5.1
2016-05-19 12:05:08 0 [DEBUG] PHP version: 5.5.35
2016-05-19 12:05:08 0 [DEBUG] =========================
2016-05-19 12:05:08 0 [DEBUG] action: export
2016-05-19 12:05:08 0 [DEBUG] component: com_virtuemart
2016-05-19 12:05:08 0 [DEBUG] operation: order
2016-05-19 12:05:08 0 [DEBUG] localpath: /home/nederla1/public_html
2016-05-19 12:05:08 0 [DEBUG] ftphost:
2016-05-19 12:05:08 0 [DEBUG] ftpport:
2016-05-19 12:05:08 0 [DEBUG] ftproot:
2016-05-19 12:05:08 0 [DEBUG] ftpfile:
2016-05-19 12:05:08 0 [DEBUG] export_email_subject:
2016-05-19 12:05:08 0 [DEBUG] export_email_body:
2016-05-19 12:05:08 0 [DEBUG] export_filename:
2016-05-19 12:05:08 0 [DEBUG] export_file: csv
2016-05-19 12:05:08 0 [DEBUG] field_delimiter: ,
2016-05-19 12:05:08 0 [DEBUG] text_enclosure:
2016-05-19 12:05:08 0 [DEBUG] include_column_headers: Yes
2016-05-19 12:05:08 0 [DEBUG] signature: Yes
2016-05-19 12:05:08 0 [DEBUG] publish_state:
2016-05-19 12:05:08 0 [DEBUG] recordstart:
2016-05-19 12:05:08 0 [DEBUG] recordend:
2016-05-19 12:05:08 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-05-19 12:05:08 0 [DEBUG] export_price_format_decimal: 2
2016-05-19 12:05:08 0 [DEBUG] export_price_format_decsep: .
2016-05-19 12:05:08 0 [DEBUG] export_price_format_thousep:
2016-05-19 12:05:08 0 [DEBUG] header:
2016-05-19 12:05:08 0 [DEBUG] body:
2016-05-19 12:05:08 0 [DEBUG] footer:
2016-05-19 12:05:08 0 [DEBUG] language: nl-NL
2016-05-19 12:05:08 0 [DEBUG] splitorderline: No
2016-05-19 12:05:08 0 [DEBUG] ordernostart:
2016-05-19 12:05:08 0 [DEBUG] ordernoend:
2016-05-19 12:05:08 0 [DEBUG] orderlist:
2016-05-19 12:05:08 0 [DEBUG] orderdaterange:
2016-05-19 12:05:08 0 [DEBUG] orderdatestart:
2016-05-19 12:05:08 0 [DEBUG] orderdateend:
2016-05-19 12:05:08 0 [DEBUG] ordermdatestart:
2016-05-19 12:05:08 0 [DEBUG] ordermdateend:
2016-05-19 12:05:08 0 [DEBUG] order_address:
2016-05-19 12:05:08 0 [DEBUG] orderpricestart:
2016-05-19 12:05:08 0 [DEBUG] orderpriceend:
2016-05-19 12:05:08 0 [DEBUG] groupbyfields: {"name":[]}
2016-05-19 12:05:08 0 [DEBUG] sortfields:
2016-05-19 12:05:08 0 [DEBUG] use_system_limits: No
2016-05-19 12:05:08 0 [DEBUG] max_execution_time:
2016-05-19 12:05:08 0 [DEBUG] memory_limit:
2016-05-19 12:05:08 0 [DEBUG] =========================
2016-05-19 12:05:08 0 [DEBUG] Export field: Aanhef
2016-05-19 12:05:08 0 [DEBUG] Export field: Achternaam
2016-05-19 12:05:08 0 [DEBUG] Export field: First name
2016-05-19 12:05:08 0 [DEBUG] Export field: Adres
2016-05-19 12:05:08 0 [DEBUG] Export field: Postcode
2016-05-19 12:05:08 0 [DEBUG] Export field: Plaats
2016-05-19 12:05:08 0 [DEBUG] Export field: Telefoonnummer
2016-05-19 12:05:08 0 [DEBUG] Export field: E-mail
2016-05-19 12:05:08 0 [DEBUG] Export field: Geboortejaar
2016-05-19 12:05:08 0 [DEBUG] Export field: Order status
2016-05-19 12:05:08 0 [DEBUG] Export field: Order status naam
2016-05-19 12:05:08 0 [DEBUG] Export field: Totaal
2016-05-19 12:05:08 0 [DEBUG] Export field: order_item_name
2016-05-19 12:05:08 0 [DEBUG] Export field: order_item_sku
2016-05-19 12:05:08 0 [DEBUG] Export query
SELECT title,
user_info1.last_name,
user_info1.first_name,
address_1,
zip,
city,
phone_1,
user_info1.email,
Geboortejaar,
#__virtuemart_orders.order_status,
order_status_name,
order_total,
order_item_name,
order_item_sku
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_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_nl_nl ON #__virtuemart_orders.virtuemart_paymentmethod_id = #__virtuemart_paymentmethods_nl_nl.virtuemart_paymentmethod_id
LEFT JOIN #__virtuemart_shipmentmethods ON #__virtuemart_orders.virtuemart_shipmentmethod_id = #__virtuemart_shipmentmethods.virtuemart_shipmentmethod_id
LEFT JOIN #__virtuemart_products ON #__virtuemart_products.product_sku = #__virtuemart_order_items.order_item_sku
Hello,
Can you send me your Joomla administrator login details and database access details? I will look into your site directly.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I sent login details to contact@csvimproved.com hope we can fix it.
Hello,
I just checked your site and did a export of order with order items and I dont see any issue as reported. I have added group by field as virtuemart_product_id and sort by order_number to your template "deelnemerslijst" and also two template fields order_number and product_sku for my testing. I can see that all products in that order are exported. I cross checked it with virtuemart orders page. Can you check the export now and tell me if that is what you wanted?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Two products will be shown as two different rows in excel file and not in one single row.
Is there a workaround for this?
Was hoping to combine quantity and sku of each item purchased in each order in one cell. For example: "2 sku1 3 sku2 1 sku3" and the rest of the order details in one Virtuemart Order Export row.
Is this possible?
Best
Hello Monica,
Was hoping to combine quantity and sku of each item purchased in each order in one cell. For example: "2 sku1 3 sku2 1 sku3" and the rest of the order details in one Virtuemart Order Export row.
Is this possible?
You can use CSVI combine rule plugin for combining these two fields for each row but it is not possible for multiple rows, Have a look at the combine plugin document to know how to create rule for the same.
To do multiple row combine you need to create your own code in an override to make export work as you need it.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks Tharuna,
OK, just to clarify...
An export containing multiple sku's in one line such as:
John Smith, 11 Test Street, Beverley Hills, CA, 90210, 2 sku1 3 sku2 1 sku3, 55-555-555 is not possible, but the combine plugin is able to create something like:
John Smith, 11 Test Street, Beverley Hills, CA, 90210, 2 sku1, 55-555-555
John Smith, 11 Test Street, Beverley Hills, CA, 90210, 3 sku2, 55-555-555
John Smith, 11 Test Street, Beverley Hills, CA, 90210, 1 sku3, 55-555-555
If I want the first example I'd need to create an override... Correct?
Best,
Monica
Hello Monica,
If I want the first example I'd need to create an override... Correct?
Yes, you need to create an override to export multiple sku's in one line.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.