Options
  • Locked Locked
  • Replies 5 replies
  • Subscribers 8 subscribers
  • Views 516 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Batch-recalculate property for all objects in a vault

Moom137
Hi,
Apologies if this is obvious somewhere, but I've looked, honest! Simple question: How can I automatically recalculate an automatically calculated property for all objects in the vault? I've already locked myself out of a couple of sandbox vaults trying to get this to work.

A bit more detail: The properties involved use a vbscript with an SQL query in it to get component data from an external database. One update a day is fine. But how?

Seems like this might be a bit buggy:
https://community.m-files.com/index.php?topic=11850.msg32810#msg32810
https://community.m-files.com/index.php?topic=6072.msg32806#msg32806

Is there a better way?

Thanks

Matt
Parents
  • That sounds very much like the data you'll be pulling through, from the ERP system, will be changing quite frequently, so it might be you can get away without having to implement any solution. The connection to the external source will update the information held in M-Files periodically (I've been trying to find out how often, and when, but can't find anything to help on this), so if anything changes on an object as a result of this, any automatic properties on the object will also update.

    Does that help, or does it sound like you still might need something that makes sure items get updated at least on a daily basis?
Reply
  • That sounds very much like the data you'll be pulling through, from the ERP system, will be changing quite frequently, so it might be you can get away without having to implement any solution. The connection to the external source will update the information held in M-Files periodically (I've been trying to find out how often, and when, but can't find anything to help on this), so if anything changes on an object as a result of this, any automatic properties on the object will also update.

    Does that help, or does it sound like you still might need something that makes sure items get updated at least on a daily basis?
Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.