cancel
Showing results for 
Search instead for 
Did you mean: 

How to load table COMMENTs from a spreadsheet or csv into tables already within PowerDesigner

Former Member
0 Kudos

I have a spreadsheet containing two columns: Table name, and Comment

I want to bring these into an existing physical model, where the Comment gets populated into the 'Description' property of each table.

Is this possible, and how?

The reason I need this is that there is a bug in PowerDesigner preventing the 'COMMENT' value in a MySQL DDL script from being imported in to 'Description' when updating a model from a DB script. They have raised a KPI for this but might take sometime to get addressed. (https://launchpad.support.sap.com/#notes/2674004)

Accepted Solutions (1)

Accepted Solutions (1)

GeorgeMcGeachie
Active Contributor

Save your CSV file in Excel format, then use the standard Excel import wizard to import it. If you haven't done that before, take a look at https://www.youtube.com/watch?v=JoAkFVrWKzE

Former Member
0 Kudos

Thanks again George. Very straightforward. I should've already discovered that the import wizard updates existing objects, not just creating new objects. Hadn't really tried it enough.

Answers (0)