1. webstar
  2. RO CSVI
  3. Friday, 25 February 2022
  4.  Subscribe via email
Hi there Ive asked this before and youve sent me a patch file previously - I'm just upgraded my ROCSVI and the same seems to be happenign again

I'm exporting orders form Virtuemart and its filling what should be an empty Shipping address 2nd line With the Address 2nd line from the Billing address.
I have the template set to use either the billing OR the shipping.

Please advise
Accepted Answer Pending Moderation
Hello,
I guess you are talking about the patch file sent in the post here. If so, this fix has been included with RO CSVI 8.0.0-beta-1 version and is available with latest RO CSVI 8.2.0 version. May i know the version of RO CSVI you are using? Have you also updated RO CSVI VirtueMart addon extension?

Also in the other post you mentioned you have overrides set for templates. I hope you do not have override set for this template. Patch file are for core files and will not work with overrides.
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
I just renewed yesterday so its plg_csviaddon_virtuemart_ro_csvi_8.2.0 and yes I update the VM addon as well

Yes I am trying to use an override with this.
I have gone back to everything core tho. with the latest verions. No overrides and this address issue still persists. Perhaps I should uninstall and reinstall
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
Perhaps I should uninstall and reinstall

You do not uninstall and reinstall. Just create a new template without override and check the export with core RO CSVI export 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
Ok, I can confirm - I've removed the override and I'm still experiencing this problem. Address_2 is blank in the shipping address (or ST address) but its puling in the Billing Address 2. Its MIXING the addresses
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Ok, will check this and get back to you with an update.
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
Many thanks
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
HI there just check to soo if you managed to find out more about this issue. Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
I had a look at this issue and since you have set address type as Billing or Shipping in the template, export uses Billing address details if available. That is the reason you are seeing billing address 2 for shipping address 2 field. Instead of using address_2 field you should be using billing_address_2 and shipping_address_2 in export. Did you try with these 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. # 8
Accepted Answer Pending Moderation
Hm, that logic doesnt really make sense to me. I have "Billing or Shipping" set in the template. I would have expected this to use billing address info IF the order was sent to the biling address OR Shipping address info IF the order was sent to the Shipping address.
The purpose of this export is to give to our shipping company. They ONLY want ONE address as this is where the oredr will be shipped to . They don't want 2 addresses.

so when I use address_1, address_2, city, zip I expect that all the field values will come from the ONE address? and not mix them like its currently doing.

When you sent the last patch file for me I seem to remember that this was fixed.on include all the address information from EITHER the billing OR the SHIPPING


So perhaps I should only be using the shipping_address_1, shipping_address_2 etc? but wont that be empty if there was no shipping address specified?
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Indeed I'm looking at the help text for the address info in ROCSVI and it reads...
Billing or shipping address...
"Orders will be exported with their billing address unless a shipping address exists. The shipping address will be used in this case."

So why should the address be mixed? I cant see a case where this would make sense

to confirm I only need 1 set of address fields EITHER shipping OR billing Never a mix of both if 1 of the fields from Shipping address happens to be empty

help file...
Status Description
Don't use: All order address types are exported
Billing address: Only orders with billing address are exported
Shipping address: Only orders with shipping address are exported
Billing or shipping address: Orders will be exported with their billing address unless a shipping address exists. The shipping address will be used in this case.


Many thanks
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
So sorry to keep going on about this. Have you investigated this any further at your end. My client is dead in the water without the ability to export these shipping files. If I can refer back to my original post a long time ago. https://rolandd.com/support/ro-csvi/issue-with-csvi-exporting-virtue-mart-orders

This Patch seemed to fix the issue. but has now re-occured with this latest version
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello,
I was able to reproduce the issue of missing address and was working on fixing it. You can Load the attached patch file and check the export.

This Patch seemed to fix the issue. but has now re-occured with this latest version

The latest version has the fix included so i think the scenario of address_2 empty for shipping address was not tested before.
Attachments (1)
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. # 12
Accepted Answer Pending Moderation
YES!!! I can confirm this has fixed the issue. Thank you. Much better.
Again sorry to have pushed the issue but we needed it fast.

Great support!!
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Sorry back in again. But I think this file is possibly corrupt? its causing endless loops and causing mysql to crash
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
If you change the address type filter from Billing or shipping address to any other value on Options tab in template settings and run the export. Does the export finish without any problem? This is to check if the new code is not creating the endless loop.
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. # 15
Accepted Answer Pending Moderation
Just to confirm - I think its somthing with this... Thats causing an endless loop


if ($address === 'BTST' && $userInfoFields)
{
$query->clear();
$query->select(implode(',', $this->db->quoteName($userInfoFields)));
$query->from($this->db->quoteName('#__virtuemart_order_userinfos'));
$query->where($this->db->quoteName('virtuemart_order_id') . ' = ' . (int) $record->virtuemart_order_id);
$query->where($this->db->quoteName('address_type') . ' = ' . $this->db->quote('ST'));
$this->db->setQuery($query);
$fieldDetails = $this->db->loadObject();
$rowResult = count($fieldDetails);

if (!$rowResult)
{
$query->clear('where');
$query->where($this->db->quoteName('address_type') . ' = ' . $this->db->quote('BT'));
$this->db->setQuery($query);
$fieldDetails = $this->db->loadObject();
}

$this->log->add('Get user info field details');

foreach ($userInfoFields as $userInfoField)
{
if (strpos($fieldname, $userInfoField) !== false)
{
$fieldvalue = $fieldDetails->$userInfoField;
}
}
}
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Yes I can confirm If I change to either just Billing or only shipping address the problem disappears. If if helps at all I'm trying to export Shipped and Paid Orders.


Ive attached my XML template if that helps
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello,
Yes, i found the cause for the endless loop and fixed it with attached patch file. Can you try the export with the modified patch file attached here?
Attachments (1)
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. # 18
Accepted Answer Pending Moderation
This seems to have fixed the issue - I will test more in the morning
  1. more than a month ago
  2. RO CSVI
  3. # 19
  • Page :
  • 1


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