You can update elements using Excel when you have previously
exported the elements and made changes in the Excel file. You can
update the elements in Focal Point according to these changes. The
Excel 2007 file format is not supported. Files saved in Excel 2007
file format must be saved in Excel 2003 format before importing. The
export or import for the Link, Link List and Matrix attribute types
differs from other attribute types.
About this task
To update elements:
Procedure
- Click Display and select a view.
- Select Table structure. You can
only update the attributes that are editable in the Display view.
- Click Update Elements.
- In the Update frame, click Browse to
select an Excel file. Select the worksheet 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.
- Select Allow import to Matrix attributes to
include any matrix attributes in your update.
- Click OK to open the next frame.
- Select the information to update. To increase performance,
large files are updated in chunks. Select Fetch size from
Maximum number of rows per page if applicable. The page index is updated
accordingly.
- Select which attribute in Focal Point to use as identifier
in the top choice field. This field shows all attributes displayed
in the view, both readable and editable attributes.
- 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 update. You can
double click the value to edit the value of a cell and click Save before
updating the value.
- Click Update.