Export Information Model with class attributes

[Issured]

Hi there,

I am trying to export an information class diagram, including attributes and notes, into CSV/Excel.  I know I have done this before but I cannot now remember how I did it!

Please can anyone outline the steps for me so I can get this done?

Thank you

[Geert Bellekens]

The easiest way is to get the info into the search window and export it from there.

If you want something more automated you can use scripting create the csv file.

Geert

[Issured]

Hi Geert,

Thank you for your help - I cannot find how to get the information classes and attributes into the search window?

[Geert Bellekens]

You could use an SQL search similar to this:

Code: [Select]

select a.ea_guid AS CLASSGUID, 'Attribute' AS CLASSTYPE, o.Name as ClassName, a.Name as AttributeName, a.Type, a.Stereotype, a.Notes
, package.name as PackageName ,package_p1.name as Package_level1,package_p2.name as Package_level2 ,package_p3.name as Package_level3
 from (((((t_attribute a
inner join t_object o on o.Object_ID = a.Object_ID)
inner join t_package package on package.Package_ID = o.Package_ID)
left join t_package package_p1 on package_p1.package_id = package.parent_id)
left join t_package package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package package_p3 on package_p3.package_id = package_p2.parent_id)
where o.Package_ID in (#Branch#)
Geert

[Issured]

Excellent - that has worked perfectly!  Thank you.  Should I now be able to export to CSV or will it only allow RTF, PDF etc.?

Sorry for all the questions.

[Geert Bellekens]

Yes, to csv. There is a button on the top right of the search window that allows exporting the results.

Geert