1. MadWelshWizard
  2. RO CSVI
  3. Wednesday, 07 November 2018
  4.  Subscribe via email
Hi,

As the title says I'm trying to export all the shipping address information along with full name, email and a couple of othewr bits and bobs. I can see that I need to run Export/Virtuemart/Order Advanced as that's where all the shipping information is but the CSV that is being created is blank.

I'm probably forgetting something obvious, could you help?

I'm running CSVI Pro 7.0.2 and I've attached a zipped Debug Log.

com_csvi.log.68.zip

Thanks,

Craig A
Accepted Answer Pending Moderation
Hello Craig,
Order advanced export is an XML export and so CSVI needs to know the setup of your XML layout. You are missing this in your template. You can set this on Layout tab in your export template. Have a look at Advanced order XML export which explains on how to set Header, Order, Orderline and Footer fields.
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
HI Tharuna,

Thanks for your help. Is there a simple way to export a CSV with just the following information for all the orders at once:

Email
Name
Shipping Address

Thanks,

Craig
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Craig,
You can use VirtueMart Order export to export the needed details as CSV file.
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. # 3
Accepted Answer Pending Moderation
Hi Tharuna,

How do I add the shipping fields? They're not in the Quick Add drop down or the New->Field Name dropdown when I use the Order option?

shipment_name
shipping_address_1
shipping_address_2
shipping_city
shipping_company
shipping_country_2_code
shipping_country_3_code
shipping_country_name
shipping_email
shipping_fax
shipping_first_name
shipping_full_name
shipping_last_name
shipping_middle_name
shipping_phone_1
shipping_phone_2
shipping_state_2_code
shipping_state_3_code
shipping_state_name
shipping_title
shipping_zip

Thanks,

Craig
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Craig,
Try updating your available fields and check if you can see the shipping fields.
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. # 5
Accepted Answer Pending Moderation
Hi Tharuna,

I followed the MIssing Fields page and It's still not giving me the options to add the fields I need. When I select Export-Virtuemart-Order the only fields that show up in the QuickAddFields box and in the New->FieldName drop down are:

Show ID fields
address_1
address_2
address_type
address_type_name
agreed
city
company
country_2_code
country_3_code
country_name
coupon_code
coupon_discount
created_by
created_on
custom
customer_note
customer_number
delivery_date
discount_percentage
email
fax
first_name
full_name
hits
intnotes
invoice_number
ip_address
last_name
layout
locked_by
locked_on
low_stock_notification
metaauthor
metarobot
modified_by
modified_on
order_billDiscountAmount
order_billTax
order_billTaxAmount
order_create_invoice_pass
order_currency
order_discount
order_discountAmount
order_item_currency
order_item_name
order_item_sku
order_language
order_number
order_pass
order_payment
order_payment_tax
order_salesPrice
order_shipment
order_shipment_tax
order_status
order_status_name
order_subtotal
order_tax
order_total
order_weight
payment_currency_rate
payment_element
payment_name
phone_1
phone_2
pordering
product_attribute
product_availability
product_available_date
product_basePriceWithTax
product_discountedPriceWithoutTax
product_final_price
product_gtin
product_height
product_in_stock
product_item_price
product_length
product_lwh_uom
product_mpn
product_ordered
product_packaging
product_params
product_priceWithoutTax
product_price_total
product_quantity
product_sales
product_sku
product_special
product_subtotal_discount
product_subtotal_with_tax
product_tax
product_unit
product_url
product_weight
product_weight_uom
published
shipment_element
shipment_name
shipping_full_name
state_2_code
state_3_code
state_name
Tax 20%
title
tos
total_order_items
username
user_currency
user_currency_rate
zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello Craig,
Checking through your previous messages i noticed you are running old version of CSVI. I would suggest you to update to latest 7.9.0. Make sure you also update CSVI VirtueMart addon to 7.9.0 version. Update the available fields after that. Create a new VirtueMart Order export template and check if you can see the shipping fields.
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. # 7
  • Page :
  • 1


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