Importing elements

To import elements or add multiple elements, you need a file in .xls format, with rows or columns corresponding to attributes of the element type. The Excel 2007 file format is not supported. Files saved in Excel 2007 file format must be saved in Excel 2003 format prior to import. The export or import for the Link, Link List and Matrix attribute types differs from other attribute types. The maximum limit for Excel cells is set to 8 KB where each cell contains approximately 8100 characters.

About this task

To import elements or add multiple elements:

Procedure

  1. In the Add menu, click the view to add an element. . The Add New Element frame is displayed.
  2. Click Add Multiple Elements.
    Note: You can only import attributes that are editable in the Add view. All other attributes has the default value.
  3. In the Import frame, click Browse to select an Excel file. Select the worksheet that contains the relevant elements and their attributes.
  4. In the Matrix setup, select Each ROW, if each row in the worksheet contains the attributes of an element. Select Each COLUMN if each column in the worksheet contains the attributes of an element. It is optional to include the attribute names in the worksheet.
  5. Select Allow import to Matrix attributes to include any Matrix attributes in your import.
  6. Click OK to open the next frame.
  7. Select the information to import.
    Tip: To increase performance, large files are imported in chunks. Select Fetch size from Maximum number of rows per page if applicable. The page index is updated accordingly.
  8. Select which attributes to use for the columns. If the first row or column of the Excel sheet contains attribute names, the attributes are automatically selected.
  9. Select the check boxes of the elements to import. You can double click and edit the value of a cell and click Save before importing the value.
  10. Click Import.
    Note: When importing links, link lists or incoming links, only links within the workspace are set. It is not possible to import links to other workspaces. For Text List attributes, you can select multiple columns to be imported to the same attribute.

Feedback