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.0921.641

      The following release notes apply to Toolbox build 23.1.0921.641 Cumulative Library Updates Fix Figure 1: Cumulative Update issue. There was a bug noted by users while attempting to download the Foundation Library’s phase 1 cumulative update and ...
    • Microvellum Foundation Library Release Notes | Build 23.0919

      Additions Added new product Master Double Sided Cabinet. Added “Horizontal Handles Centered” global option to all doors. This is available for all tab pulls, handles, and knobs. Added a new DRAWRECTANGLE 2D plan token to the door subassemblies. This ...
    • My Cases: Case Details

      Once you've logged into the Client Portal and navigated to the My Cases area, simply click on the case title to access the case details page. Here, you can thoroughly review the case description, append additional comments, upload attachments, and ...
    • My Cases: Overview

      Once you've logged into the Client Portal, accessing your support cases is a breeze. You can simply click on the "My Cases" icon in the flyout menu or choose the "View Cases" button conveniently placed on the Welcome page. Inside this section, you'll ...
    • Uploading Attachments to Support Cases

      Support case attachments are files or documents attached to a support case or ticket, serving the purpose of providing additional information, context, or evidence relevant to the reported issue. These attachments can encompass a wide range of file ...