Provides an alternative method for bulk editing when used in conjunction with the import feature. See Importing Assets from a Spreadsheet.
Allows you to use the features of a spreadsheet editor, such as find and replace or data formulas, to manipulate asset data.
Allows you to view and distribute asset information outside of ATG Merchandising.
Asset Versioning
You do not have to add assets to a project to export them, but you do have to be working in the context of a project. If you select an asset for export that you modified in your project, the modified version is exported. Otherwise, the main version—the version last checked in—is exported.
Note: Versioning information is not included in the export. If you plan to edit and re-import the spreadsheet to ATG Merchandising, see Versioning Considerations.
Security
To export an asset, you must have read and list access for the asset and any properties you want to export, but you do not need to have write access. For more information about user permissions, see Managing User Access and Security in the ATG Content Administration Programming Guide.
Export Size Limitations
Maximum number of asset rows is 65,534
The maximum number of asset rows that can be exported to a single spreadsheet is 65,533. Microsoft Excel has a maximum row limit of 65,536, and the first two rows of the exported spreadsheet are reserved for information about the export. If you export more than 65,534 assets, or you choose to itemize a collection property and the total number of items for all exported assets exceeds 65,534, any assets or collection items above that limit are not included in the spreadsheet. A message appears warning you that the data has been truncated. See Format of the Exported Spreadsheet.
Maximum number of characters in a cell is 32,767
Microsoft Excel does not allow more than 32,767 characters in a single cell. You could encounter this limit for any very long property value, but it is most likely to be an issue when you export very large collection properties, for example, a list of 2,000 SKU IDs that are greater than 15 characters each. In this case, use itemized format. See Options for Exporting Collection Properties.
