Creating a New Excel File for Cable References

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 Excel file for import .
  3. In the Create new Excel file for cable reference import dialog box, select the following:
    Option Description
    File language Lets you select the language. The default language corresponds to the interface language.

    The list contains the 14 languages that correspond to the interface languages.

    Description/Translatable data languages Lets you add a description in multiple languages.

    Click to open the Language selector dialog box to select multiple languages.

    Class Lets you open the Class selector dialog box and select the base class for the cable references.

    If you do not select any class then all the classes and subclasses are available in the Excel file.

    Template available Lets you select the Excel file found in the template folder.
    Fill with displayed manufacturer parts Lets you fill the Excel file with the cable references displayed in the Cable reference management dialog box.
    Class is disabled when this option is selected, as a file can contain multiple classes.
    Open created Excel file Lets you 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 the 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 list items in some columns, based on the Excel feature Data Validation.