Skip to Content
0

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

Sep 07 at 01:16 PM

29

avatar image

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)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
George McGeachie Sep 10 at 12:05 PM
1

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

Show 1 Share
10 |10000 characters needed characters left 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.

0