Guys,
I had a problem with extractusers.exe and sql. I did the extract and then
imported the users into MSSQL7 using MS DTS wizard on the fixed space text
file. I thought it worked quite well until I couldn't log into web messaging
because it would crash and in Imail Admin, the user list would come up, but
no attributes like FULLNAME or mail address. As well, if I clicked on a user
and then clicked on the Info Manager tab, Imail would close itself (sound
familiar?)
I noticed there were spaces after the values in the varchar fields, to solve
all these problems I trimmed the field columns with this: (note I am not
that good with SQL, I only started using it yesterday)
UPDATE tablename set fieldname = rtrim(fieldname)
You have to do it for all the varchar fields.
I am not sure if you need to do this if you use the extractusers to enter it
into the database at the same time. Hope this helps somebody save some time!
Craig.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
