Information valid from AMI version 8.0 initial release
Summary
The Spreadsheet gadget lets the user generate spreadsheets for modifying existing and creating new product information. You select one or more objects and, optionally, some attribute sets, then request an Export to generate the spreadsheet. Available spreadsheets can be downloaded to the user's machine for editing. After this they can be uploaded using the File Transfer gadget.
Structure Type
Select the structure type to be displayed in the structure browser.
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. Checking this box will add the object to the list of objects to be included in any generated spreadsheet.
Spreadsheet Gadget Menu Items
Status
Generated Spreadsheets
Once generated, spreadsheets can be clicked in the 'Generated Spreadsheets' box to download them.
Options
Parent attribute set
Optional: An attribute set that is used to specify a list of attributes on the spreadsheet's primary sheet.
Child attribute set
Optional: An attribute set that is used 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 that generated spreadsheets will be sent to.
Export...
Will generate a spreadsheet pre-populated with existing objects from the selected branches of the tree structure.
Import... Spreadsheet
This dialog lets the user select spreadsheets initially created by the Spreadsheet Gadget and upload them to the server for processing of the new details they contain.
Clicking on the 'Select file' button brings up a directory browser that lets you choose a single file. Clicking on the 'Upload' button sends 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. Multiple addresses can be entered using a comma to separate them.
To clear the file selection, use the gadget's 'Refresh' menu option.
Upload
Uploads the selected spreadsheet for processing.