9.3 931 - Glossary Problem?

[OneCent]

Hi

I try to edit my Glossary in 9.3 and i can't edit a old entry or add a new one. The buttons new, save and delete are allways disabled.

Any hint to solfe that problem?

Cheers, OneCent

[AndyBo]

I had a similar problem
It turned out to be a permissions problem with the version control system
The permissions had to be added separately to the model

[qwerty]

Check your EA security settings.

q.

[OneCent]

Thanks a lot!

[JohnRGladstone]

Don't suppose you have any idea if it is possible to import a pre-existing list of terms from a Word document into EA?

I've got a massive list of terms to capture and don't fancy typing them all in one at a time

[philchudley]

Hi John

Not "out-of-the-box", however the following may work.

1) Extract the glossary into Excel and format accordingly
2) Export to csv
3) Write a bit of code that reads the csv and creates a series of SQL Insert statements.
4) Execute the SQL Insert statements against the underlying EA repository using Access or your chosen DBMS (insert sql statements cannot be executed within the EA workspace)

The repository table details you will need are

Table name - [highlight]t_glossary[/highlight]
Table attribute - [highlight]Term[/highlight]
Table attribute - [highlight]Meaning[/highlight]
Table attribute - [highlight]GlossaryID[/highlight]

The last field is incremental and should start from 1 for a new glossary or continue from the last number for a glossary with existing entries

Something like the following

INSERT INTO t_glossary
(Term, Type, GlossaryID)
VALUES
(value-1, value-2, value-3)

Cheers

Phil