Manuals - 3Dfindit

5.12.11.26. Classify electrical parts: Additional modules

5.12.11.26.3. Electrical classification import/export

With the Electrical classification import/export module, you can export electrical classification data to Excel format and import it again. This is recommended whenever a large number of connection points are to be classified and there are many similarities between individual values. The characteristic values of the connection points can be easily copied and edited in Excel.

Following description shows a complete procedure exemplarily.

Set all required connection points; they have to be available before.
You can also use the Connection Point Wizard for this.
Set the required classes.
1. Click in PARTproject -> Edit project -> Preview, click on the context menu command Select connection point [Choose connection point].
  
  Select connection point [Choose connection point]: Call
  
  -> The same-named dialog box is opened.
  
  Select connection point [Choose connection point]: Dialog
2. Select the desired connection point and confirm with OK.
3. Scroll down to class name [Class name] "Electrical Connection " and activate the checkbox.
  -> The item is entered under Published elements.
  -> The 3D file name [3D filename] and 3D identification features are already filled in automatically.
  
  Basic values automatically filled
4. Manually set the name and identifier (same value).
  -> The name is now also displayed under Published elements.
  
  Note
  Assigning a name will also serve for a better overview in Excel later.
  
  Name is set
5. Classify all other connection points in the same way. It does not necessarily have to be the Electrical Connection class. The connection point MP, for example, has the class Mounting Point.
  -> This leads to the following result.
  
  Connection points classified
6. Now set all the required values manually for ONE point of each class (here in the example for A1 [Electrical Connection ]). You can do this either under Published elements or in the Class variables dialog.
  - Published elements: Select the desired element and enter values for the desired characteristics below.
    
    Published elements: Characteristic values filled
  - You have a better overview in the Class variables dialog box as you can enlarge and sort it.
    
    Class variables: Characteristic values filled
Now call up the Electrical classification import/export add-on module.

Call Exporter

-> The eclassExporter dialog box opens (still empty).

eclassExporter: before start
Click on the Export to file.... button
Determine an Excel file for saving the data.

Save XLSX file path

-> Click on Save to start the export. Once this is complete, the message "Done" is displayed.

Note
If a project contains several 3db files data of all files will be exported.

Export finished
Open the Excel file determined before.
We recommend using the filter function so that you can focus on the desired data in each case. In this example, we have filtered by Part Number and Classification Name "CNS_CP|4|3".

"Part Number" filter

"Classification Name" filter - here "CNS_CP|4|3" exemplarily
Focus on the area to be edited.

Excel columns: Only one connection point filled

The color coding helps for orientation.

General
CNS: NON electrical classification values
CNS: Values of the electrical classification
Visible the project table
For all connection points (rows), fill the attributes with values, what can easily and quickly be managed with the help of Excel functionality.
Here in this example, every row corresponds to one connection point (what not necessarily has to be the case, also multiple are possible).
Save the Excel file.

Excel columns: All connection points filled
Start the eclassExporter again and this time click on the button Import from file....

eclassExporter: before start
After finished import the message "Done" is shown.

eclassExporter: after finished import
Check if the data have been transferred to the other points.

A2 for example, now also contains the described data.

The prerequisite for using the module and displaying the context menu command is that the files eClass2.cfg and eClass2.vbb are located at $CADENAS/libs/all/plugins are located.

Prev	Up	Next
5.12.11.26.2.2. Information for modeling	Home	5.12.11.26.4. Verify classification

	General
	CNS: NON electrical classification values
	CNS: Values of the electrical classification
	Visible the project table