Discover M-Files Workspaces: All work available in the right business context, automatically!
➡️ Learn How it Works

Options
  • Locked Locked
  • Replies 5 replies
  • Subscribers 9 subscribers
  • Views 781 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
  • Hi ppickering,
    Thanks for the response. Not really what I wanted to hear - I don't really want to be opening M-Files Admin every day just to recalculate these values (hopefully there won't be any other need to open it!). I'm an engineer, I want to be out there hitting things with screwdrivers, etc.

    Okay. How about if I change tack? If I created a value list with all the data from the external database, and then changed the auto script for the property value to point to the value list, would that automatically update? I know the value lists update daily (at least), but would this rattle through to the property values? It seems like it might, but I don't know enough about how the property values pick up data from the value lists. If this approach works, it seems like it might be slightly clearer for future sysadmins, too.

    Easiest thing is to try it I guess. Anyone know off the top of their head how to write a vbscript to pick values from a list?
Reply
  • Hi ppickering,
    Thanks for the response. Not really what I wanted to hear - I don't really want to be opening M-Files Admin every day just to recalculate these values (hopefully there won't be any other need to open it!). I'm an engineer, I want to be out there hitting things with screwdrivers, etc.

    Okay. How about if I change tack? If I created a value list with all the data from the external database, and then changed the auto script for the property value to point to the value list, would that automatically update? I know the value lists update daily (at least), but would this rattle through to the property values? It seems like it might, but I don't know enough about how the property values pick up data from the value lists. If this approach works, it seems like it might be slightly clearer for future sysadmins, too.

    Easiest thing is to try it I guess. Anyone know off the top of their head how to write a vbscript to pick values from a list?
Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.