Resolved Error on ecport shipping rate in virtuemart 3.6.10

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.

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

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.

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

Hello,
Please load the attached patch file and run the custom table export. Post the export file to check.

Please find atached the exported table

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?

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

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?

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

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.

thanks