Skip to Content

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

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 10 at 12:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

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