Welcome to another shocking How-to with SolidWorks Electrical Schematic. One of the seemingly most daunting tasks for new SolidWorks Electrical Schematic adapters is aligning the manufacturers database with the manufacturer parts that are used in house. SolidWorks Electrical Schematic has an import feature built in to make adding large amounts of Manufacturer parts a breeze. Let us take a look at the process and see how to use the tool.
Step 1 - You will need to create a spreadsheet of the desired manufacturer parts to import into SolidWorks Electrical Schematic. Be sure to include as much information as possible to populate the database. When you are done save this file in a location that you will remember.
Step 2 - Open SolidWorks Electrical Schematic and go to the library tab then click on Manufacturer Parts Manager.
Step 3 - Once the Manufacturer Parts Manager has opened Click on "Import"
Step 4 - Now that the import window has opened, click the Microsoft Excel Picture in the upper right had corner of the window.
Step 5 - Browse to the location where you spreadsheet is saveed. Select it and then click "open".
Step 6 - You shuold now be able to see the contents of the spreadsheet in the right hand pane of the Import window. Click "Next"
Step 7 - In the Definition of a Data Range window, place a check mark in the "Part" category. This should be the only active option. Then click "Next"
Step 8 - In this window you will select how many, if any title rows are present in your spreadsheet. You may use the up and down arrows to select how many rows you would like to leave out if the import. Click "Next"
Step 9 - This is the most important step in this process. The attributes in the left pane are database headers and the information on the right is the information to be imported. In this step you are going to map one to the other.
Select a category in the left pane and drag it to the corresponding column in the right pane. Do this for as many columns that you have in your spreadsheet. Once an attribute has ben added it will turn blue noting that it is already in use.
When this is complete, Click "Next" .
Step 10 - In this step information from the imported spreadsheet is going to be compared to the existing Manufacturers Part Database. To do this Click " Compare "
Step 11 - Once the check is complete you will get a text file with the overview of what is going to added or merged with your current manufacturer parts database. Once you have read this file you can close this window.
Step 12 - The last step is to click "Import" This will import all your new Manufacturer Parts into the SolidWorks Electrical Schematic Parts Database.
When this is complete, Click "Finish"
You are now free to start designing with a custom Manufacturer Parts Database. Enjoy!
By: Clare Schaeffer, Electrical Product Manager
For another blog article on SolidWorks Electrical, read Customize Wire Numbers With SolidWorks Electrical.