Any one has macro (or any method ) in ER studio Professional to update
from XL sheet, by looking up the Table name and Column Name. ?
I am new to ER Studio , and this feature was easily done in Erwin using bulk editor.But I can't see direct method for this in ER studio.
There should be sample macros that will show you how to do this. If you click on the Macro tab on the bottom left, go to Productivity Macros, there's one for Definition Editor. There are others in there as well to Import metadata -- look at those.
Thank you Karen for the response, I could see that(Definition Editor) , but it accept the definition only from GUI not from XL sheet. The one with XL is creating all brand new entities (Import Column From XL) , not updating the existing entities. Trying to figure out a way without starting to create a macro myself, I am sure some one would have this already created being this a basic modelling tool requirement.
ah. There's also one under Sample Macros called Import Object Definitions and Notes from Excel. Give that one a try.
Powered by IDERA