Hello,
I have loaded articles from an old Joomla _content file but missed off the created date. I am not confident of running an update just for the "created" field. Can you kindly point me to some documentation on how to do this? I note the date in the .ods spreadsheet is mm/dd/yy hh:mm PM.
Many thanks
Peter
UK
I have gone ahead and used the original upload but changed the field list to include alias and category_path, plus I have added created. When I run it I now get the error: Deprecated: Use of "self" in callables is deprecated in /home/customer/www/scottsproject.org.uk/public_html/administrator/components/com_csvi/assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 476
Hello,
Can you kindly point me to some documentation on how to do this? I note the date in the .ods spreadsheet is mm/dd/yy hh:mm PM.
You can use RO CSVI custom table import template to update created field. Set Import based on field to any unique field in content table and run the import so existing records are updated. Also supported date format in database is Y-m-d H:i:s, you can change the date format using RO CSVI Multi replace rule and Custom date format operation.
When I run it I now get the error: Deprecated: Use of "self" in callables is deprecated in /home/customer/www/scottsproject.org.uk/public_html/administrator/components/com_csvi/assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/NumberFormat.php on line 476
This warning is from an external library file used in RO CSVI. In import template on Details tab set Error reporting to None and run the import. See if warning is gone with that.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.