Specifying a Destination for Data

The Specify Data Destination dialog box enables you to select an SBM table to import data into, and, if that table is a primary table, a project to import items into.

The following options on the Specify Data Destination dialog box apply to imports from all databases:

• Destination Table – This drop-down list contains all the SBM primary and auxiliary tables you can import data into. You enable SBM tables for import by selecting the Allow Import Into check box located on the Advanced tab of the Edit Table dialog box. Select the table you want to import data into.

  Tip: To import data into multiple tables, create an Import Option Set for each table. When you import data from a generic ODBC database, you can only import into one project at a time. To import into multiple projects, create a different Import Option Set for each project. For details, refer to Working With Import Option Sets.
• Destination Project – This drop-down list contains the projects available for the selected primary table, if applicable. Projects are listed alphabetically in reverse hierarchical order. Select the project you want to import data into. If you choose to import data into multiple projects based on the Source Field to Evaluation option, the project selected in this list serves as a default project where items are placed if undefined or unmapped fields are encountered in the evaluation field.

  Note: The following options apply only to imports from SBM and Tracker databases.

• Load Data Into Multiple Projects, Based On Values in a Source Field – Select this check box to enable the Source Field to Evaluate and mapping options so that you can import data into multiple projects based on values in a source field.

• Source Field to Evaluate – This list contains all Single Selection fields in the source SBM table or Choice fields in the source Tracker project. Select a field that contains values to map to SBM projects. Source items with the selected field values are then imported into projects mapped to those values. For example, you may select the Item Type source field, and map values such as "Defect" to one project, "Enhancement Request" to another project, and "Change Request" to a third project. Items in which the Item Type field does not have a value are placed into the default destination project.

• Values – This left-pane list contains values in the field selected from the Source Field to Evaluate drop-down list.

• SBM Projects – This list contains all projects associated with the destination primary table.

• Values – This right-pane list contains source field values that are mapped to SBM projects. Source items that contain this field value are imported into the mapped project. Multiple source values can be mapped to a single project.

• Map – This button enables you to map items in the Values list to items in the SBM Projects list. To map items, select a value, select a project, and then click Map.

• Unmap – This button enables you to remove mapping assignments. To remove a mapping, select a mapped project, and then click Unmap.

After specifying data destination information, click Next to continue.