/
Spreadsheet gadget

Spreadsheet gadget

Information valid from AMI version 8.0 initial release

Summary

The Spreadsheet gadget lets you generate spreadsheets for modifying existing and creating new product information. Select one or more objects and, optionally, some attribute sets, then request an Export to generate the spreadsheet and download it.





Structure Type

Select the structure type to be displayed in the structure browser. Only structure types enabled for the current workspace will be available.

Structure Browser

Objects which can be selected to form part of the generated spreadsheet are displayed with a checkbox to the left of the object name. Select this box to include the objects in any generated spreadsheet.

Spreadsheet Gadget Menu Items

Status

Generated Spreadsheets

Select a spreadsheet in the Generated Spreadsheets box to download it.

Options

Parent attribute set

An optional attribute set to specify a list of attributes on the spreadsheet's primary sheet.

Child attribute set

An optional attribute to base the attributes in the spreadsheet on.

Export... Spreadsheet

This dialog lets the user start an export process based on the current selections in the main gadget display.

Send via email to

A comma-separated list of email addresses to send spreadsheets.

Export...

Generates a spreadsheet pre-populated with objects from the selected structure points.

Import... Spreadsheet

This dialog lets you select spreadsheets created by the Spreadsheet gadget and upload them to the server to update data.

Select Select file to select a single file. Select Upload to send this file to the server for processing.

Send via email to:

The address entered in the email field will be used to report errors encountered during the processing of the spreadsheet. Delimit multiple addresses with commas.

Select Refresh to clear the file selection.

Upload

Uploads the selected spreadsheet for processing.

Related pages