Overview of Hardware Spreadsheet Synchronization

Overview of Hardware Spreadsheet Synchronization

Our goal at Microvellum is to produce software that runs as efficiently as possible. We are continuously looking for ways to streamline the process and reduce the time it takes to load spec groups and save valuable performance resources. One example of this is our work to streamline the material files.

For example, perhaps you have thousands of drawer slides that exist only to supply a value for pricing or costing purposes. You don’t need to draw them or use machine tokens from them, and if they are synchronized along with all the materials, it increases spec group loading time.

Why Is Synchronization Necessary?

Why is it necessary to sync data, and what is being synced? To answer that question, you must understand a little bit about the relationship between two components of the software.

To benefit from the customization benefits of spreadsheets, and the storage and retrieval power of databases, Microvellum uses a combination of the two when working with library data. Synchronization is necessary for obvious reasons to keep the data consistent between the two sources of data. The data syncs anytime the spec group is accessed.

Synchronizing this type of data between the material file in the database and the working spreadsheet is one area that takes a significant amount of time for large spec groups. Not all of this data requires synchronization. If the data does not change often, unproductive seconds are spent waiting for the program to ‘sync’ that data. Also, some data may improperly overwrite existing data. The program should not ‘sync’ ALL data.

Skip a Material When Syncing the Database and Spreadsheet

Microvellum build 15.6.2201, or greater, contains the ability to set a property that prevents any single material from syncing between the database and the program library spreadsheet. Check the box “Skip Spreadsheet Sync” inside the Edit Material screen to enable this feature.


Fig. 1 – Hardware Material with No “Skip Spreadsheet Sync” Checkbox Displayed

Fig. 2 – Hardware Material with “Skip Spreadsheet Sync” Checkbox Displayed

The ability to prevent synchronization for any specific material is limited to Hardware only. This category of material does not change on a project basis as do other types of materials. Some hardware materials and most other materials involve part thickness and formulas, and if the program skipped those, it could cause issues elsewhere in a project. But for hardware materials that allow it, you may use the property to tell Microvellum to skip that material from syncing into the spreadsheet. This helps reduce the time it takes to load spec groups.

The program does not display the box to skip syncing for any formula-driven hardware materials and any items that have hardware machine tokens assigned to them.

To display the “Skip Spreadsheet Sync” checkbox when adding a new project-level material, save the material, and reopen it. Then if you want to maximize performance, check the box and click OK.

The value for “Skip Spreadsheet Sync” is not stored in the spreadsheet, so you cannot edit that property for multiple materials there. Instead, use the Edit Multiple Materials interface to change that property for multiple materials at once.


Fig. 3 – Edit Multiple Materials Access

Fig. 4 – Edit Multiple Materials Interface

After you have set this property for the preferred hardware materials, enjoy the benefits of increased speed when loading spec groups with this option checked ON.


    • Related Articles

    • Overview: Formula Driven Materials

      There are two distinct types of Microvellum materials – formula materials and non-formula (traditional) materials. This article focuses on formula-driven materials. Accessing Formula-Driven Materials You may use either the Add Formula Material ...
    • Overview: Materials in Microvellum

      Material Levels in Toolbox Figure 1: Library Specification Groups. Figure 2: Project Specification Groups. Materials in Toolbox can be controlled through one of two interfaces, each of which is attached to one of two levels of control: library ...
    • Importing Materials from the Spreadsheet

      MV has added an alternative process that may be easier. See this article for more information: https://community.microvellum.com/portal/en/kb/articles/create-materials-from-import-file#Import_File_Structure
    • Overview & Tutorials: Formula Generated Materials in Doors

      This video explains and demonstrates how to use formula generated materials in the default 048 library data. Prior to this library version, this had not been included in the shipping library data although some Users have been doing this in their ...
    • Overview & Tutorials: Face Frame Images 3 (Customizing in the Spreadsheet)

      This is the third article in the series giving an overview of how to configure the custom face frame images in the default Microvellum shipping libraries of build 046.2 and higher. The first articles in the series discussed how to use the default ...
    • Recent Articles

    • Toolbox Release Notes | Build 24.1.0611.641

      The following release notes apply to Toolbox build 24.1.0611.641 SMA Fixes Users reported two issues centered around the Solid Model Analyzer, specifically centered around routing on parts that used the SMA. Fig. 01: The midpoint of an arc going ...
    • Microvellum Foundation Library Release Notes | Build 24.0607

      Additions Added additional features to the ADA Sink Angled Frame: Option to turn on Mounting Rails for the Angled Panel (and toe kick). Fastening method have been included. Hardware options have been modified to include fastening hardware to attach ...
    • Foundation Hardware Highlight: Hettich

      Microvellum’s Foundation Library is built on the premise of providing our users with the best quality hardware for their construction projects, be they commercial, residential, or anything otherwise. As such, Toolbox has hardware from multiple brands ...
    • Toolbox Release Notes | Build 24.1.0528.641

      The following release notes apply to Toolbox build 24.1.0528.641 Part Report Fix Fig. 1: Correctly flipped face 6 report image (top) and incorrectly flipped face 6 image (bottom). An issue would sometimes reportedly occur when a single part was ...
    • Microvellum Foundation Library Release Notes | Build 24.0520

      Additions Added a new product, the “Extruded Master Countertop”. Four other extruded countertop products have been replaced with a new version based on this product. Many new features have been added into this enhanced extruded product (Toolbox ...