Skip to Content

Import Traceability Link via MS-EXCEL Column Names

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.
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 18 at 07:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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?

  • Jun 18 at 08:39 PM

    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


    Add comment
    10|10000 characters needed characters exceeded