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.