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
- In the Add menu, click the view to add an element. . The Add New Element frame is displayed.
- Click Add Multiple Elements.
Note: You can only import attributes that are editable in the
Add view. All other attributes has the default value.
- In the Import frame, click Browse to
select an Excel file. Select the worksheet that contains the relevant
elements and their attributes.
- 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.
- Select Allow import to Matrix attributes to
include any Matrix attributes in your import.
- Click OK to open the next frame.
- 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.
- 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.
- 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.
- 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.