Resolved problem with saving templates

Ok fixed it - it wasnt liking _ underscores in the file and classname

Thanks this is now solved - Thanks for all the info

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

This may be a problem with the template override Ive created. I will resolve and reply

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.

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":""}

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.

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

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

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.