1. stancky
  2. RO CSVI
  3. Sunday, 09 February 2020
  4.  Subscribe via email
Hello,

I am trying to export shipping rate from virtuemart.

1) If I include the field "shipment_logos", I cannot export.
I have an error:
Status error: 200
Status message: OK

Warning: strlen() expects parameter 1 to be string, array given in E:\wamp64\www\blablabla\administrator\components\com_csvi\models\exports.php on line 721

2) If I remove the field "shipment_logos", I can export but the field "shipment_cost" is empty.

Can you please help to resolve the above 2 points.

Thanks and best regards
Accepted Answer Pending Moderation
Hello,
Can you tell use which version of RO CSVI you are using? I tried running export with both shipment_cost and shipment_logos fields and don't see the warning nor empty value. Can you post your export debug log to check? To get the debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello Tharuna,

My RO CSVI version is 7.14.0 with plg_csviaddon_virtuemart_ro_csvi_7.14.0.

Please find attached the debug log.

Thanks

Stanley
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Stanley,
Debug log looks good. Can you do this?

1. Create RO CSVI Custom table export template.
2. In template settings,on Options tab select #__virtuemart_shipmentmethods table, save the template.
3. On template fields, add fields shipment_params and shipment_element.
4. Run the export and Post the export file to check.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Ok I get the below error:

Status error: 200
Status message: OK

Notice: Trying to get property 'sortby_table_name' of non-object in E:\wamp64\www\lsbio\plugins\csviaddon\csvi\com_csvi\model\export\custom.php on line 71
{"process":false,"records":449,"downloadurl":"http:\/\/localhost\/lsbio\/administrator\/index.php?option=com_csvi&task=exports.downloadfile&tmpl=component&file=RTovd2FtcDY0L3d3dy9sc2Jpby90bXAvY29tX2NzdmkvZXhwb3J0L0NTVklfY3VzdG9tIHRlbXBsYXRlXzEwLTAyLTIwMjBfMTEuMzUuY3N2","url":"http:\/\/localhost\/lsbio\/administrator\/index.php?option=com_csvi&view=logdetails&run_id=86&return=aHR0cDovL2xvY2FsaG9zdC9sc2Jpby9hZG1pbmlzdHJhdG9yL2luZGV4LnBocD9vcHRpb249Y29tX2Nzdmkmdmlldz1leHBvcnRz"}


I also have 2 logs that is enclosed as attacments.

Thanks
Attachments (2)
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Please load the attached patch file and run the custom table export. Post the export file to check.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Please find atached the exported table
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,

Thank you for the information you provided.

The issue with the logos has been identified and fixed. The reason the export died here is because the shipping rate was processed as a single value instead of possibly having multiple images. If you load the attached patchfile that issue will be fixed.

Your second problem is the shipment cost. The reason this is exported empty is because in your file I see the cost is stored as cost however in the VirtueMart form this is called shipment_cost. Since your name is different than what is in VirtueMart it doesn't export. Which VirtueMart version are you using?
Attachments (1)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Roland,

Thanks for your reply, I will try the patch.

I just upgraded my site from virtuemart 2.0.18a to 3.6.10. Maybe the upgraded did not go well for the shipping rate.

Thanks and b.rgds
  1. 2 weeks ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello,

Can you actually see the price when you edit a shipping rule? If you save it again, then run the export, do you see the cost in the export file?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hi,

Effectively, I can't see the shipment price when I edit the rule.
It is working fine now. Thanks for your help.

Another question. How do you change the field "shipment_name"?
My problem is as below:

I export all the shipping fields and I changed the shipping cost for example.
If I import the file back, it updates de shipping cost fine.

The problem is that if I change the field "shipment_name", its not updated but added.

Thanks
  1. 2 weeks ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello,
The problem is that if I change the field "shipment_name", its not updated but added.

shipment_name is the required field in VirtueMart Shipping rate import. With the value of this field RO CSVI will find the existing record in database, if the record is not present it will create a new row and if there is a record with matching name it will update the row. That is the reason you are seeing new shipment method created with new shipment_name. If you want to update existing shipment_name you need to use virtuemart_shipmentmethod_id field in your import file.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
thanks
  1. 2 weeks ago
  2. RO CSVI
  3. # 12
  • Page :
  • 1


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