Hi there, I am new to the forum and sorry if I re-posted something which is already been discussed. I have a requirement where I need to convert all the logical attribute names *(1500 of them) into corresponding physical column name based on our abbreviation glossary standards. Like example:
The logical name of the attribute, 'account request action code' should be converted as physical column name: ACNT_RQST_ACTN_CDE.
Please suggest any existing macro I can download or appropriate changes to the code I attached here. Everytime, I am running the macro, the ER/studio is crashing without any error message.
Attached is the code. Line # 96 is where I am pointing to naming standards glossary.
Appreciate your help.
Is there a reason you can't use the Naming Standards Utility to accomplish this rather than a macro?
I am not seeing Naming standards utility in the list of standard macros that came with the ER/Studio. Can you please point on how to look that up to accomplish this task. Appreciate your response.
It's not a macro, it's a feature of the product. You'll find it under the Model Menu - Model | Naming Standards Utility. You first have to define a Naming Standards Template (Tools | Naming Standards Template Editor) which includes your glossary of name translations (this can be imported from a spreadsheet), and also defines how you want word segments separated, i.e. translate a space in the Logical to an Underscore in the Physical, as well as capitalization. Once your template is defined, you reference that template in the Naming Standards Utility.
spfister! Thank you so much. It works very well for my need. How to I export converted physical column names after I run the translation. Appreciate your help.