layoutWidgetRelationship input file

You can extract data for the relationships between widgets and layouts, default layouts, and templates with the Data Extract utility to create a layoutWidgetRelationship.csv file that you can load with the Data Load utility. For example, if you want to copy or move layouts between stores or instances, such as for creating one or more test environments.

Definitions

LayoutUniqueID

(Integer) The internal reference number for the layout or template to which you are adding a container and widgets, for example, 50001. Either this field or the LayoutName field (see next column) is required.

Note: The sample CSV file does not include this column; the sample demonstrates the use of the LayoutName to uniquely identify the layout.

Maps to:

• PAGELAYOUT.PAGELAYOUT_ID
• PLWIDGET.PAGELAYOUT_ID

LayoutName

(String) The external reference name for the layout or template to which you are adding a container and widgets, for example, SampleHomePageLayout. Either this field or the LayoutUniqueID field (see previous column) is required.

Maps to: PAGELAYOUT.NAME

UniqueID

(Integer) The internal reference number for the container. Either this field or the AdminName field (see next column) is required. You can look up this value in PLWIDGETDEF table, PLWIDGETDEF_ID column.

Note: The sample CSV file does not include this column; the sample demonstrates the use of the AdminName field to uniquely identify the container.

Maps to: PLWIDGET.PLWIDGET_ID

AdminName

(String) The administrative name for the container in this layout or template. This name is defined in the WidgetDefIdentifier column of the registerWidgetdef input file that was used to load the container. Either this field or the UniqueID field (see previous column) is required.

Maps to: PLWIDGET.ADMINNAME

ChildWidgetDefIdentifier

(String) The external reference name for the widget that you want to include in the layout or template, for example, EMarketingSpot or ContentCarousel. This identifier is defined in the WidgetDefIdentifier column of the registerWidgetdef input file that was used to load the widget.

Maps to: PLWIDGETDEF.IDENTIFIER

ChildWidgetAdminName

(String) A name to identify this widget within this specific layout or template, for example, HeaderLeftBannerContentWidget. This name is displayed in the Commerce Composer tool to help business users understand the purpose of the widget within this specific layout. You can use any name that you want.

Maps to: PLWIDGET.ADMINNAME

WidgetSequence

(Double) A number to define the order in which to stack this widget relative to other widgets that are displayed in the same slot, starting with zero (0). For example, if you add three widgets to slot 1, use this column to specify the sequence number for each widget. In the following sample excerpt from an input file, the HeroAdOnCategoryPage widget is displayed at the top of Slot 1, followed by the SecondAdOnCategoryPage widget, and the ThirdAdOnCategoryPage widget:

Example of widget sequence that is defined in an input file

ChildWidgetAdminName	WidgetSequence	SlotID
HeroAdOnCategoryPage	0	1
SecondAdOnCategoryPage	1	1
ThirdAdOnCategoryPage	2	1

For slots that contain only one widget, specify 0.

Maps to: PLWIDGETREL.SEQUENCE

SlotID

(String) The internal identifier of the slot into which you are adding the widget.

Maps to: PLWIDGET.SLOTID

Delete

(String) A flag that indicates whether to delete the relationship for this layout. Specify 1 to delete the row.