Importing a Glossary from Excel

[jzouain]

Hi All

I have being given the task to upload a spreadsheet (excel) with 80 rows of pre-defined glossary definitons into EA Glossary.

What is the best way to do this and how.
I see ways to import elements �and so on, but not Glosary elements.

Thanks
[original message]

[Paulus]

Have you seen this community resource provided by Geert Bellekens (btw thx Geert for sharing!): http://community.sparxsystems.com/resources/scripts/simple-vba-excel-ea-importer?

It is an excellent starting point for what you've in mind. It's straightforward to alter/extend it to import glossary items. You can use the subroutine below to add a term to EA.


Code:

Public Sub addterm(termType As String, name As String, description As String) � �Dim myTerm As EA.Term � � �Set myTerm = EARepos.Terms.AddNew(name, termType) � �myTerm.Type = termType � �myTerm.Meaning = description � �'save term � �myTerm.Update � �'refresh glossary collection � �EARepos.Terms.Refresh End Sub

[original message]

[Bellekens@localhost Geert Bellekens]

554844405656404B250 wrote:

(btw thx Geert for sharing!)

You're welcome  :)

You can find a (little) bit of extra info on my blog as well: http://geertbellekens.wordpress.com/2012/07/15/simple-vba-excel-to-ea-importer-v2/

Geert
[original message]

[jzouain]

Thanks will ckeck it out.
[original message]

[Bellekens@localhost Geert Bellekens]

I've finally found the time to add importing glossary terms in my Excel Importer.
See Simple VBA Excel to EA importer v3 (http://geertbellekens.wordpress.com/2013/04/30/simple-vba-excel-to-ea-importer-v3/)

Geert
[original message]

[philchudley]

Thanks Geert!

Just what I need, I have trimmed your version down to just importing the glossary and it works a treat!

I also added a dialog just to confirm when the import had finished.

Looking forward to meeting you at the EAUG later this month.

All the best

Phil
[original message]