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 ...
    • 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 ...
    • Working Within the Hardware Parts Tab

      Working Within the Hardware Parts Tab The Hardware Parts tab is where hardware items for the product are located. Note: If the Hardware Parts tab does not contain any hardware items, they may be contained in a subassembly. Hardware items can be ...
    • Recent Articles

    • Toolbox Release Notes | Build 23.1.0329.641

      Toolbox Release Notes | Build 23.1.0329.641 Processing Center Resolutions: Resolved an error in the ‘View Nesting G-Code Results’ UI when trying to view DXF’s. ‘Modify Work Order’ will no longer remove certain edge band information if editing that ...
    • Microvellum Foundation Library Release Notes | Build 23.0320

      The following release notes apply to Microvellum Foundation Library, Build 23.0320. This update includes many changes & additions to the Microvellum Closet/Wardrobe Expansion. If you have not purchased this expansion, you will not have access to ...
    • Toolbox Release Notes | Build 23.1.0313.641

      Toolbox Release Notes | Build 23.1.0313.641 Label Images Resolutions: Resolved an issue with PTP stations not flipping the face 6 WMF image correctly. WMF orientation should now match the gcode. Resolved an issue with Unified Work Order databases not ...
    • Toolbox Release Notes | Build 23.1.0222.641

      The following Release Notes apply to Toolbox Build 23.1.0222.641. Machine Tokens Resolutions: We fixed a bug affecting certain libraries that used the CONST token, which led to incorrect calculations of the distance between holes. We also fixed an ...
    • Microvellum Foundation Library Release Notes | Build 23.0210

      The following release notes apply to Microvellum Foundation Library, Build 23.0210. Additions: • Added a new global variable “Hinge Offset From Edge” to provide easier control without needing to update the finished faces subassembly. • Added a sample ...