Import Options to Manage Cable References and Manufacturer Parts (2024 SP2)

Two new commands are available in Cable reference management and Manufacturer part management:

  • Create new file for import
  • Import Excel file
In Cable reference management, you can access the commands from:
  • Library > Cable reference management. In Cable reference management, click Import > Create new file for import .
  • Library > Cable reference management. In Cable reference management, click Import > Import Excel file .
In Manufacturer part management, you can access the commands from:
  • Library > Manufacturer part management. In Manufacturer part management, click Import > Create new file for import .
  • Library > Manufacturer part management. In Manufacturer part management, click Import > Import Excel file .

Creating a New Excel File from Template

You can create a new Excel file for import and adapt it to the input language and class of manufacturer parts or cable references.

You can import all the data from the cable references and manufacturer parts, which were previously missing in the file, like cable core details, complex cable core properties, circuits, and connections points in manufacturer parts.

To create a new Excel file from the template for cable references:

  1. Click Library > Cable reference management .
  2. In the Cable reference management dialog box, click Import > Create new file for import .
  3. In the Create new Excel file for cable reference import dialog box, select the following:
    • For Language, select the language from the list. The default language is set to match the interface language. The list contains the 14 languages that correspond to the interface languages.
    • For Class, click to open the Class selector and select the base class for cable reference. If you do not select any class then all the classes and subclasses are available in the Excel file.
    • For Template available, select the Excel file found in the template folder.
    • Select Open created template to open the created template.
  4. Click OK.
  5. In the Save As dialog box, save the new Excel file in the required location. The file opens automatically.
  6. Edit the data in the Excel file to import the new data to the cable references.
    • Reference is the mandatory field for the successful import of the data.
    • Manufacturer, Class, Library, Family, Cable type, etc. are required fields. If you leave these fields empty, the software warns you and imports the data with errors.
    • Article Number, External ID, Translatable data, etc. are optional fields. If you leave these fields empty, no errors occur.
    • Column A (can be hidden) contains key code, for example, to identify the language of the header.
    • The last row of header (can be hidden) contains the name of fields associated with columns like #car_reference. Do not remove this information.
    • You can add more columns for translated data to enter more languages at the same time. Modify the language code in the field name, like .en in #car.ctr_0.en for cable description.
    • The hidden page _ValidationList_ contains the named range used to show drop-down items in some columns, based on the Excel feature Data Validation.
    You can also create a new Excel file for import of the Manufacturer part using the same steps as above. Access the command from Library > Manufacturer part management. In Manufacturer part management, click Import > Create new file for import .

Importing the Template

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 > Cable reference management .
  2. In Cable reference management, click Import > Import Excel file .
  3. In the Open dialog box, select the Excel file to import and click Open.
  4. In the Cable references 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 cable core
      • One line per reference
        For Cable core separator, choose from:
        • Colon ':'
        • Line break
        • Pipe '|'
        • Semi colon ';'
        This option appears only if you select One line per reference for Row format.
    • Under File preview, the preview of the imported file appears.
    • Click Compare to simulate cable reference 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 cable reference to the library.
    You can also import the template for the Manufacturer part using the same steps as above. Access the command from Library > Manufacturer part management. In Manufacturer part management, click Import > Import Excel file .