I created a huge glossary within an EA project that consists of over 5000 terms and acronyms from over 70 sources. It was not simple and somewhat time consuimg (over a week) to get the data in a format that was easily imported.
I ended up using MS Access to directly update the t_glossary table after performoing a lot of data cleaning of the various sources. Basically, using PDF, Word, Excel and/or Access, I created tables in Access of the various sources in the same 3 fields that are in t_glossary table (Term, Meaning, Type). Besides some issues in the data cleaning, the largest issue regarding EA is the the Term field must be unique, thus you cannot have more than one definition (Meaning) for a term. So in Access before importing to EA, part of the cleaning effort was to concatenate multiple definitions within the same Meaning field. I also creates a standard where each definition eas followed by the name of the source and a blank line. I set the value of Type for each term to a value that suggested the purpose or type of the source glossary. Once I was happy with the tables in Access, I appended them to the t_glossart table in the eap file.
To handle acronyms/abbeeviations of terms, I did two things. I listed any abbreviations/acronyms in the definition. I also created a separate entry for each abbreviation/acronym where Term=value of acrynym, Meaning=full name of acroynym and Type='ACR".
Works out fairly nice. Becomes a simgle source that can be imported into other projects.
