error when importing

[karen]

Hi, I'm having trouble importing from csv and xlsx.
I have exported from my database so that I know the field names are correct. The file name is the same as the database.

I managed to find the error in the log:

[Wed Apr 10 11:00:53.060643 2024] [proxy_fcgi:error] [pid 4016067:tid 140072347223616] [client 77.44.82.0:0] AH01071: Got error 'PHP message: PHP Warning: move_uploaded_file(/var/www/vhosts/xxxxxxxx.co.uk/demo.xxxxxxxx.co.uk/uploads_import/661663550ea776.39928860.csv): Failed to open stream: Permission denied in /var/www/vhosts/xxxxxxxx.co.uk/demo.xxxxxxxx.co.uk/front_logic.php on line 0; PHP message: PHP Warning: move_uploaded_file(): Unable to move "/tmp/phpJHZap7" to "/var/www/vhosts/xxxxxxxx.co.uk/demo.xxxxxxxx.co.uk/uploads_import/661663550ea776.39928860.csv" in /var/www/vhosts/xxxxxxxx.co.uk/demo.xxxxxxxx.co.uk/front_logic.php on line 0', referer: https://demo.xxxxxxxx.co.uk/index.php?tablename=Hoses&function=import_from_csv&step=1

The permissions on my uploads_import file is 755, is that correct?

 

[deep64blue]

You need to check permissions on both /tmp and uploads_import folders, dadabik is trying to move the file from one to the other and being denied.

 

[karen]

You need to check permissions on both /tmp and uploads_import folders, dadabik is trying to move the file from one to the other and being denied.

Hi, thanks! I got that sorted, now I have an error that says:


in my csv file, my dates are set out as dd/mm/yyyy, so I think this is the problem. I think I might need to implement a transformation function, but I'm not sure of the syntax I need to get the date to yyyy-mm-dd as per expected? Would you or @eugenio have an example of that please?