Batch-recalculate property for all objects in a vault

Sorry, I should have put in a bit more context.

We're using M-Files to manage our mechanical CAD files (3D models and drawings, basically, with a few other hangers-on). I'm trying to set things up as a "one stop shop" for our designers, to save us from having to rummage through the ERP system (which like all ERP systems is extremely user unfriendly), so I want to include on the metadata sheet things like how many of a component we have in stock, how quickly we burn through stock, how much it is, where to find it in Stores, etc. So I have SQL links into the ERP system to extract this data and present it on the metadata card. Of course we don't burn through stock that fast, hence a daily update is fine.

Most of the data items in the vault are CAD 3D models or drawings - it's the models that have all the metadata attached, so about 50% of the items in the vault. There's not that many of them (yet), so a workflow is potentially feasible, but it does seem... ungainly. I guess there are probably three properties that I really want to update regularly (stock size, cost, and usage rate), so that eases the load a bit further, doesn't it?

More and more, though, I'm thinking what I should do is set up a series of value lists, linked by part number, and then re-write the property scripts so that they use the part number as a look-up to return the cost/stock size/UR.

Sorry, I should have put in a bit more context.

We're using M-Files to manage our mechanical CAD files (3D models and drawings, basically, with a few other hangers-on). I'm trying to set things up as a "one stop shop" for our designers, to save us from having to rummage through the ERP system (which like all ERP systems is extremely user unfriendly), so I want to include on the metadata sheet things like how many of a component we have in stock, how quickly we burn through stock, how much it is, where to find it in Stores, etc. So I have SQL links into the ERP system to extract this data and present it on the metadata card. Of course we don't burn through stock that fast, hence a daily update is fine.

Most of the data items in the vault are CAD 3D models or drawings - it's the models that have all the metadata attached, so about 50% of the items in the vault. There's not that many of them (yet), so a workflow is potentially feasible, but it does seem... ungainly. I guess there are probably three properties that I really want to update regularly (stock size, cost, and usage rate), so that eases the load a bit further, doesn't it?

More and more, though, I'm thinking what I should do is set up a series of value lists, linked by part number, and then re-write the property scripts so that they use the part number as a look-up to return the cost/stock size/UR.