- Posted by Elena Vallejo
- On April 23, 2019
The Components Area can be found in the bottom DCL/BOM DETAILS and is divided into two main areas, one is this one in question, and the other is the DCL/BOM HEADER DATA AREA (explained in another FAQ).
The COMPONENTS AREA is the area where all the information related to the components of the DCL/BOM are shown. Initially, this area will appear empty, until no component has been added.
But as soon as a component is included in the DCL/BOM, the following areas will appear:
- SEARCH AREA: where any of the components listed in the DCL/BOM can be filtered by any reference or ESA family/group code.
- COMPONENTS DETAILS AREA: where the related information to the components is categorized into four different sections:
- DOEEET PART REFERENCE
- PART MATCHING STATUS
- DOEEET AND USER PART DETAILS (shifting the bar, more fields will appear in the screen).
- USER PART DATA (shifting the bar, more fields will appear in the screen).
By clicking on the button “ADD COMPONENTS”, it is granted access to doEEEt database where the required component can be selected using any of the available possibilities (search bar, family/category tree or filtering area).
Once the component has been chosen, it can be added to the DCL/BOM using the “ADD TO DCL/BOM” button.
By default, it is shown the current DCL/BOM, but if needed, it can be added to a different DCL/BOM or even create a new DCL/BOM where include the selected component.
In this case, the components of the DCL/BOM will only include the data taken from doEEEt database, i.e. only the fields listed in the section doEEEt PART REFERENCE, PART MATCHING STATUS and doEEEt PART DETAILS will be shown. The field “Quantity” can be edited directly introducing the value in the box.
Importing Components from a File
If the components list is included in an excel file, the option “UPLOAD FILE” can be used to upload the components in the current DCL/BOM. The importing process will follow the following three steps sequence:
1)To select the excel file where the components list is located, with “SELECT A FILE” button, and once the file has been selected, click on the “UPLOAD” button.
2)To import the components included in the different tabs of the excel file, selecting first the coordinates where the valid data to be imported are located, clicking on the “LOAD COLUMNS” button.
At any moment, If the current tab doesn´t need to be taking into account, the user can waive it by clicking on the “SKIP THIS SHEET” button.
In order to import properly the data included in the excel file, it is needed to do mapping, assigning the defined columns from the DCL/BOM to the correct column of the excel file.
The importing process allows, first of all, to process a list of components which includes only the very basic information, i.e., the definition of the components (part type, component number, manufacturer) and the quantity.
If the list of a component to process has more data to include in the DCLs/BOMs, the system allows importing all the fields mentioned in the ESCC-Q-60C by clicking on the “SHOW MORE FIELDS” button.
The mapping process of assigning the defined columns from the DCL/BOM to the correct column of the excel file is a manual process which has to be done column by column.
However, if previously to the importing process, the columns name of the excel file have been renamed as indicated in the TEMPLATE FILE which can be downloaded, the mapping process will be more agile because the assignation of the columns from the DCL/BOM to the column of the excel file is done automatically.
3)During the importing process, the system will check if the component is included in doEEEt database, storing the related information in the DCL/BOM. Those components matched will be showed in the components area of the current DCL/BOM, including all the mapped information as well as the doEEEt matching information (shadowed).
If at the end of the importing process the system detects that at a component level any of the fields PROJECT/SUBSYSTEM/UNIT/USER is different to the ones defined at header level, the user is advised about this situation.