When you complete the steps in Module 4 you will be able to:
▪Understand the full Import functionality
▪Add new parts to CIP and update existing parts
To update Capacitors
Step 1: Select the Admin > Bulk Operations > Import menu. At the Import tab, click Configuration button to open the Import CSV File window.
Step 2: Browse to choose the import file, SampleParts.csv. Click Upload to upload the file and click Next.
Step 3: Using the Next button, navigate through each Import screen to verify the mapping configuration you saved in Module 3. When the last window opens, (Transistors Field Mappings), Save the configuration.
Step 4: Select the Simulate check box and click the Add and Update button. The green status bar indicates the completion of the analysis.
Step 5: Review the Simulate Log. Notice there are 18 capacitors updated and no new parts.
Step 6: Conduct a search for parts that have "SAMP" in the part name. Include the "Description" field in the search results. Notice the description in the search results. The abbreviations CER and TANT indicate the Description field is not yet updated, since Simulate Option was used.
CIP search results
Step 7: Return to the CIP Import tab and click the Configuration button. Choose and upload the file SampleParts.csv. Then click Next to verify the configuration mappings of each screen. When you complete the last screen Save the mappings.
Step 8: Deselect the Simulate check box and click the Add and Update button to actually update existing CIP parts.
Step 9: Review the Import Log and notice there are 18 parts updated.
Step 10: Conduct a database search for parts that contain SAMP in the PART_NUMBER. Include the Description in the search results.
Review the 29 parts in the search results. Notice the Descriptions field. CER is updated to Ceramic and TANT is updated to Tantalum.
In addition to adding new parts to CIP, Module 4 has demonstrated how the Add and Update button can be used to update the properties of existing parts. The search results shown in the above image show the updated content of the capacitors Description property.