Importing Glossary Terms

[mlac]

I am a new EA user and am have been trying to  import CSV files to populate the EA Project Glossary and Project Issues.

Is this possible?  Do I have to use the automation interface? Or develop a custom SQLServer script?

The thought on manually entering hundreds of items is a bit daunting.....so any help is appreciated!

Cheers,
Martin

[thomaskilian]

Martin,
import/export of the Glossary is possible via XML (see Tools/Im-/Export refrence data).

Also you can import the glossary directly in EA's database. EAP files are MS Access databases. You will find the table names rather self-explanatory (you even can reverse engineer a database and analyse it with EA itself). From memory the glossary's table is named t_glossary.

Similar goes for Issues.

[«Midnight»]

Since I keep tripping over this myself, I'll add that the items in question are listed as "Project Glossary" and "Project Issues." You'll find these in the list offered by the Tools | Export Reference Data dialog.

[mlac]

Thanks for your suggestions.....but I need a bit more advice on each:

1. How do you convert a table of glossary items (residing in a CSV file) into an XML file ready for importing?

2. How do you view/access EAP tables via MS Access?

Cheers,
Martin

[KP]

1. If you export the glossary using the command "Tools | Export Reference Data" then open the output in a text editor you will be able to see the XML format expected for the import. The same applies for exporting the issues.

2. An .eap file is a renamed .mdb file. Just open it!

[thomaskilian]

Alternatively define an MS Access ODBC source pointing to any .EAP file.