The Excel Import Wizard provides a number of options to allow some flexibility in the format of the data it can import.
| Option | Description |
|---|---|
| Auto-map columns to properties |
Instructs the wizard to automatically map tables and columns that share names with objects or properties in the PowerDesigner metamodel without requesting confirmation. If your Excel sheets and table column headings conform to the PowerDesigner metamodel, this option can save considerable time by only showing you (and requesting your input for) items that the wizard is unable to match itself. For information about helping the wizard match your data to the PowerDesigner metamodel, see Preparing Your Excel File for Import). Default: Unselected |
| Create symbols in active diagram |
Instructs the wizard to create symbols, where appropriate, for the imported objects in the currently selected diagram. Default: Unselected |
| Create associated objects if not found |
Instructs the wizard to automatically create objects referenced by the imported objects where these are not otherwise defined in your Excel file. For example, If you have a worksheet listing PDM tables, which contains a column called Owner, PowerDesigner will create user objects for each of the names appearing in this column unless you supply a list of users on another worksheet. Similarly, if you do supply such a list of users but not all the names in the Owner column are included, user objects will be created for each of the missing names. Default: Selected |
| Object identifier |
Specifies whether the object's name or code (the latter of which does not usually permit spaces or special characters ) is used in columns that reference the object. In the example above, you could use the user's name or code to reference it in the Owner column of the list of tables. Default: Name |
| Qualified name separator |
Specifies the character used to separate namespaces in a qualified name. The Qualified name separator is used to specify the location or parent of an object. For example, to specify that architecture area Area3 is inside Area2, which is in turn inside Area1, you would enter Area1.Area2 in the Parent column for Area3. Default: Dot |
| List value separator |
Specifies the character used to separate items in a list in an Excel cell. For example, you could list all the columns of a table in a cell as follows: ID,Name,Email,Password. Default: Comma |
| String literal for 'True' |
Specifies the string used to signify 'True' for boolean attributes. False is signified by an empty cell. Default: X ('Y', 'Yes', 'True', and '1' also always signify 'True'. |