1. YombeeTec
  2. RO CSVI
  3. Friday, 28 April 2017
  4.  Subscribe via email
Hello.

I need export a csv file with order info and the two address in two lines.

I am trying to export both address with order export and advanced order and I can't export all information as I need. In order export the process export only billing address and the adv order, can export all in the same line...

Something I am doing bad, beause I think that this worked fine a time ago. Could you help me?


The joomla version is 3.6.5 and csvi 7.0.2

Thanks!!
Accepted Answer Pending Moderation
Hello,
Can you post your export debug log to check? To know on how to get the debug log check Where to get debug information? section on top of this page.
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
Accepted Answer Pending Moderation
In our software order import process, we have configured that by addres_type, Billing Address and Shipping Address. I remember that the export process did two lines, one for each address.

I paste all log for export orders.

Thanks!!

#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: date time line_nr action comment
2017-04-28 14:01:08 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2017-04-28 14:01:09 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2017-04-28 14:01:09 0 [DEBUG] CSVI Pro Versión:7.0.2
2017-04-28 14:01:09 0 [DEBUG] Versión de Joomla!: 3.6.5
2017-04-28 14:01:09 0 [DEBUG] Versión PHP: 5.6.30-0+deb8u1
2017-04-28 14:01:09 0 [DEBUG] =========================
2017-04-28 14:01:09 0 [DEBUG] action: export
2017-04-28 14:01:09 0 [DEBUG] component: com_virtuemart
2017-04-28 14:01:09 0 [DEBUG] operation: order
2017-04-28 14:01:09 0 [DEBUG] override:
2017-04-28 14:01:09 0 [DEBUG] output_empty_file: Sí
2017-04-28 14:01:09 0 [DEBUG] localpath: ************************************
2017-04-28 14:01:09 0 [DEBUG] ftphost:
2017-04-28 14:01:09 0 [DEBUG] ftpport:
2017-04-28 14:01:09 0 [DEBUG] ftproot:
2017-04-28 14:01:09 0 [DEBUG] ftpfile:
2017-04-28 14:01:09 0 [DEBUG] export_email_subject:
2017-04-28 14:01:09 0 [DEBUG] export_email_body:
2017-04-28 14:01:09 0 [DEBUG] database_username:
2017-04-28 14:01:09 0 [DEBUG] database_host:
2017-04-28 14:01:09 0 [DEBUG] database_portno:
2017-04-28 14:01:09 0 [DEBUG] database_name:
2017-04-28 14:01:09 0 [DEBUG] database_table:
2017-04-28 14:01:09 0 [DEBUG] primary_key_source: order_number
2017-04-28 14:01:09 0 [DEBUG] primary_key_target: id
2017-04-28 14:01:09 0 [DEBUG] create_new_columns: Sí
2017-04-28 14:01:09 0 [DEBUG] export_filename: WRPDCAB.CSV
2017-04-28 14:01:09 0 [DEBUG] export_file: csv
2017-04-28 14:01:09 0 [DEBUG] field_delimiter: ;
2017-04-28 14:01:09 0 [DEBUG] text_enclosure:
2017-04-28 14:01:09 0 [DEBUG] include_column_headers: Sí
2017-04-28 14:01:09 0 [DEBUG] signature: No
2017-04-28 14:01:09 0 [DEBUG] publish_state:
2017-04-28 14:01:09 0 [DEBUG] recordstart:
2017-04-28 14:01:09 0 [DEBUG] recordend:
2017-04-28 14:01:09 0 [DEBUG] export_date_format: d/m/Y H:i:s
2017-04-28 14:01:09 0 [DEBUG] export_price_format_decimal: 4
2017-04-28 14:01:09 0 [DEBUG] export_price_format_decsep: .
2017-04-28 14:01:09 0 [DEBUG] export_price_format_thousep:
2017-04-28 14:01:09 0 [DEBUG] header:
2017-04-28 14:01:09 0 [DEBUG] body:
2017-04-28 14:01:09 0 [DEBUG] footer:
2017-04-28 14:01:09 0 [DEBUG] language: es-ES
2017-04-28 14:01:09 0 [DEBUG] splitorderline: No
2017-04-28 14:01:09 0 [DEBUG] ordernostart:
2017-04-28 14:01:09 0 [DEBUG] ordernoend:
2017-04-28 14:01:09 0 [DEBUG] orderlist:
2017-04-28 14:01:09 0 [DEBUG] orderdaterange:
2017-04-28 14:01:09 0 [DEBUG] orderdatestart:
2017-04-28 14:01:09 0 [DEBUG] orderdateend:
2017-04-28 14:01:09 0 [DEBUG] ordermdatestart:
2017-04-28 14:01:09 0 [DEBUG] ordermdateend:
2017-04-28 14:01:09 0 [DEBUG] order_address:
2017-04-28 14:01:09 0 [DEBUG] orderpricestart:
2017-04-28 14:01:09 0 [DEBUG] orderpriceend:
2017-04-28 14:01:09 0 [DEBUG] groupbyfields: {"name":["order_number",""]}
2017-04-28 14:01:09 0 [DEBUG] sortfields:
2017-04-28 14:01:09 0 [DEBUG] use_system_limits: No
2017-04-28 14:01:09 0 [DEBUG] max_execution_time:
2017-04-28 14:01:09 0 [DEBUG] memory_limit:
2017-04-28 14:01:09 0 [DEBUG] csvi_template_id: 8
2017-04-28 14:01:09 0 [DEBUG] tags:
2017-04-28 14:01:09 0 [DEBUG] =========================
2017-04-28 14:01:09 0 [DEBUG] Export field: order_number
2017-04-28 14:01:09 0 [DEBUG] Export field: customer_number
2017-04-28 14:01:09 0 [DEBUG] Export field: created_on
2017-04-28 14:01:09 0 [DEBUG] Export field: full_name
2017-04-28 14:01:09 0 [DEBUG] Export field: company
2017-04-28 14:01:09 0 [DEBUG] Export field: DNICIF
2017-04-28 14:01:09 0 [DEBUG] Export field: address_type
2017-04-28 14:01:09 0 [DEBUG] Export field: address_1
2017-04-28 14:01:09 0 [DEBUG] Export field: address_2
2017-04-28 14:01:09 0 [DEBUG] Export field: zip
2017-04-28 14:01:09 0 [DEBUG] Export field: city
2017-04-28 14:01:09 0 [DEBUG] Export field: state_name
2017-04-28 14:01:09 0 [DEBUG] Export field: country_name
2017-04-28 14:01:09 0 [DEBUG] Export field: phone_1
2017-04-28 14:01:09 0 [DEBUG] Export field: phone_2
2017-04-28 14:01:09 0 [DEBUG] Export field: fax
2017-04-28 14:01:09 0 [DEBUG] Export field: email
2017-04-28 14:01:09 0 [DEBUG] Export field: customer_note
2017-04-28 14:01:09 0 [DEBUG] Export query
SELECT `#__virtuemart_orders`.`virtuemart_order_id`,
`order_number`,
`customer_number`,
`#__virtuemart_orders`.`created_on`,
`user_info1`.`first_name` AS `billing_first_name`,
`user_info1`.`middle_name` AS `billing_middle_name`,
`user_info1`.`last_name` AS `billing_last_name`,
`company`,
`DNICIF`,
`address_type`,
`address_1`,
`address_2`,
`zip`,
`city`,
`user_info1`.`virtuemart_state_id`,
`user_info1`.`virtuemart_country_id`,
`phone_1`,
`phone_2`,
`fax`,
`user_info1`.`email`,
`user_info1`.`customer_note`
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_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`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`
WHERE `#__virtuemart_orders`.`order_status` IN ('C')
GROUP BY `order_number`
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

I am not sure what the issue is you are seeing but not all orders come in 2 lines, only those orders which have a different BT and ST value. You are grouping on order_number, since this is unique, you will only ever get 1 line in your export file. You should remove all grouping if you want to export all lines.
Kind regards,

RolandD

=========================
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. # 3
Accepted Answer Pending Moderation
Hello Rolandd.

That was the problem the groupping by order.

Now I have my 2 lines in BT and ST :)

I know that if it is the same address I only have BT.


Thanks you very much for your help!!
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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