Sparx EA Glossary (e14)

[@UserName-oh3ke]

I found that Glossary could be exported by selecting all Glossary items and copy them into the memory as a comma separated values, but I did not find any way how to import a number of existing words at once into EA if they already exist somewhere else. I think that using SQL might be the solution.

[@UMLOperator]

If you copy the Glossary cells from Sparx Glossary View directly, you do not get the GlossaryID column.
> You are correct, going to Sparx SQL Table (t_glossary) is the best way to do CRUD operations outside of Sparx.
> Another way is through XML. Exporting the Glossary only, as Reference Data, gives you a good XML file where you can manage the data. Just remember to keep the GlossaryID unique (incremented).
> I have developed Web Tooling to read the Sparx Glossary table and even do CRU operations (be careful with Delete).
> I also use a BI Tool (e.g., PowerBI, Tableau) to extract and manage Sparx Glossary and other data. We support a lot of companies that have their own Glossaries and Acronym data which we mine and bring into Sparx.
That's the beautiful thing about Sparx as a SQL Backend 😀