Change multiple filenames at once

Hi,

Some time ago I've migrated my page to newer Joomla instance. With that migration I had to change to eDocman. To track every single file I come with a solution to add a number in [ ] before filename - for example [1234]filename.xlsx. I worked very well but now I have quite a bizzare problem - if an Excel file (.xlsx) has such a number in it's file name, Excel is taking that number as file name. For example if I try to open aformetioned [1234]filename.xlsx, Excel won't open it displaying error that he cannot find 1234.xlsx.

I would like to change the filenames by deleting that number with the bracket and I wonder if I do so in database and on the server won't this destroy everything? or is there any other way to achieve that?

Regards

Hi Dominik,
If you want to remove the number in brackets from the file names, you can do that — but please be careful.
In addition to renaming the files in the database, specifically in the table #__edocman_documents, you need to update both of the following columns:
- original_filename
- filename

You also have to make sure that the actual file names on the server match the new values you've entered in the database. If the names don't match, the documents will not load properly.
Let me know if you need any assistance during this process.

Best regards,
Dam