Bulk change document properties

adyb · ‎12 Oct 2020

Hi,

I have uploaded a tonne of documents into my repository and I need to change their document name. I can do this manually as I have an csv list of their current names and the names I need changing them to. Is it possible to change this property with an SQL command?

Cheers

EddieMay · ‎12 Oct 2020

Hi @adyb

You might want to read this post before attempting renaming.

HTH,

Digital Community Manager, Alfresco Software.
Problem solved? Click Accept as Solution!

adyb · ‎12 Oct 2020

Thanks, not really that proficient at Java... I was hoping that I could directly modify the sql tables

abhinavmishra14 · ‎12 Oct 2020

You should never update/alter anything in DB directly, it is not recommended. Use a java backed webscript that can rename the documents in batch instead.

You can also use BatchProcessor to process the no. of items at a time based on configured value.

~Abhinav
(ACSCE, AWS SAA, Azure Admin)