Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: A_Marsh on November 18, 2025, 04:43:25 am

Title: Importing db Column Notes (Descriptions) via Export / Import
Post by: A_Marsh on November 18, 2025, 04:43:25 am

I've been away from EA for a while and am effectively a newbie. Sorry if this is a dumb question.

I have a reverse-engineered database physical model to which I want to add Table and Column descriptions.
I've figured out how to export Table GUIDs and use these to then import Table descriptions using the CSV exchange and Import.

However, I cannot figure out how to get GUIDs for columns via the CSV model excahnge.   What am I supposed to enter for default types and available fields ?
https://sparxsystems.com/enterprise_architect_user_guide/17.1/model_exchange/csvspecifications.html (https://sparxsystems.com/enterprise_architect_user_guide/17.1/model_exchange/csvspecifications.html)

Thanks

Title: Re: Importing db Column Notes (Descriptions) via Export / Import
Post by: Geert Bellekens on November 18, 2025, 06:15:57 pm

You can't export/import attributes using CSV.

You might be able to use the Office MDG, write your own script, or use the excel import/export tool I made https://bellekens.com/ea-excel-import-export/ (https://bellekens.com/ea-excel-import-export/)

Geert

Title: Re: Importing db Column Notes (Descriptions) via Export / Import
Post by: Richard Freggi on November 18, 2025, 07:32:23 pm

Geert's Excel tool 100%! 

<Cue the Mandalorian> "This is the way"

Title: Re: Importing db Column Notes (Descriptions) via Export / Import
Post by: A_Marsh on November 19, 2025, 04:58:07 am

Downloading now!   Thanks for the answer and for the tool.