topic Re: Bulk change document properties in Alfresco Forum

Bulk change document properties

adyb — Mon, 12 Oct 2020 11:21:26 GMT

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

Re: Bulk change document properties

EddieMay — Mon, 12 Oct 2020 12:28:34 GMT

Hi @adyb

You might want to read this post before attempting renaming.

HTH,

Re: Bulk change document properties

adyb — Mon, 12 Oct 2020 13:39:09 GMT

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

Re: Bulk change document properties

abhinavmishra14 — Mon, 12 Oct 2020 15:17:43 GMT

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.