Adding Data to Multiple Selected Item Frames using CSV Export / Import

Introduction

WorkBench has the ability to select multiple items and modify some attributes and categories using the Properties dialog.

Properties
Properties for Multiple Selected Items

However, what if you wanted to add data into selected item’s FRAMES?

In this example, we will show how this can be achieved using CSV export / import.

Adding data to multiple selected item FRAMES

Create a CSV File

  • Export your item type to CSV. You only need to map the default attributes Identity, Type, Draft and Version that are already pre-set. The other attributes/frames/categories do not need to be exported.
    Export Control
    Export Items Dialog

    CSV Export Mapping
    Setting Required Attributes
  • Open the CSV file in Excel and add a column representing the new frame.
    In this example, we are adding a new frame named TEST and adding the text “My Text” in this frame for all (or selected) items.
    You could, of course, add different text content for each of these cells.

    Example CSV
    Add Frame Column to Excel

    Add a Frame in your WorkBench Project

  • If you don’t already have the frame, you can add a new frame to the item type in Project Setup now. This is the frame where we will add content en bloc.
Frame Setup
Frame Setup

Importing The CSV File

  • Select Import with the file type CSV and the required item type ensuring that the Overwrite option is set to Merge and press Import.
    Note also that there are options here to update the modification date / last modifier and also whether to add an entry to the items’ edit history.
Import Options
Import Options
Import Dialog
Import Dialog
  • Map the fields ensuring that the added frame is mapped
CSV Fields
CSV Fields
  • You will see that the new frame has been added with content for all items and the previous content remains intact
Updated Frame in WorkBench
Updated Frame in WorkBench