1. webstar
  2. RO CSVI
  3. Friday, 25 February 2022
  4.  Subscribe via email
Hi CAn you help - We've recently moved server and now when I jus simply save any templates I'm getting php errors when I try to run.

eg: Object of class stdClass could not be converted to string

All I did was open up a template on this new server and save it
Accepted Answer Pending Moderation
We are also getting partial downloads since moving server - ie a csv will only partially download and then the download doesnt finish
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
This may be a problem with the template override Ive created. I will resolve and reply
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
eg: Object of class stdClass could not be converted to string

Yes, these errors are possible with the override file.

We are also getting partial downloads since moving server - ie a csv will only partially download and then the download doesnt finish

It is possible that your new server has time limits and since that limit has been reached export does not finish. You can try to export only few records by setting From record and To record fields on File tab and check if the export finishes.
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
Yes I've limited to 1 row. If I dont use the template its fine and down loads. If I use the template I get the error. strange thing is it is working if I dont save the template. But when I save on this new server it doesnt work


Not sure if this helps at all
This is the good template from the DB - the override works absolutely fine


{"action":"export","component":"com_virtuemart","operation":"order","override":"shippingexport","exportto":["todownload"],"output_empty_file":"0","localpath":"/var\/www\/html","ftphost":"","ftpport":"","sftp":"0","ftpusername":"","ftppass":"","ftproot":"","ftpfile":"","export_email_addresses":"","export_email_addresses_cc":"","export_email_addresses_bcc":"","export_email_subject":"","export_email_body":"","database_username":"","database_password":"","database_host":"","database_portno":"","database_name":"","database_table":"","primary_key_source":"Order No","primary_key_target":"id","create_new_columns":"1","clientid":"","clientsecret":"","accesstoken":"","fulltoken":"","spreadsheetid":"","sheetname":"","range_from":"","range_to":"","export_filename":"shippingexport.csv","export_file":"csv","field_delimiter":",","text_enclosure":"\"","include_column_headers":"1","include_empty_nodes":"0","signature":"1","publish_state":"","recordstart":"","recordend":"","export_date_format":"d\/m\/Y H:i:s","export_price_format_decimal":"2","export_price_format_decsep":".","export_price_format_thousep":"","header":"","body":"","footer":"","language":"en-GB","splitorderline":"0","ordernostart":"","ordernoend":"","orderlist":"","usedatefield":"created_on","orderdaterange":"","lastorderid":"","orderdatestart":"","orderdateend":"","ordermdatestart":"","ordermdateend":"","orderstatus":["C"],"orderpayment":[""],"ordershipment":[""],"order_address":"BTST","ordermanufacturer":["none"],"ordercurrency":[""],"orderpricestart":"","orderpriceend":"","orderuser":[""],"orderproduct":[""],"groupbyfields":"{\"name\":[\"virtuemart_order_id\"]}","sortfields":"","use_system_limits":"0","max_execution_time":"","memory_limit":""}


Then I save it and It fails
This is the Bad one

{"action":"export","component":"com_virtuemart","operation":"order","override":"shippingexport","exportto":["todownload"],"output_empty_file":"0","localpath":"\/var\/www\/html","ftphost":"","ftpport":"","sftp":"0","ftpusername":"","ftppass":"","ftproot":"","ftpfile":"","export_email_addresses":"","export_email_addresses_cc":"","export_email_addresses_bcc":"","export_email_subject":"","export_email_body":"","database_username":"","database_password":"","database_host":"","database_portno":"","database_name":"","database_table":"","primary_key_source":"Order No","primary_key_target":"id","create_new_columns":"1","clientid":"","clientsecret":"","accesstoken":"","fulltoken":"","spreadsheetid":"","sheetname":"","range_from":"","range_to":"","valueInputOption":"RAW","export_filename":"shippingexport.csv","export_file":"csv","field_delimiter":",","text_enclosure":"\"","include_column_headers":"1","include_empty_nodes":"0","signature":"1","publish_state":"","recordstart":"","recordend":"","export_date_format":"d\/m\/Y H:i:s","export_price_format_decimal":"2","export_price_format_decsep":".","export_price_format_thousep":"","header":"","body":"","footer":"","language":"en-GB","splitorderline":"0","ordernostart":"","ordernoend":"","orderlist":"512446","usedatefield":"created_on","orderdaterange":"","lastorderid":"","orderdatestart":"","orderdateend":"","ordermdatestart":"","ordermdateend":"","orderstatus":["C","S"],"orderpayment":[""],"ordershipment":[""],"order_address":"BTST","ordermanufacturer":["none"],"ordercurrency":[""],"orderpricestart":"","orderpriceend":"","product_categories":[""],"incl_subcategory":"0","orderuser":[""],"orderproduct":[""],"groupbyfields":{"groupbyfields0":{"name":"virtuemart_order_id"}},"sortfields":"","use_system_limits":"0","max_execution_time":"","memory_limit":""}
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Yes, it is because your overrides does not support the new changes with RO CSVI. When you save the template, the new changes with Group by and Sort by fields are also saved and that is not supported by override file as it is not updated to latest RO CSVI version changes. You can remove the override and check the template. It should run without any error even after save.
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
Ok, got you - That makes sense. Ok I'll try to re-write the override based on the new version - I realise that overrides are perhaps not the best solution - for exactly this reason. Upgradabilty.

Thanks of the reply
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Argh, Any reason why new override files wouldnt be appearing in the dropdown selection within the template?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,
realise that overrides are perhaps not the best solution - for exactly this reason. Upgradabilty.

I totally agree to this. Overrides are painful with updates. This is the reason we recommend to write and use custom rules wherever possible.

Argh, Any reason why new override files wouldnt be appearing in the dropdown selection within the template?

Check the location where the overrides are saved. You can check Override import and export document for the location to be used.
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
Ok fixed it - it wasnt liking _ underscores in the file and classname

Thanks this is now solved - Thanks for all the info
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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