Import Traceability Link via MS-EXCEL Column Names

[freym05]

Import Traceability Link via MS-EXCEL Column Names

I'm attempt to import multiple Traceability Link statements to diverse Object Types. Is there a documented list of MS-EXCEL Column Names that automatically map to the Traceability Link Objects so the import column auto-map columns to properties check box option (in the Import Options dialog), can be used without manual intervention? Specifically I'm looking for the Source Object and Linked Object Types to be specified. Thank you in advance.

[freym05]

The PowerDesigner document is very high level, this is a very concise question. The Traceability Link Object minimally requires the "Source Object" and "Linked Object" information as well as the Object Type. This is not documented anywhere within SAP PowerDesigner materials. The question I have is how do I specify the "Object Type" for the "Source Object" and "Linked Object". I have taken a guess at "Source Object.Type" and "Linked Object.Type", however this doesn't work. Can SAP tell me how to do this, i.e. what should the column names be for this purpose. The relevant Import Wizard screenshot is attached showing how it requests the Object Type. Thank you.cusersfreym05documentspowerdesignerincidents2019-j.png

[former_member200945]

We do not have such documented list. You need build the list yourself.

According to Powerdesigner help document:

Auto-map columns to properties

Instructs the wizard to automatically map Excel tables and columns to objects and properties in the PowerDesigner metamodel. If all your Excel worksheets and table column headings are named from the PowerDesigner metamodel (or your predefined extensions), this option can make the import run without requesting further input.

By default, PowerDesigner metamodel file locates at C:\Program Files\SAP\PowerDesigner 16\Examples

[freym05]

I see the documentation and the reference to 09 Traceability Link Import.xlsx example file, but there's no explanation for what the DependentObject and InfluentObject syntax is. Is there somewhere that explains this?