Microvellum - Multiple Imports & Quantity Deduction
- Jean-François Rioux
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.
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.
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.
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
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
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.
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
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.
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
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.