Asset data is exported to an XLS file that can be viewed and edited using Microsoft Excel. The default filename follows the format, <YYMMDDhhmmss>export.xls, for example, a file exported January 30, 2009 at 11:43:27 AM is named 090130114327export.xls.
The exported data follows a specific format that can be used to re-import the spreadsheet to ATG Merchandising. The following figure shows an example:
Row One: Repository, Asset Type, Formatting Options, and Process Messages
The first row is reserved for the repository path and asset type, any formatting options, and any warning or error messages.
The first column of row one (cell 1A) contains the repository path and the asset type separated by a colon. For example:
/atg/commerce/catalog/ProductCatalog:productColumns two through four (cells 1B, 1C, 1D and 1E) contain data formatting options:
FORMAT=itemizedindicates that the spreadsheet contains a collection property in itemized format and appears in the second column (cell 1B), if applicable.If any exported properties contain timestamps,
TIMEFORMATappears in the third column (cell 1C) and shows the format used for dates with a time stamp, for example,TIMEFORMAT=MM/dd/yyyy HH:mm:ss.If any exported properties contain dates,
DATEFORMATappears in the fourth column (cell 1D) and shows the format used for date values, for example,DATEFORMAT=dd/MM/yyyy.Messages generated during export processing appear in the fifth column (cell 1E), for example “Data exceeds Excel 65535 row limit and was truncated.”
Row Two: Property Headings
The second row displays column headings that contain the property names of the exported properties. The ID property is always the first column (cell 2A) and is always labeled “ID” regardless of the actual repository name of the ID property. The remaining columns are alphabetical by display name, the same order that is used in the Export dialog.
Note: Unlike the Export dialog, the spreadsheet contains the repository name of the property and not the localized display name.
Rows Three and Greater: Asset Data
Asset data begins in the third row and continues for the remainder of the spreadsheet. If an asset does not have a value for a property, then the corresponding cell is blank.
