Book a Demo

Author Topic: Importing db Column Notes (Descriptions) via Export / Import  (Read 18765 times)

A_Marsh

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Importing db Column Notes (Descriptions) via Export / Import
« 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

Thanks

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13506
  • Karma: +572/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Importing db Column Notes (Descriptions) via Export / Import
« Reply #1 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/

Geert

Richard Freggi

  • EA User
  • **
  • Posts: 495
  • Karma: +18/-7
    • View Profile
Re: Importing db Column Notes (Descriptions) via Export / Import
« Reply #2 on: November 18, 2025, 07:32:23 pm »
Geert's Excel tool 100%! 

<Cue the Mandalorian> "This is the way"

A_Marsh

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Importing db Column Notes (Descriptions) via Export / Import
« Reply #3 on: November 19, 2025, 04:58:07 am »
Downloading now!   Thanks for the answer and for the tool.