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.