To import or update elements, you need a file in .xls format
with rows or columns corresponding to attributes of the element type.
You can either import new elements in a module or update existing
elements in a module. The Excel 2007 file format is not supported.
Files saved in Excel 2007 format must be saved in Excel 2003 format
prior to importing. You can import and update all attributes except
for the attribute types File, History and Matrix from within the module.
The maximum limit for Excel cells is set to 8 KB where each cell contains
approximately 8100 characters.
Procedure
- In the Modules menu, click the module to which you want
to import the elements.
- In the bottom frame, click Import.
Note: When you import or update links and hyperlinks from Excel
sheet to a text attribute, the link is displayed as plain text.
- In the Import frame, click Browse to
select an Excel file.
- Select the work sheet that contains the 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.
- Click OK to open the next frame.
- Select the information to update.
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.
- To update existing elements, select an attribute that identifies
the elements like the ID attribute. If no matching element is found,
you can either ignore the values or use them to create a new element.
- 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 elements to update or import. You can edit the
value of a cell and click Save before updating
the value.
- Click Import.