Microvellum - Multiple Imports & Quantity Deduction

By Jean-François Rioux
4 min

This feature is available in Microvellum version 15.

It allows for the import of multiple "sdf" files from Microvellum.

As part of this functionality, a quantity deduction is performed on HARDWARE products only.

An additional feature allows for the removal of files from the client's folder once they have been selected. This document elaborates on these specific features.

Configuration

In a manufacturing configuration file, the following options are available.

image-20241216-193644.png
Selected options are only available in Microvellum 15 import type

Explanations

Do not keep imported files

In the Cienapps CAD/CAM import, it is possible to select the import files. This selection of files is carried out and they are saved in the customer file.

 

image-20241216-193917.png
In the CFAO import for the Cienapps customer, a file is selected and saved in the customer folder of the CFAO directory of the manufacturer configuration

 

 

image-20241216-194001.png
In the customer record, the CAD/CAM files are saved. They become reusable for other CAD/CAM imports.

This feature - do not keep imported files - allows you to make a selection without saving them in the customer file. They are temporary and the reference is removed when the import window is closed.

They are not copied to the CFAO directory.

Enable multiple import

This feature allows you to select multiple import files.

Multiple import

The ‘triangle’ button allows you to navigate to the window for selecting files to import.

 

image-20241216-194353.png

The “Process” column allows you to select the files considered by the import.

The description column corresponds to the description from the microvellum file in the ‘WorkOrderBatches’ table and ‘Name’ field.

After a selection, the multiple file indicator is displayed

image-20241216-194520.png

When importing, in the classification selection window, the 'Description' column contains a concatenation of the individual description of the selected files and separated by “\”.

Example

image-20241216-194652.png
The descriptions of the files are combined and separated by “\”

During import, the ‘To be processed’ files are imported. This action accumulates the quantities of the materials while the finished products are considered per unit. The description is assigned.

image-20241216-194803.png
The description is accumulated and reported in the 'Description' column.
image-20241216-194824.png
All material quantities are accumulated and displayed in the materials tab.

The functionality is used as in the case of standard import (non-existent correspondence, exclusions, etc.).

When the ‘Save’ button is pressed and an existing quotation, order or WO is selected

image-20241216-194942.png

The option ‘Deduct the quantities of hardware already there’ is available and selected by default.

Merging folders disables this feature. It is only available in the case of a new folder during a merge and applies to ‘HARDWARE’ type products only.

image-20241216-195031.png

How the deduction works

For products that are not HARDWARE, the import is carried out as is without verification of quantities.

For HARDWARE products only,

  • If the imported quantity is smaller than the current quantity of the merged folder, an error message appears with the targeted product codes

image-20241216-195347.png

  • If the quantity is equal, the product is not imported. In other words, it has no impact on the import.

  • If the quantity imported exceeds the quantity already present, only the difference is imported (e.g.: quantity to import = 3 and quantity already present = 1, quantity imported = 3-1 = 2).

Important

When importing, the quantities considered already present in the targeted project (quotation, WO and order) are both finished products and materials.

 

Related content