Categories
View Replies (32)

Resolved xml advanced export not working - 500 error

  1. ClaudioRomeo
    ClaudioRomeo
  2. RO CSVI
  3. Sunday, 19 March 2017
  4.  Subscribe via email
Hello,
I have VM 3.0.19, Joomla 3.6.5 and CSVI Pro 7.1.0.
I am creating an "order advanced" Virtuemart xml export, but I got a "500 error" as soon as I try to run the export.
I need the advanced order export because I need to have shipping details (name, address and so on). I filled the "layout" sheet cells according to https://csvimproved.com/support/export/204-virtuemart/930-advanced-order-xml-export but I can't understand if something is wrong.
I attach the log file.

Furthermore, I need a field that is related to the enumeration of the items in the order. So, if an order contains 4 products, this field shall be 1 for first product, 2 for second one and so on. I did not find any field that do this. Could you help me?

Thanks

com_csvi.log.16.zip com_csvi.log.16.zip
0
Responses (32)
ClaudioRomeo
ClaudioRomeo
Accepted Answer Pending Moderation
Hi,
unfortunately this is not working. I tried to group by virtuemart_product_id, by virtuemart_order_id, combination of both, also order_item_sku and combination of some shipping fields, but I got always the same problem.
What I don't understand is why I shall find duplicates - I mean, you wrote queries in the php native orderadvanced file, I have only two orders, and duplicates occur only in a certain condition (shipping address different from billing address).
Could you help me solving this? I really am becoming crazy behind this.
  1. more than a month ago
  2. RO CSVI
  3. # 21
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Can you post the debug log with the queries that are being executed? I will have a look at what is happening.
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. # 22
ClaudioRomeo
ClaudioRomeo
Accepted Answer Pending Moderation
Hi Roland,
I attach 2 logs: first one is related to export with standard, normal orderadvanced.php. Second one is related to export with my custom override of orderadvanced.php.
The issue occurs with both.
Please consider that the solution shall suit especially the override export, since I need this.

Thank you!
Attachments (2)
com_csvi.log.39.zip
com_csvi.log.40.zip
  1. more than a month ago
  2. RO CSVI
  3. # 23
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Your are exporting only shipping address fields as per your debug log so i think grouping by correct field should fix the issue. What if you try to group only by virtuemart_order_id field? If not try only order_number field, see if it helps.
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. # 24
ClaudioRomeo
ClaudioRomeo
Accepted Answer Pending Moderation
Hi Tharuna,
I tried both and it is not working.
Especially grouping by order_number, I lose some products in the export!
  1. more than a month ago
  2. RO CSVI
  3. # 25
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I may need to look into your data you have in VirtueMart tables. Can you send me mysql dump of your VirtueMart tables as email to tharuna@csvimproved.com? Also post your export template XML file. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.
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. # 26
ClaudioRomeo
ClaudioRomeo
Accepted Answer Pending Moderation
Just a question.. what are you meaning with "dump" of VM tables?
  1. more than a month ago
  2. RO CSVI
  3. # 27
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
MySQL dump is a backup file you can generate from your phpmyadmin to collect the data from your Virtuemart tables. Using this file i will import the VirtueMart data into my database and with the requested template XML i can run the orderadvanced export here to 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. # 28
ClaudioRomeo
ClaudioRomeo
Accepted Answer Pending Moderation
Ok thanks.
I have just sent to you what you requested!
  1. more than a month ago
  2. RO CSVI
  3. # 29
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for sending the requested details. Yes as you said when there are two different address for billing and shipping you see duplicates in export. To avoid this in your template settings on options tab, look for Order address type filter and set it to billing or shipping address. Run the 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. # 30
ClaudioRomeo
ClaudioRomeo
Accepted Answer Pending Moderation
Hi Tharuna,
Your solution worked! It is unbelievable.. I was thinking about the strangest reasons for this.. but no, solution was (let's say) simple!
I did not consider that option, that was my fault.

Thank you very much for your patience and time!

Bye!
  1. more than a month ago
  2. RO CSVI
  3. # 31
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Glad to hear that your issues are solved. Would be great if you can give us a review on Joomla extension directory.
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. # 32
  • Page :
  • 1
  • 2


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