When changing from EQ2 to AllTalk, the client Descriptions are not transferred.  For large sites this can be troublesome.

The following is an outline of how to transfer the descriptions (and assign web interface passwords) into AllTalk from the EQ2 Database.

1. Extract the descriptions from the DocTable.db paradox table into a spreadsheet or other text editor. 

We have found the simplest way to do this is to use MS Access although the various other methods would be suitable.  Steps are

• Open a blank MDB
• In tables, click Import Table
• Select Paradox type
• Browse to the EQ2 SErver folder click on Doctable.db
• Import should take only a few seconds
• In queries create a new query to return the mailbox name and the description ("user" and "Real Name")

2. Construct a script to update the descriptions

Once you have the list either export to a CSV file or simply Select the entire table and copy into MS EXCEL or similar spreadsheet.

Using the concatenate command create a string in the following format

aciu <user><CRLF>name=<realname><CRLF>.<CRLF>

eg. assuming a1 has userid and b1 has the description, in cell c1 enter 

=concatenate("acui ",a1,char(13),Char(10),"name=",b1,char(13),char(10),".")

Copy this down for all rows then copy the entire column C into notepad.  Excel kindly (but wrongly) puts Double quotes around the string, so you will need to search and replace all Double quotes with Blank.

The result in Notepad should be something like this:

aciu mb1
name=Mailbox 1
.
aciu mb2
name=Mailbox 2
.

Up to N number of mailboxes.  Select all of the text in Notepad (CTRL-A) then copy it into the windows clipboard (CTRL-C)

3. Update the server with the details

Using windows telnet (from a dos window or Run)  log onto the AllTalk server's Client (pop3) port VIA A TRUSTED LAN CONNECTION

telnet <alltalk server address> 21110

At the greeting type

user manager
pass <alltalk server manager password>

Then right-click the window and the Clipboard contents will be "pasted" onto the server.  The server will update each user's description in turn, returning

+OK aciu "Mailbox 1" <mb1@...>
+OK aciu "Mailbox 2" <mb2@...>

NOTE: This same technique can be used to assign web interface passwords.  you can do this at the same time as the descriptions or later - it is of no consequence.  Use the parameter "emailpassword" to assign passwords

eg

aciu mb2
name=Mailbox 2
emailpassword=mb2001
.