Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Unable to Select Registered Word Generator
Mon, Feb 4 2013 6:24 PMPermanent Link

Norman Clark

Clark-Tech Inc.

I needed to do text searches using Text Indexes that included numbers (in Phone Number fields).

I built and then registered Millennium Software's (Atrex) Word Generator external module using the ElevateDBManager and when I view the Configuration.Modules using the Manager it can see ExtWordGen (the name I gave it) and indicates that it is a Word Generator type.

When I attempt to create/alter a text index in my database using the ElevateDBManager, I am only presented with the Default word generator and do not have the option to select my registered module.  I have stopped/restarted the engine but still no luck.

I understood that as soon as I registered the dll I should be able to use it to create the Text Indexes using this external module.  What am I missing?

The details of the external module:
Name:  ExtWordGen
Descrption:  NULL
FilePath:  ExtObjects\ExtWordGen.dll  (I have a folder named ExtObjects below the folder containing the Server Engine)
FileVersion:  1.0.0.11
FileDescription:  Atrex External Word Generator
Type: Word Generator
CharacterSet:  {blank}
Tue, Feb 5 2013 6:19 PMPermanent Link

Norman Clark

Clark-Tech Inc.

Follow on based on my self-discovery mode of running into walls, rub your head, backup and repeat. ...

Even though I had used ...

CREATE MODULE "extWordGen" Path "ExtObjects\extwordgen.dll" DESCRIPTION "a letters/numbers word list generator by Terry Swiers"

Which registered the external module in the Config file,

I failed to ...

CREATE WORD GENERATOR "extWordGen" MODULE "extWordGen"

which only then exposed the extWordGen in the Word Generator drop down in the ElevateDB Manager.

This was not so obvious as I was misled by the information in the Configuration Modules tab which indicated that the module was a "Word Generator type" once the external module was registered.

So - to register an external module as a word generator requires a two step process:
1 - create and register the external module
2 - create and register the external module as a word generator.

Tim indicates that he has this item on the improvements list for the ElevateDB Manager that will make this a little more obvious.
Wed, Feb 6 2013 3:07 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Norman


I'm glad you posted that. Its so long ago that I added this into my app that I'd forgotten what was needed.

Roy Lambert
Wed, Feb 6 2013 6:42 AMPermanent Link

Adam Brett

Orixa Systems

>>I'm glad you posted that. Its so long ago
>>that I added this into my app that I'd
>>forgotten what was needed.

There is an identical issue when creating a module which is an "ordinary" dll and then attempting to use it in a procedure ... its also a 2 step process, which I do so rarely I _always_ forget 1 of the steps.

It would actually be great if the EDBMgr had a "Modules" node on the DB tree (alongside Tables, Procedures, Views etc.) which showed registered Modules ...

1. It could include a right click menu list to open Wizards to assist in the creation, registration, altering, dropping process for modules, as for views, procedures etc.
2. It would mean you could see which modules/word generators etc you have  / haven't registered on a particular DB.

... otherwise the only way to find out registered modules (AFAIK) is to query the configuration.modules table.
Wed, Feb 6 2013 1:53 PMPermanent Link

Jan Ferguson

Data Software Solutions, Inc.

Team Elevate Team Elevate

Adam,

The EDBManager does have some of the capabilities you are looking for.
If you click on "View Installed Modules" after you have opened a
session you can view which modules have been installed for a given
session/server. That's way easier than physically querying the
Configurations.Modules table (essentially it is doing the same thing
except it's a click-away versus actually writing the query.) Modules
are installed for a given session/server, not per database.

Further you can click on "Create Database Migrators" in a local server
and it will create the migrator modules automatically for you. It
cannot do this however for a remote server.

---------------------
Jan Ferguson [Team Elevate]


Adam Brett wrote:

> It would actually be great if the EDBMgr had a "Modules" node on the
> DB tree (alongside Tables, Procedures, Views etc.) which showed
> registered Modules ...
>
> 1. It could include a right click menu list to open Wizards to assist
> in the creation, registration, altering, dropping process for
> modules, as for views, procedures etc.  2. It would mean you could
> see which modules/word generators etc you have  / haven't registered
> on a particular DB.
>
> .. otherwise the only way to find out registered modules (AFAIK) is
> to query the configuration.modules table.
Image