I am working on updating a weldment database, this requires among other issues to unify the custom properties. The action I would like to do is delete unnecesarry ones, rename some and create new content in most.

While these are ismple to do manually one by one, changing several tousand files is something unfair to give even to students

So I am looking for a way to automate the process. Ideally some sort of link between all the files and an excel table would probably work best. Maybe a macro which could work with the scheduler, I wouldn't mind leaving the computer to do the work over the weekend. Any idea is welcome.

I am experimenting with using Solidworks scheduler. This would require renaming of templates to parts and works nice only for creating new fields common to all the parts. Maybe someone knows of a better way of using this option.