Importing the Template for Manufacturer Parts

You can reimport the filled Excel file that you created earlier using the Create new file for import command. You can only import new data.

To import the Excel file:

  1. Click Library > Manufacturer part management.
  2. In Manufacturer part management, , click Import > Import Excel file .
  3. In the Open dialog box, select the Excel file to import and click Open.
  4. In the Manufacturer parts import dialog box, do the following:
    • Click Select file to open the Open dialog box and select the Excel file to import. Excel Import file displays the path of the imported Excel file.
    • Under Format selection and separator:
      • For Row format, choose from:
        • One line per circuit
        • One line per reference
        • One line per terminal
      • For Terminal separator, choose from:
        • Colon ':'
        • Line break
        • Pipe '|'
        • Semi colon ';'
      • For Circuit separator, choose from:
        • Colon ':'
        • Line break
        • Pipe '|'
        • Semi colon ';'
      You cannot use the same separator for Circuit separator and Terminal separator.
    • Under File preview, the preview of the imported file appears.
    • Select Update existing data to update the current data in the library with the data from the Excel file.
    • Click Simulate to simulate the manufacturer part import. A log file is created with the same name as the Excel file. If there are errors, you can open the Excel sheet and rectify the errors.
    • Click Open to open the selected Excel file for editing.
    • Click Import to import the Manufacturer part to the library.
    You can import data more efficiently by applying shared values to multiple circuits and terminals.

    If you enter one value for a circuit column, it applies to all circuits. If you enter one value for terminal column, it applies to all terminals through the circuits.

    While importing, if the values entered lack separators, the single value applies to all the circuits and terminals.

    The Terminal Mark field remains independent and is not affected by values meant for all terminals.

    Always review your Excel file for duplicate references before importing. The import tool uses the first instance, which can lead to incorrect or skipped data.