Where can I get the excel template to upload LDM in SAP PowerDesigner ?

[former_member1197083]

Where can I get the excel template to upload LDM in SAP PowerDesigner ?

[GeorgeMcGeachie]

Try this file - Import a complete model.xlsx

It'll build a whole model in one go, though there are a couple of questions it asks you.

[dataexpat]

Thanks , appreciate your help.

[GeorgeMcGeachie]

There's a video on YouTube that should help you. It has a catchy title - "Importing and drawing a complete PowerDesigner LDM from Excel".

[Ondrej_Divis]

Hello,

you will have to experiment a little bit, because ExcelImport requires specific structure of imported data, especially for more complex objects like Relationships (with their joins) or Inheritances. "Simple" objects like Entitites or EntityAttributes could be imported quite simply. Just add the ExcelImport extension to your LDM and run the import wizard (Import Excel file...) through context menu of your model.

In case you need more detailed help, let me know. Or you can find me on LinkedIn.

Regards,

Ondrej Divis

[arnaud_laurent]

Hello,

By default, the extension file "ExcelImport.xem" can be found in C:\Program Files\SAP\PowerDesigner 16\Resource Files\Extended Model Definitions.
The Excel Import extension provides a wizard to guide you through mapping tables of objects in an Excel file (v2003 and higher) to PowerDesigner objects and properties, to import them to your model.

Kind regards